John Kyle Hauenstein Email & Phone Number

United States

"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.

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 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.

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.

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

-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.

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 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 concernscoordinated with FP&A to provide explanations for changes in cost centers outside of budgets/forecasts.

Seattle, Washington, United States

Created a tool to reconcile reports generated from Oracle and the Customer Remittance Advice to compareaccuracy of cash application per remittance advice. The tool adjusts the analysis for common internaladjusting entries.Metrics Include:-Able to process at least 15 payments with up to 1,000 invoices per payment (Could be scaled tohandle 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

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 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.

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 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.”

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.

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.

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 monitor/prevent fraudulent activity.

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 resolution of issues arising in course of business.

Master Of Business Administration - Mba, Business Administration And Management, General, 3.46

Bachelor Of Business Administration (Bba), Accounting And Finance, 3.02

Activities and Societies: Beta Alpha Psi