Post Job Free

Resume

Sign in

Oracle Techno-Functional Financials

Location:
Vaughan, ON, Canada
Posted:
April 01, 2015

Contact this candidate

Resume:

Oracle Consulting, Business Analyst, financial background and R12

certified:

- 18 years of ERP experience, including 15 years experience with Oracle

consulting and project management.

- Certification of completion Oracle Financials R12, 2011

- Wide experience in Oracle E-Business suite (General Ledger, Accounts

Payable, Cash Management, Accounts Receivable, Inventory and Fixed

Assets)

- Expert in integration between Oracle Modules and between Oracle and other

systems.

- Good knowledge in Oracle modules Purchasing, Order Management, Human

Resource and PL/SQL.

- Worked previously in Deloitte in accounting and auditing department, and

have knowledge of IFRS.

- Experienced in re-engineering for financial and logistics business

cycles.

Work Experience:

Marsh and McLennan Companies (Mercer) Feb 2010 - Present

Senior Oracle Financial Consultant

- Manage series of projects implementing new features.

- Liaise with the project team (Partners, Business and Technical Team)

- Design and document solutions for interfaces to integrate with third

parties systems and enhancements in Oracle Financial to improve the

daily work.

- Develop enhancements for existing interfaces between ORACLE and third

parties systems and design the integration architecture between Oracle

Modules and between Oracle and other systems.

- Document Business process, Functional Specifications and Test plan.

- Merging Mercer Groups (Global) into one instance as a preparation for

R12.

- As of R12 upgrade: Reviewed the business requirements; Fit/Gap analysis

sessions, developed Fit/Gap documentation and sign-off, investigated

R12 new features, developed solutions, performed configurations (GL,

CM, some of AR&AP) and Post implementation support.

- Develop scripts using PL/SQL for investigation and find solutions (ex.

interfaces, reports), then deliver for development. Support the BI

queries

- Conducted sessions to analyze the business enhancements, estimate LOE

for R12 enhancements Implementation ex. (secondary ledger, LE, AGIS,

new COA, etc.)

- R12 Post implementation support for 2 months.

- Implemented and planned R12 new features (Legal Entities, secondary

ledgers, etc)

- Planned and Implemented R12 (GL, AR, AP and FA) in new 2 countries

(Poland and Mexico).

MDS Inc 2008 - 2009

Senior Oracle Financial Consultant

- Managed and planned series of projects implementing new features.

- Liaise with the project team (Partners, Business and Technical Team)

- Conducted business requirement analysis sessions for each project,

developed BA documentation and received approval.

- Develop scripts using PL/SQL for investigation and find solutions (ex.

interfaces, reports), then deliver for development.

- BI (Designed the dashboard and implemented Discoverer).

- Designed customization to integrate with third parties Bank systems

(saving 7 days of 7 people)

- Developed enhancements in Oracle Financial (functions and reports) to

improve the daily work following the IFRS.

- Designed new reports to reconcile the Interco transactions, the data

sources are (AR, OM, AP and INV), saving 1 week of 3 people.

OrasInvest (Orascom Companies group) 2006 - 2008

OrasInvest is a group of companies that has different business units were

established to offer specialized telecom (infrastructure for wireless)

and other business services around Middle East.

ERP Manager Oracle Application

- Management role:

- Rebuilt the ERP team which supported the group of companies and

managed the selection of the outsourcing vendors.

- Presented the implementation approach to the Top Management and

received approval.

- Developed the implementation plans for twelve subsidiaries.

- Managed Oracle implementation in five companies using an internal

ERP team.

- Managed and rolled-out Oracle implementation in the remaining seven

international subsidiaries using an outsourcing model.

- Expanded the scope of implementations and deployed more Oracle

modules (HRMS and Manufacturing) in subsidiaries, after the success

of the implementations

- Merging OrasInvest Groups many into one instance as a preparation

for R12.

- Conducted business requirement analysis sessions for each group

(different business lines), understood and mapped business to

harmonize the solution and improving the support performance,

developed BA documentation, received business approval and developed

solutions. Pre-upgrade setup and data clean: example legal entities

setup, data clean (Currency translations, locations, value sets,

etc).

- 11i to R12 upgrade: Review the business requirements; Fit/Gap

analysis sessions, develop Fit/Gap documentation and sign-off,

investigated R12 new features, developed solutions and

configurations (GL, CM, some of AR&AP). Investigate the LOE for R12

enhancements Implementation ex. (secondary ledger, LE, AGIS, new

COA, etc.)

- Merging OrasInvest Groups many into one instance as a preparation

for R12.

- 11i to R12 upgrade: review the business requirements; develop

Fit/Gap, investigate new features and develop solutions.

- Oracle Implementation role:

- Conducted business requirement analysis sessions, identifying fit

modules, orchestrating inter-module integrations and designing for

customizations.

- Developed business analysis documentation using Oracle AIM

methodology, presented the BA documentation and received approval.

- Applied a CRP-approach implementation, centralizing the solution

design, standardizing business processes, and mapping documents per

business line as approved by corporate management.

- Implemented financials (GL, AP, AR, CM and FA). Supervised the

implementation of Logistics (INV, PO and OM) and Projects (Costing)

modules.

- Designed a high level solution for the Project costing integration

and work-flows.

- Developed 'report fit analysis' report to update the current reports

following the IFRS and designed new reports as per business need.

- Conducted localized gap analysis for each international subsidiary.

- Developed scripts using PL/SQL for investigation and find solutions

(ex. interfaces, reports), then deliver for development.

- Implemented BI (Discoverer).

- Supervised and approved the configuration of the implemented Oracle

modules, providing hands-on experience to functional consultants

- Supervised the support of Oracle modules post go-live, providing

Oracle expertise to the support consultants.

Raya Holding (ORACLE Partner) 1997 - 2006

Senior Applications Consultant 2002 - 2006

- Senior Application consultant responsible for full implementation of

financial modules (GL, AL, FA AR and Cash management).

- Responsible for full Solution Cycles (Procure to Pay, Order to Cash

Cycles and lease management solution).

- Completed many full international implementations within the plan and

budget (developed the business analysis, solution design, gap analysis

and test acceptance) in different types of business (Automotive,

manufacturing, Cement trading, petroleum See Appendix for detailed

projects.

MIS manager at United Paint & Chemicals group 1998 - 2002

- Implemented ORACLE in five sites, Head Office and four Industrial

Companies in different industries (Factories, Retail, Wholesale and

Constructors), for Financials modules (GL, AR, AP, FA) and Logistics

(INV, Bill of material).

- Conducted business requirement analysis sessions, design chart of

accounts, business and process re-engineering, identifying fit modules

and designing for customizations.

- Designed solution to customize the Payroll system and Integrated with

ORACLE Application. For 3 sites.

- Designed Point of Sales systems and Integrated with ORACLE Application.

For 30 showrooms, and POS server.

- Design and implement Costing systems and Integrate with ORACLE

Application (INV) and payroll module.

- Develop scripts using PL/SQL for investigation and find solutions (ex.

interfaces, reports).

- BI (Designed the dashboard and implemented Discoverer).

Other Experiences

Intercom Enterprises

Business Analyst, S/W Designer

. Implementation of ACC PAC Application for financials and logistics

modules.

. Business and System Design for Tailored Applications.

. Senior Business and System consultant to customize tailor

application including modules:

o General Ledger, Accounts Payable, Accounts Receivable, Inventory,

Promissory Notes, Cash management, Sales, Purchasing, Customer

database (inquiry), Legal Affairs.

Egyptian International Consultants Software (EIC)

Programmer / Analyst

. Developed business re-engineering as an activity of the JDE business

solution implementation.

. Developed separate applications including the following:

General Ledger, Payroll, Purchase Ledger, Purchase Orders, Sales

Ledger, Sales Orders, Inventory.

Deloitte Egypt, External Auditing and Accounting, CA

Education:

- Post Graduate Diploma in Computer and Information Systems, Sadat Academy,

Cairo.

- Member of Egyptian Association of Political Economy, Statistics and

Legislation, Graduation Project: Effect of International Monetary Fund

(IMF) Policies on Arab Countries.

- Bachelor of Commerce in Accounting, Ein-Shams University.

Soft Skills: by A&B Associates

- Leadership and management skills

- Group Presentation and public speaking skills

- Negotiation skills

- Strategic plan

Computer Skills:

Oracle E-business suite:

. Experience in Oracle Financial Track

. Experience in Project Management.

. Experience in Oracle Logistics (Inventory, PO, OM and Quotation)

. Very strong in Oracle Costing (business, high level functions and

integration with financial and Logistics)

. Experience in Oracle HR and fair in PR

. Business knowledge in EAM

Oracle Corp. Courses:

. Certification of completion Oracle Financials R12, 2011

. Discoverer end user and admin, 2001

. ORACLE SQL, 2000

. Developer 2000, 2000

. ORACLE Data base 2000

Software Packages : ACC PAC, SCALA, Oracle, OBIEE

Microsoft Tools : Microsoft Project, Excel, Word, Power Point and Visio

Language Skills: Arabic: Native Language English: Good

Appendix

Projects Participated in RAYA Holding:

- Al Jomaih Automotive Company (Saudi Arabia)

- Senior Application consultant responsible for full implementation of

Financials Modules: GL, AP, FA, AR, Cash Management.

- Senior Application consultant responsible for full implementation

cycles (Procure to Pay, Order to Cash Cycles and lease management

solution).

- Responsible for Automotive Lease solution (customize lease module

which will be integrated with ORACLE application).

- ROYAL JET (Abu dhabi)

- Senior Application consultant responsible for the basic setup of

Financials Modules: GL and AR Logistics module: INV, OM, Price

manager and Sales Administration HRMS module (business group,

positions, jobs and departments) for CRM implementation.

- Senior Application consultant responsible for the implementation of

Modules: GL, AR, AP, CM.

- Olympic (Trade Company)

Senior Application consultant responsible for the basic setup of

Financials Modules: GL and AR Logistics module: INV, OM, Price

manager and Sales Administration HRMS module (business group,

positions, jobs and departments) for CRM implementation.

- EGC (Glasses Company)

Senior Application consultant responsible for the implementation of

Financials Modules: GL, AP and AR Logistics module: INV.

- ASEC (Cement Company)

Senior Application consultant responsible for the implementation of

Financials Modules: GL, AP, AR and CA Logistics module: INV.

Senior Application consultant responsible for the Sales cycle

implementation for Cement business.

- UGDC (Petroleum Company)

Senior Application consultant responsible for the implementation of

Financials Modules: GL, AP, FA and AR.

- NATGAS (GAS Company)

Senior Application consultant responsible for the implementation of

Financials Modules: GL, AP, FA and AR.

Senior Application consultant responsible for full implementation

and integration cycle.



Contact this candidate