Ecommerce Analyst

• May 2022 - Present

Senior Analyst - Online BI Analytics

• May 2021 - May 2022

My role is focused on building unique dashboards that help the merchandising team within our eCommerce space, manage and optimize their categories. This is done using Tableau, SQL, Google BigQuery, SQL Server, Business Intelligence and Data Visualization.Provides strategic and analytical support to the Online Merchandising team via Tableau dashboards and one-off reports leveraging multiple data sources and analytic techniques.Created a Tableau dashboard to track redeemed units for all In-Cart promotions to help the Online Merchandising team collect ~$50M worth of Credit Memo funding yearly from Vendors.Built a one-stop-shop dashboard of KPIs to answer questions about the business and highlight areas of improvement for upper leadership and the Merchandising team.Built a dashboard that tracks last week, year-to-date and R12 KPI metrics specific to the Online Kitchen and Bath team in comparison to the top online competitors in that space. Created a query to track potential issues with matched items where vendors have removed inventory they previously allocated to us and given that inventory to a competitor

Senior Online Merchandising Analyst

• Feb 2020 - May 2021

- Strategic and analytical support for Online THD Lumber and Building Materials departments in the areas of pricing, promotions, profitability, assortment planning and vendor management; supporting/managing business in excess $415M combined annual sales. - Analyze key drivers of performance related to Online Merchandising; report out on KPIs daily/weekly/monthly; provide ad hoc analysis on top business drivers for future opportunities. - Manage item assortment and optimal retail price points based on sales and margin targets.- Coordinate and evaluate all promotional activity, searching out the best items for promotion while ensuring that appropriate margin rate and promotional parameters are adhered to and executed correctly.- Mange 500+ vendors across multiple categories and over 41,000 SKUs.- Evaluate and manage the on-boarding of new suppliers and review of new items for HD.com to drive additional sales growth.- Lead or contribute to projects and new initiatives which further strategic business objectives. - Assist with creation/direction surrounding online experience; including but not limited to creation of Banner Placement and Content, PIP enhancement, PLP navigation, Featured Product Nodes, SEO/ Search optimization and general improvement of category online aesthetics.- Work with cross-functional partners including but not limited to Category Experience, Marketing, IPR, Finance, Pricing, B2B Team, Brand Advocate and Core Merchandising. - Lead project to optimize reporting for internal online merchandising organization.

Space Planning Analyst

• Oct 2018 - Feb 2020

- Manage/create all Space Management diagrams (planograms) for the Building Materials department to drive project execution and store restocking process for $6.6B in annual sales. - Provide class and category level space allocation recommendations during business reviews driving space optimization and sales lift.- Provide actionable insights with regards to holding capacity, available space, and product flow. - Represents Space Planning on the cross functional Category Management Team pilot for the Roofing business providing the merchant with regular insights and actions to drive the overall category’s health; insights derived from this pilot are reported up to the executive team and board of directors. - Manage team of external partners responsible for creating and assigning over 27,000 Planograms.

Financial Risk Analyst

• Jun 2016 - Oct 2018

- Point of contact between field teams and corporate management handling risk loss cases from start to finish.- Performed risk analysis of new and existing accounts to determine risk classification to help mitigate losses.- Performs risk analysis, reviews NSF performance trends, and payment history for delinquent accounts.- Used excel for analytics and improving process efficiencies - Created reporting to reconcile and integrate data from 3 different data sources to show monthly return payments.- Led to a 20% increase in return payment collections.- Created regular ad hoc reports as field and management need.- Created and lead presentations to Senior Managers and Directors.- Ran weekly reports to update the team on new losses.- Team subject matter expert and go to for training of new team members when they are being on boarded.- Regularly tasked with problem solving unique situations brought by management.

Technical Recruiter

• Jan 2015 - May 2016

- Tracked personal job requirements, candidates in process, interviews, placements, and current weekly spread to streamline recruitment process.- Researched new technologies in the IT industry to better find and screen quality candidates.- Facilitated relationship management through constant contact with candidates.- Qualified job specifications on client conference calls and noted additional details to better align applicant qualities with client needs. - Tracked personal job requirements, candidates in process, interviews, placements, and current weekly spread to streamline recruitment process.- Researched new technologies in the IT industry to better find and screen quality candidates.- Facilitated relationship management through constant contact with candidates.- Qualified job specifications on client conference calls and noted additional details to better align applicant qualities with client needs.

Sales Associate

• Mar 2013 - Dec 2014

- Managed a sales territory of $1.4 million in business.- Performed a deep dive analysis project of a $10 million product, focusing on customer pain points.- Led a cross functional project team that identified $1 million opportunity. - Presented findings to executive leadership regarding retention issues that was ultimately implemented.- Performed analysis on the phasing out of print products to online products.- Looked at AUR of online product versus units sold to identity driver in revenue increase.- Looked at revenue of print versus online products to optimize overall continued revenue growth.- Optimized sales reporting to present monthly KPIs to management.- Analyzed historic sales data and pricing trends to forecast monthly sales goals.