Thomas a. abt

*** **. ****** **. ********** PA **223 Phone: 412-***-**** ac03yr@r.postjobfree.com

Objective

My goal is to obtain a position in which I may combine my education and work experience to be a valuable contributor to a team and organization. I hope to continue to expand my knowledge of systems, processes, and applications in order to improve my current methods for data management and analyzation.

Expertise Highlights

Database Design & Management

Testing/Scripting/Documentation

Data/Business/Systems Analysis

SQL Queries

Oil and Gas Industry Knowledge

Reporting/Analytics (Tableau and other platforms)

Testing/Scripting/Documentation

Technical Writing (Manuals/System Specs)

Experienced with Well Completions

Healthcare Knowledge

Education:

ROBERT MORRIS UNIVERSITY– PITTSBURGH, PA

-Bachelor of Science in Professional Communications/Info System (BSPCIS), 2010

Professional Experience

Staffmark –Allegheny Health Network 06/2016– 9/2016

Reconsolidation of data through system conversions.

Key Results:

Identify deficiencies in data pulls.

Use data pulls to create metrics dashboard to be used by upper as management. As well as produce a deliverable report to be delivered to other operations area.

Worked within the ACA individual market and small group business

Staffmark -Lead Data Analyst – Highmark Blue Cross Blue Shield 06/2016– 7/2016

Consulting position to consolidate data files to post to Tableau dashboard

Key Results:

Identify deficiencies in data pulls.

Use data pulls to create metrics dashboard to be used by upper management. As well as produce a deliverable report to be delivered to other operations area.

Worked within the ACA individual market and small group business

Provided effective Tableau dashboard and report based on consolidated data summaries within 1 month of contract working with the management of a recently created department.

Cornerstone Consulting: (Gateway Health) BUSINESS ANALYST – Pittsburgh, PA 12/2015 – 2/2016

Worked with health care management to identify risk factors and potential candidates for additional managed care.

Key Results:

Reported findings for gaps in coverage for Medicaid and Medicare members using SAS Enterprise Guide and SQL

Used the results to identify candidates for additional managed care based on risk factors.

Seneca Resources – McCandless, PA 8/2011 – 9/2015

Lead Technician-Operations

Assign projects to the most qualified technician

Provide assistance to the technicians to ensure projects are completed and accurate

Work with management to determine if improvements can be made to processes

Identify data management solutions to allow for self-service reporting

Develop and maintained an organized data store for completions data

Provide completions reports to engineers and upper management

Provide completions reports to engineers and upper management

Assist Engineers with analysis of completions data

Provide budget and cost forecasts

Working in operations I would gather business requirements based on the end users need.

Summary:

Started employment at Seneca Resources as a completions engineering tech and took on the responsibilities of production tech. Following the consolidation of the engineering techs I was promoted to Lead Engineering Tech, which included hiring and managing new engineering techs.

Blue Cross Blue Shield – Pittsburgh, PA - Operations Decision Support Consultant5/2001 – 8/2011

Advanced to Operational Decision Support Consultant through ability to create large data stores and use this data in the creation of metrics and inventory reporting. Much of the success in this position is due to the ability to work within project teams and provide accurate results and meet project deadlines.

Key Results:

Develop forecast models based on established metrics

Provide additional analytic packages for established metrics in order to determine drivers outside range of expectations and propose procedural improvements

Coordinate the creation of operational data stores for reporting and analytics

Provide trend analysis and forecasting to business areas to address necessary staffing needs and inventory impacts

Coordination of new group implementation

Departmental volume and metrics reporting using different SQL tools

Create and maintain departmental web pages

Coordinate Audits, produce trending reports, and improvement processes

Responsible for business continuity planning, including pandemic and site outage planning.

Responsible for the development and delivery of training and assistance to staff

Metrics and inventory report creation and delivery

Providing immediate support to the adjustment staff

Responsible for the preparation of unit documentation and procedural formatting

Testing new versions of MS Office in addition to claims processing testing when Highmark moved to a new claims processing system (OSCAR).

Used Cognos Impromptu and Cognos Web reporter to provide reports to operations departments

Assisted in the conversion of Impromptu reports to Cognos Web Reporter

Summary

Started at Highmark as a customer service representative and moved to a claims adjustment position. Following my position as a claims adjuster I worked as a quality analyst before moving to a business analyst role and finally ending in the role of Operations Decision Support Consultant.

Technology Summary:

Applications:

Microsoft Office: (Access, Word, Excel, Access, PowerPoint, Visio), Cognos, SAS, SQL, Dreamweaver, Qlikview, Wellview, SharePoint, OFM, Wellspring (Enersight), Tableau

Languages:

C, C++, SQL, BASIC, HTML, VBA, and limited Java

Contact this candidate