Ashley Lahm, MBA, MSDS

Experience

• 

  Burlington Stores, Inc.

  Aug 2011 - Jun 2016

  Managed merchandise financial planning process for the Boys Bottoms and Dresswear departments, ensuring proper inventory levels were maintained to meet sales and profitability objectives. Strategically managed markdown process, resulting in faster turn-over and less aged and unproductive product on the regular price selling floor. Optimized merchandise markdown methods by creating quantitative analytical tool and process for assessing recommendations, reducing the chance for human error by removing the need for manual calculations.Managed weekly open to buy process, weekly forecasting and seasonal buy plans working with Buyers to react to changes in sales trends. Show less Provided company and division level analysis and reporting on a daily, weekly, monthly and seasonal basis to Planning and Executive teams to aid in their decision making processes. Automated daily, weekly, and quarterly analytical summaries, published to the Executive level and the planning organization, using VBA code to automate steps which removed redundant information and reduced non-value added time. Reconfigured a process that allowed for quarterly changes to be made to the merchandise hierarchy structure, creating a process that allowed for direct import and cross-process verification, which improved overall efficiency and reduced non-value added time. Supported the Planning team of 135 members with weekly reporting, while continuing to enhance tools to expedite the planning process. Audited, analyzed and challenged the preseason merchandise plans, working with the Divisional Planners and Vice Presidents when necessary. Streamlined merchandise planning audit process from 160 hours to 40 hours by utilizing advanced analytics to highlight questionable assumptions and errors in pre-season plans, allowing for longer turn-around times for planners to review and correct errors which improved team morale. Provided guidance for and monitored adherence to the company level preseason merchandise plans. Implemented Gantt chart-based organizational strategies, increasing team accountability and autonomy to minimize duplication of effort and missed business objectives. Resulting in faster turn around time in the planning process and allowing for better communication with the planning organization.Conducted special analysis projects for Senior Management. Show less Determined sales plan and inventory levels for over 400 stores by analyzing financial and historic information with the goal of maximizing gross margin and turn, as well as overall performance. Created store lists and assortment plans to enhance key localization initiatives. Conducted ongoing analysis of daily, weekly and monthly sales, as well as tracked current on hand inventory units and seasonal market trends; incorporating results into future business decisions.Created a monthly report, using VBA code, to track the flow of merchandise into and out of the distribution centers, allowing for better visibility and ease of use for allocations, planning and buying; ensuring that monthly flow out of the DC stayed on budget. Tracked web sales to maximize profitability and ensure that inventory levels meet cyclical demands. Analyzed reports based on dynamic criteria to determine how allocation tools could best be utilized and communicated with allocators to ensure these requirements were fulfilled. Managed allocators work to ensure daily tasks were fulfilled. Conducted weekly allocation strategy meetings with three separate buying teams to ensure buyers vision could be implemented. Acted as a liaison between store, distribution fulfillment center and buying teams. Performed user acceptance testing on new functionality implemented in the allocation system. Won CEO Awards in first and third quarters of fiscal year 2013 and fourth quarter of fiscal year 2014 for highest sales increase against the previous years and highest increase to sales plan. Show less Worked with Inventory Analysts, Planners and Buyers to develop the distribution strategies which would enhance business performance; utilized allocation tools to implement these strategies. Ensured a proper assortment of merchandise was allocated to 41 new stores. Monitored and anticipated customer demand for new stores after grand opening, while continuing to focus on existing stores and daily responsibilities. Tracked merchandise held in distribution centers to release in later months/seasons. In the Fall 2012 season, tracked over $10 million worth of merchandise. Won CEO Award in fourth quarter of fiscal year 2011 for contributing to Junior Sportswear's achievement of a 23.2% increase of sales, beating plan by 4.6%. Show less

  • Associate Planner

    Jan 2016 - Jun 2016

  • Merchandise Control Analyst

    May 2015 - Jan 2016

  • Inventory Analyst

    Mar 2013 - May 2015

  • Allocator

    Aug 2011 - Mar 2013
• 

  Quench USA, Inc.

  Jun 2016 - Apr 2017

  Sales Operations Analyst

  Automated the daily and monthly sales summaries, and published to the sales and executive teams, reducing the overall run time from 2 hours to 20 minutes daily. Provided ad-hoc analysis to the sales and executive teams as requested. Streamlined the planning process by creating an Excel based tool, using advanced analytics to recommend a yearly budget.

• 

  Qurate Retail Group

  Apr 2017 - Feb 2021

  Built a competitive pricing Tableau dashboard using SQL and SAS, to provide macro and micro level insights to leadership teams as well as buying, planning, marketing and eCommerce teams.Developed an automated and dynamic Excel-based tool, utilizing VBA, to query historical competitive pricing data and monitor impact of price changes.Created a new retail pricing strategy utilizing competitive price data, to share opportunities to drive sales and maximize profitability by improving our competitive market position. Provided regular reporting and price change recommendations to leadership teams and in partnership with the buying and planning teams. Show less Managed long-range staff planning Excel-based models for QVC's five fulfillment centers and HSN’s three fulfillment centers, as well as simplified the process and created unified reporting across all sites. Updated the staff planning models weekly and worked with staffing managers to maintain their individual files. Published staff planning summaries to fulfillment center leadership teams and VP team weekly, acting as a liaison between staffing mangers and VP team, and continually updated them to ensure accuracy and that expectations were being met.Developed and published weekly reporting for ACA compliance, worked with staffing managers and benefits team to ensure we were complaint. Developed end of quarter carryover reporting, continued to publish quarterly and worked with site teams to ensure we are accurately reporting end of quarter projections. Worked with Supply Chain team to manage flow of inventory through the fulfillment centers. Updated inbound forecast on a weekly basis and worked with BP&A team to develop new inbound forecast Tableau report. Show less

  • Pricing Analyst

    Oct 2019 - Feb 2021

  • System Analyst

    Apr 2017 - Oct 2019
• 

  Turn5, Inc.

  Mar 2021 - May 2022

  Data Analyst

  Supported the marketing team in all their analytical needs, including reporting on the company's key business initiatives. Gathered and distilled requirements from business users and transformed into actionable reporting, partnering with data engineers to scope data requirements when needed.Used SQL to support reporting needs as necessary.Developed interactive Tableau dashboards for daily, weekly, monthly business drivers reporting, as well as various other reporting to meet the needs of the marketing team.Created presentations on key marketing metrics for quarterly business review. Show less

• 

  FANCY SPRINKLES

  May 2022 - Nov 2022

  Data Analyst

  Responsible for building data warehouse from the ground up which involved researching and testing best methods for an ETL process that would stand up the data warehouse as quickly as possible, including vetting third party ETL companies, such as Stitch, Daton by Sara’s Analytics, Airbyte, Zapier, Meltano Compiled list of must have data sources that needed to be brought into data warehouse, including Shopify, Google Analytics, Google Ads, Google Sheets, Netsuite, ReCharge, Amazon Seller Central, Facebook Ads, Amazon Ads, Gorgias, Shipstation, Klavyio, Rakuten, Bing Ads, Youtube Analytics, Tik Tok Ads and worked with teams to understand the business needs for each data source. Built out data pipeline, using Daton to extract and load into BigQuery, which would be used to create main KPI Tableau dashboard. Used dbt and SQL to transform the data to create a core data environment to be used for advanced data modeling. Staged tables when necessary to prep data to be used in core environment. Modeled data using SQL in dbt and BigQuery to create datasets that would feed the main KPI reporting, including orders, refunds, and customer data from Shopify, subscription data from ReCharge, marketing analytics from Google Analytics, orders and refunds from Amazon Seller Central, customer service data from Gorgias and Amazon, paid ad analytics from Google Ads, Facebook Ads and Amazon AdsWorked with leadership team to build out the main KPI dashboard in Tableau keeping in mind agile best practices to ensure the dashboard could be easily maintained as our data stack evolved. Show less

• 

  Lilly Pulitzer

  Jan 2023 - May 2023

  Business Intelligence Analyst

  Oversaw a data democratization initiative by meeting with data stakeholders across the organization to better understand their pain points around data, and worked to resolve those issues by creating standard business metrics across the organization.

• 

  Honeylove

  May 2023 - now

  Senior Analytics Engineer

  Spearheaded and successfully led the transition from Looker to Sigma Computing after researching and determining that Sigma’s BI tool would lead to better data democratization and ability to self service across the organization. This involved reviewing and determining the business needs of over 80 dashboards, reducing it down to 28 dashboards during the transition. Overhauled data architect in dbt and BigQuery to aid in consistent and accurate data, as well as creating a semantic layer to provide standard business metrics across the organization.Worked cross functionally to understand data needs across the organization and prioritized the data teams work accordingly, including monitoring all data related OKRs to ensure the business is getting the support they need in order to complete them. Show less