Sap Bw 4 Hana

Bhanu Prakash Kanneganti

SAP SAC/DWC, BW/BI Hana Lead/Architect/Sr Consultant

Loc: Woodbury Mn-55129

Tel: 412-***-****

Email: *******@*****.***

Skills:

SAP SAC, SAP DWC, SAP BW/4HANA, Native Hana, SAP BW, ABAP/4, S/4 HANA, SAP ECC, SAP R/3 as Architect, Lead and Sr Consultant

Functionality and Specialization

Reporting Tools-SAP BO, Crystal Reports, Power BI, Native HANA, WAD, Bex Query & Bex Analyzer, Snowflake

Subject areas:

OTC, ICO (Inter Company), STP, MTD, RTR, CRM, ARM, EHS, TM, GTS, COPA, FI-GL, PCA, CCA, MTO,

AR, AP, STO, EHS

Representative Clients

Parts Town - Chicago

3M – St Paul MN

Loreal US - NJ

BBTS-Pittsburgh

Harley Davidson/Deloitte - WI

Weyerhaeuser - WA

Deloitte & Touche, Nashville, TN

USAMMA- (IBM), Frederick-Maryland

Languages

English

Education, Licenses & Certifications

BE (Mechanical Engr.) -Dec 1990

LinkedIn: https://www.linkedin.com/in/bhanu-kanneganti-77995a24a

Professional and Industry Experience

15+ years of experience in SAP Analytics Cloud (SAC), Sap DWC-(Datasphere-Data Warehouse), SAP BW, SAP BW on HANA, SAP BW/4 HANA, Native HANA, SAP ECC and S/4 Hana.

Experience as SAP Reporting Analyst, Architect, Developer, Consultant with successful implementations and system evolution including configuration and customization capabilities. Over 10 years of experience in architecture, design, development, and implementation of SAP data warehouse solutions utilizing both SAP (ECC and S/4 Hana) and non-SAP datasets.

Skills in SAP Analytics process design and development to include SAP HANA design, development, integration, testing and deployment as well as SAP HANA technical architecture.

Build stories, dashboards, and reports utilizing SAP Analytics Cloud.

Design tables, views, analytical models, and replication task chains within SAP Datasphere and SAP Datamart

Support in the management of SAP Datasphere environment including scoped roles user security, Spaces and user access.

Hands on experience in all areas of SAP BW/4 Hana which includes Modelling, Extraction (LO, COPA, Finance, Generic extractor), BW reporting.

Design, develop, and implement SAP BW solutions using BW/4 HANA, BW Hana, Sap Data sphere and S4/HANA modeling techniques.

Skilled in backend development on SAP BW platforms (BW on HANA, BW/4HANA, Data sphere, SAP Analytics Cloud (SAC) and visualization tools and proficiency of the ETL process.

Exclusively worked in SAP BW/4 Hana modelling Involving Graphical Views, SQL Views for the business needs and solutions.

Mixed Modeling with Native HANA

Work with business and IT teams to gather requirements and implement solutions. Experience in creating schemas, creating HANA attribute, analytical, calculation views, input parameters.

Development HANA models using Studio and eclipse.

S/4 HANA, BW/4HANA Integration through ODP ABAP CDS views as Data Provisioning, CDS views experience.

Experienced in ABAP development to enhance / modify extractors.

Hands-on experience with building Core Data Services (CDS) views using ABAP development tools-ADT in Eclipse.

Proficiency in data modeling, ETL processes, and SQL scripting.

Self-sufficient, strong SAP Finance, Manufacturing process and functional knowledge in OTC, STO, FI, AP, AR, ICO, CRM, MTD, MTO, VISTEX, EHS, ARM, TM and GTS.

Completed 3 SAP BW (7.5,7.3,3.5/3.1/2.1C) implementation projects for FI/CO, COPA, FIAP, FIAR, CRM, BPS, BCS, SD and MM as a BW Technical Consultant/Architect.

Knowledge of SAP S/4HANA functional processes and integration with BW4HANA.

Develop and maintain BW/4HANA models, including Info Objects, ADSOs, Composite Providers, Info Cubes, ODS Objects/DSO, ADSO, Data Sources, info Packages, DTP, Process chains, Transfer & Update rules, Characteristics and Key figures, Transformations, Business content and Data extraction.

Experience on BODS, SLT & Experience of ETL for non-sap data source Using Informatica tools.

Acted as a techno-functional lead, driving the end-to-end delivery of SAP data and analytics solutions, ensuring smooth integration and Collaborate with cross-functional teams to gather requirements and deliver solutions that meet business needs

Strong understanding of SAP modules and data structures (e.g., S/4HANA, ECC). Excellent analytical skills and attention to detail, with a focus on data quality and integrity.

Extensively worked with BPS team for Forecasting and Budgeting.

Extensive experience in Data extraction from SAP and non-SAP source systems, including BODS, SLT, SDA, SDI, ODP Process.

Expertise in Front-End Business Warehouse Components like Bex Queries, Calculated Key figures, Restricted Key figures, Structures, Variables, Workbooks and Web Reports.

Experience with SAP Bex reporting BOBJ Suite of tools, Business intelligence Analytics and Reporting.

Experience with SAP BOBJ Webi, Dash Boards, Explorer, MS Analysis and Crystal Reports, SAP Bex Query Tool and BO Universes.

Involved in Full life cycle (analysis, design, integrating BI to BO, design, development and deployment) of Business Objects reporting Applications with Web Intelligence.

Experience with BI Analysis Process Designer, BI Web Application Designer for Reporting

Provide technical support and troubleshooting for BW/4HANA-related issues.

Experience in Creating Generic extractors & loading data using Flat files.

SKILLS

Data Visualization: SAP Analytics Cloud, Power BI, Business Objects, Bex Analyzer.

Data Warehousing: Hana SQL, SAP BW4HANA, SAP BW on HANA, S4HANA, SAP SAC Analytics, SAP DataSphere (Previously SAP DWC), SAP BW Hana Modelling

Data Orchestration & ETL: SAP BODS, SDA, SDI, Informatica, SLT

Project Management: Agile, Waterfall methodologies

Cloud Platforms SAP SAC, Snow Flake, Azure,

Others: JIRA, HPLM, Charm

PROFESSIONAL EXPERIENCE:

Nov 22 – Jan 2025, Parts town Chicago

Project # 08

Client – Parts town Chicago

Role – SAP DWC/SAC Sr Analytics Specialist

Worked as Sap DWC/SAC SAP Analytics Consultant with SAP Datawarehouse.

Engage with cross-functional teams to comprehend data needs and deliver solutions.

Analyze and modify data from diverse sources employing data engineering best practices.

Craft S/4HANA analytical views (CDS views), SQL scripts, and SAP Datasphere assets.

Design tables, views, analytical models, and replication task chains within SAP Data sphere.

Set up data wrangling rules to harmonize data coming from various systems, create data models to merge and create logical datasets for reporting using Qlik as reporting tool.

Support in the management of SAP Datasphere environment including scoped roles and user security & ABAP/4 DP connections to S/4 Hana system.

Construct and uphold stories, dashboards, and reports utilizing SAP Analytics Cloud.

Expand SAP S/4HANA CDS views to facilitate interfaces and report consumption.

Offer data insights and recommendations to back business objectives and strategies.

Uphold data quality, accuracy, and compliance by leveraging data standards.

integrating data from S4HANA and Syspro and harmonizing data to optimize for reporting.

Data load performance tuning, optimization of data loads Using DP agent.

Migrating the legacy Syspro database to SAP DWC

Nov 14 – Oct 22, 3M StPaul Mn.

Project # 07

Client – 3M

Role – Sap BW IT Datawarehouse Specialist-ICO BW Lead

Led the SAP BI team of 8 consultants for design and development activities in focus areas such as ICO, MTO, MTD, CRM, EHS, ARM, OTC, PTP & FIGL.

Led workshops for requirements gathering, scoping, validation, and negotiation discussions with business analysts, Process owners, and process champions.

Led the SAP BI team of 8 consultants for design and development activities in focus areas such as OTC, PTP, and Logistics. Developed technical presentations, solution proposals, and maintained key communications and coordination with key project stakeholders.

Modeled advanced Datastores (ADSOs), Composite Providers, info-objects, Bex queries, and ABAP Routines.

Created Native HANA modeling artifacts such as Graphical calculation views (graphical and HANA SQL scripted), for both master data and transaction data, Stored Procedures, Table Functions, and Scalar Functions, Input parameters.

Worked in SAP Hana on BW & BW4 Hana Modeling, analyzing & gathering the end user requirements and providing the optimized reporting solutions using Graphical and SQL views & SLT process.

Sap BW Hana And Snowflake platforms were used for availability of data models for Global BI reporting and Analyst reporting & analysis.

Designed & Created Sap BW Hana views to provide a total End to End view of the intercompany operations across the organization getting data from OTC, STP, TM, GTS subject areas.

Supported the ICO operations in deployments WW including Japan, APAC, EMEA, LATAM, USAC regions.

Provided CRM reports using sap Hana for 3M Scott Safety plants, provided Daily Variance Reports for daily plants operations in MTD, Manual pricing reports in MTO pricing, Global Phase in and Phase Out reporting for materials, in ARM (Advanced Returns management) reporting needs for EMEA for their returns process.

Provided Stabilization metrics for deployments for management review.

Create an IMPD Report for Materials Mining daily operation report.

Involved with End users/function teams for reporting needs like Complaints, Credit Reporting, Sample sales order Reporting, shipped not Billed, Manual Pricing, Sales Order reporting.

06 Jun 10 – 10 Nov 14, Loreal USA.

Project # 06

Client – Loreal USA NJ

Role – Sap BW Technical Lead Consultant

Gathered end-user requirements mainly in Purchasing, Sales & Distribution-SD, COPA, Cost Center Accounting (CCA), FIGL –Financial Accounting, AR, AP & Special Ledger.

Interacting with Business End users gathering business needs for reporting, converting their raw reporting needs into technical & functional specs.

Involved with End users/function teams for reporting needs like open orders, orders fulfillment, shortage of orders in SD purchase orders in MM, delivery, shipping and invoice details in Billing.

Installed and activated the SAP BW Standard Content for FIGL, COPA, AP, AR Info cubes, ODS, Info Sources, Info Objects for reporting & business purposes.

Customized the Business Content to meet specific Reporting requirements in the areas of FIGL, AR, AP, CO.

Involved in the Creation & maintenance of DSO’s, Info cubes, DTP, Transformations and ETL Process of data from SAP ECC.

Involved in Creation of Reports & dash Boards using Business Objects, BEX Queries and universes.

Created Process chains for the loading of Master Data & Transaction data and scheduled using

Control M.

Aug 08– May 10, BBTS Pittsburgh PA.

Project # 05

Client – Bayer Business Technical Services-Pittsburgh PA

Role – Sap BW Analyst Consultant

Installed and activated the SAP BW Standard Content for FIGL, CO, AP, AR Info cubes, ODS, Info Sources, Info Objects, and BEX Reports. Customized the Business Content to meet specific reporting requirements in the areas of FIGL, AR, AP, CO.

Involved in creation of Basic Cubes & Multicubes for reporting on Controlling Reports in CCA.

Created ODS for the Transaction data & Delta process.

Worked with BPS team and involved in designing the Transaction cubes for the planning layouts.

Involved with SAP BOBJ Webi, Explorer, MS analysis and Crystal Reports, SAP Bex Query Tool for reporting. Involved in Govt Reports for Mckesson Sales data.

May 06– Jul 08 Harley-Davidson/ Deloitte&Touche-WI.

Project # 04

Client – Harley-Davidson/ Deloitte&Touche-WI

Role – Architect/Technical Consultant

Gathered end-user requirements in financial areas, mainly in Consolidations (BCS), Business Planning & Simulation (BPS), Cost Center Accounting (CCA), AR & AP and created Reports using Bex Analyzer.

Installed and activated the SAP BW Standard Content for FIGL, AP, AR, FIAA, CO Info cubes, ODS, Info Sources, Info Objects, BEX Reports and Web templates. Customized the Business Content to meet specific reporting requirements in the areas of FIGL, AR, AP, CO, COPA.

Involved in creation of Basic Cubes & Multicubes for reporting on Consolidation (BCS).

Nov 03– Apr 06 Weyerhaeuser–WA.

Project # 03

Client – Weyerhaeuser - WA

Role – Sap BW Consultant

Gathered end-user requirements in financial areas, mainly in Consolidations (BCS), Profit Center Accounting (PCA), Cost Center Accounting (CCA) & Logistics-MM (Purchasing) and created Reports using Crystal Reports & Web Designer.

Involved in the creation of Customer Basic & Multi cube for Consolidation using Sap Cube 0ECCS_C01.In BCS, 0PCA_C01 in PCA & MM (PUR_C01).

Created DSO’s for the Transaction data & Delta process.

Worked on Customized Info Objects, Data sources, loading data into Info Cubes

Extensively used ABAP Conversion Routines in Transfer Rules and Update rules

Created Process chains for the loading of Master Data & Transaction data for Consolidations & Profit center Accounting and Monitoring data loads, Process chains and fixing the Errors.

Involved in creation of reports using BEX Analyzer. Used Free Characteristics, Filters, Restricted Key figures, and calculated key figures, Structures, Variables.

Created Web templates using Web Application Designer for Bex queries.

May 03– Oct 03 Deloitte & Touche, Nashville, TN I

Project # 02

Client – Deloitte & Touche, Nashville, TN Role – SAP R/3 BW Consultant

Gathered end-user requirements in financial areas, mainly in Consolidations (BCS), Business Planning & Simulation (BPS), Cost Center Accounting (CCA), AR & AP and created Reports using Bex Analyzer.

Installed and activated the SAP BW Standard Content for FIGL, AP, AR, FIAA, CO Info cubes, ODS, Info Sources, Info Objects, BEX Reports and Web templates. Customized the Business Content to meet specific reporting requirements in the areas of FIGL, AR, AP,CO,COPA.

Involved in creation of Basic Cubes & Multicubes for reporting on Consolidation (BCS).

Jan 02– Apr 02 USAMMA- (IBM), Frederick-Maryland.

Project # 01.

Client – USAMMA- (IBM), Frederick-Maryland.

Role – SAP ABAP/4 Consultant

User-Exit & Enhancements: Used a user-exit (Exit_Saplmo6e) in PM-work order, to include a custom program, which was used to check stock for different line items in work order in different locations and create Purchase orders in MM if no stock is found or create stock transfer orders, if stock is found. Developed enhancement for work order (IW32), which checks for stock availability for all the line items in the work order, using certain selection criteria.

Developed BDC programs using call transaction for Conversions, Transferring data for the sap transactions in MM, SM, for Stock transfer order and Purchase order, modification of Purchase Requisition & service order.

Contact this candidate