Ian Hancock Email & Phone Number

Manchester, Nh, Us

Manchester, Nh, Us

Us

Durham, New Hampshire, Us

Falls Church, Virginia, Us

• Manage a team of three financial analysts • In partnership with business leadership, forecasted 5-year business outlook • Trained analysts in Hyperion Planning and Oracle ERP • Perform ad hoc analysis and special projects as requested • Developed financial models to price commercial catalog of products

Falls Church, Virginia, Us

· Consolidated historical & trend analysis on enterprise portfolio; tracking earned value, cost, &margin performance on $4b annual sales· Transitioned reporting towards on-line Power BI dashboards drawing directly from systems,retiring manual Excel based reporting, cutting report production time by >75%· Collapsed processes & points of data entry into single sources of truth, clearing nuance fromsimilar reports and eliminating duplicate entries for over a hundred analysts· Took part in interview/selection process for incoming Financial Leadership DevelopmentProgram (FLDP) participants

Falls Church, Virginia, Us

· Participated in probabilistic scenario-based risk assessments on $80m+ to establish a range of outcomes for management· Led and collaborated on a number of process improvements and tool developments, utilizing outside tools and Power BI·Directed the FLDP Recruitment Committee of 5 people, organizing logistically complex events,providing vision and strategy for how we best partner with schools and bring in talent

Falls Church, Virginia, Us

· Established Hyperion account structure compliant to IFRS 15, a complex shift in revenue recognition for BAE Systems· Sole analyst managing $44m of R&D and Proposal efforts; working closely with program managersand business development to best execute internal and external customer· Pioneered training and forecasting effort associated with the integration of $100m business unit· Updated the IBP forecasting process with specific focus on eliminating single points of failure

Falls Church, Virginia, Us

· Responsible for salient forecasting to support the sector Integrated Business Plan· Executed baseline review & control for a $137M externally reported development program; including Integrated Baseline Review with customer, Air Force, and Defense Contract Management Agency (DCMA)· Supported Joint Surveillance Reviews with DCMA; no findings and served as the basis for DCMA’s reaffirmation of Nashua’s Earned Value Management System· Led effort to streamline on-boarding training, designing system to shorten the learning curve and increase autonomy of new hires

Waco, Tx, Us

· Worked within information management systems developed in the 1990’s providing Excel based data mining techniques with modern fidelity standards· Automated the incentive allocation process · Provided customer service, resolving customer complaints and sales person incentive questions

London, Gb

· Streamlined direct material forecast reporting using VBA· Developed Excel based tool to consolidate one-liners and track margin and margin projections over time· Verified and compiled history in support of a $68M proposal· Lead intern project, compiling a mock proposal and request for bid approval package, performing detailed cash flow and NPV analysis

Houston, Tx, Us