Gis Analyst/developer Resume
Tallahassee, FL
SUMMARY:
- 13+ years GIS (Geographical Information Systems) Applications & IT Domain experience in application design, development, testing and technical support and guidance in ESRI ArcGIS Desktop & ArcGIS Server Web based products technology and open source tools.
- 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
- Design and implement database systems in various environments such as Development (DEV), User Acceptance Testing (UAT) and Production
- Experience in creating and analyses maps, cleaning and updating spatial data using ArcGIS for Desktop 9.x/10.x
- Experience in developing Python/Arcpy scripts and Model Builder to automate the GIS tasks.
- Experience GPS data collection with Geo Trimble XH and Lidar data processing
- Hands on experience in GIS principles, concepts, theories and concepts.
- Performed Analysis using Spatial Analyst, 3D Analyst, ERDAS, Google Earth Pro, Geographic Analysis, Geocoding, Network Analyst, and Linear Referencing.
- Hands on experience in create and publish map services using ArcGIS Server, Geo Server, ArcGIS Online and ArcGIS for Portal.
- Created and Validated Topology rules for features to identify and fix the Topology errors.
- Experience in Data Models for ArcGIS, Geodatabase Database Design, Versioning, Domains, Subtypes, Spatial Index, Reconcile, Posting and replication with ArcSDE for SQL Server and Oracle environments
- Knowledge on Hadoop distributed file systems HDFS, HBase, PIG, HIVE, Sqoop and Flume.
- Experience in UNIX shell scripts
- Experience in Development of Web GIS Applications using ArcGIS API for JavaScript, DOJO, JQuery, HTML, CSS, JSON
- Knowledge on Amazon Web Services (AWS) and cloud environment.
- 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.
- Used Arc Scripts and Arc GIS Extensions for performing better QA/QC process
- Experienced in SSIS and SSRS reports for SQL Server.
- Experience in Remedy Incident Management and Change Management
- 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, QGIS, Google Earth, Google Maps API, FME, GPS, Open Layers, AutoCAD, JavaScript API, JQuery, DOJO, HTML, CSS, Bootstrap, JSON, Firebug, GITHUB
Timesheet & Reporting Tools: Internal Software
Web Servers: IIS
Backup Tools: MS VSS and TFS
Languages: C#, VB.NET, ASP. Net, MVC, ADO.NET, SSRS, SSIS, FoxPro
Scripting Languages: JavaScript, VBScript
Reporting Tools: Cognos Reports, Crystal Reports and SSIS/SSRS
RDBMS: MS SQL Server, Oracle, PostgreSQL
Domain Knowledge & Industry Experience: GIS & Government; Utilities, Electrical, OIL and GAS, Forestry, Railway, Municipality, Marine S57 Objects, Health, Roads, Agriculture, Cadastral, Watershed, Sewerage Network
PROFESSIONAL EXPERIENCE:
Confidential, Tallahassee, FL
GIS Analyst/Developer
Responsibilities:
- Interaction with stake holders, business team for requirement gathering and input analysis.
- Consume Rest API services and developing a custom GIS Web application using ESRIJavaScript API, Dojo, HTML, CSS for survey team.
- Creating .Net Web services and web methods to pull data from SQL Server.
- Creating primary objects such as Tables, Views, Indexes, Functions, Procedures, etc.
- Modifying the database structure as necessary as per application developer’s requirement
- Collaborate with business users to gather required data and execute all necessary scripts on systems
- 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
- Create schemas, spatial indexes, versioning, domains, subtypes, relationships in ArcSDE geodatabase and replicating the data from test to production server
- Involved in QA/QC process to validate the production data as per specification
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 JavaScript API, SQL Server 2012
Confidential, Sacramento, CA
GIS Specialist/Developer
Responsibilities:
- Develop the interface to display the KMZ/KML data into Google Maps using JavaScript API in PTS program.
- Configure and troubleshoot 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 i.e., kmz/kml files, census tract polygons from SQL database and export into ESRI Geodatabase
- Create schemas, spatial indexes, versioning, domains, subtypes, relationships in ArcSDE geodatabase and replicating the data from test to production server
- Create python scripts to publish the map services, Geo processing Services, etc.
- Consume Rest API services and develop GIS Web application using JavaScript API, Dojo, HTML, CSS, Bootstrap
- Creating .Net Web services and web methods to pull data from SQL Server.
- Involved in QA/QC process to validate the production data as per specification
- Deploy 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, TX
GIS Lead/Developer
Responsibilities:
- Assisted 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.
- Gathered client business requirements and feasibility study and involved in merging the two databases i.e., 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.
- Created and published different type of GIS services.
- Developed Web map application created in ESRI ArcGIS Server using JavaScript API to loading all rail data i.e., 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 and Development of enterprise Geodatabase using Arc Catalog, ArcGIS SDE and SQL server.
- Created 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.
- Analysis of the specification provided by the clients
- Involved in Designing High Level and Low level documents
- Tested application to define clear use cases and expected results.
- Enhanced and troubleshot
- Technical write-ups and application user guide documentation
Environment: Visual Studio 2012, ASP.NET, C#, .NET Web Services, Python, ArcObjects,ADO.NET, ArcSDE 10.3.1, SQL Server 2012, ArcGIS Server 10.3.1, ArcGIS for Desktop 10.3.1, IIS 7.0.
Confidential, Houston, TX
GIS Developer/IT 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.)
- Developed 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.
- Developed 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
- Technical and application user guide documentation
- Following of Confidential compliance processes
- Following of Confidential Incident, change and release management
- Resolved the build breaks and issues within SLA timeframe
- Deploying and .
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, TX
IT Support Analyst
Responsibilities:
- Supporting and developing enhancements for these application
- Coded Client side validations using Java Script, jQuery.
- Involved in writing and modifying Queries, views, and tables in SQL database.
- Interacted and discussed 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, TFS, JavaScript, JQuery, CSS, SQL Server 2010, SSRS, IIS 7.0, and Windows Server 2008
Confidential, Houston, TX
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.
- Generated Reports.
- Supporting and developing enhancements.
- Modified stored procedures as per business requirements.
- Production Database and Backup Maintenance.
- 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, Bootstrap, SQL Server 2008, SSRS, TFS, IIS 7.0
Confidential
GIS Production Team Lead/Developer
Responsibilities:
- Developed 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 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 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
- Created 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:
- Digitized the Ski Lifts and other features from google earth as per charts/ski brochures and save it as kml files
- Exported the data from google earth to Global Mapper/AutoCAD Map and cleanup the data and converted into esri shapefiles
- Created 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 i.e., Glades, Terrain, Snowarea, etc.
- Developed 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
- Developed 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 demos 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