HASHIM SIDDIQUI

Develop OTBI, BI Publisher (BIP), and FAW reports/dashboards.
o Customize templates and optimize performance.
o Implement FBDI, ADFDI, and HCM Extract for data loads.
o Build REST/SOAP APIs and configure OIC (Oracle Integration Cloud).
o Extend Fusion using Visual Builder (VB Studio) / Redwood.
o Develop VBCS Application and integrate with Fusin/EBS.
o Develop Fast Formulas and modify Sandbox configurations.
o Debug integrations, workflows, and reports.
o Tune SQL/PLSQL and BI queries for performance.
o Provide post-go-live support and training.
o Assess impact of quarterly Fusion updates on customizations
- Design and develop Oracle Forms, Reports (BI/XML), Interfaces, Conversions, and Extensions (OAF)
- Customize Workflow Builder for approval processes (PO, AP, HR).
- Extend EBS functionality using PL/SQL, Oracle Application Framework (OAF).
- Develop **SQL*Loader, PL/SQL scripts, and Interfaces** for data migration.
- Integrate EBS with third-party apps using **Web Services (SOAP/REST), APIs.
- Work with **Oracle Integration Cloud (OIC) .
- Create **BI Publisher (BIP), XML, and Oracle Reports.
- Develop custom Financial, SCM, and HR reports per business needs.
- Optimize report performance and automate scheduling.
- Optimize **SQL queries, PL/SQL packages, and concurrent programs.
- Troubleshoot Forms, Workflows, and Interface errors.
- Monitor and fix performance bottlenecks in EBS modules.
- Apply Oracle patches, CEMLI fixes, and security updates.
- Test custom objects post-upgrade for compatibility.
- Document designs, test cases, and deployment steps.

Solid knowledge and third-party
systems.

Integration
• Integrated Retail Point of Sale (POS) with Oracle EBS via interfaces and APIs.
• Designed Biometric Device integration with Oracle HRMS Time & Labor using APIs.
• Migrated historical data from legacy systems to EBS (GL, AP, AR, PA, PO, Fixed Assets, Cash
Management).
• Leading Oracle EBS/Fusion technical development
• Provided technical support for Oracle Fusion Cloud Applications, ensuring successful implementation,
rollouts, and ongoing system stability.
• Managed and supported Oracle Integration Cloud (OIC) integrations, Visual Builder Cloud Service (VBCS),
Process Cloud Service (PCS), and App Composer across core Finance and HCM modules.
• Maintained and enhanced custom solutions and processes developed on Oracle PaaS.
• Assisted HCM functional teams with data management tasks, including HDL/HSDL loaders and HCM
Extracts.
• Utilized expertise in WSDL, REST, and SOAP APIs to support integrations across Fusion modules.
• Developed and optimized SaaS BI reports, OTBI reports, dashboards, and SQL-based data extraction
queries to support business intelligence and reporting needs.

Design and develop Oracle Forms, Reports (BI/XML), Interfaces.
- Extend EBS functionality using PL/SQL.
- Create **BI Publisher (BIP), XML, and Oracle Reports.
- Develop custom Financial, SCM, and HR reports per business needs.
- Optimize report performance and automate scheduling.
- Optimize **SQL queries, PL/SQL packages, and concurrent programs.
- Troubleshoot Forms, Workflows, and Interface errors.
- Monitor and fix performance bottlenecks in EBS modules.
- Apply Oracle patches, CEMLI fixes, and security updates.
- Test custom objects post-upgrade for compatibility.
- Document designs, test cases, and deployment steps.

• Led EBS technical team and project execution
• Designed and developed Oracle Forms, BI/XML Reports, and Interfaces to support enterprise
operations. - Extended EBS functionality using PL/SQL, delivering custom solutions for Financials and
Supply Chain modules.
• Optimized report performance and automated scheduling to improve efficiency and accuracy.
• Planned, developed, and implemented ERP modules tailored for textile operations, covering
procurement, production, inventory, sales, HR, and finance.
• Customized Oracle Forms and Reports to align with textile workflows, including modules for tracking
raw materials, weaving, dyeing, finishing, and shipment.
• Led the EBS technical team, overseeing project execution and ensuring timely delivery.
• Provided hands-on support and implementation for Oracle EBS, ensuring system stability and smooth
project rollouts.
• Opened, managed, and resolved Oracle Service Requests (SRs) with Oracle Support, maintaining clear
communication across business users, technical teams, and management.
• Conducted functional testing, debugging, and resolution of RICE components to ensure seamless
integration and performance.
• Coordinated with remote teams across time zones, meeting aggressive delivery timelines and
proactively addressing challenges.
• Applied strong expertise in Oracle APIs and open interfaces for data conversion, ensuring accurate and
efficient migration processes.

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.

• Technical lead for EBS/Fusion projects
• Provided technical support for Oracle Fusion Cloud Applications, ensuring successful implementation,
rollouts, and ongoing system stability.
• Managed and supported Oracle Integration Cloud (OIC) integrations, Visual Builder Cloud Service
(VBCS), Process Cloud Service (PCS), and App Composer across core Finance and HCM modules.
• Maintained and enhanced custom solutions and processes developed on Oracle PaaS.
• Assisted HCM functional teams with data management tasks, including HDL/HSDL loaders and HCM
Extracts.
• Utilized expertise in WSDL, REST, and SOAP APIs to support integrations across Fusion modules.
• Developed and optimized SaaS BI reports, OTBI reports, dashboards, and SQL-based data extraction
queries to support business intelligence and reporting needs.

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).

• Led multiple Oracle ERP implementations and upgrades
• Delivered hands-on support and implementation for Oracle E-Business Suite (EBS), ensuring smooth
project execution and system stability.
• Opened, managed, and resolved Oracle Service Requests (SRs) with Oracle Support, maintaining clear
and professional communication across business users, technical teams, and management.
• Conducted functional testing, debugging, and resolution of RICE components to ensure seamless
integration and performance.
• Coordinated with remote teams across time zones, meeting aggressive delivery timelines and
proactively addressing challenges.
• Applied strong expertise in Oracle APIs and open interfaces for data conversion, ensuring accurate and
efficient migration processes.
• Developed and supported Oracle EBS technical components including SQL, Forms, Reports, and BI
Publisher, with a focus on financials and supply chain modules.
• Utilized deep knowledge of Oracle EBS tables to support technical development and data conversion
activities.
• Designed and implemented integrations between Oracle EBS and SAP HRMS for salary-to-AP payment
processes, and between Oracle EBS and SAP SD for purchase orders and receipts.
• Led technical process design, including development of interfaces, data conversions, custom reports,
and Oracle report customizations across multiple modules.
• Gathered requirements, performed process engineering, and executed system configuration to align
technical solutions with business needs.

Worked as Oracle Apps Technical Consultant in various Oracle Implementations,
Specializing in modules like GL, AP, AR, OM, PO, INV.

• Led multiple Oracle ERP implementations and upgrades
• Delivered integrations, reports, and data migration solutions

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

• Customized and developed Oracle Reports using XML Publisher (BI Publisher)
• Developed SQL scripts and SQL*Loader programs for data conversion and integration

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.

• support activities
• Developed and customized reports based on business requirements
• Performed server backup and basic system maintenance tasks
• Gained hands-on experience with Oracle Applications environment

• Contributed to maintenance and enhancement of banking systems for Meezan Bank
• Worked on COII (Certificate of Islamic Investment) System implementation
• Supported maintenance of Car Ijarah (Car Leasing) System

• Worked on NADRA project under Ministry of Interior, Government of Pakistan
• Supervised quality assurance processes in the programming section
• Ensured data accuracy and system reliability for national database systems
• Coordinated with development teams to resolve system issues

• Worked as a junior/subordinate programmer on business applications
• Assisted in development and maintenance of internal systems
• Supported senior developers in coding, debugging, and testing
IBL Oracle
◦ Integrated Oracle with SAP (HRMS & SD)
◦ Designed technical solutions and reporting systems
SEARLE plants
◦ RICE components data migration solutions