Data Analyst Assistant

Samantha Handwerger

Summary

Utilize my direct retail and technology experience to use data analytics and creative problem-solving skills to hone projects based on customer feedback and working cross functionally in many different environments. Bringing a level of enthusiasm and resourcefulness to day to day workload.

Education

Double Bachelor’s Degree in Apparel Merchandising and Apparel Design - Washington State University Class of 2017 –

Relevant Coursework: Web technology and information, Apparel and Business Intelligence, Computer Applications in Apparel Design and Textiles, Business Management and Economics Analysis

Professional Experience

Microsoft Business Analyst - Redmond, Washington September 2019- Present

Owned Visualization of Risk and Business Continuity Data to create high level views of critical information to leadership leveraging data sources within Kusto, Azure DevOps, and Excel

Aligned team functions while leading a Scrum Process to ensure work is being prioritized and reported into team Power BI dashboard. Evaluated velocity statistics and created work scoring system for internal use

Worked with internal SMEs to conduct Risk assessments to ensure compliance and enhance risk process to be used across all Microsoft (Creator of SOP’s and documentation for assessments)

Worked with Continuity/ Risk and Resiliency team to streamline manual processes and analyze complex data in Excel for Software and Hardware supply chains consisting of 1000+ lines of data

Communicated with Program managers daily to conduct risk assessments in Microsoft internal databases

Mentored and Lead UW Graduate Capstone Project on Factory supply chain risk Data Visualization project teaching Power BI and data analyst basics

Sur La Table Assistant Buyer Electrics/Cutlery Team - Seattle, Washington February 2019- September 2019

Worked with in store teams to merchandise product looking for new areas to innovate the in-store experience

Forecasted and sourced new Electrics/Cutlery brands to add to the product assortment using sales data to see areas that are growing on daily, weekly and monthly basis. Appointed E-Commerce SME and grew category sales online by +32%

Managed Projects Electrics category involved in Sur La Table in store cooking experiences (building SOPs on how to use products and how to involve them in demonstrations)

Zulily Assistant Buyer Active Team- Seattle, Washington April 2018- February 2019

Forecasted trends, demand, and concepts for upcoming sales within Buying team and Organization

Drove price negotiations with vendors and established plans to intake new styles and inventory brands included (Roxy, Quicksilver, Lorna Jane, and Skechers)

Leveraged Tableau to create sales reports analyzing and recognizing areas of growth for the business and making high level Data visuals for upper management

Worked cross-functionally across the company to ensure product is being advertised accurately

Zulily Project Coordinator Contractor on Pricing Team- Seattle, Washington June 2017- April 2018

Analyzed/Priced product to substantiate vendor supplied MSRPs for internal SKUs (over 30,000 skus analyzed)

Communicated with merchandising team to identify product information to provide best customer experience

Managed/updated large sets of data utilizing excel pivot tables and v-lookups to provide stats for management

Created Data Visualizations using Tableau to report compliance information to merchandising executives

Reported on product seasonality and different department trends to the Pricing Team using Tableau

Created process to ensure a legal compliance standard was being enforced throughout company

Other Skills

Computer and Technology: Leveraging Microsoft Excel to prepare data for visualizations and reporting purposes, Tableau, Power BI, Island Pacific (Data Management Tool), and Jira technology.

Communication: Professional communication and autonomy in a high demand environment

Resilient: Able to do what it takes to complete projects accurately and efficiently when given ambiguous direction

Phone: 971-***-**** Home: Seattle, WA

******************@*****.***

Contact this candidate