Senior Accountant/Systems Analyst with Process Optimization

Ira D. Johnson

Federick, CO ***** 720-***-****

www.linkedin.com/in/idjohnsoncolo ************@*******.***

Senior Accountant/Analyst

Expertise in accounting and computer science, reducing duplication of data sources and streamlining systems

Expert in financial processes, coordinating technologies and creating efficiencies. Develop strong relationships within organization, providing effective communication and supporting operational performance feedback. Plan and coordinate projects, utilizing skills in leadership and team-building.

Skills

Accounting Accounting Systems Budgeting, Data Management Financial Reporting

Financial Statement Preparation Generally Accepted Accounting Principles (GAAP)

Showcase Tax Returns Standard Cost Accounting Job Cost Accounting

Experience

Contract Senior Accountant/Systems Analyst/Business Analyst/Sales Analyst

4/2016 to Current

Korn Ferry-Salo: Contract Accountant

Using SAP and excel to allocated assets, liabilities and expenses that would be transferred to buyer with balance to be retained byparent company.

Using emails and reports from Vendors and brokers to determine grain source, destination, type, grade, contact and price. enter into D365 system and report data to plants.

Created models to upload Master file data from old Oracle system To Oracle Cloud system.

Update current Index Pricing models. Streamline/Automate procedures. Document Data sources for Raw Materials.

Monthly analysis of Consignment sales as needed using “Tableau” Software. updated monthly changes to consignment sales forecast. Update/develop new Tableau reports for Financial Analysis.

Worked with AR team to invoiced customers for services and

product. Received ACH payments and Sent collection requests.

Account analysis. Special projects as needed.

Creative Financial Staffing: Contract Accountant

Data Analysis of the value of purchased assets transferred from previous owner to POM.

Experis/ADM-Rodel: Contract Accountsant

Financial Statements.

Budget.

Journal Entries.

Account reconciliation.

Accounts payable tie out to subledger.

Created Documentation in preparation of transfer of Accounting Department to Corporate Office

Addision/**Nutrien Ag Solutions: Contact Accountant

Used Service now to support the update of correct material pricing.

Clearing Legal blocks on sales of material based upon the requirements by Country and State/Provence.

**Crimson Renewal Energy LP, Denver, CO 6/2017 to 8/2017

Developed requirements for new ERP. Created Demo scripts and Proposal Letter

Brooksource/NEON-Battelle Ecology : Contract Accountant

Reviewed accounts receivable system to replace manual billing to US Government for activity of Non-Profit entity.

Financial Statements.

Account reconciliations.

Journal entries.

Aided in preparation for Inspector General Audit.

Documented Billing to Government.

Documented Procedures for transfer of Accounting Department to Managing Company.

Robert Half/Sprectralink: Contract Accountant

Documented procedure and created new reports for permanent staff.

LEPRINO FOODS, Denver, CO 1998 to 2016

Production Accounting Supervisor / Reporting Analyst

Served as key contributor by analyzing financial information and preparing related reports using multiple data platforms.

Guaranteed data accuracy through assessment of financial records and assigning entries to correct accounts.

Championed technology utilization by:

oOverseeing programming team.

oDirecting and coordinating database procedures.

oScheduling software modifications and installations.

oImplementing database security measures.

oTraining users on new applications.

Developed and revised reporting systems, allowing for distribution of clear, accurate data.

Controlled workflow by determining project goals and limitations

Created system databases which:

oImmediately identified problem production issues by pallet, location, defect, and specific period.

oResolved issue where faulty reporting caused variances of $135K, reducing unexplained differences to $1.

oTracked repairs to internal and external equipment and identified open work orders and accumulated cost.

oTied purchases orders on sub-ledger to General Ledger and displayed age of open POs for review.

THE ELECTRON, Littleton, CO 1994 to 1998

Senior Accountant/Fixed Assets Created links to data sources and communicated with department heads to reduce time required to create reports by 36 hours weekly.

FLETCHER OIL & REFINING, Carson, CA 1986 to 1992

Division Assistant Controller / Excise Tax Manager / System Administrator

Established database which merged physical and paper sales to create excise tax reports, validate tax documentation and create sales analysis for senior management.

Excise Tax

Property tax

Additional Professional Experience

MACY & ASSOCIATES CPA, Casper, WY

Audits / Taxes / Compilations and Reviews /Developer

Income Tax Corporation, partnership and individual

Financial Statements Corporate, Partnerships

Technical Skills

Computer / Tableau, Netsuite, D365, Essbase, Showcase, database system design, SAP Query designer, SAP Bex analyzer, VBA, Visual Basic, OLAP, MS Office, JD Edwards (17 yrs), Technical Support, Open Database Connectivity (ODBC), Systems Analysis, Java, Sales Force

Certifications and Professional Licenses

Certificate: Passed CPA exam

Education:

Bachelor of Science (BS), Management Information Systems (Combined Accounting / Computer Science), University of Wyoming, Laramie, WY

Contact this candidate