Career Summary:

• Over 8 years of Supply Chain experience including 6 years of experience as functional consultant in SAP Advance Planning Optimizer (APO), Production Planning (SAP R/3-PP) & Process Industries((SAP R/3-PP/PI) and Two years as Planning Engineer at KHAS Pvt. Limited.
• MS Supply Chain, Bradley University and have in-depth experience to analyze, map and improve entire Supply Chain, to reduce total cycle time, bring down cost, improve productivity.
• Expert level understanding of various Project Management tools including MS Project, MS VISIO, Affinity Diagram , Process Flow Diagram, Mistake Proofing, Cause & Effect Diagram, Pareto Analysis, PDCA, and other problem solving and quality analysis tools.
• Have a very good knowledge of ASAP methodologies with experience in all phase of project implementation performing Legacy System Data Analysis, Business Blue Print, Realization, Customization, Final Preparation, Go-Live and Post Live Support.
• CIF integration models for transferring the master as well as transactional data including model setup, post processing, and delta report and queue monitors including CIF customization in R/3 and APO systems, Data replication, creation and activation of integration model, Master data transfer and delta transfers and monitoring of queues. Data mapping and legacy system data transfer.
• Extensive experience of Administrative Workbench Setup APO BW source system, info source, Info areas, Info cubes, Info Source. Uploaded master and transactional data from Flat files, SAP R/3, SAP BW and Legacy Systems. Also performed data transfers between ECC, APO, BW and Live Cache.
• Participate in end user Training and Testing, defining Test Cases, performing End-To-End Testing as well as defining functional specifications for interfaces
• Knowledge and understanding of APO 7.0 enhancements

SAP APO Expertise:
Demand Planning: Configuration of Master Planning Object Structures, Generating & Changing Characteristic Value Combinations (CVC), Planning Books, Planning Areas, Macros, Statistical Forecasts, Batch Jobs/Planning Jobs, Back Ground Mass Processing, Time Bucket Profile, Forecast Profile, Planning Version, Security Profiles, Promotional Planning, Life Cycle Management, Like Modeling.

Supply Network Planning: Creation of SNP Heuristic & Optimization Profiles, SNP Heuristic and Optimization run, Capacity constraining in SNP, Capable To Match(CTM), PPM in SNP Planning, rough cut Capacity Planning, Deployment and Transportation Load Builder (TLB).

Global-Available-To-Promise: Configuration of ATP Groups, Check Instructions for Product Check, Forecast Check, Allocation Check, Check Modes, Business Events, Product Substitution, Rule Based ATP Check and Product Allocation for GATP.

Production planning & Detailed Scheduling: PP/DS Planning runs, Heuristics, Optimizers, Detailed Scheduling Planning Board, reporting data, setup matrix, Model Mix Planning, and converting SNP order to PP/DS, PP/DS Profile, and Master Data integration via CIF with R/3.

R/3 PP-PP/PI: Expertise in configuring, creating and maintaining Materials, BOMs, Super BOM, Work Centers, Resources, Routings, Master Recipe, Production Version, Batch Management, Sop, Demand Management, MRP, Process Order, Production Order, Order Execution, Pi Sheet , Capacity Planning, Scheduling, Availability Check, Material Staging, Back Flushing And Variant Configuration.

PROFESSIONAL EXPERIENCE

Client: Confidential,St Louis, MO Jan 2011-to-Date

Role: Team Lead APO DP- SNP

Environment: SCM 5.0, BI 7.0, ECC 6.0

• Business Requirement Gathering for Forecast & Availability Project (Vegetable Business). Interact with business directly to MAP their current processes and to identify and resolve GAPS.
• Analyzed and finalized AS-IS/TO-Be process via client discussions and carried out gap analysis.
• Develop flow charts to finalize various integrated processes and to finalize the process flow across various functional teams.
• Setup APO BW objects like Source System, Info Area, Info Source and Info Cubes.
• Setup Info cubes to loaded historical data from BW including info package, Transformation Rules and Data Transfer Process. Setup Process chain to carryout the above process.
• Created ABC Quality Rating from Flat File data source, Package, Transformation Rule and Data Transfer Process to load to DP Info cube and setup of Process chain to load to Planning Area.
• Prepare DP Design Documents for Vegetable Business based on Business requirement Document.
• Configured Master Planning Object Structure, Planning Area, Demand Planning Book, and Macros in the interactive Demand Planning. Sales Order and shipment History data is loaded to cube and use the same for creating CVCs and define various macros to calculate forecast.
• Created number of Macros to calculate Carryover Forecast, Forward Consumption remaining, Locked Operational Forecast, Locked Forecast with Lead time and other key figures calculations.
• Created various Data Views for Sales Person, Manager Locked Forecast, and Operation Locked Forecast.
• Setup the release of Demand plan to ECC.
• Setup process chain to generate CVCs and to load data to planning area.
• Setup Process Chain to backup the DP data to BW info cube to further upload to global BW for reporting.
• Defined Business requirements for Safety Stock Planning.
• Setup Planning area and Book for Safety Stock. Set up the DP planning area with the Location/Product characteristics/info objects.
• Setup macros to calculate Target Stock, Net Safety Stock, calculated inventory and calculated shortage.
• Release net safety Stock value to SNP
• Set up a process chain to capture and perform all the above mentioned steps.
• CTM planning run to identify the suitable production window and generate planned orders which includes regular forecast requirement and safety stock requirements.
• Setup CTM profiles, master data selection and variants.
• Analyzed Core Interface (CIF) and redefine jobs and variant for all active Integration Models.
• Functional Design Specifications for executing various Event Trigger job to update Data Source and Tables.
• Created End to End test scenarios for UAT including sample Data and instructions for Business users.
• Face to Face support during actual UAT sessions.
• Functional Design for Global Demand Allocation Report, Carryover Report, Supply Demand Balance Report and various BEx reports, testing strategies and sample data for user testing.

Client: Confidential,Atlanta, GA Sep 2010-to-Dec 2010

Role: DP-SNP-GATP

Environment: Upgrade SCM 4.1 to SCM 7.0

• Analyzed, Documented current processes and gathered Business requirements.
• Worked with the Project Manager and team to define steps required for Preparation, pre-work and post upgrade follow-up activities.
• Define test case scenarios, scenario variants and Test scripts for GATP, Product allocation, alerts, SNP and VMI.
• Maintenance of Demand Planning Book, Master Planning Object Structure, Planning Area and Macros in the interactive Demand Planning. Sales Order and shipment History data is loaded to cube and use the same for creating CVCs and define various macros to calculate forecast.
• Analyzed Core Interface (CIF) and redefine jobs and variant for all active Integration Models.
• Defined univariate profile based on adjusted shipping history and defined activity and job to release the forecast.
• Defined various Macros to calculate Final Forecast, Forecast Balance, adjusting shipping history.
• Execute test scenarios and documented the results.
• Troubleshoot issues and documented the solution.

Client: Confidential,Houston, TX May 2009-to-July 2010

Role: Team Lead APO DP SNP-CTM

Environment: SCM 5.0, BI 7.0, ECC 6.0

• Analyzed the current business process (AS-IS) of the clients Supply Chain system, carried out Gap Analysis and finalized To-Be process after conducting interview with the client focus group
• Face to Face meeting with client to understand and finalize the Business Requirements.
• Followed HP Enhanced Methodology including Opportunity Development, Project Scoping, Analysis, Design, Construction, Test, Implement and Closeout.
• Developed Application Design Document (ADD), Technical Design Specification (TDS).
• Analyzed the client organizational structure such as Regions, Divisions, Products, Customer and Plants for planning purpose in DP.
• Aligned APO BW Source System, Info Area, Info Source and Info Cubes to accommodate Product line split.
• Alignment of Data Flow through Global DP to Regional DP and Regional SNP and vice versa.
• Setup of Demand Planning Book, Master Planning Object Structure, Planning Area and Macros in the interactive Demand Planning
• Assigned users to Planning Book and created selection IDs to ensure data propagation across entire HP landscape including APJ, EMEA, and North America.
• Maintenance and alignment of Characteristic Value Combinations, Forecast Profile and Data Views.
• HP is using Univariate Time Series Forecasting method with Trend analysis. Maintained Statistical Forecast Profiles and various Data Views as per business blueprint.
• Setup the release of Demand plan to ECC.
• Setup Process Chain to backup the DP data to BW infocube to further upload to global BW for reporting.
• HP is using SNP Heuristic and CTM for Monthly and weekly planning respectively.
• Setup Basic Supply Chain Components such as Product / Location Combination, Resource, PPM, and Transportation Lane.
• Modification of Resource and PPM master data in APO to meet PAN HP requirements.
• Conversion of the PP/DS PPMs to SNP PPMs to accommodate all resources naming convention and parameters setup.
• Setup Supply chain parameters such as Maximum Earliness, Production Horizon, Volume Quotas, and Capacity Consumption Rate.
• CTM Setup at HP consider Demand element, Product Location priority, PPM, capacity and yield (YACC process). Setup detailed planning book to identify dropped demand and violation to acceptable range and setup of Capacity Planning Book to identify violation of acceptable utilization ranges.
• Developed CTM Profile based on Technology specific supply chain to facilitate parallel planning in APO and included in Batch Job.
• Setup Supply Chain Linear Flow and Set up Process Details to help business understand the process.
• Analyzed existing Core Interface (CIF) Integration models and developed new models for Location, Vendor, Material, Resource and PPM as per business requirement.
• Developed CIF Product Master and PPM USER EXITs to cater the product requirement of populating some fixed values in APO master data.
• Team lead for global APO System Integration Testing (SIT) and lead for User Acceptance Testing (UAT) during End-to-End functional testing.
• Developed Test case scenarios for System Integration testing (SIT) and End to End Testing.
• Developed PowerPoint presentation and carried out User Training as per plan for smooth handover.

Client: Confidential, June 2007-to-March 2009

Role: AP APO Consultant (DP-SNP-PP/DS) Full Life Cycle Implementation

Environment: SCM 5.0, BI 7.0, ECC 6.0

Responsibilities:

• Involved in various phases of ASAP methodology-preparation, business blue print, realization, Design, testing, customization & final preparation, go-live and post live support.
• Analyzed and finalized AS-IS/TO-Be process via client discussions and carried out gap analysis.
• Prepared test cases and Demand Planning of various scenarios with alerts.
• Specified data requirements and communicated the same across business process owners.
• CIF Integration Model for transfer of master data & Transactional data b/w APO & ECC.
• Created Master Planning Object Structure, Planning Area, Planning Book, Characteristic Value Combinations, Time Series Objects and Macros for interactive Planning. Maintained Forecast Profile and Data Views.
• Maintenance Storage Bucket and Time Bucket Profiles.
• Assigned users to Planning Book.
• Performed Life Cycle Planning through Like Profile, Phase-In and Phase-Out Profile.
• Develop transfer rules and update rules for Object Data Structure (ODS) and Info Cubes.
• Setup APO BW objects like Source System, Info Area, Info Source and Info Cubes.
• Loaded historical data from BW.
• Performed SNP Planning Area Administration with Planning Object Structure, SAP standard Planning Areas and Data Views.
• SNP Master Profiles and configured SNP Master Data Location, Product Master, Resources, Transportation Lane, Quota Arrangement & Production Process Model.
• Create products for vendor and Customer Locations, creation of storage, Transport Resources, maintained locations.
• Defined SNP Planning Profiles, SNP Lot Size Profile, SNP Demand Profile, SNP Supply Profile, Demand Profile, Deployment Profile, and SNP Rounding Profile.
• Setup SNP Planning Book and Data Views and created Selection Profiles for product and Resource selections.
• Created SNP Optimization Profile, SNP Cost Profile and setup Quota arrangement for the use in SNP Heuristic.
• Performed SNP run using SNP Heuristic, Capacity Leveling, Deployment and Transport Load Builder (TLB) run
• Setup the release of Demand Plan to SNP; and release of SNP plan to DP after SNP Heuristic run.
• Integration of SNP and PP/DS.
• Interactive planning setup in PP/DS.
• Creation of PP/DS product master views, lot sizes, production horizon etc.
• Period-Oriented planning in the product planning table.
• Configuration of PP/DS propagation range, strategy profile, Heuristic profile, DS planning board
• Develop Supply Chain Model/Engineer (SCE), Work Area and various objects in Work Area and setup of Alert Monitor.
• Maintained SNP Deployment Optimization Profile to run Deployment Optimization.
• Maintained TLB profile to run TLB and assigned to Transportation Lanes.
• Participate in end user training and testing, defining test cases, performing end-to-end testing, as well as defining functional specifications for interfaces
• Trained Demand Planners and developed training documents for the end users, knowledge transfers through training and resolve end user issues.

Client: Confidential,Lakeland, FL Oct 2006- to-May 2007

Role: SAP APO Consultant (DP-GATP) Full Life Cycle Implementation

Environment: SCM 5.0, BI 7.0, ECC 6.0

Confidential,is the nation\'s leading supplier of shelf stable "good for you" beverages. The Juice Bowl product line includes fortified 100% juices, juice drinks and iced tea.

Responsibilities:

• Analyzed the current business process (AS-IS) of the clients Supply Chain system, carried out Gap Analysis and finalized To-Be process after conducting interview with the client focus group
• Analyzed the client organizational structure such as Regions, Divisions, Products, Customer and Plants for planning purpose in DP.
• Setup APO BW Source System, Info Area, Info Source and Info Cubes.
• Maintenance of Storage Bucket and Time Bucket Profiles.
• Setup of Demand Planning Book, Master Planning Object Structure, Planning Area and Macros in the interactive Demand Planning
• Assigned users to Planning Book.
• Maintained Characteristic Value Combinations, Forecast Profile and Data Views.
• JBC is using Univariate Time Series Forecasting method with Seasonal and Seasonal Trend analysis. Maintained Statistical Forecast Profiles and various Data Views as per business blueprint.
• Loaded historical data from BW.
• Setup the release of Demand plan to ECC
• Configured the overall GATP setting in APO.
• Rule based ATP customization with Location & Product Substitution.
• Updated product master to accommodate strategy type according to rule bases substitution.
• Complete configuration of Backorder Processing, Product Allocation and Rule Based ATP Check, Transport and Vehicles Scheduling done by creating scenarios using sales order from ECC.
• Defined Access Sequence, Condition Tables, Condition Types, Maintained and Assigned Rule Strategies.
• Maintained Allocation Quantities for all the customers (sold to party) in the Planning Book, used a Macro to define the default allocation quantities and cumulative allocation quantities.
• Configuration of back order processing including setting of Filter Types, Sort Profiles and assignment and generation of the same.
• Trouble shooting configuration issues in GATP and integration to ECC.
• CIF Integration Model for transfer of Master Data & Transactional Data.
• Implemented the functionality of Hard and Soft Allocation (to allow customers to order in variation to allocation quantities.)
• Involved in the Unit testing and Integration Testing, defining test cases, performing end-to-end testing, as well as defining functional specifications for interfaces.
• Developed training documents for the end users, knowledge transfers through training and resolve end user issues.

Client: Confidential,Export, PA Dec 2005- to-July 2006

Role: SAP APO Consultant (DP-SNP-PP/DS)

Environment: SCM 4.1, BW 3.5, ECC 5.0

Confidential,is the world\'s leading provider of flexible stainless steel connectors for natural/LP gas and fluid conveyance applications. Dormont also designs and manufactures interior gas and fluid conveyance assemblies for major applianceOEMs.

Responsibilities:

• Configured and maintained Master Planning Object Structure (MPOS), Planning Area administration including time bucket and Storage Bucket Profile, disaggregation.
• Design and setting of Planning Book and time series for DP
• Maintained Characteristic Value Combinations, Forecast Profile and Data Views.
• Setup Macro for various applications as per specification from the Demand planner, maintenance Storage Bucket and time bucket Profiles.
• Modeled Univariate Forecast Profile, Life Cycle Planning, Phase-In, and Phase Out and Back Ground Planning.
• Developed transfer rules for Info Source & update rules for professional data Source and Info Cubes. Loading historical data from BW Info Cubes, testing data upload.
• CIF integration model for transfer of master data & Transactional data.
• Created transfer Profile, Planning job and scheduling jobs.
• Maintain Planning calendar, setup master Profile, Supply Chain Master Data, mass maintenance of product parameters.
• Created product for vendor and customer locations, creation of storage, transport Resources, maintaining locations.
• Setup of Supply Chain Models/Engineer (SCE), Work Area and various objects in Work Area with all relevant Locations, Resources, Transportation Lanes and relationships.
• Perform SNP runs using SNP Heuristic, Optimizer, creating transportation lane, maintain Quota Arrangements, Quota Items, Planning versions.
• Setup of CTM Prototype Model for key products.
• Setup Deployment heuristic and created Deployment Optimization Profile.
• Created and assign TLB Profile to Transportation lane, configuration of Core Data Interface (CIF & Integration Models)
• Responsible for checking the integration of master data from SNP to PP/DS.
• Maintained PP/DS master data, Production planning procedures and defined conversion of SNP orders to PP/DS.
• Setup strategy profile, source determination and procurement quantity calculations.
• Provided support and troubleshooting the configuration issues in PP/DS.
• Unit and integration testing and created training document for PP/DS.

Client: Confidential,Monee, Illinois May 2005- to-Oct 2005

Role: SAP PP Functional Consultant

Environment: SAP R/3 4.6C

Confidential,rotary actuators, linear thrusters, rod less cylinders, flow controls and position-sensing cylinders. Bimba also provides a number of related products, Flow controls Switches Valves Transition plates Alignment couplers Air-to-air boosters Low-Profile switches Air reservoirs

Responsibilities:

• Performed AS-IS/TO-BE Study with core team members and presented reports after completing GAP Analysis
• Conducted workshops with Business users ranging from Production Schedulers, Manufacturing Managers, Procurement Managers, Finance Head, et al to gather requirements for Business Blueprint documentation
• Created a custom template for Business Blueprint documentation and captured the process in Visio flow diagrams
• Prepared documentation describing step-by-step implementation process and configuration procedures for business processes. Developed Flow Chart documentations including different Business Scenarios
• Interacted with core team members and plant managers to perform Gap analysis based on As-Is study reports
• Configured & Created new Material Master and Bill Of Materials (BOMs), Routing and Work Center for the old and new equipments in large volume Discrete Manufacturing environment to support process requirements.
• Maintained work scheduling, MRP and Forecasting views in material master.
• Configured the Planning strategies Planning With Final Assembly and Planning Without Final Assembly/Make To Stock
• Involved in configuring & defining Work Break Schedule, Shifts and Breaks.
• Extensively worked on Production Order Creation, Release, Availability Check, and Confirmation of orders, Automatic Goods Receipt and Goods Issue displaying Capacity load, and Capacity Leveling.
• Created the planned orders by using planned tables and sequences
• Configured graphic Profiles for Capacity Planning/Leveling in Repetitive Manufacturing
• Created new evaluation and Leveling Profiles for MRP and Shop floor control in Capacity Requirement Planning, Variant Configuration, Data Migration LSMW
• Production order creation, release and confirmation and back-flushing, shop floor papers printing with user defined layouts
• Configured collective Availability Check for production orders.
• Production completion confirmations are simplified and are made with reference to the material being produced.
• Responsible for design, documentation and implementation of Forecasting and MRP Planning.
• Trained the users on process flow stock/requirements list, converting of planned orders into production orders, creating manual stock transport orders and to use various movement types for different purposes

Sr. Planning Engineer

Confidential, Jan 2003- to –Dec 20004

Responsibilities:

• Review Sales Forecast and Safety stock requirements after discussion with marketing and Sales and facilitate ERP planning process.
• Develop Master Production Plan and Procurement Plan by converting Demand Plan including marketing forecast and Safety stock planning, while optimizing the utilization of inventories and operational resources.
• Work closely with Manager Production to ensure production requirements can be met and negotiate adjustments to production schedule if needed.
• Analyze KHAS Supply Chain and Leaded Continuous Improvement program and teams in Planning and carrying out process improvements; reviewing and making recommendations for manufacturing process improvements; and actively working to improve plant performance and efficiency
• Project Manager for implementation of computerized maintenance management system (CMMS) D7i from DataStream (Infosys) and Project coordinator for implementation of computerized maintenance management system (CMMS) D7i and implementation team member for PeopleSoft Asset Management module (client Side).

Education:
MS (Industrial Engineering) with focus on Supply Chain Management
BE (Mechanical Engineering)
Certified Auditor for ISO

Technical Skills:
Application Packages: SAP SCM 5.0, SCM 4.1, SCM 4.0, APO 3.1, ECC 6.0, ECC 5.0, SAP R/3 4.7, SAP R/3 4.6C, BI 7.0, BW 3.5, BW 3.0
Programming Languages: Visual Basic, C, C++, FORTRAN, dBase III+
MS Packages: MS Project, MS Excel, power point, Access, Outlook, Word, MS Visio
Operating Systems: Windows 95/98/2000/NT, UNIX, MS DOS