Kim Kelln, M.Sc., P.Eng.

Io Software Consultants, Calgary, Alberta, Canada
Telephone: (403) 830-5983
E-mail: k.kelln@iosoftware.ab.ca
Last Updated: 30 October 2017

Experience Certifications Affiliations Technical Availability        (very long) Print Version        (short) Print Version

PROFILE

Kim Kelln has been providing data architecture, business analysis and software engineering consulting services to a broad spectrum of Calgary businesses since 1983. He has been instrumental in delivering effective and practical solutions to satisfy all of his customers' needs as they have evolved over the years. Kim's experience has mostly been in the Oil & Gas domain where his clients have included many of the major oil and gas operators, service companies and data vendors. His background and experience also includes projects in the business domains of electrial energy production, rail transportation, health care and publishing. Kim is able to provide expertise throughout all phases of the system or software life cycle: Business analysis, requirements elicitation and analysis, information and systems modeling, analysis, design, development and deployment, and software engineering. He is especially recognized for his capabilities in information and data architecture, analysis, modeling and integration, and for his background, knowledge and understanding of the Public Petroleum Data Model (PPDM).

Kim is a registered Professional Engineer (Lifetime P.Eng.) in the province of Alberta.

PROFESSIONAL EXPERIENCE

Dates
(click on dates for detail)
Company
Sub-contract
Project(s)
Roles
January 2015 to June 2017 Transcanada
Sub-contract: S.i. Systems
GIS Replacement Program
Data Analyst
 
Kim was brought in to take responsibility for the a number of research and analysis sub-projects. Three of the sub-projects were corporate wide assessments of GIS quality factors, GIS replacement dependencies, and socialization of new paradigms for linear measurement in the GIS.

September 2014 to December 2014 Devon Energy
Sub-contract: Noah Consulting
PPDM v3.8 Migration
PPDM Data Architect / Analyst
 
Kim was the PPDM data analyst expert for the current deployment phase of the Devon PPDM v3.8 migration project.

April 2014 to September 2014 Mark's
Sub-contract: Cadeon Associates
Single Source of Truth (Phase I)
Data Analyst
 
Providing data analyst support for the end of phase I of the Single Source of Truth project, including (mostly) troubleshooting issues with the quality of the source data content and the proper migration into the ARTS-based data vault repository.

October 2013 to December 2013 ConocoPhillips
Sub-contract: Noah Consulting
Eagle Ford PPDM Data Warehouse
Data Architect, PPDM SME
 
PPDM expertise, data architecture and detailed data mapping for the Eagle Ford PPDM data warehouse project.

June 2013 to July 2013 Devon Energy
Sub-contract: Noah Consulting
Asset Management (GHG Reporting)
Business Analyst, Data Architect
 
Providing business analysis and data architecture services during the assessment phase of an asset management strategy needed to support new GHG reporting requirements.

June 2012 to June 2013 Groundswell Group Inc. Cenovus DMS Managed Service
Data Architect
 
Data architecture and subject matter expertise in support of projects initiatied by the DMS group at Cenovus. The projects related to moving content into and out of the Cenovus data warehousing systems - EDW and FIS. The major project was the upgrade for the new Wellview and Siteview versions.

August 2011 to May 2012 Husky Energy
Sub-contract: InSync Systems
Saskatchewan Registry Conversions
Data & data integration architect
 
Data and data integration architecture, business analysis and sub-project coordination related to the UWI and facility identifier conversions arising from the switch by the Saskatchwan Government to the Petroleum Registry for regulatory reporting purposes.

January 2011 to June 2011 Transalta Utilities
Sub-contract: Noah Consulting
Common Data Access Release II
Data architect
 
Data architecture services related to trouble shooting and warranty for the first release of the program, and related to fine tuning and enhancement of existing data management algorithms, processes and procedures, especially for the Estimated Gross Margin calculation data set and engine.

July 2010 to December 2010 Transalta Utilities
Sub-contract: Noah Consulting
Common Data Access Release 1
Data architect
 
Data architecture services in support of the modeling, design and deployment of the common data access operational data store and information delivery layer.

March 2010 to June 2010 Transalta Utilities
Sub-contract: Noah Consulting
Common Data Access Assessment
Data architect
 
Data architecture services related to the assessment of data readiness and conceptualization of a common data access repository and information delivery warehouse for operational data, including production, availability, maintenance, facilities and human resources.

December 2009 to February 2010 Nexen Inc.
Sub-contract: Noah Consulting
Strategy & Architecture Assessment
Data architect
 
Data architecture services in support of Noah's Strategy and Architecture Assessment of Nexen's Information Management Improvement Initiative.

May 2009 to June 2009 geoLOGIC Systems Ltd.
PPDM Conversion
Data architect, PPDM SME
 
Data architecture and SQL scripting to convert a PPDM v2.3 operational datastore to PPDM v3.8, integrate the content with IHS well data and build updatable PPDM v2.3 views to allow exisitng applications to view the integrated content.

September 2008 to December 2008 Husky Oil Operations Limited
Land Data Store
Data architect, PPDM SME
 
Data architecture, modeling, analysis, and detailed design for the transformation of CS Explorer content into a PPDM Land Data Store, including all of the infrastructure required to support the new PPDM v3.8 constructs for dynamic translation and management of reference entities, and units of measure conversions. Working with the Land system Subject Matter Experts on the architectural and data mapping requirements and preliminary workflows. The first phase of the project comprises only basic mineral lease header information, plus all of the reference entities need to support the lease content.

December 2007 to September 2008 Husky Oil Operations Limited
Wellview and Siteview Deployment(s)
Data architect, business analyst, integration specialist, data migration and data quality specialist, well SME
 
Integration architecture, models and designs for the conversion of Husky's upstream integrated reporting environment from a Maxwell base to Wellview and Siteview for drilling and completions information. Data architecture, analysis, modeling and design for the migration of well and lease construction content from the Maxwell well management system into Wellview and Siteview, respectively. Eliciting, verifying and validating requirements for well and lease construction information with selected subject matter experts and the extant Maxwell support team.

September 2007 to November 2007 Husky Oil Operations Limited
Lima Refinery Transition
Data migration and data quality specialist
 
Consulting relating to data migration and data quality, including document management issues and concerns, for the transition of the Lima refinery operations from Valero Energy to Husky.

September 2006 to June 2007 Encana Corporation
Sub-contract: S.i. Systems
CORPWELL/eWATCH
Encana Data Depot projects/support
Data and integration architect, business analyst, designer, developer
 
Operational support for the Encana Data Depot (EDD) and consulting on selected EDD projects. Working with client groups within Encana to refine information and data requirements and to validate data access workflows. Modeling, analysis, design and programming for Corporate Well Repository that is primarily intented to support eWATCH project. CORPWELL is based on the industry standard PPDM data model.

June 2005 to August 2006 Encana Corporation
Sub-contract: S.i. Systems
Encana Data Depot
Well Cross-Reference
WellView Version 8 implementation
Architecture
Data and integration architect, business analyst, designer
 
Architecture, modeling, analysis and design for the Encana Data Depot (EDD) project. Modeling, analysis, design and prototype development for the Well Cross-Reference (engine). Part of the Information Architecture team of the newly formed Solutions Delivery Architecture department. Working with the Architecture team internal clients to elicit and refine requirements for the EDD and (primarily) the Well Cross-Reference projects.

August 2004 to May 2005 Encana Corporation
Sub-contract: Access Technology Management (defunct)
Spend reporting, Compliancy, BIA
BC spend analysis
WellView and SiteView maintenance and support
Architecture, Integration, Software Engineering
Data and integration architect, business analyst, designer, developer
 
Architecture, modeling, analysis, design and development for several Foothills Region Business Intelligence and Access (BIA) initiatives including a spend reporting and operational data warehouse, and spend analysis databases. On-going maintenance and support for WellView and SiteView implementations. Gathering, documenting, refining and verifying requirements from Foothills Region clients and Subject Matter Experts.

April 2004 to June 2004 Encana Corporation
Sub-contract: Access Technology Management (defunct)
Architecture, Integration, Frameworks
RTD and RTC
Wellview maintenance, support and data cleanup
Data and integration architect, business analyst, designer, developer
 
Part of a team responsible for Enterprise architectures and architectural frameworks, mostly around application and data integration. Requirements gathering and refinement, modeling, analysis and design related to enhancement and integration of existing Requisition to Drill/Complete applicatons.

May 2003 to March 2004 Encana Corporation
Sub-contract: Access Technology Management (defunct)
WellView Implementation and Integration
Integration team lead, data and integration architect, business analyst, designer
 
Team lead, architecture, modeling, analysis and design for integration of the newly implemented WellView drilling and completion system with the existing Complete Well Summary system, the source for well identity at Encana. Eliciting, verifying and validating information, data and workflow requirements with the CWS users and subject matter experts.

January 2003 to April 2003 Encana Corporation
Sub-contract: Access Technology Management (defunct)
Drilling and Completions System Evaluation
Business analyst, data architect
 
Eliciting, documenting, refining, verifying and validating requirements from Drilling and Completions engineers, technitions and well management experts for a Drilling and Completions replacement system at Encana.

October 2002 to November 2002
March 2002 to September 2002
October 2001 to February 2002
April 2001 to October 2001
International Datashare Corporation Land Database - Phases I, II, III, and maintenance
Business analyst, data and integration architect, designer, developer and project manager
 
Model, design, build and deploy the infrastructure necessary to support the acquisition, management, sale and distribution of publicly available information on land of interest to the oil industry. This would include information on crown agreements, freehold titles and encumbrances, federal lands, calculations of open crown rights, and land sales. The principal feature of this system is integration of land information from all jurisdictions under a common PPDM v3.5 land data model, using a 3D rights model. This was a turnkey project starting with elicitation and documentation of requirements, the preparation and presentation of a specification and budget. The requirements were continually refined, verified and validated with the clients subject matter experts and web delivery team.

August 2000 to February 2001 Talisman Energy Inc.
Sub-contract: xwave
Corporate Query and Reporting
Accounts Payable Data Store
Lead business analyst, system architect, data and integration architect, designer
 
 

April 1999 to June 2000 Canadian Pacific Railway VISTA STP Sub-Contract
Business analyst, lead designer, programmer
 
 

May 1998 to April 1999 Talisman Energy Inc.
Sub-contract: Minerva Technologies (now xwave)
Corporate Well (Administration) System
Lead business analyst, system architect, data architect, designer
 
 

February 1998 to May 1998 Newspaper Technologies Inc. (defunct)
Sub-contract: RIS Resource Information Systems
Conversion of SQL Server stored procedures to Oracle
Developer
 
 

October 1997 to February 1998 OTATCO Inc. (defunct) Oilfield Equipment Management
Lead data architect, designer, DBA
 
 

January 1997 to October 1997 Canadian Pacific Railway
Sub-contract: RIS Resource Information Systems
Order Entry Project
Business system analyst
 
 

July 1995 to December 1996 QC Data (now IHS Energy) CDA and Log Axxses
Designer, Developer
 

November 1992 to June 1993 (Contract)
July 1993 to June 1995 (Full time)
Applied Terravision Systems Database Products Manager, data and integration architect, designer, developer
 
 

January 1992 to October 1992 Digitech Services (now IHS Energy) Canadian Oil Scouts Databases
Designer, Developer
 
 

Prior to 1992 Io Software Consultants Numerous
Business analyst, data and integration architect, designer, developer, project manager
 
 

CERTIFICATIONS

1997   American Society for Quality
Certified Software Quality Engineer (Re-certified 2004, Not renewed since 2007)
 
1981   Association of Professional Engineers, Geologists and Geophysicists of Alberta
Professional Engineer
 

EDUCATION

1981   Master of Science in Civil Engineering
Specialization: Structural Engineering
University of Calgary, Calgary, Alberta, Canada
 
1976   Bachelor of Science in Civil Engineering, With Distinction
University of Calgary, Calgary, Alberta, Canada

PROFESSIONAL AFFILIATIONS

Association of Professional Engineers, Geologists and Geophysicists of Alberta ( A.P.E.G.G.A.)

TECHNICAL

Languages: PL/SQL, SQL
Databases: Oracle, MySQL, SQL Server
Tools: ER Studio, Visio
Models: PPDM, PODS
Methods: UML