Freelancerprofil: SAP HANA/BW/BI Senior Consultant, große internationale Erfahrung - CIO-Ansprechpartner d-TREE GmbH in Lüneburg

SAP HANA/BW/BI Senior Consultant, große internationale Erfahrung

CIO-Ansprechpartner d-TREE GmbH | Lüneburg
Um den Freelancer zu kontaktieren, müssen Sie eingeloggt sein
Kategorie(n): Consulting



  • Englisch (Muttersprache)


Shiva Kumar M
SAP HANA/BW/BI Consultant

Professional Summary

 SAP BW/BO/HANA Certified with 9+ years of SAP BW, BOBJ, BW on HANA and HANA for multiple industries like Oil & Gas, Mining, Digital, Electronic, Manufacturing and Retail Industries.
 Experience in Information Technology industry with SAP BW (BW/4HANA 7.5, BW 7.4, BW 7.3, BI 7.1, BI 7.0, and BW 3.5), SAP HANA, SAP BOBJ (4.1, 4.0), Integrated Planning and SAP ECC.
 Coordinated with business/users and responsible for deployment & Go-live (Review/approve transport, solutions, help troubleshoot and coordinate any issues with basis and functional teams).
 Experience in Migration of BW systems to BW on HANA.
 Experience in SAP BW Implementation, Support, Upgrade and Rollout.
 Experience in full life cycle implementations following LSA++, Agile methodologies which involves Requirement Analysis, Business Blueprinting, Design, Realization, Data Modeling, Data Extraction, Unit Testing, Integration Testing, Training Documentation, Production Support, End user training and Go-Live check.
 Expertise in SAP HANA Modeling of Attribute Views, Analytic Views, Calculation Views, Procedures, Decision Tables, Package & Schemas and Analytic.
 Involved in creating Advanced DSO’s, Composite provider, ODP using BW Modelling perspective.
 Extensively worked in SAP HANA Data provisioning activities to provision the data from SAP & Non-SAP sources systems using SLT Based replication and BODS ETL based.
 Expertise in SAP HANA to BW & BW to HANA model importing mechanism and provided solutions for reporting BW on HANA Implementation projects.
 Extensively worked in BI 7.X, BW 7.3 End to End implementation & production support projects
 Experience in SAP BW Data modeling of HANA Optimized Info Cube, ADSO, Composite Provider, SPO, Data source, Transformation & DTP, Process Chains, Open Hub Destination (OHD), and APD.
 Extensively worked in SAP BW Data Extraction from Multiple SAP and Non SAP (Legacy) Systems using BI Content Extractions LO (SD, MM, PP, QM, and PM), FI/CO, Flat File, and Generic Extraction.
 Designed and developed queries for reporting using BEx Analyzer, Query Designer and Web Application Designer
 Extensively involved in Data load & Report Performance tuning Techniques (Partitioning, Parallelization, Aggregates, Cube Compression, Line Item Dimension, and Indexing).
 Extensively involved in SAP BI-BW Production Support in handling daily batch jobs, load failures, delta failures, Performance issues, BIA issues, system issues, reporting issues and enhancements of existing flows.
 Extensively worked in SAP Business Objects (BO 4.1, BO 4.0) tools like Universe Designer, Information Design tool, Analysis for office and WEBI.
Certification details -

 SAP BW/BO (C_TBI30_73) Certification completed
 SAP HANA (C_HANAIMP142) Certification completed


ab September 2019
3 Monate Vorlaufzeit für den Projekteinsatz-ggf. früherer Einsatz möglich
Umfassende Erfahrung in internationalen Projekten/On-Site Projekten, Projekt-Einsätze in Canada, Frankreich, Neuseeland, Ungarn, USA, UK, Australien, Niederlande


Professional Experience

 Working as Senior Consultant in Bangalore from Feb 2015 to till Date.
 Worked as Senior Analyst at Accenture services Pvt. ltd, Bangalore from Aug 2009 to Feb 2015.
 Worked as Analyst Programmer at IBM India Pvt. ltd, Bangalore from Aug 2008 to March 2009.


• SAP BW3.5, BI 7.0, BI 7.1, BW 7.3 & BW 7.4, BW 7.5
• SAP HANA 1.0 SP6, SP7, SP9 (HANA Studio)
• Business Explorer, Web Application Designer.
• Business Objects 4.0 (Information Design Tool, Universe Designer & Webi)
• SAP ECC (SD, MM, FI/CO, QM, PP and PM)

Professional Experience
Projects: Fonterra, New Zealand Nov 2017 to till date
Role: HANA/BW Consultant

 Analyzing the business requirements coming through change requests from the business users and translated into Functional Design and Technical Design Documents.
 Attended interaction meetings with the project team members and end users to understand the requirements.
 Implemented CR’s for enhancement of data sources, reports and BW HANA objects.
 Involved in development of HANA objects Attribute Views, Analytic Views, Calculation Views to implement the real time data reporting directly from ECC through HANA and BW.
 Monitoring the data loads using ST13, RSPCM and fixing the load issues.
 Handling incidents without breaching SLA’s, used service now as supporting tool.
 Attending the Weekly Project status meeting to discuss about the Open tickets, Open issues and any planned maintenance activities.
 Worked with ECC, DB Connect and BODS to bring the SAP and Non SAP data into BW
 Extensive experience in SAP SLT to acquire the data into SAP HANA also involved Partitioning of bigger tables and filter the data also working on SLT DB upgrade.

Projects: Staples, Netherlands Nov 2016 to Oct 2017
Role: HANA/BW Consultant

 Created design specification document, standard modeling documents for HANA and front end requirement documents uploading on APSE based on functional specification/mock up document and also involved in discussions to understand the functional specification.
 Developed in the areas of SD, MM, FI and COPA.
 Worked on migration of BW systems to BW on HANA.
 Worked on Pre and Post Migration activities while migrate to BW on HANA.
 Extensively worked on creation of Composite Provider and Advance DSO’s for latest developments.
 Developed Information Models such as Attribute Views, Ana lytic Views and Calculation Views according to the business requirements.
 Created Calculated Columns, Restricted Methods, Variable and input parameters.
 Involved in testing both Unit/System test, System Integration Level testing and Pre-UAT during implementation.
 Developed reports of Click and Collect, Stock Turn, Daily Sales and Delivery Report, WAC and Monthly Reporting Staples Advantage BE for roll-out of Benelux.

Projects: Harman, Hungary Sep 2016 to Nov 2016
Role: BW Consultant

 Interacted with business users and generated functional documents at client office.
 Created Technical design document based on functional specification document and also involved discussions with BPA (Business process Automation) to understand the functional specification.
 Worked on creation of custom info Objects and DSO based on client naming convection and data flows as per report requirement.
 Developed reports for the area of Inventory, SD, Billing & Shipment.
 Involved in Generic extraction, extracted the data from the master data tables and transaction data tables and created the corresponding objects and DSOs with the data flow.
 Developed the Backlog Quantity reports to calculate Inventory unrestricted stocks, MTD Shipments of stock quantity, Backlog orders of Open/Delivery quantities and MTD projection reports as per the business logic.

Project: Miller Coors, USA Feb 2015 to Aug 2016
Role: BW/BOBJ/HANA Consultant

 Analyzed the business requirements and converted them into Functional design and Technical design documents.
 Worked with ECC, DB Connect and BODS to bring the SAP and Non SAP data into BW.
 Worked on Various information models like attribute views, Analytical views and calculation views.
 Created Input parameters and variable parameters.
 Involved in the implementation of BW for RTR and OTC modules.
 Created BO Web Intelligence report for P&L structure reports.
 Created APD’s by taking source as BEx queries and sending actuals to BPC system for planning.
 Worked with BODS functionalities Project, Job, Work flow, Data flow, Data store to import the tables from ECC, Legacy systems to HANA.
 Executed data extraction transfer loading (ETL) using SAP data services 4.0 to import csv files into SAP HANA tables.
 Involved in Pre/Post Go-Live activities for Shenandoah, FBoR and Golden releases.

Project: Shell UIMS, USA Jun 2014 to Feb 2015
Role: BW/HANA Consultant

 Involved in Requirements gathering and preparing the Functional design and Technical design.
 Involved in development of HANA objects Attribute Views, Analytic Views, Calculation Views to implement the real time data reporting directly from ECC through HANA and BW.
 Created/maintained Schemas and packages, worked with Analytical privileges.
 Performed data modeling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.
 Developed reports for the area of Logistics and FI.
 Created Universe on top of HANA calculation views of column views and developed the Webi reports and dashboards using IDT (Information design tool).
 Migrated HANA content from development, testing environment to Production environment using delivery units.
Project: Talisman Energy AO, Canada Jan 2013 to May 2014
Role: Sr. BW/BO Consultant

 Analyzed the business requirements coming through change requests with the business users and translated into Technical Design Documents.
 Participated in technical design and build reviews, etc. with client team
 Worked closely with the business users while resolving issues at Onshore.
 Involved in the developments and enhancements of BW objects as per CRs.
 Involved in MEC (Month End Closure) activities which includes Data loading and Monitoring, fixing the loading issues and refreshing the reports
 Handled the tickets of priority 1, 2 and 3 by following (SOP) Standard Operating Procedures and never missed the (SLA) Service Level Agreement.
 Resolved customer reported ticket through mail and phone.
 Perform production change work during change windows as well as providing on call support as required by the team.
 Involved in monitoring the process chains by using T-code - RSPC, RSPCM and ST13.

Project: Talisman Energy SI, Canada June 2011 to Dec 2012
Role: Sr. BW/BO Consultant

 Involved in BI implementation for FI-AR, AP and AA, GL, CCA and PS modules.
 Worked for WAVE1 in Design & Build.
 Based on the report requirement documents created data flow functional documents and diagrams for whole backend and frontend requirements.
 Integration of legacy and SAP ECC data in BW system.
 Worked on BEx Reports, Workbooks for PS & CCA.
 Involved in all cutover activities while moving objects up to production.
 BW query integration with BO and created reports on BO Webi.

Project: BP FBW, U.K Feb 2010 to May 2011
Role: Sr. BI Consultant

 Involved in preparation of Technical Design, Development and Testing.
 Involved in functional KTs to understand the business.
 Worked for R1 in Design, Build &Testing.
 Involved in the implementation of BI for FI module.
 Created APD and Process chains.
 Created unit test cases and were uploaded into QC.
 Worked on QC to fix the defects in IT1, IT2, IT3 and IT4.
 Performance tuning of queries using aggregates, table partitioning, indexing of Info Cubes.
 Created queries and broadcast settings based on Exception.
 RRI reporting.

Integrated Planning:
 Created Real time cubes, Aggregation levels, Filter, Planning functions and planning sequences.
 Created Characteristic relations using Top down distribution and also worked with Data slices.
 Worked with Planning functions (Copy, Repost, Delete, Forecasting, Delete invalid combination, unit conversion and Currency conversion).
 Worked with Flat file load of Budget, Forecast and Plan data into the Real time cubes.
 Maintain Master data and created variables in IP.
 Created Input Ready Queries for plan data.

Project: BHP Billiton, Australia Aug 2009 to Feb 2010
Role: BW Consultant

 Involved in the implementation of BI for SD, FI, PM modules.
 Extensively Involved in activating the business content Objects.
 Gathered reporting requirements and designed the data flow from SAP R/3 to BI for specific functional areas like Finance, Sales & Distribution.
 LO Cockpit (LBWE) initialized the setup tables. Scheduled and Implemented delta mechanism for periodic loads.
 Setup the Statistical Setup for the LO-Cockpit and used the V3 Update for Delta Management.
 Involved in Cutover Activities to get UAT from Business.
 Created Status Tracking Reports for Daily Batch loads, Adhoc loads and historical Data loads updated on e-room.

Project: Total, France Aug 2008 to Mar 2009

 Attended boot camp within organization and taken KT from superiors
 Involve in both the activities monitoring and production Support
 Data loads monitoring for daily, weekly and monthly loads through process chains
 Analyze the errors in the data loads
 Involved load monitoring using RSPC, RSPCM, RSMO, SM37, SM50 and SM58
 Create new process chains for both master data and transactional data chains also created Meta chains.
 Worked existing reports on BEX Analyzer (Using free characteristics, key figures, calculated key figures, variables, Exceptions etc.,) in SCE project based on request from the user.

Stunden- und Tagessatz

Stundensatz: 110 EURO

alles inklusive: On-Site Unterbringungs-Kosten, Fahrtkosten


Der Senior Consultant kommt aus Indien und kann On-Site in Deutschland arbeiten.

Bitte loggen Sie sich ein oder registrieren Sie sich, um das Freelancer zu kontaktieren.
Neu bei projektwerk?