United States
• Own production reliability of the member enrollment data platform SSIS ingestion jobs into SQL Server, downstream Snowflake refresh tasks, and Salesforce CRM sync serving as primary on call for data incidents. • Rebuilt a fragile nightly enrollment ingestion (11 source feeds, 4.2M records) by replacing chained SSIS dependencies with a parameterized parent package and Snowflake Streams, cutting failure rate from weekly to under one incident per quarter. • Authored T-SQL stored procedures and Snowflake procedures driving eligibility, plan-assignment, and outreach segmentation logic consumed by CRM and analytics teams. • Migrated database object deployment from hand-run scripts to Git-based change control with pull-request review and a lightweight CI/CD pipeline, eliminating untracked production changes. • Partnered with the Data Architect, web development team, and analytics team as the CRM data SME, troubleshooting integration defects and documenting recurring issues into a runbook. • Tuned 18 high-cost Snowflake queries through clustering review, warehouse sizing, and rewriting correlated subqueries, reducing the daily warehouse runtime window by roughly 37%.
• Built and maintained SSIS packages ingesting pharmacy claims, eligibility, formulary, and rebate feeds from 9 vendor sources into SQL Server, replacing legacy file-drop manual loads. • Designed the dimensional model (claims fact, member/prescriber/drug dimensions) supporting adherence reporting, prior-authorization tracking, and rebate reconciliation. • Wrote T-SQL stored procedures, scalar and table-valued functions, and triggers powering the claims reporting layer; led an indexing redesign on the claims fact table that reduced p95 query latency on the top 25 reports. • Engineered the CRM-to-claims integration linking pharmacy CRM contact records to adjudicated claims, enabling outreach workflows for non-adherence and gaps in care. • Built monitoring on SSIS job failures and SQL Agent schedules using a lightweight Python alerting script, replacing reactive ticket-based discovery with proactive notifications. • Performed deployment activities to pre-production and production from a Git-managed repository, supporting a two-week Agile cadence with the application development team.
• Developed and maintained ETL pipelines on MS SQL Server using SSIS and T-SQL, ingesting claims, eligibility, and clinical feeds across multiple regional payer clients. • Designed normalized operational data stores (3NF) and denormalized reporting marts feeding population-health KPIs, readmission analytics, and HEDIS-aligned quality measures. • Authored a large library of stored procedures and reusable functions powering risk stratification and member segmentation logic adopted across three regional client networks. • Built a Python validation framework (Pandas, NumPy) running duplicate detection, referential-integrity checks, and exception queues against nightly loads, lifting downstream data quality scores meaningfully. • Implemented FHIR-aligned and XML/JSON standardization across multi-site CRM and operational systems, enabling interoperable cross-site reporting. • Operated as the day-to-day owner of SQL Agent job monitoring, backup verification, and incident triage across the payer reporting environment.