Eight years. Four domains. One thread.
Eight years, four strands.
- 2025 Now
- Started JMR Advisory, an independent data-automation and web-design practice based in Puerto Rico
- Positioning the practice around data-engineering depth, not generic agency work
- Building first-client pipeline and operational foundation in parallel with portfolio launch
- Notion
- 2025 Now
- Designed JMR Advisory's brand identity and visual system
- Built and shipped the JMR Advisory portfolio site — Astro, motion-first hero, sub-200KB JS budget, axe + Lighthouse gates in CI
- Treating the site as the case study: render quality, performance, and accessibility are the deliverable
- Astro
- HTML/CSS
- Figma
- 2022 Now
- First hire into the newly formed Rebates Data & Reporting department — its senior IC and project owner — as rebate-data ownership transitioned in from the B2B, BI, and Analytics teams
- Architected the Rebates Snowflake single source of truth — 20+ dbt models, 4 ingest pipelines, ~20 reports — collapsing reporting deliverables from days to minutes
- Led data and reporting requirements for ASES Medicaid rebates within the federal MDRP program
- Directed 2 contractors through requirements gathering, design, development, and deployment of the Snowflake SSOT
- Snowflake
- dbt
- Python
- SQL Server
- Tableau
- Git
- 2021 2022
- Led 4 direct reports through onboarding, training, mentoring, and quarterly assessments
- Owned analytics projects end-to-end as sole developer — eliciting the real requirements from stakeholders who described the result they wanted, then design, development, deployment, testing, training, and support
- The team's go-to for T-SQL query optimization — the escalation point when a query failed on performance — across replica, data-warehouse, and new-client implementation reporting serving financial operations, MTM, coverage determinations, financial planning, rebate operations, formulary, and provider networks
- Defined functional and architectural information-delivery requirements jointly with the BI team
- SQL Server
- SSRS
- Tableau
- Excel
- SSIS
- 2019 2021
- Owned 5 CMS audit reports — RR MTM, RR CD, CDAG, FA, RR LTC — as analytics lead across federal compliance cycles
- Specified data warehouse reporting requirements: the views, columns, and tables the BI team implemented
- Trained the analytics team on T-SQL query optimization patterns
- SQL Server
- SSRS
- Tableau
- Excel
- 2018 2019
- Migrated 40+ COGNOS reports to SSRS in a six-month period
- Recreated the claim financial billing process for a report and identified a production code bug behind a material billing recovery
- Headed two CMS live audits in the analytics manager's absence
- Learned SQL and SSRS from scratch in the first month with minimal support; debugged coding and logic errors across the reporting estate
- SQL Server
- SSRS
- SSIS
- Excel
- 2017 2017
- Drafted operational reports from in-house Access credentialing application for provider network team
- Supervised inter-departmental credentialing support project with 4 employees from the claims department
- Led quarterly provider expired-credentials cleanup efforts
- SQL Server
- Excel
- 2017 2018
- Directed digitalization and reporting of "Operation Blue Roof" — the post-Hurricane María ROE database for federal disaster recovery
- Supervised up to 6 staff on daily ROE data entry; built data-entry templates and trained the team
- Cross-referenced US Army Corps of Engineers data to surface status discrepancies in disaster-recovery records
- Reported project status to the VP for informed decision-making during the recovery window
- Excel
- SQL Server
Selected projects.
Data Engineering
Rebates Snowflake SSOT
Rebate analytics at Abarca were scattered across SQL Server, SSIS packages, and stored procedures owned by three separate teams (B2B, BI, Analytics) — slow, fragile, and impossible to audit cleanly.
SnowflakedbtPythonSQL Server +1
Web
JMR Advisory — Web Presence
Transitioning from full-time analytics engineering to running JMR Advisory required a public artifact that could filter inbound work and demonstrate craft — a portfolio that argues by existing.
AstroPreactTypeScriptGSAP +2