Oracle Apps Technical Consultant
Integration Xperts
Total years of experience :18 years, 11 Months
The company was considered as pioneers of introducing the
concept of modern departmental store retailing in Karachi
Environment - Oracle Applications : 12.2.6
Description: P2P, O2C Technical Consultant.
Integration Development between Sales POS System.
Integration Development between oracle EBS and Sales POS System
(Retail Pro) → (AR, INV, PO).
Worked on the development of interfaces, Data Conversions, Developing
Reports, Customizing Oracle Reports In various modules such as
Oracle Financial (AP, AR, GL)
Oracle Purchasing,
Oracle Inventory
Developing new Reports, Customizing Oracle Reports various modules.
Involved in Customer Conversions to load Customer details into HZ tables
by creating staging tables and performing validations and finally loading
them in to base tables using TCA APIs
Worked on Auto Invoice Interface Program to validate and load credit
memos, debit memos and invoices.
Developed an outbound interface for open Payable Invoices.
Developed Purchase Order, Receiving and AP Invoice Interface.
Developed Supplier Interface.
Developed Inter Org Inventory Interface.
Developed Item Import Interface
Expertise in System Administrator responsibility to create users,
responsibilities, Values Sets and Request sets.
Developed custom templates for the invoice reports by calling sub
templates in XML/BI Publisher.
Project: #1.
SEARLE (Pharmaceuticals & consumer products manufacturing)
Searle Pakistan Ltd is Manufacturing of Pharma and one of the biggest companies of Pakistan in this organization, I am independently working as Technical Consultant at different modules Developing new Reports, Customizing Oracle Reports in various modules.
Oracle Financial (AP, AR, FA, GL, CM)
Oracle Purchasing, Oracle Order Management,
Oracle Shipping Execution
Oracle Inventory
Oracle Process Manufacturing
OPM Inventory
OPM Financial
OPM Formulator
OPM Process Engineering
OPM Production Supervisor
OPM Quality
Oracle Web ADI
Oracle System Administrator
Global HRMS Manager
●Coordination with different department & resolve any queries of ERP.
●Providing Oracle Training to users on the basis of necessary requirements
●I have as technical Oracle Implemented in the following New Plants of Searle Pakistan and Sister Concern Companies of IBL Group, Which were running ERP.
. At Lahore Plants of Pharma Products (Solid & Liquid)
. At Lahore Plant Searle Laborites (Intra Venous (IV) Products)
. At Korangi Plant
. At Karachi IBL Health Care
. At Searle Biosciences Private Limited
Loaded the vendor’s information from file to oracle Purchasing. Developed
Expertise in System Administrator responsibility to create users, responsibilities, Values Sets and Request sets.
Developed custom templates for the invoice reports by calling sub templates in XML/BI Publisher.
Developed PL/SQL scripts for validating the data and Storing the data into MTL_SYSTEM_ITEMS_INTERFACE and then populating the base tables by running the ITEM IMPORT Interface.
Developed PL/SQL procedures, functions, packages, triggers to validate the data and insert the validate data into Oracle Standard interface tables.
Project: #2. IBL HEALTHCARE (Nutritionals, medical & hospital products)
Description: O2C AND P2P as Technical Consultant.
Worked on the development of interfaces, Data Conversions, Developing Reports, Customizing Oracle Reports In various modules such as Oracle
Oracle Financial (AP, AR, FA, GL, CM)
Oracle Purchasing, Oracle Order Management,
Oracle Shipping Execution
Oracle Inventory
Project: #3. IFL (International food franchising (Dunkin Donuts)
Description: AP, AR, GL support as Technical Consultant.
Worked on the development of interfaces, Data Conversions, Developing Reports, Customizing Oracle Reports In various modules such as
Oracle Financial (AP, AR, GL)
Project: #4. UDL PAKISTAN (Agrochemicals, fertilizers & seeds)
Description: AP, AR, GL support as Technical Consultant.
Worked on the development of interfaces, Data Conversions, Developing Reports, Customizing Oracle Reports In various modules such as
Oracle Financial (AP, AR, GL)
Developing new Reports, Customizing Oracle
Project: #5. UNITED BRANDS (FMCG, food products marketing & distribution)
Description: AP, AR, GL support as Technical Consultant.
Developing Reports, Customizing Oracle Reports In various modules such as
Oracle Financial (AP, AR, GL) .
Project: #6. HABITT (Retail home & commercial furnishing & accessories)
Description: AP, AR, GL, PO, INV as Technical Consultant
Implemented the integration between oracle EBS and legacy POS System (Magento) (AR, INV, PO).
Worked on the development of interfaces, Data Conversions, Developing Reports, Customizing Oracle Reports In various modules such as
Oracle Financial (AP, AR, GL)
Oracle Purchasing, ,
Oracle Inventory
Project: # 7. AL-ABID Textile Mills (Textile Mills)
Description: AP, AR, GL, PO, INV as Technical Consultant
Implemented the integration between oracle EBS and legacy POS System (Magento) (AR, INV, PO).
Project: # 8. MYCART mycart.pk provides a one-stop, enhanced shopping experience to consumers online
Description: AP, AR, GL, PO, INV as Technical Consultant
Implemented the integration between oracle EBS and legacy POS System (Candela) (AR, INV Lot Wise, PO).
Worked as Oracle Apps Technical Consultant in various Oracle Implementations,
Specializing in modules like GL, AP, AR, OM, PO, INV.
Responsibilities
* Prepared User Requirements document (URD) for Data Migration from legacy to Oracle Apps.
* Developed SQL scripts to create temporary tables and developed SQL*Loader control files to
load the legacy data into the temporary tables.
* Worked on configuration and customization various oracle modules ( INV, AP, AR, GL) for
amulti-site, multi-phase implementation
* Worked on Open Item Interface to convert Purchased Item Information from Custom Purchasing
System to Oracle INV module.
* Conversion and reconciliation of Legacy AP Invoices and Payments into Oracle Applications.
* Designed and developed Payables interface import program and interface tables to
load invoices from the legacy systems into the oracle payables base tables.
* Designed and developed Conversion scripts to convert data from 11.0.3 to 11.5.10.2 systems for
AR Module. For the Customer related data, Scripts were developed to use the standard Customer
Interface program and includes converting Customers, Addresses, Sites, Contacts, Phones,
Profiles.
* Customized reports such as Invoice print report, Commercial Invoice, Customer Invoice report,
Print Selected Invoice, transaction detail report, Account Status report in AR.
* Validated the data and populated the Payables interface table through a Concurrent program
which in go submits a standard Payables Interface program.
* Customized Invoice Register Report by appending additional columns like invoice terms, supplier
site promotions cost and descriptive flex field information.
* Created a custom AP Trial Balance report.
* Developed Reconciliation Report using XML Publisher (BI Reports) Reporting Tool.
* Developed a new report to get users who have Purchase order and requisition open and are out
of the company
Responsibilities
* Learn Oracle Apps Reports.
* Developed SQL scripts to create temporary tables and developed SQL*Loader control files to
load the legacy data into the temporary tables.
* Worked on customization various oracle modules ( INV, AP, AR, GL) for amulti-site, multi-
phase implementation
* • Worked on Open Item Interface to convert Purchased Item Information.
Environment: Oracle Applications EBS 11.5.10.2 (AP, AR, PO, INV, GL, ), Oracle 9i, Workflow
Builder 2.6, Developer 2000/6i, Reports 4.5, BI Publisher 5.6.2, PL/SQL, SQL*Loader, SQL*Plus,
TOAD, Windows XP.