Project Sql Server

Venkateswarlu Nittala

*** * ******* ** *************,CA. *********@*****.***

Phone 415-***-****/630-***-****

Would like to implement as required GeoSpatial Big Data Solutions using Geomesa, GeoServer, MapBox,OpenLayers or Leaflet Map with EMR or Hadoop Based System and want to solve Spatial intelligence World hunger.

Education: Master of Science & Technology in Geophysics, Andhra University, India. Roles & Responsibilities performed so far

• GIS Tech Lead/Developer with 17 years of experience in designing, developing and maintaining software applications ranging from medium to very large scale applications in large multinational organizations in various countries. Sectors include: Electric, Oil, Gas & water utilities, transportation, and telecommunication industries.

• Hands on experience on writing FME Scripts and FME Server Administration

• Extensive experience managing GIS database applications using Oracle and MS SQL Server, PostgeSQL with PostGIS,AWS Aurora, RDS PostgreSQl, RDS SQL Server

• Have a knowledge to implement Geomesa using AWS EMR and Geoserver to handle large GIS datasets size of TBs.

• Experience in Inmemory Database and Big Data Concepts, Spark etc.

• Implemented GIS Systems in AWS for Electrical Asset Risk Management

• Developed GIS ETLS for GIS Data Mart using FME and Python, Spatial SQL.

• Built Geo Data Mart for Gas and Electrical Utility using Kinetica GPU DB

• Built a web application for Electric Asset RiskManagement using Spark, GraphQL, AWS Aurora, PostgreSQL RDS with PostGIS, Geo Server and Leaflet Map.

• Developed and Implement GPS/GIS Mobile Applications.

• Little knowledge on deck.gl Map Frame work.

Skills

PROGRAMMING & SCRIPTING : C#, SQL, PL/SQL, Python, JavaScript, JQuery,Node OPERATING SYSTEM : UNIX, Mac, Windows

DATABASES : AWS Aurora, RDS PostgreSQL, Oracle, MySQL, SQL Server, PosgreSQL IDE : Microsoft Visual Studio, Eclipse

GIS : Geodatabase, FME ServerArcMap,

ArcCatalog, Arc ToolBox, ArcPad, QGIS, PostGIS,

Java Scrip API, REST API

Experience

October 2013 – present Programmer Analyst Expert /GIS Lead Pacific Gas and Electric Company San Faransico, CA May 2007 – September 2013 GIS Lead Developer Indsoft, Inc,USA July 2005 – October 2007 GIS Developer HCL, Singapore December 2002 – June 2005 GIS Developer SHELL, Oman Aug 99 – Dec 02 GIS Developer Reliance Digital World, India Projects

Project Title: Electric Distribution and Asset Management GIS The PG&E EDAM GIS project will convert and enhance PG&E Electric Distribution (ED) asset data into an integrated GIS/SAP system and provide analytical and visualization tools to enhance ED asset management and operations, will enable improved decision making and innovation from a safety, compliance, reliability, and productivity perspective. Currently developing a models for Electric Asset Risk Score and Health Score using Big Data Technologies and GIS which will prioritize 10000 assets out of 2.8 million assets. Client : Pacific Gas & Electric, San Ramon/Walnut Creek, CA Project Title: Mariner Integrity & Risk Analysis Project This project will install 6 Integrity Management software tools, in an effort to enable industry standard software technology for integrity analysis and enhance safety. Client: CSX, Jacksonville, FL

Project Title: Positive Train Control - Rail Road (PTC) Positive Train Control (PTC) systems are integrated command, control, communications, and information systems for controlling train movements with safety, security, precision, and efficiency. Client: PACIFICORP, USA

Project Title: Hydro, Oil and Gas Compliance Inspection - Mobile GPS – Electric and Gas Utility

It provides Gas and Hydro Operations (Engineering) with a toolset for performing inspections on water conveyance facilities, storing the inspection data centrally. Client: Singapore Land Authority (SLA)

Project Title: CGS (Consolidated GIS System). - Transportation SLA is responsible for maintaining records of comprehensive and precise definition of all land parcels (land lots) in Republic of Singapore. The objective of the project is to develop a system which serves as a common Geographic Information System platform for SLA. Client: Urban Redevelopment Authority of Singapore(URA) Project Title: iPLAN- Integrated Planning and Land Use System - City Planning Client: Singapore general hospital

Project Title: DOTIIS – Digital Operation Theatre Information Integrated System - Health DOTIS shows the patient detail, location when a patient registers for an operation. It sends SMS and receives SMS from Patient relatives. It uses WiFi technology to find the patient location. Project Title: PIPELINE MANAGEMENT SYSTEM – Oil and Gas System manages the oil exploration, oil pipelines construction, maintenance. Project Title: Telecom Network planning & land use system System manages the telecom network GIS database and fiber optic network planning

Contact this candidate