FINANCIAL SYSTEMS

Implemented NetSuite as a billing system interfacing with a custom billing engine, including 22 multi-currency subsidiaries at a content delivery company.

Created model for the automatic reconciliation and upload of QuickBooks activity into SAP for a publicly held technology company.

Managed the software selection for a new ERP and Expense Reimbursement solution for entertainment publishing company.

Project managed Oracle Fusion (Cloud) implementation, including system configuration, chart of accounts re-design, business unit segmentation, data mapping, UAT and testing to go live at pre-IPO tech company.

Chief Finance Lead for HFM (Hyperion Financial Management) and Hyperion Essbase 2.0 software implementation, including the oversight of the successful migration of data, analytics and processes from Oracle to HFM and from Hyperion Essbase 1.0 to 2.0.

Championed conversion of equity compensation accounting and administration from Excel to an external, cloud-based software solution, EquityEdge, including creation of infrastructure to capture and appropriately report data for proper accounting and dividend calculation, validation of historical data and ongoing management of appropriate individual participant account balances for publicly held REIT.

Created automated reporting table and chart dashboards in Anaplan for private equity backed B2C SaaS company. These dashboards included variance comparisons, YOY growth trend lines, water fall net bookings and unit breakdowns, annual (past, current and future) trend lines and version analysis.

Developed MS Project VBA application to auto-generate timeline and milestone reporting for project team communication for national restaurant company (e.g., online weekly agendas, important dates section, key project documents section, functional area document libraries).

Designed and implemented ERP update of Oracle EBS for cost accounting module, including gap analysis, development of user requirements and process flows for a pharmaceutical company.

Led evaluation and selection process to identify a dynamic Budget, Planning and Forecasting SaaS solution to integrate existing ERP HR, and event planning systems and replace static MS Excel-based spreadsheets for large publicly held entertainment company.

Managed integration responsibilities for the Finance department of a $500M consumer products company during the implementation of NetSuite, including working with internal and external resources in the configuration of forms, records and workflows, working with internal and external software programmers in the design and QA of custom programs, and gathering information from various Finance team members to develop more effective reporting and enhanced processes.

Designed process for 820 EDI (cash application) and worked with internal software developers to automate functionality in NetSuite, including the reporting for improved analysis and process validation.

Built financial statement modeling for migration from QuickBooks (by company) into NetSuite (by Product Family), including re-allocation of audit adjustments by quarter, more detailed segmentation by product family and detailed SG&A allocation by department for a multi-level marketing company.

Completed Workday HRIS General ledger mapping and file export implementation for a social media company. Reversed and manually rebuilt 3 months of inaccurate payroll data for 7 payroll periods of roughly 800 people. Constructed comprehensive bridge file showing full traceability of data reversed and replaced. Successfully reconciled majority of the significant accounts.

Oversaw and performed all Finance function tasks for Ultimate Software’s Ultipro HRIS implementation and integration to Oracle EBS, including GL integration strategy, all earnings and deduction code mappings to GL accounts, earnings and deduction code testing in the payroll files and configuration and testing of integration to JP Morgan for payroll ACH file transmission.

Wrote all test scripts and performed all testing on behalf of accounting/finance in support of a successful MRO integration with Oracle EBS.

Implemented Excel4apps GL Wand (general ledger reporting) and Reports Wand (Oracle sub-ledger reporting) reducing month-end variance analysis time by days leading to a more timely and accurate close for publicly held technology company.

Implemented the Oracle Cash Management module with full integration to bank using automated file transfers to clear payments in Oracle and reconcile cash daily. This removed several hours of manual cash reconciling work from the month-end close for $300M publicly held company.

Assessed feasibility of managing weekly revenue flash forecasts in Salesforce system, including development of standardized requirements.

Project managed the implementation of an automated billing system, Zuora, including the development of custom reports and the integration of an integrated sales tax collection system, Avalara, at VC-backed SaaS company.

Advised on methods to streamline, increase accuracy and improve security of MBO (Management of Objectives) consolidation, reporting and distribution process by shifting reliance from Excel to in-house databases (Essbase) and third-party compensation applications for private equity-backed retailer with over 10,000 employees.

Developed Data Mining and Reporting GUI using Access/SQL/VBA, resulting in one-stop shop replacing legacy process that required multiple platform usage.

Implemented fully-automated monthly reporting process using VBA to extract salient data from 300+ deals to feed centralized data repository in SQL backend.

Assisted with the migration of stock compensation programs from Option Ease to Shareworks and from Shareworks to Morgan Stanley Sapphire and FAS systems including fixing migration issues and errors and creating reconciliations of share and compensation expense calculation differences.