Associate Story Producer on Pawn Stars for History Channel

Producer on Neighborhood Wars for A&E

- Conduct monthly accrual analysis in Microsoft Excel to determine proper accrual amount for major balance sheet accounts, including marketing ($30M+) and personnel ($2M)- Perform 10+ monthly reconciliations of balance sheet and income statement accounts for corporate accounts- Build process narratives for corporate monthly close procedures to assist in becoming Sarbanes-Oxley compliant- Supervise and mentored staff accountants through tasks such as reconciliations and routine monthly journal entries- Work with IT team to troubleshoot and resolve reporting issues encountered during implementation of Workday

-Perform monthly financial close and consolidation procedures in PeopleSoft for 10+ film markets-Consolidate monthly P&L flash submissions from markets to analyze market trends and provide executive management with consolidated P&L estimates prior to close -Prepare and present monthly presentations regarding budget versus actual film performance to executive management

-Audit financial statements and supporting financial data of film studios such as Fox Studios and Warner Bros. as well as digital content providers such as Hulu to arrive at conclusions regarding company performance-Perform analytical procedures for film and television ultimate models in conjunction with amortization models to validate the company's conclusion-Audit participations (both gross and net participation numbers) as well as residuals to ensure correct accounting treatment of accrued liabilities and expenses is applied-Provide entertainment clients with accounting guidance in relation to film/television costs and capitalization (ASC-920 and ASC-926)-Utilize advanced Excel skills to audit 5000+ lines of client journal entry data exported from Oracle, SAP, and Hyperion for manual journal entries -Develop entry-level staff by guiding staff through audit procedures such as cash, accounts payable, and accounts receivable-Establish and maintain working relationships with client executives, including CFOs, and hold an active role in quarterly, interim and year-end closing meetings with clients-Document walkthrough of the advertising revenue processes of both Hulu and Fox to improve client efficiency and operations by 10% in accordance with Sarbanes-Oxley

-Worked on 15+ valuations of mergers and acquisitions for Fortune 1000 companies-Created valuation templates for the use of senior managers and executives -Utilized weighted average cost of capital calculations for 15+ companies to test for possible Company impairment-Calculated complicated valuation formulas such as the dividend discount model, Graham's formula, and the Fisher effect-Conducted research to determine the effectiveness of the Efficient Market Hypothesis to further improve the Company's valuation techniques-Utilized regression analysis functions of Excel to analyze stock returns of 20+ companies to determine the impact of public information on a Company's stock returns-Worked with the legal department of the firm to analyze contracts to help with client valuations

-Acted as a part of 4+ audits in a variety of industries including automotives, insurance, cellular, and banking-Conducted a financial audit of 10+ cash accounts to ensure financial accuracy-Performed 5+ inquiries with a variety of different client contacts to further understand financial controls of the business-Utilized pivot tables and other advanced Excel skills in order to create 50+ spreadsheets to assist in the overall audit-Analyzed 10+ equity accounts to re-perform company calculations to verify amounts were accurate-Created 20+ fluctuation analysis spreadsheets to flag any account balances that needed further investigation-Implemented new testing system in Excel for expenses to help streamline and test expenses more efficiently -Presented to 15+ employees at the client site to explain key findings from audit investigations-Conducted journal entry testing for 45 accounts in order to investigate potential fraudulent balances-Maintained professional business relationship with client in order to provide effective client service-Performed 10+ financial statement tie-outs in Excel to ensure financial statement accuracy

-Prepared Quarter IV financial statements using Excel for the Media division-Utilized Excel and SAP to create graphs to consistently track 50+ accounts’ and subunits’ earnings -Analyzed sales numbers using CRM software to present on a regular basis to executive members-Projected future earnings based on previous years’ financial statements for the upcoming fiscal year of 2013-Streamlined sales funnel process using CRM software of 400+ accounts to increase consistency and ensure accuracy

-Organized marketing campaigns on campus to increase awareness of Apple products -Led demonstrations of new software at various locations on campus to groups of 30+ people-Generated marketing materials to increase promotion of Apple’s image on campus

-Automated budget variance analysis process for the LM Employee Association to highlight variances for 60+ accounts-Responded to Defense Contract Audit Agency audit requests to reconcile proposed labor costs to actual labor costs-Automated the process for future follow-ups of corrective action plans using Visual Basic to increase accountability-Implemented corrective action follow-up process in all three Lockheed Martin Aeronautics sites-Initiated revising the purchasing card process by creating a keyword filter that would cut time by 2 days per month-Coordinated registration procedures and materials for 50+ attendees at the Corporate Government Finance Conference-Conducted a supplier audit of LM Aero and government property in accordance with government regulations-Performed labor audits of 10+ LM Aero employees to ensure they were charging correct labor hours

-Managed computer support for 50+ employees-Improved and maintained networking stability for 70+ computers-Implemented new SAP software to expedite customer transactions-Streamlined network connections into one patch panel to increase efficiency