GIS/ESRI

Prabhakar Rao G

Ph. # 1-817-***-****, Email: ***************@*****.***

Professional Summary:

Over 11+ years GIS IT Domain experience in application design, development, testing and technical support and guidance in ESRI ArcGIS Desktop & Web based products technology and open source tools.

Experience working in all stages of Software Development Life Cycle (SDLC) including Requirements, Analysis and Design, implementation, integration and testing, deployment and maintenance.

Hands on experience in creating and analyses maps, cleaning and updating spatial data using ArcGIS for Desktop 9.x/10.x

Experience in customization, such as a collection of tools on a toolbar that plugs into an ArcGIS for Desktop application using VBA, Python, ArcObjects and ArcGIS Engine.

Experience in developing python programming script to automate the GIS tasks.

Hands on experience in Development of Web GIS Applications using ArcGIS API for JavaScript/DOJO/JQuery/HTML/CSS

Hands on experience in creating applications using C#, VB, ASP.NET, ADO.NET, XML, HTML, JavaScript, jQuery and JSON

Migrated existed GIS web applications from Arc GIS Server 9.3 .Net Web ADF to Arc GIS Server 10 .1 Net Web ADF.

Hands on experience in create and publish map services using ArcGIS Server, Geoserver, ArcGIS Online and ArcGIS for Portal.

Experience in enabling OGC standards ie., WMS, WFS, WPS, KML into the GIS Service.

Created and Validated Topology rules for the features for fixing the Topology errors.

Experience in Transform data and Automate Workflows using FME Desktop, FME Server.

Experience in creating and securing map services using ArcGIS for Server 10.x

Experience in Data Models for ArcGIS, Geodatabase Database Design, Versioning, Domains, Subtypes, Reconcile, Posting and replication with ArcSDE for SQL Server, ArcSDE for Oracle and ArcSDE for PostgreSQL

Added additional map services, query task services to the developed application, with the updated GIS resources during the production support.

Provided privileges (read, insert and delete) based on the revised departmental groups and users associated with the project during the support.

Developed scripts and SQL queries for the clients based on the information to be extracted during the production support.

Experienced in preparing and executing Geoprocessing tools with Python/ArcPY.

Used Arc Scripts and Arc GIS Extensions for performing better QA/QC process

Experienced in using TFS for handling file versions, storage and build automation.

Experienced in SSIS and SSRS reports for SQL Server.

Knowledge in Microsoft Release Management

Experience in carrying out projects through Agile/Scrum Software Development Methodology.

Actively involved in various phases of testing. Extensive experience in Problem Resolving and Performance tuning and Recommendations.

Hands on experience in Team Coordination, Team Management, Task Allocation and providing Status Reports, Managing Issues and Concerns.

Educational Qualification:

Bachelor of Mechanical Engineering from Andhra University, India.

Project Summary:

BNSF Railway, Fort Worth, Texas – GIS Developer/Tech Lead

1.BNSF TSM P&A Jan 2016 to current

Assisting BNSF GIS team to Design and build-out of an Enterprise GIS Publication Workflow and Delivery of a suite of Enterprise Map Services to integrate physical changes-CMP process into GIS System.

.

Responsibilities:

Developed ArcGIS/ArcObject add-in tool to report log file for matched and unmatched attributes ie., CLIC_NBR, M-Values, LINE_Segment_NBR values between NCS and ENG Track lines across DEMARCATION point.

Developed Python Add-in tool for Generalization to reduce the vertex count for track center line data without changing the geometry shape.

Creating and publishing different type of GIS services.

Developing Web map application created in ESRI ArcGIS Server using JavaScript API to loading all rail data ie., track center line, switch points, turnouts, mile post, demarcation point on the map. BNSF officers performing for spatial and attribute queries and search and tracking the data by Routeid, Rail owners, Sub-Division and Track type.

Design and Development of enterprise Geodatabase using ArcCatalog, ArcGIS SDE and SQL server.

Schema finding and compare between NCS and Engineering database.

Developed ArcGIS Add-in tool to compare Field and data type of Track center line data and other features classes file between NCS and ENG database those are coming from different RDBMS and report a log file.

Installed and Configured Arc GIS Desktop and ArcGIS Server.

Analysis of the specification provided by the clients

Involving in Designing High Level and Low level documents

Alternative analyses of migration and Estimation

Involved in developing application architecture

Design and development of new solution

Enhance and Troubleshooting

Technical write-ups and application user guide documentation

Tool documents preparation and Demo’s with customer/ product owners.

Environment: Visual Studio 2012, ASP.NET, C#, .NET Web Services, Python, ADO.NET, ArcSDE 10.3.1, SQL Server 2012, ArcGIS Server 10.3.1, ArcGIS for Desktop 10.3.1, IIS 7.0, ArcGIS Javascript API, Dojo.

Chevron - PAD BAS Apps Services, Houston – GIS Developer

2.QGIS-CNAEP October 2012 to Dec 2015

QUORUM GIS Desktop and QUORUM GIS Web applications which it gives you the power to capture and maintain, query and analyze, and explore and visualize the corporate data, currently held in other Quorum Systems, such as Land, QCM and QRA.

Responsibilities:

Automated GIS tasks by preparing Python Add-ins scripts such as intersect, adding fields/deleting unnecessary fields. Populate missing attributes, Remove invalid records (null data records, etc.)

Developing GIS Web map application which was created in ESRI ArcGIS for Server using JavaScript API/HTML/DOJO/CSS. Petroleum engineers were doing well search for spatial and attribute queries and editing data on top of the map.

Design and Development of enterprise Geodatabase using ArcCatalog, ArcGIS SDE and Oracle environment.

Develop custom tools, including the ability to select and retrieve attributes from a single, or multiple event details by API codes.

Analysis of the specification provided by the clients

Usability and impact analysis

Alternative analyses of migration and Estimation

Involved in developing application architecture

Design and development of new solution

Technical and application user guide documentation

Responsible for quality deliverables to onsite

Coordination with onsite manager and customers

Following of Chevron compliance processes

Following of Chevron Incident, change and release management

Resolved the build breaks and issues within SLA timeframe

Deploying and Training.

Environment: Visual Studio 2010, ASP.NET, C#, .NET Web Services, Python, ADO.NET, ArcSDE 10, Oracle, ArcGIS Server 10, ArcGIS for Desktop, IIS 7.0, ArcGIS Javascript API, Dojo.

3.Contractor Requisition Webform (CMPortal/ITCMPortal)

This web application is for match engineering and technical manpower needs with global resources and provides users with an efficient and reliable tool in on-boarding personnel.

Responsibilities:

Involved in the analysis, design and support of the project life cycle.

Designed and developed Web pages using C#, ASP.NET.

Coded Client side validations using Java Script, jQuery.

Involved in writing and modifying Queries, views, and tables in SQL database.

Interacting and discussing with users and fixing the reported issues.

Designed and developed various levels of security measures such as data access and login privileges according to the levels of user’s login.

Involved in business meetings to gather additional requirements for the application.

Coded/designed web pages according to the Coding standards

Created numerous reports using SSRS.

Involved in, but not limited to Enhance, Testing, Bugs Fixing, and Issues meeting to achieve zero bug convergence.

Environment: Visual Studio 2010, ASP.NET, C#, .NET Web Services, JavaScript, JQuery, CSS, SQL Server 2010, SSRS, IIS 7.0, and Windows Server 2008.

4.Coastline Updating Project-GIS Developer June 2011 to October 2012

This project is for capturing the Spatial Features like Coastal Areas, Lake Areas, Rivers, Islands, Roads, Railway Lines, Ponds and other features in Atlantic Spain and North America Areas from Google Earth. The AOI is as per Coast-ID wise.

.

Responsibilities:

Develop and implemented ArcGIS Add-ins for Desktop Automation component using Arc Objects with C#.Net and create Python scripts for this project for getting total length of features those are intersecting within 7.5x7.5 Degree each cell and report the total length for each polygon feature class. And also an Automation tool is developed for Quality checks like Topological Errors, Attribute Errors.

Automated geo processing tasks for the dissolve, union & frequency analysis tools.

Automated the process of selected polygon geometry attributes on the fly.

Created all the automation using Add-Ins.

Supported in debugging the errors that creped in while running the application over the browser end during the support of ESRI’s Arc GIS Server .net ADF application.

Installed ESRI Enterprise tools – Arc GIS Server .net ADF, Arc SDE

Arc SDE Administration and Configuration

Created different versions of geodatabase for multiuser editing.

Provided privileges (insert, update, select and delete) for the users.

Developed a Marine Viewer a Web-based mapping application for marine safety navigation purpose. ArcGIS Server with Microsoft Web ADF is being used as the map service technology. The map service is consumed by ASP.NET application developed in C#.NET. HUB users visualize, query and edit the correct Feature classes like Contours, Depth area, Lake Area and other features for sending into the market version, and they are querying and finding the Coast lines as per ID for any data discrepancy.

Prepared project documentation.

Environment: Visual Studio 2008, ASP.NET, C#, .NET, VBA, Python, Arc SDE, SQL Server 2005, ArcGIS Server 9.x, ArcGIS for Desktop, IIS, ESRI ArcGIS Microsoft WEB ADF.

5.DUP Lakes-GIS Developer/Analyst April 2010 to June 2011

This project is for capturing all Lakes Area Spatial Features in entire us regions, and updated the most recent data into existing geodatabase. The National Agriculture Imagery Program (NAIP) is the source for data capturing.

.

Responsibilities:

Requirements gathering and study for the project.

Developed and implemented ArcGIS Add-ins components using Arc Objects with C#.Net and create Geoprocessing Python scripts for this project for getting length of features those are intersecting within 7.5x7.5 degrees each cell and report the total length for each polygon feature class. And also an Automation tool is developed for Quality checks like Topological Errors, Attribute Errors.

Developed a DUP Lake Viewer a Web-based mapping application for checking the production completion of lakes. ArcGIS Server with Microsoft Web ADF is being used as the map service technology. The map service is consumed by ASP.NET application developed in C#.NET. HUB users can check and verify the status of lakes completion on daily basis and they are querying and finding the Lakes as per Lake-ID for any data discrepancy.

Developed custom tools using Arc Objects in Arc GIS Desktop 9.x

Creating Domains to avoid data discrepancy.

Created Arc Objects tool to Validated Topology rules for the features for fixing the Topology errors and evaluating attribute errors.

Environment: Visual Studio 2008, ASP.NET, C#, .NET, VBA, Python, ArcSDE, SQL Server 2005, ArcGIS Server 9.x, ArcGIS for Desktop, IIS, ESRI ArcGIS Microsoft WEB ADF.

6.SKI i-Phone and OMNIA Integration-GIS Developer Feb 2008 to March 2010

This project is to provide ski resorts information details for the skiers. The Process starts digitization of Ski Lifts (all type of lifts), Trails, Routes and junctions from Google Earth. Java Open StreetMap editor is used for digitizing all the above said features. If required download plug-ins from JOSM. Finally, data is uploading into the JOSM server.

.

Responsibilities:

Develop Automation tools for Conversion and Geo-processing Tools with Arc objects using C#.Net and Python like converts Shape files to Geodatabase, query and export, etc.,

Developed Arcobject component tool to Find and report duplicate features between two-point shape file datasets with 1000m buffer distance and report the information into attribute table

Develop tools for Topology checks, Attribute Data Editing and Validating on Tables

Developed custom tools using Arc Objects in Arc GIS Desktop 9.x

Creating Domains to avoid data discrepancy.

Project and Tool document preparation and demo’s with customer/ product owners.

Environment: Visual Studio 2008, ASP.NET, C#, .NET, ArcSDE, VBA, Python,

SQL Server 2005, ArcGIS Server 9.x, ArcGIS for Desktop, IIS

7.ONS Raster’s and Land base- GIS Developer/Analyst April 2007 to Feb 2008

This project provides navigation details for the hikers, bikers and skiers, layers like roads, city names, and municipal boundaries etc. Topographic Charts / Aerial Images Different Trails (Cycle, Hiking and Biking) will be captured, routing and database will be prepared

.

Responsibilities:

Requirements gathering and project analysis.

Installed and Configured ArcGIS and Arc SDE for SQL Server.

Worked with COM objects for developing the required tasks.

Developing GIS applications using Arc objects C#.NET that helps in Querying, Symbolizing, and Map producing and Customizing ArcGIS interface to support holding geographic data. Add all required feature classes from customized menu to data frame with specific symbology and export as raster files.

Develop ArcGIS desktop tools for Topology checks, Attribute Data Editing and Validating on Tables.

Environment: ESRI ArcGIS, ArcObjects, C#.NET, VBA, ArcSDE, SQL Server 2005

8.GPS survey-GIS Mapping Application May 2005 to Feb 2007

This project is to assisting state Municipal Officers to preparing Maps for Tax Purpose, collecting all information like parcel number, parcel id, owner name and other consumer details. Collecting spatial and non-spatial details and integrate into GIS Maps.

.

Responsibilities:

AS a GIS Specialist, Requirements gathering, Planning and executing the spatial and non-spatial data with survey team and mapping team.

Coordinate with clients and shared weekly progress, participate in meetings.

Developed a Tax Parcel Viewer a Web-based mapping application for viewing and querying all parcel owners for. ArcGIS Server with Microsoft Web ADF is being used as the map service technology. The map service is consumed by ASP.NET application developed in C#.NET and ArcGIS Server 9.x.

Develop ArcGIS desktop tools to validate for Topology and Attributes errors.

Environment: ESRI ArcGIS, ArcObjects, ArcGIS Server, C#.NET, VBA, Microsoft Access, AutoCAD, Mapinfo

Technical Skills:

Project Plan & Design Tools

MS Visio 2000

Communication Modes

AT&T & Web Ex

GIS Technologies

ESRI Arc objects, ArcGIS Online, ArcGIS Portal, ESRI ArcGIS Desktop/ ArcGIS Server, ArcGIS Engine, Python, ESRI ArcSDE, Global Mapper, FME, Open Layers, AutoCAD, Web AppBuilder, JavaScript API, JQuery, DOJO, HTML, CSS, Bootstrap, JSON, Firebug, Angular JS

Timesheet & Reporting Tools

Internal Software

Web Servers

IIS

Backup Tools

MS VSS and TFS

Languages

C#, VB.NET, ASP. Net, ADO.NET, SSRS, SSIS, FoxPro

Scripting Languages

JavaScript, VBScript

Reporting Tools

Cognos Reports, Crystal Reports and SSIS/SSRS

RDBMS

MS SQL Server 2000 / 2005 / 2008, Oracle, PostgreSQL

Domain Knowledge & Industry Experience

GIS & Government; Utilities, Electrical, OIL and GAS, Forestry, Railway, Municipality, Marine S57 Objects., Roads, Agriculture

Certification Skills

Web Application Development Using Microsoft .Net Framework 4.0.

Microsoft Certified Professional: MCID:11521693

Awards:

Received “Most Time Saving” award from Navionics Technologies, for creating ArcObjects Components/Add-ins.

Received “Certificate of Appreciation” from Chevron for doing hard work and dedication to support of their applications.

References:

Available on request.

Contact this candidate