[et_pb_section fb_built=”1″ admin_label=”Page Title Section” _builder_version=”4.4.8″ background_enable_color=”off” use_background_color_gradient=”on” background_color_gradient_start=”#4facfe” background_color_gradient_end=”#00f2fe” background_color_gradient_direction=”34deg” background_color_gradient_start_position=”13%” background_color_gradient_overlays_image=”on” background_image=”https://radiare.com/demo/wp-content/uploads/2020/06/risk-33-scaled.jpg” background_blend=”multiply” background_enable_video_mp4=”off” custom_padding=”120px||1px|||”][et_pb_row admin_label=”Page Title Area” _builder_version=”3.25″ background_size=”initial” background_position=”top_left” background_repeat=”repeat”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” custom_padding__hover=”|||”][et_pb_text admin_label=”Page Title” _builder_version=”4.4.8″ text_font=”Montserrat||||||||” text_text_color=”#ffffff” text_font_size=”18px” text_line_height=”2em” header_font=”Montserrat|600|||||||” header_font_size=”60px” header_line_height=”1.6em” header_3_font=”Montserrat||||||||” header_3_line_height=”1.8em” text_orientation=”center” background_layout=”dark” max_width=”700px” module_alignment=”center” custom_margin=”||10px|” animation_style=”fade” header_font_size_tablet=”40px” header_font_size_phone=”” header_font_size_last_edited=”on|desktop”]

 Case Study

Data Mart & MIS Reporting Implementation

[/et_pb_text][et_pb_post_nav in_same_term=”on” prev_text=”Previous Case Study” next_text=”Next Case Study” _builder_version=”4.4.8″ title_font=”Montserrat|600||on|||||” custom_padding=”10px|10px|10px|10px|true|true” border_radii=”on|1px|1px|1px|1px” border_color_all=”#f29900″][/et_pb_post_nav][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section fb_built=”1″ admin_label=”Quote Section” _builder_version=”3.22″ custom_padding=”1px|0px|1px|0px||” border_color_all=”rgba(255,186,96,0.6)” border_width_right=”8vw” custom_margin=”|-74px||||”][et_pb_row column_structure=”3_4,1_4″ admin_label=”Quote Area” _builder_version=”3.25″ use_custom_width=”on”][et_pb_column type=”3_4″ _builder_version=”3.25″ custom_padding=”|||” custom_padding__hover=”|||”][et_pb_text admin_label=”Author Name” _builder_version=”4.4.8″ text_font=”Montserrat|700||on|||||” text_text_color=”#f29900″ text_letter_spacing=”4px” header_font=”Montserrat|600|||||||” header_4_font=”||||||||” module_alignment=”center” animation_style=”slide” animation_direction=”bottom” animation_intensity_slide=”10%” animation_starting_opacity=”100%” hover_enabled=”0″]

– Case Description

[/et_pb_text][et_pb_text _builder_version=”3.27.4″ text_font=”Roboto Slab||||||||” text_font_size=”17px” text_letter_spacing=”1px” text_line_height=”1.8em” header_font=”||||||||” header_3_font=”||||||||” header_3_line_height=”1.6em” header_4_font=”||||||||” custom_margin=”|||” custom_padding=”|||30px” animation_style=”flip” animation_intensity_flip=”5%” animation_starting_opacity=”100%” border_color_all=”#313e47″ border_width_left=”10px”]

Customer has grown through multiple acquisitions and has led to proliferation of different source systems for POS, Inventory, Purchase, Warehouse thereby not able to provide a single view of: Sales, Profitability, Spend Analysis, Inventory. Project was executed over a period of 3 months in an onsite-offshore model with 3 onsite and 6 member offshore team (peak size).

[/et_pb_text][/et_pb_column][et_pb_column type=”1_4″ _builder_version=”3.25″ custom_padding=”|||” custom_padding__hover=”|||”][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section fb_built=”1″ admin_label=”Project Analysis Section” _builder_version=”3.22″ custom_padding=”0px||90px|||”][et_pb_row column_structure=”1_4,3_4″ admin_label=”Project Analysis Area” _builder_version=”3.25″ custom_padding=”60px|0px|0px|0px||” border_color_all=”rgba(51,51,51,0.12)” border_width_top=”1px”][et_pb_column type=”1_4″ _builder_version=”3.25″ custom_padding=”|||” custom_padding__hover=”|||”][et_pb_text admin_label=”Title” _builder_version=”4.4.8″ text_font=”||||||||” header_font=”||||||||” header_3_font=”Montserrat|600|||||||” header_3_line_height=”2em” animation_style=”fold” animation_direction=”left” animation_intensity_fold=”5%” hover_enabled=”0″ header_3_text_color=”#f29900″]

Business Benefits

[/et_pb_text][/et_pb_column][et_pb_column type=”3_4″ _builder_version=”3.25″ custom_padding=”|||” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.27.4″ text_font=”||||||||” text_font_size=”16px” text_line_height=”2em” animation_style=”fade” custom_padding=”||2px|||”]

  • Identification of $15 Million worth of dead inventory
  • Enabled finance to do month end closing in less than 2 weeks, first time in years

Phase 1 of the implementation involved addressing the Sales, Purchase and Inventory Requirements. Radiare took complete end-to-end ownership in building the data mart, MIS reporting & supporting the data loads.

[/et_pb_text][/et_pb_column][/et_pb_row][et_pb_row column_structure=”1_4,3_4″ admin_label=”Final Result Area” _builder_version=”3.25″ custom_padding=”0px|0px|1px|0px||” border_color_all=”rgba(51,51,51,0.12)” border_width_top=”1px”][et_pb_column type=”1_4″ _builder_version=”3.25″ custom_padding=”|||” custom_padding__hover=”|||”][et_pb_text admin_label=”Title” _builder_version=”4.4.8″ text_font=”||||||||” header_font=”||||||||” header_3_font=”Montserrat|600|||||||” header_3_line_height=”2em” animation_style=”fold” animation_direction=”left” animation_intensity_fold=”5%” header_3_text_color=”#f29900″]

Result

[/et_pb_text][/et_pb_column][et_pb_column type=”3_4″ _builder_version=”3.25″ custom_padding=”|||” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.27.4″ text_font=”||||||||” text_font_size=”16px” text_line_height=”2em” header_font=”||||||||” animation_style=”fade”]

The Key areas that were delivered as part of the Project Implementation include:

  • Data Mart Development
  • Creation of Data Models for Sales/Purchase and Inventory Data Marts
  • Data Integration from various source systems such as HAYAT, FALCON, WAGDY, KHUNAINY, FPOS among others.
  • Building of Reports for Sales/Purchase and Inventory
  • Running Month-end reporting to address areas such as Weighted Average Cost, Gross Margin per Item among others
  • Support Daily Data Load from various source systems
  • Consolidated Operational Reporting like Daily Sales summary, Current Inventory etc across all systems
  • Historical and analytical reporting – Worst and Best performing pharmacies, relative pharmacy performance in terms of sales returns, Promotion effectiveness – from star schema based model

[/et_pb_text][/et_pb_column][/et_pb_row][et_pb_row column_structure=”1_4,3_4″ admin_label=”Final Result Area” _builder_version=”3.25″ custom_padding=”3px|0px|0px|0px||” border_color_all=”rgba(51,51,51,0.12)” border_width_top=”1px”][et_pb_column type=”1_4″ _builder_version=”3.25″ custom_padding=”|||” custom_padding__hover=”|||”][et_pb_text admin_label=”Title” _builder_version=”4.4.8″ text_font=”||||||||” header_font=”||||||||” header_3_font=”Montserrat|600|||||||” header_3_line_height=”2em” animation_style=”fold” animation_direction=”left” animation_intensity_fold=”5%” header_3_text_color=”#f29900″]

Technology Areas

[/et_pb_text][/et_pb_column][et_pb_column type=”3_4″ _builder_version=”3.25″ custom_padding=”|||” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.27.4″ text_font=”||||||||” text_font_size=”16px” text_line_height=”2em” header_font=”||||||||” animation_style=”fade”]

Informatica 8.6.1, Microstrategy 9 and Oracle 10g

    [/et_pb_text][/et_pb_column][/et_pb_row][et_pb_row column_structure=”1_4,3_4″ admin_label=”Final Result Area” _builder_version=”3.25″ custom_padding=”0px|0px|0px|0px||” border_color_all=”rgba(51,51,51,0.12)” border_width_top=”1px”][et_pb_column type=”1_4″ _builder_version=”3.25″ custom_padding=”|||” custom_padding__hover=”|||”][et_pb_text admin_label=”Title” _builder_version=”4.4.8″ text_font=”||||||||” header_font=”||||||||” header_3_font=”Montserrat|600|||||||” header_3_line_height=”2em” animation_style=”fold” animation_direction=”left” animation_intensity_fold=”5%” header_3_text_color=”#f29900″]

    Client

    [/et_pb_text][/et_pb_column][et_pb_column type=”3_4″ _builder_version=”3.25″ custom_padding=”|||” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.27.4″ text_font=”||||||||” text_font_size=”16px” text_line_height=”2em” header_font=”||||||||” animation_style=”fade”]

    Large Pharmacy Retailer based out of Saudi Arabia.

    [/et_pb_text][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section fb_built=”1″ admin_label=”Contact Form Section” _builder_version=”4.4.8″ background_enable_color=”off” use_background_color_gradient=”on” background_color_gradient_start=”#4facfe” background_color_gradient_end=”#00f2fe” background_color_gradient_direction=”34deg” background_color_gradient_start_position=”13%” background_color_gradient_overlays_image=”on” background_enable_image=”off” background_blend=”multiply” background_enable_video_mp4=”off” custom_padding=”0px|0px|0px|0px” animation_style=”zoom” animation_intensity_zoom=”4%” saved_tabs=”all”][et_pb_row admin_label=”Service Section Title” _builder_version=”3.25″ custom_margin=”||40px|” custom_padding=”80px|||||” animation_style=”fade” animation_direction=”top” locked=”off”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” custom_padding__hover=”|||”][et_pb_text admin_label=”Title” _builder_version=”4.4.8″ text_font=”Montserrat||||||||” text_text_color=”#747d88″ text_font_size=”16px” text_line_height=”1.9em” header_font=”||||||||” header_text_color=”#ffffff” header_2_font=”Montserrat|700|||||||” header_2_text_color=”#ffffff” header_2_font_size=”42px” header_2_line_height=”1.3em” background_size=”initial” background_position=”top_left” background_repeat=”repeat” text_orientation=”center” max_width=”700px” module_alignment=”center” animation_style=”slide” animation_direction=”bottom” animation_intensity_slide=”4%”]

    Let’s Start Something new
    Say Hello!

    [/et_pb_text][/et_pb_column][/et_pb_row][et_pb_row _builder_version=”4.4.8″ min_height=”135px” custom_margin=”-81px|auto||auto||”][et_pb_column type=”4_4″ _builder_version=”4.4.8″][et_pb_button button_url=”@ET-DC@eyJkeW5hbWljIjp0cnVlLCJjb250ZW50IjoicG9zdF9saW5rX3VybF9wYWdlIiwic2V0dGluZ3MiOnsicG9zdF9pZCI6IjQwMjEifX0=@” button_text=”Contact Us” button_alignment=”center” _builder_version=”4.4.8″ _dynamic_attributes=”button_url” custom_button=”on” button_text_size=”20px” button_bg_color=”#ffffff” button_border_width=”0px” button_border_color=”rgba(0,0,0,0)” button_border_radius=”6px” button_font=”Montserrat||||||||” button_icon=”%%3%%” custom_margin=”0px||||false|false” custom_padding=”12px|32px|12px|32px|true|true”][/et_pb_button][/et_pb_column][/et_pb_row][/et_pb_section]