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 to join data from multiple tables to create the desired datasets-Generate reports and dashboard data from queries-Use python for data analysis on exported spreadsheet reportsProject: Implement systems transition from Velocity to Epic. This project is intended to transitionthe legacy ERP system of The Underwriters Group (Velocity) to the one being used by the newparent company, Higginbotham (Epic).-Translate data fields from Velocity to Epic-Coordinate with business intelligence contractor regarding data export testing-Analysis and quality control of data exportsI also provide onsite IT support and analysis services (reports, metrics, process optimizations,dashboards with Power BI). Products supported include Outlook, Teams, Zoom, Okta, Citrix,Microsoft Office, Epic, Onbase, and Onedrive.See below for other duties.

-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 into Velocity-Implement quarterly account audit process-Assist with bookkeeping for surplus lines taxes-Create automation process in Velocity for Higginbotham captive insurance program-Track MVR report expenses and analyze with Python*Inactive during my time at GlobalTekForceCom*

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 current process and conceptualize a new reporting processfor the Power BI dashboards-Create Visio diagrams of the data models for each dashboard-Analyze SQL Code and translate it into PowerQuery for each table and query of the datamodel-Create technical documentation regarding the structure of PowerQuery M language andSQL to PowerQuery translation process.

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 review project requirements from team manager and supervisor-Review intake group outreach to candidates. Verify that all employment and matterinformation is accounted for-Distribute work to team members-Interface with team members and management regarding status, roadblocks and processchanges

• 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.