Schlagwörter
Skills
SAP BW4HANA , SAP BI/BW
SAP BI-IP
SAP HANA
SAP BODS
LUMIRA, SAC, PowerBI
SAP BI
SAP BI-IP
SAP HANA
SAP BODS
LUMIRA, SAC, PowerBI
SAP BI
- End to End Data Modelling in SAP BW/HANA with BW relevant ABAP.
- Design and implementation of Data integration solutions from external sources like
- 3rd party data (IBM Sterling) integration using TIBCO and webservice datasources.
- CRM application systems (Sales Force Dot Com-Veeva) using BODS and integration with Sales data.
- Lotus Notes(timesheet application)
- Reporting layer - Bex Query Designer, Workbook, WAD, Analysis for Office.
- Finance and controlling extractions (New GL(Totals), CO-PA, Controlling), LO Cockpit.
- Integrated Planning – Fox Formulas, WAD based input layouts.
- BW on HANA data modelling.
- Modelling of HANA views for reporting – analytical, calculation and scripted views.
- Batch Job, Workflow, Dataflows.
- File Formats, Data Stores, Custom Functions
- Integration of BODS with SAP BI/BW (7.0) using 3.5 Datasources).
- Web Intelligence Rich Client
- Universe Designer Tool.
Projekthistorie
April 2016 – Present: Primary BW/HANA Consultant Ecom OmniChannel BI Integration and Reporting at Adidas Group, Herzogenaurach, Germany.
October 2013 – December 2014: BI/BW, IP Consultant for Sandoz (Hexal AG) Pune, India
- Functional and technical Integration of IBM sterling data for e-commerce solutions via TIBCO, Implementation of reporting solutions in a BW on HANA system with MSTR frontend reporting for –
- E-commerce reporting.
- Omnichannel sales reporting( Retail sales + E-com Sales).
- Global Operations reporting – OTIF(On-Time in Full), DCRM( Delivery center responsiveness management).
- Integration of SAP CAR and SAP Retail data(invoiced sales) into reports.
- Re-Defining and implementing reporting solution based on new business processes like Ship-from-store, Return-to-Store, Click-and-Collect.
- Performed extensive Fit-GAP analysis of Omnihub data v/s SAP AFS data, conceptualized and implemented Data harmonization and Gap-Fulfilment on a technical and functional level.
- Designed web service Datasources with a field by field mapping exercise, grouped semantically similar data into Datasources sing TIBCO.
- Enhancements to provide additional “ Omnichannel “ reporting from HANA backend with performance optimization leading to 70% performance increase.
- Implementation of a “user comments” functionality using HANA backend and MicroStrategy’s Write-Back functionality as front end.
- Implementation of Group Data Warehouse integration of financial data from Novartis Sandoz to Novartis Group data warehouse(Novartis Business Services).
- Area Manager for all Finance and costing applications in BI.
- Single point of contact for Financial Month end closing for BI reporting for Global Business.
- Worked on country Roll-outs, projects and as a reviewer for finance applications.
- Involved in service management for Financial operations with close interaction with stakeholders like BPA managers, FRA ops, Country managers for business processes like R2P, R2R.
October 2013 – December 2014: BI/BW, IP Consultant for Sandoz (Hexal AG) Pune, India
- Conceptualization to Implementation of FCRS(Financial Consolidation and Reporting) application from GL Line item datamodel to “ GL Totals” data-model. Lead to almost real time reporting during Financial month-end closing periods (Hourly refresh)
- Worked on FCRS- involving Balance sheets, Income statements generic Financial reporting and BPA reporting.
- Primary Owner for all Finance and costing applications in BI.
- Implementation of SAP BODS extraction of VEEVA( Sales Force Dot Com) data with SAP data in BI and SAP BO – Webi based reporting including sales and Sales Representative effectiveness reporting.
- Implementation and post go-Livesupport for IP applications like Cost center planning and integration with income statement reports, Retraction to ECC.
- Single point of contact (SPOC) for Dataload monitoring team.
- Single point of contact (SPOC) for America region enhancement and support.
- Application owner for Daily sales reporting (DSR) and CRM( SFDC-BI) dashboard.
Reisebereitschaft
Verfügbar in den Ländern
Deutschland