techm gis competency

1Copyright © 2013 Tech Mahindra. All rights reserved.

Connected World. Connected Solutions.

GIS Competency

Sept 2013


Improved QualityWell defined process & best

in class quality standards ensure high quality

solutions

Our Technology driven, Service led approach leads to

Reduced cycle timeReusable and tested

components reduces time on testing & development

Cost effective solutionsPre built components &

productivity improvements help us decrease effort &

cost

Tech Mahindra GIS COE

Key customers

Consulting

Product Alliance

Domain

TechnologyESRI GE Smallworld OGIS

Application Development & Maintenance Services

Global Presence

USA

Europe

Asia Pacific

Autodesk

(Google Earth / Bing Maps)

GovernmentEnergy & Utilities

Telecom

Transportation Health Care

MEA & India

Practice highlights 100+ consultants on

applications 600+ associates on

spatial data management

60+ project executed 1200 person years of

experience

Service offerings Consulting Project Management Application

Development Implementation &

Training Testing Maintenance & Support Spatial Data

Management System Upgradation

Delivery Methodology


Government

GIS & Spatial Services

Utilities• Infrastructure Management• Operation and Maintenance• Forecast demand• Planning & Engineering • Tax Planning

• Land Information System• Urban Planning• Disaster Management

Natural Resources

• Exploration• Modeling• Protection• Planning• Management

Financial Services• Regulatory Compliance• Market Analysis• Customer prospecting• Site Prospecting & Analysis• ATM Branch locator

Transportation• Pavement Management System• Roads & Highways Management• Railroad Management• Motor Vehicles Administration• Water Transportation• Intelligent Transportation System

Telecommunication

• Location Based Services• Network planning• Wireless Engineering

Insurance

• Address Validation• Claims Management• Risk Underwriting• Risk Aggregation & review

SCM & Logistics• Asset Tracking• Route Scheduling• Territory optimization• Site selection

GIS @ Tech Mahindra


Tech Mahindra GIS CoE

Health GIS

GIS with ERP

Enterprise GIS(EGIS)

Open GIS

Transportation GIS

Mobile GIS

Disaster Management System ( DMS)

Telematics

Tech Mahindra GIS CoE offerings


Awards:

International Award LandNET

Special Achievement Award - GIS

LTA-GIS mgLAMS

Govt. Technology Award LandNET

CIO Asia Award LTA - EGIS

Certification of Appreciation Chevron

Leading Telecom Service Provider,

Europe

Leading manufacturer and supplier of Utility solutions, USA


• A leading GIS solutions provider

• Established in 2000

• Projects spread across over 10 countries

• Clients include Fortune 500 companies

• Partnership with GE Smallworld, Autodesk & ESRI

GIS@Tech Mahindra

Overview


ESRI

GE- Sm

allw

orld

Autodes

k

OGIS

Go

ve

rnm

en

t

En

erg

y &

Uti

liti

es

Tele

co

m

Ins

ura

nc

e

Tra

ns

po

rta

tio

n

Consulting

Application Development

Implementation & Training

Project Management

Maintenance & Support

Testing

Partn

ers

/ Alli

ance

s

Servi

ces

Ind

ust

ries

/ V

erti

cals

Other

s

(Google

Ear

th /

Bing M

aps)

* Alliance in Progress

Service Offerings & Verticals


2000

2002

2003

2004 2005

2006

2007

2008

June 2000 – Start of GIS Journey

India’s First Navigation Portal

2001

Designs India’s first ASP Based Telematics Solution

ODC sign up with Pronounced Technologies

Content Partner with MSN & Yahoo India

2002

Application Development Projects with LTA , GECIS, World Bank, Lafarge, ICICI Bank

Started competency development in GE Smallworld

2003

ODC for a global leader in digital map data, GM Onstar, SLA, SG Land Hub, Web GIS JTC Singapore, Laserscan

All NRPS Projects got Renewed, DMDRS from UK, GDW, Saudi ARAMCO, MJ Harden

OPC for a global leader in digital map data, SLA, LTA, PipeView Soln

SLA, LTA, Express-07,Tietoenator ,PowerOn PNI Defect Resolution

Leading Telecom Service Provider, Belgium, UPRR, A large insurance company in US , Prime Infrastructure Insurance Specialist in Switzerland , SLA, PVDS, Developed competency in Mobile GIS and Bing Maps

2010

Received various international awards from various clients across the globe

2009

Developed competency in Open GIS

Significant Milestones - Projects

2011Setup Telematics Center of Excellence

2012

Optus GIS,UPRR, Shell GIS


GIS Consulting

• Assessment

• Strategic Planning

• Technology Feasibility Study

• Project Management

• Data Quality Management

Strategic Service Offerings


GIS Application / Product Development and Integration

GIS practice has cutting edge experience in Application / Product Development which includes

• Requirement Analysis

• Design / Development

• Integration

• Testing

• Deployment

• Maintenance and Support



GIS practice has extensive experience in Spatial Data Management which Includes

• Analyzing existing dataset

• Preparation / updating of spatial data

• Database fine tuning

• Spatial data modeling

• Creation of symbology

• Spatial data integration services

• Projection and transformation

• Development of QC / QA tools

• Development of tools for automating data capture

• Development of tools for data migration and data updating


Spatial Data Management


Remote Sensing Land use/land cover morphology data

(used in wireless network planning) Vector Updates Telecom

Road Data Generation Semi Auto Process Applying 3d coordinates from high

accuracy DEM to 2D features captured from ortho-photos

3rd Dimensional Products Stereo Imagery for 3D - Elevation

Models Applying 3d coordinates from high

accuracy DEM to 2D features captured from ortho-photos

Spatial Data Management contd..



Cartography Geo-database

Including topology cleaning to correct hanging/ overshooting segments and incorrect

common boundaries between adjacent area polygons, attribute data linking, edge

matching to facilitate seamless geo-database development




Positional Accuracy Improvement

A solution to the issues raised by the PAI programme is to transform user’s data

automatically using the link files and then to post-process the data to resolve any

residual problems




Data Extraction and Conversion

Conversion services take various paper based data, electronic files, and library databases and convert these into electronic data for web delivery or for use in other in-house applications

Image Mosaic facility to create seamless database




ESRI

Smallworld

Autodesk

MapInfo

Bentley

FME

OGC

Technology


Spatial Data Management

AM / FM


Belgium

Application / Product Maintenance

A large insurance company in US


Belgium

Application / Product Development

Prime Infrastructure

Insurance Specialist in Switzerland


BelgiumLeading Fortune

500 Company

Key Clients


Infrastructure Planning Services

Location based Services

E-learning

Leading Fortune 500

Company

Key Clients


Delivery Model

System Upgrade, Application

& Data Migration

Onsite

Web based Property &Land

Management system

Onsite

Consolidated GIS solution

Onsite

Product bug fixing Support

and Maintenance

Offshore

Utility Major

Intranet based Asset

management and maintenance

OnsiteOffshore

Leading Telecom Service

Provider, Belgium

Key Customer Engagements


• First Global Alliance Partner for GE Energy NRPS for their Network Reliability Software Products

• Leader in providing customer focused competency solutions

• Significant footprint in various geographies and vertical industries. Large full cycle SDLC projects across 4 continents and 10 countries

• Strong GIS Project Management Practice

• Domain expertise in industry verticals like Transportation, Water, Telecom, Power, Utilities and Infrastructure

• GIS Consulting assignments with World Bank, Singapore Land Authority, Jurong Town Council and so on

• Vast experience in executing multi-vendor environment projects

• Ability to ramp up resources at short notice

Strengths

21Copyright © 2013 Tech Mahindra. All rights reserved. 21

Integrated Engineering Solutions

GIS Case studies


Project needs

• Development of a mobile based GIS field data collection system

• Mobile database synchronization with the central database

• Archive layers

• Generate reports

Benefits to customer

Project details

• Following modules were developed to address the requirement

–Checkout / Check in layers to mobile in ArcGIS 9.2

–Capture spatial and non spatial information through a customized ArcPad Application on mobile device

–Job Record Reports & Archival tools were developed in ArcGIS 9.2 Environment

• Paperless environment

• 50% reduction in field data collection time

• Data security achieved through data encryption

• Supervision on field officers

• Facility to capture Imagery and non spatial data

Mobile GIS Land Asset Management System – Singapore Land Authority


Project needs Project details


To develop a GIS based national infrastructure system ( LandNet) for Singapore Land Authority to enable government and private agencies for an on-line exchange and access to heterogeneous land data.

• Extract, Migrate and store shareable data from the agencies (GIS and CAD formats) to the Oracle

spatial DBMS.

• Ensured extracted and exported GIS data from the Oracle Spatial DBMS will maintain all topology information of the respective GIS data formats.

• Land Net admin module was developed using ArcGIS, J2EE

• Government agencies & private companies will use the LandNet data for their operations

• Land Net is the central hub of land Information related to Singapore Country

• Download the LandNet data at a nominal rate

• Access at any time any where

• Scalable to more users

LandNet – Singapore Land Authority




•Migration of existing INLIS to Microsoft .Net environment based on standard web services architecture

• Development and enhancement of application modules in .Net environment

• The technologies used for the development were Microsoft .Net (ASP.NET, C#), ESRI ArcSDE & ArcGIS , Oracle 10g

• Access from anywhere any time

• User friendly interface • 24*7 support

• Number of users – Unlimited

• Application Migration of existing INLIS to the web service enabled technology platform • Development & maintenance support of a fully operational Integrated Land Information Service (INLIS) for the SLA .

Integrated Land Information Service – Singapore Land Authority


•User can search for land parcel and application will show whether it is private land or public land.

•Users can view Wireless coverage area and non Non-coverage areas (Wireless@SG).

•Users can get information about wireless points available by clicking on wireless hotspot points (Wireless@SG).

Wireless@SG Coverage Map is a free service that allows users to search Wireless@SG coverage areas and to locate them on a map.

Using the search keys, the users need to find the nearest Wireless@SG hotzones and hotspots in the vicinity of the users destination or current location.

The applications were developed based on the following • Microsoft .net 2005• ArcGIS Server 9.2• ArcSDE 9.2• Oracle 10g

Project Needs Project Details

Benefits To Customer

SG Land Hub – Singapore Land Authority



.


Migration of existing application and to develop a new CADMAP system to maintain the records of comprehensive and precise definition of all land parcels (land lots) in Singapore.

• Precise information of all land parcels in Singapore.

• Automatic process for updating the parcel data

• Reduced the survey verification time by 60%

• Upgrading the existing geodatabase and existing applications to the new ArcGIS 8.3

• Development of verification tool using VB, Arc Objects & Oracle 9i

CADMAP – Singapore Land Authority



.


• Migration of existing CADMAP Modules from ArcGIS 8.3 to 9.0

• Development of control points, Land records & survey management sub system using Arc Objects & Oracle 10g

• CGS has become a common GIS platform to serve the most of the GIS needs Singapore

• 24 * 7 support & maintenance

• Scalable to more users

• Development of Control Points Sub System (CPS)

• Development of Land Records Sub System (LRS)

• Development of Survey management Sub System (SMS)

Consolidated GIS System (CGS) – Singapore Land Authority


Project needs

• To analyze, design and enhance the Road information management System

• Install and maintain the Enhanced Road Information Management system

Benefits to the customer

• Data integrity & Information sharing

• Standardized & structured process for various submission types

• Efficient data capture, maintenance and administration

• TAAM to help in road safety engineering, traffic accident details & traffic accident locations analysis

Project details

Following modules developed to address the requirement

• Web based Submission Processing Module [SPM]

• Geographic Data Management Module [GDM]

• Traffic Accident Analysis Module [TAAM])

• Data migration from ArcStorm Database to ArcSDE Geo-database

• Interfacing with external and internal systems

Collision between a through vehicle and a right turning

vehicle

Enhanced Road Information Management System – Land Transport Authority


Project needs

• To minimize operation time for allocating and parcelisation of land

• To develop Intranet based solution to optimize their operations and increase their customer responsiveness

• To seamlessly interact with different business support systems

• To upgrade from MapInfo GIS, CAD to ESRI ArcGIS Environment


Project details

• Integrated GIS system to manage diversified spatial databases

• Internet / Intranet-based GIS for distributing data and services across web users

• First implementation of ArcGIS 9.0, worldwide

• Interface to seamlessly interact with different business support systems

• Improved productivity, efficiency in workflow

• Centralized information repository

• Accelerated decision-making process

• 24 & 7 web services

Web GIS – Jurong Town Council


Project needs

• Develop a Field Data Collection(FDC) Application to

– Collect data and support GIS implementation

– Field validation of existing data– Add new data to support expansion of GIS

applications– Maintain existing facility database


• This application is being sold as a Product• Totally parameterized and all the forms are

dynamic So it can be used as a product• Improved efficiency in data collection• Provide up-to-date facility information for

mobile workers & reduce dispatch support time

• Maintain accurate spatial data at enterprise level

• Cuts-down the cost of manual digitization

Project details

• Developed the FDC using ESRI ArcPad, .Net, C#, & Sybase

• Customer visited Satyam location to freeze requirements & design

• Fully executed from offshore

• Customer worked with offshore team for 3 weeks to freeze requirements and design Dynamic

FormsSpatial Data

EditingSpatial Layers

FDC Application - M J Harden


• Rich set of functionality intuitive, easy to use, flexible, and nice look and feel user interface in ArcGIS.

• Superior platform for data management is provided utilizing the ArcGIS Pipeline Data Model (APDM).

• Pipeline integrity management, with improvements in productivity, cost reduction and cost avoidance.

• SheetGen provides up-to-date, construction-quality drawings of a pipeline system for field use

• SheetGen provides analysis and decision-making purposes.

• Customer was in need to develop a Desktop application specifically for Oil and Gas Pipeline users those who hosted their existing solutions on ESRI platform.

– Need to improve the SheetGen functionality in the Pipeline market by implementing a rich set of functionality intuitive, easy to use, flexible, and nice look and feel user interface in ArcGIS

– Enhance the SheetGen functionalities for better analysis and decision-making purposes.

• Express07 product developed contains following modules:

– Configure SheetGen - ArcGIS Properties window configure the ArcGIS environment to create Alignment Sheet Map windows and generate them.

– Band Manager — to define bands, and associate tables which feed data to the bands.

– FormatSheet Wizard — to format alignment sheets and the bands within the sheet.

– Generate Sheet — to generate and display alignment sheets.

Project Needs Project Details

Benefits To Customer

Express07 - Leading Fortune 500 Company


Project needs

To develop a web based Project Progress Monitoring System to monitor the project progress of road construction work via. Web

Project details

The GIS application for viewing spatial data is developed using ESRI’s standard Arc IMS enterprise product and PostgreSQL an open GIS database software for the backend database. The user interface page was designed using Java script.

The users can access the application using any HTML or Java browsers. The application developed is based on n-tier architecture.


• Project Progress monitoring access at any where• Option to upload the project progress details in the

(.MPP) format to PostgreSQL DB• Dynamic segmentation of the linear features and

showing the project progress of these segments with different colors representing the percentage of completion of the work with regard to the segment

• Facility to attach ground photographs to spatial data to get ground scenario.

Project Progress Monitoring System




• Integrate Arc GIS desktop 9.2 with SAP BW using OLAP plug-in

• Visualize the business intelligence data fetched from SAP BW in Arc GIS Desktop frame work • Analyze the SAP data using GIS tools to generate maps and reports

•Generate map based reports using SAP Bex map

•Visualize geographic (location based) business data on maps•Provide an easy and intuitive way to detect and analyze regional patterns (e.g. market trends)•Allow interactive information analysis on maps•Select and filter (e.g. regions or customers)•Filter (e.g. country) and drill down (to e.g. regions)

The application is developed using Arc GIS desktop 9.2, SAP BW and OLAP plug-in.

SAP – ArcGIS Integration : GIS with ERP




Development of a web based Decision support system for providing earlier warnings to the community in case of emergencies. The system should have the facilities to register the incident by drawing a polygon on a GIS map, modify the incident details and initiate the call out to the people within the polygon.

The web based application was developed using ESRI ArcGIS Server. The web user draws the polygon of the affected area and registers the incident. The adminstration user can extract the details of the people to be notified from the data base.

• Near real time communication of the Incident information along with spatial extent of the incident

• Efficiency in identification of the affected population which helps in communicating early warnings

Community Information and Warning System : DMS


Broadband Business Strategy support using GIS – Biggest business group in India

Project needs

•Define a Enterprise GIS framework where in all users can fetch the centralized Geodatabase•Make available to users the latest Map information for Planning & Engineering•Seamlessly integrate the GIS data to other systems such as Network Inventory (SAP), Workflow, Google Earth•Help field crew to identify and navigate network fault locations on Google Earth & ArcGIS

Project details

•Published the best practices for both LTE & FTTX Network Planning & Engineering•Implemented Enterprise GIS using ESRI ArcGIS & Google Maps Technology•Integrated Inventory Management and GIS•Google Earth & Mobile Maps used extensively for validation of OFC & Network Elements in field•Developed custom applications on top of Google Maps & ESRI for Sales & Distributionafety.


•Accurate location and Fiber Lengths will be generated without field •Integration of Network Analytics helped in identify and rectify fiber cuts•Latest Map information available to users• Users can fetch and analyze Network Asset data on Google Earth•Reduced GIS software costs as most of the GIS apps are browser based•Users can seamlessly access GIS data across the organization safety.



.


• Data discovery with Metadata Catalogue built using GSA

• Map data visualization using ESRI Flex Map Viewer

• Sharing of Agency data via data transformation using FME Server 2011

• Collaboration via Spatial Communities – Oracle WebCenter 11g

• Registering of Data Services via Oracle SOA Framework

• Common Map, Vector/Raster & Network Geo-Processing Services exposed via integration of ArcGIS 9.3 and Oracle 11g Enterprise Service Bus

• 85% of government agencies contributing and sharing data via GeoSpace

• 95% of existing spatial data layers from agencies are sharable via GeoSpace

• 95% of spatial data layers adopted GeoSpace metadata standards which resulted data to be searched, discovered and used by agencies

• One of the key outcomes of a whole-of-Singapore-government initiative to unlock the vast potential of public sector data

• Accessible to over 6000 Public Officers across 35 Singapore Government Agencies

• Over 400 Real Time Map Data layers covering Health, Environment, Utilities, Socio Economic Information for making better and informed decisions by Agencies

GeoSpace – Singapore Land Authority


Google Maps API SQL Server 2005, Javascript, Dojo UI Framework, SQL OLE DB

Scope

Tools

Deliverables

Smartgrid and GIS Integration

Highlights

Geographical representation of each meter in Google Map Dashboard of meters to chose Dynamic update of the meter status Popup for displaying the attributes of each meter Graphical representation of meter’s history data

Realtime tracking of Meter Readings on Google MapsGraphical analysis of the meter readings history

Source Code


Thank you

Contact :

Sid Vyawahare

Program Manager- GIS

Tech Mahindra

Ph: +91 80 6780 8094

Email: [email protected]