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
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