SUMMARY

• Over 13+ years GIS/GPS (Geographical Information Systems) Applications & IT Domain experience in application design, development, testing and technical support and guidance in ESRI and Open source tools & technologies.
• Hands on experience in creating and analyses maps, cleaning and updating spatial data using ArcGIS for Desktop 9.x/10.x and ArcGIS Extensions
• Experience in customization, such as a collection of tools on a toolbar that plugs into an ArcGIS for Desktop application using Arc Objects/VBA/C#.Net and ArcGIS Engine.
• Experience in developing Python/Arcpy programming scripts and Model Builder to automate the GIS tasks.
• Hands on experience in Development of Web GIS Applications using ArcGIS API for JavaScript/DOJO/J Query/HTML/CSS/JSON
• Experience in GPS data collection with Geo Trimble XH and export into GIS System.
• Hands on experience in GIS principles, concepts and QA/QC process
• Performed Analysis using Spatial Analyst, 3D Analyst, Google Earth Pro, Geographic Analysis, Geocoding, Network Analyst, Linear Referencing.
• Hands on experience in creating and publishing map, feature & geoprocessing services using ArcGIS Server 9/10.x, Geo Server, ArcGIS Online and ArcGIS for Portal.
• Experience in enabling OGC standards ie., WMS, WFS, WPS into the GIS Service.
• Created and Validated Topology rules for the features for fixing the Topology errors.
• Experience in Creation and maintaining Geo - databases including Data Models for ArcGIS, ESRI Geodatabase Database Design, Versioning, Compressing, Spatial Indexing, Domains, Subtypes, Reconcile, Posting and replication with ArcSDE for SQL Server, Oracle and PostgreSQL
• Experience in development, administration and testing of Enterprise GIS and Database projects using ESRI, Microsoft and Oracle based technologies
• Plan, design of conceptual, logical, physical entity-relationship diagrams for database physical schema creation. Data migration from different GIS datasets using ETL tools, Jobs creation & scheduling and report creation.
• Creation & scheduling daily, weekly, monthly and quarterly batch jobs using FME ETL, ESRI Objects, Data Interoperability tools based on customers’ requirements
• Liaise with vendors, stakeholders and internal customers, Production DBA’s regarding spatial data integration and spatial data processing.
• Support to Enterprise business applications, database maintenance activities, and resolve issues in timely, accurately with committed SLA
• Experienced in SSIS and SSRS reports for SQL Server.
• Write complex Structured Query Language (SQL) queries as per requirement.
• Knowledge on Amazon Web Services (AWS).
• Knowledge on Hadoop distributed file systems HDFS, HBase, PIG, HIVE, Sqoop and Flume.
• Experience in carrying out projects through Agile/Scrum Software Development Methodology.

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, ArcGIS Runtime SDK,QGIS, Google Earth, Google Maps API, FME, GPS,Open Layers, AutoCAD, Web AppBuilder, JavaScript API, JQuery, DOJO, HTML, CSS, JQuery Mobile, Bootstrap, JSON, Firebug, Angular JS, uDIG, GITHUB, GeoJSON

Web Servers: IIS

Backup Tools: MS VSS and TFS

Languages: C#, VB.NET, ASP. Net, MVC,ADO.NET, FoxPro

Scripting Languages: JavaScript, VBScript

Reporting Tools: Informatica, 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/Cadastral, Watershed, Sewerage Network

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

GIS Developer/Analyst

Responsibilities:

• Designs, develops and maintain software using ESRI software suite as well as programming tools including .NET, JavaScript API, JSON and Python.
• Analyzes and interprets complex business rules, methods and practices.
• Performs database design modifications using MS SQL and PostgreSQL.
• Develops programming specifications for assigned tasks.
• Generate DDL & DML to create the objects necessary to implement in the relational DBMS
• Creating primary and objects such as Tables, Views, Indexes, Functions, Procedures, etc. Modifying the database structure as per requirement
• Analyzing and publishing DOH Parcel datasets and other region boundaries.
• Geocoding the parcel address data and loading parcel attribute information.
• Create program source code, performs standardize validation tests and debugs code when issues are identified.

Environment: Visual Studio 2013, C#, NET Web Services, Python, ArcSDE, 10.3.1, ArcGIS Server 10.3.1, ArcGIS for Desktop 10.3.1,0, ArcGIS JavaScript API, JSON, SQL Server 2012

Confidential, Atlanta, GA

GIS Specialist/Developer

Responsibilities:

• Developing the interface to display the KMZ/KML data into Google Maps using JavaScript API in PTS program.
• Configuring and troubleshooting applications using ESRI ArcGIS Desktop, ArcGIS Server and ArcGIS Portal tools.
• Design and Implement the GIS tool component and develop the GIS Workflows
• Develop Python scripts to automate the tasks i.e., extract binary GIS data ie., kmz/kml files, census tract polygons from SQL database and export into ESRI Geodatabase
• Creating schemas, spatial indexes, versioning, domains, subtypes, relationships in ArcSDE geodatabase and replicating the data from test to production server
• Creating python scripts to publish the map services, Geo processing Services, etc.
• Consuming Rest API services and develop GIS Web application using Javascript API/Dojo/HTML/CSS/Bootstrap
• Involved in QA/QC process to validate the production data as per specification
• Deploying applications to production environment using automated build & deployment process.

Environment: Visual Studio 2015, ASP.NET, C#, .NET Web Services, Python, ArcSDE, 10.3.1, ArcGIS Server 10.3.1, ArcGIS for Desktop 10.3.1,0, ArcGIS Portal 10.3.1, IIS 7.0, ArcGIS JavaScript API, SQL Server 2012, Google Maps API, Google Earth Pro.

Confidential, Fort Worth, Texas

GIS Lead/Developer

Responsibilities:

• Gathering client business requirements and feasibility study and involved in merging the two databases ie., NCS and Engineering into Enterprise Geo-Database.
• Developed ArcGIS/Arc Object add-in component to report log file for matched and unmatched attributes i.e., 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 tracking the data by Routeid, Rail owners, Sub-Division and Track type and provide online editing functionality to modify any changes.
• Design, Development & Maintain of enterprise Geodatabase using Arc Catalog, ArcGIS SDE and SQL server.
• Creating schemas, spatial indexes, versioning, domains, subtypes, relationships in ArcSDE geodatabase and replicating the data from test to production server
• Create routes for railway track center line using Linear Referencing and calculate the measure values based on Mile post, add events to the routes
• 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.

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.

Confidential, Houston, Texas

IT GIS Analyst

Responsibilities:

• Engage with customer teams on an ongoing basis on all aspects of project delivery. Seek informal feedback and escalate any issues to senior managers.
• Constantly review if there is a better way of doing things, which may help with economizing time or money or deliver better to the customer
• Data inventory of existing datasets and define Data Standardization and data flow processes for Oil & Gas upstream and subsea operations
• Database design, creation and maintain data models for MCBU and Upstream data formats
• Generate DDL & DML to create the objects necessary to implement in the relational DBMS
• Creating primary objects such as Tables, Views, Indexes, Functions, Procedures, etc. Modifying the database structure as necessary as per requirement
• Understand upstream Oil & Gas based field datasets, which is held in different formats automate the process using Data Interoperability, Python scripting and schedule jobs
• Design, develop, and test FME ETL processes per business requirements to meet the development standards
• Development, testing for generating geospatial Reports, Charts and Dashboards using Excel and Web App Builder as per business logic
• Preparation of technical documentation including Metadata standards, Data migration, Data interoperability procedures and Data dictionary document
• Created test plan, test cases document, test the application and User Manuals for MCBU Portal
• Create customized ArcGIS Toolbox using custom python scripts for data processing and data manipulation
• Develop, test and maintain SQL scripts for use in ArcGIS and database tools

Environment: Python, TOAD, Oracle 10g/11g, MS Access, Excel, FME, Google Earth Pro,MS Visio, Oracle SQL data modeler, ESRI Arc GIS, Arc GIS Web App builder

Confidential, Houston, Texas

GIS Developer/Analyst

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 Arc Catalog, 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.
• Following of Confidential Incident, change and release management
• Resolved the build breaks and issues within SLA timeframe

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.

Confidential, Houston, Texas

IT Support Analyst

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, MVC, JavaScript, JQuery, CSS, SQL Server 2010, SSRS, IIS 7.0, and Windows Server 2008.

Confidential, Houston, Texas

IT Support Analyst

Responsibilities:

• It is a monthly process. Every month need to export the finance reports, Eligibility, user’s wages, Members File, Transactions File, using GPDA.
• Generate Reports.
• Modify stored procedures as per business requirements.
• Production Database and Backup Maintenance & creating backup scripts.
• Involved in, but not limited to Enhance, Testing, Bugs Fixing, and Issues meeting to achieve zero bug convergence.

Environment: ASP.NET, C#, .NET Web Services, JavaScript, JQuery, MVC, Bootstrap, SQL Server 2008, SSRS, SVN, IIS 7.0, and Server 2008

Confidential

GIS Production Team Lead/Developer

Responsibilities:

• Develop and implemented ArcGIS Add-ins for Desktop Automation component using Arc Objects with VBA 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 Installation, 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.
• Involved in QA/QC process to validate the correct Feature classes as per spec
• 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.

Confidential

GIS Developer/Analyst

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 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, AutoCadMap, ArcSDE, SQL Server 2005, ArcGIS Server 9.x, ArcGIS for Desktop, IIS, ESRI ArcGIS Microsoft WEB ADF.

Confidential

GIS Developer/Analyst

Responsibilities:

• Digitizing the Ski Lifts and other features from google earth as per charts/ski brochures and save it as kml files
• Export the data from google earth to Global Mapper/Autocad Map and cleanup the data and converted into esri shapefiles
• Create routes for Ski Trails using Linear Referencing and store the distance information in M values, add events to the ski trails to display the type of ski routes ie., Glades, Terrain, Snowarea, etc
• 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 Arc object 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, PythonSQL Server 2005, ArcGIS Server 9.x, ArcGIS for Desktop, IIS