Summary
Overview
Work History
Education
Skills
Technicalcompetency
Projects
Timeline
Generic

Palash Bhivgade

Austin,TX

Summary

Background includes data mining, warehousing, and analytics. Quality-driven and hardworking with excellent communication and project management skills.

Overview

9
9
years of professional experience

Work History

Data Engineer

Apple Inc.
03.2020 - Current
  • Executing engaging, effective reporting, along with data analytics programs and initiatives
  • Designing and implementing structure, focus, and standardization within a reporting and data analytics environment, including the development of standard methodologies across functions and regions
  • Utilized quantitative analysis and aptitude for synthesizing complex data into key insights by building automated reports in Tableau reducing the manual hours of every project manager by around 40%
  • Consolidated, gathered and optimized data in Snowflake SQL by writing and modifying scripts in github
  • Automated and optimized the data by creating data pipelines in python
  • Supported various lines of businesses by collaborating with the business stake holders and helped them make key decisions by presenting key insights
  • Building design document, creating prototypes, impact assessment and playback the impact statement
  • Collaborating with data warehouse architects and software developers to generate business intelligence including producing actionable reporting from both enterprise and custom tools for end users
  • Presenting results of analysis to business units, utilizing both real-time strategies (for example using Webex, Tableau, Keynote or Executive Presentation) and automated functionality tool such as Python-drive alerting systems that help push actionable data when actions are needed by business.

Data Analyst

Michael Page/PTS Consulting / State Street
09.2019 - 02.2020
  • Analyzed data in excel and tableau to track server development phases for Lifecycle management team
  • Responsible for designing reports in tableau by collecting and mapping data from various databases to track development phase of server and applications for Project Managers.

Data Analyst

Dassault Systemes
05.2018 - 11.2018
  • Analyzed data of 5 million free users for Draftsight CAD software to predict the subscription conversion rate
  • Cleaned the data in R to get users insights from different countries and companies
  • Monitored the user traffic on web pages and created KPI reports using Google Analytics for Digital marketing
  • Created visually impactful dashboard on tableau to get the trend of users for the CAD software
  • Scraped data using API in python to track companies using 2D and 3D software users
  • Used quantitative data gathered to develop an understanding of customer behavior and demographics
  • Presented data using tableau that helped guide decisions of company to take the product from free to pay
  • Worked with sales and marketing team to prepare targets for resellers.

Business Analyst/Data Analyst

Salve Software Services
11.2015 - 12.2016
  • Designed complex reports using Cascading parameters, Drill-Through Reports, Parameterized Reports, Sub reports and AdHoc reports using SQL Server Reporting Services (SSRS)
  • Applied technical skills using Tableau and SQL in data collection, data analysis and reporting to procure data from database structures to report and provide solutions to client request in a timely manner
  • Formulated new stored procedure, views and functions based on the requirement to support the ETL.

Education

Master of Science - Industrial Engineering (Data Analytics) -

Northeastern University
Boston, MA
05.2019

Bachelor of Engineering in Mechanical - undefined

Nagpur University
07.2015

Skills

  • Data Migration
  • Machine Learning
  • Data Modeling
  • Data Warehousing
  • SQL and Databases
  • Business Intelligence
  • Data Analysis

Technicalcompetency

R(plotly, ggplot2, dplyr), Python (pandas, matplotib, plotly, numpy, H2O), Java, Spark, Tableau, Power BI, Google Analytics, Excel, SQL, Looker, HTML, MS Azure, AWS, Oracle, MySQL, MS SQL Server, PostgreSQL, Access, Teradata, Classification, Modelling, Principal Component Analysis, Hypothesis testing, Time series, Quantitative Modeling (Coursera), Machine/Deep Learning (Udemy), Google Analytics, AutoCAD, Visual Studio, Toad data modeler, SSIS, Talend Data Integration, SSRS, Jenkins, Snowflake

Projects

Analysis of Appliances-Energy-Prediction Dataset (Python), 01/2018 - 03/2018, Applied exploratory data analysis using Pandas profiling to calculate energy consumption for appliances, Performed feature selection using Boruta and tsfresh and created final pipeline using docker

Timeline

Data Engineer

Apple Inc.
03.2020 - Current

Data Analyst

Michael Page/PTS Consulting / State Street
09.2019 - 02.2020

Data Analyst

Dassault Systemes
05.2018 - 11.2018

Business Analyst/Data Analyst

Salve Software Services
11.2015 - 12.2016

Master of Science - Industrial Engineering (Data Analytics) -

Northeastern University

Bachelor of Engineering in Mechanical - undefined

Nagpur University

Similar Profiles

CREATE PROFILE
Palash Bhivgade