Technical Capability
Oracle / SQL. Gateway TechnoLabs Pvt. Ltd. ... Back End: Oracle 8i. 1.2.4 Conclusion ... Three-Tier Architecture (Java Swings, EJBs, Oracle 8i) Modular Structure ...
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: [email protected]
URL: www.gatewaytechnolabs.com
This document and any files with it are for the sole use of the intended recipient(s) and may contain confidential and privileged
information.
If you are not the intended recipient, please destroy all copies of the document. Any unauthorized review, use, disclosure,
dissemination, forwarding, printing or copying of this document or any action taken in reliance on this document is strictly
prohibited and may be unlawful.
Visit us at http://www.gatewaytechnolabs.com
Copyright © 1997-2007 Gateway TechnoLabs Pvt. Ltd.
Gateway Technolabs Pvt. Ltd.
Technical Capability June 2007
Oracle/ SQL
Table of Contents
1 Experience Gateway – Project Showcase: Oracle Database......................................... 5
1.1 Web based Project Management Office (W-PMO) ............................................................ 5
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 Technology Statistics ............................................................................................. 8
1.1.9 Project Duration .................................................................................................... 8
1.2 Mudra Advertising Agency – CRM Application .................................................................. 8
1.2.1 Introduction.......................................................................................................... 8
1.2.2 Features............................................................................................................... 9
1.2.3 Technological Statistics .........................................................................................10
1.2.4 Conclusion ...........................................................................................................10
1.3 Mudra Client Servicing Application ................................................................................11
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 Need.................................................................................................................... 3
2.1.2 Solution................................................................................................................ 3
2.1.3 Technical Architecture............................................................................................ 3
2.1.4 Tools & Technologies used ..................................................................................... 4
2.1.5 Team Size & Duration ............................................................................................ 4
2.2 Interactive Statistic (InterStat) ...................................................................................... 4
2.2.1 Client Introduction................................................................................................. 4
2.2.2 Overview .............................................................................................................. 4
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 Need...................................................................................................................15
2.3.2 Solution...............................................................................................................15
2.3.3 Tools & Technologies used ....................................................................................16
2.3.4 Team Size & Duration ...........................................................................................16
2.4 Business Buy and Sell..................................................................................................16
2.4.1 Description ..........................................................................................................16
2.4.2 Features..............................................................................................................16
2.4.3 Tools & Technologies used ....................................................................................17
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 June 2007
Oracle/ SQL
2.5.2 Technologies........................................................................................................18
2.5.3 Team Size and Duration ........................................................................................18
Gateway Technolabs Pvt. Ltd.
Technical Capability June 2007
Oracle/ SQL
1 Experience Gateway – Project Showcase: Oracle Database
1.1 Web based Project Management Office (W-PMO)
1.1.1 Client Introduction
The client is a Denmark based web-service provider and is involved in providing portals to enable
web-based service in the area of B2B.
1.1.2 Requirement
Small and medium scale companies operates with number of manual processes to maintain the
practices dealing with their Client Interaction, Order Processing, Project Management, Task
Allocation, Monitoring and tracking, Cost Involved, Inventory and Accounts Maintenance. The need
of the client was to develop a Service Portal, which would help in these companies to manage the
any project by assigning tasks and reviewing the status of the same.
This would essentially mean that developing a solution that would encompass the activities right
from the creation of a new client, Project generation related to a client, breaking the project into
orders and then into worksheet and allocating the same to the employees of the company. These
worksheets or the task allocated would then be available to the allocated resource who would then
close it as and when the particular task is over. This would also keep the track of the materials
employed a particular task, status, and the cost involved.
Hence the portal would help in monitoring and tracking of any project related activities.
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 June 2007
Oracle/ SQL
The solution can be outlined to be a services portal, which will encompass everything from order
entry through to management reporting, providing an end-to-end solution to the Vendors. To
achieve this goal, the Service Portal provided the services in the following sectors:
Client Information, related with capturing and maintaining the client details.
Order Processing & Invoicing, a core service, which will be used to track the currently
active orders and provide support for invoice generation.
Project Management, another core module, which supports the Order Processing
services, to manage the ongoing orders.
Inventory Management, a supportive service that manages the item inventory used
during the project (job) execution.
Each of these modules are closely related to one another and fully integrated into one system,
which help the user to manage their end-to-end activities starting from order creation till invoice
dispatch.
1.1.5 Features
The portal is Wireless enabled. In this case the administrator of the company can log on
to the portal through his/ her mobile and monitor and track the project activities.
Similarly the employees can access to the portal and enter the worksheet details.
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.
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 June 2007
Oracle/ SQL
Information availability – Employees can obtain information about the jobs for the day
without having to report at the office first.
The portal also provides services that support instant messaging for new allocation or
reallocation of jobs to the employees.
Managing Worksheets from any place - Employees can update the worksheets from
anywhere.
Modular Design - The whole design has been made available in modular way. Primary
services are available as basic module catering the basis needs. The solution also
supports add-on modules for WAP and SMS services to provide the effectiveness.
Employees will be more reachable if they are connected through mobile devices like Cell
Phones and PDAs.
1.1.7 Future Enhancements
The future versions for service portal will provide many enhancements to the existing portal, which
would be carried out in Phase II:
Adding Auction facilities.
Utilizing XML Technology for integrating with clients’ legacy data. In case where the
client has his/her own systems to manage the legal data, the future versions of the
service portal provides the export and import functionalities in XML formats, to provide
seamless interaction with any third party systems.
Locating Employees.
The Client Information System will provide support for creating and monitoring the order
directly from the web site, as well as from the mobile devices.
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 June 2007
Oracle/ SQL
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
Database: Oracle 8i
Application Server: Apache Tomcat 4.0.3
Java Environment: JDK 1.4
Front End: JSP 1.2
Tools: HTML, Photoshop
1.1.9 Project Duration
The total project duration was 6 person-months.
1.2 Mudra Advertising Agency – CRM Application
1.2.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.
This Application allows Mudra to have an edge over its competitors, as it is able to furnish lots of
information, which is important to close a deal, and also makes the client comfortable by projecting
an open environment. This also allows Mudra to give customized packages to client.
The other important feature of this application is that the knowledge base of the company is stored
in an ordered fashion and can be retrieved very easily. This will ensure that there is some level of
reusability and thereby reduce costs.
The concept of this site is that Mudra wants to Store all the documents in this site and make it
accessible to the employees of Mudra as well as the Clients. The entire site is based on a role
access mechanism wherein authorization is required. So if the user is a Manager then he has
access to most of the links. If the user is a Data entry operator he has access to the Administration
module.
Gateway Technolabs Pvt. Ltd.
Technical Capability June 2007
Oracle/ SQL
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
of the various advertisements that are to appear on a certain date.
Gateway Technolabs Pvt. Ltd.
Technical Capability June 2007
Oracle/ SQL
Site has global utilities like the Discussion Forum, Collaboration Module (which allows the
user to make presentations to the client and also chat with the client. It also has the
facility to talk using VoIP). Also Net-Meeting features have been embedded.
1.2.3 Technological Statistics
Architecture: Two-Tier Architecture
Front End: JSP 1.2, JDK 1.3
Web-Server: Orion Web-Server
Back End: Oracle 8i
1.2.4 Conclusion
Everyone in an organization can benefit from the specific information gathered from assessments
of employees' and customers' perceptions. Leading organizations use this feedback to improve
personal and departmental performance along the path of becoming a truly customer-centric
organization. Rely on experienced facilitators and change management consultants to help you
kick-start your efforts and lead you through the implementation of systems to collect opinions,
perceptions and priorities from employees and customers. Then, use this information to gauge
training, performance and human development needs. You'll be on your way to developing a
world-class customer-centric organization.
Gateway Technolabs Pvt. Ltd.
Technical Capability June 2007
Oracle/ SQL
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
Client Servicing team with the clients. ROI (Relevant and Original Impact) forms are used to fetch
relevant information from the client for the smooth functionality of delivering an advertisement.
Client servicing team will fill the campaign details and budget information thru the campaign
management form. Then thru job request module different departments are assigned relevant jobs
for the advertisement.
The other features that are provided in this system are to keep track of the budget, the Estimates,
the bills and the jobs. Close control is maintained by using the Estimate Tracking, the Bill tracking
and the Job status modules.
New Business:
All the relevant information regarding the new client is entered in the application (e.g. address,
concerned person name etc).
Business Approval:
The detail of the client is entered from this Form. The Company Profile, Product Brand Information
Financial Aspect, Client Competitors etc are recorded. This helps the Mudra to have upto date
information of this client and is useful in further business expansion with the client.
Media Plan:
Media Plan is maintained for the Press and TV business of Mudra. This plan contains all the
information of the clients advertising plan (e.g. for press the advertisement type, the language, the
size of the advert etc). A facility to upload these plans from an excel file or any comma separated
text file is also provided.
Gateway Technolabs Pvt. Ltd.
Technical Capability June 2007
Oracle/ SQL
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)
Gateway Technolabs Pvt. Ltd.
Technical Capability June 2007
Oracle/ SQL
1.3.3 The Work Flow Diagram
Client 1.1.1.1.1 Stage-0
Generating Business
Client servicing
Stage-I
• Client Account Handling and development
• Understanding the need with the client
Creative
Conceptualize and implementation of the need
Stage-II Copywriter: The text of the Art: The visual effects, layout,
• Campaign and Budget Planning campaign is written and slogan graphics for ad
• Client briefing and presentation are conceived
• Research for the product launch
Media Planning
Positioning of an ad in the media.
Studio
Identifying and procuring display space/ air time.
Finished Layouts, story boards, art
Raising estimates on campaign media plan
work and slides
Stage-III
• Client briefing and presentation
• Final Approval on the campaign
Production
Responsible for the looks of the ad when they are
released in different media.
Ensures that the ads are released.
Stage-IV
• Scheduling and Release Order, Voucher
Copy Verification
Media Operation
Responsible for the schedule and Release of the
Advertisement to the Media and verification of the
release of the Advertisement.
Stage-V
• Billing to the customer
Stage-VI
• Supplier Voucher Booking & Bill Passing
Gateway Technolabs Pvt. Ltd.
Technical Capability June 2007
Oracle/ SQL
Press Estimate
This screen helps in generation of Media Estimate, which are then sent to client for approvals, and
on approval of the client only the further processing is carried.
Figure: Screen shot of Press Estimate from Mudra-CS Application
Gateway Technolabs Pvt. Ltd.
Technical Capability January 2007
Oracle / SQL
Press Schedule
This Screen helps to generate the schedules based on the estimate information
Figure: Screen shot of Press Schedule from Mudra-CS Application
Confidential
Gateway Technolabs Pvt. Ltd.
Technical Capability January 2007
Oracle / SQL
Press RO
This Screen helps generating Release orders by the media operations department from the
schedules created.
Figure: Screen Shot of Press Release Order from Mudra-CS Application
1.3.4 Features
• Web-Enabled Application
• Full-integration of all the departments
• Three-Tier Architecture (Java Swings, EJBs, Oracle 8i)
• Modular Structure
• Status Monitoring of the Job, Bills, Proforma etc across the departments
1.3.5 Technological Stats
Architecture: Three-Tier Architecture – The Business logic resides in the Middle Tier (Oracle
Container for Java – OC4J), which makes it easier to handle and modify the application.
Front End: Swing Based Java Components developed using Oracle JDeveloper
Middle Tier: Oracle Application Server with Oracle Container for Java.
Bank End: Oracle 8i
Confidential
Gateway Technolabs Pvt. Ltd.
Technical Capability January 2007
Oracle / SQL
2 Experience Gateway – Project Showcase: SQL Database
2.1 Legal Search Portal
2.1.1 Need
The objective of Legal Portal is to provide a highly sophisticated search tool to the legal community.
Legal Portal is a set of managed service, providing customers a legal search facility, which is fully
accessible over the Internet and does not require any local infrastructure.
2.1.2 Solution
Legal Portal is an innovative new service that enables fast and easy access to multiple legal
information sources. Relevant legislation, case law, literature and dossiers are now available within
seconds, following a simple search action. Legal Portal is a valuable tool for all legal professionals who
wish to find relevant information faster, and need better, more precise search results.
As part of the managed service, Legal Portal takes care of collecting and indexing legal information
from a large number of document sources. This information is collected from public sources (i.e. laws
and EU regulations), but can also come the customer’s internal files. The search facilities offered by
Legal Portal provide the possibility to search across all document sources and provide the search
results in ‘one window’.
2.1.3 Technical Architecture
• Microsoft .Net Enterprise Business Solution.
o Integrated Microsoft .Net Enterprise Business Solution. Written in multi-layered VB.Net
architecture, separating Application logic, interface, data, object, user interaction and
web.
• Microsoft .Net Remoting as Object Communication Architecture.
o . Net Remoting used as central object Communication Architecture. Custom serialized
object used for communication Across application
• Microsoft Message Queuing (MSMQ) as Basic Message Transfer Mechanism.
o MSMQ used as central message collector and dispatcher for all message enabling data
filtering and populating SQL database within Queue interface.
• Full Featured Use of Collexis (third party Search Engine) for Document Finger-printing and
Thesaurus integration with Site and Back End Application like Data Loader, Data Validator and
Law Cutter Application.
o Collexis API used in object wrapper to create 3 tier access to Collexis search engine,
with automated console application to create and manage multiple collexions (Collexis
Database).
• Separate Windows Service to manage Remoting and MSMQ interface.
o Two windows service created each for MSMQ and Remoting listener. Business logic of
this service is wrapped in Object Class in 3-tier fashion.
• Three console application (scheduler enabled) for updating Collexis and SQL Database.
o Data Loader, Data Validator and Law Cutter Application manages Collexis and SQL
database as a scheduled back end process. Also integrated logging of Application
security (user blocking), application usage and Application Exceptions.
• Remote Object Transfer Through Internet through TCP channel.
o User configurable TCP Listener used for Remoting channel in Internet / intranet
environment.
• Command line interface to scheduler, back end application for Collexis updating and link
Validation usage.
Confidential
Gateway Technolabs Pvt. Ltd.
Technical Capability January 2007
Oracle / SQL
o Customized command line interface for data updating by console application and
inbuilt link checker for Collexis
2.1.4 Tools & Technologies used
o Back-End: SQL Server 2000
o Front-End: ASP.NET
o Language: C# (C Sharp)
o Version Control: Visual SourceSafe 6.0
o Platform: .NET
2.1.5 Team Size & Duration
• Team Size: 5 professionals
• Duration: 6 months
2.2 Interactive Statistic (InterStat)
2.2.1 Client Introduction
The client is a Denmark based web-service provider and is involved in providing portals to enable web-
based service in the area of B2B.
2.2.2 Overview
Interactive Statistics is aimed to be an application for making various tasks concerning administration,
calculation and publishing statistic data on the Internet or Intranet.
It is recognized that the use of databases are widely spread in conjunction with statistical data. Thus,
the goal for Interactive Statistics is to provide a feeling of a database-independent system. Because of
the apparent database-independency, the Interactive Statistics tool shall provide the user with an easy
transition between database types such as Oracle or InterBase.
Interactive Statistics shall consist of a system containing several modules, with a minimum set of basic
functions for publishing statistic data. For additional functions and viewing possibilities extra modules
can be added. This way the costumer can create an Interactive Statistics, containing exactly what is
needed, with as little functional surplus and economic expense as possible.
The Interactive Statistics tool can provide a large amount of freedom to the publishing user, in
choosing which data to publish and in what degree the online-users may manipulate the data
themselves. The publishing methods can range from numbers only to simple diagrams and larger
visualization schemes, depending on what modules there have been added. The online-users can have
an appropriate range of various viewpoints of the published data, if the publishing user has allowed
other viewing possibilities. This gives the publishing user a new kind of freedom concerning publishing
data.
2.2.3 Solution
On the basis of the interaction with the client team, Gateway proposed a solution that can help the
companies to achieve,
o Ease of manageability and maintainability
o Advantage of use of any database for internal purpose
o Ease of generation of analytical reports that includes charts and tabular data representation
o Ease of Report generation process due to availability of Query Designer
Confidential
Gateway Technolabs Pvt. Ltd.
Technical Capability January 2007
Oracle / SQL
2.2.4 Features
o Available as a Microsoft Installable, Add-on can be installed on demand
o Availability of modules for different functionality, that can be installed/uninstalled as required
o Open database connectivity, can connect to any database
o Query Designers for creating source of data for charts/data tables
o Chart Generation Wizards for generation of Charts from data
o Multilingual support for English and Danish, can be easily expandable
2.2.5 Benefits
The application provides the following advantages:
o Reduced maintenance due to modular design
o Ease of configuration management as users can install only required modules
o Ease for enhancements, as individual modules can be upgraded to newer versions
o Support for almost all widely used databases, will give openness for database usage
o No knowledge required for Database query languages due to availability of Query Designer
o Ease of analytical reports containing data tables and complex charts
o Multilingual Support
2.2.6 Screen Shots
Confidential
Gateway Technolabs Pvt. Ltd.
Technical Capability January 2007
Oracle / SQL
InterStat Object Menu
Once you login to InterStat you can use the menu on the left for
managing your activities.
The Object Menu will appear on the left as soon as you logged in. Here
you can create objects, which can be published and viewed from the
View Menu.
InterStat View Menu
Click on View tab will appear the View Menu. Here you can view the
pages you have created. You can expand the option if it has child
options.
Confidential
