SUMMARY

• Over 8 years of Software Quality Assurance (QA) experience testing Data Warehouse, Database (ETL & BI), Web, and Client - Server Systems and Applications for Banking, Healthcare, Financial, Wireless, and Retail Industries.
• Experience in Defining Testing Methodologies; creating Test Plans and Test Cases, Verifying and Validating Application Software and Documentation based on standards for Software Development and effective QA implementation in all phases of Software Development Life Cycle (SDLC). In depth technical knowledge and understanding of Data Warehousing, Data Validations, OLAP, SQL Server, Oracle, and ETL.
• Expertise in Writing, Executing and Maintaining Test Plans, Test Strategy, Test Procedures, Use Cases and Test cases.
• Excellent working knowledge of System Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC) and Defect Life Cycle. Expert in Manual Testing and Back End Testing.
• Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.
• Experience in Data Warehouse using Informatica, SSIS, Data Stage & Experience working in using Databases like Oracle, SQL Server, Teradata, MS Access and DB2.
• Experience in ETL Testing, Web application Testing and Client Server application testing.
• Experienced in Functional testing, Performance testing, Load testing, Integration testing, System Testing, Regression testing, Black Box testing, Stress Testing, Smoke Testing, End to End Testing and GUI Testing.
• Have experience in testing reconcile (initial) and delta (daily) loads.
• Experience in Data Analysis, Data Cleansing (Scrubbing), Data Validation and Verification, Data Conversion, Data Migrations and Data Mining.
• Experience in Testing Business Intelligence (BI) reporting tools using Cognos, BO & Microstrategy. Have tested several complex reports including dashboards, summary reports, master detailed, drill down and score cards.
• Involved in preparation of Requirement Traceability Matrix (RTM), Defect Report, and Weekly Status Reports.
• Experienced in understanding Data Modeling, Star/Snow Flake Schema Designs, Logical Data Modeling, Normalization, Physical Design, Data Analysis, Data Modeling, Reports and Report Design.
• Expert in writing complex SQL queries and data verification for back-end testing.
• Effective in working independently and collaboratively in teams.
• Good communication, analytical skills and flexible to learn advancements in the IT industry.

TECHNICAL SKILLS

OS: Sun Solaris 2.7/2.6, HP-UX, IBM AIX 4.3/4.2, MS DOS 6.22, Win NT/2000/98/95.

ETL Tools: Informatica Power Center 8.6.1/8/7.1/6. x, Power Connect, Power Analyzer, and Power Exchange tools

BI Tools: Cognos Reportnet 1.1, Business Objects, and Microstrategy

Languages: SQL, PL/SQL, JCL, COBOL

Databases: Oracle 10g/9i/8i, MS Access, SQL Server, Teradata, DB2

Other Tools: Erwin 4.5/4.0/3.5.5/3.5.2. , MS OfficeTesting Tools Win Runner 8.2, Load Runner 7.8, QTP 8.2, Quality Center 10, and Test Director

PROFESSIONAL EXPERIENCE

Confidential, New Jersey

Sr. Quality Assurance Analyst

Environment: Microstrategy 9.2.1, SQL, PL/SQL, SQL Server 2008, Red Hat Linux 5,Teradata 12, Oracle 11gR2, HP Quality Center 10, QTP 11.

Responsibilities:

• Attended Daily Scrum meetings, Defect review meetings, Requirement understanding meetings with Business Analysts.
• Reviewed the Business Requirement document and Functional Specification document.
• Participated in preparing Test Plan from the BRD and Functional Specification.
• Developed Test Cases for the Functional/GUI Verification, ETL Data Validation, Metric Verification and Report Testing.
• Validated ETL processes and made sure that the data from source to target tables are loaded correctly.
• Created and executed complex SQL queries to validate the flow of data. Tracked and reported the bugs with HP Quality center.
• Executed the SQL's against the source and against the Target and compared the Results in the excel Sheets.
• Validated the front end reporting components created using Microstrategy and Web Intelligence reports as well as Back End testing, making sure that the correct data for a specific report are being pulled out from the Data Warehouse.
• Performed regression testing after every enhancements, build installation and releases.
• Responsible for functional testing, user interface testing and user acceptance testing.
• Worked closely with the Business analyst, System Analysts, Developers and DBA to solve the issues identified during the testing process in a timely manner.
• Executed tasks proficiently meeting crucial deadlines in an Agile Scrum environment.

Confidential, Rochester, New York

Sr. QA /ETL/Analyst

Environment: Informatica 8.6.1, BO XIR3, SQL, PL/SQL, SQL Server 2008, Unix Shell Scripting, JCL, TSO, COBOL Files, TOAD 9.2, Teradata, Oracle 10g, Mainframe, HP Quality Center 10, MQ Series, Microsoft Visio, Web Focus reports.

Responsibilities:

• Involved in gathering System and Business requirements, studying and coordinated with the Development and Business teams to prepare Test Plans and Execution Plans.
• Involved in Database testing by writing & executing SQL queries using TOAD to validate that data is being populated in an appropriate tables & manually comparing the results with front-end values.
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing.
• Participated in creating Test Plan and Test Strategies for testing ETL processes and BO Reports. Created documents as guidelines in performing testing and validation. Involved in Regression, load, UAT and Functional Testing.
• Tested ad hoc, dashboard, canned, web application and client server reports.
• Coordinate Test Data Preparation with business users covering all necessary features for securities.
• Generated tractability Metrics to ensure that all the requirements are covered by the test cases.
• Designed and developed Test Plans, Test Scripts and Test Cases in HP Quality Center and executed them based on Business Requirement (BRD), User Requirement Document (URD) and Functional Requirement documents (FRD).
• Providing testing inputs to the Project team (Project manager, Planner and the Development lead) during the Planning sessions to finalize the Work Breakdown structure (WBS).
• Participated in Daily and weekly status meeting with team members and coordinated with teams (Development, Business, and QA) for the progress of the work done in application.

Confidential

Sr. QA/ETL Tester

Environment: Informatica Power Center 8.1, Business Objects XIR2/6.5.1,SQL, PL/SQL, SQL Server 2000/2005, Teradata, XML, XSD, XML Spy 2008, XSLT, TOAD 9.2, Oracle 9.2, HP Quality Center, Rational Suite, DBArtisan 8.5.2, IBM AIX 5.5

Responsibilities:

• Designed and developed Test Plans, Test Scripts and Test Cases based on Business Requirement and Functional Requirement documents.
• Used various SQL queries to validate the test case results for back-end test cases.
• Developed and involved in both Manual Testing and Automation Testing.
• Tested Reports that were created in BO by running SQL.
• Worked as ETL Tester responsible for the data verification/validation and ETL Testing.
• Experienced in writing complex SQL queries for extracting data from multiple tables.
• Performed UI testing, Regression Testing, UAT and Functional Testing

Confidential

Data/SQL Tester

Environment: Informatica Power Center 8, SQL Server 2000/2005, SQL, PL/SQL, Erwin 4.0, XML, JCL, TSO, TOAD, HP Quality Center, Teradata, Report Net, Mainframe,, Cognos 8 B Report Studio, Cognos 8 BI Query Studio, Report Net 1.1

Responsibilities:

• Gathered user requirements from each Business Units for test.
• Interacted with the Business users to identify the process metrics and various keys dimensions and measures.
• Designed and developed Test Scripts and Test Cases and executed them.
• Used Teradata SQL Assistant extensively to work with Teradata Database.
• Documented defects accurately and with sufficient information to enable developers to analyze and reproduce the defect using Test Director’s defect reporting tool. Used Query Studio to test ad hoc reports.
• Used various SQL queries to validate the test case results for back-end test cases.
• Tested several complex reports generated by Cognos including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards.
• Involved in Regression, UAT, Integration and Load Testing.
• Developed complex queries using different data providers in the same report.

Confidential, Chicago, IL

Data Tester/ETL/SQL

Environment: Informatica Power Center 7.1, Oracle, MS Excel, Flat Files, SQL, PLSQL, SQL Server, Erwin 4.0, Unix Shell Scripting.

Responsibilities:

• Used Informatica Power Center for Extraction, Loading and Transformation (ETL) of data into the Data Warehouse.
• Involved in developing and writing the Test Cases, Test Plans and Test Scripts using the Business Requirement
• Involved in Manual Testing, positive testing and Negative testing of the Application.
• Created the test data & Coordinating with Developers/Leads in resolving bugs.
• Completely involved in developing Test Plans, Test Cases/Test Strategy with input from the Business Analysts
• Extensively involved in the UAT and Performance testing of the programs.
• Coordinated with QA Testing Team to test various test scenarios involving Test Plans, Test Cases and Test Scripts.
• Used various SQL queries to validate the test case results for back-end test cases.

Confidential

Data Analyst/Tester

Environment: Informatica Power Center 6.x, Oracle 9i, SQL, PL/SQL, Mainframe, Erwin 4.0, UNIX Shell Scripting.

Responsibilities:

• Gathering of user requirements and source system analysis and establishing mappings between sources to target.
• Involved in writing the Test Plans based on Business Requirement and Functional Requirement documents and writing the Test Cases and Test Plans based on Informatica mappings, Data Analyst mappings and BA Visio diagrams.
• Involved in Positive and Negative Testing and extensively involved in the Performance testing.
• Used various SQL queries to validate the test case results for back-end test cases.