Senior Oracle Techno-Functional SCM/MFG Consultant

Refaat Ibrahim Elsayed

Mobile: +201*********)

OBJECTIVE

Professional with extensive experience in Oracle business for five years and more in financial, human resources and supply management especially in the United Arab Emirates, Africa and the Middle East,

I have gained considerable experience in the field of Oracle, since I have worked in many industries such as Manufacturing, Transformers, Construction, Projects, Housing and also Maintenance of cars,

I am always looking for self-development and always looking for everything that is good for me and my company and always looking for a new challenge to prove myself and my abilities.

Key Skills:

Oracle App DBA (Install - Cloning – Patching - Concurrent Managers).

Oracle Supply Chain Management (OM – INV – PO – LCM – Cost Management).

Oracle Financial Modules (GL - AP - AR).

Technical Skills (Toad – SQL – Pl/SQL – BI Publisher – Report Builder – XML Publisher – Oracle Discovery - Alert – Personalization – AME – Data Loader).

Microsoft Office ( Excel – Visio – Project – Word).

Linux environment (Oracle Enterprise Linux 5.7/5.8/6.5/6.6/7).

4 full cycle implementations (analysis, design, configuration, data migration, testing, training to cutover) of Oracle EBS financial modules + 1 rollout Project.

Gathering and Analysis, Business Process Design, CRP's, Documentation and Systems Configuration.

Capable of Leading and managing implementations, flexible to work extended hours and over the weekends on need basis

Good written and verbal communication skills

Develop Oracle Application Functional and Technical specifications based on business requirements and analysis and design of technical solutions to business problem Participate in reviews for requirements, architectures, designs, code and test plans.

Provide management with ongoing recommendations to advancements in Oracle ERP technology and applications.

Support of business users in terms of clarification, training and changes.

Become single point of contact for any support call or enhancement / upgrade / rollout requirement in the domain.

Review, evaluate, analyze and participate in planning for such project.

Quality assurance of the delivery and production movement for the configuration.

Facilitate knowledge sharing among the team.

Responsible for maintenance of all the documents related to functional work.

Able to manage a team onsite and offshore.

Work Experience:

Lootah Group of Companies, Dubai, United Arab Emirates Jun 2016 - Present

Senior Oracle Techno-Functional SCM/MFG Consultant

Highlights:

The company focuses on the purchase / sale / renting of residential and commercial properties and land within the UAE. At the same time, the company is also being involved in developing properties at prestigious locations in Dubai. The company also runs an exclusive real estate division, involved in various real estate contracts pertaining to residential and industrial warehouses.

Key Responsibilities:

Responsible for support Oracle SCM/MFG Modules (support & implement).

Translated business requirements into system requirements, design specifications and document new and/or existing application requirements. Ensure that new or existing systems meet business requirements and practices and that all application interface issues/concerns are understood, documented and addressed satisfactorily.

Supported 60 employees and managers in multiple modules (GL - AP - AR - PO -INV- OM – BOM – WIP – QA - OPM) through direct interviews and also through Communication

Conducted Conference Room Pilot and User Acceptance Testing sessions

Collaborated with all departments to ensure all management reporting requirements are defined and supported by the current systems

Identified product gaps and design solutions to meet those gaps

I supported more than one company at the same time up to 5 companies in 2 different countries.

Created and manipulate all reports required by users & managers (Report Builder, XML publisher, Toad).

Engaged Business Users spanning multiple departments and ensure cohesive articulation of business goals and processes to ensure effective solutions.

Engaged Business Users to support all necessary clarification to design and implement an effective Solution in (Finance – SCM - MFG) modules.

Open and follow up tickets SR with Oracle.

Verification of feasibility of Business User's request functionality and business rules based on existing technical systems and data structures.

Developed testing scenarios and write test scripts.

Worked with documentation team to develop user guides and training materials.

Oracle Apps DBA

Key Responsibilities:

Managing Oracle Apps DBA [patching, upgrade, clone, backup/restore, …]

Monitor DB data files and table-space growth.

Managing Concurrent Managers and Concurrent Programs.

Code Migration Support to Functional Consultants

Handling tickets raised by functional/technical/business users

Patch Analysis where there is a patch needs to be applied.

Patch Application as per schedule.

Cloning as per schedules.

Backups and issues related to them.

Query response time and other Performance Issues.

Work with Oracle Support by raising SRs on several issues.

Regular database maintenance activities (table space management, purging log files).

Lootah Projects:

1 . National Ready Mix – KSA JUN 2016 – Aug 2016

Highlights:

National Ready Mix is a subsidiary of Lootah Group of Companies UAE, Works in the manufacture of concrete.

Project description:

Functional assistance to running financial, Procurement and Production modules implementation. Project includes the continuous development of the implementation and integrations Cycles.

Key Responsibilities:

Apply Arabic Patch.

Full cycle implementation project for SCM/MFG modules.

Upload Master Items.

Upload Inventory Open Balance.

Conducted user-training sessions.

2. INMAA Djibouti - Tadjoura Water Factory, Djibouti Nov 2016 – Jan 2017

Highlights:

INMAA Djibouti is a subsidiary of Lootah Group of Companies UAE, Works in the manufacture of Mineral water bottles.

Project description:

Functional assistance to running financial, Procurement and Production modules implementation. Project includes the continuous development of the implementation and integrations Cycles.

Key Responsibilities:

Full cycle implementation project for SCM/MFG modules.

Resolved technical and operational problems in a timely fashion.

Supported employees and managers in multiple modules (INV – PO – ONT – BOM - WIP).

Upload Master Items.

Upload Inventory Open Balance.

Identified product gaps and design solutions to meet those gaps.

Conducted Conference Room Pilot and User Acceptance Testing sessions

Conducted user training sessions.

Roll out Full Implementation Project at

El SEWEDY Transformers Company, 10th of Ramadan City, EGYPT JAN 2011 – MAY 2016

Oracle APPS DBA & Oracle SCM/MFG Functional Consultant

Highlights:

At Elsewedy Transformers are committed to providing our customers with distinguished products and services. We extend to enhance our partnership with our customers by covering all specific requirements and by being available everywhere. We select more than one country every year to start up a new facility in order to respond properly to the local requirements.

Key Responsibilities:

Overview about their business & their expectations about the product features & Offerings

Transferred all Manual process to do through Oracle Applications

Delivering Training Manuals for end users.

Assistance to Technical Consultants for reporting.

Supporting for All SCM/MFG Modules.

Solve Gap between System and Business.

Engaged Business Users to support all necessary clarification to design and implement an effective Solution in Finance modules.

Co operated with team members for completing the project phases and resolving any problems during the project

Created AIM Documents (BR.100, TE.040, User Manuals, BP.080, DO.070)

Achievements:

Implement ATO cycle.

Implement OSP cycle.

Implement drop shipment cycle.

Implemented Landed Cost Management (LCM) Module.

El SEWEDY Project:

SUDATRAF Transformers Company, Khartoum, SUDAN Jan 2014 - Sep 2015

& SEDC Company for Contracting & Projects

Oracle APPS DBA & Oracle SCM/MFG Functional Consultant

2 Full project cycles for 2 companies (SUDATRAS & SEDC)

Highlights:

Works in the field of electrical transformers, geared up to deliver our commitment and to develop the Partnership relation with our customers on a win-win base, established on 2005 with a location at Khartoum City, Sudan.

The operational area of the factory is 12,000 square meters under roof, which enables us to produce 6000 units yearly.

Project description:

Functional assistance to running Financial, Procurement and Production implementation. Project includes the continuous development of the implementation and integrations Cycles.

Key Responsibilities:

Repair and maintain oracle application R12 .

Make a clone server.

Make a script to take a backup daily from database.

Setup Oracle Discovery.

Install Oracle BI Publisher 10.

End-to-end implementation for SCM/MFG (PO, INV, OM, BOM, WIP, QA) modules.

Implement ATO cycle.

Implement OSP cycle.

Implement drop shipment cycle.

Implemented Landed Cost Management (LCM) Module.

Created all the required reports from users and managers

Resolve technical and operational problems in a timely fashion.

Provides encouragement to team members, including communicating team goals and identifying areas for new training or skill checks

Delivering Training Manuals for end users

Created AIM Documents (BR.100, TE.040, User Manuals, BP.080, DO.070)

Delivered Training sessions for end user to increase their performance using Oracle

Co operated with team members for completing the project phases and resolving any problems during the project.

Conducted presentations and live demos for clarifying and resolving any issues the customer may have regarding the Application.

IT Support Engineer

Key Responsibilities:

Establish, maintains and tests network, applying knowledge of network administration and system engineering techniques and computer systems

Install and perform minor repairs to hardware, software

Make monthly reports on clients’ systems

Eastern Trading Company - Skoda EGYPT Mar 2015 - May 2016 Part Time

Oracle Apps DBA – SCM Techno Functional Consultant

Highlights:

El Sharkawy group has established since 1965 mainly in tourism and automotive business. In the year 1998, El Sharkawy group has participated in the Egyptian Germany Automotive company (EGA), and also has contributed in (NATCO) the main Mercedes Benz dealer in Egypt.

The Chairman's efforts in the automotive business were continuing till he established many brands for sales and services: (SKODA, HYUNDAI, etc.)

Project description:

Functional assistance to running financial modules functional and Technical reporting wise Implementation (GL – AP – AR – Depot repair – OM – PO - INV)

Project includes the continuous development of the implementation and integrations Cycles

Key Responsibilities:

Setup oracle application R12.

Make a Clone Server.

Make a script to take a backup daily from database.

Troubleshoot concurrent service Issues.

Monitor DB data files and table-space growth.

Supported employees and managers in multiple modules (GL - AP - AR - PO –INV – OM - depot repair) .

Resolved technical and operational problems in a timely fashion.

Conducted Conference Room Pilot and User Acceptance Testing sessions

Created and manipulate all reports required by users & managers (Report Builder, XML publisher, Toad).

Engaged Business Users spanning multiple departments and ensure cohesive articulation of business goals and processes to ensure effective solutions.

Engaged Business Users to support all necessary clarification to design and implement an effective Solution in Finance modules.

Verification of feasibility of Business User's request functionality and business rules based on existing technical systems and data structures.

Developed testing scenarios and write test scripts.

Senior Planning Stock Controller at Olympic group – Delta NOV 2006 DEC 2010

Key Responsibilities:

Work on oracle application

Prepare daily report on the performance work

Prepare daily report of material deficits of suppliers

Prepare daily report on materials rejected of suppliers

Prepare daily report on ore material of suppliers

Prepare monthly report on suppliers problems

Prepare monthly report of suppliers evaluation

EDUCATION:

Bachelor of Computer Science from Future Academy

Graduate Year 2006 – Grade Very Good

Key Trainings:

Oracle supply chain and Manufacturing (Next Academy)

Oracle Payable and Oracle Receivable – Self Study

CCNA (Kit Academy)

MCITP(Central Agency For Public Mobilization and Statistics)

DBA Advanced (TSS Academy)

PERSONAL INFORMATION:

Date of birth: 04 April 1985

Military status: Exemption

Marital status: Married

Skype ID: ******.**********@*****.***

Email ID: ****************@*****.***

Eligible to travel and live in any country

Contact this candidate