ArcGIS DBA and Application Developer

Mark Cederholm

Current Address
2267 S Rocking Horse Ln
Flagstaff, Arizona 86001
I prefer to be contacted via email:
plp@pierssen.com

Education
1985 B.S. in Biology. University of Wisconsin, Green Bay, Wisconsin.
1985-88 Graduate Studies in Biochemistry. Wayne State University, Detroit, Michigan.

Areas of Expertise
Since 1979 I have had experience in programming and using a variety of computer systems. As a Senior Developer for UniSource Energy Services, I have extensive hands-on experience in almost every aspect of creating and administrating spatial databases using ArcGIS, Smallworld, and related applications. I am adept at integrating digital and non-digital data from various sources into a unified GIS, and have developed C++, .NET, and Magik applications for data entry, import/export, DBA, and analysis. Past experience as an environmental GIS consultant has given me a diverse GIS background at a variety of project levels ranging from simple biological and archaeological surveys to complex mine reclamation programs. I also have experience in Oracle database creation and administration. Recently, I have shifted my focus to developing rich, cost-saving field and office applications using ArcGis Runtime technology.

GIS Experience
Certification: Certified GIS Professional (GISP), 2004 (renewed 2009, 2014)
Current Software Skills: ArcGIS Desktop, ArcGIS Server, ArcGIS Runtime (.NET, Qt), ArcFM Designer
Current Languages: C++, C#/VB.NET, Python, JavaScript

Professional Experience
2012-present Senior Engineering Application Developer. UniSource Energy Services, Flagstaff, Arizona.
2004-2012 Operations Technology Integrator. UniSource Energy Services, Flagstaff, Arizona.
1999-2004 Senior Programmer/Analyst. UniSource Energy Services (formerly Citizens Arizona Gas), Flagstaff, Arizona.
1992-99 GIS Consultant. SWCA, Inc., Flagstaff, Arizona.
1990-92 Junior Consultant. SWCA, Inc., Flagstaff, Arizona.
1989-90 Database Manager and Desktop Publishing Specialist. Citizen's Network, Ithaca, New York (a non-profit environmental awareness organization).

Current Responsibilities and Accomplishments
Administrative Duties: Application support and development. GIS database administrator for UniSource Energy Services UNS Gas and UNS Electric divisions. Data model evolution.

Selected Completed Applications: ArcMap-based field and office applications including: QA/QC; network outage analysis; custom locators; automated plotting; datum-transformed GPS display with snapping; saved visibility settings. ArcReader-based field and office applications including: many functions previously implemented in ArcMap; field data entry and synchronization with ArcSDE; layout template selection and As-Built plots. ArcGIS Runtime .NET field and office applications replacing ArcReader.

Major Completed Projects: Migration of data and applications from Smallworld to ArcGIS. Integration of GIS with new CIS database platform (CC&B) through Oracle. ArcGIS Server intranet applications. ArcMap field applications utilizing two-way geodatabase replication. ArcReader field applications. ArcGIS for Silverlight application implementation. ArcFM Designer implementation for UNS Electric, with SOA integration to Oracle Business Suite. ArcFM Designer implementation for UNS Gas.

Current Projects: Implementation of ArcGIS Runtime to replace ArcReader. Migration of Silverlight apps to JavaScript. Evaluation of JavaScript vs. ArcGIS Runtime for Qt to develop cross-platform mobile GIS apps.

Other Accomplishments


Last revised: 3/29/2015

[Some GIS code examples are available at my personal web site: www.pierssen.com]