IT Billing Application – Fortune 10

IT Billing Application – Fortune 10 Company Case Study

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:

Providing solution architecture:

Functional analysis
IT system specification
Logical & physical data modeling

End to end solution designing & deployment

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

Ensure data integrity and re-usability

Data migration from SQL Server 2000 to Oracle 12c RDS

Project support and maintenance

Tools & Technologies:

Java JDK 1.6 Eclipse

Oracle 12C AWS RDS

PL/SQL

Spring framework 4.0.1

JBOSS 6.2 EAP

Apache web server 2.4.12

iText 5

HTML 5

Highcharts

Jenkins

SDG Solution

Implementation of an integrated system with custom modules

Dynamic user roles & authorization along with SSO Open ID integration

Writing custom algorithms for business processes

Enabled analytics using various reports & charts

Improved system auditing

Results

Centralized customer and billing data repository for establishing a single version of truth and improved analysis of customer dynamics

Reduced manual effort by enabling auto-generation and sending of periodic invoices

Improved user experience and processes

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.