Mark Cederholm — Retired

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.

GIS Experience

I have over 30 years of experience in developing GIS applications using various Esri technologies, from Arc/Info AML to ArcObjects to ArcGIS Runtime and APIs for Python and JavaScript.

Certification: Certified GIS Professional (GISP), 2004 (renewed 2009, 2014, 2019, 2023)
Current Software Skills: ArcGIS Runtime SDK (.NET, Qt), ArcGIS API for Python, ArcGIS API for JavaScript, ArcGIS REST API, Microsoft Visual Studio, Qt Creator, ArcGIS Web AppBuilder, ArcGIS Pro, ArcGIS Enterprise
Current Languages: C#/WPF, Python, JavaScript/TypeScript, C++

Professional Experience

2022-2024 Application Developer-Geographic Information, IBM, Research Triangle, NC.
2022 Sr. ESRI Consultant, Wise Men Consultants, LLC, Houston, Texas.
2012-2021 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.

Past 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. Develop Python scripts to automate various scheduled tasks: process meter updates, create new premises, reconcile versions, update leak survey status, export data, generate and deploy MMPKs for field applications. Portal and GIS server administration for Evergy.

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 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. Implementation of ArcGIS Runtime to replace ArcReader. Migration of Silverlight apps to Web AppBuilder.

Other Projects: Migration of Gas data model to Utility Network / UPDM 2019. Development of geoprocessing services and WebAppBuilder widgets to automate plots and reports.

Other Accomplishments

Last revised: 2/21/2024

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