Technical Lead Resume

SUMMARY

Associate has around 10+ years of experience in the Information Technology industry.
His primary experience includes Design, Analysis, Development and Testing of Projects in Data Warehousing and Business Intelligence environment.
He has been instrumental and involved in all phases of many data warehousing and business Intelligence projects end - to-end solution.
He has a very good knowledge of Data Warehousing Concepts and has worked across major ETL tools - Informatica, SSIS & Databases - Teradata, Oracle and SQL Server.
He has exposure towards Data Modeling activities in his earlier projects and has worked as a Data Modeler in his previous assignments.

TECHNICAL SKILLS

Hardware / Platforms: Windows XP, Vista, 7

Technology: Data warehousing, Business Intelligence

ETL Tools: PowerCenter9.1 & 9.5, SSIS, Teradata Utilities

Database: Teradata V13/V14, Oracle 11g & SQL Server 2008 R2

Data Modelling tool: Oracle SQL Data Modeler, MS Visio

Scripting Language: Unix Shell Scripting

Version Control Systems: MS Visual Source Safe (VSS 6.0)

PROFESSIONAL EXPERIENCE

Confidential

Technical Lead

Responsibilities:

Gathering requirements from Client teams and Data Modelers.
Source Data Analysis with respect to the Requirements provided by the Client.
Designing of ETL approach.
Development of Teradata BTEQ scripts for the data loading and Audit purposes.
Interacting and managing the Offshore team (2 members)
Reviewing of Test Case documents.
Review the deliverables to ensure that they are as per the standards.
Prepare and share Status Report with Customer & other Stake holders on periodic basis.

Confidential

Technical Lead

Responsibilities:

Coordination with Client directly on a daily basis.
Requirements Gathering & Source Data Analysis.
Designing of ETL approach.
Preparation of Technical Design documents for the proposed ETL solution.
Preparation of Test cases.
Developing Informatica Mappings, Oracle Stored Procedures.
Review the deliverables to ensure that they are as per the standards.
Unit testing / System Integration testing of the developed objects.
Prepare and share Status Report with Customer & other Stake holders on periodic basis.

Confidential

Team Member (ETL Lead)

Responsibilities:

ETL Lead of the Project - Lead a 2 member ETL Team.
Interacted with the Client directly on a daily basis.
Responsible for analyzing the Source data and was involved in the suitable enhancement to the existing Data Model of the project.
Designed the Loading & Error Handling approach of the project.
Developed SQL Server Stored Procedures for loading different Dimension & Fact tables.
Involved in the creation of the ETL - Technical Design documents and held review meetings with the Client.
Prepared the User Manual of the ETL process for the Go-Live & Support purposes.

Confidential

Team Member (ETL Lead) / Data Modeler

Responsibilities:

ETL Lead of the Project - Lead a 2 member ETL Team.
Designed the Logical / Physical Data Model for the project.
Proactively researched the Business terms and analysed the Source system to identify the different Entities of the Project.
Designed the Error Handling approach of the project.
Developed SSIS packages for different Load modules in the project.
Provided important inputs for the Reporting team with respect to fetching of data from the database.
Provided the ‘Go-Live’ Support for the project and interacted with the Client directly during the Support phase.

Confidential

Team Member (Module Lead)

Responsibilities:

Confidential

Team Member (Module Lead)

Responsibilities:

Entirely involved in all the phase (Requirement gathering, Design, Coding, Testing & Implementation) of the project.
Involved in the development of Detailed Mapping / Design specifications of the ‘Claims’ module.
Involved in designing and execution of the Test cases required for the Unit & System Testing activities.
Developed considerable amount of BTEQ scripts for the Claims module, which also includes Dynamic SQL generation scripts.
Led the Claims module (4 members) from Coding till the implementation of the project.
Involved in the Query tuning activities and Defect prevention meetings.
Took up the activity of managing the database at offshore.
Proactively took up the responsibility of VSS Administrator for the Chennai team of Confidential account.