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
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
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:
-
What is the difference between a normal IT operations professional and a true expert
-
How can you make your IT operations professionals better
-
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.