Director of Project Controls

JOHN JOHNSON

Portland, OR ***** 503-***-**** ad5t0g@r.postjobfree.com

Professional Summary

FINANCIAL & PLANNING AND ANALYTICS LEADER

Strategic and analytical business partner with 10+ years’ experience delivering financial, operational, technology and strategic solutions. Deep experience in strengthening finance operating models and decision support capabilities, including process cost redesign, performance management, strategic planning, data driven insight, CRM implementation reporting and analytics.

Work History

Director, Project Controls April 2023 – Present

ReconCraft Clackamas, OR

• Led development, and implementation of Project Controls program for $70M in newly awarded Department of Defense (DOD) contracts. Created Earned Value Management (EVM) scorecards that document variances, analyzed cost (CPI) and schedule (SPI) performance.

• Created, defined, and structured revenue recognition plan, challenged, and forecast billing milestones to ensure consistent consolidated revenue recognition and cash. Ensured global view of consolidated project financials and impact of each supplying partner's financial movements.

• Created and gained approval of standard monthly project financial analyses, work in process (WIP) reporting and variance analyses presentations of company income statement (P&L), Balance Sheet, Cash flow and working capital to CFO, Project Finance and G/L Accounting teams.

• Establish standards for collection and creation of estimates at completion (EACs) that ensured estimate to completions (ETCs) were consistently reasonable. Implemented Work Breakdown and Project Coding Structures that ensured data converted correctly from original estimate to the Costpoint Project Control system.

• Developed strong external relationships with DCAA and DCMA and provided continuous communication flows to ensure that direct and indirect cost working assumptions are shared, consistently calculated, and reported in a detailed and timely manner.

Sr Consultant, People Analytics & Workforce Strategy July 2021 – July 2022 Nike World Headquarters Beaverton, OR

• Designed data architecture & automated data pipeline to populate Workforce Planning tools with operational data using Snowflake, and Alteryx, as well as monthly plans feeds to SAP HR and analytical datasets to Tableau dashboards Including Talent pipeline data from data from Taleo, Avature applicant tracking systems (ATS)

• Partnered with Global Business Planning team to create the company's first-ever combined headcount and fully loaded wage base forecast model. Coded the forecast model in Excel using VBA.

• Engaged with HR Customers to deliver reporting & analytics solutions and address data requests; Organized workflows and processes to efficiently address customer requests and track the Workforce planning progress.

• Designed and built automated reporting processes serving the Global Talent Managements Center of Excellence

(COE) using Alteryx and Python, improving the COE's access to prompt data while increasing efficiencies >1 FTE.

• Work leader in standardizing and scaling aggregate Metrics and Common filters across Strategic Workforce planning team. Create process design training documentation to ensure client success post Workday implementation.

Manager, HR Budgets & Workforce Analytics Apr 2019 - Mar 2021 Avangrid Management Company New Haven, CT

• Led, mentored team of 4 talented analysts & intern(s) in development, forecasting and variance analysis of 7,150 staff plan, $1.4B (US GAAP) in personnel expense, $14M HR department OPEX budget, $3M CAPEX plan.

• Partnered with HR leadership, Business Area Leaders to define, create, deploy financial and workforce analytics linking causality of employee lifetime value events, personnel cost performance and staffing plan predictability.

• Built data driven planning models, descriptive and predictive analytical tools that achieved precisions of up 80%. Aligned tactical deliverables to global performance metrics and generated compelling, actionable insights.

• Led process redesigns that reduced by 30% the time to report, efficiently analyze, and present cost & staffing performance to Chief Human Resource Officer (CHRO), Global Human Resources, Operations and Finance.

• Partnered with HR Customers to deliver targeted Attrition Analysis with qualitative insights from employee surveys to measure the impact of corporate initiatives at the senior executive level

• Drove talent acquisition efficiencies by restructuring reporting processes, creating self-service data tools and visual analytics resulting in 15% work time reduction, 40% drop in bad data creation, 10% drop-in Time to Hire. Senior Consultant May 2011 - Apr 2019

Blackrock LLC Portland, OR

• Led financial, strategic, and technology risk initiatives within client organizations on project and interim basis Work with engagement team to identify requirements, design, implement, analytical methods and solutions.

• Collaborated with client analytics teams to automate business processes and direct mail campaigns using Excel, SQL, and VBA, which recovered up to twenty hours of labor each month.

• Drove adoption of consistent financial support and partnered with senior management to provide reports and insights leaders needed to run their business in alignment with guidance set up by National Director.

• Developed, implemented long-term technology investment strategy to streamline analysis pipeline and enable 50% cost savings on flagship analytical service through automation and data modeling.

• Collaborated client Finance & Operations team to drive creation and gain approval of monthly variance analyses of

$335M global internal services budget that establish cost allocations rates for manufacturing divisions. Senior Network Capital Analyst Apr 2010 - Apr 2011 Sprint Bellevue, WA

• Owned financial project lifecycle. Developed project job cost models that defined long-term investment portfolio of

$100M to $400M cell tower construction projects. Performed month-end client budget to actual review

• Tracked project performance, proactively identifying potential cost overruns. Created earned value analysis to prove assets revenue recognition value and timing.

• Collaborated with Legal and Business Development to analyze project contracts, budgets, and vendor proposals. Communicated productivity and performance metrics updates to Marketing and Fixed Asset Accounting (GAAP).

• Tracked and analyzed program health metrics and Key Performance Indicators (KPIs) as well as benchmarking with closely related industry standards. Drove month-end project budget to actual variance analyses.

Education

Master of Science, Business Analytics

University of New Haven, New Haven, CT

Bachelor of Science: Finance

San Francisco State University, San Francisco, CA

Associate of Arts: Business Administration

Monterey Peninsula College, Monterey, CA

Contact this candidate