Eight years. Four domains. One thread.
Eight years, four strands.
- 2025 Now
- Founded JMR Advisory LLC to deliver data-automation and web-design services from 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
- Established a specialized RDR department, transitioning rebate-data ownership from 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
- Acted as Director when director was absent; engaged C-suite stakeholders directly on the department's highest-visibility initiative
- 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
- Spearheaded analytics projects end-to-end — requirements analysis, development, deployment, testing, training, and support
- Recognized as T-SQL query optimization SME; debugged and optimized large-scale queries across the analytics estate
- 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 — across federal compliance cycles
- Served as SME across operational finance, rebates, compliance, coverage determination, and provider network teams
- Produced data warehouse architecture and modeling designs in partnership with the BI team
- Trained the analytics team on T-SQL query optimization patterns, raising performance at both individual and group levels
- SQL Server
- SSRS
- Tableau
- Excel
- 2018 2019
- Migrated 40+ COGNOS reports to SSRS in a six-month period
- Recovered $100K by recreating the claim financial billing process and identifying a production code bug
- 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
What I reach for.
- SQL Server
- Tableau
- SSRS
- Snowflake
- dbt
- Excel
- Python
- Astro
- HTML/CSS
- Figma
- Notion
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