ABOUT ME
» TECHNICAL KNOWLEDGE «
- Data Collection
- Web scraping with BeautifulSoup and Selenium
- API integration
- Survey design
- ETL Pipeline Design and Management
- Automating and implementing ETL processes
- Relational Database Management
- RDBMS: MySQL, PostgreSQL, SQL Server
- Schema design, data normalization and denormalization, data partitioning and indexing
- Data Cleaning & Wrangling
- Cleaning and transforming data
- Handling missing values and outliers (imputation, removal)
- Data integration and aggregation (combining data from different sources into a unified dataset)
- Tools: Pandas and NumPy (SciPy)
- Statistical Analysis & Modeling
- Hypothesis testing
- Descriptive and inferential statistics
- Probability theory
- Bayesian statistics
- Machine Learning
- Supervised and unsupervised learning techniques
- Regression, classification, neural networks, clustering, and dimensionality reduction
- Model evaluation and selection (cross-validation, A/B testing and optimization)
- Feature engineering
- Tools: Scikit-learn, Statsmodels, TensorFlow, Keras, lightGBM
- Data Visualization and Reporting
- Dashboards and reports: Tableau, Looker Studio, Power BI
- Python Tools: Matplotlib, Seaborn, Plotly
- Cloud Platform Familiarity
- Microsoft Azure (most used platform, working towards certification), AWS (certified), Google Cloud
- ETL/ELT Pipeline Design and Management
- Automating and implementing ETL/ELT processes using tools like Azure Data Factory, AWS Glue, and dbt (data build tool)
- Designing and implementing efficient ETL and ELT processes
- Building and maintaining data pipelines
- Utilizing tools like Apache Spark and Hadoop for large-scale data processing
- Data Storage and Management
- Experience with data lake platforms including Azure Data Lake Storage and Amazon S3
- Knowledge of data warehousing solutions like Azure Synapse Analytics, Amazon Redshift, and BigQuery
- Familiarity with SQL (MySQL, PostgreSQL) and NoSQL (MongoDB) databases
- Data Integration and Interoperability
- Integrating various data sources through RESTful APIs or GraphQL
- Knowledge of different data formats (CSV, JSON, Parquet, etc) and their appropriate use cases
- Data Warehousing and Business Intelligence
- Azure Synapse Analytics, Amazon Redshift, Google BigQuery
- SQL Querying and Optimization
- Advanced SQL querying, SQL optimization techniques, window functions, CTEs (Common Table Expressions)
- Database Design and Schema Development
- ER modeling, normalization, dimensional modeling, star and snowflake schemas
- Performance Tuning and Indexing
- Query profiling and optimization, indexing strategies, partitioning, sharding
- Data Security and Compliance
- Familiarity with implementing security best practices, data encryption, and access controls via role-based access control (RBAC) and IAM (Identity and Access Management)
- Knowledge of regulatory requirements like GDPR, CCPA, HIPAA, and ensuring data practices are compliant
- Containerization and Orchestration
- Docker, Kubernetes
- Machine Learning Integration
- MLFlow, TensorFlow, PyTorch
- Version Control
- Git, Github
- Development Practices
- CI/CD, DevOps principles, automated testing
- Python
- Pandas, NumPy, SciPy, Scikit-learn, Statsmodels, Plotly, Matplotlib, Seaborn, BeautifulSoup, Selenium
- SQL
- DDL and DML
- Familiarity with RDBMS (MySQL, PostgreSQL)
- HTML, CSS, JavaScript
- Bootstrap, jQuery, React, Node.js
Also familiar with PHP, Java, C#, and C++ and most CMS platforms, including WordPress, Shopify, BigCommerce, SquareSpace, Joomla, and Drupal
- Python Libraries
- Matplotlib, Seaborn, Plotly
- Data Visualization Tools
- Looker Studio (Google Data Studio)
- Tableau
- Power BI
- Google Analytics (GA4, UA)
- Google Tag Manager (GTM)
- Google Search Console
- SEMRush
- Google PageSpeed Insights
- GTMetrix
- Screaming Frog
- Hotjar
- Ahrefs
- Google Keyword Planner
- Google Ads
- Search, Display, Video, Shopping, Performance Max, App
- Organic & Paid Social
- Facebook, Instagram, Snapchat, TikTok, LinkedIn
- Streaming
- YouTube, Hulu
- MailChimp
- Salesforce
- HubSpot
- Microsoft Suite
- Excel (VLOOKUP, Pivot Tables, Conditional Formatting), PowerPoint, Word, Outlook, Access
- Google Suite
- Sheets, Slides, Docs, Drive
» EDUCATION «
- Masters of Science in Data Analytics with a Specialization in Data Engineering, Western Governors University, Expected: Dec 2024
- Bachelor of Science in Computer Science, Western Governors University, Jun 2023
- Bachelor of Arts in Anthropology, University of Montana, May 2015
- WGU Certificate: Data Preparation, Credential ID: 65e273590d88f060be6a8cd4
- AWS Certified Cloud Practitioner, Credential ID: Q5W20LCK0FF1Q55G
- ITIL 4 – IT Service Management, Credential ID: GR671475483HB
- Google Analytics Certified, Credential ID: 144781538
- Google Ads – Display Certification, Credential ID: 144288927
- Google Ads – Measurement Certification, Credential ID: 144269381
- Google Ads – Search Certification, Credential ID: 38886503
- Google Ads – Video Certification, Credential ID: 81038461
» INDUSTRY FAMILIARITY «
Below is a selection of industries and organizations I’ve worked with, highlighting my ability to work with diverse business types.
- A-Abel Family of Companies – HVAC, Electric, Plumbing
- Go2Pros Pest Control
- KBD (Kitchens by Design)
- General Tree Company
- Huber Management Corp.
- Solar Shade Truck & Car Paradise
- Solid Rock Roofing
- Denise Swick & Co. Real Estate
- PRG (Premier Resources Group) Team – Construction Staffing
- CURT (Construction Users Roundtable) – Construction
- Retrofix Games
- Cincy T-Shirt Co.
- Brock’s Performance
- The Shopping Bag
- Karma Kollective
- Jaffe Jewelers
- Bloombeads
- BHA Piano
- Smedleys Chevrolet
- Beau Townsend Ford
- Beau Townsend Nissan
- Ride 1 Powersports
- Dyer, Mann, Garofalo, & Schultz L.P.A.
- The Clardy Law Firm
- Weaver Law
- Franklin D Azar & Associates
- McGarity Law Firm
- Poelking Wellness (Chiropractic Care & Physical Therapy)
- Pot Card Online (Online MMJ Provider)
- Dr. Richard W. Teeters (Chiropractic Care)
- Dr. Thomas C. Volck (Dental)
- Fountain of Youth (Med Spa)
- YMCA of Greater Dayton
- NCCJ of Greater Dayton
- For Love Of Children (FLOC)
- Stop Bullying Dayton
- Christmas for Kids
- Safe Birth Project
Judicial
- Magistrate G. Parker for Judge*
- Mary Montgomery for Judge*
- Marshall Lachman for Judge
- Solle for Judge*
- Arvin Miller for Judge
- Tony Schoen for Judge
- Julie Bruns for Judge*
City Government
- Woods for Vandalia City Council
- Sinclair Community College
- Chaminade Julienne High School
- Cousin Vinny’s Pizza (all locations)
- Tessora Liqueurs
» OUTSIDE OF MY CAREER «
When I’m not hunkered down behind a computer screen, I enjoy being out in nature – hiking throughout Ohio and my home state of Montana with my fiancé and our corgi, foraging for huckleberries & paw paw fruit, kayaking, hunting, fishing, and gardening (or, at least, attempting to make things grow).
Indoors, I enjoy painting landscapes and abstract portraits with acrylics & watercolors, baking, binge watching fantasy & sci-fi shows and movies, and hosting board game/D&D nights and painting parties with my friends.
I also have a unique passion for entomology that stems from my educational background in forensic anthropology – I enjoy ethically collecting, pinning, and preserving butterfly, moth & other insect specimens. If we ever chat over video, you might see a gallery of some of my collection in the background!
DATA ANALYTICS &
DATA SCIENCE PORTFOLIO
During my Master of Science in Data Analytics program, I gained comprehensive experience in the data analytics lifecycle by working on a diverse range of projects. These projects encompassed each critical stage, from identifying and defining the business problem to drawing actionable insights and evaluating the results.
Exploratory Data Analysis Project
About
This project dove into key statistical concepts, including calculating and interpreting mean, median, and mode to summarize data, measuring the relationship between variables to identify patterns and trends, quantifying the spread of data using standard deviation and variance, applying statistical tests to evaluate hypotheses and draw conclusions about data, and developing effective communication skills to present data insights and findings to stakeholders.
Tools & Technologies Used:
Python (Pandas, Scikit-Learn, Matplotlib, Seaborn), Jupyter Notebook
Data Cleaning Project
About
Through this project, I honed my data preparation skills, identifying data quality issues, exploring and transforming medical data, handling outliers, and imputing missing values. I wrote code to effectively manipulate, structure, and clean the data, ultimately preparing it for analysis and even reducing its dimensionality for improved efficiency.
Tools & Technologies Used:
Python (Pandas, NumPy, Scikit-Learn, Matplotlib, Plotly), Jupyter Notebook
Data Acquisition Project
About
In this data acquisition project, I expanded my SQL skillset by working with PostgreSQL (beyond my prior experience with MySQL), gaining practical experience in data transfer techniques and the ability to manipulate data within a relational database for use by a large national internet and cable provider. The project challenged me to analyze data availability, considering factors like dimensionality, quality, relationships, and limitations. I successfully built a physical data model and crafted SQL queries to acquire data for further analysis.
Tools & Technologies Used:
SQL, PostgreSQL
Data Visualization
Dashboard & Report Examples
Examples of my ability to use visualization tools like Looker Studio and Tableau to create custom reports and dashboards for my clients. These reports focus on the client’s specific KPIs, providing them with actionable insights derived from Google Ads, Google Analytics (GA4), and social media ad campaigns.
Google Ads & Analytics Dashboard
Platform: Looker Studio
Client: Go2-Pros
(affiliated with Kitchens By Design)
Client Industry: B2C Services
(Pest Control & Extermination)
Google Ads & Analytics Dashboard
Platform: Looker Studio
Client: Kitchens By Design
(affiliated with Go2-Pros)
Client Industry: B2C Services
(Kitchen & Bath Renovation)
Google Analytics Monthly Traffic Report
Platform: Looker Studio
Client: A-Abel Family of Companies
Client Industry: B2C/B2B Services
(Electric, HVAC, Plumbing)
Consulting Report
Contains: Google & Social Ads Review and Professional Recommendations
Client: Sinclair Community College
Client Industry: Education
Facebook & Instagram (Meta) Ads Report
Platform: Looker Studio
Client: The Clardy Law Firm
Client Industry: Legal
PROGRAMMING &
CODING PROJECTS
Building on my foundation in Computer Science, I continue to actively expand my programming skillset. While my day-to-day professional experience primarily involves using Python, SQL, HTML, CSS, and JavaScript, my education and self-teaching has equipped me with proficiency in Java and C++. Beyond that, I’ve explored other languages like C# and PHP for personal projects, building social media clones and 2D role-playing games. I’ve included this to demonstrate my ability to learn new languages and apply them to practical applications.
Scheduling Application
About
Designed and implemented a database, using MySQL (workbench) and SQL, for a scheduling application. The application was built primarily with Java, utilizing JDBC (a Java API) to allow the app to communicate with the database, to process SQL statements and execute queries. JavaFX Library and SceneBuilder were used to make a more aesthetically pleasing interface.
The database schema consists of basic tables that house data for appointments, contacts (company employees), customers, country information, first-level division information (depending on the country, division may mean state, province, territory, or region – which helps to determine which language to set the Login & Main Menu screens of the application to, as well as the time zones based on location), and users (database access [employee login] information).
The purpose of this application is to enable customers in different countries to schedule meetings with an American based company during the company’s hours of operation. Each table has its own functionality and purpose. The customer has the ability to schedule appointments with various contacts, assuming the appointment is within business hours and does not conflict with other appointments at that time.
Tools & Technologies Used
JDBC with MySQL, SQL, Java (JDK 17), JavaFX Library, SceneBuilder
Inventory Management System
About
This inventory management system was built for a motorcycle parts company to store and keep track of parts and products inventory on local computers.
The application, written in Java with use of the JavaFX library and SceneBuilder for ease of creating the GUI, contains tables of in-house and outsourced parts and products, each of which can be added, modified, and removed.
A built-in option allows products to have associated parts (parts that require other parts and/or must be bought with a specific product), notifying users of association before deletion of either part or product.
The application also has simple search functionality, allowing users to search by Part or Product ID (auto-generated by the program) or complete or partial name of the part or product.
Tools & Technologies Used
Java (JDK 17), JavaFX library, Scene Builder
Class Roster
About
The purpose of this project was to migrate an existing student system to a new platform using C++. I was responsible for implementing the part of the system responsible for reading and manipulating the provided data.
The program contains two classes (Student and Roster). It maintains a current roster of students within a given course. Student data for the program includes student ID, first name, last name, email address, age, an array of the number of days to complete each course, and the student’s degree program. The program reads a list of five students and uses function calls to manipulate data. While parsing the list of data, the program creates student objects. The entire student list is stored in one array of students called classRosterArray.
Tools & Technologies Used
C++
Social Network Clone
About
My goal for this project is to create a full scale social networking website similar to Facebook/Twitter, with features like news feeds, profiles, friend system, chat system, and trending posts. I’m used to manage social media accounts for business pages when I was more involved with digital marketing so I thought it would be fun to come full circle and challenge myself as a developer to learn the inner workings of such platforms.
I began this project with HTML and PHP to build the registration and login forms, linking those to phpMyAdmin to create a MySQL database to store values (user information like first name, last name, username, email, etc). I configured XAMPP to create a local Apache web server on my computer and utilized the MySQL module for my database.
To style the register and login form, I used vanilla CSS and Bootstrap. jQuery script helped make these forms more responsive so that only one of the forms is viewable to the user at a time (either the login form if they have an account or the registration form if they need to register for a new account).
Tools & Technologies Used
HTML/CSS, Bootstrap, PHP, JavaScript, jQuery, MySQL, phpMyAdmin, XAMPP
Tiger Game
About
My client, Dyer, Garofalo, Mann, & Schultz (whose company mascot is a tiger), asked if I could create a simple tiger game for them to use as promotional material geared towards a younger crowd. I wasn’t familiar with game development but jumped on the opportunity to give it a go!
I’m building this project with our agency in-house graphic designer, Caitlin. She created the sprite character sheet and background scenes while I’m learning how to use Unity and C# to turn those static files into a working 2D RPG.
This project is still a work in progress so I will have more information about it coming soon!
Tools & Technologies Used
Unity, C#
Client Websites
A small sampling of websites I’ve designed and built, highlighting my ability to work with clients from a wide-range of industries, including:
Real Estate (Property Management), Service (B2B), Legal, Service (B2C), E-Commerce, Non-Profit, and Political (Judicial)
hubermgt.com
Client: Huber Management Corp.
Client Industry: Real Estate
theprgteam.com
Client: Premier Resources Group (PRG)
Client Industry: B2B Service
theclardylawfirm.com
Client: The Clardy Law Firm
Client Industry: Legal
go2-pros.com
Client: Go2-Pros
Client Industry: B2C Service
flocdayton.org
Client: For Love of Children (FLOC)
Client Industry: Non-Profit
weaverlawsc.com
Client: Weaver Law
Client Industry: Legal
cincytshirts.com
Client: Cincy T-Shirt Co.
Client Industry: E-Commerce
a-abel.com
Client: A-Abel Family of Companies
Client Industry: B2C/B2B Services
gp4judge.com
Client: Judge G. Parker
Client Industry: Political
Graphic Design
Creativity 🤝 Functionality
Although my primary career aspirations do not focus on graphic design, I wanted to include this section to showcase my creative abilities.
Alongside my diverse skill set, I’m well-versed with digital illustration tools such as Adobe Illustrator, Photoshop, Canva, and Figma, as well as collaborative and creative feedback tools like Slack, Dropbox, Vimeo, and Google Drive.
I include this section to highlight my versatility and further emphasis that when I say I’m a Jill of all trades, I genuinely mean it!
Google Ads Designs
Client: Committee To Elect Magistrate
Arvin Miller for Judge
Google Ads Designs
Client: Committee To Elect Julie Bruns
Google Ads Designs
Client: Susan Solle for Judge
Logo Design
Client: Retrofix Games
Logo & Resource Guide Design
Client: CURT (a division of PRG)
Logo Design
Client: PRG