HIMANSHU KUMAR

• SAC Planning Lead in an Assessment program from Data analytics Reporting and Planning standpoint. Responsible to assess their As-Is Budgeting, Forecasting, Planning processes and MIS dashboards, reports of FP&A Business Department.
• Conducted Workshops, Weekly meetings with required stakeholders and showcase current, transition and target state and accordingly proposed recommendations.
• Define To-Be processes, architecture, data integration and data migration strategies from legacy applications to S/4HANA, HANA cloud-Data lake, SAC Visualization and Planning applications.
• Worked on Overall effort estimates, Staffing, Implementation Roadmap plan for Analytics and Planning solutions

1. Worked in the Retail Industry for SAP TPM and Analytics Carve Out Divestiture, USA with the following responsibilities on SAP ECC on HANA, CRM 4.0 and BW on HANA (PAK) on-premises systems:

Responsibilities

· Solution Architect in SAP trade promotion Carve-out divestiture project. Responsible for designing data migration strategy to carve out SAP trade & non-SAP systems. Conducted workshops with 5+ client's core technical teams to assess in-scoped metadata, define testing, cutover strategy for 700+ BW/Input enabled Planning reports, overall data migration strategy, provide solutions using LSA++ method, align Project plan & provide automation techniques. Contributed to SAP BOBJ & tableau migration strategies also.

· Developed info providers, ADSO Partitioning, ABAP Programs, Process chains to support data migration strategy. Resolved critical BW Integrated Planning issues wherever the backend custom planning functions and sequences got involved.

· Resolved many issues related to PF filters, Variables, Data Achieving Process (DAP / NLS) characteristics relationship and data slices.

· Worked on system and BW & TPM metadata validation to ensure all the functionality runs well on the carved-out system

2. Worked in the Retail Industry for SAP TPM, CBP (Sales Planning) and SAC Implementation with the following responsibilities on SAP S/4HANA 1909 on-prem, CRM 4.0, BW on HANA on-prem systems and SAP Analytics Cloud

Responsibilities

· Responsible to deliver SAP trade promotion/BW Integrated Planning daily tasks. The Role was to focus on agile methodology & LSA++ development approach and build the best design for 20+ user stories. Had ensured design's flexibility from a future development standpoint.

· Created custom planning functions & sequences, implemented AMDP scripting and ABAP routines for the custom complex requirements.

· Worked in TPM Analytics project for CSD, GL reconciliation of invalid, aging trade promo and settlements. Created S4HANA CDS Views (basic, composite, consumption), Fiori Apps and consumed also in SAP Analytics Cloud application.

· Gathered Reporting requirement for SAC application - created Dimensions, Planning & Analytical models using acquired import/live data connections and Story (Responsive & Grid Pages), defined Data Actions using Advanced Formula Scripts, Allocations, Value Driver Tree.

3. Worked in Petroleum Industry or SAP HANA, BW/4HANA, ABAP, SQL with the following responsibilities on SAP BW/4HANA, SAP ECC 6.0, SAP DWC on-prem systems and SAP Analytics Cloud 2019.x.x to 2021.x.x:

· Worked at Onsite at KL, Malaysia aas SAP HANA/BPC/BW Lead for process analysis, restructuring & requirement finalization. Responsible for managing critical Finance month-end issues & resolving them. Created relevant BW data flow and made data mart available for further extraction to Qlik sense. Delivered these data flows using agile methodologies. Worked as single month end focal for all FI & BCS month end issues in BW/HANA/BPC system. Extracted data from BW/HANA system and transform them for further QlikView reports.

· Managed BW, HANA deliverables from offshore

· Optimized data flows designed for better query performance including optimization of ABAP codes

· Automated 2 process chains, which was traditionally been scheduled by monitoring team manually

· Involved in HANA sub-projects, created ADSOs, Composite providers and reports

· Replicated the tables in SLT and configured near real time data update to HANA studio

· Replicated ECC Tables through SLT framework into HANA database

· Created HANA views on top of these tables for further analysis or reporting.

• Managed BW deliverables from offshore as a BW lead with 3 members in the team
• Gathered user requirements: Functional Specifications & consequently created Technical specifications
• Defined data Sources loads: delta initialization, re-initializations, and re-construction. Scheduled jobs of standard DELTA programs in ECC. Involved in validating data reconciliation by implementing RRI functionality
• Designed and developed process chains for master data and transaction data loads and scheduled for periodic loads
• Developed enterprise portal iViews using WAD templates and assigning authorization accesses on iView through work sets & roles
• Worked on integration of systems while migrating the systems on cloud SAP systems and resolved many issues related WAD templates on Portal.
• Involved in rectifying initial unit/currency entries with KF, applied SAP notes for SD data flow issues
• Enhanced generic extractors, generated composite keys in master data flow. Worked on LO extraction, scheduled LO jobs in source systems and initialized their data source by taking downtime
• Implemented FI, PS data flows in BW reporting over Crystal reports
• Created few generic PS extractors based on function module
• Scheduled process chains by creating custom program and triggered them through EVENT.
• Developed Master data and Transaction data of FI, IS-U Billing, FICA data flows. Worked on Analysis Authorizations: Maintained authorizations in BEx report through customer exit logic
• Transported source-target flow, IOs, BEx queries, WADs from development to production system
• Successfully managed high-prioritized tickets regarding extractions, performance Issues and on load failures
• Generated yearly cubes, which has bifurcated data to avoid huge data load
• Successfully managed high-prioritized tickets regarding extractions, performance Issues and on load failures
• Generated yearly cubes, which has bifurcated data to avoid huge data load
• Part of ECC & BW upgrades and handled many issues related to BW
• Managed offshore all deliverables by taking 5 resources in my team