Learn Data Skills
Beta

Prateek Makkad

Certified

Data Analyst

N | Toronto

Technologies

My Portfolio Highlights

My New Project

Analyzing Students' Mental Health

My New Course

Introduction to SQL

My New Certification

Data Engineer Associate

My New Project

Analyzing Students' Mental Health

Innovative thinker, shaping the future through data intelligence.

My Work

Take a look at my latest work.

course

Introduction to SQL

course

Joining Data in SQL

certification

Data Engineer Associate

course

Introduction to SQL

My Certifications

These are the industry credentials that I’ve earned.

Data Engineer Associate

Data Engineer Associate

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to SQL
Joining Data in SQL
Introduction to Python for Developers
Understanding Data Engineering

My Work Experience

Where I've interned and worked during my career.

Loblaw Digital | Feb 2023 - Apr 2025

Senior Analyst

Spearheaded the development of dashboards and managed data pipelines, ensuring efficient data delivery and reporting across platforms. ● Automated reporting workflows with Python, reducing manual dependencies by 95% and scaling the production of hundreds of reports. ● Defined KPIs, established benchmarks, and monitored performance to optimize key online merchandising metrics. ● Analyzed customer journeys across web and app platforms, enabling data-driven decision-making for cross-functional teams in product, analytics, SEO, and omni-channel. ● Partnered with BI and analytics teams to resolve data quality issues and design advanced analytics dashboards and reports. ● Influenced product strategy and new development initiatives by leveraging data-driven insights, driving impactful enhancements. ● Conducted A/B tests and user engagement analysis to refine merchandising strategies and improve digital performance.
Show More

GroupM | Feb 2022 - Sep 2022

Senior Data Analyst

Point of contact for various clients ’ teams catering to Fortune 50 companies. ● Developed automated scripts for post-campaign analysis using Python to improve work efficiency by 60%. ● Worked on customer segmentation and cohort analysis to track KPIs and provide recommendations for better ad targeting. ● Utilized SQL, BigQuery, Data Clean Rooms (Google ADH) and Python to analyze data and provide recommendations to optimize marketing campaigns. ● Utilized Microsoft Power BI and Google Data Studio to prepare insightful reports and dashboards.

Intello Labs | Feb 2020 - Feb 2022

Senior Data Analyst

● Spearheaded understanding of business objectives, strategies, and data context for multiple projects to build analytical reports and dashboards and oversee accuracy standards of data for reporting. ● Lead point of contact for product and technology teams catering to various clients for data requirements and providing robust supply chain analysis. ● Built analytical reports and interactive dashboards with actionable insights on Microsoft Power BI and Tableau pertaining to various stages of the supply chain to support business objectives and find areas of improvements in the supply chain. ● Applied query, data exploration, transformation, and statistical methods to identify patterns and improve data quality. ● Worked on ad-hoc demo reports for new client pitches and improved conversion rate by 25%. ● Developed auto mailer and report generation scripts in Python to automate Microsoft Excel reports and improved work efficiency by 50%

Genesis BCW | Sep 2018 - Jul 2019

Assistant Account Executive - Analytics

● Point of contact for media analytics reporting for various client teams who served Fortune 50 companies looking to expand and manage their media presence in the Asia Pacific Region. ● Prepared client-facing presentations for recurring updates on long-term engagements – heavily focused on tracking KPIs and recognizing anomalies – as well as ad-hoc crisis management scenarios where requirements for analysis and recommendations are open-ended.

My Education

Take a look at my formal education

MSc in Logistics and Supply ChainCardiff University | 2017
BBA in BusinessAmity University | 2016

Powered by

  • Work
  • Certifications
  • Courses
  • Experience
  • Education
  • Create Your Data Portfolio for Free