PROFESSIONAL EXPERIENCE

Confidential

SQL and PL\SQL

Responsibilities:

• Understanding the existing customizations in 3 divisions around MFG / SCM modules.
• Defining the future process flows and BP080 preparation.
• Co - coordinating with 3 divisions and making the best practices in the processes.
• Analyze the AS-IS process and preparing detailed To-be process documents.
• Responsible to get signoff from 3 divisions on BP080s.
• CEMLI analysis and impact analysis in R12 and suggested the improvements by using R12 new functionalities in SCM / MFG business areas.
• Demonstrated R12 new functionalities - Buyer work center,Change tolerances in Procurement area,IR/ISO change management,Fixed component usage,Item simulation set and Gantt chart functionalities in ASCP.
• Understanding the existing pain areas and suggesting the improvements by using R12 new functionalities.
• Working with Oracle on SRs for Standard issues and co-ordination between Oracle and users.
• Test case preparation and business sign off on test cases.
• Co-coordinating the weekly status call with business and Genpact team.
• Managing the deliverables in Topteam and ALM tools for future tracking.
• Worked on POC for using the Landed cost management with Oracle purchasing and also demonstrated the functionalities as per business requirements.

Confidential

ERP Oracle MFG & Planning Business Analyst

Responsibilities:

• Interacted with business users, Application specialist, business owners for the MFG open issues.
• Interacted with external application owners for the legacy feeder’s related issues.
• Worked on all MFG and ASCP related issues that users face on daily basis.
• Working on month end close process for MFG and Inventory modules.
• Supporting custom processes around MFG modules.
• Worked with Oracle on SRs for Standard issues and co-ordination between Oracle and users.
• Worked on Setup changes and follow RFC process to migrate changes from Dev to PROD instance.
• Co-ordinated with change management team to migrate data fixes from Dev to PROD instance.
• Execution of critical test scripts for all business units using planning solutions, identify the issues and resolve them whenever patches are applied.
• Taking KTs for recent customizations/migrations/ implementations.
• Follow up with support team for the open issues and responsible to take the open issues to the closer status.
• Worked on business critical issues related to Standard Cost update customizations, Sourcing Utility and match configuration customizations.
• Worked on critical issue related to IR/ISO cycle which was generating the infinite transfer price due to customization in advanced pricing.
• Worked on custom Routing update program to migrate routing information based on the business needs.
• Worked on custom match functionality for ATO configured item creation.
• Demonstrated the ATP functionality to end users for complete understanding.
• Resolved critical issue which was restricting the bill deletion for creating the common bills.
• Worked on hard pegging issues related to Project MFG environment in ASCP.
• End user training on ASCP, BOM, WIP, ENG & Inventory modules.
• Weekly status meeting with support managers
• Co-coordinating relationship charter call.

Confidential

ERP Oracle MFG and Planning Lead

Responsibilities:

• Involved in gathering requirements from business users, application specialists and business owners for Purchasing, iProcurement, ENG,BOM, WIP,Inventory,APC & ASCP modules.
• Prepared AS-IS process and finalized detailed To-be process documents.
• Design doc preparation for all customizations.
• Got trained on Rapid ESuite tool and trained the users on the same.
• Rapid file preparation and injection into different instances and worked closely with Rapid team for injection issue resolution.
• Worked on ASCP profile options accommodation in migrating the ASCP setups from single instance to the instance where number of business division are already up and running.
• Co-ordinated with DBAs for patch analysis / applications and ASCP activities during data migration from one instance to other instance.
• Worked with technical team on data conversions in SCM / MFG areas.
• Worked on the interfaces among Oracle EBS, ASCP and other non-oracle systems and ensure they are running well as intended.
• Worked on the custom legacy collections from non-oracle systems to ASCP.
• Instance planning activities.
• Conducting Conference Room Pilots and support got SIT and UAT.
• Demonstration of R12 functionalities to business users.
• Conducting conference calls among all the business divisions to make sure our division setups are not impacting others.
• Verification of all custom interfaces once migration is done by technical team.
• Cutover plan preparation for PRODUCTION instance.
• Working with Oracle through SRs for Standard functionality issues.
• Finalize the data load error handling strategy documents and closely interacted with technical team for the development.
• Follow up with users to closet the SIT, UAT open issues and get it sign off.
• Cutover communication with different teams on the status of each activity.
• Prepared detailed training documents and conducted end user trainings for the real time data load files.
• Post go live support.
• Worked on the POC for PLM engineering tool to Oracle EBS applications integrations.

Confidential

ERP Oracle Functional Consultant

Responsibilities:

• Understand existing business process across all the 3 different business units Identify impact on any of the existing processes due to migration to R12 in SCM and planning area.
• Analyze custom business processes and explore new standard Oracle functionality Understand Impact of in-flight projects or project in pipeline.
• Demonstration of new R12 functionalities, which ever are possible in permissible time in key functional tracks, on Wipro’s R12 instance.
• Solution Design and Implementation of New features in PO & iSupplier and ASCP modules.
• Test case preparation for SCM modules (ASCP,Purchasing, iSupplier modules).
• Implemented 11i EBS integration with R12 ASCP instance which reduced the time during the production cut over.
• Implemented Advanced Pricing security in R12 as per business requirements.
• Implemented Advanced Pricing for Purchasing module and also populated the price based on the system date by using the custom pricing hook.
• Implemented Promise date vs need by date consideration by ASCP for creating Purchase orders from Planned orders in ASCP.
• Worked on natural time fence for firm planned orders as per business requirements.
• Worked buyer work center page personalization for hiding the unwanted tabs and fields are per business requirements.
• Resolved the issues related to Outside processing in WIP module.
• Worked with Oracle on period end reconciliation issue in inventory module.
• Demonstrated Accrual reconciliation process in R12 as the process changed completely in R12.
• Co-coordinating with Oracle to resolve R12 standard functionalities.
• Configuration of the application in all the environments such as System Testing, System Integration Testing, User Acceptance Testing and testing support.
• Preparation of User Training Materials for new functionalities and Post production support.
• Participated in Weekly Status calls
• Preparation of cutover plan and communication on each activity completion with all the stake holders.
• Patch analysis and tracking of the patches.
• Post go live support.
• Worked on POC and demonstrated the Rapid planning functionalities to ITRM business users.

Confidential

ERP Oracle Functional Consultant Lead

Responsibilities:

• Impact analysis of changes, patches to the existing functionality.
• Developed sql scripts to verify the data once the clone is completed and making sure everything is ready for testing the functionalities.
• Automated the manual monitoring process to monitor the planning requests and send notification mails to intended recipients for failures.
• Document setup changes that are required post upgrade to R12 VCP
• Execution of critical test scripts for all business units using planning solutions, identify the issues and resolve them.
• Testing of all Custom requests, Reports and Programs post upgrade to R12 and identify the issues for RICE remediation.
• Participate in weekly status calls and discuss the status of each issue logged for VCP modules.
• Created SRs with Oracle on standard functionality issues.

Confidential

Oracle Applications Functional Consultant

Responsibilities:

• Responsible for successful completion of Data collections and Plans daily within SLA in Production environment for NA and Europe.
• Perform the necessary steps as per support framework, such as resolving functional tickets, performance issues, setups, end-to end testing, patch analysis, migration and Root Cause Analysis.
• Manage approximately 12 ASCP instances as well as 14-15 OLTP instances.
• Collaborated with Product Support and Dev in converting some of their requirements to Bugs and Enhancements while providing resolution to requested requirements.
• Automated the manual monitoring process to monitor the planning requests and send notification mails to intended recipients for failures for Dev instances.
• Patch analysis and patch testing.
• prepared test cases for the testing.
• Co-ordinated with Oracle on SRs and status update to business on weekly basis.

Confidential

Oracle Applications Consultant

Responsibilities:

• Business requirements on the data extraction of customers, Price list information,Sales Orders information.
• Setting up the master setups in Order Management, Shipping & Advanced Pricing modules.
• Test case preparation for Order Management,Shipping & Advanced Pricing modules.
• Data verification post conversions.
• Responsible for testing various functionalities of all the applications which are interacting with IFOCUS once the changes are done.
• Responsible for keeping the updated test cases into QC once testing is over.
• Worked on Order Import,IRISO,Back to Back Order and dropship cycles.
• Cutover sheet preparation for Production go live.
• Post go live support for Order Management, Shipping & Advanced Pricing modules.

Confidential

Oracle Functional consultant.

Responsibilities:

• As a Team Member, I have worked on all purchasing related issues like POs, receipts & requisitions maintenance and issues related with them.
• I had worked on creating SQL and PL/SQL scripts for generating reports from module related tables to be given to the clients according to the requirements and also have worked on automating some frequently required reports through concurrent programs.
• Responsible for handling business critical issues.
• Suggested and implemented process improvement which has reduced many tickets and manual efforts for ERS transactions.
• Modified existing interfaces based on business requirement.
• Worked on Requestor Vs Preparer hierarchy customization related to workflows.
• Developed functional test cases for testing GE Business customizations and Interfaces
• Assisted the Development and Implementation teams by performing Root Cause Analysis on failed tests to identify and resolve the problem areas.
• Able to customize reports using Oracle Report Developer 6i and also familiar with Oracle Workflow customization.
• Implemented direct hierarchy for EUR business unit
• Defining Document series pertaining to Inventory & Purchasing module
• Definition & problem identification for creation of Item master.
• Developed Outbound interface to send PO and Receipts information to 3rd Party AP system.
• Period closing support for Inventory module.
• Lead the team of 10 people.
• Communicating and coordinating with the client/users regularly.