Garrison (Beau) Brenno Email & Phone Number

Saint Paul, Mn, Us

Bloomington, Minnesota, United States

Bloomington, Mn

• Expanded QlikView environment with documents for Weekly Operational Reporting, Marketing, HR, AP and a Document Management system. Metrics developed from multiple internal and external data sources.• Revenue Cycle Management (RCM) processes designed using SSIS, SSRS and QlikView to download (API and FTP), batch and review electronic/manual payments into multiple Practice Management Systems.• Support QlikView NPrint reporting email environment. QlikView data emailed to offices and… Show more • Expanded QlikView environment with documents for Weekly Operational Reporting, Marketing, HR, AP and a Document Management system. Metrics developed from multiple internal and external data sources.• Revenue Cycle Management (RCM) processes designed using SSIS, SSRS and QlikView to download (API and FTP), batch and review electronic/manual payments into multiple Practice Management Systems.• Support QlikView NPrint reporting email environment. QlikView data emailed to offices and external Vendors each week.• Support Global Search (Document Management System). Workflow of AP invoices, EOB (Explanation Of Benefits) imports into system and QlikView invoice search document. Show less

Greater Minneapolis-St. Paul Area

• Managed 9-person department (3 Network Support, 3 Application Managers, 3 Developers)• Facilitated sale of $100M line of business by leading IT systems separation project. • Migrated data and systems successfully to new parent company, transferred historical information from 28 branch locations.

Greater Minneapolis-St. Paul Area

• Implemented QlikView (Business Intelligence tool), creating efficient and effective daily branch performance reports/analysis applications for Finance, Operations, HR, Payroll and Fleet Finance – Consolidated reporting by any dimension. P&L, Forecasting, Trends Operations – Job performance by Customer, Line of Business, Product, Employees Fleet – Costs by vehicle type, age, trends and preventative maintenance• Consolidated data from multiple internal… Show more • Implemented QlikView (Business Intelligence tool), creating efficient and effective daily branch performance reports/analysis applications for Finance, Operations, HR, Payroll and Fleet Finance – Consolidated reporting by any dimension. P&L, Forecasting, Trends Operations – Job performance by Customer, Line of Business, Product, Employees Fleet – Costs by vehicle type, age, trends and preventative maintenance• Consolidated data from multiple internal and external sources• Supported and distributed access to 275+ end users• Implemented dynamic analysis and metrics, providing management real-time visibility to changes and financial performance. • Performed month end reporting and reviewed packets built daily requiring no finance resources; conducted in-depth line of business analysis documents• KPI Dashboards highlighting Yearly/Monthly/Daily/Hourly performance and outliers Show less

• Developed and supported MS Dynamics NAV ERP for 55 branches / 300 users in the U.S. • Managed security and roles of MS Dynamics NAV• Managed SQL and NAV security• Implemented data transfers between NAV and outside vendors• Implemented SQL Data Warehouse for consolidated reporting with SSRS / SSIS• Developed operational and financial reporting• Designed and implemented Wells Fargo lockbox invoice payments import process. SFTP -> SSIS - > NAV -> Doc… Show more • Developed and supported MS Dynamics NAV ERP for 55 branches / 300 users in the U.S. • Managed security and roles of MS Dynamics NAV• Managed SQL and NAV security• Implemented data transfers between NAV and outside vendors• Implemented SQL Data Warehouse for consolidated reporting with SSRS / SSIS• Developed operational and financial reporting• Designed and implemented Wells Fargo lockbox invoice payments import process. SFTP -> SSIS - > NAV -> Doc. Mgt.• Created data transfer process to import and export Ultimate HRIS payroll data weekly. • Created job performance reporting and sales commission calculations Show less

• Supported a mixed network of Microsoft and Netware systems, of approximately 250 end users, built on Compellant and Xiotech SANs.• Installed servers, supported NDS, maintained workstations, provided network user access, application support, backups and virus/spam signature updates

Business Computer Information Systems, Information Technology

Associate Of Arts - Aa, General Studies