John Reeves

**** ****** ***** **.

Watauga, TX **137

817-***-****

SUMMARY

An Accounting associate with extensive background in accounts receivable and payable and data analysis including monthly, quarterly, and annual scorecard reports.

Excellent communication skills with internal and external customers.

Works well as an individual contributor as well as being a team member.

High knowledge of MS Office Suite as well as trouble-shooting computer hardware.

Accounts Payable (po# match)

Accounts Receivable (Researcher II)

Excel (PivotTables/Vlookup)

Access (Outload of data to Excel)

SAP (upgrade from AS400)

Electronic Data Invoicing (EDI)

Data Entry (at every position)

Oracle Based System (New Breed & Corelogic)

PROFESSIONAL EXPERIENCE

M.S.I., Keller, TX December 2018 – May 2020

CMT2 Processor (2018)

• I currently keep track of about 140 loans for CMT2 Presale Non-FHA orders.

• I am ask to order Recurring Grass Cuts on occasion for the whole dept. (varies)

• I keep track of Initial Secures and follow-up with them every 3 days until the Rep has secured the property, then I change PRPSEC in web direct to “closed”.

M.S.I., Hurst, TX / North Richland Hills, TX December 2014 - 2018

Final Billing - Billing Analyst - QC Billing and Final Billing (2016)

•I research work orders the QC Biller has requested to be Final Billed and double-check everything that appears on the Final Billing to make sure all Federal Guidelines are met and that each client is billed correctly and that we pay the vendor correctly.

•I also backup the person who divides the work orders up within our department so that we do not work the same work orders. This involves using the vlookup function in excel.

•Recently, I was crossed trained on how to work Vendor Disputes when they do not agree with a payment they have received from M.S.I.

CORELOGIC, Westlake, TX August 2013 - November 2014

Through the Volt Agency

Accounts Receivable - Researcher II

•Data Analysis comparing daily Reconciliation reports against ORACLE reports and doing research to find out what is different between the two systems and reporting this out.

•Daily, I utilize the "vlookup" "Pivot Table" functions within Microsoft Excel to help determine the differences between the two systems noted above.

•I am also responsible for posting the daily Cash Application upload for checks received from Wells Fargo, Ocwen(GMAC), RBS Citizens, etc..

•Also, I help with the research for the Critical Exceptions that kick out of the daily upload of files for both Inspections and Preservation sides.

MITCHELL INTERNATIONAL, Coppell, TX July 2012 - July 2013

Through the Volt Agency

Claims Examiner – New Jersey (Workers Comp)

•Was responsible for Auditing pre-keyed Claims for the State of New Jersey.

•Part of my job was also the keying of the claims that could not be handled through the outside vendor (IOS).

•Responsible for learning/knowing IDX Codes as well as most HCPC codes for the State

DYNCORP INTN'L, FORT WORTH, TX September 2011 – July 2012

Through the Volt Agency

Billing Specialist

•Worked on government contracts and their billing accuracy / compliance

•Ran reports as needed to catch inconsistencies between billings and receivables

NOVATION CORP. IRVING, TX June 2011 – August 2011

Through The Insource Group

Supply Chain Analyst

Utilized Excel and Access to transfer and manipulate data.

Worked on their website upgrade process - gathered logos, product descriptions, and images of products from suppliers to include in the new Novationco.com website.

NEW BREED LOGISTICS, Fort Worth, TX January 2011 – May 2011

Through Express Employment

Data Analyst

Utilized TOAD (front end for SQL) and edited and executed SQL statements.

Transferred data from mainframe to Access, exported data from Access to Excel, and used advanced features of Excel (including vlookups and pivot tables) to extract and analyze data.

Performed research and analysis for the company's warehouse that stocked cell phones.

MCKESSON CORPORATION, Carrollton, TX 2001 – October 2010

Sr. Account Representative

•Accounts Payable

•Accounts Receivable

•Analyze Data

•Data Entry

•Ran monthly, quarterly and annual Supplier scorecards to view trends on receipt of electronic invoices. Information used to track defects from transmitted data in order to identify root cause of defect.

•Compiled individual suppliers’ data in order to provide specific defect trends to Scorecard Team which would present findings such as:

•matching by exact purchase order number

•listing incorrect “ship to” address

•verifying correct unit pricing and/or Unit of Measure (UOM)

•unusually high shipping costs

•Ran monthly Open Sales Orders for all purchase orders over 30 days to identify potential internal/external errors on invoices.

•Utilized SAP, C.M.S., S.M.O., Word and Excel to assist in facilitating processing of invoices.

•Billed drop-shipped customers and paid suppliers using EDI/IXOS.

•Ongoing communications with Distribution Centers, Suppliers, and Service First (Customer Service Department) in order to verify customer demographics, account numbers, invoices submitted, and any other general order information.

EDUCATION

Trinity High School (Euless, TX)

•Obtained High school diploma

•Vocational Course on – Office Education

Contact this candidate