top of page

Kennie Nybo Pontoppidan

Schooled as a pure mathematician, I try to live by applying theory to practice in almost every aspect of life. In the recent years, my professional curiosity has been centered around the "Why?" before the "How?"

 

This blog is devoted mainly to the whys. There will be hows too, though.

CONTACT

Write me, email me, tweet me, connect with me

Trepkasgade 4, 2. th

DK-2100 Copenhagen Ø

Denmark

  • LinkedIn Basic Black
  • Twitter Basic Black

Success! Message received.

Contact

CV

Kennie Nybo Pontoppidan

Born in 1972

Lives & works in Copenhagen, Denmark

Skills

 

Databases

Data warehousing

Business Intelligence

Data Science

Product/program management

Scrum

 

Certifications

 

2014 - Microsoft Certified Solutions Expert (MCSE): Data Platform

2013 - Professional Scrum Master (PSM, level 1)

2013 - Professional Scrum Product Owner (PSPO, level 1)

2013 - Certified IPMA level D project manager

2010 - Oracle 9i Certified Professional (OCP) DBA

2008 - Oracle 9i Certified Associate (OCA) PL/SQL Developer

 

Publications

 

2010 - How to build an IT operations Expert, Master thesis

2000 - Spin Geometry and Relativity, Ms. Sc. thesis

Education

 

2006 - 2010 Master in IT Management, ITU, Denmark

2001 - 2002 Computer Science studies, UQ, Australia

1998 - 2000 Ms.Sc, Mathematics, University of Copenhagen, Denmark 

1992 - 1997 Bs.Sc, Mathematics, Physics, University of Copenhagen, Denmark 

Work Experience

2016-now    Senior Program Manager, Microsoft

2015-2016   Engagement Manager, IMS Health

2014-2015   CEO, Effektor

2013-2014   External Associate Professor, ITU

2012-2014   Head of R&D, Rehfeld

2011-2012   Senior BI Consultant, Rehfeld

2008-2011   Database Consultant, Miracle

2005-2008   Head of IT development, ITU

2002-2005   Software Developer, ITU

2000-2001   Software Developer, Vigilante

 

Speaking and teaching

2018 - SQL Konferenz, Copenhagen .net user group

2017 - NAVUG DK, Danish SQL Server User Group, SQL Nexus, TechEd Devcon, SQL Saturday #632, NAV Directions (US and EMEA)

2016 - Danish SQL Server User Group, Data på kanten,  SQLPass Virtual Chapter, SQL Saturday #501, #520, and #541, NAV Directions (US and EMEA), SQL Server Days.

2015 - SQL Saturday #380, #411 and #413
2014 - data:cph meetup, ITU, SQL Saturday #275, #280, #281, #317 and #310, GoBI 2014, IT people DK, VidenDanmark, DIKU
2013 - DIKU, IT-University of Copenhagen, SQL Saturday #226, #228 and #274, Microsoft Campus Days DK, SQL Rally Amsterdam
2012 - Miracle Open World, Swedish SQL Server User Group, Danish Oracle User Group day, ITU
2011 - Danish SQL Server User Group, Danish Oracle User Group day
2010 - Miracle Open World

CV

Talks

In 2009, I decided to take up speaking...

Since then, I have spoken more than 40 times at conferences in Europe and in the States. Here are some of the talks, I have prepared. Please contact me, if you want me to speak at your event.

Expert SQL Server configuration for Dynamics NAV

The performance of a Dynamics NAV installation can be much impacted by the setup and configuration of the SQL Server database storing data. The MSDN documentation of this topic has been improved a lot during the last year, hoping that better database performance will give better response times and therefore also improve end user satisfaction. In this session, I will go into details around installation and configuration of SQL Server with a focus on why different practices are recommended and how these recommendations will help you get an optimized database experience for Dynamics NAV.

SQL Anti Patterns

You can learn SQL in three days but it'll take you 10 years to become good at it. In this session we will have a look at some basic design errors and get a notion of the things that absolutely doesn't work. Antipatterns is a way of naming common design errors in order to make them easier to remember - even if you haven't done them yet. We will become acquainted with antipatterns on a physical level, a logical level and an sql-queries and application level, and spice it up with some seriously foolish errors made by me and my colleagues. The session is relevant for developers and DBAs.

WTF with SQL

SQL is based on the relational  algebra, right? Relational algebra is based on set theory, right? So we would expect SQL to  kind-of respect common sense from set theory. Like A union A has the same number of elements as A. Well, this is not always the case with SQL. 

Come and have fun when we explore scenarios of simple SQL statements, where I guarantee you moments of inner WTF. 

All things time-related

In many data warehouses we model fact tables with measures based on attributes which we can count and do arithmetic upon. It is more difficult to handle fact tables with measures based on length of intervals of events happening in the source systems. So questions like "What are the typical waiting times in our order process?" are seldomly modelled in the data warehouse. Especially if the event data comes from different source systems. In this talk I will show you different techniques and models related to time: process mining, lean, six sigma, process datawarehousing, relational temporal theory and SQL 2016 temporal.

Data Warehouse Architecture Primer

Using a health care case story, we will develop a common data warehouse architecture with staging, Enterprise Data Warehouse (EDW) and datamart layers. We will touch upon concepts and patterns like stage copy/stage history, surrogate/business keys, dimensional modelling, inferred members, data warehouse history types 1/2, datamarts and many more. Concepts/patterns are introduced from problems from the case. The talk has equal focus to the “whys” as well as the “hows” in data warehousing.

Scrum, requirements and product management

The product Effektor was (and still is being) developed using Scrum over sprint more than 80 sprints. During this time, we realized that we needed to have more written practices on requirements and design than just epics and PBI descriptions. Come and hear about how we combined the scrum process with feature descriptions, requirement specifications and design documents – methods that you might connect with more waterfally development practices.

How to build an IT operations expert

My thesis in the Master of IT management program was about the life of IT operations people and how they learn. Specifically I worked on the following three research questions:

  1. What is the difference between a normal IT operations professional and a true expert

  2. How can you make your IT operations professionals better

  3. What can you do to make your experts thrive

Come and hear about my results and how to make your IT operations professionals grow

Ask the CEO - business application infrastructure for your new business

Want to start a new business? You have the great idea, but what about creating a business plan, web site, invoicing, CRM, social media and all the other infrastructure you need to operate that great startup. Come and spend an hour with me and see how we did it with our new company Effektor. Ask all the questions you have. I might even be able to answer them.

Please reload

Talks
bottom of page