Objective
To secure a position as a software developer that permits me to learn new technologies while utilizing my skills and experience developing data warehousing projects.
Summary

• 2.5 years of experience in Data Warehousing using Informatica and Teradata
• Domain Knowledge in US Banking & Securities
• Expertise on Power Center, Power Exchange in Informatica
• Expertise in ETL design using Informatica, and loading data into Teradata warehouse using MultiLoad and TPump.
• Have worked in re-engineering legacy Mainframe systems and Oracle databases into Teradata using Informatica
• Expertise in design, implementation and maintenance of databases. Gained significant knowledge and experience in database modeling. Have also done extensive query tuning and design & coding of complex queries specific to Teradata
• Involved in end to end project execution ¡V to gather the business needs, creation of design documents, development, testing and implementation of the same
• Strong leadership skills with ability to motivate teams to increase productivity
• Skilled in coordinating between development, maintenance and testing teams with focus on meeting deadlines
• Excellent attitude to suit roles in a collaborative environment and ability to work independently too

Skill Set
ETL Tool
Informatica Power Center 7.1, 8.1, Power Exchange
Operating Systems
Windows XP/2000/NT, UNIX
Databases
Teradata, Oracle
Tools & Utilities
Teradata SQL Assistant 6.1, MultiLoad, FastExport,FastLoad , TPump, TOAD, VSS
Languages
SQL
Emulators
Mainframe Emulator-QWS3270
Exposure To
Shell Scripting, Java
Certifications
Informatica

• Informatica Power Center 8 Mapping Design
• Informatica Power Center 8 Advanced Mapping Design

Domain

• Dun and Bradstreet Foundation Course in Banking, Certified by Infosys Technologies Ltd

Professional Experience

Project Name : Securitization Data Model - BASEL Enterprise warehouse
Client : Confidential
Role : Team Lead
Duration : From Mar 2007 to Dec 2008

• Client is one amongst the world\'s leading financial services companies with operations in Consumer Banking, Commercial Banking, Global Corporate and Investment Banking and Asset Management
• The objective of this project was to design and setup a Risk and Financial Data Warehouse to ensure that the bank conforms to the Basel II accord.
• Involved in understanding Basel II requirements and in modeling activities of the Basel II attributes identified from different source systems which are in Oracle, Teradata, CSV FILES and Mainframe. Data is Staged, integrated, Validated and finally loaded the data into Teradata Warehouse using Informatica.
• Performed the role of a Team Lead which included mentoring 4 people. Involved with various Project Management activities & Configuration Management tasks. Worked extensively on proposals & estimations for the implementation of the systems into the warehouse
• Involved Completely in Analysis, Design (including creation of software requirement specification from the business requirement document), Build, Test and End Delivery for Securitization module.
• These systems were implemented using Informatica and the Warehouse in Teradata. Fast-Load, MultiLoad, BTEQ & Fast-Export were the Teradata utilities used
• Worked extensively on performance improvement & query tuning tasks.
• Involved in providing user support for executing System Integration Testing & Acceptance Testing
• Involved in production implementation of new systems and Teradata system upgrades as part of maintenance
• Involved in migrating the Code from Informatica 7.1 to 8.1.
• Involved in Conducting Informatica PowerCenter, Informatica PowerExchange and Teradata Training to Infosys Employees.
• Managed diverse teams in multiple locations in Chennai, India.
• Exposure to the Maestro and AutoSys Scheduler tools.
• Was the Defect Prevention Anchor for the team. Audit teams for test and defect metrics, and provide consultation for improvement.
• Participated in the development of process improvement techniques across development functions, as the team embarked on attaining CMMI level 1 credentials.

Project Name : Traded Products/Trading Hub & Equity -BASEL Enterprise Warehouse
Client : Confidential
Role : Team Lead
Duration : From Mar 2007 to Dec 2008

• Involved in the creation of the trading hub data mart which obtained data from various Oracle, Teradata and flat file sources .Created and performed various Data cleansing and Data validation rules to ensure that the end data was synchronized.
• Involved in Analysis, Design, Build and Test for Equity and Traded Products module.
• These systems were implemented using Informatica and the Warehouse in Teradata. Fast-Load, MultiLoad, BTEQ & Fast-Export were the Teradata utilities used.

Project Name : Implementation of Wholesale Credit Risk Warehouse
Client : Confidential
Role : Developer
Duration : From Aug 2006 to Feb 2007

• The objective of this project was to convert the some of the existing Legacy systems in Wholesale to the Wholesale Warehouse in Teradata
• Total of 8 major systems were converted as part of this initiative. The scope also included various downstream extracts and views as well
• These systems were implemented in Informatica where the Legacy Systems were in Mainframes. Involved mainly with the Informatica side for all these systems.
• Fast-Load, MultiLoad, BTEQ & Fast-Export were the Teradata utilities used. Informatica systems were implemented in UNIX using Maestro for scheduling. Power Exchange was used to pull data from Mainframes.
• Involved in the understanding of the requirements, High Level Design (HLD) and Low Level Design (LLD) for all the systems that was converted
• Involved in Build & unit testing and was responsible for reviewing the final code. Completely involved in executing Integration Testing & Acceptance Testing
• Worked extensively on performance improvement & query tuning tasks.
• Responsible for monitoring production implementation tasks. Involved in planning for disaster recovery & back-up process

Project Name : Testing of Basel Retail Systems
Client : Confidential
Role : Developer
Duration : From Aug 2006 to Sep 2006
Project Details :

• The project Scope involves Testing of the Retails Systems in Teradata which was coded by other IT Vendor
• Involved completely in testing four systems where responsibility was to come up with extensive test cases and testing approaches.
• Got good exposure for various Test Cases
• Mostly the testing was done using Test Scripts in SQL.

ACHIEVEMENTS:

• Got a Spot award for outstanding performance and excellence during the fourth quarter of 2007-2008.
• Have been awarded with Client¡¦s spirit cards for exemplary work done in the development project.
• Consistent top ratings in all the appraisal cycles.
• Submitted BOK(Knowledge Management Documents) in the following area:
• Performing Incremental loads in Informatica
• Provided solutions for various complex requirements for other Warehouse Projects.