Kumar Bhatta

Overall I have 14 years of experience in System Application Products (SAP). As Analyst/Consultant implemented 3 large global roll-out template projects in SAP APO. As Analyst, I advised clients on performance, regulatory and optimization of KPIs and helped with design processes that make information gathering more efficient, accurate and timely.

With a strong technical background in SAP Advanced Planning and Optimization (APO) and Supply chain management (SCM), Business objects and HANA. I designed scalable architectures that combine data from various sources, configure planning, consolidation and publish information that is insightful and actionable. Effectively communicated with stakeholders at all levels to ensure smooth project delivery, commercial governance and organizational alignment to reduce total cost of ownership to client and partners.

I have deep knowledge of Retail, FMCG, Manufacturing, Oil & Gas, public sector industry in particular and I'm currently working as a Project Manager in finance regulatory reporting.

SAP APO Consultant - Deloitte

(2013-12 - 2026-03)

As a Team member played a key role in implementation of project in Advanced planning and optimizer, demand planning, Supply network planning. As a project lead I am accountable for project plan, technical architecture, APO solution design authority, configuration, test documentation.

• Migrated data from SAP APO/ERP to Kinaxis Maestro planning tool using ODP replicating framework.
• Implemented IBP modules for demand driven replenishment, inventory optimization.
• Implemented demand driven replenishment material requirements planning, setting up buffer profiles, average daily usage, decoupled lead time, buffer zone determination, defining profiles for safety stock.
• Designed process for inventory positing, buffer positioning, dynamic buffer adjustments, replenishment planning and replenishment execution, stock positioning, Fiori apps for lead time, MRP monitor, schedule classification of products, replenishment lead time monitor, Buffer level determination, schedule buffer level calculation, safety stock simulation, Inventory optimization services, activation of MRP Live, optimizing MRP live performance, Planning file entries conversion, subcontracting, mat
• Accountable for production of Demand plan and Supply Network Plan within agreed timetable and respond to audit requests arising from audit of these accounts.
• Responsible for making sure all business processes are followed to produce daily product demand plan, supply network plan in SAP APO.
• Implemented Demand Planning (DP) at both aggregate and detailed level and configured statistical forecasting to meet strategically and operational reporting goals.
• Implemented Supply network planning (SNP) to generate planned orders, stock transfers and purchase requisitions.
• Maintained planning areas, planning books, SNP Heuristic run, capacity check and leveling, Planning supplier constraints using SNP heuristic, aggregated planning, capable to match process, finite supplier planning in CTM.
• Implemented Global available to promise (GATP) creating set of rules using Multilevel available to promise by checking the sales order by on-time competency.
• Implemented safety stock calculation methods SB safety stock from location product master, SZ Safety days supply from location product master.
• Tested powerful planning library functions converted data contained in info cubes to relevant business information including aggregate function, Disaggregate function, Comparison functions and financial functions.
• Identifying the key risks and complex areas in APO design and challenging necessary teams to collate and document processes to support and validate configuration.
• Maintained log of recommendations from various teams on solution options and challenging them where necessary, documenting changes, and actions to be taken including target dates.
• Configured intermediate document IDoc standard data structure for electronic data interchange (EDI) between application programs.
• Clear understanding of control record, data records and status records, WE02 – Idoc list report, WE30 – Idoc type development, WE31 development IDoc views.
• Reviewed existing quarterly process to produce consolidated accounts to identify where improvements can be made with APO solution.
• Built relationship with team from project kick off and established communication channels early on with key stake holders and steering committee for the project and organization.
• Organized project status meetings to major stake holders with details on delivery and issue logs and project plan.
• Active role in managing the relationship between Business, Third-party implementation partners and Auditors, responding to their queries relating various processes.
• Liaise with all necessary teams to ensure audit queries are dealt with the agreed timetables.
• Organized workshops to gather functional requirements and understand business processes, prepared glossary of terms for all business processes in the blueprint document.
• Prepared system environments by performing test readiness activities helped the testing team to complete integration testing and user acceptance testing.
• Proactively involved in the cutover phase of the project.
• Deep understanding of complex accounting treatments Core accounts such as intercompany eliminations, currency conversions, data mapping in transformation files, conversion files, logic scripts.
• Implemented drill through of reports to ECC and BW from APO Input schedules.
• Analyzed master data loads using data manager packages, configured planning functions script logics, business rules, ABAP programming.
• Deployed Microsoft office with EPM Add-in for Microsoft office (EPM).
• Reported across EPM sources, OLAP providers including SAP Netweaver BW.
• Analyzed secured dimensions and security for member-level dimensions to control users read, writes and deny access to applications.

SAP APO Consultant - Kingfisher PLC

(2011-06 - 2013-11)

• Implemented interactive demand planning in /SAPAPO/SDP94.
• Created customized planning areas, planning books and user specific data views.
• Experienced in implementing univariate forecasting, composite forecast, casual analysis and consensus based forecasting.
• Designed Demand planning models considering future products launch by creating phase in-out and like profiles for life cycle planning.
• Implemented promotion planning using cannibalization groups to model effect of promotions.
• Defined promotional attributes.
• Tested Mass processing for macros, forecasts and demand plan releases.
• Participated in workshops to