Headline

Data Analyst @ SVF Entertainment | Media, Streaming & Broadcast Analytics | Power BI, SQL, Python | Driving Content Yield & GenAI Workflows

About

I am a Data Analyst with 2.3 years of experience transforming complex broadcast and media data into scalable commercial strategies. At SVF Entertainment & hoichoi, I sit at the intersection of analytics, content acquisition, and monetization, driving data-informed decisions across digital streaming (OTT/DSP) and linear television. My work spans the end-to-end data lifecycle. I architect scalable BI reporting pipelines and star-schema models using advanced SQL, Power BI, and Python to accelerate executive decision-making. Within media and streaming intelligence, I optimize platform velocity, content retention, and YouTube CMS rights across major DSPs, while also driving linear TV programming and ad yield optimization using BARC/Yumi Analytics. To further streamline agile workflows, I actively focus on applied AI, rapidly prototyping interactive assistants and integrating LLMs using Streamlit and Hugging Face. adityadgayen@gmail.com | Always open to discussing BI architecture, media intelligence, and applied data analytics.

Location

Bengaluru

AI stack

claude code

claude

gemini

geminicli

langgraph

langsmith

Work experience

Data Analyst at SVF Entertainment, Nov 2024 - Present · 1 yr 11 mos, Greater Kolkata Area, Streaming Ecosystem & Catalog Governance: Lead multi-platform performance analytics across DSPs (Spotify, Amazon Music, JioSaavn) and YouTube CMS; enforced 100% metadata compliance and tracked multi-million stream velocity to maximize content discoverability and royalty yield. Broadcast Programming & Market Intelligence: Evaluate linear TV viewership using BARC data via Yumi Analytics; deliver competitive weekly/monthly GRP/TRP benchmarking and slot-level analysis to guide executive programming and content acquisition strategies. Commercial Inventory Optimization: Analyze Fixed Program Charts (FPC) and movie telecasts alongside FCT/AdEx datasets, identifying high-yield commercial windows to optimize ad clearance rates and revenue potential. Enterprise BI Architecture: Architected interactive Power BI dashboards utilizing advanced DAX, Power Query, and star-schema modeling, automating legacy reporting workflows and reducing executive turnaround time. Advanced Data Ingestion & SQL Engineering: Design optimized relational queries using CTEs, Window Functions, and subqueries across PostgreSQL and MySQL to consolidate disparate media datasets into scalable analytical models. AI Solutions & Delivery: Prototype custom AI analytics assistants using Streamlit, Hugging Face models, and Gemini/Claude Code to automate DSP/BARC trend analysis; manage cross-functional deliverables using Agile/Scrum frameworks in Jira.

Data Analyst Intern at SVF Entertainment, Jul 2024 - Nov 2024 · 5 mos, Kolkata

Internship Trainee at Oil and Natural Gas Corporation Limited (ONGC), Jun 2019 - Jul 2019 · 2 mos, Navi Mumbai, Maharashtra, India, During my internship at ONGC, I gained hands-on experience in the operation and maintenance of lean gas compressors, a critical component in gas processing facilities. Key responsibilities included: Performance Monitoring: Conducted performance evaluations of lean gas compressors, analyzing key parameters like pressure, temperature, and flow rates to ensure optimal operation. Technical Documentation: Contributed to technical reports detailing compressor performance, maintenance schedules, and optimization strategies, ensuring compliance with industry standards.

Education

Master's degree, Nanotechnology, Jadavpur University, Kolkata

Bachelor of Technology - BTech, Mechanical Engineering, Amity University Kolkata