Summary
Overview
Work History
Education
Skills
Websites
Projects
Certification
Timeline
Generic

Deepa Palariya

Auburn Hills,United States

Summary

Detail-oriented Business Analytics graduate student seeking opportunities to leverage strong analytical, critical thinking, and problem-solving skills for driving business growth and efficiency. Proficient in data analysis, reporting, and management, with a solid understanding of database systems.

Overview

6
6
years of professional experience
1
1
Certification

Work History

Addressable Analyst Intern

Magna International
11.2023 - 03.2024
  • Conducted tech research and collected diverse data for market size projection
  • Utilized Python for implementing automated routines for addressable market sizing in emerging tech
  • Presented findings in Power BI, leveraging its visualization capabilities to communicate insights effectively.

Business/Data Analyst

S&P Global
01.2022 - 05.2022
  • Proficient use of iLEVEL - a cloud-based software for data management, evaluation, reporting, and presentation in the context of private equity clients
  • Extracted financial data from iLEVEL and performed data enhancement using both iLEVEL and advanced Excel functions
  • Utilized DAX functions like count, if, and sum to refine and calculate specific metrics and measures
  • Created portfolio reports and dynamic dashboards to effectively communicate findings.

Business/Data Analyst

Global Data/Genpact/Karvy
05.2018 - 10.2021
  • Proficient in utilizing advanced visualization tools such as Tableau and Power BI to create dynamic reports and visualizations for comprehensive financial analysis
  • Experienced in conducting meticulous data cleaning and preparation to refine datasets for meaningful insights and trend analysis
  • Skilled in leveraging advanced Excel-based data visualization tools and techniques to develop interactive dashboards and dynamic charts, effectively translating complex datasets into actionable insights for informed decision-making
  • Skilled in creating comprehensive financial reports for individual companies, encompassing their entire portfolio, and emphasizing crucial metrics for informed decision-making
  • Proficient in conducting in-depth secondary research for market insights.

Education

Master of Science - Business Analytics

Oakland University Graduate School
Rochester, MI
04.2024

Integrated BMS - MBA - Finance

Department of Management Studies, Kumaon University
India
01.2018

Skills

  • MSSQL
  • Microsoft Access
  • RDBMS
  • SSIS
  • SSAS
  • SSRS
  • Power BI
  • Tableau
  • Microsoft Excel (Advanced)
  • Python (Programming Language)

Websites

Projects

Strategic Safety Solutions: A Data-Driven Approach to Vehicle Design (RDBMS): 

  • Developed an RDBMS using Microsoft SQL Server for vehicle safety analysis.
  • Utilized SSIS for efficient data loading and transformation.
  • Conducted OLAP analysis with KPIs to extract safety insights.
  • Created comprehensive reports with SSRS and interactive dashboards with Power BI.
  • Leveraged MSSQL, MS Access, ETL (SSIS), and reporting tools (SSRS, Power BI).


Energy Consumption/Production: Time Series Forecasting (Python/R/ML/SAS):

  • Conducted predictive analysis to forecast energy consumption and production trends in the United States, spanning 1973 to 2017.
  • Utilized Python and R for data cleaning and preprocessing, identifying monthly seasonality.
  • Employed machine learning models including SARIMA, Exponential Smoothing, RNN, LSTM, GRU, and XGBoost, exhibiting higher accuracy.
  • Evaluated model performance using MAE and MSE metrics, showcasing ability to handle complex patterns.
    Incorporated economic variables using SAS, enhancing forecast precision and accuracy.
  • Incorporated economic variables using SAS, enhancing forecast precision and accuracy.


Gemstone Price Prediction (SAS):

  • Utilized SAS software for predictive analysis, employing Multiple Linear Regression, CART, and Neural Network techniques.
  • Predicted prices for 27,000 cubic zirconia gemstones.
  • Successfully identified profitable stones and key price- influencing factors.

Certification

  • Power BI: Certification issued by PwC and Forage
  • Crash Course on Python: Certification authorized by Google (Coursera)
  • SAS (Programming & Visual Analytics): Issued by SAS

Timeline

Addressable Analyst Intern

Magna International
11.2023 - 03.2024

Business/Data Analyst

S&P Global
01.2022 - 05.2022

Business/Data Analyst

Global Data/Genpact/Karvy
05.2018 - 10.2021

Master of Science - Business Analytics

Oakland University Graduate School

Integrated BMS - MBA - Finance

Department of Management Studies, Kumaon University
Deepa Palariya