SUMMARY:

• Software Quality Assurance Manager with 14 years of experience in Quality Assurance & Testing covering Health Care, Insurance, and Retail industries providing technical leadership and deliver ing cost effective, high quality testing solutions utilizing quality assurance, business, and technology experience to effectively manage QA/QE teams for Web/ETL/DW/BI environment.
• I have active PMP, CSQA, and CSTE license/certifications.

TECHNICAL SKILLS:

Methodology: Agile/Scrum, Waterfall, Iterative, Familiar with CI/CD process

ETL Tools: Informatica Power Center 9.6/8.6, DataStage 8.0/7.5

BI Reports testing: MicroStrategy, Cognos, and Business Objects

RDBMS: Oracle 10g, Teradata, Sybase, MS SQL Server, DB2

Languages: SQL, HTML, DHTML, XML, Unix, WSDL

QA Tools: Toad, SQL Navigator, WinSQL, ALM/Quality Center, QTP, Load Runner, Silk Central, Test Manager, Rational Clear Quest, Visio, JIRA, Exult XML

PROFESSIONAL EXPERIENCE:

Confidential, Buffalo, NY

IT Supervisor

• Software Quality Assurance leader with the ability to envision the “big picture” and deliver cost effective and high quality testing solutions that support strategic business objectives.
• Established Quality Assurance/Engineering & Testing discipline from ground - up by hiring, retaining, and engaging the geographically distributed QA-Data Integration team of 17 including Leads and Test Engineers for testing large volume of data for Health Insurance Applications
• Delivered testing of multiple projects on schedule, within budget, and with high quality encompassing Front-end applications, ETL (extract, transform, load) process, Data Warehouse, (BI) Business Intelligence initiatives including EDI transactions encompassing the enrollment, membership, provider, and claims data
• Provided technical leadership and mentoring to cross functional teams for on-schedule and defect free project implementation covering SIT, UAT, Post-Prod (review of requirements, design documents, mapping documents, test plans/strategies, estimates, defect triage, production readiness documents).
• Implemented test methodologies and managed automation (Agile/Scrum, Waterfall, Iterative) based on project needs and aligned QA teams with the SDLC process for optimal resource utilization. Optimized test processes, quality standards for testing, and Test automation for gaining efficiencies on regression testing.
• Employed several process improvement initiatives including automation testing to meet business objectives, gain program efficiencies, improve productivity, and reduced testing timelines by 25%.
• Managed QA Budget, Created team goals, in-house training programs, and conducted periodic performance reviews including Key Performance Indicators (KPIs) related to quality in performance plans.

Environment: HP-UX, ALM/Quality Center, QTP, JIRA, SQL Server, DB2, Oracle, Informatica 9.6, Cognos, WinSQL

IT TEST Manager consultant

Confidential

• As a hand-on Test Manager, managed cross-functional teams implementing multiple QA Programs.
• Managed section of ICD9 to ICD10 Conversion Program as part of US Dept. of Health’s new national coding standards for ICD-10 for more accurate data tracking, reimbursement, reduction in claim rejections, and more accurate revenue recognition.
• Reviewed and defined the scope of testing within the context of each delivery, Created Test Plans and coordinated with various distributed programs and business units for early remediation of issues and meet project timelines. Oversaw re-building of the manual regression suite for the program for increasing the test coverage and followed that up with automation, thus reducing a multiple resource/multiple week regression effort into an overnight process.
• Provided technical guidance - assigned testing resources and activities with cross functional teams. Utilized Silk Central Test Manager for defect management, DataStage for ETL process, running/testing Business Objects for reporting. SQL queries were executed against the databases (Oracle, DB2).

Environment: HP-UX, SCTM, Quality Center, SQL Server, DB2, Oracle, DataStage, Business Objects, Toad

Confidential, Columbia, MD

Lead ETL Testing for CMS (Center for Medicare & Medicaid Services) programs

• Directed and managed the team of geographically distributed QA Engineers for several Health Care projects for CMS for data validation of Eligibility, Medicare Provider, and Beneficiary data.
• Built, managed, and mentored the QA team. Defined testing scope, goals and deliverables, prioritized work, assigned resources, managed test schedule, acceptance criteria, made recommendations and offered solutions to improve efficiency. Created test plans, reviewed the requirement documents, mapping documents, and traceability matrix in Quality Center.
• Improved software quality, met customer expectations, and reduced defects by supporting proven software quality practices and implementing effective process improvement methods.
• Utilized Quality Center for defect management, QTP was used for test automation, LoadRunner for Load/Stress testing. Informatica was the tool for ETL (Extract, Transform, and Load) process. SQL was run against the Oracle/DB2 databases to test the business rules and MicroStrategy reports.

Confidential, Plano, TX

Team Lead Quality Assurance

• Business Intelligence (BI) project in the Data Warehouse environment to build rich set of web based/online data around store attributes, and merchandise.
• Created and managed the QA process that included requirement analysis, work estimation, resource planning, scheduling, acceptance criteria, project execution, and results. Effectively communicated project expectations to team members, Planned, Identified, Managed and Tracked the project dependencies to meet the Quality objectives
• Created test plans, managed, and tracked the project dependencies. Tested the data in multiple databases (Oracle/DB2/Sybase). Data Warehouse testing involved testing ETL jobs using Informatica Power Center (from source ADW to the Merchandise Analytics Mart. Stress/Performance testing was done using LoadRunner. The BI reports were tested using Microstrategy. Quality Center 10.0 suite was used for managing of manual testing. QTP was used for automation testing.

Lead Quality Assurance

Confidential, Englewood, CO

• Lead the team of six testers. Created the test strategy for the following projects:
• PrepSmart - It is a Web Based application that is designed for the delivery of customer history, research information to the Sales department in order to help them in selling Dex products. Tested the browser, GUI, functional, database tables, tested Business Intelligence reports that were created using Cognos. Managed stress/load testing using Load Runner.
• K-Gen - National Data Mart that was built to integrate information from multiple sources to effectively improve sales and increase the accuracy of financial reporting. ETL process that populated/updated the Data Warehouse base tables was tested using Informatica Workflow Monitor to run the work flow and view the log events. SQL queries were run against the database to validate database tables.