Alex Conerly
Hattiesburg,MS
Summary
Data Analyst with 3+ years experience and a passion for helping businesses find insights in Big Data. Looking to transition to a full-stack data scientist role. Skilled in using programming languages and technologies such as Python, SQL, Excel, JavaScript, R, Tableau, machine learning and AI to solve real-world problems.
Overview
3
3
years of professional experience
Work History
Data Analyst/Developer
Duff Capital Investors/Southern Tire Mart
03.2021 - Current
- Developed Python-based reports, analytics, and interactive visualizations for strategic account managers, store managers, and business owners to enhance efficiency and aid decision-making.
- Optimized company inventory levels through exploratory data analysis of store buying and selling patterns using advanced SQL, python, and excel.
- Collaborated with software developers, data architects, and data engineers to meet company goals through daily scrum meetings.
- Designed and automated Python scripts from SQL data analysis to help stores identify slow-moving inventory and collaborate with one another to reduce overstock and improve sales.
Education
Data Analytics 24-week Bootcamp Certificate
Vanderbilt University
Nashville, TN2021
Data Analytics Jumpstart Course Certificate
Nashville Software School
2020
BBA - Business Administration
University Of Mississippi
Oxford MS2008
Skills
- Python
- SQL
- R
- Excel
- Tableau
- Machine Learning
- HTML/CSS
- Javascript
- Git
- Visualizations
- Statistics
Sample Projects
Project: Predicting Nashville Airbnb Prices
GitHub Link: github.com/alexconerly/Predicting_Airbnb_Prices
Live Demo: airbnb-price-prediction-stage.herokuapp.com/
- Using historical airbnb data, compared machine learning models to predict airbnb prices and create a dynamic website for users to find suitable price. Project manager, collaborated with team, ETL, data cleaning/engineering, statistics, website creation and deployment.
- Tools: Python 3, Machine Learning, VS Code, Pandas, Numpy, Sklearn, Plotly, HTML/CSS, JavaScript, Heroku, Flask, PostgreSQL, Tensorflow, Matlplotlib
Project: Pewlett-Hackard Employee SQL Analysis
GitHub Link: github.com/alexconerly/Pewlett-Hackard-Analysis
- Used SQL analysis to aid a company in analyzing employee data to safeguard the HR dept from overload of retiring employees. ERD diagrams, DB queries, data engineering, groupby/orderby functions
- Tools: PostgreSQL, Quickdbd.com, Excel, PgAdmin, Visual Studio Code
Project: MechaCar Statistical Analysis with R Programming
GitHub Link: github.com/alexconerly/MechaCar_Statistical_Analysis
- Used R Programming to perform statistical tests to aid a car manufacturing team in uncovering insights about needed improvements in a vehicle prototype. Required linear regression, T-tests, summary statistics analyses, use of significance levels and p-values to determine whether to reject null hypotheses
- Tools: Python 3, Jupyter Notebook, Visual Studio Code, pandas, scikit-learn
Timeline
Data Analyst/Developer
Duff Capital Investors/Southern Tire Mart
03.2021 - Current
Data Analytics 24-week Bootcamp Certificate
Vanderbilt University
Data Analytics Jumpstart Course Certificate
Nashville Software School
BBA - Business Administration
University Of Mississippi
Similar Profiles
Howard J. Aubuchon Jr.Howard J. Aubuchon Jr.
Route Delivery Driver at Friend Tire / Southern Tire MartRoute Delivery Driver at Friend Tire / Southern Tire Mart
Ernest BlandErnest Bland
Delivery Driver at Friend Tire/ Southern Tire MartDelivery Driver at Friend Tire/ Southern Tire Mart
Jessie JonesJessie Jones
General Manager at Southern Tire Mart at PilotGeneral Manager at Southern Tire Mart at Pilot