Resume

Sign in

Financial Analyst Assistant

Location:
Canyon Country, CA, 91351
Salary:
90000
Posted:
December 07, 2019

Contact this candidate

Resume:

Daniel Stephenson

Santa Clarita, CA *****

661-***-****

ada0ql@r.postjobfree.com

www.linkedin.com/in/danielastephenson/

SENIOR FINANCIAL ANALYST

Financial Analyst with 10+ years in the Entertainment Industry. Expertise includes: financial analysis, planning, and budgeting at a managerial level. Demonstrated skills in assisting with budget decisions and maintaining financial controls. Experience includes: mentoring and coaching junior analysts on a daily basis, and compiling and preparing executive forecast presentations for digital portfolios and demonstrating expertise in and dedication to innovating process.

EXPERIENCE

Recent or Independent Consulting Contracts (Los Angeles) – 12/2018 to Current:

Tutor Perini FP&A Consultant

IPayment Systems Inc Financial Forecasting Consultant

Member of the Financial Planning and Analysis team. Primary responsibilities included P&L variance analysis and quarterly control and review of all financial documents (including Cash Flow and Balance Sheet reports).

Coordinated Annual Operating Plan (AOP) and Strategic Plan for Corporate G&A Departments.

Run SQL financial vendor payments for weekly planning

Monthly prepared and quarterly reviewed department expenses with department managers.

Reviewed monthly closing actuals and accruals.

Identified top revenue and profit drivers by project and explain previous year and budget variances. Final review findings are reported to the SEC and filed as a component of Form 10Q/10K.

Quarterly reviewed and audited the published documents to ensure consistency of information as reported in the 10Q. The process includes the Quarterly Investor Reports, Press Release, Script used on the quarterly earnings call, Board of Director’s presentation slides, and Securities and Exchange Commission form 10-Q/10-K

Performed Ad Hoc Reporting and Analysis on Financial Management Data and review with Executive Management Team.

Sony Pictures Entertainment 7/ 2015 – 7/2018

Sr. Financial Analyst: IT Finance - Financial Planning and Analysis & Operations

Preparation of operating expense budgets for twenty-five cost centers – Domestic and International (EMEA, Asia Pac, LatAm & Enterprise Infrastructure Service). Prepare budgets; Mid-Range Forecast, Original Budget, and Long-Term Plans (3 Years), year-end forecast and coordinate budget submission and Interface with LOBs.

Prevented and detected errors, irregularities and misstatements of financial results by maintaining proper financial controls.

Prepared monthly Cause of change and variance analysis, analyzed actual vs. budget and year over year performances.

Supervised monthly financial close, including territory recharge and two step entries.

Utilizing SAP, BPC and Ariba to run reports for actuals, commitments, post entries and research.

Provided support for DCIO’s for analysis by providing relevant material variance analysis and explanation on a monthly and quarterly basis.

Took part in stakeholder meetings regarding monthly/quarterly financial analysis (i.e. DCIO’s, CIO and assistant Controller reviews).

Managed shared service analyst in Sony Global Business.

Managed Amazon Web Service Cloud billings enterprise wide.

Reconciliation of statements and make journal entries

Managed prepaid amortization for SAAS & Hardware

Prepared IT labor metrics and utilization reports

Warner Bros. Entertainment Inc., 2004 - 2015

Manager Finance - Financial Planning and Analysis (FP&A) (2014 – 2015)

Managed the preparation of operating expense budgets for over forty-nine cost centers. Took part in stakeholder meetings regarding monthly/quarterly financial analysis (i.e. SVP, CIO and assistant Controller reviews).

Generated and utilized data sourced from various budget tools and systems to assist in creation of the Operating expense plan.

Ensured that all relevant planning assumptions were included in detail, line item planning by

Interfacing with Client Relationship Managers (CRM) and L2s.

Managed tools (Interim and long term) which are used to support planning cycles (i.e. Supporting schedules).

Provided Financial and Management Reporting.

Managed generation of monthly detailed reporting and oversaw/performed variance analysis.

Assisted in setting up the prepaid for IT Finance and managing it

Provided support to consolidation and analysis team by providing relevant material variance analysis and explanation on a monthly and quarterly basis.

Produced timely and accurate product by managing staff and colleagues.

Developed staff for optimum performance (efficiency and effectiveness).

Improved proficiency with financial reports and accountability for financial results by developing staff to provide financial support for internal clients and business partners.

Delivered continuous improvement in Enterprise Financial Services processes and output by

managing direct and indirect resources.

Reduced complexity and increased client understanding of financials.

Expanded transparency of processes, reports and output.

Prevented and detected errors, irregularities and misstatements of financial results by maintaining proper financial controls.

Reduced prior period adjustments due to missed accruals, expense reclassing and other adjustments.

Worked on financial system conversion.

Daniel Stephenson 661-***-**** Page Two

Warner Bros. Entertainment Inc.

Sr. Financial Analyst - IT Finance & General Accounting (2004 – 2014)

Prepared budget, mid-year forecast, year-end forecast and coordinate budget submission. activity with Client Service Representatives and MIS department heads.

Prepared monthly Cause of change and analyze actual vs. budget and year over year performances.

Assisted in preparing Long Term 5-year budget plan.

Consolidated monthly, quarterly and annual financial reports for MIS domestic and international departments with a total budget of $125 million and over 25 cost centers

Developed metrics to determine key financial variances and facilitate analysis at VP level for controllable and non-controllable support (OPEX) and project costs (CAPEX).

Analyzed projects with total capitalization of $25 million.

Assisted in developing and managing complex excel base financial models.

Generated periodic reports of financial results utilizing advanced functions of MS Excel, including vlookup, DSUM, Pivot Tables and MS Access.

Prepared Quarterly Footnotes for capital and operating leases.

Ensured delivery of quality work in compliance with GAAP, Sarbanes-Oxley & Time Warner standards.

EDUCATION

Bachelor of Science (BS), Business Administration. Major: Accounting.

California State University, Los Angeles

TECHNICAL SKILLS

SAP Super User Office 2016

BW PowerPoint

Ariba Word 2016

SharePoint Excel 2016

Outlook 2016 Essbase

PPM (Project and Portfolio Management Visio

Access Cognos

Business Explorer VBA -Excel

BPC HFM Hyperion

VOLUNTEER EXPERIENCE

United Friends of the Children, volunteer team

AFFILIATIONS

Member of Sony Pictures Employee Business Resource Groups (EBRG)



Contact this candidate