Richard Ramsell Email & Phone Number

Fayetteville, Ar, Us

United States

United States

United States

United States

Lehi, Utah, United States

Position daily responsibilities include:- HUE coordinator/workflow management - Advanced HSQL/Presto SQL queries to increase job efficiency, improve accuracy, and provide data sources for end user reports/analytics throughout the business - Advanced Python script management and reporting to the executive team on operational performance- Python for adhoc requests (data wrangling and visualization)- Training/Onboarding new analysts and assisting other analysts in their projects- Group ADMIN on virtual machine and VM's task scheduler for daily emailed reports- Creation of advanced tableau interactive dashboards using sets, drill downs, viz tooltips, parameters, and LOD functions- Tableau Server data source, file, and network management- Working cross-functionally with different LOB's to determine business process friction points and find actionable solutions- Excel reporting - Monthly business reviews with executives providing deep dive analytics into business problems providing insight and solutions

Lehi, Utah, United States

Position daily responsibilities include:- HUE coordinator/workflow management - Advanced HSQL/Presto SQL queries to increase job efficiency, improve accuracy, and provide data sources for end user reports/analytics throughout the business - Advanced Python script management and reporting to the executive team on operational performance- Python for adhoc requests (data wrangling and visualization)- Training/Onboarding new analysts and assisting other analysts in their projects- Group ADMIN on virtual machine and VM's task scheduler for daily emailed reports- Creation of advanced tableau interactive dashboards using sets, drill downs, viz tooltips, parameters, and LOD functions- Tableau Server data source, file, and network management- Working cross-functionally with different LOB's to determine business process friction points and find actionable solutions- Excel reporting - Monthly business reviews with executives providing deep dive analytics into business problems providing insight and solutions

Draper, Utah, United States

- Automated inventory reporting processes to save over $100 in administrative payroll each month and approx. $1500 each month in inaccurate accounting variances- Successfully managed a franchise with 4.6% positive YoY sales through COVID-19 in 2020 - Leveraged MS Excel (using Macros) to transform sales performance data into a forecast to optimize scheduling- Utilized exploratory data analysis to determine variables within loyalty customer demographic to fuel strategic marketing initiatives- Performed data analysis to determine logistical redundancies in kitchen processes (market basket analysis for ergonomics)- Used predictive modelling and cost benefit analysis to understand the lifespans of equipment and for operational efficiencies- Managed data pipeline from US Foods to calculate variance of inventory and price changes enabling the business to optimize - Responsible for ultimate financial and logistical reporting and analysis - Led all HR elements including hiring, training, promoting, termination, and employee development. Approx. 30 employees - Processed payroll, invoices, labor/CoGS reporting, and inventory reporting, for a clear financial analysis - Developed relationships with customers and managed the business with top tier customer service - Achieved the first (and second) only perfect score on an EcoSure food safety evaluation in Brack&Field company history

- Managed and evaluated the production, packaging, and shipping of laser-engraved decorative gifts- Enhanced macros and excel formulas to clean sales data for pipelining- Motivated, trained, and managed over 50 employees and evaluated performance - Regulated quality control of the product and worked process improvements to increase quality - Leverage data management skills to create analytic reporting and to correct billing mistakes within customer historical data- Reduced expenses by maintaining and optimizing production processes and decreasing downtime- Recruited, interviewed, and hired new staff

Master Of Science - Ms, Data Analytics, 3.0

WGU's Masters in Data Analytics was a rigorous accelerated 1 year program which solidified my expertise in Analytics and Data Engineering..

Data Analytics Nano Degree, Computer Science

This nano degree provides a professional certification atesting to the fact that I can program fluently (as a data analyst) in python.

Bachelor Of Science Of Business Management - Bs, Business Administration And Management, General

Associate'S Degree, General Studies

Completion of and A.S. in General Studies at Utah Valley University