Sandy Steward

Cincinnati, OH

513-***-****

ad0wel@r.postjobfree.com

Professional Summary:

Hands on experience in accountabilities, Fixed Asset, GL posting, Reon, Credit Specialist AR/AP, Business Expense Admin, Office Admin.

Strong knowledge with Microsoft applications and import/exporting data from various databases and communicate resolution.

Time management enhancements are displayed at month end with improving and organizing report data with explanation.

Computer Database Skills:

MS Office, Epicor, Doclink, Peachtree, QuickBooks, SAP, AS 400, Coda, Colbert, Concur, Citrix, Express5 on-base online, FAS, Frontier, Gelco, ACE, Lotus Notes Database, PeopleSoft, Prism, Maximo, MSA, Quicken, Enterprise Journal, SharePoint, Oracle, Business Objects, Content Manager, Apple IIe, CRT, Delta Data, Schwab Fund link.

Education:

Accounting - AIU College Online - Attended 2007/2009

Accounting Technology Cincinnati State Technical and Community College Cincinnati, Ohio

Degree: Associate of Applied Business - AAB

Certificate:

Northwest Senior High School Computer Application - CAPC.CTL Graduation Date: 06/06

Professional Experience:

Work Experience

Kao USA

AR Analyst present-12-2021

Apply payments from PNC wires, check remits per open revenue.

Allocate deductions per 10 reasons codes resolve and clear direct GL deductions penalties, freight, fairshare charges.

Export deductions aging per accounts from SAP to analyze trends and investigate shortages and returns.

Interact with internal/external customers, Brokers, Sales, to resolve outstanding issues with disputing deductions.

Process accounts receivable information concerning deductions, related to deals and store offers discounts, discontinued items.

Perform regular analysis of Key Performance Indicators (KPI’s) and to take steps required to attain service goals and objectives.

Compile monthly reports and communicate results to the appropriate personnel & Supply Chain.

Maintain desk manual including update contacts, process per account assigned every 6 months with treads on deductions.

Support Team members with applying cash on account while assisting with training and navigation knowledge.

Engage continues communication with Hybrid base skills meetings & team chats while attending workshops per corporate webbase.

Investigations Specialist (Contract role)

Citi Bank via Mindlance 2/21 - 2022

Scan all checks for investigations.

Verify aba, routing numbers, amounts, legal lines etc. in conjunction with rescans (imaging)

Administrative work related to check scans and investigations.

Meier’s Wine Cellar Cincinnati OH 2/20-12/20

Government Reporting

Maintain monthly inventory reconciliation prep excel spreadsheet shipments, receiving, adjustment.

Reported monthly 7 forms to TTB Wine and Spirit activity with several computation and conversion.

Reconciled both monthly for adjustment to report proofs per physical inventory balancing.

Retrieved data support for reports submitted from various system sources, Access, Doclink, Epicor

Communicate inventory negative balances on all products for adjustment.

Insight Global Staffing - Fifth Third Bank Cincinnati OH 12/18 – 06/19

Investment Ops - Reconciliation

Monitored investment activities (exchanges, trades, buy, sell, transfers)

Conduct audits to resolve variance between main frame and holding system software.

Completed adjustments to balance general ledger accounting with holding system software.

Reconciled investment accounts/subs per share activities

Prepared workbook/excel spreadsheets from PDF data for merger.

CDK Global Cincinnati, Ohio 02/17 – 12/18

Account Specialist

Define, design and work on continual improvement of the AR process, customer billing & credit.

notes, service contract management and write-offs

Assist in the process of researching and resolving customer disputes and issues, providing support and service excellence to our customers, and securing payment of disputed debt process is implemented and continually improved.

Maintain accurate records of all AR activities.

Assist in producing accurate reports for management on a daily/weekly/monthly basis with attention to detail.

Jacobson Ins. Staffing – Great American Ins Cincinnati, Ohio. 10/16 – 12/16

Accounting Assistant

Processes daily transactions for department, journal entries into PeopleSoft

Resolve and post customer payments per PNC bank expectation daily per deadline.

Process daily deposits per the PNC check scanner

Disburse all department checks daily with required process for MPCI loss checks per PC.

Record all PeopleSoft checks per tracking/log on excel workbook for auditing.

A-line Staffing-Omnicare Cincinnati, Ohio 8/16- 9/16

Contract Pricing

Navigate between multiple excel workbooks and systems to obtain current pricing information.

Develop standard pricing templates utilizing Microsoft Excel

Pinpoint cost within an account/facilities contracts form PDF documents

Populate excel template with appropriate cost or equation per contract agreement.

Review pricing requests and ensure that all fields are properly completed per facility type.

(Assistant living facility- ALF, Skilled living facility- SNF, and other)

Analyze and input current pricing within the company’s operations systems (DX)

Macys Corporation Cincinnati, Ohio 8/15 – 7/16

Account specialists

Submitted invoices for project director approval through a database.

Initiated invoice posting procedures for vendor payment, check run.

Performed daily reconciliation of general ledger, internal DDA.

Monitored exception report and resolve with appropriate personnel.

Accounts receivable cash issues

Reconciled offshore remittance processing, Cash Balancing/ Accounts Receivable, Daily and monthly cash balancing.

Recruiting Agencies Cincinnati, Ohio 2012-2014

Accounts Payable

Daily invoice data entries into FDM4 an AS400 system 200+

Monthly operating expenses entries direct to GL coding

Twice a month match invoices to check copy and file.

Monitor A/P entry for efficiency.

Ensure all “Drop Ships” invoices are entered at month end.

EXTENDED EXPERIENCE

BASF, Formerly Cognis Corporation Cincinnati, Ohio 1999 – 2011

Fixed Asset Accountant- 2006 to 2011

BASF

Created project structure outline for project request/proposal (WBS element-SAP)

Processed release procedures for project structure outline per budget approval

Calculated monthly Capex project spending activity WIP, CIP on linked excel spreadsheet.

Created assets to begin depreciation life from the project structure outline.

Allocate assets to project structure outline.

Settle Capex spending balance

Prepare fixed asset depreciation accrual monthly.

Reconcile Capex spending by location, asset.

Close project structure outline

Report CIP monthly to Engineers

Accounting Assistant

Administrate check runs twice a week, estimated weekly volume of 800 checks.

Conduct PC allocate by Percentage.

Created customer credit/debit memos per request.

Responsible for preparing the month end journal entries consisting of over 1500 transactions.

Administrator of the corporate Visa card accounts and maintains daily applications.

Compare the income statement report against the accumulated cost center report for month end.

Complete year-ends audits tax schedules on expense accounts and provide information on the Senior Management Team (SMT) spousal travel yearly.

Conduct routine audits on random employee's expense reports.

(Detailed Resume Upon Request)

Contact this candidate