John Edman Iii Email & Phone Number

Minneapolis, MN, US

Minneapolis, Minnesota

* Create data pipelines using SSIS and C# to pull data into our internal SQL Server database* Work closely with data analysts to direct towards proper data sources, improve query efficiency * Assess and improve data quality through both manual and automated processes* Train new fellows on SQL basics and act as Point person for any SQL-related questions*.

Springfield, Missouri

* Pulled in data from a variety of different data sources including DB2 and Postgres* Implemented mappings/workflows to automate data load/transform processes using Informatica based on business reporting needs * Performed validation checks using R Scripts* Tracked project progress through Jira* Transitioned from ETL to ELT process, allowing for more.

Jefferson City, Missouri

• Contracted by Missouri Department of Revenue to implement fully integrated tax processing system – went live with business tax in September 2017
• Developed business rules for individual income tax
• Extensively utilized SQL on relational tax database to diagnose and repair issues through data queries and manipulation
• Provided quality assurance on bug fixes through application testing and SQL queries
• Addressed questions and concerns from the client as they used the system

Poway, California

• Identified best-fit teams for minor league free agents based on team needs, projected depth charts, and player goals
• Conducted research to gather and compile historical salary data on the MLB draft. Information was used to guide contract negotiations for clients in 2014, 2015, and 2016 drafts
• Created a data-driven presentation used by the Weisz Sports agency to sign NFL coaching client

Greater San Diego Area

Attended Major League Scout School, October 2016 Selected projectso Evaluated independent league stats to identify potential prospects, resulting in player signingo Analyzed collegiate summer league stats, neutralizing stats to allow year-to- year comparisonso Looked for correlations between different throwing programs and pitcher performance/durabilityo.

Wheaton, Illinois

- Assisted with instruction of Math for Elementary Education (Fall 2014, 2015)- Lead weekly study sessions to assist students with course material- Grade weekly quizzes and homework assignments for class of 30 students- Assisted with instruction of Programming I (Spring 2015, 2016)- Guided students with lab work on a weekly basis- Assisted with instruction.

- Provided live statistical updates during Wheaton football, soccer, and basketball games- Managed social media (Twitter and Instagram) for fans following sporting events online

- Tutored junior high and high school students in mathematics and standardized testing- Weekly tutoring through World Relief, Fall 2012 – Spring 2013

New Brunswick, New Jersey

- Performed sensitive research using combinatorial experimental design on walk-through metal detectors at large events- Presented results to several groups including the Rutgers University Police Department

La Jolla, CA

- Spent the summer of 2012 and 2013 working at a six-week long day camp.- Led group of campers between the ages of 5 and 10 during daily activities and weekly field trips.