QVCForecasting & Business Planning Analyst
Dec. 2018 - Mar. 2020Greater Philadelphia Area•Analysis & Modeling – Utilizing SQL, SAS, CACI and Python, develop statistical models for forecasting various business volumes and review models for business needs and improved accuracy. •Individual Projects: - Developed new Tableau dashboards to report Outbound Forecasts for each fulfillment center, roughly 8M units monthly. Forecasts provided down to the hourly level. - Created historical online-only sales search archive in Tableau for Forecasting team as well as senior management to allow for better planning and preparation during given promotions and overall business trends. - Analyzed an existing Excel report regarding company-wide volumes by site, current as well as historical, and transformed into an interactive and automated Tableau dashboard for senior management. •Tactical Planning – create, interpret, identify trends, adjust and publish multiple forecasts (Inbound, Outbound, Returns) for Customer Service and Distribution teams across 5 fulfillment centers. •Client Interaction – Seek feedback from end-users of forecasts, solicit input from other areas of business that may influence operational volumes (Sales and Product Planning, Buyers, Supply Chain Operations, Site Operations), and facilitate and attend forecast meetings. •Database Management – create and maintain accurate records of all volumes and variables involved in published forecasts to ensure current data is available for analysis by all members of the department.