Prateek Kashyap
Singapore
Summary
Experienced Data Analytics professional with over 8 years of expertise across Media, E-commerce, Aviation, specializing in transforming data from multiple sources into actionable insights to drive informed decision-making. Adept at leveraging Analytics & Business Intelligence to solve business challenges with precision, while leading teams, managing complex projects, and achieving strategic outcomes.
Overview
10
10
years of professional experience
Work History
Assistant Data Analytics Manager
Warner Brothers Discovery
2021.10 - Current
- Pioneered data analytics projects aimed at uncovering customer behavior and driving engagement, utilizing SQL, Python, Excel, Power BI, and Looker for optimized data analysis and transformations
- Empowered content teams by executing digital transformation projects that led to a 30% increase in efficiency and productivity, utilizing data-driven insights for decision-making.
- Achieved 8% boost in engagement by using a Customer Segmentation ML model, enabling the marketing team to deliver highly targeted strategies
- Streamlined data visibility by conducting in-depth data analysis and reporting for 20+ channels, revealing key trends in User Behavior & improve content consumption across diverse platforms
- Engaged with cross-functional teams including merchandising, programming, customer retention, and marketing, achieving a 14% increase in customer engagement
- Collaborate closely with internal stakeholders to refine business goals, establish key performance and engagement metrics, data governance, time & resource allocation on multiple ad-hoc projects
- Oversaw the automation of 35+ dashboards and a Gen-AI tool across APAC with a focus on delivering accurate, targeted solutions to empowered teams to become data self-sufficient
Senior Digital Data Analyst
Mediacorp
2019.12 - 2021.10
- Designed Analytical solutions & developed interactive Reports & Dashboards for all company's platform(linear, digital, e-commerce) by using Power BI, SQL, Python & Excel
- Executed analytical evaluations to boost user conversion rates by 4% through A/B testing, while measuring and analyzing content performance across multiple platforms
- Engineered and managed comprehensive ETL workflows utilizing APIs from diverse data sources enabling the collection and analysis of media consumption and user behavior data to derive valuable insight
- Led ad-hoc analytics requests to derive key customer insights and automated key projects to boost team efficiency, while collaborating with cross-functional teams to provide consumer engagement insights
- Crafted and presented in-depth analytical reports to senior management, highlighting key insights to facilitate strategic decision-making
- Delivered successful virtual Power BI training programs organization-wide, focusing on comprehending key data metrics that drive product performance on the platform
Senior Data Analyst
Shopee HQ
2019.05 - 2019.10
- Worked with Regional Analytics team & responsible for creating Data Pipelines using PySpark & HiveSQL for campaign data and perform ETL operations
- Actively collaborated with the CRM and Cross-Border teams, leveraging HDFS, Hive, Presto & Airflow to provide comprehensive data for campaign analysis and a deep understanding of customer shopping behavior.
Data Scientist
Scoot TigerAir Pvt Ltd
2018.08 - 2019.03
- Developed and implemented a Customer Segmentation Model using K-Means clustering in Python and SQL, enhancing customer acquisition by enabling more precise targeting strategies.
- Designed and Optimized a Data Pipeline for the Customer Database, providing actionable insights through feature analysis and visualization in dashboards, improving decision-making for marketing and product teams.
System Analyst
TATA Consultancy Services (TCS)
2015.03 - 2018.01
- Leveraged SQL and Excel expertise to analyze app log data of CRM apps utilized by Financial Advisors at Morgan Stanley, successfully identifying and resolving app failure issues
- Responsible to Lead the shift and awarded with Star of the Month & On the Spot Awards for outstanding performance.
Education
Masters in Technology Data Science and Analytics (Knowledge Engineering) -
National University of Singapore (NUS)
Singapore07.2019
Bachelor of Technology in Mechanical Engineering -
Uttar Pradesh Technical University
India05.2014
Skills
- Python
- MS SQL
- Power BI
- Adobe Analytics
- Tableau
- Advance Excel
- MS PowerPoint
- Google Analytics
- Machine Learning
- Business Intelligence
Links
- Https://www.linkedin.com/in/pratkashyap/
- Https://www.github.com/Pratkashyap/
Timeline
Assistant Data Analytics Manager
Warner Brothers Discovery
2021.10 - Current
Senior Digital Data Analyst
Mediacorp
2019.12 - 2021.10
Senior Data Analyst
Shopee HQ
2019.05 - 2019.10
Data Scientist
Scoot TigerAir Pvt Ltd
2018.08 - 2019.03
System Analyst
TATA Consultancy Services (TCS)
2015.03 - 2018.01
Masters in Technology Data Science and Analytics (Knowledge Engineering) -
National University of Singapore (NUS)
Bachelor of Technology in Mechanical Engineering -
Uttar Pradesh Technical University
Similar Profiles
Craig JohnsonCraig Johnson
IT Business Consultant at Warner Brothers DiscoveryIT Business Consultant at Warner Brothers Discovery
Franco ChumbitaFranco Chumbita
Information Technology Specialist at Warner Brothers Discovery StudiosInformation Technology Specialist at Warner Brothers Discovery Studios
Jason ShemperJason Shemper
Senior Manager, Program Management at CNN/Warner Brothers DiscoverySenior Manager, Program Management at CNN/Warner Brothers Discovery