SUMMARY:

• Senior ETL Developer/Analyst with 6 years of IT experience focusing on Business Intelligence (BI) and data warehousing solutions, with knowledge in ETL technologies like Informatica PowerCenter, Teradata Scripts, Ab Initio.
• Involved in all stages of software development including requirements gathering, analysis, design, coding and implementation.
• Involved in data analysis and created visually impactful dashboards in Microsoft Excel to cater the business needs.
• Work Experience in Insurance and Retail Domains.
• Knowledge in RDBMS systems including Teradata, Oracle and DB2.
• Experience in UNIX using PUTTY and WINSCP clients.
• Hands on experience in Teradata Utilities - Fast Export, Bteq.
• Experience in Scheduling and Workload Management tools like WLM and CTM.
• Experience in ETL/Data Migration Testing tool ICEDQ.
• Experience in creating business and user documentation.
• Team player with good communication skills and ability to work independently or as part of a team.
• Confident, sincere and hardworking with a positive attitude

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 8.6.1, 9.x,10 Ab Initio

Languages: Basics of C, C++, C#, Java

Generic Skills: WinSCP, PUTTY,Microsoft Suite (Including Excel, PowerPoint, Word )Tablaeu

Version Control: VSS, SVN

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, Virginia

Environment: Informatica, Teradata scripts, ICEDQ and UNIX.

Responsibilities:

• Creating LOE and Design Documents for Regression Test Load projects.
• Setting up the environment and performing end to end data ware house loads for multiple systems.
• Understanding test scenarios and validating them.
• Analyzing the data flow and identifying the underlying issues in case of unexpected/missing data in EDW.
• Collecting and cleansing project execution details; creating Project dashboards, Vendor Management decks and reports to support decisions for multiple enterprise initiatives.
• Automating Test Scenarios using Automation tool ICEDQ.
• Performing DML requests to modify data within Test Environments, by closely identifying and avoiding data conflicts between multiple Development teams.
• Reviewing and executing Data Copy requests from EDW dev teams, and moving data from production to test environment. Data Copy requests are performed by working in close co-ordination with Release team and DBA team.

Confidential, Texas

Environment: Informatica, Oracle, UNIX shell scripting.

Responsibilities:

• Requirement Gathering and Analysis by seeking inputs from onshore coordinators.
• Performing Estimation and creating LOE.
• Creating High Level Design and Technical/Detailed Design Documentations.
• Developing high quality code using Informatica PowerCenter, Oracle SQL and UNIX scripts.
• Reviewing design and code created by team members and providing inputs.
• End to end testing of application to validate seamless flow of data.
• Creating test documents and test artifacts.
• Co-ordinating a team of 5-6 members.
• Supporting Integration Testing, QA and Functional Testing
• Deployment of the components to live environment and support in live environment.

Confidential, Illinois

Environment: Teradata, UNIX shell scripting, Teradata Fast Export Utility, Teradata Bteq Utility

Responsibilities:

• Requirement Gathering and Analysis.
• Analyzing the existing code and identifying the required changes that needs to be implemented.
• Creating High Level Design and Technical Design Documentation.
• Developing and modifying Teradata scripts as per the new business requirements.
• Creating Test Cases and test artifacts.
• Performing Unit testing.

Confidential, Texas

Environment: Informatica, DB2, Oracle, UNIX shell scripting.

Responsibilities:

• Requirement Gathering and detailed analysis for translation to design.
• Performing Estimation and creating LOE.
• Creating High Level Design and Detailed Design, Documentation.
• Developing high quality performance tuned ETL components using Informatica PowerCenter, Oracle SQL and UNIX scripts.
• Involved in peer review of documents and code.
• Creating Test Cases, Performing Unit Testing and creating test documents.
• Supporting Integration Testing, QA and Functional Testing
• Deployment of the components to live environment and support in live environment.

Confidential, Texas

Environment: Informatica, DB2, Oracle, UNIX shell scripting.

Responsibilities:

• Requirements Gathering and Requirement analysis, Performing Estimation and creating LOE.
• Extracted, interpreted and analyzed data to identify key metrics and transform raw data into meaningful, actionable information.
• Creating High Level Design and Detailed Design Documentation.
• Designing the fact and dimension tables based on the business requirements and developing necessary DMLs to create them.
• Analyzing the input data and identifying the methods to calculate the metrics that needs to be populated in fact tables.
• Developing ETL code for populating reporting tables in DataMart using DB2 queries, Informatica mappings and UNIX scripts.
• Performed end to end testing and high-quality code was delivered without any QA testing defects.
• Creating Test Cases, and other test documents.
• Supporting Integration Testing, QA and Functional Testing
• Deployment of the components to live environment and support in live environment.

Confidential , Texas

Environment: Ab-Initio, DB2, UNIX shell scripting

Responsibilities:

• Requirement Analysis.
• Analyzing the existing code to identify the necessary changes.
• Creating High Level Design and Detailed Design Documentation.
• Developing ETL components as per the business requirements.
• Creating Test Cases, Performing Unit Testing and creating test documents.