Professional Summary

• Seven years of experience in Verification & Validation of critical business applications asQA Analystin ETL/Data warehouse, client server and web environments using state of the art tools & techniques(HP– Mercury, IBM - Rational etc.) in Financials, Banking, Insurance, Technology, Health Care, Government, Non-Profit orgs and CRMdomains.
• Sound experience in end to end Testing Life Cycle of various technology platforms like Data Stage, Informatica, METaL, BO, Microstratagey, Cognos, SSAS, SSIS, SSRS, Oracle, DB2, SQL Server, Java, J2EE, .Net, Mainframe, ERP/CRM - Salesforceapplications.
• Sound experience in creating, updating and peer review of Business Requirements Documents, System Requirements Specifications, Functional & Non Functional Requirements.
• Extensive experience in creation and execution of Test Plan, Test Cases, Test Scenarios, Test Scripts, Test Reports, Defect Reports, and Test Summary documents.
• Proficient in using automated testing tools, Requirements Management tools and Defect Management tools like HP - ALM, IBM-Rational Suite, and third party integration tools.
• Experience in performing Functional & Non Functional Tests, System Integration Tests, Ad-hoc Tests, Sanity Tests, Regression Tests, Smoke Tests, Positive – Negative Tests, white box, black box, Data Center Migration testing and UAT.
• Solid Back End/Data base, OLAP and OLTP Testing experience by writing and executing SQL Queries.
• Expertise in Testing Dimensional Data Models designed using Star and Snow Flake Schema and complex Business rules created by Source to target mappings and various transformation rules.
• Experienced in various SDLC methodologies –Agile, Waterfall, and V-Model.
• Strong Experience in using various tools likeVSTF, Winscp, Putty,BIDS,Rapid SQL, Toad, Teradata SQL assistant and Quest Centralfor testing effectively at the fastest and thoroughly.
• Sound experience on various Operating systems like Windows, UNIX.
• ExcellentDebugging, Data Analysis, Data Validation,analytical, problem solving and communication skills along with strong verbal and written skills.
• Good Team player with the ability to communicate effectively at all levels of the SDLC.

Technical Expertise

Requirements Mgmt.&Testing Tools :

Quality Center,Test Director, Clear Quest, Clear Case,SoapUI, Req. Pro, Load Runner

Database Management:

DB2 UDB, SQL Server 2008/2005/2000, Oracle 8i/9i/10g, Teradata, MS Access

ETL Tools:

Data Stage, METaL and Informatica

Reporting Tools:

SSRS, Business Objects 5.1/ 6.1/XI R2, Microstrategy, Cognos

Operating Systems:

Window 2003 Server/98/ XP/ Vista and UNIX (AIX).

Version control :

Visual Source safe, Product Studio, Visual Studio Team Foundation

Web Programming:

HTML, XML, Java Script, VB Script, HTTP, Web services, SOAP

Programming languages:

VB.Net, ASP.Net, C#.Net, C/C++, Java,SQL, PL/SQL, VB 6.0

Defect Tracking tool:

VSTF, QualityCenter, Test director, Clear Quest

Rational Testing tools:

Rational clear case, clear quest, Rational Robot

Tools & Utilities:

SSMS, BIDS, Toad, Teradata SQL Assistant, WinSCP, Putty, IDEAL, Share Point, MS Office 2003, and Microsoft Outlook.

Professional Experience

Confidential,Atlanta, GA Mar’12 - Present
Confidential,Lead QA Tester

Responsibilities:

• Participate in JAD sessions with Product owners, business users, Data Modelers, and developers to estimate/formalize testing requirements.
• Review Business Requirement Documents and Technical Specifications.
• Create detailed test plan, test cases and test scripts using visual studio based on the source to target mapping document.
• Create Source to staging quality validation test cases and validate the results are matching with expected results.
• Create parametric SQL statements to reuse across QA - SIT, UAT environments.
• Verification and Validation of the Transformation Rules and mappings by writing and executing complex sql scripts in sql server.
• Validation of the business logic implemented, slowly changing dimensions, default values, audit columns, duplicate records, and referential integrities.
• Test end to end data flow from source to mart to reports (aggregate functions).
• Create precise SQL code to test reporting database data.
• Coordinated with the development team to move QA\'ed jobs to higher environments.
• Responsible for creating and managing defects and traceability matrix for all stages of ETL in visual studio as a lead tester.
• Conducted Defect Triage meetings with Developers and Business users on daily basis, and also responsible for creating defect management reports for Executive Management and Steering Committee
• Responsible for planning test execution schedule, and allocation of resources,tracking and monitoring actual work progress against planned work assignments.
• Responsible for creating testing status reports and summary reports for Go/ No Go decision making and supported application.

Environment: SQL Server 2008, Visual Studio, SSRS, Excel and MS Office

Confidential,Atlanta, GA Feb’09 –Feb’12
QA Analyst/ Business Analyst

#1 Labor Exchange (LEX):Employment Services and Unemployment insurance and claims system

#2 Workforce Investment Act (WIA): The WIA/TAA Tracking and Reporting System provides a tool for detailed tracking of funding, obligations, and expenditures for the Workforce Investment Act (WIA)

#3 State Information and Data Exchange System (SIDES):GDOL exchanges information of UI separation responses with large Third Party Administrators (TPA) and other employer customers.

#4 UI Legal (also worked as Business Analyst for this project):Tracks petitions that are filed with the Georgia Department of Labor.

Responsibilities:

• Reviewed Business Requirements, Technical Specifications and Source to Target Mapping (STM) document for creating Test Plan and Test Scenarios.
• Analyzed the user requirements and Data mapping documents by interacting with system & data architects, developers, DBAs and business users
• Conducted testing using the standards, guidelines and structured methodologies in testing the application.
• Created Test Cases, Test Scenarios, Test data, execution schedule and traced back to requirements for building Requirements Traceability Matrix.
• Designed test cases to cover System testing, Integration testing and Regression testing and UAT.
• Documented, Implemented and executed Test plans, Test cases and Test scripts based on baseline requirements.
• Executed Unix Jobs to load data into staging, Mart, and warehouse.
• Tested DDLs, data loads (counts), referential integrities, Views and reports.
• Created Source to staging quality validation test cases and validate the results are matching with expected results.
• Tested database by writing complex SQL queries to verify the database tables as part of ETL data validation.
• Tested Web Services using SOAPUI tool and monitored error logs to identify program and/or data processing errors.
• Coordinated with business SME’s and end users for requirements updates and during entire testing life cycle of migration for testing needs
• Conducted JAD session with business users and created business requirements for UI project , and also conducted peer review of requirements
• Updated business requirement document as per peer review comments and baseline BRD in Requisite Pro /Quality Center.
• Created process flow mappings and use cases for UI project and presented to Business users.
• Participated in all the review meetings, Project meetings, Walk through and Defect report meetings periodically.

Environment: DB2, Oracle, SQL Server, UNIX, Quality Center 11, QMF, WIN SCP, Putty, IBM Rational Suite, Java, J2EE, Web Services, SOAP, XML, Business Objects and MS Office

Confidential,Redmond, WA May’08 – Jan’09
Sr. QA Tester
Confidential,Business Intelligence Center of Excellence

Responsibilities:

• Reviewedrequirements andtechnical specifications, Source to Target Mapping (STM) document for creating Test Plan and Test Scenarios.
• Created Test Plans,Test Cases, Test Scenarios, Test data and test strategies.
• Performed technical tests such as installation scripts validation for build installation
• PerformedSystem testing,regression testing, Integration testing and User Acceptance testing (UAT)
• Performed data validation on Source, Staging and target dimension and fact tables.
• Validated Slowly Changing Dimensions and Change Data Capture (CDC) by writing complex sql queries.
• Developed sql queries to validate data in Cube against data mart.
• Executed test cases/scripts and documented test results.
• Performed Security testing onmost critical modules.
• Tested SSRS reports as part of data validation between cube and reports.
• Created bugs and issues during testing in VSTF and communicated to team in Test Triage meetings on daily basis.
• Created test reports and status reports and presented to Test lead on daily basis and to the management on weekly basis.

Environment:.Net 3.5,Server 2008 (SSAS, SSIS, SSRS),Visual Studio Team Foundation (VSTF),METaL, Exceland Business Intelligence Development Studio (BIDS).

Confidential,Rochester, MN Jan’08 – Apr’08

ETL QA

Confidential,Enterprise Data Trust

Responsibilities:

• Analyzed Functional specifications and requirement documents to identify the gaps and reported identified gaps to the project teams to raise change requests.
• Created Test Plans, Test Procedures and Test Cases.
• Conducted System Testing to test each and every part of the System.
• Responsibilities include functional, integration and User acceptance testing.
• Developed Request for Change (RFC) documents for the defects in the application.
• Executed Unix jobs to load data from source to staging to warehouse.
• Validated data at each step of the ETL based on the transformation.

Prepared Test data (Input Data) strictly following referential Integrity for testing large quantities of data.

Transformation rules applied are thoroughly reviewed; data is tested efficiently at each level of ETL process by writing complex SQL queries against the source and Target.

Validated the given DDLs, tested data loads and verified objects created.

• Participated in various project status meetings and updated testing status
• Executed test scripts and verified the results.
• Interacted with developers, Business & Management Teams and End Users.
• Participated in Walkthrough and defect report meetings periodically.
• Mentored team members (5) on testing process and conducting testing.
• Extensively worked on Quality Center 9.0 for Defect reporting/tracking.
• Documenting and communicating test results using Quality Center 9.0.

Environment: Quality Center 9, Informatica, Oracle 10g, Teradata,Microstrategy, Embarcadero Rapid SQL, Excel, Windows XP, Java, Clear Questxml, html, UNIX, MS Office and Toad.

Confidential,Minneapolis, MNApr’07 – Dec’07
ETL QA Tester
Confidential,

Enterprise Data Warehouse

Responsibilities:

• Prepared test plans for the whole system.
• Worked in all phases of the QA Life Cycle and SDLC with timely deliverables.
• Reviewed Business requirements and System requirement specifications documents and developed test scenarios.
• Test cases were designed to cover System testing, Regression testing and Integration testing.
• Participated in walk through meetings with project manager, developers, business analysts and DBAs.
• Transformation rules for all the columns(STM) are tested writing complex sql queries, DDL statements are verified and the objects created are validated.
• Tested CCG Basel (Consumer Credit Group) as part of ETL testing.
• Executed test cases/scripts and documented test results. Reported Bugs through Quality Center.
• Submitted status and test evaluation reports to Test Lead.
• Constantly updated test deliverables by maintaining Test Matrix for latest test results information by tracking requirement changes using Clear Quest.

Environment: Quality Center 9.0/8.2, Data Stage, Clear Quest, HTML, J2EE, Java, VB Script, JavaScript, XML, HTTP, Windows 2000 server, Cognos and Oracle 9i.

Confidential,India Jan’05-Mar’07

Online Financial Services

Responsibilities:

• Analyzed BRD & SRS to prepare Test Plans and Test Cases.
• Created test casesto cover system, integration, regression and data base testing.
• Executed test cases, documented results and testing status is communicated with management.

Environment:Windows NT, JAVA, Test Director, Oracle 8.0,Microstrategy, Toad and UNIX.

Education:

Bachelor of Engineering in IT