Todd Frech
Data Analysis, SQL Scripting, Problem Solving
About Me

I'm an insightful data analyst who has worked with data for more than ten years: compiling, transcribing, querying, auditing, analyzing, designing, and visualizing. I have exceptional skills with Excel, Tableau, SQL (Access, MySQL, Postgres, SQL Server). Working with data has always been one duty of many in my career, and my goal is to make it my only focus. I've built a solid work ethic and sense of self in my customer-focused and supervisory roles. I meet deadlines and deliver what was promised.

I love writing SQL queries just like I love jigsaw puzzles. All the pieces are there: you just have to figure out how they fit together. I've built a great pool of queries, allowing my team to quickly get the information they need in the appropriate format.

I've honed excellent communication skills with a range of users from non-technical to C-level.

When I'm not in front of a computer, I'm often baking or digging for new records to add to my growing music collection.

Projects
Cover art displayed may be NSFW
A web app for lazy days when I want to listen to something but just can't decide. Click for a random item from my collection. Built in Python using Flask, HTML, CSS, JavaScript, and the Discogs.com API.
A series of SQL queries that isolate customer records to be purged from a rental management system. An "as of" date is provided; the scripts identify inactive customer IDs as of said date and delete associated records across dozens of tables in a snowflake-style schema.
Donor History Analysis
An anaylsis and summary report of donor data for a local shelter. Using SQL for analysis and Tableau for visualizations to summarize donor demographics and trends. A volunteer project working with a marketing professional.
ETL
Developed, documented, and maintained ETL procedures for onboarding and deboarding to rental management system using Excel XLOOKUP and Macros, MySQL, and RegEx.
RuPaul's Drag Race Stats
At 14 seasons of the flagship series alone, the reality competition has plenty of data to comb through. Created a MySQL database and collected, imported, and verified data using Wikipedia and first-hand knowledge.