Sign in

Manager Data Analyst

Cleveland, OH
February 26, 2020

Contact this candidate


Vicki D. King

**** ********** **** – Cleveland Heights, Ohio 44112


Quality Assurance Analyst/Strategic Lead – Mercer Co. 2/28/2011 – 2/29/2020


Functioned as the Lead Tester for small, medium, and large project enhancements. Could be working on as many as four separate project enhancements with varying time frames

Participated in the project review process from design through to test approach/plan review

Used the requirements set up in Team Foundation Server (Epics, Features, User Stories, and Acceptance Criteria) to create the High-Level Test Plan/Approach using risk-based analysis scope, and environments affected to determine level and amount of testing required.

Started creating test scenarios that would be placed in the TFS Test Manager, after the high-level test plan/approach was created.

Validated that all acceptance criteria/User Stories had at least 1 test scenario

Started Testing as the User Stories moved within the Kanban board (Deployed to Test 1, Test 2, etc.)

Created Task/Time estimates upon completion of the Test Plan/Approach and kept project team apprised of how testing was progressing with respect to original estimate during weekly stand ups. These tasks/test estimates were added into TFS Web Application to be adjusted as the testing process ensued.

Started with Exploratory, then Functional, then Integrational testing to ensure the entire system/process still functioned with the new or updated enhancement features. Also performed Regression testing to ensure no surrounding systems were broken with the enhancement features.

Immediately reported any defects found during any segment of testing to the project team (Product manager, Developer/Engineer, QA, and Business Stakeholder) via the TFS Test Manager. Developers communicated the fixes through TFS Test Manager and then were retested to validate the fixes.

As a Strategic Lead…tracked the Flight Plan of upcoming enhancement projects and assignment of projects to QA team by their specific bandwidth. Also notified project managers of available QA resources for each specific project

Tracked and reported on the status of current and upcoming releases on a monthly basis to upper level management (number of projects, what systems were affected, # of user stories, etc.)

Tracked and reported on Defect Leakage – regarding missed requirements, missed functional or regression testing by QA to management on a weekly basis

Prepared QA Release Signoff documentation (received input from all QA with their enhancement project details-brief description of projects and status diagram of completed scenarios from the lower environment testing)


Worked using various browsers – IE 11, Chrome, Firefox, Microsoft Edge, also used previous versions of these browsers to test backwards capability

Also worked on Project Enhancements for SSO, Multifactor Authentication, Non-Security and Enhanced Security features

Experienced with scripting for automated regression and smoke testing. Ran these tests at least once a month during Sunday weekly maintenance window testing. Was able to step through these tests when any failed to ascertain reason for failure.

Experienced with end to end system testing

Worked using Waterfall methodology 3 years and Agile for 4 years

Worked using the following software – Excel, Team Foundation Server Web Application, Team Foundation Server Test Manager, In house Health and Benefits packages, Outlook, OneNote, SnagIt, LinkedIn, Microsoft Word

Customer Marketing Associate – Bank of America – 7/2009 – 2/2011


Took incoming calls regarding the types of banking services available to customers…checking, savings, CDs, etc.

Performed upselling to increase the services previously receiving from Bank of America

Performed other tasks as assigned

Quality Assurance Analyst – Progressive Insurance Co. -10/2006 – 6/2009


Functioned as single tester in one segment of a specific project.

Participated in requirement reviews prior to coding being deployed to environment

Reported any defects to QA lead

Performed other testing tasks as required

Data Analyst II – Progressive Insurance Co. – 9/1999 – 10/2006

Ensured monthly expense and budget reports were produced on time and accurately

Completed monthly Corporate Administration Expense Reconciliation of the expense system to the Profit by Line system, investigated and documented any differences between two systems.

Contacted department managers regarding any expense variances exceeding analysis scope to ascertain the reason, affect, and impact on future periods.

Coordinated annual budgeting project for two years. With input from the Management Reporting and Plan departments, set up the yearly budgeting calendar. Provided assumption information to budgeters. Worked with the Information Technology programmers to schedule budget system nightly system runs to pull in the day’s information. Prepared worksheets for analytical budget review.

Assisted in the automation of manual entry processes with the use of data retrieval packages

Updated and maintained the departments’ cost centers coding system. Also updated and maintained the expense allocations.


Bachelor of Science/Business Administration – Roosevelt University, Chicago, IL

High School Diploma – Shaw High School, East Cleveland, Ohio

Contact this candidate