Scroll Top
Information technology systems
0
By Charisma Burghouts Case Study February 12, 2019

IT Billing Application – Fortune 10 Company Case Study

[image_with_animation image_url=”11706″ alignment=”center” animation=”Fade In” hover_animation=”none” border_radius=”none” box_shadow=”none” image_loading=”default” max_width=”50%” max_width_mobile=”default” img_link=”https://staging.sdgc.com/wp-content/uploads/IT_Billing_Application_Fortune_10.pdf” margin_bottom=”20″][ult_buttons btn_title=”Download Case Study” btn_link=”url:https%3A%2F%2Fwww.sdgc.com%2Fwp-content%2Fuploads%2FIT_Billing_Application_Fortune_10.pdf|||” btn_align=”ubtn-center” btn_title_color=”#ffffff” btn_bg_color=”#69d72d” icon_size=”32″ btn_icon_pos=”ubtn-sep-icon-at-left” btn_font_style=”font-weight:bold;” btn_font_size=”desktop:18px;”]

This large conglomerate needed a more efficient process for cross-charging businesses internally for IT Services provided by Corporate and In-Network Vendors. They were using multiple legacy systems for storing customer billing records, determining the billing rates associated with the billing records, calculating the cost for each billing record, and aggregating these records periodically to generate invoices

Services Include:

[text-with-icon icon_type=”image_icon” icon_image=”11567″]

Providing solution architecture:

  • Functional analysis
  • IT system specification
  • Logical & physical data modeling

[/text-with-icon]

[text-with-icon icon_type=”image_icon” icon_image=”11562″]

End to end solution designing & deployment

[/text-with-icon]

[text-with-icon icon_type=”image_icon” icon_image=”11569″]

Business logic development using PL/SQL (Stored Procedure & functions & triggers etc.)

[/text-with-icon]

[text-with-icon icon_type=”image_icon” icon_image=”11563″]

Ensure data integrity and re-usability

[/text-with-icon]

[text-with-icon icon_type=”image_icon” icon_image=”11566″]

Data migration from SQL Server 2000 to Oracle 12c RDS

[/text-with-icon]

[text-with-icon icon_type=”image_icon” icon_image=”11566″]

Project support and maintenance

[/text-with-icon]

Tools & Technologies:

[text-with-icon icon_type=”image_icon” icon_image=”11593″]

Java JDK 1.6 Eclipse

[/text-with-icon]

[text-with-icon icon_type=”image_icon” icon_image=”11593″]

Oracle 12C AWS RDS

[/text-with-icon]

[text-with-icon icon_type=”image_icon” icon_image=”11593″]

PL/SQL

[/text-with-icon]

[text-with-icon icon_type=”image_icon” icon_image=”11593″]

Spring framework 4.0.1

[/text-with-icon]

[text-with-icon icon_type=”image_icon” icon_image=”11593″]

JBOSS 6.2 EAP

[/text-with-icon]

[text-with-icon icon_type=”image_icon” icon_image=”11593″]

Apache web server 2.4.12

[/text-with-icon]

[text-with-icon icon_type=”image_icon” icon_image=”11593″]

iText 5

[/text-with-icon]

[text-with-icon icon_type=”image_icon” icon_image=”11593″]

HTML 5

[/text-with-icon]

[text-with-icon icon_type=”image_icon” icon_image=”11593″]

Highcharts

[/text-with-icon]

[text-with-icon icon_type=”image_icon” icon_image=”11593″]

Jenkins

[/text-with-icon]

SDG Solution

[icon_timeline timeline_line_color=”#425b76″ time_block_bg_color=”#f7f7f7″ time_sep_color=”#000000″ time_sep_bg_color=”#69d72d” tl_animation=”tl-animation-shadow” timeline_margin=”margin-right:5px;margin-left:5px;”][icon_timeline_item title_font_color=”#333333″ desc_font_color=”#333333″ desc_font_size=”desktop:17px;tablet:17px;tablet_portrait:17px;mobile_landscape:15px;mobile:15px;”]

Implementation of an integrated system with custom modules

[/icon_timeline_item][icon_timeline_item title_font_color=”#333333″ desc_font_color=”#333333″ desc_font_size=”desktop:17px;tablet:17px;tablet_portrait:17px;mobile_landscape:15px;mobile:15px;”]

Dynamic user roles & authorization along with SSO Open ID integration

[/icon_timeline_item][icon_timeline_item title_font_color=”#333333″ desc_font_color=”#333333″ desc_font_size=”desktop:17px;tablet:17px;tablet_portrait:17px;mobile_landscape:15px;mobile:15px;”]

Writing custom algorithms for business processes

[/icon_timeline_item][icon_timeline_item title_font_color=”#333333″ desc_font_color=”#333333″ desc_font_size=”desktop:17px;tablet:17px;tablet_portrait:17px;mobile_landscape:15px;mobile:15px;”]

Enabled analytics using various reports & charts

[/icon_timeline_item][icon_timeline_item title_font_color=”#333333″ desc_font_color=”#333333″ desc_font_size=”desktop:17px;tablet:17px;tablet_portrait:17px;mobile_landscape:15px;mobile:15px;”]

Improved system auditing

[/icon_timeline_item][/icon_timeline]

Results

[nectar_icon_list animate=”true” color=”Accent-Color” direction=”vertical” icon_size=”small” icon_style=”border”][nectar_icon_list_item icon_type=”numerical” title=”List Item” id=”1722525536755-7″ tab_id=”1722525536755-5″ text=”Centralized customer and billing data repository for establishing a single version of truth and improved analysis of customer dynamics”] [/nectar_icon_list_item][nectar_icon_list_item icon_type=”numerical” title=”List Item” id=”1722525536810-2″ tab_id=”1722525536810-7″ text=”Reduced manual effort by enabling auto-generation and sending of periodic invoices”] [/nectar_icon_list_item][nectar_icon_list_item icon_type=”numerical” title=”List Item” id=”1722525536850-10″ tab_id=”1722525536850-6″ text=”Improved user experience and processes”][/nectar_icon_list_item][/nectar_icon_list]
[ult_buttons btn_title=”Download Case Study Here” btn_link=”url:https%3A%2F%2Fwww.sdgc.com%2Fwp-content%2Fuploads%2FIT_Billing_Application_Fortune_10.pdf|||” btn_title_color=”#ffffff” btn_bg_color=”#69d72d” icon_size=”32″ btn_icon_pos=”ubtn-sep-icon-at-left” btn_font_style=”font-weight:bold;” btn_font_size=”desktop:18px;”]

About SDG

SDG is a global cybersecurity, identity governance, risk consulting, and advisory firm that advises and partners with clients to address their complex security, compliance, and technology needs and delivers on strategy, transformation, and long-term management of their cybersecurity and IAM programs.

Charisma Burghouts / About Author
More posts by Charisma Burghouts