Brad Hoffmann Email & Phone Number

Indianapolis, In

Build and QA bi-monthly Encounter Data Validation (EDV) reports to be used by State Departments for major health plans across various states• Utilize PowerBI to QA data imports and discover innovative and effective ways to visualize health plan data• Conduct testing, analysis, and data mining of encounter submission and cash disbursements data from health plans and subcontractors during External Quality Review (EQR) audits• Reformat and standardize health plan report layouts with updated style and function

Indianapolis, Indiana

• Collaborated with database administrator to build fact & dimension tables in the data warehouse in order to store construction overhead allocation data using Microsoft's SQL Server Management Studio• Worked closely with SVP of the IT Department to automate reporting for the accounting and construction departments utilizing data and visualization management systems• Created dynamic PowerBI dashboard for the executives so that reporting on job financials is no longer manual process within company