Data Analyst

TECHNICAL SKILLS

Database : SQL (MySQL, PostgreSQL), NoSQL

Scripting languages : Python, R

Data Visualization : Tableau, Power BI, Advanced Excel (Solver, decision tree, Macros, pivot tables, VLOOKUP’s) Distributed systems & tools : Hadoop/MapReduce, Spark, AWS, Jupyter Notebook, Git, Heroku, Linux Experience in : Data optimization, Database management, Time series Forecasting, Data mining, Data wrangling, Data modeling and Reporting

ML techniques : Regression, Classification, Cluster analysis, Decision Trees, Ensemble learning, A/B Testing, Principal Components, Bootstrap & Boosting and Time Series Analysis Python Libraries : Scikit-Learn, NumPy, Pandas, Matplotlib, Plotly, Seaborn, Folium, SciPy WORK EXPERIENCE

Korrun Bangalore, India

Data Analyst 11/2017- 1/2019

● Performed in-depth financial and operational due diligence on prospective investments by analyzing market trends, competition, and potential growth opportunities

● Collaborated with marketers to identify areas of opportunity for a data science solution, and translated business questions into statistical models, visualizations, and analysis

● Contributed to the workforce efficiency plan by recommending actions that decrease the labor costs by over $300k

● Completed a 3,000-row data spreadsheet with the use of self-taught Excel Macros (VBA) in less than two weeks to increase the efficiency of the data integrity process

● Developed customer segmentation and predictive modeling for a variety of products, leveraging advanced analytics to improve the efficiency of the marketing campaigns and communicated actionable insights with executives to support data driven decision making

● Performed data visualization by leveraging calculated field, interactive dashboards and created storyline using Tableau CLASS PROJECTS

End-to-End Machine learning project - Flight fare prediction

● Built a machine learning web application which successfully predicts the flight fare for future dates

● Completed End-to-End implementation by creating a Flask App and deployed on Heroku platform

● The application is expected to assist tourists on choosing the travel dates and travel on budget

● Tech Stack & Algorithm used: Random Forest Regressor, Python, Jupyter Notebook, Flask and Heroku Real life Healthcare Chatbot with IBM Watson assistant and IBM cloud functions

● Built a real life chatbot that detects 445+ health problems by recognizing 280+ symptoms

● The chatbot is anticipated to help patients to get a detailed description of the condition and the treatment required

● Tech Stack used: Python, IBM Watson assistant, IBM cloud services Times Series Forecasting - US Private Housing starts

● Statistical analysis and forecasting of housing starts is carried out using advanced time series forecasting methods

● Used Moving Average, Multiple regression models, Holt’s Winter model and ARIMA models in forecasting

● Plots of the series and autocorrelation function is used to analyze the series

● Tech Stack used: R, R-studio, and MS-Excel

Web scraping and prediction modeling on Zillow.com

● Used Beautiful Soup to scrape housing data of 1000+ properties in SFO bay area and built a dataset for exploration

● Cleaned and pre-processed the data and built a linear regression model to compare the predicted value and the z- estimate of property prices

● Tech Stack used: Python, Jupyter Notebook, NumPy, pandas, Beautiful soup, Sklearn and Tableau Covid-19 tweet classification – Analyze 200K+ tweets to identify human or bot

● Developed a Classification Model to identify human/bot Covid-19 Tweet using Twython, SQLite, SQLalchemy.

● Developed a 3 layered neural network-based retrieval chatbot that answers Covid-19 related FAQs with 99% Accuracy using Keras sequential API using Relu and Softmax activation function and SGD as optimizer

● Tech Stack used: Twython, SQLite, SQL alchemy, NLTK, LSTM and RNN EDUCATION

California State University, East Bay Hayward, CA

Candidate for Master of Science in Business Analytics, Cumulative GPA: 3.6/4.00 5/2021 Visvesvaraya Technological University Bangalore, India Candidate for Bachelor of Engineering in Electronics & Instrumentation 8/2017 ACCOMPLISHMENTS

ANZ Bank Virtual Experience Program participant

● Tasks completed- Exploratory data analysis, Geospatial analysis & Predictive Modeling AKSHAY BHAT

adkdkh@r.postjobfree.com Hayward, CA 94542

www.linkedin.com/in/akshaygbhat 510-***-****

https://github.com/akshaybhatt0095

Contact this candidate