Muhammad Hashim Siddiqui Email & Phone Number

Karachi, Pk

Karāchi, Sindh, Pakistan

Oracle Apps/Fusion Technical Consultant

Karachi Division, Sindh, Pakistan

Karachi Pakistan

• Historical data uploading in all Oracle HR modules through open interface, API’s,, SQL Loader, Web ADI etc.• Integrations from legacy systems to Oracle EBS R12.• Developed RDF and RTF Reports of Financial, Order Management, SCM, OTL and HRMS.• Oracle fusion Core HR data loading through HDL's.• Developed OTBI reports and alerts via report bursting. • Developed XML Reports using BI Publisher.• Register Form in Ebs suit, Add Form in specific responsibility, menu.• Write extensive PL/SQL procedures, functions, packages, cursors.• Worked on SQL query optimization• Write scripts to create tables, indexes, views, aliases and synonyms to meet requirements.• Worked in the support system, performed the responsibility of system administration which involved creating users, setting up the user profile, registering and managing the concurrent programs.• Functional and technical expertise in the modules of Payroll, HRMS, FIN, SCM• Oracle Custom Workflows.• Importing data in Oracle Apps modules via open interfaces and APIs• Setting up and enabling Descriptive and Context Sensitive Flex fields, Key Flex fields, Value Sets and Lookups as per business requirements.• Reports Development as per EBS R12.x.x standard using Reports Builder 10g. • Oracle Key Modules i.e. Financials, Order Management , SCM, OTL and Oracle HRMS.

Pakistan

Project: #1. SEARLE (Pharmaceuticals & consumer products manufacturing) Duration - Dec 2008 to till date (Operational Support)Environment - R12.1.3Description: AP, AR, GL, PO, INV, OM, OPM support as Technical Consultant.Project: #2. HC (Health Care) Duration - Jan 2013 to Jun-2013Environment - R12.2.4Description: AP, AR, GL, PO, INV support as Technical Consultant.Project: #3. IFL (International food franchising (Dunkin Donuts) Duration - Jul 2013 to Dec-2013Environment - R12.2.4Description: AP, AR, GL support as Technical Consultant.Project: #4. UDL PAKISTAN (Agrochemicals, fertilizers & seeds)Duration - Feb 2014 to Jul-2014Environment - R12.2.4Description: AP, AR, GL support as Technical Consultant.Project: #5. UNITED BRANDS (FMCG, food products marketing & distribution)Duration - Aug 2014 to Dec-2014Environment - R12.2.4Description: AP, AR, GL support as Technical Consultant.Project: #6. IBL HEALTHCARE (Nutritionals, medical & hospital products)Duration - Jan 2015 to jun-2015Environment - R12.2.4Project: #7. HABITT (Retail home & commercial furnishing & accessories)Duration - Jan 2016 to Apr 2016Environment - R12.2.4Description: AP, AR, GL, PO, INV and implemented integration with legacy software between AR and INV support as Technical ConsultantProject: #8. AL-ABID Textile Mills (Textile Mills)Duration - May 2016 to Aug-2016Environment - R12.2.4Description: i have developed Integration between Magento and Oracle E-Business Suite.AP, AR, GL, PO, INV support as Technical Consultant.SAP ABAP Development.

Karachi

Worked as Oracle Apps Data Migration Consultant in various Oracle Implementations, Specializing in modules like GL, AP, AR, OM, PO, INV.  Developed the Triggers for implementing the complex business rules.  Used Custom PL/SQL API’S for converting open AP Invoices, Suppliers, Supplier Sites, Supplier Contacts, Customers using TCA, Open AR Invoices, and Open Purchase Orders from legacy system (Mainframe) to Oracle Applications.  Worked on SQL*Loader Scripts to migrate the invoice data from the flat files and populate the staging tables before implementing auto invoice interface.  Developed PL/SQL procedures, functions and packages for validating the invoice data before importing it into Account Receivables interface tables.  Worked on journal import interface program to import journal data from legacy system into GL Base tables.  Developed several Ad Hoc reports using Reports 6i.Developed complex reports using lexical parameters, bind variables and several SQL dynamic queries.  Developed Interface for the Standard Items of Sales Orders Import in OM.  Worked on Item Conversion in the INV Module.  Customized the Sales Order Invoice Detail Report in Order Management.  Customized Pack Slip report, Shipping, Back Order Report and Freight Carrier Listing Report in OM.  Modified Material Account Distribution Summary Report to run for all organizations in INVENTORY.  Developed Order Capture Exception Report to display errors, exceptions and modifications generated during Order Import Interface.  Developed Order Status Summary Report to provide the status of orders in the system for given time period.  Design and Development of Oracle BI Publisher Reports Layouts Templates and Data Templates using Oracle SQL.  Developed and worked on various customer facing invoice reports. Environment: Oracle Apps 11.5.10.2, AP, AR, GL, PO, OM, Oracle 10g, Forms 10g, Reports 10g Discoverer 10g, SQL*Loader, Workflow Builder 2.6, PL/SQL, XML Publisher, TOAD,WINDOWS XP, UNIX.

United Arab Emirates Uae

ROLE: Oracle Apps Technical Consultant 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. Environment: Oracle Applications EBS 11.5.10.2 (AP, AR, PO, INV, GL,), Reports 4.5, BI Publisher 5.6.2, PL/SQL, SQL*Loader, SQL*Plus, TOAD.

Pakistan

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., AR, FA, AP, INV Developed New and Customized reports.

Pakistan

Involved in Maintenance & in new implementation of COII (Certificate of Islamic Investment) System of Meezan Bank.Involved in Maintenance of Car Ijarah (Car leasing) System of Meezan Bank.Involved in Maintenance of General Ledger System of Meezan Bank.Involved in Maintenance System Maintenance System of Meezan Bank, which is used of Creation of new user accounts & assigning privileges to users for all above- mentioned system.

Pakistan

I have worked associated with ISM, a wholly owned subsidiary of NIFT (National Institutional Facilitation Technology Pvt. Ltd) as a “Quality Assurance Supervisor in Programming Section” for the project of NADRA (National Database & Registration Authority) Ministry of Interior Govt of Pakistan

Pakistan

I have worked as a oracle programmer