Sign in

Test Cases Data

Des Moines, Iowa, United States
January 12, 2018

Contact this candidate


Sandra Johnson

Cell: 515-***-**** • •


Grand View University, Des Moines, IA

BA in Management Information Technology with an emphasis in Business Analyst

Graduated April 2016

GPA 3.1

American Institute of Business, Des Moines, IA

Associate Degree in Computer Support Services

Graduated with Honors, May 2000

GPA 3.8

Summary of Qualifications

Experience with SDLC.

Five years’ experience with vendor/third party software.

Fifteen years’ experience in compiling, organizing and aggregating data to meet business requirements.

Ten years’ experience in creating business process maps, flowcharts and diagrams to document technical processes and procedures.

Ten years’ experience as an instructional writer for several different processes within Wellmark, Inc.

Understanding of SQL, SAS and Java development.

QA tester in all positions at Wellmark. UAT and regression testing, writing of test cases, both in a mainframe environment and data warehousing environment. Documenting and analyzing test results, and making recommendations to improve overall quality and process improvement.

Proficient with Microsoft Word, Excel, PowerPoint, Access and Outlook.

Strong analytical and problem-solving skills.

Employment History


HEDIS Reviewer January 2017-March 2017

oReview member medical records and record results for the annual HEDIS quality program.

The Members Group

Solution Analyst May 2016-October 2016

oAct as the lead for all operational issues that comes in from partner support and other Canadian channel team members.

Delivery Coordinator April 2015 – May 2016

oPerform all administration duties for the Delivery Team.

oParticipated in process improvement events to establish process and workflow within the Delivery Services Team.

oCreated multiple forms in Excel related to scoping projects.

oAttended many training sessions with the goal to learn the credit card industry.

Career History with Wellmark BCBS of Iowa (Dec 1981 – Sept 2012)

Interim Senior System Analyst April 2010 – September 2012

oResponsible for building the yearly database using vendor software (Mckesson) on an Oracle server. Worked closely with the vendor’s software engineers and internal IT resources to problem solve issues that arose. Worked with requirement documentation to understand process.

oSupported Access Database that assisted in organizing data for the yearly compliance (HEDIS) reporting period. This included updating tables, queries and forms.

oPerformed data integrity verification to account for accuracy of data files.

oParticipated in new 3rd party vendor selection process, creating RFP specifications.

oVerified temporary staff’s security request, along with verification of correct permissions and set-up of ODBC connections.

Operational Analytics and Reporting Consultant April 2006 – April 2010

oParticipated in several file development projects, including writing test cases and QA functions and implementation.

oMember of corporate warehouse development team. Participated in scoping and developing detailed business requirements (DBRs) and high-level requirements (HLRs). Performed UAT and regression testing.

oParticipated in several process improvement events.

oSupported the Business Intelligence team by developing and implementing operational metrics for internal stakeholders.

oResponsible for various ad hoc reporting, using Business Objects software, SAS EG and SQL for both internal and external reporting.

Provider Analyst/Consultant July 1999 – April 2006

oBusiness unit project lead for the HMO product incentive (pay for performance) program paying physicians and hospital over 2 million dollars in quality based incentives. This included gathering of requirements, working with programmers in development of project, and all QA functions and post production support.

oDeveloped and executed an education plan to the Wellmark provider community regarding the incentive program.

oSelected to be a data warehouse steward. Implementing rules and processes for enterprise wide data warehouse.

Technical Skill Summary

oTesting Tools: SAS, WinSQL

oDatabases: MS Access, Enterprise data warehouse.

oTest Management Tools: MS Excel, SQL

oBrowsers: Internet explorer, Mozilla Firefox, Chrome.

oSoftware: MS Office Suite 97, - 2016, Business Objects, Full Shot, Visio

oDocumentation Tools: MS Office, Excel, MS Project

Certifications and Training

oMicrosoft Office Access

oSAS EG Training

oBase SAS Training

oSAS SQL Programming

oSix Sigma Green Belt

oBusiness Object Power User Module

Contact this candidate