Work History

Work History

Figure

Latitude
Figure 1 Table 1 Time period involved: The data seems to include several processing dates. Beginning with the districts and its logged metadata it seems to be last updated in, while the layer shows a June 2012 and the excel file seems to be from. Therefore the data possibly will have to be updated in order to produce any effective information products. Geographic extend of the provided data: Based on the geographic extends provided by the districts and school data any analysis or enquiries will only apply within the New Mexico state. List of questions/answer: based on the available data I expect to be able to answer the following questions by using the feature fields: From the District layer, by using the identify tool. What is the name of the district? Name What is the lowest grade in that district? LOGRADE What is the highest grade in that district? HIGRADE10 What is the census FIPS code? STATEFP10 What is the unified school district local education agency code? UNSDLEA10 What is the MAF/Tiger feature class code? MTFCC10 What is the census school district type? SDTYP10 What is the census functional status? FUNCSTAT10 What is the census land area? ALAND10 What is the census water area? AWATER10 What is the census latitude of the internal point? INTPTLAT10 What is the census longitude of the internal point? INTPTLON10 From the schools layer, What is the name of the school? School What type of school is it? Type What is the school address? Address What is the name of the city? City What is the zip code? ZIP What is the County? County What is the state? State What is the latitude? What is the longitude? Longitude From the Excel table after creating a relationship class with the Schools feature class. By using the query tab in Arcmap. What are the schools that fall in a specific district code? Dist Cd What are the schools with a specific district organization type? District Org Typ Select a school by location ID. Loc ID What is the location organization type? Loc Org Typ What is the school level? School Level What is the grade level range? Grade Level Range What is the course subject area? Course Subject Area What is the state course name? State Course Name What is the state course ID? State Course ID Total Number of Students? Total Students In combination of the database features and by using the available tools. How many schools are there in a given district? By selecting the features by their location that intersect a given district. What are the schools that offer a certain geography class? By using the query tool and selecting the desired class. What is the spatial density of students that are currently taking a given course? That can be extracted by using the select Total Students and then use the spatial analysis tools, density, Kernel density. What are the schools affected by some sort of gas spill? Use the buffer tool around the accident area to identify the schools that are inside the danger areas. Methods: Most of the questions were derived from the data provided by the feature classes' fields and the converted excel table. In order to create the schema, I first identify the fields and their types that are going to answer some of the questions and select those fields that do not provide any data at all. Right after that I used an add on tool called Arcgis Diagrammer to visualize each prototype of the schema. Once I had an adequate schema then I used ArcCatalog to import the schema into the database and then load all of the features from the shape files. the imported
Feb 2007 - Present

GIS Specialist

The City of El Paso

Create maps using GIS software; conduct research to locale and obtain existing databases; gather, analyze, and integrate spatial data from staff and determine how best the information can be displayed using GIS; compile geographic data from a variety of sources including censuses, field observation, satellite imagery, aerial photographs, and existing maps; analyze spatial data for geographic statistics to incorporate into documents and reports; update database, applying additional knowledge of spatial feature representations and engineering drawing standards; enter new map data through use of geo-referencing techniques or by direct input of coordinate information using the principles of cartography including coordinate systems, longitude, latitudes, elevation, topography, and map scales; analyze geographic relationships among varying types of data; prepare metadata and other documentation; operate GIS system hardware, software, plotters, and printers; convert data between common GIS formats; move, copy, delete, and add files, drawings, and maps to output reports in hard copy or electronic transfer; present information to users and answer questions. Duties included the installation and maintenance of software related products. Provided computer related hardware/software maintenance and support to employees throughout the company.

1984 - Present

Figure

The data seems to be partially complete, yet the current projection seems to be the incorrect one. In order to fix this the shape files had to be unprojected, then the GCS_ WGS_ projection and datum was temporarily assign to the layer in order to work with other layers. Some of the fields in the layers will be removed since they fail to provide an opportunity for analysis. i.e. LSDA10 from districts only has“ 00” in all of the records or Shape_ Leng which is a duplicate of the Software created Shape_ Length. The District layer does not contain any metadata, also the layer seems to have several geometry errors, and some of the most typical errors are self-intersections see Table 1 and slivers see Figure 1. Several cases exist where the district polygon layer seems to have void spaces between adjacent features.
Oct 2009 - Present

Sources

Sources
Use the Five-Step GIS Analysis Process, http://blogs.esri.com/esri/esritrainingmatters/2009/10/08/use-the-five-step-gis-analysis-process/, Suzanne B.. Approaches to school of business GIS programs, http://www.esri.com/library/brochures/pdfs/approaches-to-school.pdf https://desktop.arcgis.com/en/desktop/latest/manage-data/geodatabases/geodatabase-design-steps.htm.
Jan 2003 - Feb 2007

GIS Technician

El Paso Water Utilities

Responsible for the creation and maintenance of the information systems projects applied the handling and maintenance of the EI Paso Water Utilities GIS water distribution system; Maintain and update water utility asset databases and maps with the support of GIS and AUTODESK software; Review project plans and provide engineering support in new water distribution construction, recommending modifications to meet hydraulic parameters; Provide construction crews and supervisors technical information to complete projects in compliance with TCEQ rules, city codes and regulations; Develop statistical data associated, with water main breaks, fire hydrants and pressure regulators. Maintain and upgrade their respective databases using EXCEL, HANSEN and ACCESS and prepare reports for upper management and public information; Manage water distribution system data and assets using and sharing information through the use of GIS and HANSEN software. In addition; provide technical support and training to the various sections in the use of these programs. Implement GPS technology to determine the exact location of water assets.

Jan 1996 - Jan 2003

Engineering Assistant / Production Supervisor

Hatch Inc.

  Produced engineering drawings using AutoCad. Worked with consulting civil, structural, and mechanical engineers, clients, surveyors and architects. Ensured drawings met standards. Supervised personnel in shipping, receiving and assembly stock line departments. Responsible for identifying and problem solving system issues, e.g. incorrect inventory records, with recommendations to management. Audited inventory parts and created reports for presentation to senior management. Shipped/received product inventory and processed in database. Trained regular and new employees. Assisted in the development/writing of employee manuals.

Skills

Skills

Database/Development

Active participant in the planning of the GIS division IT infrastructure, database design, or software development using Microsoft  and Linux technologies.

Autodesk Autocad MAP/Civil 3D

Been using the software in order to share and transfer data between the city and its departments and any public request.

Computer Programming

I have studied Java, Avenue, Visual basic, Python, and object oriented programming methodology through the Computer Science department at the El Paso Community College  as well as completed recently a couple of ESRI trainings involving object oriented programming with GIS.

ArcInfo/ArcGIS

Been using the software extensively through my position as a GIS Specialist for the City of El Paso.

Portfolio

Education

Education
2012 - 2012

Schools
1983 - 1984

UTM