Accounts Payable Assistant

BRUCE D. HARRINGTON

**** ******** ******, ***** ****, MN 55105

(651) 983 - 4648

******@*******.***

QUALIFICATIONS

Business Process Analyst

Three years’ experience with Ditech LLC (FKA Green Tree LLC) loan servicing company. Responsibilities included: analyze business processes with a focus on long-term improvements, monitor data via SQL queries (SQL Server, DB2, MS Access), create VBA solutions for small projects, prepare ad hoc reports and presentations for senior management, gather business requirements documents, create and map process flows. As a process analyst, I gathered business requirement for a payment reversal and reapplication proprietary software, collaborated with cross-functional teams as our company transferred 1.4 million loans to a new loan servicing platform, served as subject matter expert on resolving bankruptcy payment issues and identified process gaps related to fees. This self-directed project resulted in more than $500,000 in additional annual fee income in its first year of implementation.

Loan Servicing Team Lead (Bankruptcy group)

For two years I led initiatives to streamline workflow and trim labor costs. Self-directed projects in Loan Servicing yielded >2 FTE’s savings and contributed to improved SLA’s and CFPB compliance. Excellent data analysis skills, broad and deep knowledge of systems and programming including proprietary and standard platforms including: SAP, MS Office, SQL, and VBA. In 2013, I was one of two Ditech Loan Servicing employees awarded the Servicing Star.

Accounts Payable Assistant Supervisor, Grain Inventory Accountant

Eleven years’ experience in Accounts Payable, two years’ experience inventory accounting with locally-based Pillsbury and General Mills Corporation (merged 2001).

EDUCATION, PROFESSIONAL AWARDS

B.A., Business Administration, Minor in Accounting — Augsburg University

Servicing Star 2013, Ditech LLC

Microsoft Office Specialist, Excel 2016 Certification (Exam 77-727)

PROFESSIONAL EXPERIENCE

Xcel Energy (Contract through Genesis10), Minneapolis, MN

Business Process Analyst

September 2018 – November 2018

Process Analysis with focus on Accounts Payable & Sourcing improvements

Created interactive tracking and reporting of problem work orders

Mapped process flows using MS Visio

Implement SAP Accounts Payable best practices

Ditech LLC, Saint Paul, MN

Business Process Analyst

August 2015 – September 2018

Process Analysis with focus on long-term business process improvements

Gathered business requirements for proprietary software & process overhauls

Mapped process flows using MS Visio

Coordinated data collection with other analysts on offshoring initiative

Created ad hoc analysis for senior management

Built supplemental reporting using T-SQL, VBA macros and IBM DB2 queries

Prepared cost-benefit analyses for proposed projects

Served as Subject Matter expert on MS Excel and advanced SQL techniques

Data Mapping to new loan-servicing platform

User Acceptance Testing for upgrades in user screens

Data Analysis of fees led assessment changes generating >$500K/year increase in collections, >$1M/year ongoing assessments.

Developed VBA scripts for tracking closed loans

Subject Matter Expert on late fee assessment

Revised regular expressions used on Bankruptcy payment ETL eliminating thousands of false payment exceptions

Implemented LEAN and SCRUM practices

Loan Servicing Bankruptcy Team Lead

August 2013 – July 2015

Assist Managers and Supervisors in Bankruptcy-related processes including payment processing, account maintenance, loan payoffs, compliance, and modifications.

Developed department database for custom queries, reports, linking tables and data-entry forms

Trained and advised teammates on daily management of accounts in Bankruptcy

Replaced static lists with real-time MS Access queries for Payment Processors

I project managed a data clean-up of bankruptcy table information resulted in an immediate decrease in payment exceptions of 35%

Authored original procedure manuals

Re-organized and automated data collection for identifying regulated advances

Quality and User Acceptance Testing on proprietary software for Daily Simple Interest loans

Developed illogical condition reports for problematic loan conditions

Developed SQL queries to identify fees not matching Bankruptcy payment plans

Senior Payment Processor

December 2010 – July 2013

Revamped unidentified payment research processes. Improvements netted approximately two FTE savings by reducing the source of unidentified payments and expedited payment application.

Designed targeted queries for improved workflow and account identification.

Provided training in MS Excel and Access to teammates to improve their efficiency and accuracy.

Self-managed project identified and eliminated root cause of 2,000 manually-corrected monthly exceptions.

General Mills, Minneapolis, MN

Grain Inventory Accountant

August 2007 – February 2009

Tracked the purchase, sale, value and movement of millions of bushels of grain through a major food manufacturer.

Generated daily reports on volumes and value of commodities in company elevators throughout the U.S.

General Mills, Minneapolis, MN

Grain Inventory Accountant

Assistant Accounts Payable Supervisor

June 1995 – July 200

Assembled monthly working capital reports

Collected escheated funds under Pillsbury and General Mills’ name nationally.

Analysis of SAP reports on check-cashing patterns lead to modifications of Treasury’s cash flow assumptions.

Contact this candidate