Pricing Analyst II - The Fresh Market - Greensboro, NC
(2023-11)
- Collaborated with category directors to develop data-driven pricing and promotional strategies, leveraging advanced analytics to optimize profit margins and drive revenue growth.
- Designed and implemented robust Alteryx workflows to automate complex pricing analysis, enhance data accuracy, and streamline reporting processes, resulting in increased operational efficiency.
- Conducted market research and competitive analysis to recommend strategic promotional initiatives and margin optimization techniques, maximizing sales performance and market share.
- Supported product lifecycle management by analyzing sales trends and inventory data to recommend product discontinuation and SKU rationalization strategies, reducing excess inventory and improving inventory turnover.
- Utilized Alteryx, SQL, Excel, and BI tools to synthesize large datasets, generate actionable insights, and support strategic decision-making in pricing and assortment planning.
- Assisted in cross-functional teams to develop pricing models, conduct scenario analysis, and perform sensitivity testing to identify optimal pricing points and promotional timings.
- Monitored performance KPI metrics such as GM%, revenue, and sell-through rates, providing ongoing insights to enhance category performance and profitability.
Marketing and Business Analytics Consultant - Sequoya Analytics - Sarasota, FL
(2019-10 - 2023-07)
Sequoya's suite of products uses advanced data science to synthesize sales & promotion data insights: channel performance, shopper behavior, Strategies to optimize trade spends. Performed as a Marketing and Business Analytics consultant to several Fortune 500 clients on post-promotional analysis to identify opportunities to optimize promotion design, spends & margins at key retailers.
- Design and implement pricing & promo scenario simulations to balance and reproportion pricing and promotion budgets.
- Analyze and decompose historical sales trends, demand drivers including regular price changes, promotion depth and frequency, elasticities, seasonality, calendar events and cross elasticities, to develop econometric forecast models, and polish forecast results.
- Automate and streamline report delivery along with comprehensive documentation on the statistical backing behind each solution.
- Collaborate with Category Management, Sales & Analytics teams to implement data driven pricing solutions at top CPG Manufacturers/brands in the US, Canada, and LATAM.
- Advised clients on the impact of everyday price changes, implemented marketing strategies, and advised clients on ways to optimize volume of units sold.
- Analyzed client marketing campaigns using post-promotional analysis, providing data on successful and unsuccessful strategies. Used data to forecast future promotion calendars, resulting in significant client ROI.
- Developed SQL reports, and collaborated with digital visualization team, for presentations to client stakeholders to meet internal and external KPIs.
- Organized presentations, reporting on key business issues, and updating client stakeholders on the status of their yearly and quarterly goals.
- Mentored and trained new-hire analysts on Sequoya Analytics' proprietary tools.
- Provided training to new and existing clients on Sequoya's external facing web-apps, guiding them on the settings, functionality, and interpretation of reports specific to each client's individual organizational needs.
- Performed in a cross-functional team environment, provided peer-to-peer data validations checks, to ensure accuracy of internal models of client data.
- Collaborate with internal data engineers and programmers to implement clients' request of applications enhancements and data customizations with high level of satisfaction.
Systems Project Analyst & Administrator - Florida Department of Education - Tallahassee, FL
(2017-08 - 2019-09)
- Collaborated with State Reporting and IT teams to perform a migration of the Florida Department of Education's state records of student enrollment and performance from a Cobalt legacy system into an on-demand report of records using SQL Reporting Services. Previous records could only be viewed once a week, the new system allowed real-time data access with measurable impacts to district funding.
- Developed and maintained new SAS programs to streamline data collection/reporting processes for State, Federal, and Ad Hoc Reports pertaining to Florida Adult Education Programs, increasing accuracy of real-time data of State funded programs.
- Remediated system errors causing inaccurate quarterly District and State records to allow accurate real-time reports instead of waiting for the end of year report to be published.
Team Lead - Capstone Project
(2017-05 - 2017-08)
Using national census data for the State of Florida, performed regression analysis, and forecasting of the number of employees in the State of Florida that would take additional leave provided an expansion of the Family and Medical Leave Act (FMLA). Quantified the economic impact and presented data to Capital representatives for the State of Florida. Statistical analysis was performed using the tools Stata and SAS.
