Automating SharePoint-based health checks and redesigning document workflows with Power Automate and Microsoft Lists to improve compliance visibility for ITS audits.

• Automated the Backup OnBase system health checklist, cloning 40+ weekly records while dynamically updating “Check Date” and “Results” fields to eliminate manual duplication.
• Modernizing fax line and workflow request processes by introducing Microsoft Lists and structured data collection for better compliance and reporting.

Designed surtax compliance dashboards, publication-ready reports, and digital intake forms that streamlined municipal transit oversight.

• Built a contract payment tracking workbook to monitor labor hours and costs against three active purchase orders, covering 40+ invoices to prevent overspending.
• Authored and formatted the 90+ page Municipal Program report by consolidating data from 30+ municipalities using Excel and Canva.
• Digitized paper attendee sign-ins with Microsoft Forms that auto-populated Excel logs, eliminating manual transcription and saving hours per event.
• Rebuilt the municipal ridership tracking workbook, calculating 18M+ annual boardings across 37 municipalities and adding new performance metrics.

Supported ENS certification preparation and bilingual documentation for Kenus Informática’s security programs.

• Assisted with compliance documentation for Spain’s Esquema Nacional de Seguridad (ENS) certification.
• Supported the systems department in risk assessment and security policy documentation.
• Drafted internal guides in Spanish and English outlining certification and privacy requirements.

Scaled portfolio management and QA tooling with Excel, SharePoint, and Monday Work Management to increase transparency across county IT initiatives.

• Developed VBA scripts that automated regression test status updates across workbooks, reducing manual effort by 20%.
• Created an Excel dashboard surfacing real-time regression test progress, percent complete by module, and on-time performance for PMO briefings.
• Built a SharePoint bug reporting system for 15 procurement staff with automated submissions, notifications, and status updates in Power Automate.
• Managed 15 Monday Work Management boards tracking ~100 IT initiatives to improve collaboration and delivery visibility.

Supported enterprise privacy by aligning NIST cybersecurity controls with COSO frameworks, assessing third-party vendors, and refreshing university policy guidance.

• Assisted in updating university policies and privacy standards in alignment with the NIST framework for 40,000+ stakeholders.
• Performed SOC 2 Type 2 vendor assessments covering 30 critical partners in response to a state audit.
• Mapped NIST cybersecurity controls to COSO internal control frameworks to strengthen organizational security posture.