T E D U T T E R

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.

Download Resume

About Me

My Skills and Experience

Skills by percentage competency.

SQL

0 %

Python

0 %

APIs

0 %

ETLs

0 %

Docker

0 %

Git

0 %

OOP

0 %

PHP

0 %

Reporting (Power BI, Tableau)

0 %

AWS (S3, Glue, Athena)

0 %

Data Developer

2002-Now

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

My Projects

Here are my first two projects. I hope to add to this section soon. Please stay tuned!

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

This is a basic 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