Luis Rivera Gonzalez

Senior IT Professional with 25+ years of experience bridging legacy systems and modern innovation. Expert in SQL database administration, healthcare IT interoperability (HL7/Meditech), and advanced data automation. Driving digital transformation through Prompt Engineering and AI integration (Claude, ChatGPT, Gemini, Copilot) to optimize workflows and reporting. Bilingual educator skilled at translating complex technical concepts into actionable business value.

IT Specialist & Data Analyst (AI Integration Focus) at DTOP (2024-01 – Present)

• Revolutionizing data workflows through AI-powered KPI and statistical reporting using Claude, Gemini, ChatGPT, Perplexity, Copilot, and NotebookLM
• Managing and optimizing MS SQL and Access databases, ensuring data integrity for large-scale governmental records
• Designing advanced Excel automation tools and formulas to streamline departmental metrics and operational efficiency

Computer Science Professor at Central College UNI (2019-01 – 2022-12)

• Delivered high-impact instruction on MS Office 365, database management, and emerging AI technologies to diverse student populations
• Managed virtual and in-person classrooms; developed curricula aligned with current industry demands

Computer Science Professor at Central College UNI (2024-01 – Present)

Accounting IT Assistant at ERC Manufacturing Inc. (2023-01 – 2024-12)

• Key Achievement: Engineered a sophisticated Excel-based Bank Reconciliation system using XLOOKUP and complex logical nesting to automate monthly transaction validation for Sage 50c
• Optimized financial data processing through advanced Excel formula programming

IT Specialist (Database Admin / EHR Specialist) at PR Medical Services Administration (ASEM) (1998-01 – 2019-12)

• Served as Meditech (EHR) Data Repository Specialist, managing critical healthcare data for one of Puerto Rico's largest medical administrations
• Automation Success: Developed an automated HL7 file transfer process (scripts/scheduled tasks) renaming and moving files every 60 seconds to ensure seamless integration between Meditech and ProClaim billing systems
• Spearheaded major Sybase-to-MS SQL Server migration, architecting new database tables, fields, and complex relationships

Master's Degree in Management Information Systems (MIS) – EDP University

Bachelor's Degree in Computer Science (Programming Focus) – Inter American University

Certification in Medical Billing & Coding – University of Puerto Rico