Digital Marketing Analyst

• Oct 2020 - Present

Advertising Analytics Consultant

• Oct 2020 - Oct 2020

Inventory Planner and Analyst

• Apr 2019 - Jul 2020

Product Data Analyst

• Oct 2017 - Mar 2019

Working for The Annie Selke Companies, I performed a variety of data management, analysis, and reporting tasks of increasing importance, responsibility, and complexity. Software I developed was used to predict and control purchasing for products in excess of $16M per year.Data Management: Lead for the transition to Tableau in a young Data Analytics team• Self-taught the software before assisting in the training of others• Built and maintained custom Tableau databases using SQL, enabling complex analytical and visual reporting• Created and presented reporting on product data, sales, and inventory• Monitored and maintained data qualityDepartmental super user during SAP implementation• Collaborated with IT department to migrate existing business processes• Created SOP’s and documentation• Provided training and on-going support for department membersIT Subject Matter Expert for company-wide data initiative• Documented and defined existing data, identifying holes and potential improvements• Created new data governance structures• Refined suggestions during cross-functional meetings, working towards data which best supported all departmentsInventory Forecasting and Purchasing:Responsible for weekly product reorder and seasonal new product introductory orders • Developed forecasting capabilities in Tableau, automating a previously manual Excel process• Collaborated with Product Development and Marketing departments to support initiatives• Proposed quantities and used SAP to place final buys with vendorsPromoted to shift focus towards longer-term inventory forecasting, starting by creating and refining a preliminary Open to Buy based on rough initial plans and input from my supervisor

Office for Information Technology Intern

• Sep 2017 - Oct 2017

• Tested and reported on the potential functionality of Power BI, building a mock data model with financial data and comparing to currently used Excel pivot tables• Wrote DAX code to perform data analysis and built Power BI visualizations • Tested and reported on the potential functionality of Power BI, building a mock data model with financial data and comparing to currently used Excel pivot tables• Wrote DAX code to perform data analysis and built Power BI visualizations

Research Assistant

• May 2015 - May 2017

• Conducted computational chemistry research on the fluorescence spectrum of indole• Ran complex calculations using remote login to XSEDE supercomputers and wrote Python code to parse, analyze, and display results

Research Assistant

• Jan 2015 - May 2015

•Assisted chemistry Dr. Steven Frey with research regarding manganese complexes•Ran ion chromatography experiments and analyzed results

Laboratory Assistant

• Sep 2014 - Dec 2014

•Prepared solutions, set up equipment, and managed waste for general chemistry lab under the direction of Cynthia Sood