Matt is available for hire
Hire MattMatt Hamm
Verified Expert in Engineering
Database Developer
Location
Woodstock, GA, United States
Toptal Member Since
January 16, 2023
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, Alteryx, SQL Server 2016, Python 3, 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, Alteryx, SQL Server 2016, Python 3, 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
Experience
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.
Skills
Languages
SQL, Python 3, R
Storage
Databases, SQL Server 2016, Netezza, Teradata
Paradigms
ETL, Data Science
Other
MicroStrategy, Data Engineering, Data Analysis, IBM Unica, Machine Learning
Tools
Tableau
Platforms
Alteryx
Education
1987 - 1993
Bachelor's Degree in Industrial and Systems Engineering
Georgia Institute of Technology - Atlanta, Georgia
Certifications
AUGUST 2021 - PRESENT
Data Science Micromaster
Georgia Institute of Technology
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