Ted Utter
I am an IT and data professional with over 20 years of experience. I have a diverse skill set in data, full stack programming and networking. I’ve done hundreds of data migrations and conversions with accuracy and proficiency along with reliable workflows, ETL processes, and data solutions. I have strong SQL skills in creating queries, reports, stored procedures and views, with additional expertise in Python data libraries for automation and data processing. I have extensive experience in SQL Server and MySQL. I’m at ease working with large enterprises and small businesses alike. I’m passionate about IT and data and an enthusiastic lifelong learner. I’m excited to talk about how I could put my skills to work for you.
- Denver, Colorado 80220
- TedUtter@gmail.com
About Me
Skills
Skills by percentage competency.
Work Experience
Data Developer
2002-2025
- Developed and optimized complex SQL queries and ETL pipelines to collect data from APIs, databases, JSON, and XML into SQL RDBMS improving client processes, saving time and increasing accuracy
- Cleaned and transformed data using Python scripts and SQL stored procedures
- Streamlined client data processes using Python to ingest data from APIs, transformed data with python and SQL reducing manual work and delivery time
- Built and maintained JasperReports to meaningfully display client data and reveal business insights
- Gave management progress analysis tools through PHP based reporting tools for process and work queue monitoring
- Maintained and updated data driven PHP and Java based web application
- Established and monitored data replication between remote and data center locations
- Orchestrated complex scheduled processes to move data through various stages
- Analyzed complex data and developed migration and conversion plans for large Fortune 500 enterprises
- Migrated physical servers to virtual environments using both Hyper-V and VMWare platforms
- Developed SQL queries to improve efficiency in implementing data systems by targeting relevant components drastically cutting implementation time
- Reliably maintained critical business infrastructure, networks, systems, databases and websites in a 24/7 data center environment
- Built PHP/SQL Server based vendor management application to add customer records, associate vendors and automate emailing vendor rebates
Field Engineer | Data Conversion Engineer
1997-2001
- Performed data conversions for TREEV Content Management systems
- Converted legacy TREEV system data to import into latest TREEV systems
- Analyzed data, developed a conversion strategy and processed scripts to convert data
- Worked with customers to develop data layout for their new systems
- Supported team of Field Engineers performed implementation of document imaging systems
- Completed professional implementation of TREEV document imaging systems
- Visited banking industry customers onsite to perform hardware/software setup, customization, and training to customer specifications
My Portfolio
Here are three of my projects. I hope to add to this section soon. Please stay tuned!
Python API ETL and MySQL
Watch me explain how I was able to automate billing for a client using the Order Desk API, Python and MySQL. I was able to automate a manual process to save a bundle of time while making billing more accurate. This project uses pandas, json, sqlalchemy, requests, regular expressions, openpyxl libraries and more in Python. View the source code on Github: https://github.com/tedutter/OrderDeskAPI
Tableau Visualization
Featured below is a dashboard created in Tableau showing year over year sales information with data collected from the Order Desk API. This visualization shows changes in sales current vs. previous year with a selectable year parameter. The left half shows the best performing products for the selected year and the bottom left shows a comparison with the previous year sales for the product. The right half shows the best performing vendors for the selected year. The bottom center features month by month comparison for total sales of the selected year and the pervious year. The bottom right shows current vs previous year comparisons by top 10 vendors. Hovering over the bottom middle month on the graph will change the graph to the right and left to show performance for a given month current vs previous year.
Power BI Visualization
This visual below is a sales dashboard created in Power BI. This report captures top performing products, brands and vendor booths at the event. Also shown is the best customers and best selling reigns and districts. Visit my Github page to get all the details on this project including the SQL queries for cleaning and analysis: https://github.com/tedutter/TradeShow
