Building Web3 DeFi application

Designed-to-Shipped all data requirements, and ETL infrastructure pipelines from scratch for a new 3rd-party checkout module traffic tracker, as a DS experiment platform for any upstream feature/ design changes:- Validated conversion uplifts quantitatively between treatment and control group by releasing fingerprinting JS lib to identify users indirectly yet effectively.- Resolved early stage inflow traffic ETL bottleneck (multi-million entries daily during invite-only pilot release) collaboratively with PM and engineer team through schema optimization.- Iterated agilely to balance evolving business requirements and technical stakeholders timeline, communicated and pivoted on success.Integrated BNPL (Afterpay) product into Square checkout ecosystem following the acquisition in 2021:- Sized and formulated strategies with GTM team for product launch and merchants migration, sifting through databases with ML modeling (RF) to lock on opportunities with highest ROI/ impact.- Created alerting algorithm for high value sellers’ migration funnel analysis and new features adoption, and performed RCA to explain possible cannibalization between products.- Collaborated with Operations team to locate and follow up on slow movers and experimented with incentives to boost conversion of integration funnel. - Liaised between Square and Afterpay DS team as data steward & custodian to maintain integrity, control and dictionaries of data structure and released protocols to resolve discrepancies and delays to ensure low latency and low error on data flow.(continued below in Afterpay section)

Initiated and owned projects to boost efficiencies and reduce costs across internal and external workflows:- Identified common patterns on API failure with Shopify, the eComm giant, the subsequent reimplementation increased the success rate by ~60% and recovered millions $ GMV.- Distilled insights for leadership around laggers/ weak points on external partnerships with Stripe, Adyen and other enterprise merchants for summit meetings, resulting in mutual performance boost.- Created ML algorithm to automate classifications of checkout attributions, retrieving critical information on platforms and channels for business and regulatory reporting needs. Moving away from the manual process saved huge resources cross-functionally and became future-proof with minimal maintenance. - Categorized help-ticket escalations for engineering to improve runbook documentations and freed-up valuable dev time from addressing Zendesk by ~80%.Pioneered building of the North America Merchant DS team as the 1st hire, grew the team to 10+ DS and influenced team culture:- Deployed OpenAI chatbot trained with Confluence resources and Google Cloud documentations for team knowledge transfer as well as new hire onboard rampings, benefiting especially when SMEs worked across time zones (HQ located in Australia).- Authored team SOP and SLA working with sales, business, finance, engineering stakeholders.- Standardized schema protocol for seamless referencing and maintained database/ tech stack hygiene.

Payment System Interfaces team builds products, manages projects and operates to maintain overall health and stability of the financial data that moves funds into, around, and out of Stripe. In this role, I:- Identified and codified automation snippets in Ruby for inefficient manual processes to ensure financial infrastructure stability and data availability above 99.9999%. Freed up computation and engineering resources on subsequent reporting cycles by 50%+.- Operated and collaborated across the company, including engineering, accounting, financial partnerships, treasury and product teams, to trace and reconcile for billions of USD equivalent moving through Stripe's platform daily.- Designed checkers to boost observability by 10%+ and detected anomalies in time to avoid incidents. Utilized feedback and pivoted on patterns discovered to iterate product optimization.- Served as subject matter expert. Unblocked technical challenges and resolved inquiry tickets for internal/ external financial partners to drive alignment on product usage and SLA.- Managed projects with engineers to implement and roll out complex technical overhauls to reflect updated accounting treatments. Liaised across financial and engineering orgs.- Cross-trained and spun up teammates. Supported on domain knowledge and analytics projects.

- Wrangled, munged and de-duped web metrics data from Google Analytics and S3 in R. Configured A/B tests, discovered causality and formulated statistical impact of feature launches on SEO growth for product managers using hypothesis testing, OLS regression prediction techniques.- Guided 10+ product managers to define quarterly KPIs and hosted Tableau office hours. Published and maintained custom HTML-based BI dashboards to monitor, flag and alert for abnormal traffic/ lead volume fluctuations, and supported agile product development using DS experiments and hypothesis testings. - Conducted funnel analysis throughout brand website transitions for unexpected/ unwanted performance beyond pre-set thresholds. Discovered the root-cause and recommended actions for product and engineering stakeholders to mitigate anomalies, ensuring smooth transitions.- Orchestrated ETL DAG from Google AdWords and Bing Ads to OracleDB with engineers. Automated $600k+ SEM monthly expense reports(.xls) in Python and increased lead quality for digital marketers.- Onboarded and mentored 4 interns, providing domain knowledge and guided on analytics projects.

- Wrote up bi-weekly A/R-aging analytics dashboard, forecasted cash-flow and presented BI visualization for executives.- Automated data push from Oracle and Salesforce to inhouse server and developed VBA scripts to shorten SEC report preparation time by 70%+.- Constructed and converted existing Excel data tables into MySQL database with Operations and Marketing team to streamline sales management, and provided maintenance

- Designed surveys and conducted marketing research experiments to identify potential business opportunities using demographic Big Data and SQL for sales team- Tested statistical hypotheses and visualized insights in Tableau dashboards, empowering management to make data-driven decisions for new market entry- Employed Google AdWords, Google Analytics and Google Trends to monitor business performance and investigated Key Performance Indicators with director of growth in BI reports to improve web traffic conversions

Graduate Student Instructor for Undergraduate Course Economics 136Introduction to Financial Economics (Aug 2012 - Dec 2013, Aug 2014 - Dec 2014)Graduate Student Instructor for Undergraduate Course Economics 138Financial and Behavioral Economics (Jan 2014 - May 2014)- Designed and taught lecture sessions for 60 students on derivatives, bonds and capital markets, and provided one-on-one tutoring and Q&A sessions towards students in need - Constructed investment portfolios for various risk exposure levels with Excel using real time Bloomberg and Yahoo Finance data and performed time-value calculations for equities- Facilitated learning through weekly summit with course professor to understand class’s feedbacks with aid of homework assignment tailored by all teaching staff

- Contributed in treatment identifications and questionnaire design in field experiment conducted at Chicago metropolitan area aiming to measure utility in pride signaling and guilt aversion- Built panel structure with thousands of household experiment subjects, summarized the database using plots and histograms, visualized results for descriptive analysis in Stata and built regression model and power testings to identify and isolate suspected background noises- Utilized calibrated coefficients on counterfactual analysis to justify social welfare under alternate policy regimes- Collaborated in primary stage of research question specification to measure racial discrimination and bias around 2008 presidential election as natural experiment - Research and categorized literatures from top Economic journals from 1975-2010 according to models/ data involvement to classify and study the role of theory in field experiments

- Improved arithmetic efficiency of core algorithm that estimated the risk of forced labor and child labor in supply chains of businesses by developing formulae-linked Excel template archives- Identified relevant policy reports from UN, IMF, World Bank, and other global institutions to expand and ultimately doubled the scope of input variables- Translated reported measurements into model parameters and reoptimized weight coefficients using Stata statistical inference techniques to increase model fit accuracy exponentially and provided cross-validation to avoid overfitting- Collaborated closely with lead full-stack engineer to build data architecture, release model algorithm into production, and design user interface to visualize model predictions in .js graphics and diagrams- Prepared weekly report for COO and Director on model and interface development progress and preliminary feedbacks from pilot users

- Performed Interim Financial Statement Audit for publicly held companies Van Shung Chong Holdings Ltd (1001.HK) - Conducted testing and reconciliation of various Balance Sheet and Income Statement accounts including Equity, Revenue, Expense, Inventory to ensure completeness, accuracy and reasonableness of reported balances- Interviewed client financial management team to perform walkthrough and accurate documentation of auditing files