Thomas Houk
Verified Expert in Engineering
Data Analyst and Developer
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
Experience
- Data Analytics - 9 years
- SQL - 8 years
- T-SQL (Transact-SQL) - 7 years
- Business Intelligence (BI) - 7 years
- PostgreSQL - 7 years
- Microsoft Power BI - 4 years
- Python - 2 years
- R - 1 year
Availability
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
Power BI Developer
Harrier
- Improved data integrity and functionality of existing dashboards built in Power BI.
- Designed and developed new data dashboards in Power BI while retaining existing style guides.
- Produced comprehensive documentation outlining the business logic underpinning the back-end systems.
Senior Data Analyst
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.
Graduate Assistant
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.
Experience
Developed a Financial Fraud Detection System
Developed Financial Dashboards
Education
Master's Degree in Business Administration and Computer Information Systems
Emporia State University - Emporia, Kansas, USA
Bachelor's Degree in Information Systems
Emporia State University - Emporia, Kansas, USA
Bachelor's Degree in Business Administration
Emporia State University - Emporia, Kansas, USA
Skills
Libraries/APIs
Complex SQL Queries, Pandas, PySpark, PostgREST
Tools
Microsoft Power BI, Microsoft Excel, Git, Tableau, STATA
Languages
SQL, T-SQL (Transact-SQL), Python, JavaScript, Excel VBA, R, Java, VB, COBOL, CSS, HTML5, Python 3
Paradigms
Business Intelligence (BI), ETL, Entity-relationship Diagrams
Storage
MySQL, Oracle SQL, PostgreSQL, JSON, Microsoft SQL Server, Databases, Amazon S3 (AWS S3)
Frameworks
Windows PowerShell
Platforms
Oracle, Windows, Amazon Web Services (AWS), Salesforce
Other
Data Analytics, Data Engineering, Data, Dashboards, Data Analysis, BI Reports, Excel 365, Data Science, Complex Data Analysis, CSV, Data Reporting, Business, Business Analysis, IT Project Management, Leadership, Communication, Decision Intelligence, Big Data, DAX, Data Visualization, Data Modeling, Entity-relationships Model (ERM), Pattern Analysis, Data Governance, Data Stewardship, Data Strategy, Data Migration, FTP, Data Cleaning, Data Conversion, Finance, Cost Accounting, B2C Marketing, Web Marketing, Web Development, Business Law, Reports, Data-driven Dashboards, Information Systems, Business Administration, Machine Learning, APIs, Data Build Tool (dbt)
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring