KUNJ MITHAPARA

Boston, MA adhcse@r.postjobfree.com 857-***-**** www.linkedin.com/in/kunjmithapara https://github.com/kunj1995/ EDUCATION

Northeastern University, Boston, MA

Master of Science in Industrial Engineering (Data Science), GPA 3.89 Dec 2021 Relevant Courses: Data Warehousing and Business Intelligence, Visualization, Data Management, Data Mining, Operations Research Gujarat Technological University, Gujarat, India

Bachelor of Engineering in Mechanical Engineering June 2012 - May 2016 SKILLS

• Database and Big Data Technologies: My SQL, MS SQL, Postgres SQL, Cassandra, Spark, Airflow, SQL Alchemy

• BI Tools & Libraries: Tableau, Power BI, Advanced MS Excel, Visual Studio, Looker, RStudio, ggplot2 (R)

• Cloud Technologies: AWS (RDS, Redshift, S3), Athena

• Programming Languages: R, Python, SQL, SAS, VBA

• Project Management tools: JIRA, Confluence, GitHub

• Certifications: Data Engineering Nanodegree

ACADEMIC EXPERIENCE

Cloud Data Warehousing for a music streaming application (PySpark, Redshift, Apache Airflow) Aug 2020

• Created star schema in Apache Cassandra and developed ETL using PySpark to extract real time music streaming data from S3

• Performed data wrangling and data validation using Spark SQL library and ingested in AWS Redshift for advanced analytics

• Deployed and scheduled Spark application to automate process with daily ingestion of data using Airflow Capstone project - Udacity data engineering (Python, Jupiter notebook, S3) Sep 2020

• Performed Web Scrapping and data wrangling using Python to drop all rows with invalid or duplicate values from I94 Immigration and temperature datasets

• Designed and developed an ETL framework in Python to integrate data into facts and dimensions tables

• Computed ETL framework to identify effects of temperature on number of visitors at different locations Prediction of buying intention of a customer on an eCommerce website (R (ggplot 2), R Studio) Jan 2020

• Executed data wrangling, feature selection and descriptive analysis in R to gain valuable observations of website visitors

• Anticipated whether customer will purchase or not from an eCommerce site, by utilizing various classification models like Random Forest, Neural Nets, Logistic Regression and Naïve Bayes and evaluated their performances Database development for online real estate brokers (Python (pandas, NumPy), My SQL) Jan 2020

• Designed a database to integrate broker data, real estate type, location and pricing module in MySQL and MongoDB

• Implemented stored procedure to increase tracking of real estate sale, pricing and order cancellation by 15%

• Integrated Python with My SQL Database to visualize and analyze market buying, pricing and other trends PROFESSIONAL EXPERIENCE

Power Master Industries, Gujarat, India (Tableau, Python (Pandas, NumPy), Rest API, MS SQL, Excel) Jan 2018 - May 2019 Operations Analyst

• Developed ETL using SSIS packages and designed mappings between source and data flow tasks to load data in MS SQL Server

• Designed various interactive dashboards in Tableau to monitor and analyze data to make critical engineering decisions

• Visualized data using scatter plots, cross tables, box charts, bar charts, density charts in Tableau

• Created different KPIs using calculated key figures and parameters in Tableau

• Fetched organization’s sensor data by developing Rest API in Flask and provided it for the further use of the analytics teams

• Generated actionable insights using Python (Pandas, NumPy) which reduced equipment/production down time by 12%

• Constructed monthly dashboard with Macros and VBA to improve efficiency and reducing manual work by 8%

• Evaluated data using MS Excel to identify shortfalls, provided recommendations for improvement to stack holders

• Predicted chances of defects in different products using advanced statistical techniques like linear and logistic regression in R

• Authored technical training module for tools to be utilized by team and provided training to new employees Bosch Rexroth (India) Private Limited, Gujarat, India (R, R Shiny, Excel) Dec 2016 - Dec 2017 Apprentice Engineer

• Analyzed past data using R to identify recommendations for improvement in sourcing strategies as per existing requirements

• Developed customized R Shiny Web App to assist product manager to understand functionality of a product

• Created monthly reports in MS Excel using Pivot Tables and Vlookup to track product performance

• Conducted audit to map business processes, developed and implemented an action plan to achieve a 7% reduction in lead time

• Performed product quantity analysis to identify highest to lowest product demand and optimized floor space by 14%

• Exercised SCRUM PDLC for continuous product integration by sprint planning, backlog refinement and task management

Contact this candidate