Aakash Yadav SAP Hana Consultant

Ph. +91-776*******) Schlumberger Pune India

adexvn@r.postjobfree.com;

Professional Summary

Technical

Functional

* ***** * ****** ** total IT experience in SAP HANA Modelling and Development, Power BI dashboards and supporting existing WebI reports on top of SAP HANA.

Working on Celonis process mining tool for few weeks.

Achieved External certificate in HTML and SharePoint.

Achieved Certificate of Appreciation within 6 months in Schlumberger.

Manages time efficiently and effectively through scheduling and prioritizing

Enjoy working in a multi-cultural, fast paced and simulating environment

Flexible and adaptive to change; resourceful in getting the job done

A team member and lead with strong interpersonal & analytical skills

Work Experience

SCHLUMBERGER-India.

Designation: Celonis Data Scientist

Duration: 1st May 2020 – Till Date

Project Description:

Deployment of various Dashboards on Celonis process mining tool. As of now ‘Procure to Pay’ and ‘Vendor Invoice Management’ reports are created on top of SAP HANA. These reports are used by management in Schlumberger to analyze the progress of purchase orders and to resolve if any hiccups delaying the process.

Designation: BI/BO Analyst

Duration: 9th April 2018 – 30th April 2020

Project Description:

It involved working with Schlumberger India, the world's largest oilfield services company. It is involving the table migration from SAP ECC system to HANA through SLT process (Data provisioning). HANA views creation to pass to informatica, also these HANA views are used for Power BI report creation.

Implementing Smart Data Integration logic for delta loads behind the Power BI reports.

Role: HANA Developer.

Project Activities:

oHANA Information objects creation as per the demand for Power BI reports.

oRequirements gathering from the user for both HANA and Power BI. And deciding on the approach to achieve it.

oWorking as a Charm lead responsible for the migration of Hana objects from one environment to another using Charm Document. Also managing release into production.

oReplication of the table from ECC system to HANA database using SLT process.

oSupporting WebI reports based on top of HANA views.

oWorking as Power BI dashboards developer on top of SAP HANA database.

oImport/Export in SAP HANA.

oCreating Procedures and Table Function.

oManaging analytical privileges.

oWorking on to resolve production defects and Incidents by using HPALM and Remedy Tools.

oWorking on to enhance the performance of the HANA views by using PLANVIZ.

oActively involved in cutover activities, Production Go live and Postproduction Go Live and resolving issues.

INFOSYS LTD.

Designation: Technology Analyst

Duration: 5th March 2012 – 28th Feb 2018

Project Information:

R2.1 SLB Migration

Client: Schlumberger Inc.

Project Title: R2.1 BW HANA migration

Technology: SAP HANA Modelling, SAP HANA Development, Data Provisioning

Duration:1st Feb to till date

Location: Pune

Project Description:

It involved working for Schlumberger account, the world's largest oilfield services company. It is involving the table migration from SAP ECC system to HANA through SLT process (Data provisioning). And then creating the HANA views on those tables. On top of these Hana views WebI reports are created.

Role: Developer.

Project Activities:

oHANA procedures being created for passing the input parameters in HANA views.

oOn top of the available tables, calculation views are being created.

oReplication of the table from ECC system to HANA database.

oWebI report creations on top of HANA views.

oImport/Export in SAP HANA.

oCreating Procedures and Table Function.

oWorking on to resolve production defects and Incidents by using HPALM and Remedy Tools.

oWorking on to enhance the performance of the HANA views by using PLANVIZ.

oActively involved in cutover activities, Production Go live and Postproduction Go Live and resolving issues.

ABI

Client: Anheuser-Busch Inbev

Project Title: KPI

Technology: SAP HANA Modelling, SAP HANA Development

Duration:1st Jan 2016 – 30th Jun 2016

Location: Pune

Project Description:

It involved working for AB-InBev, one of the world's largest Beer retailers. Database being used is HANA. Using the Hana procedurs we are uploading the User’s data into HANA Database. Then the HANA Modelling Views are created. Business is using QlickView reporting tool to analyze the data further.

Role: Developer.

Project Activities:

oHANA procedures were created for validation or uploading of the data.

oOn top of the available tables Attribute, Analytical and calculation views were created.

oUploading the data from flat files to HANA database.

Atradius

Client: Atradius

Project Title: Finance Evolve

Technology: Business Objects WebI, Crystal Report, Universe Designer, SAP HANA Database

Duration:1st May 2015 – 31st Dec 2015

Location: Pune

Project Description:

It involved working for Atradius, one of the world's largest credit insurers. The backend database version was upgraded which was involving a lot of tables to be removed or newly tables added in the database. Some of the names of table’s column were changed. Due to this we had to modify the universe completely on the basis of current objects in the database. After the Universe changing part was done, we had to change all the reports which were already existing using the old objects. And had to create new reports as well based on newly added tables and all.

Role: Developer.

Project Activities:

oDevelopment activities. Handling various types of WebI reports and implementing them right from coding, testing to maintenance.

oChange in the universe designing based on updated database.

oHaving a very good know how of the entire software life cycle and following it in everyday tasks.

oHANA procedures were created for validation or uploading of the data.

oOn top of the available tables Attribute, Analytical and calculation views were created.

oUploading the data from flat files to HANA database.

Aetna Health Insurance

Client: Aetna, Inc.

Project Title: AOC

Technology: Business Objects WebI, Crystal Report, SAP HANA DATABASE

Duration:1st September 2014 – 31st April 2015

Location: Pune

Project Description:

It involved working for AETNA, one of the US’ largest healthcare insurance domain companies. We created reports based on different needs using Business Objects Web-Intelligence and crystal reports.

Creation of universe based upon the needs of our reports for which back-end database was SAP HANA.

Using BO-Web Intelligence for creation of reports for various states and physician groups across the company and optimizing the report creation. Report validation was done using standard templates and testing for error free reports.

The reports were developed from Scratch. All the database procedures were also created from scratch. The reports were being used by the business to get the information of all the insurance sold on interval basis and the seller of the insurance.

Role: Developer.

Project Activities:

oDevelopment activities. Handling various types of WebI reports and implementing them right from coding, testing to maintenance.

oHaving a very good know how of the entire software life cycle and following it in everyday tasks.

oHANA procedures were created for validation or uploading of the data.

oOn top of the available tables Attribute, Analytical and calculation views were created.

oUploading the data from flat files to HANA database.

Aetna Health Insurance

Client: Aetna, Inc.

Project Title: Managed Services- Reporting

Technology: Business Objects WebI, Crystal Report, Universe Designer, SQL Server

Duration:1st June 2013 – 31st Aug 2014

Location: Pune

Project Description:

It involved working for AETNA, one of the US’ largest healthcare insurance domain companies. We created reports based on different needs using Business Objects Web-Intelligence and crystal reports.

Creation of universe based upon the needs of our reports for which back-end database was SQL.

Using BO-Web Intelligence for creation of reports for various states and physician groups across the company and optimizing the report creation. Report validation was done using standard templates and testing for error free reports.

With the help of these reports, AETNA was able to analyze the performance of the brokers and accordingly they come to know the amount AETNA need to pay to Brokers. The project is continuously getting excellent client feedbacks.

Role: Developer and Application supporter.

Project Activities:

oMajorly enhancement and development activities. Handling various types of WebI reports and implementing them right from coding, testing to maintenance.

oHaving a very good know how of the entire software life cycle and following it in everyday tasks.

oSometimes being a part of the project’s production support team, I was handling the responsibility of monitoring the jobs and upstream systems in production environments.

oMaintaining knowledge base to facilitate and improve support tasks.

oDoing Impact Analysis of various scenarios and modifications.

Infosys Education & Research

Client: Infosys

Project Title: Training Reports

Technology: Business Objects WebI, Crystal Reports 2008, SQL Server 2008, MS .NET

Duration:1st June 2012- 15 May 2013

Location: Pune

Project Description:

Infosys training is the best training among all the organizations in India. We developed some reports to analyze the performance of the trainees. Most of the work was in SQL and crystal reports. MS .Net was used as a front end to insert data so have done some work on .Net technology also. With the help of this they used to get information about the areas of training need improvement.

Role: Developer and Application Supporter.

Project Activities:

oDevelopment of WebI and Crystal reports which run Daily/weekly/monthly to analyse the performance of the trainees.

oBack-end database used is SQL Server 2008

oModification of existing Crystal reports. This came up due to change in one column structure at the database level.

oTesting of new and modified reports.

Education

Currently Pursuing M.Tech in Data science & engineering from BITS Pilani under WILP program.

Other Achievements

Won a District level medal in THAI boxing in Pune.

Personal Dossier

Birth Date : Aug 01st 1988

Languages Known : English, Hindi

Temporary Address : A601 Erica Society Wakadkar Wasti Wakad Pune - 411057

Permanent Address : A601 Erica Society Wakadkar Wasti Wakad Pune - 411057

Nationality : Indian

DECLARATION

I do here by declare that all the information provided above is true and correct to the best of my knowledge.

Date:

Place: Pune Aakash Yadav

Degree/Course

Institute

Board/University

Year

% Marks

B.Tech (Computer Science and Engineering)

Inderprastha engineering college,

Ghaziabad

Uttar Pradesh Technical University

2011

75.1%

H.S.C.

Saraswati Vidya Mandir, RATH

Uttar Pradesh Board

2005

75.4%

S.S.C.

Saraswati Vidya Mandir, RATH

Uttar Pradesh Board

2003

69%

Contact this candidate