Summary
Overview
Work History
Education
Skills
Websites
Projects
Timeline
Generic
Prasanna Chandran

Prasanna Chandran

Lead Data Analyst
Bangalore

Summary

Results-driven Lead Data Analyst with expertise in transforming complex raw data into actionable insights using SQL and Python. Skilled in developing dynamic Tableau and Power BI dashboards to drive data-driven decision-making. Known for uncovering key data trends and developing innovative solutions to solve business problems.

Overview

12
12
years of professional experience
8
8
years of post-secondary education
3
3
Languages

Work History

Data Analytics Lead

DoorDash
11.2021 - Current
  • Enhanced data-driven decision making by implementing advanced analytics to extract insights from raw data for the DoorDash Revenue Data team / Global heads.
  • Analyzed PRD/BRD documentation created by multiple product teams to understand new product/service objectives, then developed advanced SQL queries in Snowflake to extract, test and validate the operational data flow is accurate. Integrated Snowflake with Python to perform advanced analytics, deriving valuable business insights.
  • Created Tableau and Sigma Computing dashboards by integrating Snowflake, transforming raw data into actionable visualizations. Automated reports with custom visuals and analytical tabs, streamlining data access for management by significantly reducing manual effort.
  • Developed advanced custom SQL scripts in VS Code to link upstream / related tables, deployed the code via Docker to GitHub. The code is back tested and ingested into Snowflake.
  • Performed advanced excel analytics to reconcile the monthly revenue data.
  • Interpreted business needs, collaborated with engineering teams to identify data sources, and led cross-functional teams to design and implement data analytics solutions.
  • Conducted comprehensive data audits between dashboards and GitHub to maintain high levels of data quality and integrity.
  • Implemented randomized sampling techniques for optimized test results.


Professional Services Consultant

Epicor Software India Private LTD
05.2017 - 11.2021
  • Initiated the pilot batch for BisTrack product within Epicor. Traveled Canada to learn the process, transferred the knowledge & did a successful go live. Visited two customers site in Canada and did a successful product implementation.
  • Performed Exploratory Data Analysis for procurement & sales (SCM) trends for lumber industries & suggested inventory optimization technics to effectively manage their supply chain process and maintain an economic order quantity..
  • Extracted data from SQL server, transformed & loaded the SQL data to Power BI / Tableau to automate reports that provided business inferences.
  • Mentored junior consultants on best practices and techniques, fostering a collaborative team environment focused on continuous improvement.

Financial Analyst

Xerox Business Services India Private Limited
10.2015 - 5 2017
  • Prepared financial trend analysis for several customers, reported the same to management and implemented innovative process ideas to improve the collections process significantly. Performed Aged analysis and recovered huge old debts from several customers.
  • Streamlined financial reporting for better decision-making with clear, concise analysis and presentation.
  • Prepared Statement of Reconciliation by comparing, analyzing the Accounts receivable & Accounts Payable Statement of Accounts. Performed variance analysis by figuring out the imbalances that occur during month end time and post accruals in order to avoid any imbalances reflecting between the statement of accounts.
  • Mentored and monitored a team of 6 members.
  • Designated Auditor - Audited and reviewed collection activities performed by other agents. Coordinated with external auditors at the time of statutory audits
  • Analyzed financial statements against forecasts to prepare high-level variance analysis. Prepared comprehensive monthly reports highlighting key financial metrics and achievements for stakeholders'' review.

Finance Specialist

Siemens Technology and Services Pvt Ltd
01.2013 - 09.2015
  • Performed End to End Accounts Payable data analysis. Analyzed financial trends & suggested control measures for an effective cost reduction.
  • Performed in-depth financial data analytics in excel by extracting data from SAP.
  • Trained and qualified as an ISO auditor | Conducted Information Security Audits 9001:2008 for different Business Units to ensure business is run as per ISO norms.

Education

Post Graduation Program - Data Science & Business Analytics

Great Learning in Collab With Texas McCombs
Bengaluru, India
01.2019 - 09.2021

Bachelor of Arts - Commerce

G.R. Damodaran College of Science
Coimbatore, India
06.2007 - 04.2010

PUC -

Stanes Higher Secondary School
Coonoor, Tamilnadu
06.2005 - 04.2007

SSLC -

Defence Employees Matriculation School
Aruvankadu, Tamilnadu
06.2004 - 04.2005

Skills

    Snowflake

    SQL Expertise

    Python Programming

    ETL development

    Microsoft Power BI

    Microsoft Excel

    Tableau

    Sigma Computing

    GitHub

    Docker

    Machine learning Algorithms/Models

    Data Quality Management

    Data cleansing

    Data Mining

    Exploratory Data Analysis

    Feature Engineering

    Predictive model

    Pandas

    NumPy

    Matplotlib

    Sklearn

    TensorFlow

    Keras

    BeautifulSoup

    Selenium

    Requests

    Scrapy

    Flask

    Classification

    Regression

    K-Means Clustering

    Predictive Analysis

    Hypothesis

    Basket Analysis

    Text Analytics

    R

    Tableau

    Advanced Excel

    MYSQL

    POSTGRESQL

    Missing value & Outlier Value treatment

    Visualizations

    One hot encoding

    Hyper parameter Tuning

    Lasso

    Ridge

    Elastic Net Regression

    Support Vector Regression

    Gradient Boosting Regression

    LGBM

    XGBoost

Projects

Capstone project in Supply Chain Management domain:

Obtained material purchasing data for a real time manufacturing company. Identified their  monthly material usage. Forecasted material usage by applying Machine Learning with Hierarchical  Project Approach: Data Cleansing | Missing Value | Outlier Treatment | Exploratory Data Analysis |  Feature Engineering | Model Building |Hyperparameter Tuning | Model Validation | Forecast |  Time Series. Later, suggested safety stock levels to be maintained by the company.   Snowflake, MYSQL, MS SQL, POSTGRESQL  properties of sale and factors affecting it. Tableau’s data visualization tools were used to create  Models: HTS Forecasting: ARIMA, SNAIVE, ETS, NNETAR, XGBOOST, CATBOOST, LightGBM. Based on model results, final forecasts were made using catboost model. The models are validated using the metrics: MAPE, MAE, RMSE, SMAPE.  

Salary Prediction using ML & deploying the model in Heroku (End to End):

Data cleansing | EDA | Feature Engineering | Predictive model using XGBoost | Deploying the model on Heroku using Flask API.

House Price : Advanced Regression Techniques:

Date Cleaning | Missing value & Outlier Value treatment | Exploratory Data Analysis &visualizations|  One hot encoding | Feature Engineering | Hyper parameter Tuning | Lasso, Ridge, Elastic Net  Regression, Support Vector Regression, Gradient Boosting Regression, LGBM, XGBoost, Bagging &  Stacking regressor.

Web scrapping with Python:

Web scrapped online bookstore using python - Selenium | Requests | BeautifulSoup | Scrapy | xml.

Factor Analysis on Consumer Perception towards Cereal Brands:

Consumer perceptions towards a brand can be built on various parameters depending upon the  product. In this project, I have used Factor Analysis to evaluate and identify the most significant attributes that contribute towards the consumer perception of the different cereal brands.

Visualizing House Sales for Boston Real Estate in Tableau:

In this project, I have explored the art of problem-solving with the aid of visual analytics to identify properties of sale and factors affecting it. Tableau’s data visualization tools were used to create interactive dashboards to uncover hidden insights for sellers of the properties as well as prospective  buyers. https://public.tableau.com/profile/prasanna3111#!/vizhome/BostonCondostorybyPrasanna/BostonCondo-StorybyPrasanna

Evaluated impact of change in temperature of Cold Storage products during the year:

In this project, I have computed the mean cold storage temperature in different seasons and used  hypothesis testing to evaluate if any corrective action is required from the plant's side or the  procurement's side.

Evaluated and inferred significant predictors affecting the customer loan preferences:

In this project, I have found Education and Income are the most significant predictors affecting the  customer response on seeking personal loan for ‘Thera bank’. Business strategies can be made by  concentrating more on these variables to increase the potential customers seeking personal loan.

Created multiple dashboards using Power BI:

Performed ETL & data visualization using Power BI | Extracted data to power BI by connecting to  multiple Microsoft office tools, SQL | Transformed data using Power Query | Performed Data Modelling using DAX functions, measures, mfunction and connecting multiple tables. My first blog on power BI is featured by Analytics-vidhya in their medium publication. https://medium.com/analytics-vidhya/a-complete-beginners-guide-on-power-bi-ed7d54a0b73e


Timeline

Data Analytics Lead

DoorDash
11.2021 - Current

Post Graduation Program - Data Science & Business Analytics

Great Learning in Collab With Texas McCombs
01.2019 - 09.2021

Professional Services Consultant

Epicor Software India Private LTD
05.2017 - 11.2021

Financial Analyst

Xerox Business Services India Private Limited
10.2015 - 5 2017

Finance Specialist

Siemens Technology and Services Pvt Ltd
01.2013 - 09.2015

Bachelor of Arts - Commerce

G.R. Damodaran College of Science
06.2007 - 04.2010

PUC -

Stanes Higher Secondary School
06.2005 - 04.2007

SSLC -

Defence Employees Matriculation School
06.2004 - 04.2005
Prasanna ChandranLead Data Analyst