Michael Ocasio

Senior Federal IT Specialist with extensive experience designing enterprise-scale data infrastructures, building automated ETL/ELT pipelines, and supporting mission-critical government systems. Expert in SAP HANA, Oracle, SQL Server, and cloud-integrated data environments. Proven experience supporting disaster recovery (COOP/DR), production system upgrades, database modernization, and cross-functional collaboration with technical and business stakeholders in FISMA/NIST environments.

Information Technology Specialist (GS-13) - U.S. Department of Health and Human Services (HHS)

(2017-01 - 2025-06)

• Designed enterprise-scale data infrastructure supporting mission-critical healthcare systems using SAP HANA, Oracle, and SQL Server.
• Developed automated ETL/ELT pipelines integrating multiple enterprise data sources into centralized data repositories.
• Led Oracle-to-SAP HANA migration including database objects, stored procedures, and data model conversion.
• Developed SQLScript, PL/SQL, Python, and PowerShell automation for data validation, transformation, and monitoring.
• Implemented database validation and unit testing during system upgrades including table counts, user permissions, and stored procedures.
• Supported production database patching and upgrades ensuring continuous system availability and data integrity.
• Collaborated with DBAs, developers, cybersecurity, and business stakeholders to resolve complex technical issues.
• Supported disaster recovery readiness, production validation, and system recovery planning activities.
• Ensured compliance with FISMA and NIST security requirements.

Information Technology Specialist - U.S. Department of Commerce – Bureau of Economic Analysis (BEA)

(2004-01 - 2016-12)

• Supported enterprise data systems for monthly GDP and Personal Income production environments.
• Designed ETL processes integrating Aremos and FAME economic datasets into centralized databases.
• Participated in Continuity of Operations (COOP) and Disaster Recovery (DR) exercises for monthly production releases.
• Supported production deployment and validation at alternate processing sites ensuring uninterrupted operations.
• Developed SQL Server stored procedures and automated processing workflows.
• Collaborated with economists, developers, and leadership during monthly production cycles.
• Automated system monitoring and reporting using PowerShell scripts.

Computer Specialist - U.S. Census Bureau

(1997-01 - 2004-12)

• Developed enterprise applications supporting Economic Census data processing systems.
• Used COBOL, SAS, FORTRAN, Java, and C for large-scale government data processing.
• Supported NAICS-based economic data collection, processing, and reporting systems.
• Developed data validation and batch processing applications for census operations.

M.S. - Computer Science - Herbert H. Lehman College, CUNY