Finance/Data Analytics

ANDREW D. MCALLISTER

719-***-**** ● ******.*.**********@*****.***

EDUCATION

MARRIOTT SCHOOL OF MANAGEMENT, BRIGHAM YOUNG UNIVERSITY Provo, UT

Bachelor of Science, Business Administration August 2009 – April 2012

3.57 Cumulative GPA

EXPERIENCE

L-3 COMMUNICATIONS Salt lake City, UT

Finance Analyst February 2014 – May 2016

●Developed a reporting process within Excel and SAP that utilized macros and advanced formulas to generate and distribute 100+ individualized reports. The former process required 120+ man hours weekly, but under my new system this was reduced to a mere 8 hours.

●Created an Access database to document and track all incoming department requests. Assignments are now able to be conveniently prioritized and distributed to the appropriate parties. The system drastically increased turnaround time and prevents requests from falling through the cracks.

●Received an award for being “Most Indispensible” as the go-to expert for Excel, Business Objects, reporting and process improvement.

SELECT PORTFOLIO SERVICING Salt lake City, UT

Client Relations Analyst November 2012 – January 2014

●Worked closely with executives to provide dashboards, performance metrics, and other analytical support to internal business units and clients by creating ad hoc SQL queries and advanced Excel workbooks.

●Developed macros and VBA functions to automate regularly referenced reports.

●Created transaction management and legal notice databases using Microsoft Access resulting in streamlined processes, increased communication between inner departments and clients, and maximized user friendliness for both clients and executives.

●Reviewed legal contracts and extracted key points giving executives the info they needed to make informed decisions.

ACCRETIVE HEALTH Provo, UT

Operations Lead January 2012 – June 2012

●Implemented Accretive Health’s systems and processes to improve front-end revenue cycle operations at Utah Valley Regional Medical Center and six outlying rural facilities.

●Planned and conducted weekly training sessions aligning the team’s goals and performance.

●Identified patterns and analyzed data trends for delinquent accounts allowing for the collection of over $250,000.

OFFICE OF INFORMATION TECHNOLOGY Provo, UT

Accounts Receivable Accountant December 2009 – January 2012

●Developed a macro program to automate a lengthy task eliminating the potential for human error and the need for approximately 150 hours of labor annually.

●Performed audits at Brigham Young University facilities, allowing for the collection of thousands of dollars’ worth of previously provided but unbilled services.

FREELANCE SERVICES June 2012 – Present

●Inventory Management Systems

●Pricing Analysis

●CRM and Other Database Creation

●Website Development

●Ghost Writing and Editorial Services

SKILLS AND DISTINCTIONS

●Microsoft Excel Expert

●Proficiency with Microsoft Access, Business Objects, SQL, AS400, VBA and SAP

●Published Author (V. K. McAllister)

●Fluent German

●Eagle Scout

Contact this candidate