PROFESSIONAL EXPERIENCE

Confidential

BPC implementation

Responsibilities:

• Business planning, including the consolidation of Income and Cash Flow statements.
• Analyzing financial/operational data and maintaining analytical tools and models used in reporting operating results.
• Assisting with variance explanations of actual and forecast results compared to plan and prior year.
• Compile and analyze the monthly review packages from each label and summarize the data for upper management
• Processing reports and financial statements out of Hyperion Financial Management system as well as Financial Revenue Reporting and Plan & Forecast systems.
• Preparing deal analysis including new deal analysis and post - mortem reviews.
• Facilitating and coordinating with internal teams for financial discovery deliverables related to litigation processes.
• Assisting in user acceptance testing of SAP BPC reports and development of SAP BPC reports.
• Preparing special ad hoc reports as needed.

Confidential

Financial/Systems Consultant

Responsibilities:

• Performed UAT on financials for both Colombia and Ecuador between Oracle ERP and legacy system
• Created accounting entries needed for both Colombia and Ecuador territory books.
• Designed financial reporting in Oracle ERP
• Designed financial reporting in OBIEE
• Project managed and designed a SQL dB to help solve reporting issues in Oracle
• Used BPC to submit financials to corporate
• Created automated submissions/reporting in BPC
• Created both internal reporting and corporate reporting from the SQL dB
• Worked in an IT Finance group where I liaised with IT to establish project requirements to implement a SQL dB
• Utilized Visio to create system design data flow charts
• Helped with yearend close activities
• Maintained, loaded and performed variance analysis on the 2012 departmental budget in Oracle
• Advised on how to fix system limitations in terms of data by capturing additional fields in order to automate reporting both internally and for corporate after a comprehensive study of client reporting needs and source data analysis.

Confidential

Financial/Systems Consultant

Responsibilities:

• Used Crystal Reports to create P&L, Balance Sheet and Cash Flow for SAP v8.8 (Small Business Version)
• Created an automated consolidation of 6 subsidiaries
• Worked for the VP of Accounting.
• Redesigned a SQL dB to setup a comprehensive datamart
• Analyzed all the ecommerce operational data for the executive power point deck.
• Managed 2 database projects designed to capture IT usage metrics and allocate to the various business units within the company.
• Managed a VBA developer to code the 2 databases.
• Fixed and added to the VBA code after the developer was let go
• Managed a project to load the monthly financials into operation analysis application called Apptio.
• Created a vendor analysis model to launch a new ecommerce platform throughout the company and another model to compare web analytics vendors vs. the current vendor.
• Improved the processes within the group by creating automated upload files using Excel designed to be uploaded into an operational analysis application named Apptio.
• Automated the Data Center model, which was manual and automated the process of monthly actualization.
• Implemented and created an automated financial model used to allocate costs by service.
• Recommended the use of WBS Elements to capture project costs and have them settle to the appropriate GL accounts, which was incorporated in the FY12 budget

Confidential

Financial Consultant

Responsibilities:

• Modeled a five year forecast for the balance sheet, P&L and cash flow.
• Worked for the Director-Controller for the IT Organization.
• Created a presentation of my resulting model for the CFO of the organization.
• Evaluated a process for capturing revenue actuals with an ODBC link to a SQL Server.
• Integrated new requirements into current Access database building tables, queries and a top sheet which automated the process using SQL.
• Utilized Visio to create system design flow charts
• Created macros using VBA
• Created an ongoing best practice for housing revenue actuals using Oracle.
• Tested results and created documentation of process.
• Created on the fly reporting package in excel to link directly to the various databases and pull data real-time for all management's managerial reporting needs.
• Performed costing (amortization, participations, residuals) by-title for TV titles and updated participations models.
• New Line Implementation team member responsible for capturing legacy data for both the P&L and Balance Sheet and uploading by-title into SAP.

Confidential

Financial/Systems Consultant

Responsibilities:

• Managed budgets (500M), forecasts and reporting.
• Implementation team member for Enterprise One (J.D. Edwards) Software package.
• Created a financial model in excel for home video group (both domestic and foreign) for released and future titles.
• Designed and developed Access databases using complex calculations to determine film fees for international territories.
• Worked in BCS and R/3 systems within SAP.
• Acted as a liaison between finance/accounting and IT.
• Helped drive reporting process improvements (both efficiency and accuracy) in order to help group move from a quarterly to a monthly close process.
• Utilized Hyperion reporting tool to create forecast, budget and compare with actuals.
• Performed NPV analysis to determine which titles were write-offs.
• Created templates used to tie out BCS system of SAP to accounting system during financial close.
• Maintained a flash report to help book quarterly accrual for marketing departments.
• Performed reconciliation between Peoplesoft and SAP.
• Increased efficiency in a reporting procedure that used to take three weeks, now takes three days with greater data integrity.
• Developed Monthly Product Profitability Report for Branch Managers to effectively manage new business with key factors at their control.
• Peformed month-end close; account reconciliation; variance analysis.
• Analyzed ultimate schedules for the participations to check for inaccuracies in the financial film models.
• Extensive interface with Senior Management.
• Modeled financial statements out five years.
• Prepared weekly Cash Flow based on collections and disbursements from theatrical, home entertainment, international, and television.
• Created, researched and maintained fiscal operating budget
• Maintained ultimate and other sales schedules.
• Analyzed international contracts and sales contracts.
• Completed Profit Participation reports.
• Performed Regression Analysis