San Francisco Bay Area
Data analytics professional with 8+ years of experience transforming complex datasets into dashboards and insights that drive measurable business outcomes. Background spanning consulting, healthcare, and pharma with expertise in SQL, Python, and cloud platforms (Snowflake, Teradata, AWS). Skilled at working cross-functionally and translating ambiguous business questions into clean data models, automated pipelines, and self-serve analytics.
• Developed and maintained Tableau dashboards integrating A/B testing and statistical inference to evaluate feature impact, delivering 30+ enhancements that drove measurable improvements in user engagement and KPI alignment. • Streamlined Informatica and Snowflake ETL pipelines to meet updated guidelines, increasing reliability of reporting tables powering downstream dashboards and stakeholder analytics. • Engineered complex SQL stored procedures to reconcile and deduplicate millions of records, improving data quality across downstream reporting infrastructure and reducing reporting errors • Restructured and optimized complex SQL source data with advanced joins and suppression logic, driving a 50% increase in active users through expanded dataset dimensions and deeper dashboard insights. • Developed Python scripts integrating location-based APIs to standardize addresses, coordinates, and isochrones, powering travel-time visualizations for informed decision-making • Synthesized findings from comprehensive data analysis into executive-facing strategic recommendations, directly influencing KPI alignment and roadmap decisions across cross-functional teams. • Led cross-functional User Acceptance Testing (UAT) across 100+ test scenarios, prioritizing client feedback to align KPIs, resolve data and UX issues, and deliver a validated release on schedule
• Developed and implemented a BI dashboard with provider consultants to analyze denied claims data, driving a 12% improvement in provider KPIs and enabling data-driven operational decisions at the leadership level. • Constructed an R-based automation framework integrating directly with the data warehouse to generate polished Excel reports, cutting production time by 90% and freeing capacity for higher-value analysis. • Built complex Teradata SQL queries to identify variance discrepancies and analyze business performance data, surfacing insights that directly informed strategic assessments and operational decision-making.
• Prepared year-over-year portfolio analyses and quarterly budget summaries for executive leadership, tracking study performance trends and surfacing financial risks across a multi-million dollars R&D clinical portfolio. • Managed over 10 clinical studies monthly for operational delays and budget risks, independently reallocating hundreds of thousands of dollars across study portfolios to optimize spend and maintain financial plan integrity.
• Strengthened operational accuracy by investigating account discrepancies, validating client data, and monitoring data quality across all implementation phases.
• Delivered end-to-end credit analysis by stress-testing cash flows, assessing collateral risk, analyzing tax returns in Sageworks Analyst, and presenting loan performance insights to executives.