Ron Houser

Former USMC Officer with 6+ years experience in Data Analytics and Process Improvement resulting in six figure cost savings. Significant experience communicating with and presenting to diverse stakeholders. Currently serving as Data Visualization Professional for CAT's Global Program Management Division.

Technical Skills

Microsoft Power BI, SQL (MySQL, PostgreSQL, SSMS), DAX, M, Power Automate, Azure DevOps, Snowflake, Tableau, R, Python (Pandas), Microsoft Excel, Microsoft PowerPoint, Data Analytics, Data Presentation, RPA, Statistical Analysis, Data Cleaning, XML Documents, Tetris (Classical NES), Problem Solver, Critical thinking, Motivated, Collaborative, Communicative, Passionate, Resourceful, Quantitative, Methodical, Analytical

Professional Experience

Data Visualization Professional

Caterpillar Inc.
November 2022 - Present

• Automated license tracking and implementation by producing a dashboard that extracted and transformed data from 4 distinct sources, sending automated email alerts via Power Automate; effectively reducing man hours and increasing productivity by more than an estimated 208 hours.
• Successfully transitioned CAT’s Global Program Management (GPM) division to a standardized process of data visualization, by migrating all existing Tableau dashboards into Power BI.
• Developed over 130 unique dashboards, tailored specifically to Stakeholders' requests.
• Presented metrics data and innovation team updates at the extended staff meeting for the entirety of the GPM division consisting of 260+ individuals.
• Provided an immediate solution to a critical visualization error outside of CAT’s control that affected over 500 dashboards by developing a Gantt Chart visual to display Program Management Data.
• Developed and automated a crucial dashboard for monitoring the GPM Toolbox (software) usage data providing necessary historical and current metrics that were leveraged in a decision making conversation with the Microsoft Corporation.
• Maintained 100% positive feedback with outstanding reviews from all individuals reporting on my performance.

Manufacturing Data Analyst

EnviroServe Chemicals, Inc.
July 2019 - 2022

• Presented data visualizations via Power BI to Manufacturing Engineering Department to develop and maintain production standards after querying data with SSMS, and organizing legacy datasets through Microsoft Excel, resulting in cost-effective savings on average of $12,000 per month.
• Gathered data, provided monthly analysis reports, and effectively communicated with stakeholders of more than 15 separate manufacturing companies the current procedures and recommended implementations to drive informed decision making.
• Communicated effectively KPIs through Power BI leading to the production of a 27 page Standard Operating Procedure (SOP) for chemical implementation and maintenance, including step-by-step visualizations and detailed oriented guidance of roles and responsibilities.
• Developed relationships with stakeholders to gain an understanding of business drivers and objectives. Working for a company that services top manufacturers in the US such as: Caterpillar, ELKAY, Energizer Battery, Scottland MFG, and more.

Field Artillery Officer (Operations Analyst)

United State Marine Corps
Sept 2012 - Sept 2015

• Conducted detailed oriented data analysis on datasets containing 10,000+ data points, developing schemes for battalion live fire exercises and dashboard visualizations via Microsoft Power Point to communicate tactical control measures to highest ranking officials.
• Produced 63 page Standard Operating Procedure (SOP) for OPSEC, CBRN, and ORM to highlight the procedures and responsibilities that all Marines must perform in operational and non-operational environment in order to identify hazards and eliminate or reduce the risks associated with them.
• Demonstrated exceptional leadership skills by maintaining 100% training safety rate with 0% incidents as Range Safety Officer (RSO) and Officer In Charge (OIC) for 256 days of live fire training exercises by thoroughly planning precise surface danger zones (SDZ), organizing secondary and tertiary logistical maneuvers, and communicating clearly the training objectives.
• Developed Battalion's first automated Microsoft Excel spreadsheet actively displaying expiration dates for 240+ individual certificates for marines at 3rd Battalion, 12th Marine Regiment; color coded to denote length of time before certificate expiration date, dramatically improving training efficiency.

Independent Projects

SQL with Tableau Visualization

World COVID Dataset
February 2021 - October 2022

• Utilized 7+ SQL skills: Joins, CTE's, Temp Tables, Windows Functions, Aggregate Functions, Views, and Converting Data Types.
• Analyzed data to determine infection and vaccination rate per country, and demographics of vaccinations received.
• Created 2 dashboards through Tableau to depict the information gathered and display the analysis conclusion.

Data Cleaning

Nashville Housing Data

• Utilized 13+ SQL Skills: Converting Data Types, Alter, Update, Self Join, IsNull, Substring, Charindex, Parsename, Replace, Case, CTE, Windows Functions, Aggregate Functions.
• 223 lines of scripted SQL using SSMS to standardize dates, convert NULL values, parse delimiters, remove duplicates, and drop columns.
• Demonstrated detailed oriented transforming data in the ETL process.

Python

• Performed Data Cleaning, Data Visualization, Web Scraping and Correlation Analysis on 2 separate datasets.
• Utilized 3 Python libraries: Pandas, NumPy, and Seaborn to create and display statistical analysis visualizations.
• Generated a 24 hour incremental scraping script that populates a dataset and automatically emails notifications.

Education

Campbell University (2019)
Master of Divinity (Distinction with Languages: Hebrew, Greek)
Buies Creek, NC

Gardner-Webb University (2011)
Bachelor of Arts in Religious Studies Minor in Theatre
Boiling Springs, NC