Intermediate Clerk
Los Angeles County Public Works
- Developed and implemented SharePoint-based workflow automation, digital record management, and tracking solutions for the Records of Survey Unit, replacing paper-based processes and improving operational efficiency and record accessibility.
- Designed and developed automated Excel-based solutions with advanced formulas, Power Pivot, and automated data validation to streamline map-checking and records tracking processes.
- Integrated Excel workbooks with ArcGIS Online and Oracle data sources to automate data population, reduce manual data entry, and improve data accuracy.
- Developed interactive Power BI dashboards and reports for operational reporting and performance monitoring.
- Designed and developed SharePoint pages. Currently implementing a Microsoft 365 Copilot solution that enables users to query operational data and reports using natural language.
- Tested, troubleshot, enhanced, and maintained internally developed applications, spreadsheets, and automated workflows based on user feedback.
- Collaborated with Survey staff, GIS professionals, and the Information Technology Division to gather business requirements and implement technical solutions using ArcGIS applications, SharePoint, Power BI, Power Automate, Oracle data sources, and EPIC-LA.