SUMMARY

• Over 7+ years of experience working as a Data QA Analyst / ETL tester in almost all the domains like Financial and Banking.
• Experienced in developing Test Plans and Test Cases for different types of software testing.
• Excellent understanding of Software Quality Assurance techniques, Agile Methods and complete
• Proficient in both Manual and Automated Testing Tools such as QTP, Load Runner.
• Extensive knowledge of SDLC (Software Development Life Cycle) methodologies.
• Expertise in Bug reporting tools such as Test Director, Quality Center and Rational Clear Quest
• Validation of SQL data is done by using tools like Rapid SQL, Toad for databases like Oracle, Sybase, SQL Server
• Extensive knowledge in database querying and data manipulation using SQL, TSQL, and PL/SQL.
• Experience in working with different modules of Quality Center such as Requirements, BPT, Test Plan, Test Lab and Defects.
• Experienced in validating source to target mappings, their implementations via ETL tools, and the testing processes involved in a data warehousing environment.
• Experience in working with Business Analysts to understand the business critical functions and workflows define in BPT module of Quality Center and to convert them into automation test scripts using QTP.
• Experienced in Bug Tracking Tools such as Quality Center.
• Performed Back End Testing by executing SQL queries.
• Performed portfolios of clients and assignments and key client relationship, develop and deliver services and value charters
• Effective Time Management Skills and consistent ability to meet client deadline.
• Assisted the Project Manager Plan, Coordinate, and Monitor project levels of performance and activities to ensure project completion.
• Excellent project planning, design and management skills.
• Excellent analytical, problem solving, presentation, and interpersonal skills.
• Good team player with excellent communication skills and ability to lead, manage and work independently in a time sensitive environment.

TECHNICAL SKILLS

Testing Tools: QTP/UFT, SOAPUI, RSW Suites, SILK

Test Mgmt Tools: HP ALM/Quality Center, Microsoft Visual Studio Test Management

Scripting Languages: TSL, VB Script, C, C++, Java, PL/SQL, TSQL

Query Tools: MS SQL Server Management Studio, SQL Analyzer, SQL+

Web Reporting Tools: SSRS (SQL Server Reporting Services) etc.

Technologies: HTML, XML

Servers: MS IIS, Apache, Web logic

Database: MS SQL Server, MS Access, Teradata, DB2, Oracle

Platforms: Windows, UNIX, Mac OS X

PROFESSIONAL EXPERIENCE

Confidential - Pittsburgh, PA

Sr. Data Quality Analyst

Responsibilities:

• Interacted with developers to report and track bugs using HP ALM/Quality Center
• Wrote SQL queries to validate source data versus data in the data warehouse including identification of duplicate records.
• System was implemented using Informatica and the Warehouse in Teradata.
• Used HP ALM/Quality Center for managing and reporting defects.
• Prepared Test status reports for each stage and logged any unresolved issues into Issues log.
• Worked with the components of Data Warehousing like components model, ETL tools
• Involved in extensive DATA validation using SQL queries and back-end testing
• Wrote complex SQL, PL/SQL Testing scripts for Backend Testing of the data warehouse application.
• Extensively performed ETL and QA Testing process to ensure the quality of the software.
• Responsible for preparing and executing System Test Plan and Test cases using HP ALM/Quality Center
• Assisted in kicking off ETL jobs using Data stage Director and analyzed the data in dimension and fact tables.
• Responsible for different Data mapping activities from Source systems to Teradata.
• Validated the ETL Scripts in the Target Database (Oracle) for creating the cube before migrating it to SQL Server.
• Reviewed the Business Requirement Documents and the Functional Specification.
• Prepared Test Plan from the Business Requirements and Functional Specification.
• Understand the ETL Design and Mapping documents and identify the Test Scenarios and prepared the Test cases.
• Involved in testing of Universes from different data sources like DB2/ Teradata.
• Prepared test scenarios and test cases in HP ALM/Quality Center
• Experienced in writing complex SQL queries for extracting data from multiple tables.
• Preparation of System Test Results after Test case execution.
• Ability to use testing tools to execute tests (HP ALM/Quality Center)
• Designed and developed UNIX shell scripts as part of the ETL process to automate the process of loading, pulling the data for testing ETL loads.
• Managing, tracking, documenting defects using HP ALM/Quality Center.
• Validating the load process of ETL to make sure the target tables are populated according the data mapping provided that satisfies the transformation rules.
• Queried Teradata Database and validated the data using SQL Assistant
• Investigated software bugs and reporting to the developers using HP ALM/Quality Center Defect Module.

Environment: SQL, PL/SQL, UNIX, putty, Teradata, Files, HP ALM/Quality Center, ORACLE, UFT, MS Office, MS Excel, MS Word, Agile, SOAP UI.

Confidential, Cranston, RI

Data QA Analyst/ Warehouse Tester

Responsibilities:

• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
• Used SQL Server for writing complex SQL Queries to validate the data for source and target
• Arranged meetings with developer and BSA to understand the business needs and some incidental defects before logging them in.
• Tracking defects using the HP ALM/Quality Center as a defect management tool.
• Interacting with the developers regarding the status of defects in different builds.
• Involved in Verification of builds and deployment of final builds.
• Conducted the defect report in HP ALM/Quality Center.
• Validated Counts, Referential Integrity Checks, table structures, and transformation rules in Source and Target tables
• Executed test cases and logged in defects for failed test cases in HP ALM/Quality Center
• Developed and executed test cases test Scenarios and followed-up defects using HP ALM/Quality Center
• Responsible for testing all new and existing ETL Data Warehouse components.
• Responsible for testing and reviewing of ETL mapping and transformation specifications based on the business requirements from various teams and the business teams.
• Executed test cases through HP ALM/Quality Center and reported defects in QC.
• Developed mappings in Informatica to load the data from various sources into the Data Warehouse
• Involved in writing Test scenarios, Generic tests cases, detail Positive and negative test cases for ETL also Preparing ETL and SQL routines/code for performing ETL testing (system and integration testing) and Documenting the test results
• Developed the reports using HP ALM/Quality Center.
• Performed Data Profiling of current state of data in the Data Warehouse by doing Data Analysis using advanced SQL Queries and Microsoft Excel, finding Gaps in Data and formulating solutions for the same
• Arranged meetings with the Project Teams to discuss the test approach used for the Data Conversion and ETL modules
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping
• Worked with the components of Data Warehousing like components model, ETL tools.

Environment: Java, J2EE, .NET, Teradata, Enterprise Data Warehouse, ETL, SSRS, Informatica, SQL Server, PL/SQL, XML, HP ALM/Quality Center, QTP/UFT, Etc.

Confidential, Cleveland, OH

QA Analyst / Tester

Responsibilities:

• Participated in requirement walkthroughs and creation of test plan.
• Developed and executed test cases, test scenarios and followed-up defects using Quality Center.
• Experience in working with Agile as well as traditional SDLC cycles.
• Compiled, Organized and Reported data to aid with decision making.
• Used Defect module of Quality Center to identify, manage and resolve defects through the test execution phase.
• Used Quality Center to create Business Components, write test cases, execute tests, log, assign and track defects
• Performed Integration Testing, Smoke, System Testing and Regression Testing.
• Interfacing with developers to resolve the technical issues.
• Developed Web Services scripts for a Web Service call sing SOAP UI
• Functionally validated Web Services delivered in SOAP XML format as provided in specification document.
• Performed negative and positive testing using SQL Queries
• Actively participated Agile and Scrum meetings, review and developed test scenarios.
• Created various test sets for different test cycles within Test Lab module of Quality Center and perform the test case assignment within Quality Center for offshore QA testers.
• Created various test reports such as Test Execution Status, Defect Status, and Defect Injection Rate through Reports and Graphs feature of Quality Center and publish them on as needed basis on the SharePoint site.
• Conducted Bug Review meetings by reviewing and discussing all defects by their business severity and worked actively development and business team to perform the root cause analysis in order to find the resolution.

Environment: Windows, Quality Center, QTP, SQL Server, Informatica, SSIS, XML, XML Schemas, Crystal Reports, Oracle/UNIX, Enterprise Data Warehouse, ETL, SSRS, Informatica, etc

Confidential, Harrisburg, PA

QA Analyst

Responsibilities:

• Involved in manual testing of test cases.
• Used Rational Clear Quest for bug tracking and reporting.
• Participated in the creation and execution of automated test cases using Visual Studio 2010.
• Performed automated testing using Silk.
• Maintained Test Matrix and Traceability Matrix.
• Develop parameter driven ETL process to map source systems to target data warehouse with Informatica complete source system profiling.
• Created and executed test plans that improved data warehouse report quality using Word, Excel and Access.
• Worked in the agile development environment with frequently changing requirement and features set review product requirement document, functional requirement, test plan and test case document.
• Configure NSG notification, debugging and JMS message content using Web Logic Server.
• Created Mock Services using SOAP UI to get responses as defined in the release.
• Used Linux version as well as GUI version of SOAPUI for web service testing.
• Performed database designing, developed packages, stored procedures, functions and database triggers using SQL.
• Conducted Unit Testing, Integration Testing and System Testing.
• Participate in weekly meeting with the management team and walkthroughs.
• Performed Smoke Testing, Security Testing, White Box Testing, GUI Testing and User Acceptance testing.

Environment: Test Director, Windows NT, Java, HTML, Oracle7.0, Apache, UNIX.