AY

Abhijeet Yatgiri

verfügbar

Letztes Update: 18.02.2021

SAP BI/BW HANA Senior Consultant

Abschluss: Bachelor of Engineering in Information Sciences
Stunden-/Tagessatz: anzeigen
Sprachkenntnisse: deutsch (Grundkenntnisse) | englisch (Muttersprache)

Dateianlagen

abhijeet_yatgiri_curriculum_vitae1.docx
abhijeet_yatgiri_cover_letter1.docx

Skills

SAP BW4HANA , SAP BI/BW
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.
SAP HANA
  • BW on HANA data modelling.
  • Modelling of HANA views for reporting – analytical, calculation and scripted views.
SAP Business Objects Data Services
  • Batch Job, Workflow, Dataflows.
  • File Formats, Data Stores, Custom Functions
  • Integration of BODS with SAP BI/BW (7.0) using 3.5 Datasources).
     SAP Business Objects (Beginner+)
  • 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.
  • 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.
March 2016 – May 2016:                  HANA Consultant for  IBP – Omnichannel Reporting at Adidas Group, Herzogenaurach, Germany.
  • 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.
January 2015 – March 2016:        BI/BW Functional Consultant for FCRS, NBS at Hexal AG (Sandoz), Holzkirchen, Germany.
  • 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.
January 2012 – October 2013:      BI/BW, IP & BODS, BO Consultant for Novartis OTC (Pune, India).
  • 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.
November 2010 – December 2012:    BI/BW, BO Consultant for Novartis OTC (Pune, India).
  • 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
Profilbild von Abhijeet Yatgiri SAP BI/BW HANA Senior Consultant aus Erlangen SAP BI/BW HANA Senior Consultant
Registrieren