Case Study 1 - FORD Asia Pacific

Overview

The advent of the Internet sees entire organizations being integrated and streamlined, with the potential result of bringing hundreds of thousands of users online -employees, business partners and customers to access and share the latest information. These new environments create new requirements in terms of scalability and performance that go beyond the needs of more traditional applications. The Multilingual Ford Bulletin Board system was one such application that was a single point application that Ford owner connection portal registered users from different countries and regions could use and would see the bulletin board in their own local language.

The Challenge

Bharatplanet has very strong technical expertise in building multilingual applications that can be gauged by the fact that it has custom built a standard’s based generic Phonetic engine that can currently transliterate English into 8 major Indian languages. This module can be used as a plugin with virtually in building any kind of an application say ranging form a word processor to an instant messenger. With its strong foothold in Multilingual technologies bharatplanet was easily able to understand and execute fords requirements with an Oracle database driven single application being capable of supporting multiple languages including Chinese, Japanese, and Taiwanese.

The Solution

The Ford Bulletin board is an application where users of Ford vehicles meet and discuss about Ford cars and topics related to Ford. The basic idea is that one person makes a discussion board post in one of the boards. Another person who is also interested in the conversation then responds to the message. More people read these posts and join in the conversation. Each discussion board is like a mini town hall where lots of people come together and talk about something that interests them.

This will serve as an electronic community board for users. Only registered users of the site will be able to access the forum .The discussions are separated by country and language. The users will be shown only the discussions pertaining to their country and language .The administrators would be distributed Marketwise and their rights will be limited to their specific market.

All information regarding Markets, Languages, Market schema, Conferences, Forums, Individual Topics is created and controlled by the admin module of the forum application .The admin module will have interfaces to add language, market and more admin users.

The admin part has user level based access, which demands that the Admin User essentially be one of the following.

Moderator

Any Ford user logged into the ford site can access the Bulletin board corresponding to his market and language passed to the Bulletin board application by the OC application. The user is identified by a unique sGUID available via cookies to the Bulletin board application.

The main menu of the Bulletin board will have a list of all Conferences and the forums under each conference. Option to view conference and forum description is available to the user. In addition the user will also be able to see the no of topics under each forum and the total no of replies.

The Bulletin Board supports input and display of Multi language text e.g. Chinese, Japanese, Vietnamese

Case Study 2 - NetConnect WBCI

Overview

The client is a leading financial services provider with a track record of outstanding business milestones.

Existing System

The benefit that NetConnect has added to its Service chat is considerable saving of cost/time from live internet chat service as the support/queries from the customers can be solved online. This system has been part of the Customer Relationship Management to provide better solutions to the customers in short span of time.

The Technology

The daunting task ahead of BharatPlanet was that the business data was not exposed through application APIs and the fact that there were different data models across Applications.

As an end-to-end business process integration solution BharatPlanet undertook Product customization, Legacy analysis and mapping to Oracle apps using Oracle methodology and Compatibility with existing back-office Oracle applications, which cater to the query-processing engine. All this was achieved using Standards based technical architecture.

The utilization of Cache Fusion in Oracle9i enabled us to take advantage of the scalability provided by Oracle9i Real Application Clusters, with little or no performance cost. This means that the client can horizontally scale the database tier as usage and demand continues to grow. This means that for the first time a cluster can be treated as a truly scalable single system, providing transparent scalability for all applications. Additionally, cluster load balancing features enable large number of user connections to be automatically and transparently distributed among cluster nodes, making optimal use of the overall cluster processing capabilities. Pipelining and parallel execution of table functions helps to improving the performance and scalability of a number of applications. In the data warehouse environment, table functions have been used in the ETL (Extraction-Transformation-Load) process that builds a data warehouse by extracting data from an OLTP system.

The use of Oracle9i Enterprise Java Engine (EJE) Accelerator, a native compiler, has helped perform more advanced code optimization at runtime.

With OCI connection pooling, OCI clients share a pool of database connections and increasing number of clients can be supported by the database with fewer connections.

We have written a micro Adapter for the Oracle database, which enables the Net connect server program to link to Oracle Applications. The micro Adapter validates the incoming service request, transforms the data into an Oracle interface table format, populates the interface table, and invokes the appropriate interface programs to complete the request. This enables the client application to access the Oracle Application using the micro Adapter for Oracle. BharatPlanet also ensured sophisticated security for users of system, Banking information and back end systems including integration with the Talisma Email engine, which again uses Oracle as its backend.

Though this could also have been done with the traditional approach the major drawback that application upgrades could result in significant redevelopment effort for the integration has been averted by this business rules based configurable solution. We have with our rich expertise in Oracle based applications delivered a productized, configurable integration solution to automate business processes spanning best of breed applications in the extended enterprise, running on the customer’s middleware platform of choice.

Case Study 3 - Institute of Chartered Accountants

Overview

The Institute of Chartered Accountants of India was established on 1st July, 1949 by "The Chartered Accountants Act, 1949", for the purpose of regulating the profession of Chartered Accountants in India. The affairs of Institute are managed and the functions assigned to the Institute are discharged by a Council comprising of 24 members elected by the members of the Institute all over the country and 6 persons nominated by the Central Government. The Institute conducts a course called ISA (Information Systems Audit) for the members. The Course comprises of

1. Application Process
2. Professional Training
3. Eligibility Test &
4. Assessment Test

Existing System

Inability to provide quick customer service

The challenge

1. Complete automation of the processes from application to issue of ET certificates
2. Administration module to control all the processes
3. Exhaustive Administrative interface & MIS reports.

The Solution

This system aims at completely automating the ISA course right from the stage a participant registers for the course, Application approval, Allotment of ISA Registration no, Scheduling of Professional Training Sessions, Attendance Reporting, Scheduling of Eligibility Tests, Test Score Reporting, Intimation to participants about the Schedules through automated emails and the web interface, Eligibility of Participants for Assessment Test among other features.

1) Registration Module

a) Conversion of the Application in Email format to a meaningful Database format.
b) Administrative interface to Approve/Reject Application forms and assign ISA Registration no.
c) Automated email to Applicants on Application status.
d) Interface for applicants to view status of the application, payment details and allotment of ISA Registration no.
e) This module provides the administrator with total control over the application process and reduces time spent on manually processing of the application.
f) Online Data Entry Module – For application hardcopies only
g) Validity checking of functional email id
h) Update Application form feature
i) Online dispatch of ISA Registration Letter
j) MIS Reports.

2) Usage Module

a) Select PT Center Feature for participants whose center detail is unknown
b) PT Schedule Listing – As and when PT Schedule is added
c) PT Guidelines & Instructions
d) Co-Participant List & Messaging
e) User Group Facility
f) Ron-Weber Book, Study Material ( Dispatch confirmation and receipt date confirmation)
g) Manage mentor Usage, ROSM( Dispatch confirmation and receipt date confirmation)
h) Contact Administrator ( Query based dispatch of email to concerned administrator)
i) View ET Schedule( Only for PT Completed Participants)
j) ET Application – Form A – Only for Current Batch of PT Participants ( Allowed only once per participant)
k) ET Application – Form B – Only for Practice tests (Submission allowed only once per quarter)
l) ET Application – Form C - ET Failed (Submission allowed only once per quarter)
m) ET Application – Form D – AT failed (Submission allowed only once per quarter)
n) Downloadable ET Admit card with candidate photograph ( if available) – Download allowed only twice for one ET Schedule
o) ET Results – Result publication after ET scores and performance analysis are updated by Administrator
p) ET Query – Venue, ET Roll no, ET Result Declaration, ET Schedule, ET Admit card

3) Administration Module

An intuitive and easy to use web based administration module with access based on user rights. The administration module based on user level access is classified into the following

Region administrator

a) Module administration to facilitate Eligibility test schedule.
b) Payment information Administration.
c) Professional Training Schedule addition and administration center wise with centralized approval by Administrator.
d) Add Participant’s Attendance
e) Eligibility Test & Eligibility List
f) Eligibility Test Schedule Administration.
g) Add ET Score – Test A , Test B, Test C, Test D, Performance Analysis on an individual basis ( Bulk update is through database updating by exporting from an excel file in the format – ISA no , Name. test 1 score, test 2 score, test 3 score, test 4 score , Performance)
h) View/Update Eligibility Test Score details
i) Online Dispatch of ET Test scores as email to participants
j) Add AT Schedule
k) Add AT Score
l) Ron Weber Book dispatch
m) Managementor release Update
n) ROSM release Update
o) Study Material Dispatch update
p) PT Completion Certificate Update
q) PT Eligibility List
r) Participant List
s) ET Application Approval
t) ET Application Online Data Entry – Form A , B, C, D
u) Exhaustive MIS reports regarding ISA program and participants.
v) Profile Update administration and automated emails to participants on profile update status

Center administrator

a) Professional Training session Attendance reporting.
b) Information on PT & ET Schedule center wise.
c) Eligibility Test Scores reporting.
d) Assessment Test Eligibility for Participants.
e) MIS reports

4) Automated reply to communication through templates requesting for PT center change, registration and profile updates.

Case Study 4 - TTK E-commerce Portal

Overview

TTK Services (http://www.ttkbharatplanet.com/), is a pioneer in bringing out innovative and user-friendly services for Non Resident Indians living in the US and the UK.

The Problem

TTK knew from the start that they had to have a robust, open ended web application for their web based NRI services which runs into different fronts including Healthcare, Insurance, Messaging services, a novel gifting service, Legal Services, Property Management and Travel Services. Time was limited, start from scratch was out of question as BharatPlanet had already developed all core modules prior to merger, and the need was for a provider that could help them integrate with the Oracle database and conform to internal quality and people processes that were being put in place.

The Solution

TTK chose BharatPlanet because it had already gone through the process of business discovery, implementation, strategy formulation, development and deployment of the parent application, its integration with Oracle and because they already had the skill sets required to hit the ground running. TTK could leverage on the built in security framework and user management in the parent application for getting a huge jump-start on the application development. This enabled them to concentrate on the front-end look and feel of the application. BharatPlanet developed additional modules that provide transaction and concurrency management, built in security, and dozens of other features that led to the creation of a world class web application coupled to the face that it was seamlessly integrated with an Oracle backend. The Table API packages that BharatPlanet chipped in with also acted as an excellent interface for converting legacy data. This helped finish development of the application in a matter of months.

BharatPlanet now maintains the whole application for TTK and provides the following services

Post Implementation Maintenance and Support - Monitoring and Troubleshooting Daily / Weekly / Monthly Jobs, Development of customizations and Interfaces

Application Architecture Description

The target was to integrate the existing enterprise wide information and minimizing custom development requirement with the end work product being an extremely customizable business rules based Workflow Management system tightly integrated with the front-end web application for users. Each department will maintain its own processes and functions assigned to them based on their access level, which can further be customized. Each member will be provided with access rights to maintain information specific to its department without any IT expert help. The Application targets to consolidate different applications to one platform. The Application has been extended with the special features like Self-service publishing, such as document upload, version control, check in/check out, page formatting, and access control, allow users to easily and securely share information with other authorized users.