B.CHINNA VANNURU SWAMY
Jubail,Saudi Arabia
Summary
SAP Professional experience with 14 years of expertise in SAP BW, SAP BPC, SAP Analytics Cloud (Reporting & Planning), SAP Native HANA, S/4 HANA, and BW4HANA, complemented by advanced proficiency in Power BI and ABAP and Working with ESG ( Sustainability) Project Involved various stages of development, providing better integration with CPI to access ODATA to external tools like, SPHERA, BPMS, PCF and Bloomberg. Demonstrates a strong command of SAP BW – IP, SAP BPC, CPI, SAP Webi, and SAP Lumira to deliver innovative data solutions and optimise business processes. Adept at leveraging cutting-edge technologies to enhance analytics capabilities and streamline operations.
Overview
4
4
years of professional experience
2
2
years of post-secondary education
1
1
Certification
Work history
Project Technical Lead
Wipro
- Working as a Project Team Lead in Greenfield Sustainability project to implement SAP BW, SAP BPC Models to visualize DATAPOINTS in SAC Dashboards
- Developed BW Dataflows to display SABIC GHG, Energy KPIs in the SAC Dashboard
- Configured Sales Dataflow in BW to BPC to visualize Sales Revenue & Quantity
- Integrated BW SCM Transport modes data into BPC Environment
- Integrated BPMS Workflows into CPI through ODATA Service for decision making
- Implemented Product Carbon Footprint (PCF) data through ODATA into SPHERA tool using CPI
- Developed Automation process for PRODUCTS, PLANT, BUKRS into BPC
- Implemented BW SCM, Sales, GPM Data Points to display in BPC Environment
- Involved in business blueprinting and subsequent solutions for architecture design
- Developed ESG Models in BPC Environment to display Data Points from Affiliate level
- Collaborated with BPC team to develop Consolidation Model for Data Points
- Developed BW Models like Advanced DSO, Composite provider and BPC model, Bex Query to connect to SAC Dashboards
- Implemented ODATA Services for Read and Write functionality
- Developed Automated Process Chains for BW and BPC models to get files form ECM folders
- Worked on GPM master data to display KPIs on Plant and Affiliate level for all regions
- Involved in Configured Models, Dimensions, Members and Hierarchies
- Working in ESG Project to meet ESG Ratings in SAC Reporting tool
- Implemented SCM, Sales dataflows to consume Datapoints Values and comments from ESG
- Implemented PCF (Product Carbon footprint) Dataflows to consume Values from SPHERA tool
- Integrated Business Application Workflows into DWH to provide status of BPMS tool
- Integrated CPI functionality with DWH to access ODATA services to display KPIs from ESG
- Connected to MSSQL Server to extract Affiliate ratings and Datapoints values
- Achieved RPA BOT Project using RPA tool to automate data upload process to DWH
- Power BI Exposure
- Authored and published Power BI reports.
- Coordinated extraction of SQL Server data to Power BI and configure data connections.
- Performed troubleshooting and analysis of Power BI reports produced by other developers.
- Worked closely with data team to analyze data models for procurement of business data.
Technical Lead
PHILIPS
- Responsible for efficiently delivering the project and supervising the implementation team.
- Implemented Graphical Calculation Views
- Involved in design and development of Advanced DSOs and Composite providers.
- Exposing FI Data Models into SAC using live connection.
- Successfully created Sample Dashboard story in SAC using Canvas, Responsive pages and Digital boardroom.
- Worked on Hierarchies in SAC Dashboards
- Implemented stories using different features of SAC.
- Developed FI Model KPIs in SAC Story using Live Connection
- Developed BW HANA Models to generate External HANA Views
- Developed ADSOs to generate External HANA Views to be consumed in CV
- Expert level exposure to In-Memory Computing, Structure of SAP HANA studio, Configure Perspectives & Create Package, Enterprise HANA and BW on HANA.
- Creating Calculation Views of type Dimension/ Cube/ Cube with Star Join.
- Creating the Attribute Views /Analytical View and consumed into Calculation View
- Created Calculated Measures and Restricted Measures in Aggregation node to serve different business requirements.
- SAP Analytics Cloud (Reporting & Planning) Exposure
- SAC Technical Lead in SAP Analytics Cloud Implementation for BO Rationalization Project
- Managed all phases of Project from Requirement gathering, Blueprinting, Configuration, Integration Testing and Training to Go Live, Documentation, Post Go Live Support and end user training.
- Developed SAP Analytics Cloud Analytics Solution involving data wrangling, multi model set-up, model development, and story development, KPI Dash boarding for multiple streams of reporting and business units.
- Extensively involved into find the Reporting solution in SAC and providing Solution to the team
- Developed Dimension set build (including calculated and restricted dimension)
- Developed and maintained dimension properties to be leveraged in calculations
- Developed Complex advanced formulas using Data Actions Process
- Developed configured layout using Analytics Application
- Developed Complex Calculation Views to support SAC backend
- Configured connections between SAP HANA and SAC System
- Key point of Contact in communicating business requirements for reporting needs
- Worked with business and technical stakeholders in developing models, Dimensions, Members and Hierarchies
- Working in migration project from BO to SAC Reporting
- Migrating SAP Lumira and Webi Reports to SAC Reporting Solutions
- Involved in design and development of SAC Reports from BO tool
- Developed various SAP Modules Reports like, SAP PP, SAPMM, SAP FICO and SAP PM
SAP BI/HANA Consultant
LTI
- Worked in the BW Modelling tools in HANA Studio Eclipse to develop the Business Request
- Expertise in BW4HANA and ABAP
- Define work plan based on SAP Methodologies
- Use the ODP Data Provisioning to connect the SAP Data Sources
- Modeler the full Data Flow by creating Generic and Standard Data sources from ECC to replicate to SAP BW4HANA
- Expert in S4HANA Platform
- Created sample Models and stories with Geo maps
- SAP BO (Webi & Lumira) Reports Migration to SAC Exposure
- Migrated SAP BO Reports from Legacy to SAC Cloud Reporting tool
- Migrated 500+ BO Reports SAP Lumira and SAP Webi Reports from Legacy system to SAC Reporting Solution and displayed same KPI Values with SAC advanced options
- Migrated 50+ Celonis reports into SAC Reporting tool
- Developed SAP PP Complex Report like Two-Orders Scheduling Dashboard to give Production Planning feedback
- Developed few Complex Webi template-based reports using Advanced Analytics solution
- Developed complex advanced formulas using SAC
- Developed Configured layout using Analytical Application
- Configured Connections between SAC and BW4HANA System
- Developed Customize reports in SAC
- Migrated Complex Webi Reports to achieve same KPIs in SAC Environment
- Provided User training for APAC, AMEA and US regions
- Provided corporate training on SAC and HANA to new Business Users from all regions
SAP BI/HANA Consultant
BOSCH
- Implemented LSA++ architecture in the BW on HANA Landscape.
- Worked extensively on HANA modeling for BW Objects.
- Extensive knowledge and hands on Experience in LSA, LSA++, Composite Provider, Open ODS View, Advanced DSO using BW Modeling Tool in HANA Studio
- Created Data flows from CDS Views to Composite Provider
- Hands on Experience in creating CDS Views to consume ACDOCA table data from S4/Hana
- Experience in Import excel files to HANA Schema and used for Data Modeling
- Knowledge on ODP creation on SAP Extractors
- Knowledge on SLT Replication Server
- Generated SAP HANA Analytic Views for standard DSO’s in HANA and used them in calculations Views.
- Client: KEC
- Project: Development
- Role: SAP BI/HANA Consultant
- Environment: SAP BI 7.4 on HANA, ECC6, S/4 HANA, BEx Analyzer, Query Designer, AFO
SAP BI Consultant
TCS
- Worked on SAP HANA Data Modeling using Attribute Views, Analytic Views and Calculation Views
- Worked on ADSO to Load data to Reporting Layers.
- Developed Open ODS views and Advanced DSO Data flows
- Strong knowledge on data flows & workflows using SAP BI
- Extensively worked on Business Information Warehouse Info Cubes, DSO's, Info Objects, Info Sources, Multi providers, Data Sources, Transformations, DTP's.
- Developed all kind of Routines (Start, End) during the creation of Transformations & DTPs using ABAP.
- Client: Zimmer Biomet
- Project: Development
- Role: SAP BI Consultant
- Environment: SAP BI 7.3 on HANA, ECC6, BEx Analyzer, Query Designer
SAP BW- BPC & HANA, SAC (Reporting)Technical Lead
SABIC
Jubail, Saudi Arabia
2022.02 - 2026.02
- SAP Experienced BW, HANA, BPC Architect/Developer with 14 years of IT Experience and worked in different areas of SAP HANA & SAP BW4HANA, SAP Analytics Cloud (Reporting & Planning) and SAP BPC that involved various stages of development, providing better integration with CPI to access ODATA to external tools like, SPHERA, BPMS, PCF and Bloomberg.
- Working in ESG (Sustainability) Project to meet ESG Ratings in SAC Reporting tool
- Implemented SCM, Sales dataflows to consume Datapoints Values and comments from ESG
- Implemented Custom PCF (Product Carbon footprint) Dataflows to consume Values from SPHERA tool
- Integrated Custom dataflows for Water, Raw Materials related KPIs in PCF tool
- Integrated Business Application Workflows into DWH to provide status of BPMS tool
- Integrated CPI functionality with DWH to access ODATA services to display KPIs from ESG
- Connected to MSSQL Server to extract Affiliate ratings and Datapoints values
- Achieved RPA BOT Project using RPA tool to automate data upload process to DWH
- Developed Procurement dataflows from HANA CVs to DWH to accommodate changes with BPC Models
- Developed Sales dataflows for Revenue and Quantity results to display in SAC
- Extensively worked with Global Digitalization team to extract GD data into DWH to integrate with BPC ESG Models
- Experienced in SAC – Data Wrangling, Model Configuration, Story Development, Security Development
- Worked in SAP BW, BPC and SAC Project Implementation
- Experienced in SAP HANA – Calculation Views creation, Scripted views development, Creation of Calculated Columns and Measures
- Experienced in SAP HANA- Information Models, Attribute, Analytical and Cal views
- Experienced in BO tools like SAP Lumira, Webi & Celonis
- Strong Communication skills with business users in understanding strategic tools and key data information
- Expert in Data Provisioning techniques from S4HANA to BW4HANA System
- CPI - Integrations with BW Sustainability Project
- BPMS tool
- PCF (Product Carbon footprint) Tool
- SPHEARA tool
- Bloomberg Tool
Education
Master of Business Administration - Finance
Visveswaraya Technological University
India 2007.06 - 2009.07
Skills
- SAP Analytics Cloud
- SAP Native HANA
- S/4 HANA
- SAP BW
- BW4HANA
- BW on HANA
- Power BI
- ABAP
- SAP BW – IP
- SAP BPC
- CPI
- SAP Webi
- SAP Lumira
Certification
- SAP BW4HANA Certified
- SAP HANA Certified Consultant
- Power BI Consultant
Custom Section
- KSA, +966 576482845
- India, +91 9535389725
Personal Information
Title: SAP BW4HANA Certified SAP HANA Certified Consultant
Timeline
SAP BW- BPC & HANA, SAC (Reporting)Technical Lead
SABIC
2022.02 - 2026.02
Master of Business Administration - Finance
Visveswaraya Technological University
2007.06 - 2009.07
Project Technical Lead
Wipro
Technical Lead
PHILIPS
SAP BI/HANA Consultant
LTI
SAP BI/HANA Consultant
BOSCH
SAP BI Consultant
TCS