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
|
|
|