SUMMARY

• Business Process Experience: 12 years of experience as a systems focused accountant, with an auditing, business process, design, and implementation background. Recognized as someone who halps businesses leverage the full value of their current IT investments. Strong focus on solving business problems with technology assets and freeing up finance staff for higher - value tasks by automating manual processes.
• Industry Experience:8 years of Oracle experience (11i, R12, Cloud)6 years of audit and general accounting experience
• Expertise:Chart of Accounts Design, Financial Reporting, Transaction Reporting, Tax Software, Closing the Books
• Products and Tools:Cloud and E-Business Suite Modules: General Ledger, Smartview, Business Intelligence, Tax, Accounts Receivable, Accounts Payable, Project Billing and Costing, Inventory, Cost Management, Sub-Ledger Accounting
• 3rd Party Products:Vertex, Rapid4Cloud, Ad-Orb, Quickbooks, Excel
• Certification or Specializations:Oracle Fusion Financials 11g General Ledger EssentialsOracle EBS R12.1 General Ledger EssentialsCertified Public Accountant (CPA) - active Ohio license since 2007

PROFESSIONAL EXPERIENCE

Confidential

ORACLE CLOUD FINANCIALS IMPLEMENTATIONS

Responsibilities:

• OANDA currency service integration and spreadsheet currency rate loads for translating financials from 8 currencies to USD
• Migrate key financial reports from EBS 11i FSGs to Financial Reporting Studio (FRS). Train end users on FRS and Smartview
• Manual Fusion Tax implementation for US Sales Tax, VAT taxes in Canada, Europe, and India
• Conversion of Oracle EBS 11i GL and Asset data using SQL and spreadsheet loaders
• Configured Oracle Time and Labor for use with Project Financial Management and Absence Management products
• Customized subledger accounting for business unit with multiple legal entities and project costing/billing based on HR data
• Mass update of job assignments in Human Capital Management using HCM data loader, to facilitate project costing

Confidential

Financials Lead

Responsibilities:

• Designed chart of accounts and intercompany setup for 5 legal entity organization
• Designed and built financial reporting package (balance sheet, income statement)
• Customized subledger accounting rules based on transaction attributes coming out of inventory and order management
• Configured and traied client staff on 1099 tax reporting, BAI2 bank statement upload and reconciliation
• Configured payables, receivables, and fixed assets, including setup of checks and receipts
• Coached client through AP, AR, and Fixed Asset converisons

Confidential

Financials Lead

Responsibilities:

• Designed chart of accounts after training staff on differences between Quickbooks and Oracle Cloud ERP
• Configured core financials modules: GL, AR, AP, FA, and expenses
• Built complete financial reporting package and custom reports for expense report auditing
• Designed chart of accounts after training staff on differences between Quickbooks and Oracle Cloud ERP
• Trained staff on GL balance conversions and spreadsheet (ADI) journal uploads
• Advised client on migrating data from Quickbooks and Oracle EBS to Oracle Cloud ERP, including the chart of accounts, customer records, supplier records, general ledger balances, and open transactions
• Instructed client on how to upload budget scenarios, and compare to actual, using the SmartView Excel plug-in
• Interfaced web-based ordering systems with Receivables module
• Trained client on setting up e-mailed invoices, statements, and collection letters
• Set up deferred revenue accounting for subscription and service-based businesses
• Configured expense reporting module so employees could submit expenses using mobile devices, and get reimbursed using a third-party payroll provider
• Prepared complete financial reporting packages (balance sheet, income statement, cash flow) using SmartView and Hyperion Financial Reporting Studio
• Designed and built detailed transactional reporting using BI Publisher and Transactional Business Intelligence. Example: Detailed Receivables Aging by Customer
• Designed report to extract financials data for consumption by Oracle Planning and Budgeting Cloud Service

Confidential

Financials Consultant

Responsibilities:

• Created report to show select details and drill down from general ledger to projects, payables, receivables, order management, and payables
• Set up project costing system to capture labor and material cost on engineering projects
• Used burdening functionality to allocate overhead across projects
• Trained client on drop ship, inventory receipt, and cost accounting features in Supply Chain Management
• Advised client on allocation functionality for standard reclassification entries
• Designed complete financial reporting package for large, multinational, publicly traded company with 30+ subs
• Automated the generation of financial reports using books, batches, and bursting features of FR studio
• Various ad-hoc reporting projects including custom supplier and asset listings
• Assisted client in designing custom forms to track various stages of a remodel project
• Designed report to compare projected sales data in Oracle Sales Cloud with actual cost data in Oracle Projects, to arrive at a complete margin by projectManually configured state and local taxes for a regional professional services company
• Customized accounting rules, based on transactional data, to properly classify revenues and expenses for taxes and reportingAdded US, Hong Kong, and China ledgers for newly acquired subsidiary
• Added rules for consolidation of new ledgers to parent company consolidated ledger
• Configured currencies and transaction taxes for US and China entities
• Added new fixed asset categories and trained parent company accountant on fixed asset conversion
• Documented cutover procedures and trained company staff on tie out procedures for inventory on-hand quantity and balances, open receivables, and open payables
• Configured and tested receivables, with emphasis on correct AutoInvoicing of billing lines from order management

Confidential

Senior Accounting Analyst

Responsibilities:

• Set up average and standard costing inventory organizations and sub-inventories
• Migration of data from legacy system to R12, using spreadsheets and manual data validation
• Trained users on maintenance of costing dataConfiguration and testing of custom approval workflows
• Configuration of internal requisition and internal purchase order flow
• Wrote SQL scripts to drill from the GL to AR, AP, Projects, and Payables, to provide the business with detail from the transaction tables dat was not available on seeded reports.
• Drafted requirements used by the BI team to modify the OBI RPD so SLA information was imported in to the data warehouse and joined to existing custom subject areas.
• Wrote ad-hoc SQL queries to get statistics on events in SLA used to halp business determine the impact of moving to a shared services model for US and Canada.
• Account Derivation Rules - Used Order Management and Payables transaction attributes to customize company code, department, and natural account segments on revenue and expense entries.
• Journal Entry Description Customization - Configured SLA so journal line descriptions would include user selected information. For example, freight entries included the original transaction’s order number.Financial Statement Generator - designed and wrote income statement, balance sheet, and management summary reports.
• Security - set up definition and data access sets. Configured security in Report Manager. Wrote testing program for business users.
• Maintained cross-validation rules and accounting flexfield tables.Power user and evangelist of Answers and Dashboarding
• Tested completeness and accuracy of data loads
• Designed process to validate freight accrual using SQL queriesDesigned extract-transform-load process to import non-Oracle time and attendance data to Oracle Projects
• Set up Oracle Inventory module to interface material cost data to Oracle Projects
• Automated time and material cost journal entries by importing Projects data to the General Ledger
• Leveraged Projects for reporting. Used data for estimate to complete calculations and bid packages
• Configured Projects for cost-plus fixed fee government contract.