Summary
Overview
Work History
Education
Skills
Websites
Software
Accomplishments
Timeline
Generic
Parth Panchal

Parth Panchal

Scarborough,ON

Summary

Experienced Business Intelligence and Data Professional with over five years of experience in data analytics, database and ETL development, and report generation. Demonstrates exceptional skills in data visualization, statistical analysis, and predictive modeling, leveraging tools like Python, SQL, and Tableau to drive operational improvements and strategic decision-making. Known for meticulous attention to detail, strong problem-solving capabilities, and excellent communication. A dedicated, goal-oriented individual adept at collaborating with cross-functional teams to translate complex data sets into actionable corporate insights.

Overview

6
6
years of professional experience
1
1
Language

Work History

Business Intelligence Consultant

WBGames(Sub-Contractor)
02.2023 - Current
  • Developed and managed dashboards using PowerBI and Looker
  • Improved data gathering, analysis, and visualization procedures with strategic optimizations.
  • Collected data from wide-ranging sources.
  • Generated reports, updated spreadsheets, and presented results.
  • Implemented coding solutions for data analysis. Performed QA on datasets and reports. Helped with bug detection in SQL scripts.
  • Worked with big data platforms (e.g AWS Redshift) and visualization tools (e.g Looker) to improve data exploration.
  • Engaged in cross-functional teams for impactful business analysis projects.

Business Intelligence Developer

Nuance
08.2022 - 12.2022
  • Generated monthly reports and utilized advanced Excel functions and data visualization tools to analyze trends and communicate insights.
  • Engaged in requirement meetings, contributing to the development and implementation of data models for real-time KPI monitoring.
  • Developed methods for efficient data extraction, organization, and documentation, ensuring reproducibility.
  • Leveraged business intelligence tools like PowerBI for trend analysis, root cause identification, and solution recommendations, enhancing decision-making processes.
  • Executed data extraction with SQL queries and XLOOKUPS,VLOOKUPs, and provided sales analysis reports through Excel Pivot Tables and Power Pivot
  • Demonstrated strong communication and presentation skills, showcasing case studies with effective visualizations.

Data Developer

Teranet
08.2021 - 05.2022
  • Provided technical support for analytics and reporting, designed data models, and developed scripts for data analysis from multiple sources.
  • Helped with ETL pipeline development for data acquisition and processing.
  • Implemented code for analytics, developed customized reports, and created dashboards to monitor key performance indicators, supporting decision-making processes.
  • Collaborated with stakeholders to prioritize issues, documenting methods for efficient data extraction and organization.
  • Produced and analyzed monthly reports through advanced Excel functions, identifying trends and patterns in complex data sets for strategic resource allocation.
  • Supported commercial projects with scheduling, continuous improvement initiatives using Macros and SQL, and managed production instructions via Base-Camp.
  • Conducted demand calculations, analyzed shipping KPIs with Tableau and performed web scraping with Python.

Analytics Consultant

RBC (Sub-Contractor)
03.2020 - 07.2021
  • Collaborated with application development analysts to translate business requirements into data designs, driving innovative solutions that align with business goals.
  • Engaged in Jira sessions and information-gathering meetings to capture business needs, delivering requirements documents and preliminary data models.
  • Supported data warehouse projects with logical and physical data modeling.
  • Designed and implemented a data quality improvement system for cleansing and consolidating data pre-data warehouse loading.
  • Utilized SQL GUI tools like Dbeaver extensively for data modeling and database design, including FACT and Dimension Tables creation.
  • Developed SQL stored procedures, functions, Materialized views, triggers for database management.

Data Analyst

Samcom Infotech
01.2018 - 02.2020
  • Created business and technical requirements documentation and developed data solutions for analytics implementation.
  • Helped with workflow automation using VBA Macros.
  • Reviewed current analytics implementations and provided recommendations for realignment to customer metrics or technical best practices.
  • Helped with sanity checks on datasets and reports.
  • Provided analytics domain expertise, consultation and troubleshooting internally and for customers.

Education

Post Graduate Diploma - Embedded Systems Development

Conestoga College Institute of Technology And Advanced Learning
Kitchener, ON

Bachelor of Technology - Electrical And Electronics Engineering

Navrachana University
Gujarat, IN

Skills

  • Technical Analysis
  • Data Mining
  • Data Mapping
  • Version Control
  • DAX and Advanced Excel
  • SQL Analytics and window functions
  • QA on Datasets and data sanity checks
  • Debug SQL scripts
  • Report Automation and Scheduling
  • Web Scrapping

Websites

Software

Advanced MS-Excel

PowerBI

Tableau

JIRA

GitHub

Apache Airflow

AWS Services(Redshift,S3)

BaseCamp

Looker

Postgres SQL

Power Query

CognityPro/Dbeaver/Dbviz

Miro board

Acrylic data

Power Pivot

Microsoft Copilot and GPT user

Accomplishments

  • AWARDS , Best Paper award for research Paper titled “Color tracking based virtual mouse”. Paper Id: ICAI-16510 was published in ICAI JOURNAL (ISBN: 978-93-85016-99-8) Recipient of Distinction Certificate(in Bachelors) from Registrar
  • Won Best Project of the Program - Embedded Systems Development 2019.
  • Achieved 1st Position in Sales and hit Experts Status in Ontario GTA District in August 2019.

Timeline

Business Intelligence Consultant

WBGames(Sub-Contractor)
02.2023 - Current

Business Intelligence Developer

Nuance
08.2022 - 12.2022

Data Developer

Teranet
08.2021 - 05.2022

Analytics Consultant

RBC (Sub-Contractor)
03.2020 - 07.2021

Data Analyst

Samcom Infotech
01.2018 - 02.2020

Post Graduate Diploma - Embedded Systems Development

Conestoga College Institute of Technology And Advanced Learning

Bachelor of Technology - Electrical And Electronics Engineering

Navrachana University
Parth Panchal