SUMMARY:

• Over 13 years of professional experience as Oracle Applications Consultant 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.
• Implemented project plans, managed daily activities, regular communication ensuring quality of deliverables and adherence to compliance standards.
• Performed and supervised configurations of Inventory, Purchasing, and 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.
• Experience in Development and Customization of WRICE (Workflows, Reports, Interfaces, Conversions and Extensions).
• Hands on experience on ETL tools like ODI (Oracle Data Integrator).
• Configuration and Implementation of OBIA (OBIEE foundation) 11.1.7.1
• 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), Warehouse Management (WMS), Quotations, General Ledger (GL), Accounts Payables (AP), Purchasing (PO), Inventory (INV), Bill of materials (BOM), ORMS (RETEK).

Software tools: OBIEE, OBIA, ODI, AIA PIP, OAF, XMLP 5.6.2, Forms4.5/6.0/6i, BPEL, Reports 2.5/4.5/6.0/6 i, SQL* Loader and UPK

Core Knowledge: Business Requirement Mapping, Solution Architecting/ModuleDesign & 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

WORK EXPERIENCE:

Confidential

Solution Architect Oracle EBS

Environment: Oracle Applications R12

Responsibilities:

• 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.
• Performed configuration and setups for Single tier collaborative planning
• Owned end to end ASCP solution and support supply chain business partners with training and trouble shooting.
• Worked on WMS, OM implementation. Designed and developed drop ship process. Trained end users on IR/ISO process using ASCP.
• Extensively worked on WebADI for various data imports into oracle applications.
• Designed and developed order import, pricelist upload and blankets upload using WebADI.
• Responsible for ASCP roll out. Worked on un-constrained ASCP roll out along with Collaborative Planning.
• Working on AS-IS and TO-BE process for unconstrained VCP Implementation
• Worked on Procure to Pay Implementation along with iSupplier portal, prospective vendor registration and approval using AME.
• Worked in Install, configure OBIA for Procurement and Spend Analytics.
• Provided functional and technical support to OBIEE. Performed ETL work using ODI.
• Lead team members and work product delivery both on-site/offshore.
• 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.

Senior Analyst - VCP

Environment: Oracle Applications R12.2.4 ASCP, Demantra

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.

Senior Systems Analyst ERP Systems

Environment: Oracle Applications R12

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 OA Framework 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.

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.

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.

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 (ID Automation).
• 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.

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.

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 center, developing/customizing production objects based on client’s 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