Developer .Net Sql Server Service Project Programmer
Resume:
Lijun Cheng
Markham,on L*R 7B3
*********@*****.***
Summary of Qualifications
Over 16 years programming, web programming experience.Masters of Science Degree in Applied Mathematics.Bachelor of Science Degree in Mathematics.Programmed with NET and ASP,VB6, VB, Active X, COM, HTML, Java Script, VB Script, MapObject, ASP,ASP.NET, VB.NET, ADO, ADO.NET, C#, Java,C++.Work experience with IIS, Windows Server, Oracle, MS SQL Server, MySQL.
Employment Experience
Progrmmer/SQL Server DBA March 2012 to Nov 2012
The Alea Group(call center) Richmondhill, ON
Maintain and develop new code for over 100 web portals with VB script,classic ASP, stored procedures, viewers, T-SQL.
Created SQL server 2005&2012 database, tables, stored procedures, views, job agents, backup,restore, SSIS,SSRS,import data,T-SQL,Tuning as DBA.
Migrated Window server 2003 SQL Server 2005 to Window 2008 SQL Server 2012.
Programmed with C#,SQL,Excel, Thread, Scheduled task, SMTP, VBA Macro for Excel, Crystal Report,Microsoft Report, Javascript,Classic ASP,HTML,VB Script.
Published and maintained Web pages as web administrator with Window server 2003&2008 IIS.
Studied and programmed with Flex Builder 4.6, ActionScript,XML, GeoCortex.
Studied Pivot Viewer Silverlight with Visual Studio 2010 and C#.
Studied Google Earth API with HTML and Javascript.
Developer Oct, Dec, 2011
Tek System, Memphis,TN
Programmed with HTML,CSS,Javascript, Eclipse, Python, JSP,Java, JQuery,AJAX.
Developer May 2011---Sept, 2011
Mission Communications, Atlanta, GADeveloped Chart and Graph projects with Javascript, HTML, Jquery, Ajax,DOM, JSON, Classic ASP, Jquery Flot API, VB, VS 2008, VS 2010, Stored procedure, XML, XSLT,SQL Server,PHP, and MySQL Server.Made code work for IE, Safari, FireFox, and Chrome browsers, iPhone and iPad.
Consultant(in China) Sept, 2010 --April, 2011Made lectures about GIS Project Development in Harbin Normal University.Wrote proposals to get a project of Heilongjiang Provincial Land Management. Programmed with VS 2010,Silverlight 4, C#, and LINQ.
Leader Programmer/Analysis(contract) Feb, 2008 July,2010
City of New Orleans, LADeveloped Property Viewer web sites with JavaScript, dojo, DOM CSS, HTML, AJAX, C#, Visual Studio 2005, AJAX control kit, Google Map, AJAX. Developed web site with Silverlight, Grid, Draggable Panel, stackPanel, Combo Box, Canvas, WCF Service, SQL Server 2008, C#,ASP.NET http://property.nola.gov/).Developed Image Rotators with Silverlight, VS 2010, and DispatcherTimer .Created two WCF services with WCF Service Application template, ADO.NET,SQL Server, VS 2010.Developed web site wiith Flex API,Flex Builder 3, and Actionscript.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(C#),SQL Server.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. Maintained ArcIMS Web Site with Visual Studio VB, ArcSDE, Crystal Report, T-SQL,SQL Server, and AJAX.Solve problems which other programmers can not solve.Maintaining ArcObject programs with VB6.Trained and self studied SharePoint Development with .NET. Manipulate SQL server 2005 database in Window 2003 server.Redeveloped web pages with SiteCore and C# NET.
Developer July, 2007 Dec, 2007
RTM Design LdConverted VB 6 code to VB.NET with XML,WinForm, MS SQL server 2003 and MS Access with Visual Studio 2005.Programmed with VB.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, SSIS, and SSRS) in Window 2003 server.Did analysis with pie chart, bar chart, crystal report.Did reports with SQL Report Service 2005.Updated CCGD Visual Studio 2003 ASP.NET 1 System to Visual Studio 2005 NET 2
ArcIMS Developer Dec, 2006-- May, 2007
Florida Power and Light Successfully finished ArcIMS website Poles Viewer using Javascript, XML, ArcXML, ArcMap Server, Java connector, SOAP, Web Service,CSS, DOM, HTML, DHTML, Java, AJAX, and Applet.Manipulated spatial data with ArcGIS9 and ArcObject.Wrote a train document; setup running environment.
GIS programmer Jan, 2006 Dec, 2006
Florida Fish and Wildlife Research Institute 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).Maintained classic ASP, HTML,VB Script web sites.Programmed for Deep-Water-SEAMAP project using VB 6.Programmed for summary manatee data using ArcObject, VB 6, ADO, and Crystal Report.Programmed zip ArcSDE files and published them 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 Manatee data using ASP.NET(C#), ArcXML, Visual Studio, NETLink, Java Script, and ArcSDE(Pending, waiting for fund).Edited and Changed old web site codes with Dreamweaver8.
GIS Assistant Sept, 2005---Dec, 2005
University of Guelph, Guelph, OntarioTaught Arcview3 (Geoprocessing, map design, and layout) and IDRISI(Spatial Analysis). Developed programs with VB 6, Avenue and SAS.
Application Programmer January, 2005- April, 2005
Superior Holiday Adventures, Sault Ste. Marie, ONDeveloped programs to track tour package sales with VB.NET, C#, 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 web sites with MySQL and PHP.
Software Developer (Contract position) Summer 2004WorkGroup Design Ltd., Toronto, ONAdded codes to Juggler using VB 6, ASP,ADO, Crystal Report, SQL and MS Access.
ArcObject Programmer April,2004 to May,2004
Ontario Ministry of Northern Development, Geology DivisionDeveloped field survey programs using ArcObject ArcPad, and VB
ArcObject Programmer(part time) Nov,2003 to March,2004
Ontario Ministry of Natural Resources, Wawa DistrictDesigned and modeled project of Road Access ManagementDesigned and established Access database(tables, forms, queries, pictures, reports)Linked the Access database with point features(a shapefile) in ArcMap8Developed a tool linking a MS Access report and a point feature using VB 6 and SQLDeveloped 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 6.Established and maintained MS Access members database.
Programmer (part time) September 2001, May 2002
Boreal Services Ltd., Victoria, BCCustomized Arcview 8 with ArcObject, VB6, and ADO.Programmed with C#,VB,ODBC, and MS Access.Translated English web site into Chinese web site with Front Page.
Programmer (Volunteer) July – September 2001
Latitude Geography Group Ltd., Victoria, BCDeveloped programs with Avenue, ArcView3 and Dialog designDeveloped web site program using JavaScript, Visual Basic 6, ASP and MS Access
Programmer/GIS Analyst 1990-2001
Heilongjiang Provincial Computer CentreEstablished and maintained cadastral database (spatial and attribute) for three government bureaus with VB,Foxprow,Access, MapInfo and Mapbasic.Developed programs with Basic, VB6, ADO, MS Access, MapInfo, and Mapbasic.Created cartographic solutions to support land management.Manipulated SQL Server 7 with stored procedure, T-SQL, and Enterprise ManagerManipulated Oracle with PL/SQL, Enterprise Manager, and NT Backup/NT Recover.Designed, programmed, and maintained Oil Tank Storage Software of Measurement, Statistics, and Management with C++.Programmed for optimization software for design of pumpjack.
Education
Post-Diploma GIS Applications Specialist (2004)
Sault College of Applied Arts and Technology
Courses Included:
ArcObject (VBA)
GIS (Arcview3)
Geodatabase(ArcSDE)
Arc/Info 8(AML)
VB6 Programming
Remote Sensing(ENVI)
Modeling with GIS
Cartography, GPS,UML
PCI
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:
AutoCad2002
Land Survey
Elementary Survey
GeoScience
VB6 Programming1&2
Advanced VB(XML MapObject)
Map Interpretation
(ENVI)
Database System (Oracle with SQL)
Computer Network
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.
Bachelor of Science Degree in Mathematics (1985)
Harbin Normal University
Professional Development
January 6th,2010 Sitecore Certificate: Web Site .NET Developer
Contact this candidate