Vode Lighting LLCBusiness Data Analyst
Apr. 2019 - Feb. 2020Sonoma, California• Head of Tableau usage. Oversaw integration initiative with internal systems (including FishBowl, Vode Sales System, and QuickBooks), implemented companywide workflow protocols, and oversaw ongoing data entry, warehousing, analytics, and reporting
• Used MySQL & Excel to create data sources for reporting metrics dashboards (sales, finance, accounting, marketing, operations), and to drive relevant analysis in Tableau.
• Implemented revenue forecasting processes utilizing Excel, Data Warehouse. Worked with sales and operation leaders to create standardized pipeline data and implement reporting workflows from S&M team. Reduced forward quarterly sales forecast margin of error from 18% to less than 1%. • Automated commissions accrued & cost processes for distributors using the internal data warehouse and Tableau.