Dean Krog
Curriculum Vitae

 Personal information
Dean Krog E-mail-address: Dean@Krog.dk
Sealand, Denmark Internet: http://www.dean.dk
Nationality: Danish
Marital Status: Cohabiting
Number of children: 2
Year of birth: 1971
Non smoker
! Notice !   -   Online CV stripped of certain personal details and contact information   -   ! Notice !

 Personal profile
I have been involved with IT since the mid 1980s, first at the hobby level and professionally from 1990. I have developed serious applications in many different programming languages and on many different systems. Analysis, design, programming, implementation, operation, project management and support of ERP, datawarehouse, system integrations, websites and more since 1994, this alone, as part of a team or as project manager.

I have a very broad academic profile with expertise in many areas. I am always committed, energetic and proactive with the tasks I undertake. I will therefore typically be an anchor person, usually I am able to cover most technical roles in the projects I'm working on.


I am a very skilled quality conscious, analyst and developer with extensive knowledge and a quickly learner and become productive on new projects and technologies.

I thrive on exciting, complex challenges and are a very skilled problem solver and very skilled within concept development and reverse engineering.


I have in recent years primarily working with database-based solutions, where my functions have been characterized by system integrations and design of complex tools to deal with business-critical situations.

As a consultant, it has been a necessity with a large self-drive, systematic skills and creativity, where the solutions many times have come to think out of the box.

 Education
01.1991 – 06.1993 EDB Assistent, Niels Brock, Copenhagen Business School (IT - Education / Diploma / Bachelor)
08.1989 – 06.1990 EFG Handel og Kontor, Vestegnens handelsskole (Commercial / Office - Technical School / Exams)
08.1988 – 06.1989 10 klasse udvidet, Teglmoseskolen (High school)

 Professional experience
09.2010 - ---> Consultant, Rambøll Informatik (Industry: IT, Field: IT (Software) Role: DataBase Administrator)
Hired as consultant, working with databases, primarily as DBA.

06.2010 - 08.2010 Seinor developer, Spectronic Systems A/S (Industry: IT, Field: IT (Software) Role: Database Specialist)
Developer to databases in Petabyte sizes, here working with Postgresql, perl used to create server/client for testing insert performance. Hereafter created intial CLI interface in both perl and c. Due to not enough work with databases, I quit working here.

04.2010 – 05.2010 Freelance, Compass DataWarehouse A/S (Industry: IT, field: IT (Software) Role: Freelance Data Warehouse Developer)
Developer with ETL in Microsoft SQL environment:
● Development of complex ETL processes in stored procedures to process oriented data
● Documentation
12.1999 – 01.2010
Senior Developer, YouSee (Industry: Other telecommunications activities, field: IT (Software) Role: Specialist)
Analysis, design and development of complex Oracle-related tasks:
● SQL and PL / SQL programming and optimization
● Data Warehouse designed and developed from scratch in SQL and PL / SQL
● Develop Backend functions in PL / SQL systems to web frontend self-service solutions
● Design and review of database and data warehouse architecture
● Self-Development of effective job scheduling system (ASP, HTML, Access, shell programming, SQL, PL / SQL)
● Mentor and teacher of IT, programming and datawarehousing
● Project Management
03.1997 – 11.1999
Systems integrator, DKnet (Industry: Internet, field: IT (Software) Role: Specialist)
● Development and maintenance of complex ERP system (Concorde XAL)
● Development of system integrations between the rest of DKnet's production and ERP system.
● Developing financial security system
● Development of traffic based invoice calculation and archiving of traffic data
● Operational responsibility for TDC Business and DK-Hostmaster's ERP
● Oracle database integrations with DK-Hostmaster
● Webmaster at DKnet website, SCO Unix.
● Internal consultant for TDC Internet's IT department for the development and optimization of ERP
03.1997 - ---> Senior consultant, own company, DKdata (Industry: IT, field: IT (Software) Role: Self-employed)
Own company with just a few hours annually, which provide consulting services to:
● Development of complex ERP solutions in Microsoft Dynamics XAL (old Concorde XAL / Navision XAL)
● Database Programming in Oracle (SQL and PL / SQL)
● DataWarehouse solutions and advice in higher dataloads
● Web-based self-service solutions with the Oracle database as background
● Furthermore, general IT solutions, installation, CMS maintenance, network setup
07.1995 – 02.1997
Chief Programmer, GE Capital IT Solutions (Industry: IT, field: IT (Software) Role: Specialist)
Development of complex financial systems through the use of Concorde XAL and Oracle, to customers who: 
● Denmark teacher associations (Danmarks Læreforening)
● Insurers-Societetet (Assurandør-Societetet)
● Danish Industries (Dansk Industri, Here also worked as an Oracle support) 
Stationed in Lithuania to educate in the programming of major financial systems and performance tuning.
During the development of ERP systems, I developed strategies for programming ethics and rules for documenting, and introduced a way of "object oriented" approach to development in macro language, this ensured that many of the programs could be reused among many clients and not only for the individual client, as normal was.
10.1994 – 06.1995 IT Consultant, Bolt & Rønberg ApS (Industry: IT, field: IT (Software) Role: Specialist)
Development of Concorde XAL ERP systems, and worked as an Oracle support / fire extinguisher, then headhunted for GE Capital IT Solutions.
05.1994 – 06.1994 Consultant, Herstedøster kirkegård (Industry: Religious institutions and associations, field: IT (Software) Role: Consultant)
Functioned as an independent consultant
● Setting up of IT equipment, including installation, network with more
● Training in the use of IT and computer tools
08.1990 – 01.1991 Computer-assistant, Vestegnens Kraftvarmeselskab I/S (Industry: Heat supply, field: IT (Software) Role: Employee)
Building critical business registration system and responsible for business-sensitive data

 Courses / Certifications
20.02.2006 - 20.02.2006 New SQL features i 10g, Oracle Denmark
28.07.2003 - 30.07.2003 Oracle 9i:Develop PL/SQL Program Units, Oracle Denmark
14.07.2003 - 15.07.2003 Oracle 9i:PL/SQL Fundamentals, Oracle Denmark
10.06.2003 - 13.06.2003 Oracle 9i: SQL Basics, Oracle Denmark
19.02.2001 - 21.02.2001 SAS Programming, SAS Denmark
01.03.1997 - 01.03.1997 DBA, Oracle version 7, Oracle Denmark
01.12.1995 - 01.12.1995 Oracle DBA on XAL Oracle, Damgaard Data
● Concorde (Navision), XAL, Oracle DBA at XAL Oracle
01.10.1995 - 01.10.1995 Retailer steps 1-3, Damgaard Data
● Concorde (Navision), XAL, stage I-III

 Language
Danish Oral: Native Written: Native
English Oral: Very good Written: Very good

 Competencies
Category Competence Years experience Last used Level
Workspace User Interface Development 16 2010 Expert
Workspace Business Intelligence 10 2010 Expert
Workspace Data Integration 16 2010 Expert
Workspace Data Warehouse 10 2010 Expert
Workspace Database Design 16 2010 Expert
Workspace Data Conversion 16 2010 Expert
Workspace DBA (Database Administrator) 16 2010 Good knowledge
Workspace Internet 14 2010 Expert
Workspace Intranet 13 2010 Expert
Workspace Requirements specification 16 2010 Very experienced
Workspace Network Settings 16 2010 Very experienced
Workspace ERP 16 2010 Very experienced
Workspace Performance optimization 16 2010 Expert
Workspace Performance Tuning 16 2010 Expert
Workspace Personnel Management 9 2010 Very experienced
Workspace Programming 26 2010 Expert
Workspace System Integration 16 2010 Expert
Workspace System Design 16 2010 Expert
Workspace Systems Development 16 2010 Expert
Workspace Telecommunications 8 2010 Expert
Workspace Web Development 13 2010 Very experienced
Workspace 2nd level support 16 2010 Expert
Language Concorde XAL 16 2010 Expert
Language HTML 13 2010 Expert
Language JavaScript 12 2010 Good knowledge
Language Perl Script 13 2010 Good knowledge
Language PL/SQL 16 2010 Expert
Language SAS 1 2002 Good knowledge
Language SQL 16 2010 Expert
Language Unix Shell 13 2010 Very experienced
Technologies ASP (Active Server Pages) 11 2010 Very experienced
Platforms C64 10 1996 Expert
Platforms HP-UNIX 6 2010 Very experienced
Platforms Linux 3 2010 Good knowledge
Platforms UNIX 13 2010 Very experienced
Platforms Windows 20 2010 Expert
Databases Oracle 16 2010 Expert
Developertools Microsoft Access 6 2010 Rutineret
Developertools Oracle SQL Loader 10 2010 Expert
Methods Structured Programming 23 2010 Expert
Business and office support applications Damgaard XAL 16 2010 Expert

 References
David Tykskov IT Consultant, David Tykskov IT-konsulent.
Ulla Stenstrøm Accountant, Nyborg Friskole
Thai Dinh Pham Systemdeveloper, YouSee A/S
Tom David Lindved IT-Specialist, YouSee A/S

Dean Krog
Project Experience


Here listed selected experiences from YouSee, while those responsible for and development / maintenance / tuning / operation of YouSee's DataWarehouse.

 Project Experience 1, YouSee, DataWarehouse
Period: 2001/01 - 2009/08
Project description: Data Warehouse in PL / SQL and SQL with integrations and handling of large scaled data volumes.
 
Developer and designer of YouSee's Data Warehouse, with ongoing major tasks.
 
● Design and development of table structure.
● Design of system structure and data flow.
● Development of PL / SQL and SQL scripts.
● Development of business logic in PL / SQL and SQL scripts.
● Accrual of millions of invoice lines on a daily basis with variable values.
● Treatment of millions of traffic data records daily reporting.
● Release, operation and monitoring / performance tuning.
● Cloning between production, test and development environments by exp and imp.
Technologies used: PL/SQL, SQL, SQLLDR, Shell Script, ASP, HTML, sendmail.
My role in the project: System Development, System Design, Systems Analysis, Database Design, Operation, Project Management.
Contact: Thai Dinh Pham, Systemdeveloper, YouSee A/S
Tom David Lindved, IT-Specialist, YouSee A/S

 Project Experience 2, YouSee, job scheduling system
Period: 2002/01 - 2009/08
Project description: On its own initiative, designed, developed and maintained effectively jobscheduleringssystem to Oracle Data Warehouse, here achieved performance tuning of over 80% and the chance to see logs, scripts, execution plans, driving times, with more back to the beginning.
 
● Design and development of table structure.
● Design of system structure and data flow.
● Designing interfaces for database and web-based interface.
● Design and development of GUI using HTML, JavaScript and ASP.
● Development of the Access database with ODBC access to Oracle database tables.
● Development of AIX / UNIX and HP-UNIX Shell scripts.
● Development of PL / SQL and SQL scripts.
● Development of mailing follow-up jobs.
● Release, operation and monitoring / performance tuning.
Technologies used: PL/SQL, SQL, ASP, HTML, Access, shell-programming, Unix and HP-Unix, sendmail.
My role in the project: System Development, System Design, Systems Analysis, Database Design, Operation, Project Management.
Contact: Thai Dinh Pham, Systemdeveloper, YouSee A/S
Tom David Lindved, IT-Specialist, YouSee A/S

 Project Experience 3, YouSee, address update
Period: 2009/01 - 2009/08
Project description: Update 3 million addresses from 1998 to July 2009 version, this effect through all address changes made in the municipal reform.
Design and development of complex systems for automation of address update from optional system of addresses from Geomatic (CPR Enriched with more address data).
 
● Responsible for the quality of address data.
● Development of complex tools for general updating of addresses.
● Development of system-specific update addresses.
Technologies used: PL/SQL, SQL, SQLLDR
My role in the project: System Development, System Design, Systems Analysis, Database Design, Operation.
Contact: Thai Dinh Pham, Systemdeveloper, YouSee A/S
Tom David Lindved, IT-Specialist, YouSee A/S

 Project Experience 4, YouSee, data integrity
Period: 2008/09 - 2008/12
Project description: Ensuring data integrity, so that multiple systems can be managed through a common system where if the data changed, or should be in other systems should be possible.
 
● Responsible for the quality of data.
● Design of data flow.
● Requirements for stored procedures.
● Developing PL / SQL stored procedures.
● Development of the triggers to work with stored procedures.
● Release, operation and monitoring.
Technologies used: PL/SQL, SQL, ASP, HP-Unix shell scripts.
My role in the project: Project manager, System Design, Systemarkitetkt, System, Operation.
Contact: Thai Dinh Pham, Systemdeveloper, YouSee A/S
Tom David Lindved, IT-Specialist, YouSee A/S

 Project Experience 5, YouSee, backend PL / SQL to dealer systems
Period: 2008/01 - 2008/03
Project description: Development of PL / SQL stored procedures to the backend systems to dealer systems.
 
● Requirements for stored procedures developed in collaboration with java people.
● Design of the structure and interfaces for PL / SQL stored procedures and Java scripts.
● Developing PL / SQL stored procedures
● Release and maintaining the PL / SQL stored procedures
Technologies used: PL/SQL, ASP
My role in the project: System design, System development, operation.
Contact: Thai Dinh Pham, Systemdeveloper, YouSee A/S
Tom David Lindved, IT-Specialist, YouSee A/S


 Project Experience 6, YouSee, backend PL / SQL for self-service solutions
Period: 2007/08 - 2007/12
Project description: Development of PL / SQL stored procedures to the backend of self-service solutions.
 
● Requirements for stored procedures developed in collaboration with java people.
● Design of the structure and interfaces for PL / SQL stored procedures and Java scripts.
● Developing PL / SQL stored procedures
● Release and maintaining the PL / SQL stored procedures
Technologies used: PL/SQL, ASP
My role in the project: System Design, Systems, Operations.
Contact: Thai Dinh Pham, Systemdeveloper, YouSee A/S
Tom David Lindved, IT-Specialist, YouSee A/S

 Project Experience 7, YouSee, customer data transfer
Period: 2007/01 - 2007/06
Project description: Development of complex tools for verification / cleaning, separation and deployment of customer data in the production system. This to meet the business needs to quickly, efficiently and with quality data to load the purchased Antenna associateions data and the like. into the system, either at known addresses, or newly created addresses.
 
● Design and development of table structures
● Ensuring flexibility to different data sources without general program changes.
● Documenting execution plan.
● Reporting at each step in CSV format.
Technologies used: PL/SQL, SQL, SQLLDR
My role in the project: Project manager, System Design, Systems, Operations.
Contact: Thai Dinh Pham, Systemdeveloper, YouSee A/S
Tom David Lindved, IT-Specialist, YouSee A/S

 Project Experience 8, YouSee, address key system
Period: 2006/06 - 2006/12
Project description: Development of mission-critical system for authentication / pairing of addresses, this mod Geomatic (CPR Enriched with more data) and the rest of YouSee's systems.
 
The gain was a key system where one with an address lookup could see account numbers from the different systems, a transparency not previously available.
 
● Design and development of table structures
● Design of data flow.
● Ensuring flexibility for different data sources without general program changes.
● Documenting execution plan.
● Quality Selection at address level.
Technologies used: PL/SQL, SQL, SQLLDR
My role in the project: Project manager, System Design, System Architect, Systems, Operations.
Contact: Thai Dinh Pham, Systemdeveloper, YouSee A/S
Tom David Lindved, IT-Specialist, YouSee A/S
Comments