Sanjaya Shrestha
SAP APO DP/SNP/Data Consultant - Nike,
Inc
Alpharetta, GA - Email me on Indeed: indeed.com/r/Sanjaya-Shrestha/4c1e5373c39bc5dd
Strategic thinker with seven years of functional experience in the SAP APO, specifically in Demand Planning
(DP), Supply Network Planning (SNP), Core Interface (CIF) and Production Planning (PP)
WORK EXPERIENCE
SAP APO DP/SNP/Data
Consultant
Nike, Inc - April 2013 to Present
Participated in the Kick-Off meeting for the project to understand the scope such as the capabilities, Business
Areas, Physical Flow, Criteria, Short Lead Time Products, Technical Architecture, and Report of the project
• Worked with Planning Master Data team to setup all the required master data for planning purpose in SNP
to run CTM engine.
• Validated Master data flow such as Material, Sourcing, T-lanes, Quota Arrangements, Resources, Product
location, PPM and so on from the planning data management work-stream to Teradata and finally to the APO
system.
• Worked through the demand planning data flow from the Logility system and non Logility system into
the
APO DP.
• Involved in demand segmentation analysis for multiple demand streams for multiple business lines.
• Worked on the demand distribution profile to provide precise week level demand signal to its downstream
partners to facilitate inventory planning, capacity planning, and material planning at weekly level.
• Validated the multiple demand stream key figures to identify short term demand and futures demand in DP
to SNP release key figures in SNP planning book.
• Validated master data requirements such as PPM, T-lane, Quota Arrangement, Product Location, Resource,
Planning Parameters and CTM profile for planning engine run.
• Involved in validation and reviewing of CIF master data, Teradata, CTM disaggregation results from Factory
to DC and Planned Orders after disaggregation run, CTM profile, Process Chains, SNP Alerts, and Planning
Book Results.
• Reviewed the SNP planning result for short term demand and futures demand, as CTM constrained planning
is performed only for the short lead time demand.
• Monitor batch jobs for DP to SNP Release, CTM run, and Delivery Plan Publish to i2 supply planning as
future demand are being planned in i2 system.
• Checked different reports which help in demand planning such as demand planning and sales order
report, demand volatility, demand plan exception. Also, checked supply planning reports - capacity
utilization,
production and inventory burst report, supply shortage report and ad hoc reports.
• Involved in issue handling to assign to appropriate people to get the early fix done.
• Attended test scripts writing kick-off meeting and involved in writing test scripts for the master data
validation.
Followed in
• Involved the test scripting
developing template
business to prepare
scenarios test scripts
to execute systemandintegration
uploaded it to thetoappropriate
testing folderearly
identify defects into
on
the
before
QC.
• UAT and
Attended the go-live.
session of TBOM creation called out by automation engineers to APO business process to
assess an impact analysis of changed business process.
SCM APO SNP/DP System Analyst
Intel Corporation - June 2012 to March 2013
Created DP Master Data characteristic value combinations for the new Business Unit.
• Monitored DP Process Chain that picks up forecasts released by the external tool and uploads to the
Forecast
Cube
• and onto
Evaluated thethe Planning Book.
correctness of macro calculation and release of Demand Plan from DP to SNP.
• Validated and maintained ECC Master Data: Materials, BOMs, Production Version, Info Records, and
Scheduling Agreements as per business requirements.
• Developed the Supply Network Model incorporating all the Customers, CBA, Primary Warehouses, FG MRP
Areas, Subcontracting Vendor, Components MRP Areas, and Components Suppliers based on the Supply
Chain Process.
• Configured the Supply Chain Model with Actual & Simulation Versions, Master data comprising
Locations, Products, External Procurement Relationships, Transportation Lanes, Means of Transport, Quota
Arrangement and Production Data Structure.
• Creation and Mass Maintenance of all the Master Data, and Corrected Master Data related issues for
Product,
Location, T-Lanes,
• Maintained Means of
SNP product Transports,
Master Views:and PDS.
administration, ATP, SNP Supply profile, SNP Deployment Profile,
lot size, extra attribute etc.
• Maintained settings for Deployment and its different horizons, deployment strategies, deployment run
and
comparing
• Discussedthe results
specific of critical
and deployment run.
requirements with the client team and discussed what can be done and what
data to be mapped from their legacy system, SPEED to R/3. Actively refined integration Data Specifications.
• Selected necessary test cases and modified test cases as per business requirements in HPQC and
documented the test results for both Functional Unit Testing and End to End System testing of the
implementations in Demand Planning and Supply Network Planning.
• Coordinated UAT and developed training documents for the End Users, conducted knowledge transfer
through end user training, and resolved end user's issues.
• Involved in creating and managing Batch Jobs for planning processes in DP and SNP.
• Conducted performance tests on batch jobs to check ecology of overall Batch Jobs
• Prepared pre conversion activities, conversion and cutover activities before the Go-Live.
• Actively involved in the stabilization of system after Go-Live and assigned to handle tickets using IPRO tool.
• Created, activated and maintained Integration Models using Core Interface for transferring Initial Master
data
like Locations, Product Master Data, and External Procurement Relationships.
• Debugged CIF related issues, worked on CIF Error handling, and CIF Post Processing, CIF reconciliation,
and Delta Reports.
SCM APO Consultant
FMC Technologies - March 2012 to May 2012
Participated in the kick off meeting for initial requirement gathering to understand the business process.
• Involved with design and implementation of Demand Planning, Production Planning and Detailed
Scheduling
projects using
• Involved SCM 7.0.
in "As-Is" study & interacted with the core team members for developing a "To-Be" process to suit
the company's objectives using FMC Global Template.
• Walkthrough business process to identify template gap, process gaps, issues, and process alignment.
• Discussed specific and critical requirements with the client team and discussed what can be done and what
data to be mapped from their legacy system, SyteLine to R/3. Actively designed and refined integration Data
Specifications.
• Assigned in monitoring of proper transfer of Master Data and Transactional Data from ECC to SCM through
Core Interface.
• Streamlined, Reviewed, Corrected the Blueprint while incorporating SAP Best practices for Demand
Planning,
and Production
• Assigned Planning
to create and Detailed
Functional Scheduling.
Specification & Technical Specification documents, Unit and Integrations Test
script documents for Demand Planning Business Processes for the company.
• Proposed the usage of and configured the new features of SCM 7.0 in DP like Key Figure Specific Locking,
Macros with Fixing/Unfixing capability.
• Discussed different forecasting method and demand planning, and analyzed different integration model for
effective execution of SAP APO.
• Responsible for handling entire DP configuration objects like Planning Areas, Planning Object Structures,
Storage and Planning Buckets Profiles, Forecast profiles, Alert Monitor, Lifecycle Planning, Mass processing
and rest of the areas.
SCM APO DP Consultant
Rexam PLC - October 2011 to January 2012
Setup of various activities for background jobs, set up variants to load data from the APO BW to the Planning
area and the calculation of specific key figures in the planning book
• Set up Background jobs, Mass processing, configure Process Chain for DP monthly cycle.
• Resolved macro aggregation issues along with the selection ID issues to stabilize the system in post go-
live phase.
• Interacted regularly with the client members to resolve key requirements issues that led to detailed
design
documentation.
• Solved many DP critical issues within the tightly specified time frames to meet the service level
agreements.
•
• Worked
Proposedonthe
Production
usage of support new requirements
new macros and resolve
with authorization issues the new features in demand planning
and configured
such as Key Figure Specific opening and closing macros.
• Defined and created macros with Fixing/Unfixing capability for specific key figure in the table.
• Developed and customized Macros in DP to suit the business requirements
• Improved DP Batch processes of background jobs by designing Process chains for entire activity.
• Configured Meta Chain of Process Chains as per the business requirements for entire DP activity and
configured individual process chains for specific business requirements.
• Created documentation for the configuration of the process chains in DEV system.
SCM APO SNP/DP Consultant
Diversey Inc - May 2010 to September 2011
Created process chains for loading data into APO from BW and vice versa.
• Modified info objects length for the source system and rebuilt the complete Characteristic Value
Combinations
(CVC)
• and Master
Created reloaded the data
Planning successfully.
Object structure, Characteristic Combination, Storage Bucket Profile and Planning
Bucket Profile for monthly buckets and weekly buckets.
• Worked on Forecast Error Analysis using MAPE and MAD for forecast accuracy measurements, configured
the trend dampening profiles and assigned it to the Univariate forecast profile, maintained Promotional
Planning functionality, Life cycle management, and "Like" Modeling.
• Enhancements in Demand Planning by changing to existing configuration and settings in objects like ODSs
by adopting SAP's Best Practices with intent to optimize the performance in product box.
• Tested technical objects and helped ABAP team.
• Configured new alert requirement and also worked on production support.
• Set up of SNP master profile and configured SNP Master Data Locations, Product Masters, Resource and
Production Process Models (PPM)
• Reconfiguration of plant setting from R/3 to APO.
• Maintained Planning calendar, Planner Responsible and Creating variant for SNP Transaction Data Deletion.
• Performed SNP runs using SNP heuristics, created cost and Optimization profile for SNP Optimizer.
• Setup required configurations for Supply Network Planning run using Capable-to-Match and various
Capable-
to-Match planning methods. Capable-to-Match master data selection, Order selection, Capable-to-Match Time
stream.
• Identified the rules for optimization by identifying the optimization costs for production, procurement,
and
transportation. Utilized the quota arrangements for correct distribution to different sources of supply.
SCM APO DP/GATP Consultant
Barr Pharmaceuticals - May 2009 to April 2010
Analyzed the AS-IS condition of the demand planning process and carried out the TO-BE and GAP analysis,
business process re-engineering and configuration.
• Maintained storage bucket and time bucket
profiles.
• Involved in the creation of Info packages for both delta and full loads to various ODSs and info Cubes and
also monitored the loads.
• Set up the Demand Planning Book, Planning Object Structure, Planning Area and Macros in the Interactive
Demand Planning.
• Created Characteristic Value Combinations, Storage Bucket Profile and Planning Bucket profile, Phase-in,
Phase-out and Like Profiles and the related Activities, Batch Jobs, Variants and Background jobs.
• Created Forecast Alert profiles to display alerts for Univariate forecast errors and used Alert monitor to
identify
potential problems
• Maintained in the
Statistical forecastProfiles
Forecast by defining alert macros.
and various Data views as per business blueprint.
• Prepared Business Flow Charts based on Business Blue Print documents.
• Completed configuration of product allocation including settings in Demand Planning
• Responsible for configuration for Rule based ATP check.
• Worked on testing Backorder processing, Product allocations and Rule based ATP check by creating
scenarios using sales orders in R/3.
• Troubleshooting configuration issues in GATP and its integration with R/3.
• Configured mass processing for forecast, macros and demand plan releases.
SCM APO SNP/DP Consultant
Brown - February 2008 to April 2009
Was given the responsibility for maintaining the Key Figures, Characteristics, Macros, Alerts, Planning Books,
and Data Views in consensus with planners.
• Set up APO BW Source system, Info Area, Info Source, and Info Cube.
• Maintained Time bucket profiles, Statistical Forecast profiles, and Planning Versions.
• Improved Demand Planning Batch processes by designing Process Chains for specific processes.
• Discussed specific and critical requirements with the client team and discussed what can be done and
what data to be mapped from their legacy system to R/3. Actively designed and refined integration Data
Specifications.
• Monitored exceptional or critical situations using Alert Monitor.
• Performed Life Cycle Planning through Like Profile, Phase-in, and Phase-out Profile.
• Designed and Developed the Supply Network Model incorporating all the plants, distribution centers,
Customers and Suppliers based on the Supply Chain Process.
• Designed & Configured the Optimization Planning, Heuristic Planning, Deployment and Transport Load
Builder Functionalities.
• Created, activated and maintained Integration Models using Core Interface for transferring Initial Master
data
like Production Process Models, Product Master Data, Locations and Resources.
• Involved in Core Interface activities like Monitoring and error handling and other problem solving activities.
• Worked on Forecast Consumption, carried out Procurement Planning process and Allocation Planning.
• Maintained settings for Deployment and its different horizons, deployment strategies, deployment run
and
compared
• thetraining
Developed results of deployment
documents for run.
the End Users, knowledge transfer with end user training and resolved
any end user issues.
• Developed test cases and documented the test results for both functional and integration testing of
the
implementations in Demand
• Debugged CIF related Planning
issues, and
CIF Post Supply Network
Processing, and CIFPlanning.
reconciliation.
SCM APO DP/SNP/PPDS Consultant
Delphi Auto, MI - April 2007 to January 2008
Involved in "As-Is" study & interacting with the core team members and developed a "To-Be" process to suit
the company's objectives using ASAP methodology.
• Designed Planning Books and Data Views, Planning Areas, and worked on configuration of APO- Demand
Planning MPOS.
• Maintained Time Bucket Profiles, Storage Bucket Profiles, Statistical Forecast Profiles.
• Created Info Areas, Info Catalogs, Info Sources and Info packages to accommodate various data
presentation
and
• integration
Worked requirements.
on demand planning master data, consolidating and harmonizing master data.
• Created forecast Alert profiles to display alerts for Univariate forecast errors and used Alert Monitor to
identify
potential problems
• Rolled out in the
a Vendor forecast Inventory
Managed by defining alert program
(VMI) macros. with key accounts to drive significant channel
inventory and cycle time improvements.
• Parameterized the strategic Demand planning for
automotive.
• Designed and configured the Optimization Planning, Heuristic Planning, Capable-To-Match Planning,
Deployment and Transport Load Builder Functionalities.
• Detailed analysis of SNP optimization results to fine-tune costing parameters for desired planning results
• APO-based master data setup for Supply Network Planning: Planning calendars, transportation lanes,
appropriate material attributes
• Configured the Supply Chain Model with Actual & Simulation Versions, Master data comprising Locations,
Production Process Models, Resource and Hierarchy.
• Involved in the Implementation of PPDS Module and Master data maintenance.
• Configured Production Planning and Detail Scheduling Alert Profile, Work Area, propagation range, strategy
profile, maintained Optimization profile.
• Created Period - Oriented planning in the Product Planning table.
• Utilization of Production Planning and Detail Scheduling optimization to produce feasible schedule
constrained by resource capacity.
• Incorporated setup matrix functionality to facilitate campaign scheduling requirements of production
facility.
•
• Worked on the
Developed the Interactive & Automatic
reporting formats backlogPlanning scenarios.
rescheduling report, Shortage list report, and Production Plan
report.
SCM APO DP/SNP Consultant
Dole Foods - March 2006 to March 2007
Configured navigational attributes for Location in Demand Planning. Forecast drivers in Interactive Demand
Planning.
• Created info areas, info catalogs, info source, and info cube.
• Generated planned independent requirements based on the customers historical sales data using various
statistical forecasting methods of Demand Planning and developed methodology for evaluating the best
forecast based on Best Practices in the industry.
• Maintained Material Master Data, Customer Master Data and Vendor Master Data and transferring the data
into APO.
• Creation and maintenance of all the Master Data and Corrected Master Data related issues for Product,
Location, Transportation Lanes, Means of Transports, and PPM.
• Debugged CIF related issues, worked on CIF Error handling, and CIF Post Processing, CIF reconciliation
and Delta Reports.
• Used BAPI's in several custom programs to extract transactional data from R/3 to APO.
• Worked on Forecast consumption, carried out Procurement Planning process and Allocation Planning.
• Executed Deployment Runs to determine the distribution of available supply.
ADDITIONAL INFORMATION
Job Skills:
• DP: Interactive panning, Planning Area Configuration (Info Objects, Info Cubes, Source Systems,
Info Sources, and Info Packages), Planning Book, Macros, Forecasting Strategies, Life Cycle Planning,
Background Job, Mass processing, Process Chain Maintenance, Demand Release, Alert Monitor.
• SNP: Master Data, Planning Methods (Heuristic, Optimization, Capable-to-Match), Planning Book and Macro
Design, Advanced safety Stock Planning, Deployment and Transportation Load Builder.
• CIF: Created, Activated and Maintained CIF Integration Models for Master and Transaction Data transfer
between ECC and APO.
• Engaged in full life cycle implementations, support projects, and upgrade projects in APO with SAP
recommended Best Practices.
• Gained experience in ASAP methodology in all phases of project implementation- Project Preparation,
Business Blueprint, Realization, Pre-go Live, Go Live and Post Live Support.
• Participated in projects, that employed the SAP ECC Production Planning (PP) module, with a
comprehensive
knowledge of Material Requirement Planning (MRP), Bill of Materials (BOM), Work center and Routings, etc.
• Involved closely with Sales and distribution, procurement processes of material management (MM) and
exposed
• Hands onto Supplier Network
experience Collaboration
on Test Planning and(SNC)
execution in HP Quality Center environment. Good knowledge
in unit testing, integration testing and user-acceptance testing.
• Maintained Time bucket profiles, Forecast profiles, planning versions, promotional Planning, life cycle
management and "Like" Modeling.
• Expertise in Project Management, Business Process Reengineering, Lean Manufacturing, and Optimization
concepts.
• Excellent analytical and technical skills with an ability to maintain a good interpersonal relationship
with
business users, and
• An exceptional theplayer
team clients.
with a strong management, administration, problem solving, and decision-
making
capability.
• Flexible and can easily adapt to change of environment and work schedule
TECHNICAL SKILLS:
SAP Applications: SCM APO 4.0, 5.0, 7.0, R/3 4.6C¸4.7, ECC 5.0, 6.0, TAO, BPCA
MS Tools: MS Office, MS Visio, MS Project, MS SharePoint
Other Tools: HPQC, Peregrine, IPRO, Cognos, Web Portal
Database: MS Access, MS SQL Server, Toad for Oracle, Teradata SQL Assistant
Operating System: Windows 2007, Vista, XP, Windows 2000
