Data Intelligence Sap

.

Sunilkumar Mudipalli

SAP BW*HANA_DI_DATASPHERE_SAC Developer

Phone +1-470-***-****

E-mail: ********.******@*****.*** LinkedIn: www.linkedin.com/in/sunilkumar-mudipalli-28b80574 SUMMARY

• Over 15 years of IT experience, including 12 years in SAP B4HANA/HANA, SAP DI (Data Intelligence), SAP DWC/Datasphere, SAP Analytics Cloud (SAC), MS Power BI with focus on functional and technical areas.

• Experience in diverse industries including Retail, Hi-Tech and Manufacturing domain clients and have experience with integrated systems that enables to offers a wide variety of options for my clients and business needs.

• Interaction with Business users to gather the requirements, effort estimation and impact analysis along with communication and coordination with business users.

• Design and build end-to-end data warehouse solutions using SAP DWC, integrating data from various SAP & non-SAP sources.

• Collaborate with cross-functional teams to ensure successful implementation and integration of SAP DWC and SAP DI Cloud with other systems for data replication.

• Experience in migrating a complex BW data model to SAP Data Sphere using BW Bridge.

• Worked on migration SAP DI pipelines to SAP DI cloud on BTP platform.

• Design, implement, and deliver the technical and functional components of planning, forecasting, and budgeting solutions.

• Experience on SAC modeling, Stories creation, Analytical application creation, scripting, OLAP cubes to support Canned reports, Dashboards using DWC and SAC.

• Experience on both SAP and Non-SAP Data source for consuming data in SAC using both Live and Import Data connections.

• Design & develop Solutions to writeback data from SAP Analytics Cloud to BW/4 HANA using export APIs.

• Develop SAP embedded and Analytical solutions empowering Hybrid data modeling approach.

• Have worked on creating SAP Native HANA information models such as HANA Views, table functions, Joins, calculated columns, input parameters and filters.

• Developed SAP DI Pipeline graphs using standard function like SQL Operator, table replicator, SQL Consumer, File producer operators.

• Experience in provisioning data to & from SAP & Non-SAP systems into BQ using SAP DI.

• Experience in SAP HANA Data Provisioning techniques SAP LT Replication Server (SLT), BODS, Smart data Access

(SDA).

• Developed and Design CDS Analytical Consumption views, Composite views and Basic views.

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

• Developed embedded Analytics data models in S/4 HANA using CDS views.

• Worked on end-to-end implementation of BW4HANA project.

• Extensively worked on migration cockpit tool with all conversion approaches.

• Worked on technical upgrades of BW/BPC/BOBJ environments to different versions and migration from on- premise to GCP.

• Good knowledge over SAP NLS and Data Tiering Optimization (DTO).

• Driven requirement sign-off and Design sign-off meetings with design authority to ensure code quality standards and design standards are maintained.

• Working as onshore Team lead and manage onshore-offshore teams to represent the team on call with the clients for status on project, to face escalations and for other technical discussions, also responsible to provide status reports to senior management on regular basis.

• Expertise in executing projects and working in onsite-offshore model.

.

Tech Skills

• SAP BW4HANA

• SAP DI (Data Intelligence)

• SAP HANA

• SAP BW / BWoH

• SAP DWC/Datasphere

• SAP Analytics cloud (SAC)

• CDS views

• Embedded Analytics

• SAP NLS, DTO

• SAP BPC

• SAP Lumira

• SAP Analysis for Office (AO)

• SAP ABAP

• Data Provisioning (SLT, SDA, SDI)

• Microsoft Power BI

• Google Big Query and Google Storage

• SQL

• ERP: SAP R/3, S/4 HANA & ECC

• SAP Modules: SD, MM, FI-CO, COPA, CRM, CAR

• Databases: SAP HANA, DB2, SQL Server

• SAP Enterprise Portal

• Broadcaster

• Analysis Process Designer (APD)

• Google console

• GitHub

• Bex suite

• Web Analyzer Designer

• Web intelligence

• Bizlink

• Jira, Confluence, Pivotal tracker

• SAP Solution manager

• Service Now

• IBM Tivoli Workload scheduler

• HPALM

• Brio Query

• Configuration Manager

Personal Skills

• Drove a team of ten+ and met the deadlines.

• Part of multiple Agile teams and kept the velocity ticking.

Certifications

• SAP Certified BW4HANA 2.x Application

Associate.

Education

• 2003-07 Bachelor of Technology: Electrical and Electronics Engineering Professional Experience

• Working as Consultant with Tata Consultancy Services since October 2013.

• Worked as Senior Associate Consultant with Infosys Limited, Bangalore from January 2011 to August 2013.

• Worked as Genesys Administrator with Optimus Global services (Polaris Group), Chennai from October 2007 to February 2010.

.

Work History

July 2018 – Present – The Home Depot, Atlanta, GA

Role:

SAP BW4HANA Technical Consultant

Project: Financial reporting Experience

Financial Reporting is a reporting solution to THD’s business Strategy. This project involves implementation, support, upgrade & migrate of Retail financial solutions and the SAP Enterprise Portal (ERP) module of SAP. The project requires to work with functional leads, architects, business teams, software development engineers and other technology partners to deliver data, tools, and dashboards. Responsibilities:

• Interaction with Business users to gather the requirements, effort estimation and impact analysis along with

• communication and coordination with business users.

• Analyze the requirements to provide robust data model in the areas of SAP BW4HANA, SAP DWC/Datasphere, SAP Analytics cloud, SAP DI (Data Intelligence), GBQ, S4HANA Embedded analytics.

• Design and build end-to-end data warehouse solutions using SAP DWC, integrating data from various SAP & non-SAP sources.

• Collaborate with cross-functional teams to ensure successful implementation and integration of SAP DWC with other systems.

• Design, implement, and deliver the technical and functional components of planning, forecasting, and budgeting solutions.

• Experience on SAC modeling, Stories creation, Analytical application creation, scripting, OLAP cubes to support Canned reports, Dashboards using DWC and SAC.

• Experience on both SAP and Non-SAP Data source for consuming data in SAC using both Live and Import Data connections.

• Design & develop Solutions to writeback data from SAP Analytics Cloud to BW/4 HANA using export APIs.

• Develop SAP embedded and Analytical solutions empowering Hybrid data modeling approach.

• Developed and Design CDS Analytical Consumption views, Composite views and Basic views.

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

• Developed embedded Analytics data models in S/4 HANA using CDS views.

• Have worked on creating SAP Native HANA information models such as HANA Views, table functions, Joins, calculated columns, input parameters and filters.

• Developed SAP DI Pipeline jobs using standard function like SQL Operator, table replicator, SQL Consumer, File producer.

• Experience in provisioning data to & from SAP & Non-SAP systems into BQ using SAP DI.

• Experience in SAP HANA Data Provisioning techniques SAP LT Replication Server (SLT), BODS, Smart data Access (SDA).

.

• Worked on end-to-end implementation of BW4HANA project with extensive experience on migration of SAP BW 7.5 to BW/4HANA using Shell migration method.

• Extensively worked on Note implementations and issue resolutions to implement BW4HANA Transfer cockpit tool to ensure up & functional.

• Extensively worked on resolution of migration cockpit issues and ABAP CODESCAN errors, version compatibility issues to redesign to objects to support BW4HANA code line.

• Extensively worked on Advanced ADSOs, ODS Views and Composite Providers in BW Modelling perspective of Eclipse, CDS views extraction to BW/4 HANA.

• Worked on Migration of BW landscape from on-prem to GCP to ensure BW system is functional with all inbound and Outbound integrations, coordination of issue resolution related to app server Performance issues identified using ABAPMETER.

• Worked on redesigning Scripts to support code line of GCP systems.

• Worked on technical upgrades of BW/BPC/BOBJ environments to different versions and migration from on- premise to GCP.

• Worked on identifying the root cause analysis and resolution for upgrade issues.

• Expertise in NLS & ADK archiving and DTO.

• Driven requirement sign-off and Design sign-off meetings with design authority to ensure code quality standards and design standards are maintained.

• Manage offshore and onshore teams and represent the team on call with the clients for status on project, to face escalations and for other technical discussions, also responsible to provide status reports to senior management on regular basis.

• Met with supervisors on weekly basis to provide detailed project report and milestone updates. Oct 2017 – June 2018 – Tata Consultancy Services, Bangalore, India Role:

Technical Consultant

Client: Johnson & Johnson (Ortho Clinical diagnostics (OCD)) The objective of the project is to build SAP Lumira visualization reports (POC) by using LUMIRA 2.0 design studio and HANA / BW in order to replace existing MSBI reports and to implement NLS configuration. Responsibilities:

• Have worked on creating SAP Lumira visualization dashboard using Lumira designer 2.0 to implement the functionalities of Geographical user selection, front and reverse cascading of selection filters, Graph Drilldown, Graph change by cascading filter.

• Have built combined chart report and crosstab reports with conditional formatting and dynamic legends.

• Have developed SAP HANA Calculation View, Joins, calculated columns, input parameters and filters.

• Have worked on enhancements of SAPI data Sources and customer exists

• Migration of BW 3.x data flows to BW 7.x flow by using RSMIGRATE tool and issue resolution.

• Coordination with Basis Team for migration cockpit issues and ABAP analyzer report issues.

• Have analyzed hundreds of SAP Notes to implement SAP IQ solution to setup NLS setup, NLS functionality and system validations.

• Identifying list of data targets for NLS archiving to free up more space for HANA sizing to migrate to HANA DB.

.

Sep 2014 – Oct 2017 – Tata Consultancy Services, Bangalore, India Role:

Technical Consultant

Client: KPMG IBS 2.0

Responsibilities:

• Have worked on creating SAP Native HANA information models such as HANA Views (Attribute View, Analytic View, Calculation View), table functions, Joins, calculated columns, input parameters and filters.

• Providing the effort estimation for development and enhancements, Design and develop the application to fulfil the requirements.

• Worked on incidents to fix issues / bugs on priority to meet SLA as per business requirements in SAP BI / BWoH / HANA.

• Troubleshooting the issues in customized objects or solving production tickets or hyper care tickets and service calls leading to defects.

• Supporting HANA transports across the landscape and redeploy inactive / invalidated models.

• Responsible for finding the root cause analysis for issues and suggesting the permanent fix and work around.

• Responsible to improve the performance of the reporting and data loads and managing BWA.

• Involved in Performance Tuning by maintaining Aggregates, Query read mode, secondary indices creations, Line-Item Dimensions, Compression and Partitioning of Info cube to optimize query performance. Early Career

• NXP Semiconductors, SAP BI consultant (10/2013 to 09/2014)

• Syngenta, SAP BI consultant & Enhancement Track Lead (02/2011 to 08/2013)

• Genesys Administrator (10/2007 to 10/2010)

Contact this candidate