Result driven Oracle SCM Techno-Functional Consultant with a comprehensive background spanning 8 years in of expertise in designing & developing custom applications in Oracle Application Framework (OAF). Proficient in AME and Oracle Workflow, Oracle Report Builder, Oracle Form Builder, PL/SQL Developer, Toad, Oracle JDeveloper. Orchestrating end-to-end implementation and optimization for Supply Chain Management modules. Possesses 7 years of hands-on experience streamlining operations, enhancing efficiencies, and configuring customized solutions within Oracle SCM. Proven track record of leveraging both technical and functional acumen to deliver impactful solutions that align with organizational objectives.
Involved in Implementations and Supporting Projects of Oracle Applications 11i/12.1 with hands on experience on various RICE Components
Having Good Knowledge on Oracle SCM Modules Such as Procurement(P2P) module, Inventory Module and HCM Module and good technical experience in Fusion APIs, FBDI, ADF DI Loads, BIP and OTBI
Gathered requirements from all stakeholders including admin, Conducting, Examining and Migration of Users
Worked in Data Modeling, SQL,PL/SQL including Stored Procedures, Functions and Packages and Views
Writing SQL
Loader Scripts to Create CTL Files in order to load the data into oracle base tables
Creating Value Sets for Report Parameter and registering them in applications
Design and developing various reports using Oracle Analytics Cloud and BIP.
Working Knowledge on Oracle Fusion ERP Cloud and PAAS products such as Java Cloud Service DBaas
Design and develop integration using Oracle Integration Cloud Service
Good Experience in ESS Jobs, OM Extensions, Flex Fields(DFF/KFF), Lookups, Value Sets and Fusion Apps Functional Setup Manager Configuration
Experience in Payroll Inbound Data Migration using SQL
Loader and Outbound Interface using UTL_FILE Package
Working Knowledge in ADF UI/Task Flows/ADF integration with Web service such as SOAP /REST API
Oracle HRMS Suite Manager
Al- Raya Super Market
01.2008 - 08.2008
Managed the Oracle HRMS Suite, a standard Oracle Application Software consisting of modules such as Core HR, Payroll, Self-Service Human Resources (SSHR), I Recruitment (iRec), Learning Management (LMS), Time and Labor (OTL)
Maintained, modified, and developed new features in the application
Analyzed the entered data using queries
Gathered requirements from all stakeholders, including Admin
Analyzed requirements and designed reports as per the specified requirements
Managed change requests and ensured quality control
Oracle Process Manufacturing Consultant
Naft Lubricants Oil Company
01.2008 - 08.2008
Uploaded OPM data through standard API, including specifications, formulas, and Item Master
Developed new custom reports and custom forms
Administered the database/application, including patching, cloning, and shell script execution
Acted as an extensive technical lead throughout the implementation
Provided support/solutions for complex scenario mapping and implications in Oracle
Routinely reported status to project directors and managers
Oracle Discrete Manufacturing Consultant
Abbar & Zainy Cold Stores
01.2008 - 08.2008
Uploaded ODM data through standard API, including specifications, formulas, and Item Master
Developed new custom reports and custom forms
Administered the database/application, including patching, cloning, and shell script execution
Acted as an extensive technical lead throughout the implementation
Provided support/solutions for complex scenario mapping and implications into Oracle
Routinely reported status to project directors and managers
Oracle Discrete Manufacturing Consultant
Arabian Ceramics Co.
01.2008 - 08.2008
Developed customized home textile solutions
Developed a customized terry towel solution
Acted as an extensive technical lead throughout the implementation
Provided support/solutions for complex scenario mapping and implications into Oracle
Routinely reported status to project directors and managers
Oracle EBS Technical Lead
International Medical Hospital
01.2008 - 08.2008
Lead the project from the technical side as a technical lead
Developed applications using Apex
ERP EXECUTIVE ASSOCIATE
AL AZIZIA PANDA UNITED COMPANY
01.2005 - 08.2008
3+ Years of experience on Oracle Applications SCM /HRMS & Payroll 11i Technical work.
Developing and Customizing Reports for Finance//SCM/HCM module and Interface Programs
Developed Reports for PO,AP,GL,INV, AR and HR modules using Developer 6i
Responsibilities for preparing procedures, functions, custom packages as per requirements
Preparation of Technical Specifications from the functional specifications(CV60,MD70,MD120)
Analyze the design document for code changes, understand the intricacies, provide Estimate of timeframe in which this code change can go live.
Responsible for Creating different types of Value Sets in various modules of the application
Writing the Scripts to load the data from legacy system into Oracle Application tables
Involved in Registering Apps Forms, Menus, Data Groups, Request Groups and Data Objects needed for the project as per AOL Standard.
Create and interpret technical specifications as per project requirements.
Experience in Fast Formula, PL- SQL, OA Framework and Workflow, self-service personalization, VO extension and XML Publisher.
ERP SUPPORT ENGINEER
DIGITAL NATCOM
04.1998 - 11.2004
Worked on Oracle based ERP Orion 7.4, support the client’s User Acceptance Testing (UAT) and Support application go-live
Provide knowledge transfer to clients and ensure the client staffs are ready to operate the application upon go-live
Assist clients in transitioning the application to client’s production support team
Plan and execute effective hand-off to Power Plan’s Support organization
Identify client skill or knowledge gaps that might be addressed via Power Plan’s training organization and/or via an enhanced support model
Utilize and contribute to enhancing Power Plan’s implementation methodology as requested
Participate in special projects, training initiatives, industry groups and conferences, and client forums as requested
Preparing confidential reports on Oracle Discoverer which is used only by our Top management, which shows the full sales value, confirmed and unconfirmed Invoices.
Showing the details of each customer to our accounts personnel regarding cash, credit, and balances from Customers.
Loading Price list of Compaq and Alpha on Oracle database, which is in Excel by using SQL loader.
Description of Discoverer reports and Website can be produced on demand.