SUMMARY:

• Experienced GIS Specialist offering 18 years of success in private/public sector: designing, implementing, and supporting high - availability GIS infrastructures (desktop/server and intranet/internet).
• Responsible for the Public Works Utility Data Quality, Organization and maintenance: designing, implementing, and maintaining real time data availability on demand.
• Lean Six Sigma minded: identify value and non-value added time to develop proficiency process and implement GIS tools to achieve optimal return (dollar value).
• Excellent communicator: able to effectively translate technical information in a way that enables management, associates and end-users to understand.
• Asbuilts/originals drawing can be located on a network drive using Five Click Data Retrieval System.
• Created a structured filing system that enables an efficient searching process of engineering drawings.
• Supervised scanning and filing process of hardcopy engineering documents.
• Update addresses and parcels GIS Data (partially manual and automated)
• Concurrently managed the installation of three ArcGIS Enterprise Server 10.2, Installed Enterprise, MS Windows 2008R2, and MS SQL 2008R2, Created user login and specified user roles, data backup and recovery process.
• Designed and implemented automated data backup and restoration procedures in production and staging server mode.
• Implemented database refresh processes using full export a table level and full database defragmentation, resulting in improved performance and effective space management.
• Automated over 25 nightly data processing jobs with “Success” or “Fail” email provision.
• Coordinated with the vendor (Intergraph) in database and software upgrade ( ).
• Updated the oracle CAD911 database bi-monthly.
• Created hot spot map to identify areas with highest code case concentration to support implementation of the LEAN process to expedite code violation cases, and mobilize resources where it’s needed most by identifying value and non-value added time.
• Identified value and non-value added time in existing asbuilts review processes (expected to save over $100,00 worth of man-hours/year).

CORE COMPETENCIES:

Hardware: Apple Devices, Raspberrypi, Multi-core servers and desktop PCs.

Software: CityWorks, EnerGov, ArcGIS Server 10.5, ArcGIS 10.5, ArcSDE 10.5., QGIS, EDEN

Operating Systems: MS Windows 7/8/10, Enterprise MS Windows 2008 R2, MS SQL Server 2012, Ubuntu (desktop/server), PostgreSQL.

Protocols: TCP/IP

Tools: Network Analyst 10.2, Spatial Analyst 10.2, Oracle SQL Developer, DMAIC, 5S, Kaizen, Value stream mapping, Pareto analysis, Total predictive maintenance, Gantt Chart.

PROFESSIONAL EXPERIENCE:

Confidential

Sr. GIS Data Quality Assurance Specialist

Responsibilities:

• Administrator: Cityworks server: AMS/Designer/Storeroom, configure workflows, cases, work orders, service requests, and inspections, managing user access, users, testing new releases and feature changes, creating and managing application-based reports, create work order templates as needed basis
• Coordinating implementation of the Cityworks Storeroom for $615 million renovation project of the Confidential .
• EnerGov SME: managing map services, web-configuration, Live link, Map Viewer and update/review addresses/parcels and assign new addresses.
• Eden Utility Billing System: Maintain current and historical customer information and location mapping, validation and address lookups, set up new customers and utility accounts, extract water consumption reports.
• Identified value and non-value-added time in the existing workflow process (receiving, review and deliverables).
• Develop, implement and document GIS utilities quality assurance procedures.
• Coordinate with the Public Work’s survey crew to capture utility assets in areas with unreliable asbuilts.
• Supervise the digitizing/scanning of water and sewer system data from as-built drawings, CAD files, and survey files.
• Reduced turnaround time for the Engineering Document Request from 5 to 10 business days to 1 to 3 business days.
• Developed Five Click Data Retrieval System to retrieve the asbuilts/original drawings of a given area of interest.
• Coordinated with Fire Department to update the Fire Hydrant locations.
• Provide logistic support to the flood mitigation committee.
• Collaborate with the vendors to support Citywide Public Works project.
• Deploy, administer and support the GIS (software/hardware) infrastructures.

Confidential

GIS SPECIALIST/DATABASE ADMINISTRATOR

Responsibilities:

• Responsible for the administration and support of the Confidential ’s GIS and CAD911 dispatch infrastructures including 3 core sites and citywide users.
• Provided logistic support to the EOC team during emergency situations (special events, natural disaster).
• Collaborated with the vendors to support GIS data needed for city projects.
• Authored and maintained data update flow diagrams using Microsoft Visio.
• Conducted sessions on ArcGIS desktop software and custom GIS applications to instruct and mentor users in the different department of the City.
• Conducted feasibility studies to identify areas where GIS technology can be utilized in the City.
• Researched and evaluated hardware and software solutions that can add value, performance, and resiliency to the City’s GIS environment.
• Maintained/updated the CAD database (Oracle) using Oracle SQL Developer to support the 911 dispatch calls for the Police Department and Fire Rescue.
• Administering/maintaining ArcGIS Enterprise Server Use ArcGIS online for web applications and maps.
• Install operating Windows Server 2010 and MS SQL Server 2008 R2 database software on servers.
• Created over 25 ETL processes in SQL Server 2008 R2 to retrieve the data from IBM Informix, MDB/Excel database, and create/populate table.
• Designed and maintained over 100 feature classes/feature datasets in SDE and LocalGovernment schema (polygon, line and point)
• Design and maintain spatial databases in the ArcSDE enterprise geodatabase environment.
• Data Analysis (hotspot mapping) to support implementation of the LEAN six sigma process to expedite code violation cases, and mobilize resources where it’s needed most.
• Database server tuning, application tuning, maintaining documentation, capacity planning and database security in MS SQL Server 2008 R2.
• Managed database security. Design, develop, and implement automated data backup and restoration procedures. Provided technical support for database maintenance and disaster recovery.
• Coordinated, administered and executed all aspects of 45th Civil Engineering Base (Patrick Air Force Base) Comprehensive Mapping Program included resource management, resource allocation, contract management, and technical execution.
• Maintained project schedules.
• Provided and support for 45th Civil Engineering Base users.
• Supervised employees and maintained high technical standards.
• Developed a project plan with timeline, project budget, and employee management plan with task description.
• Managed project data collection. Implemented project quality control processes.
• Maintained direct customer contact to assure client satisfaction.
• Defined project specifications, assess customer’s needs and project expectations, plan and submit

Confidential

GIS analyst

Responsibilities:

• Derived methodologies for enhancing and extracting multi-spectral details from multi-spectral imageries using image processing software.
• Analyzed (ortho-rectification, mosaicing, geo-referencing and classifying) multi-spectral digital data to delineate and map illicit crop cultivation and other agricultural land use in South America.
• Developed a procedure for bi-directional reflectance issues.
• Created and customized MS Access databases with GUI (using Visual Basic/VBA) to access over 10,000 circuit line cards for tracking and maintenance.
• Implemented SDSFIE and FGDC metadata standards for Base map, electrical, sanitary and water utility systems geodatabase.
• Implemented web GIS solution (using Apache/Tomcat-Jakarta/ArcIMS 3.1).
• Converted and processed AutoCAD data into geographic data.