SUMMARY

• 8+ years of experience in Software Quality Assurance and Quality Control.
• Excellent Functional knowledge on various domains like Finance, Banking, Derivatives, Equities, Fixed Income, Insurance and Telecommunication.
• Good knowledge of Quality Assurance methodologies like Agile, Waterfall, V - Model, RUP, Scrum, RAD, UML, TDD.
• More than 3+ years of experience in ETL Testing / Data Warehousing within the environment of Oracle, SQL Server, Informatica Power Center 9.1/8.6/ 7.1, PowerMart 6.2/ 5.1/ 4.7. x (Repository Manager, Mapping Designer, Server manager, Transformation Developer and Warehouse designer).
• Proficiency in Back-End Testing/Database Testing specifically in developing and executing SQL queries to interact with databases and also involved in review of ETL architecture, ETL design, and analysis and ETL technical specifications.
• Extensive experience in testing Data warehousing environment, experience in testing to ensure that ETL process functions well with all the upstream and downstream processes.
• Proficient in different types of testing that includes Black Box testing, Smoke testing, Functional testing, System Integration testing, End-to-End Testing, Regression testing & User Acceptance testing (UAT) & Involved in Load Testing, Performance Testing & Stress Testing.
• Tested ETL applications in relational databases and flat files using Informatica and tested UNIX shell scripts written for ETL Processes to schedule workflows on Autosys.
• Has good knowledge of Software Development Life Cycle (SDLC) Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).
• Well versed with writing detailed test cases for functional & nonfunctional requirements.
• Experience in designing, documenting, and executing test plans, test harness, test scenarios/scripts & test cases for Manual, Automated & bug tracking tools.
• Experience in Data warehousing integration services: SSIS, Reporting Service: SSRS and SSAS and also involved in the report generation of BI systems using Crystal Reports.
• Responsible for collection of metrics/ reporting on metrics/ design preventative and corrective measures for senior management consideration.
• Understanding and experience working on a variety of technologies such as UNIX, HTML, VB Script, XML.
• Work experience reviewing and testing of data maps between various legacy systems and relational databases.
• Experience in IT testing with expertise in test plan preparation, system testing and in automated tools such as QTP and SOAPUI.
• Expertise in use of Quality Center (QC) & Test Director for writing test cases, test execution, defect management, defect tracking and Bug Reporting.
• Experience in creating Traceability Matrix to ensure comprehensive test coverage of requirements.
• Experience in interacting with business analysts, developers, technical support & help them base line the requirement specifications.
• Attend periodic meetings, teleconferences and led discussions on problem resolution.
• Experience with version control, configuration management and change control procedures using tools such as Rational ClearCase.
• Extensive experience working with onsite/ off site team model; aware of the cultural issues; aware of the issues in terms of planning efforts/ schedules etc.
• Open to dynamic work environment and ability to work collaboratively with business analysts, other testers, developers and other team members in the overall enhancement of software product quality.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 8.6 / 7.1 / 6.2, DataStage 8.1v, Ab Initio GDE 1.14 / 1.13 / 1.12 , CO>Operating System 2.14 / 2.12 / 2.11 , EMEData Bases Oracle 10g / 9i /, MainFrame via web3270, DB2 UDB, MS SQL Server 2000 / 7.0, MS-Access

Development Languages: SQL*Plus, T-SQL, PL/SQL 2.2 / 8.x, Unix Shell Scripting, Benthic Software Golden 5.7/ Goldview32/ ImpExp32, TOAD 7 / 7.6, SQL Loader, VBA

Operating Systems: UNIX (AIX), Linux, MS-DOS, Windows 10 / XP / 2000

Scheduling Tools: Tivoli Workload Scheduler (TWS) for Z / OS, CA7, Autosys.

BI Tools: Cognos 8, Business Objects

Methodologies: Ralph Kimball’s Data modeling, Star and Snowflake Schema Modeling

Testing Tools: HP Quality Center 11.5, Quick Test Professional, loadrunner

Workflow Tools: PuTTY, WinSCP3, MS-Project, MS-Excel, MS-PowerPoint, MS-Word.

PROFESSIONAL EXPERIENCE

Confidential

Sr. ETL Tester / Analyst

Responsibilities:

• Coordinated all QA activities and enhancements using Agile Methodology.
• Conducted Smoke testing, Functional testing, Regression testing, Integration testing, User Acceptance Testing (UAT) and Data validation Testing.
• Responsible for validation Target data in Data Warehouse and Data Marts which are Transformed and Loaded using Informatica Power Center also tested various Reusable ETL Transformations which facilitate Daily, Weekly & Monthly Loading of Data.
• Developed and maintained multiple project deliverables such as Test Plans and Test Cases.
• Reviewed the Business Requirement Document to understand the process and write Test Plan and Test Cases.
• Create Crystal Reports, which would facilitate decision-making. The Crystal Reports designed were complex and used formulas, parameters, selection criteria, sub reports etc.
• Tested the performance bottle necks at sources, targets, mappings, and sessions and employed required measures.
• Hands on experience in collecting several metrics and come up with corrective measure to be presented to senior management.
• Created Integrated summary data from multiple Oracle tables to represent the business perspective of the top management executives
• Responsible for testing and reviewing of ETL mapping and transformation specifications based on the business requirements from various cruise specialists and the business team.
• Prepared scripts, running tests, Analyzing results in LoadRunner 9.1 for Performance testing.
• Developed SQL queries to check the database automatically and checking the data integrity in accordance with business standards of the company.
• Executed SQL queries for validation of data and used TOAD for SQL Server to write SQL queries for validating constraints, indexes.
• Executed and managed test cases and reported bugs in Quality Center.
• Used Clear Quest and Quality Center as the Defect management Reporting tools.
• Performed functional and load testing using SOAPUI.
• Used Clear Case as the Version Control tool.
• Created and executed automated tests for functional, and regression testing using Quick Test Professional using VB scripts.
• Inserted various types of check points including text checkpoints, text area checkpoints and Image checkpoints.
• Hands on experience in collecting several metrics and come up with corrective measure to be presented to senior management.
• Good knowledge of Financial Products like Derivatives, Equities and Fixed Income.
• Hands on work experience working with offsite team model; coordinate my own efforts with team members in the off- site team.
• Participated in User Acceptance testing (UAT) and involved in UA test cases, Executed test cases, Documenting Defects, Resolved defects and Signed Off from Application.

Environment: Windows - 7, Vista, XP, UNIX, Oracle 11g, SQL Server 2008, TOAD, SQL, PL/SQL, Crystal Reports 14, Informatica Power Center 9.1, Erwin 8, QC 10.0, QTP 10.0, SOAPUI, HTML, XML, Java, Clear Case, Clear Quest, UML, Word, Excel, PowerPoint, Outlook, MS Visio, MS Project, Firefox, IE, Chrome, Safari

Confidential

ETL Tester

Responsibilities:

• Responsible for reviewing Requirement Specifications and Design Documents.
• Involved in Test Case Design with respect to Test Plan.
• Involved as part of automation team using QTP, developed test scripts.
• Involved in implementation of ETL best practices and Maintain, backup and restore the Informatica ETL repositories for the QA team.
• Involved on testing the new functionalities based on test cases and coordinated with development team in fixing the issues.
• Prepared and executed scenarios for the Regression testing on new ETL process builds.
• Tested Informatica folders, global sources, global targets, global ODBC connections, global FTP connections workflows, data profiling and manage metadata.
• Worked on conversion of manual integration tests into automated tests using QTP.
• Performed tests for Functionality, GUI and Backend.
• Executing, Reporting and Tracking the defects using Quality Center.
• Executed regression tests at each new build in QTP
• Created and maintained Regression test suite to check the progress of the testing process by performing identical tests before and after fixing defects
• Tested data models and data maps (extract, transform and load analysis - ETL analysis) of the datamarts and feeder systems in the aggregation effort.
• Customized the scripts according to the requirements by using conditional statements and loops.
• Coordinate with manual tester and set up expectation on what will be handled by automation team.

Environment: Vista, XP, 2003, UNIX, QTP 10.0, XML, HTML, UML, TOAD, PL/SQL, Crystal Reports 14, QC 10.0, Informatica Power Center 8.6/8.1, Erwin 7.2, JavaScript, Word, Excel, PowerPoint, Outlook, MS Visio, MS Project, VMware

Confidential

ETL Tester

Responsibilities:

• Attended walk though meeting in which business rules and functionalities were discussed
• Coordinated all QA activities and enhancements using Agile Methodology.
• Developed Test Plan and wrote Test Cases.
• Performed Sanity testing, System testing, Functional testing, Integration testing, Web testing and GUI testing.
• Performed Cross browser compatibility testing and cross platform compatibility.
• Prepared Test Plan wrote Test Cases and executed test scripts as well as tracked bugs and generated defect report using Quality Center (QC).
• Prepared test data for positive and negative test scenarios for functional testing as documented in the test plan.
• Designed various test Cases with different test conditions.
• Validated correct process of ETL.
• Hands on experience in collecting several metrics and preparation of defect reports.
• Prepared and executed scenarios for the Regression testing on new builds.
• Performed Regression testing by executing the scripts developed with QTP.
• Conducted User Acceptance Test (UAT) with users and customers and wrote issues log based on outcome of UAT.
• Adopted Data Driven Methodology to the test application with different sets of data.
• Extensively involved in performing Backend testing by using SQL.
• Performed Manual Testing of the application as well as identified the critical test scripts to be automated. Performed ETL testing to validate data is transformed correctly from OLTP to data ware house.
• Performed that all data is transformed correctly according to design spec.

Environment: Windows 7, NT, 2003, UNIX, SQL Server 2005, Quality Center 9.0, QTP 9.0, HTML, HTTP, HTTPS, XML, SQL, PL/SQL, N-Tier, Firefox, IE, Safari, MS Word, Excel, PowerPoint, Outlook, MS Visio, MS Project

Confidential

ETL Tester

Responsibilities:

• Analyzed the requirement documents and detailed design documents to prepare test plans
• Communicated with BA's for questions related to the requirements and use cases
• Tested the UNIX Shell Scripts of the ETL processes.
• Worked in OLTP and OLAP environment that includes production, QA and development database in SQL Server.
• Involved in Developing Test Strategy and Requirements Tractability Matrix (RTM) to ensure adequate test coverage.
• Involved in Test Case Design with respect to Test Plan.
• Executed Positive and Negative Test cases.
• Involved in Test Execution and Bug Reporting using Test Director.
• Performed GUI, Functional, Regression and compatibility Testing.
• Used Joins like Inner join, Outer joins while testing from multiple tables.
• Involved in performing various levels of testing like Unit Testing, System testing and Integration testing.
• Develop parameter driven ETL process to map source systems to target data warehouse with Informatica complete source system profiling.
• Performed validation testing for each field in the application for different scenarios with the use of Mercury Test Director and HP QC.
• Used Joins like Inner join, Outer joins while testing from multiple tables.
• Tested PL/SQL procedures used in the ETL batch processes; used complex SQL queries to verify the data in the database tables.
• Analyzed and validated the data stored in the data base by running SQL Queries using SQL Server 2005.
• Involved in Test Reporting on daily/ weekly basis through company prescribed format.
• Provide accurate and timely testing status reports to the QA Lead and Project Manager.
• Participated in User Acceptance testing (UAT) and involved in UA test cases, Executed test cases, Documenting Defects, Resolved defects and Signed Off from Application.
• Executed test cases through Iterative testing for testing the incremental functionality.
• Responsible for communicating with Development Team, Technical Support, Business Support in order to resolve the issues.

Environment: NT, 2003, 2000, UNIX, C, Test Director 7.0, SQL Server 2005, SQL, PL/SQL, Oracle Designer 9i, TOAD, Informatica Power Center 7.1.2, Power Connect, UML, MS Word, Excel, PowerPoint, MS Visio, MS Project, QC 8.2, SOAP UI, SQL Server 2005, XML

Confidential

DWH / ETL Tester

Responsibilities:

• Attended meetings (walk through) with assigned application teams to get details on Application overview, Business requirements and Functional Requirements.
• Performed Manual Testing to check usability of the system.
• Performed tests for Functionality, GUI and Backend.
• Tested Informatica folders, global sources, global targets, global ODBC connections, global FTP connections workflows, data profiling and manage metadata.
• Developed Test Plan and created Test Cases from the Business Requirements.
• Involved on testing the new functionalities based on test cases and coordinated with development team in fixing the issues.
• Validated SOAP Response and Used Assertions.
• Performed load testing for checking the application's performance under various capacities using various strategies such as, Burst and built and performed test cases for END to END testing using Quality Center.
• Involved in implementation of ETL best practices and Maintain, backup and restore the Informatica ETL repositories for the QA team.
• Executed Batch tests using QTP.
• Filed defects using Quality Center as the defect management and reporting tool.
• Collaborated with Project Manager and QA Lead to monitor and communicate status of showstopper and high severity defects.
• Involved on testing the new functionalities based on test cases and coordinated with development team in fixing the issues.
• Used SQL Queries to verify and validate Data populated in Front-End is consistent with that of Backend, used Insert, Update, Aggregate and Join queries.
• Prepared and executed scenarios for the Regression testing on new ETL process builds.
• Tested data models and data maps (extract, transform and load analysis - ETL analysis) of the datamarts and feeder systems in the aggregation effort.
• Performed Regression test to ensure product integrity after modification and enhancements.

Environment: Windows - 7, Vista, XP, NT, 2003, UNIX, SOAPUI, QC 9.5, QTP 9.5, Oracle 10g, TOAD, Informatica Power Center 8.6/8.1, Erwin 7.2, SQL, PL/SQL, JavaScript, HTML, HTTP, HTTPS, XML, 3-Tier, MS Word, Excel, PowerPoint, Outlook, MS Visio, MS Project Firefox, IE, Chrome, Safari