SUMMARY:

• 10+ years of extensive experience as Oracle Applications Technical Consultant with Implementation, Upgrade, Migration, Production Support of Oracle EBS Applications (R12.2.4 and 11.5.10) in various modules with major focus on Order Management, Inventory and Shipping.
• Implemented EBS - OTM Trip stop interface solution and implemented Multi-leg/Multi-trip shipment in 12.2.4 platform for the first time in industry.
• Technically proficient in RICEW components (Reports, Interfaces, Conversions, Extensions and Workflows) development using Oracle Database 10g/11g, Oracle Forms 6i, Reports 6i, SQL, PL/SQL, JDeveloper, BI Publisher, Workflow Builder etc.
• Experience in Procure to Pay (P2P), Order to cash (O2C), Back to Back Supply Chain business flows.
• Expert in Customizing Oracle reports and developing new reports by using Oracle Report 6i/10g and XML Publisher (BI Publisher).
• Experience in importing data from legacy systems to Oracle Applications.
• Strong Knowledge of Application Implementation Methodology (AIM), Application Object Library (AOL) implementation standards and Software Development Life Cycle (SDLC).
• Expert in SQL Performance tuning for optimized results.
• Good knowledge on SOA BPEL, OAF and ADF.
• Expertise in EBS R12 upgrade activities in R12.2.4 platform.
• Good understanding on Oracle Transportation Management (OTM) and Global Trade Management (GTM).
• Worked on Oracle EBS (12.2.4) to OTM/GTM (6.3) Web Service integrations.
• Driven CRP session for Integrated Trip stop solution for Multi-leg shipment scenario.
• Automated the process of Item reservation, Pick release, Pick confirm, Multi leg trips creation, Ship confirm and Serial numbers assignment in a single Concurrent program to back-up the OTM based trip creation process.
• Excel in team collaboration, quick adaptation and problem solving with good communication skills.

PROFESSIONAL EXPERIENCE:

Technical Lead

Confidential

• Identifying the RICE components for retro-fitment for R12.2.4 environment as part of R12 upgrade activities.
• Prioritizing the components as Work packet groupings and working on retro-fitment of the same.
• Coordinating with DBA team on Upgrade steps like Pre-upgrade, Upgrade and Post-upgrade activities.
• Analyzing the OPCC outputs generated in the R12 instance based on the R12 patches applied by the DBA.
• Fixing the OPCC violations in the R12.2.4 environment in accordance with Oracle Standards.
• Raising Service Tickets (SR) with Oracle on issues with Standard components.
• Working on Workflows, Forms, Reports, PL/SQL Packages based on Work packet assignment.
• Working on CEMLIs as part of R12.2.4 transformation.
• Implemented multi-leg shipment between OTM and EBS for the first time in 12.2.4.
• Driven CRP sessions for Integrated Trip stop solution for Multi-leg shipment scenario.
• Worked on BI Publisher reports for Intransit Inventory tracking, Shipment Reconciliation between Commercial Invoice and AR Invoice.
• Automated the process of Item reservation, Pick release, Pick confirm, Multi leg trips creation, Ship confirm and Serial numbers assignment in a single Concurrent program to back-up the OTM based trip creation process.
• Preparing MD070 and TE020 documents for the retro-fitment and CEMLI components.
• Onsite-offshore coordination.

Track Lead

Confidential

• Responsible for assigning support tasks and production tickets to team members.
• Responsible for resolving P1/P2 tickets in the areas of PO, AP, AR and Inventory.
• Presenting status of issues reported vs resolved to Customer on daily basis.
• Streamlining the support process and preparing documents for different support related tasks.
• Onsite-offshore coordination.

Technical Lead

Confidential

• Upgraded and migrated B2B MMX queue connections and Tibco adapters from San Jose to Richardson Data center.
• Tested the technicality and functionality of B2B components, Concurrent programs, Service Order tools etc. as part of different test cycles after migrating to Richardson Data center.
• Participated in migration activities and post production support.
• Identification of all Master data to be migrated for Item, Item Categories, Item Cost, Price List and BOM Interfaces.
• Data migration using AD Parallel scripts.
• Building interfaces to convert 11i data to R12 data without any loss in data or functionality of Interfaces.
• Changing the logic of Item, Item Categories and BOM interfaces w.r.t. R12 compatibility.
• Identifying Core APC Set-ups and preparing BR100 documents and validation of Core and Custom set-ups post migration.
• Designing logic to sync-up Ids due to upstream 11i to R12 data changes.
• Worked on converting conventional Confidential Data Bus (CDB) methodology to Oracle Golden gate (GG) technology for data replication.
• Re-designing all the major interfaces (Item, Item Categories, BOM, Item Cost, Price list) to cope up with upstream changes without any data loss or functional loss.
• Onsite-offshore coordination.

Senior Developer

Confidential

• Requirement Collection and Analysis.
• Prepared detailed MD050 and MD070 documents.
• Working with Customers and other stakeholders to get the documents reviewed and approved for development.
• Developing RICE components and generating Unit Test Plans.
• Presenting the deliverables to Confidential Architecture Review Board (ARB) for approval.
• Working with QA Team and Business clients on functional testing.
• Created E-R Diagrams for EBS and Geo database entities.
• Designed the components using PL/SQL, Oracle Forms and Reports, Web Services 2.0 etc.
• Implemented Confidential ’s Service Order fulfillment functionality based on Geo routing using SOAP web services to connect EBS to Geo-spatial database, to improve Inventory optimization and to improve Service order SLA for the first time in Industry.
• Participating in Final Practice Run and Smoke testing of all the deliverables developed by team members.
• Resolving Production critical issues that were raised in the areas of Order Management, Inventory, Planning.
• Resolving Service Order processing issues from Order creation till Order fulfilment.
• Resolving Issues related to Internal order processing and Allocation.
• Resolving Issues related to B2B documents processing between Confidential and Third party vendors and workflow related issues.
• Worked on Issues related to performance of the Service Order delivery.
• Contribution towards Service Delivery Performance testing.

Software Developer

Confidential

• Involved in Oracle 10.7 to 11.5.9 upgrade activities.
• Created Oracle Alerts for day to day monitoring of Production activities.
• Worked on service tickets in the areas of OM, Inventory, BOM, WIP.
• Performed Production critical tasks in the area of Oracle Manufacturing on day to day basis.
• Developed CEMLI using PL/SQL, Oracle Forms and Reports.
• Documentation of CEMLI developments in the form of MD070.