Data Analyst Python

Ujjual Ramachandran

****SW **th St HH-***, Gainesville, FL, 32608 352-***-**** ********@*****.*** www.linkedin.com/in/ujjualr https://github.com/ujjualr

SUMMARY: A data analyst with 3 years of experience with substantial know-how on implementing Data Mining, Business Intelligence and Statistical Machine Learning Solutions to various business domains to drive growth and influence business decisions PROFESSIONAL EXPERIENCE

University of Florida: School of Forest Resources and Conservation September 2019-May 2020 Business Data Analyst Gainesville, FL

• Built new databases, macros and optimized access to tables using SQL queries which optimized the turnaround time by 15%

• Performed data pre-processing to clean, eliminate outliers and conducted data exploration to detect correlation, trends, and patterns

• Produced ad-hoc reports as requested which analyzed various metrics used for budget evaluation and monitoring UF Information Technology: Enterprise Systems July 2019-August 2019 Data Analytics and Reporting Intern Gainesville, FL

• Performed statistical analysis ( Hypothesis testing, Multiple linear regression, and ANOVA tests) using SPSS and R

• Conducted regular data quality checks ensuring accuracy, consistency, and completeness of the data

• Forecasted the performance of various growth initiatives, revenue and other KPI’s using predictive models in Python and SAS/SPSS on UF alumni dataset with 50k records to amplify the performance of the UF Career Service MITCO January 2017 – May 2018

Data Analyst Ajman, United Arab Emirates

• Dropped project lag by 20% by analyzing 10M+ rows of schedule data from clients using Python and SAS

• Enforced compliance with company policies and federal laws for managing personnel and ensuring 100% project success

• Generated result-oriented data models using Visio and Tableau dashboards that monitored KPI’s and provided strategic recommendations to solve business problems

Future Supply Chain Solutions LTD June 2016 – December 2016 Data Analyst Bengaluru, India

• Optimized standard operational procedures that improved the accuracy of the order fulfillment system by more than 15%

• Analyzed key operation metrics utilizing Excel and Tableau to chart numerous measures on a weekly, monthly, and quarterly basis

• Designed databases with more than 50k records using SQL and used Tableau dashboards to track benchmarks

• Enhanced supply chain inventory forecasting which reduced backorders to retail partners by 17% PROJECTS

Business Insights for ECommerce Website (Python- sklearn, R-Apriori, Visio, SQL, MS -Excel &Access) Spring 2019 Performed customer segmentation using k-means clustering on behavioral data of customers and market basket analysis to discover cross-selling product patterns to provide product recommendations Exploratory Analysis on Google Job Openings (Python-numpy, pandas, matplotlib, seaborn, R-ggplot, Tableau) Fall 2019 Developed dashboard stories using Tableau to demonstrate job market shifts and trends. Developed statistical model and performed text mining using Python, R and STATA to identify minimum job experience and skills for every job opportunity Heart Disease Classification using KNeighborsClassifier (Python- numpy, pandas, seaborn, sklearn) Spring 2020 Produced a model to predict if a patient has heart disease. Utilized the elbow method to identify k and achieved an accuracy of 86% Wine Classification Using Neural Networks (Python-sklearn, numpy, pandas, TensorFlow Keras) Spring 2020 Developed a model in Google-Colab notebook that classifies the type of wine and achieved a test accuracy of 87% EDUCATION

University of Florida, Hough Graduate School of Business April 2020 MS, Information Systems and Operations Management GPA: 3.88 Gainesville, FL Visvesvaraya National Institute of Technology September 2016 BS, Electrical and Electronics Engineering Nagpur, India TECHNICAL SKILLS

Programming/ Scripting Languages: Python, SQL, R, C++, SAS, VBA, JavaScript Databases/Business Intelligence: MySQL, MS Access, SSIS Statistical Tools: IBM SPSS Statistics, JMP, STATA Modeling/Analysis: Classification, Regression, Clustering, Dimensionality Reduction, ARIMA, Hypothesis Testing, ANOVA Data Visualization Tools: MS Excel (V/H lookups, solver, pivot tables), Visio, Tableau, IBM Cognos Analytics, QlikView

Contact this candidate