PROFESSIONAL SUMMARY:

• Functional Business Systems Analyst with over 15 years of experience in project management, systems analysis, solution design and deployment using Oracle ERP and other custom applications.
• Strong domain knowledge and understanding of business processes in supply chain and finance business areas.
• More than 6 years of experience in value chain planning using Demantra and advanced supply chain planning (ASCP) modules.
• Acted as the primary business engagement contact in Planning and Order management/fulfilment functions and lead projects from conception through deployment using standard Project management methodology.
• Worked extensively in Order Management, Shipping, Inventory, BOM, Costing, Demantra and Advanced Supply Chain planning (value chain planning) modules.
• Multiple implementations experience in Order to Cash (O2C) cycle with Order management, Account Receivables, and Inventory modules
• Also supported and has working knowledge of other financial modules such as Payables, General Ledger, Fixed Assets and Purchasing.
• Implementation Experience with Oracle AIM Implementation Methodology with expertise in preparation of Requirements (RD, BR), functional (MD), Testing (TE) and conversion (CV) documents.
• Expert in technical aspects also with the knowledge in SQL, PL/SQL and other aspects of Life cycle development (SDLC). Working knowledge also in business objects, Informatica and OBIEE
• Ability to multi - task and comfortable working in a fast paced environment with excellent communication skills

TECHNICAL SKILLS:

ERP: Oracle Applications R12, 11i, 11.03 and 10.7

Databases, tools: Oracle, PL/SQL, SQL*Loader, SQL*Plus, Unix

Planning: Demantra ASCP

Office tools: Microsoft Excel, Word, Power Point, Projects, Visio

Data Warehouse: Informatica, Business Objects, Oracle OBIEE

WORK EXPERIENCE:

Business Systems Analyst

Confidential

Responsibilities:

• Currently working as Operations Business Systems Analyst supporting Order Management(OM), Shipping (Scheduling, ATP), Planning (Demantra and ASCP) and Ops finance(costing) business areas.
• Acted as liaison between business and development for implementation and enhancements to IT systems. Typical activities include project management, requirements gathering (BRD), analysis, solution design (FSD), business walkthroughs, dev coordination, Testing (IT, Integration and User acceptance testing) coordination and migration to production.
• Involved in the implementation of Demantra and Advanced Supply Chain Planning(ASCP) modules for statistical forecasting, Global order promising(GOP), collaborative demand planning and production planning(MPS generation) in contract manufacturer environment.
• Worked on a tuning project to improve forecast accuracy using Demantra AFDM module.
• Implemented Available to promise, Global Order promising (GOP) and MRP using ASCP.
• Involved in Implementation of consignment based fulfilment model with Vendor managed Inventory (VMI) using oracle, eVMI and B2B messaging.
• Also implemented custom applications like CM BOM application to manage excess and obsolescence Inventory
• Implemented a custom solution for Subscription based billing for BNS products using OM, Fixed Assets, Pricing and Receivables modules.
• Another home grown application implemented is for cost control and forecasting in contract manufacturer model. This has touch points with inventory, BOM, MRP areas.
• Implemented Project and portfolio management tool (PPM) Planisware for NPI(new product initiative) and corp program management
• Currently implementing Total Product cost data warehouse analytical reporting solution to identify period cost in addition to product cost at business unit level.
• Also completed Demantra upgrade from 7.2.1 to 7.3.1

IT Support Lead

Confidential

Responsibilities:

• Responsible for production support for all the financial (AR, AP, GL, FA, OM, PO) modules of Oracle.
• Also responsible for the execution of user enhancement requests.
• Responsible for Requirements analysis, Functional specifications document generation, Testing with users and production deployment.
• Working with development team for the specifications and completing the development.
• Implemented several enhancements in iprocurement and ipayment workflow approval processes

Functional Implementation Consultant

Confidential

Responsibilities:

• Involved in the implementation of Order Management and Account Receivables modules for the new company acquired by JDSU. I was also responsible to assess tax and legal implications of the merger and implement a suitable solution. Used vertex for tax rates and implemented complex VAT requirement for UK.
• Used AIM methodology and responsible for preparing functional requirements, mapping, process and Gap documents like RD050, BR010, BR080 and BR030 etc and getting the business approval.
• Based on the business inputs configured the system for CRP validation and prepared BR100 Setup documents for OM and Receivables.
• Was also instrumental to streamline the Order to Cash process for Internal Sales order Processing. Oracle AIM methodology is followed for the implementation with multiple CRP validations before go live.
• Later executed global rollout for UK and Germany and I was involved in AP, AR implementation

Functional Team Lead

Confidential

Responsibilities:

• Confidential is Geneva based bio - tech leader in Infertility and dermatology drugs. They have one global instance support all the financial and supply chain operations of all the countries
• Responsible for the implementation of Order management, Account receivables, Cash Management, Inventory and Advanced pricing modules to support 3PL distributor in the consumption based billing model. I was also responsible for the functional testing and validation of various custom processes like corporate intransit, and revenue reporting.
• Implemented the corporate In-transit functionality for Intercompany account transfer of material.
• Co-ordination with development team for custom Order Import, Outbound Picking extract, Inbound Warehouse Adjustments and Ship confirm APIs

Data Warehouse Analyst & Developer

Confidential

Responsibilities:

• Worked as On-site Analyst and developer for Confidential sourcing Data Marts. SSP5 is one of the major instances and there are constant roll-outs/acquisitions in this instance as new operating units will be added to SSP5 constantly. Also responsible to bring data from all those new operating units and converting them to GEPS standard Accounts for consolidated reporting. Used Informatica and Decision Point applications for ETL and Business Objects for reporting.

Techno-Functional Support Lead

Confidential

Responsibilities:

• Acted as onsite coordinator and responsible for day to day production support activities AR, AP and GL modules. Responsible for requirements gathering, design, working with offshore development (3 developers), testing with users and deployment.

Developer

Confidential

Responsibilities:

• Specifically involved building customer interfaces, reports in Account payables and Purchasing modules. Developed an interface between Procurement card system and Account payables module. I was also responsible for developing an interface between EDI PO and Invoice auto match project.

Techno-Functional Team Member

Confidential

Responsibilities:

• Specifically responsible for the implementation of the Accounts Receivables and tech support for all the financial modules. Also responsible for developing of an Interface with a Real Estate System (REMS), a legacy system used by the client. Invoice was imported using the Auto Invoice, Receipts through Auto Lock Box and customer Interface.

Techno-Functional Team Member

Confidential

Responsibilities:

• I was responsible, as a team member for bespoke development of a module to address the India Specific Taxation Issues, which are not provided as standard Oracle Applications Functionality. This module interacts with OE, Inventory and AR modules. I was also responsible for the production support of Order Entry, Receivables and Inventory modules.