Technical Capability

Oracle / SQL Gateway TechnoLabs Pvt. Ltd.
B-81, Corporate House, Judges Bungalow Road, Bodakdev, Ahmedabad - 380 054, India
Tel: +91 79 2685 2554/5/6 Fax: +91 79 26858591
E-mail:

URL:


1.1.1

Client Introduction................................................................................................. 5

1.1.2

Requirement ......................................................................................................... 5

1.1.3

Challenges............................................................................................................ 5

1.1.4

Solution................................................................................................................ 5

1.1.5

Features............................................................................................................... 6

1.1.6

Benefits................................................................................................................ 6

1.1.7

Future Enhancements ............................................................................................ 7

1.1.8


1.3.1

Introduction.........................................................................................................11

1.3.2

About the Project .................................................................................................11

1.3.3

The Work Flow Diagram ........................................................................................13

1.3.4

Features............................................................................................................... 4

1.3.5

Technological Stats................................................................................................ 4

2

Experience Gateway – Project Showcase: SQL Database............................................. 3

2.1

Legal Search Portal ...................................................................................................... 3

2.1.1


2.2.3

Solution................................................................................................................ 4

2.2.4

Features............................................................................................................... 5

2.2.5

Benefits................................................................................................................ 5

2.2.6

Screen Shots......................................................................................................... 5

2.2.7

Technology Statistics ............................................................................................15

2.2.8

Project Duration ...................................................................................................15

2.3

Mail System Solution ...................................................................................................15

2.3.1


2.4.4

Team Size & Duration ...........................................................................................17

2.5

Heritage Golf Group Intranet Site..................................................................................17

2.5.1

Features..............................................................................................................17

Gateway Technolabs Pvt. Ltd.
Technical Capability Oracle/ SQL

June 2007

2.5.2

Technologies........................................................................................................18

2.5.3

Team Size and Duration ........................................................................................18




1.1.3 Challenges

The challenges faced during the execution of the project:

• Some of the resources in the portal had to be WAP enabled. The compatibility files for this
needed to be less than 50 KB so that it could be loaded on to the Wireless enabled devices (Java
Platform).

• High Level of security based on Roles to define the resources available the user in the Portal.

• Multi-Lingual support: The static data appearing on the GUI would be available in multiple
languages to the user.

• Multiple Layouts: The GUI of the portal would change as defined by the user.
1.1.4 Solution

On the basis of the interaction with the client team, Gateway proposed a solution that can help the
companies to achieve better Quality in providing the services to their customers, Quicker
procedures, decreasing the response time in contract management.

Gateway Technolabs Pvt. Ltd.
Technical Capability Oracle/ SQL

June 2007

The solution can be outlined to be a services portal, which will encompass everything from order

 Multiple Layouts: The GUI of the portal would change as defined by the user.

 Project monitoring and tracking: The project manager/ administrator can do the planning
and allocation of activities and track them to closure.


Automatic Email notification for task allocation and project completion to the users.

1.1.6 Benefits

The service portal provides the following advantages:

 Employee registration process is more qualitative and uniform.

 Invoice Generation is managed by the system, and thus the Invoices are generated and
sent on the finished date of the job.

 Increases Liquidity – Due to faster response in sending invoices the liquidity will be
increased substantially.

Gateway Technolabs Pvt. Ltd.
Technical Capability Oracle/ SQL

June 2007

 Information availability – Employees can obtain information about the jobs for the day
without having to report at the office first.

 Importing lists of materials for different branches

 Use of portable scanners

 Use of PDAs for maintaining worksheets

 A fully automated inventory management module

 Automated price estimations on projects, based on price listings of inventory, rate of
different employees, estimated use of man-hours etc.

 A module for clients to announce projects, and vendors to bid on the projects

 Retrieving a scanned drawing, and a small drawing tool

 Collection of payment against invoices, that are printed on site

Gateway Technolabs Pvt. Ltd.
Technical Capability Oracle/ SQL

June 2007

 Connecting to payment gateways so that money can be directly paid through the cell
phones or PDAs.
1.1.8 Technology Statistics

Architecture: N-Tier Architecture

Gateway Technolabs Pvt. Ltd.
Technical Capability Oracle/ SQL

June 2007
1.2.2 Features

 Web-Based Application, which makes it accessible anywhere-anytime.

 Transparency to the clients as well as the employees.

 Enhanced security features to have limited and allowable access of the resources.

 Contains the details of a particular campaign for a client, which enables a manager to
make an analysis. Details like Presentations, creative outputs, Guard Book, Press
Clippings etc maintained and accessible to the client.

 News/ Awards/ Research etc are made available to the Client.

 Discussion Forum to allow the client and the company (Mudra) to interact with each
other. Media schedule for a particular campaign are accessible to the clients.

 Discussion forum have the facility of simple and advanced search mechanism.

 Site also has information about the competing media companies and also the schedules

world-class customer-centric organization.

Gateway Technolabs Pvt. Ltd.
Technical Capability Oracle/ SQL

June 2007

1.3 Mudra Client Servicing Application
1.3.1 Introduction
Mudra as an organization has always been on the forefront of technology. All its users are very
much aware of the importance of computerization. They were among the pioneers in automation
in India.

The application, Mudra-CSA is developed for the automation of their Client servicing activities and
operations giving an edge over its competitors, as it is able to furnish lots of information, which is
important to handle and implement a campaign, and also makes the client comfortable by planning
and scheduling each activity of the campaign. It also takes care of the Branch operations between
New Business development to Client Billing and Supplier Invoice passing.
1.3.2 About the Project

Whenever a new client occurs. The team from Mudra spends some time and effort for pitching to
convert the client. The expenditure made to bag this client initially is made by Mudra. These are
noted as pre pitching expenses.

Client Servicing:

The Service Report form is provided to record the day-to-day meetings and discussions of the


Oracle/ SQL

June 2007

Studio/Production:

These departments carry on the actual design and production of the Advertisement. They also
interact with various Third party agencies that will actually print the Advertisement or run the
Advertisement (Star TV, Times of India).
On receiving Job request from CS department, the studio department makes Purchase Orders as
per requirement. These PO-s are followed by the Delivery Challans and Supplier Bills. Then
department sends estimates to CS department, which gets approved by the client. On approval
client bills are generated.

Press/TV:

The various areas are Press, TV, Radio, and Other Production (which includes hoarding, film
shooting, web site etc)
In case of TV and Press Media plans are generated, and most of the time they are prepared in
excel sheets and get converted into database. Then estimates are created and sent to the client
for approval. On approval Schedules are prepared. On the basis of schedules Release Orders are
created. These are monitored and entered into monitoring detail or Voucher copy modules. Once
Voucher copy received or Channel certificates are received the client is billed as per the estimate.
Simultaneously publication and channel bills are processed.

The Document Flow Diagram (step-wise)