Natarajan Ramalingam

SAP IBP Skills:

• Setup application template for users in IBP Excel add in.
• Setup and maintain Master data in IBP.
• Create BOM Explosion using IBP master data to identify all the levels of components.
• Validate master data from SAP IBP to SAP ERP
• Knowledge on Planning Model: Attributes, Master data types, Time Profiles, Planning area, Planning levels, Key figures.
• Knowledge on Planning operators, Versions and Scenarios.
• Knowledge on IBP demand Planning- Forecast models, Outlier Correction methods, Forecast Error methods and Demand sensing.
• Considerable Knowledge on S&OP and Control Tower.
• Setting up of dashboard and analytics
• Create jobs to import and export data to IBP using CPI-DS (HCI-DS).
• Create different data store to connect multiple source (SAP, Oracle, APO and etc) of information.

Capacity Check Process:

• To Track Customer demand vs Capacity Utilization % and gather necessary feedback from Supply Analyst and convert that into Sellable Part and provide the feedback accordingly to the customer

Responsibilities:

• Understand current process (without IBP) and prepare new process which is aligned with IBP
• Collaborate with Global S&OP team and setup the new process in IBP
• Created new version to capture Capacity check related data
• Different Heuristic will be scheduled for Capacity check data
• Demand data is loaded thru Data integration every month end
• Created an application to support the process in a better user experience to plan their S&OP planning (Using DB, Power Apps, Webi Report)
• Extract Capacity check data monthly basis for Capacity Check process from IBP using CPI-DS to show in the application
• Will plan planning based on Resources
• Run BOM explosion to find Product which is produced in the resources and get the feedback from Resources level to Product Level
• Created escalation matrix to this process to maintain proper timeline to finish the task which is assigned to Supply and demand analyst
• Provided tableau dashboard to get business insights to business

Constraint Forecast Process:

It has shown how important it is for a business to constantly keep track of its Capacity. In this case it is the potential for faster time to market through transparency for Product Management and faster reduction of premium freights by pre planning for upcoming constraints. Therewith minimizing delivery interruptions and reducing lates impact. The project will include the already used logic for the new capacity check functionality to find the Finished Good Product from the Resource ID in IBP.

Responsibilities:

• Currently business uses excel sheet to track constraint machines and tools to take action
• We built an application to track constraint machines and tools information with supply analyst feedback
• To support application, we extract Supply data out of IBP using CPI-DS and filter Resources Capacity Utilization % above 80% and will show them in the app every week after heuristic run
• After receiving feedback from Supply analyst,Run BOM explosion to find products which is produced in the Resource and bring necessary information that will help to analysis the resources capacity
• Created escalation matrix to this process to maintain proper timeline to finish the task which is assigned to Supply analyst
• Provided tableau dashboard to get business insights to business

CPI-DS Data Load and Extract:

• Created a connection in Data store and bring necessary input tables and output tables
• Connections like connecting Azure DW, Flat file and IBP
• Create a 40+ jobs to Extract Master Data and Key figures related to Demand planning on Daily/Weekly/Monthly basis
• Create a 20+ jobs to Extract Master Data and Key figures related to Supply planning on Daily/Weekly/Monthly basis
• We created a flat file destination for huge data sets extract due to time constraint
• Azure DW take abnormal time to load
• To push flat file to Azure DW, we created Azure pipeline to push the data into Azure dW
• We created data monitoring application to track data load information
• Predicting Statistical Forecast:
• Idea is to build Better forecast in IBP to support demand team to predict consensus forecast
• We extract Historical Demand from IBP and other streams of Forecast using CPI-ds
• Comparing all the Streams of Forecast and suggest better forecast to demand planner to update consensus forecast
• Data will be modified as per machine learning needs and stored in DW
• Predict the Statistical Forecast using Machine Learning
• We created short term forecast for future 3 months and 6 months range
• Data’s are stored in DW after forecast prediction and pushed into IBP using CPI-ds

• Coordinate with circle office and collect report (16 Circles All over India)
• Maintaining Vendors invoices and Payment management through ERP
• Maintaining Usable/Repairable & not Repairable Inventory details
• Creation of Purchase Order/ Goods Receipt Note/ Rate Contract/Stock Transfer Note

• Making reports as per formats provided by the Process/ Client
• Consolidation of reports like eligibility criteria for IJP’s & Performance Reports
• Reporting the attendance of the unit on a daily basis to the HR and PDH
• Preparing Pay Roll Tracker for Floor Agent
• Publishing attired agents, absenteeism shift wise, AWOI list daily
• Preparing Agent Performance, Repeat and etc.,
• Handling Review data for process Like (Quarterly & Monthly Business Review)