Data Analyst Python

SAIPRASAD ANIL BAHULEKAR

United States 201-***-**** adi4k1@r.postjobfree.com

linkedin.com/in/saiprasadbahulekar/ github.com/SaiprasadBahulekar SUMMARY

Graduate professional with expertise in Tableau, Python, R, SQL, Machine Learning, Microsoft Power BI, Excel Macros, Excel Analytics, Qlik for Data Analysis and Business Intelligence needs over large data sets. EDUCATION

Rutgers University,Rutgers Business School, NJ

Master of Information Technology and Analytics (M.S) Dec 2020 Coursework: Data Analytics & Decision Making, Analytics Business Intelligence, Business Data Management, (GPA 3.8/4) Business Forecasting, Data Analysis, and Visualization, Machine Learning & Statistics, Business Analytical Programming, Data Mining, Project Management Mumbai University, India Bachelor of Electronics Engineering (B.E) Jun 2017 Vivekanand Education Society’s Institute of Technology TECHNICAL SKILLS

• Programming Languages: Python (SciPy, NumPy, Pandas, Matplotlib), R (ggplot2, dplyr, Shiny), C,, C++ PHP,MATLAB, SQL.

• Tools: R-studio, Tableau, Power BI, MySQL, SAS, Advanced Google Analytics, Advanced Excel Analytics, TIBCO Spotfire, PostgreSQL, AWS, GCP, Spyder, Anaconda, Django, VBA, Looker, QlikSense, QlikView.

• Certifications: DataCamp (DataScientist with Python), HackerRank (Gold in Python, SQL), Udemy (R for Data Science, Power BI, Master of Tableau, Looker, QlikSense), Udemy (Python, Machine Learning & Deep Learning), Advanced Google Analytics. WORK EXPERIENCE

Aryming Asset Funding & Capital LLC New Jersey,USA United States Business Data Analyst (Co-op) Sept 2020-Present

• Identified key metrics and built exec-facing dashboards using Tableau to track progress of business and high priority activities.

• Created 2 Joint Venture business proposal models which generated around 8 Million investment from the investors.

• Developed SQL queries that helped our IT department in the strategical approach towards the lien reports with the clients.

• Developed and applied advanced statistical models that helped investors understand dynamic business issues. Aryming Asset Funding & Capital LLC New Jersey,USA United States Data Analyst (Internship) May 2020-Aug 2020

• Designed and incorporated 6 exit strategies for the company’s business model which increased the net yearly revenue by 22%

• Participated in 8 Lien Note Auctions held by Chase Bank, CITI Bank, etc. through SITUS & Mountain View and won around 300 Lien Notes.

• Leveraged analytical techniques like data wrangling and data cleaning to use data to guide client and team decision making. Newton Power Team Pune, India Project Data Engineer Jul 2017-Feb 2019

• Processed Managed the light detailing project for a client to optimize the plants electrical output efficiency by 23% using regression models.

• Built dynamic dashboards in Tableau & Power BI for clients with analytical review which reduced the cost of production by 9%.

• Managed and updated the database using SQL. Utilized PHP for maintaining the backend and updating the features for the company’s website. Reported manager with QlikSense, Excel and Tableau visual/KPI reports. ACADEMIC PROJECTS

Analysis of Airbnb NYC (Python, Tableau)

• Preprocessed the Airbnb 2019 New York City dataset.

• Summarized each data variable and its significance with visual analysis to understand the relationship between the variables.

• Applied machine learning techniques and models for prediction with 80% accuracy. Forecasting and Financial Time Series (Pyrhon,R,Regression,Tableau)

• Used the S&P 500 index dataset from 2007 to 2019.

• Predicted the outcomes using the ARIMA, GARCH, ARCH, Naïve, Seasonal Naïve, Holts Winter, SES time series models for forecasting andfound an accuracy of 86.67%.

Heart Disease Prediction Analysis (Python,R,JSON, Excel, Tableau, Excel Pivot, Excel Macros, Excel Ad-Hoc)

• Collected Barcelona people’s dataset of about 17000 people and predicted whether the person will have heart attack or not depending on various parameter and applying logistic regression in R and Python and found an accuracy of 83%.

• Also did the KPI testing in Excel and Tableau along with visualization. ODS DBMS project (SQLite, XAMPP, Microsoft Access)

• Designed a library management systems database including ER data modeling and data mapping and implemented SQL Queries to extract and load the data.

• Implemented SQL Queries to extract and load the specific data as per requirement.

• Optimized data collection procedures and generated queries to get the required output. Bitcoin Price Prediction (Python,R, Tableau,TextBlob,GGPlot)

• Utilized datahub for bitcoin dataset from 2013 till 2018 and predicted the outcome using regression models in Python.

• Forecasted the values with the accuracy rate of 89%.

Contact this candidate