Brandon Wimer Email & Phone Number

Eden Prairie, MN, US

Bayport, Minnesota, US

• Collaborate with Senior Leadership to create intelligence visuals that prompt and support decision-making and strategy
• Develop, recommend and implement business solutions through research and analysis of data and business processes
• Articulate compelling stories using visualization software
• Troubleshoot data integrity issues by evaluating completeness to meet project goals
• Mentor multiple junior analysts

Bayport, Minnesota, US

• Analyze and present financial results for a production line worth $100M gross annual revenue
• Consult on performance improvement projects and verify financial savings potential
• Develop and advise yearly budgeting for production and quality groups
• Train supervisors on the budget process and coordinate the implementation of future year budgets
• Perform monthly analysis of financial results and expense trending for all aspects of production
• Implement process improvement initiatives around reporting and data visualization

Bloomington, Minnesota, US

• Use SAS and SQL coding to develop and report on client solutions found in healthcare metrics
• Develop Tableau workbooks to a range of datasets and problems, most prominently claim and authorization medical data regarding transplant patients
• Prepare and present complex analytical conclusions to a variety of audiences including senior leadership and integrated physicians

US

• Team lead of healthcare analysts advising the financial risk of Medicare and Medicaid contracts with a forecasted yearly revenue of $6.5B and gain of $250M
• Project lead on risk adjustment model statistical improvement project generating a projected $25M lift in revenue over the 2018 payment cycle
• Served as key healthcare economics and analytics contact for local, regional, and national OptumCare leadership and key national finance and operations stakeholders
• Designed, produced, and supported creation of financial and operational dashboards and key performance indicator reports to meet customer requirements in both Excel and Tableau
• Developed and managed complex financial risk models from data aggregation in SQL to detailed customer facing reports and conclusions
• Organized clinical diagnosis information into business level metrics to assist business leaders in making targeted decisions around population risk management

US

• Assigned special projects, such as process improvement, and Medicare Payment data intake optimization in MS Access, saving department $10K yearly from prior used software
• Advanced Excel workbook enhancement, including macro creation, automated financial statements, and early financial statement views based on journal entry information prior to ledger posting
• Analyzed and prepared financial statements, including balance sheets and statements of financial position for Medicare and Commercial healthcare organizations with a monthly IOI of $60M
• Reconciled, analyzed and reviewed general ledger accounts in preparation for month end close

Dallas, TX, US

• Managed a portfolio of complex commercial and industrial properties worth $300K, ensuring accurate records are maintained
• Completed basic to intermediate level accounting transactions in preparation of client financial statement packages

Menlo Park, CA, US

‐ Collected and processed incoming membership renewals‐ Imported and compiled sales data in Microsoft Excel‐ Organized sales data into visual representations for executive usage‐ Successfully identified and presented safer methods of controlling incoming payment processes

Menlo Park, CA, US

‐ Handled accounts payable processing for a mid‐range construction corporation‐ Contributed to the timely, accurate processing of invoices, payroll, and outgoing checks‐ Completed daily ACH payments, wire transfers, and weekly journal entries‐ Assisted in managing vendor/supplier relations‐ Redesigned various Excel spreadsheets for management use

‐ Performed cash reconciliations, fixed asset management, fraud interviews, accounts payable and accounts receivable verification, and prepaid asset verification for multi‐million dollar companies.‐ Completed reviews and compilations of clients' financial statements‐ Developed Excel spreadsheets to better perform the audit‐ Completed tax form 990's for.

I used my accounting background to perform bank reconciliations through Quickbooks, generated Excel spreadsheets based on expense data, and researched global business opportunities.

‐ Prepared, organized, processed, and reviewed tax files completed by firm partners‐ Collated supplementary documents related to tax perparation activities‐ Corresponded with firm partners and walk‐in clients as needed

Master Of Science In Business Analytics

Bachelor Of Arts, Accounting

Education record