Nicholas Hettinger Email & Phone Number

Louisville, Kentucky, United States

Client: Quantix SCS, LLC-Consult with client regarding report results and revisions-Troubleshoot and optimize existing reporting processes (invoice delivery, daily unbilled, weekly unbilled, statement of accounts)-Anticipate and conceptualize reporting needs

Client: National Institutes of Health, Office of Management, NIH Business System (NIH OMNBS)-Create eLearning resources (presentations, documentation) used for training users on theNBS system-Consult with subject matter experts regarding best practices, revisions, and processimprovements-Engage in QA testing (SIT and UAT)

Project: Calculate uninsured/underinsured premium cost for client broken down by vendor. Thisproject will help a team of account managers to provide a detailed breakdown of the coveragecost to the client and enable them to generate reports automatically from monthly data.-Write VBA code to cleanse client data and import into Access database-Write SQL query.

-Use Excel to create reports and metrics for internal use and client presentation-Write VBA scripts to streamline workflow-Data management and support for the Velocity database system-Create import and export data templates-Update the Velocity user manual and create training instructions for claims submission-Quality control and importing of large datasets.

Client: National Institutes of Health, Office of Financial Management (NIH OFM)Project: Create data models for IPAC (Interagency Payment and Collection) and CommercialInvoices dashboards in Power BI. The purpose of this project was to streamline the currentprocess for simplicity and provide improved dashboard visualizations.-Examine Access VBA code of.

Louisville, Kentucky Area

- Analyze research results for conflicts issues and create exposure lists for staff checks- Conduct outreach with internal staff and candidates to settle conflicts issues- See my previous title below for additional responsibilitiesProject: Co-manage the completion of conflicts checks for 60+ new incoming associates into thefirm (fall 2019)-Receive and.

• Perform research for new business and associate intake to identify potential conflicts of interest
• Write SQL queries to create client profile, matter and related party reports
• Create and upload Excel data templates into the Conflicts database
• Update data and troubleshoot errors in Conflicts database

• Utilize enterprise and client databases to obtain information on member policies
• Research and validate member information through letter correspondence and phone calls to insurance clients, members and providers
• Analyze EOBs, NAIC guidelines, MSP provisions, plan language and state regulations to determine coordination of benefits primacy and recoverable claims
• Identified at least $154K in overpayments

• Find investigations that contain potential recovery revenue to help the CAQH team pursue claims
• Created a new method of inventorying Outlook email requests that is‭ ‬57%‭ ‬faster.‭ ‬Automated the process to be quicker and more efficient
• Troubleshoot small computer issues to keep the audit support unit running‭
• Train coworkers on Microsoft Excel to make investigation reassignment quicker and more efficient
• Research information for auditors to assist in the recovery process
• Created support documentation for the investigation reassignment process

Frankfort, Kentucky

• Analyze oral history interview files and summarize to aid researchers
• Uploaded excel templates into the Pass the Word database for public access
• Finished Pass the Word project deadline ahead of schedule

Bachelor Of Arts (B.A.), History, Business Administration, 3.73/4.00

Front End Development

Learned HTML, CSS and JavaScript through online coursework and mentor guidance. For my final project I completed a redesign of the Oldham.