Data Analyst /Business Analyst

Data Analyst/ Business Analyst

PREYA PATEL

437-***-**** *********@*****.***

LinkedIn Profile

Tableau Portfolio

SQL Portfolio

Toronto, ON M1B 5C5

Skills

• SQL (SQL Server, MySQL, PostgreSQL)

• Tableau (Interactive Dashboard)

• Data Cleaning & Manipulation

• Collaboration & Teamwork

• Formula Auditing & Error Handling

• Excel (VLOOKUP, Conditional Formatting, Pivot

Tables)

• Analytical & Problem-Solving

• Presentation (Communication, Written,

Documentation)

Projects

COVID-19 VACCINES RATE DASHBOARD – Personal Project – Toronto, ON May 2023

● Inspected vaccine distribution data across 50+ countries and income groups.

● identified patterns in vaccination rates across demographics, ultimately informing policy decisions aimed at increasing vaccine equity for underserved groups.

● Produced innovative data visualization techniques to better communicate complex trends in global vaccine access. SPOTIFY ANALYSIS – Personal Project – Toronto, ON May 2023

● Developed a statistical analysis method for tracking album sales trends and artist performance, enabling informed business decisions.

● Utilized advanced SQL to identify top-performing artists through sales, streams, and listener engagement.

● Resulted in an increase in playlist followers due to the identification of top performing artists based on sales, streams, and listener engagement.

CUSTOMER SALES ANALYSIS – Personal Project – Toronto, ON May 2023

● Utilized SQL to extract data from 8 different related tables from customer sales databases using JOIN and VIEW.

● Transformed and filtered data by using aggregating and filtering function to improve reporting process.

● Quantified revenue by product category and created an easy-to-use dashboard using Tableau software, which allowed sales reps to identify opportunities for cross-selling and upselling with clients. Work Experience

TECHNOLOGY VIRTUAL EXPERIENCE PROGRAM – Deloitte – Virtual March 2023 - May 2023

● Significantly increased database efficiency by analyzing and meticulously recording information, resulting in streamlined data management processes and improved accuracy by 15%.

● Successfully enhanced data-driven decision-making by creating dynamic Tableau Dashboards, leading to increased visibility and actionable insights for key stakeholders.

● Improvements in data interpretation and informed strategic decision-making. Education & Certifications

GOOGLE DATA ANALYTICS – Google March 2023 - Continued COMPUTER PROGRAMMING – Seneca College – Toronto, ON Apr 2023 TABLEAU CREATOR – Tableau Apr 2023

DATA ANALYTICS – Break into Tech May 2023

SQL QUERYING & MANAGING DATA – Khan Academy Apr 2023

Contact this candidate