Matt Hamm, Developer in Woodstock, GA, United States
Matt is available for hire
Hire Matt

Matt Hamm

Verified Expert  in Engineering

Database Developer

Woodstock, GA, United States

Toptal member since January 16, 2023

Bio

Matt has been a professional for over 25 years, focusing on data modeling and SQL coding supporting enterprise data warehouse development and analytics. His roles have included developer, consultant, trainer, support tech, and manager/leader. Currently, he is freelancing to broaden his horizons and gain exposure to diverse experiences. Matt is seeking data-focused projects which support application development, analytics, and data pipelines.

Portfolio

Wellstar Health System
SQL, Tableau Development, Alteryx, SQL Server, Python, Data Analysis
Aptos
Netezza, ETL, SQL, MicroStrategy, Data Analysis
AT&T
Teradata, SQL, IBM Unica, Data Engineering, Data Analysis

Experience

Availability

Part-time

Preferred Environment

Tableau, Netezza, Teradata, Alteryx, SQL Server 2016

The most amazing...

...data model and ETL process I've built is one to support mid-tier retailer merchandising, leading to better product mixes and higher margins.

Work Experience

Manager, Business Intelligence

2016 - PRESENT
Wellstar Health System
  • Led a team of nine BI analysts that deployed over 60 analytic solutions, primarily using Alteryx, SQL, and Tableau, for an audience of over 3,000 users.
  • Managed all phases of analytics projects, including requirements gathering and visualization design with stakeholders, data engineering, visualization development, rollout and training to end users, and post-deployment support.
  • Trained and guided the team in upskilling in SQL and data visualization best practices and adopting Agile-based project management and solution delivery.
  • Started a Tableau center of excellence to support the hub and spoke model of analytics across the enterprise.
  • Partnered with the clinical data warehouse team to enhance the enterprise data warehouse.
  • Tracked and fixed bugs using ServiceNow as a reporting tool.
Technologies: SQL, Tableau Development, Alteryx, SQL Server, Python, Data Analysis

Senior Manager, Professional Services

2007 - 2016
Aptos
  • Served as project manager and the main point of contact with clients during large implementation projects involving multiple resources, being accountable for delivering projects on time and within budget.
  • Designed and optimized data model and ETL processes for a retail-focused data warehouse implemented on platforms, including Netezza, Teradata, SQL Server, and Redshift, and used them as a foundation for the MicroStrategy reporting environment.
  • Managed all post-implementation client support using Jira as a reporting system, ensuring the timely resolution of operational issues and product defects.
  • Designed and developed the MicroStrategy schema for new modules and the expansion of existing modules, including the warehouse catalog, aggregate-aware logical tables, facts, and attributes.
  • Managed all senior implementation consultants directly and was liable for their performance and career growth, as well as the hiring and onboarding of new consultants.
Technologies: Netezza, ETL, SQL, MicroStrategy, Data Analysis

Data Analyst

1997 - 2007
AT&T
  • Engineered large datasets using SQL to pull data from Teradata EDW for use by the predictive modeling team to predict propensity to buy, likelihood to churn, customer segmentation, and lifetime customer value.
  • Built the marketing data mart using SQL to build attributes. Engineered features sourced from Teradata enterprise data warehouse (EDW).
  • Automated direct marketing campaigns across multiple channels and for various products using IBM Unica software combined with SQL.
  • Provided ad-hoc query support for the consumer marketing department to provide timely insights from Teradata EDW.
Technologies: Teradata, SQL, IBM Unica, Data Engineering, Data Analysis

Consultant and Trainer

1994 - 1997
IQ Software
  • Provided consulting services to clients and end users, building data models and creating reports using IQ Software, one of the earliest reporting software products on the market.
  • Conducted onsite and in-house training sessions for end users on how to utilize IQ Software for reporting solutions.
  • Provided technical support for clients when we encountered issues with the software.
Technologies: SQL, Data Analysis

SQL Developer

1993 - 1994
American Business Products
  • Wrote SQL scripts to convert nightly data processing jobs from mainframe COBOL to Sybase SQL Server.
  • Developed SQL scripts to ingest and convert data for newly acquired printing companies.
  • Provided support for nightly batch data processing jobs.
Technologies: SQL

Data Model for Retail BI

A SQL-based model agnostic to the relational database management system (RDBMS) platform to support retail merchandising operations such as planning, buying, and allocation. I was part of the back-end development team that built a model and ETL components that would map data from the clients' source systems to a standard data model. The data model fed a pre-built BI package built in MicroStrategy. Key components included analyzing sales and inventory data to predict stockouts and overstocks while adjusting for seasonality, recommending purchase order actions, and suggesting when to markdown items.

COVID-19 Data Analysis

In the early days of the COVID-19 pandemic, I used SQL and Alteryx to build data sets used in visualizations to help the health system. The data sets assisted the health care system by managing bed and ventilator availability, monitoring protective equipment supplies, assessing the impact on staffing due to employees being quarantined, and analyzing the financial impacts due to the shutdown of elective care.
1987 - 1993

Bachelor's Degree in Industrial and Systems Engineering

Georgia Institute of Technology - Atlanta, Georgia

AUGUST 2021 - PRESENT

Data Science Micromaster

Georgia Institute of Technology

Tools

Tableau Development

Languages

SQL, Python, R

Storage

Database, SQL Server, Netezza, Teradata

Paradigms

ETL

Platforms

Alteryx

Other

MicroStrategy, Data Engineering, Data Analysis, IBM Unica, Data Science, Machine Learning

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