Ryan Dingess
Summary
Accomplished SQL Developer with extensive experience at Metropolitan Family Services, adept at crafting complex queries and optimizing data processes. Proficient in MS-SQL Server and Power BI, I excel in delivering accurate reports and collaborating effectively with cross-functional teams to drive project success. Strong analytical skills enhance my ability to meet tight deadlines.
Overview
17
17
years of professional experience
Work History
Sr. SQL Developer
Metropolitan Family Services
Chicago
11.2020 - Current
- Company Overview: Metropolitan Family Services is a non-profit organization specializing in behavioral health studies and treatment.
- Wrote complex queries to join tables for output into reports.
- Managed several different SQL server databases within QA and PROD environments.
- Performed regular maintenance of scripts to ensure accuracy of data.
- Worked closely with the applications team to ensure accurate data and timeliness of project completion.
- Designed and developed nightly server jobs and ETLs to migrate data between different sources.
- Ran daily reports and scripts for download to FTP and import to state portal.
- Developed Tableau reports using data from the EHR billing system.
- Developed an app for refreshing document and PDF data.
- Scripted upload and import of XML data to FTP through SSIS.
- Worked with clinicians and higher ups to understand data from both a backend and front-end perspective.
- Assisted with new applications deployments to meet tight deadlines.
- Helped to manage the implementation of MSPs and regular database backups.
- Metropolitan Family Services is a non-profit organization specializing in behavioral health studies and treatment.
SQL Developer
SellersCommerce, LLC
Northbrook
03.2012 - 04.2020
- Company Overview: SellersCommerce is an e-commerce firm specializing in online stores that cater to the Tactical, Industrial, and Hospitality uniform industries.
- Managed SQL project involving Pro Wear Uniforms employee allowance data.
- Used PostgreSQL and custom .NET code to import data into PostgreSQL, output data, perform math calculations, and import data with improved accuracy.
- Maintained SSIS packages and server jobs to handle financial data for payroll deduct and allowances.
- Wrote reports in T-SQL for managers and end users.
- Designed and Developed Staging tables, SQL queries and stored procs for nightly server jobs.
- Configured and maintained APIs for managing credit card data and updating databases.
- Designed and implemented database backup and recovery strategies.
- Designed, developed and implemented processes for backup up and storing data.
- Assisted with QA of data on the front end to ensure accuracy.
- Experience in server job monitoring activities and support tickets.
- Worked on solving tickets and meeting SLAs.
- Created PL/SQL scripts to extract the data from the operational database into clean reports for managers and end users.
- Wrote server jobs using SQL, PL/SQL, stored procedures, functions, and packages to migrate data from SQL server database to Oracle database.
- SellersCommerce is an e-commerce firm specializing in online stores that cater to the Tactical, Industrial, and Hospitality uniform industries.
SQL Developer
Integraphix
Palatine
10.2011 - 03.2012
- Company Overview: Integraphix was a small local business dedicated to the management of both local and national business websites and data.
- Built out databases, ETL processes and data warehouses for both local and national businesses.
- Developed reports for use with Power BI and Tableau.
- Wrote applications for local businesses with T-SQL and Visual Studio.
- Integraphix was a small local business dedicated to the management of both local and national business websites and data.
SQL Developer
Lasalle Futures Group
Chicago
10.2008 - 09.2011
- Company Overview: Lasalle Futures Group is a Chicago based commodities brokerage focusing on financial investments in the stocks and commodities industries.
- Wrote and managed T-SQL queries, server jobs and stored procedures in SSMS for the financial markets.
- Developed reports for uses with Power BI and Tableau.
- Managed T-SQL and PL SQL scripts behind applications for stockbrokers to manage investment and financial data.
- Wrote queries to extract reports between Infusionsoft CRM database and local hosted databases.
- Managed scripts for CRM data and wrote stored procedures for handling input and update of data.
- Lasalle Futures Group is a Chicago based commodities brokerage focusing on financial investments in the stocks and commodities industries.
Education
Bachelor - Arts
Judson University
IL01.2004
PHP Certificate -
LinkedIn Learning
JavaScript Developer -
LinkedIn Learning
Tableau 48 Hour Certificate -
Skills
- RDBMS/DBMS
- MS-SQL Server 2014
- MS-SQL Server 2022
- Oracle 19
- SQL
- PL/SQL
- XML
- HTML 5
- CSS
- JavaScript
- Shell/Bash Scripting
- XML Scripting
- MS Office
- Visual Studio
- SSMS
- Visual Cron
- Azure Data Studio
- Microsoft Fabric
- Power BI
- Linux
- Windows
- MS SQL Server
- Oracle
Timeline
Sr. SQL Developer
Metropolitan Family Services
11.2020 - Current
SQL Developer
SellersCommerce, LLC
03.2012 - 04.2020
SQL Developer
Integraphix
10.2011 - 03.2012
SQL Developer
Lasalle Futures Group
10.2008 - 09.2011
Bachelor - Arts
Judson University
PHP Certificate -
LinkedIn Learning
JavaScript Developer -
LinkedIn Learning