SUMMARY

• Over 10 years of professional experience as Oracle Applications Analyst carried out development on Oracle Applications release 11i/R12.
• Extensive working knowledge in Oracle Supply Chain Planning.
• Being a techno - functional well versed in interacting with process Leads and Business super users.
• Very good experience in onsite-offshore model.
• Sound knowledge at Identify, draft, review and analyze business requirements and perform POC (proof of concepts), AS-IS & TO-BE processes, feasibility studies and gap analysis based on business requirements.
• Map and translate business requirements to design and solutions using Oracle E-business suite and able to document the design, solution in all phases of project.
• Collaborate with functional, tech leads, process architects, PMO, business users, DBA’s and other teams during various stages of project including design, test, development, deployment and production support.
• Ability to help and work closely with various analysts from Demand forecasting, Supply Chain Planning, Sourcing and Procurement departments.
• Perform improvements in business processes, resolve production Incidents, deliver enhancements & seek feedback from customer.
• Experience in Development and Customization of WRICE (Workflows, Reports, Interfaces, Conversions and Extensions).
• Hands on experience on ETL tools like ODI (Oracle Data Integrator).
• Hands on Functional Knowledge on Supply Chain Planning and Procure to Pay flows.
• Experienced in all stages of documentation in the implementation life cycle using Oracle’s AIM.

TECHNICAL SKILLS

Languages: C, PL/SQL, Java

Application Modules: Demantra & Advanced Supply chain planning (ASCP), iSupplier, Order Management (OM), Quotations, General Ledger (GL), Accounts Payables (AP), Purchasing (PO), Inventory (INV), Bill of materials (BOM), ORMS (RETEK).

Software tools: ODI, OAF, XMLP 5.6.2, Forms4.5/6.0/6i, BPEL, Reports 2.5/4.5/6.0/6 i, SQL* Loader.

Core Knowledge: Business Requirement Mapping, Solution Architecting/Module Design & Build, Process Redesign, Business System Testing, Data Conversions, Interfaces.

Process Areas: Supply Chain Planning, Procure to Pay, Inventory Management

Databases: Oracle 8i/9i/10g/11i/12c

PROFESSIONAL EXPERIENCE

Confidential

Project Lead

Environment: Oracle Applications R12 - ASCP, Demantra, S/W: Oracle RDBMS 11g, Oracle Forms/Reports (10G), PL/SQL, TOAD, Oracle R12.2.4 Applications Object Library, XMLP, SQL * Loader, UNIX, shell scripting.

Responsibilities:

• Implemented Constraints based Value Chain Planning.
• Modeled Oracle ASCP from various source systems including oracle e-business suite, JDE, Mfg*Pro, Mainframes and other legacy systems.
• Extensively used ODI (Oracle Data Integrator) for data transformations into Oracle.
• Has worked on AIA PIP - integration of JDE with E-business suite for value chain planning.
• Worked on Oracle 12.2.4 upgrade for ASCP - Modeling premium capacities, Warehouse capacity requirements, Multi Sourcing and Time phased capacities planning.
• Extensively worked on Standard Collections from Oracle EBS and Legacy collections from other ERP’s.
• Designed and customized the way Oracle Publishes make/move/transfer orders from planner’s workbench.
• Has worked on scheduling daily and weekly jobs from Control M.
• Plan, prioritize and coordinated R12.2.4 installation/upgrade activities.
• Implemented project plans, managed daily activities, regular communication ensuring quality of deliverables and adherence to compliance standards.
• Performed and supervised configurations of Oracle ASCP and Demantra applications.
• Lead team members and work product delivery both on-site/offshore.
• Identifies critical path decisions, makes recommendations/influences leaders/business process owners.
• Involved in system testing, performance optimization and systems Analysis.
• Conducted requirement gathering, conference room pilot and user acceptance testing sessions.
• Provided technical solutions to business problems by identifying needs and requirements and development of the appropriate technical solution.
• Provided developing estimates on software design, development and testing activities.
• Assisted in diagnosing and troubleshooting performance issues and executing production changes.

Confidential

Senior Systems Analyst

Environment: Oracle Applications R12 - ASCP, Demantra, INV, BOM, WIP, AP, PO, iSupplier S/W: Oracle RDBMS 11g, Oracle Forms/Reports (10G), PL/SQL, TOAD, Oracle R12.1.3 Applications Object Library, XMLP, SQL * Loader, UNIX, shell scripting.

Responsibilities:

• Participated in VCP Value Chain Planning Implementation.
• Designed and developed Integration Import & Export interfaces in and out of Demantra.
• Designed and developed custom interfaces to trigger Demantra workflows from EBS.
• Configured data model and created custom series for various imports in Demantra.
• Designed custom solution for Product Cannibalization, new items and replacement items data load into Demantra.
• Hands on experience with Demantra server & client expressions.
• Performed Initial data load into Demantra.
• Designed a custom solution to export ASCP, DRP plan results to excel.
• Participated in ASCP unconstrained implementation.
• Developed AS-IS and TO-BE process flows to implement iSupplier portal.
• Participated in workshops to evaluate the feasibility of implementing VMI (vendor managed Inventory), Supplier scheduling and various custom P2P solutions.
• Designed and Implemented Consignment Inventory within Oracle Purchasing.
• Developed functional designs and technical designs to implement Prospective vendor registration with Oracle iSupplier portal.
• Proposed a custom cost group update solution for Oracle WMS where traditional sub inventory transfer was not working internally.
• Designed and developed end to end PO receiving interface to integrate Oracle receiving with AS400, Also used 3rd party schedulers like AUTOSYS.
• Customized Oracle MSCA screens within Oracle Purchasing.
• Have worked on Extending Oracle VO objects using JDeveloper.
• Responsible for end to end implementation of Oracle iSupplier portal including user requirements gathering.
• Built custom OAF pages to upload files from oracle screens to server locations.
• Responsible for preparing, reviewing MD70, MD120, TE40 and review check lists.
• Participated in implementing oracle WMS (Ware house Management MSCA).
• Responsible for design and development of the different kinds of RICEW components in EBS12i.
• Participated in Oracle R12 upgrade.
• Prepared System, Integration tests Scripts. Also involved in documenting Impact Analysis.
• Wrote test cases for Oracle code and Performed UAT testing.
• Converted standard RDF reports to XMLP reports for more user-friendly access the data
• Created complex validation units based on Value Sets and list of values (LOV).
• Extensively utilized the Application Object Library (AOL) to register SQL*Loader programs, Shell Scripts, PL/SQL procedures, Forms and reports.
• Trained end Users conducted KT meetings and performed Demos for various objects in delivery life cycle.

Confidential, KY

Senior Applications Developer

Environment: Oracle Applications R12 - ASO, OM, TCA and Oracle APEX.

Responsibilities:

• Responsible for design and development of the different kinds of interfaces between R12 and oracle store.
• Used OM and TCA API’s extensively to develop the interfaces.
• Developed custom tables and PL/SQL packages and used integrating R12 and Oracle Store.
• Maintain the production environment by enhancing and fixing the bugs on existing one.

Confidential, Libertyville, IL

Lead Consultant

Environment: Oracle Applications R12 - ASO, OM S/W: Oracle RDBMS 10g, Oracle Forms/Reports (v6i), PL/SQL, TOAD, Oracle R12 Applications Object Library, XMLP, SQL * Loader, UNIX, shell scripting.

Responsibilities:

• Responsible for design and development of the different kinds of RICEW components in EBS12i.
• Developed Vastera Integration system to check customer RPL status. (Restricted party list). Used utl http packages, TCA business events to communicate with Web services.
• Designed and Developed Sales Order Import process with XML data source.
• Designed and Developed ASO Quotations Interface using standard oracle API’s with XML data source.
• Conducted training sessions for the team to understand the Requirements and Performance requirements of the system.
• Involved in code reviews, standard performance and functional reviews.

Confidential, Harrisburg, PA

Team Lead - Senior Consultant

Environment: Oracle Applications R12 - GL, AP, PO, HRMS and FA S/W: Oracle RDBMS 9.x, 8.1.x, Oracle Forms/Reports (v6i), PL/SQL, TOAD, Oracle R12 Applications Object Library, XMLP, SQL * Loader, Oracle Retail UNIX, shell scripting.

Responsibilities:

• Involved in integrating Oracle EBS with Oracle Retail.
• Involved in requirements analysis, design and implementation of Requisition Account Generator work flow for various requisition types with different destination types.
• Involved in writing MD70, CV60, MD120 and TE40.
• Involved in CAR (Casual analysis and resolution), DAR analysis (Decision analysis and resolution).
• Sales Order Import Interface (OM).
• ASO Quotations Import Interface using ASO QUOTE PUB API.
• Involved in Purchase Orders conversion into Oracle Retail without using RIB objects.
• Involved in developing outbound interface GL Commitment balances to SAP and generating outbound XML data file with BPEL.
• Developed Invoice Check printing report as per PLCB check format by customizing the existing Standard Oracle Java Concurrent Program.
• Performed End to End testing while delivering Procure to pay cycle during UAT across the modules AP, PO.
• Developed inbound invoice Interface to process invoices generated in Legacy System.
• Customize the existing Requisition account generator workflow to populate the expense, budget, variance accounts as per the business requirements.
• Designed and developed the report for requisitions requiring board approval report that is report on requisitions waiting for the approval at seventh level in the hierarchy.
• Developed Supplier update program to update the supplier attributes both at header and site level.
• Designed and developed Complex interfaces like Payments Inbound in Oracle Accounts Payable by writing custom API and integrated it with the legacy system.
• Customized the existing Purchase order in ORMS (RETEK) as per the business requirements and scheduled through APPWORX.
• Used sales order API (OE ORDER PUB) to update the order attributes whenever there is an update to the sales order in legacy system.
• Developed PL/SQL collections to integrate OE ORDER PUB API with legacy system using custom BPEL process.
• Designed and developed complex label report using RDF and suggested the client to use bar code software from outside vendors (IDAutomation).
• Designed/Developed (RETEK) the feasible solution “how to print bin labels during peak sales and festive seasons”. Extensively used PL/SQL triggers and Oracle D2K to implement this solution.

Confidential, Pittsburgh, PA.

Consultant

Environment: Oracle Applications R12 - GL, AP, PO, HRMS and FA S/W: Oracle RDBMS 9.x, 8.1.x, Oracle Forms/Reports (v6i), PL/SQL, TOAD, Oracle R12 Applications Object Library, XMLP, SQL * Loader UNIX, shell scripting.

Responsibilities:

• Team member of development team, involved in customizations/personalization of various reports in Oracle modules like AP, PO, FA and HRMS.
• Successfully conducted CRP1 and CRP2 during project assessment.
• Analyzing the complexity of reports based in Functional specifications.
• Distributing the work among team members based on the skill and efforts required.
• Trained End Users also involved in conducting KT meetings.
• Involved in configuring complex products.
• Preparing, reviewing MD70, MD120, TE40 and review check lists.
• Involved in migrating the objects between instances by generating LDT scripts using FNDLOADER.
• Co-coordinating with Oracle Product support for TARs.
• Used XMLP extensively for developing different kinds of reports.
• Developed Multi-Lingual reports using Oracle XML Publisher 5.6.2.
• Involved in migrating Data definitions, template definitions and physical .RTF files between the various instances.
• Designed and developed land and building report in Fixed Assets module.
• Developed report on Employee Contact information in HRMS.
• Worked on the report which captures the daily changes of HR decisions.
• Involved in developing a report which displays supplier header, line and contact details.
• Involved in developing MD70s and also experienced in writing CV40, TE40
• Involved in defining Unit of measures in Inventory.
• Extensively developed Technical specs (MD70s).
• Created and Customized PL/SQL APIs to import data into custom tables from various base tables.

Confidential

On-site coordinator & Consultant

Environment: Oracle 11i (11.5.6, 11.5.8, 11.5.9, 11.5.10) - INV, BOM, WIP, ASCP, AP, PO S/W: Oracle RDBMS 9.x, 8.1.x, UNIX, shell scripting, Oracle Forms/Reports (v6i), PL/SQL, TOAD, Oracle 11i Applications Object Library, SQL * Loader, Oracle Advanced Supply Chain Planning.

Responsibilities:

• Worked as on-site co-coordinator and SPOC for ASCP plan run support.
• Setup and execution of constrained and unconstrained plans.
• Super user of planning and manufacturing.
• Monitoring and support of ASCP Plan runs.
• Debugging and troubleshooting the problem in Plan runs.
• Making changes to plan as required by functional users.
• Solving and providing assistance to day to day issue of planning and manufacturing modules.
• Logging bugs and tars. Providing information to product support and product development and getting the issues resolved.
• Scheduling and monitoring of various jobs before and after the plan runs.
• Working on performance problems of various programs.
• Changing profile options and values.
• Providing functional assistance in understand functionality of specific module.
• Weekly updates on plan run status and schedules and discussion on progress of various bugs and issue. Advising on precaution during month and quarter end closing.
• Client communication in multi-vendor environment.
• Worked in solution centre, developing/customizing production objects based on clients requirement.
• Worked on developing a custom program to update item attributes at ODS.
• Worked on item categories conversion based on external legacy data to Oracle EBS.
• Developed a report to display the sales order validation after data collection.

Confidential

Developer

Environment: Oracle APPS 11.5.10, UNIX, shell scripting, Windows NT, Oracle 8i, Reports 6i, Forms 6i, TOAD, SQL*Loader, PL/SQL, SQL* Plus, XMLP, INV, BOM, PO, WIP, Kintana, Clear Case.

Responsibilities:

• Involved in preparing the Technical Specifications from the Functional Specifications.
• PO ASL Conversion.
• Item Import, Category Import and Item category assignments.
• BOM (Bill of Materials) Import.
• Developed a report on items on hazard classes.
• Designed and developed a report on cancelled lines with PO details where such PO has receipts made against any of lines.
• Used Mercury Kintana for Code Migration.
• Developed Report on cancelled lines with PO details where such PO has receipts made against any of the lines.
• Item demand histories conversion.
• Report on UN used items not transacted and not used in any PO after Cutoff date.

Confidential

Developer

Environment: Oracle APPS 11.5.7, Sun Solaris Unix, Window NT, Oracle 8i, Reports 6i,Forms 6i, Discoverer, TOAD, SQL*Loader, PL/SQL, SQL* Plus, Advanced Pricing, Purchasing, General Ledger, Field Assets, Order Management, Inventory and Cash Management.

Responsibilities:

• Involved in Inventory conversion of legacy data into Oracle Applications using PL/SQL packages and Shell Scripts. SQL * Loader was used to load data into custom tables.
• Developed PL /SQL packages, procedures and functions for interface programs to validate the data for the following modules: General Ledger, Order Management, and Inventory.
• Designed and developed custom reports in Inventory, Purchasing, and General Ledger.
• Involved in conversion of legacy Purchase orders in to Purchasing.
• Involved in converting Purchase order attachments to Oracle EBS from legacy systems.
• Involved in developing an inbound interface which processes item transactions.
• Involved in Converting Supplier Quotations from Legacy to Oracle EBS.
• Worked on item conversion on Inventory modules.
• Developed PL/SQL Packages, Procedures, and Functions for validating the invoices and payment information from the legacy system and imported into Oracle Application using the Payables Open Interface Import program and populated into the Base Tables that involved Approval of invoices and creating of New Invoices.