Developer Sap
Resume:
Aakash Yadav SAP Hana Consultant
Ph. +91-776*******) Schlumberger Pune India
***************@*****.***;
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