Matt Schultz Resume
Contact
- E-mail: matt@mwschultz.com
- Website: https://www.mwschultz.com
Skills
Languages, Libraries & Frameworks
- Python
-
JavaScript
- jQuery
- React
- Redux
-
PHP
- Laravel
-
Ruby
- Ruby on Rails
-
SQL
- T-SQL
Developer Tools
- Docker
- git
- Heroku
- Kubernetes
- Jira
- GitHub Actions
Business Intelligence and Data Warehousing
- ArcGIS
- BusinessObjects
- Google (Looker) Data Studio
- Microsoft Power BI
- SAS Data Integration Studio
- SAS Visual Analytics
- SQL Server Integration Services
- Tableau
Education and Certifications
North Carolina State University, Bachelor of Science in Biochemistry ITIL Foundation Certificate in IT Service ManagementExperience
-
Data Integration Developer, Civic Federal Credit Union
March 2025 - Current
- Develop ETL pipelines for mortgage data following operational independence from State Employees' Credit Union and the transition to a new core banking system.
- Build out data warehouse focused on analytical reporting from Fiserv DNA banking platform transactional data.
- Improve speed and performance of existing data pipelines by optimizing SQL queries and implementing incremental data loading strategies.
-
Senior Systems Analyst, ElectriCities of NC
May 2024 - March 2025
- Automated data collection to improve auditing of municipalities' electrical utility billing systems.
- Served as liaison between municipalities and commercial software vendors.
- Assisted in monitoring and outreach efforts for municipalities' annual Energy Information Administration (EIA) Form 861 federal compliance reporting.
-
Senior Developer, Duke University School of Medicine, Office of Academic Solutions and Information Systems
December 2022 - May 2024
- Built web services for tracking research effort across both the university and the health system.
- Integrated new tools, including GitLab CI/CD and the OpenShift platform, into existing devops workflows for enhanced developer productivity and application reliability.
- Onboarded and mentored junior developers.
-
Developer, North Carolina State University, Enterprise Application Services
June 2020 - December 2022
- Designed tooling to migrate legacy data and enable ongoing data transfer from internally developed applications into the university’s new vendor-developed research data management system.
- Build initial set of ETL pipelines in SAS Data Integration Studio to capture enterprise data for operational work and reporting, moving from a highly manual process to a series of automated and monitored jobs.
- Retained as consultant to provide customized enhancements as additional modules of the research data management system are brought online.
-
Data Analyst/Developer, Duke University School of Medicine, Office of Academic Solutions and Information Systems
June 2015 - July 2020
- Built Ruby on Rails web services for data sourced from multiple Duke systems, including clinical trials, research finance, and conflict of interest.
- Served as technical lead on the successful multi-year migration of existing enrollment data out of Duke's Epic instance and into a single clinical trial management application.
- Collected user requirements and built reports and dashboards to track research operations data using BusinessObjects and Tableau.
-
Business Analyst, SBG Technology Solutions
December 2012 - June 2015
- Assisted project managers in directing multiple healthcare IT projects for the federal government.
-
Research Associate, TransAnalytics
December 2010 - December 2012
- Developed and maintained interfaces, queries, and reports in Access and Excel for analyzing traffic fatalities from a nationwide geographic database.