Bryan Collins

Experience

1. Business Analyst

   Ellsworth Adhesives

   Sep 2017 — Present · Sparks, NV, US

   Created and maintained PowerBI reports to provide valuable insight into key indicators of profitability, productionefficiency, inventory accuracy, etc. Created machine learning model in python using visual studio to increase quote conversion efficiency by 5% across different product lines Created a SARIMA demand forecast to optimize inventory levels Automated processes using PowerBI, Excel, and SQL functionality to improve efficiencies across disciplines Lowered inventory risk by 5% and improved cash flow by streamlining our inventory min/max program Spearheaded the combination of two data sets into one non-redundant data set during a merger of two sistercompanies Implemented a standard gross margin on products to increase overall gross profit by 5% Created and maintained budgets and forecasts to maintain profitability goals Assisted with budget, cost, and variance analysis to develop annual budget, quarterly forecasting and preparebudget schedules including operating expenses, asset management, and headcount Subject matter expert and responsible for training coworkers on proper use of our company wide ERP (enterpriseresource planning) software to maintain data integrity Amended previous practice of manual invoicing and created an automated system with VBA increasing efficiencyby 50%

Skills

• Financial Analysis
• Public Speaking
• Leadership
• Vba
• Customer Service
• Social Media
• Payroll Services
• Finance
• Research
• Management
• Microsoft Excel
• Financial Modeling
• Event Planning
• Marketing
• Teamwork
• Real Estate Development
• Microsoft Office
• Customer Relations
• Social Networking