Financial Analyst /Accounting

Thomas A. Driscoll

**********@***.*** 515-***-****

Summary

I am a highly motivated and detail-oriented individual with nearly fourteen years of accounting experience and analytic skills seeking a Parts Forecast Analyst position.

Experience

Accountant, John Deere Financial, Johnston October 2012 – Present

Work closely with Supply management and business areas to create Purchase Orders, answer questions regarding PO's, and research any issues with purchase orders such as incorrect charges, incorrect G/L, credits, etc.

●Utilize the following Excel functions in performing my daily responsibilities including, various Excel formulas, including but not limited to, Pivot Tables, V-Lookups, SumIF and Conditional Formatting

●Prepare manual journal vouchers for travel, payroll, accruals, other expenses, incoming customer payments and inter-company charges.

●Review and analyze fixed assets: AFE’s, AFD’s, AFL’s and prepare monthly fixed asset reports for management. . I work closely with FASS to ensure the Fixed assets are recorded accurately.

●Assist with month-end closing including reviewing balance sheet and income statement. Identify and research variances and determine if an adjustment or an accrual is required.

●Work closely with the Tax Department to prepare, analyze and file sales/use tax for the state of Iowa and Wisconsin quarterly. Prepare and file sales/use tax for Nevada yearly.

●Prepare, analyze and file Real property and Personal property taxes for the state of Iowa and Wisconsin.

●Prepare year-end financial exhibits for Corporate/Consolidations accounting, dues and donations, external audit fees, and property reporting.

●Participated and led various projects: testing and implementation of updated Cash Application version, the conversion of SAP-PDF to SAP-PFI, transition of Canadian accounting functions to JDF in Johnston, and the alignment of JDF Property G/L accounts with the Enterprise G/L accounts

●Work closely with contacts from other units to analyze and post daily incoming ITS memos from different units and ensure backups are properly provided for audit purpose.

●Responsible for daily ACH validation/balancing and balancing of US and Canada bank account activities using the FEBAN, PTS Business Objects and RMDS reports. Determine discrepancies and what course of action needs to be taken to correct the discrepancies.

●Work closely with contacts to analyze and post daily incoming ITS memos from different units and ensure backups are properly provided for audit purpose.

●Balance and Post process daily bank transmissions in our FEBAN system. Work closely with Treasury to determine actions needed for pending transactions.

Accounting Associate, John Deere Financial, Johnston IA May 2006 – Oct. 2012

●Balanced Cash Processing Application - the balancing process matches the daily incoming and outgoing transactions in CPA to the daily incoming and outgoing transactions in the BCGK RMDS report and the daily incoming and outgoing transactions in the general ledger. The balancing is done daily and matches the prior days CPA activities to the prior day’s GL activities.

●Reviewed manual journal vouchers or application for accuracy. Researched any reconciling items and determined course of action needed to make corrections.

●Handled the balancing of daily and monthly various Bank Accounts. Identified and resolved issues from these transactions directly with appropriate banks or individuals who posted the entries

Handled OIB cash - invoice based billing payments, including applied payments and credit to specific invoices and accounts

●Handled customer payments to accounts in CPA. including Mars, Revolving, Lease payments, and profile payments. Assisted colleagues with cash application and journal voucher questions

Technical Skills

SAP PFI, PTS

Microsoft Excel, Word, and PowerPoint

Legacy system: TSO, RMDS

Walker

CPA, MARS, Deere1, CACS, Lease, RMD, Monti, Service Desktop

Awards & Recognition

2019 CFO Award Winner - 2017 tax reform and accounting methods implementation

Own the Moment Silver Award - 2018 Wisconsin Sales Tax Audit

Own the Moment Silver Award - Teamwork in taking on extra tasks for several month's while a coworker was working on a project.

Own the Moment Silver Award - U.S./Canada accounting consolidation

Own the Moment Bronze Award - Updated Cash Application implementation and testing

Education

●B.S., Accountancy, Simpson College, Indianola, Iowa

Contact this candidate