Gregory Hou Email & Phone Number

Seattle, Wa

- Designed and built Google BigQuery data tables using Python and SQL to track dozens of application metrics for client reporting- Developed and built Oozie workflows on Hadoop that combined customer registrations, medical claims, and historical records for a customer rewards service- Built over a dozen interactive and dynamic Tableau dashboards to visualize and summarize API traffic events for clients- Developed user session tracking logic in BigQuery SQL to replicate user session metrics from Google Analytics- Managed and developed a treatment cost estimator pipeline using R and SQL that modeled and categorized treatment costs from hundreds of millions of medical and pharmacy claims- Updated and maintained several client data tables in Amazon Redshift, such as client-based weighted average treatment costs

Seattle, Wa

Fremont, Ca

- Audits: Participated extensively in IRS audit; compiled over 5 gigabytes of general ledger data from an SAP ERP app, and prepared all requested worksheets to be directly submitted to IRS agent- Financial statements: Verified accuracy and completeness of trial balances for various tax-related receivable, payable, retained earnings, and foreign currency accounts- Financial Reporting: Reconciled numerous balance sheets, income statements, and other tax documents in Excel as part of the reporting process- Tax accounting: Used Excel to calculate over $200,000 of erroneous use tax accruals for state tax deductions- Tax accounting: Prepared and completed numerous tax worksheets in Excel, including net operating loss calculations for over 19 states, and variance analysis for state tax returns using sales data

Master Of Science (Ms), Applied Economics And Finance

- Accounting: Comprehensive asset, liability, and equity accounting methods, including graduate projects - Corporate Tax: Concepts.

Bachelor Of Arts (B.A.), Business Economics

Activities and Societies: Flying Samaritans - Health clinic volunteering in MexicoDean’s Honor List: Spring 2007 – Spring 2008