Vikas Tahlani

BI Expert(Informatica)

Flat-****, Tower#11

Sector –R3, Amanora Park Town

Teradata, Pune, India

Hadapsar - Pune-410028

Phone No: +91-855*******

Email: acqdrt@r.postjobfree.com

DOB: 11th Dec, 1988

Professional Summary:

4.5 years of experience in design, development and implementation of various BI - DWH projects (Informatica).

Extensive experience in extraction, transformation and loading of data directly from different heterogeneous source systems like flat files, Oracle and Teradata.

Responsible for interacting with business users to identify information needs and business requirements.

Prepared design, specification documents and test plan, test cases, test data (Unit and Integrated Test Plans) to test application using business, functional, design requirements.

Highly flexible and capable of quick learning new tools and applications.

Experience:

Working as Associate Technical Consultant in Teradata, Pune from Jan 2014 to till date

Earlier worked as System Engineer in TCS from Mar 2011 to Dec 2013

Achievements:

Awarded with Teradata Employee of the Quarter Award Q4-2014 for outstanding performance and excellent contribution in the DWH project for Telecom Giant based out of Ireland.

Awarded with 4 times TCS-GE Customer Appreciation Award for Outstanding performance in bringing delight to GE IM Project Managers (Customers).

Have been certified as Six Sigma Green Belt aligned towards process improvement of projects.

Awarded with two times TCS On Spot Award for outstanding contribution to the organization.

Awarded with rare TCS gems in ILP (Initial Learning Program-Training period) which is only given in TCS if trainee performs extraordinarily throughout the ILP.

Several Appreciation notes from Group Lead, Site Lead, Account Manager and Project Manager for successful delivery of projects I assigned to, supporting others for making their project delivery on time.

Educational Qualifications:

B.E (Electronics & Communication) with distinction (78%) from Rishiraj Institute of Tech., Indore ( RGPV University) in June 2010.

Class XII with 72 % from DAV Public School (CBSE) in 2006.

Class X with 72 % from DAV Public School (CBSE) in 2004.

Software Proficiency:

IDE/Tools : Informatica 9.1/8.6, Metreo Vision 3.2

Programming Languages : C, C++, PL/SQL

Operating System : Windows-7 /XP.

Scripting Language : Unix Shell scripting

Data Base : Oracle, Teradata(14.0 and 14.1)

Project Profile:

Project # 1

Project Name:

Eircom

Client

Eircom – Ireland

Role

SME

Organization

Teradata

Duration

Jan 2014 till date

Tools:

Informatica 9.5, Quality Center

Database:

Teradata

Project Description:

The Sunrise project at eircom isntegrate existing Mobile and Fixed line data and a newer fixed-mobile converged set of data into a single data warehouse model on a Teradata platform, with a single enterprise business intelligence solution delivered using MicroStrategy.

A new Data Warehouse database will be implemented on the new Teradata platform to store all data in a single database repository. The benefit of this integration approach is that it provides a single platform, capable of analyzing the entire business regardless of business unit, customer or product type, and reduces the overhead and maintenance of existing separate analytical environments.

Project # 2

Project Name:

Marketing and Visualization Ops

Client

GE Oil & Gas

Role

Team Lead

Organization

Tata Consultancy Services

Duration

Aug 2013 Dec 2013

Environment

Solution Environment:

UNIX Operating System

PL/SQL

Tools:

Informatica 9.1

Database:

Oracle

Project Description:

The Project Marketing and Visualization Ops is mainly responsible to develop ETL’s to bring all the legacy data as well as the recent data(stored in Support Central as Data form) for the six different KPI(Key Process Indicator) under one structure, and also to bring the automation for the entire process.

The desired goal was to create/manage any triangulation scenarios in Tableau with one Master Fact craved out of all six KPI, and also with the individual KPI.

Project # 3

Project Name:

GE Transportation SAS

Client

GE Transportation

Role

Module Owner (Developing & Unit Testing)

Organization

Tata Consultancy Services

Duration

Jan 2013 July 2013

Environment

Solution Environment:

UNIX Operating System

ORACLE PL/SQL

Tools:

Informatica 9.1

Database:

Oracle Exadata

Project Description:

The design goals of the Tieout Automation of the GE Transportation to Initially replicate the existing Tieout comparison process for both ADW and ODW in automated process, Reduce the Tieout comparison time and avoid the manual intervention, Enable existing Automated Process for Identifying Missing/ updated records and create/update the Missing & Defective records in a dataset with change Type.

The Tieout includes the Automation from Informatica and SAS

Informatica Automation : Execute Tieout queries for ODW data and produce the flat files and FTP to the SAS server

SAS Automation:

1.Execute Tieout queries for ADW data and compare the ODW data received in flat files and produce the comparison reports

2.Identifying Missing/ updated records and create/update the Missing & Defective records in a dataset

Project # 4

Project Name:

GE Wind Parts Metreo – Enhancement 2013

Client

GE Power & Water

Role

Team Member

Organization

Tata Consultancy Services

Duration

May 2013 Sept 2013

Environment

Solution Environment:

UNIX Operating System

PL/SQL

Tools:

Informatica 9.1 Metreo Vision 4.3

Database:

Oracle

Project Description:

The Project GE Wind Parts Metreo – Enhancement 2013 is mainly responsible to develop ETL’s for GE Wind Parts Metreo by getting the pricing, sales and cost data of the Parts Business of GE Wind and this data will be used by the Metreo Vision Application to generate its vector cube and display Analytics.

The GE Wind Parts business is implementing one instance of Metreo Vision, a pricing cube to display multiple waterfall elements, including cost data. User access to this cube is restricted because of the sensitive nature of the cost data.

Project # 5

Project Name:

GET BI Program BGL – 2012

Client

GE Transportation

Role

Team Member

Organization

Tata Consultancy Services

Duration

Jan 2012 Dec 2012

Environment

Solution Environment:

UNIX Operating System

PL/SQL

Tools:

Informatica 9.1/8.6

Database:

Oracle

Project Description:

The Project GET BI PROGRAM BGL – 2012 is mainly responsible to develop ETL’s for capturing the incremental, insert, update and delete logic for the source and bringing that into the target environment out of which reports can be generated. Besides it includes tracking the status of any change i.e. records insertion, updation and deletion of records of those targets in separate control tables through CDC logic.

Project # 6

Project Name:

GE Wind Parts Metreo

Client

GE Energy

Role

Team Member

Organization

Tata Consultancy Services

Duration

Mar 2011 Dec 2011

Environment

Solution Environment:

UNIX Operating System

PL/SQL

Tools:

Informatica 8.6 Metreo Vision 4.3

Database:

Oracle

Project Description:

The Project GE Wind Parts Metreo is mainly responsible to develop ETL’s for GE Wind Parts Metreo by getting the pricing, sales and cost data of the Parts Business of GE Wind and this data will be used by the Metreo Vision Application to generate its vector cube and display Analytics.

The GE Wind Parts business is implementing one instance of Metreo Vision, a pricing cube to display multiple waterfall elements, including cost data. User access to this cube is restricted because of the sensitive nature of the cost data.

Contribution:

Interact with Business Analyst to understand the business requirements Performed Impact Analysis and submitted Impact Analysis Document to the customer.

Prepare project plan and obtain management approval of the project plan.

Prepare a Star Schema model which supports the combined structure for legacy and current data.

Assure that all team members understand their roles and accept their responsibilities.

Developed transformation logic and designed various Complex Mappings using the Designer.

Testing and validating data along with the test cases.

Follow all the milestone process along with Change Control to move any changes to production.

Coordinate technical decisions.

Performance metrics - Collect and report on project status, progress toward milestone completion and general health of the progress towards completing the Plans.

Contact this candidate