TECHNICAL DOCUMENT for PRE-TENDER MEET Dated 11/12/2017

TECHNICAL DOCUMENT FOR PRE-TENDER MEET dated 11/12/2017

Development, Implementation and Maintenance of General Service Platform/Business Analytical Platform (BA) on SAAS Model

For

1.Introduction

Indraprastha Gas Limited (IGL) was incorporated in 1998 and took over Delhi City Gas Distribution(CGD) Project in 1999. The organization is a leading natural gas retailing and distribution company and in consortium with GAIL India Ltd., BPCL and Govt. of Delhi. IGL is supplying Piped Natural Gas (PNG) to domestic, commercial, industrial consumers and Compressed Natural Gas (CNG) to transporters through steel pipeline networks in Delhi and NCR i.e. Ghaziabad, Noida and Greater Noida. IGL has recently been awarded a new geographical area i.e. Rewari and Karnal, which fall under the state of Haryana

IGL is continuously improving the internal and external processes by implementing various systems which has resulted in its growth and customer satisfaction. IGL further desires to improve on business processes through implementation of a General Service Platform (GSP) for creating effective Business Analytical (BA) platform for CGD business.

The GSP/ BA Platform will be the common umbrella software application which will coordinate all activities with each service and to provide necessary functionality for specific processes. GSP/ BA Platform will act as a one-stop solution for managing business process integration and collecting data from various systems, analyze the collected data for fast and effective decision making.

2. Project implementation methodology and timeline

SNO. / Milestones / Time period(months)
1 / AS-IS- Successful understanding of IGL business, functions, processes and data systems. / 6
2 / KPI-Successfully defining KPIs, matrix, data/system modules and reports..
3 / PROTOTYPE/DEVELOPMENT- Successfully building a GSP prototype on selected 20-30% of IGL provided data.
4 / DEPLOYMENT/PRODUCTION - Successful implementation of GSP prototype on complete 100% data for all mentioned systems of IGL.All data pertaining to deployment / production stage should reside in India. / 6

The GSP/ BA Platformproject will be implemented in SAAS model .

System is being developed in such a manner that it will allow all types of Integration with any existing as well as future automation that take place at IGL.

The selected GSP Provider has to complete the development of existing automated modules within 6 months from receiving the Purchase order/FOI from IGL.

The selected GSP Provider has to deploy and run the prototype / solution model for atleast 6 months at full scale capacity in terms of 100 % IGL data pertaining to existing automated processes / systems. In these minimum six months of deployment, vendor will automate remaining manual processes and integrate them to GSP/BA.

Existing automated systems
Sl.No. / System Description
1 / Steel Pipeline SV (Sectionalizing Valve) Automation.(SCADA)
2 / AMR for I&C (Industrial & Commercial) Customers
3 / AMR for existing Domestic customers
4 / CNG stations with Site Monitors of Compac dispensers
5 / Odorization unit automation
6 / IGL’s portals: IGL CHARM Portal, Customer Portal, Bill watch System portal, Debar Portal, Complaint management System etc.
7 / ERP (SAP)
8 / IGL Mobille Applications: (Meter reading apps, Field Mobility Apps, Domestic Consumer Apps)
9 / GPS System for LCV Tracking
10 / Operational Risk management System (ORM Tools)
11 / Integration File Tracking System
12 / Integration with IT Helpdesk System
13 / Payment Gateway integration
14 / HR-Biometric Attendance
Existing Manual Processes
Sl.No. / System Description
1 / Development of Dealer Licensing Module
2 / Enterprise Risk Management (ERM) & Auditing System
3 / Automation of Corporate strategy department
4 / CNG and PNG manual work automation ( Land status, Civil work, Approval related to NOC, PESO License, Pipeline Laying Status)
5 / E tendering process for Pes& JV and C&P Department
6 / Automation of Corporate Communication and CSR Activities
7 / Automation of Litigation status
8 / Automation of all HR related processes: industrial relation, recruitment, training & development, travel, pre-printed stationary, fuel consumption by company cars etc.
9 / Automation of Calibration certificates of field equipments and automation of ISO documents.

3. Technical Scope

3.1. SCOPE OF WORK(Development of GSP/ BAPlatform Application)

Background

IGL wants to improve on its business processes through implementation of a General Service Platform (GSP)/business analytics (BA) platform for creating effective Business plans for CGD business.

The GSP/ BA Platformwill act as a one-stop solution for managing business process integration and collecting data from various systems, analyze the collected data for fast and effective decision making.

The General Services Platform GSP/ BA Platformwill be the common umbrella software application that coordinates all activities with each service and provides necessary functionality for specific processes..

Since the GSP/ BA Platformis having very multifaceted elements that can be brought online as plans permit. As processes get added the GSP must be able to adapt as it will be a living breathing system always growing and changing GSP/ BA PlatformCore System will cover all existing systems and add new modules for missing data gaps. It will provide a real time data analysis for effective decision making.

Propose GSP/ BA Platformapplication architecture:

Existing Automated processes currently running at IGL

As It is well understood that, Government of India has approved the ‘Digital India’ programwith the vision to transform India into a digitally empowered society and knowledge economy. .

The major applications that are currently running at IGL is given below

ERP (SAP)

Currently, SAP is used as ERP system in IGL. The some of the SAP modules already implemented at IGL are:

Materials Management (MM) and Quality Management (QM);
Financials and Controlling (FI/CO);
Project Systems (PS);
Plant Maintenance (PM);
Human Resources (HR), including Employee Self Service (ESS) and Manager Self Service (MSS)
Sales and Distribution (SD);
Industry Specific Utilities (ISU); and
Solution Manager
Business Intelligence & Business Objects (BI & BO)
Extended Enterprise Content Management by Open Text (ECM)
Document Presentment (DP) by Open Text
Customer Relationship Management (CRM)
Business Communication Management (BCM)
Utility Customer E-Services (UCES)
Governance, Risk and Compliance (GRC) – Access control
Enterprise Portal (EP)
Net Weaver Process Orchestration (PO)
Sybase 365 Money Mobilizer Platform + SAP Enterprise Integration for Utilities Customer Engagement + Reporting
Manufacturing Integration and Intelligence (MII)

Automatic meter reading system ( for PNG Domestic and Industrial customers)
Smart Phone application ( for Domestic customers)
Compac Dispensers online monitoring system.
ORM Tool, is running to check the Risk Management at Operational Levels
GPS based System is running for LCV Tracking System
Various Portals(not limited to- CHARM Portal, Customer Portal, Bill watch System portal, Debar Portal) are running to cater the need of various requirements
Different Mobile Applications (not limited to-Meter reading apps, Field Mobility Apps, Domestic Consumer Apps ) are running at IGL to cater various need of intra departments
Remote Valve Operation for SV stations.(SCADA)
Odorization units are automated with installations of different specific tools
Complain management System is used to track and trace all the complaints raised at IGL and different users will be accessing to the Complaint management solution to address the complains.
Automated File Tracking System for smooth transaction of Files.
Various MIS Reports
Payment Gateway Integration

Existing manual processes currently running at IGL that need to be automated

There are certain areas which are still running under the manual process and data is acquired under various forms/type.

Development of Dealer Licensing Management System: IGL deals with various dealers for selling of the Gas. It is well understood that IGL requires developing a dealership licensing module for automating all its licensing business processes. Visualize a solution that covers application reviews, exams, renewals, audits, fees, complaints, investigations, legal actions, and compliance activities.
Enterprise Risk management System andauditing system under Quality and Integrity management.
The entire process (Strategic Planning process, Project wise strategy planning, History of strategy adopted etc.) of Corporate strategy department is running under manual process
Some of the vital reporting and information’s like (DPR Preparation, maintenance of Gasreconciliation, informationof consumption of station power, information related to machine Ownership status) are being maintained in manual way through excel sheets.
Under CNG Project department various process are still running manually like ( information related to civil work going on, equipment status, approval mechanism for NOC, PESO Licensing, power loading status) for new projects. Similarly for existing projects currently information related to Land status is being maintained manually.
The entire process of tender mechanism up to selection of vendor (which is dealt by PES and C&P Department) is running on manual process which requires to be automated for smooth communication.
All information and transaction process dealt by legal department is currently running in manual process.
Information related to Industrial relationship, recruitment process, training and development, employee grievances, estate management, health insurance, fuel consumption by company cars and preprinted stationary, processes those are dealt by HR department is currently running under Manual process. This creates hindrance for the user to get exact report at required time
Vital information like project status Pipe laying status which is being dealt by the PNG department is currently running under manual process.
All information dealt by Corporate communication department ( information related to Corporate communication and corporate social responsibility) is running in manual process

III. General requirements for GSP/ BA Platform

Proposed GSP/Business Analytics platform should meet under mentioned Deliverables (requirements):

Scalable, Modular and Flexible (extensible with respect to all business functions), such as to be compatible solution oriented in respect to existing and future requirements. Further it must be scalable, expandable to cater the increase in number of users, processes, systemsor technologies
Rationalize existing reports and also develop new reports as per IGL requirements.
Suitability with respect to IGL technical ecosystem and support functional needs.
Detailed data assessment, validating ability to support functional requirements.
Provide dashboard showing automated reports and defined analytical output.
Capable to integrate with other systems though Application Programme interface (API).
Capable of updating on Pre-defined interval or Real-Time basis.
Compliance to latest Common Data Format (CDF) protocol in order to communicate with third party applications
In-built features for customization possibilities to publish/generate various reports as per IGL requirement.
Geographic Integrated System (GIS) integration to support Geo-Tagging of all assets
Should have mobile application support/mobile App for GSP/BA.
Accessible through internet or intranet.
Provided solution should support private cloud or private cloud inside the hosted data centre provider. The proposed cloud solution must have the capability to transfer/shift the entire solution into dedicated private cloud of IGL in future.
Provide change management services to support business users
Capable to port and integrate data from existing system.
Comply with third party digital security for SSL/TSL compliance.
Inbuilt email feature, message alerts.
Compatible with devices such as scanner, printer and Wi-Fi projectors, video wall etc.
Inbuilt document management feature and should support various extensions such as .doc, .docx, .pdf, .xls, xlsx, .txt, .rtf, .bmp, .jpeg, .jpg, .png, etc.
Product should be capable for detailed analysis of manual process and integrate them to enterprise data warehouse.
The system should bring transparency in payment reconciliation process by integrating the data into GSP/ BA Platform from available payment modes through developed automated systemfor CNG/PNGcustomers like Credit/Debit Card, Payment through e-Wallets, Cash Collection etc. and provide real time status of transactions. The system should capture the real-time payment transaction data and pass on to GSP/ BA Platform.
The proposed system will be used to monitor the various performance matrixes like DSM performance, compressor efficiency, dispenser efficiency, Section Valves etc.
Predictive, Prescriptive and descriptive analytics can be performed through GSP Dashboard. Mentioned analysis must be clearly performed and shown to IGL after successful completion of prototype/development phase.
The GSP/ BA PlatformSystem will integrate with existing systems like SAP, third party software using Common Data Format (CDF) by harmonizing data.
The Bidder would be responsible to fetch the available data from third party systems and integrate it into GSP/Business analytics platform.
The entire solution (during production / deployment phase) including Data (during production / deployment phase) will not be hosted outside India as per RBI/MEITY guidelines during deployment/production.
The solution should have the capability to lift and shift without configuration the entire system from hosted data Centre to IGL as an option in the future without any additional cost (in terms of hardware / software) to IGL.
Provided solution shall be compatible with the available IGL Hardware & Software.
At the time of contract closure vendor (Solution Provider has to handover all data to IGL without any condition and will be free of cost).
The Development of GSP/BA may take place on a public cloud. During development IGL will identify Data, which the bidder will extract and use during period of Development and testing.
Post acceptance of development model by IGL and subsequent to management approval for Go Live, the Bidder will have to ensure that the system is lifted and shifted, AS-IS, to a Dedicated Cloud infrastructure for IGL in India.This Cloud service of the GSP/BA's Cloud Hosted solution infrastructure must be physically dedicated to only IGL's GSP/BA application and the underlying GSP/BA technology layer and resources should not be shared with any other customer of the Service provider during the time of contract to avoid security breaches, IP related infringement issues, reduction in performance arising out of competing resource demand from any non IGL GSP/BA application etc.
At the time of contract closure of the GSP/BA service provider, the entire technology, including dedicated cloud infrastructure , application layer, application logic, ETL/ELT, Business analytics layer, algorithms , KPI's and reports including all the underlying software technology, should be movable from GSP/BA Providers Data Centre As-Is, to IGL's Dedicated private cloud / Data Centre without any additional cost (in terms of hardware / software) to IGL.

Detailed requirements based upon various IGL processes

Inline to the implementation approach, two segments have been defined (Existing automated process and manual Process). The GSP/ BI Platformimplementing agency is required to integrate the existing automated process and in the proposed GSP/ BA Platformapplication and will also provide and build a solution to automate the various process data, which is currently running manually at IGL.

It is required that Bidder will provide best suitable solution which require minimum configuration, custom made application, Multi compatible coding and secure data encryption.

The Proposed GSP/ BA Platformwill be developed in such a manner that will help the end user to configure the modules from the user interface dynamically with drag and drop facility.

The Propose GSP/ BA Platformwill be integrated to all the existing automation modules .Below are segment wise requirements( but not limited to) required in GSP/BA tool.

Wherever manual data collection points exist, a web based application compatible with mobile browsers for data collection from the department/process needs to be developed by GSP/BA provider to collect the data.

GSP/ BA Platformimplementation on ERP:

SL. No. / Requirements
1 / The Propose GSP/ BA Platform should be integrated to All the modules as mentioned in the document covering under ERP (SAP)
2 / Various reports to be consolidated and displayed on GSP/ BAPlatform,so that quick decision can be made possible
3 / Should be able to drill down to specific data parameters on requirement
4 / Should be able to show the reports on graphical as well as statistical format
5 / Reports to be displayed user role wise
6 / Module wise different reports can be displayed instantly
7 / Option for export to excel, PDF, and other formats to be there so that the extract of GSP/ BA Platformdata can be used further.
8 / Comparison analysis can be done by taking relevant data as input
9 / Auto email and SMS facility will be there so that instant communication can made possible from the system itself.

GSP/BA Platform implementation on Customer portal:

SL. No. / Requirements
1 / Information about Customer details, customer feedback to be displayed on GSP/ BA Platformwhich will help the concerned authority to take immediate action for customer retention.
2 / Should be able to generate alerts and acknowledgement about negative feedback received by customers.
3 / Should be able to show the reports on graphical as well as statistical format
4 / Reports to be displayed user role wise
5 / Feedback from Social media and other electronic media can be displayed
6 / Higher authority can able to drill down from the system to get information about the customer and their transaction details.
7 / Information about the active and inactive customer to be displayed in the GSP/ BA PlatformSystem and proper analytics can be maintained against the inactive customer for retention process
8 / Details of Outstanding payment against customer can also be displayed which will help the higher authority to take immediate action on the same.
9 / Auto email and SMS facility will be there so that instant communication can made possible from the system itself.

GSP/BA Platform implementation on Document Management System:

SL. No. / Requirements
1 / Information of No. of documents digitized and kept digitally at IGL to be displayed
2 / Document retrieval mechanism will be there which will help the higher authority to refer some old document while in a meeting.
3 / File tracking system to be integrated which enable to track a particular e file
4 / Should be able to show the reports on graphical as well as statistical format
5 / Reports to be displayed user role wise
6 / Information related to pending file and with no. of days and date can be tracked.
7 / Higher authority can able to drill down from the system access a particular file to open and check the information mentioned in the file
8 / Information about No. of Letter received and dispatched at IGL can be monitored
9 / History of a file movement can be tracked through GSP/ BA Platform
10 / Auto email and SMS facility will be there so that instant communication can made possible from the system itself.

GSP/BA Platform implementation on Remote Valve Operation: