Project Domain: U.S Based Food Retail Client, Packaged Food Industry
- Handled ETL Production team responsible for Monitoring & fixing of SLA/Non-SLA loads/process Chains, pertaining to both master data and transaction data of different flows like Sales /Supply Chain/Finance on a day-to-day basis.
- Worked and developed Sales flows from ECC to BW and worked on their Reporting part and handled various issues that are raised by business users as part of this.
- Created data flow models in various functional areas like SD, SCM, FI using DSO, ADSO, Cubes, Multiproviders, Composite Providers, Queries, RKFs, CKFs, Customer Exits, etc.,
- Worked on Hybrid Modelling of different critical reporting flows related to budgets, funds etc. involving building, maintenance and providing issue resolution adhering to Service level agreements.
- Worked on Input ready queries, Hana Views ,Open ODS Views and different models like DSO’s, Infocubes ,ADSO’s, Composite Providers,Multi Providers , ABAP routines during issue analysis and also worked on enhancements in Hana Views as per the business needs.
- Experienced in fixing standard extractors(2Lis) level data mismatch issues in BW and reconciliation accordingly with respect to ECC/R3.
- Experienced in Point of Sales /Market research related data feeds to BW hana tables using DaaS services/reports/data provided by analytics companies like Iri/ Neilsen etc.
- Automated time/effort consuming areas in the project which reduced business turn around significantly and leveraged BODS/.bat scripts for this development.
- Gained knowledge of LSA++ architecture and its corresponding models relevant to BW/4 Hana during POC’s conducted.
- Gained expertise in handling and managing different system wide cut-over activities,documenting plans etc.
- Lead and harmonized production support team in bug fixes, testing and debugging of data models and in providing root cause analysis.
- Worked on integration of BW/HANA Models with Azure Data Lake, Snowflake ,Power BI to drive enterprise reporting.
- Worked and implemented system optimization techniques to mitigate issues in the system raised by early watch report of SAP.