Summary
Overview
Work History
Education
Skills
Work Availability
Timeline
Generic

Branden Rushton

Celina,OH

Summary

Results-driven Business Intelligence Developer with 7+ years of experience seeking to leverage expertise in data analytics, ETL development, and Power BI to drive data-driven decision-making in a dynamic organization.

Overview

7
7
years of professional experience

Work History

Data Analytics Engineer

TrueRX Health Management Services
Remote
09.2022 - Current
  • Defined and documented requirements for the organization's Enterprise Data Warehouse as a part of the Data Governance initiative
  • Developed ETL pipelines in Azure Synapse Analytics to populate data warehouse tables in an Azure SQL cloud environment
  • Collaborated with the business intelligence team to identify and deploy new data warehouse assets for use in Power BI reporting
  • Developed SQL queries, stored procedures, and views to support data requirements from various departments across the organization
  • Maintained a Power BI paginated report used by the account management team to send clients data on their prescription drug plans.

Production Support Manager

Crown Equipment
New Bremen, OH
11.2021 - 06.2022
  • Managed a team of 17 Business Analysts responsible for supporting Crown's global SAP solution production environment
  • Redesigned and automated the teams data reporting strategy by developing Power BI dashboards that monitor key performance indicators of the SAP Production Support team
  • Saved 8-16 hours of monthly manual work while increasing data visibility refresh from once per month to once per day
  • Collaborated with business analysts and key users to coordinate continuous improvement initiatives between the SAP team and the power users from the business.

Business Intelligence Engineer

Quaker Windows & Doors
Freeburg, MO
03.2021 - 10.2021
  • Led the design and implementation of an enterprise data warehouse project using Kimball and Agile methodologies
  • Successfully designed, developed and monitored 8 star schemas, making up 50+ SQL tables and well over 50M data points
  • Developed and maintained self-service BI reports in both Qlik Sense and Power BI, saving 10+ hours weekly in manual labor
  • These reports were used for Inventory Forecasting, Sales Budget Analysis, and Executive Summaries
  • Utilized Microsoft Azure DevOps for continuous improvement and deployment of SSIS packages to be stored in our EWD (SQL On-Premise)
  • Identified and implemented opportunities for data quality improvement within the enterprise data warehouse.

Business Analyst

Crown Equipment
New Bremen, OH
08.2018 - 03.2021
  • Lead a team of 30 personnel charged with identifying and cleansing master data from legacy systems for migration into SAP
  • This team cleansed and prepped 500+ different data points for over 100,000 different manufactured and warehoused materials, resulting in a 90% drop in data defects at Go-Live compared to the previous release
  • Developed and maintained 5 dashboards in Excel and Power BI to report overall progress of data cleansing project to Executive Management daily
  • Provided Excel and Power BI training and support to other business analysts on the SAP team internally
  • Conducted interviews with key business users to collect information on business processes and user requirements in order to identify gaps in the data cleansing project
  • Resulted in 25+ additional data steward rules that if missed, would have impacted manufacturing production during Go-Live.

Data Analyst

International Brake Industries
Lima, OH
01.2017 - 07.2018
  • Extracted, structured, and analyzed data sets in Power BI from the JDE ERP system to identify operational strengths and weaknesses
  • Redesigned the executive daily sales report in Power BI, saving IT staff 3 hours every morning in manual labor
  • This report was the primary tool for all of Executive Management to monitor sales and manufacturing activity from the prior day
  • Created and maintained a year-over-year sales tracker for the sales department to monitor account and sales rep actuals vs budget
  • Redesigned the procurement processes for 1000 raw materials through a reorder point system and ABC analysis
  • This system cut missing inventory by 20% and increasing sales, while keeping only increasing carrying inventory by a negligible amount.

Education

MBA -

University of Delaware
12.2016

Bachelor of Science: Electrical Engineering -

Ohio Northern University
05.2014

Skills

  • Business Intelligence: 7 years of experience in data mining, data warehousing, and actionable report generation
  • Data Modeling: Proficient in dimensional data modeling techniques for optimized data structures
  • ETL Development: Strong skills in ETL pipeline design and development
  • Requirements Gathering: Proven ability to gather and document project requirements
  • Data Visualization: Expertise in creating interactive and insightful reports using Power BI
  • Data Integration: Proficient in Azure Data Pipelines and SQL Server for data integration
  • Microsoft Excel: Advanced Excel skills for data analysis and reporting

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Timeline

Data Analytics Engineer

TrueRX Health Management Services
09.2022 - Current

Production Support Manager

Crown Equipment
11.2021 - 06.2022

Business Intelligence Engineer

Quaker Windows & Doors
03.2021 - 10.2021

Business Analyst

Crown Equipment
08.2018 - 03.2021

Data Analyst

International Brake Industries
01.2017 - 07.2018

MBA -

University of Delaware

Bachelor of Science: Electrical Engineering -

Ohio Northern University

Similar Profiles

CREATE PROFILE
Branden Rushton