SUMMARY

• Twelve years of work experience in IT with Quality Assurance, in the roles of Sr QA Analyst supporting the areas of Client - Server Technology, Web applications, and Data warehousing/ Business Intelligence, in diverse business & technical environments, with demonstrated leadership abilities and excellent communication skills.
• Expertise in managing Onsite and Offshore teams.
• Expertise testing on Banking, Telecommunications, Helpdesk, Mortgage, P&C Insurance, Public Sector, Financials, Enterprise Infrastructure, Conversion, and Healthcare applications.
• Expertise in designing and developing test strategy, test plan, test cases and generating test reports, preparing documentation, standardizing procedures.
• Experience in defining standard metrics and implementing policies and procedures for Quality Assurance.
• Experience in implementing SDLC methodologies including Waterfall Model, Agile methodology and Rational Unified Process (RUP).
• Experience testing applications built on SOA architecture.
• Participate in requirements review, design review and code reviews to identify common errors.
• Expertise in estimating and deriving schedules for test execution.
• Expertise in designing test cases using Boundary value analysis, Equivalence partitioning and Error guessing techniques, Smoke, Functional, Regression, Database and Integration testing for Client-Server and Web applications.
• Experience with GAP Analysis to analysis enterprise data.
• Experience with automation testing.
• Experienced in replicating field issues reported by end users, investigate the problem and identify corrective measures.
• Expertise in Problem solving and Bug Reports using Defect Tracking Tools like Test Director, mercury Quality Center, Bugzilla, Issue tracker and Rational Clear Quest.
• Expertise in writing complex SQL queries to verify the database.
• Experience in working with Multiple Relational Databases like Oracle 9i/8i/7.x, SQL Server 2000, MS Access, XML and Flat Files.
• Experience in writing test cases to comply to CMMI and ISO standards
• Enthusiastic self-starter with great work attitude, Excellent communication, Presentation Skills, Coordination skills and Leadership Qualities.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 8.5/7.1.2/7.1.3 , Data stage

Reporting Tools: Business Objects, Micro Strategy

RDBMS: MS SQL Server, Oracle, DB2, TOAD

Languages: C, C++, SQL, PL/SQL, JAVA, VB, VB.Net, PERL

Scripting Languages: HTML, DHTML

Operating Systems: Windows NT, 2000, XP, DOS, UNIX

Test Methodologies: Manual Testing

Bug Reporting Tools: Test Director 8.0, Mercury Quality Center

ARS Applications: Remedy, ITIL, Change Management, Problem and Incident Management.

Others: Win Runner, QTP 9.0, Tivoli, Thompson One Reuters, JAWS, ZoomText, Supernova, SharePoint

PROFESSIONAL EXPERIENCE

Confidential

Senior QA

Responsibilities:

• As a QA test lead, responsible for preparing detailed test plan, test scripts and test cases by understanding the business logic and user requirements.
• Experience in leading large, cross-enterprise testing initiatives including Capital Markets industry.
• Working closely with Quality Assurance Senior Management and Operations Counterparts to manage the Data Automation and Data Testing effort.
• Expertise with leading QA teams and coordinating Functional testing, System testing, Integration testing, Smoke testing, Regression testing, Performance testing and UAT testing.
• Experience working with data sources across distributed and mainframe platforms.
• Experience with Test Data Analysis and subject-matter expert in building out test data required for system, functional, performance and regression testing.
• Strong experience creating concise and clear reports for distribution to senior management on a weekly basis.
• Experience monitoring and tracking implementation plans to ensure desired outcomes.
• Experience leading accessibility project for visual & hearing disabled users as part of conversion efforts.
• Expertise testing the application on data driven testing to test the application functionality on UI.
• Expertise working with the SME and development team to understand the Business logic and create test scenarios for validation.
• Expertise working with data management team and SAD team for managing the test data creation from various sources in Mainframe environment and escalating any issues to the Management and PMO team.
• Expertise working with Off-shore team on Onsite-offshore model and assigning testing responsibilities an follow up till test completion and reporting the status to Project Manager.
• Expertise working with Senior Management team and reporting the testing status on a weekly basis to identify any issues and follow up with further escalations with the corresponding teams.
• Working with the development team to create a suite of test data (both input files and expected results) that fully exercises data validation (detecting and rejecting bad data.
• Expertise working with UAT team in testing the Change Requests and defects identified in Production.
• Improving specification and design documents through active review and feedback with developers.
• Expertise working with Requirements Matrix Traceability in Quality Center.
• Identifying and logging defects if a test fails.
• Experience working with the Product documentation based on the CMMI 3 standards.
• Responsible for updating the weekly status meeting and meeting minutes for team.

Environment: Windows 7, Thompson One Reuters, JAWS, ZoomText, Supernova, Net, Visual Source, SQL, Main Frames, Tivoli, Manual testing, QTP, Quality Center, Citrix, Sharepoint.

Confidential, NJ

Senior QA

Responsibilities:

• Preparing detailed test plan, test scripts and test cases by understanding the business logic and user requirements.
• Expertise with Functional testing, System testing, Integration testing, Smoke testing, Regression testing, Performance testing and UAT testing.
• Expertise testing the application on data driven testing to test the application functionality on UI.
• Expertise working with the SME and development team to understand the Business logic and create test scenarios for validation.
• Expertise working with data management team and SAD team for managing the test data creation from various sources in Mainframe environment and escalating any issues to the Management and PMO team.
• Expertise working with Off-shore team on Onsite-offshore model and assigning testing responsibilities an follow up till test completion and reporting the status to Project Manager.
• Expertise working with Senior Management team and reporting the testing status on a weekly basis to identify any issues and follow up with further escalations with the corresponding teams.
• Working with the development team to create a suite of test data (both input files and expected results) that fully exercises data validation (detecting and rejecting bad data.
• Expertise working with UAT team in testing the Change Requests and defects identified in Production.
• Improving specification and design documents through active review and feedback with developers.
• Expertise with Mainframe screens to validate Brokerage accounts like CMA, Retirement accounts, Business accounts, Delaware accounts.
• Expertise testing the mobile banking between Brokerage and bank accounts and out of bank- 3rd party accounts.
• Expertise with security testing of mobile banking to ensure the daily and weekly limits based on roles.
• Expertise working with Requirements Matrix Traceability in Quality Center.
• Expertise with XML web services to test the functions and validate the output against the UI and bank accounts against the database.
• Expertise with testing various services to validate data for Smoke testing, QA testing an UAT testing.
• Identifying and logging defects if a test fails, if necessary, using SQL to narrow down the root cause of the problem for efficient investigation by the development team and log accordingly.
• Expertise working with Database tools generating SQL queries for checking the Data.
• Identifying and logging defects if a test fails.
• Experience testing various modules to validate the functional flow of the business logic on Open systems and Main frames.
• Experience working with the Product documentation based on the CMMI 3 standards.
• Responsible for updating the weekly status meeting and meeting minutes for team.

Environment: Informatica Power Center 8.5/7.1.3/BI, Cognos, .Net, Visual Source, MicroStrategy SQL, Main Frames, TOAD, Manual testing, Support Magic, ATS, Mainframes, Citrix Metaframe, Enterprise Architect 1.1.

Confidential, PA

Senior QA

Responsibilities:

• Preparing detailed test plan, test scripts and test cases by understanding the business logic and user requirements.
• Expertise with Functional testing, System testing, Integration testing, Smoke testing and UAT testing.
• Working with the SME and development team to understand the Business logic and create test scenarios for validation.
• Analyzing the ETL process created in Informatica, developed SQL queries and tables which replicated the ETL, and compared the SQL results with the Informatica tables and suggest any corrective action.
• Using workflow manager to edit, validate and run workflows, worklets and tasks.
• Using workflow monitor to monitor the status of workflows and sessions.
• Expertise with working with the Change Management Board (CMB) for any issues created and follow up on a daily status basis.
• Experience with automation tools for regression testing the application.
• Experience with automation framework, parameterization, checkpoints for automation testing.
• Experience with relating associated incidents and services to the Changes for Change Management.
• Experience working re-testing an resolving issues base on Service Level Agreements and managing appropriate triages.
• Working with the development team to create a suite of test data (both input files and expected results) that fully exercises data validation (detecting and rejecting bad data) and actual ETL functionality (properly processing good data i.e., transformations, calculations, and derivations).
• Improving specification and design documents through active review and feedback with developers.
• Identifying and logging defects if a test fails, if necessary, using SQL to narrow down the root cause of the problem for efficient investigation by the development team and log accordingly.
• Using TOAD for generating SQL queries for checking the Data Transactions and Database Integrity.
• Identifying and logging defects if a test fails.
• Experience testing various modules to validate the functional flow of the business logic on Open systems and Main frames.
• Experience testing the ETL workflow.
• Experience testing web based application- CSWS for intake cases, establishment, and financial modules for functional, system, integration and database testing.
• Experience working with the Product documentation based on the CMMI 3 standards.
• Responsible for updating the weekly status meeting and meeting minutes for team.

Environment: Informatica Power Center 8.5/7.1.3/BI, Cognos, .Net, Winrunner, Microstrategy, QTP 9.0, Change Management, Incident Management, Visual Source, Oracle 9i, SQL, Main Frames, TOAD, Manual testing, Support Magic, ATS, Citrix Metaframe, Enterprise Architect 1.1.

Confidential, VA

Senior QA

Responsibilities:

• Responsible for managing a team, planning activities, creating test plan, requirements Traceability Matrix and standard templates (Daily status, defect status, defect process etc.)
• Preparing detailed test plan and test cases by understanding the business logic and user requirements.
• Responsible for creation of project plan, defining QA tasks to be done and estimating times for those tasks.
• Working with the development team to create a suite of test data (both input files and expected results) that fully exercises data validation.
• Responsible for the validation of any additions/modifications to the Micro Strategy reports before release to production.
• Improving specification and design documents through active review and feedback with developers.
• Having exposure to integration of data across more than 15 sources in an ETL process, versioning, manual correction of tables, address correction.
• Experience testing XML web services built on SOA architecture.
• Identifying and logging defects if a test fails, if necessary, using SQL to narrow down the root cause of the problem for efficient investigation by the development team and log accordingly.
• Using TOAD for generating SQL queries for checking the Data Transactions and Database Integrity.
• Improving specification and design documents through active review and feedback with developers.
• Identifying and logging defects if a test fails, if necessary, using SQL to narrow down the root cause of the problem for efficient investigation by the development team and log accordingly.

Environment: Remedy 7.0, ITIL, Service Management, Change Management, Incident and Problem management, Oracle 9i, SQL, SOA, TOAD, XML, Crystal reports, Mercury Quality Center, Share Point, CMMI3.

Confidential, CO

QA Lead

Responsibilities:

• Responsible for managing a team, planning activities, creating test plan, requirements Traceability Matrix and standard templates (Daily status, defect status, defect process etc.)
• Preparing detailed test plan and test cases by understanding the business logic and user requirements.
• Responsible for creation of project plan, defining QA tasks to be done and estimating times for those tasks.
• Experience in Windows mobile applications testing.
• Experience testing customized mobile application for commercial users to verify the order entry and services management.
• Experience testing the out of box and customized applications on Remedy tool and testing the workflows.
• Experience testing configuring the mobile devices with desktop applications via exe files.
• Extensive use of UNIX commands to move source files (XML and txt) and trigger files to ETL QA server.
• Using workflow manager to edit, validate and run workflows, worklets and tasks.
• Using workflow monitor to monitor the status of workflows and sessions.
• Performing test data set-up in XML for testing and update test data based on the requirements.
• Validating the data in staging (umf) and permanent (EDW and datamart) tables using Aqua data studio.
• Querying data from different database tables as per the requirement and executing the source queries from workflows.
• Working with the development team to create a suite of test data (both input files and expected results) that fully exercises data validation.
• Participate in bug reviews to ensure that quality criteria are met.
• Improving specification and design documents through active review and feedback with developers.
• Identifying and logging defects if a test fails, if necessary, using SQL to narrow down the root cause of the problem for efficient investigation by the development team and log accordingly.
• Using TOAD for generating SQL queries for checking the Data Transactions and Database Integrity.

Environment: Informatica Power Center 8.5/7.1.3/BI, Oracle 9i, Experitest, Remedy, SQL, SOA, TIBCO, Oracle 9i, SQL, TOAD, PERL, Mercury Quality Center, Team Track, Share Point.

Confidential, OK

Senior QA

Responsibilities:

• Responsible for managing a team, planning activities, creating test plan and standard templates (Daily status, defect status, defect process etc.)
• Responsible for assigning tasks and managing the onsite and offshore teams
• Creating test case and test sets, tracing them to requirements and executing them in Mercury Quality center. Analyzing the ETL process created in Informatica and developed SQL queries and to validate the data from the source to the target tables.
• Experience testing customized trouble ticketing application on Remedy tool.
• Experience testing the Remedy reports, workflow and macros.
• Working with the development team to create a suite of test data that fully exercises data validation and actual ETL functionality. Using workflow manager to edit, validate and run workflows, worklets and tasks.
• Using workflow monitor to monitor the status of workflows and sessions.
• Querying data from different database tables as per the requirement and executing the source queries from workflows. Involved in data migration from Data stage to Informatica.
• Experienced in testing the ETL process using data stage tool
• Experienced in validating and running the jobs in Data stage Director and verify the log file for errors or warnings. Using TOAD for generating SQL queries for checking the Data Transactions and Database Integrity
• Expertise testing the IVR (Interactive Voice Response) application for automatic generation of tickets.
• Reporting defects in Mercury Quality center and generating reports for the daily status meetings
• Preparing status reports and defect reports for daily status meetings and sending them to all the stakeholders of the project
• Preparing test results and QMO promotion recommendation documents.

Environment: Informatica Power Center 8.5/7.1.3/BI, Oracle 9i, Change Management, SQL, Remedy, Crystal Reports, IVR, DB2, Sybase 11.0, SQL, SOX, Mercury Quality Center, TOAD, Windows NT & Unix.

Confidential, CA

Sr. QA Analyst

Responsibilities:

• Responsible for managing a team, planning activities, creating test plan and test execution
• Creating test case and test sets, tracing them to requirements and executing them in Mercury Quality center.
• Preparing status reports and defect reports for daily status meetings and sending them to all the stakeholders of the project
• Analyzing the ETL process created in Informatica and developed SQL queries and to validate the data from the source to the target tables.
• Working with the development team to create a suite of test data that fully exercises data validation and actual ETL functionality. Using workflow manager to edit, validate and run workflows, worklets and tasks.
• Using workflow monitor to monitor the status of workflows and sessions.
• Querying data from different database tables as per the requirement and executing the source queries from workflows. Involved in data migration from Data stage to Informatica.
• Experienced in testing the ETL process using data stage tool
• Experienced in validating and running the jobs in Data stage Director and verify the log file for errors or warnings. Using TOAD for generating SQL queries for checking the Data Transactions and Database Integrity
• Responsible for the validation of any additions/modifications to the Micro Strategy reports before release to production
• Work closely with the offshore developers and test engineers in the review & modification of product specifications.

Environment: Informatica Power Center8.6, Data stage, Oracle 9i, DB2, SQL, Mercury Quality Center, TOAD, Windows NT & Unix, Micro strategy

Confidential, VA

Sr. QA Analyst

Responsibilities:

• Responsible for managing a team, planning activities, creating test plan and standard templates (Daily status, defect status, defect process etc.)
• Creating test case and test sets, tracing them to requirements and executing them in Mercury Quality center.
• Preparing status reports and defect reports for daily status meetings and sending them to all the stakeholders of the project
• Analyzing the ETL process created in Informatica and developed SQL queries and to validate the data from the source to the target tables.
• Working with the development team to create a suite of test data (both input files and expected results) that fully exercises data validation and actual ETL functionality
• Using workflow manager to edit, validate and run workflows, worklets and tasks.
• Using workflow monitor to monitor the status of workflows and sessions.
• Querying data from different database tables as per the requirement and executing the source queries from workflows.
• Executed PERL scripts to perform any changes in the source files.
• Using TOAD for generating SQL queries for checking the Data Transactions and Database Integrity
• Responsible for the validation of any additions/modifications to the Micro Strategy reports before release to production
• Work closely with the offshore developers and test engineers in the review & modification of product specifications.

Environment: Informatica Power Center, Oracle 9i, DB2, SQL, Mercury Quality Center, PERL, TOAD, Windows NT & Unix, Micro strategy

Confidential, VA

QA Analyst

Responsibilities:

• Responsible for managing a team of 6 and executing planning activities, creating test plan and standard templates (Daily status, defect status, defect process etc.)
• Participated in checkpoint reviews and walkthroughs during the verification and validation process.
• Responsible for project planning, coordination and implementation of QA methodology.
• Participated in writing HLS (High Level Scenarios), Test plans, Test scenarios and Test cases, software documentation from business and functional requirement.
• Extensively used SQL queries to perform back end testing to check the Data Integrity.
• Performed Test Data set up - a pre-requisite to executing use cases during system testing.
• Load and Unload flat files from Unix Box.
• Executed PERL scripts to perform changes in MABEL files.
• Followed the testing progress during status meetings and prepared contingency plans when required.
• Generated Reports using internal tools to report the daily status and Test Summary.
• Reported defects in Clear quest and followed up on the resolution with the developers.

Environment: Sybase, UNIX, SQL Server, PERL, Shell Scripts, Java, Windows XP, Test Director, Toad and Manual Testing

Confidential, GA

QA Analyst

Responsibilities:

• Responsible for managing a team of 6 and executing planning activities, creating test plan and standard templates (Daily status, defect status, defect process etc.)
• Participated in writing HLS (High Level Scenarios), Test plans, Test scenarios and Test cases, software documentation from business and functional requirement.
• Tested the web application for multiple logins and verify unauthorized accesses
• Performed stress and load test for the web application to verify the performance of the application
• Conducted data integrity testing by extensive use of SQL Queries to perform back-end testing.
• Performed Import / Export / SQL* Load in oracle database
• Participated scheduled meetings and maintained good relationship with developers.
• Attended daily status meetings to discuss the testing progress
• Validated mocked up data to ensure that they follow the specifications
• Load and Unload flat files from Unix Box
• Executed PERL scripts to perform changes in MABEL files.
• Reported and tracked function defects using Clear Quest, Issue Tracker
• Testing to ensure that BID sends the feed files correctly and BSTAR receives them in expected format.
• Tested the application to verify Internationalization
• Testing the format and content of feeds from BID to BSTAR - BID Service Feed, BID Features Feed, BID Fan to Account Changes Feed and BID EOD Feed and loading them in BSTAR Database.
• MMT System Testing and Regression Testing

Environment: E-commerce, Oracle 8i, SQL, Unix, Windows XP, Java, Test Director7.6, Toad and Manual Testing

Confidential

QA Analyst

Responsibilities:

• Performed testing on all the stages of the Applications’ life cycle.
• Involved in developing the Test strategy, Test plan, Test Scripts and Test execution requirements for the project.
• Performed functional and performance testing.
• Used Mercury Interactive tools for test scripting, execution unless a specific case requires manual testing.
• Developed and executed automated test case scripts using WinRunner for the Front-end-applications.
• Security and data integrity testing on both front end and back end of the applications.
• Performed extensive Data Integrity testing by executing SQL statements.
• Reported defects in Test Director.

Environment: J-Builder, Html, JavaScript, Jdbc, Oracle, Win Runner6.0, Test Director.