Summary
Overview
Work History
Education
Skills
Timeline
Generic

Doug Abraham

Randolph,WI

Summary

Detail-oriented, organized and meticulous employee. Works at fast pace to meet tight deadlines. Enthusiastic team player ready to contribute to company success.

Overview

20
20
years of professional experience

Work History

Business Analyst II

Hewlett Packard via Tek Systems
12.2013 - 12.2015
  • Report development and datasets using tools including Oracle SQL DB, Business Objects and Java Support aspects of the SDLC, including UAT with model office and insure timeliness and accuracy on deliverables Develop and maintain internal and external relationships to manage scope, schedule, budgets and expectations.
  • Actively participated in team meetings to share knowledge, exchange ideas, address challenges, and collaborate on potential solutions.
  • Developed high-quality documentation to support training efforts, helping employees fully understand new systems and procedures.
  • Interacted with internal customers to understand business needs and translate into requirements and project scope.

Business Intelligence Analyst

Beaver Dam Community Hospital
02.2016 - 04.2024
  • Support and UAT for software application upgrades ETL loads using SSIS and database maintenance and troubleshooting using best recommended practices Report development and datasets using BI tools including Power BI, SQL Server, SSRS, SAS, Excel VBA and C
  • Reduced manual data entry errors by automating routine tasks using SQL scripts and ETL tools.
  • Designed customized data collection models for specific visualization tasks.
  • Participated actively in stakeholder meetings, presenting data-driven insights and recommendations to support business growth initiatives.
  • Standardized best practices in report generation across departments to ensure consistency in presentation formats as well as analysis methodologies employed.

Production Analyst

Wisconsin Physicians Service (W.P.S)
12.2011 - 06.2013
  • Monitor production report data to determine trends and potential problems using tools including Cognos and Excel VBA Collect daily, weekly, monthly and quarterly statistical reports from supervisory areas for accuracy and assure contract obligations were met Analyze production data and provide system improvement recommendations

Edit Analyst II

Wisconsin Physicians Service (W.P.S)
01.2004 - 12.2011
  • Maintain detailed knowledge of contract claims processing and procedures, regulations and requirements Identify and solve coding issues with procedures and diagnosis HCPCS, ICD9, EDI for accurate statistical data in compliance with contract specifications and guidelines for annual budgeting Train staff to assist with high volumes of claims to meet deadlines and solved problems with provider coding errors

Edit Analyst I

Wisconsin Physicians Service (W.P.S)
12.2003 - 01.2004
  • Process insurance claims for potential duplicate payments Resolve assigned edits per review to apply appropriate allowable fees and rate program review in accordance with contract regulations and guidelines Perform mathematical calculations including percentages and OHI (Other Health Insurance) payments

Software Engineer

Marshfield Medical Center - Security Health Plan
03.2022 - 04.2024
  • Worked with software development and testing team members to design and develop robust solutions to meet client requirements for functionality, scalability, and performance.
  • Consistently met project deadlines by effectively managing time and prioritizing tasks according to importance.
  • Analyzed proposed technical solutions based on customer requirements.
  • Developed scalable and maintainable code, ensuring long-term stability of the software.
  • Collaborated with management, internal and development partners regarding software application design status and project progress.
  • Established efficient communication channels within the team, leading to better collaboration among members during project development phases.

Education

MBA Business Administration - Business Administration

Lakeland College
Madison, WI
11.2015

BA Business Specialized Administration -

Lakeland College
Madison, WI
11.2013

AA Information Technology Visual Communications -

University of Phoenix
Madison, WI
11.2009

Skills

  • Professional
  • Verbal and written communication
  • Root cause analysis
  • Problem solving and detail orientated
  • Technical
  • Java
  • C#
  • Python
  • Microsoft Excel
  • VBA Macros
  • Business Objects
  • SQL Server
  • SSIS
  • Oracle SQL DB
  • Javascript
  • SQL
  • Object-Oriented Programming
  • Software Development Lifecycle
  • Team Collaboration
  • Agile Methodologies
  • Front-End Development
  • Code Development

Timeline

Software Engineer

Marshfield Medical Center - Security Health Plan
03.2022 - 04.2024

Business Intelligence Analyst

Beaver Dam Community Hospital
02.2016 - 04.2024

Business Analyst II

Hewlett Packard via Tek Systems
12.2013 - 12.2015

Production Analyst

Wisconsin Physicians Service (W.P.S)
12.2011 - 06.2013

Edit Analyst II

Wisconsin Physicians Service (W.P.S)
01.2004 - 12.2011

Edit Analyst I

Wisconsin Physicians Service (W.P.S)
12.2003 - 01.2004

MBA Business Administration - Business Administration

Lakeland College

BA Business Specialized Administration -

Lakeland College

AA Information Technology Visual Communications -

University of Phoenix
Doug Abraham