CRI Advantage is looking for a consultant to deliver data warehouse and business intelligence consulting working Oracle. This is a 1 year engagement.
The Nevada Department of Transportation (NDOT) is beginning a multi-year project to implement and GIS enable the OBIEE product suite. The project will include creating data marts or a data warehouse, populating them with data from our production systems, integrating the data with our production ESRI road network, using OBIEE features to analyze and display the data, and converting existing Oracle Discoverer reports to use Oracle BI Publisher or Oracle BI Answers.
SCOPE OF WORK
· Consultant must perform all activities to the agreed upon project plan/schedule.
· Data warehouse and data mart design;
· Mapping from operational data to data warehouse or data marts;
· Migration of data into data warehouse or data marts using Oracle Data Integrator;
· Report creation in BI Publisher;
· Dashboard and report creation in BI Answers;
· Scorecard creation in OBIEE;
· Migration of reports from Oracle Discoverer to Oracle BI Publisher and Oracle BI Answers;
· Creation of maps in OBIEE;
· Integration of NDOT’s ESRI road network into OBIEE;
· Tuning of queries created in OBIEE; and
· Sharing knowledge with other team members.
· Consultant must provide the following based on the agreed upon project plan/schedule.
· Data marts or a data warehouse correctly loaded with appropriate data;
· BI Publisher reports;
· BI Answers reports and dashboards;
· OBIEE Scorecards;
· All major reports migrated from Discoverer to BI Publisher or BI Answers;
· Reports and queries running quickly;
· Road network data displayed on maps within OBIEE with integrated querying capabilities for GIS and tabular data
EXPERIENCE AND SKILLS REQUIRED
Consultant must have:
· Strong knowledge and experience implementing, using, and tuning the Oracle Business Intelligence Enterprise Edition (OBIEE) Suite in a Windows based environment;
· Knowledge and experience in the implementation of Oracle BI Publisher and Oracle Data Integrator;
· Understanding of and experience with the implementation of data marts and data warehouses using star schema design, and the migration of operational data to this structure; and
· Excellent written and verbal communication skills.
EXPERIENCE AND SKILLS DESIRED
· Knowledge of ESRI and Geomedia geographical information systems and how their data can be integrated with and queried upon by the OBIEE suite is desired.
· Experience in the use of Oracle Discoverer and the migration of Oracle Discoverer reports to OBIEE will be beneficial.
· An understanding of transportation systems and road design principles will also be beneficial.