Shantel Shephard

I am a

About Me

Data Analyst

  • Phone:  314.856.2972
  • City:  Saint Louis, Missouri
  • Status:  Available

I started my professional journey in the pharmaceutical sector, specifically concentrating on overseeing laboratory operations. Applying those experiences to my personal interest in horticulture, I transitioned to the agricultural industry to further develop my career. I obtained an associate degree in horticulture with a specialty in greenhouse management. In the field agricultural, I learned the importance of real-world problem solving using data collected from measurements and observations. From there, I earned a certificate in data analytics which allowed me to apply all of my skills to my ultimate passion of gathering, processing, interpreting and presenting data in order to support organizations in making well informed decisions.

Skills

Experienced individual skilled in collecting, converting and structuring data for the purpose of generating well-informed decisions while being flexible and adaptable in various situations. Exceptional knowledge and proficiency of platforms for effective data analyses, including spreadsheets, SQL, R, Tableau and Python. Strong communication, organizational, time-management and analytical skills. Recently achieved the following certifications: Google Data Analytics Certificate- a rigorous, hands-on curriculum that encompasses the entire framework of the data analysis process and Data Analysis with Python - covers topics such as data manipulation and cleaning, exploratory data analysis, data visualization, statistical analysis, and utilizing the models for prediction and decision making and Data Visualization with Python - a program that covers how to effectively utilize a variety of data visualization tools and techniques.

Perform SQL queries 85%
Create presentations from data analysis results 90%
Identify the data needs of users 95%
Data Analysis in Python 80%
Create data cleaning reports 100%
Sort and filter data in spreadsheets 90%
Run scripts in RStudio 90%
Data Visualization 95%

Resume

Horticulturist transitioning into Data Analyst role after obtaining the following certificates: Google Data Analytics Professional Certificate, Data Analytics with Python, and Data Visualization with Python. Diverse experience in production, communication and often exceed expectations in efficiency. Passionate about data-driven decision making and well-adaptable in fast paced environments. Over 6 years of collecting and transforming data while successfully increasing profits by offering alternatives while decreasing cost by 25%.

Summary

Shantel Shephard

  • Saint Louis, Missouri
  • 314.856.2972
  • SShephard0805@gmail.com

Education

Google Data Analytics Certificate

2022 - 2023
  • Gained an immersive understanding of the practices and processes used by data analysts in my day-to-day job
  • Learned key analytical skills (data cleaning, analysis and visualization) and tools (spreadsheets, SQL, R programming, Tableau and Python)
  • Skilled in cleaning and organizing data for analysis, and complete analysis and calculations using spreadsheets, SQL, R and Python programming
  • Learned how to visualize and present data findings in dashboards, presentations and commonly used visualization platforms

Data Analysis with Python

2023
  • Developed Python code for data cleaning and preparation, including handling missing values, formatting, normalization, and binning, using libraries such as Pandas, Numpy, and Scipy.
  • Perform data manipulation using dataframes, by summarizing data, analyzing the distribution of data, establishing correlations and constructing data pipelines.
  • Constructed and assessed regression models utilizing the scikit-learn library in machine learning, employing them for predictive purposes and informed decision-making.

Data Visualization with Python

2023
  • Created of a wide range of basic and advanced graphs and charts, including Waffle Charts, Area Plots, Histograms, Bar Charts, Pie Charts, Scatter Plots, Word Clouds and Choropleth Maps
  • Designed interactive dashboards that enable individuals with no prior Data Science experience to gain a clearer understanding of data
  • Utilized multiple Python data visualization libraries such as Matplotlib, Seaborn, Folium, Plotly, and Dash

Professional Experience

Horticultural

  • Worked with clients to understand aesthetical needs and translated those needs into physical results that saved $3,000 per project on average
  • Analyzed terrains for opportunities and impediments and executed installations and reformations to promote environmental prosperity
  • Managed the life cycle of herbicide tolerant crops, dicotyledons and weeds in controlled environments achieving a 100% survival rate for bioassays
  • Increased germination results by 45% by implementing new techniques for optimal propagation
  • Prepared data summaries and analyses to document laboratory operations and results.

Pharmaceutical

  • Pharmaceutical software proficiency
  • Pharmacy patient database management
  • Data gathering, interpretation and reviewal
  • Conducted complex sterile compounding such as TPNs and hazardous drugs
  • Ensured that medication orders were correct, complete and written clearly
  • Prepared medication orders and assisted in dispensing medications

Portfolio

The following section contains several case studies that I have completed in which demonstrates my knowledge and experience with SQL, R Studio, Tableau and Python. Each case study has been documented in the form of a notebook with a step-by-step guide of my analytical processes performed as well as visual charts for easy interpretation. I have also included a presentation for an additional case study that displays a summary of my results.

Bike Share Case Study

Fitness Tracker Case Study

Project 3

In Progress

Contact

Location:

St. Louis, Missouri

Call:

314.856.2972