ROGELIO E. ALBANDOZ
Weston,FL
Summary
Experienced IT Consultant with a robust 15-year track record in delivering enterprise modernization solutions, orchestrating data and infrastructure migrations, and executing detailed system assessments for clients across multiple sectors, including housing and government.
Proficient in managing sophisticated transitions from legacy systems to advanced architectures, with a strong commitment to security, performance, and operational resilience.
Solid foundation in SQL Server technologies, emphasizing architecture, upgrades, and performance tuning, with expertise in SSIS/SSRS automation. Knowledgeable in cloud and virtual desktop environments, including Azure and AVD. Competent in integrating essential business systems through REST APIs while adhering to secure connectivity standards like TLS/SSL.
Expert in facilitating collaboration between technical teams and stakeholders, interpreting requirements into scalable solutions, and managing projects from discovery to delivery with precise documentation and governance
Overview
18
18
years of professional experience
1
1
Certification
Work History
Technical Consultant (Technical Engineer Track)
Emphasys Software
01.2021 - Current
- Engineer and deliver implementation-ready technical solutions across database, reporting, and application integration components, supporting production deployments for public-sector clients.
- Support Azure cloud engineering delivery for SaaS-hosted environments, including deployment readiness and operational validation across Azure Web Apps, Azure Functions, VNets, Azure Virtual Machines, Azure Virtual Desktop (AVD), and SQL Managed Instance.
- Develop and maintain SQL automation scripts that standardize delivery tasks, reduce manual execution time, and improve repeatability across implementation workstreams.
- Perform SQL performance tuning and proactive index maintenance to sustain database efficiency and reduce performance degradation over time.
- Implement index fragmentation management strategies, including monitoring thresholds and executing rebuild/reorganize routines to maintain stable system performance.
- Diagnose and isolate middleware performance bottlenecks by evaluating disk latency, CPU utilization, memory pressure, and network throughput impacting application responsiveness.
- Drive troubleshooting and incident resolution through structured root cause analysis, remediation planning, and validation—supporting production stabilization and risk reduction.
- Partner with client stakeholders and internal teams to translate business requirements into technical deliverables, aligning scope, priorities, and delivery timelines.
Data Migration Analyst
Emphasys Software
08.2017 - 01.2021
- Executed full-cycle data migration activities using Microsoft SQL Server, including data imports, cleansing, mapping, transformation, and post-load validation across multiple legacy source formats.
- Conducted database analysis and conversion validation to support housing authority implementations, including HUD RAD compliance requirements.
- Validated PBV and PBRA datasets, documented exceptions, and supported remediation efforts to protect data integrity and regulatory alignment.
- Coordinated migration schedules, cutover dependencies, and stakeholder communication to ensure smooth transitions and minimize operational downtime.
IT Internal Auditor
Office of the Comptroller of Puerto Rico
08.2016 - 08.2017
- Supported continuous auditing initiatives using ACL analytics to assess process effectiveness, compliance, and internal controls.
- Evaluated IT security controls, including privileged access administration and access governance practices to reduce risk exposure.
- Assisted with enterprise data warehouse development by integrating multiple data sources to strengthen audit reporting and analysis.
Programmer Analyst
Office of the Comptroller of Puerto Rico
07.2008 - 07.2016
- Developed internal systems that centralized multiple data sources into a unified portal, improving investigation speed and audit effectiveness.
- Built BI dashboards supporting leadership visibility into audit trends, outcomes, and operational performance indicators.
- Delivered and maintained public-facing government systems, including a Government Contract Registry, improving transparency and public access to information.
Education
Master of Information Systems - undefined
EDP University of Puerto Rico
San Juan, PRBBA - Management Information Systems
Universidad Interamericana de Puerto Rico
San Juan, PRSkills
Software deployment strategy
Accomplishments
- Helped implement a Payroll upgrade for hosted SaaS customers, saving ~$40K by avoiding external service costs.
Certification
- Microsoft Certified: Azure Fundamentals (AZ-900) — Microsoft
- Credential: https://learn.microsoft.com/en-us/users/RAlbandoz/credentials/443C94B97A1B3C8E
- Predictive Analytics & Data Mining — The Modeling Agency (2013)
- Professional Certificate in Systems Audit — EDP University (2009)
Languages
English
Full Professional
Spanish
Native or Bilingual
Timeline
Technical Consultant (Technical Engineer Track)
Emphasys Software
01.2021 - Current
Data Migration Analyst
Emphasys Software
08.2017 - 01.2021
IT Internal Auditor
Office of the Comptroller of Puerto Rico
08.2016 - 08.2017
Programmer Analyst
Office of the Comptroller of Puerto Rico
07.2008 - 07.2016
Master of Information Systems - undefined
EDP University of Puerto Rico
BBA - Management Information Systems
Universidad Interamericana de Puerto Rico