PROFESSIONAL SUMMARY:

• 7+ years of techno - functional experience supporting, implementing and customizing Oracle ERP applications like OM, INV, Purchasing, WIP, BOM.
• Hands on experience of complete Order to Cash & Procure to Pay process.
• Good knowledge of Oracle Planning module like Demantra, ASCP.
• Worked in Conversion tools like Back office Cranport for Financial Data conversion.
• Basic knowledge in Finance AR/AP/GL modules.
• Extensive knowledge in Supply chain management.
• Knowledge in using Oracle Applications foundation: System Administration (Users, Responsibilities, Menus, Functions), Profiles, Concurrent Programs and Executables.
• Experience with Flex fields - Key Flex fields, Descriptive Flex fields.
• Experience in Data conversion and data loading through QTP.
• Created test scripts, business process flows, and conducted multiple testing cycles.
• Experience of entire software development life cycle including Requirement gathering, Analysis, Design, Development, Testing, Implementation and Support.
• Created User Requirement specifications, functional documents, UATs, STS.
• Extensive experience with Business Analysis, design, Business Process Management and Business Development, customizations and implementation of Oracle application Solutions.
• Extensive experience in understanding and providing Gap and Fit analysis
• Strong documentation, analysis, requirement skills and good interpersonal and communication skills to work with clients and team members.
• Bachelor in Technology with major in Electrical Engineering.

SKILLS AND TOOLS:

Modules: Order Management, Inventory, Purchasing, Bill Of Materials, Work In Process, Warehouse Management System, Demantra, Backoffice, Advanced Supply chain Planning, Mobile Supply Chain Application, Configure to Order, Inventory Planning process, Receivables, Payables.

Testing: HP Quality Centre

ERP: Oracle Applications 11i, R12, Supply chain Management.

Database: Oracle

Programming: SQL,PL/SQL, C, C++

Operating System: Windows, Linux/UNIX

Tools: PL/SQL Developer, Quick Test Professional, MS Visio, PVCS Version Manager, Clarify, WinScp, Putty, Oracle Forms and Reports 6i, MS Office, Toad, SQL Developer

PROJECT EXPERIENCE:

Confidential

SCM Track Lead, Schenectady

Responsibilities:

• Main responsibility Business and Development Requirements Study, System Analysis, Technical Design, Development, Testing, and Documentation,, Understanding Business requirements, Preparing the documents, Designing, developing and testing the RICE component, Preparing the Unit test case document
• Impact analysis in current business process, functional mapping, prototyping, gap analysis.
• Conducted requirements gathering workshops.
• Involved in Analysis, Design and Development and Unit Testing of Interfaces
• Involved in Analysis, Design and Development and Unit Testing of Reports.
• Worked with Oracle Support regarding various issues and bugs appeared during development.
• Worked fit gap analysis of the report to fit into tableau, Endeca
• Monitoring critical issue progress to avoid SLA violations and customer escalations
• Provided Training & Conducted Practice & Additional Business Requirements sessions.
• Created design & technical documents, UAT scripts and other deliverables.
• Involved in Unit testing execution for each business process and end to end integration testing.

Environment: Oracle apps, Tableau Reports, Windows.

Confidential

Onsite Project Manager, New York City

Responsibilities:

• Impact analysis in current business process, functional mapping, prototyping, gap analysis.
• Conducted requirements gathering workshops at the Distribution centers.
• Led the design and development work.
• Analyzing user needs, conferring with users to improve procedures and identifying and solving problems.
• Coordinating with the different sources like Demandware, Jet reportings, Navision systems.
• Worked with end users regarding various issues and bugs appeared during development.
• Provided Training & Conducted Practice & Additional Business Requirements sessions.
• Performed daily reconciliations for inventory, sales orders, purchase orders, GRNs, ASNs and published dashboards for the same.
• Prepared daily issued item list and worked on the analysis.
• Created design & technical documents, UAT scripts and other deliverables.
• Involved in Unit testing execution for each business process and end to end integration testing.

Environment: Microsoft NAV, Jet Reporting

Confidential

Onsite Project Manager, Houston

Responsibilities:

• Impact analysis in current business process, functional mapping, prototyping, gap analysis.
• Conducted requirements gathering workshops.
• Led the design and development of the Nucleus tool.
• Analyzing user needs, conferring with users to improve procedures and identifying and solving problems.
• Coordinating with the different sources like Oracle, Esms, SMF and integration via Informatica.
• Worked with Oracle Support regarding various issues and bugs appeared during development.
• Provided Training & Conducted Practice & Additional Business Requirements sessions.
• Created design & technical documents, UAT scripts and other deliverables.
• Involved in Unit testing execution for each business process and end to end integration testing.
• Will be providing post go-live support.

Environment: Oracle apps, Informatica, Tableau Reports, Java, Linux, Windows.

Confidential

VCP Onsite Lead, Waukesha, WI

Responsibilities:

• Impact analysis in current business process, functional mapping, prototyping, gap analysis.
• Conducted requirements gathering workshops.
• Led the design and development of Demand Management and Sales & Operations Planning solutions.
• Demantra Business Modeler configuration like Series & Level setup, user security, workflow & methods, integration Interface, component setup.
• Demantra Worksheets creation for different aggregations level, Worksheet with Calendar view, publishing forecast to ASCP.
• Sales Force integration to Demantra for forecast calculation.
• Standard Collections customization to bring data to Demantra based on business requirements.
• Standard ASCP collections & plan run to get a view of supply and demand of product families & project items.
• Provided Demantra sales and operation process demo and trained Sales/Product/supply team by mapping their current process to Various worksheets in Demantra.
• Analyzing user needs, conferring with users to improve procedures and identifying and solving problems.
• Worked with Oracle Support regarding various issues and bugs appeared during development.
• Provided Training & Conducted Practice & Additional Business Requirements sessions.
• Created design & technical documents, UAT scripts and other deliverables.
• Involved in Unit testing execution for each business process and end to end integration testing.
• Provided post go-live support.

Environment: Demantra (7.3.1.4), ASCP (R12), Linux, Windows, Oracle INV, OM, PO.

Confidential

VCP Offshore Lead

Responsibilities:

• Impact analysis in current business process, functional mapping, prototyping, gap analysis.
• Conducted requirements gathering workshops.
• Led the design and development of Demand Management and Sales & Operations Planning solutions.
• Demantra Business Modeler configuration like Series & Level setup, user security, workflow & methods, integration Interface, component setup.
• Demantra Worksheets creation for different aggregations level, Worksheet with Calendar view, publishing forecast to ASCP.
• Sales Force integration to Demantra for forecast calculation.
• Standard Collections customization to bring data to Demantra based on business requirements.
• Standard ASCP collections & plan run to get a view of supply and demand of product families & project items.
• Provided Demantra sales and operation process demo and trained Sales/Product/supply team by mapping their current process to Various worksheets in Demantra.
• Analyzing user needs, conferring with users to improve procedures and identifying and solving problems.
• Worked with Oracle Support regarding various issues and bugs appeared during development.
• Provided Training & Conducted Practice & Additional Business Requirements sessions.
• Created design & technical documents, UAT scripts and other deliverables.
• Involved in Unit testing execution for each business process and end to end integration testing.
• Provided post go-live support.

Environment: Demantra (7.3.1.4), ASCP (R12), Linux, Windows, Oracle INV, OM, PO.

Confidential

Oracle Functional Consultant

Responsibilities:

• Study of Current business processes, future business flow & identification of gap to provide an integrated information system solution to meet the business change to the company.
• Analysis of Customer Facing Documents & scenarios, functional documents related to OTR.
• Assisting in developing and testing software applications.
• Create/update functional MD documents
• Reviewing the User Requirement specification document
• Unit Testing for all implemented modules (PO, INV,AP,AR, OM,PA & FA)
• Coordinating with shared service teams to complete the regression testing.
• Setups to keep integrated custom components and to flow data between various modules as required.
• Provided Training & Conducted Practice & Additional Business Requirements sessions
• Supported production environments and users on a daily basis by responding to emergency requests

Environment: PO, INV, OM, AR, AP, Oracle e Business 11i, Oracle PL/SQL, Windows, Sun Solaris

Confidential

Conversion Lead

Responsibilities:

• Preparation of technical documents.
• Setups of Finance and Sourcing modules
• Setting up the conversion strategy and configuring the Back-office as per the requirement
• Unit testing through Oracle and Cransoft.
• Creating and Updating of the Functional & Technical documentations
• Perform conversion dry runs & Coordinate with business users for testing.
• Track conversion activities and Object migrations.
• Development/Enhancement of custom pl/sql packages
• Testing of end to end oracle standard cycles
• Technical documentation of all the changes
• Conversion objects development.
• Tracking of conversion activities.
• Performing data mapping and data quality check
• Performing conversion dry runs
• Unit Testing for all implemented modules (PO, INV,AP,AR, OM,PA & FA)
• Tracking of all the logged issues and resolving them on priority basis.
• Finding standard bugs and following up with oracle to resolve standard issue through SRs.
• Coordinating with shared service teams to complete the regression testing.
• Setups to keep integrated custom components and to flow data between various modules as required.

Environment: Oracle eBusiness R12, Oracle PL/SQL, Backoffice Cranport, Windows, Quality Centre, Oracle Inventory, Customer Maintenance

Confidential

Oracle Finance Consultant

Responsibilities:

• Fit Gap Analysis of the current business process.
• Worked on the Proof of Concepts of the new Flow model business and service interim business for various scenarios.
• Handling design and testing of development components in coordination with the Development Team.
• Worked with the Legacy team to map the source data into Oracle for the conversion activity.
• Provided Training & Conducted Practice & Additional Business Requirements sessions
• Carrying out Users Acceptance Test (UAT), go-live activities and Post implementation support.
• Finding standard bugs and following up with oracle to resolve standard issue through SRs.
• Coordinating with shared service teams to complete the regression testing.
• Setups to keep integrated custom components and to flow data between various modules as required.
• Worked on various critical issues along with Oracle Corporation to ensure resolution.

Environment: Oracle eBusiness R12, AP, AR, Inventory, PO, Oracle PL/SQL, Windows XP, UNIX

Confidential

Oracle SCM Consultant

Responsibilities:

• Analysis of as-is process for the EMEA Devices Business.
• Gap Analysis of the current business process with respect to the user requirement.
• Working on the Proof of Concept of the new enhanced design in devices business.
• Drafting user requirement specifications and UAT (User Acceptance Test) scripts
• Handling the design and testing of development components in coordination with the Development Team.
• Setups in Oracle for the following modules - Inventory (INV), Order management (OM), Purchase order (PO), Warehouse management system (WMS), Account Payable (AP).
• Conversion - Item Conversion, Item creation Conversion, item update Conversion, On hand Conversion, item category Conversion, Sales order Conversion, Consignment Conversion, RMA Conversion, Purchase Order Conversion, Price list Conversion, Customer Conversion, Cost Conversion. These conversions are basically done from a custom form except Consignment Conversion and Cost Conversion.
• Quality Center - Creation of Test Scripts in the respective project folder like UAT (User acceptance testing), STS (System Test Script), UTS (Unit Test Script). All Test Scripts are kept in the Test Plan, Clubbing of scripts in the Test Set, Scripts are mapped in the Test Lab. Testers raise defects
• Conducting user training sessions to get the functional team up to speed on the Oracle environment.
• Worked with the business users along with the team during black out and Go-live ensuring a smooth go-live.
• Drafting the User Requirement specification document.
• Drafted the customization document.
• Trained users on the new design.
• Gave support to the business users during the three testing cycles prior to go-live
• Provided post production support on various issues.
• Closely work with business end users which help in smooth business execution.

Environment: Oracle eBusiness Suit 11i, PO, OM, INV, WMS, Mobile Supply Chain Application, Oracle PL/SQL, FEMC, TC/TA, Windows XP, UNIX.