SUMMARY:

• He is a Quality Assurance/Analyst with close to 10 years of IT experience.
• His expertise is leading testing efforts and UAT support within data warehouse/ETL solution environments.
• He has testing experience within Teradata, Oracle 11g,Informatica and Business Objects.
• He is experienced in Agile and waterfall methodologies, test cases preparation, reviews of test plans, data, summary, Estimations and defect management.
• He is experienced in team management, status reporting, project tracking, metrics collection, reporting, and end - to-end test management.
• He is well versed in detecting errors and assisting User Acceptance testing by designing, developing and executing test scripts.
• He is skilled in analyzing business context and requirements for UAT testing purposes.
• Strong working knowledge and experience in performing data analysis and impact analysis in Data Warehouses systems.
• Industry experience includes the Health Care, Retail and Insurance domains.

TECHNICAL SKILLS:

Operating Systems: Windows

Languages: SQL

Databases: Teradata, Oracle, SQL Server 2000/2005

Tools: Informatica, Abnitio, Business Objects, SSRS, SSIS, Web Services, ALM, Test Director, HP Quality Centre, Version One, UC4

PROFESSIONAL EXPERIENCE:

ETL Test Consultant

Confidential

• Understanding logical flow of the application/project and analysis of the specifications provided by the customer.
• Participating in the reviews of requirements, design documents and data models.
• Estimate the efforts required to design the test plan, test cases and execute the project.
• Create and maintain the test strategy document for ETL tasks and also other related applications which communicate with ETL tools and technologies.
• Design test cases as per test plan, design and mapping specifications
• Responsible for reviewing of test plans and test cases with team members to ensure high quality deliverables.
• Verifying that data is transformed correctly according to various business requirements and rules.
• Validating that all projected data is loaded into the data warehouse without any data loss and truncation.
• Make sure that ETL application appropriately rejects, replaces with default values and reports invalid data.
• Responsible for data loaded in data warehouse within prescribed and expected time frames to confirm improved performance and scalability
• Ensure reports generated using web services which are sent to customers is as per the design.
• Performing RCA (Root Cause Analysis) of the failed test cases and provides the related data samples to developers and business stakeholders.
• Defect Triage using HP Quality Center ALM with various application groups
• In corporate UAT test cases into testing, setup test data and provide proactive support to business during the UAT phase.
• Co-ordination with upstream and downstream partners to ensure data flow between the systems in the application is as per the design
• Environment: Teradata, Informatica, Web Services, Unix, HP Quality Center

Confidential

ETL Test Lead

• Responsible for supporting business users as a Test Lead with thorough data validation and verification to help them identify gaps with existing business models that helped them to take right business decisions.
• Manage a team of 10 offshore resources and thoroughly review daily deliverables to customer
• Reviewed test cases, test plans, test data for projects along with reporting status ensuring accurate coverage of requirements and business processes.
• Responsible for reverting of test data upon completion of validations and in managing data requested by conflicting teams which required controlled management of test data without compromising on data security and privacy.
• Project estimation and resource management
• Environment: Teradata 12.0, Informatica 9.0.1, Linux, Advanced SQL, Version One, UC4

Confidential

ETL Test Lead

• Provided analysis of existing business functions and processes.
• Created mapping document for source to target data flow based on existing and future business requirements.
• Provided requirements gathering with UAT/end users, analyzed the information and documented the functional and business requirements.
• Made recommendations to the test plan, test cases and scenarios prepared by the SIT QA team and maintained Traceability Matrices for baseline documents.
• Developed UAT test process and monitoring SIT execution phases.
• Drafted complex SQL queries, drove end-to-end test scenarios efforts, and in identified test data for UAT.
• Assigned the tasks of preparing test results as well as gathered test results from other testers in standardized format.
• Assisted user acceptance testing to ensure that developed systems satisfied the needs of business clients as specified in the functional requirements.
• Captured and tested all modifications to proposed functional requirements.
• Handled the tasks of identifying defects and performed root cause analysis by analyzing data quality issues.
• Teradata 14.0, Informatica, Business Objects, Oracle, UNIX, ALM, HP Quality Center
• Interacted with multiple stakeholders and business teams for timely updates on each project status.
• Played dual role of tester onshore for government (DOD) sub-projects which involved PHI/PII data and ETL test lead for parts offshore.
• Interacted with offshore team (QA leads & QA testers) and offshore team (Developers and Business analyst) for analysis of project requirements.
• Analyzed business specifications and prepared test strategy, test plan, test scenarios and test case documents.
• Cloned production data on test environments and cleaned up and reverted test data upon completion of validations.
• Generated additional data for test scenarios provided for specific data related testing upon request by various testing tams.
• Prepared ETL Test Estimations.
• Teradata 14.0, Informatica, Business Objects, Oracle, UNIX, ALM, Clear Quest

Confidential

ETL Tester

• Created complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.
• Provided analysis of membership, claims, claim line relations, and creating SQLs to validate the data flow.
• Analyzed requirements, created, and executed test cases.
• Worked with the development team for process improvement and release planning.
• Analyzed application data using the SQL to identify the ETL processes.
• Modified and created SQL Queries and stored procedures for quality assurance and analysis.
• Performed integration testing, system testing, end-to-end, and regression testing to validate the system.
• Provided test case design, test execution and defect management using defect management tools including Quality Center and Test director.
• Environment: Teradata 14.0, Oracle, UNIX, ALM, Clear Quest
• Prepared test strategy based on the functional and technical requirements.
• Provided execution of test cases, test scripts and test scenarios.
• Worked with data analysts to implement Informatica mappings and workflow, shell scripts and stored procedures to meet business requirements.
• Performing backend testing of the DB by writing PL/SQL queries to test the integrity of the application and Oracle databases.
• Wrote and modified SQL validation scripts, and SQL scripts to validate the outputs.
• Worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters to extract only the additional data added during that period.
• Prepared SQL/Teradata queries.
• Provided defect reporting and defect management.
• Preparation of exit report for the projects handled.
• Provided daily, weekly and bi-weekly status reports.
• Drove defect call/meeting with the client and developer.
• Environment: Teradata 12.0,Informatica, RQM, Clear Quest

Confidential

ETL Developer

• Interacted with business users for collecting, analyzing and documenting requirements.
• Provided analysis of the business requirement of the project.
• Interacted with onsite lead for collecting, analyzing and documenting requirements.
• Worked with source analyzer, transformation designer and mapping designer
• Developed transformation logic and designed various mappings using the designer.
• Performed independent unit and integrated testing on the database.
• Environment: Teradata, Informatica, Unix

Confidential

ETL Developer

• Creation of SQL server Reports using SSRS 2005. Experience in Query Optimization and Performance Tuning of Stored Procedures and functions.
• Report writing using SQL Server Reporting Services(SSRS) and creating various types of reports like Drill Down, Parameterized, Conditional, Table, Matrix Chart and Sub Reports.
• Experience in ETL design and development using SSIS Packages.
• Design and development of SSIS packages by using multiple transformations like Data Conversion, Conditional Split, Bulk Insert, Merge and Union All available in SQL Server Integration Services (SSIS).
• Environment: SSRS 2005, SSIS 2005, Oracle