John D. Kirk

Manager of Planning and Analysis

303-***-**** (Mobile) adjkoh@r.postjobfree.com Littleton, CO

Experience

VSMPO-Tirus, US (World’s Largest Titanium Supplier) Corporate Manager of Analysis and Planning

October 2011 – December 2020 (9 years 2 months) Highlands Ranch, CO

Owned the Financial Planning, Analysis, and Budgeting processes, regularly collaborating on-site with regional sales and operations management teams to prepare accurate quarterly sales and supply forecasts and presentations

Implemented ongoing enhancement of Business Segment and KPI-based presentations through collaboration and requirements gathering among internal and external stakeholders, reducing frequency of ad-hoc requests

Created, maintained, and standardized reports for Finance, Accounting, Sales, and Operations with Hyperion, later designing, validating, enhancing, and automating with SAP Business Objects eliminating need for manual report runs

Forecasted full P&L on monthly basis and managed Transfer Price to consistently achieve target ROS

Conceptualized and created product line/part-level line-of-balance tools for part-level profitability management and inventory optimization, reducing working capital and excess supply by tens of millions of dollars

Assisted with Monthly Close, ad-hoc reporting, trend, and variance analysis for US operations from order to cash

IQNavigator (Software as a Service for Contingent Labor Market) Business Intelligence Analyst

August 2010 - September 2011 (1 year 2 months) Greenwood Village, CO

Revolutionized visualization of client data from data warehouse by creating interactive reports and dashboards using Pentaho BI Stack, FusionCharts, Google APIs, and other 3rd party software, enhancing client value proposition

Created and oversaw development of reporting solutions via Oracle and legacy BI architectures to bolster the standard reporting library

Documented business requirements for development teams with solution tracking in JIRA and SalesForce

Trained and conducted demos to empower and educate end-users of IQNavigator's reporting tools

Gambro Renal Products (Medical Device Manufacturer) Finance Manager - Americas

June 2007 - July 2010 (3 years 2 months) Golden, CO

Led Western Hemisphere Budgeting, Forecasting, Financial Reporting, and Financial Analysis for six North and South American legal entities segmented by product line for Sales, Service, and SG&A units

Consolidated monthly legal entity and business segment financial reporting packages

Completed Monthly corporate-level presentations currency adjusted for currency exchange gain/loss

Supervised and provided guidance to two sales and commission analysts

WhiteWave Foods (Organic Foods)

Senior Financial Analyst

January 2006 - June 2007 (1 year 6 months) Broomfield, CO

Designed and implemented commissions and sales/territory reporting database to unify data from three legacy companies (Horizon, Dean Foods/International Delight, and Silk) and migrate to SAP, resulting in consistent, accurate compensation and reduction in sales administrative headcount requirements

Maintained brand consolidation models for P&L and monthly reporting packages incorporating commentary from each brand analyst and price/volume/mix analysis

Took on preparation of Monthly Sales and Financial KPIs for parent company to free up departmental resources

Education

The University of New Mexico - Robert O. Anderson School of Management Master of Business Administration (M.B.A.), Finance The University of New Mexico

BA, Philosophy, Psychology

Skills

Financial Planning, Financial Analysis, Business Intelligence, Financial Modeling, Budgeting, Forecasting, GAAP, IFRS, Transfer Pricing, Report Automation, Inventory Management, Consolidation, Foreign Currency, Business Objects, expert/developer level Microsoft Excel, VBA, PowerPoint, PL/SQL, MSSQL, MySQL, XML, HTML, PHP, JavaScript

Contact this candidate