SUMMARY:

• Establishment and management of QA, UAT, data and other test processes
• Hands - on testing
• 10+ years’ experience as project QA/UAT lead, management and project management, including establishing processes and mentoring team members (team sizes of 10+)
• 10+ years of managing defects in the software systems
• 10+ years creating/maintaining quality control artifacts including those that are used in audits
• Test strategies
• Test plans
• Test cases
• Test data
• Test reports
• Test closure documents
• 10+ years of professional knowledge and skills in information systems software testing, Quality Assurance (QA) & UAT, and quality control of application software and systems
• Strong SQL skills
• 10+ years of promoting appropriate testing methodologies
• Web applications, web services, healthcare insurance (including interfaces to CMS and DHS systems), financial, investment and mobile testing experience.
• Experience with all types of testing, including ETL/Informatica/data, system, functional, end-to-end, regression
• Big Data testing and test automation
• International experience
• Experience with automated testing tools, including UFT/QTP and Selenium
• Selenium 3.0 (WebDriver) Certified (January 2018)
• System integration testing
• Ex-developer

SKILLS SUMMARY:

SQL, BI platforms, Business Objects, QA Assessments, Data Testing, ETL / Informatica Testing, 834/835/837 EDI files and processes, Salesforce, SQL, ICD-10, Quality Center / ALM, TFS, Microsoft Test Manager, Rally, Jira, Agile, Mainframe testing, automated testing, HTML, some Data Warehouse exposure, QTP, Selenium Cucumber exposure. Tested .NET and non-.NET applications transparently.

PROFESSIONAL EXPERIENCE:

Confidential

UAT Test Manager

Responsibilities:

• Management and improvement of the UAT process for a complex, Big Data/Data Warehouse system
• Researched and recommended automated data test tools for Big Data/Data Warehouse testing
• Managed and led 11-person UAT test team
• Test Strategy, Test Planning, Defect Management & Triage
• Coordination with Technology team and Stakeholders

Senior QA / UAT Consultant

Confidential, San Diego, CA

Responsibilities:

• Test planning, automated testing and defect/results reporting
• Creation and execution of automated Selenium scripts for the company website
• Defect reporting and consultation

Senior QA Analyst

Confidential

Responsibilities:

• Execution of business and QA test cases for an Confidential ’s Trading and Settlement processes, implemented via a COTS web-based application.
• Used HP Quality Center (ALM) with Excel-based test metrics reporting process.

Confidential

Senior QA Tester

Responsibilities:

• Performed test planning and security testing of a data security interface using Active Directory and an I dentity Access Management tool, for pharmaceutical management and optimization applications, web services and interfaces to/from existing Web applications
• Tested Applications/web services related to data security
• Rapid, flexible, thorough QA testing on new application that enabled new releases to be bug-free
• Functional and data testing of new and legacy applications involving optimization of hospital pharmacy costs
• SQL scripting via SQL Server
• QA testing of interfaces with existing client applications
• Agile environment, with 2-week sprints, scrum meetings, etc.
• Used ‘Conditions of Acceptance’ (COAs) (i.e., Cucumber Feature files) as part of the test design
• Praised for the thoroughness of the testing
• Was offered a full-time position

Confidential

Senior Consultant - BLA / UAT Lead (web systems/apps)

Responsibilities:

• Managed a multi-level test team that spanned 3 different Business areas
• Performed detailed project planning (and re-planning) on a highly visible project, while identifying project risks and tracking to project milestones
• Trained testers and others in the defect management process and in the use of Quality Center for test execution status and defect creation/updates
• Developed Quality Center reports to aid management of the testing process, using Analysis filters and SQL
• Directed test process improvement efforts using HP Quality Center and other tools, including report generation
• Created and executed test cases for apps on a variety of Mobile devices, including iPads, iPhones, Android phones and Android tablets.
• Used ‘Conditions of Acceptance’ (COAs) (i.e., Cucumber Feature files) as part of the test design process.
• Included web applications and mobile apps involved with banking, Brokerage / Trust accounts, robovesting and account aggregation.
• Developed ground-breaking method to improve the efficiency and productivity of the Mobile testing process.
• Did BLA / UAT testing on multiple concurrent projects in brokerage and trust areas, and in online banking.
• Praised for my positive approach, in a technically and organizationally challenging environment.

Confidential

Senior Software Quality Analyst

Responsibilities:

• Provided hands-on testing for a data-centric, mobile project to re-engineer how Ecolab associates deliver best-practice customer care in the field.
• Tested a Mobile tablet-based product in a complex, multi-national Salesforce-based system.
• Did intensive data and ETL testing using complex MS SQL and Force.com queries
• Served as the "go-to" data tester on the multi-national QA team.
• Mentored functional testers on how to do data testing
• Designed and executed complex data test cases for ETLs that performed adds, deletes, undeletes, modifications and incremental updates on multiple databases.
• Created queries in SQL and Force.com (using JOINs and other clauses) to verify data in SQL and Salesforce databases
• Participated in review of business requirements and application design
• Participated in defect identification and triage
• Used Rally for user stories, estimating, task tracking and defect tracking.
• Used HP Quality Center for test cases, test suites, defect tracking and reusable SQL
• Used mobile tablet and SalesForce.com applications.
• Agile environment, with 3-week or shorter sprints, scrum meetings, etc.
• Data Warehouse exposure

Confidential

Software QA Lead

Responsibilities:

• Served as QA lead and did hands-on-testing for multiple projects in the Medicare / Medicaid arena, including Encounters Improvement, which automated and streamlined the process of submitting claims to the Minnesota Department of Health Services and CMS, for reimbursement based on Business Rules.
• Included working with 834, 835, 837 Encounters files for Medicare and Medicaid, and the EDI interchange process with Department of Health Services (DHS) for the State of Minnesota (for Medicaid)
• Led the team to take risks and make major "saves", including areas where other team members wanted to take the word of development that the application was working correctly.
• Led the creation of a robust End-to-End (E2E) test plan and refined it in conjunction with colleagues, pioneering the End-to-End process and related test planning, test case creation, and tracking.
• Defined the End-to-End test scope, test strategy and drove the test planning.
• Read and analyzed XML files to verify correctness and trace data flow.
• Created queries in SQL and Toad (using JOINs and other clauses) to verify data in SQL and Oracle databases.
• Introduced the use of test metrics for status reporting.
• Technology areas included testing of SSIS packages
• Included a small project related to implementation of ICD-10

Confidential

E2E Test Lead / Test Principal

Responsibilities:

• Led the End-to-End (E2E) test effort for a $400 million claims migration project.
• Defined the End-to-End test scope, test strategy and drove the test planning.
• Participated in test strategy and planning sessions with the Vice-President in charge of the program, key stakeholders, the overall test Manager, and technical staff.
• Developed Business Process Model diagrams and technical diagrams that summarized key business, architectural and data flow aspects of the system under test.
• Raised key obstacles to appropriate management levels.
• Identified a key gap in Business Rule Identification that impacted an external organization and would have resulted in potential financial liability if it had remained undetected.
• Raised the level of visibility in spite of organizational pressure and led the drive to get the gap closed and a solution implemented and tested.
• Identified critical technical resources to accomplish the planned testing and led the test execution, reporting and defect tracking process.

Confidential

Data Test Lead / QA Lead / UAT Lead / Business Analyst (BA)

Responsibilities:

• Mailing component:
• Developed and executed QA & regression test cases and scripts for a client-server application.
• Performed manual application and data testing using SQL queries.
• Performed smoke testing for each major delivery of new code.
• Performed regression testing after each modification and enhancement.
• Tested format, layout and content of physician-specific reports produced by the application.
• Documented defects and worked with the software developer and BA to resolve them.
• Helped the BA structure and perform the UAT testing.
• Physician portal:
• Led the UAT team on multiple releases of the portal over a 2+ year time-frame.
• Business Analyst (BA) duties: Evaluated the initial interface from a business perspective, set up and managed stakeholder focus groups, and redefined the UI in conjunction with the business.
• Developed and presented the redesigned interface to approximately 80 senior managers and medical and technical staff in a series of user awareness sessions.
• Developed and executed manual test cases and test scripts.
• Performed functional and regression testing of the application.
• Tracked defects in a web-based system used by the vendor, and in Quality Center used by internal technical staff.
• Partnered with the BA to execute test cases and evaluate the results.
• Documented defects and worked with the software developers and the Solution Architect to resolve them.
• Interfaced to senior management.
• Data testing:
• Led the Data test team, including planning, coordinating, controlling, resource management, risk management and tracking to milestones.
• Defined and managed the data testing of 20 major data deliveries in a 9-month period, with each delivery having different scope and requirements.
• Developed complex SQL queries (including constructs like multiple JOINs, Replace, trim, convert, and ‘IN' clauses with SELECT sub-clauses).
• Created stored procedures.
• Executed SQL queries and related stored procedures.
• Imported text-delimited files to create temporary tables.
• Reported defects and worked with the Data development team and the Solution Architect to resolve them.
• Tested complex data extracts, using stored procedures and complex SQL queries.
• Read and analyzed XML files to verify correctness and trace data flow.
• Used Excel and Visio to define the key characteristics and test scope of each data delivery.
• RESULTS:
• The only post-release support issue related to things missed during QA or UAT was a misleading page number on one of the letter attachments.
• Was applauded for testing plans that combined detailed functional QA and business UAT in a short time-frame. The testing uncovered serious functional quality issues, business process issues and workflow usability issues. The issues led to a major redesign.
• Received personal written accolade from the National Director of Physician Engagement for the quality of the testing and the redesign of the portal interface.
• The original assignment was for four months, and was extended multiple times.