SUMMARY

• 8+ years of Professional Experience in Software Quality Assurance and Testing in different environments and platforms including Client - Server and Legacy Mainframe applications.
• Excellent understanding of Software Development Life Cycle and Software Quality Assurance (SQA).
• Ensuring smooth onsite to offshore transition of requirements and conducting knowledge transition sessions
• Excellent working knowledge of designing & implementation of all QA test strategy plans manually and automated test solutions for client/server and Web applications with HP test suite (Quick Test Pro (QTP), Quality Center) and Manual Testing.
• Very strong background on Quality Assurance and Testing. Hands-on experience in preparing project plans for testing.
• Worked as an Administrator for HP Quality Center 10, creating new projects, adding new users or deactivating users and troubleshooting user issues.
• Worked as an Administrator for Rational ClearQuest (7x and 8x), adding and deactivating users, creating Projects, querying database for any reports, and troubleshooting any issues.
• Experience as Production Support and helped resolving issues, taking calls, following up with team and/or vendors until the issues are resolved and escalating the issue as needed.
• Experience with Agile Methodology
• Facilitated Functional testing, System testing and UAT. Extensive experience in writing Test Plan, Traceability Matrix and Test Strategies.
• Written complex SQL queries against every database including Oracle, DB2, Sybase, Teradata and SQL Server
• Profound experience in testing web applications using Quality Center and Quick Test Pro (QTP).
• Expertise in Integration Testing, Functional Testing, Regression Testing, Performance Testing. Experience in manual testing and in using Automated-testing tools such as Win Runner, for GUI, Load and Regression testing.
• Involved in various conversion and migration projects as System Analyst, pivotal in understanding present state and future state systems and business processes. Developed and recommended changes for conversion plans.
• Experienced in working in Agile Scrum, Agile XP, Waterfall, RUP, RAD and SDLC methodology environments
• Proficient in Oracle 11i/10g/9i/8i/7.3, PL/SQL Development Toad, PL/SQL Developer, SQL Navigator, UNIX.
• Strong ability to interface with business users, understand their reporting and data needs create complex Ad hoc queries, views and custom reports. Also developed a significant number of models and templates for data analysis and data reconciliation.
• Good experience in Client/ Server applications
• Managed Clear Case for version control and configuration control

TECHNICAL SKILLS

Test Management: MS Project Test Scheduling, Test Director, Quality Center, Rational Quality Manager, Traceability Matrix for Requirements and Defects

Testing Methodologies: Object Oriented, Keyword Driven and Data Driven testing, Top to Bottom and Bottom to Top test methodology, Requirement based, Risk based, Priority based test methodology

Mercury Interactive: QuickTestPro9.5/9.2/8.0, Business Process Testing, WinRunner 9.2/9.0/8.0/7.5 , LoadRunner9.2/9.0/8.0, TestDirector9.0/8.0/7.5, Quality Center9.0/8.2

ETL Tools: DataStage 8.1, Informatica 7.1/8.1/8.6.1 , SSIS, Ab Initio (Co>Op 2.15, GDE 1.15)

BI Tools: Micro Strategy, Business Objects XIR3, Cognos Series 8.0

Bug Reporting: Rational Clear Quest, HP Quality Center, Test Director, MS Access, Bugzilla, Siebel Service Request

Scripting languages: TSL, SQA basic, Java script, VB Script, HTML, XML, Shell Scripting, PERL

Operating Systems: Windows XP/NT/2000, DOS, Mac 10.4, AIX UNIX, LINUX

Databases: Oracle 10g/9i/8i/7.3, MS SQL Server 6.5/7.0/7.5/2005/2008 , Sybase 12.5/12.0/11.0 , MS Access, Teradata 12.0

PROFESSIONAL EXPERIENCE

Confidential, Minnetonka MN

UAT Lead/ Technical Test Lead

Responsibilities:

• Involved in Business meetings to review and analyze Business requirements.
• To analyze and review Claim files in various formats from Providers and report back for any issues.
• Review files from Providers and analyze as they are processed through the database and Ensemble.
• Develop Master Test Plan and update the document as required through out the Program
• Leading a team of three resources and oversee the daily QA activities
• Review and finalize the Test Strategy, Test Scenarios and Test Cases
• Write and execute test cases for each requirement and provide the metrics
• Write SQL scripts analyzing and/or comparing data in the database as backend validation
• Prepare Requirement Traceability Matrix for all the test cases and test scenarios.
• Act as a point of contact between the testing team and other resources including higher management
• Act as the technical contact for testing team and consult respective resources to resolve any outstanding issues or questions
• Arrange and/or attend the meetings with higher management to provide tasks/project updates
• Prepare report on the progress of testing
• Escalate any critical issues and follow up for quick resolution
• Planning, deploying, and managing the testing effort for any given engagement / release.
• Attending meetings with the peers and provide estimates for any new release or tasks
• Promote documented quality standards throughout the organization. Includes abiding by and being a lead advocate for standards and processes, mentoring team members, communicating and documenting quality related issues, and recommending improvements.
• Manage the quality process as part of the complete solution delivery life cycle of the project ensuring the delivery of projects meeting business quality requirements and expectations.
• Monitor and oversee the daily QA activities and provide inputs on any outstanding issues/road-blockers
• Analyze the final data, as needed, and check for any inconsistency in quality and take actions or suggestions as needed
• Walk through Business and technical teams, the test results and clarify any questions from different resources and send a follow up communication with all the details.
• Function and interact across teams to execute multiple tasks/assignments simultaneously with input from several resources.
• Complete tasks/assignments in a timely and effective manner.

Environment: SQL Server, Teradata, SQL Developer, Ensemble, Informatica, BO, HPQC.

Confidential, Chicago IL

ETL QA Tester/Lead

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Participated in fact and dimension table implementation in Star Schema model based on requirements.
• Participated in grooming sessions and Project kick-off meetings.
• Prepared and/or reviewed Test Plan from the Business Requirements and Functional Specification.
• Developed and/or reviewed Test Cases for Deployment Verification, ETL Data Validation, Cube Testing and Report testing.
• Experienced in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using HP Quality Center 10.
• Tested incremental iterative application releases using an Agile process (Scrum)
• Different Datastage components especially are used effectively to develop and maintain the database
• Verified the Target table inserts and updates that occurs based on different conditions mention in the mapping specification document
• Verified the data loads to critical and non-critical columns based on the ETL updates or inserts
• Created test plans and number of test cases and test scripts and executed the test scripts.
• Extensively tested various transformations such as Source Qualifier, Expression, Lookup, Sequence Generator, aggregator, Update Strategy, and Joiner for data coming from various heterogeneous sources like Oracle, DB2, XML and Flat files to Oracle.
• Extraction, Transaction and Loading was done using different Components and different expressions using Datastage to create test data.
• Write SQL statements that use joins or sub queries to combine data from multiple tables.
• Involved in extensive DATA validation using SQL queries and backend testing
• Tested for Type 2 slowly changing dimensions in the warehouse. Performed all aspects of verification, validation including functional, structural, regression, load and system testing.
• Raised numerous defects in the testing process. Identified bottlenecks through performance testing and suggested SQL performance tuning techniques to development and extensively worked with DBA's to resolve performance and tuning issues.
• Extensively performed System testing, Integration Testing and Regression Testing.
• Extensively used Datastage for extraction, transformation and loading process.
• Tested and scheduled Datastage jobs using Tivoli.
• Worked as Production Support, taking call from various Plans and helping resolving the issues.
• Prepared various excel reports on a daily, weekly and monthly basis and shared with the Business.
• Verified various Cognos Reports.
• Worked as HP Quality Center (10) Admin
• Worked as ClearQuest (7x and 8x) Admin. Created user profiles and upgraded the version from 7x to 8x.
• Extensively created test data to cover various scenarios and performed positive and negative testing on for validation purposes.
• Conducted weekly status meetings with the team and updated the status of the team to the higher management.

Environment: Oracle, SQL Server, DB2, Informatica, Datastage, BO, Tivoli, HPQC 10, ClearQuest 7x and 8x, ClearCase

Confidential, Bethpage NY

Sr. ETL QA Tester - Business Intelligence

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Participated iact and dimension table implementation in Star Schema model based on requirements.
• Prepared Test Plan from the Business Requirements and Functional Specification.
• Developed Test Cases for Deployment Verification, ETL Data Validation, Cube Testing and Report testing.
• Experienced in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using HP Quality Center 10
• Tested incremental iterative application releases using an Agile process (Scrum)
• Different Informatica components especially are used effectively to develop and maintain the database
• Verified the Target table inserts and updates that occurs based on different conditions mention in the mapping specification document
• Verified the data loads to critical and non-critical columns based on the ETL updates or inserts
• Created test plans and number of test cases and test scripts and executed the test scripts.
• Extensively tested various transformations such as Source Qualifier, Expression, Lookup, Sequence Generator, aggregator, Update Strategy, and Joiner for data coming from various heterogeneous sources like Oracle, DB2, XML and Flat files to Oracle.
• Used TOAD Software for Querying ORACLE. And Used Teradata SQL Assistant for Querying Teradata and conducted data integrated testing by extensive use of SQL
• Extraction, Transaction and Loading was done using different Components and different expressions using Informatica to create test data.
• Write SQL statements that use joins or sub queries to combine data from multiple tables.
• Executed SSIS Packages and verified the results.
• Involved in extensive DATA validation using SQL queries and backend testing
• Wrote PL/SQL /Complex SQL queries for system testing.
• Tested for Type 2 slowly changing dimensions in the warehouse. Performed all aspects of verification, validation including functional, structural, regression, load and system testing.
• Raised numerous defects in the testing process. Identified bottlenecks through performance testing and suggested SQL performance tuning techniques to development and extensively worked with DBA's to resolve performance and tuning issues.
• Extensively performed System testing, Integration Testing and Regression Testing.
• Extensively used Informatica for extraction, transformation and loading process.
• Tested Automated and scheduled Informatica jobs using UNIX Shell Scripting.
• Used SQL plus as a query analyzer to run queries against the warehouse to get a better understanding of the SQL produced by MicroStrategy, which greatly enabled in better data quality
• Worked with ETL group for understating SSIS.
• Enhanced QTP scripts by putting database checkpoints.
• Tested several complex reports generated by Microstrategy including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards
• Extensively created test data to cover various scenarios and performed positive and negative testing on for validation purposes.
• Attended weekly status meetings with the manager and lead and updated the status of the team to the higher management.

Environment: Informatica Power Center 8.6, MicroStrategy, SQL, PL/SQL, SQL Server 2008, SSIS, Oracle10g, DB2, Teradata 12.0, Flat files, SQL plus, MS Access, TOAD, XML, HP Quality center v10, QTP 9.5, UNIX, Shell Scripting

Confidential, East Hanover, NJ

ETL QA Tester

Responsibilities:

• Involved in the team design and Review Meetings. Acted as one of the key member in designing the application.
• Checked error log table and Documented the error messages, session load time and concatenated primary keys
• Tested graphs for extracting, cleansing, transforming, integrating, and loading data using Ab Initio ETL Tool.
• Developed complex SQL queries using different data providers in the same report.
• Tested the data and data integrity among various sources and targets.
• Created test case scenarios, executed test cases and maintained defects in Remedy
• Used Quality Center to track and report system defects.
• Developed and executed various manual testing scenarios and exceptionally documented the process to perform functional testing of the application
• Coordinated system walk through, training, User Acceptance Testing (UAT) and facilitate issue resolution
• Followed RUP and AGILE development methodology and adhered to strict quality standards in requirement gathering.
• Executed the Test Cases Manually and reported the defects using Quality Center and Quality Center.
• Prepared Test Scripts and test Plan for automated testing using QTP
• Developed complex UNIX Shell scripts for various data movement needs including data archiving, cleaning up process and job scheduling.
• Creating complex and simple reports depending on the environment.
• Developed various stored procedures and triggers to implement business logic.
• Developed packages and collections using PL/SQL.
• Extensive mainframe testing with DB2/SQL skills
• Execution of Manual Test scripts and responsible to track and log the defects using Quality Center.
• Involved in automated Regression Testing using Quick Test Professional (QTP).
• Handle change requests and version controlling in Quality Center
• Written stored procedures and triggers to retrieve the data from database for fast access purposes.
• Analyzed Business and System Requirements to build test cases
• Performed Integration and System testing, Performance Testing, Installation Testing, User Acceptance Testing, User Interface Testing, Load Testing.
• Tested several data validation graphs developed in Ab Initio environment
• Run Regression testing after bug fixes and system enhancements.
• Generate reports based upon the defects and severity of the application.
• Designed Load process for Initial loads involving very large amount of data.

Environment: Ab Initio CO>OP 2.14, GDE 1.14,Windows 2000, Win Runner, XML, Microsoft Excel, MS Office, QTP, SQL, Quality Center, Agile, UNIX, Shell Scripting, SQL, PL/SQL, MS SQL Server, Stored Procedures.

Confidential, San Antonio, TX

ETL Test Analyst

Responsibilities:

• Analyzed and evaluated the existing as-Is system, Business Process Improvements (BPI) incorporated and enhanced future (To-Be) system and developed the test requirements
• Written Test Cases for ETL to compare Source and Target database systems.
• Created ETL test data for all ETL mapping rules to test the functionality of the SSIS Packages.
• Used Quality Center to create manual (IEEE format) and automated tests, build test cycles, run tests and report and track defects.
• Generated reports and graphs to review the progress of test planning, tests run and defects tracked.
• Tested several DataStage ETL jobs and ran on UNIX for loading purpose and checking the log files
• Tested both the Web Service Architecture and Service Oriented Architecture
• Supervising the QA team in accomplishing their tasks as per the deadlines.
• Responsible for testing packages using SSIS (ETL) to verify data completeness, data transformation, data quality, integration testing, UAT & regression testing.
• Written XSLT scripts for various XML needs and used XPath, XQuery for data retrieval from XML documents.
• Ensured data integrity and verified all data modifications and calculations during database migration using ETL tools. Developed test cases to accomplish ETL data migration
• Extensively used DataStage tool to extract, transform and load the data from Oracle to DB2.Compared the actual result with expected results.
• Validated the data by reverse engineering methodology i.e. backward navigation from target to source.
• Worked with Username Token, Binary Tokens, XML Tokens and Timestamp
• Ensured that the mappings are correct
• Writing complex SQL queries for data validation for verifying the SSIS transformation and business Rules.
• Analyzed SQL code to ensure Business Objects queries the correct data from the database
• Testing the source and target databases for conformance to specifications
• Conditional testing of constraints based on the business rules
• Identify and request test resources like QA engineers, Software (SW) and Hardware (HW)
• Performed functional testing using QTP for end to end application testing.
• Create and execute load test plans and scripts using Load Runner
• Debugging the SQL-Statements and stored procedures
• Developed regression test scripts for the application
• Tested several business reports developed in Business Objects and Written test cases for same.
• Tested the Oracle PL/SQL testing programs
• Conducted review sessions on test case and regression test scripts in quality center

Environment: Oracle 9i, SQL Server 2005, ETL SSIS/DTS, SQL, PL/SQL, DataStage 7.5, Flat Files, Windows XP, QTP 9.0, XML Files, XSD, XQuery, XML Spy 2008, TOAD, Quality Center 9.0, Business Objects XIR2, PERL, UNIX, Shell Scripting

Confidential

Test Engineer

Responsibilities:

• Involved in Design and development of test plans based on high-level and detailed designs.
• Analyzed the use cases given by the business analysts and developed test cases using them.
• Worked with the team lead to coordinate the test case turnover process proceeding each cycle and selectively executed the test cases to verify that they are kept current.
• Performed black box/functional testing, regression testing on Application Under Test
• Performed manual testing on various modules of the Application.
• Generates functional test cases that capture actual code behavior as a deployed application is exercised
• Written complex SQL queries to validate the front-end screens.
• Front-end testing includes Functionality, navigation, Alignments, links validation Session management, cookies, Authentication, company specific colors, privacy policy using different web browsers for eight different web sites.
• Executes the test suite to identify regressions and unexpected side effects
• Parameterizes test cases for use with varied, controlled test input values (runtime-generated, user-defined, or from data sources)
• Monitors test coverage and achieves high coverage using branch coverage analysis
• Tests individual methods, classes, or large, complex applications
• Tracks how test results and code quality change over time
• Conducted performance and load testing using Load Runner
• Analyzed, reported and kept track of defects using Test Director.
• Provided testing results and weekly status report to the QA lead, provided test summary report once project was fully completed.

Environment: Windows NT, MS-Office Tools, Manual Testing, Test Director 7.5, Oracle 8i, Java, Servlets and Java Script