Summary
Overview
Work History
Education
Skills
Timeline
Generic

Shiva Gunukula

Toronto,ON

Summary

Experienced SAP BW Consultant with a proven track record of over five years in SAP BW and BW on HANA environments. Recognized for delivering exceptional results in the analysis, design, implementation, and support of SAP BI systems. Passionate about leveraging data analytics to drive decision-making and optimize business processes. Seeking a challenging role where I can apply my analytical skills and enthusiasm for data-driven insights to contribute to managing global data warehouses, generating insightful reports and visualizations, and conducting in-depth studies. With a history of consistent recognition for outstanding performance and client satisfaction, I am eager to bring my expertise to your team and make a significant impact.

Overview

5
5
years of professional experience

Work History

SAP BI Consultant

Accenture Solutions Private
09.2021 - 09.2022

Client - TRINSEO, NA

  • Worked on a greenfield implementation project, designing and developing new data flows to replicate data flow from existing legacy systems into SAP BW/4HANA.
  • Installation of SAP Delivered Objects and performed Initial data loads and validated over-reporting.
  • Created the HANA Objects like ADSO, Open ODS, and Composite Provider.
  • Designed and developed optimized data models using SAP BW/4HANA, including InfoProviders, Composite Providers, and Advanced Data Store Objects (ADSOs), to meet business reporting and analytics needs.
  • Develop Composite Providers by integrating ADSOs and Calculation Views to fulfill user requirements and enhance reporting capabilities.
  • Implemented custom variables and data source enhancements using BAdIs (Business Add-Ins) and enhancement spots in SAP BW/4HANA.
  • Conduct impact analysis to assess the implications of customizations and enhancements on existing processes and data flows.
  • Design and implement analytical architecture on HANA, including Attribute Views, Analytical Views, Calculation Views, and SQL Queries to support reporting and analysis requirements.
  • Implemented real-time data integration solutions using SAP HANA Smart Data Integration (SDI) and Smart Data Streaming (SDS) to enable real-time analytics and streaming data processing.
  • Worked on performance optimization activities, including data partitioning, indexing, and data tiering, to improve query performance and reduce data processing times in SAP BW/4HANA environments.
  • Worked on ABAP code in Start, End Routine, and InfoObjects by InfoObjects in Transformation, CMOD, and Customer Exit.
  • Created custom queries as per stakeholder requirements, ensuring alignment with business needs, and published them on Power BI dashboards for end-user consumption.
  • Experience in handling SAPM BW Cutover activities.
  • Provide end-user training and knowledge transfer sessions to ensure a smooth transition and adoption of the new SAP BW/4HANA system.

SAP BW/BI Associate Consultant

Capgemini Technology Services
10.2018 - 09.2021

Client - PostNord, Sweden

  • Continued to excel in maintaining SAP BW applications, including daily tasks such as Data loading and Data validation.
  • Monitor and oversee daily data loads into DSOs and InfoCubes, ensuring data integrity and completeness.
  • Specialized in monitoring daily delta loads to key data targets within the SAP BW environment.
  • Proactively implement measures to prevent the recurrence of data loading issues, such as refining validation processes and optimizing data load operations.
  • Provide comprehensive support for the SAP POSDM module, leveraging existing SAP BW knowledge to troubleshoot issues, enhance functionalities, and ensure smooth integration with other modules.
  • Monitor and manage incidents using tools like HPSM and ServiceNow for tracking purposes.
  • Actively engage in discussions and meetings to address recurring issues, gather feedback, and propose solutions for ongoing improvement initiatives.
  • Provided L3 support for critical issues related to data discrepancies and transformation errors, adhering to defined SLAs.
  • Contributed to GDPR project by implementing Data Masking and Data Deletion logic ensuring data privacy compliance.
  • Handle data loads from various sources including flat files, non-SAP systems, and SAP systems, as well as data publishing to external systems using Open HUBs and APDs.
  • Participated in patching activities, including pre and post-patching actions, to maintain system integrity and security.
  • Following the DevOps support model, worked on developments, and enhancements, and offered parallel support for the system.
  • Served as an on-call resource, providing 24/7 support for the SAP BW system.
  • Work in alignment with AGILE methodology, contributing to iterative development and continuous improvement.
  • Possess basic knowledge of Information Lifecycle Management (ILM) archiving, particularly in resolving data storage issues related to SAP POSDM data.
  • Proficient in creating new BEx queries, selecting InfoProviders, defining filters, and implementing complex functionalities such as calculated key figures, restricted key figures, variables in formulas, and customer exit variables.
  • Experienced in building new data flows from scratch, both on SAP-delivered data flows and custom flows, to meet specific business requirements.

SAP BW/BI Software Analyst

Capgemini Technology Services
07.2017 - 09.2018

Client - AIRBUS, France

  • Responsible for maintaining the SAP BW application, ensuring its smooth operation, and resolving any difficulties or errors.
  • Contributed to the migration of objects from 3.x to 7.x, including Info Objects, Info Cubes, DSOs, Transfer and Update Rules, Process Chains, Query Objects, Web Templates, and so on.
  • Performed Unit testing, and Integration testing and provided support during the hyper-care period.
  • In case of any discrepancies found by the end users during their UAT, was responsible for providing solutions.
  • Due to limitations with the standard process of migrating objects, also performed Manual Migration of objects and recreated the new objects with the same functionality and calculations if any.
  • Once the migration is complete, thoroughly test the migrated queries to ensure that the objects behave correctly as expected in the SAP BW 7. x environment. An example of comparing the results to the original SAP BW 3.x queries to guarantee consistency and accuracy.
  • Document the migrated restricted key figures and any changes or enhancements made during the migration process. Provide users and administrators with training or assistance on how to work effectively with migrated queries and restricted key figures.
  • Conducted initial data load runs and set up delta pointers in the SAP BW environment. This included carrying out the appropriate procedures to feed the system with initial data sets and developing delta systems to track incremental changes efficiently.
  • Documenting solutions, processes, and configurations to ensure knowledge transfer and guide future troubleshooting.
  • Worked closely with cross-functional teams, including SAP BASIS administrators, functional consultants, and business stakeholders, to ensure alignment of technical solutions were aligned with business goals and priorities.

Education

Post-Graduation Diploma - Computer And Information Technology

Northern College of Applied Arts And Technology
Toronto, Canada
04.2024

Bachelor of Science - Computer Science

Jawaharlal Nehru Technological University
Hyderabad, India
05.2017

Skills

  • Experience in BI/BW Components like Info objects, Info providers, Hierarchies, Info Sources, Update Rules, Transfer Rules, InfoCubes, Multi Cubes/Multi Providers, ODS, Info packages, and aggregates using BW Administrative Workbench (AWB)
  • Deep knowledge of Generic Extractors, Info packages, Roles, Transports, etc
  • Experience in Enhanced Business Content Extractors
  • Experience in ETL from SAP R/3 systems using LO extract Structures
  • Expertise in Business content, Activating and enhancing InfoCubes, ODS, and InfoObjects
  • Excellent knowledge of SAP BW components like Data Source Enhancement, User Exits, OLTP extraction, Loading (Full/Delta Upload), Scheduling, Monitoring, Process Chains, Data Mart and Open Hub Service, Reporting Authorizations, and user profile maintenance
  • Knowledgeable in ABAP in start routines, end routines, update rules, and transfer rules
  • Experience in BEx Analyzer, BEx Browser, and BEx Query Designer for developing reports, and BEx Web Application Designer
  • Expertise in performance enhancement features such as Indexing, maintaining aggregates, and compression
  • Designing the backend architecture for reporting requirements and doing an end-to-end implementation of it
  • Front-end reporting using BEx Query Designer, BEx Web Analyzer, and Web Application Designer
  • Linking up BI systems with other SAP systems either as a fresh start or after source system copy back
  • Hyper care after Go live and production support
  • Involved as a key member of project teams through all phases of realization, go-live, and post-implementation support of SAP BW in FI, SD, and MM modules
  • Working knowledge of SAP ASAP methodology in the Software Development Life Cycle
  • Experience in working with standard and custom InfoCubes, InfoObjects, Info Sources, ODS, Multiproviders, Extraction Process (LO Cockpit, Generic Extraction), and transportation of business objects using the CTS tool
  • Experience in automating loads using process chains and use of BW Monitor to supervise data loading
  • Played the role of BW Specialist in the Sales & Financial BW enhancements and Capital Management BI Reporting
  • Have done Business content Installation in BI 70 for Sales and Financial Modules
  • Served as a Single point 1st level Contact for BW Production Support
  • Have conducted workshops with End users on BI functionality and features for the developed reports
  • 9 months of HANA exposure experience with exposure to hands-on proof of concept including Pilot and Prototype experience, and a full life cycle of HANA
  • Experienced in the implementation of BW 73 on top of HANA
  • Experienced in making presentations and holding client workshops, requirement validation, and group discussions

TECHNICAL SKILLS:

  • SAP BI: BI 7 X and BW 3 X, SAP Business Objects 30/31/ 40, SAP Hana 10 SP5
  • SAP ECC: ECC 60, ERP, S/4 HANA
  • Function Modules: SD (Pricing, Delivery, Billing), MM (IM, PP), FI-CO (GL), SAP POS-DM
  • Languages: BW ABAP, SQL
  • Reporting Tools: BEX Analyzer, Web Application Designer & Report, Power BI, SAP Microsoft Analysis for Office
  • Operating Systems: Windows, macOS
  • Ticketing Tools: HPSM, ServiceNow, JIRA and SAP SOLMAN

Timeline

SAP BI Consultant

Accenture Solutions Private
09.2021 - 09.2022

SAP BW/BI Associate Consultant

Capgemini Technology Services
10.2018 - 09.2021

SAP BW/BI Software Analyst

Capgemini Technology Services
07.2017 - 09.2018

Post-Graduation Diploma - Computer And Information Technology

Northern College of Applied Arts And Technology

Bachelor of Science - Computer Science

Jawaharlal Nehru Technological University
Shiva Gunukula