Resume

Snowflake, AWS, dbt, Matillion, PostgreSQL, Python, SQL, Pandas

• Built a Snowflake/AWS enterprise data warehouse consolidating payer, clinical, claims, eligibility, attribution, and operational data across 14 insurance payers into a single source of truth — now powering 100+ Tableau dashboards for ~150 daily users
• Consolidated payer eligibility and Athena EHR data into an SCD2-historized member-month dataset tracking patient coverage and provider attribution over time
• Engineered batch and CDC ELT pipelines ingesting 400–500 files/month via Matillion, Snowpipe, Snowpark, and Streams/Tasks, with automated deduplication and schema-drift resilience (~10-minute S3-to-table latency)
• Established Snowflake cost-governance dashboards and credit-spend anomaly alerts surfacing top-cost queries, and cut redundant compute via incremental Stream/Task processing
• Architected a multi-tenant platform serving multiple entities from shared dbt models, using row-level security (row-access policies), secure views, and column-level PII masking to enforce isolation and accelerate onboarding
• Implemented dbt tests and data-quality checks (not-null, referential, freshness) across 100+ models, with alerting on pipeline failures to protect downstream reliability
• Modeled multi-payer medical and pharmacy claims into a standardized, certified dataset, normalizing disparate per-payer schemas to enable population-health analytics and PMPM cost metrics
• Developed dbt models on a landing→curated→gold medallion architecture, refining raw data into star-schema marts powering self-service analytics across clinical, payer, and operational domains
• Implemented Terraform IaC with Git-based CI/CD (GitHub Actions) to provision AWS and Snowflake objects, ensuring reproducible, auditable deployments and eliminating configuration drift

React JS, Laravel, C#, MSSQL, PostgreSQL, ASP.NET, Python, SQL, JavaScript

• Developed and maintained a full-stack web app for online review management and customer feedback, serving enterprise, small-business, and individual accounts
• Administered the MSSQL database and built core application logic via stored procedures
• Integrated Zoho CRM to automate sign-ups and lead intake, improving onboarding for large multi-location businesses
• Built AWS Comprehend sentiment analysis to process customer review and survey text at scale, powering automated reporting and reputation monitoring
• Helped migrate a legacy .NET monolith to a modern React.js frontend and Laravel/PHP backend architecture

Python, DuckDB, dbt, Streamlit, LLM text-to-SQL, GitHub Actions, Cloudflare R2

• Built a Streamlit Cloud app for natural-language querying of a star-schema warehouse, returning transparent SQL with clause-level explanations and visualizations
• Used dbt manifest and catalog metadata as schema context for text-to-SQL, with read-only validation, query timeouts, and automated CI/CD publishing to Cloudflare R2

Details · Live demo

Python, Streamlit, Plotly, pandas, yfinance, Docker, public REST APIs

• Built and deployed a config-driven Streamlit dashboard (assets, sections, and indicators defined in YAML) showing where price sits versus its moving averages and where capital is rotating across crypto, equities, and macro markets
• Engineered a resilient multi-source ingestion layer pulling four free public APIs (yfinance, CoinGecko, OKX, CFTC Commitments of Traders) behind TTL-cached, fault-tolerant fetchers with parallel cold-start fetch and graceful fallbacks; deployed on Streamlit Community Cloud

Details