PROFESSIONAL SUMMARY:

• Over 12 years of progressive experience in the Information Technology industry with emphasis on Quality Assurance in web based client/server applications, ETL/Data Warehouse implementations and Data Analysis.
• Experience working in Health Care, Directory Publishing, Telecommunications, Communication Services and Hospitality industries.
• Experience in all aspects of the Software Development Life Cycle with specific focus on testing.
• Involved in Project Planning, Test Planning, Coordinating and implementing various QA methodologies such as Waterfall, Rational Unified Process (RUP) and Agile.
• Hands on experience with Business Intelligence, Data Warehousing concepts, OLTP, OLAP, Dimensional Modeling (Star and Snowflake schema).
• Strong working experience in Data Analysis/Data Verification of ETL Applications, Back - End/Database Testing using complex SQL queries.
• Lead various software testing projects along with execution of testing processes, test strategies, test plans, defect documentation and regression testing.
• Experience in mentoring, coaching, guiding and managing junior testers in the team.
• Experience in manual and automated White-Box/Black-Box testing techniques. Functional, Regression, System, Integration, User Acceptance, Parallel, Web Services and ETL/Data Warehouse testing.
• Experience in designing, documenting, and executing test plans, test harness, test scenarios/scripts & test cases for manual, automated & bug tracking tools.
• Experience in creating and reviewing the Requirements Traceability Matrix with project team to confirm test coverage.
• Experience in performing automated tests using tools such as QuickTest Professional 9.2, SoapUI 5.2.1 and HP ALM Quality Center 12.01
• Experience in working with J2EE, XML, HTML/DHTML, VBScript, SQL, PL/SQL, and UNIX, C, and C++.
• Sincere, well-organized, quick learner, ability to deal with change with good interpersonal and leadership skills.
• Effective Team Player with excellent analytical, programming, written and verbal communication skills.

TECHNICAL SKILLS:

Testing Tools: QuickTest Professional 9.2,Selenium, HP ALM Quality Center 12.01, CM Synergy 6.3, SoapUI 5.2.1, Telelogic Doors 7.0, Toad 11.5, DBVisualizer 5.1.1, AQT 8.2.8, SQL Developer 4.1.1

Scripting Tools: VBScript, JavaScript, Perl, XML

Languages: C, C++, JAVA, Visual Basic, SQL, PL/SQL, HTML/DHTML

Operating Systems: Windows 98, 2000/XP/7, UNIX

Database: Oracle9i/10g/11g, MS Access 2003, DB2, MS SQL Server 2005, Netezza, PostgreSQL

ETL/Reporting Tools: Ascential DataStage 7.5.1A, Ab Initio, Cognos 1.1 MR2, MicroStrategy 9

Web Servers: Microsoft IIS, Apache Tomcat 5.0.28, Sun Java System Web Server

Utilities: MS Office Suite, Eclipse, JCreator

WORK EXPERIENCE:

Confidential, Atlanta, GA

Product QA Lead

• Product QA for multiple applications (Rule Update & Maintenance, Client Inquiry and Client Profile) across different teams implemented on an onshore/offshore model.
• Work with the product and delivery teams in an Agile software development lifecycle to ensure that epics, features, stories and defects are documented in Agile Central and delivered are per the requirements specifications.
• Participate in epic, feature, user story grooming of the requirements and agile ceremonies in an Agile software development lifecycle.
• Create and publish end of sprint and release test summary reports to the product/delivery teams and business users that determine product quality and release readiness.
• Lead a four member QA testing team in implementing QA best practices to ensure compliance and deliver the product as per business needs and specifications.
• Assign user stories to members of the testing team at the beginning of each sprint cycle.
• Review user stories, test cases and defects created by members of the testing team in Agile Central.
• Conduct defect triage meetings to obtain prioritization of the defects from the Product owner.
• Assist with user acceptance testing(UAT) for each application release.
• Conduct regular meetings to obtain testing progress, mentor and provide clarification to questions raised to the product team and business users.
• Create, maintain and execute the regression test suite for the regression cycle of each application release.
• Assign and approve test cases for test automation execution.
• Create and execute test cases and document defects in Agile Central.
• Utilized SQL queries to verify application functionality in the backend Oracle 12c database.
• Utilized Lotus Notes to submit and process workflow requests initiated from RUM and JIRA applications.
• Provide production support assistance by analyzing and identifying the root causes for all production defects reported by the business users.

Environment: Agile Central, J2EE, Angular JS, Oracle 12c, TOAD, SQL, JIRA v6.4.12, Confluence, IBM Lotus Notes 8.5, Microsoft Office 2013, MS SharePoint.

Confidential, Atlanta, GA

Senior QA Test Lead

• Primary onshore Test Lead for the Wholesale and Retail applications QA teams working on multiple new/enhancement projects across various releases.
• Create daily status reports and provide updates for the projects to Confidential / Confidential upper management.
• Read and analyze the requirement specification documents to create Test Strategy and Test Plan documents.
• Conduct Test Plan reviews, knowledge transfer meetings with the Confidential offshore QA team.
• Conduct daily defect triage meetings to resolve critical/blocking defects, generate defect and test results reports.
• Create, document and execute manual test cases in HP ALM Quality Center 12.01
• Perform functional and regression testing on Confidential ’s Web/Intranet/POS applications for the Retail, Care and Wholesale business streams/channels.
• Conduct live/non-live mobile handset device testing using sims/msisdns activated using the WCSM application.
• Verified web services using the SoapUI 5.2.1 application by modifying the end point URL when working on different environment servers, providing required input data to request XML and validating the response XML.
• Verified subscriber information and error codes/exceptions from testing in the Oracle databases using SQL queries.
• Monitor application logs and retrieve information using UNIX commands to analyze/report error codes and exceptions.

Environment: HP ALM Quality Center 12.01, J2EE, Tibco, Oracle 11g, SQL Developer 4.1.1, SQL, UNIX, PuTTY, SoapUI 5.2.1, Microsoft Office 2013, MS SharePoint.

Confidential, Atlanta, GA

Senior QA/ Data Analyst

• Perform System/Parallel/Data Validation testing and analysis for the Just in Time Rating ( Confidential ) project.
• Read and analyze the requirement specification documents to create Test Strategy and Test Plan documents.
• Conduct Test Plan reviews, knowledge transfer meetings, generate defect and test results reports.
• Create, document and execute manual test cases in HP ALM Quality Center 11.0
• Create, track and manage defects, gather and report quality metrics and analyze the collected data.
• Assign tasks, mentor and train team members of the testing team.
• Perform end to end data verification and data analysis of customer/subscriber information flowing from Vision to UBSR to Confidential /RBM systems.
• Verified the Usage Broker (UB) Customer/Subscriber Seeder workflow process developed to load the current customer/subscriber data from Vision into the Usage Broker Subscriber Repository (UBSR) and the Rating and Billing Manager (RBM) Oracle 11g database tables.
• Verify and analyze the Usage Broker (UB) Customer/Subscriber Reconciliation workflow process created to reconcile customer/subscriber data changes between Vision, UBSR and RBM database tables.
• Verify that the raw usage files are configured into RBM rate-able event files by the Usage Broker (UB) Rating Interface Workflow (RIW) as specified in the Vision to UB to RBM mapping document.
• Execute RBM’s Usage Rating jobs and processes to rate the event files using UNIX commands.
• Verify/Analyze the rated or rejected usage by querying the UBSR and RBM Oracle databases using SQL queries.
• Verify/Analyze error codes/exceptions from the customer/subscriber Seeder and Reconciliation workflows using SQL queries.
• Monitor application logs and retrieve information using UNIX commands to analyze and report error codes and exceptions.

Environment: HP ALM Quality Center 11.0, J2EE, Oracle 11g, SQL Developer 4.1.1, SQL, PL/SQL, UNIX, PuTTY, WinSCP, Microsoft Office 2007, MS SharePoint.

Confidential, Atlanta, GA

Senior QA Analyst

• Ensure that the QA process is documented and communicated to ensure agreed quality levels for the application in an AGILE environment.
• Work with the Agile Scrum master to plan, prepare and monitor testing progress to ensure 100% test coverage.
• Create, track, estimate and manage tasks and defects in Rally/HP ALM Quality Center.
• Create, document and execute manual test cases in HP ALM Quality Center 11.0
• Perform functional and regression testing on the eleven Confidential hotel brand websites.
• Create/Record automated test scripts using Selenium IDE for testing.
• Monitor application logs for exceptions using UNIX commands.
• Verify/Test logging, caching and throttling techniques using the MX4J Java Management Console.
• Test different application web services/methods/request invocations using an in-house tool called FuncTester.
• Execute cross browser testing using Internet Explorer, Firefox, Chrome and Safari browsers on all Confidential brand websites.
• Execute cross platform testing using Windows and MAC operating systems for all Confidential brand websites.
• Write SQL queries to verify the hotel, price, payment and reservation information in the Oracle 11g database.
• Execute Single Sign-On (SSO), Internationalization(I18N) and Localization(L10N) testing on different hotel brand sites
• Build/Deploy/Revert the project code using Hudson to test environments as and when new code is available and ready for testing.

Environment: HP ALM Quality Center 11.0, J2EE, JavaScript, CSS, UNIX, PuTTY, Windows XP/7, Microsoft Office 2007, Rally, Oracle 11g, Apache 2.2, Resin, Akamai, Hudson

Confidential, Charlotte, NC

Lead ETL QA/ Data Analyst

• Worked closely with the architects, developers and business analysts to clarify/understand functionality, to resolve issues and provide feedback in an AGILE software development life cycle environment.
• Design and develop test plans/scenarios to satisfy the functional and architectural requirements of the application.
• Provide estimates for tasks and mitigated issues in a lead role for the testing team.
• Manage, assign tasks, mentored and train the team members of the testing team about the ETL applications.
• Verify multiple ETL(Extract, Transform and Load) applications like SBASE, SBASEAE, SQA, CDW, SCDW, HCDW, I3 and ACDW by executing table count check, data transformation check, Not Null check, Duplicate record check, Primary Key(PK and Foreign Key(FK) check between source and target databases.
• Verify the Fast Pub table copy process developed to copy tables over to different databases across different environments using SQL queries and UNIX shell scripts.
• Verified the scheduled Autosys batch process jobs run within the datawarehouse environment using SQL queries.
• Identify ETL test data/ units of work in the source databases and put them on queue for every ETL run.
• Develop complex SQL queries and UNIX shell scripts to perform source-to-target verification of the Ab Initio ETL graphs.
• Verify the data on the MicroStrategy Reports with the data in the data warehouse.
• Create, document, execute test cases, track execution and maintain the test suite using HP Quality Center 10.0
• Created, track and manage tasks/stories/defects using JIRA.

Environment: HP Quality Center 10.0, J2EE, JavaScript, MicroStrategy 9(Reports), Oracle 11g, Netezza, PostgreSQL, Ab Initio(ETL), UNIX, Autosys, Microsoft Office 2007, JIRA, Subversion, SQL, PL/SQL, Advance Query Tool(AQT)

Confidential, Atlanta, GA

Lead QA Analyst

• Involved in creating test cases from the test plans and identifying test scenarios and test harnesses of varying complexity.
• Worked with the data management team for creating and managing test data created from various sources.
• Used Mercury Quality Center 9.2 to create/execute test cases and track defects from inception to resolution.
• Involved in functional and regression testing of the jPayment payment processing application.
• Created complex SQL queries perform end to end backend testing to verify payment and transaction data.
• Tested and verified the front end web pages, screen navigation, data entry/data retrieval of POS web applications.
• Involved in functional, regression, white-box and black-box testing of Remedy - Action Request System, Streamline intranet, TMobile.com and MyTMobile.com web based applications.
• Involved in functional and regression testing of the CSM component of the Confidential Samson 9.20 billing application.

Environment: Mercury Quality Center 9.2, MS SharePoint, J2EE, ASP, VB, HTML, JavaScript, Power Builder v 10.2.1.9004, SQL, Microsoft SQL Server 2005, UNIX, Windows XP and Citrix Metaframe.

Confidential, Birmingham, AL

Senior QA Test Analyst

• Developed test cases, maintained the test suite and tracked defects using Mercury Quality Center 9.2.
• Created test cases for the Medicare hospital Outpatient Prospective Payment System (OPPS) regulations for the calendar year 2008 set by the Centers for Medicare Medicaid Services (CMS), implemented in the Surgery applications.
• Tested the administrative and clinical processes from scheduling, registration, clinical documentation and inventory management to billing, collections and revenue cycle management on SurgiSource, AdvantX and Vision applications.
• Data Verification of UB04, UB92 and HCFA reports for different states in the U.S for Vision, AdvantX and SurgiSource.
• Used SQL Query Analyzer to access the database to retrieve and verify and test data.

Environment: Quality Center 9.2, Microsoft Window Server 2003, Microsoft SQL Server 2005 SP1, Microsoft.NET, Visual Basic 6.0, Crystal Reports, C++, XML, Visual SourceSafe 6.0.

Confidential, Newton, MA

Lead QA Analyst

• Conduct reviews for business requirements and functional specifications of the web portal application.
• Set test schedules, generated test results reports, defect reports and assigned tasks to members of the team.
• Managed all types of change requests, defects and enhancements/documentation changes with a flexible workflow process.
• Implemented and developed test cases, test scenarios, test strategies and test plans, ensuring accurate coverage of requirements and business rules, maintained and executed the test suite using Quality Center 9.2.
• Involved in creating automated scripts to perform functional and regression tests using QuickTest Professional 9.2.
• Developed SQL queries to retrieve the test data from the database using DBVisualizer 5.1.1.
• Used PuTTY to view and monitor the Tibco application log files.
• Worked closely with the development/business to meet deadlines for the project.

Environment: Quality Center 9.2, QuickTest Professional 9.2, SQL, PL/SQL, UNIX, Oracle10g, DBVisualizer 5.1.1, Apache Tomcat 5.0.28, Windows XP, MS SharePoint, Tibco.

Confidential, Denver, CO

QA Test Analyst

• Developed, maintained, executed test scripts and tracked defects using Mercury TestDirector 8.0.
• Developed automated test scripts to execute functional and regression tests using Mercury QuickTest Professional 8.0.
• Data verification using SQL queries using TOAD 8.0 of reports developed using the Cognos reporting tool for the National Datamart project.
• Verified/Tested the Extract, Transform and Load (ETL) applications/jobs created using the Ascential DataStage tool for the RHD integration project.
• Tested the Keystone CRM application by creating items/charges and validating them on the Oracle database.

Environment: TestDirector 8.0, QuickTest Professional 8.0, J2EE, SQL, PL/SQL, JavaScript, UNIX, DB2, Oracle10g, Toad 8.0, Cognos 1.1 MR2, Ascential DataStage 7.5.1A, Apache Tomcat 5.0.28, Windows XP.

Confidential, Atlanta, GA

QA Test Engineer

• Created test scripts, executed, and maintained the test suite using TestDirector 8.0.
• Involved in creating automated scripts to perform system tests, functional and regression tests, user acceptance tests, smoke tests, cross-platform and cross-browser using QuickTest Professional 8.0.
• Executed tests for cross-browser/cross-platform testing on Windows/MAC operating systems using VMware Console 3.1.
• Created SQL queries to retrieve and verify data from the Oracle database using TOAD 8.0.

Environment: QuickTest Professional 8.0, TestDirector 8.0, VMware Console 3.1, J2EE, SQL, JavaScript, UNIX, Oracle9i, Toad 8.0, CM Synergy 6.3, Telelogic DOORS 7.0, MAC OS 9 and OS X, Windows 98, ME, XP, 2000.