SUMMARY:

• Over 22 years experience in Confidential Suite (ArcGIS Desktop, ArcGIS Server, Portal for ArcGIS, ArcGIS Data Store, ArcGIS Online and ArcGIS Enterprise)
• Expert in ArcGIS Server, Portal for ArcGIS, Data Store Installations, upgrades and configurations in HA and Silo model.
• Expert in SQL Server, Oracle and Geodatabase Administration tasks and python scripting.
• Expert in Data Migration, Geodatabase Upgrades, Installations, Centralization, Database designing, Data modeling, Data loading, Data Conversions, and Data Analysis.
• Expert in GIS Analytics, Reports using Portal for ArcGIS, Web Map, Web Maps Applications using WebApp Builder, OBIEE Map Viewer, Map Builder,

WORK EXPERIENCE:

Confidential, Kansas City, MO

GIS Solutions Architect/ GIS DBA Lead/Analyst

Responsibilities:

• Installed, configured ArcGIS Servers, Portal for ArcGIS, Datastores and Desktop ArcGIS and build REST services and Web map applications.
• Expertise in providing GIS solutions for ArcGIS Architecture, GIS applications and Enterprise Geodatabase, managing ArcGIS licensing.
• Migrated SQL Spatial data to Oracle Spatial data in used for Enterprise Data warehouse.
• Worked on ArcGIS online, ArcGIS Enterprise and Collector for ArcGIS, Survey 123 and work force for mobile devices for field officers.
• Worked on Windows SSL entrust certificate on IIS, Windows security and resolved number of Vulnerability issues on servers.
• Designed and developed python scripts to automate data conversations, data transfers, database maintenance jobs and geo processing tools.
• Designed and Developed ArcGIS REST Services, Interactive maps and Map Analytics in Portal for ArcGIS and ArcGIS Webapp builder.
• Designed and Developed Reports in OBIEE using MapViewer tool, build Themes, Base maps, Tile layers in map builder, Set up data design and data transfer from SQL Spatial to Oracle Spatial.
• Continues supporting and maintaining SQL/GIS servers and all the roles and responsibilities carried over from previous project.

Confidential, Kansas City, MO

GIS DBA/Lead, GIS Analyst, GIS Architect

Responsibilities:

• Primary responsibilities include administering, maintaining and supporting Production and pre - production environments that comprises of over 3100 county data spread across in 54 geodatabases on SQL Server and ArcSDE. Migrated, upgraded and centralized ArcSDE\SQL Geodatabases spread across 2400 SQL Server instances into 54 geodatabases from number of versions starting from ArcSDE 8.3 to 10.6 versions and SQL Server 2000 to 2017. In support of GIS projects configured servers, migrated data, manage and supported 16 SQL Server instances on ArcSDE.
• Developed and enhanced number of SQL procedures and Python scripts. Implemented SQL and Confidential replication, developed reconcile and post, sync and compress python scripts. Developed automated batch processes using SDE commands and SQL procedures on SDE compress, creating state and national layer, developed python scripts to export data in different formats for other departments as per database needs.
• Coordinated with different groups on upcoming data migrations, upgrades, data model and data changes, and server downtimes on timely manner. Planned system releases and implemented successfully on all environments within the deadline set by Business and Program sponsors.
• Troubleshooted issues and documenting problem solving solutions in related to Installation, configurations, ArcSDE, SQL server, database, performance, database tuning, settings, ArcGIS Server REST services on production and pre-production environment following FSA standards, procedures and policies.
• Worked with different groups within and outside FSA agency on Disk and server capacity planning during the purchase of new servers and rebuilding existing server. Participated in disaster recovery planning exercises
• Developed number of scripts and stored procedures to full fill users and other agencies requirements, support includes databases backups, restore databases when necessary, Synchronize SQL authentication accounts, creating databases, users, roles and assigning appropriate permissions and all security protocols.
• Used SQL profiler to capture traces and analyzed long running queries, memory usage, disk IO, reads and writes to resolve application performance issues. Helped other groups to troubleshoot and configure multiple SQL server instances and multiple ArcSDE services on testing server.

Confidential, Michigan

GIS Team Lead, DBA

Responsibilities:

• Primary responsibilities include Incorporating Geodatabase technology by moving file base architecture to geodatabase technology. Loaded 200 different formats of GIS Data files into ArcSDE Geodatabase and also loaded 90 GB of raster data through ArcSDE command based batch program. Installed and upgrade of ArcSDE and ArcGIS from 8.3 to 9.0 and SQL Server 2000 on both development and production servers.
• Troubleshooted database, ArcSDE service, Installation, Configuration, network and application related issues.
• Gather Information from various sources to create over 50 different GIS data layers for Pre Disaster mitigation program. This includes mapping, projecting and exporting data to ArcSDE geodatabase. Re-projected 100 GB of 1 foot color Aerial photos, mosaic, and compressed to Mr. Sid files by each municipality and loaded in SDE Database through SDE command base batch program. Tuned SDE Database by creating spatial indexes, views and setting grid sizes for all feature class that has more than 10,000 features.
• Performed all ArcSDE/SQL DBA activities that includes versioning layers, reconcile and post the changes, SDE compressing, check-out, check-in, creating users, roles, privileges. Installed and configures Oracle on production and development servers and performed Database administration activities. Regular monitoring of ArcSDE/SQL databases activities, database connections, locks, hung process, licenses, services and log file. Database activities include taking backups, restores and replicating data between servers and databases.

Confidential, Chicago, IL

GIS Analyst/Developer/DBA

Responsibilities:

• Primary responsibilities include designing the schema for centralized geodatabase, and perform DBA activities, that include database restores, backups, replication, analyze and troubleshoot and resolve performance issues, database and application issues, create workflow for data layers, reconcile and post the edits, compress SDE database, create users, roles, privileges, loading vector and raster data.
• Regular monitoring of ArcSDE and Oracle databases, data layers tuning, SDE connections, ArcMap and ArcSDE licenses, transaction and SDE log files. Developed and used VB Dll’s in ArcMap environment and made calls to C and C++ Dlls. Converted ArcObjects Visual basic code to VB Dlls and were called from ArcMap interface. Developed and enhanced tools to reduce the user intervention to edit the feature classes in ArcMap.
• Developed Photogrammetry tool that can calculate height of an object, width of the lane and position of the object using triangulate function.

Confidential, Chicago, IL

GIS Analyst/Developer/DBA

Responsibilities:

• Primary responsibilities include Installing and configuring the ArcSDE on SQL Server 2000, upgraded ArcSDE and ArcGIS from 8.1 to 8.2.
• Troubleshooted database, Installation, Configuration, network and application related issues.
• Reconcile and post the spatial edits, automated the SDE compress process, loaded raster data, created roles and privileges.
• Carried out requirement analysis, designed, developed and implemented application in ArcIMS, Visual Age for Java, Java Script, HTML, VB .NET and integrated it with lotus notes applications to prepare demographic maps and reports for a new store opening. Developed toolbars, menus in Visual Basic using ArcObjects and ActiveX Map controls and dll’s were called from ArcMap application.
• Regular monitoring of ArcSDE databases, tuning layers, configuring dbtune table, monitor connections, licenses, transaction logs and SDE log files. Database activities include backups, restore and replicated data using snapshot and transactional procedurals.

Confidential

GIS Analyst/Developer/DBA

Responsibilities:

• Primary responsibilities include Installing, configuring and maintaining ArcSDE on SQL Server and perform database administration tasks.
• Migrated databases from ArcStorm to ArcSDE Geodatabase technology.
• Recommended and implemented several best practices on ArcSDE, SQL server, ArcView and ArcGIS applications. Developed stored procedures, views, incorporated the tiling structure from ArcStrom database to ArcSDE.
• Designed, developed and implemented application using ArcIMS, Java, Java Script and integrated it ArcIMS interface for Singapore police department to locate crime locations and road accidents.
• Developed toolbars, menus in Visual Basic using ArcObjects . .NET and ActiveX Map controls and dll’s were called from ArcMap application.
• Carried out requirement analysis, designed, developed and implemented front end applications. Maintained and redesigned existing applications and developed new modules and enhance existing modules using ArcView 3.x and Avenue.
• Migrated applications from ArcView 3.x to ArcGIS 8.x. Developed techniques for optimization of the ArcInfo license usage for multiple client AML programs requiring individual Arc process

Confidential

GIS Analyst/Developer

Responsibilities:

• Primary responsibilities include gathering requirement analysis, developing test applications for feasibility study, developing and customized ArcView and ArcView extensions, generating crystal reports and dynamic hyperlinks.
• Performed Image Rectification, Merging, Mosaic and other Image processing methods on Confidential Imagine.
• Developed ArcInfo AML and SML scripts to customize and automate the manual editing and QC process.
• Performed database administrative activities on SQL Server and Oracle servers.