Peter Deusterman Email & Phone Number

Greater Minneapolis-St. Paul Area

Work contracts using the following technologies: SQL, SSIS, SSRS, Visual Studio, Jasper, TOAD, Microsoft Access and more to create/tune queries/stored procedures, develop/modify/improve reporting, and support clients as needed. I turned a 60 day contract into 18 months with ICF/Olson Marketing, a 30 day contract into 11 months with Olmsted County Government (working remotely), worked a 5 month contract helping Augeo Marketing with their day-to-day duties as they focused on on-boarding a new client, and migrated an Access database for Special Olympics Minnesota.These are all contracts I worked for clients. Robert Half collected an hourly fee for my services and paid me a salary. 1) Larner School of Medicine [University of Vermont] (Dec.2022 - Apr.2023)Upgrade SSIS packages from 2008 version to 2019. Troubleshoot, document, deploy.2) Sundays (Sep.2022 - Oct.2022)Create ad hoc reporting using PostgreSQL and Metabase3) SullivanCotter (Sep.2018 - Jun.2022)Write complex SQL queries and views, adjust and maintain Access reporting & database, create ad hoc reporting and visualizations in Excel, and assist in Power Point presentations.4) Home Buyers Marketing (Mar.2018 - Jul.2018)Get SSRS and SSIS reporting up an running for a company whose previous reporting analyst quit with no notice and no documentation, causing several recurring tasks to cease. I took over the old laptop, got reports out to clients, set up automation, documented the process, and left them with a well-oiled machine.5) Olson Marketing (Jul.2016 - Dec.2017)Wrote SQL complex queries and stored procedures and performed troubleshooting and optimization on existing code. Source control through Jira.6) Olmsted County (Aug.2015 - Jun.2016)Created reporting for the HR department using SSMS, SSRS, and some Access.7) Augeo Marketing (2015: Mar-July)Took overflow work, writing and adjusting SQL code in TOAD.8) Special Olympics MN (2015: Jan-Feb)Updated Access database (from .adp to .accdb)

Greater Minneapolis-St. Paul Area

Creating, maintaining and producing a large volume of reporting to help Ford dealers sell vehicles and service to their customers through the loyalty program TLG operates. Writing and running queries in SQL, using the code to populate SSRS templates, using SSIS to automate the production of several reports for individual dealers (6,000+ reports per week). Producing polished Power Point presentations and other reporting to effectively communicate complicated analytical insights in high-level business language.Data “deep dives” that generated new insights into the customer base or other business functions that presented opportunities for improved efficiencies.

Greater Minneapolis-St. Paul Area

Researching, creating and refining transaction approval rules for debit cards of US Bank as well as many smaller financial institutions to mitigate fraud losses with minimal customer impact. Writing and running queries in SAS and SQL, creating reports in Excel, etc.Spent a significant amount of time on the phone with other departments that handled clients directly, explaining the logic and business needs behind the authorization rules. It was important to be able to clearly explain the utilitarian ideas behind data analytics in a language that was both accurate and easily understood by those who are not mathematicians themselves.Worked with very large amounts of data to find patterns and anomalies through detailed query work and validation/verification.

Englewood, Co

Writing and running queries, views and stored procedures in SQL, creating reports in Excel, monitoring website performance, call center performance, forecasting business for large/key clients, mining for gems in data, finding outliers both good and bad, etc.Used various detailed and complex SQL queries to perform this work. Mastered reading and modifying many different SQL functions as well as writing queries from scratch to accomplish many specific ad hoc requests. Proficient in various criterion techniques in the WHERE clause, JOINs, nested SELECT statements, and many more.