Santosh Kumar

SAP HANA Consultant

Ph: 201-***-****

ad3f5j@r.postjobfree.com

Professional Summary:

Certified SAP HANA (Certification Id:002*******).

SAP Consultant with 10+ years of extensive experience in IT industry which includes SAP HANA (1.0) and SAP HANA (2.0), and SAP BO experience playing various key roles in Design, development and production support.

Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using SAP SLT, SAP Data Services & Informatica Power Center.

Skillful in creating and developing Web I, Power BI Dashboards, SAP Analytics Cloud into rich look.

An effective communicator with strong analytical / logical skills and ability to relate to people at any level of business and management and A quick learner with the ability to work under pressure and meet deadlines.

Strong knowledge in the areas of SQL which has DDL, DML, DRL, DCL and TCL statements.

Ability to work with various types and stages of Software Development Life Cycle (SDLC) process including Analysis, Design, Development, Testing and implementation of business applications using Agile and Waterfall methodologies.

Experience in Scrum methodology for software delivery and support by creating user stories, updating day to impediments to maintain the dependency and closing tasks with day-to-day activities.

Involved in design specification, development, performance tuning, testing, documentation, Go-live and maintenance.

Experience in HANA models creation like Attribute, Analytic and Calculation Views & schemas and table definitions.

Experience in design and development of Calculation views using Graphical and Script based.

Implementation of SQL Script stored procedures for data intensive jobs to be utilized in Calculation views.

Good understanding of SAP HANA concepts In-Memory Computing,RowStore, Columnstore, Data Compression, Partitioning, Data Provisioning, Modeling and Reporting.

Expertise in HANA WEB IDE creating calculation views,roles,CDS tables.

Expertise in HANA 2.0,moving changes using BIT BUCKET.

Expertise in Enterprise HANA/Native HANA and SAP BO powered by HANA.

Experience in replicating the data from SAP / Non-SAP sources to SAP HANA using SAP Landscape Transformation (SLT), Business Objects and Data Services (BODS).

Expertise in HANA data modeling/data profiling, like creating information models using Calculating Views (both Script based & graphical) in SAP HANA studio.

Developed HANA models using all modeling capabilities in Hana studio.

Experience in creating Stored Procedures and Exposure on Decision tables.

Experience in creating table functions.

Worked on SQL Scripting in HANA studio.

Experience in designing and building Analytical Privileges.

Involved in Transporting HANA content from development to testing environment and testing to production environment using delivery units and Import/ Export methodology.

Working Exposure onSmart Data Access(SDA).

Experience with integration of HANA with BO Components.

Experience with Performance Tuning in HANA Database by using plan Visualizer.

Discussion with customer about business pain points.

Good analytical and communication skills, ability to perform in team as well as independently.

Reporting:

Webi:-

Information Designer Tool, Web-Intelligence, SAP Lumira, SAP HANA and Informatica.

Created universe using IDT on top of HANA Views and built WebI reports.

Fixing Universe and report level issues.

Creation & enhancement and support of Universes.

Experience in developing different kinds of reports\Dashboards using Desktop Intelligence, Web Intelligence,Lumira, and Business Objects Dashboards

Validated data in the reports against the databases, Fine-tuned query performance of all the reports.

Excellent analytical and communication skills that is required to work effectively in the field of applications development and maintenance.

Education and Certifications:

B.Tech from KITE College of Engineering (JNTU), SHABAD. 2013

SAP HANA certification with Certification ID 001*******

Certifications:

SAP Certified Application associate (C_HANAIMP_13) - SAP HANA 2.0

Professional Experince:

SAP Consultant with 10+ years of extensive experience in IT industry which includes SAP HANA (2.0), and SAP BO experience playing various key roles in Design, development and production support.

Deloitte, NJ May’2023 to Till Date

SAP HANA Consultant

Description: STAFFFIT application is a global solution supporting the resource management processes for various member firms. The business should have the ability to see a consolidated view of all available resources for a member firm with real time/near real time changes and all historical data available.

Responsibilities:

Developed calculation view on top of master and transcational data, used input parameters in the bottom level to increse the performnce of the view.

Created Stored Procedures and table function using tranctional data.

Expertise in creation of complex calculated columns.

Worked on day to day business requirements into SAP solutions and writing clear and complete functional specifications for all elements of RICEFW (Reports, Interfaces, Conversions, Enhancements, Forms and Workflow)

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

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

Worked with HANA Modeling - Calculation Views with different joins and unions used in the HANA modeling e.g., Inner join, Outer joins, Referential joins etc and Worked with Aggregation, Projection, Star Join, Union, Inner Join, Left Outer Join and Text Join

Worked on input parameters, variables, joins, and currency & unit conversions.

Monitoring the XS jobs on XS DASHBOARD.

Discuss with Business users to define and document new or enhanced reporting requirement.

Provide training assistance to business users on the reporting tool for generation of reports and dashboards.

Design,developmet,testing implementation and maintenance of business intelligence (BI) reports.

Environment: SAP HANA 2.0, SAP ECC,WEBI,IDT,AO REPORTS,SLT.

Anzani Group, Texas July’2019 to April’2023

SAP HANA Consultant

Description: Anzani Group is a company based out of Italy, which deal with end customers for eyesight, Its products include, with instruments, services, consumables, applications and expertise, and personal care products.

Responsibilities:

creating information models using Calculating Views in SAP HANA studio.

Once Data set is loaded in Primary table set, used ETL logic to process the data and load into to secondary table

Created batch job using Informatica to load the HANA view data into a persistent table, which will be used as a source for the dashboard for faster processing.

Developed calculation view on top of materisls data, used input parameters in the bottom level to increse the performnce of the view.

Developed Reporting table will pull the data from different Hana source tables and merge the data into single view using different kinds of joins, calculated fields.

The secondary level tables push the data directly to Hana reporting view/table for reporting purpose.

Analysis of all material cost saving for the savings,contract manufracturing,insourcing,and manual adjustments.

Environment: SAP HANA 2.0, spot fire, Informatica, SAP HANA 2.0 SP06, Tibco Spot fire, SAP ECC

Cognizant/Agilent BI AMS, Texas Nov’2017 to Apr’2019

SAP HANA Consultant

Description:

Agilent is a leader in life sciences, diagnostics and applied chemical markets. The company provides laboratories worldwide with instruments, services, consumables, applications and expertise, enabling customers to gain the insights they seek,

It is all about tracking the material in terms of purchasing raw materials for building counters or any of the external manufacturing products (nonbuilt by Agilent).

Responsibilities:

Monitoring the HANA systems and XS jobs.

Working on incidents which are raised by users, like data mismatch, errors while running the reports and performance related issues.

creating information models using Attribute Views, Analytical Views and Calculating Views (both Script based & graphical) in SAP HANA studio.

Working on Change request like creating new models, adding new fields to the models and logic changes for Calculated columns.

Have worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center.

Involved in extracting the data from the Flat Files and Relational databases into staging area.

Developed the Informatica Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers, and data flow management into multiple targets using Router.

Developed several reusable transformations and mapplets that were used in other mappings.

Analyzing and developing PLSQL stored procedures high level Change Requests which can be called from Informatica and loading data into the warehouse or flat files

Worked on different reporting tool SAP BO 4.2,Lumira.

Involving in MEC activities like taking table backup, changing the parameters for schedule reports and running the procedures.

Environment: SAP HANA 1.0, spotfire, informatica, SAP HANA 1.0 SP12, SAP BO 4.2, Tibco Spotfire SAP EC

E&Y/NESTLE, India Aug’2013 to Oct’2017

Sap HANA Consultant

Description: Nestlé is the world’s largest food and beverage company. We have more than 2000 brands ranging from global icons to local favourites, and we are present in 191 countries around the world. The Company insists on honesty, integrity and fairness in all aspects of its business and expects the same in its relationships.

Responsibilities:

Active Participation in roadmap development and responsible for project implementation.

Experience in replicating the data from SAP / Non SAP sources to SAP HANA using SAP Landscape Transformation (SLT),BODS and Importing Flat Files into Database artifacts.

Worked on Replicating Realtime time Data into Hana through SLT.

Understanding the requirements and analyzing the data models

Design and Building HANA Views (Attribute, Analytical & Calc Views).

Created Advanced Views like Graphical and Script based Calculation Views.

Created Calculated Columns,Variables, Input parameters and Restricted columns.

Worked on creating Stored Procedures for user specific data.

Worked on creating Analytical privileges both static and dynamic.

Worked on Importing and Exporting SAP HANA Data Models in hana studio.

Involved in transport of HANA views from Development to Test and Production systems using Delivery Unit.

Created Universes using IDT (Information design tool) on top of HANA calculation views and developed the Web Intelligence reports .

Worked on import data from the Bw Cubes to Hana Database.

Involved in creating and maintaining Info cubes, DSO, PSA, Info Objects, Info Areas, Multi provider, Data Sources and Info Packages.

Worked Creating Composit Provider.

Designed Technical design specification for future enhauncements and integration aspects

Environment: SAP HANA 1.0 SP05, SAP BO 4.2, Crystal Reports, SAP CRM

Contact this candidate