Account Administrator Treasury Analyst

SUMMARY

Experience in Accounts Payable; Three -way match; PO Reconciliation; Cash Applications.

AP Full Cycle, GL Coding; ACH refunds and issuing check refunds.

Creating, running query reports, data testing and integration, Financial Reporting;

Proficient in using various Software applications: Microsoft Excel, Oracle, Crystal Reports, QuickBooks, PeopleSoft, MS 365, SAP.

DATA SOFTWARE SKILLS

MS Applications: Outlook Lotus Notes Internet & Intranet networking skills. MS 365 Applications

Acct Database: Data Warehouse; OMS; Doc Imaging; AS400; PDX Sales Force, Kofax

Acct Software: People Soft; QuickBooks intuit; Peachtree, ARIBA; Regions MAAS, Quick Check, SAP, Yardi, Sage, Coupa, Concur, NetSuite

Software Systems: Crystal Reports; Oracle Quick Check, EPPN; Envision, Data Image

FEDX & UPS Website Research PODs, BOL, PDX, ODC4, Ariba data Systems

PROFESSIONAL EXPERIENCE

Weather Group Television, Atlanta, GA 05/19 – 05/22

Senior Account Payable Analyst

Vendor setup foreign and Domestic; 1099 tax verification & vendor account management & 1099 reportable vendors

Process purchase order and non-purchase order invoices and analyze invoices for proper use tax self-assessment

Collaborate with Procurement and Weather Group Television associates to resolve invoice exceptions and denials

Audit travel and expense reimbursements for policy compliance and resolve ACH bank rejections resulting from invalid banking details

Daily Invoice entry & weekly invoice audits on min of 150.

Audit travel and expense reimbursements for policy compliance and resolve ACH bank rejections resulting from invalid banking details

Review vendor profile, payment terms to ensure it matches vendor’s agreement.

Key vendor master additions and updates and manage incomplete vendor submission requests to bring to resolution

Initiate manual wires through the online treasury management portal and record journal entries for invoice and wire accruals for month end and annual.

Perform the administration of Concur T&E cash advance process and assist AP Manager with Concur; PeopleSoft and NetSuite ERP system administration responsibilities

Format electronic data files and upload to PeopleSoft / NetSuite ERP system; correct and resolve data errors when generated.

Perform the setup of recurring invoice contracts for vendor payments.

Assist with system implementations and perform system testing as required.

Assist with unclaimed property due diligence efforts for vendor payments.

Perform 1099 Miscellaneous Income tax reporting and assist with 1042 Foreign Person’s annual income tax reporting.

Assist AP Manager with annual audits and taxing authority reviews Research open claims to identify and resolve vendor inquires.

Assist with complete system conversion project including performance testing.

SunTrust HQ, Atlanta, GA 05/18 – 04/30/19

EIS Account Payable Analyst - Hays Staffing Agency

Created process for Global & Non -Global Resources for successful department audit.

Provide Invoice approval and updates for Global and Non -Global projects.

Ensure project hours align with contract within approved budget & correct GL Account.

Support SFO, CTO, Project Manager; Account Manager and Controller to achieve all project related deadlines.

Research and resolve exceptions on Project related invoices resolve 80% VMS time-mate discrepancies’ immediate payment.

Resolved entry errors on Project ID; Cost Centers; GL Code identified and provide resolution.

Identifying missing data off EPPM System to report accurate data.

Provide EIS Assistant Controller end of day status report with target points on invoices in pay status.

Last Quarter end of prior year project and goal was to complete all remaining CE Projects for year-end close out. Ensure data and revisions with correct approvers listed based on the project dollar and capitalized expense rerouted for approval. Successfully completed before deadline.

First Key Homes, Marietta, GA 03/17 – 05/18

Account Payable Analyst

Researched and resolved past due invoices rejected from payables due to discrepancies. Resolved 60 invoices daily provided vendor payment by, revision correction and resubmission for payment.

Ensured any home improvement invoices over 5K contained notarized Lean Waver prior to release payment.

Coded invoices & breakout by work detail to ensure items were charged to correct job code tied to its budget on turns or rehabs homes.

Matched Purchase orders to vendor location base off company branch location & daily system updates.

Ensure each work order stayed within budget and submit request for additional funds on those that exceeded limit

Payables project that started with over 300K open invoices in past due category. I resolved over a 3rd of open invoices

Review freight bills prior to payment processing to ensure information is listed and accurate ensure no duplicate payments. Reviewing supporting documentation name of shipper, description of freight, ship location, amount, shipment details, weight, amount and shipping location ensure review to ensure payment has not been processed.

Processed payments for operational accounts and ensured billed to the correct GL.

RaceTrac, Smyrna, GA 06/16 – 12/16

Treasury Analyst – Contract

Special projects initial fundamentals to ensure completion of all deadlines until company integration system is operated at full capacity. Due to successful outcome within time frame - contract extended twice requested assistance by other departments.

Started with department 3 months behind on reconciliations. It only took me three weeks into the project to get A/P back to current. My assistance was requested for other departments including IT to help with integration software testing. Prior to the end of my contract, I left successful results of positive impact for all areas.

Performed system testing to ensure current software is providing accurate reports and both systems agree and matches end of month bank statement reports.

Maintained all RaceTrac ATM’s for state of Texas and ensured the replenishments successfully completed.

Managed ATM activity reports for volume by location to ensure accurate disbursement requests and that all are operable.

Scheduled ATM service & maintenance. Ensure all scheduled deposits reconciled to statement reports. Updates to Armor Car & Loomis service operators with future replenishment schedule and service dates.

Three -way match. PO reconciliation and credits.

Reported Daily calculations for proof of cash and report daily drawdowns totals.

Gather backup for pre-approval on payments processed for FinTech alcohol beverage.

Merchants Preferred Lease-Purchase Service, Atlanta, GA 03/14 - 06/16

Business/Treasury Analyst

Fund contracts, Processed Batch Report upload data and released ACH batches.

Processed payments calculated and adjustments to ledgers on cancelled contracts.

Generate end of day reports researched batches prior to release and reconciled it against sales orders

Upload data into Quick Books and processed QB end of day report.

Performed daily and end of day reports through Regions treasury and reconciled prior day’s batch released against bank statements.

A/R Posted customer payments and updated and maintained customer’s ledger

Processed ACH refunds and issued check refunds applied adjustments to customer’s ledger.

Monitored and notified Dealers of any Credits owed and applied it against next contract deal.

Researched ACH Returns by follow up calls to notified dealers of discrepancies with their account to resolve and resubmit funds. Obtained scanned copy of voided check to add to vendor file. Updated vendor profile with new revisions in LTE and processed new payments. Posted Journal Entries and provided notes in LTE and Quick Books for (Returns).

Diamond Disposal Inc., Austell, GA 10/11 - 02/14

Account Administrator

Managed receivables with 98% successful collection ratio

Researched and resolved customer inquiries provided resolution

Reported on monthly payables and reconciled credit card report to monthly statement

Posting cash applications, cc payments, and customer checks.

Preparing various month end reports and report on revenue for Monthly, Quarterly & Yearly

Providing drivers with weekly route reports and customer delivery details.

Scheduled meetings, travel arrangements and assist owner with itineraries.

EDUCATION

Diploma, Everett High School, Lansing, MI

MS Office Suite 2000 Certificate - Southern Polytech Inst. – Marietta, GA

SharePoint 2013 Essential Training

Contact this candidate