SUMMARY

• Overall 7+ years of IT experience with Specialization in Teradata development, DW Testing, Data Analysis and design of ETL methodology for supporting data transformations & processing in a corporate wide ETL Solution using Teradata TD12.0/TD13/TD14, Informatica 8.6, analyzing business needs of clients, developing effective and efficient solutions and ensuring client deliverable within committed deadlines.
• Extensive experience in developing & designing ETL by using, SQL, Macros, BTEQ, MLoad, Fastload and FastExport.
• Proficient in Teradata TD12.0/TD13.0 database design (conceptual and physical), Query optimization, Performance Tuning by using explain plans.
• Expertise in implementing complex business rules by creating re - usable transformations, and Mappings/Mapplets and Creating Repository, Source, Target Databases.
• Well experienced in Performance Tuning of Informatica (sources, mappings, sessions and targets) and Databases, Multi-Threading and parallel processing.
• Very good knowledge and loads of experience on informatica- Push down Optimization.
• Strong knowledge of complete System Software development Life Cycle (SDLC) of Data warehousing, Decision Support System.
• Proficiency in Data Warehousing techniques for Data Cleansing, Data Modeling using Dimensional Data modeling, Star Schema/Snow flake schema, FACT & Dimensions tables, Physical & logical data modeling, Slowing Changing Dimension (type 1, 2 & 3) phenomenon.
• Heavily interacted with the Business Users to gather requirements, Design Tables, standardize interfaces for receiving data from multiple operational sources, coding, coming up with load strategies of loading staging area and data marts. Dealt with Type1/Type2/Type3 loads.
• Exclusive knowledge in System Design, writing Program specifications, Coding and implementation of the Systems.
• Proficient in testing of Extract Transform and Load (ETL) processes on Teradata.
• Rich experience in Test requirements gathering, Test cases preparation and reviews, Test plan preparation, Test data preparation, Test Summary Preparation, Test Dashboard Preparation, Test Estimations and Defect management.
• Good work experience in Unit testing, Functional, Performance, and User Acceptance Testing.
• Extensive Experience in Test management tools like Clear Quest (CQ), Test Director (TD) and Rational Quality Management (RQM) which includes Uploading Requirement, Preparation of Test cases and uploading, Execution of Test Cases, Logging Defects.
• Experience in Unix Shell Scripting and Job Scheduling on Multiple platforms.
• Capable of working on Mainframes (Z/OS).
• Have good hands on Clear Case as a Configuration management tools, for maintaining the project related documents and their versioning system.
• Possess strong knowledge on Oracle with PL/SQL stored procedures, cursor, functions, and triggers, however haven’t got a chance to explore more on this area.
• Involvement in preparing Project documents, Installation documents.
• Work experience in agile methodology.
• Have acquired Sufficient Business knowledge in Membership and Claims subject area along with related Health Care concepts with 5+ years of Healthcare domain experience.
• Have 4 years of experience as a Team Lead, Managed couple of resources both at offshore and onshore. Conducted technical/domain and application oriented training programs for team members and knowledge transfer for new joiners.
• Ability to meet deadlines and handle pressures coordinating multiple tasks in project environment, excellent communication, interpersonal, analytical skills.
• Highly motivated with the ability to work effectively in teams as well as independently.

TECHNICAL SKILLS

RDBMS: Teradata 13/12/V2R6.2/V2R5, Oracle 10g/9i/8i, MS-Access.

DB Tools/Utilities: Teradata SQL Assistant 12.1/13.10/14.01 , SQL*plus, BTEQ, Fast load, Multiload, FastExport, TPump, TOAD 8.0., Hummingbird Bi-Query

ETL Tools: Informatica Power Center 7.1.1/8.6.1

Programming: PL/SQL, SQL, C, C++, UNIX, JAVA, HTML.

Data Modelling: Logical/Physical/Dimensional, Star/Snowflake

Version Control Tools: Clear Case.

Operating Systems: Windows, MS DOS, UNIX, Mainframe Z/OS

PROFESSIONAL EXPERIENCE

Confidential, Franklin Lakes, New Jersey

Senior ETL Tech Lead

Responsibilities:

• Meetings with business/user groups to understand the business process and gather requirements. Extracted and analyzed the sample data from different systems from both the sides to validate the user requirements. Created high level design documents.
• Participated in data model discussions with Data Modelers for creating both logical and physical data models.
• Created Mapping Documents and ETL design documents. Followed Enterprise Level Metadata while creating design and source-to-target mapping documents.
• Involved in performance tuning of the Teradata BTEQ process and performed the testing for the same.
• Involved in error handling, performance tuning of mappings, testing of Stored Procedures and Functions.
• Experienced in loading data into Data Warehouse/Data Marts using Teradata Multiload, Fast load and BTEQ utilities.
• Enriched knowledge on Teratata 14 concepts by closely working with DBAs and applied concepts successfully.
• Implemented operational data store framework between sources to target Structures and new mechanism of interface table, which will integrate various types of sources.
• Extensively worked on indexes in Teradata and Creation of proper Primary Index (PI) talking into consideration of both planned access of data and even distribution of data across all the available AMPS.
• Worked with DBA in making enhancements to physical DB schema. Also coordinated with DBA in creating and managing table, indexes, table spaces, triggers, db links and privileges.
• Extensively created and used various Teradata Set Tables, Multi-Set table, global temp tables and volatile table.
• Extensively involved in data transformations, validations, extraction and loading process. Implemented various Teradata Join Types like Inner-join, outer-join, self-join, cross-joins
• Extensively created Teradata Macro’s for repeated use across various applications
• Performance tuning for Teradata SQL statements using Teradata Explain command and Run stats
• Suppored production job failures 24/7 and provided resolutions immediately. This involves upstream data corrections, script override to the errors and handling space issues.
• Quick solution provided for all the Production job failures and missing loads that requires immediate attention due to a huge reliance on it.
• Performed activities like analyzing the Issue for different Sources with dependency impact, Approach Design, providing the solution, Code Development, Deployment
• Responsible for migrations of the code from Development environment to QA and QA to Production.
• Documented the existing mappings as per the design standards followed in the project.
• Involved in job scheduling discussions with CA7 Schedule team.
• Prepared the validation scripts to compare the new data with legacy systems.
• Carry out Defect Analysis and fixing of bugs raised by the Users.
• Prepared Unit and Integration testing plans. Involved in Unit and Integration testing using the testing plans.
• Involved in after implementation support, user training and data models walkthroughs with business/user groups.

Environment: Teradata 14, Teradata SQL Assistant, BTEQ, Multi Load, Fast Load, Fast Export, HummingBird BI, Mainframe Z/Os, CA7 Scheduler

Confidential, Richmond, VA

Senior ETL Tech Lead

Responsibilities:

• Participated in user meetings, gathered Business requirements & specifications for the Data-warehouse design. Translated the user inputs into ETL design docs.
• Involved in the designing of the Data Model in deriving Conceptual, Logical and Physical model’s with Architect teams. Defined, and documented the technical architecture of the Data Warehouse, including the physical components and their functionality.
• Created business specification document, Technical specifications document, Test Plan Document and reviewed the document with business partners, source system SMEs, UA tester, DBAs and Architectures.
• Experienced in loading data into Data Warehouse/Data Marts using Informatica, Teradata Multiload, Fast load and BTEQ utilities.
• Performed the activities like Providing the solution, Code Development and Deployment of Product and Membership data into EDWard.
• Development of scripts for loading the data into the base tables in EDW using FastLoad, MultiLoad and BTEQ utilities of Teradata.
• Performed application level activities creating tables, indexes, monitored and tuned Teradata BETQ scripts using Teradata Visual Explain utility.
• Collected Multi-Column Statistics on all the non-indexed columns used during the join operations & all columns used in the residual conditions.
• Used extensively Derived Tables, Volatile Table and GTT tables in many of the ETL scripts.
• Tuning SQL queries to overcome spool space errors and improve performance
• Assess the impacts to downstream applications that use EDWard data and communicate the changes to the respective team
• Worked closely with the end users in writing the functional specifications based on the business needs.
• Involved in extensive DATA validation using Teradata queries.
• Involved in testing the structure of the newly inserted tables in all stages, from source till EDWard
• Extensive experience in writing and executing SQL scripts for validation and testing of the data integrity between source and target database for all the EDWard tables
• Developed and performed execution of Test Scripts to verify the expected results.
• Responsible for testing all new and existing ETL data warehouse components
• Triage UAT concerns by discussing with SMEs and respective teams
• Monitoring the ETL workflows
• Used RQM to state requirements, business components, test cases, and test runs for every iterations, defects. Also link defects with requirements
• Co-ordinate the day- today activities for offshore members and also involve in the client interaction to report them the status and other development activities.

Environment: Teradata 12, Teradata SQL Assistant, BTEQ, MLOAD, Clear case, WLM, RQM, UNIX, Windows2000.

Confidential, Richmond, VA

Senior ETL Tech Lead

Responsibilities:

• Understanding the requirement, design, data sourcing and data transformation, data loading, SQL performance tuning through testing and deployment of data Enhancements into EDWard.
• Quick solution provided for all the Production job failures and missing loads that requires immediate attention due to a huge reliance on it.
• Performed activities like analyzing the Issue for different Sources with dependency impact, Approach Design, providing the solution, Code Development, Deployment
• Perform Data Analysis for the CR (Change Request), Profile the data with acquired prior knowledge and provide the solution. .
• Created functional and technical detailed design documents for the ETL Did the ETL using Informatica.
• Well experience on Informatica- Push down Optimization.
• Responsible for implementing the Informatica CDC logic to Process the delta data.
• Designed and Created data cleansing, data conversion, validation and External loading scripts like MLOAD and FLOAD for Teradata warehouse using Informatica ETL tool.
• Involved in error handling, performance tuning of mappings, testing of Stored Procedures and Functions, Testing of Informatica Sessions, and the Target Data.
• Experienced in loading data into Data Warehouse/Data Marts using Informatica, Teradata Multiload, Fast load and BTEQ utilities.
• Worked with DBA in making enhancements to physical DB schema. Also coordinated with DBA in creating and managing table, indexes, table spaces, triggers, db links and privileges.
• Performed tuning and optimization of complex SQL queries using Teradata Explain and Run stats.
• In-depth expertise in the Teradata cost based query optimizer, identified potential bottlenecks.
• Prepare a Scope and Approach document and review with Subject matter experts and Business Analysts
• Created Primary Indexes (PI) for both planned access of data and even distribution of data across all the available AMPS.
• Created appropriate Teradata NUSI for smooth (fast and easy) access of data.
• Develop Test Plan / Test Strategy and walkthrough it to clients & UAT users.
• Validated that design meets requirements and function according to technical and functional specifications
• Develop and Execute Test Scripts to verify the expected results.
• Involved in all phases and stages of Software Testing Life Cycle including end-to-end system testing and business requirements analysis.
• Used RQM to state requirements, business components, test cases, and test runs for every iterations, defects. Also link defects with requirements
• Supported end users for UAT Testing.
• Participated in walkthroughs and triage meetings periodically
• Carry out Defect Analysis and fixing of bugs raised by the Users
• Highly motivated with the ability to work effectively in teams as well as independently

Environment: Teradata 12, Teradata SQL Assistant, BTEQ, MLOAD, FLOAD, Informatica 7.1.1/8.6.1 . Clear case, WLM, RQM, UNIX, Windows2000.

Confidential

Senior ETL Developer

Responsibilities:

• Requirement Analysis and Design
• Coding (involves coding of shell scripts, Informatica mapping, sessions and workflows)
• Loading data by using the Teradata loader connection, writing Teradata utilities scripts (Fast load, Multiload) and working with loader logs.
• Scheduled workflows, BTEQ Scripts, UNIX shell scripts using WLM Scheduling tool.
• Testing and debugging of all ETL and Teradata objects in order to evaluate the performance and to check whether the code is meeting the business requirement.
• Responsible for migrations of the code from Development environment to QA and QA to Production.
• Unit Testing.

Environment: Teradata, UNIX Shell Scripting, WLM Scheduling tool and Windows XP

Confidential

ETL Tester

RESPONSIBILITIES:

• Review Business Requirements, Business Use Case and functional documents
• Involved in Writing the Test Cases and Test Plans based on Source to Target Mapping Documents
• Validation of data load in Teradata through Informatica and Teradata in EDW
• Validation of Access control restrictions and privileges in Teradata
• Involved in preparation of Test Strategy, Test Plan, Test Cases, Test Scripts, Test Results and Test Summary reports as per the test strategy
• Has involved in regular discussions with the various Confidential Subject Matter Experts for different healthcare subject areas Membership, Claims, Products and Providers to derive the design approach using her specialized knowledge on data warehousing
• Involved in Mapping the Test Cases with the Requirements and Mapping Document
• Involved in writing Test Cases to validate the Enterprise Data Warehousing (EDW) Tables from source.
• Validated data between flat files(UNIX) and LZ tables(source in Teradata)
• Wrote SQL queries for each Test Case and executed them in Teradata to validate the data from flat files(UNIX) to Enterprise Data Warehouse
• Used Test Director 8.0 to state requirements, business components, test cases, and test runs for every iterations, defects. Also link defects with requirements
• Developed test cases based on business requirements document, technical specifications document and functional flow of application
• Worked rigorously with developers to create test scripts in regards to the Informatica ETL
• Tested Informatica Mappings and worked with Staging area to validate the data with SQL Queries
• Designed and documented all the Issues and defects to ensure application software functionality for Present and Future Builds using Test Director
• Performed Retest for the defects raised and Regression testing, to make sure, new defects were not introduced
• Prepared Test Defect Metrics on a Weekly basis to know the status of the application
• Preparation of Test Data for Positive and Negative Test Cases

Environment: Teradata, Informatica 7.1.1, UNIX Shell Scripting,Test Director, and Windows XP