[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_1765188314008{margin-top: 0px !important;margin-bottom: 0px !important;padding-top: 40px !important;}”][vc_column css=”.vc_custom_1765188277847{margin-top: 10px !important;padding-top: 0px !important;padding-bottom: 0px !important;}”][vc_column_text css=”.vc_custom_1765188197488{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]

Business Intelligence Enhancements Improved Financial Management

[/vc_column_text][vc_column_text css=”.vc_custom_1765185720411{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]The client is a state government agency in one of the states in the USA. The agency operates a state-wide financial system to enable the state to perform budgeting, procurement, cash management, and accounting functions transparently and efficiently, thus eliminating the need for hundreds of independent legacy systems.[/vc_column_text][vc_column_text css=”.vc_custom_1765186174558{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]

The Challenge

[/vc_column_text][vc_column_text css=”.vc_custom_1765186644212{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]The client required Subject Matter Experts in the areas of Oracle Business Intelligence Enterprise Edition (OBIEE), Microsoft’s Power BI and Hyperion systems. SMEs were needed to support the design, development, implementation and maintenance of an enhanced business intelligence (BI) solution. The main challenge was to transfer Data from FI$Cal PeopleSoft and Hyperion applications to Oracle Data Warehouse and Azure Synapse Analytics platforms using data integration tools like Oracle Data Integrator (ODI), Oracle Golden Gate (OGG), Azure Data Factory (ADF). [/vc_column_text][vc_column_text css=”.vc_custom_1765188351719{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]

DiLytics’ Solution

[/vc_column_text][vc_column_text css=”.vc_custom_1765186759643{margin-top: 0px !important;margin-bottom: 10px !important;}”]DiLytics provided day-to-day support and enhancement services which included:[/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_1765186814074{margin-top: -5px !important;margin-bottom: 35px !important;padding-left: 35px !important;}” list_extra_class=”text-block”]

• Capturing and reviewing reporting requirements and determining implementation options.
• Planning the tasks for enhancing the BI solution using the recommended option and communicating with all stakeholders.
• Designing, developing, and testing BI solutions to support the reporting needs.
• Implementing and supporting BI solutions using Oracle Business Intelligence Enterprise Edition (OBIEE), Microsoft Power BI, Microsoft Azure Synapse, and Hyperion.
• Using integration tools such as Oracle Data Integrator (ODI), Oracle Golden Gate (OGG), and Azure Data Factory (ADF) to Extract, Load, and Transform data.
• Implementing security at various levels such as Business Unit and row-level security, dashboard, and shared reports.
• Troubleshooting performance issues and tuning queries.
• Implementing load plans and schedules to support Incremental/Full loads.
• Designing and developing semantic models, dashboards, interactive visualizations, paginated reports, and self-service analytics solutions on OBIEE and/or Power BI platforms.
• Updating OBIEE data warehouse to analyze current inventory costs.
• Mentoring development staff on the BI solution

[/rt_list_style][vc_column_text css=”.vc_custom_1765186846355{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]

Business Benefits

[/vc_column_text][vc_column_text css=”.vc_custom_1765859939950{margin-top: 0px !important;margin-bottom: 10px !important;}” el_class=”text-block”]Key business benefits to the client included:[/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_1765188382674{margin-top: 0px !important;margin-bottom: 35px !important;padding-left: 35px !important;}” list_extra_class=”text-block”]

• Lower Total Cost of Operation (TCO) with modernized and re-engineered financial business operations of the state government on an enterprise-wide basis
• Improved financial management and enhanced transparency via technological business transformation that combined accounting, budgeting, cash management, and procurement operations into a single integrated financial management system
• High level of standardization of business processes that eliminate the need for redundant manual input, and time-consuming reconciliations and increased accuracy, timeliness, and flexibility of data reporting

[/rt_list_style][vc_column_text css=”.vc_custom_1765187180498{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]

Technical Stack

[/vc_column_text][vc_column_text css=”.vc_custom_1765187287987{margin-top: 0px !important;margin-bottom: 0px !important;}” el_class=”text-block”]Source Systems: PeopleSoft and Hyperion 

Data Integration Tools: Oracle Data Integrator (ODI), Oracle Golden Gate (OGG), Azure Data Factory (ADF) 

Data Warehouse: Oracle Data Warehouse and Azure Synapse Analytics 

Reporting Tools: Power BI, 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_1684237429473{margin-top: 0px !important;margin-bottom: 0px !important;padding-top: 35px !important;padding-bottom: 35px !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_1765187352691{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]