Jose Serna Email & Phone Number

Englewood, Colorado, Us

Colorado Springs, Colorado, Us

■ Made some modifications to our GIS build that is written in python. The python script is ran by Jenkins.■ Added the buffer tool to our application at the project level. To accomplish I got the geo json from our leaflet local library converted to ESRI JSON and use the ArcGIS Geometry Utility Rest API Call to buffer the line or point. Then used the apply edit to save the data into the SQL Server Enterprise Geodatabase.■ Save two types of geometry through our MBS API, when using the buffer tool. This other geometry is use on other workflows.■ Added the functionality to our application to be able to do insert to another geodatabase by using a method that applies edits at the feature service level. Used linq together with entity framework, to be able to get the data that needed to be process instead of getting all the data. Call a SOE to create a version. Call the method that does the apply edits at the feature service level. Call the SOE for the post processing.■ Converted point feature class to multipoint feature class. Modified our C# and JavaScript code to handle multipoint instead of points. The leaflet API has a function toMultiPoint() of which I used to get the points drawn in map into a single geo json. Created a python script to migrate the existing point feature classes to multipoint feature classes. Create an empty multipoint feature class using the point feature class as template. Use the arcpy insertCursor to insert the non-geospatial data from the point to multipoint feature class. Use SQL update to add the geometry data. Republish mxd’s so that they reflect the change from point to multipoint. In the case for the mxd that uses view, we must make sure to choose multipoint on the drop down.■ Worked with C#, Entity Framework, JavaScript, Polymer, Python (arcpy) and the ESRI Suite.

Gainesville, Texas, Us

■ Migrated the GIS infrastructure from Windows Server 2008 to Window Server 2012. This included installing ArcGIS Server 10.4.1, License Manager, ArcGIS Portal and republish all the services.■ Migrated the GIS infrastructure from Window Server 2012 to AWS. This included installing ArcGIS Server 10.7.1, Data Store, License Manager, ArcGIS Portal, and Federating the ESRI Suite.■ Served as the Portal Admin.■ Created a console application that gets data from a SQL Table and saves it as an excel document and email it automatically every week.■ Used SQL Spatial to create a report that will show the rigs and permits within a 10 mile radius of the water sources. Also added a query to remove duplicates.■ Using ESRI Model Builder, Python, VB#, I created a model that takes a kml file and other inputs from the user that creates a water path, job, greenzones, and attaches 2 pdf reports to the job feature service. Published this model as a geoprocessing service that is used by web app builder. ■ Used the data from the ESRI Enterprise Geodatabase to publish feature services.■ Using ESRI Sites, I created a website for our operations teams that shows graphs to help the end user make educated decisions. Within the site I have added way for the user to have access to web application I created with web app builder.■ Using ESRI Dashboard, I created a dashboard for the operations team.■ Modified the current JavaScript API in AquaNet.■ Created a python script that uses mxd files within a folder and create a kml file per mxd file. Then used VisualCron to send out the kml files to particular people.■ Created a PowerShell script that makes a call to ArcGIS Server that generates KMZ file. Then use VisualCron to email the KMZ file weekly to interested parties.■ Created an Enterprise Geodatabase, to be consumed by App Studio.■ Used ESRI Model builder, Python, and SQL Database to automate the creation of pits for AquaView.■ OutSystems Certified

Houston, Tx, Us

Worked on Quorum Land System (QLS) and Quorum GIS (QGIS) while using C#, ORACLE, Python, MVC, Javascript, KendoUI. Helped with migrating the QGIS code from a coupled environment to a decoupled environment (from TFS to VSTS). Added two new functionality to the agreement linker. The purpose of this new functionality is to show status on where in the agreement linking process where. Here the two functionalities that I have added. Linking 20 of 400 Agreements. Progress bar to show visual representation of the progress e.g. 5%,10%.Traveled to customer site and fixed there agreement linking issue. Worked on defects that where show stoppers the clients had.Configure the customer ESRI Web Maps to be able to talk with our oracle database. Worked with ESRI Web App Builder with co-worker to do a POC. Work with VSTS, for time tracking and check in code. Our team was working on the agile methodology which included scrum, and retrospective meetings.

Houston, Tx, Us

Created documentation of third party software used to help the intern’s in their training.Extracted field values from a pdf form and insert those values to sql server using java. The form had latitude and longitude, as part of the insert into the database I did conversion to web Mercator and inserted the latitude and longitude as a geometry field in sql server and was able to show the point in the map.Created a analitical window with bar graph using Kendo UI, Javascript, .NET, that would show the pass and failed inpections for centerpoint.Worked on rest calls on the .NET side and then transferred the data over to the Javascript code and used the data to do the analytics the customer requested.Currently using PhoneGap Cordova to create a multi-platform app for the Binkley Barfield.Created a PHP program to extract the coordinates from KML and insert them into SQL Server to be seen in web map.

Develop with Eclipse RCP and used the ESRI Runtime 10.1/10.2/10.2.3/10.2.4 API to produce a map where the user can see Wells/Faults/Mapping Polygon and other datatypes.Work with python scripting and geodatabase to geocode data from database and place it on our map using JMAP from ESRI RunTime API.Work with python scripting to geoprocess data to be able to render data into our JMAP.Work on vector, raster geoprocessing with python. Save and Load Web Maps using json and java to allow the user to save what they are working on, and be able to load save session at any given point.Used the Java Runtime API to implement the info popup, which function in our map like the identify functionality work in arcmap.Created pie chart functionality, used the Java Runtime API with Oracle Database to gather the count of each datatype(Well/Faults/Mapping Polygon etc..) by project and displayed the amounts of each datatype in portion in pie chart depending on the Openwork’s Project.Work closely with ESRI customer support to solve bugs that we find while we are developing phase.Work with Install Anywhere 2009 and 2012 to rap the Arc Engine 10.0/10.1/10.2 Linux/Window installers from ESRI.

Maintain and update the CDS2OW synchronization Java code.Moved the configuration of the CDS2OW synchronization from flat files to Oracle database.Created oracle views and scripts.Created/Maintained/Updated Meta-Data Topics and Views.Maintain and updated the CDS/RDM Installer with InstallAnywhere 2009.

Paris, Île-De-France, Fr

Create applications with Java, JSP, Javascript, interfaced with SQL databases or InformixCreate Pivot Tables as a reporting tool; Pivot Tables are created with store procedure in SQL server; Created an intranet printer spec databaseIncluded a user interface and an admin interface for updates; training session for employees on database

Master'S Degree, Geographic Information System

Mscs, Computer Science

Bscs, Computer Science