Rich Wang Email & Phone Number

Seattle, Washington, Us

Learning, sharing, and debating best practices and best-in-class solutions

Denver, Colorado, Us

Inaugural member of DataLab Initiative, a cross-functional internal workgroup of three analysts and engineers tasked with founding company’s first data org by defining a team charter, working agreement, intake process, technical requirements, system architecture, and vendor selection criteria, then implementing a scalable, secure, cost-effective modern analytics infrastructureKey advocate and test pilot for the migration of bespoke, legacy AWS-GSuite data ecosystem (S3, Glue, Athena, Google Sheets, Tableau) to a modern relational data stack (Snowflake, Fivetran, dbt, Docker, git, Mode) connecting all critical business systems (Hubspot, Salesforce, Jira, Metronome, Stripe, Quickbooks, Google Sheets, product & third-party data) under SOC2-compliant ecosystemTaught SQL, analysis, and charting best practices to junior analysts, admins, and managers around the company to foster stronger data culture and boost productivityMigrated reporting and analysis from business system silos to a centralized warehouse, allowing more data consumers to access disparate first and third-party data sources as cleaned, curated, cohesive single-table data martsCreated Sales and Sales Development Performance Tracking dashboards to enable more precise measurement of compensation-dependent KPIs providing greater trust and transparency between RevOps, Sales, and Sales Dev teams Created Implementation Fee Tracking dashboard to support goal of fully offsetting Delivery overhead by pricing in project complexity and market value of services into contracts to improve operating leverageCreated Pipeline and Revenue Snapshot models from field history tables to remove blockers for Finance and RevOps reconciliation exercises, further reducing future cost-to-insightAccount Cleanup Project Lead tasked with eliminating data quality issues impacting sales productivity, identifying over a quarter of records as non-viable to scrub from CRMProof of concept TAM analysis for US insurance industry

San Francisco, California , Us

Denormalized a 143-entity data model to bridge back-end server events with third-party front-end web events and created an atomic model to build user engagement and retention dashboards, leaderboards, and power user curves

San Francisco, Us

Won Hack Day and Hack Day People’s Choice award by building a model that can measure a customer’s usage of shared resources across the platform enabling a shift to usage-based pricingDeveloped web apps to accurately invoice, upsell, and analyze usage by function, domain, source, and customerCreated transform templates to demonstrate rapid delivery of customer value by offering new customers out-of-the-box baseline engagement, retention, stickiness, and monetization metrics for archetypical business needsContributed input and feedback to internal data models, product roadmap, documentation, marketing copy, and various customer success initiatives

San Francisco, California, Us

Built a comprehensive revenue model combining income from commissions, subscriptions, and partnerships, which provided visibility into sales-driven and self-service measures of net new business, expansion, contraction, upgrade, downgrade, upsell, and churn in dollar, seat, and logo units, summarized by product and vertical over timeMaintained consistency and accuracy of revenue reporting through the transition between three distinct subscription billing systems with significant semantic and design incongruities, which allowed the business to identify and respond to invoicing errors and collections, create targeted renewal, upsell, and upgrade initiatives, and design a cost-effective tiered service modelDenormalized Payroll product's data model and built a ledger-balancing web application that enabled Payroll Operations team to reconcile off-platform payments and determine internal and customer tax obligations by jurisdiction, which served as a critical back office function allowing a strategically critical product to launch successfully on schedule while still under beta developmentBuilt sales, marketing, and product funnels to help business partners understand drop-off and relative lift of competing campaigns, experiments, and channels, fix bugs, and remediate poor performanceProvided a funnel analysis that helped to identify a major deficiency in our value proposition to a strategic customer segment, which resulted in the restructuring of Sales and Operations orgsDeveloped a licensing compliance model certified by third-party auditors that allowed Legal and Compliance teams to tie customer engagement data with income statements in order to self-report the scope of compliance issues, which resulted in minimum regulatory fines and retention of licenses in all jurisdictions for all lines of authorityTransitioned key data models in the semantic layer from AWS Data Pipeline to dbt, rewriting lengthy single-file scripts into source-controlled atomic models

San Francisco, California, Us

Built an initial response time model for Operations Center of Excellence team with logic that enabled measurement in business hours, accounting for a pivot in hours of operation and company holidaysEstablished precise customer success metrics that accounted for a highly nuanced SLA and SOP, which drove measured improvements in initial response time and overall service qualityProvided case analysis that identified the need to manage Engineering efforts under Product teams with roadmaps aimed at reducing servicing costs, which resulted in reorganization of Operations and my promotion into the core Analytics team

Jersey City, Nj, Us

Created standardized data feeds from disparate source platforms (ASP, .NET, PHP), which were productized into new service offerings for CPG and retail partnersManaged and developed T-SQL / .NET4-based client-server middleware applications used by various teams to execute critical business operations

Jersey City, Nj, Us

Designed and developed microsites styled to match the aesthetic of the client's web domainDesigned and developed v1 and v2 of Help Center, implemented dynamic Contact Us web forms that mapped to Salesforce, leveraged Salesforce to automate initial response, which closed out 80% of inbound without overhead cost

Jersey City, Nj, Us

Designed, built, and supported scalable service solutions from a manual phone and email response process to a semi-automated CRM-managed system of Exchange-based bulk exporting to Excel-based VBA script mapping to Salesforce Apex-based load scheduling