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.