Brad Devos Email & Phone Number

St. Peter, Mn

St Peter Business Services (SPBS) is a consulting and bookkeeping company, specializing in financial analysis and process improvement. I have expert-level experience in Microsoft Excel and Access, finding creative ways to streamline data entry and analysis. I also have extensive experience in the financial management of childcare centers.Work performed for clients has included:-Financial/workflow analysis and recommendations-Operational and startup consulting-Record transactions in multiple reporting systems-Accounts payables-Accounts Receivables-Monthly reconciliations-1099 processing-Work with auditors and banks to provide the information needed for review

St Peter, Minnesota, United States

Analyze and approve municipal and enterprise fund budgets, expenses, ordinances, and policy changesCurrent City Council representative for-Economic Development Authority-Planning & Zoning Commission-Public Works-Minnesota River Valley Transit-Climate Smart MunicipalitiesFormer City Council representative for-Region Nine Development Commission -Continue to be involved in an unofficial capacity-Rivers Edge Hospital Commission

Sleepy Eye, Minnesota, United States

-Process improvement including analysis, development, testing, training, and implementation-Compilation and review of data transfers between systems

Sleepy Eye, Mn

-Monthly accounting updates and reconciliations for sales, purchases, and inventory -Analysis of data collection systems including the testing of handheld devices to replace the manual collection of data-Introduced the use of Microsoft Access to enhance the speed and accuracy of monthly reporting and daily data entry tasks-Analysis of proposals from solar power vendors on new installations-Staff supervision

St. Peter, Mn

Board member since March 2013-Introduced financial reporting to track delinquent payments, accumulated debt and provide detailed cash flow analysis-Introduced measures, including automatic payment plans, that reduced delinquencies from over 15% weekly to less than 5%-Solicited quotes from local firms to move payroll from in-house processing, saving staff time and eliminating consistently recurring errors-Provided guidance on impact of minimum wage increases on payroll and revenue required to compensate for increase-Provided breakeven analysis based on enrollment and expense projections-Budget development-Provided cost/benefit analysis for expansion plans-Met with Saint Peter city officials as needed-Managed center’s finances, including vendor relationships and payment prioritization-Worked with the Executive Board and City of St. Peter to secure space allowing the consolidation of two facilities into one

Golden Valley, Mn

-Provided monthly and ad hoc reporting on the accuracy of data transfers between systems using SQL and Access-Reviewed SQL code to recommend process improvements and troubleshoot data reporting issues-Updated Access databases and Excel spreadsheets to increase efficiency in the reserve calculation and reporting process-Served as interdepartmental resource in troubleshooting Access issues-Researched new product data and update SQL database with appropriate product information-Provided gatekeeper role in transferring information to secure location-Tested and validated improvements to SQL based reserve calculation system

Richfield, Mn

-Provided monthly and ad hoc reporting on Factory Warranty and Extended Warranty claims submitted to vendors for repairs-Researched revenue and rejection discrepancies with Accounting-Maintained and updated multiple Access databases and Excel spreadsheets involved with claims process-Designed new databases to enhance the efficiency of the claims process-Provided departmental monthly profit and loss reporting using Essbase-Researched details and discrepancies using Essbase and Oracle

Plymouth, Mn

-Conducted audits of claims involved with a class-action lawsuit by analyzing funds paid into and disbursed from life insurance contracts to ensure proper settlement amount and tax reporting-Prepared weekly and ad hoc reports to management on audit results-Led multiple projects with tight deadlines to ensure accurate year-end tax reporting for clients-Interpreted procedures for determining tax consequences incurred by claimants seeking damages in class-action lawsuit-Developed worksheets and guidelines for determining tax consequences-Implemented individual and group training initiatives-Analyzed workflows, determining the most efficient allocation of resources and correcting errors in the transfer of work between units-Developed and coordinated testing of work-reduction proposal that resulted in labor savings over $100,000-Earned Mobilization Star award for implementing work-reduction proposal-Partnered with corporate legal counsel to resolve high-level complaint cases-Derived premium, dividend, cash, and loan values on life insurance policies and calculated taxable gains on policy disbursements

Duluth, Minnesota

-Maintained finances and lobbied for funding for student group with over 200 volunteers-Developed and implemented 1994-1995 fiscal year budget-Conducted cost/benefit analysis for upgrading computer system used by SERVE-Organized training seminars for volunteer coordinators-Interviewed and assigned positions to new volunteer coordinators-Supervised and assisted coordinators in dealing with community organizations