Overview
Summary
Work History
Education
Skills
Accomplishments
Work Preference
Timeline
Hi, I’m

CHIRAG PRAMODBHAI GHOTIKAR

Toronto,CA

Overview

4
years of professional experience
3
years of post-secondary education

Summary

Versatile Data Analyst with over 3 years of experience in data modelling, statistical analysis, and business intelligence. Proficient in SQL (including window functions, CTEs, and stored procedures), Power BI, and Tableau, with expertise in transforming data into actionable insights. Skilled in designing scalable data models, optimizing data processes, and creating complex dashboards to support data-driven decision-making. Proven track record of collaborating with cross-functional teams to enhance business performance and implement best practices. Detail-oriented individual with exceptional communication and project management skills. Proven ability to handle multiple tasks effectively and efficiently in fast-paced environments. Recognized for taking proactive approach to identifying and addressing issues, with focus on optimizing processes and supporting team objectives.

Work History

Numerator

Data Analyst
03.2022 - 11.2023

Job overview

  • Analyzed large datasets stored in PostgreSQL to identify patterns and trends across various product categories
  • Utilized Binder Tool, a proprietary system, to assign and categorize brand items such as, , Hershey, Fresh Express, Activia, and Da-one in the Canadian market
  • Managed and categorized over 300+ product categories with high accuracy, ensuring the integrity of vast datasets for major retailers (Costco, Walmart, Dollar Tree, Dollar-Rama, IGA, Foodworks)
  • Used Jira to track work progress, manage tickets, and monitor assigned tasks, ensuring timely completion of projects and adherence to SLAs
  • Collaborated with cross-functional teams to optimize processes and improve accuracy in data handling, contributing to the overall efficiency of the data analysis workflow
  • Produced monthly reports using advanced Excel spreadsheet functions. Utilized data visualization tools to effectively communicate business insights.
  • Key Skills: Agile Workflow, Data Analysis, Python, Market Research, Data Modelling, FMCG Analytics, PostgreSQL

Nielsen

Data Processing Specialist(Statistical Operations)
06.2021 - 03.2022

Job overview

  • Managed and processed large datasets from major Moroccan retailers, including Aswak Assalam, Carrefour, Leader Price, and Acima, focusing on supermarket and pharmacy data
  • Developed market stratification models to analyze patterns in shop performance across Morocco, including metrics such as ACV (All Commodity Volume), earnings on a monthly, quarterly, and annual basis
  • Led Agile project delivery, handling sprints and iterative reviews independently to meet goals
  • Collaborated with stakeholders and cross-functional teams to clarify requirements and enhance workflows
  • Utilized data-driven insights to support strategic decision-making for retailers, providing detailed reports on store performance and market trends in MADRAS (Market and Data Reporting and Analysis System)
  • Developed comprehensive training materials, successfully onboarding new team members to the data processing department.
  • Spearheaded process improvements, contributing to increased productivity and cost savings within the organization.
  • Established a culture of continuous improvement within the data processing team by encouraging open communication and active participation in process enhancement initiatives.
  • Key Skills: Agile Project Management, Stakeholder Communication, Data Stratification, Automation, Python, Retail Data Processing

Numerator

Data Classification Associate
06.2019 - 06.2021

Job overview

  • Coordinated with data collection and analysis teams to meet client-specific requirements across 5 media types: Catalogue, Newspaper, EDM (Email Direct Marketing), Website, and Social Media (Facebook & Twitter)
  • Gathered and classified promotional data from various media sources to create comprehensive reports for clients
  • Spearheaded the transition from Excel-based reporting to Power BI, reducing error rates by 15% and improving productivity
  • Designed and implemented new processes to enhance reporting accuracy and timeliness.
  • Enhanced team productivity by streamlining communication and implementing efficient project management tools.
  • Played an integral role in launching successful projects by coordinating tasks among team members while adhering closely to established timelines and budgets.
  • Exceeded sales targets consistently by employing strategic selling techniques and building long-lasting relationships with clients.

Education

The Maharaja Sayajirao University Of Baroda
Vadodara, India

Master of Science from Applied Mathematics
04.2015 - 07.2017

University Overview

  • Grade: First Class
  • Dissertation: Method for Solving Nonlinear Equations Using Quadrature Rule

Conestoga College
Kitchener

Post Graduate Diploma from Business Analytics
01.2024 - 09.2024

University Overview

  • 3.75 GPA
  • Capstone Project: City Selection for International Students in Canada, Analyzed rent, wages, and climate across Canadian cities using SQL and Power BI to identify Toronto as the most suitable city for international students
  • Research Project: Optimizing Tobacco Retail Dealer Cap Allocation in NYC, Identified trends in market saturation and gender disparity, proposed strategies to optimize cap distribution, reduce competition, and encourage female participation, resulting in potential revenue growth and improved market share.

Skills

    Python programming

    Data visualization and presentations

    Data analysis

    Excel functions

    SQL

    Data cleaning

    SQL databases

    Statistical analysis

    Tableau

    Data validation

    Database programming and SQL

    Data modeling

    ETL processes

    Project management

    Report preparation

    Report writing

    Data storytelling

    Data mining

    Data exports

    Business needs analysis

    Microsoft Access

    Clear and concise communication

    Data quality assurance processes

    Data integrity validation

    Data programming

    Sentiment analysis

    Product development

    Problem-solving

    Time management

    MS Excel

    Data collection

    Data governance knowledge

    Data quality

Accomplishments

Accomplishments
  • Made recommendations on business intelligence tools to cut processing time by 10%.
  • Developed methods to integrate checking the shops and Market Checker Tool to significantly improve workflow efficiency.
  • Collaborated with team of 3 in the development of MINOC.
  • Used Microsoft Excel to develop inventory tracking spreadsheets.
  • Created a PowerBI dashboard for team for tracking the workload status.

Work Preference

Work Type

Full Time

Work Location

On-SiteRemoteHybrid

Important To Me

Career advancementWork-life balancePersonal development programsFlexible work hours

Timeline

Conestoga College
Post Graduate Diploma from Business Analytics
01.2024 - 09.2024
Data Analyst
Numerator
03.2022 - 11.2023
Data Processing Specialist(Statistical Operations)
Nielsen
06.2021 - 03.2022
Data Classification Associate
Numerator
06.2019 - 06.2021
The Maharaja Sayajirao University Of Baroda
Master of Science from Applied Mathematics
04.2015 - 07.2017
CHIRAG PRAMODBHAI GHOTIKAR