Diane L Oltmann

Grimes, Iowa *****

515-***-****

Summary

Skills and experiences include: Finance Manager, Accounting Manager, Project Manager, Project Coordinator, Subject Matter Expert, Accounts Payable, Accounts Receivable, Asset Management, Budget Management, File Management, Forecasting, Payroll Processing, Fixed Assets, Procurement, and Purchasing.

Technical Skills

Word, Excel, Project Manager, Access, Visio and PowerPoint.

Other Applications include: Business Objects/Crystal Reports, QuickBooks, Quicken, PeopleSoft, STAMP, Planview, PMUWS, SharePoint, Planview, Oracle, Citrix, Primavera, PIC; AS400, TAS, PACT, Concur, and PASS.

Professional Experience

Wells Fargo Bank, West Des Moines, IA (Contractor) March 2020 to March 2021

Business Systems Consultant – Contract will be ending soon.

Responsible for coordination of the Enterprise Business Technology processes and IT Releases.

Create change requests, work orders and work requests in PAC2000 system for each release.

Upload documents into SharePoint, and numerous Wells Fargo systems.

Set up release meetings, create agendas, send out correspondence to team.

Federal Home Loan Bank, West Des Moines, IA (Contractor) May 2019 to November 2019

IT Financial Analyst

Responsible for coordination of the Information Technology and Information Security Budgets.

Prepare and manage the FY 2019/FY 2020 Financial Budgets; review invoices.

Provide Key Performance Indicators and review monthly report for Management Teams.

Review telecommunication invoices for accuracy and compliance.

Wells Fargo, Des Moines, IA (Contractor) Nov 2018 to Jan 2019

Business Initiative Consultant

Responsible for activities involved with sale/transfer of mortgage portfolio currently provided by Wells Fargo Mortgage to a new service provider. This involves all types of mortgage loans.

Prepare, publish minutes from meetings and schedule meetings with business teams regarding mortgage transfer/sales.

Monitor systems activity for sales/transfers; review issue logs; review transfer logs and monitor change request logs.

Wellmark, Des Moines, IA (Contractor) July 2018 to Sept 2018

Program Coordinator

Responsible for coordination of activities involving a new health insurance policy established between

Wellmark and Blue Cross Blue Shield.

Track and report project status; maintain database documentation in SharePoint; document

Project Managers action items/progress at weekly project meeting; maintain project schedules .in Program Manager schedules and corresponding resource management needs.

Attend Waterfall and Scrum Methodology meetings; post weekly status reports.

Update financial data in system of record; create/maintain Marketplace Readiness Project Workbooks.

Bradley Tools, Johnston, IA (Contractor) May 2018 to July 2018

Hydraulics, Des Moines, IA (Contractor)

Accountant

Responsible for all aspects of AR, AP, and Payroll at both locations. This involves filing the required reports to proper reporting agencies.

Process Accounts Receivable/Accounts Payable; Issue Payments to Vendors and Create invoices for customers.

Prepare financial/budget reports; process Bi-Weekly Payroll; File State Tax Obligations

Manage Accounts Receivable staff.

Resolve/reconcile GL Account reconciliation; prepare GL entries; and Reconcile Credit Card statements.

Wells Fargo Bank, West Des Moines, IA (Contractor) August 2017 to April 2018

Project Manager/Business Analyst

Responsible for monitoring/tracking the status of Developer’s applications for all new and existing applications.

Monitor Developer’s application processes on weekly basis for completeness and accuracy.

Monitor Developer’s outstanding PAC2000 daily problem tickets and prepare ALM Documents in SharePoint.

Follow-up on outstanding processes with Developer exceeding target dates and report exceptions to VP of Service Technologies.

Sysco Foods, Ankeny, IA May 2015 to August 2017

Finance Manager

Responsible for managing the AP, AR and Cash Application Teams and all accounting duties required in these roles. Filing of reports to the proper state reporting agencies on a monthly, quarterly, semi-monthly, and annual basis.

Prepare Weekly, Monthly, Quarterly and Annual Financial/Budget Reports.

Responsible for Managing Accounts Receivable and Accounts Payable staff.

Reported budget expenses each week to the management team.

Reviewed/Analyze budget accounts in the General Ledger; prepared GL entries;

resolve/reconcile account reconciliation issues including aged items, GL Accounts, and Purchase Cards.

Manage the licensing process for Iowa, Missouri and Kansas Resale.

File Appropriate IFTA Road Use Tax, and USE and Excise Tax obligations to Federal and State Agencies.

Maintain the fixed assets additions and retirement schedules.

Review Accounts for 1099 reporting.

Prepare audit packages for internal and external customers.

Oversee and evaluate processes for compliance with accounting policies

Prepare audit packages for internal and external customers.

Iowa Clinic, West Des Moines, IA (Contractor) March 2015 to April 2015

Payroll Accountant

Responsible for processing payroll for all exempt and nonexempt employees and monitoring/tracking benefits.

Process payroll for 500+ employees and oversaw the work of four administrative clerks.

Answer questions/resolved problems regarding payroll, leave time, and insurance.

Maintain record of absent, unpunctual employee and leaves on a daily/monthly basis.

Wells Fargo Home Mortgage, West Des Moines, IA Nov 2014 to Mar 2015

Accountant 3

Ownership of new and/or established processes to ensure Accuracy in the Financial Statements.

Prepare accounting entries and more complex financial reports and analysis.

Preparing audit packages for internal and external customers.

Prepare and/or reviewing Accounting Entries, Account Reconciliations and Certifications.

Review General Ledger Account Data for SEC and Regulatory Reporting Compliance.

Review mortgage loan documents for accuracy (Escrow, Mortgage Loan Application, Legal Descriptions, etc.)

Wells Fargo Wholesale Bank, Minneapolis, MN (Contractor) Apr 2014 to Sept 2014

Project Manager 3

Track and report project status; maintain database documentation in SharePoint, STAMP and PMUWS; document Project Manager action items/progress at weekly project meeting; maintain project schedules and corresponding resource management needs.

Responsible for monthly financial and $2M budget data into project worksheet and STAMP.

Enter/Update monthly forecasts, journal entries, budgets, actuals into SharePoint and STAMP.

Monthly reconcile and approve invoices for payment with Accounts Payable.

State of Iowa, Des Moines, IA Oct 2013 to Feb 2014

Credit Union Examiner

Review the credit union's policy and procedures for compliance; review prior findings and current present findings to Board Members and staff.

Perform the account reconciliation between the GL and Subsidiary Ledger accounts.

Analyze expense reports for accuracy; perform financial statement ratio and analysis on borrower’s portfolio.

Review consumer, home, secured and unsecured loans and the terms issued for compliance.

Assist the Examiner in Charge on conducting the examination as required by the State of Iowa.

Mark Seed Company, Perry, IA (Contractor) Sept 2013 to Oct 2013

Senior Accountant/Inventory Control Manager

Maintain the company's General Ledger and Subsidiary Ledger Accounts; perform the account reconciliation between the General Ledger and Subsidiary Ledger Accounts.

Analyze expense reports for accuracy; maintain inventor control on commodities.

Verify work of Staff Accountants for accuracy and compliance; assist CEO on special projects.

Maintain Accounts Receivable and Accounts Payable Accounts; process bi-weekly payroll.

Marsh & Mercer Companies, Urbandale, IA (Contractor) June 2013 to Aug 2013

Senior Financial Analyst

Review journal entries and consolidated statements; review monthly reconciliation of Balance Sheet accounts.

Prepare and analyze expense reports; review special project data in Oracle.

Perform various financial reporting tasks; coordinates expense accruals.

Wells Fargo Home Mortgage, Des Moines, IA (Contractor) Nov 2011 to May 2013

Project Coordinator 2

Track and report project status; maintain database documentation in SharePoint; document

Project Manager action items/progress at weekly project meeting; maintain project schedules

and corresponding resource management needs; prepare and create agendas and minutes for projects.

Experience with Agile and Scrum methodology.

Create purchase orders; reconcile and approve invoices for payment with Accounts Payable.

Create work requests; run queries; create and post Weekly Status Reports; create Change Requests for technical teams; request approvals and sizings.

Create/Maintain Project workbooks with macros in excel workbook and system of record.

Update financial and budget data in Planview, STAMP, PMUWS and PIC Systems.

Enter budget forecasts and actuals into system of record and determine variance.

Des Moines University, Des Moines, IA (Contractor) Sept 2011 to Oct 2011

Accounts Receivable Administrator

File student documents; review documentation according to retention schedule.

Set up new student files; review student accounts; post payment transactions to student accounts.

Customer service and answer inquiries regarding student accounts.

Principal Financial Group, Des Moines, IA Jan 2004 to Sept 2011

General Accountant II

IT Asset Analyst

Analyze and troubleshooting daily reports in systems for accuracy; perform systems

payment functions within PeopleSoft; special projects; analyze AP system exceptions

within PeopleSoft, PACT, TAS, and PASS; and manage Foreign Vendors Onboarding

and W9 Tax reporting documentation and write process instructions for Accounts Payable Team.

Validate vendor build data in systems for accuracy; and compile dashboard reports.

Review monthly account reconciliations for software, hardware and GL Accounts;

and calculate monthly depreciation expense.

Develop and implement a Retention Policy; Foreign Vendor On Boarding Process; Disaster Business

Continuity Plan; Develop process documentation.

Calculate Monthly Depreciation Expense; Post Journal Entries to the General Ledger.

Worked with Business Analyst on system upgrades for fixed asset module to ensure

technology solutions and processes support business objectives.

Assist in analysis, testing and documentation for upgrades, replacements and

enhancements to Principal's Financial system applications.

Subject Matter Expert for the Conversion Team on General Ledger Upgrade for the IT

Asset Management Group.

Analyze IT Fixed Asset activities in Asset Center Database; Audit purchases and end of life cycle for

IT equipment

Budgeting, forecasting, analyze purchasing trends and determine procurement

equipment needed by the business unit.

Education and Professional Development

University of Phoenix, West Des Moines, Iowa

Master of Business Administration: Business Administration

Upper Iowa University, West Des Moines, Iowa

Bachelor of Science: Management/Accounting

Contact this candidate