Ankur Agrawal

Email: ac6n5q@r.postjobfree.com Address: - 2260 Hassel Rd,

Phone: 224-***-**** Apt# 312, Hoffman estates

IL 60169

With 6 years of experience in business intelligence as an ETL developer, aiming to give my best at work and ready to learn new things and utilize the knowledge, skills and expertise for the growth of organization.

Career Highlights

Worked with Infosys Ltd Pune (23rd Oct 2017 – 6th Apr 2018)

Worked with Cognizant Technologies Soln. Pune (9th July 2014 – 22nd Aug 2017)

Worked with TATA technologies Ltd. Pune (14th Feb 2011 – 6th July 2014)

B.E. in Information Technology (2006 - 2010)

Professional skills

Informatica Power Centre 9.x

Informatica cloud application

Unix shell scripting

Oracle/Greenplum/Teradata database

SQL

HDFS/Hive

Projects

Daimler Analytics

Tele2 Data warehousing

Reliance JIO 4G – BI implementation

Abdul Lateef Zameel BI Implementation project – SAHAL

Tata Motors CRM & DMS Application Program

Tata Motors OBIEA Upgrade Program

Sr. Client Project / Assignment Duration

1

Daimler

(Automotive

domain)

Daimler Analytics

The Daimler Group is one of the largest producers of premium cars and the world’s biggest global manufacturer of commercial vehicles. Ensuring this, Infosys will be looking after the Analysis track by setting up an Applied Analytics platform, fulfilling all information delivery requirements which includes various source system integration, data loading, reporting to business users etc.

Total

5

Months

Sr. Client Project / Assignment Duration

2

Tele2 AB

(Telecom

domain)

Tele2 Data warehousing

Tele2 AB is a European telecommunications operator has launched its telecom services in many countries. Ensuring this, Cognizant will be looking after the Analysis track by setting up an Applied Analytics platform, fulfilling all information delivery requirements which includes various source system integration, data loading, reporting to business users etc.

Total

2

Months

Sr. Client Project / Assignment Duration

3

Reliance Jio

Infocomm 4G

(Telecom

domain)

RJIO 4G BI Implementation

India’s biggest industrial house is launching its 4G services across India towards the end of this year. Ensuring this, Cognizant will be looking after the Analysis track by setting up an Applied Analytics platform, fulfilling all information delivery requirements which include these below tracks -

A. DPI – Deep Packet Inspection

B. SFG – Site Forge

C. CGNAT – Carrier guide network address translation D. REG – Telecom regulatory

Total

2.7 year

Sr. Client Project / Assignment Duration

4

TATA Motors Ltd,

India(Automotive

domain)

TATA Motors CRM & DMS Application Program

Tata motors have built its DMS using Oracle’s Siebel verticals and uses Siebel eDealer, Automotive and Siebel Analytics for all pre and post sales operations. The real time availability of Customer and product information is enabling the company and its channel partners to

improve response time and Customer Service. Being

implemented in phases since 2003 the combined on-line CRM- DMS initiative now August 2013 supports over

25000 users and 2000+ locations,within the company and among its channel partners in India and abroad, to conduct all customer facing transactions.

Total

1.5 year

Sr. Client Project / Assignment Duration

5

TATA Motors Ltd,

India

(Automotive

domain)

OBIA Upgrade Program

Tata motors have upgraded from Siebel 7.8 to Siebel 8.1 in April 2012 for which there is Upgradation of Siebel Analytics i.e. Oracle Data base Schema 7.8.4 to Oracle Data base Schema 7.9.6.2 and Informatica power centre 7.1.2 to Informatica power centre 8.1.6 and After Upgrade to new versions TATA Motors Ltd has again improve response time to its Application Users and provide many more improvement in functionalities. Total

1 year

Sr. Client Project / Assignment Duration

6

Abdul Latif

Jameel

(Automotive

domain)

ALJ BI Implementation -

Project SAHAL

ALJ has implemented its Siebel CRM 4 - 5 years before but now they have implemented its Analytics Application and following are the modules that we have delivered to them

A. CRM – Customer module

Voice of guests

Guest delight index

Lead Generation

Service appointment

B. Unified Customer Module

C. Customer 360

Total

9 months

My Roles –

Build ETL Mapping,workflows to extract data from a source to a target and schedule them in informatica power center based on essential business needs.

Deploy transformations to cleanse, format, join, aggregate, route data and other transformation in informatica power center mapping designer.

Apply Informatica power center performance tuning methodology

Design error handling strategies appropriate for the intended purpose of a workflow

Perform error handling/trapping using mappings

Migration of Informatica repository from one environment to other.

Managing database object like Index, Views, Tables, Query writing for the databases like Oracle, Greenplum etc.

Writing SQL query and procedures and Solving issues.

Design, Setup, Execute ETL through DAC11g or by schedule workflows in informatica workflow manager.

Migration of DAC repository from one environment to other.

Complex Unix shell scripting for – typical operations include file handling, file manipulation, file formatting program execution, printing text, monitor several tasks like disk usage, taking data backups and snapshots

Python scripting for file handling, file manipulation and other tasks. My Responsibilties -

Development of New Module - Full fill all the requirements related to the development of new Tracks and complete them as soon as possible.

Change Request - To check change requests raised every day, do the required development and closing the requests as soon as possible.

Support Request - To check the support requests created every day, find the solution for the same, taking approvals if required, implementing the solution and closing the SR as earliest.

Migration Activity– After completing the development of tracks will migrate informatica & UNIX code from dev env. to qa env.

Academic profile

Pursued Bachelor of Engineering (2006 - 10) in Information Technology discipline from RGPV University, Indore

Aggregate percentage in B.E. is 65.67%

Personal profile

Name : Ankur Agrawal

Father Name : Mr. Sunil Agrawal

Date of Birth : 25 August 1988

Sex : Male

Marital Status : Married

Nationality : Indian

Language known : English,Hindi

Brief Profile: I am self-confident, friendly and helping.

Strengths: Willingness to learn, problem solving, Positive Thinking.

Hobbies & Interests: Playing Table Tennis, yoga. Declaration

I here by declare that the above mentioned information is correct up to my knowledge and I bear the responsibility for the correctness of the above mentioned particulars. Date: 08/10/2018

Place: Chicago ANKUR AGRAWAL

Contact this candidate