Pradeep Krishna Mobile: +1-610-***-****

SAP HANA, BW E-Mail: adi61c@r.postjobfree.com LinkedIn: https://www.linkedin.com/in/pradeep-krishna-gutta-a0101412

https://www.linkedin.com/in/pradeep-krishna-gutta-a0101412

A Competent professional with more than 14 years of experience in SAP HANA, BW, ABAP, BPC.

SAP Certified Application Associate in SAP HANA 1.0

SAP Certified Solution Consultant in SAP Net weaver – SAP BW.

Successfully conducted several SAP HANA/BW implementations, across US for several customers like LabCorp, Pfizer, American Water, Kimberly Clark etc.

Worked on native HANA projects, SAP BW projects, BW/4HANA or B4HANA Hybrid scenario projects, S4HANA embedded analytics projects and BW-BPC integration projects.

Worked as Techno functional lead for HANA/BW Implementations, for various domains like Pharma, Utilities, Healthcare, Retail, Finance, Sales and distribution.

S.No

Title

Certified From

Certificate ID

Certified On

1

SAP certified solution consultant in SAP BW

SAP Labs, Germany

S0004455210

15th June 07

2

SAP HANA Application Associate

SAP Labs, Germany

S0004455210

July 2013

Designed & developed various SAP HANA information models like Calculation views, Analytic privileges, Roles, Stored procedures, SQL scripting, Table functions, SDA/SDI Flow graphs, XSJS, XS jobs, HANA XS Advanced (XSA), XSODATA, SAP UI5 and custom tables in SAP HANA Studio.

Extensively used HANA SQL Script imperative language features like Variable Declarations, Control statements like IF statement, looping statements (FOR), Arrays, Cursors, Triggers, Exception or Error Handling, window functions, System views, Library functions, Sequences and Dynamic SQL.

Performed complex Hana modelling using Joins (Temporal and Dynamic), Union, Rank, Currency/unit conversion, Hierarchies, Calculated/restricted columns, Variables/Input parameters, multi-level partitioning, performance improvement and analysis using Visualize plan, Expensive statement trace.

Created SAP BW advanced DSO’s, composite providers, open ODS views, Hana analysis process (HAP), Master data info objects, Star schema, Process chains, BEX or BW Queries, Restricted Key Figures, Calculated Key Figures, Variables with User Entry, Default Value, Replacement Path, Customer Exit, HANA exit, Formulas, Filters, Default values, conditions, exceptions, cell restrictions, exception aggregation and non-cumulative key figures.

Extensively worked on SAP BW Transformations, DTPs, Start, End and Expert routines, Field level routines using HANA SQL Script, ABAP runtime, ABAP Managed data base procedures, Error handling, Texts, Hierarchies, Debugging, Full and Delta loads.

Developed Basic and composite ABAP CDS views (Core Data Services) using several annotations, advanced ABAP CDS table functions, VDM’s (Virtual Data Models) using HANA SQL Script.

Used various data provisioning methods like SLT, SDA/SDI, BODS, Files and various SAP BW extractors LO, COPA, Generic extraction, Data source enhancement, ODP-ODQ and DXC.

Worked on reporting tools like BOBI Analysis for Office, WEBI, Crystal reports, Design Studio, Lumira and Tableau.

LabCorp, Burlington, NC

SAP HANA Consultant OCT. 2019 – TILL DATE

End to End native Hana implementation of LabCorp turnaround time project.

Designed and architect complex, custom HANA solutions end to end, translating complex requirements in an optimal HANA design and created De-normalized tables in HANA to provide better analytical capabilities with star schema model.

Experience with real time replication into HANA with SDI (Smart Data Integration) work flows to transform data from source to target using adapters such as Hadoop, DB2 & Oracle.

Created stored procedures to load the data from one table to another de normalized table.

Used SQL script imperative programming language features like arrays, exception handling and inserted the record counts, error messages into log tables.

Unloaded the data from main memory and moved to the secondary storage, for historical cold data, leaving the hot and warm data in main memory.

Partitioned tables using multi-level partitioning techniques like hash in the first level and range partitioning in the second level, to improve the query performance.

Developed table functions, to implement percentile/window functions and consumed them in the Hana calculation views.

Passed input parameters, filters to the lowest table level in table functions using advanced SQL script features like Dynamic SQL, Apply filter.

Extensively worked on the performance improvement of the calculation views using plan visualizer tool and M_SQL_PLAN_CACHE tables.

Created complex calculation views and used various alternative ways to RANK node to ensure filters are passed to the lowest table level.

Transported the objects from one development to quality, stage and production using native HANA application life cycle management HALM).

Created xsjs java script files and xs jobs to schedule the stored procedures on daily, weekly and monthly frequency.

Debugged stored procedures in HANA Web IDE using break points and analyzed the data in the intermediate scalar variables and table variables.

Created analytic privileges and implemented row level security using classic and SQL analytic privilege options.

Created unique key index on top of the data base tables to improve the performance.

Developed various performance tuning methods like Union Pruning via Pruning configuration table, Join Pruning using “Optimize Join Columns”, Union pruning via constant selection and improved Performance of the calculation views.

Analyzed the performance of the Query/Calculation views using Explain Plan and make use of the Visualization Plan tools to graphically analyze the execution plan and where the process takes more time. Deep dive of logs and trace files and analysis of expensive statements.

Debugged Stored procedures in HANA web IDE using break points and analyzed the data in the intermediate scalar variables and table variables.

Scheduled Stored procedures using XS Jobs and XSJS to run on daily, weekly, monthly frequency.

Developed advanced Java Script code to schedule multiple xsjobs in parallel and reduce the time to load the data into the denormalized tables.

Used dynamic SQL features, to pass input parameter selections of calculation views into table functions.

Endo Pharma, Malvern, PA

SAP BW/HANA Consultant MAY. 2019 – SEP. 2019

End to End native Hana implementation of sales order fill rate project.

HANA Architect & delivery lead of project, that accounts to 1.7 Million of Revenue.

Replicated ECC data into HANA using SLT (SAP Landscape Transformation Replication Server) and extracted non-SAP data into HANA using SAP BODS.

Developed Calculation views and table functions on top of the base tables in SAP HANA.

Delivered high performance analytic dashboards using Tableau.

Used ETL tool Talend to load the data from non-SAP source systems.

Developed table functions and used standard SQL functions & user defined scalar functions to perform intermediate calculations.

Created stored procedures to stage the data into custom tables, to avoid performance issues.

Created several complex calculated columns to meet the business requirements.

Translated functional specifications into technical specifications and ensured a comprehensive data warehouse design.

Created advanced DSO’s, open ODS views and composite providers.

Provide ongoing support of the existing BO Reporting, Data Services and BW systems.

Implemented various performance tuning techniques in HANA.

Transported objects from development to quality and production using SAP HANA Life cycle management CTS (Change and transport system).

Retirement of various BW models and implement the model and logic in native HANA.

Single point of contact for sales order fill rate reporting for entire North America.

Extracted data from various S4/HANA systems (Simple Finance, Simple Logistics).

Very good understanding of SAP S4HANA Embedded Analytics Architecture.

Created Query views on top of composite ABAP CDS views and consumed in SAP Lumira.

Created users, analytic privileges, roles and assigned roles to users to implement security in HANA.

Extensively worked on SAP BW reporting tools like BEX analyzer, BEX Query designer, work books.

Created Restricted Key Figures, Calculated Key Figures and Variables with User Entry/Default Value, Replacement Path and Customer Exit, Formulas, Filters, Default values, conditions and cell restrictions.

Created advanced DSO’s, composite providers, open ODS views, Hana analysis process (HAP).

Extensively worked on DTPs, Transformations, Start, End and Expert routines using HANA SQL Script.

Involved in Transactional/Master data loading, Scheduling, creation/monitoring of process chains and resolving of various data load errors.

Experience in transporting BW objects from Development to quality and Production.

Kimberly Clark, Neenah, Wisconsin

SAP HANA Consultant FEB. 2018 – APR. 2019

End to End Hana implementation of KC ITAS Application IBP Project.

HANA Architect & delivery lead of project, that accounts to 1.0 Million of Revenue.

Created custom tables in HANA with UNIQUE Index and performed multi-level partition with Hash partition in the first level and Range partition in the second level.

Unloaded the tables from memory, for historical cold data and loaded into memory when required, based on Dynamic Tiering hot, warm and cold data principles.

Created input parameters and variables to filter the data and also Used “Procedure/Scalar Function” to populate the default values of the input parameters.

Created various calculated columns, restricted columns, counters wherever necessary.

Used temporal joins to model the data, based on time dependent master data attributes.

Performed delta merge operations on tables to merge the committed entries from the table’s delta storage into its main storage.

Created Level Hierarchies and Parent Child Hierarchies in HANA.

Used several system views in HANA like object dependencies, change entries and SQL plan cache.

Developed Sequences to generate sequential numbers and used in procedures to avoid complex loops.

Implemented Currency/Unit conversions in HANA using standard currency conversion tables.

Scheduled BODS ETL jobs to Load data into SAP HANA Database from source system.

Designed data flows in SAP BO Data Services for different source systems and merging them.

Collected all the HANA content/modelling objects into change request and used Application Lifecycle Management to attach the objects to SAP transport request through SAP CTS (Change & Transport System) and transported modelling objects from development to quality and Production.

Technical design and development of the HANA information models.

Developed 6 high quality reports for immediate business needs.

Successful Go Live for 15 markets and received feedback from the business as one of the report with highest number of business users.

Coordinated business analysts and onsite/offshore team members to deliver the project on time without any customer escalations.

Received several appreciations from the customer for the effective communication and high quality deliverables.

Used advanced SQL scripting like dynamic SQL, arrays, cursors and developed scripted calculation views.

Developed table functions and stored procedures for moving the data from one table to other table.

Developed customized input parameters and complex calculated columns to handle key business requirements.

Developed several Graphical and SQL Script calculation views.

Developed Analysis for office reports and Fiori dashboards.

Implemented Analytic privileges for row level security.

American Water, Cherry Hill, New Jersey

SAP HANA Consultant MAR. 2017 – JAN. 2018

End to End Hana implementation of American Business KPI project.

Onsite delivery lead of VDM phase1 project, that accounts to 1.2 Million of Revenue.

Replicated tables from ECC into HANA using SLT (SAP Landscape transformation).

Gathering requirements from business by conducting product backlog sessions.

Followed Agile SCRUM methodology with 3 weeks sprint execution time.

Proposed architecture based on the functional design of device management, revenue, Accounts receivable, tax and customer service.

Replication of base tables from ECC into SAP Hana using SAP SLT.

Created Calculation views (Cube & Dimension) based on the nature of the data.

Created scripted calculation views for scenarios not possible with graphical approach.

Developed complex calculated columns to handle various revenue categories.

Developed AO reports on top of the HANA information models.

Created Fiori tiles using ODATA Services generated from the Hana calculation views.

Generated ODATA services for various KPI’s of the American Business.

Consumed SAP HANA information models in the SAP BW system using virtual provider and built historical data snapshots.

Fetched data from the SAP BW DSO’s into SAP Hana views, for end user fiori reporting.

Handled performance related issues of the calculation views.

Published BOBJ reports to the portal, for easy access to the users through BI Launch pad.

Pfizer Inc. Collegeville, PA

SAP BW/HANA Consultant AUG. 2014 – FEB. 2017

Implementation of the BW/4HANA Hybrid scenario.

Implemented BW implementations using advanced Layered and Scalable architecture (LSA++).

Consumed BW info providers in HANA combining native HANA models with BW data models using composite provider, in B4HANA hybrid scenario projects.

Implemented HANA based BW transformations and created SQL Script (AMDP) ABAP Managed Database Procedures and ABAP managed data base functions (AMDF).

Developed complex dashboards using design studio tool.

Delivered 3 phases of EIS reports to reduce the inventory levels at the site and market levels.

Migration of the database from Oracle to the SAP HANA after upgrade.

Involved in the pre cutover activities of the HANA migration.

Used SAP best practice of System creation via production copy (“safe side”) approach.

Designed BO WebI reports for info providers using BICS connection.

Involved in Unit testing, System testing and User acceptance testing.

Involved in Customer presentations from Onsite and working on the modifications.

Worked on the conversion of selected info cubes and DSO’s to “In memory optimized”.

Actively participated in the post migration activities.

Removal of unnecessary info cubes to improve the query performance.

Consistency check of various objects of BW after migration to the HANA database.

Identification of bottlenecks in the migration process.

Enhancement of the existing master data & transaction data extractors.

Building interfaces like APD’s for the outbound systems like AURORA & LEGS.

Created the Safety stock optimization dashboard for the inventory analysis.

Created the BOBJ transports in the development system through Central Management Console (CMC).

BOBJ transport movement from development to the quality and production systems.

Created various BOBJ reports for the LEGS project using WEBI as front end tool.

Worked on the BW related ABAP, wherever customizations are necessary.

Worked on end to end implementation of the Historical inventory project with BW as back end and BOBJ tools at the front end reporting.

Educating the end users and provide the necessary training in accessing the newly created BOBJ reports through BI Launch pad.

Interacted with users in understanding the requirements and build SAP BW data flows and BO reports.

Bank of America, Charlotte, NC

SAP BW/BPC Consultant FEB. 2012 – JUL. 2014

Loading Transaction Data using a Flat File, NW BI Info Cube using Standard Data manager Packages.

Exposure in extracting data from Heterogeneous data sources like R/3 BI servers

Created Data manger packages for data loading activities and used to call script logics to perform complex calculations.

Created multiple models and dimensions based on business requirements.

Maintained master data and created required properties in Dimensions.

Prepared the Business user training manual for interfaces have done.

Provided user training about to explain planning templates.

Involved in preparing technical documentation for all BPC objects

Design and develop the BPC reports and input schedule according to business requirements.

Created the technical specifications from the functional specs received.

Worked on EPM reporting to drill through from balances to line items.

Exposure in extracting data from Heterogeneous data sources like R/3 BI servers.

Transported various objects from Development to Production.

Performed the regression testing to check the consistency of the data in special use system.

Worked on the SPO’s for different partitioning criteria.

Prepared the Business user training manual for interfaces have done.

Involved in preparing technical documentation for all BW objects.

Created Process chains for loading both Master data and Transaction data

Worked on creation of roles and authorizations to business users.

Report development according to technical specifications which includes Hierarchical functionality, prompts, formatting features of the tool.

Development of objects like info cubes, DSO’s, SPO’s and Open hubs.

Transport repackaging during go live time.

Sending Effort estimates for the new change requests.

Developed complex reports using query designer and reported through WEBI and Bex analyzer.

Involved in Performance Issues like Creation of aggregates, Partitioning and Compressed the Info cube to improve the query performance

Created Process chains for loading both Master data and Transaction data

Created transformation and conversion files to import data into BPC from data in any format from any source system.

Kraft Foods, Hyderabad, India

SAP BW Consultant APR. 2010 – JAN. 2012

Created the technical specifications from the functional specs received.

Writing Test Scripts, conducting Unit Testing and documenting the results.

Worked on EPM reporting to drill through from balances to line items.

Exposure in extracting data from Heterogeneous data sources like R/3 BI servers

Transported the objects from Development to Production.

Performed the regression testing to check the consistency of the data in special use system.

Worked on the SPO’s for different partitioning criteria.

Prepared the Business user training manual for interfaces have done.

Provided user training about to explain planning templates.

Involved in preparing technical documentation for all BW objects

Involved in Performance Issues like Creation of aggregates, Partitioning and Compressed the Info cube to improve the query performance

Created RKFs, CKFs, and Variables with User Entry/Default Value, Replacement Path and Customer Exit, Formulas, Selections, Structures, RRIs, Authorizations, Filters and Web templates.

Created Process chains for loading both Master data and Transaction data

Worked on creation of roles and authorizations to business users.

Report development according to technical specifications which includes Hierarchical functionality, prompts, formatting features of the tool.

Development of objects like info cubes, DSO’s, SPO’s and Open hubs.

Transport repackaging during go live time.

Sending Effort estimates for the new change requests.

Developed complex reports using query designer and reported through web and Bex analyzer.

Updating the Process Chain status in the portal.

Performing pre & post implementation maintenance activities, when there is a system down time for maintenance.

Experience in transporting objects from Development to Production.

Handling CRs for enhancing the process chains, data flows and queries.

Resolved the reporting related defects and coordinated with the users.

Handled post cutover and pre cutover release management activities.

Nestle Business Services

SAP BW Consultant SEP. 2006 – MAR. 2010

Second Level IM Resolution Team (Offshore). Provides the analysis of the Idoc errors & monitoring issues and provide Technical solutions for error resolution in addition to the Ad hoc and weekend activities.

SUMMARY

CERTIFICATIONS & ACHIEVEMENTS

TECHNICAL EXPERTISE

PROFESSIONAL EXPERIENCE

Contact this candidate