- Lead company efforts on data modeling. Assist with weekly/monthly reporting and credit portfolio analysis.

- Build and maintain client data pipelines using Python, Docker, PostgreSQL, and Redshift.- Create generic data integrations for importing data from sources such as Facebook, Amazon S3, S/FTP servers, and other vendors.- Contribute to internal Python SDK used to standardize nodes and data streaming across various data sources.

- Write, maintain, and optimize data warehouse tables and views for business reporting. Consolidate data from more than 10 production SQL databases and third-party sources, for a rapidly growing consumer finance company.- Implemented Looker as a business intelligence reporting solution. Build and maintain weekly/monthly business reporting, summarize and discuss with C-level leadership, and optimize marketing and underwriting strategy accordingly.- Hire and manage a Business Intelligence team to drive reporting and ETL projects to completion, using agile project planning.

-- Conceived of and built website on a Django/PostgreSQL/Heroku platform, did all development work, researched/wrote over 100 articles, and drove to 2,000 daily visitors. (See: https://www.americanhistoryusa.com/) -- Built presidential election game using Javascript/JQuery, receives over 1,000 visits per day and drives signups for premier account system. Modeled 12 scenarios (1844, 1860, ... 2016) based on election returns and historical research. -- Implemented PayPal payments, Google/Facebook based account system, data architecture, unit test suite, Redis caching, SSL, Google AdSense and Analytics, Amazon affiliate setup, A/B conversion tests, and Heroku cloud hosting.

-- Built a lifetime NPV projection tool for a US installment loan product, using R, Python, and PostgreSQL. Modeled predicted default rate by installment to return projected value of each customer. Supported approval/marketing decisions.-- Designed reporting schema for US installment loan product. Created daily ETL process using Python and SQL scripts.-- Implemented approval model using DecisionLogic bank statement data, created credit variables from structured transaction report and unstructured text data, and created ETL process from DecisionLogic API.-- Created variables and credit score from the Chinese national credit report, for a Chinese installment loan product.-- Built and maintained extensive weekly and daily business reporting, using PostgreSQL, Excel, PowerPoint, and Python.

-- Wrote 3-5 queries/week in PostgreSQL, MySQL, and Microsoft SQL Server to respond to ad hoc business needs.-- Created monthly transaction logs and accounts receivable reports for Accounting, from raw transaction database.-- Built Collections call logs from raw transaction database, tracking rep, call time, payment amount, etc. for optimization.

-- Planned and implemented various process and website improvements for UK-based short-term loan product.-- Oversaw implementation of an IVR system, reduced inbound customer service calls by 30 percent.