EXPERTISE SUMMARY:

• Over 20 plus years’ experience with Oracle Cloud Demand, Supply Planning, Oracle Value Chain Planning Applications - Performing Techno Functional work within the Oracle Demantra, Advanced Supply Chain Planning, Oracle Sales and Operation Planning, Oracle Planning Central, Demand Management Cloud
• Effectively involved inRequirement gathering, analyzing business requirements, System Mapping, Conference Room Pilot and Postproduction support.
• Experienced in both technical as well as functional aspects of ERP solutions implementation of Oracle Applications.
• Have sound knowledge of OIC related to planning modules and Oracle Inventory Cloud Modules
• Ability to work independently with minimal supervision to meet deadlines.
• Expertise in the Oracle implementation cycle including Requirement’s analysis, solution design, data migration, testing, trouble shooting, implementation, roll out.
• Good understanding of Business flow and conversion of business process into Oracle functionalities.
• Having very good knowledge in Preparing of different Documents by usingOracle Applications Implementation Methodology (AIM), Oracle Unified Methodology (OUM)
• Hands on experience on User Documentation, training for end users, post implementation support.

TECHNICAL SKILLS:

Oracle ERP Modules: Oracle Cloud Planning Central, Oracle ASCP, Oracle Demantra 7.3/ 7.2, Sales and Operation Planning, Oracle Demand Management Cloud, Oracle Inventory Cloud, Order Management Cloud, Oracle Purchasing Cloud

PROFESSIONAL EXPERIENCE:

Confidential, Irvine, California

Modules: Demantra 12.2.6 Implementation, Planning Central Cloud, Demand

Sr. SCM Lead

Responsibilities:

• Implementing Cloud Planning in WD, currently assessment is in progress for Implementation
• Lead Implementer for Oracle Demand Planning and Supply planning across all legacy subs to achieve common demand planning and supply planning
• Was responsible for the QA defects raised by users in JIRA tool and get it fixed by development team
• Was responsible for the development and support all the Functional and Technical objects at client place
• Involved in discussion for solutions as a part of Technical Architecture
• Importing several custom measures forecast data to demand planning cloud using Oracle Integration Cloud methodology (FTBI)
• Review and approval of change requests, solutions, designs, configurations, process flows and other documentations requested by all vendors and internal teams working on various projects.
• Communicating with multiple vendors and internal teams working on various implementations and maintaining synchronization between the projects.
• Analyzing requirements and recommending solutions based on knowledge of Oracle software capabilities and Supply Chain best practices.
• Working on design and validation of new solutions and modifications to existing solutions
• Mentoring team members and Subject Matter Experts (SME) on Oracle functionality
• Develop specifications and lead design of scalable solutions to business requirements as well as interfaces to approved 3rd Party software
• Develop specifications and lead design of common dashboard metrics (KPI) of business performance information to drive timely decisions
• Perform process governance and oversight for the Oracle environment and design
• Establish guidelines and a process to develop SMEs throughout the global business
• Validated collections for receiving master data and historical data from EBS
• Prepared the Functional Design Documents, test plan documents and created User Manuals to provide training to the client and other guides for the company knowledge archive
• Worked extensively with DBA and technical team for performance tuning of the Demantra system at the database level for overall improved performance
• Worked on the configuration using all tools of Demantra package like Business Modeler, Demand Planner, BLE, Collaborator Workbench, Forecast Engine on AIX and Workflow Manager
• Good Documentation skills with experience in creating functional documents including Requirements Traceability Matrix, Functional Design documents, Process Flows, Test Scenarios and Scripts, Configuration sheets
• Support OBIEE and Tableau related requirements from business
• Providing post-production support after Go-Live
• Providing comprehensive training Materials and practice exercises.

Confidential, San Jose, California

Modules: Demantra 7.3.1.4 Implementation

Demantra Lead / SCM Lead

Responsibilities:

• Was responsible for the development and support all the Functional and Technical objects at client place
• Involved in discussion for solutions design involved in the project
• Leading the Demantra team, on-site and Offshore team
• Supporting Demantra Predictive Trade Planning both functional and technical
• Created standard Functional design and technical design documents
• Was the onsite functional lead, was responsible for taking the project through CRP, SIT, UAT and Go-Live

Confidential, Irvine, California

Planning Lead Consultant

Applications: Oracle Applications R12.0.6

Modules: Oracle ASCP, GOP, Oracle Demand Planning, Oracle Collaborative PlanningMRP Planning, iSupplier

Responsibilities:

• As a Lead consultant, my role was to assist the client by making sure the current existing process is up and running after the R12 upgrade
• Was responsible in documenting the current system process and prepare the AS-IS TE040 which includes all the scenarios and scripts for planning modules.
• Was responsible to make sure the MRP/ASCP flow works correctly.
• Was responsible for new partner on board process from iSupplier to Cisco enterprise.
• Was involved in setting up VMI Supplier facing process for the cisco existing supplier
• Was involved in setting up VMI Customer facing process for the cisco existing customers
• Was involved in making sure all the current customizations are working correctly after R12 upgrade with all the other boundary systems
• Was involved in the Collaborative planning activities with the client
• Was involved in generating the forecast from ODP module to informatica system. This involves the complete ODP cycle.
• Working on the new issues we got after R12 upgrade in ASCP, Collaborative planning, Oracle Demand Planning.

Confidential, California

Sr. Demantra Consultant (Lead Consultant)

Applications: Oracle Applications R12.0.6

Modules: Oracle ASCP, Oracle Demantra7.3, OM

Responsibilities:

• As a Lead consultant, was involved in the implementation of the Demantra Upgrade project from 7.1 to 7.3.0.1 version
• Was responsible for the development and support all the Functional and Technical objects at client place
• Involved in discussion for solutions as a part of Technical Architecture
• Was leading the Demantra technical team
• Worked on the below interfaces for Demantra Project
• Running ASCP Collection
• Creating a Plan
• Worked on Demantra Upgrade from 7.1 to 7.3.0.1
• Worked on Integration interface to load the On hand quantities into Demantra
• Worked on Integration Interface to load customer bases pricelist into Demantra
• Worked on Integration Interface to load Open Sales Orders into Demantra
• Worked on export integration workflow to load the final forecast data into a TXT file
• Worked on flat file load (CSV file) into Demantra, for series baseline forecast at different levels
• Creating cache worksheets for huge worksheets with loads of data in it
• Working on Business Modeler, Member Management process
• Was involved in loading the pricelist into Demantra
• Worked on splitting the EBS Uplaod Local Forecast workflow from Monthly to Weekly buckets into Denorm tables. This is as the custom process and custom workflow.
• Worked on creating new product introduction (NPI) in Demantra

Confidential

Sr. Demantra Consultant (Lead Consultant)

Applications: Oracle Applications R12.0.6

Modules: Oracle ASCP, Oracle Demantra7.2, Oracle S&OP, OM, INV

Responsibilities:

• As a consultant, was involved in the implementation of the Demantra project
• Was responsible for the development and support all the Functional and Technical objects at client place
• Involved in discussion for solutions as a part of Technical Architecture
• Was involved in giving the user training documents
• Was involved in gathering the functional requirement from the users for the development of the tasks.\Worked on Item master updates for planning attributes using Item Import
• Worked on the below custom objects for Demantra Project
• Worked on the enhancement to create custom collection for Collect Shipping and Booking History for some of the sales channels to bring Order Taking Customer into Demantra
• Worked on getting the ASCP Planned Orders into Demantra
• Worked on interfaces to get the Approved PO into Demantra
• Worked on interface to get the On hand quantities into Demantra
• Worked on getting Confirmed PO into Demantra
• Worked on Custom Hook collections (this included Item Hook and Location Hook)
• Worked on integrating salesforce.com to get the opportunities data into Demantra
• Worked on creating new items required to fulfill the SAT Month Report through member management
• Worked on interface to create combinations in mdp matrix and sales data for all items to the sales rep customers
• Created Demantra Workflows, integration profiles for the tolerance and combination creation.
• Worked on Item Master update attributes, Item Import
• Worked in BLE setup and workflows
• Worked on creating new product introduction (NPI) in Demantra

Confidential, California

On-site Manager

Applications: Oracle Applications R12.0.6

Modules: Oracle ASCP, Oracle Demantra7.2, Oracle S&OP, OM, INV

Responsibilities:

• Was involved in the implementation of the Demantra project
• Monitor the Project Management Track Sheet for tracking of timelines and deadlines of the project
• Was involved in mentoring the resources based on the skills
• Involved in conducting weekly status meetings with onsite and offshore team for project progress
• Was responsible for the development and support between off-shore and on-site technical team
• Involved in discussion for solutions as a part of Technical Architecture
• Helping the off-shore team in fitting the requirements for new custom objects that are to be developed in Demantra
• Was involved in giving the user training documents
• Was involved in gathering the functional requirement from the users for the development of the tasks.
• Worked on Creating custom responsibilities based on the responsibility matrix
• Involved in E2E design in the project
• Worked on the below interfaces for Demantra Project
• Worked on Item master updates for planning attributes using Item Import
• Worked on custom Inter org Transfer Interface
• Worked on custom Internal Order and Shipment Process Interface
• Worked on ASCP Supplier Forecast Extract for Monthly and Weekly
• Worked on Projected Inventory $ value report in ASCP
• Worked on Projected Inventory Analysis report in ASCP
• Created Demantra Workflows, integration profiles for the tolerance and combination creation.
• Worked on Projected Inventory Analysis report for Gross Requirement and Planned Orders for 6 months Buckets
• Worked on Zip Code and Regions Interface in WSH REGIONS
• Worked on In transit Shipment interface
• Working on creating Integration Interface for SOP Supply interface
• Working on Lag series Import and Export Integration Interface with custom workflow
• Worked on Audit reports which will run in ERP Side, APS Side and Demantra Side
• Worked on Item Master update attributes, Item Import

Confidential

Offshore Project Manager

Applications: Oracle Applications 11.5.10.2

Modules: CRM Administrator, Oracle Marketing Online.

Responsibilities:

• Monitor the Project Management Track Sheet for tracking of timelines and deadlines of the project
• Involved in conducting weekly status meetings with onsite team for project progress
• Involved in resource planning in Confidential and updating employee skill sets matrix for future projects
• Played a role of Resource Manager
• Involved in discussion for solutions as a part of Technical Architecture
• Estimation of time for the development or customization of new object
• Reviewing the code and documentation.
• Interacting with the team and make sure that development and customization is in the correct shape
• The customization includes the following:
• 4 Reports (Custom Development of New Reports), including XML Publisher Reports
• 3 Forms (Custom Development of New Forms)
• Customizing ebusiness center form
• Interfaces involve:- Event and event schedule creation, event registration creation in oracle marketing online module.
• Involved in giving technical solution for customization in BRM workflow.
• Involved in giving technical solution in shell scripts and list generation programs
• Was involved in Quality related documentations
• As a part of OSI, was involved in taking interviews

Confidential

Project Manager

Front End: Oracle Developer suite (Oracle PL / SQL, Oracle Forms 6i)Back End: Oracle 9i

Applications: Oracle Applications 11.5.10.2

Modules: Tele service, Install base

Responsibilities:

• Monitor the Project Management Track Sheet for tracking of timelines and deadlines of the project
• Involved in conducting weekly status meetings with onsite team for project progress
• Involved in discussion for solutions as a part of Technical Architecture
• Estimation of time for the development or customization of new object
• Involved in resource planning in Confidential and updating employee skill sets matrix for future projects
• Reviewing the code and documentation.
• Interacting with the team and make sure that development and customization is in the correct shape
• The customization includes the following:
• Was involved in giving technical solution for Interfaces:- Service Request Creation, Creation of customers, creation of service charges, creation of install base items

Confidential

Project Lead

Front End: Oracle Developer suite (Oracle PL / SQL), Oracle Workflow

Back End: Oracle 9i

Applications: Oracle Applications 11.5.10.2

Modules: Oracle CRM Administrator

Responsibilities:

• Monitor the Project Management Track Sheet for tracking of timelines and deadlines of the project
• Involved in conducting weekly status meetings with onsite team for project progress
• Involved in discussion for solutions as a part of Technical Architecture
• Estimation of time for the development or customization of new object
• Reviewing the code and documentation.
• Interacting with the team and make sure that development and customization is in the correct shape
• The customization includes the following:
• 1 workflow customization: - The customization involved in giving solution to change the seeded workflow BRM as per client’s requirement.
• Was fully involved in giving technical solution design for the workflow.

Confidential

Sr. Team Lead

Front End: Oracle Developer suite (Oracle PL / SQL, Oracle Reports 6i)Oracle Workflow, Oracle XML Publisher.

Back End: Oracle 9i

Applications: Oracle Applications 11.5.10.2

Modules: GL, AR, AP, PO, OM, Production, OM, Inventory.

Responsibilities:

• Monitor the Project Management Track Sheet for tracking of timelines and deadlines of the project
• Involved in Designing of the reports, Interfaces, Forms, Custom.pll MD070 based on MD050.
• Was involved in preparing CM010 and MD 120 documents for Monthly Release
• Estimation of time for the development or customization of new object
• Reviewing the code and documentation.
• Interacting with the team and make sure that development and customization is in the correct shape

Confidential

Sr. Team Lead

Front End: Oracle Developer suite (Oracle PL / SQL, Oracle Reports 6iOracle Workflow, Oracle Discoverer 4i).

Back End: Oracle 9i

Applications: Oracle Applications 11.5.10.2

Modules: GL, AR, AP, PO, OM, Production, OM, Inventory.

Responsibilities:

• Monitor the Project Management Track Sheet for tracking of timelines and deadlines of the project
• Involved in Designing of the reports MD70 based on MD 50.
• Was involved in CR060 Design Documents
• Was involved in preparing CM010 and MD 120 documents for monthly Release
• Estimation of time for the development or customization of new object
• Reviewing the code and documentation.
• Interacting with the team and make sure that development and customization is in the correct shape
• The customization includes the following:
• Worked on Customer conversion interface using TCA API
• Worked on Supplier and supplier contact conversion interfaces
• 40 Reports (Custom Development of New Reports),
• 3 Forms (Custom Development of New Forms)
• 52 Interfaces which includes OM, PO, Drop ship concepts
• Was involved in giving Training to Oracle Applications Fresher who joined as Junior Analyst in Oracle Apps Technical Team

Confidential

Team Lead

Front End: Oracle Developer suite (Oracle PL / SQL, Oracle Reports 6i, Oracle Workflow, Oracle Discoverer 4i).

Back End: Oracle 10g.

Applications: Oracle Applications 11.5.10.2

Modules: GL, AR, AP, PO, OM, Production, Oracle Manufacturing (BOM, WIP), Inventory.

Responsibilities:

• Monitor the Project Management Track Sheet for tracking of timelines and deadlines of the project
• Involved in Designing of the reports MD70 based on MD 50.
• Was involved in preparing MD 120 documents
• Estimation of time for the development or customization of new object
• Reviewing the code and documentation.
• Interacting with the team and make sure that development and customization is in the correct shape
• The customization includes the following:
• 60 Reports (Custom Development of New Reports),
• 10 Discoverer Reports.
• 6 Forms (Custom Development of New Forms)
• Interfaces which includes Quality Module, Purchasing, Production, OM etc.
• Worked on HR Employee Conversion Interfaces
• Worked on Item import interfaces
• Worked on Customer interface conversion
• Worked on PO, Receipts interface conversion
• Worked on OPM conversions
• Implemented Test Director Tool to track the defects and for MIS reports for Top Management

Confidential

Sr. Analyst

Front End: Oracle Developer suite (Oracle PL / SQL, Oracle Reports 6i, Oracle Workflow).

Back End: Oracle 9i.

Applications: Oracle Applications 11.5.9

Modules: Oracle Manufacturing (BOM, WIP), Inventory.

Responsibilities:

• Involved in Designing of the reports MD70 based on MD 50.
• Was involved in preparing MD 120 documents.
• Involved in Development of Reports, and customization of seeded ASN workflow.
• Involved in migrating existing objects from 11.5.5 to 11.5.10 instance at client place (Tecumseh Balanagar, Hyderabad).
• Involved in creation of Concurrent programs and Value sets.
• Was involved in fixing the issues occurred during the production.
• Worked on Customer conversion API
• Gave Technical Training (Oracle Apps Training) to other practices to get exposure in Oracle Apps.
• Handling a team of 2 as Senior Analyst.