Summary
Overview
Work History
Education
Skills
Timeline
Generic

Pranil Mambalam

Windsor,Ontario

Summary

Detail-focused Data Analyst with knowledge in data warehousing, process validation and business needs analysis. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Big Data.

Expertise in transforming raw data into actionable insights and strategic recommendations for optimizing production workflows, identifying cost-saving opportunities, and improving quality control. Proficient in developing interactive dashboards and reports to visually communicate key findings to stakeholders in the automotive industry.

Overview

5
5
years of professional experience

Work History

Data Analyst

Centerline
08.2021 - Current
  • Produced monthly reports using advanced Excel spreadsheet functions.
  • Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
  • Utilized data visualization tools by 70% to effectively communicate business insights.
  • Used statistical methods to analyze data and generate useful business reports.

INTERNAL PROJECT ROLES

  • Identified, analyzed and interpreted trends or patterns in complex data sets by 80%
  • Synthesized complex analytics-derived insights into easy-to-understand, actionable recommendations for business users.
  • Worked with business intelligence software and various reports to glean insights into trends and prospects.
  • Data interpretation and insights: Examine data to find trends, correlations, and patterns that can be used to make decisions.

Junior Data Analyst

DIASTYLE
09.2018 - 09.2019
  • Data Collection and Preparation: Assisting in gathering data from various sources, such as databases, spreadsheets, or APIs. Cleaning and preprocessing data to ensure accuracy, consistency, and suitability for analysis by 90%.
  • Data Analysis and Reporting: Conducting basic data analysis tasks by 50%, such as descriptive statistics, data exploration, and simple visualizations. Assisting in creating reports or summaries of analysis findings for presentation to stakeholders.
  • Data Visualization: Assisting in creation of visualizations and dashboards to effectively communicate data insights to stakeholders. Learning and using tools like Excel, Tableau, or Power BI to create visually compelling presentations.
  • Developed diagrams to describe and lay out logical operational steps.
  • Assessed business requirements to create focused solutions

Education

Master of Science - Engineering

University of Windsor
Windsor, ON
05.2021

Bachelor of Science - Engineering

Anna University
Chennai
05.2018

Skills

  • Python
  • Tableau
  • Power BI
  • SAS
  • UNIX
  • Excel
  • MATLAB
  • Wise Solutions Software
  • Apache Spark
  • Accounting Principles
  • Data Mining
  • Data Integrity Validation

Timeline

Data Analyst

Centerline
08.2021 - Current

Junior Data Analyst

DIASTYLE
09.2018 - 09.2019

Master of Science - Engineering

University of Windsor

Bachelor of Science - Engineering

Anna University
Pranil Mambalam