Spencer Cole Email & Phone Number

Chicago, Illinois, United States

• Scripted hundreds of custom SQL data ad hoc requests from clients, leadership, and account management teams• Created, productionalized, and supported custom data feeds supporting >$500k in direct yearly revenue using SQL, email automations, and Python• Automated into production dozens of custom SQL scripts to support local reporting and tools• Compiled older excel documents while increased their flexibility and efficiency by adding additional variables and connecting them directly to server held data• Developed and maintained SQL queries, reports, templates, and dashboards to provide actionable insights to senior leadership, account mangers, SMEs, and procurement specialists• Collaborated with cross-functional teams to define 3 key metrics, 5 KPIs, and reporting requirements to drive business performance improvements and then wrote the core SQL to put them into practice • Analyzed large datasets from Petco to identify customer trends and decision-making behaviors, influencing product placement and shelf space optimization• Collaborated with Petco leadership and subject matter experts (SMEs) to conduct a deep dive into dog food data, leading to strategic insights•Leveraged Dog Food analysis to secure additional contracts for multiple product categories, including Dog Toys, Dog Accessories, Cat Food, Cat Toys, Cat Accessories, and other pet product lines

Minneapolis, Minnesota

• Wrote original back end data templates with Velocity, variable SQL, PySpark, and Python• Integrated John Hopkins Covid-19 data with existing data feeds and built contextual reports• Coded underlying scripts for alpha and beta test applications, then proposed associated efficiency edits• Translated 150+ pages of SQL code from Kognitio to Snowflake• Generated custom in-store coupon banks for 15M members based on 3.5B historical purchases• Wrote the SQL code to create, measure, and control for over a dozen coupon campaigns for different categories and merchants• Transformed raw data and custom data feeds into meaningful visualizations and reports using SQL, Excel, and Power BI• Performed data cleaning and validation using SQL, ensuring data accuracy and consistency for reliable analysis for the data lake and OLAP cubes• Conducted A/B testing and statistical analysis on datasets to make marketing decisions, improve campaigns, and assess marketing efficiency• Taught Excel, SQL, Power BI to junior team members and simplified basics to account managers

Minneapolis, Minnesota

• Constructed the SQL logic, process and report for compliance for the North American automation goals of 2020• Built the bid management process for NA Drop Trailer using macro enabled templates, Sharepoint data lists, and SQL• Automated the historical reports for NA Truckload large bid process with VBA macros that generate dynamic SQL• Designed a user-friendly report for Audit to track red flags in the financial system• Taught and trained new hires on SQL and the system structure

Greater Los Angeles Area

• Created Access databases to process corporate server-side data (T-SQL) on a branch-specific level • Developed two in-depth Excel classes to teach beginning to advanced skills • Completed Excel tools to automate processes, including accounting invoices and sending past due notifications • Produced automatic quoting tools to process and parse complex, multi-part rate sheets, including accessorials • Devised new regional customer based reports and reworked existing reports for a better user experience• Used statistical analysis to create customer specific zone, state, and lane pricing

Greater Los Angeles Area

• Created auto-sorting system to track expiration dates in real time, using Excel VBA• Worked on implementation and integration of the above system• Designed performance graphics and summary metrics for the system• Improved process flow and inventory control metrics

St Louis, Missouri, United States

• Promoted within one month of starting the job• Held three concurrent management roles, two of which were created for me• Designed and implemented an organization system for Student Union Storage• Co-created training materials and developed "How-To" documents for incoming student workers and treasurers

Washington University In St Louis

• Filmboard (Jan 2010 - May 2014)• Active Minds (Jan 20110 - May 2014)• Belegarth Medieval Combat Society (Jan 2010 - May 2014)• Anime Exploration Team (Dec 2011 - May 2014)

Washington, Dc

• Created an in-depth market analysis on the effects of a trial outcome for Intel• Researched and presented investment opportunities, competitors, and Chinese market entry for a green energy startup• Minimized overhead costs by migrating data and optimizing cloud, phone and e-mail services

Bsba (Bachelor Of Science In Business Administration), Operations And Supply Chain Management

Minor in Environmental Earth Science

Education record