John Van De Pol Email & Phone Number

Spring, Tx, Us

Houston, Texas, United States

Currently Seeking a new role in FP&A. Experience in:BUDGET, MONTHLY REPORTING, DATA INTELLIGENCE, AND ANALYTICS SPECIALIST - Extensive hands-on experience working with both too little and with too much data to create actionable intelligence in support of current decision making and forward planning, spanning Financial Services and Manufacturing in PowerGen and Oil & Gas industries.SKILLS AND EXPERIENCE MOST RELEVANT TO APPLICATION Complex, dynamic, 3-statement Excel business models Excel Model and Workbook Auditing and Error Correction  Budget Production & Financials, Variance YTD Actuals with Rolling Forecast Deal analysis for new business, acquisitions, divestitures  True cost and margin versus Standard Data Lake reduction to actionable information – Big Data  Business Intelligence - Data Analytics 80/20 Analysis - client and product mix optimization  SAS/JCL, R, SQL Server Management Studio Developer Level Excel, DAX, Advanced Access, BI, KPIs  International Operations & Private Equity Native level English, Dutch; intermediate German, French Financial Statistics – Power Pivot presentation Treasury, Cash Flow, debt covenant adherence monitoring  POC accounting and methods QAD Root Data retrieval / Analysis Consolidation and De-consolidation

Kingwood, Tx

 Complex 3-statement planning model resuscitation and redevelopment (Excel 50+ tabs) for 4-Channel Loan and Lease portfolio with differing risk and attrition attributes, portfolio securitization, syndication, and bulk acquisitions. Created 4-business channel consolidations. Consolidated 4-business channel Budget, Quarterly and Monthly rolling forecasts with actuals integration.  Revamped monthly detailed Portfolio Analysis (70,000+ contracts) over 17 data dimensions, enhancing presentation, reducing preparation time by 80%, and greatly speeding up file responsiveness.  Multi-scenario valuation modeling to evaluate parent company exit strategies Various portfolio segment deep dive analyses to review true performance Renewal payment projections in 30,000-contract portfolio with differing, terms, seasoning, and risk patterns Assembling of detailed “data tapes” for Transaction Due Diligence of potential company acquisition

Houston, Texas Area

- Start-up private cosmetic business focused on client base challenged with chemical sensitivities. Developed organic product line. Set up and run production, manage inventories and supply chain. - Business plan development with detail supported 3-statement financial models, business loan - Entity loan restructuring, - Accounting infrastructure setup.

Houston, Tx, Boston, Ma

Achieved key process improvements at multiple business units and client accounts for this global manufacturing leader, enhanced efficiency and improved bottom line results. Restructured ineffective business units, strengthened client relationships, and crafted business plans to accelerate growth and productivity. Analyzed work systems and processes to streamline operations, capture savings, improve client service, and bolster profit margins. Successes include:* Drove global turnaround on a $50M engagement with a Fortune 100 Power Gen corporation and prevented customer exit* Resolved schedule conflicts across 3 supply factories, taking on-time deliveries from 40% to 98%.* Identified $30M of trapped cash in AR and guided effort to secure its release* Improved daily factory throughput up to 40%.* Designed and created executive Quarterly Operations Reviews. Combined key financial and operational performance overviews with custom KPIs into homogenized presentations for 12 global entities.* Improved daily factory throughput up to 40%.* Developed new $1.5M European account in PowerGen business segment.

Houston, Texas Area

* Created and delivered premium fulfillment, ultra-high margin sales channel by re-purposing out of spec production units. Realized $3M in first-year revenues, significantly exceeding sales and margin expectations.* Supported and enhanced international accounts in the aerospace and industrial gas turbine markets, successfully presenting strengths and value propositions for this global forging supplier.* Designed and implemented new Quote system that improved margins and win rates, while reducing quote response time by 90%.

Houston, Texas Area

* Developed business plan and investor presentation for the launch of a $150M Middle East manufacturing company. * Built 3-statement dynamic model for the 5-year strategic plan for a $10M division of an offshore Telecom company.* Helped secure $5M in venture capital for an oil field startup.

Houston, Tx - London, England

* Maintained price levels of project bids and 90,000 catalog items to maximize margins and minimize skewed demand between 15 manufacturing plants across 12 currencies.* Designed, developed, and implemented budget system from a zero base. Trained and supported users to address expanded requirements of $900M global revenue and expense budgets. Project scope was 40 management locations with 15 manufacturing plants in 25 international locations.* Created business plan for new concept, supplier managed maintenance contract for $70M strategic client in Nigeria. Successfully tendered and secured the $50M pilot contract.

Bachelor'S Degree, Finance, General

Master'S Degree (Mba), Finance And International Business Administration

Bachelor'S Degree, International Business Administration