Supply Chain Data Team Lead

• Oct 2022 - Present

Senior Supply Chain Analyst

• Jun 2021 - Oct 2022

Supply Chain Analyst

• Oct 2020 - Jun 2021

Business Analyst

• Apr 2020 - Oct 2020

Fixed regular data disparities between segments of the daily and weekly sales and inventory data pipelines.Improved accuracy of scheduled data workflows by updating and cleaning SQL and Python code.Worked in Airflow, S3, Redshift, Tableau, Microsoft SQL Server, and Excel.Communicated data integrity issues and implications with team members.

Business Analyst

• Jul 2018 - Apr 2020

Designed and built a data lake solution for sales and inventory data in AWS (Amazon Web Services) through Python and SQL scripts which made on demand reporting possible for Merchant and Allocation teams via Tableau dashboards.Improved the load time of all company Tableau workbooks and dashboards by 33% by updating existing SQL to aggregate clunky data sources in MySQL, writing new SQL to create more specific data sources in Redshift, and optimizing the filtering within Tableau workbooks.Built Regression models to predict planned products’ margins in Python eventually transitioning the models to a self service tool for the Planning team which made more accurate forecasts than the existing tool set. Scoped, managed, and helped build an automated excel scraping tool reducing each Merchant’s weekly workload by 5% and dramatically reduced the errors ingested into our databases.Evangelized and established JIRA and Confluence across the company creating a project and task management structure improving communication, transparency, and teamwork across the company. Show less

Business Analyst Consultant

• Feb 2017 - Jul 2018

Partnered with management to assess, test, and implement project management solutions for Iowa Wind and Solar. Established Tableau reports to determine the monthly profitability of the customer base of Ironbridge, a Civil Engineering company. Used advanced excel functions like pivot tables and vlookups to generate weekly player performance reports for nationwide coaching group. Created course material for an online Tableau 101 class in conjunction with Simplilearn. Developed data storage models for warehousing previously unstructured customer data. Show less

Data Analyst

• Apr 2016 - Feb 2017

Designed a real time KPI tracking scorecard in Tableau used by management to assess the efficacy of Merchant outreach teams.Managed development and improvement of new and existing tables in Teradata allowing for more valuable reporting capabilities on Merchants.Ran linear regressions to predict Merchant usage behavior on our platform resulting in a 11% reduction in monthly support tickets.Addressed ad-hoc business questions using customized SQL queries and Tableau/Excel to extract and communicate data answers to management. Show less

Merchant Data Specialist

• Jul 2015 - Apr 2016

Product Manager & Customer Analyst

• Mar 2013 - Jul 2015

I began my employment at Venuelabs as a part time button pusher. I pinpointed ineffective company processes that were critical to scalable growth and overall company success and personally solved many of these issues. Worked with the CEO on the internal management of the 175 customers using a strategy I developed resulting in a staff reduction saving the company money. Project managed our major outsourcing project through a crowdsourcing operation where I directly and indirectly managed teams of people. Create various Tableau reports on customer usage of our platform used to monitor behavior. Show less

Sales Rep

• Feb 2012 - May 2013

Hired to be the face and backbone of the store's expansion into a new sphere of business. Developed the store's addition into a successful profitable business through creative problem solving, grass roots customer acquisition, and expert customer service. Created a professional atmosphere where customer's needs are individually addressed with a more one on one sales experience. Interpreted customer's issues and placed them into a product that would be most successful in fixing their issues and/or maximizing their potential Show less