Sap Bw Data Modeling

Ravishankar Cheedepudi

*********@*****.***

US Citizen Mobile: 214-***-****

Summary:

Over 15+ years of IT experience in SAP BW, BW/4HANA, S/4, HANA, ABAP, IP and BO, Ability to work independently and as part of a team and In-depth knowledge of ETL Concepts.

Expertise in implementing SAP BW/4HANA and BW on HANA projects, involved in data base Migration and Green Field implementation Projects. Participated in Sizing and modeling of In-memory optimized objects.

Experience in HANA XSA, SAP Analytics Cloud, Datasphere, BPC Optimized and HANA Web IDE Development.

Well versed with S/4 HANA embedded analytics CDS Views, SAP FIORI/UX, OData based modeling with strong understanding of Business Requirements and System Analysis.

Extensive knowledge in LSA++ based data modeling for HANA and BW Implementations. Involved in design, development, and maintenance of Full Life cycle implementation Projects.

Designed and developed BW/4HANA transformations with AMDP Script and Used Table functions to replicate ABAP logic in HANA Views.

4 Full Life Cycles Implementations involved in Sizing, Security and Data Modeling in SD, MM, PP, Vistex, Retail, APO, FICO, and COPA functional areas.

Expertise in Business Objects 4.2, BODS, Design Studio, Universe Designer, Web Intelligence Dashboard Designer, Crystal Reports and OLAP Analysis. Built reports using SAP BO 4.1 and integrating with BI 7.5 on HANA.

Developed complex ABAP user exits for transaction/master data extraction and Bex variables and complex routines in start routine and update routines.

Good experience in Qlik view, Tableau and Power BI extraction from Bex Queries and HANA Views and building dashboard combining multiple sources.

Expertise in Performance Tuning of OLTP, Reporting Performance, Roll-up performance, performance analysis during Extraction/Data load and System Monitoring.

Technical Skills:

Applications : SAP BW (3.x to 7.5), SAP BW on HANA, BW4/HANA, ECC 6.0 ABAP, HANA XSA,

SEM-BPS, BPC 10.1, SAP BOBJ.

Reporting Tools: Query Designer, Analyzer, Web Application Designer, BOBI 4.0 (Information

Design Tool, Web Intelligence, Analysis Office, Lumira), Power BI, Tableau and

Qlik View.

Programming : ABAP, CDS Views, AMDP, Python, VBA and SQL.

Delloitte CA Jul 2022 to Till Date

Role: Sr.BI Consultant

Environment: SAP PaPM, HANA, BOBJ.

Worked as a PaPM Technical Consultant for Contractor pricing and allocations scenarios like Alfa and Downstream allocations.

Designed multiple Extracts in ABAP/Fiori to extract data from BW and S/4 to stage data for PaPM consumption. built Fiori interfaces to upload manual adjustments files and edit master data.

Created multiple HANA views (Graphical and Script based) and table functions for AO and crystal reporting needs.

Created Multiple AO reports and crystal reports based on HANA views and published in BOBJ environment.

Created multiple Fiori apps to publish BW AO workbooks in Gateway system, familiar with configuration in Fiori tiles along with single sign on connections to BW.

Toyota Motors, Plano TX Sep 2022 to May 2023

Role: Sr.BW/4HANA Consultant

Environment: SAP S/4, BW/4HANA.

Designed and End-End solution in BW/4HANA for poor performing CDS views in S/4 systems AO workbooks. Created multiple CDS extractors with CDC and built BW Hybrid data models replicating S4 security.

Created multiple CDS view based extractors with CDC annotations to extract data to aws data lake using Qlik replication server tools.

Designed and developed Project systems data models to extract Actuals and commitments data into Azure database using OData services created on Bex queries and BW data models. Created multiple AMDP based routines to flat WBS hierarchy in BW.

Worked on HANA 2.0 WEB IDE to create complex HANA Views to be consumed in Cloud, Tableau and other Front End Tools.

Created multiple Fiori apps to publish BW AO workbooks in Gateway system, familiar with configuration in Fiori tiles along with single sign on connections to BW.

MAKINO Corporation Feb 2022 to Sep 2022

Role: BW Senior Consultant

Environment: SAP BW 7.3,ECC 6.0.

Gathering requirements from the end users and converting them into functional and technical specifications.

Develop backend data models, including writing ABAP User exits and Transformation routines.

Building Bex queries and consume them into WAD reports and building Tableau dashboards.

Involved in S/4 HANA / BW/4HANA migration project planning and impact Analysis for BW system migration from MY SQL to HANA.

Robert Half International, Dallas TX Jan 2021 to Jan 2022

Role: BW4HANA Senior Consultant

Environment: SAP BW4HANA 2.0, S4 1809, BODS, Qlik Scene, BO and SAC.

Involved in BW4HANA 2.0 shell conversion project and performed analysis of existing landscape and creating a technical project plan to provide estimates and timelines for redesign and upgrade activities.

Coordinated with basis team to setting up system ready by analyzing the OSS notes in BW and source systems. Performed Scope conversion of BW Objects, Authorizations and HANA views from BW on HANA 7.5 to BW4HANA 2.0. Worked with security team to redesign authorizations.

Involved in redesign activities such as removal of redundant data layers, performance settings for data tiering and adding source system to master data objects to accommodate multiple sources systems master data. Developed BW on HANA hybrid data models including composite providers based on HANA views and ADSO’s.

Familiar with all upgrade Issues related to BW Scope conversion and migration of objects to new landscape and find alternate solutions for legacy dataflows. Coordinated with multiple teams to update BW source system changes to BODS, Qlik and BOBJ.

Created multiple CDS view based BW extractors to replace BW extractors and created multiple HANA views with Table functions to replace existing Bex based Qlik extractors to HANA view.

Lennox International, Dallas TX May 2019 to Sep 2020

Role: BW on HANA Senior Developer

Environment: SAP BW on HANA, BODS, Qlik Sense & Power BI, APO, IP and SAP ECC6.0.

Designed and developed solutions in various SAP projects related to Shipments, Demand planning and Quality notifications. Developed BW on HANA hybrid data models including composite providers based on HANA views and ADSO’s.

Analyzed Legacy SQL stored Procedures and related data models and e migrated to HANA based solutions using ABAP, AMDP Script, BW extractors and HANA Views.

Extensively used AMDP scripting to fine tune ABAP code in transformation and developed AMDP script to derive attributes from the model number masking patterns.

Designed and developed ETL routines in BODS, modified or created new Data Services jobs to extract data from SQL Server to HANA database.

Developed multiple Qlik sense and Power BI Dashboards by combining multiple sources Bex queries, HANA views, flat files and Oracle/SQL system tables. Also implemented end to end integration Qlik incremental or Historical Loads based on process chain status.

Created multiple HANA views for Inventory planning scenarios, consumed HANA views into Qlik dashboards and AO reports.

Worked on forecast IP PAK to enhance manual planning and planning functions with fox formulas. The planning reports are delivered using Design Studio and Analysis for Office tool.

Sealed air Corporation, NC Jul 2018 to May 2019.

Role: BW/4HANA Senior Consultant

Environment: SAP BW/4HANA, S4 HANA, CDS Views, BO 4.2, and SAP ECC6.0.

Involved in Greenfield implementation of BW/4HANA which includes Gap Analysis, Requirements gathering, Blue printing, Development, Testing, Reporting.

Designed and developed Hybrid data models combining HANA views with ADSO generated Objects and developed AO and BOBJ Reports.

Worked on BW4/HANA Migration Cockpit and converted BW Objects to the BW/4HANA Objects.

Designed and developed BW4HANA transformations with AMDP Script Used Table functions to replicate ABAP logic in Native side.

Simplified Oracle based BW data models and developed using HANA external/dictionary views and used in ABAP transformations. Developed Composite providers based on HANA Views and ADSO and created Bex and Webi reports.

Created Multiple webi and AO reports based on bex queries and HANA views and published through dynamic recipient based on company code / Plants.

Installed IMO content for LO Shipments, Cost center accounting-based business content and developed simplified Hybrid data models.

Developed Function module-based Hierarchy extractors and combined multiple hierarchies to Global customer-based hierarchy for reporting.

Involved in S4 HANA FICO POC for Europe and developed CDS Views and Fiori Apps and integrated with BW/4 HANA.

Rush Enterprises, TX Sep 2017 to June 2018.

Role: BW Analyst

Environment: SAP BW 7.5, BO 4.2, and SAP ECC/DBM 8.0.

Involved in Migration Project from BW 7.3 to 7.5 on HANA, Including Sizing, preparation, Cutover activities and Testing. Converted old data flow objects to new dataflow using new in memory business content.

Created Multiple webi reports using bex queries and HANA views and published through dynamic recipient based on branch roles. Created/Updated Design studio dashboards using Bex queries and Visual BI Components.

Installed IMO Inventory management data models and created dynamic No Sale, inventory turns and goods movement analysis reports.

Involved in Production Support activities and finetuned several process chains and ABAP extractors.

Involved in ECC/DBM 8.0 Upgrade project and responsible for all BW related extractors, ABAP user exits and upgrade cutover activities.

Worked on ETL Extraction using Data Services and Data stage.

PFIZER, Collegeville, PA Oct 2014 to Jun 2017.

Role: Senior Consultant

Environment: SAP BW 7.5, BO 4.1, and SAP ECC 6.0.

Worked on BW 7.5 on HANA migration project including data flow migration from 7.0 to 7.5 and converting BW data models to ADSO and Composite providers by replacing info sets and Multi providers and related ABAP code changes.

Worked on Migration of Bex to BOBJ conversion project, scope include Analysis, design and development of Bex and WAD reports to OLAP Analysis, Webi and Design Studio reports.

Re-designed Genealogy Model with delta capability to improve the data load performance and related simplifications. Designed Backend model and reconciliation process to validate the Genealogy data.

Involved in NLS Data Archiving project, was responsible for Identify and analyze the impact on Manufacturing, Quality and Packaging data models and develop the archiving process for those data models.

Designed and developed/enhanced Design Studio dashboards for Manufacturing Production schedule adherence and Operational Metrics. Developed backend data model, BEx queries for these Dashboards.

Responsible for analyzing and enhancing the data models and making Global Report changes for new international Rollouts.

Responsible for onsite and offshore Co-ordination for Development work in Migration of data flows and archiving projects.

Cristal Global, Maryland, MD Jan 2014 to Sep 2014.

Role: BI Lead Consultant

Environment: SAP BW 7.4 on HANA, BO 4.1, and SAP ECC 6.0.

Involved in Greenfield implementation of Cristal Global BW 7.3 on HANA project from feasibility analysis to implementation of BW 7.4 on HANA.

Designed and developed POC for Impact Analysis of existing ECC data source feeding to BW 7.0 and BW 7.4 on HANA. Analyzed COPA and other time stamp-based extractors for delta Issues and parallel maintenance.

Replicated sales volume plan LIS table data from ECC through SLT and created HANA calculated views and exposed as analytical index and loaded data into DSO.

Built open hubs and APD’s to migrate historical data from BW 7.0 to BW 7.4 on HANA.

Created Webi reports for operational and dashboards with Bex queries developed on BW 7.4 on HANA.

Redesigned existing BI data models in BI on HANA, migrated objects to HANA optimized DSO’s and SPO’s.

Resolved performance issues in BI data loads, Bex quires and BW Accelerators.

Front-line production support, to include help desk ticket resolution and on-call responsibilities.

Arizona Chemical, Jacksonville, FL Jun 2012 to Jun 2013.

Role: Senior BI Analyst

Environment: SAP BI 7.0, SAP BO XI 3.1, and SAP ECC 6.0, BPC 10.1.

Worked on Implementation of BI project with SD, FI, PP and Purchasing modules, Performed Requirement gathering, writing functional and technical specs for BW and Business Object Enterprise XI.

Responsible for complete BW Backend Design and Development, writing user-exits, extractors, Generic Data sources, Info cubes, DSO objects, Dataflow and Process chains.

Developed BEx and Webi summary and Detail Reports and created universes, classes and objects by retrieving the data from various data sources and defining the necessary connections.

Performed configuration of servers, setting up user security, scheduling reports, import/export universes and reports among different environments, developing Universes, Dashboards, Web Intelligence and Crystal reports

Developed complex web intelligence reports by combining multiple universes/queries. Formatting reports, generation of graphs etc as per user requested format.

Involved in migration and deployment of the universes and webi reports across multiple domains using Import wizard.

Cooper Industries, Aug 2006 to Jun 2012.

Role: Senior BI Developer

Environment: SAP BI 7.0, SAP BO XI 4.0, SAP ECC 6.0.

Worked on SAP Business Objects XI 4.0 implementation and developed Webi Reports, Summary and Detail Reports, Using the Summary as the source for the dashboard designer Detail is linked through Open Docs to view the User Selections from the Dashboard in Detail.

Implemented BW-HR reporting for HR users. Created report for Headcount, Payroll and Benefits BEX & WEB Intelligence reports. Activated BI content heavily for the first ever BW implementation for the company. Define configuration for the implementation.

Designed and developed MCER/WALK Analysis reports to analyze the price changes for sourcing team, data extracted on monthly basis using Analysis process design (APD) and loaded to summary level cubes and created Bex and WAD reports.

Worked on SAP Vistex (Chargeback’s and Customer Rebates) module and related BI extractors. Involved in configuration, extraction, enhancement of Bill backs and Claims Data sources and created summary and detailed level Bex queries.

Involved in SAP Net Weaver BI Accelerator (BIA) sizing and Implementation, familiar with all BIA day to day Issues and trouble shooting.

Involved in the 2004s & ECC upgrade projects, pre-checks, technology upgrade, prepare, post activities, prepared test scripts and involved in all testing scenarios like integration testing and stress testing at every stage of upgrade.

ALLSTATE Insurance, North Brook IL Feb 2005 – Aug 2006

Role: Senior BW Consultant

Environment: SAP BW 3.5, SAP 4.7, ABAP and VBA.

Key member of FDW phase2 development team. FDW Phase 2 project involved collection of enhanced data (Statutory & Age of Development) from Premiums, Claims, Sales, Expenses and Profitability.

Developed Intercompany reinsurance prototype to replacing the statutory reporting that comes from the Orion Database.

Developed Accident year model and Report Year long tail model triangles for analyzing Estimating loss, calculating averages and trends, estimating claim settlement using the Bex, Affinity 3.3 and VBA Macros.

Created comparison macros using VBA so that the QA team could use them to validate the reports in development and Staging systems.

Trained offshore development team and super users on documentation and different functionality in workbooks.

Participated in Daily status meetings and updated all the participants about current status, issues encountered and remedies.

Assigned and tracked all the tasks that were assigned to the offshore team (5 offshore and 2 onsite resources) on a day-to-day basis. At onsite - handled all the high priority assignments and critical issues.

Written master data extraction ABAP interfaces to download sales representative hierarchy

Information to the application server.

Education: -

BS in Mechanical engineering.

Certifications: -

Sap BW 2004s Certified.

Introduction to Software Development on SAP HANA

Contact this candidate