Benjamin Groves
Tampa,FL
Summary
Responsive expert with extensive experience in developing and implementing data pipelines and ETL workflows in Snowflake. Proficient in SQL programming, with expertise in writing complex queries and stored procedures. Intermediate Python skills with strong focus on metadata analytics. Equally confident working independently and collaboratively as needed and utilizing excellent communication skills.
Overview
16
16
years of professional experience
Work History
Data Engineer
Stanley Black & Decker
07.2021 - 04.2024
- Planned, designed, and deployed relational database and schema architecture using Snowflake. Migrated data stored in Excel, SAP, and Dodge Data & Analytics warehouse to Snowflake.
- Developed Python algorithm for creation of tables, queries, and stored procedures. Used algorithm across multiple projects to reduce scripting hours.
- Set up 160 Salesforce Marketing Cloud connections using Treasure Data platform, reduced 160 table cleansing and staging procedures to 7 using Python to create and standardize schemas and tables.
- Designed and implemented ETL pipelines for processing large datasets, resulting in a 50% reduction in processing time and increasing data availability by 75%.
- Migrated data from AWS S3 buckets to Snowflake, designed and implemented data pipelines to generate analytics for the ConTech team.
- Used Spark to connect to web APIs. Created and modified existing stored procedures using Spark SQL, and analyzed data to create a new taxonomy for the ConTech group.
Market Data Analyst
Stanley Black & Decker
01.2021 - 06.2021
- Extracted large datasets from Excel, loaded to Power BI, transformed data using DAX, and designed analytics reports for senior management. Resulted in reduction of manual processing in Excel, easily identifiable KPIs which led to easier, efficient, and effective decision making.
- Designed algorithm to predict potential revenue of commercial projects using regression and machine learning methods.
- Simplified groupings of commercial projects by city and state, created data models to identify revenue potential, steered leadership and teams towards high value projects resulting in 10-25% market revenue increases.
- Leveraged Power BI to gain understanding of commercial construction market using geospatial algorithms such as grouping data points using longitude and latitude leading to deep, yet clear understanding of commercial construction potential revenue.
- Created bots in Power BI to assist new users while getting acclimated with reports, enabled bots to automatically filter user data based on their company role, resulting in satisfied coworkers and better strategy planning and execution.
- Experimented with AWS EC2 instances, S3, and Athena to assist sales organization with data decisions.
Business Development Manager
TBC
07.2008 - 06.2020
- Identified inventory overages reducing spending by 25%
- Used forecasting to recommend marketing strategies to generate business resulting in 10% increase in fleet sales
- Facilitated regular communication with clients to ensure their needs were met, fostering long-lasting relationships
Education
Master's Degree - Data Science & Analytics
University of Maryland Global Campus
Bachelor's Degree - Economics
University of Maryland
Skills
Technical Skills
- Python
- R
- Spark
- SQL
- Snowflake
- AWS
- Big Data
- Architecture
- Data Science
- Machine Learning
- Data Modeling
- Data Migration
Soft Skills
- Analytical thinking and problem-solving
- Collaboration and teamwork
- Communication and presentation skills
- Attention to detail and accuracy
- Time management and organization
- Efficiency and productivity
Timeline
Data Engineer
Stanley Black & Decker
07.2021 - 04.2024
Market Data Analyst
Stanley Black & Decker
01.2021 - 06.2021
Business Development Manager
TBC
07.2008 - 06.2020
Master's Degree - Data Science & Analytics
University of Maryland Global Campus
Bachelor's Degree - Economics
University of Maryland
Similar Profiles
Regi T HallRegi T Hall
Monitoring Specialist, Customer Service Specialist at Stanley Black & Decker, StanleyMonitoring Specialist, Customer Service Specialist at Stanley Black & Decker, Stanley
Macy CarrollMacy Carroll
Senior HRIS Workday Analyst at Stanley Black & DeckerSenior HRIS Workday Analyst at Stanley Black & Decker
Christina RatliffChristina Ratliff
Assembly Line Production Worker at Stanley Black & DeckerAssembly Line Production Worker at Stanley Black & Decker
Julius MuñozJulius Muñoz
Senior Lead Technician at Stanley Black & DeckerSenior Lead Technician at Stanley Black & Decker
ANGEL ROSIERANGEL ROSIER
Cosmetologist at Mimie's House of Beauty SuitesCosmetologist at Mimie's House of Beauty Suites