STEPHEN CHEN
Los Angeles, CA 408-***-**** ********.****@*****.***
www.linkedin.com/in/stephen-suit-chen/
EDUCATION
University of Southern California
Master of Science, Biostatistics
University of California, Los Angeles
Bachelor of Science, Psychobiology
Skills/Awards:
Experienced in SQL, Excel, Power BI/Tableau, Oracle, SSMS, OLAP, OLTP,
Proficient in SSRS, Google Data Studio/Looker, Visual Studio, Python, Rstudio, DBT, Snowflake, Git/Github/Gitlab, SSDT, SSAS, Jira, Confluence, Atlasssian, Workday, Terraform, Bitbucket
Machine Learning/AI (Linear/Logistics regression, Decision Trees, K-Nearest Neighbors, Neural Network, Naïve-Bayes)
David Geffen School of Medicine Humanitarian Award WORK EXPERIENCE
SonderMind 2024 - 2025
Analytics Engineer
Engineered data integration solutions connecting enterprise operational, accounting, and financial/business data warehouses/marts (Snowflake, DBT, Fivetran, Looker).
Developed and streamlined Looker dashboards to provide business visibility into rolling performance of providers for the largest client by market share (UHC/Optum).
Sole analytic resource for business negotiation and implementation teams, driving rate analysis and financial modeling for a $100M+ line of business.
Cross-functional contributor to product management teams, supporting compliance, customer acquisition, and growth initiatives.
Kaiser Permanente 2023 – 2024
Data Architect, Database Management
Led as the Product Owner for requests to a data mart, managing the intake request lifecycle from user story development to non-release stages achieving stakeholder alignment for business users and senior leadership
Spearheaded the development/deployment of (POC) data cubes utilizing SSDT/Visual Studio to efficiently source approximately 200 million rows/2 years of data from Oracle and Microsoft SQL DB.
Designed, analyzed, and developed a data build solution that significantly accelerated the runtime of a customer outreach tool by 75% efficiency resulting in 4 hours to 1 hour runtime by leveraging AI(LightGBM, LGBM Regressor, LGBM Classifier, and NonparamDML)
.
On Prem Solutions, Qvest.US 2022 –2023
Consultant, Data and Analytics (Major Studio)
In collaboration with a team, contributed to the development and implementation of an ETL pipeline (utilizing a 5-star schema structure in Snowflake) using DBT data models in an agile, CI/CD environment (Bitbucket)
Implemented column and row-level security on PII data in Snowflake and third-party applications, ensuring a seamless and hierarchical end-user experience while protecting confidential data. Additionally, I built macros in dbt/Snowflake to automate permissions, models, and row-level security
Created an actionable roadmap for building a simpler, scalable data architecture for marketing data to power better identification of sales opportunities for campaigns across social media (Google Analytics, Google Tag Manager, Salesforce)
Conducted a comprehensive current state analysis on a 20M budget, including facilitating workshops, conducting market research, and documenting pain points. Provided strategic recommendations for future state improvements and developed a 5-year roadmap to guide the implementation of these recommendations Optum, United Health 2020 – 2022
Data Analyst, Internal Consulting
End to end contributor in a collaborative, cross-organizational team in a post-merger integration by supporting and driving contract negotiations through management/ingestion of native, ambiguous data (SQL Server, Snowflake), financial modeling (Excel), and automated business intelligence solution (Power BI)
Drove $40M dollars business growth by partnering with senior leadership/external vendor(s) to spearhead risk valuation client by client and new line of business growth
Built P&L reporting dashboard(s) deliverable that refreshes quarterly to CFO to capture revenue/membership growth and attrition to inform senior leadership on business and data strategy as well as predictive analytics
Drove negotiation of several $100-$500M contracts by evaluating contract performance through financial modeling as a cross functional consult for quantifiable action in Optum’s negotiations LA Care Health Plan 2019
Health Information/Quality Analyst
Spearheaded data query manipulation via for LA Care's flu shot compliance program; analysis drove a $162,500 business decision for a collaborating department to actionize pilot program to increase compliance for flu vaccinations
Spearheaded AI cluster analysis utilizing K nearest neighbors to provide statistical reporting on CCS data to optimize marketing operational strategy
Analyzed claims data and presented visualizations(Powerpoint) for compliance initiative - successfully drove support for extending current business practice (for ~100,000 members/year) to encourage compliance of child-care visits.
Drove process improvement by modeling data lags in Tableau with by looking at pharmaceutical claims data