Requests
6
Keep in touch with meI'm using Intch to connect with new people. Use this link to open chat with me via Intch app
Network Power<100 people
Roles
✔️100%
IT
Geos
Work Background
CVS HealthData Scientist
Oct. 2022I Contributed to 3 different projects Safety Stock Optimization and Simulation, Transferability, Event Tracking (Event Tracking is not included here due to character limit). I implement this work inside Databricks/PySpark and Snowflake daily to write efficient functions, select pilot stores & products, handle datasets with billions of rows, and utilize ML models to predict weekly demand forecasting. Safety Stock Optimization and Simulation SUMMARY: I worked with a team of data scientists to optimize the number of items held in inventory across 8,000 stores which is currently contributing to an estimated ~$150,000,000 impact on working capital across CVS stores. MY ROLES:
- Refreshing the data each week
- Significantly improving and contributing to the codebase including: - reducing the runtime of entire workstream from 54 hours to 8 hours which had a significant reduction in cloud computing costs - a binary search algorithm which significantly decreased runtime and increased efficiency calculating forecast bias for all items - adapting the codebase for items with a seasonality component. - comparing the differences between sales when an item is on sale versus regular price. IMPACT
~$150,000,000 of working capital Transferability SUMMARY:
Worked with a team of 3 to investigate the impact of lowering the number of low margin items and increasing the number of high margin items that were relatively similar (like different brands of toothpaste). This would drive low margin items out of stock and cause customers to buy higher margin items. MY ROLE:
Developed how to monitor the transferred sales and impact of the pilot
I filtered and created the list of specific stores according to pre-determined criteria
Generated the exact values that we would lower the low margin items to for pilot PROJECTED IMPACT
+$15M on annual margin
Q-CentrixData Analyst
Jan. 2022- Increased efficiency of Central Planning Business unit by 4x within 1 month of employment. - Continue to find ways to make business processes more efficient daily. - Finding high-quality placement for staff members.
- Balancing input from multiple data sources including opinions from managers, skillset, and capacity to find the perfect assignment for staff members to be as productive as possible across the organization.
- Effective communication with managers on efficacy of assignments for personnel.
- Create effective reports daily.
- Building Salesforce Reports and handling resources and assignments in SalesForce
Robert HalfData Analyst
Apr. 2021 - Dec. 2021- Data Alignment and resolution of 1000+ Contracts and Providers
- Resolved 1 Microsoft Excel macro to run more efficiently
- SQL queries in Microsoft Access
- Problem Solving
UpworkCourse Instructor
Feb. 2021 - Sep. 2021- 6.2-hour course called the "Introduction to R"
- 13 In-depth Sections with practical exercise given at the end.
- 58 Multiple-Choice questions
- 1 Mini-project that gave students a chance to test their new skills
Guru.comData Analyst
Jan. 2021 - Sep. 2021Completion of several projects with a perfect 100% client satisfaction rating. Projects include: - Sentiment analysis of WallStreetBets subreddit comments
- Time-series analysis of stock data
- Human Resources Excel Dashboard and exit survey data analysis
FiverrData Analyst
Jan. 2021 - Sep. 2021I maintain a rapid response time and look to give my client's true VALUE with my data analysis or writing posts for their blog. Find my gigs at: https://www.fiverr.com/williamfetzner
CodeverseCode Guide
Apr. 2020 - Apr. 20211-on-1 tutoring over 100+ students in coding their own games in a unique coding platform that is a combination of Python, JavaScript, Ruby and more.
SpringboardSpringboard Data Science Career Track
Apr. 2019 - Jan. 2020550+ hours of hands-on curriculum, with 1:1 industry expert mentor oversight, and completion of 2 in-depth capstone projects. Mastering skills in Python, SQL, data analysis, data visualization, hypothesis testing, and machine learning. Capstone Project 1 - Title: Projecting rainfall averages in North Carolina for the next 50 years.
Objective: To provide a forecast of rainfall amounts for the next 50 years. This forecast could potentially be used to influence decisions in agriculture, government water regulations, and government resource management. Tools Used: Python, Time-series analysis, Seasonal Decomposition, Correlation, and Auto-correlation.
Outcomes: A report and corresponding code of findings with a raster map of North Carolina projected annual rainfall for the next 5 years (2020 - 2024) the intensity of projected rainfall varies by color. I provided 95% confidence intervals for the subsequent 45 years (2025-2069). A second map detailed the differences in rainfall from present day to the projected amounts. Lastly, I separated projected data into projected annual rainfall per decade. Capstone Project 2 - Health Scores
I collected all of the data regarding all 500 cities from the City health Dashboard and the different metrics used to determine the level of health for a city. By ranking these cities, I made a system for being able to accurately compare the level of health of one city to another. This could be helpful for city health managers or nonprofits that are looking to understand how well their city is performing compared to other cities. These managers could compare their city to the cities ranked above them and see how they might change their programs in their city to increase the health of their city. I compared the efficacy of several different Clusterization and Classification methods to find the pair of Machine Learning methods that best fit the dataset to then rank the cities from healthiest to the least healthy.
Code NinjasCode Sensei (Mentor)
Nov. 2018 - Apr. 2020Wake Forest, North Carolina, United States• Mentor 100+ students to code games using several different coding languages including Javascript and Python.
• Created "Steps to Success" guides for the students to use for all 30 "Prove Yourself" Challenges
• Led activities for 4 week-long camps on block coding in Scratch.mit.edu and snap circuits
Intch is a Professional Networking App for the Future of WorkSee more people like Billy on Intch
300k+ people
130+ countries
AI matching
Get Intch if you'd like to
453430 people
18
Technologist, Project/Program Manager
24
Data Scientist Intern @ Newell Brands
16
Program Manager @ DISH Network
39907 people
42
Senior Mining Engineer @ Riot blockchain
16
CEO/Data Engineer and Consultant @ Propeltech Services LLC
25
Tech Analyst @ Capital Online Trade