SUMMARY

• Over 9+ years of experience in Software Development Life Cycle process, with emphasis on Quality Assurance Testing in various enterprise - wide application environments;
• Expertise in manual testing - black box and white box testing;
• Proficient in writing Test Cases for both Manual and Automated Testing;
• Extensive experience in functional testing, user acceptance testing, GUI testing, back-end testing, browser compatibility testing, and load/performance, regression and integration testing;
• Hands-on experience in testing of client-server and web-based applications (intranet and extranet) in .NET, SQL Server, Oracle, DB2 and J2EE environments;
• Proficient in SQL, T-SQL and PL/SQL; executed and updated SQL queries and SQL Scripts for manual back-end testing.
• Extensively performed ETL testing and Reporting application testing in supporting enterprise-wide data warehousing and business intelligence (BI) applications;
• Experienced in interacting with peers, both technical team members and business stakeholders, and analyzing business requirements and transforming into Test cases, reporting status updates and rolling out the deliverables on-time;
• Possess working knowledge of using defect-tracking tools like Test Director, Quality Center, Rational ClearQuest & Microsoft Test Manager (test scripting, execution, and organizing) and Team Foundation Server (tracking and reporting Defects, Requirements, and Testing Tasks);
• Hands on expertise in developing, and enhancing automated test scripts using Quick Test Pro, CodedUI, Test Manager;
• Involved in Change management and Configuration Management processes;
• Proficient in working with databases like MS SQL Server, Oracle and DB2 and other BI/ETL tools such as Cognos, Informatica, Microsoft SSIS/SSRS;
• A Life-long learner, ability to absorb upcoming technologies and acquire functional knowledge on-the-project and support business deliverables;
• Excellent team player and can work with minimum supervision in a time sensitive environment ensuring 100% compliance with corporate set standards;

TECHNICAL SKILLS

Testing Tools: Quick Test Pro 10.x/9.0/8.2/ 6.5, Win Runner, Load Runner 9.x/7.8

Defect Tracking Tools: Test Director 8/7.5, Quality Center 9/10, Rational ClearQuest 7.0

Front End Tools: MS Office Suite, MS Visio, ERWIN, TOAD 7.5, Rational RequisitePro

Browsers: Netscape Navigator, Internet Explorer, Mozilla Firefox

Languages: SQL, PL/SQL, SQL*PLUS, VBScript, HTML, XML, JavaScript, MS-DOS, Unix Shell scripting, VBA

Source Control Tool: Visual Source Safe, AccuRev

Packages: Cognos 8.x/7.x, Informatica 8.1.1/7.x

Databases: SQL Server 2005/2008, Oracle 11i/10g, Teradata, DB2

Operating Systems: Win 2000/2003, UNIX, LINUX, Windows XP/2000/7, MS-DOS

PROFESSIONAL EXPERIENCE

Confidential, Libertyville, IL

Programmer Analyst

Responsibilities:

• Primarily involved in analyzing business requirements and creating test cases for the major application rewrite, and new interfaces design and development - developed using Microsoft Visual Studio 2010, SQL Server 2008 database;
• Worked with the development team to create a suite of test data using XML Schema (both input files and expected results) that fully exercises data validation (detecting and rejecting bad data) and actual SQL functionality, verifying aggregated data and also the filtered data;
• Expert in SQL Data Validation, Testing functionality of mapping by preparing test data for all SQL mapping rules by loading data from various sources;
• Performed rigorous testing of the ADC-II application releases (built on .NET framework, Visual Studio.NET 2010, 2013) which have complex built-in functionalities and web services;
• Involved in Integration testing after integrating the different units;
• Updated the Incident Log Report and documented the Test summary report;
• Participated in change control process and documented all updates;
• Involved in verifying the functionalities of all the modules manually, and reported the broken links after manual testing;
• Performed functional, Integration and database testing and UAT;
• Performed regression testing after fixing the bugs manually;
• Work closely with other developers, business analysts, project managers, IT Operations and Application Support team for deploying new builds with latest bug fixes and change requests;
• Contributed to project plans by detailing the expected level of effort and time required, and consistently met the allocated milestones;
• Performed data validation and data integrity testing during manual backend testing involving complicated SQL Queries and joins;
• Participated in project sync meetings during all phases of testing as a lead for daily status reports for test activity and created performance reports (execution progress status, defect status);
• Participated in defect triage meetings for defect status updates enterprise wide.
• Participated in Disaster Recovery estimations and testing, providing QA Estimations;
• Performed extensive testing execution during Release Management phases and Production support as QA Lead during Dress Rehearsals for Go Live;
• Involved in all aspects oftest planning development(e.g. goals, objectives, strategies);
• Developed and Performed execution of Test Scripts manually to verify the expected results;
• Performed BizTalk Testing for Various Applications/WebServices, Used Test Harnesses/web services, Enterprise Shared Services;
• Performed extraction of test data from tables and loading of data into SQL tables.
• Creating and maintaining the defects usingMicrosoft Test Manager and JAMA defect tracking tools and retest defects found during all testing phases;
• ConductedFunctionality,Regression, End-to-End Testingduring the various phasesof TestLifeCycle
• During User Acceptance Testing, tested a number of defined test cases using quality data to validate end-to-end business processes and compared actual test results against expected results

Environment: MS-Visio, Web Services, TOAD, Win 7, MS Visual Studio, Rapid SQL XE4, SQL Server 2008, Microsoft Test Manager 2013, VB.NET, C#.NET, ASP.NET, AJAX, IIS, SharePoint 2010, Splunk Enterprise 2017, JAMA 2014, HP Service Manager 2012, Cisco 2016.

Confidential, Detroit, MI

QA Tester

Responsibilities:

• Performed functional, Systems Integration Testing, UAT and Regression testing.
• Worked on Quote renewals - Group Wide Changes (GWC) for Small Groups.
• Participated in smoke testing for applications which were developed in different environments.
• Participated in updating test cases, analyzing results of testing sessions and present results to team lead.
• Worked as part of an Agile testing team.
• Documented defects in Clear Quest.
• Team communication was via SharePoint site for sharing updated Test grids and cases.
• Utilized appropriate testing tools and testing processes on projects.
• Maintained manual test scripts/cases for user interface, functionality, system integration testing.
• Performed all the above testing phases under different roles - underwriter, managing administrator (MA), sales representative, and producer/agent administrator.
• Performed server side validations using request and response XML schemas.
• Interacted with the technical team to execute integration layer testing.
• Analyze formal test results in order to discover and report any defects, bugs, errors, configuration issues, and interoperability flaws.
• Execute regression tests, functional tests and data tests.

Environment: Java, J2EE, DB2, SharePoint, Quality Center, Clear Quest, MS Excel, MS Word.

Confidential, Flat Rock, MI

QA Analyst

Responsibilities:

• Primarily involved in analyzing business requirements and creating test cases for the two new data mart plus BI reporting applications - AAIQDS and MPS developed using SQL Server 2008 Integration Services (SSIS) and Reporting Services (SSRS);
• Worked 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, verifying aggregated data and also the filtered data;
• Expert in ETL Data Validation, Testing functionality of mapping by preparing test data for all ETL mapping rules by loading data from various sources;
• Perform rigorous testing of Complex reports containing custom SQL, cross tab, Master detail reports, drill-thru, calculated columns, filters, and prompts;
• Performed rigorous testing of the new web-based PFB and FTZ applications (built on .NET framework, Visual Studio.NET 2005, IIS 6.0) which have complex built-in functionalities;
• Inserted verification checkpoints, synchronization points, and parameterized data using QTP;
• Involved in Integration testing after integrating the different units;
• Performed Ad-hoc testing, Black box testing, Integration testing, End-to-End testing, Function testing, Performance testing, System testing, Black box testing and White box testing;
• Installed new builds on Virtual machines and tested different versions of application on the VM images;
• Created functional test scripts for dynamic content for the web-pages which is very sensitive in nature;
• Performed Exception Handling in application using functions and Recovery Manager in QTP
• Performed manual test execution from Quality Center using QTP Add-in
• Involved in creation and maintenance of Hybrid QTP Framework
• Extensively worked on handling application response for positive and negative sets of data for data driven testing using QTP
• Conducted data driven testing by parameterizing data using QTP
• Developed master startup by using Reusable Actions and Copy Actions
• Created user defined functions in QTP function library to reuse them in different tests and using Test Director for defect tracking and reporting
• Updated the Incident Log Report and documented the Test summary report;
• Participated in change control process and documented all updates;
• Involved in verifying the functionalities of all the modules manually, and reported the broken links after manual testing;
• Involved in tracking the defects and reported the defects using MS Excel and actively participated in Defect life cycle;
• Performed functional, Integration and database testing and UAT;
• Performed regression testing after fixing the bugs manually;
• Worked closely with QA Lead, developers, lead business analyst, and project manager;
• Contributed to project plans by detailing the expected level of effort and time required, and consistently met the allocated milestones;
• Contributed to maintaining the Traceability Matrix in MS Excel;
• Performed data validation and data integrity testing during manual backend testing involving complicated SQL Queries and joins;
• Worked with clients to make sure the requirements are properly met in terms of expected functionality and work flow;
• Attended weekly status meetings and updated manager about the progress as well as any road blocks;
• Updating test process documentation and sharing, via SharePoint Team site, with local IT team and other stakeholders.

Environment: MS-Visio, QTP, VBScript, Excel, Word, TOAD, Win 2000/7, Oracle 10g/11i, SQL Server 2005/2008, SSIS, SSRS, Visual Studio.NET 2005 (Visual Basic), AccuRev, IIS 6/0/8.0, SharePoint 2010.

Confidential, Philadelphia, PA

QA Specialist

Responsibilities:

• Used MS-Visio to develop the test cases for integration of multiple projects
• Put time and efforts to understand thebusiness requirements & studying the application
• Involved in all aspects oftest planning development(e.g. goals, objectives, strategies)
• Assisted QA Lead in creating test plans and Test Cases after analyzing the specifications Document
• Developed and Performed execution of Test Scripts manually to verify the expected results.
• Performed extraction of test data from tables and loading of data into SQL tables.
• Creating and maintaining the defects usingClearQuestdefect tracking tool and retest defects found during testing
• ConductedFunctionality,Regression, End-to-End Testingduring the various phasesof TestLifeCycle
• During User Acceptance Testing, tested a number of defined test cases using quality data to validate end-to-end business processes and compared actual test results against expected results
• Participated in various meetings and discussed Change Requests
• Preparedand executedtest casesas per schedule
• Execute Interface Testing and enter test data into databases using SQL scripts
• Tested PL/SQL stored procedures and tuned them for optimal performance.
• Sharing all updated documentation on the local SharePoint Team and Project sites, with internal Technical teams and also with business stakeholders.
• Interacted with the management regarding time lines and participated in Bug review meetings

Environment: MS-Visio, MS Word, MS Excel, SharePoint 2007, Rational ClearQuest, Windows Vista/2000/XP, Oracle 10g, DB2, J2EE, RAD (WSAD).

Confidential, Malvern, PA

QA Analyst

Responsibilities:

• Worked with the Lead QA analyst in gathering, analyzing and documenting data specifications for testing
• Performed manual testing of complex reports which had multiple dimensions, alternate drill-through, multiple layers with drill-through capabilities.
• Developed Test Cases as per the Test Plan for data warehouse and reports testing.
• Performed testing of Scorecards and dashboards consisting of activities and travel efficiency for Relationship Managers & Sales executives.
• Report generation and Bug tracking using Test Director.
• Unit tested the Cognos Reports to ensure reporting standards and data validation.
• Used database query tool TOAD to execute SQL queries on Oracle database.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Used SQL* loader to load data from flat files to the database tables;
• Tuned SQL for reports’ optimal performance by modifying joins and applying filters.
• Involved in performance testing of all the reports before moving into production.
• Executed complex SQL queries for analyzing data in different reports for UAT signoff.
• Tested conditional formatting in reports and multi-lingual feature (for European team).
• Tested different reports - detail, summary reports and ad-hoc reports.
• Tested row level and object level security implemented by Developers.
• Involved in identifying the defects and developed defect tracking report using Mercury Quality Center and interfaced with developers to resolve them and provided full support to the development team
• Participated in project sync meetings during all phases of testing.
• Involved in migration testing of Cognos reports from 8.2 to 8.3 and then to 8.4 v/s

Environment: Quality Center 9.0, Test Director, Oracle 10g, Sql*Plus, flat files, Excel, Word, TOAD 8.6, SQL, PL/SQL, UNIX, Win XP, Cognos 8.x, Power Play 7.x, Transformer 7.x, Informatica.

Confidential, Richmond, VA

QA Tester

Responsibilities:

• Analyzing defect documentation requirements and business scenarios
• Analyzed comprehensive test plans based on Defect and business scenarios
• Fully integrated with Test Director for Test Management activities, created separate test sets for each release based on the severity
• Developed SQL scripts to verify the database updates, inserts and deletes of the records
• Customized TSL Test scripts for multi-platform testing across windows 95/2000 and XP
• Divided various functional areas of the application into various Risk Levels for effective testing of the application, also risk leveled all the test cases accordingly
• Involved in the development of automated data driven test Scripts
• Validating if environment is configured properly
• Responsible for gathering matrices for automated test scripts run on each day during testing period for report generation purpose using TSL scripting
• Executing test cases in test region and validating functionality of all new fixes
• Extensively performed back end testing on Oracle using TOAD
• Verifying whether a new fix is impacting existing functionality by conducting regression testing
• Used Test Director for Defect reporting and tracking purposes
• Worked with Performance Test team to study the response times of the application under stress.

Environment: HP-Unix, Ab-Initio, Quick Test Pro, Test Director, Terminal Emulator Configuration, J2EE, WSAD, TOAD.

Confidential, Dearborn, MI

QA Analyst/Tester

Responsibilities:

• Worked with team lead to decide specific areas for Automated Testing
• Wrote Test Cases and test plans
• Performed Manual Testing using Quality Center
• Performed various aspects of Functional testing using QTP
• Automatedthe functional testing usingQTP bycreating generic functions
• Testing Website UI navigation & Cross Browser Testing
• Discussed Test Plans with team lead and members
• Used database query tool TOAD to execute SQL queries on Oracle and SQL Server databases.
• Involved in extensive DATA validation using SQL queries and manual back-end testing
• Programmed Test Scripts to maximize reusability and ease of maintenance
• Developed Automated Black Box/Functional Test scripts for Java application
• Performed Regression Testing for different versions/releases
• Performed Manual Black Box Testing on alpha, beta and release versions of product.

Environment: WinRunner 7.6, Quick TestPro, Test Director, Quality Center, Java, JavaScript, HTML, J2EE, XML, SQL Server 2000, Oracle 9i, PL/SQL, SQL, WSAD, LINUX, Win XP/2000, WAS.