PROFESSIONAL SUMMARY

• Over 15+ years of IT experience & over 11 years in Quality Assurance with testing experience in Manual Testing for Client/Server and Web - based Applications and ETL/BI Testing and extensive background in quality assurance, design verification and various test methodologies. As a Sr.QA/ Lead and QA analyst expertise in technical and functional environment with demonstrated leadership abilities and setting up test environments.
• As a QA Lead expertise in Project management in designing and developing test Strategy, Test Plan, Test Cases and generate test Reports, Defect Tracking and preparation of Production quality documents.
• Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture.
• Expertise in designing the Test Plans, Test scenarios and Test cases in order to test the application.
• Experience in Oracle database testing and all phases of Software Development life Cycle (SDLC) and Development/Enhancement and Maintenance of application.
• Experience in ETL and BI testing.
• Strong data base experience in Oracle, Teradata, Sybase, and DB2 & SQL.
• Experience in developing Test Strategy, Test plan, Test cases, Use Cases, Test scripts and traceability matrix.
• Strong in developing Stored Procedures, Functions, Triggers and packages utilizing SQL.
• Worked on different versions of Cognos for Report testing.
• Expert in writing the complex SQL queries.
• Extensive experience in performing various types of testing such as Integration testing, Functional testing, Regression testing, Load testing, System testing, and User Acceptance Testing (UAT).
• Experience in testing Data Marts, Data Warehouse/ETL Applications developed in Informatica, Cognos/BI testing and Ab Initio using Oracle, DB2, Teradata and UNIX.
• Ability to mentor multiple testing projects with effectiveness to increase productivity based on agile process.
• Extensive experience in analyzing success Factor throughout organizations both large and small a tightly integrated- empower seamless business execution to drives execution end-to-end across the business to ensure that every single employee from the top to the bottom on the same page.
• Experience in Implementing SDLC process in various test methodologies like Agile/Agile Scrum and Waterfall
• Proficient in identifying, documenting and analyzing Business Requirement Documents (BRD), Functional Requirement Documents (FRD) and Software Requirement Specification (SRS).
• Expertise in use of HP / Mercury tools for writing test cases, test execution, defect management, and defect tracking.
• Excellent skills in Bug Reporting using HP / Mercury Quality Center
• Meet weekly / Monthly with team members to various goals, responsibility, and understanding of assigned projects to clarify on projects to reviewing their test cases and documentation.

TECHNICAL SKILLS

Operating Systems: UNIX, Windows 2000, Windows XP.

Languages: C, C++, PL/SQL, T-SQL, SQL, SSIS, Visual Basic 6.0, SAS 9.1

Web Technologies: XML, XSL, XHTML, HTML, CSS, JavaScript, VBScript

Database: SQL, Oracle, (ETL ; EDW) ; EDI

Testing Skills: Manual Testing, Automation, Test Plan, Test Strategies, Test metrics and Test Case Preparation

Automation Tools: Selenium, Rational Functional Tester (RFT 8.1.0), Rational Performance Tester (RPT 8.3), QTP 9.0

Reporting Tool: Business Objects, Crystal Reports

Functional Test Tools: HP ALM 11.1,Win Runner 8.0Defect Tracking Tool Rational Clear Quest (RCQ 7.0), Mercury Quality Center (MQC 9.2); Bugzilla & Jira

Data Warehouse Tool: Informatica Power Center, MS DTS Packages & Fast Load

Quality Tools: Metrics, Rational Portfolio Manager (rpm)

Traceability Matrix Tools: Requirement Management Tool (RMT), ReqPro, PRISM

Other Tools: Remedy 7.6, Rational Policy Tester (RPT), Incident Management, Rational Requisite Pro, SOAP UI, Beyond compare, JIRA, Contour and PivotalTracker.

PROFESSIONAL EXPERIENCE:

Confidential, MN

Senior QA Analyst

Responsibilities:

• Analyzed Business Requirements documents to get a better understanding of Business Perspectives and assist in implementing improvements in test methods and strategies.
• Involved in Writing the Test Cases and Test Plans based on Source to Target Mapping Documents in Quality Center.
• Managed the on-shore and off-shore test teams by delegating tasks to the team and escalate quality concerns to management.
• Review current test cases to reflect changes made to the Test Plan documentation for new functionality and performance issues.
• Involved in full SDLC process and ensure the specific elements of the product are thoroughly tested per the Test Plan documentation.
• Responsible for the analysis, reporting and communication of test results on all assigned projects and overall measurement of the test efforts.
• As a part of testing process to identify, analyze and document all defects and operational characteristics that are inconsistent with stated requirement and design specifications by providing meaningful defect reports with the defect tracking system( HP ALM QC)
• Tested several complex reports generated by Cognos including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards.
• Validate log files for warnings, errors, and inbound/outbound XML messages sent through MQ.
• Performed execution of application software testing in coordination with teams the typically include managers, project managers, business analysts, system analysts and developers.
• Facilitated test case peer reviews with project and business team members.
• Performed the Back-end Integration Testing to ensure data consistency by writing and executing SQL Statements and involved in extensive data validation using SQL queries and Back-end testing in web testing in point of Sales, Return and Exchange of mobile device and iOS & iPad applications.
• Experience in web services end-to end testing of web applications, IOS, android apps and voice-based applications.
• Involved in extensive data validation using SQL queries and Back-end Testing.
• Involved in Mapping the Test Cases with the Requirements and Mapping Document.
• Involved in writing Test Cases for Enterprise Data Warehousing (EDW) Tables in Quality Center.
• Wrote SQL queries for each Test Case and executed them in Toad to validate the data between Enterprise Data Warehouse and EDW Staging Tables.
• Logged the Defects while running the Test Cases and assigned it to ETL Developers using Defect Tracking Tool.
• Extensively tested several Cognos reports for data quality/BI testing
• Designed and developed detail test cases using Quality Center tool and developed requirements traceability matrices to ensure appropriate level of test converge.
• Reviewed system functional and non-functional requirements and create test cases to ensure overall quality.
• Confer with project managers, developers, analysts and other to clarify software intent, business and system requirements.
• Participated in software requirements specifications and high level and detailed design views.
• Designed and documented all the Issues and defects to ensure application software functionality for Present and Future Builds.
• Involved extensively in manual; automation testing in Agile SCRUM methodology.
• Experience in X12 EDI Transactions 270,276,277,,832,835,855,856,820,834,837
• Prepared Test Defect Metrics on a Weekly basis to know the status of the application.
• Developed test plans and test summary reports. Coordinate and perform the execution of test plans.
• Written several complex SQL queries for validating Cognos Reports.
• Experience in loading from various data sources like Teradata, Oracle …
• Developed & assist in test plan strategy for each project assigned.
• Provided technical and functional support in test environment.
• Status reporting on daily and Weekly basis to Manager-QA.

Environment: Informatica 8.6.1/8.1, Quality Center 11, SSIS,Teradata SQL Assistant, Teradata, UNIX, TOAD, IBM AIX 5.5. Visual Studio, QTP and MTM

Confidential, VA

Senior QA Analyst

Responsibilities:

• Involved in preparing Test Plans and Test cases based on the business requirements Document in the Quality Center.
• Extensively used Informatica client tools and BI testing. The objective is to extract data stored in Oracle database, flat files to load finally into a single data warehouse repository, which is in Oracle.
• Involved in Data Extraction from Teradata and Flat Files using sql assistant.
• Involved in writing the test cases based on Requirements, Executing the test cases, Defect Reporting.
• Performed execution of application software testing in coordination with teams the typically include managers, project managers, business analysts, system analysts and developers Opened Defects in Quality Center and tracked the status until defect is closed.
• Logged and Tracked the Defects in Quality Center.
• Involved in the development of RTM (Requirements Traceability Matrix) for completeness and correctness of the Testing process.
• Involved in testing the Cognos reports by writing complex SQL queries
• Involved in Regression Testing to test whether defects reported are resolved and verifying for the side effects of resolved defects.
• Experience in web services end-to end testing of web applications, IOS, android apps and voice-based applications.
• Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target database including SQL Server and used the data for Reporting purposes.
• Written SQL and PL/SQL scripts to validate the database systems and for backend database testing.
• Responsible for the analysis, reporting and communication of test results on all assigned projects and overall measurement of the test efforts.
• Actively participated in Review meetings along with development and test teams for discussion of Requirement changes and Rejected and deferred defects.
• Involved in backend testing for the front end of the application using SQL Queries in Teradata data base
• Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target database including SQL Server and used the data for Reporting purposes.
• Experience in X12 EDI Transactions 270,276,277,,832,835,855,856,820,834,837
• Involved in writing and analyzing SQL scripts for effective Data validation.
• Designed and documented all the Issues and defects to ensure application software functionality for Present and Future Builds.
• Worked with business team to test the reports developed in Cognos
• Involved in Documentation of Test Scenario’s, Test Cases, and Test Scripts for future enhancements.
• Performed the execution of the test cases to verify the expected results.

Environment: Informatica Power Center 7.2, Quality Center 9.2,DB2,SSIS, Teradata SQL Assistant, Teradata V2R6,Java, J2EE, XML, SQL, SOAPUI AGILE, Web Services, MS Office Suite, Toad, Cognos 7.1 Series, Visual Studio, QTP and MTM

Fannie Mae, Reston VA

Senior QA Analyst

Responsibilities:

• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Wrote SQL, Testing scripts for Backend Testing of the data warehouse application, validated data loads.
• Worked with leadership team to analyze current SDLC process and recommended process improvements.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• As a Lead, was involved in weekly status, following up the development as well as the business /testing teams, re-scoping project planning.
• Metadata graphs from legacy source system to target database fields and involved in creating Ab Initio DMLs
• Involved in Teradata SQL Development, Unit Testing and Performance Tuning
• Analyzed Business Requirements documents to get a better understanding of Business Perspectives and assist in implementing improvements in test methods and strategies. Analyzed and verified the flat, Mainframe IMS and xml data using Ab Initio Data Profiler.
• Different Ab Initio components especially are used effectively to develop and maintain the database
• Extraction, Transaction and Loading was done using different Components and different expressions using Ab Initio to create test data.
• Submitted Status and Test Evaluation Reports to Test Lead on daily basis and constantly updated test deliverables.
• Utilized Test Director/Quality Center for Tracking and Reporting Defects, which are assigned to developers. Designed and developed Test Plans, Test Scripts and Test Cases in HP Quality Center and executed them.
• Expertise in designing the Test Plans, Test scenarios and Test cases in order to test the application.
• Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries
• Involved in issues with Data migration from development to testing and project data migration.
• The reports that were created in Business Objects were testing by running the SQL statements against the tables in the Oracle Database
• Involved in creating the design and technical specifications for the ETL process of the project.
• Prepared extensive set of validation test cases to verify the data
• Written several UNIX Shell Scripts for cleanup, logging, file manipulation and transferring the files.
• Involved in Writing the Test Cases and Test Plans based on Source to Target Mapping Documents in Quality Center.
• Performed web services end-to end testing of web applications, IOS, android apps and voice-based applications.
• Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted
• Involved in Functional testing, End to End testing and Regression Testing
• Preparing and supporting the QA and UAT test environments

Environment: Ab Initio, Teradata V2R5, (GDE 1.14, Co>Op 2.14), J2EE 1.4, HP Quality Center 9.2, SSIS, SSRS, XML, SQL, SSIS,Oracle 9i/10g, IBM AIX 5.1, SOAPUI AGILE, Web Services, Business Objects XIR2/6.5, UNIX, Korn Shell Scripting, Microsoft Office suite, QTP and Test Director 8, ALM

Confidential, MN

QA Analyst

Responsibilities:

• 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.
• Developed and Tested UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Written several complex SQL statements for various business scenarios.
• Loaded data from operational data store (ODS) to data warehouse tables by writing and executing foreign key validation programs to validate where exactly star schema appears, with fact tables and dimensions/lookup tables.
• Writing Triggers enforcing Integrity constraints, Stored Procedures for Complex mappings, and cursors for data extraction.
• Worked extensively with mappings using expressions, aggregators, filters, lookup and procedures to develop and feed Data Mart.
• Did data parsing, text processing and connecting to the database using PERL.
• Developed UNIX Shell scripts to automate repetitive database processes
• Tested several ETL routines and procedures.
• Identify the primary key (logical / physical ) and put update or insert logic
• Deleting the target data before processing based on logical or physical primary key
• Design and execute the test cases on the application as per company standards

Environment: Oracle 7.0, SQL*Plus, SQL, Test Director, SQL Server 2000, Visual Basic 6.0, Windows 95, XML, XSLT, XSD, UNIX, Korn shell scripting, PERL, MVS, JCL, ISPF, VSAM Files, OS/390, QTP, ALM

Confidential, OK

QA Analyst

Responsibilities:

• Writing test cases and test scripts according to business requirements.
• Suggested change requests and updated the test cases for approved CRs.
• Conducted the Functional, System, Integration, Regression, and performance testing.
• Tagging the Testable and Non Testable requirements.
• Developed Requirement Traceability Matrix.
• Experienced in writing complex SQL queries for extracting data from multiple tables.
• Written complex SQL queries to test the backend database.
• Closely worked with Subject Matter Experts.
• Extensively involved with performance testing.
• Created test processes, test cases and methods for performing tests using technical document.
• Involved in manual testing of the Java applications.
• Created defects using Test Director and reported them to developer.
• Interacted with developers for the Bug Fixes and Problem resolution.
• Conducted Data Driven Testing using different sets of external data
• Developed and Tested the Web application.
• Reported periodic project status and updates to the QA Lead and QA Manager

Environment: Oracle 7i, SQL, MS Office, Java, Test Director, Windows XP.