Technical Capability

Chia sẻ: Bich Huyen | Ngày: | Loại File: PDF | Số trang:32

0
57
lượt xem
10
download

Technical Capability

Mô tả tài liệu
  Download Vui lòng tải xuống để xem tài liệu đầy đủ

Oracle / SQL. Gateway TechnoLabs Pvt. Ltd. ... Back End: Oracle 8i. 1.2.4 Conclusion ... Three-Tier Architecture (Java Swings, EJBs, Oracle 8i) Modular Structure ...

Chủ đề:
Lưu

Nội dung Text: Technical Capability

  1. 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: gateway@gatewaytechnolabs.com 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.
  2. 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
  3. Gateway Technolabs Pvt. Ltd. Technical Capability June 2007 Oracle/ SQL 2.5.2 Technologies........................................................................................................18 2.5.3 Team Size and Duration ........................................................................................18
  4. 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.
  5. 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.
  6. 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
  7. 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.
  8. 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.
  9. 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.
  10. 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.
  11. 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)
  12. 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
  13. 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
  14. 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
  15. 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
  16. 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
  17. 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
  18. 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
  19. 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
Đồng bộ tài khoản