PROFILEKim 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. |
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 |
Association of Professional Engineers, Geologists and Geophysicists of Alberta ( A.P.E.G.G.A.) |
Languages: | PL/SQL, SQL | |
Databases: | Oracle, MySQL, SQL Server | |
Tools: | ER Studio, Visio | |
Models: | PPDM, PODS | |
Methods: | UML |