programmer/web programmer/GIS programmer

Lijun Cheng

**** ******* ***** **

Buford, GA ***19

Cell phone:678-***-****

*************@*****.***

Summary of Qualifications

Over 16 years programming, GIS analysis, web programming experience.

Post-diploma in GIS Applications Specialist program.

Masters of Science Degree in Applied Mathematics.

Bachelor of Science Degree in Mathematics.

Experience in ArcMap, ArcGIS Server 9.2 & 9.3&10&10.1&10.2, ArcGIS Server Javascript API&Flex API, Customizing ArcIMS with ASP.NET and ASP, ArcObject, Arcview, Avenue, AML, MapInfo,MapBasic, AutoCAD, VB, Active X, COM, HTML, Java Script, VB Script, MapObject, ASP,ASP.NET, VB.NET, ADO, ADO.NET, Java, C#, Oracle, MS SQL Server.

Work experience in maintaining hardware and software(SQL Server, IIS, Windows).

Programmer(Contractor) July, 2013 to Current

AT&T, 675 W Peachtree St NW, room 29044, Atlanta,GA

Analyzed and visualized sale data with Tableau.

Target Statistics Analysis with R programming(vector, median, standard deviation, plot, relative percentage plot, linear regression, distribution).

Developed Sale Data statistics analysis web applications for Mobile, iPad, various screen resolution with Jquery, AngularJS, Javascript, HTML5, CSS3, ootstrap, LESS, web service,VS 2012, C#, VB.NET, SQL server, Crystal Report,T-SQL,SQL, SSIS, SSRS, Excel, Web Service, LING, XML,AJAX Control Toolkits, MVC, TDD, Responsive Design, Python, ArcGIS Server Javascript API.

Published and managed web server with IIS for our group web server.

Updated SQL server 2008 to 2012, created tables, view, queries,functions,stored procedures, backup, restore,Input/Output.

GIS Programmer/Analyst Jan, 2013 to June, 2013

Global Information System, 455 S. Sam Barr Drive, Kearney, MO 64060

Programmed ESRIQc Web and ArcObject Add-ins with VS 2010 C#,TFS, Spatial Oracle, HTML, CSS,ArcGIS 10&10.1, Javascript, Jquery,Excel, SQL, XML, LINQ,C#,cross browsers, Infragistic, Python.

Developed Version Compare Excel Output Add-in 10.0&10.1 with ArcInfo10&10.1, Geodatabase, SQL, Excel, WPF, XAML, C#( for two clients, one client 10.0, other 10.1).

Added new functions(such as LayerList Widget) to ESRI Arcgis server Javascript API projects.

Read other guy’s Python code to understand business logic for ESRIQC projects.

Modified AutoUpdate with ArcObject,LINQ,C#, Winform .

Programmed Pipeline Data Dashboard with VS2010,bar,chart,Oracle,ASP.NET.

Progrmmer/SQL Server DBA/Web master Feb 2012 to Nov, 2012

The Alea Group, 60 Granton Dr, Richmond Hill, ON, Canada

Programmed and maintain web and window Form with C#, SQL, Javascript, Jquery,Crystal Report,SSIS,SSRS, HTML, Excel, scheduled tasks, Thread, Classic ASP, XML, VB Script .

Migrated python XML Generation code to C#.

Migrated Window server 2003 SQL Server 2005 to Window 2008 Server 2012.

Published and maintained Web pages with Window Server 2003&2008 IIS, Active Directory as Web administrator.

Created database,tables,views,stored procedures,SSIS package, Job,import,export,T-SQL, backup,restore, Join, union,tuning as SQL Server DBA.

Created new Widget and modified existing Widgets for Ontario Natural Resources with ArcGIS Server Flex API .

GIS Java Consutant Oct, 2011 to Dec 2011

FedEx Memphis, TN

Wrote and debug code with Java,Eclipse, ArcGIS Server Javascript API

(the job no interview, FedEx ask several programmer for test, then hire, it not hire me because my English is not perfect and Java not expert)

Got train about LP360 LiDAR process software.

Customized some functions of its LP360 LiDAR software.

Front End Dveloper April, 2011--- Sept, 2011

Mission Communications, 3060 Business Park DR,Suite C, Norcross,GA

Manager: Harry Feng 678-***-****

Developed SCANDA data Chart and Graph projects with Javascript, Responsive Web Design, HTML, Jquery, Ajax, JSON, XML, XSLT, Classic ASP, VB, ODBC, ADO, CSS, VS 2008, VS 2010, PHP, SQL Server, Stored procedure, and MySQL Server.

Made web work for IE, Safari, FireFox, Chrome browsers, Mobile, various screen resolution desctop, iPhone and iPad.

Designed or tested how to develop web GIS with Javascript, SQL Server or MySQL Spatial.

GIS Consultant Aug, 2010 –March, 2011

Harbin Normal University, 50 Hexing Rd Harbin, Heilongjiang, China.

Made lecture about GIS Project Development in Harbin Normal University, China.

Made projects for my lectures with ArcGIS server Javascript API.

GIS Programmer/Analysis(contract) Feb, 2008 July,2010

City of New Orleans, 1300 perdido street, New Orleans, LA

Designed and Developed ArcGIS Server 9.3 web sites with Javascript API, dojo, Javascript, DOM, VB,C#, Visual Studio 2005&2008, Crystal Report, Web Service, AJAX Control Toolkits, Google Map API, AJAX, ArcGIS Online as a leader developer.

Developed several Generation New Map tools with Python and ModelBuilder.

Designed and Developed Web site with ArcGIS Server Silverlight API, WCF Service, SQL Server, Grid, Draggable Panel, stackpanel, Combo Box, Canvas, C#,Visual Studio 2008 as a leader developer(http://property.nola.gov/).

Developed Image Rotators with Silverlight, VS 2010, and DispatcherTimer ;

Developed and maintained web sites wiith ArcGIS Server 9.3 Flex API, Flex Builder 3, and Actionscript.

Developed Adress Join with ArcObject, C#,ArcSDE, SQL Server,Geocode, Locator.

Wrote a user guide for Address Join via reading code of VB, ArcObject, and ArcSDE.

Developed Mayor Indicator Automation with Visual Studio 2005(VB), Excel, SQL Server, ADO.NET, and VBA.

Developed Church Management Web Sites with Visual Studio 2005, SQL Server, Google Map API, SharePoint.

Developed ArcObject programs(get adjacent parcel information ) for New Orleans Recovery Authority.

Analyzed client requirement and designed logic solutions.

Loaded data into ArcSDE database and added data into map service from ArcSDE.

Developed DTS(local packages) for SQL Server 2005.

Maintaining and added new functions for ArcGIS Server 9.2 Web Site with Visual Studio(C#,VB), SQL Server, and AJAX.

Maintaining ArcIMS Web Site with Visual Studio(C#,VB), ArcSDE, Crystal Report, T-SQL,SQL Server, and AJAX.

Solve problems which other programmers can’t solve.

Maintaining ArcObject programs with VB,C#, geocode, and locator.

Manipulate SQL server 2005 database in Window 2003 server.

Installed and configured ArcInfo, ArcExplorer, VS 2008, and ArcGIS Server 9.3.

Maintained web sites and created map service with ArcGIS Server.

Developer Aug, 2007 Dec, 2007

RTM Design Ltd, 137 Straight Drive, Anderson, SC 29625

Developed a program transfer XML data to MS SQL server database, Win Form, and MS Access with Visual Studio 2005.

Programmed with ASP.NET 2, SQL, Javascript, Web service, stored procedures, ADP.NET, CSS, AJAX Toolkit, ASP.NET Callback Framework, IIS.

Manipulated SQL server 2005 database(SQL,stored procedure, backup,SSRS,Index) in Window 2003 server.

Did analysis with pie chart, bar chart, crystal report.

Updated CCGD(311) Visual Studio 2003 ASP.NET 1 System to Visual Studio 2005

GIS Developer (Contractor) Dec, 2006--June, 2007

Florida Power and Light, 700 universe blvd, Juno Beach, FL

Successfully finished ArcIMS website Poles Viewer using Javascript, XML, ArcXML, ArcMap Server, Java connector, SOAP, Web Service,CSS, DOM, HTML, DHTML, Oracle,Java, AJAX,JSP, and Applet.

Used ArcFM to compare my web showing data and spatial data.

Fixed data duplicate problems with ArcMap 9.2,TOAD, ArcObject, Geodatabase, ArcSDE Oracle, SQL,VB, VBA.

GIS programmer/Analyst(contractor) Jan, 2006 Dec, 2006

Florida Fish and Wildlife Research Institute, 100 8th Ave SE, St Petersburg, FL 33701

Programmed for Deep-Water-SEAMAP project using ArcObject(Done).

Programmed zip ArcSDE files with ArcObject(C#) and ASP(done).

Get training in ArcGIS Server 9.2, ArcInfo 9.2 and Python programming.

Designed and programmed ArcIMS website for South Florida EcoMap 140-layer data using ASP.NET(VB), ArcXML, SQL, Visual Studio, NETLink, ASP, Crystal Report, Java Script, and ArcSDE(Done, http://ocean.floridamarine.org/ecomap)

Designed and programmed ArcIMS website for Manatee data using ASP.NET(C#), ArcXML, Visual Studio, NETLink, Java Script,Oracle, and ArcSDE(Pending for summary manatee data using ArcObject, ADO, and Crystal Report., waiting for fund).

Edited and Changed old web site codes with Dreamweaver8.

GIS Assistant Sept, 2005---Dec, 2005

University of Guelph, Guelph, Ontario

Taught Arcview3 and IDRISI including geoprocessing tasks such as overlay analysis (union, intersect, and erase) and proximity analysis (buffer, near, point distance).

Developed programs with VB, Avenue and SAS.

Initiated and changed code for SWAT hydrologic model.

Application Programmer January, 2005- April, 2005

Superior Holiday Adventures, Sault Ste. Marie, ON

Developed programs to track tour package sales with VB.NET, ADO.NET, and SQL Server.Did sales data analysis using chart, bars, crystal report, and VB.NET.

Designed and created SQL database.Manipulated SQL Server using T_SQL.

Maintained SQL Server database.

Software Developer (Contract position) June 2005 Oct 2005

WorkGroup Design Ltd., Toronto, ON

Added codes to Juggler using VB, Crystal Report, SQL and MS Access.

ArcObject Programmer April, 2004 to May,2004

Ontario Ministry of Northern Development, Geology Division

Developed field survey programs using ArcObject ArcPad, and VB.

ArcObject Programmer(part time) Nov,2003 to March,2004

Ontario Ministry of Natural Resources, Wawa District

Designed and modeled project of Road Access Management

Designed and established Access database(tables, forms, queries, pictures, reports)

Linked the Access database with point features(a shapefile) in ArcMap8

Developed a tool linking a MS Access report and a point feature using VBA and SQL

Developed a tool that read spatial information from a shapefile and wrote it into Access database.

Developed VBA tools that read data from Access tables and write to MS Excel files.

Developed a program that merges two shapefiles.

Wrote a proposal and tutorial files about the GIS system.

Programmer (Contract) Summer 2003

Central Alberta Economic Development Corporation, Red Deer, Alberta

Developed Web Site programs (Server and Client Sides) with ASP, HTML,VB Script, and VB.

Established and maintained MS Access members database.

Programmer (part time) September 2001, May 2002

Boreal Services Ltd., Victoria, BC

Customized Arcview 8 with ArcObject, VB6, and ADO.

Programmed with C#,VB,ODBC, ColdFusion,and MS Access.

Translated English web site into Chinese web site with Front Page.

Programmer (Volunteer) July – September 2001

Latitude Geography Group Ltd., Victoria, BC

Developed programs with Avenue, ArcView3 and Dialog design

Developed web site program using JavaScript, Visual Basic, ASP and MS Access

Published data using ArcIMS.

Programmer/GIS Analyst/Project Manager 1995-2001

Heilongjiang Provincial Computer Centre

Led 5 developers and 10 technicians to established and maintained cadastral database (spatial and attribute) and computer management system for three county government agencies with VB, Visual FoxPro, Access, MapInfo and Mapbasic.

Wrote and maintained Borland C++ code for Harbin Refine Factory project.

Created cartographic solutions to support land management.

Manipulated SQL Server 7 with stored procedure, T-SQL, and Enterprise Manager

Manipulated Oracle with PL/SQL, Enterprise Manager, and NT Backup/NT Recover.

Managed Data Entry for China Harbin Life Insurance Co with SQL, Linux, Sybase.

Programmer 1990--1994

Daqing Oilfield Limited, China

Designed, programmed, and maintained Oil Tank Storage Software of Measurement, Statistics, and Management with VB.

Programmed for optimization software for design of pumpjack.

Education

Post-Diploma GIS Applications Specialist (2004)

Sault College of Applied Arts and Technology

Courses Included:

MS Access

ArcObject (VBA)

GIS (Arcview3)

Geodatabase(ArcSDE)

Arc/Info 8(AML)

VB6 Programming

Remote Sensing(ENVI)

Modeling with GIS

Cartography, GPS,UML

Linear Referencing

Hydrologic Analysis

3 D Analysis

Spatial Analysis

Utility Analysis

Dreamweaver MX

ArcGIS(ArcMap, ArcCatalog, ArcTools)

Web Design (HTML, Front Page, ArcIMS)

Project Management

(PowerPoint)

Geomatics Courses (2002-2003)

Lethbridge Community College, Alberta

Courses Included:

AutoCad(AutoLisp)

Land Survey

Elementary Survey

GeoScience

VB6 Programming1&2

Advanced VB(XML MapObject)

Map Interpretation

(ENVI)

Database System (Oracle with SQL)

Computer Network

GeoScience

Project Experience:

Read data from XML file and created an shapefile with VB,COM, and Active X.

Designed many tools to manipulate the shapefile with VB6 and MapObject.

Exported information to MS Excel sheet file with VBA.

Designed database with Microsoft Visio 2000.

Masters of Science Degree in Applied Mathematics (1988)

Harbin Institute of Technology

Project Experience: Developed oil prospecting data analysis program (including algorithm and modeling) using Fortran 77.Courses including Operation Research, Algorithm, Statistics, and Modelling.

Bachelor of Science Degree in Mathematics (1985)

Harbin Teaching University

Professional Development

Certificates of Pragramming with Python(2006).

Certificate of Exploring the VBA Environment (2004)

Certificates of Working with ArcPad (2004) and Customizing ArcPad (2004)

Contact this candidate