[vc_section full_width=”stretch_row” css=”.vc_custom_1532085157436{margin-top: 0px !important;margin-bottom: 0px !important;padding-top: 0px !important;padding-bottom: 0px !important;background-color: #ffffff !important;}”][vc_row full_width=”stretch_row” css=”.vc_custom_1764838132394{margin-top: 0px !important;margin-bottom: 0px !important;padding-top: 40px !important;}”][vc_column css=”.vc_custom_1764838118689{margin-top: 10px !important;padding-top: 0px !important;padding-bottom: 0px !important;}”][vc_column_text css=”.vc_custom_1764838163480{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]
BI Support and Enhancements Led to Improved Efficiencies in Material Management Function
[/vc_column_text][vc_column_text css=”.vc_custom_1764837455739{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]The client is an executive department in one of the states in the USA. It manages more than 50,000 miles of highway and freeway lanes, provides intercity rail services, permits more than 400 public-use airports and special-use hospital heliports, and works with local agencies.[/vc_column_text][vc_column_text css=”.vc_custom_1764837534042{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]
Background
[/vc_column_text][vc_column_text css=”.vc_custom_1764837585548{margin-top: 0px !important;margin-bottom: 20px !important;}” el_class=”text-block”]The client used an internally developed application called Integrated Maintenance Management System (IMMS) for field staff. They extended the application to manage supply inventory, orders, workflow, cost tracking, and sourcing. They wanted to enhance the data warehouse and reporting application for real-time reports, integrate new IMMS modules, and add analytics. The client needed a vendor to provide day-to-day support for the OBIEE application and implement changes to existing reports and new data models to support the added functionality in IMMS.[/vc_column_text][vc_column_text css=”.vc_custom_1764837633212{margin-top: 0px !important;margin-bottom: 20px !important;}” el_class=”text-block”]The client extended this application to additionally manage supply inventory, orders, workflow, cost tracking, and sourcing. In conjunction with this, the client intended to enhance the existing data warehouse and Oracle Analytics reporting application to provide additional real-time reports, integrate new IMMS modules into the data warehouse, develop an architectural design for the new modules, and add analytics to support the related reporting needs.[/vc_column_text][vc_column_text css=”.vc_custom_1764837674403{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]Hence, the client was looking for a vendor to provide day-to-day support for the Oracle Analytics application and implement changes to existing reports, new data models, new extract-load-and-transform (ELT) processes and new reports to support the added functionality in the IMMS application. [/vc_column_text][vc_column_text css=”.vc_custom_1764837708740{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]
DiLytics’ Solution
[/vc_column_text][vc_column_text css=”.vc_custom_1764837752202{margin-top: 0px !important;margin-bottom: 10px !important;}” el_class=”text-block”]DiLytics delivered support and enhancement services for the existing IMMS OBIEE installation to provide additional real-time reports, expanded data warehouse design and additional warehouse reporting and analytics including:[/vc_column_text][rt_list_style list_style=”seven” list_content=”
- List Item Text One
- List Item Text Two
- List Item Text Three
” list_css=”.vc_custom_1764838433327{margin-top: -5px !important;margin-bottom: 35px !important;padding-left: 35px !important;}” list_extra_class=”text-block”]
- Oracle Business Intelligence-related product patches and upgrades
- OBIEE Environment Monitoring and Support
- OBIEE Software Maintenance
- Discovery Sessions for new requirements
- Expand the current data warehouse models, reports or dashboards
- New Product Implementation
- Develop and Support Oracle Application Express (APEX) Input Applications related to OBIEE
- Patching of APEX Components for OBIEE
- IMMS program-related Data Governance and enhanced analytics
[/rt_list_style][vc_column_text css=”.vc_custom_1764837823850{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]
Business Benefits
[/vc_column_text][vc_column_text css=”.vc_custom_1764837866297{margin-top: 0px !important;margin-bottom: 10px !important;}” el_class=”text-block”]DiLytics solution provided business benefits to the client such as[/vc_column_text][rt_list_style list_style=”seven” list_content=”
- List Item Text One
- List Item Text Two
- List Item Text Three
” list_css=”.vc_custom_1764838524121{margin-top: 0px !important;margin-bottom: 35px !important;padding-left: 35px !important;}” list_extra_class=”text-block”]
- Improved efficiency of material management function via the availability of enriched business insights on new functional modules
- Superior quality of IT support and maintenance services, delivered at an economical cost
[/rt_list_style][vc_column_text css=”.vc_custom_1764838019455{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]
Technical Stack
[/vc_column_text][vc_column_text css=”.vc_custom_1764838043224{margin-top: 0px !important;margin-bottom: 0px !important;}” el_class=”text-block”]Source System(s): Oracle APEX
Data Integration Tool: Oracle Data Integrator (ODI)
Data Warehouse: Oracle Database
Reporting Tool: Oracle Analytics [/vc_column_text][/vc_column][/vc_row][/vc_section][vc_row full_width=”stretch_row” equal_height=”yes” content_placement=”middle” css=”.vc_custom_1764838103577{margin-top: 0px !important;margin-bottom: 0px !important;padding-top: 35px !important;padding-bottom: 75px !important;background-color: #ffffff !important;background-position: center !important;background-repeat: no-repeat !important;background-size: cover !important;}”][vc_column width=”1/3″ css=”.vc_custom_1531997568277{margin-top: 0px !important;margin-bottom: 10px !important;padding-top: 0px !important;padding-bottom: 0px !important;}”][/vc_column][vc_column width=”1/3″][vc_column_text css=”.vc_custom_1764838083050{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]
DiLytics Delivers
[/vc_column_text][/vc_column][vc_column width=”1/3″][vc_custom_heading text=”View all Success Stories →” font_container=”tag:h6|font_size:16px|text_align:right|color:%23dd3333|line_height:26px” use_theme_fonts=”yes” css=”.vc_custom_1660717315754{margin-top: 0px !important;margin-bottom: 10px !important;}” el_class=”font-weight-medium” link=”url:https%3A%2F%2Fdilytics.com%2Fsuccess-stories%2F|title:Success%20Stories”][/vc_column][vc_column css=”.vc_custom_1661424713241{margin-bottom: 25px !important;}”][rt_case_study_style case_study_style_variation=”seven” case_study_display_filter=”no” case_study_enable_title=”yes” case_study_enable_excerpt=”yes” case_study_spacing=”30″ case_study_looping_sort=”ASC” no_of_case_studies=”3″][/vc_column][/vc_row]