SUMMARY

• Over 8 years of experience in IT industry as a Teradata developer working in the area of Data warehousing specialized in Extract Transform and Load (ETL) and business intelligence (BI), with particular expertise in Informatica, ETL, Oracle, SQL server and UNIX. Specialized in Analysis, Design, Development, Implementation, Modeling, Testing, and support for Data warehousing (DWH) applications from various Heterogeneous Data Sources.
• Extensive experience on Data Warehousing with architecture, design, development and implementation of data warehouse ETL processes.
• Expertise in Data Warehousing projects using Teradata Development.
• Excellent experience in TERADATA Utilities: BTEQ, Fastload, Multiload, TPUMP and Fastexport
• Expertise in Data Warehousing projects using Informatica Power Centre 9.x/8.x.
• Extensively worked on Informatica Designer Components - Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor.
• Strong hands on experience on Administration of Informatica Environment consisting of Power Center, Power Exchangeand Metadata Manager.
• Good experience in designing and developing mappings from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy etc.
• Extensive work experience in the areas of Insurance, Banking and Financial services.
• Data modeling experience using Dimensional Data modeling, Star Schema & Snow Flake Schema, Fact & Dimension tables, Physical &logical data modeling using ERWIN and TOAD tool and utilities.
• Extensively used ETL methodology for supporting Data Extraction, Transformation and Load processing in a corporate-wide-ETL solution using Informatica.
• Comprehensive working knowledge of Oracle RDBMS.
• Worked with different data sources non-relational Databases such as Flat files and other relational sources such as Oracle and SQL Server.
• Good Knowledge of OLTP and OLAP.
• Expertise in Performance Tuning of Queries.
• Hands on experience in tuning mappings, identify and resolve performance bottlenecks at various levels like source, target, mappings and sessions.
• Expert in troubleshooting, debugging and improving performance at different stages like database, workflows, complex mappings.
• Experience in identifying and resolve ETL production root cause issues.
• Experience in maintenance, enhancements, performance tuning of ETL code.
• Excellent problem solving skills with strong technical background and good interpersonal skills.
• Quick learner and excellent team player, ability to meet deadlines and work under pressure.
• Ability to function both in a team environment as well as individual capacity.

TECHNICAL SKILLS

Operating Systems: Windows XP, Windows 2000, UNIX

Languages: Markup languages, C, C++, UNIX, LINUX

Packages: MS-Office(2000/XP)

DBMS: Teradata, Oracle, SQL Server

Business Intelligence: Informatica 8.x/9.x

Miscellaneous: Unix Shell scripting, WLM, Autosys Scheduler, Erwin data model, JAMS

PROFESSIONAL EXPERIENCE

Confidential

Lead Teradata Developer

Responsibilities:

• Responsibility in this project involves Creation of Requirement, Design docs, providing design solutions
• Analyzing the data and profiling is done to make the design compatible for all business scenarios and performing independent unit testing.
• Responsibilities also include Development of Informatica workflows and mappings, BTEQ scripts and list files.
• Preparation of code review documents and performance tuning on the queries developed.
• Preparation of Defect Analysis, Unit Test & Release Manual documents, client interacting, bug-fix request, and implementation support.
• Technology involved in this project includes Teradata, Informatica, UNIX and WLM scheduling tool.

Confidential

Technology Analyst

Responsibilities:

• Responsibility in this project involves Creation of Requirement, Design docs, providing design solutions, analyzing the Metric data for reporting need, designing and performing independent unit testing.
• Responsibilities also include Development, preparation of Defect Analysis, Unit Test & Release Manual documents, client interacting, bug-fix request, and implementation support.
• Technology involved in this project includes Teradata, SQL Server, JAMS.

Confidential

Module Lead/Data modeler

Responsibilities:

• Responsibility in this project involves managing the team, provide inputs based on technical expertise, analyzing defects, reviewing codesand performing independent unit testing.
• Managed Onshore-offshore coordination and worked as a backup data modeler in the project.
• Technology involved in this project includes Teradata, Oracle, and Unix/LINUX and Autosys/Crontab scheduler.

Confidential

Senior developer/Module Lead

Responsibilities:

• Responsibility in this project involves Creation of Requirement, mapping document, TSD, BRD and Traceability matrix, analyzing the incoming claim data, designing and performing independent unit testing.
• Responsibilities also include Development, preparation of Defect Analysis, Unit Test & Release Manual documents, Offshore coordination and implementation support.
• Technology involved in this project includes UNIX, Informatica, and Teradata.

Confidential

Systems Engineer

Responsibilities:

• Responsibility in this project involves understanding of Requirements, TSD, FDD and Traceability matrix, analyzing the Claims, membership and Provider data, designing in key and performing independent unit testing.
• Responsibilities also included Development, preparation of Defect Analysis, Unit Test & Release Manual documents, Onsite-Offshore coordination, bug-fix request, and implementation support.
• Technology involved in this project includes UNIX, Informatica, and Teradata.

Confidential

Developer/ Database Admin

Responsibilities:

• Responsibility in this project involved in analyzing, designing in key and performing independent unit testing.
• Responsibilities also included Development, preparation of Defect Analysis, Unit Test cases and integration of different codes. Technology involved in this project includes MS SQL server 2005, C#, ASP.NET.