Summary
Overview
Work History
Education
Skills
Certification
Projects
Timeline
BusinessAnalyst
Aditya Parmar

Aditya Parmar

Data Analyst

Summary

Passionate and Motivated Data Analyst with a strong drive for problem-solving in a fast-paced environments. Being an analytical individual, I achieve my goals and make data-driven decisions by leveraging technical skills such as Python, SQL, programming languages and BI tools to drive impactful business outcomes. Loves challenges and learning.

Overview

2
2
years of professional experience
2
2
years of post-secondary education

Work History

Data Analyst Intern

Dexterous Software Solutions
01.2023 - Current
  • Reporting directly to Senior Data Analyst and Manager, I am responsible for taking part in following tasks: Data Collection, Extraction and Analysis, Visualization and reporting, Statistical Analysis, Development of ETL pipeline.
  • Perform comprehensive data analysis tasks, including data extraction, cleansing, and validation using Python and SQL to identify trends, patterns, and insights. Play a key role in creating charts, graphs using MS Visual Studio.
  • Collaborate closely with technical delivery teams to define and comprehend intricate data and database requirements.
  • Participate in a wide range of analytical problem-solving activities and foster efficient collaboration to maintain data quality. Work with cross-functional teams to enrich data-driven decision-making throughout the organization.
  • Contribute actively to the organization's broader data strategy, fostering a data-driven culture by ensuring data quality.

Key Achievements:

  • Perform advanced analytics functions, including modeling and prescriptive analytics, utilizing BI Tool (Power BI) to create 5 Dashboards and 26 ad hoc reports while maintaining 95% accuracy rate for timely submission.
  • Successfully analyze and visualize 17 complex large datasets using Excel and Python to provide actionable insights.

In-Home Sales Consultant

Shaw Communications Inc
Winnipeg, Canada
09.2021 - 10.2022
  • Report to Sales manager to develop and execute strategic plans that drive revenue growth and business goals, proactively identify new sales opportunities, build strong customer relationships through consultative selling techniques.
  • Attended meetings with cross-functional team to analyze sales to forecast budget, identify patterns and adjust when necessary. Designed cost-effective solutions for clients that met their unique needs and drove long-term customer loyalty.
  • Attended industry events for prospecting leads and trade shows to meet potential clients and helped in market research.

Key Achievements:

  • Effective pipeline management and coaching new hires, providing product training and mentorship to sales team members, this effort resulted in a 20% increase in team performance. Consistently exceeded individual sales targets by 27%.
  • Track and analyze accurate sales reports and provide insights, resulting in 15% improvement in sales forecasting accuracy.

Education

Bootcamp Certificate - Data Analytics

University of Toronto
Toronto, ON
01.2023 - 06.2023

Diploma College Degree - Business Accounting And Finance

Georgian College
Barrie, ON
09.2018 - 09.2020

Skills

  • Data Collecting, Modeling, Transformation & Visualization, Business Metrics and Dashboards, BI tools, Data Warehouse, ETL, Data Pipeline, Statistical Analysis, Ad hoc Analytics, Stakeholder Management, Strategy Planning & Reporting
  • Data Modeling & Visualization tools: MS SQL, Python, Power BI, Tableau, MS Excel & PowerPoint
  • Software and Statistical Packages: VS Code, pgadmin4, Jupyter Notebook, Numpy, SAS, Scipy, Pandas
  • Strong communication & Organizational skill, Strong problem-solving & analytical skill, Detail-oriented & curious mind, resilient individual with an adaptive & flexible work approach, Teamwork & Multitask, Storyteller

Certification

  • The Data Analyst Course: Complete Data Analyst Bootcamp – Udemy
  • Data Analyst Toolbox: Excel, Python, Power BI, PivotTables – Udemy
  • The Complete SAP S/4 HANA Bootcamp 2023 – Udemy

Projects

Toronto Crime Analysis | Python, Jupyter Notebook, PostgreSQL, API, Flask, HTML, JS
• Built an interactive dashboard that displays charts, graphs and maps that examines different categories of crime for 158 neighborhoods in Toronto. The goal for the project is to help users visualize crime trends in their area.
• Capitalize available data and clean it using Python (Jupyter Notebook), load the data into a Database (PostgreSQL), connect to API using Flask, and create different visualizations by leveraging leaflet.js, plotly.js, D3.js and added Select2.

Crowdfunding_ETL | ETL pipeline, Python dictionaries, pgAdmin, PostgreSQL(GitHub)
• Building an ETL pipeline using Pythons, Pandas and different Python libraries and regular expressions to extract and transform the data into CSV files and create ERD Diagram and table schema and uploaded CSV file data into a PostgreSQL.
• Leveraged Pandas, NumPy, json libraries and created Data Frame by exporting and transforming excel data with different types of data frames, utilized ERD to sketch the diagram and table schema to load the data in Database.

Timeline

Data Analyst Intern

Dexterous Software Solutions
01.2023 - Current

Bootcamp Certificate - Data Analytics

University of Toronto
01.2023 - 06.2023

In-Home Sales Consultant

Shaw Communications Inc
09.2021 - 10.2022

Diploma College Degree - Business Accounting And Finance

Georgian College
09.2018 - 09.2020
Aditya ParmarData Analyst