Matthew Hamilton Email & Phone Number

Chicago, IL, US

US

US

• Led sanitized data layer buildout for US Telecom for near real-time customer journey analysis. Processed >1TB data/day using PySpark, BigQuery, DBT, and Airflow. Rewrote data science POCs, reducing model runtime by ~96%.
• Built reporting for a promo optimization tool at a global CPG manufacturer. Completely replaced prior underlying Databricks data model and DAX measures to improve rendering times by 60-90%. Added logging to catch.
• Built tools in PySpark to quickly generate GBs of complex, realistic synthetic data. These datasets supported Digital Twin visualization demos at clients, speeding up visualization feedback.

Seattle, WA, US

• Migrated healthcare data from Lotus Notes to Salesforce using SSIS and SQL Server. Worked with Salesforce team and client to develop a denormalized schema for the information. Handled corrupted input files, fuzzy.
• Taught an “Intro to Python” course to Associate Consultants, going over basics of data analysis and data visualization. Ran weekly TA sessions focused on coding design considerations. Additionally, introduced.

Chicago, IL, US

• Automated AWS deployments using CloudFormation and CodePipelines. All core projects now generate at least a dev and prod environment, allowing much quicker and less painful deployments of upgrades.
• Rebuilt AWS security to significantly reduce limit unnecessary access to AWS resources using Network ACL and security groups. Projects now default to using their own unique security group allowing access only to other.
• Orchestrated all AWS ETLs through Airflow, using custom operators. Operators include wrappers around Lambda, Glue, EMR, and ECS, as well as higher-level operators controlling extraction from database types to S3 and.
• Having tagged resources either through Airflow or CloudFormation, created report that would identify old dev environments and orphaned resources. Deletion of those resources reduced costs by ~12%.
• Optimized Redshift instance by running “analyze compression” and following suggestions as well as making use of sort- and distkeys more frequently. This resulted in substantially increased performance for a few of our.
• Created common resources such lambda layers, a base lambda docker image, and an AWS utility package, substantially decreasing the amount of duplicate and near-duplicate code being deployed. Also replaced many per-table.

Chicago, IL, US

• Led the infrastructure rebuild of the Performance Management department. Created and integrated tools on the department server for automating emails, simplifying my AWS Redshift uploads, managing credentials, email.
• Revolutionized the department’s main workflow’s to <5% reliance on Microsoft Excel. Working with IT I gained access to new data sources to avoid using canned reports and taught other analysts how to use libraries like.
• Built and optimized daily data extraction from every department including emails, Excels, PowerPoints, PDFs, websites, databases, and custom applications. This allowed a 40-page PowerBI report presenting two years of.
• Created a model that predicted the top 10 individuals most likely to have an “unexpected” absence. Averaged 70% accuracy.
• I created both a tool to automatically generate the daily train schedule by automatically parsing PDFs and Word documents. In addition, I created a calendar displaying the service changes for each line. Previously.
• Expanded my reporting to include many interactive web tools, allowing individuals to see trends and metrics unavailable in the standard 3rd party reports. One of the results has been a decrease in the amount of overdue.

Chicago, IL, US

• Created a program to identify uncommitted work and regularly email each analyst to save their code on a remote server. This helped protect the department from accidental code/resource deletion and ensured better.
• Developed an application for replacing the paper terminal logs. The tool cleanly integrates existing operations and maintenance data source, and other users’ data to help supervisors monitor and quickly restore rail.
• Created and automated multiple reports for Maintenance Departments that are used to perform Preventative Maintenance of CTA vehicles. This automation saves ~2 hours per day of managers’ time that can now be used to.

Chicago, IL, US

• Created a framework for quickly uploading data to our Redshift database, increasing data report reliability and reducing workload across the department. The framework was coupled with a site for an executive overview.
• Created numerous automated reports designed to both supplement PM meetings and to give Garage Managers easy access to day-to-day information. In the field, these reports have improved vehicle cleaning across the fleet.
• Introduced the use of larger datasets and more advanced statistics to the department. This includes a revenue report that uses multi-level seasonal adjustments to demonstrate trends in revenue and ridership, as well as.
• Created a model using neural networks which uses garage and individual characteristics to predict how many and at what time absences will occur in the next day. This allows managers to decrease the number of lost runs.
• Shared my programming knowledge to support other members of the department. I used U+200B to help others with formatting in PowerBI, scraped websites for the daily Flash report using Selenium, and recovered lost.

Chicago, IL, US

• Created product software for automated reporting and predictive failure models incorporating machine learning methodology.
• Automated data gathering to monitor train schedule accuracy and passenger load reporting.
• Using Twitter and Facebook API's, generated automated customer satisfaction reports through social media engagement.

Chicago, IL, US

• Undergraduate position in research group led by Steven Levitt (author of Freakonomics).
• Collaborated with graduate students, responsible for project delivery under tight timelines.
• Using the programming language Python, created tools that organized and documented experimental data used in group research.
• Optimized data acquisition to improve the speed of data entry and reduce database errors.

Chicago, IL, US

• Jeff Metcalf Internship in team responsible for:
• Designing and distributing promotional literature for large college events involving >100 alumni/faculty and >1000 students.
• Contacting and persuading alumni and faculty to participate.
• Mitigating last minute issues at events.
• Reconciling budgets with planned activities.
• Addressing questions and concerns of parents.

Chicago, Illinois, US

• Collated and analyzed academic articles for use in literature reviews.
• Independently automated data entry from 2 minutes per manual entry to ~6 seconds with minimal supervision.
• Created programs to collate and analyze data using R and Stata programming languages.
• Helped organize and worked on a number of field experiments between September 2015 - November 2015 which involved door to door consumer surveys.
• Participated in weekly research meetings with faculty and graduate students.

Greenwood Village, CO, US

• Primary contact for guests arriving at the Roosevelt Lodge in the evening and overnight.
• Addressed questions and concerns of visitors.
• Watched out for wild animals and called park rangers as needed.
• Cleaned and maintained lodge public facilities.
• Created Excel spreadsheet to explain employee time and activities to support facility budget.
• Willingly accepted the jobs nobody else wanted to do (cleaning bathroom grout, etc.).