John Bongen Email & Phone Number

Louisville, KY, US

Frankfort, Kentucky, United States

Louisville, Kentucky Area

Louisville, KY

• Developed the 5 year long range planning model by legal entity used for parent cash flow, capital budgeting decisions, and segment performance measuremento Formalized the process to streamline receiving inputs from.
• Built an enterprise operating pre-to-post allocated admin expense dashboard o Reporting suited facilitated better discussions between profit and cost centerso Designed relational database to allow for greater details.

Menlo Park, California

• Financial Modeling Product Owner for the Biz Apps information technology departmento Improved the corporate model to be more driver based to allow their FP&A teams allowing for better sensitivity analysis, scenario.
• Business subject matter expert supporting the Business Intelligence teamo Automated International Opex Dashboard and related slides in the BOD deck using Tableauo Converted manual excel reports into Tableau automating.

Louisville, Kentucky Area

Improved process to allocate balance sheet data correctly to the lines of business using relational databases. Allow for a more accurate ROIC calculation, standardization in applying business logic, created verifiable results, and quicker turn around for each new run of the allocation process.Generated ROIC reports by lines of business for efficient.

Louisville, KY

• Team member of Regulatory Financial Reporting Project Team tasked with helping the department achieve maximum efficiencyo Assisted in management of large scale initiatives, coordinating with multiple business and IT.
• Prototyped natural expense allocation methodology for G&A expenseso Developed a SQL application prototype and managed the project to get it fully productionalized in Oracle DBo Shining Star reward received.
• Established the Valid SKEY dataset used finance wide as way to validate the combination of Product/Company/Market
• Developed financial models using BI tools like Qlikview and Tableau.o Published Enterprise level reports creating synergies across the entire finance organizationo Overhauled Incurred Financial Model to Filing report.

Louisville, KY

• Acted as liaison between business and IT, ensured the financials systems met needs of the Finance Departmento Facilitated meetings across a large matrix style organization, managed the issue log and prioritization of.
• Developed an Excel application to process/validate/approve journal entries into Financial System. o Over 12,000 entries have been processed, totaling over 100M records over the last 3 years of use. o Tightly controlled.
• Refactored the IFM Tool, Financial Operation’s main incurred expense model (VBA Excel Front end), improving the timeliness of seasonality calculations and enhancing incurred expense estimation accuracy.
• Developed financial models using BI tools, Qlikview and Tableau, allowing for drill down into granularities of data previously not possible.
• Integrated newly acquired Medicare acquisition’s underwriting data into the EDW

Louisville, KY

• One of three managing partners for a small start-up companyo Created the business plan, financial projections and models, and potential investor presentationso Pitched to angel investors and potential customerso Met.
• Full stack developer of the web producto Utilized LAMP web development platform for back end processes and created full AJAX front end solution using JQuery.o Ensured strong OOP patterns and utilized MVC architecture.
• Generated $20,000 of investment from angel investors and $75,000 Kentucky enterprise fund grant received
• Employed a lean start up mentality to determine prioritization of feature implementation and product management

GL uploads and analysis for corporate cash, debt interest accruals, and other treasury-related entriesSupport timely forecasting, determining, and reporting of daily cash positionReconciliation of $90 million in tenant escrow accounts and reports to internal Asset Managers and external tenants.Development of a Visual Basic macro in Excel to convert bank.

Reconciliation of bank statements and adjustment of interest accruals.Accounts Payable support, processing of invoices, and printing of checks. General ledger software maintenance including standardization of chart of accounts, environment setup.Accounting projects as designated.

Mba, Mba

B.S., Accounting