[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_1767769988408{margin-top: 0px !important;margin-bottom: 0px !important;padding-top: 40px !important;}”][vc_column css=”.vc_custom_1767769971442{margin-top: 10px !important;padding-top: 0px !important;padding-bottom: 0px !important;}”][vc_column_text css=”.vc_custom_1767769954849{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]
Material Requirement Planning Analytics Led to Improved Production Efficiency
[/vc_column_text][vc_column_text css=”.vc_custom_1767768990860{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]Established in 1997, the client is a world leader in developing and commercializing first-or-best-in-class therapies for rare genetic diseases. Headquartered in California, US, the client has operations spread across 20+ countries and has 2500+ employees worldwide. [/vc_column_text][vc_column_text css=”.vc_custom_1767770173640{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]
Background
[/vc_column_text][vc_column_text css=”.vc_custom_1767770200339{margin-top: 0px !important;margin-bottom: 20px !important;}” el_class=”text-block”]The customer was facing a challenge with respect to determining which raw material needs replenishment and hence needs to be ordered, when to be ordered, in what quantity, and when the delivery of the order should be scheduled.[/vc_column_text][vc_column_text css=”.vc_custom_1767770242440{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]In addition, the customer also wanted information that would help it to identify what raw material items will create a production shortage, what raw material items in quarantine should be released and by when, and what raw material items should be called from the local warehouse in order to release it on time for the next production work order.
[/vc_column_text][vc_column_text css=”.vc_custom_1767769248627{margin-top: 0px !important;margin-bottom: 20px !important;}” el_class=”text-block”]
DiLytics’ Solution
[/vc_column_text][vc_column_text css=”.vc_custom_1767769214834{margin-top: 0px !important;margin-bottom: 10px !important;}” el_class=”text-block”]DiLytics extended the current reporting solution in Oracle Analytics by:[/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_1767769276658{margin-top: -5px !important;margin-bottom: 20px !important;padding-left: 35px !important;}” list_extra_class=”text-block”]
- Creating new tables and adding columns to existing tables in Enterprise Data Warehouse (EDW)
- Developing ETL code using Informatica to extract data required for MRP Analytics reporting from EBS into EDW staging tables
- Developing ETL code using Informatica to load data required for MRP Analytics reporting from the EDW staging tables into Facts and dimensions
- Modeling the extended EDW tables in Oracle Analytics to create metrics and attributes
[/rt_list_style][vc_column_text css=”.vc_custom_1767769376246{margin-top: 0px !important;margin-bottom: 20px !important;}” el_class=”text-block”]DiLytics implemented a solution on Oracle Analytics that involved:[/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_1767769484060{margin-bottom: 35px !important;padding-left: 35px !important;}” list_extra_class=”text-block”]
- Items with BOH Below Safety stock
- Need by to Promise date PO
- OTD to Promise date PO
- Past Due PO Confirmation
- Past Due PO
- Past Due RM QA Release
- Planned Orders Compression Lead Time
- PO Lines created from MRP
- PO Reschedule In-Out
- Production Shortage Dashboard
[/rt_list_style][vc_column_text css=”.vc_custom_1767769571649{margin-top: 0px !important;margin-bottom: 20px !important;}” el_class=”text-block”]
Business Benefits
[/vc_column_text][vc_column_text css=”.vc_custom_1767769602432{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_1767769731777{margin-bottom: 35px !important;padding-left: 35px !important;}”]
- Improved inventory control via better scheduling and ordering for raw material items
- Increased production efficiency
[/rt_list_style][vc_column_text css=”.vc_custom_1767769768567{margin-top: 0px !important;margin-bottom: 20px !important;}” el_class=”text-block”]
Technical Stack
[/vc_column_text][vc_column_text css=”.vc_custom_1767769844680{margin-top: 0px !important;margin-bottom: 0px !important;}” el_class=”text-block”]Source Systems: Oracle EBS, Oracle ASCP
Data Integration Tool: Informatica
Data Warehouse: Oracle Business Analytics Warehouse
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_1767769896120{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_1767769881136{margin-top: 0px !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]