ETL Developer

VIGNESHWARAN.B

*************@*******.***

Contact: +91-801*******

`

CAREER OBJECTIVE

To find an art gallery, a firm, to showcase my painting i.e. my skills, for the development of my art and art gallery.

EXPERIENCE SUMMARY

1.Having 3 years of Experience in Data Warehousing as ETL Developer using Data Stage.

2.Good working experience with Parallel jobs in Datastage 11.5 and 11.3 version.

3.Experience in implementation of ETL methodology in data Extraction, Transformation and Loading.

4.Experience in extraction of various data sources like Oracle, Excel files, flatfiles.

5.Experience in Oracle.

6.Experience in Cisco Tidal and Jira

7.Good domain knowing on Mortgage banking

EMPLOYMENT SUMMARY

Employer

From

To

Tata Consultancy Services Limited

21-Dec-2015

Till Date

TECHNICAL SKILLS

Operating Systems

Windows 7

Languages

SQL

DBMS

Oracle

Tools

IBM Infosphere Datastage 11.5 and 11.3, Cisco Tidal

EDUCATIONAL QUALIFICATION

EXAMINATION PASSED/DEGREE

INSTITUTION

YEAR OF

PASSING

AGGREGATE

B.E(Mechanical

Engineering)

Sri Sai Ram Institute of Technology,Chennai-44

2015

7.57

HSC

Zion Matriculation Higher Secondary School,Chennai-73

2011

89.3%

S.S.L.C. Examination

Zion Matriculation Higher Secondary School,Chennai-73

2009

89.2%

PROJECT AND TASK DESCRIPTION

Project #1

Title of the Project

Enterprise Data Modernization

Client

Flagstar Bank

Project Type

Development

Role

Developer

Skills Applied

IBM Infosphere Datastage v11.5, IBM Infosphere Datastage v11.3, Oracle

Duration

Mar 2016 to Till Now

Description

As part of this Data Modernization program a new data warehouse(EDW) is build to replace the existing data warehouse(DW) which is too complex. Currently DW ETL logic is done using PL\SQL and in EDW the ETL Code is implemented using Datastage. As part of Modernization Datamarts are built based on business requirements

Contribution

Working with Clients to gather the requirements and document the technical requirements

Design and build efficient ETL solutions that satisfy all functional and technical requirements

Creating possible generic ETL patterns for effective code management and development

Provide support for user acceptance testing,defect triage and release management for project deliverables

Provide support for on History Catchup upon production implementation

Perform data analysis and data pull when required for analysis

Performing data analysis when there is any discrepancies while doing a reconciliation between existing DW and new EDW

ACHIEVEMENTS

Received Star of the Quarter award for the 2016 Q3

Received multiple appreciations from clients for data analysis and hitting the ETA during production delay

PERSONAL DETAILS

Father’s name: Mr. Baskaran.S

Date of Birth: 18.06.1994

Sex: Male

Total Experience: 3 years and 4 months

Contact: Ph: 801-***-****

Mail: *************@*******.***

DECLARATION

I hereby declare that all the particulars stated above are true to the best of my knowledge and belief.

VIGNESHWARAN.B

Contact this candidate