Sap Bw Data Modeling

Location:

Posted:

September 09, 2024

Resume:

Professional Experience Summary:

• Around ** Years of experience as a Techno functional on application development and implementation, support, upgrade and maintenance in SAP BW4HANA, Native HANA, S/4 HANA Embedded Analytics, SAP HANA/ABAP, BEX, BO, SAP BODS which includes 5 Full Life cycle Implementations and 6 Support projects in SAP BW/BI, HANA and BW4HANA. Worked in different roles like Individual contributor, SME, Manager, Architect. Experienced in various industries like Manufacturing, Telecom, automobile and insurance, Pharma, Automobile and retail. Good understanding in SAP functional modules like MM, SD, FI, PP, HR, MDG and CRM Services.

•Strong in BW Related ABAP and Development of Extractors based on CDS Views and AMDP Routines.

•Good Understanding in SAP Datasphere and SAP SAC.

•Successfully implemented multiple full life cycle SAP BW/HANA, BW4HANA and BO projects as a technical lead, architect, developer including new implementations, rollouts, mergers/separations, and upgrades.

• Exceptional skills in gathering business requirements, finalizing functional specifications, preparing gap analysis, design and develop technical specification documents, realization, cut-over plan, support, and end user training.

• Expertise in ETL process, data modeling, and reporting by using standard delivered content as well as custom created objects, analyzing and solving problems, improving system performance by following standard best practices and benchmarks.

• Data Modeling: HANA Base Data model for Creating CV, CDS Views and Table functions. Proficient in BW data modeling, ADSO design, Composite provider design, Semantically Partitioned Objects, Graphical Data Flow Modeling, HAP, Smart Data Integration, Administration Expertise on Repartitioning, Remodeling and Data Achieving.

• Transformation: Experience in building custom transformations base on Start routine, End routine and Export routine.

•Enhancements: Data source enhancements in R/3. Writing user exits to populate data to enhanced fields. Writing customer exits on BEx Variables.

•Performance Tuning (Loading): Experience in performance tuning on data load including data modeling techniques, deleting Indexes, creating Indexes. Maintain Data package sizes, Refreshing DB Statistics.

•Worked on system upgrade and migration activities from BW 3.5 to BI 7.0, BW 7.3 to BW 7.4 on HANA, BW 7.3 to BW 7.5 on HANA SPS03 (SPAU/SPDD Transactions)

•Worked on S/4 HANA CDS modelling on different modules (MM, SD and FI).

•Implemented end to end application using S/4HANA CDS Views, SAP BW4/HANA, SAP BW on HANA and Enterprise HANA.

•Having Experience in writing AMDP, creating Open ODS views, DB connect data sources.

•Very good knowledge on HANA modelling like scripted/graphical calculation views, table functions, Procedures, Virtual table, Virtual Procedures. Extensively worked on SAP HANA CDS Modeling - HANA Calculation views, HANA CDS Views.

•Extensively worked on S/4 HANA CDS Views, Enhanced the Existing S/4 Hana Simple Finance CDS Views, Accounts receivables, Accounts payable, Treasury and Sales overview reports.

•Designed the Dynamic Reporting Facility for Business Users consuming CDS Views direct from "Analysis for Office" that really helps business users understanding and leveraging the existing data without new development effort/budget.

•Customized the existing CDS views by adding new fields/joining multiple CDS views building the master report.

•Developed and Design Analytical consumption views, Composite views and Basic views using Hana Developer Studio using ABAP Perspective.

•Good working knowledge of Associations and Annotations for Consumption view development and Reporting prompts using Annotations Base CDS Views

•Consume CDS data model used by SAP S/4HANA can be considered a successor to SAP HANA Live reports as CDS view as source provides front end reporting using BO WEBI

SAP BW/HANA:

•Experience on end-to-end implementation of BW/BI projects that includes Standard/custom data source extraction, Data Modeling, development of BW data flow, ABAP routines, development of Bex query’s, Custom Workbooks and Analysis for Office reports and HANA Modeling.

• Worked on 6 Implementations projects, 4 support projects and 2 upgrade projects.

•Involved in modelling with respective to SAP BWoH using composite providers, Advance DSO, HANA Optimized DSOs and Open ODS.

•Involved in Web Services extraction for Non- SAP source systems, File processing.

•Worked on BWHANA migration projects.

•Worked on Data Modeling, Bex Reporting and Data Extraction.

•Experience in reporting tools like SAP BO Webi, SAP AFO and Power BI.

•Involved in Installing Business Content for Standard Info Objects, Info Sources, DSO, Info Cubes related to project. Developed new objects as and when required.

•Extensively involved in setting up of procedures for extracting data from SAP R/3 by using Generic Extraction and customizing LO Cockpit by using enhancements.

•Proficient in understanding client business process and requirements gathering.

S4HANA Embedded Analytics:

•Experienced S4HANA Developer with Strong experience in CDS View and Fiori Apps

•Strong Functional knowledge on SAP S4HANA P2P, STOCK, FINANCE, SALES and DISTRIBUTION and MTS.

•Hands-on experience with SAP S/4 Embedded analytics specifically with Core Data Services (CDS) views development technique.

•ABAP CDS objects (Core Data Services) and publishing as a OData services.

•Strong experience with Development Tool Kit using HANA studio or Eclipse.

•Worked on Query browser and Dashboard overview pages

SAP ABAP & BW Related ABAP:

•Proficient in Routines like Start Routine, End Routine, Expert Routine and Field level Routine.

•Proficient in Data Source Enhancement Using CMOD and BADI.

•Extensively Involved in Generic Data source Using Table, View, Info set Query and Function Module.

•Customer Exits for Variables using CMOD and ABAP Classes and Methods.

•Involved in SAP ABAP reports like classical, interactive and ALV reports.

•Involved in Data Migration using LSMW, BDC program and BAPI.

•Involved in Smart forms and SAP scripts.

•Involved in AMDP in Start Routine & END Routine.

•Involved in creation of AMDP Procedures to reuse in other Methods of the class.

Technical Skills:

Elements

Particulars

Primary Skills

SAP BW4HANA, Native HANA, ABAP, CDS View and SAC

Languages

ABAP/4, SQL, Python

Reporting Tools

SAC, Power BI, Bex tools, SAP BO tools

Databases

SAP HANA, Oracle and Microsoft Azure Synapse

Domain Knowledge

Oil & Gas, Industrial products, FMCG, Utilities, Automobile, Manufacturing, Health Care, Insurance.

ERP

ECC 6.0 (MM, FI, P2P), SRM, CRM, HCM

Other Applications

Azure DevOps, Snowflake, SAP Solution Manager.

Data Provisioning

SAP-SLT, ODP, SDA, SDI

Educational Qualification:

Master of Computer Applications (MCA) from Bharathaiar University.

BSc Electronics from Nagarjuna University.

Certifications:

SAP Certified on BW4HANA (C_BW4HANA_14).

SAP Certified Development Specialist - ABAP for SAP HANA 2.0 (E_HANAAW_16)

SAP Certified on HANA 2.0 (C_HANAIMP_13).

Projects Summary:

Sno

Company name

Project

Duration

Designation

Mak Technologies

Cisco

Jan 2023 to Till Date

SAP BW4HANA Consultant & Native HANA

TCS

McKesson

June 2022 to Dec 2022

SAP BW4HANA & Native HANA

TCS

Mars

Aug 2021 to May 2022

SAP BW4HANA Consultant & Native HANA

Capgemini

PSA

Sept 2020 to July 2021

SAP S/4 HANA Embedded Analytics & BW

Capgemini

TE Connectivity

Nov 2019 to Aug 2020

SAP BW/HANA/ABAP Sr Consultant

Capgemini

SATAIR

Jan 2019 to Oct 2019

SAP BW4HANA/ABAP Sr Consultant

Capgemini

Nokia

Aug 2017 to Dec 2018

SAP BW/HANA/ABAP Sr Consultant

Capgemini

SPARK

Oct 2016 to July 2017

SAP HANA Consultant

Capgemini

Alcatel Lucent

Nov 2012 to Sept 2016

SAP ABAP Consultant

Capgemini

Valeo

Feb 2010 to Oct 2012

SAP ABAP Consultant

Capgemini

HP Astro Project

Aug 2006 to Dec 2009

SAP ABAP Consultant

Professional Experience:

Client : Cisco, CA

Environment : SAP BW4HANA, Native HANA, S4HANA, SLT, SAC

Role(s) : Sr SAP BW HANA Developer

Duration : Jan 2023 to Till Date

Roles and Responsibilities:

Worked on complete design and develop of HANA (Native HANA) Models, BI/BO Reports and Tableau/Power BI Dashboards.

Worked on the advanced options in SAP HANA like Procedures, Input Parameters, Variables.

Designed, Developed and Debugged various Information Models (Attribute, Analytic and Calculation Views) to model data for reporting.

Worked on OTC, PTP Flow with requirements like extended sales history reports.

Worked on SQL Script views/models, Table functions and stored procedures.

Experience in Importing BW models Info Cube, DSO in HANA as Analytical view.

Built BW data models to extract data into ADSO layer and make it available for HANA.

Designed and developed BWHANA to bring in the data through ETL from models from Non-SAP Source systems into and leverage those table in stored procedures.

Worked on Performance Tuning, optimizing existing Cal Views, Procedures, SQL logics.

Experienced in data modeling and preparing datasets, merging, appending, custom hierarchies, custom calculations, groupings, formatting values, data wrangling, dimensions and measures

Good Exposer in visualizations and their usage charts, tables, maps, filters, dropdown menus, hiding functions, interactive objects, pictures.

Interview process owners and other stakeholders to identify and understand business processes,

workflow and business rules of Pacific Coast Companies in the respective functional areas.

Translate business requirements into functional and technical design document.

Help to identify the defects in each Landscape (Development, Quality, Preproduction and

Production environments) and resolve them.

Working extensively on HANA Views in coordination with the team to keep the business

functionality intact.

Work with various senior technical managers and staff within the Information Services and

Technology organization, which includes SAP functional areas. Involved in creation of Functional and Technical specification for data models based on SAP HANA 2.0.

Considering a new requests & Enhancements towards to User requirements.

Client : McKesson

Environment : SAP BW4HANA, Native HANA, S4HANA

Role(s) : Sr SAP BW HANA Developer

Duration : June 2022 to Dec 2022

Responsibilities:

Design and develop Native HANA Models - Calculation views with Data Category Dimension and Cube for Master data and Transaction data, calculated and Restricted Columns, Filters using input parameters as per the report development

Developed and implemented of SAP Analysis Process Designer (APD) applications.

Created Data Sources Read data from Info Providers, Attributes of a Characteristic, Query, Flat Files, Database Tables and

Created Transformations - Filter restricted amount of data, Aggregate Data, Join data from different Data Sources, ABAP Routines, Formula,

Sort data, etc. and Data Targets -Write data directly to Data Store Objects (DSOs), Flat files

Maintain and support existing APD Applications

Involved in Business requirement gathering in Sales and Distribution, OTC, Order management and finance with application development in XSSH Process and Pharma Sales History Processing logic and consumes Inventory, Purchase Order, Sales Order, Billing, customer, material, plant, vendor, pricing, purchase and closed Truck.

Involved in order to cash requirement Legacy & Flex SWR (Standard Wholesale sales Reporting).

Applied advanced data modelling techniques in Native Hana, including currency conversion, variables and input parameters. Implement decision automation using business rules.

Monitor, investigate and optimize data models and reporting performance on SAP HANA. Advise on modelling approach and tools to achieve optimum performance.

Experience of managing complex and large datasets in a HANA (and BW) environment.

Modify existing SAP HANA Models according to the requirements to optimize it to run it on the new SAP HANA platform and to improve its performance according to the best industry standards.

•Worked on S/4 HANA CDS modelling on different modules (MM, SD and FI).

•Implemented end to end application using S/4HANA CDS Views, SAP BW4/HANA, SAP BW on HANA and Enterprise HANA.

•Having Experience in writing AMDP, creating Open ODS views, DB connect data sources.

•Extensively worked on S/4 HANA CDS Views, Enhanced the Existing S/4 Hana Simple Finance CDS Views, Accounts receivables, Accounts payable and Sales overview reports.

•Designed the Dynamic Reporting Facility for Business Users consuming CDS Views direct from "Analysis for Office" that really helps

•business users understanding and leveraging the existing data without new development effort/budget.

•Customized the existing CDS views by adding new fields/joining multiple CDS views building the master report.

•Developed and Design Analytical consumption views, Composite views and Basic views using Hana Developer Studio using ABAP Perspective.

•Good working knowledge of Associations and Annotations for Consumption view development and Reporting prompts using Annotations Base CDS Views

•Consume CDS data model used by SAP S/4HANA can be considered a successor to SAP HANA Live reports as CDS view as source provides front end reporting using BO WEBI

•Extensively worked on SAP BW4/HANA for BW modelling.

•Having Experience in writing AMDP, creating Open ODS views, DB connect data sources.

•Very good knowledge on HANA modelling like scripted/graphical calculation views, table functions, Procedures, Virtual table, Virtual Procedures.

Hold regular technical team meetings to determine progress and address any questions or challenges regarding projects.

Client : MARS.

Environment : SAP BW/4HANA, Native HANA, ECC.

Role(s) : Sr SAP BW HANA Developer

Duration : Aug 2021 to May 2022

Responsibilities:

Use the BW Modeling Tools in HANA Studio 7 Eclipse to develop the Business Request.

Customize SAP functionality to satisfy business unit requirements, scope, plan for risk and issues.

High level Architecture project included creation of new SAP BW Composite Provider for several processes.

Developed and implemented of SAP Analysis Process Designer (APD) applications.

Created Data Sources Read data from Info Providers, Attributes of a Characteristic, Query, Flat Files, Database Tables and

Created Transformations - Filter restricted amount of data, Aggregate Data, Join data from different Data Sources, ABAP Routines, Formula,

Sort data, etc. and Data Targets -Write data directly to Data Store Objects (DSOs), Flat files

Maintain and support existing APD Applications

Worked on Sales and Distribution(sales order, delivery, billing, shipping ) finance report development.

Worked on S/4 HANA CDS modelling on different modules (MM, SD and FI).

Implemented end to end application using S/4HANA CDS Views, SAP BW4/HANA, SAP BW on HANA and Enterprise HANA.

Extensively worked on SAP BW4/HANA for BW modelling.

Having Experience in writing AMDP, creating Open ODS views, DB connect data sources.

Very good knowledge on HANA modelling like scripted/graphical calculation views, table functions, Procedures, Virtual table, Virtual Procedures.

Development the Composite Providers from Financial, Inventory, PM, CRM and HR Process from SAP and Legacies Data Sources.

Modeler the full Data Flow by creating Generic and Standards Data Sources from ECC to replicate to SAP BW4HANA.

Consolidate in the advance DSO objects the information of the processes that involve the SAP and SQL legacy systems.

Modeler Composite Provider with Advance DSO and Calculation View (attribute view, analytic view) to satisfy

Modify existing SAP Native HANA Models according to the requirements to optimize it to run it on the new SAP HANA platform and to improve its performance according to the best industry standards.

Add ABAP code in Start, End Routine in Transformation, CMOD, and Customer EXIT.

Use the ODP Operation Data Provisioning to connect the SAP Data Sources.

Create new queries From Data Mart - composite provider and calculation view direct.

Client : PSA

Environment : S/4 HANA Embedded Analytics, SAP BW/HANA

Role(s) : Sr SAP BW HANA Developer.

Duration : Sept 2020 to till July 2021

Responsibilities:

Responsible for requirement gathering for the Analytical report development.

Responsible for Preparation of functional and technical specification for development of Analytical reports and Overview pages.

Worked on SAP S/4 HANA Embedded Analytics reports development in P2P, OTC, MTS and STOCK.

Worked on CDS views on S/4 HANA analytics and content driven models.

Extensively worked with CDS views using various Virtual data models.

Expert in ABAP CDS Views modelling, ODATA and S4 HANA embedded Analytics.

Knowledge in creating Fiori Apps and Tile creation.

Developed multiple Business operational & analysis Reports using BO Analysis for Office consuming data from BEx reports.

Troubleshooting issues with Analysis for office & ensured timely delivery from offshore.

Creation of ADSOs/Composite providers to make use of HANA DB

HANA Optimization of transformations for effective loading performance.

Guiding team from time to time to be updated on technical changes in the design.

Mentoring new members in the team.

Validating objects by peer review before moving to Quality system.

Aligning transports for smooth placements of objects in Production system.

Client : TE Connectivity

Environment : SAP BI 7.X, ECC, WAD, Bex

Role(s) : SAP BW Lead Consultant.

Duration : Nov 2019 to Aug 2020

Responsibilities:

Gather requirements and create functional specifications

Preparation of Technical Specifications for building BW data model

Involved in optimizing ABAP code in transformations

Worked on SQL to created stored procedures, triggers, Table types and Synonyms.

Created SQL Based calculation views to deploy them in Native HANA.

Extracted data from SAP and Non-SAP sources to SAP HANA using SDA and SLT.

Created activity log reports and worked and supported GL balances item level and summary level reports

Worked on SDA (Smart data Access) for accessing data virtually and SLT for Sap Source system

Worked on Denodo views on top of HANA view and exploring for the further systems.

lient : SATAIR

Environment : SAP BW4HANA, WAD, Bex and BO

Role(s) : SAP BI Consultant

Duration : Jan 2019 to Nov 2019

Responsibilities:

Involved with the Business Analysts and the business users to gather the business reporting requirements and aligning them to logical data architecture and mapped to functional requirements.

Delivered the BI design document, report functional specifications, BI technical specifications and Interface specification documents.

Have designed TAS reports and build the reports in SAP Business explorer tools (Bex Query Designer) and connected them to Business Objects Universe designer and Webi reporting.

Worked on performance aspects such as designing aggregates per report views, fine tuning of reports, caching, indexes, stats, pre calculations etc.

Worked with the business users in UAT resolving critical issues and was responsible for the delivery and lead to successful go live.

Designed and integrated complete data load batch schedule using Control-M tool (scheduled tool) connecting 4 different system landscapes, covering various loads, master and transaction data.

I have delivered the first prototype of the TAS reports to client, which has eventually fetched credibility with the client and eventually gained more business areas to the program.

I have created templates for BI design document and report functional specifications myself and have been approved by the Architects.

I was successful in accomplishing the tasks of BI logical data model, design and delivered the reports eventually getting approval from the client, which led to the successful Go-live within time.

Client : Nokia

Environment : SAP BI 7.0, ECC, Bex and WAD

Role(s) : SAP BI Consultant

Duration : Aug 2017 to Dec 2018

Responsibilities:

Worked in complete life cycle of the project.

Understanding the business requirement & Analyzing the gaps to bridge with frontend.

Worked on building Functional & Technical Specification.

Lead the team from onsite to ensure the timely delivery of the developments with quality.

Played SME and Solution Architect for the Nokia Project.

Involved in Project management Activities and Release Management.

Worked on web services to extract the kayang data (HR application system, non-sap source system) and load to SAP BW for Global employee headcount.

Worked on the Flat file (CSV format) data to get the data from different regions like EA, ASN and RFS.

Worked on SAP HANA and BW for Global reporting.

Client : SPARK

Environment : Native HANA

Role(s) : SAP HANA Consultant

Duration : Oct 2016 to till July 2017

Responsibilities:

Worked on end-to-end design, build and testing activities.

Determine HANA landscape including server sizing to meet the clients BI needs.

Implementing HANA Analytics on Cloud, Architecting SAP Digital Boardroom solution

Architecting Business Objects solution which included Business Objects 4.2 and Lumira 2.0

Help Business users to upgrade from Lumira Desktop to Lumira discovery

Data modeling using Hana Modeler – Create scripted and graphical calculation views

Extract Data from Oracle using SLT and SAP Data Services.

Work closely with SAP Business users to understand Claims management scenarios and create HANA Models that would be consumed by Webi and Lumira to create Dashboards.

Reporting against OLTP data source, define security for HANA models bases on Roles

Lead and mentor team comprising of 15 onshore and offshore HANA and Business Intelligence report developers, Recommended BI Best practices.

Client : Alcatel Lucent

Environment : SAP BI 7.0, ECC, Microsoft SSIS tool, Business Objects, Bex and WAD

Role(s) : SAP ABAP Consultant

Duration : Nov 2012 to till Sept 2016

Responsibilities:

Involved in identifying the master and transaction data from various sources in the project’s MI landscape and mapped them to the SAP BI data model.

Delivered the Solution Abstract, which gives a high-level summary of the design, interfaces and conceptual data model.

Involved in the Deployment plan covering the various source system extracts with detailed deployment / de-commission approach accordingly.

Gathered the detailed interface requirements and delivered the interface functional specifications with other team members, including setting up the extraction procedures using an ETL tool - SSIS.

Responsible for managing the end-to-end design, build and testing activities.

Responsible for preparing the technical specification of the solution

Responsible for customizing the objects, Programming, Transport management and Unit testing in the development environment

Responsible for assisting the users in performing User acceptance Testing and resolve issues.

Utilize in-depth knowledge of functional and technical experience in SAP BI and business skills to deliver solutions to customer.

Client : Valeo

Environment : SAP BI 7.0, ECC, Business Objects, Bex.

Role(s) : ABAP consultant

Duration : Feb 2010 to till Oct 2012

Responsibilities:

Involved in Requirement Gathering and development of data models.

Responsible for providing, validating and approving BW Data Model Design.

Coordination with Onsite personnel and giving status update on Project Progress.

Involved in new evolutions and support issues.

Client : HP, India

Environment : SAP ECC 6.0, SAP BW

Role(s) : BW/ABAP consultant

Duration : Aug 2006 to till Dec 2009

Responsibilities:

Involved with the core Business team in finalizing the high-level design documents and mapping business requirements to technical specifications.

Worked with the business team in mapping the data extraction processes for transactional data and master data from SAP R/3 system in various areas in Logistics, HR, COPA and FI.

Requirement gathering, preparing functional and technical specifications.

Developing Master data Info objects to handle alpha conversion, lower case and long text data

Requirements.

Worked on creation of all objects as per the design documentation. Created transformations, DSO’s, DTPs in data warehouse layer, second level of DSO’s, DTP’s, transformations in consolidation layer and Info cubes, multicides in reporting layer as per architecture.

Creating Standard and write optimized DSOs for Datamart and Info cubes for transactional

Data reporting.

Creating transformations using direct mapping and field level routine transformation rules.

Developing FULL/Delta Info packages to extract data from ECC.

Developing Bex Queries similar to existing R3 ABAP info set queries.

Automating data loads into BW system using process chains.

Resolving the issues after UAT and ongoing project support after go live.

Modified standard and created custom Info Source/Data Source, DSO, and Info Cubes.

Creation of Standard info cube, DSO according to the customer requirement

Documented in all stages of BI implementation: Data Analysis, Modeling, Data Extraction/Uploading,

Transports (CTS) and Bex Reporting.

Handled Testing and validations.

Worked with Web Application Designer in linking the Queries to portal and broadcasting

Contact this candidate