Analyst

Zachary C. Chapman

***** ***** *** **, ***. B-***, Kent, WA 98030

757-***-****, *******@*****.***

Analytical thinker with the ability and desire to learn, catch on quickly to new concepts to maximize potential, and be inspired by department ideals to go the extra mile

Work Experience

Ferguson Enterprises

Vendor Funds Analyst (October 2014 June 2015)

●Calculate and submit 45 reports totaling $4 million monthly and requests for payments to vendors

●Assist in the creation of vendor reconciliation programs to honor vendor contracts

●Assessment of program changes on reconciliation program master data including making changes in Microsoft SQL Server and ACCESS databases

●Analyze and compare vendor submitted information to internal pricing to ensure all eligible distribution center sales are included in the reconciliation calculation

●Communicate with vendors and sourcing managers regularly with updates on respective programs, business opportunities, and to relay important account information

●Collaborated with 4 departmental coworkers on one-off scenarios to come up with solutions

Ferguson Enterprises

Accounts Payable Coordinator (November 2013 October 2014)

●Meticulously reconcile discrepant invoices from downloaded report to evaluate inventory and verify freight terms between Ferguson branches and vendors

●Maintained and exceeded department requirements of 20 discrepancies per hour while averaging below 1% error rate.

●Communicate with the branches/management as needed for resolution and payment approval

●Bill customers, use proper general ledger coding, and analyze payment terms as necessary

Peninsula Escrow and Title Company

Post Closer (May 2010 August 2011)

●Dispersed real estate files within 48 hours to comply with RESPA/CRESPA regulations

●Created real estate contracts between seller and lenders regarding property sales

●Followed up with clients concerning inquiries regarding past closed files

Education

Old Dominion University, Norfolk, Virginia

Bachelor of Science in Business Administration Graduation: July 2013

Major: Accounting Major: Business Analytics

Skills

●MS Office and Advanced Excel knowledge (vlookups, pivot tables, financial modeling, etc.)

●SQL Server Management Studio experience altering and pulling queries

●Eligible and actively pursuing CPA licensure within Washington

●Strong knowledge of Generally Accepted Accounting Principles

Contact this candidate