Data Analyst

BHARATH HEBBAR

**************@*****.*** 480-***-****

https://www.linkedin.com/in/bharathhebbar/

SUMMARY

A data enthusiast skilled in analyzing and visualizing data to deliver valuable insights in a fast-growing environment. Advanced proficiency in Excel, SQL, Python & Tableau. Experienced in data analysis & reporting, data visualization and model building.

EDUCATION

Master of Science Arizona State University, USA Graduation Industrial Engineering GPA - 3.33/4 May - 2018

Bachelor of Engineering Visvesvaraya Technological University, INDIA Industrial Engineering GPA - 9.07/10 June -2015

Masters Coursework: Design of Experiments, Computational Statistics, Statistical Learning for Data Mining, Regression Analysis, Web Information Systems, Data Science for System Informatics, Quality Control TECHNICAL SKILLS

Analytical/ Visualization Tools: Base SAS, Tableau, JMP, SPSS, Power BI, Advanced Excel Programming/DBMS: R, Python, VBA, SAP, MySQL, Microsoft SQL, AMPL, Hadoop, Spark Statistics: Hypothesis Testing, DOE, A/B Testing, ANOVA, Resampling Methods, Subset selection RELEVANT EXPERIENCE

Data Analyst Intern Feb 2016 – July 2016

Bharat Electronics Limited (BEL), Bangalore INDIA (Excel, VBA, Tableau, SQL)

• Performed data wrangling of raw data using advanced MS Excel tools such as VLOOKUP, Formulas, Pivot tables, Macros, and SQL queries thereby increased working efficiency by 28%

• Created data visualization dashboards in Tableau to provide insights about KPIs (product time, cost)

• Developed Macros in VBA Excel to automate data loading in excel from SQL server and for computing cost estimations in Excel thereby saving 35% of working time

• Reporting the bi-weekly and monthly business metrics and creating visualization charts for the manager ACADEMIC PROJECTS

Decision Enabled System for a Manufacturing Unit (MySQL, VBA, Excel Solver)

• Optimized the product ordering process by designing and deploying the relational database using Excel VBA, SQL DBMS, Excel Solver

• Used SQL queries to load and retrieve the product data from the database

• Implemented a problem-solving algorithm (TSP) for the decision-making criteria for the unit

• Deployed VBA User forms and analyzed product orders to get insights of orders across dealers Prediction of House price using regression (Model Building) (Python)

• Developed a regression model to predict the Median house price for the Boston housing dataset

• Applied Lasso and Ridge regularization for the data to identify the important features

• Implemented SVM, Random Forest, Logistic Regression & XGBoost algorithms to predict the click through rate on Click Through Rate Prediction dataset Exploratory Data Analysis of Prosper Loan Data (Tableau)

• Performed data cleaning of the loan data which had over 100000 observations and 81 features

• Visualized features in tableau to analyze the distribution of data across those features

• Created visualization dashboards for the important features to visualize the trends and to draw further insights which aided in model building

• Implemented log-transformations, feature hashing, to prepare the data for further analysis Optimization of Wireless Internet Experience, DOE (JMP, Design Expert)

• Performed a 2^3 full factorial experiment to analyze the factors affecting the Wi-Fi signal strength

• Analyzed the ANOVA table to evaluate the performance of the model and to visualize factor effects

• Tuned the model to improve R squared value to 0.98 from 0.74 thereby optimizing the Wi-Fi strength Model building using Machine Learning Algorithms (R, Python)

• Applied Machine Learning algorithms to ‘Heart Volume’ data to obtain the model with minimum error

• Evaluated the performance of different penalized estimators based on the model MSE

• Created a step function to perform stepwise model selection based on ‘Robust Stepwise Regression’

Contact this candidate