Rimsha Ishfaq

Industrial Engineer passionate about developing AI-driven automation and data intelligence systems. Experienced in Python, APIs, and exploratory data analysis, with a strong understanding of data pipelines and applied ML concepts.

Business Intelligence Analyst | Intelligence and Innovation Department at DOT REPUBLIC MEDIA (2024-08 – Present)

Region's Biggest Content Distribution Platform managing over 10B minutes in 240 countries

• Developed Python-based NLP scripts to detect flagged or sensitive keywords in metadata, reducing limited-monetization cases by 40%.
• Integrated YouTube APIs and Google Cloud Functions to automate real-time audience insights dashboards, cutting manual reporting time by 70%.
• Proposed and launched an AI-powered podcasting pipeline using generative AI (e.g., OpenAI + Eleven Labs + Notebooklm), that increased revenue of the channel by 10%
• Performed sentiment analysis on 100K+ YouTube comments for trend detection and audience behavior prediction, improving content strategy accuracy by 30%.
• Centralized and maintained Believe/Orchard reports in a SQL database, ensuring scalable and efficient data access saving 20% of errors and time for excel
• Integrated and analyzed data from Google Cloud, YouTube Data API, YouTube Reporting API, YouTube Analytics API to automate channel insights and audience engagement reports for 200+ channels.
• Played a key role in the PSL campaign, delivering real-time insights and performance updates for major channels like Pakistan Cricket and Sports Central.
• Automated news content selection from Reuters using Google Trends API, significantly improving the editorial team's speed and accuracy to 10%.
• Defined and tracked daily/monthly KPIs for channel performance, helping stakeholders evaluate campaign success and team output.
• Used the Spotify API to extract trending song data for supporting DRM's music release strategy, aligning content with current trends.

Bachelor in Industrial and Manufacturing Engineering – UNIVERSITY OF ENGINEERING AND TECHNOLOGY (2020-09 – 2024-07)