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


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.


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?