Role details
- Administered and tuned relational databases
- Managed online login access for 400 public agencies to access over 10,000 confidential public agency records
- Developed ad hoc reports using Power BI, Cognos BI, Crystal Reports, Power Pivot, and Power Query
- Regularly developed queries and reports using IBM Cognos Analytics 10 and 11
- Scrubbed, input, and tracked insurance renewal data for general liability, property, and cyber liability
- Evaluated vulnerability scans and communicated CVEs to California water and power agencies
- Queried SQL Server 2019 using SSMS for executive reporting and decision making
- Communicated new and evolving cyber threats to member agencies
- Managed data streams, created stored procedures, implemented functions and aggregated data
- Managed two-year project to move property database to new software solution
- Created PowerShell scripts to perform bulk file movements and clean data
- Liaised between IT providers, cyber liability insurers, and public water agencies
- Assisted members in the implementation of domain scanning services and other cyber security training
- Recommended mitigation actions to public agencies including hardening of SCADA, PLC’s, and VNC’s
- Conducted cyber security training for risk management team
- Developed fire maps using QGIS, ArcGIS, and CPUC data to evaluate fire risk within state of California
- Created online tutorials instructing public agencies on use of member portal
- Documented SOPs to achieve quality output, uniform performance, and industry compliance
- Worked with CISA to development cyber security and DR plans
- Calculated the replacement costs of member agencies’ insurable property values more than $13 billion
- Trained Member Services staff in data manipulation and proper use of data types
- Used Adobe Pro to create official documents including, invoices, schedules, and certificates of insurance
- Implemented advanced Excel functions: VLOOKUP, IFERROR, INDEX, MATCH, and other string operations
- Elicited requirements from stakeholders and conducted root cause analysis
- Communicated technical issues with non-technical customers and staff
- Analyzed replacement costs of property for insurance purposes