USDA Enterprise Geospatial Management Office – Enterprise GIS and IT Services

VSolvit added a data repository, multi-dimensional data aggregation, improved presentation capabilities, and performance improvements required due to increased utilization, customer demand for comprehensive products in a timely manner, and requirements for advanced analysis.. This solution was to augment the existing Material Readiness Database (MRDB) Oracle 11g database with Oracle Business Intelligence Enterprise Edition 11g (OBIEE). Multiple tools and technologies in the support of the current MRDB Technical Refresh Project include: Oracle Business Intelligence Enterprise Edition, Oracle Data Integrator, Oracle Business Intelligence Interactive Dashboards, Oracle Answers, Oracle Delivers, Oracle Publisher, Oracle Disconnected Analytics, TOAD, ERWIN Data Modeler, Oracle Database 11g Enterprise Edition, Oracle Access Manager, Pl/Sql, SQL Developer, Web Catalog and IBOTS. VSolvit had many responsibilities, including architecture design, security design, software installation and design, data modeling, business intelligence and report design, OLAP and OLTP design and analysis, performance testing of OBIEE platform, database design, data analysis, migration, integration and warehousing.