SUMMARY:

• Expert and Result Driven, Senior Oracle EBS professional with more than 12 years of experience in Implementation, Upgrade, Support, Extensions, third party applications integrations to Oracle e - Business Suite Applications 11i and R12 with hands on experience and as Project Manager.
• Experience in Oracle Fusion implementation data migrations and good exposure to Oracle Fusion SCM.
• Extensive experience in the areas of systems analysis, design, architecting, modeling, development and implementation of Oracle applications in timely fashion. Skilled in all technical aspects of Oracle E-Business Suite including multiple full Oracle ERP SDLC deployments for Oracle Applications R12/11i.
• Track record of strong problem-solving skills and ability to follow through with the projects from inception to Go Live and support activities.
• Experience working as Project Lead and Project Manager in driving multiple projects with clients, vendors, Offshore/Onsite teams.
• Experience with Oracle EBS upgrade from 11i to R12 in SCM modules ( ASCP, BOM,WIP, OPM, OM, Inventory),
• Experienced in solution designing and configurations in Oracle SCM Modules ASCP, BOM, Inventory, WIP, Order Management.
• Performed retrofit and redesign of Oracle Reports, Forms, Integration, Customization, Extension and Workflow elements to make code base compatible with R12 technology stack.
• Expert in Patch Analysis and support for patching by retrofitting the customizations. Performed the impact analysis of Oracle E-Business Suite patches on configurations, extensions, modifications and integrations.
• Sound Knowledge of Application Implementation Methodology (AIM) documentation, Application object Library (AOL) implementation standards, Software Development Life Cycle (SDLC), Waterfall and agile.
• Functional Proficiency in EBS modules, Oracle Inventory, Order Management and Shipping, Oracle Advanced Supply Chain (ASCP), Oracle Process Manufacturing, OPM Costing, OPM, P2P and O2C, Payables(AP), BOM, WIP, Oracle Warehouse Management (WMS), Oracle Purchasing (PO), Account Receivables (AR), Oracle General Ledger (GL), SLA(Subledger Accounting), Oracle Project Accounting,, Oracle iStore, Install Base, Oracle Core HRMS, Oracle Service Contracts and Service Requests, iProcurement, Oracle Cloud ERP Knowledge in data migrations.
• Expert in Developing Oracle Forms/Reports, XMLP reports, OAF(Oracle Applications Frame Work) customizations,3PL intefaces, Workflow Customizations, Discoverer reports, Business Events and Forms Personalization's.
• Expert in SQL and advanced PL/SQL using Collections with BULK COLLECT, Dynamic SQL, Cursors & MVs.
• Expertise in developing Data Conversions/Migration from Legacy System of various sources (XML, flat files and Non-Oracle Database) to Oracle system Using UTL FILE, SQL Loader and external tables.
• Experience in Data Flow Diagram, ER Diagrams using Microsoft Visio. Defining and Designing user requirements, convert design and specifications into code as per business requirements. Perform data analysis, developing and delivering end-user training, creating and maintaining project schedules, preparing and presenting project briefings to higher management.
• Strong interpersonal, analytical and communication skills, proven ability as an efficient team member in System Analysis, Design, Normalization, Data Modeling, Development and Migration.
• Proven ability to quickly grasp new technical, functional and business-related concepts and utilize as needed.
• RICEW experience including the design, development and customization of CUSTOM.PLL, Flex fields, Concurrent Programs, Oracle Reports, Alerts Setup and Interfaces using Public APIs, BI Publisher, Business Events, Conversions and Extensions.
• Highly contributed in CMMI appraisal corporate level as project manager in APPSASSOCIATES PVT limited.
• Successfully completed migration of discrete manufacturing organization to process manufacturing organization in the recent engagement and received an award of ‘Certificate of Excellence’ from Confidential .
• Actively participated and presented on OPM Manufacturing Configurations and Conversions in New York Metro Oracle Applications User Group (OAUGNYC).

TECHNICAL SKILLS:

ERP:: Advanced Supply Chain, Oracle Process and Discrete Manufacturing, Order Management and Shipping, General Ledger, Account Payables and Account Receivables, Oracle HRMS, Inventory, Purchasing, AOL, Alert Manager, Install Base, Mobile Field Service, and Oracle iStore, Inventory, Bills of Material, Work in Process, Oracle process and Discrete manufacturing Cost Management, Oracle Process Manufacturing batch execution and quality

Oracle Technologies: SQL, PL/SQL, Oracle Workflow and Business events, Oracle Forms & Reports 6i, Discoverer, XMLP, WebADI, OAF, ADF,Oracle Discoverer Reports, Custom.pll, Forms Personalization, APEX, Data Loader

RDBMS: Oracle 9.x, Oracle 10g

Languages: C, Core Java, SQL, and PL/SQL,XSL-FO,UNIX

Tools: Toad, Sqlloader, Oracle Workflow Builder, Discoverer, 6i Reports, Forms 10g, BI Publisher Reports and PL/SQL Reports, Jdeveloper, OAF, Data Loader.

PROFESSIONAL EXPERIENCE:

Oracle EBS Lead

Confidential, San Jose, CA

• Analyzing the Oracle Applications to implement and support all the customizations and extensions impacted due to Oracle R12 Upgradation and part of Oracle 12c database upgrade. Designing the process for Oracle R12 upgrade customizations upgrade in compatible with R12.2.5.
• Analyzing the applications for impacted customizations and working on technical design documentation, Implementing code changes and unit testing. Code configuration and deployment of all the customizations pertaining to SQL, PLSQL, Workflow, Forms, Reports, XMLP reports.
• Doing the GAP analysis to identify the impacted customizations in different ERP modules including Inventory, OM, BOM Advanced Supply Chain Planning, GL, PO, AP, AR, WMS
• Code review and artifact the documents in repository.
• Analyzing the Oracle R12.2.5 application changes related to database and documenting the facts for ERP modules Inventory, OM, BOM Advanced Supply Chain Planning, Projects Accounting, Service Contracts, iProcurement, GL, PO, AP, AR, WMS.
• Applying the any standard table changes which effects the customizations due to references and correcting all the invalid objects application schema wise.
• Applying MOAC (Multi Org Access Control) changes in all the customizations in Inventory, OM, BOM Advanced Supply Chain Planning, Projects Accounting, Service Contracts, iProcurement, GL, PO, AP, AR, WMS.
• Applying Online Patching changes: Edition based control changes in all the customizations in the modules Inventory, OM, BOM Advanced Supply Chain Planning, Projects Accounting, Service Contracts, iProcurement, GL, PO, AP, AR, WMS.
• Drive test and code deployment processes to the various environments (Integration testing instances, user acceptance testing and production).

Confidential, San Diego CA

Oracle EBS Lead

• Solution design and configurations in Oracle SCM Modules ASCP, BOM, WIP, Inventory, OM, for new inventory organizations migrated from Discrete to OPM Manufacturing.
• Implemented workflow process customization in OPM Quality Sample creation business event enhancement.
• Month end and year end support to business to close the pending transactions in the EBS system for all the applications.
• Working on enhancements for 3PL logistics interfaces for consumer invoice report integration with OM.
• ASCP Collections programs and Plan monitoring and scheduling the concurrent requests.
• Conversions in Oracle HRMS and developing PL/SQL programs using APIS approach.
• Working with oracle support SRS on technical or functional issues.
• Implemented quick data loader programs for mass data uploads using data loader utility.
• Implemented major enhancement Master Lot for manufacturing and shipping business, This includes objects pl/sql packages, customization in OL workflow, Custom XMLP reports.
• Implemented functional solution for single lot inventory picking for Shipping.
• Develop one of the complex report used in manufacturing business OPM Batch Ticket Reports that display complete information about OPM batch and its details like formula, lot technical information, onhand availability.
• Resolved complex issues in Cost Rollup and during manufacturing product and business is happy with the response provided.
• Resolved many complex issues during stuck inventory transactions due to costing issues.
• Implemented Key enhancements in ASCP data collections and Manufacturing forms.
• Data updates using standard APIS in Oracle WMS, PA, AP, PO, OM, Inv, BOM.
• Resolved high priority functional issues in PA, Financials and Manufacturing.
• Wrote Complex SQL to extract the data from ASCP and Manufacturing modules.
• Developed complex conversion programs for Manufacturing Modules OPM and WIP.
• Implemented outbound interface for manufacturing data into third party system Agile.
• Developed major interfaces data flow from Oracle Inventory module and Project Accounting.
• Developed a PA interface to transfer the materials issued out of inventory to be used on R&D projects. Custom Interface developed will ensure that project costs as viewed within Oracle Projects. This program interface table pa transaction interfaces all for each material transaction charged against a project. Standard program called in the interface program PRC: Transaction Import would then be leveraged to import the records into Projects as expenditure items.
• Worked on Developing a Project Accounting report that displays different organizations project expenditure in XML publisher.
• Developed Forms personalization in the projects creation form to display custom data validations and warning messages to users.
• Developer conversion PL/SQL programs using standard interface table approach for Oracle Projects, General Ledger, Inventory, Service Contracts, Service Requests.
• Single point of contact in San Diego location for Manufacturing Operations, Cost management, shipping warehouse issues Reports and Interfaces. Business is very confident about any break fixe solutions implemented.

Confidential

• Spearheaded project that merge Wisconsin based Business into San Diego business. This is migration of Discrete Manufacturing to Process Manufacturing project.
• This project went live within short interval of time with many Oracle Project, Service Contracts, Inventory, costing, OM conversions and customizations and reporting requirements.
• Starting from extracting the data Oracle Projects, Service Contracts, Discrete BOM Cost extractions to converting to OPM Objects,Quality Objects and end to shipping in Order management.
• Majority of the objects converted includes Oracle Project creation with modified data, Service Contracts creation with new org changes, Item changes include Key ATP settings, On hand Issues and On hand Receive complex issues due to hanging inventory transactions, Item Cost extract from Discrete Org and loading OPM org and loading the item cost in OPM and Distribution org.
• Reconciliation of the data migrated and testing the standard flow in OPM batch processing and OM flow.
• Cost reconciliation in discrete org and process org by running cost rollup in both the orgs.
• Code Migration maintenance and documentation maintenance and process adherence.

Confidential

• This is a major project for Confidential involving retirement of third party software live link for scrap transactions materials.
• This project implemented with OA Frame Work Custom pages, oracle workflow and pl/sql development.
• Implemented multi-level approval hierarchy using oracle workflow builder and CRM resources ad hoc roles.
• Implemented complex pl/sql package development in Oracle Inventory Module that will create inventory material transactions.
• Workflow developer send notification and approvals integrations.

Confidential

Project Manager and EBS Lead

• Understanding requirements and doing the GAP analysis and technical design of customizations involved in OM Quick Ship Form, Custom form for scrap inventory process, reporting the scrap transactions using XMLP report and developed workflow for updating Install Base record.
• Key contribution in design of the solution and implementation.
• Development of standard Oracle Form Customization, Buidling Scrap pl/sql customer concurrent programs, Workflow developer to update records in Install Bases,
• Developed WebADI programs for Items, Oracle Service Contract and Service Requests and this involved with developing Pl/SQL package with service contracts interface and reconciliation query to validate services contracts loaded.
• Code Review, Documenting MD070 and MD120 and code Configuration management and regression testing.

Confidential

Project Manager and EBS Lead

• Worked on building Interface between Project Accounting and Order Management using standard interface tables and developed custom validations and business logic in the pl/sql package.
• Worked on extraction of data for Adhoc requests from business on different module Oracle Project, Oracle Service Contracts, General Ledger, Iprocurement, Sales Orders, Install base.
• Worked on data update scripts using standard interface table approach for modules Oracle Service Contracts, General Leder, Account Payables, Oracle Projects Tasks, resources updates, Project expenditures updates, Sales Orders, Customers, Suppliers and Item Updates.
• Review enhancements methodology and suggesting mode of operation that optimizes cost, quality, and schedule, minimizes risk and maximizes customer satisfaction.
• Contribute in developing project plan and Project management from Offshore India, Effort estimation and resource management.
• Project Management from offshore India.
• Resource manager for the project team of 20 members.
• Utilizing trouble shooting skills to solve complex and major production support issues.
• Implemented solution internal time tracking solution in APEX.
• Gathering status in daily calls (Onsite Offshore Model), leveraging earned value technique to measure overall status.
• Working on enhancements effort estimation Oracle Projects, Service Contracts, General Ledger, Account Payables, AP Supplier Discoverer Report, HRMS Alerts, Building Interfaces for OM, and Form Personalization in HRMS.
• Developing technical design for enhancements Discoverer Report, HRMS Alerts, OM Interfaces and Form Personalization.
• Leading technical team in implementing the enhancement, break fixes and functional testing.
• Ensuring proper code migration, documentation and supporting post go live issues.
• Accomplished company goal by implementing CMMI Level 3 Certification for this project.

Confidential

ERP Lead

• Lead the Technology Assessment and understanding the requirements and contribution to project plan and effort estimation. This is a major project involving data integration to blackberry devices from Oracle Service Requests and service contracts data.
• Implemented complex Pl/SQL package changes involving service request data retrieval and representing in XML tags that will be readable format in black berry devices.
• Implemented Item categories conversion program,
• Ensuring proper code migration, documentation and supporting post go live issues.
• End to end testing service request creation to exporting the data into blackberry devises.

Confidential

ERP Lead

• Analyzing the requirements on data conversion updates on HRMS, AP, PO and Customers, Inventory, Order Management, Oracle Projects updates, Service request tasks updates, Service Contracts customer information update.
• Implementing the extension in iStore to Order Updates using istore hook package.
• Ensuring proper code migration, documentation and supporting post go live issues.
• End to end testing of functional flow.

Confidential

Project Manager and Technic Lead

• This project involving multi Org Changes on all the customizations existing in the system.
• Gap analysis identifying the effected components in RICE objects,
• Leading technical team in implementing all the customer object changes.
• Regression testing all the objects effected due to MULTI org changes.
• Gathering status in daily calls (Onsite Offshore Model), leveraging earned value technique to measure overall status.
• Ensuring proper code migration, documentation and supporting post go live issues.

Confidential

ERP Technical Lead Hyderabad, India

• Product Support for Confidential issues for customers Hologic, Sigsauer, and Siemens.
• Building production support fixes and releasing the fixes.
• Interaction with FEDEX and UPS for any API issues.
• Documenting issues in troubleshoot document.
• Ensuring proper code migration, documentation and supporting post go live issues.