Consolidate and audit client payroll and time keeping records. Standardize data sets for integration based on customized requirements utilizing complex MS Excel logic and macros that enable scalable databases for iterative data set updates. Partner with legal experts to apply quantitative and statistical techniques to efficiently generate insights that assess compliance with exempt/non-exempt employee classification requirements and estimate potential damages in PAGA and Class Action legal… Show more Consolidate and audit client payroll and time keeping records. Standardize data sets for integration based on customized requirements utilizing complex MS Excel logic and macros that enable scalable databases for iterative data set updates. Partner with legal experts to apply quantitative and statistical techniques to efficiently generate insights that assess compliance with exempt/non-exempt employee classification requirements and estimate potential damages in PAGA and Class Action legal matters. Show less

Supply Chain forecasting, Workforce Planning modeling, Overhead and Pool management, Excel-based reporting optimization

Conduct risk assessment of existing Financial Statement MS Excel models and implement recommended enhancements that streamline actuals and forecast loading, reduce risk of model linkages errors and improve forecast accuracy. Design scalable enhancements to models that allow for flexibility to customize and implement future improvements required as changing business dynamics require new analytics.

Consolidated and analyzed financial data in Essbase for Annual Operating Plan and strategic Capital expenses to support the expanding Broadcast organization. Assisted in the analysis and consolidation of key assumptions to develop strategic business cases for future investment. Acted as strategic partner to collaborate cross-functionally with Broadcast, Events, IT, Facilities and Security organizations to ensure alignment between cost assumptions.

Financial Planning & Analysis:Responsible for consolidating business segments and analyzing Volume, Price, Revenue, Gross Margin and Overhead financial metrics for 5-Year Long Range Planning, Annual Operating Planning and quarterly short-term risk & opportunity reporting for a $13B+ annual revenue business segment. Focus on financial reporting process gaps and developing new reporting tools to enable more efficient and accurate reporting to senior leadership.

Financial Planning & Analysis:Responsible for consolidating business segments and analyzing Bookings, Sales, Profit, Cash, Working Capital and Overhead financial metrics for 5-Year Long Range Planning, Annual Operating Planning and quarterly short-term risk & opportunity reporting for a $1B+ annual revenue business segment. Partnered closely with Supply Chain and Engineering functions to manage key operational assumptions critical to the financial forecast. Collaborated cross-functionally… Show more Financial Planning & Analysis:Responsible for consolidating business segments and analyzing Bookings, Sales, Profit, Cash, Working Capital and Overhead financial metrics for 5-Year Long Range Planning, Annual Operating Planning and quarterly short-term risk & opportunity reporting for a $1B+ annual revenue business segment. Partnered closely with Supply Chain and Engineering functions to manage key operational assumptions critical to the financial forecast. Collaborated cross-functionally with Business Development and Engineering functions to model strategic business cases that documented assumptions pertaining to Capital, R&D and Income. Oversaw execution R&D budget by providing finance support to Program Managers to ensure achievement of scope within funding allocations and timelines.Operations Finance:Evaluated Material Resource Planning (MRP) demand and production trends to conduct cost volume and margin analyses that support revenue forecasts. Collaborated with Factory Finance counterparts to assess and challenge production assumptions related to headcount, Hours Per Unit (HPU), rework reduction initiatives and supplier combined orders. Developed process to standardize and streamline factory financial forecasting that led cross-functional team members toward common finance goals by ensuring transparency and setting clear time-phased priorities to achieve meeting financial commitments. Show less

Program Finance:Utilized Earned Value Management (EVM) analysis and reporting to support multiple technical leads to successfully execute the program baseline and generate variance analysis & predictive metrics to satisfy both leadership and customer requirements. Collaborated with Program Management, Control Account Managers (CAM) and Schedulers to process and optimize baseline changes to program execution. Responsible for actively identifying program risks and opportunities that effect… Show more Program Finance:Utilized Earned Value Management (EVM) analysis and reporting to support multiple technical leads to successfully execute the program baseline and generate variance analysis & predictive metrics to satisfy both leadership and customer requirements. Collaborated with Program Management, Control Account Managers (CAM) and Schedulers to process and optimize baseline changes to program execution. Responsible for actively identifying program risks and opportunities that effect cost and schedule and supporting plans for mitigation. Show less

Underwriting:Supported due diligence process during evaluation of prospective acquisitions by collecting and interpreting asset and market information to underwrite and extrapolate market value and create investment pro forma offering materials. Participated in negotiation and procurement of appropriate financing to maximize the benefit of loan terms for acquisition.Asset Management:Monitored the performance of third-party asset managers to verify the fulfillment of contractual… Show more Underwriting:Supported due diligence process during evaluation of prospective acquisitions by collecting and interpreting asset and market information to underwrite and extrapolate market value and create investment pro forma offering materials. Participated in negotiation and procurement of appropriate financing to maximize the benefit of loan terms for acquisition.Asset Management:Monitored the performance of third-party asset managers to verify the fulfillment of contractual obligations to investors. Implemented budgetary and occupancy strategies which maximized the performance and profitability of company portfolio. Responsible for compliance with lease contract obligations, maintenance and repositioning strategy, including oversight of income and expense related to occupancy, renovations and valuation for targeted disposition. Show less

Research and Reporting:Performed research and summarization of technical analysis for Environmental Impact Reports (EIR) and Mitigated Negative Declarations (MND) and assisted in drafting of Request for Proposals (RFP) for marketing purposes to increase company pipeline / backlog. Interacted with public agencies, private developers, sub-consultants and the public to advance projects through the entitlement process. Developed management plan and mitigation program to address project impacts… Show more Research and Reporting:Performed research and summarization of technical analysis for Environmental Impact Reports (EIR) and Mitigated Negative Declarations (MND) and assisted in drafting of Request for Proposals (RFP) for marketing purposes to increase company pipeline / backlog. Interacted with public agencies, private developers, sub-consultants and the public to advance projects through the entitlement process. Developed management plan and mitigation program to address project impacts during construction. Show less