Thomas Houk, Developer in Topeka, KS, United States
Thomas is available for hire
Hire Thomas

Thomas Houk

Verified Expert  in Engineering

Data Analyst and Developer

Location
Topeka, KS, United States
Toptal Member Since
May 31, 2024

Thomas is a results-driven data analyst with over seven years of experience delivering innovative, data-driven solutions. He has extensive knowledge in SQL, machine learning, and data visualization. Thomas consistently exceeds client expectations, specializing in fraud detection, system migration, and KPI dashboard development.

Portfolio

State of Kansas
Data Analytics, Communication, Business Intelligence (BI), SQL, Oracle SQL...
Emporia State University
STATA, Python, Python 3, APIs, Excel 365, PostgreSQL, R, Data Science, Pandas

Experience

Availability

Part-time

Preferred Environment

Windows

The most amazing...

...solution I've developed is a forecasting model that predicts monthly economic growth at the local level nine months ahead of national figures.

Work Experience

Senior Data Analyst

2017 - 2023
State of Kansas
  • Migrated federal and state-required reporting from mainframe code to a modern SQL system.
  • Created interactive dashboards to track key performance indicators (KPIs) and guide public policies.
  • Improved application turnaround by 70%, leveraging data and cross-functional collaboration to resolve critical pain points.
Technologies: Data Analytics, Communication, Business Intelligence (BI), SQL, Oracle SQL, Oracle, Microsoft Power BI, Tableau, T-SQL (Transact-SQL), Python, R, Reports, Leadership, IT Project Management, ETL, Data Engineering, Microsoft Excel, JSON, Data, Microsoft SQL Server, DAX, Data Visualization, Dashboards, Data Modeling, Data Analysis, Amazon S3 (AWS S3), Amazon Web Services (AWS), Machine Learning, Databases, BI Reports, Python 3, Excel 365, Data Science, Pandas, PySpark

Graduate Assistant

2015 - 2017
Emporia State University
  • Developed a multivariate time-series socioeconomic model to forecast monthly state economic growth, which accurately predicted a local recession nine months before official reports.
  • Automated the data collection process for the model using Python and web scraping technology.
  • Presented research selected as a grand finalist for the Capitol Research Summit, garnering significant interest and engagement from lawmakers.
Technologies: STATA, Python, Python 3, APIs, Excel 365, PostgreSQL, R, Data Science, Pandas

Financial Fraud Detection System

This project involved leveraging my data analysis and machine learning expertise to develop sophisticated algorithms for monitoring financial transactions in real time. This solution effectively mitigated fraud risk from both the consumer and provider sides.
2015 - 2017

Master's Degree in Business Administration and Computer Information Systems

Emporia State University - Emporia, Kansas, USA

2011 - 2015

Bachelor's Degree in Information Systems

Emporia State University - Emporia, Kansas, USA

2011 - 2015

Bachelor's Degree in Business Administration

Emporia State University - Emporia, Kansas, USA

Libraries/APIs

Pandas, PySpark

Tools

Microsoft Power BI, Microsoft Excel, Git, Tableau, STATA

Languages

SQL, T-SQL (Transact-SQL), Python, R, Java, VB, COBOL, JavaScript, CSS, HTML5, Python 3

Storage

MySQL, Oracle SQL, PostgreSQL, JSON, Microsoft SQL Server, Databases, Amazon S3 (AWS S3)

Paradigms

Business Intelligence (BI), ETL, Entity-relationship Diagrams, Data Science

Platforms

Oracle, Windows, Amazon Web Services (AWS)

Other

Data Analytics, Data Engineering, Data, Data Analysis, BI Reports, IT Project Management, Leadership, Communication, Decision Intelligence, Big Data, DAX, Data Visualization, Dashboards, Data Modeling, Entity-relationships Model (ERM), Finance, Cost Accounting, B2C Marketing, Web Marketing, Web Development, Business Law, Reports, Data-driven Dashboards, Information Systems, Business Administration, Machine Learning, APIs, Excel 365

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring