Hans Dirkmaat, Cpa, Mba Email & Phone Number

Longmont, CO, US

Longmont, Colorado, United States

• Identified over $4M savings annually through product technical improvements using SQL and modeling
• Saved 32 hours weekly for immediate team through automations and technical process improvements
• Provided technical mentorship to analysts through teachings of SQL, Google BigQuery, and Google Sheets
• Subject matter expert for the two main business lines to advance the product experience and increaserevenue through analyses on daily activities, retention, churn, and user journey with actionable insights to influence.

Longmont, Colorado, United States

Built and maintained relationships with businesses to sell out products within Denver and Northern Colorado.

Remote

• Impacted by restructuring layoffs.Owned process for development of advertiser recommendations for Sales to pitch to customers.
• Evaluated existing dashboards and improved or deprecated them depending on need determination.
• Represented Global Business Group for ad solutions to improve tools for Sales.
• Worked cross-functionally with global workers to ensure unified guidance for ad solutions.
• Served as point of contact for 5 dashboards and resolved issues when they arose.
• Provided design ideas that were implemented to strengthen trust end users had in the tools.

Remote

This was an internal promotion from within the Cigna/Evernorth family.

Work From Home

• This is a subsidiary to Cigna.Created Tableau reports for different business segments to move away from traditional Excel methodology.
• Expanded and developed metrics and information presented to stakeholders to allow for deeper analysis todetermine success or failure of a program.
• Investigated and resolved any data issues and determined correct data sources for projects.
• Negotiated contract rates in 2021 with seven vendors based on the member utilization and modeled futureutilization, which led to a minimum $6M in savings for 2022.
• Used SAS, SQL Server, and Teradata to transform and “clean” data to be more presentable and accurate.
• Created financial models to determine success of supplemental benefits and 8 other healthcare programs (ex:occupational therapy, home health, physical therapy, etc.).

WFH - Houston, TX

• Created financial reports and dashboards for various HCA financial and operational departments using SAP Business Objects, SQL Server, and Teradata. Additionally, created dashboards in Tableau and PowerBI.
• Analyzed and interpreted financial data for areas such as acquisitions, insurance, and collections.
• Communicated with HCA clients in an effective manner to determine if needs were met and explained theresults produced on reports.
• Trained co-workers on relevant technology to ensure educational progression of department.
• Created and automated processes for executives to provide additional information for improvement to therevenue collection process to determine which accounts should be priority.

WFH In Nashville

Nashville, Tennessee

• Performed assessments of complex company IT initiatives and operational areas. Examples include:
• Assessed the new company ledger controls and determined if calculations were performing correctly
• Determined if Sarbanes-Oxley controls were effective for the fiscal year, which included user access,change management, Active Directory security, termination testing, and various other application controls
• Determined and assessed applicable laws for compliance (i.e. HIPAA, GDPR, MU)
• Assisted in determining the best course of action for cybersecurity incident responses within HCA.
• Utilized Business Objects, Teradata, SQL, and Tableau to assess large data sets for various audit scopes.

Greater Nashville Area, TN

Duquesne University

I am currently assisting in a research on how individual users validate the credibility of Wikipedia users and their arguments on Internet posts.

I am currently assisting in SharePoint security and designing KGC's website on SharePoint 2013.

I worked as a Project Management Intern. I worked with SharePoint to condense programs that contained over 500,000 files, was a manager on four programs, and attended several trainings involving project management and programming.

I am assisting in building a computer system for the aviary as a service learning project.I was on the functional team for one year and now I am the campus client representative for the project.

I prepared wealth management account taxes.

I processed and paid university bills.

Bachelor’S Degree, Accounting And Information Systems Management

Magna Cum Laude

Master Of Business Administration - Mba