Data Analyst Entry
Resume:
DEEPANSH ARORA
EDUCATION
Mobile
********@*****.***
www.linkedin.com/in/deepansh777
GitHub
https://github.com/Deepansh777
Wichita State University, Wichita, KS Aug 2020 - May 2022 Master of Science in Industrial Engineering, Concentration: Data Analytics GPA: 3.97/4.0 Coursework: Statistical Methods for Engineers, Introduction to Data Mining and Analytics, Big Data Analytics in Engineering, Forecasting and Analytics, Machine Learning, Introduction to Database Systems Wichita State University, Wichita, KS Aug 2016 - Jul 2020 Bachelor of Science in Aerospace Engineering, Minor: Mathematics GPA: 3.64/4.0 Analytical Tools: Power BI, Tableau, Advanced Excel, SAP, Statgraphics Programming Languages: R, Python, T-SQL, HTML, CSS, MATLAB Database: MySQL, Microsoft SQL Server, Microsoft Access Packages: Scikit-Learn, NumPy, Pandas, BeautifulSoup, Matplotlib, seaborn, ggplot2, Plotly, Tidyverse, dplyr, purrr Data Analyst Intern (Virtual Internship) Mar 2021 – Jul 2021 PartRunner
Built multiple SQL queries and functions in R to automate data reporting of weekly and monthly sales, operations, and customer success reports.
Developed interactive and dynamic KPI dashboards in Tableau to increase the scalability and making the storytelling process more efficient
Developed an R Shiny app to track the pickup and delivery of orders in real time. This helped company in saving thousands of dollars by effectively assigning drivers based on their real time locations.
Communicated and presented insights clearly to the leadership of the organization Research Assistant May 2019 – Mar 2020
Advanced Coatings Laboratory, National Institute for Aviation & Research, Wichita, KS
Collected, compiled, and visualized metallurgical data using Power BI
Performed corrosion analysis, using EIS techniques, on metals and 3D printed materials
Performed statistical analysis on Corrosion data using R TECHNICAL SKILLS
EXPERIENCE
CERTIFICATIONS
Microsoft Certified: Data Analyst Associate (DA100 - Analyzing Data with Microsoft Power BI) Microsoft Certified: Azure Data Fundamentals (DP900) Data Analyst Nov 2021 – Present
ProviDRs Care, Wichita, KS
Developed performance reports evaluating the Primary Care Physicians’ (PCPs) performance in the network. Statistical Methods were used to tier the Providers based on their performance in different domains
Worked with Employer groups to help them understand which members are driving the cost. Several different metrics were calculated like Admission Per Member Per Month (PMPM), Admission Per 1000 members, and Re-Admissions.
Developed Employer Reporting to help Employers understand which chronic diseases are common amongst their members. The reporting also highlighted the Total Per Member Per Month Spend, Referral Rate, and Savings Opportunity
Classification Machine Learning Algorithm was used to predict which members are more likely to cause a high dollar claim in the future. The algorithm was embedded in the RShiny Web App which used Real Time Claims data to classify the members as high cost or low cost Members. The web app was regularly accessed by the Care Navigator team who would then contact those members and educate them. This application helped many employer groups in saving thousands of dollars each month.
Developed an algorithm to incentivize the PCPs based on their performance in different domains (i.e. Quality, Access). RShiny app was developed which allowed user to change the parameters and adjust the PCP incentives. Data Science Graduate Research Assistant Mar 2020 – Dec 2021 Emerging Technologies, & CAD/CAM Laboratory, National Institute for Aviation & Research, Wichita, KS
Created database schema and number of database objects like tables, views, stored procedures using SQL Server management studio
Developed several automated procedures for weekly reporting using R Shiny, leading to reduced development time
Designed complex data-intensive reports in Power BI utilizing various graph features such as Key Influencers, donut, network for better analysis
Developed Classification Machine Learning Models using R to optimize the Additive Manufacturing Parameters
Developed R Shiny Web Application to evaluate the Additive Manufacturing Machines’ log data
Built input forms and report forms in MS Access to make the data entry process simple and less time consuming
Contact this candidate