DILEEP CHANDRA

Creative professional with over 9 years of experience in 3D animation and storytelling, now pivoting to Data Analytics. Proficient in Power BI, SQL, and Excel, with a keen focus on visual detail and project management. Committed to transforming raw data into actionable insights and compelling narratives.

• Junior Data Analyst / Associate Analyst
• Power BI Developer / Reporting Analyst
• Business Intelligence Analyst (Entry Level)
• Gaming or Marketing Data Analyst

• Assemblage Studios, 05/01/23, 07/31/25, Stitch Head, Sneaks, Gabby Doll House, Followed feedback-driven iterative workflows via ShotGrid to animate characters based on storyboard and creative briefs.
• Mikros Animation, 08/01/22, 04/30/23, Mickey Mouse Fun House, Delivered high-quality animation shots, aligned with production goals and tight deadlines.
• Xentrix Studios, 07/01/21, 07/31/22, Big Nate, Monster High, (Further studios and projects available upon request. Total 9+ years of consistent experience.)

English, Telugu, Hindi, Data Visualization, Film Analytics, Cricket, Gaming

This resume reflects a career transition. Project work is ongoing and growing. Portfolio and case studies available upon request.

• Power BI: Analyzing rainfall impact on agricultural productivity, to understand the relationship between historical rainfall patterns and crop production in India, collected and cleaned 50+ years of rainfall and agricultural production datasets, created measures using DAX, and applied advanced filtering to highlight seasonal and regional variations, designed an interactive dashboard enabling users to visualize rainfall trends, identify drought/flood years, and analyze their direct impact on crop yields, Power BI, DAX, data cleaning, data transformation
• SQL: Flight data analysis and reporting, to analyze airline performance and identify operational bottlenecks, used SQL queries to join multiple datasets containing flight schedules, delays, and cancellations; implemented aggregate functions to calculate delay frequencies, on-time performance, and busiest routes, generated comprehensive performance reports that could support decision-making for route optimization and delay reduction strategies, SQL, joins, aggregate functions, subqueries, data analysis
• Excel: Streaming service user analysis, to assess user engagement trends for a video streaming platform, imported raw CSV usage data into Excel, performed data cleaning and transformation, and built pivot tables and charts to track watch time, retention rates, and most-watched categories, created a dynamic Excel dashboard helping stakeholders identify peak usage hours, churn risks, and popular content types, Excel, pivot tables, charts, conditional formatting, data cleaning