Craig W. Brunschon

• Woodbury, MN ***** • ac37gk@r.postjobfree.com • 651-***-**** • www.linkedin.com/in/craig-brunschon FINANCIAL SERVICES SYSTEMS ANALYST

Data Analyst, Loan-Lease-Funding Analysis and Data manager with experience in Financial-Banking Services, Software/Hardware Development. Manufacturing and Hospitality accounting for Hotel/Restaurant. Adept at solving software configuration and technical problems, administration of “Change Management Control” for Financial Software systems. Coordinated the process and data compilation to produce the Corporate

“KRI / KPI Reporting package and other significant Corporate Credit Reporting packages. Installing and testing software, reviewing and developing cost-benefit analysis, and managing efficient upgrades, transitions, patches, and hardware improvements.

Computer network experience, and an array of financial/reporting systems experience and training. Good communication and interpersonal skills, teamwork, time management, and project management training. Participation in and managing Record Retention programs for server data and work group files. Basic project management training and project execution, UAT at the user and group/department levels. Data Governance project participation and basic MDM for various financial data sets and systems. WORK EXPERIENCE

TCF Financial Corporation, Plymouth, MN 2009-2017

AVP – Sr. Manager of Decision Analytics – Risk Review (Loan-Lease-Funding) Managed the data flow from many legacy lending/leasing/funding systems for risk review analysis, sampling and investigation.

Directed training required for review staff utilizing the ABA LMS training system, time tracking databases, Loan/Lease Review issues database, validation of all data back to the main general ledger system with Essbase Smartview.

Analyzed sampling selections – storage – history – maintained archives and documentation.

Recommended upgrades, improvements and enhancements to all applicable systems.

Worked with the Data Governance team to insure data quality and reliability. TCF Financial Corporation, Wayzata, MN 2003-2009

Hyperion Administrator / Application Systems Analyst Managed the Hyperion Enterprise software product used on site by financial reporting department and corporate users in seven different states.

Monthly maintenance of accounts cost centers reports web enabled support and reporting.

Monthly – quarterly - annual close cycle and annual report production.

Supported the following financial software packages: Hyperion Enterprise – Hyperion Report Writer and all excel add-ins for Enterprise and ongoing Citrix user support. The support includes initial setup and configuration management with ongoing user support.

Development of user defined reports and data interfaces to all products. Completed extensive training on all products at Hyperion training facilities.

Assisted with the storage data warehouse selection, reviewing and testing systems based on RFP to vendors, and then selecting oracle Hyperion Essbase versus Cognos TM1.

Participated in the configuration development and the reporting requirements for that lending/leasing data summary warehouse using Essbase. Computer Sciences Corporation, Bloomington, MN 3 Years Application Systems Analyst

Directed Hyperion Software products used on site by client Corporation.

This included support for the following financial software packages: Hyperion Enterprise, Essbase – Pillar Analyzer – Report Writer and all Excel add-ins for each product. The support included initial set up and configuration management with on-going user support.

Craig W. Brunschon ac37gk@r.postjobfree.com Page Two

The St. Paul Hotel / Morrissey Hospitality Companies, Inc., St. Paul, MN 8 Years Systems Manager

Maintained all computer systems at the hotel, the Minnesota Club and Pazzaluna Restaurant. Telecommunications and the related training.

Developed and implemented all data processing accounting procedures. Participated in all executive MIS decisions. Was originally with the hotel from 1982-1985 as Asst. Controller.

Installed PCs, Novell Network NT4 Network, upgraded mainframe from SYS36 to AS400; installed MS Office network-wide, managed POS micros4700 and upgraded to 8700 systems.

Administrated all network software including TRM time system, ADP Payroll, Ceridian Payroll, HIS Front/Back Office Systems, Breeze Sales and Catering System, Access Databases, Peachtree Accounting, Lotus123, Excel, SYM22, Spreadsheets. Email admin, Centigram Voicemail admin, phones switch CONFIG and admin.

ADDITIONAL EXPERIENCE

Controller/Accountant - The Dakota Bar & Grill, St. Paul, MN Controller - The Whitney Hotel, Minneapolis, MN

Asst. Controller - The Holiday Inn Metrodome, Minneapolis, MN Asst. Controller and Controller - The Saint Paul Hotel/Lincoln Hotel Corp., St. Paul, MN /Philadelphia, PA Credit Manager - The Radisson Plaza Hotel, St. Paul, MN SOFTWARE EXPERIENCE

Corp Financial Systems

Hyperion Essbase, Hyperion Enterprise, Hyperion Report Writer for Essbase and Enterprise, FCS, Basic training on SAS-ACL-Tableau Analytics. Fiserve ITI Premier Commercial Lending, Harland Lending System, Shaw Retail LMS, Oracle Query Tools. Cognos BI Reporting Tools Accounting / Payroll Systems

Peachtree DOS/WIN, Solomon DOS/WIN, MYOB, Open Systems, GreatPlains DOS, HIS Front & Back Office for SYS36, HIS Front & Back Office for AS400, Open System DOS/WIN, Ceridian HR Payroll, ADP HR Payroll, Solomon Payroll, Paycheks Payroll, HRTools

Dbase's and Spreadsheets

Excel, Access, Paradox, Dbase, Revelation, Q&A, MS Works, various SQL type Data systems-Oracle Word Processing

MSWord, Q&A, Symphony, MSWorks, WordPerfect

POS and Various Systems

MICROS4700 & 8700, NCR, DTS,TRM-Timeclock System, Time Management, XIOX Call Accounting, Lodgenet Movie Systems, Centigram Voicemail Admin, Meridian Northern Delphi/Breeze Sales and Catering Dbase, various Electronic Credit Card Systems, Safelok Keycard Systems EDUCATION

Business Administration Degree

Globe College of Business, St. Paul, MN

Covered every aspect of accounting from cost Accounting to Budgeting, Cash Management and Intensive Analytical Training. Excelled in Creative and Business writing skills.

Contact this candidate