Candidates About

 

Wissam M. El-hasrouny

Oracle Financials Functional Consultant

                                                                              SUMMARY

·         Certified Oracle Financials Cloud Implementation Specialist with around 12 years of Experience in Full Life Cycle  of Oracle Financials implementations for multiple regions (North America, APAC, EMEA) involving Record to Report (R2R), Order to Cash(O2C), Procure to Pay(P2P), E-Business Tax (E-BTAX) and & Oracle Projects.

·         Expertise include requirements gathering, functional gap analysis, application design, configuration, module setup, test script generation, writing training guides using Oracle User Productivity Kit (UPK), training end users, and production support.

·         Extensive experience in the finance and procurement modules (General Ledger, Subledger Accounting, Accounts Payable, Accounts Receivables, Fixed Asset, Cash Management, Advanced Collections, iExpenses, AME, E-Business Tax and Purchasing) in Fusion, EBS Release 12 and 11i.

·         Experienced in analysis and design of client specific custom requirements i.e. conversion and interface, designing custom solutions, leading developers, producing documentation and providing production support.

·         Hands-on working and demonstrating of Oracle Cloud Financials and Fusion Accounting Hub (FAH).

·         Lead for multiple Oracle EBS R12 upgrades and roll outs for various industries like Manufacturing, Services and Education.

·         Proficient in Application Implementation Method (AIM), AIM for Business Flow (ABF) and Oracle Unified Method (OUM), including BF.015, BF.016, TE.040, MD.050 CV040, and MD070.

 

SKILLS

Oracle Fusion:   Fusion Financial Offerings –General Ledger, Accounts Payable, Accounts Receivables, Fixed

Assets, Cash Management (Version 11g Release10) with OTBI, Smart View, Financial Reporting Studio reports (FRS), ADFDI & FBDI integrations and Fusion Accounting Hub (FAH).

Oracle EBS:         Oracle Apps R12 Financials –General Ledger, Accounts Payable, Accounts Receivables, Fixed

Asset, Cash Management, Project Costing, Property Manager, I-Expense, Advanced Collections       (Version R12.1.3, R12.2.4)

Utilities Tools: Toad, PL/SL Developer, Web ADI, I-loaders and Data loader.

 

CERTIFICATIONS

·         Oracle Financials Cloud: General Ledger 2016 Implementation Essentials

·         Oracle E-Business Suite R12.1 Financials Best Practices Implementation Boot Camp, 2010 by Oracle.

·         Oracle Business Intelligence Enterprise Edition (OBIEE) HYPERLINK – RDC 2007.

 

EDUCATION

·         Masters of Business Administration specializing in Management Information Systems, Middle East University, Beirut, Lebanon, 2008

·         Maitrise en Gestion des Entreprises, Bachelor’s Degree equivalent specializing in Management, Lebanese University, Beirut, Lebanon, 2004

 

RESEARCH PAPER

·         "Automated Transactions Management", June 2004

·         Lebanese Baccalaureate in Experimental Sciences, 1999

 

LANGUAGES       

·         English, fluent                                                  

·         French, conversant

·         Arabic, native

 

PROFESSIONAL EXPERIENCE

 

Client: PFIZER/MEDIVATOIN INC, San Francisco, CA   (NTT DATA)                                              July 2015 – Present

Medivation, Inc. (Acquired by Pfizer in September 2016) is a biopharmaceutical company focused on the development and commercialization of medically innovative therapies to treat serious diseases for which there are limited treatment options.

 

Role: Oracle Financial Functional Lead – On site - NTT DATA Contractor

Product Version: 12.2.4

Module: GL/AR/AP/FA/CE/ IBY/AGIS

 

Responsibilities:

·         Worked on the implementation of Oracle E-Business Suite R12 Financial Modules (GL/AR/AP/FA/CE/AGIS/IBY) performing the following business tasks: requirements gathering, functional gap analysis, application design, configuration, module setup, test script generation, writing training guides, training end users, and production support

·         Configured General Ledger including the following (Ledgers, Reporting Ledgers for MRC transactions, Multi Ledger Processing, Data Access Sets, Management Reporting and Security, Subledger Accounting SLA)

·         Worked on the solution for the Non-GAAP Reporting Requirement reflected in the client financial statements.

·         Designed and setup up FSG (financial statement generator) for generating different types of financial reports

·         Configured Advanced Global Intercompany System (AGIS) as an intercompany solution across entities.

·         Configured inter-company and Intra-company Accounts so transactions can more easily be controlled, monitored and reconciled.

·         Configured the Payables module including the following (Financial options and Payables options, Invoice Attributes Payment Terms and Distribution sets, Special calendar, recurring invoices and Expense report templates)

·         Designed the client’s check templates using xml publisher

·         Designed, Implemented and automated the process of sending the Positive Pay File to the bank.

·         Designed an auto reconciliation process that matches figures from the accounting records against those shown on a bank statement helping users reconcile and close their month

·         Completed the necessary prerequisites and configuration setups for the Cash Management module (Transaction Codes, Bank Statement Mapping) to complete and execute the auto reconciliation process

·         Defined the payment process profiles for different domestic and foreign banks

·         Configured Receivables module including the following (AR System Options and Defaults, Transaction Types, Accounting Rules)

·         Analyzed and Configured Fixed Assets (Mass Additions, Adjustments/Transfers and Assets Depreciation)

·         Driven test planning and execution for the regime to rate setups

·         Supported Period End Close after Implementation

 

Client: ASSEMBLY BIOSCIENCES, San Francisco, CA   ( NTT DATA )                              November 2015 – July 2016

Assembly Biosciences, Inc. is a clinical-stage biotechnology company advancing a new class of oral therapeutics for the treatment of hepatitis B virus (HBV) infection and novel oral biotherapeutics for disorders associated with the microbiome.

 

Role: Financial Functional Consultant -  NTT DATA Contractor

Product Version: Oracle Fusion Release 10

Module: GL/AP/FA/CE

 

Responsibilities:

·         Create Implementation Project and define financials configuration for rapid implementation including Chart of Accounts, Ledgers, Legal Entities & Business Units.

·         Define Legal Jurisdictions, Addresses and Create Legal Authorities.

·         Create an Accounting Hierarchy, Account Combination Activity, Define Cross-Validation Rules, Create Calendars, Create Primary, Secondary Ledgers.

·         Create different activities i.e. Ledger Sets, Data Access Set and Segment Value Security.

·         Used the Calculation Manager to define Allocation Rules and deploy it the Essbase.

·         Used the Subledger Accounting module to create an Account Rule that assigns different account combination rules based on the invoice type.

·         Defined the Common Options for Payables including Invoice Options and Payment Options.

·         Configured the Oracle Fusion Payments for Payables including: setting up Electronic Payment files and automating the transmission of the files to the bank though Transmission Configuration, Payment System, Payment System Account and Payment Method Defaulting Rules.

·         Creating and managing Assets Fiscal Years, Asset Calendars and Prorate Conventions.

·         Creating Asset Corp and Tax Books and defining Category Key Flexfield Values.

·         Create a Bank, Branch, and Account.

·         Create a Transaction Creation Rule.

·         Create Reconciliation Rules to include tolerance rules, matching rules and rule sets.

·         Issue resolutions for SIT/UAT Execution.

·         Preparation of Data conversion strategy & cut-over strategies.

 

Client : WESTERN DIGITAL TECHNOLOGIES INC, Irvine, CA   ( IBM )                        March 2014 – March 2015

Western Digital Corporation is one of the largest computer hard disk drive manufacturers. Western Digital Corporation has a long history in the electronics industry as an integrated circuit maker and a storage products company.

 

Role : Oracle Financial Functional Lead – On site  -  IBM Contractor

Product Version: 12.2.2

Module: GL/AR/FA/CE/AGIS/eBTax

 

Responsibilities:

·         Worked on the upgrade of Oracle E-Business Suite from 11i to R12.2.2 involving multiple regions/countries (US, Europe, Asia Pacific and South East Asia) leading the following Financial Modules (GL/AR/FA/CE/AGIS/eBTAx) performing the following business tasks: functional gap analysis, application design, configuration, module setup, test script generation, writing training guides, training end users, and production support

·         Conducted workshops to present R12 finance new features

·         Configured General Ledger including the following (Ledgers, Reporting Ledgers for MRC transactions, Multi Ledger Processing, Data Access Sets, Management Reporting and Security, Subledger Accounting SLA )

·         Worked on the solution for the intercompany transaction across OU’s.

·         Configured Advanced Global Intercompany System (AGIS) as an intercompany solution across entities.

·         Configured inter-company and Intra-company Accounts so transactions can more easily be controlled, monitored and reconciled.

·         Designed the client’s check templates using xml publisher.

·         Defined the payment process profiles for different domestic and foreign banks

·         Designed and presented the Revenue Recognitions solution as part of the Proof of Concept session.

·         Configured Receivables module including the following (AR System Options and Defaults, Transaction Types, Accounting Rules)

·         Tested the lockbox solution by importing a lockbox file from the bank where receipts will be created and applied to AR Invoices.

·         Analysis and configuration of Mass Additions, Adjustments/Transfers and Assets Depreciation.

·         Designed an auto reconciliation process that matches figures from the accounting records against those shown on a bank statement helping users reconcile and close their month

·         Completed the necessary prerequisites and configuration setups for the Cash Management module (Transaction Codes, Bank Statement Mapping) to complete and execute the auto reconciliation process

·         Collected requirements around Indirect Tax (Sales Tax, VAT, Offset taxes etc.).

·         Drive test planning and execution for the regime to rate setups.

·         Test R12 functionalities

·         Run 11i critical Reports before upgrade

·         Run SLA Post Upgrade Program to migrate historical data into SLA tables

·         Test Custom Objects after upgrade

·         Support Period Close after successful Upgrade

 

 

Client : AMERICAN UNIVERSITY OF BEIRUT, Beirut, Lebanon & New York, NY                    Oct  2010 – Jan 2014

The American University of Beirut is a private, non-sectarian institution of higher learning, founded in 1866, which functions under a charter from the State of New York. It is administrated by a private, autonomous Board of Trustees. American University of Beirut has around 700 instructional faculties and a student body of around 8,000 students.

 

Role : Oracle Financial Functional Lead - Independent Contractor

Product Version: 12.1.3.

Managed and handled the following modules on site:  GL/AP/AR/FA/CM/OIE/AGIS/eBTax

 

Responsibilities:

·         Worked on the implementation of Oracle E-Business Suite R12 Financial Modules (GL/AP/AR/CE) performing the following business tasks: requirements gathering, functional gap analysis, application design, configuration, module setup, test script generation, writing training guides, training end users, and production support

·         Configured General Ledger including the following (Accounting Key Flex field, Accounting Fiscal Calendar, Ledgers, Reporting Ledgers for MRC transactions, Auto reversal, auto posting, and scheduling the transactions, Cross Validation rules and Security rules)

·         Configured inter-company and Intra-company Accounts so transactions can more easily be controlled, monitored and reconciled.

·         Designed and setup up FSG (financial statement generator) for generating different types of financial reports

·         Worked extensively with development to help them design the Physical Layer, Business Model & Presentation Layer.

·         Designed Reports & Dashboards using Business Intelligence (OBIEE) solution based on client’s needs.

·         Configured the Payables module including the following (Financial options and Payables options, Invoice Attributes Payment Terms and Distribution sets, Special calendar, recurring invoices and Expense report templates)

·         Designed and Configured the Approvals Management Engine (AME) for Payables Invoice Approvals, Payables Invoices Holds Release (Price Variance, Quantity Hold) in addition to Approving iExpense reports by managers and auditors, based on the client’s rules and requirements.

·         Implantation and support for 1099 Supplier reports.

·         Designed the client’s check, electronics and wires templates using xml publisher.

·         Defined the payment process profiles for different domestic and foreign banks

·         Used oracle’s transmission configuration to automatically transmit the electronic payment files to the banks.

·         Designed, Implemented and automated the process of sending the Positive Pay File to the bank.

·         Configured Receivables module including the following (AR System Options and Defaults, customers, Invoice attributes - Payment Terms, Transaction Types, Accounting Rules, Memo Items, recurring invoices, Auto Accounting, Invoice Sources, and Adjustment Approval Limits)

·         Implemented lockbox solution by importing a lockbox file from the bank where receipts will be created and applied to AR Invoices.

·         Enter Receipts - Cash and Miscellaneous receipts - Batches - Manual regular, Manual Quick cash, Automatic

·         Enter Remittances - Manual and Auto Create, Clear Receipts - Using the Automatic Clearing program

·         Collection Parameters - Collectors, Aging Buckets

·         View Collections - Enter call details, View scheduler, customer information, transaction details, account details, aging.

·         Analysis and configuration of Mass Additions, Adjustments/Transfers and Assets Depreciation.

·         Designed an auto reconciliation process that matches figures from the accounting records against those shown on a bank statement helping users reconcile and close their month

·         Completed the necessary prerequisites and configuration setups for the Cash Management module (Transaction Codes, Bank Statement Mapping) to complete and execute the auto reconciliation process

·         Designed a travel and expense solution that streamlines and automates travel spend management

·         Provides a way for employees and contingent workers to enter their expense reports where their expense reports become invoices in Oracle Payables.

·         Designed expense report templates that contain a list of expense items to be used for reimbursements.

·         Collected requirements around Indirect Tax (Sales Tax, VAT, Offset taxes etc.).

·         Created process flows for Regime to Rate flows and functional design activities for E-Business Tax.

·         Drive test planning and execution for the regime to rate setups.

 

 

 

 

Client : CHRONICLE BOOKS, San Francisco, San Francisco, CA                                               Sept 2012 – Aug 2013

Chronicle Books is a San Francisco-based American publisher of books for adults and children founded in 1968 and bought by McEvoy Group in 1999. The company also sells custom publishing and gift accessories.

 

Role : Oracle Financial Functional Lead

Product Version: 12.1.3.

Managed and handled the following modules: GL/AP/CM/IBY

 

Responsibilities:

·         Worked as a financials lead on the implementation of Oracle E-Business Suite R12 Financial Modules (GL/AP/CE) performing the following business tasks: requirements gathering, functional gap analysis, application design, configuration, module setup, test script generation, writing training guides, training end users, and production support

·         Managed team of functional & technical resources in process area of Financial Modules.

·         Implemented Reporting Currencies Setups, Chart of Accounts, Multi Org, FSG, Budgets and Flex fields.

·         Good Exposure to Reconciliation of Sub-Ledger modules with GL, Accounting Setup Manager, Inter Company Accounting and MOAC.

·         Documented current process module, future businesses process module and system configuration using ABF Methodology to enrich project management.

·         Designed solutions to enhance standard oracle flows for Procure to Pay (P2P), Assets to GL, TCA, GL Accounting processes.

·         Designed Functional solutions to the Key Gaps through Interface, Extension, Customization, Reports.

·         Designed and Configured the Approvals Management Engine (AME) for Payables Invoice Approvals, Payables Invoices Holds Release (Price Variance, Quantity Hold) based on the client’s rules and requirements.

·         Collaborated with the Business users during the various stages of project lifecycle (CRP to UAT)

·         Supported month-end closing activities with business users and helped reconciliation with the accounting team.

·         Implemented AP/AR Netting which allows you to net your Payable invoice balances against your Receivables invoice balances for those Customers who are also your Suppliers.

·         Expertise in post implementation support, prepared training manuals and also trained end users.

 

 

Client : FXDD, New York, NY                                                                                                         Sept 2009 – Nov 2010

FXDD is a forex broker in the market, focusing mainly on America, Europe, Asia and Japan. It offers its forex trading clients a comprehensive environment of capabilities and support comprising a wide variety of trading tools. It has its own trading platform, the Metatrader platform, where clients can trade online.

 

Role : Oracle Financial Functional Consultant

Product Version: 12.0.5

Managed and handled the following Modules: GL//AR/AP/CM

 

Responsibilities:

·         Implementation and testing of Oracle Applications Financial R12 GL, AP,,AR and CM modules.

·         Involved in designing the Chart of accounts to ensure adequate coverage for financial reporting.

·         Requirement gathering and analysis and design of the application.

·         Designed Ledger Multi-org in R12.

·         Post implementation support and interacting with Business users on resolve incidents.

·         Worked with the oracle technical team to help design conversions, interfaces, reports.

·         Reconcile AP with bank statement in Cash Management.

·         Funds into Accounts Receivable: Responsible for the analysis and design of five interfaces. These will each have logic and algorithms to match funds from different sources/Banks (JP Morgan Chase, Key Bank, Pay Pal, BPS and Click & Buy) to customer accounts

·         Funds out: Designed programs pertaining to funds out to the banks (JP Morgan Chase, Pay Pal, BPS, Click & Buy) using different payment methods: Electronic Checks, Wires, NACHA Files

·         Responsible for user accepting testing in test instance and worked with certain key super users, prepared required documentation, user manuals, knowledge transfer and handover for the client.

 

 

Client : HARVARD BUSINESS SCHOOL PUBLISHING, Boston, MA                                                         May 2008 – July 2009

Harvard Business School Publishing is a wholly owned subsidiary of Harvard Business School. It operates as an umbrella corporation to manage a group of publishing products associated with the school, including Harvard Business Review, the school's management journal, Harvard Business Press for general-interest business books, and Harvard Business School Case Studies.

 

Role : Oracle Financial Functional Consultant

Product Version: 12.0.5

Managed and handled the following Modules: GL/AP/SLA

 

Responsibilities:

·         Setting up the GL including the following major configurations and definitions (Defining and compiling Accounting Key Flex field, Ledgers using Chart of Accounts, Calendar, and Currency and required accounting combinations, Reporting Ledgers for MRC transactions, FSG (financial statement generator) for generating different types of financial reports, Cross Validation rules and Security rules, Recurring journals template, recurring journals and Auto-reversal)

·         Design analysis and configuration for Payables (Defining financial options and Payables options, Invoice Attributes-Payment Terms and Distribution sets, special calendar, recurring invoices)

·         Configure System Cash Management (bank accounts, bank documents, bank codes, Bank Transaction Codes, Transaction Mapping, Reconciliation, Cash forecasting and Cash positioning)

·         Analysis and design of a concurrent program used to interface all revenue generated from Oracle Order Management to Oracle Account Receivables route into Oracle Project Account for project profitability and reporting analysis

·         Designed a program that stores and views transactional summary data.  This data is summarized based on the customer’s activity on the source system currently

·         Responsible for the design of custom workflows to be configured based on implementation specific business rules of the each client

·         Defined Web ADI template for GL journal

 

 

 

 

Client : AMALGAMATED LIFE INSURANCE COMPANY, New York, NY                            Nov  2007 – May2008

Amalgamated Life Insurance Company is a third party administrator, a medical management company, a computer service company and a printing and graphics company.

 

Role : Oracle Financial Functional Consultant

Product Version: 12.0.5

Handled the following Modules:  GL/AR/AP

 

Responsibilities:

·         Setting up the GL including the following major configurations and definitions (Defining and compiling Accounting Key Flex field, Ledgers using Chart of Accounts, Calendar, and Currency and required accounting combinations, Reporting Ledgers for MRC transactions, FSG (financial statement generator) for generating different types of financial reports, Cross Validation rules and Security rules, Recurring journals template, recurring journals and Auto-reversal)

·         Design analysis and configuration for Payables (Defining financial options and Payables options, Invoice Attributes-Payment Terms and Distribution sets, special calendar, recurring invoices)

·         Configuration for Receivables (Define System Options and Defaults, Invoice attributes - Payment Terms, Transaction Types, Accounting Rules, Memo Items, recurring invoices, Auto Accounting, Invoice Sources, and Adjustment Approval Limits, Receipt attributes - Remittance Banks, Customer Bank, Receipt Classes, Receipt Sources, Auto Cash Rule Sets, and Distribution Sets)

·         Implement lockbox solution by importing a lockbox file from the bank where receipts will be created and applied to AR Invoices.

·         Enter Receipts - Cash and Miscellaneous receipts - Batches - Manual regular, Manual Quick cash, Automatic

·         Enter Remittances - Manual and Auto Create, Clear Receipts - Using the Automatic Clearing program

·         Collection Parameters - Collectors, Aging Buckets

·         View Collections - Enter call details, View scheduler, customer information, transaction details, account details, aging)

 

 

Client : MALIA GROUP, Beirut, Lebanon                                                                                            Oct 2005 - Feb  2007

Malia Group is a multifaceted organization owning equity participation in several companies dealing in the production, marketing, sales and distribution of pharmaceuticals, consumer goods, personal-and professional-care products and fashion retail.

 

Role : Oracle Financials Functional

Product Version: 11.5.10.2

Module: AR/AP/CE

 

Responsibilities:

·         Interacted with the Business users for understanding the Requirements and subsequently developed functional design document (MD-050)

·         Responsible for gathering Business Requirements, Identifying Gaps & Fit Gap analysis.

·         Configured and tested business scenarios for CRP1, CRP2 and UAT.

·         Designed & implemented a Customization on “Refund process” (with the help of Technical team) to refund the amount to the Customer by cutting a check in AP.

·         Implemented a major Enhancement “Journal entry creation for Cash management Entries” to perform reconciliation of bank statements entries which avoid manual intervention.

·         Evaluating the Reports and testing them for the desired outputs after development as Per the Business requirements.

·         Responsible for configurations for Accounts Payables, Accounts Receivables & Cash Management.

·         Providing solution for Revenue Recognition for orders in AR.

·         Helping technical team develop a customized Revenue Recognition program in AR.

·         Developed and executed test scripts and drove resolution of fixes to the system prior to UAT.

·         Responsible for end to end testing on Accounts Payables.

·         Testing the entire process of Payables transfer to GL, AP Assets creation and mass Additions create through Payables.

·         Set up of Desktop ADI and test the creation of Journals along with WEB ADI.

·         Evaluating and adding account combinations so Account Generator runs smoothly for Depreciation run.

·         Played significant role in system Integration testing and production support.

 

 

 

Client : MALCO GROUP, Beirut, Lebanon                                                                                      March 2006 - Oct 2006

Malco Group is a Bread Production/ Trading, Fast Food Chains, Foodstuff Industry/Trading, Import / Export, Restaurants Management.

 

Role : Oracle Financial Functional

Product Version: 11.5.10.2

Module: AR/AP/GL/CE/FA

 

Responsibilities:

·         Gather Business requirements and worked with End-users on Issues resolution

·         Study of the current Business Process, Suggestion of future Processes and GAP Analysis using AIM documents.

·         Defined Set of books, accounting flexfield structure

·         Resolved Client/User issues during Testing Phase and Post implementation support.

·         Prepared and Executed Financials Test scripts

·         Interacted with End-users on day to day business operations.

·         Worked on Reports Development.

·         Validation of Data Migration and data loading.

·         Preparation of training materials.

·         Trained End user on Oracle Financials.