Florida Department of Agriculture & Consumer Services

Client Need: To augment homeland security and prepare for potential threats to Florida’s citizens and resources, Florida DACS needed to rapidly identify, locate, and notify its employees, it’s emergency contacts, and the emergency contacts of other regulated facilities during emergencies. To solve this problem, Florida DCAS initiated a Geospatial Data Integration (GDI) Project. This project needed extensive Extraction, Translation and Loading (ETL) to pull all of the data from the different systems into a central repository used by the GIS interface.

Our Solution: E24X7INC provided a Database Architect, Database Analyst, Business Analyst, and Contract Manager to verify the business needs and create the technical requirements for the GDI Project. Our team developed and deployed the entire ETL Flows to load the GDI required tables for BSF, CPAS, PDA and DAIRY in addition to other project deliverables.