Dani Interrante

• Constructed interactive reports in Microsoft Power BI that display metrics and project statuses of Hazard Mitigation Grants being issued by FEMA to state and local governments
• Automated Python and Spark SQL based ETLs in Azure Databricks that utilized both internal, enterprise data and data imported via API from external sources
• Built ArcGIS Online Dashboard that uses multiple search criteria to link users to external sources. The dashboard is formatted with ESRI Arcade and maintained with Python ETLs
• Built project tracking and collection app in AGO Survey 123 Connect and Experience Builder, which comprises of multiple modules allowing users to join and relate data collected both internally and from the field

Working on behalf of the Department of Licenses and Inspections

• Supervised and provided extensive training to team of 1-3 analysts
• Automated delivery of tabular data via email
• Maintained reporting and dashboard environments for users to extract data on an as needed basis in Metabase and Izenda Ad Hoc
• Lead the implementation of the Building Certification application on L&I Property History website and integrated with Atlas
• Supervised ETLs and data integrations both with our department and across the city government

Working on behalf of the Department of Licenses and Inspections

• Developed 'Mean High Tide Line' GIS dataset using raster interpolation tools and map algebra on data collected via Python from NOAA's VDatum API
• Provided technical and departmental guidance to junior analysts allowing them to independently tackle projects
• Served as de facto 'addressing' expert for department for integrating property data between databases
• Lead the integration of Python and SQL based ETL processes onto GitHub
• Oversaw and trained new staff in creating reports in Metabase and Izenda Ad Hoc Reports
• Use technical knowledge to handle sometimes obscure data requests

Working on behalf of the Department of Licenses and Inspections

• Continued to rework and improve the Python and Oracle SQL based ETL applications maintained by the unit
• Lead the preparation of building planimetric and address data for integration into the new eCLIPSE Database
• Built custom reports and dashboard in Metabase Reporting System
• Built custom geoprocessing tools in Python
• Explored applications of aerial lidar to identify structural deficiencies in buildings

Working on behalf of the Department of Licenses and Inspections

• Implemented ETL workflows that regularly move data from departmental SQL databases into a shared city-wide GIS Enterprise using Oracle SQL queries and Python scripts
• Used Oracle SQL to pull custom data requests to be delivered as either Excel spreadsheets or vector GIS layers
• Implemented a system for maintaining city-wide building planimetrics
• Experimented with predictive indicators on building conditions