Summary
Overview
Work History
Education
Skills
Projects
Certification
Timeline
Generic

Prit Wade

Toronto,Canada

Summary

Data Analyst with hands-on experience building interactive dashboards, managing data pipelines, and delivering insights that influence strategic decisions. Skilled in SQL, Python, Excel, Power BI, and Tableau, with a strong focus on automation, data quality, and KPI tracking. Successfully applied real-world analytics during virtual internships at Accenture and Quantium. Known for translating data into actionable insights, collaborating cross-functionally, and driving business outcomes through storytelling and stakeholder alignment.

Overview

1
1
year of professional experience
1
1
Certification

Work History

Business Intelligence Developer

SSS Engineering
Mumbai, India
09.2022 - 08.2023
  • Scraped and aggregated machine logs and operational metrics from production floors for clients like L&T and Tata Steel to support downtime and delay analysis.
  • Cleaned, validated, and structured raw sensor and workforce data using Python (Pandas, NumPy), improving data quality for predictive insights by 40%.
  • Developed and launched interactive Tableau dashboards that visualized KPIs like machine uptime, workforce allocation, and material consumption in real-time.
  • Identified recurring performance bottlenecks and flagged high-risk equipment zones, enabling supervisors to implement preventive maintenance plans that reduced unplanned downtime.
  • Automated daily operations reports using Python and Excel, cutting report generation time by 3+ hours per week and minimizing manual errors.

Education

Ontario Graduate Certificate - Business Insights and Analytics

Humber Polytechnic
Toronto, ON
12.2025

Bachelor of Computer Applications -

Atharva Institute of Information Technology
Mumbai, India
07.2022

Skills

  • SQL
  • Python (Pandas, NumPy)
  • MS Excel (Pivot Table, VLOOKUP)
  • Databricks
  • Google Sheets
  • Looker Studio
  • Tableau
  • Power BI
  • Google Analytics
  • Competitive analysis
  • Agile methodology
  • JIRA project management
  • Confluence documentation
  • MS Office Suite (Excel, Word, PowerPoint)
  • GitHub version control
  • Data modeling and cleaning
  • Data transformation
  • KPI measurement and trend analysis
  • Data governance and reporting automation
  • Structured query generation
  • Documentation management
  • Data storytelling and communication
  • Clear written and verbal communication
  • Adaptability and collaboration
  • Attention to detail and problem solving
  • Analytical thinking and stakeholder engagement

Projects

Marketing Campaign Performance Analysis

  • Led an end-to-end marketing analytics project analysing 200k multi-channel campaign records to identify performance trends, reduce acquisition costs, and optimize ROI.
  • Applied Agile methodology with JIRA, structuring the project into sprints, tasks, and epics to mirror real-world analyst workflows.
  • Designed and executed SQL queries to calculate and segment KPIs, including CTR, CAC, ROAS, and engagement trends across time, location, channel, and audience.
  • Built a dynamic Power BI dashboard with custom visuals, drilldowns, and slicers to help marketing teams monitor ROI, campaign effectiveness, and audience targeting strategies.
  • Packaged project with executive summaries, strategic recommendations, GitHub documentation, and a case study to showcase storytelling and stakeholder impact.

Bank Customer Profitability & Risk Segmentation

  • Built a customer profitability framework using KPIs like Lifetime Value and Engagement Score, improving segmentation clarity and insight depth.
  • Cleaned and processed 10000+ customer records using Python, enhancing data usability for downstream analysis.
  • Designed a Tableau dashboard layout to present churn trends, regional performance, and customer engagement metrics.
  • Classified customers into High/Medium/Low churn risk tiers using behavioural logic to simulate real-world retention planning.
  • Analysed churn and value loss across cohorts and regions and structured the entire analytics pipeline in a well-documented GitHub repository with notebooks, dataset description, and business summary.

Certification

Generative AI Data Analyst Specialization – Vanderbilt University via Coursera

Timeline

Business Intelligence Developer

SSS Engineering
09.2022 - 08.2023

Ontario Graduate Certificate - Business Insights and Analytics

Humber Polytechnic

Bachelor of Computer Applications -

Atharva Institute of Information Technology

Similar Profiles

CREATE PROFILE
Prit Wade