Principal Consultant Resume
SUMMARY
- Core competency in Demand Planning, Advance Supply Chain Planning, Collaborative Planning.
- 7.4 years of total experience in all phases of design, development and implementation of Oracle Value Chain Planning modules and Oracle Apps manufacturing Module.
- Implementation and Support knowledge in Oracle VCP (Value Chain Planning Applications: ASCP, CP) and Oracle Demantra (DM, SOP) and other supporting modules Inventory, Bill of Materials, Work in Process, Order Management, Purchasing.
- Troubleshooting and solving the production issues.
- Strong Experience in Oracle Application technology tools like SQL * plus, Toad, SQL Developer
- Experience in Programming Using SQL,PL/SQL
- Strong interpersonal skills, highly adept at diplomatically facilitating discussions and negotiations with Client.
- Experience working with agile software development using Scrum and experience in leading a team and playing the role as Scrum Master/Tech Lead.
- Expert at driving the agile culture and implementation of Scrum rules, removing impediments and encouraging self - management.
- Experienced in overcoming organizational challenges of transitioning to agile methodology from traditional project management and development.
TECHNICAL SKILLS
ASCP: Standard Collection, Continuous Collection, Refreshing Snapshots, MBP Input & Output Files, Item setups, Sourcing rules, Defining - Enabling - Disabling Responsibilities, Plan Output, Plan Backup, Plan Options, Profile options and tuning database for improved performance
Demantra: Demantra Collections, Statistical Models, Bayesian Forecasting, Aggregation, Levels, Series, Workflows, Worksheets, New Product Introduction (Cannibalization), Causal Factors, EBS Integration.
Collaborative Planning: Understanding on Horizontal and Vertical View. Supply commits and Order forecast load. Setups and collections of CP.
Integration: Integrating Demantra DM with ASCP and Demantra DM with ASCP and CP.
Inventory: Organization Setups, Item Setups, Inventory Planning. Inventory Transactions, Move Orders, On Hand - Cycle Count and reservations
BOM: Where-used, Indented, Setups for Planning & WIP, BOM Comparison
WIP: WIP Job Creation, Move Transactions, Resource Charging.
Order Management: Sales Order Creation, O2C cycle, Shipping, OM workflow, Different stages of Order line and order header.
Purchasing: Setups, different type PO, Requisitions, RFQ’s creation, Receipts and Receiving.
PROFESSIONAL EXPERIENCE
Confidential
Principal consultant
Responsibilities:
- Sizing the Hardware with Oracle
- Followed Agile methodology
- Taken Scrum calls to see team progress and time take to implement each functionality
- Creation of parallel hierarchy in data model
- Wrote custom Demantra collection
- Setups in business modeller
- Writing MD50 with Confidential business consultants
- Guiding team in setups like forecast tree, engine setups
- Worked on integration interfaces, workflows, worksheets
- Demo to client for each Demantra functionality
Confidential
Team Lead
Responsibilities:
- Worked on Purchasing module
- Decks creation on ASCP and Demantra for bidding
Confidential
Senior Consultant
Responsibilities:
- Demantra Collabora tor Workbench, Demand Planner, Business Modeller, Integration Interface, Workflow Management and Engine Administration.
- Performing monthly data loads and statistical forecast generation.
- Deliverables include: Enhancing and Configuring Demantra 7.3.x as per requirements.
- Collaborator Workbench to develop a Waterfall Analysis of actual vs. forecast demand to determine prior period forecast baselines and variances.
- Designed custom workflows to import/export data from legacy and ASCP module.
- Creating Worksheets and Series (Server/Client Expressions) as per requirements.
- Reports (excel sheet) for exporting heavy data from Demantra.
- Preparing Functional Design documents (MD050’s)
- Handling issues on worksheet performance.
- Providing functional support from ASCP perspective in terms of analyzing the Plan run.
- Simulating the customer environment and business processes in a local instance for testing in terms of setting up ASCP module.
- Working on Demand and supply recommendations in client environment and thereby providing process related inputs to the development team.
- Testing of various ASCP scenarios in terms of launching the Plan, and analyzing the ASCP plan output.
- Ensure smooth running of VCP scheduler jobs which comprises of programs from all implemented VCP modules.
- Interact with business to have the issues are updated and resolved to their satisfaction.
Confidential
Software Engineer
Responsibilities:
- Involved in the client meetings to understand the client requirements.
- Preparation of Technical Documents from the functional specifications which are based on the client’s requirements.
- Worked on interfaces and API’s.
- Worked on form development.
- Worked on report development.
- Worked on preparation of unit test Cases.
- Worked on Customization of Order Management Workflow.
- Worked on Scheduling Tool named Appworx.
- Worked on alert.
- Worked on migration Activity to make it Go Alive.
- Developed or customized reports as per project requirement like:
- Pick Confirm Notification Report
- Material Ageing Report
- Developed Sourcing Rule report.
- Customization on WMS Dimension Entry Form.
- Customization on Lineside Request Form.
- Customization on Lineside Approval Form.
- Report for inter organization transfer.
- Report on OSP item processing.