Engineer Sql Server

LIYUAN WU

Tel: 949-***-****

Email: **********@*****.***

Home address: ** ***** **** ****, ******, CA 92612

PROFESSIONAL HISTORY

. Paragon Partners Ltd., Huntington Beach, California, Senior GIS

Specialist, 03/2009 - 10/2009

. TRC Solutions Inc., Irvine, California, Senior GIS Analyst, 03/2006 -

08/2008

. ABS Consulting, Irvine, California, GIS Engineer, 12/2000 - 08/2005

. Canada Center for Remote Sensing (CCRS), Research Associate, 04/1992

-11/2000

PROFESSIONAL Qualifications

. 15+ years of hands-on experience with Geographic Information System

(GIS), natural hazards, natural resources, environmental, energy,

pipeline engineering and remote sensing applications

. Proficient in using ESRI products including ArcInfo, ArcView, ArcGIS 9.x,

ArcSDE, ArcIMS and ArcGIS Server

. Application oriented GIS development on ArcObjects using VBA, VB 6.0 and

VB.NET

. Strong database design and modeling expertise using SQL server 2000/2005

. Strong understanding of Microsoft Access, AutoCAD, HTML, PCI, ERDAS and

Adobe Photoshop

. Proficient with UNIX, Windows and VMS

. Successfully completed more than 20 projects with proven achievements and

demonstrated abilities as a creative and cooperative team member

Work Experience

. 03/2009 - 09/2009: Senior GIS Specialist at Paragon Partners Ltd.

> GIS analyses for Right-of-Way and pipeline engineering requirements,

including data conversion, spatial analysis, datum coordinate system

transformation, 3D analysis, geo-processing, feature extraction and

editing, ortho-rectification, linear referencing analysis and geo-

database design

> ArcObjects programming to develop GIS application tools, including

pole audit inspections, database creation, pipeline parcel

extractions, and pipeline length calculations for specific routes

. 03/2006 - 08/2008: Senior GIS Analyst at TRC Solutions Inc.

> Cartographic mapping, 3D and spatial analysis, pipeline linear

referencing analysis, and pipeline design/integration with AutoCAD

> Developed ArcObjects tools for ArcMap based on pipeline alignment

sheets

> Database modeling for pipeline design engineering projects using T-SQL

statements and customized Pipeline Open Data Standard (PODS) and

ArcGIS Pipeline Data Model (APDM)

> Data migration and database administration of ArcSDE geo-database for

various pipeline databases and models

. Dec. 2000 - Aug 2005: GIS Engineer at ABS Consulting

> Designed database for the development of HAZUS MH (Hazards-United

States, Multi-Hazard) flood loss estimation tool contracted with

Federal Emergency Management Agency (FEMA)

> Performed GIS application programming tasks using VBA and ArcInfo AML

language for HAZUS MH flood model

> Involved in all aspects of GIS application activities including data

acquisition, processing, integration and analysis

> Processed the United States' 2000 census data to develop the HAZUS MH

database using SQL Server and ArcGIS systems

> Implemented damage evaluations based on occupancy square footage,

demographics, exposure dollar replacement costs and agriculture yield

losses

> Methodology analysis of spatial terrain surfaces for flood loss

estimation and evaluation using TOPO feature and Digital Terrain Model

(DTM)

> Provided direct assistance to customers for technical support

. April 1992 - Nov 2000: Research Associate at Canada Center for Remote

Sensing

> Integrated a variety of satellite sensor data into multi channel

images

> Developed methodologies to perform GIS/Remote Sensing applications

using VBA

> Created image processing scripts and Digital Elevation Models (DEM)

> Analyzed, processed and created satellite image maps for ingests, geo-

coding, scaling and enhancements using PCI and ERDAS

> Performed feature extraction from stereo satellite images (Optical,

SAR and LIDAR), geometric corrections and ortho-rectifications

> GIS processing of extracted features overlaid with DEMs and the

National Topographic System (NTS) base map and improved upon the data

handling efficiency using ArcInfo's AML

> Statistical analysis of the remote feature extraction accuracy and

spatial/temporal distribution patterns of SAR images

> Quantitative analysis of RADARSAT images

> Oceanographic applications including image processing, ocean surface

analysis (ship, wind, oil) with Ocean Monitoring Workstation (OMW),

hurricane wind retrieval and real time hurricane watch using

GIS/Remote Sensing integration methodologies

EDUCATION

. B.Sc. Degree in Photogrammetry, University of Zhengzhou Surveying &

Mapping, China

. 12 Certificates of ERSI training courses

Contact this candidate