Malhotra - SAP APO DP SNP SCM / Project Management - New Delhi, Delhi, India

Manas Malhotra

New Delhi, Delhi, India


SAP APO DP SNP SCM / Project Management


I have experience of seven years in IT consulting, data management, solution architecture, Lean Management and process improvement
Three years of domain experience in Automobile sector in distribution management and manufacturing.
As a IT / Process consultant specialize in Advance Planning Tools (SAP APO/ SCM), have implemented planning solutions for market leader in FMCG / Pharma industry,
Have been able to successfully manage business requirements related to vendor inventory, plant optimization, distribution optimization
Have seen “4” end to end implementations and developed two Demo systems for Pre sales. Have developed custom solution to cater client’s business needs
Being a part of Presales team have worked on client requirement, data analysis and proposed prospective system solution to cater to client requirements

Work History

SAP SCM SNC Solution Architect, Track lead for integrated solution


From March 2013

h 2013
Role: SAP SCM SNC Solution Architect, Track lead for integrated solution (design build/ deploy team), data management and testing track
Client Facing / Working out of client office: Yes / Bangalore

* Responsible for Implementing SNC customer collaboration , handling a team of 9 member team to get the project completed
* Responsibility as Manager for the project
• Present project development and mile stone achieved to the steering committee
• Develop project plan and present it to the client
• Develop meeting plan to achieve weekly objectives and develop risk and action log and maintain a continuous follow up to bring it to closure
• Being a multi vendor environment , need to maintain cordial communication with vendors handling other integrated systems
• Manage resources and conduct interviews for team enrolment
* Are currently using SAP APO Ascendant methodology to implement this project
* Conducted client work shops to show case standard functionalities in SNC to get clients buy in

Responsibility in this project is as to get clients sign off on all major deliverables in each phase of the project; my responsibility was also to achieve mile stones in project as our mile stone achievement was directly linked to client payment to our services
* Business scenarios mapped on the SNC system to achieve business requirements
• Promotions
• Short term forecasting
• Product determination
• Projected sales
• Critical product identification
• Static sourcing
• Historical sales management
* LSMW creation master data upload and maintenance
* For initial cut over activity using APO load builder
Company details: Britannia Industries LTD (India, Bangalore),
Phase of the project: Project Preparation to realization

DP Senior consultant


From April 2012

Client Facing / Working out of client office: Yes / Bangalore

* Responsible for Implementing SNP / DP
* Have been through the entire life cycle, made use of SAP ascendant methodology for this project
* Conducted client work shops to show case standard functionalities in SNP / DP to get clients buy in

Responsibility in this project was to get clients sign off on SNP design; my responsibility was also to achieve mile stones in project as our mile stone achievement was directly linked to client payment to our services
* Business scenarios mapped:
• Run Discrete Optimizer monthly / quota arrangement
• Monthly optimizer followed by weekly heuristic run
• Extract reports
• Deployment heuristic
• Force loading resources
• Product interchangeability to use stocks of similar products incase of stock out of a finish good
• Cross period lot sizing
• Integrating SNP and ECC
* Implementing SNP for cost optimization solution
* LSMW creation master data upload and maintenance
* APO load builder for master data maintenance
Have worked on following areas in Demand Planning
• Conducted workshop / session to arrive at level of forecasting
• Worked with client on their historical data to find COV and decide on forecasting levels cross different brands
• Master planning object structure / planning area design
• Advance macro creation in Demand Planning ( DP )
• Planning books Design
• Had worked on different forecasting models
• Like modeling / Phase in Phase out scenario show casing to the client ( client demo)
• Realignment
• Demo / POC on data modeling
* Creating info cube
* Loading it using flat file
* Show demand in planning book
* Run forecast using univariate profile / different planning profiles were tested
* Various different combination of trend / seasonal / Smoothing factors were applied on historical to reduce MAPE ; to arrive at right forecasting model
* Macros on Sales volume / Consensus based planning

Track Lead / Project Manager

Hindustan Unilever

March 2011 - April 2012

(India, Bangalore),
Phase of the project: Project Preparation till Realization and go live support
Duration: March 2011 to April 2012
Role: Track Lead / Project Manager
Client Facing / Working out of client office: Yes / Bangalore office

• Managed a team of 8 member
• Responsible for SNC SCM 7.0 go live , did blue printing/ other design documentation / system configuration / mile stone sign offs
• Was responsible to manage project deliverables and achieve project mile stones for payments from client
• Resource management from supporting functional and technical consultants
• Have been responsible to bring in the business & invest in our existing client
• Was responsible to conduct client work shop and SAP work shop to get client buy in

Being a Subject matter expert in SNC SCM domain at my current company was responsible for following
• Define project goals and objectives
• Clarified scope of implementation
• Define project schedule and implementation sequence
• Business Blueprinting
• Configuration setting and getting scenario tested
• System setup and connectivity between system ( CIF setting ; Idoc configuration)
• Business scenarios mapped:
o Replenishment
o Truck load building
o Auto publishing and order send in back ground report
o Promotion planning
Did functional specification for all the custom requirement not supported by SAP
Our client being a major player in distribution sector have concept like Area and customer material mapped to an area; distributor access
These concepts were not available in SNC so did logic builds up to incorporate these concepts and incorporated then in standard process as follows:
• Product activation
• Customer activation for an area in real time business scenario
• Automation of area activation
Have also developed logics to enrich the master data for replenishment planning
• Location product creation
• Partner product and PO split criteria maintenance
• TLB and Selection criteria maintenance
• Forecasting profile and...

Team Lead

Mead Johnson Nutrition

July 2009 - March 2011

(USA, Evansville, Indiana)
Phase of the project: Blueprinting Phase till go live support; support team setup.
Duration: July 2009 to March 2011
Role: Team Lead
Client Facing / Working out of client office: Yes / USA Evansville

Implemented following business processes and gained experience on following areas in SNC trough the life cycle of both the projects:

• Promotion planning
• Responsive Replenishment Planning
• Statistical and short term forecasting
• Like profiling
• Multi stop using hierarchy
• Worked on standard extractor for report generation in BI

I have worked on APO load builder to upload data in production during cutover and have been responsible for data validation.

During cutover handles all configuration related to system step up that are non transportable. In APO SNC system like open quantity, Partner product assignment
Worked on Planning and service profiles in SNC system for planning customer products and creating weekly job and daily jobs planning jobs.

XML being an important part of SNC, worked every closely with Web sphere consultants to map customer input data EDI 852 to SNC system using XML messages.

In sales and distribution side worked on sales order integration with SCM SNC

* For Client requirements not supported by SAP, worked on GAP analysis. and functional specification and worked with technical team to develop programs

* Developed an application on the execution system to change order quantity with customer inputs by displaying them their orders for material using Webdyn pro, worked on all functional specification ,
Screen design and mathematical logic to support it

* Few of the developments done were related to change of unit of measure / order quantity conversion based on customer inputs while processing Orders05 using IDOCs.

On Demand Planning (DP) front was responsible for following activites:

• Data modeling
• Analysis on historical data / forecast modeling / forecasting level
• Load history using CSV files

Senior SCM consultant

IBM India Pvt LTD

From May 2007

I have been working as a Subject Matter expert on SAP SCM SNC customer collaboration and on the delivery front specialize as an SCM Consultant / Business Analyst in SCM (supply chain management) domain (Distribution sector).
Specialize in SAP APO DP / SNP / SNC

Have been responsible for client development / improve engagement for existing clients
Develop and present solutions to new clients and take part in RFP's

I have performed role of subject matter expert/ project manager / track lead

Working as a functional consultant / Business analyst mapped various supply chain concepts like hub and spoke module, postponement model , Promotion interventions to name a few

Worked on product behavior, understanding product life cycle and promotion patterns, did demand / sales patterns analysis.

During my tenure, I have implemented major projects. I specialize in CPG / FMCG industry; have worked with market leaders (Hindustan Unilever; Britannia Industries, Mead Johnsons)

Have been able to achieve landmarks like improved service level for the client through their supply chain by implementing SNC, DP and SNP as planning solution

Helped in reducing the operational cost both at business and IT support end

Have been actively involved in Pre sales activities for our existing clients and increasing client engagement, have been actively involved in answering RFP's (request for proposals)

Have been Responsible to achieve project mile stones / the client payments for mile stone achieved / Resource management for my team

Team member

July 2007 - March 2008

Team Lead (March 2008 to July 2009)
Client Facing / Working out of client office: Yes / Bangalore

Job Responsibility / Role: Package solution consultant / Client facing role/ Team lead (team strength of 6 members)
Provide Solution to client using ICH as a tool
Implemented Replenishment planning and Promotion planning to cater to client requirement
Brought in concept like mass replenishment
Incorporated the concept on beat or delivery plan in SNC.
Worked on Elective Enhancement for the customer to cater to their needs, to incorporate business process which could not me mapped in Standard SAP

Contribution in Pre sales and Sales activities for my current organization:

* Have design Sales template on the functionality of Supply network Planning, The template deals with capturing demand for customer material, running forecasting and order creation with inputs from the customer as per a pre defined quota. Changing order for customer material on pre defined quota is not supported by standard system; to cater to FMCG sector developed this functionality in the template for better client acceptance.

* I have actively participated in Pre Sales activities to bring in business from the existing clients, was responsible for clients buy in.

* Have been successful to engage our existing customer to give us more business in term for support and future enhancements.

* I have actively worked with our sales team to understand customer requirements and working with internal teams to propose a solution to the client both custom and standard solutions.

* Have been awarded a certificate by my current company towards my contribution to client success. This was presented to me for my work on providing them with custom solutions and designing an entire end to end solution; handled and build entire team from design built; after go live support till the solution was stable.

* As team lead, handled a team of 10. Kept a track of all the development and User issues reported. Worked...

Sales Executive

G.G Automotive Gears LTD

December 2002 - November 2004

Handled after sales market for Delhi, Performed role of Sales executive and worked in team for dealer development program.

Dealer Development Program

Project Description:
To develop after sales market for gear components in Delhi tractor market

I contributed by carrying out a market study, finding out the competitor products available, we as a team even carried out a survey at the work shop end , thus analyzing product acceptability and the dealer who could promote our product.


Trainee Engineer

Kirloskar Oil Engines LTD

November 2001 - October 2002

Worked in production plant as a Line Manager, took initiatives for Kaizan (continuous improvement) at the shop floor and Sinter division (powder plant) Continuous Improvement

Project Description:
The project related to reducing the bottle necks.

To reduce the bottle necks, we as line managers carry out time and motion study and suggested improvements that could be done. I had suggested two Kaizans that were implemented on the shop floor

Qualifications & Certifications


K.J.Somaiya Institute of management Studies and Research

Production Engineering

Kolhapur Institute of Technology, Shivaji University

Manav Sthali School

Skillpages has been acquired by! is pioneering the way people find local services. Skillpages is the world’s premier directory of service providers.

Find out more

Supported Countries
Choose your country