Sql Server Manager
Resume:
Yeong Shih
Contact Information Address: * Kernville, Irvine CA 92602
Email: *********@*****.***
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 ********@*****.*** 949-***-****
Marcela Pearson ***************@*******.***
Jeff Tung ********.****@*****.*** 949-***-****
Contact this candidate