Name: Pratik Malaviya

Job Role: Data Analyst

Experience: 2 Years 3 Months

Address: Toronto, Canada

Skills

SQL 80%
Python 90%
R Programming 80%
Statistical Analysis 85%
Machine Learning 85%
Tableau 90%
Power BI 80%

About

About Me

I am a passionate data enthusiast with expertise in Analytics, Machine Learning, and Statistical Modeling. With a Master’s degree in Analytics from Northeastern University, Toronto. I specialize in transforming complex datasets into compelling narratives that drive informed decision-making. Proficient in Python, R, SQL, Tableau, and Power BI. I thrive on using data as a tool for innovation. Always eager to learn and collaborate, I’m driven by the power of analytics to shape the future.

  • Profile: Data Analyst & Data Scientist
  • Domain: Data Analytics, Machine Learning & Predictive Analytics, Data Visualization & Business Intelligence
  • Education: M.Sc Analytics, & B.Tech Information Technology
  • Language: English
  • BI Tools: Microsoft Power BI, Looker & Tableau
  • Database: MySQL, Big Query, SQL Server
  • MS Office: Excel, Power Point, Word, Sharepoint, PowerApps & DAX Functions
  • Other Skills: Cloud, PySpark, Excel, Git, JIRA, Google Analytics &

0 +   Projects completed

LinkedIn

Resume

Resume

Experienced Data Analyst skilled in managing and validating securities data to ensure accurate and timely delivery. Strong ability to resolve discrepancies, collaborate with cross-functional teams, and maintain high-quality service standards to meet client requirements. Proficient in R, Python, SQL, and business intelligence tools such as Tableau and Power BI, with a proven ability to deliver data-driven insights and solutions in high-impact environments.

Experience


September'2023-December'2024

Business Intelligence Analyst

Canadian Western Bank

Canadian Western Bank (CWB) was a financial institution that provided specialized banking services to businesses and individuals across Canada, focusing on commercial banking, equipment financing, real estate lending, and wealth management.

  • Managed ETL processes and ensured data integrity, resolving warehouse and reporting issues while supporting audit compliance and stakeholder requirements.
  • Developed BI dashboards and mission-critical reports using data visualization tools, enhancing data accessibility in a hybrid (cloud/on-prem) enterprise architecture.
  • Optimized cloud-native data models through process and gap analyses, recommending BI solutions to enhance efficiency and scalability.

April-July'2023

Capstone Project - Apprenticeship

Sofvie Inc.

Sofvie, Its an all-in-one solution tailored to enhance safety, engagement, and performance across all levels of the mining industry.

  • Developed machine learning models, including Decision Tree, Random Forest, XGBoost, and Gradient Boost, with Random Forest performing best in predicting hazard completion times.
  • Gathered and processed data using SQL, applying techniques like SMOTE, label encoding, and feature selection to improve prediction accuracy.
  • Enhanced workplace safety by identifying risk patterns, proactively managing incidents, and gaining insights into forecasting methods and model limitations.

February'2021-February'2022

Data Analyst

Continix

CONTINIX is a global IT services company that helps organizations transform how they compete and win by helping them turn ideas into valuable insights, predictions, and products.

  • Collaborated with operations, finance, and BI teams to enhance data accuracy, automate reporting, and create interactive dashboards for strategic insights.
  • Utilized ETL pipelines, Python, and SQL for data analysis, while developing visualizations in Power BI to support data-driven decision-making.
  • Managed database integrity, ensured data security, and produced performance metrics, playing a key role in tracking KPIs and supporting business objectives.



Education


2022-2023

M.Sc Analytics

Northeastern University, Toronto

Majors: Statistical Modeling, Business Analysis, Predictive Analytics, Machine Learning

Grade: 3.5/4.0

2016-2020

B.Tech, Information Technology

Parul University

Majors: Big Data Analytics, Internet of things, Cyber Security, Networking

Grade: 7.25/10 (First class with disctinction)

Projects

Projects

Below are the sample Data Analytics projects on SQL, Python, Power BI & ML.

World Nuclear Power Dynamics

My Tableau analysis shows 75% of nations use PWRs, with Russia leading at 72,370 MWe, highlighting nuclear’s key role in clean energy.

USA's Automotive Odyssey

The US auto market shows 448M cars sold, Ford leading, automatics dominating, and California as the top-selling state.

Predicting Hazard Completion with Machine Learning

This project used machine learning to predict hazard completion times, improving workplace safety through proactive incident management.


Predictive Analytics for Promotion Identification

This project employs predictive analytics to determine the factors influencing employee promotions and identify individuals most likely to be promoted.

Certificates

Certificates

Below are the my Achievements and Certificates.


0 Achievements
0 Projects
0 Apprenticeship

More projects on Github

From data to discovery, I transform numbers into meaningful insights. & Through the lens of analytics, I reveal the powerful stories hidden within the data, turning complexity into clarity.


GitHub

Contact

Contact Me

Below are the details to reach out to me!

Address

Toronto, Canada

Contact Number

+1(647)-446-4511

Resume

Download