Production Data Analyst
Current• Collaborated with productions and stakeholders from cross-functional departments (HR, Recruiting, Finance, Animation Technology) to streamline data sourcing processes, increasing accuracy and efficiency in centralizing data for production tracking, headcount, finance and vendor data• Automated data cleaning, organization, merging and standardization processes using Python scripts, resulting in a 90% increase in workflow efficiency• Utilized Python, Tableau and Excel to create new headcount forecasting and production planning tools, increasing forecast accuracy by 25% and enabling more data-driven decisions to be made on space planning and crew scheduling across a 5-year production timeline• Created and maintained interactive dashboards in Tableau for easy exploration of studio data and to perform quick ad hoc analyses for executives• Developed automated KPI reporting tools in Tableau to generate monthly executive summary PDF reports that visualize and provide insights on centralized studio data