Post Job Free
Sign in

Sql Server Manager

Location:
Irvine, CA, 92602
Posted:
August 29, 2013

Contact this candidate

Resume:

Yeong Shih

Contact Information Address: * Kernville, Irvine CA 92602

Email: ab53br@r.postjobfree.com

Tel: (C) 949-***-****

Experience 25 Years of Professional Software Development.

System Architech with Integration.

ESRI GIS iOS & HTML5/Dojo/Dijit Web application

Development.

ESRI ArcGIS & ArcSDE Server administration/backup

Apple iOS Mobile device application development.

AutoCAD & ESRI GIS .Net Application Architect &

Development.

SQL Server Administrator/Application Design & Develop.

Web Environmental Data Management System Design &

Develop.

Web Master Company web site manager/Silverlight

development.

Deltek Vision System Administrator/Customization

Development.

Civil/Survey/Mapping/Water/Environmental Engineering

Application Design, Develop & Integration.

Education, Training M.S. Computer Science (Ohio University, Athens) 1988

& Certificate. B.S. Civil Engineering (Feng-Chia University, Taiwan)

1981

Microsoft Share Point For Developer (C#).

Microsoft SQL Server Advance Integration Service.

Microsoft .NET & ASP.NET programming in C#.

Actuate 8 Report Design And Customization.

Deltek Vision System for Administrator.

Actuate 8 Report Design & Customization.

AutoCAD Civil 3D Implementation.

AutoCAD Customization User Interface Design.

Microsoft SQL Server Integration Service Development.

Microsoft SQL Server 2000 with Transact-SQL.

Microsoft SQL server administrator.

Microsoft SQL server developer.

ESRI MapObjects (MOIMS) & ArcIMS.

Intergraph Geomedia GIS Development.

AutoCAD Advance II, LISP, VB &DotNet C# Application.

Dale Carnegie Training for manager.

Terramodel (Plus 3) for Survey and Civil Engineering

Model.

Softdesk Civil Modules - COGO, Design.

Microsoft Access Database advanced developer

(Microsoft).

Microsoft Access Application Development (Microsoft).

Oracle for Developer (Oracle).

Advanced Moss Design (Auto-Trol).

Workstation Training for Managers (Integraph Unix

Base)

Software Expertise ArcGIS iOS SDK application development.

ESRI JavaScript, Dojo/Dijit, HTML5, Jquery, Jquery-UI,

Box2D.

ArcGIS Server, MapObjects, ArcIMS, ArcObject, ArcSDE.

(DotNet - C#) with Dojo JavaScript HTML5 Map.

SQL Server 2005/2008, Integration Service. (DotNet -

C#)

Microsoft SharePoint, C#, VB.NET, ASP.NET etc.

Database Design and Programming T-SQL, MS SQL, Oracle,

PLSQL.

AutoCAD & Civil 3D Customization. (DotNet - C#

FW2,3,3.5,4,4.5)

Microsoft Office/Access integration/development.

Microsoft DotNet 2,3,3.5,4.0 VS2005/2008/2010.2012.

Adobe Flex Builder II/III. Microsoft Web Service.

Google Map.

Windows 7 64-bit application development.

Google Map/Google earth Integrations.

Project Experience

2003 - Present RBF Consulting- A Michael Baker Company

Sr. Application RBF Consulting was ranked #68 in the Top 500

Development Manager. Engineering Design Firms of the nation and also

awarded "The Best Places To Work" in year 2007.

Senior Associate. My role within the company not only an application

designer/developer but also as a software

planner/architect.

1. Develop ESRI ARCGIS Web Application Java Script

SDK/HTML5

For City of Santa Clara & Caltrans.

2. Develop ESRI ARCGIS Web iOS SDK For iPhone Mobile

Device.

3. Develop Microsoft Share Point application For

internal Suvery Field Book data collection system.

4. Develop integration programs to automate the

"Deltek Vision" financial system, design custom report

with "Actuate 8" and also serve as a MS SQL2005

server/OS system administrator. Responsibilities

included database implementation, Network load balance

setup, Deltek webLink system configuration and SQL

server SSIS development/Integration. (C# FW 3.5,4,

VBA, ADO.NET)

5. In charge of AutoCAD 2009, 2011, 2012 custom

configuration and installation package setup.

Responsible items included create enterprise/main CUI,

integrated with third party software by developing

MNL, create RBF-IntelliDraft cad system to provide

automated drafting tools for engineer design use.

IntelliDraft developed by Microsoft dotNet C# language

and currently around 100 functions and still on

progressing. (C# FW 3.5,4, AutoCAD OCX)

6. Design and develop RBF Floor Plan web system.

System included create web base administrator and

client interfaces to update employee information in

SQL server and provide a web client component in

AutoDesk DWF format to display employee office

location, contact phone list and photo image etc. This

also included a dynamic DWF generator application

(VB6) that running daily to convert AutoCAD base

drawing to DWF format for all offices. (ASP, VB6 CGI,

SQL2005/2008, ADO.NET, JSP)

7. Develop GIS applications for internal use by using

MS dotNet C# with ArcGIS. Help to install and manage

ArcIMS server. In charge of ArcSDE 10/MS SQL 2005/2008

spatial database management. Responsible for

maintaining ArcSDE server and SQL Server general

services. (C# FW 3.5,4, ASP, JSP, Dojo/Dijit Web GIS )

8. Develop company-wide civil engineering related

applications to automate and integrate current third

party software to enhance project productivity

dramatically. These applications included for Mapping,

Survey, Land Development and Water resource

departments. (VB6, C# FW 3.5,4, Access MDB,

SQL2005/2008, ADO.NET)

2000/04 - 2003/04 Integrated Environmental Service Inc. (IESI)

Senior GIS IESI is a leading GIS and Environmental Consulting

developer, company. The products included Environmental Data

System Administrator Management System (EDMS), Storage Tank Management

System (STMS), GIS Project Data Management System

(PDMS), Civil Engineering & Mapping software and 3D

Vice President of visualization software etc.

Application

Development. 1. I am currently working on the next generation EDMS

software by using Google Map Flex Builder SDK with

PostgreSQL/GIS spacial data. This application provides

rich web user interface, manage well and chemical data

through the web platform.

2. PDMS web service is a project data management

system that provides crucial project progress data for

real time visualization application by using Microsoft

VB6 language as a CGI with ESRI MapObject Web

component.

3. EDMS (Environmental Data Management System) is

leading environmental data management software. This

software consists of GIS technology, file management,

collaboration and plan schedule modules. I am the

major designer and developer for this system and

finished projects including Raytheon Canoga Park,

LASMO Tankport and Boeing C1. And create installation

program to install this product on the server side

with minimum configuration.

4. NexGolf PDA is wireless application developed on

WinCE platform. NexGolf is a new and innovative

product to help serious and casual golfers enjoy their

round and analyze their performance. NexGolf is

running on WindowCE platform and using Win Socket API

as the communication layer to connect to our server

program in the clubhouse. NexGolf also provide a

rich score analysis tools and display every single

shot location/attributes on a web base GIS map

platform.

5. Data acquisition project. This is a field data

collection project. Technician collect the field data

by using laptop or handheld device then send XML

stream through wireless Internet service provider and

company's VPN to our MSMQ COM server. This provide

automatically update to the EDMS database.

6. Design and implement database interface to MS SQL

server database by using dotnet C#.

7. Design and Develop "LegalMaster" for mapping

property data calculation and legal document

auto-creation.

1988/12 - 2000/03 RBF Consulting.

CAD/Civil/GIS App. RBF Consulting was ranked #68 in the Top 500

Developer. Engineering Design Firms of the nation and also

awarded "The Best Places To Work" in year 2007.

CAD System

Administrator Application System Integration.

Software Application 2. Develop enterprise CAD Plot Data Collection system.

Manager This application automatically collect plot

information (user, size, material, job#, plotter etc)

while making an AutoCAD plot then place plot request

to plotter and write plot data to SQL server. System

included a web base tool for project manager to review

plot cost of their projects and a plot progress viewer

application to notify user about the plot status.

(VB6, ASP, JSP, ADO.NET, BAT)

3. RBF Field Note thin client management system is a

handy application provide engineer access original

survey field note in a scanned PDF format through the

thin client windows application. The software provides

Input/Edit/Search/Report/Configuration functions for

company wide use. (SQL Server, ADO.NET, VB6, Crystal

report)

4. Provide VB6 and Microsoft Office suite

integration/automation application development. This

included MS Word, Excel, Power Point and Access MDB.

(VB6, VBA, Access Form/Report)

5. Develop professional Survey and Mapping tool

applications for file format conversion (Lewis to

TDS), check Mapping data precision (Mapcheck),

Integration with survey hand held device, infrared

measurement device, create legal document from mapping

data (Legal Description) and accuracy checking.

(VB6, RS-232, Access Reports)

6. Develop AutoCAD LISP applications for Land

Development, Water, Traffic, Transportation design

use. (AutoCAD LISP,VB6)

7. Create ESRI Dojo/Dijit/MoIMS web application for

Irvine Company property management use. (VB6, JSP,

HTML5, JavaScript, C#)

Reference Doug Abramson ab53br@r.postjobfree.com 949-***-****

Marcela Pearson ab53br@r.postjobfree.com

949-***-****

Jeff Tung ab53br@r.postjobfree.com 949-***-****



Contact this candidate