John Kyle Hauenstein

CFO of Consensus Protocol at Consensus Protocol
  • Claim this Profile
Contact Information
Location
Bonita Springs, Florida, United States, US

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
You need to have a working account to view this content.

Experience

    • United States
    • Blockchain Services
    • 1 - 100 Employee
    • CFO of Consensus Protocol
      • May 2021 - Present

      United States

    • United States
    • Staffing and Recruiting
    • 700 & Above Employee
    • Consultant
      • Aug 2019 - Present

      "Experienced CPA Accountant | Robert Half Contractor | Amazon, Zillow, Turnitin Alumni 📊 Bringing a wealth of expertise as a Certified Public Accountant, I've honed my skills through successful contract engagements with prestigious companies such as Amazon, Zillow, and Turnitin. My track record at Robert Half showcases my ability to deliver top-tier financial services, driving efficiency and accuracy across diverse industries. 🔹 As a seasoned CPA, I've navigated complex… Show more "Experienced CPA Accountant | Robert Half Contractor | Amazon, Zillow, Turnitin Alumni 📊 Bringing a wealth of expertise as a Certified Public Accountant, I've honed my skills through successful contract engagements with prestigious companies such as Amazon, Zillow, and Turnitin. My track record at Robert Half showcases my ability to deliver top-tier financial services, driving efficiency and accuracy across diverse industries. 🔹 As a seasoned CPA, I've navigated complex financial landscapes, leveraging my comprehensive understanding of regulations and best practices to ensure compliance and financial clarity. 🔹 My tenure with Robert Half allowed me to work on critical projects with industry giants like Amazon, pioneering solutions that enhanced financial reporting, analysis, and strategy. 🔹 During my tenure at Zillow, I contributed to shaping financial frameworks that fueled data-driven decisions and strategic growth, playing a pivotal role in the company's success. 🔹 At Turnitin, I applied my accounting acumen to optimize financial processes, aligning the company's financial health with its mission of academic integrity. 🔹 My achievements are underscored by a collaborative approach, adeptness in financial software, and a knack for converting complex data into actionable insights. Whether it's fostering fiscal transparency, facilitating strategic decision-making, or optimizing financial processes, my journey as a CPA accountant continues to make a lasting impact. Show less

    • United States
    • Travel Arrangements
    • 700 & Above Employee
    • Consultant
      • Sep 2022 - Dec 2022

      Remote **Process Automation Expert | Financial Systems Enhancement** I specialize in optimizing financial processes to deliver efficiency gains. Some of my accomplishments: **In-Transit Receivables Enhancement:** - Devised a seamless "one-click" consolidation process for data from 21 files across 4 sources, covering 6 currencies and 100K+ rows. - Enabled precise In-Transit Receivables Journal Entries during month-end, with enhanced clarity. - Reduced processing time from 4 hours… Show more **Process Automation Expert | Financial Systems Enhancement** I specialize in optimizing financial processes to deliver efficiency gains. Some of my accomplishments: **In-Transit Receivables Enhancement:** - Devised a seamless "one-click" consolidation process for data from 21 files across 4 sources, covering 6 currencies and 100K+ rows. - Enabled precise In-Transit Receivables Journal Entries during month-end, with enhanced clarity. - Reduced processing time from 4 hours to 20 minutes, primarily for report retrieval. **Prepaid Account Transformation:** - Streamlined Prepaid Account historical process, cutting file size and complexity. - Introduced historical research view, simplified business logic, and granular expense insight. - Redesigned credit card rate calculation, now a 5-minute one-click process. **Voyage Closing Automation:** - Orchestrated automated voyage finalization validation, referencing 3 PeopleSoft/NVS entries. **AR and AP Journal Entry Automation:** - Engineered an automated system for Account Receivable and Payable Journal Entries. - Established baseline template for expedited account reconciliation. **Monthly Analysis Enhancement:** - Improved business logic, converted Excel to Power BI for advanced reporting. **Commissions Bank Reconciliation:** - Automated commission-based bank reconciliation with a streamlined template. Show less

    • United States
    • Software Development
    • 700 & Above Employee
    • Senior Accountant
      • Jun 2021 - Sep 2022

      Remote -Lead Consultant for data translation to new ERP System. -Supervised Staff Accountants. -Developed reconciliations and associated reports. -Optimized processes increasing turnaround time for deliverables. -Provided Audit support for the year with merger with new parent company.

    • Mexico
    • Airlines and Aviation
    • 1 - 100 Employee
    • Senior Business Analyst
      • Feb 2021 - Mar 2021

      Created invoice tool to handle 10 unique contracts and allow for additional clients: -Improved accuracy of calculation of invoice, preventing consistent re-working of invoice process -Tool handles 2.4M rows of data for historical analysis spanning 6 months. -Reduction of preparation time from 80 hours to 2 hours. -Tool has multi-currency functionality. -Monthly dollar amount of all clients: 625K$ -Invoices contained a 4-level hierarchy of various charge options

    • United States
    • Financial Services
    • 700 & Above Employee
    • Senior Business Analyst
      • Oct 2020 - Jan 2021

      -Created multiple data models in SQL that reconcile over 80% of existing items valued over $1M. Analyzed patterns in unreconciled transactions to identify common events and assign a flag to help future reconciliation. -Identified errors in internal processors continuously generating reconciling errors and made recommendations for resolution. -Validated data integrity for international banks for 3 years of data.

    • Banking
    • Senior Accountant
      • Jan 2020 - Sep 2020

      Greater Seattle Area -Reconciled travel credit card account with 78 different card numbers with total monthly transaction amount over 1M$ and volume of 7K transactions. -Reconciled procurement credit card account with 86 different card numbers with total monthly transaction amount over 1M$ and volume of 7K transactions. -Created tool to reconcile said credit card account reducing reconciliation time from 2 days to 30 minutes. prepared accrual entries for credit card accounts for over 1,000 items totaling… Show more -Reconciled travel credit card account with 78 different card numbers with total monthly transaction amount over 1M$ and volume of 7K transactions. -Reconciled procurement credit card account with 86 different card numbers with total monthly transaction amount over 1M$ and volume of 7K transactions. -Created tool to reconcile said credit card account reducing reconciliation time from 2 days to 30 minutes. prepared accrual entries for credit card accounts for over 1,000 items totaling over 1M$ on a monthly basis -Reviewed and approved prepaid amortization schedules of around 50 invoices with the median amount of 53K$, average amount of 107K$, Min of 15K, max of 2M$ performed monthly analysis of the account fluctuations to help directors recognize potential concerns coordinated with FP&A to provide explanations for changes in cost centers outside of budgets/forecasts. Show less

    • United States
    • IT Services and IT Consulting
    • 700 & Above Employee
    • Senior Accountant
      • Aug 2019 - Dec 2019

      Seattle, Washington, United States Created a tool to reconcile reports generated from Oracle and the Customer Remittance Advice to compare accuracy of cash application per remittance advice. The tool adjusts the analysis for common internal adjusting entries. Metrics Include: -Able to process at least 15 payments with up to 1,000 invoices per payment (Could be scaled to handle larger volume if required) -Reduced average reconciliation time from 5 days to 1 day per reconciliation -Average payment size $36K… Show more Created a tool to reconcile reports generated from Oracle and the Customer Remittance Advice to compare accuracy of cash application per remittance advice. The tool adjusts the analysis for common internal adjusting entries. Metrics Include: -Able to process at least 15 payments with up to 1,000 invoices per payment (Could be scaled to handle larger volume if required) -Reduced average reconciliation time from 5 days to 1 day per reconciliation -Average payment size $36K, Min $0.25, Max $1.8M -Tool rolled out to 4 international branches and utilized by 50 analysts -Identified $8.6 million of unapplied cash of outstanding -Simple interface Show less

    • Senior Revenue Accountant
      • Sep 2018 - Jul 2019

      Greater Seattle Area -Manage $5MM+ in monthly payments to 60+ partners; correspond with 35 clients across 25 countries to validate/synchronize subscriber data for proper servicing and billing. -Automated full cycle revenue and COGS procedures, reducing process time from 25 to 4 business days. -Employed innovative accounts payable aging report to lessen manager approval processing time by 10 business days. -Developed new accrual process, slashing variance from actuals by 25%; reconciled differences from… Show more -Manage $5MM+ in monthly payments to 60+ partners; correspond with 35 clients across 25 countries to validate/synchronize subscriber data for proper servicing and billing. -Automated full cycle revenue and COGS procedures, reducing process time from 25 to 4 business days. -Employed innovative accounts payable aging report to lessen manager approval processing time by 10 business days. -Developed new accrual process, slashing variance from actuals by 25%; reconciled differences from external parties to eliminate 30% of costs. -Coordinated with Business Intelligence Team to streamline data feeds and reduce errors; new processes cut 100+ vendor invoice reviews saving 5 hours monthly. -Generated a report increasing the granularity of COGS analysis to label, country, partner, and product tiers across multiple periods. -Examine trends in revenue amounts/subscriber counts and review market share of labels to evaluate root causes between KPIs. Show less

    • Senior Accountant
      • Feb 2017 - Aug 2018

      Miami/Fort Lauderdale Area -Analyzed $60MM in monthly revenue and $15MM in monthly expenses against forecasts to explain deviations from expectations. -Automated 20 financial statements and reports for CEOs and presidents across 2 companies, saving 30 hours of cycle time and input error. -Created data models in Excel containing 1,000+ cells/formulas for multi-period and multi-market analysis. -Researched international event impacts on financial statements for 16 global market regions to inform strategic… Show more -Analyzed $60MM in monthly revenue and $15MM in monthly expenses against forecasts to explain deviations from expectations. -Automated 20 financial statements and reports for CEOs and presidents across 2 companies, saving 30 hours of cycle time and input error. -Created data models in Excel containing 1,000+ cells/formulas for multi-period and multi-market analysis. -Researched international event impacts on financial statements for 16 global market regions to inform strategic direction; presented findings to 5 brand presidents and 10+ attendees. -Reviewed 7 weekly reconciliations and 11 processes for accuracy and completeness. -Produced ad-hoc analysis streams for the Director of Revenue Accounting. -Collaborated with external auditors to document/explain accounts and receive an “Unqualified Opinion.” Show less

    • United States
    • Staff Accountant
      • Mar 2016 - Aug 2016

      Doral, FL -Formulated operational analyses to calculate stress points and equipment demand for 20,000+ person events; implemented financial transaction cash control on event days. -Performed geospatial analysis, evaluating the impact of range on attendance. -Developed fixed/prepaid asset registers to consolidate month-end journal entries from 9 to 2. -Audited $20K monthly expense account spanning 30 people to ensure compliance and documentation; prepared and presented financial statements to CEO.

    • United Kingdom
    • Insurance
    • Staff Accountant - Contractor
      • Sep 2015 - Mar 2016

      Miami/Fort Lauderdale Area -Reconciled $10MM in escrow accounts across 3 check-processing systems; created and improved reconciliation processes for existing accounts. -Provided weekly reports to executives on special project integrating existing reconciliation process with Blackline.

    • Ireland
    • Security and Investigations
    • 700 & Above Employee
    • Staff Accountant
      • Apr 2014 - Sep 2015

      Boca Raton, FL -Prepared, maintained, and analyzed $40MM in monthly cash flow. -Composed journal entries to import financial balances of subsidiary ERP to main ERP. -Generated month-end closing journal entries, reconciling $40MM in domestic and foreign cash accounts between 3 reporting systems. -Teamed with Tax and Payables Departments on unclaimed property due diligence, filings, and account reconciliations. -Developed reconciliation processes for accounts previously unreconciled to… Show more -Prepared, maintained, and analyzed $40MM in monthly cash flow. -Composed journal entries to import financial balances of subsidiary ERP to main ERP. -Generated month-end closing journal entries, reconciling $40MM in domestic and foreign cash accounts between 3 reporting systems. -Teamed with Tax and Payables Departments on unclaimed property due diligence, filings, and account reconciliations. -Developed reconciliation processes for accounts previously unreconciled to monitor/prevent fraudulent activity. Show less

    • United States
    • Government Administration
    • 700 & Above Employee
    • Intern
      • Nov 2012 - Mar 2014

      Miami/Fort Lauderdale Area -Ensured cash flow synchronization between the general operating and special services account by monitoring stop payments, cancelled checks, and maintaining appropriate funding for special services. -Reconciled the general operating account with 3,500 transactions valued at over $3.5 billion, the voucher account, and 3 special revenue accounts. -Standardized business processes through writing user training manuals for the entire division, providing a documented structure for uniform… Show more -Ensured cash flow synchronization between the general operating and special services account by monitoring stop payments, cancelled checks, and maintaining appropriate funding for special services. -Reconciled the general operating account with 3,500 transactions valued at over $3.5 billion, the voucher account, and 3 special revenue accounts. -Standardized business processes through writing user training manuals for the entire division, providing a documented structure for uniform resolution of issues arising in course of business. Show less

Education

  • Florida Atlantic University - College of Business
    Master of Business Administration - MBA, Business Administration and Management, General
    2014 - 2015
  • Florida International University
    Bachelor of Business Administration (BBA), Accounting and Finance
    2007 - 2013

Community

You need to have a working account to view this content. Click here to join now