Suresh Babu Guttikonda

SAP HANA Technical Consultant

E-Mail: adc6qy@r.postjobfree.com

Mobile: +1-314-***-****

Professional Summary

Over 12 years of experience in which 5 years on SAP HANA and 7 years on Business Intelligence solutions, innovative analytical reporting and visualizations to often unique business requirements utilizing the SAP HANA BW products such as HANA 2.0, BW 3.x, BI NW 7.0,7.3,7.4,7.5 and SAP BOBJ 4.X.

Worked in various Industries such as Electronics, Chemical, Food and Beverages and Retail.

Involved in Full life cycle implementation by using SAP HANA 2.0, SAP BW & BO.

Expertise in working SAP HANA modeller by using business artefacts for each business unit and analyse the KPIs.

Experience in Hana Cloud foundry, Hana Cloud Platform (HCP) and On-Premise environments.

Experience with Cloning the Repositories from GIT repository into Local workspace, Build DB Artifacts, Containers and Multi-Tenant architecture using HANA 2.0

Native HANA - Schemas, Packages, designing Views (Attribute View, Analytic View and Calculation View), Stacked Calculation Views, and Views that needs multiple table functions, counters, Restricted and Calculated measures, input parameters, filters, transparent filters. Debugging Views. HANA Modelling using SQL Script, Variables and Input Parameters, Calculated and Restricted Columns, Currency Conversion, Hierarchies and CESQL scripting, Export/Import of Models, Validating Information Models, Creating Schemas, Manage Schema Mapping, and Performance Tuning.

HANA SQL SCRIPTS & CDS Views - Strong experience on Creating SQL, Stored Procedures with SQL Script and Calculation Engine (CE) Functions, Debugging SQL Script using various techniques like – Tracing, Using the SQL Script Debugger.

Proficient working on XS Engine, O Data Service and CDS Views.

Worked on NetWeaver 7.3/7.4 platform to deploy models.

By using SAP NetWeaver Application server, perform analysis and embedded analytics in real time.

Experience in Requirement gathering, Gap analysis, design, development, testing, documentation, maintenance, troubleshooting and Performance tuning.

Working experience in define and implement security and Dynamic Analytics Privileges.

Experience in extracting the data using Business Object Data services (BODS), SAP Landscape Transformation Replication Server (SLT) and Smart Data Integration (SDI).

Good understanding of LSA and LSA++.

Extensively worked on Data Warehousing workbench Info Objects, Info Cubes, Classical DSOs (Standard and Write Optimized), Advanced DSOs, Composite Providers, Transformations, DTPs, Open Hub destinations.

Strong Experience Hybrid Modelling - BW Data Models with Native HANA modelling artefacts and vice versa.

Worked on AMDP to Pushed logic to HANA DB to leveraging potential of HANA.

Expertise on modelling of Advanced DSOs, Composite Providers and Open ODS views using BW modelling Tools in HANA Studio.

Good Experience on Analytic Privileges as part of Security for HANA Information Models.

Expertise in OLTP extraction from SAP R/3 using LO Cockpit, CO-PA, FI AR, AP and Generic Extraction also data from flat files

Worked extensively on Logistics (PP, PM, MM, QM and SD) and generic data extractions.

Worked extensively on SCM, FI-CO and CRM.

Requirement gatherings, Design solutions and worked throughout different project phases.

Proficient working with cross-functional project teams on different phases of Software Development Life Cycle implementation – Requirement Gathering, Solution Design, Solution Build/Development, Testing, Preparation of Cutover Plan and Deployment.

SAP HANA Data Provisioning using SAP Landscape Transformation Replication Server (SLT) for real time (and Non real time) data replication from SAP ERP and non-SAP systems.

Expertise in Data Extraction, Transfer and Loading (ETL) using SAP Business Object Data services (BODS) and Direct Extractor Connection (DXC).

Extracted data using BODS from SAP into HANA with the ODP (Operational Data Provider) functionality.

HANA SECURITY & TRANSPORT- Creating Analytic Privileges, Setup data level authorization and privileges at SAP HANA Database, Creating User, Roles & assigning the respective Privileges. Hands-on experience on all three modes of transport – Delivery Unit mode, Development mode, as well as on the ‘SAP support mode’, Apt in Direct metadata import – mass import of metadata, selective import of metadata.

Created Universes on top of HANA Calculation views and developed the Webi reports and dashboards using IDT (Information design tool)/UDT.

Expertise on Reporting using BEx Query Designer, BEx Analyzer, Analysis for Office Microsoft Excel, WebI, Design Studio, Tableau and SAP Lumira.

In WebI developed Adhoc Reports with BEx Queries as source using BICS Connection.

Hands on experience on new SAP Business Objects 4.1 client tools like Information Design Tool, BI Launch Pad, Dashboard Design, Crystal Reports Enterprise etc.

Adept in analyse information system needs, evaluating end-user requirements, custom designing solutions, and troubleshooting any problems in the process.

Good exposure to Project Management activities and involved in all phases of Project Management & experience of helping Practice Heads/Sr Managers in building the Proposals and handling Requirement gathering workshops.

An enthusiastic, highly self-motivated, Excellent Technical, Interpersonal and solid communication skills with the ability to interact with end-users and Training end-users on the solutions.

Technical Skills

Data Base

DB2, HANA, Oracle, MS-SQL server

ETL

BODS,BW,SLT,SDI,SDA

DW Skills

SAP BW, SAP HANA

Reporting Tools

BO Webi, Dashboards IDT, Tableau, Lumira, Analysis for Office, Design Studio.

BeX Analyser

Power BI

Programming Language

ABAP, SQL, PL/SQL, T-SQL

Projects Profile

Ulta Beauty, Bolingbrook, IL

Sr.SAP HANA Consultant (Native) Oct 2019– Till date

Project Description:

FFC SKU Limited project will limit the SKUs list in Ecommerce DC by considering the limitation of space. Today Ulta Beauty have multiple FFC (Fast fulfilment centres) and this Solution is leveraged to all DC’s for better utilization of limited space by applying assortments like Fragrance, Aerosol and General.

This allows business to analyse and plan to decide which articles to be carried by a quarterly basis based on past sales and forecast for better utilization of DC’s.

Environment:

SAP HANA 2.0,S/4 Hana(1809),Web Intelligence, Native Hana, HANA SQL,CDS views,SLT, SDI, and AO.

Roles and Responsibilities:

Involved in Requirement gathering to understand the current business scenarios for the e-commerce Fast Fulfilment centre SKUs Limited.

Worked on S/4 HANA(1809) to consume tables in embedded HANA

Analyse and architect HANA staging and developed models using Scalar and Table functions.

Analysed and Created KPI’s as per the outcome of brain storming from the business users.

Enhanced data models to accommodate additional data without impacting existing reporting setup.

Extracted the data using Business Object Data services (BODS), SAP Landscape Transformation Replication Server (SLT) and Smart Data Integration (SDI).

Involved on NetWeaver 7.3/7.4 platform to deploy BI models by integrating other services.

Worked on SAP NetWeaver Application server, perform analysis and embedded analytics in real time.

Used SAP cloud foundry to access data from google cloud platform.

Configured and Replicated the ECC Tables using SLT for retail time data and modelled the Calculation Views.

Created Technical specs by analysing functional specs.

Developed Info Providers using HANA Studio such as Advanced DSOs, Composite Providers, Open ODS Views.

Export/Import of Models, Validating Information Models, Creating Schemas, Manage Schema Mapping, Performance Tuning.

Developed SAP HANA Information Models using Calculated Views.

Designed the data flow architecture for Master & Transaction data.

Modelled Calculation views using Scalar functions to derive Week from and Week to from Current date input parameter.

Involved in SAP HANA Security Analytical Privileges.

Created Test cases for data models.

Conducted user trainings to help them understand the enhancements so that they can use self-service reporting views, Bex reports and AO.

Developed new Reports as per the Business Requirements.

Worked extensively on Data Model design in Supply chain.

Coordinated with teams from cross functional areas to manage dependencies and continue to complete project with in the agreed time lines.

Maintained detail document for all the changes and shared knowledge with support team for smooth transition.

Provided training to the end users on reports for their business decision making.

Projects Profile

Ulta Beauty, Bolingbrook, IL

Sr.SAP HANA Consultant Mar 2019– Sept 2019

Project Description:

Channel localized pricing project will give Pricing team the capability to maintain retail price at multiple price points in SAP. Today Ulta maintains single Price for a SKU across Organization. Going forward prices can be maintained at store level and zone level.

This allows business to analyse and plan the pricing to thrive through the competitive market.

Environment:

SAP HANA 2.0, Business Objects 4.2 – Web Intelligence, CDS views, Native Hana, Hana SQL.

Roles and Responsibilities:

Participate in Requirement gathering to understand current reporting scenarios where the pricing is relevant and e-com Fast Fulfilment centre Limited SKUs.

Analyse and architect HANA staging and developed models using Scalar and Table functions.

Enhanced native Hana data models to accommodate additional data without impacting existing reporting setup. Pushed logic to HANA DB using AMDP leveraging potential of HANA.

Configured and Replicated the ECC Tables using SLT for retail time data and modelled the Calculation Views.

Implemented HANA CDS views with annotations, associations and rich semantics like currency conversions, variables and Input parameters.

Extracted and transformed the data remotely using Smart Data Access (SDA) and Smart Data Integration (SDI).

Assigning the Reporting Views to corresponding role using SQL based privileges.

Created Technical specs by analysing functional specs.

Developed SAP HANA Information Models using SQL based Calculated Views.

Conducted user trainings to help them understand the enhancements so that they can use self-service reporting views, BO and Bex reports.

Modelled Calculation views using Scalar functions to derive Week from and Week to from Current date input parameter.

Involved in SAP HANA Security including Object Privileges, Analytical Privileges

Creating Test cases for data models.

Worked on SAP HALM (Hana Application Life Cycle Management, transported objects from one environment to another.

Designed Data flow architecture for Master & Transaction data.

Developed new Reports and Modified existing Reports as per the Business Requirement Testing.

Worked extensively on Data Model design in Supply chain.

Coordinated with teams from cross functional areas to manage dependencies and continue to complete project with in the agreed time lines.

Maintained detail document for all the changes and shared knowledge with support team for smooth transition.

Projects Profile

Nestle Globe, St. Louis, MO Mar 2017– Mar 2019

SAP HANA Consultant

Project involved: Worked on the requirements gathering for retrofitting the legacy applications to HANA optimized, Built native HANA calculation views, CDS views for application using both graphical and SQL based views for GD sales, FI and COPA extractors, implemented CO module and CS areas. Extensively worked on CDS views, entity views, table functions, SQL procedures, formula functions and other calculations and restrict measure.

Project Description:

HANA migration to NUSA (Nestle USA), which Evaluates migrating from legacy to Globe system by developing and implementing the HANA objects for GD sales and CS.

Environment:

SAP HANA 2.0, Business Objects 4.1 – Web Intelligence, Native Hana, Hana SQL, CDS.

Roles and Responsibilities:

Interacted with Business stakeholders in order to understand their structured and ad-hoc reporting requirements, User stories for business Marketing and Sales domains.

Conducted interviews with clients to solidify the required business rules and fact-finding sessions with continued reviews throughout the project lifecycle.

Created Technical Specifications document based on Functional Specification, Report Design Documents.

Created HANA Procedures, functions, Tables, created the HANA Calculation views exposed it for reporting.

Creating Test cases for data models.

Worked on SAP NetWeaver Application server, perform analysis and embedded analytics in real time.

Worked on SAP HANA data model with LSA++ architecture

Developed Complex Calculation views using Graphical and SQL Scripts

Created Tables and Views using CDS Artifacts.

Extracted and transformed the data remotely using Smart Data Access (SDA) and Smart Data Integration (SDI).

Configured and Replicated the ECC Tables using SLT for retail time data and modelled the Calculation Views.

Export/Import of Models, Validating Information Models, Creating Schemas, Manage Schema Mapping, Performance Tuning.

Developed Stored Procedures with dynamic calling of Calculation views as per the requirement.

Created Calculation Views by using various nodes like Aggregation, Join, Union and Projection.

Created advanced modelling using Hierarchies, derived views, restricted calculated column, variable, input parameter.

Modelled Calculation views using Stored Procedure to derive YTD, MTD and Rolling Sales Revenue values.

Developed Info Providers using HANA Studio such as Advanced DSOs, Composite Providers, Open ODS Views, Calculation views

Designed and developed virtual data models HANA Live eliminating the need to replicate data of ECC and analytical, attribute, calculation views on SAP HANA.

Created web services for querying HANA database from external end user report portal using real time jobs in data services 4.0 designer.

Developed the security model, Naming conventions, folder structure for HANA 1.0 and BOBJ 4.1 and established the recommended SAP best practices for developing Universes, reports and dashboards from HANA data sources.

Used Data Services to expose data from HANA Calculation views.

Developed Production Order Actual vs Plan variance report, Capacity Utilization report, Material Actual vs Plan Reports.

Adopted parallel techniques/filter pushdown/parameters in developing models to achieve the performance.

Involved in User/Role Management and HANA security.

Implemented HANA CDS views with annotations, associations and rich semantics like currency conversions, variables and Input parameters.

Co-coordinated with different functional teams in SAP SD and SAP MM.

Involved in SAP HANA Security including Object Privileges, Analytical Privileges

Proficient in performance analysis, monitoring and SQL query tuning using EXPLAIN PLAN.

Consumption of HANA information Models in BW

Involved in Support pack upgradation Testing Activities.

Created Universes on top of HANA calculation views and developed the Webi reports and dashboards using IDT Information design tool

Worked on SAP HALM (Hana Application Life Cycle Management, transported objects from one environment to another using this brand-new tool.

Project: Trade Promo Eval. Mar 2015 – Feb 2017

SAP HANA Technical Consultant

Project Description:

Trade Promo Eval is a solution to Nestle waters North America, Which Evaluates the Performance of the Promotions, by using the Trade Promotions data and Market Research data.

Environment:

SAP HANA, SAP BW 7.4, Business Objects – Web Intelligence

Roles and Responsibilities:

Involved in Collaborating with Client managers, Reporting team, Business users and other Stake holders to understand SAP HANA, the existing landscape and identify key business use cases for the Proof of Concept POC.

Interacted with Business stakeholders in order to understand their structured and ad-hoc reporting requirements, User stories, business Marketing and Sales domains.

Created Technical Specifications document, Functional Specification Documents, Report Design Documents.

Designed and Developed HANA Modeling Artifacts –Attribute, Analytic and Calculation views using HANA Studio (Graphical and SQL Script).

Created SQL Stored Procedures to implement complex logics and integrate them with HANA Views and Composite Providers.

Extracted data from Calculation Views into SAP BW with the ODP (Operational Data Provider) Functionality.

Development of Hybrid Models by consuming BW Models into Native HANA.

Worked with variables, Input Parameters, Calculated and Restricted Columns, and Currency Conversion in Calculation Views.

Developed SAP HANA Information Models using Calculated Views.

Worked on Projection, Join and Union in HANA calculation views.

Developed Information models like Scripted Calculation Views in native HANA.

Worked on Filters, Restrictions, Calculated measures, restricted measures in HANA views.

Worked on Decision Tables, Triggers and Sequences in HANA Studio.

Worked on Performance Tuning using Explain Plan and Visualize Plan.

Worked on Analytic Privileges for HANA Information Models.

Designed Open ODS view, Advanced DSO, Composite providers, analytical views, calculation views- graphical and SQL scripted stored procedures and consumed those models into Bex Query designer, Analysis office and BO WebI.

Created Calculation Views to meet new reporting requirements in HANA Studio using different joins (inner join, outer join, referential join etc) and union to connect tables.

Created HANA Expert Routine to Leverage the HANA DB and provided the performance of data loads in EDW.

Development of Proof of Concepts (POCs) in Sandbox before starting the Actual development.

Coordinate with Business users and completed the Market Integration Tests and user Acceptance Tests.

Worked on Performance Tuning Techniques to Push down HANA Transformation logic into HANA Data Base.

Designed Data flow architecture for Master& Transaction data.

Extraction of Data from SAP ECC and development of ABAP programs with SAP BW.

Maintain and modify existing ETL applications and corresponding documentation.

Develop new ETL processes of simple to moderate to highly complex scope and contribute to design specifications, using organization standards, procedures, and techniques.

Assist in the development of test plans for assigned projects.

Development of New Reports or Modification of existing Reports as per the Business Requirement and Testing.

Worked on Smart Data Access (SDA) solution for virtualizing data from Oracle, MS SQL Server.

Multi Temperature Data Management - Hot, Warm (Dynamic Tiering), Cold and Frozen.

Developed Stored Procedures to move aged to data to WARM Dynamic Tiering tables and scheduled those using XS Jobs to run periodically.

Worked extensively with the major functionality of BO WebI Reports like Breaks, Sections, Group values, Sorts, List of Values (LOV), Calculations and Ranking.

Involving in House-keeping Activities and Performance Optimization.

Co-coordinating with different functional teams in SAP SD, SAP MM, SAP PP, SAP FI-CO etc.

Estimating the timelines for RFCs (Request for Change).

Nestle Bangalore Apr 2013 - Feb 2015

SAP BW HANA Consultant

Environment:

SAP BW 7.3, HANA SAP ECC 6.0, ABAP/4, BO,BEx Analyzer, BEx Query Designer

Roles and Responsibilities:

Worked on Conducting workshops, Business requirements gathering for the solutions replacing their existing legacy system.

Gap Analysis between the existing solution and the business requirement.

Designed and developed data models for MM, HR-PA and FI-GL, COPA modules as per the LSA architecture and customized the MM and GL data source enhancements.

Extracted data from MM (Stock Initialization– “2lis_03_BX” data sources). Extensively worked in performing customer, vendor analyses in BW.

Build custom data sources for the COPA extracts from ECC into BW and activated and customized COPA info providers and related objects.

Developed custom BW info providers for New GL data, built BPC staging layer objects for loading new GL data from ECC/BW for Financial, sales planning and consolidation models.

Worked on the complex BW transformation, complex business KPI models.

Build custom extracts using DB Connect for historical data from Performance point.

Developed complex BEx queries for inventory, Head count reporting and KPI reporting.

Transported the objects from Development to Production through Quality system.

Created Authorizations for users to access only the corresponding company codes data.

Created complex formatted Web reports using Web Intelligence.

Involved in cutover activities for Go Live.

Involved in the preparation of Health reports for the project Management.

Ensure quality and timeliness of the Deliverables.

Designed and created reports using Web Intelligence (Webi) in Business objects.

Designed Web intelligence Reports on SAP BW / Bex queries using BICS connection.

Involved in Support pack upgradation Testing Activities.

Generated Pictorial views in the form of graphs, pie charts and cross tabs from existing reports and Chart wizard.

Created Complex Reports by using multiple data providers to combine 3 reports as a single Report in Webi.

Implemented Security Features of Business Objects like row level, object level and report level to make the data secure.

Coordinating development between offshore and onsite teams. Interactions and dependency handling with Test team, Users for UAT.

Status reporting to management and steering committee teams.

Created WebI and Analysis tools for Excel reporting in deploying the inventory and KPI reporting.

Built the data flows in LSA Architecture i.e., Built the Pass through, corporate Memory, Propagation, Business Transformation and the reporting Layer.

Built the info packages/Data transfer process and the process chains to schedule the data loads in Business warehouse.

Mapped the created cubes into the Existing Multi Provider.

Coordinating development between offshore and onsite teams. Interactions and dependency handling with Test team, Users for UAT.

Status reporting to management and steering committee teams.

DuPont Sept 2010 – Mar 2013

SAP BW BO Consultant

Roles and Responsibilities:

Involved in Activating Business Content for Standard Info cubes, Info sources & Info objects of SD, MM, and FI Modules as per the Client Requirements.

Worked on support environment of SAP BI/BW includes Tickets, Task handling and monitoring from using info package groups, Process chains.

Developed technical specifications from functional specifications

Worked on new Data sources development and enhancement of standard data sources

Worked on deployment of process chains for all transaction data and master data loading

Worked on Data Loading activities such as master data loading as well as Transactional data loading Using process chains.

Experience in Data modelling, Data Extraction and Reporting using Logistics Cockpit, Generic Extractors, Data Loading, Scheduling and Monitoring.

Experience of SAP BI/BW components like Data source Enhancement, Bex Reporting- Including Web Reporting, OLTP extraction data, Loading (Full /Delta Up-Load), Scheduling, Monitoring, Process Chains.

Generated Pictorial views in the form of graphs, pie charts and cross tabs from existing reports and Chart wizard.

Implemented Security Features of Business Objects like row level, object level and report level to make the data secure.

Designed Universes and classes by Business Objects XI 3.1 enterprise tool and build all the objects required for Webi reporting which performed selecting, joining tables, cross tab, ranking, and alter functions.

Monitoring the process chains and analysing the reasons for frequent failures of Info packages. Exclusively Involved in Performance Related issue - Improved data load and query performance using compression, Statistics, aggregates, partitioning and BWA.

Generated BO Reports involving Complex Queries, Sub Queries, Unions and Intersection.

Exported Universes to the Repository to make resources available to the users.

Generated BO Reports based on time like Year, Quarter, Month and week based on Company code and Comparative reports.

Responsible for creating the reports (On demand, Ad-hoc Reports, Summary Reports, Sub Reports, dynamic grouping, Cross-Tab.

SONY Oct 2007 – Aug 2010

SAP BW Consultant

Discover a wide range of high quality products from Sony—including electronics, PlayStation, movies, music and TV shows.

Roles and Responsibilities:

Involved in Requirements gathering for reports in Sales, and Classification System. Prepared the mappings of Legacy fields with R/3 fields and further with BI Info Objects. Involved in meeting with the R/3 functional teams for understanding the process changes and Classification system.

Worked extensively with the Data Model design for the Sales reporting requirements. Worked extensively with Data Warehouse Workbench for Modelling, Monitoring, Scheduling DTP/Info package and Process chains.

Designed the Data Model, Logical and Physical Data Models in the Sales (SD).

Created Transformation Routines for Transformations.

Performed Data loads for Transaction/ Master Data using Process Chains.

Created transport requests. Transported the objects.

Maintained Info Cube, Update Rules and Creation of Info Package and scheduling the data into the Data Targets in development system as per the work request (development request).

Extracting Master & Transaction Data using Generic Data Sources from OLTP.

Uploaded Transaction Data from the Flat File as the Source System.

Involved in high-prioritised tickets regarding extractions, Performance Issues and also load failures.

Worked on LO extractors 2LIS_11_VAHDR, 2LIS_11_VAITM, 2LIS_12_VAHDR, 2LIS_12_VAITM, 2LIS_13_VAHDR, 2LIS_13_VAITM, 2LIS_02_HDR, 2LIS_02_ITM & 2LIS_02_SCL.

Designed and developed cubes and DSO 0SD_C01 (Customer), 0SD_C02 (Delivers), 0SD_C03 (Deliveries), 0SD_O01 (Order Items), 0SD_O02 (Returns Items), 0SD_O03 (Returns Items) adding purchase order no and item no and 0PUR_C01 (Purchasing Data).

Manually scheduling info packages for both master data and transaction data as a part of weekend and monthly activities as per the business requirement.

Expertise in day-to-day activities like Scheduling, monitoring process chains for daily Master data and Transaction data, Changing and activating reports as per the requirement, Handling Tickets, Data load failures

Maintaining Reconciliation’s to verify the data in SAP R3 and SAP BW are same or not after the data loads.

Created Transfer Rules & Update Rules as part of enhancement (Change Request).

Involved in enhancing reports as per the user requirement based on the business document.

Worked on BEx Query Designer, BEx Analyzer to develop various queries based on user requirements as well as utilization of business content related queries and workbooks.

Using BEx Query Designer Formula variables, Conditions, Exceptions, Exception aggregation, Cell editors, Customer exit variables and Structures for developing complex custom reports.

Worked with RKF’s and CKF’s in the queries.

Handled various day-to-day Tickets of all priority/severity levels on Incident Tickets, Change Request Tickets and Problem Management Tickets.

Documentation for the problems faced and the rectification.

Knowledge transfer to shadow resources regarding technical guidance & project.

Education:

Master of Business Administration (MBA) specialized in information systems -2005, Bangalore University, Bangalore.

Certifications:

SAP Certified Application Associate - SAP HANA 1.0

Contact this candidate