IT Billing Application – Fortune 10

IT Billing Application – Fortune 10 Company Case Study

Hariworld Travels is an influential and respected flight ticket consolidator, headquartered in the US, who provide travel professionals access to millions of fares to Europe, Asia, Africa, South America and beyond. The client needed an B2B eBusiness site to connect travel agents with the Airline and Hotel booking engine.

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.