PROFESSIONAL SUMMARY:

• 10 years of experience in ETL and DW Technologies like - Informatica, Teradata, SSIS, DTS, SQL Server and DB2.
• Working as Lead Consultant at Confidential in BI vertical.
• 5+ years of work experience as Technical Lead.
• 7+ years of experience in Healthcare Domain and experience in Insurance and Retail Domains.
• Experience in implementing small and large ETL / EDW projects with Fortune 500 clients - Confidential, Confidential, Confidential and AAA.
• Well versed with complete SDLC process that includes translation of Requirements into Functional and Technical specifications, Designing, Developing, Testing and implementation and Post Production warranty support.
• Strong skills in Data Analysis, Data Profiling and Data Mapping for ETL processes.
• Expertise in Data warehousing concepts and ETL processes.
• Extensive experience in ETL design, development and maintenance using Informatica Power Center v9.1/9.6 and SSIS 2008.
• Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Joiner, Update Strategy, Aggregator, Stored Procedure, Sorter, and Sequence Generator.
• Experience with SSIS Transformations like Execute SQL task, Script task, Data flow tasks, Script component, Union all, Derived column transformations.
• Automation, Scheduling and monitoring of jobs using Work Load Manager and Autosys.
• Efficiently able to Lead the project team and ensure smooth project execution.
• Self-learning ability with a drive for results through self-motivation and good team player.
• Good communications skills and interpersonal skills.
• Strong analytical, design skills and problem solving abilities.
• Flexible and Adaptable to the people, circumstances & responsibility.
• Management skills include Team Management, Project Planning, Tracking project tasks.
• Interested in learning and exploring new technologies.

TECHNICAL SKILLS:

ETL Tools: Informatica v8.6/9.1/9.6, SSIS 2008 R2, DTS

Databases: Teradata v13/14, MS SQL Server 2000/2008, DB2

Languages: BTEQ, SQL, PL/SQL, VB, C#

Operating Systems: Windows 7/XP, UNIX

Others: TOAD, SSMS, SQL Assistant, WLM, Autosys, Visual studio tools for office (VSTO)Visual Source Safe, Microsoft Office, Microsoft Visio, Clearcase, ClearQuest, APLUS, JDA

PROFESSIONAL EXPERIENCE:

Confidential - Milwaukee, WI

Technical Team Lead / Lead Consultant

Responsibilities:

• Responsible for End to End implementation of the project.
• Perform Requirements Gathering, Scope determination and Estimation.
• Provide Technical Design Solutions using Informatica Workflows.
• Co-ordinate with Project Manager, Business users, SMEs and process owners to accomplish all Project Tasks.
• Create Informatica mappings using various transformations like Expression, Filter, Router, Look up (connected and unconnected) etc.
• Create Sessions, Mapplets and Workflows and configure the Work flow Parameters and variables.
• Verify Session Logs and Work flow Logs for any issues.
• Review of Code Components and Test cases.
• Perform UAT co-ordination and UAT Results walkthrough with Business Users and Business Analysts.
• Responsible for QA migration and Production Deployment.
• Prepare Job schedule for Informatica and UNIX components using Autosys.
• Analyze Performance issues and provide resolution.
• Provide Warranty Support and Transition to Production Support Team.

Technology Used: Informatica v9.6, DB2, UNIX

Confidential - Richmond, VA

Senior ETL Developer Lead / Senior Systems Analyst

Responsibilities:

• Tech Lead for the project and Accountable for all technical deliverables.
• Perform Requirements Gathering, Scope determination and Effort Estimation.
• Perform Data Analysis and Profiling to identify data gaps, redundancies & anomalies.
• Provide Technical Design Solutions using Informatica Workflows and Teradata BTEQ scripts.
• Worked effectively with Business Analysts and Project managers for assigned tasks and deliverable timelines.
• Interact with BSAs, DBAs and Architects during project execution.
• Build Informatica Code components using Informatica Power Designer, Workflow Manager.
• Create Teradata BTEQ scripts.
• Create MLOAD, FLOAD and TPUMP Connections used in Informatica mappings.
• Create UNIX scripts for File validation.
• Review of Code Components and Test cases.
• Perform UAT co-ordination and UAT Results walkthrough with Business Users and Business Analysts.
• Responsible for QA migration and Production Deployment.
• Prepare Job schedule for Informatica and BTEQ components using Work Load Manager (WLM).
• Analyze Performance issues and provide resolution.
• Co-ordinate all Release activities - SIT, UAT and PROD phases.
• Provide Warranty Support and Transition to LightsOn Team.

Technology Used: Informatica v9.1, Teradata 14, BTEQ, UNIX

Confidential

Technical Lead

Responsibilities:

• Tech Lead for the project and Accountable for all technical deliverables.
• Perform Requirements Gathering, Scope determination and Effort Estimation.
• Co-ordinate with Project Managers, Business users, SMEs and process owners to complete SDLC processes.
• Design the Database Components and Relations.
• Provide Technical Design Solutions for the ETL Workflows.
• Create Simple and Complex SSIS Packages.
• Utilize Logging and Event Handling features.
• Prepare XML Configuration files for SSIS packages.
• Create SSRS reports for Business users (Pilot Project Effort).
• Review of Code Components and Test cases.
• Analyze Performance issues and provide resolution.
• Co-ordinate all Release activities - SIT, UAT and PROD phases.
• Co-ordinate all Implementation Activities - Business Approvals, Code Review Approvals, Code Migration, Creating TSRM Tickets and Work Orders etc.
• Provide Warranty Support.

Technology Used: SSIS 2008 R2, SQL Server 2008 R2, SSRS

Confidential

Technical Lead

Responsibilities

• Tech Lead for the project and Accountable for all technical deliverables.
• Perform Requirements Gathering, Scope determination and Effort Estimation.
• Perform Data Analysis and Profiling to identify data gaps, redundancies & anomalies.
• Provide Technical Design Solutions using Informatica Workflows and Teradata BTEQ scripts.
• Interact effectively with BSAs, DBAs and Architects and Project managers for assigned tasks.
• Build Informatica Code components using Informatica Power Designer, Workflow Manager.
• Create Teradata BTEQ scripts.
• Create MLOAD, FLOAD and TPUMP Connections used in Informatica mappings.
• Review of Code Components and Test cases.
• Perform UAT co-ordination and UAT Results walkthrough with Business Users and Business Analysts.
• Responsible for QA migration and Production Deployment.
• Prepare Job schedule for Informatica and BTEQ components using Work Load Manager (WLM).
• Analyze Performance issues and provide resolution.
• Co-ordinate all Release activities - SIT, UAT and PROD phases.
• Provide Warranty Support and Transition to LightsOn Team.

Technology Used: Informatica v9.1, Teradata 14, BTEQ, UNIX

Confidential

Lead Developer

Responsibilities:

• Perform Requirements Gathering, Scope determination and Effort Estimation.
• Perform Data Analysis and Profiling to identify data sources, data gaps, redundancies & anomalies.
• Provide Technical Design Solutions using Informatica Workflows.
• Build Informatica mappings, Sessions and Workflows and configure the Work flow Parameters and variables.
• Verify Session Logs and Work flow Logs for any issues.
• Review of Code Components and Test cases.
• Analyze Performance issues and provide resolution.
• Co-ordinate all Release activities - SIT, UAT and PROD phases.
• Provide Warranty Support.

Technology Used: Informatica v8.6, IBM DB2

Confidential

Senior Developer

Responsibilities as a Senior Developer:

• Analyzing and resolution of issues reported by client.
• Monitoring the JDA jobs and takes corrective action.
• Generation of adhoc reports and extracts
• Analysis of CRs
• Design and Implementation of CRs
• Preparing test cases
• Preparing Functional and Technical documents
• Conduct training sessions to Business Users

Software Used: JDA v7.4.2, Oracle 10g

Confidential

Senior Developer

Responsibilities:

• Requirements Gathering and Analysis.
• Create Design documents and Test Cases.
• Design the database objects and Data flow for ETL components.
• Build DTS packages for Data loading and Report generation.
• Create Stored procedures in SQL Server 2008.
• Unit testing and System testing.
• Perform Peer review for all deliverables.

Technology Used: DTS, SQL Server 2008, VB script.

Confidential

Developer / Software Engineer

Responsibilities:

• Detailed Analysis of the Requirements.
• Create Design Documents and Test Cases.
• Coding of .Net components.
• Prepare SQL Server Stored Procedures as per Business Requirement.
• Code Deployment to QA environment.

Technology Used: VB .NET, VSTO, SQL Server 2005