SUMMARY:

• Geographic Information System (GIS) Database Architectural Design and Administration.
• Manage Hardware and Software Requirements and Implementation for the GIS. Geospatial Software Development, Customization, and Deployment.
• Spatial Analysis and Automated Map Generation.
• A GIS professional and strong data analytical skills with over 20 years of core strengths in GIS Architectural Design, GIS Software Development (web and desktop applications) and Relational Database Management Systems for the GIS. Highly experienced with GIS Lands Management System, Pipeline Design and Engineering projects using ESRI ArcGIS Suite of software.
• Experienced in integrating programming languages such as HTML5/JavaScript/VBScript, Visual Studio (asp.net, c# and vb.net) in web design, development and deployment. Strong programming and customization skills with ArcGIS Geo - Processing tools for ArcGIS JavaScript API, Silverlight.
• Highly skilled in automating Geo-Processing tools on the ArcGIS Desktop environment using scripting languages such as Python (ArcPy) and vbscript with embedded ArcObjects.
• Over 10 years of managing Relational Database Management Systems (RDBMS) and incorporating ArcSDE (Spatial Database Engine) server-software sub-system in databases such as MS Access, Oracle, SQL Server, IBM DB2.
• Well versed in project management implementations, improvement efforts and managing operational tasks with an uncommon ability to relate and work well with people at all levels.
• Outstanding capacity to strategically prioritize, plan, coordinate, and steer projects to maximize productivity and efficiency.
• A Microsoft Certified Professional and Systems Engineer (MCP+I, MCSE) with over ten (10) GIS s from the Environmental Systems Research Institute (ESRI).
• Data Scientist with Python s (Microsoft Professional Program and DataCamp Academy). Skilled in applying Python Modules (matplotlib, tensorflow, networkx, nxviz, itertools, pandas, numpy, keras, sklearn:KMeans) for Deep Learning, Machine Learning, Supervised/Unsupervised Machine Learning, Bokeh Data Visualization, etc.
• Excellent verbal and written communication skills.

TECHNICAL SKILLS:

• ArcGIS Web
• ArcGIS Server/Desktop
• ArcSDE
• Visual Studio .NET (c#, vb)
• Active Server Pages (ASP, ASP.NET)
• JavaScript/VBScript
• DHTML
• Silverlight
• Python
• ArcObjects
• Windows Workstation/Server
• Microsoft SQL Server
• Oracle 11g
• IBM DB2

TECHNICAL SKILLS AND PROGRAMMING/SCRIPTING LANGUAGES:

GIS Technologies: ESRI

ESRI ArcGIS Suite: ArcGIS Desktop, ArcGIS Model Builder, ArcGIS Server, ArcGIS Web, ArcGIS Mobile, ArcGIS Online, ArcGIS Portal, ArcSDE

Web Programming: HTML5, CSS, JavaScript, Silverlight, VBScript, Visual Studio (ASP.Net), Dojo 1.6, JSON, ESRI JS API, XML

Web Services: Flask, SoapPy, WSGIServer, Web Service Definition Language (WSDL), Request-Response transmission via WSDL, HTML, etc.

Programming Languages: C#, VB.NET

Scripting: Python and Tkinter module interface, VBScript, Arc Macro Language (AML), ArcObjects

Relational Databases: MS SQL Server 2016, MS Access, Oracle 11g, IBM DB2, SQLite

Other Microsoft Technologies: Active Directory, Domain Controller, Internet Information Service (IIS), Active Server Pages

Mobile Technology: Code Division Multiple Access (CDMA), GPS navigation , Automated SMS Messaging, etc.

PROFESIONAL EXPERIENCE:

Confidential, Houston, TX

Senior GIS Consultant/Project Manager

Responsibilities:

• Maintain GIS feature data architecture for Enterprise geodatabase in database servers (development, test and production), geodatabase (GDB) archiving and accessibility.
• Integrate business intelligence with geospatial data to ensure optimized user productivity and performance.
• Responsible for migrating Enterprise geodatabase from Oracle 11g to Microsoft SQL Server 2016.
• This includes creating and enabling geodatabases, configuration of all user/roles permissions, migrating XML workspace documents between servers, and enabling versioned editing on servers.
• Manage multi-user versioned edit operations and all work in progress (versions) along with published datasets (DEFAULT).
• Maintains a complete collection of all critical geospatial feature datasets in schemas and validate accuracy and integrity of spatial feature edits.
• Manage all scheduled data uploads activity with automated Python scripts and Window Task Scheduler.

Project Manager

Confidential

Responsibilities:

• Design of data delivery template system for all 12 survey companies to maintain high data quality, uniformity, seamless data upload/download process flow for development designs.
• Geospatial python scripts for reservoir engineering wellbore spacing optimization with considerations to hydraulic-fracture geometry and reservoir quality.
• Geospatial python scripts to generate latitude/longitude of prestake wellbores location from spreadsheets and integrate result coordinates of well locations with various systems such as Petra, Kingdom, ArcGIS for visualization by regulators, facility planners and drilling schedulers.
• Geospatial python scripts to automate the generation of different pad types and their corresponding wells layout for planning efficiency.
• Well planning map viewer to provide real-time views on well information and survey activities, etc. The planning viewer helps visualize all infrastructure locations in relation to planned/existing well locations.
• Python plotting (plotly) support for StarSteer geosteering visualization.

Confidential, Canonsburg, PA

Senior Solutions Engineer

Responsibilities:

• Installation or update of 3-GIS software on Client servers
• Application development and ArcGIS scripting services for geometry checks, unattended processes and map configurations
• Configuration and edit permission configuration of 3-GIS software using 3-GIS Administrator
• Support efforts for 3-GIS Web, Mobile and Administrator
• GIS Map Service support
• Mobile Map cache support
• Manage data loading and support rules development for the BOM and QA/QC
• Assist with technical support (logging tickets and implementing resolutions from 3-GIS technical support)
• Direct New Business onboarding such as requirements gathering, documentation and configuration to 3-GIS

Confidential, Houston, TX

GIS Project Consultant/Manager

Responsibilities:

• Enterprise GIS System Deployment, Property Appraisal and Tax Management System, Pipeline Route Management System, Right-of-Way Database Management System, Emergency Response Management System, Crime Pattern Monitoring System, Spatial Grid Zoning System, Consultancy,, and Support. Provided overseas technical support to the Government of Abia State, Nigeria, on their development of Consolidated Assets and Resources Inventory Service (CARIS) and deployment of statewide Property and Land Use Charge (ABIAPLUC).
• Designed, developed and maintained MS SQL Server 2008/2012 environment. Collaborated with other system architects in evaluating data modeling and applications. Ensure accuracy of data by defining and building necessary audits and controls. Skilled in using MS SQL Server tables, views, stored procedures, and troubleshooting SQL Server related issues.
• Managed the system review team responsible for gathering requirements for the new system by developing initial project requirements, determining software requirements, initiating meetings/technical sessions to discuss requirements, and preparing documents and prototypes for project implementation. Areas covered include analyzing existing processes for GIS data management (storage and retrieval) and recommendation for migration to enterprise geodatabase system, analyzing hardware and software needs for seven (7) state agencies and implementing a process management system for the entire state property and land use charge system.
• Developed and deployed a spatially-enabled statewide Property Location System for proximity analysis of building plan process management in the Ministry of Lands.
• Development components include Visual Studio (vb.net, asp.net), ArcSDE (spatial) running on Microsoft SQL Server (SSIS), Toad for Oracle 11.6, embedded ArcObjects, etc.

Confidential, Houston, TX

GIS Project Consultant/Manager

Responsibilities:

• Architectural design, execution, management and methodological services in support of installing, configuring, managing the Relational Database Management System (RDBMS) and ArcSDE components of the GIS Hosting Infrastructure and their integration with other enterprise systems. These elements include application servers, database servers, and web servers. Primary application utilization includes ESRI ArcGIS applications (ArcGIS Desktop and extensions, ArcSDE, ArcIMS, ArcGIS Server).
• Performed data collection, database, web development and mapping design work. Designed and implemented in-house web based applications for end-user data input and maintenance using ASP, ASP.NET, and VB.NET. Configured and maintained ArcSDE server and ArcGIS servers and web services.
• Maintained 21 SQL server databases and maintenance plans. Created maps, reports and GIS database management systems for research, assessment support and presentation purposes. Provided technical support to personnel GIS use.
• Provided overseas technical support to the Asset and Resource Inventory Service (ARISE) and Anambra State Property and Land Use Charge (APLUC) project to GlobalMcKens Limited, Nigeria. Project work includes the statewide Property Enumeration, Classification and Property Tax Management System in Anambra State, Nigeria.
• Developed and deployed a spatially-enabled (web-based) Property Valuation System that calculates property values (land and building) based on land size, property use classification and location proximity analysis using buffers. Development components include Visual Studio (vb.net, asp.net), ArcSDE (spatial) running on Microsoft SQL Server, embedded ArcObjects, etc.
• Developed and deployed a Property Picture Reconciliation System and Process that uses the ‘Date-Taken’ attribute of picture files to reconcile some 390,000(+) property pictures captured in the field work, with property information in the spatial and non-spatial database. Development components include Visual Studio (vb.net), Microsoft SQL Server data manipulation language (DML) triggers on user-designed stored procedures, etc.
• Coordinated the activities of the contracting company assigned the responsibility of creating a digital fishnet section-grid management system. Plan section-grid mapping by high consequence areas and schedule deliveries of digital maps to Field Coordinators for geospatial property enumeration exercise.
• Managed the Location and Data Administration Units tasked the responsibility of field data entry into the RDBMS. These units comprise some 44 Field Representatives, 10 Digital Data Entry staff, 3 GIS Specialist and 1 third-party vendor responsible for capturing property pictures with digital cameras.
• Discussed project developments with Client and presided over weekly/monthly activity meetings with staff and management.

Confidential, Houston, TX

GIS Project Manager

Responsibilities:

• Managed the entire GIS component of 2 major pipeline design and engineering projects. Provided leadership, direction, and oversight to ongoing project work.
• Accountable for data upload/download schedule and have responsibility for data quality control plans, and other functions as related to the specific GIS component of the project requirements. Developed and participated in proposal development and client presentations, applying direct experience utilizing ESRI's suite of products.
• Built and managed the central RDMS repository (spatial and non-spatial) for 18 natural gas pipeline segments and 10 compressor stations, routing some 483.2 miles from Mississippi to Florida. Also served web-based secured access to pertinent project management, engineering and environmental datasets and maps.
• Developed and deployed a geospatial Right-of-Way database management system to seamlessly manage records of survey permissions on tracts, tract events, issues, offers/payments, plats, and deeds. Development components include Visual Studio (vb.net, asp.net), ArcIMS web service, JavaScript, ArcSDE (spatial) running on Microsoft SQL Server, embedded ArcObjects, etc.
• Deployed spatially-enabled design and engineering activities along pipeline routes, such as civil and environmental (biological and cultural) survey activities, by automating the progression of all such activities on a web-enabled mapping service. Development components include Visual Studio (vb.net, asp.net), ArcIMS web service, JavaScript, ArcSDE (spatial) running on Microsoft SQL Server, embedded ArcObjects, etc.
• Built and managed the central RDMS repository (spatial and non-spatial) for 30-inch heavy crude TransCanada pipeline from the Canada border to Cushing, Oklahoma. Development components include ArcSDE (spatial) running on Microsoft SQL Server, embedded ArcObjects, Microsoft Schedule and Batch File Processing, etc.
• Deployed an automated Desktop Mapping Application used for map generation process on Construction Estimate and Property Sketches. It spatially analyzes geographic features on each tract/property along the pipeline route, such as property size, pipeline length on a property, entry/exit points, area of wetland, area of workspaces, biological and cultural component, etc. Development components include Visual Studio (vb.net), Microsoft SQL Server data manipulation language (DML) triggers on user-designed stored procedures, embedded ArcObjects, etc.
• Coordinated clients’ GIS data submission activities to project portal.
• Established process management systems for the seamless exchange of GIS data from the Spatial Database Engine (SDE) to all individuals and companies permitted to upload and download project data. Presided over the Data Management Committee meetings on 2 design and engineering projects.
• The committee was responsible for designing standardized data collection methods, and incident report forms used to accurately collect Right-of-Way field crew activities.
• Also authored hours-long data presentation sessions to project owners and managers.

Confidential, Houston, TX

GIS Database Administrator and Programmer

Responsibilities:

• Manager of the MSSQL/ArcSDE database. GIS software development, automation, and customization. ArcGIS Installation and configuration.
• Created and deployed automated processes for the ArcSDE database.
• Some of such maintenance processes include the ArcSDE compression, recalculating spatial extents, managing statistics for the core participating ArcSDE multi-versioned data tables, rebuilding fragmented indexes on tables, etc.
• Other automated processes include optimizing the ArcSDE to increase performance by monitoring context switching activities on the database server to help determine CPU equalization on the Enterprise Manager.
• Map database backup and recovery plan for the SDE. Managed backup of the data files and transaction log. Managed transaction log shrinks, etc.
• Managed the multi-version environment, making sure to avoid orphaning on versioned edits. Created views on spatial data and related spatial/non-spatial tables.

Confidential, Pensacola, FL.

GIS Manager

Responsibilities:

• Maintained comprehensive and technical knowledge of GIS administration techniques including internal structure, customization processes, external interfaces, and developing trends to assist in planning, and to develop and modify application programs to create and maintain a comprehensive GIS for county departments and agencies. Applications used include VisualBasic.Net, ArcXML, JavaScript, and HTML.
• Built, customized and deployed -winning websites and all ArcIMS sites for the county’s GIS map service and supervise the installation, testing, and maintenance of software applications.
• Maintained the central database repository for the GIS and possibly for associated departments and agencies; establishes conventions, security, quality assurance and documentation (data dictionary) for the database management system. Administrator of the Spatial Database Engine (SDE) server running on Microsoft SQL Server, ArcIMS services, etc.
• Provided staff assistance to GIS users, prepares agendas, makes presentations, and confers with technical staff from other departments and agencies. Also assisted in the development of technical and quality standards, the development of documentation and materials, and provides for the of user departments and agency staff in the most effective use of the system.
• Monitored developments in the field of GIS software and applications technology, determines potential benefits for the county's system and make recommendations to ensure continuing effective development and utilization of the system.
• Prepared a variety of written correspondence, extensive map and/or report generation based on requests from supervisors, department heads, citizens, and state/local officials, and periodic special reports regarding system status and work performed.

Confidential

Digital Data Management Technologist

Responsibilities:

• Extraction and in corporation of linear/aerial features from digital imagery e.g. LANDSAT, SPOT, Airborne SAR into Geographical Information System (GIS) Database using ArcInfo on the Unix platform. Effectively used Imageries for quality control of layers to determining the accurate location of features.
• Oil/Gas Fields Regioning: Delineated, vectorized and attributed Confidential and competitor oil/gas fields, creating ArcInfo region coverage for the reservoirs. Original data extracted and converted from ZMAP. ArcInfo GENERATE was used in converting tabular data with coordinate information into spatial layers.
• GPS Surveys of Platforms And Settlements: Involved in the planning and implementation of a differential GPS survey primarily undertaken to accurately locate production platforms, flow stations, swamp well protectors and well jackets/slots. Settlements such as permanent and temporary communities located in Chevron’s Niger-Delta operational area in Nigeria are also surveyed and locations incorporated into the GIS database with ArcInfo and ArcView.
• Industry-wide Lease Boundary Errors: As a member of the TECOM sub-committee on Lease Boundary Errors, I have been involved in the extensive identification of petroleum leases boundary errors/overlaps industry-wide, using GIS ArcInfo and ArcView on Unix/Windows NT platform.
• Using ArcIMS, data from shapefiles/coverages/layers are compiled into map layers to identify existing Lease Boundary Errors. The resultant Map Configuration File (ArcXML) is published on the Internet and updated regularly for other TECOM sub-committee to query real-time GIS database.
• Data Management: My responsibilities included loading shapefiles/coverages into ArcSDE layers, granting/revoking user access to SDE layers, exporting/importing SDE layers and spatially enabling and deleting attribute tables.

Confidential, San Ramon, CA

Responsibilities:

• Developed and implemented a system of assigning company-wide unique identity numbers (UID) to existing and proposed facilities (pipelines, flowlines, and platforms). The unique identity number is critical to joining/linking Facilities Engineering Department database with the GIS database for relevant information retrieval, spatial analysis, and map generation.
• Pipelines Network System: Create industry-wide route system for oil/gas pipelines/flowlines. This involves scanning existing maps, querying Oracle databases, the extraction, and delineation of as-built pipelines from images such as Airborne Synthetic Aperture Radar (SAR) imageries. Built and published ArcIMS configuration file to allow access to querying the networked feature class of the pipeline dataset etc. Data access granted for the purpose of; identifying proposed/existing pipelines route communicating needs for network/route modification