Learn Data Skills
Beta
Vatsal Prajapati

Vatsal Prajapati

Data Analyst

Shoppers Drug Mart Specialty Health Network | Canada

Technologies

My Portfolio Highlights

My New Course

Introduction to SQL

My New Workspace

Analyzing unicorn company data

Passionate problem-solver, leveraging data to drive impactful solutions.

My Work

Take a look at my latest work.

course

Introduction to SQL

course

Joining Data in SQL

workspace

Analyzing unicorn company data

My Certifications

These are the industry credentials that I’ve earned.

Other Certificates

Coursera Python for everybody specialization

MSI Lean Six Sigma White Belt Certified - v4.0

Coursera Data Engineering and Machine Learning using Spark

SAS Applied Analytics Using SAS Enterprise Miner

DataCamp Course Completion

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

My Work Experience

Where I've interned and worked during my career.

Shoppers Drug Mart Specialty Health Network | May 2023 - Aug 2023

Business Analyst Intern

• Performed data reporting, cleaned, and analyzed extensive static data from on premise servers, summarized results through progress narratives, and created value metrics. • Acquired hands-on SQL experience using SSMS for automating data cleaning, transformation, and blending processes, resulting in a significant reduction of manual data transformation efforts by up to 55%. • Developed data-driven outreach dashboards in a corporate setting, resulting in up to 35% savings in manual data reporting. Translated business needs into specific actionable requirements to team. • Managed end-to-end data migration, conversion, and modeling using MicroStrategy and SQL for 120+ data input files to generate Power BI Dashboard data sources.
Show More

Web Ache Solutions | Sep 2020 - Aug 2021

Data Analyst

• Gained Hands on experience in Alteryx by working on complex workflow for automating the process of data cleaning, transformation and blending of data and saving up to 55% of manual data transformation. • Utilized SQL Server and GCP to query structured and unstructured data, supporting multiple projects and addressing client requirements with frequent ad hoc analysis. • Collaborated with stakeholders to develop an inventory management tool, resulting in an 84% reduction in errors. Worked with project managers and analysts to create reports and enhance KPI by 26%.

Web Ache Solutions | Mar 2020 - Aug 2020

Data Analyst Intern

• Delivered valuable insights by analyzing extensive SQL and SharePoint data, assisting the Sales, and Finance teams in tracking KPIs, trend prediction, and risk identification. • Automated and enhanced reporting processes, optimizing efficiency and saving over 1000+ hours of manual data reporting. Utilized Tableau for data visualization.

My Education

Take a look at my formal education

Postgraduate Degree in Applied A.I. Solutions Development George Brown College | 2023
Postgraduate Degree in Big Data AnalyticsGeorgian College | 2022
Bachelor of Engineering in Computer EngineeringGujarat Technological University | 2020

About Me

Vatsal Prajapati

I'm eager to collaborate on data-driven projects and contribute to organizations leveraging data for informed decision-making. Let's connect and explore opportunities in the exciting world of data analytics!

Powered by

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