Sap Data

Dileep Kotha

SAP BI, BW/*HANA, SAC, BW, S/*HANA Analytics Consultant

https://www.linkedin.com/in/dileep-kotha +1-612-***-**** **********@*****.***

Overview

** ***** ** ********** ** SAP BW/BI/HANA/BW4HANA techno-functional consultant, indulging in the design, development, implementation and maintenance of Client/Server environment.

Involved in 4 full life cycle implementations which includes 1 BW/4 HANA, 2 NetWeaver 04s (BI 7.0) and 1 full life cycle implementation of BI 4.0

Business Modules: Key Involvement in the configuration of cross application modules FI /CO-PA, CRM, SD, CS, MM, IM, PP, SCM, SRM, WM, APO, CCA, Asset Management, CO-OM, HR.

Licenses and Certifications

SAP Certified Application Associate - Reporting / Modeling and Data Acquisition with SAP BW/4HANA

SAP Certified Application Associate - SAP Analytics Cloud

SAP BW/4HANA,

Knowledge in implementing and setup of SAP BW/4HANA environment.

Acquisition of data into BW/4 system using Smart data Access (SDA), Smart data integration (SDI) and SAP Landscape Transformation Replication (SLT).

Worked in SAP BW/4 HANA on data modeling using Advanced datastore objects (ADSO), Open ODS views, composite providers and field-based modeling.

Converted traditional SAPI extractors to Operational data provisioning ODP extractors.

Data acquisition from SAP ERP applications and external sources using local and tenant database schema and Operational Data Provisioning.

Handled Inventory Management in SAP BW/4HANA using standard Data sources and /IMO* objects

Knowledge on Data Retention Strategy in SAP BW/4HANA.

S/4HANA

Worked with Core Data Services (CDS) and Virtual data models in S/4 HANA.

Created and enhanced data models with Core Data Services (CDS) views.

Worked on real time operational reporting requirements in SAP S/4HANA

Worked on embedded analytics and virtual data models in SAP S/4HANA

Knowledge of CDS (Core Data Service) View create in DDL source Editor.

Creation of information objects packages, attribute views, analytic views, calculation views, both Graphical and SQL script based.

Direct Data provisioning using Data Services (BODS)

Created HANA modeling scenarios and activities such as adding a system, creating schemas and content models, attributes and measures, hierarchies

Experience in loading data into table definitions, suspending data loads, resuming data loads

Worked on ABAP CDS View, AMDP, HANA View and HANA Store Procedure.

Worked with operators, aggregations, and expressions in CDS Views.

Experience working with SAP BW/HANA Workspaces.

SAC: SAP Analytics Cloud

Worked on integration between BW/4 HANA and S/4HANA to SAC

Experience in creating User stories, planning and hierarchy models, Charts in SAC

Worked extensively in creating models with data import from desktops, connecting data from SAP BW, S/4 HANA systems

Configured formulas for different accounts, manage currency conversion tables as well as allocations in SAC.

Used data enriching procedures in SAC like date dimensions, geographic dimensions, using attribute dimensions, creation of level-based hierarchy and applying of aggregation settings in models.

Worked with calculations and alerts in SAC (Calculated and restricted measures, forecast and rolling forecast cross calculation)

SAP BW, BWoH

Extensive Knowledge in Data-Modeling (HANA Optimized Data Models), Data Staging, Data Extraction (LIS, LO Cockpit, FI/CO, New GL, Project Systems, CO-PA, SD, HR/HCM, MM, SRM, QM, PP, Flat File and DB Connect, ETL Tools) Generic Extraction, Data Loading, Scheduling, Monitoring, BEx Query and Business Objects (BOBJ).

Excellent skills to work on Business warehouse extractors such as LO-Cockpit, COPA, Generic Extractors, Standard Extractors, Generic Delta Extractors and ALE Delta Extractors.

Worked on SAP BW on HANA modeling with Advanced DSOs, composite providers, Open ODS views.

Good knowledge in Direct Extractor Connections (DXC) & SLT (SAP Landscape Transformation) - Data Provisioning Tools.

Hands on experience in HANA modeling - Created multiple schemas and table definitions. Experience in creating Attribute views, analytical view and calculated views. Experience in applying privileges.

Trained and practical experience in both Native HANA & BW on HANA (BWoH).

Experienced in BW optimization for SAP HANA (HANA optimized Info-Providers)

Good experience in extracting data from SAP & non-SAP systems. Extensive experience to work on Flat File Extraction, Generic Data Sources, BI Content Data Sources, Full and Delta Extraction Management.

Extensively worked on BW 7.0 / 7.3 & 7.4 Data Modeling which includes installing Business Content, creating Info-Objects, Info-Cubes, DSO (Data Store Objects), ODP, SPO, Hybrid Providers, Transformations, DTP, Data Flows, Remodeling, Repartitioning, Info-Packages, Data Sources, Process Chains, PSA Maintenance and Source Systems.

Installed Inventory BI Content and extensively worked with 2LIS_* data sources.

Excellent skills to develop all kinds of ABAP Routines (Start/End/Expert) during Transformations/update rules. Designed Custom extractors using User-exits, routines and Function Modules. Worked on all kinds of BI-ABAP requirements.

Expertise in BEx Analyzer, Query Designer, Web Application Designer, Info-Set queries.

Experience with Front-end Business Warehouse Components, which involved constructing custom queries using Variables, Structures, Conditions and Exceptions, Restricted and Calculated Key Figures. Expertise in publishing queries to web portals through Web Analyzer. Extensively designed Drill Specific Reports.

Worked on various kinds of Performance Tuning techniques such as Aggregates, Rollups, Indexes, Partitions and Info-Cube Compression techniques. Exclusive skill set in maintenance of BIA Indexes. Evaluated statistical performance on OLAP using BW Statistics.

Strong knowledge in maintaining Events & Process Chains. Contributed in Testing & Transporting of extractors, Info providers, Transformations and BEx Queries from development to testing and Production.

Production Supporting skills: load monitoring, enhancements and change requests.

Excellent skills to solve Data loading issues and Developed Detailed Cutover plans. Managed huge cutover activities and solved issues during the process.

BOBJ/BI

Experience in using Information design tool (IDT), to create universes using multiple Relational Data Sources.

Developed, designed and maintained new and existing universes by creating joins and cardinalities responsible for creation of the universe with Classes, Objects and Condition Objects.

Extensive experience in Business objects reporting, in the context of developing the Universe using the Universe Designer and the Analytics using, Xcelsius, Web-i and Crystal.

Designed Universes using IDT with Multi source data sources and defined Connection layer such as Data Foundation Layer and Business Layer and published the universes.

Configured BICS connection in SAP BI 4.0. 4.1 Information Design tool.

Created dashboards directly over Universes using Query Browser in SAP BI 4.0, 4.1

Professional Experience

Tek-Analytics LLC, Schaumburg, IL 2010 - Present

SAP Business Intelligence Principal Consultant

Serves as a principal consultant in Analytics space as SAP BW/4HANA Architect, SAP Business Analyst.

Multiple projects in SAP Business intelligence and analytics space ranging in all budgets across multiple functional area and products.

Accomplished highly complex deployments in SAP BW, BW/4HANA with expertise in Operations/Release management.

Application development in SAP Data warehouses such as S/4HANA, BW/4HANA, BW on HANA

Developed reports and dashboards supporting business analysis in corporate wide reports using SAP BI tools

Environment: S/4 HANA 1909, SAC, SAP BW/4HANA 1.0, SAP BW 7.4 on HANA, SAP BI 4.2

Glatfelter, Charlotte, NC Jun’20 – Present

SAP BW/4 HANA Consultant.

Project Next Analytics: SAP BW/4 HANA implementation to support enterprise wide central reporting repository.

Responsible for Architecting solution to bring Manufacturing, cost center and inventory modules data from Multiple ERP systems (ECC, S/4 and MS CRM) into SAP BW/4 HANA instance and developing reports on top of data models.

Environment: SAP BW/4 HANA 1.0, BW 7.4 on HANA, S/4 HANA 1909, ECC 6.0; SAP CRM; SAP BI 4.2

Change Healthcare, Alpharetta, GA Feb’19 – Apr’20

SAP BW/HANA Architect.

Project UNUM: Unification of ERP systems, to bring complete organization into single ERP platform.

Responsible for SAP BI space performance, day to day activities and future enhancements.

Environment: SAP BW 7.4 on HANA, ECC 6.0; SAP CRM; SAP BI 4.1

McKesson, Alpharetta, GA; Livonia, MI May’14 – Dec’14, Jul ‘15 – Aug’16, Apr’17 – Feb’19

Sr. SAP BW/HANA, Integration Architect/Lead.

Project SAP CLONE: Implementation of new SAP environments for Change Health care as part of McKesson Technology Solutions (MTS) exit from McKesson to Change Health Care.

Mosaik realization: Meet McKesson Canada Finance requirements and create financial models and reports.

MTS Revenue Convergence Program: New GAAP standards will require all publicly traded companies to change the way they recognize revenue for software. While all McKesson Business Units are impacted, the MTS segment will account for most McKesson’s impact. Due diligence was initiated by Corporate Financial Reporting and PwC during FY14 and has transitioned to be the project is transitioning to be business led by MTS in FY18.

RelayHealth Migration Project: RelayHealth provides the connectivity and solutions that enable constituents across healthcare to exchange information securely and conveniently. By connecting patients, providers, pharmacies, payers and pharmaceutical manufacturers, RelayHealth offers real-time solutions to streamline interactions throughout healthcare. The net result: improved care, faster access, lower costs and enhanced bottom lines. McKesson acquired RelayHealth and this project is to retire the existing PeopleSoft ERP system and integrate the solution to present SAP environment of McKesson Corporate.

Project: MPS&A McKesson Pharmacy systems and automation is the business of McKesson providing Pharmacy management software systems. Project is to retire existing ERP, few legacy interfaces and integrate the solution to present SAP environment of McKesson Pharma.

Environment: SAP BW 7.4 on HANA, 7.0, HANA SPS 12, ECC 6.0; SAP BI 4.1, SAP RAR 1.1, 1.2

Viacom, New York Jun’17 – Oct’17

SAP BW/4 HANA Architect.

Financial system Upgrade from SAP 7.4 to 7.5 on HANA to BW/4 HANA 1.0

Environment: SAP BW 7.4, 7.5 on HANA, SAP BW/4HANA 1.0, SAP BI 4.2

Medtronic, Inc. Minneapolis, MN Sep’16 – Mar’ 17 Service & repair reporting lead.

CGEN 4 (USA and Canada) Migrating Covidien systems to Medtronic, Inc. SAP environment. After Medtronic, Inc. acquired Covidien, new project started and is being handled in 5 phases. In CGEN4, scope of the project is to bring Covidien data and design to Medtronic, Inc. Centerpiece system for US and Canada regions.

Environment: SAP BW 7.4 on HANA, 7.0, HANA SPS 10, ECC 6.0; SAP BI 4.1

Veolia Environmental Services NA, Milwaukee; Indianapolis; Boston Jan ‘15 – Aug’15 Senior SAP BW Architect/Consultant

Project AGORA: Veolia North America is functioning on different technologies across various kinds of business operations. Project AGORA is designed to bring all the Financials to one system SAP (which is already being used by Veolia France)

Environment: SAP BW 7.4 on HANA, 7.0, ECC 6.0, SAP BI 4.1

FMC Technologies, Houston, TX Apr’13 – May’14 Sr. SAP BW BI Consultant.

Project Syclo: The warehouse would like to see various “real time” progress and performance reports or “dashboard” style displays for areas such as picking and critical activities. There is currently no WM data in BI, and no standard content that can be easily turned on. This project addresses the local requirements from the Syclo project but also aims to build a standard WM data set which can be used by all other sites.

Payroll reporting Project: ADP is handling FMC’s payroll process from 2013 and before it was done by Ceridian. Payroll department requires few reports to be developed for the business to do various metrics. As of this project payroll data is not present in BW system.

Environment: SAP BW 7.3 on HANA, 7.0, ECC 6.0, BI 4.0, APO 5.0, CRM 6.0

Brock Group, Houston, TX Oct’11 – Mar’13

SAP BW/BOBJ Developer.

Project: SAP Implementation of ECC and BW

Environment: SAP BI, ECC 6.0, Business Objects.

Education

Master’s in engineering management, St. Cloud State University, MN

Bachelor’s in electrical and Electronics Engineering, JNTU, India

Contact this candidate