SUMMARY

• 8+ Years of professional experience in Software Quality Assurance, QA Methodologies and SDLC in areas of Data Warehouse and ETL.
• Experience in testing software designed for Healthcare, Insurance, Finance, Sales and Marketing Industry.
• Extensive experience of testing end to end ETL processes developed using T - SQL Stored Procedures, SSIS 2008R2,2012.
• Performed extensive data warehouse, ETL QA by performing research in source systems and data feeds.
• Created test cases and test plans.
• Tested execution of ETL Processes T-SQL procedures for business rules.
• Tested the ETL processes involving data which flows from Third Party Applications, Manual Data Feeds, Automated DB restores, Data Warehouse Stage, Dimensional Data Warehouse.
• Extensive experience in data integration validations, stored procedure validations, ETL Jobs validations, triggers and replication validations by comparing the target databases with source data and expected transformation results
• Developed complex SQL queries using Management Studio (SQL Server) and SPUFI (DB2) based on built in functions, group by, having, Inner Joins, Outer Joins, Sub queries, Correlated sub queries for efficient data quality analysis and testing Application Database, Reporting Applications and Data Integration applications
• Experience in various types of testing includes Functional Testing, Smoke Testing, System testing, Integration testing, GUI Testing, Regression testing, User Acceptance testing (UAT), Load/Performance Testing, Black-box testing and End-to-end testing
• Strong experience in manual testing and script building using HP Quality Center
• Experience testing Web Services using SOAP UI
• Extensive experience in VBScript
• Experienced in reviewing test plans and test cases before QA process
• Hands on experience in HP Quick Test Professional
• Proven hands-on experience with quality assurance practices, including project plan development, test strategy development, test plan development, test case & test data review, and test automation.
• Knowledge in UML, Object Oriented Programming concepts, data models, HTML and XML.
• Self-starter and team player with excellent communication, problem solving skills, interpersonal skills and a good aptitude for learning.

TECHNICAL SKILLS

Quality Analyst: HP Quality Center 10,11,HP QTP, ALM, SharePoint 2007, 2010

ETL: SSIS 2008 R2, 2005, T-SQL, SQL*Loader

Database: SQL Server 2005, SQL Server 2008 R2,2012, DB2

Web Technologies: HTML, XML, ASP, Web Services

Methodologies: Agile, Waterfall Method, RUP

Operating Systems: MS Windows XP, Vista, 7, 8, Server 2003,2008 R2

Languages: SQL, VB Script

Software Tools: MS Word, MS Excel, MS PowerPoint, MS Project2010, VISIO, JIRA, Business Intelligence Development Studio 2008R2, Visual Studio 2008R2, SOAP UI

Source control: Team Foundation Server 2010

PROFESSIONAL EXPERIENCE

ETL Quality Analyst

Confidential, Tampa, FL

Responsibilities:

• Analyzed the Requirements from Addendums to use for Business Process.
• Created Test Scripts, Input sheet in excel for Benefits-Clinical, Transaction Fills, SCC, MIC & STCOB phases.
• Execute in Rx-Claim system and validate through Backend Data Base files.
• Prepared and executed Test scripts for various Clients
• Created test cases and test plans for the ETL process
• Reviewed and analyzed the design and developed Test Cases based on business requirements and functional specifications for the ETL processes
• Tested SSIS packages on SSIS server as well as by executing them in Business Intelligence Development Studio 2008R2.
• Tested end to end ETL processes developed using T-SQL Stored Procedures, SSIS 2008R2, 2012.
• Tested execution of ETL Processes T-SQL procedures for business rules.
• Performed extensive data warehouse, ETL QA by performing research in source systems and data feeds.
• Tested the ETL processes involving data which flows from Third Party Applications, Manual Data Feeds, and Automated DB restores, Data Warehouse Stage, Dimensional Data Warehouse.
• Used ALM HP Quality center HP ALM/Quality Center to track issues and also participated in defect review meetings for updating defect statuses.
• Developed extensive SQL queries joining multiple tables using complex inner-outer joins, set operations, sub-queries, correlated sub-queries
• Wrote complex SQL queries for data verification and data quality checks and for extracting data from multiple table, multiple databases.
• Conducted manual testing in important phases like Functional testing, Integration testing, System testing, User Acceptance Testing (UAT).
• Assisted users during User Acceptance Testing (UAT)
• Performed positive and negative testing.
• Communicated with developers to explain the bugs and issues.
• Developed Test reports and provided the same to Leads and management

Environment: SQL Server 2008 R2, SSRS 2008 R2, SSIS 2008R2, ALM HP Quality Center, MS Office, Word, Excel, Power Point, Visio.

Data Warehouse Quality Control Analyst II

Confidential, Atlanta, GA

Responsibilities:

• Created test cases and test plans for the ETL process
• Tested end to end ETL processes developed using T-SQL Stored Procedures, SSIS 2008R2 & 2012.
• Tested the ETL processes involving data which flows from Third Party Applications, Manual Data Feeds, Automated DB restores, Data extracted from Web Sites or SharePoint using Web Services, Data Warehouse Stage, Dimensional Data Warehouse.
• Tested SSIS packages on SSIS server as well as by executing them in Business Intelligence Development Studio 2008R2.
• Worked on Test Strategy, Test Planning, Test Case development, Data validation, Test reporting of dimensional data warehouse implementation which is sources from various data sources.
• Extensive experience of testing end to end ETL processes developed using T-SQL Stored Procedures, SSIS 2008R2,2012.
• Written several complex SQL queries for data verification and data quality checks and for extracting data from multiple table, multiple databases as well as Views, Functions and Stored Procedures to automate the QA processes.
• Involved in Web services testing using SOAP UI tool and created scenarios with multiple sets of data.
• Created Test Suites and Test cases in Soap UI tool to execute regression scenarios for Web Services testing.
• Used ALM HP Quality center and also participated in defect review meetings for defect tracking and updating defect statuses.
• Prepared test data includes identifying Groups, members, providers and procedure codes and diagnosis codes etc. for all scenarios.
• Performed manual testing of back-end processes such as services, SQL Batch Processes and evaluating results.
• Conducted manual testing in important phases like Functional testing, Integration testing, System testing, User Acceptance Testing (UAT).
• Coordinated with cross-functional teams during the course of testing.
• Enthusiastic and self-motivated team player with the ability to manage multiple projects simultaneously, meet stringent deadlines and achieve project objectives
• Improved the documentation of QA testing practices to enhance their repeatability, saving time and money and encouraging testing standardization and best practices.

Environment: SQL Server 2008 R2, SSRS 2008 R2, SSIS 2008R2, DB2,SharePoint 2010, ALM HP Quality Center, HP Quick Test Professional, MS Office, Word, Excel, Power Point, Visio.

ETL Tester

Confidential, Clinton, NJ

Responsibilities:

• Created test cases and test plans for the ETL process
• Tested the ETL processes involving data which flows from Third Party Applications, Manual Data Feeds, Automated DB restores, Data extracted from Web Sites or SharePoint using Web Services, Data Warehouse Stage, Dimensional Data Warehouse.
• Tested end to end ETL processes developed using T-SQL Stored Procedures, SSIS 2008R2
• Written several complex SQL queries for data verification and data quality checks and for extracting data from multiple table, multiple databases.
• Prepared Test Strategy & QA Schedule for manual testing for the new software
• Published Test Summary Report at the end of Testing
• Maintained good rapport with Development team and completed all the QA needs on time
• Documented and executed test cases and generated scripts using HP Quick Test Professional
• Analyzed system requirements and developed test cases for Functional, GUI and Regression testing.
• Analyzed the user requirements by interacting with Business analysts, developers and business users.
• Performed end-to-end and Integration testing.

Environment: MS Office, Word, Excel, Power Point, ALM HP Quality Center, Visio, SQL Server 2005, SSRS 2005, Crystal Reports, SharePoint 2007, Oracle, VB 6.0

Quality Analyst

Confidential

Responsibilities:

• Provided Quality Assurance for a portfolio of applications assuring that a quality product is available to the clients (Doctors) and employees.
• Created and framed test scenarios/cases that emulate real-world business activities and operations in a controlled test environment
• Based on framed scenarios, wrote and manually executed detailed functional and regression test cases using documented functional and technical requirements
• Conducted manual testing, defect identification, defect and test execution reporting, and retested of assigned enhancements and defect fixing
• Developed and executed formal test plans to ensure the quality delivery of software applications
• Developed and created reusable test data, and employing test strategies so as to minimize test collisions and maximum test efficiency
• Conducted all types of testing (smoke, functional, disaster recovery, system /regression) to validate system performance as per the expectations

Environment: MS Office, Word, Excel, Power Point, Visio, SQL Server 2005, SSRS 2005,Business Intelligence Development Studio 2008R2, SharePoint 2007