Pro DBA Ms Sql Server, SSIS Specialist
Name: Martin Hollander.
Nationality: Dane.
Date of birth: 1959-08-09
Martial status. Relationship.
Contact: Hollander.private@gmail.com
(I'll provide phone number).
IT Consultant with focus on DBA and DBA related activities. Expert skills on Microsoft Sql Server, SSIS and database administration in general. Experience as Enterprise architect and solutions based on Microsoft technology, especially in combination with products from other vendors.
Focus on configuration and administration of 24/7 mission critical solutions, performance and maintenance.
Team player, fast paced, and persistent with close attention to detail. Advocate for, but in no way limited to agile methods. Prefer ‘best practices’, creativeness and letting the job point out the right method. Dedicated at getting things done, and done correctly, - and, at documenting new knowledge in a way that is beneficial for the team.
Experience as software engineer (around 20 years using a variety of languages), but rather collaborate with developers than try doing their job.
Professional experience
2004-2009. DBA, System administrator & Chief Enterprise Architect, DmPartner, Copenhagen, Denmark.
The Company focuses on Data management, Data Quality and Direct Marketing for larger enterprises in Scandinavia.
DBA, System Administrator, Data Manager, Enterprise and Solution architect, senior software engineer.
Large ETL solutions based upon DTS, SSIS, TSql and .Net
• Orchestrating, Implementation and administration of huge mission critical databases involving data from other database mergers. Eg. OIS, a database containing facts about all real estate and every building in Denmark combined with data extracted from Central Personal Registration (CPR), combined with Statistics from DS, (official Danish Statistics), combined with …
• Architect and technical specialist on BI-solutions, data integration and .net development.
• Trainee on Ms Sql Server Best Practices, SSIS and .Net.
2004 (3 month). ETL & Data Management consultant, Microsoft, DK.
Data management, replication and performance tuning on Customer and License database, based in Dublin, Ireland.
2001 (5 month). Consultant and Software engineer with focus on ETL programming, WWF, Helsingborg, Sweden.
Consultant and Software engineer on The World Wildlife Foundation database hosted in Küngsbacke, Sweden. 5 month, acting as Consultant, Software engineer and Dts-developer on major migration project for WWF, based in Helsingborg, Sweden.
2000-2004 DBA, Architect, senior developer at Scandirect, Copenhagen, Denmark.
Scandirect was a marketing company focused on CRM and loyalty management.
My largest contribution was (apart from some HTML and Asp), development of www.biozonen.dk. The largest member site in Denmark.
• Development of all databases and related programming. Sql Server 2000, VB6
• DBA, WA on the same site.
• Software engineer with focus on development of data management and data quality solutions.
Other responsibilities:
• System Administrator.
• Trainee and supporter in every aspect related to IT.
1998-1999 (8 month), Software engineer at Microsoft, Redmond.
• Codename: Shiloh.
1998-1998 (6 month), Software engineer, Den Danske Bank, Høje Tåstrup, Denmark.
Project initiated by a merger of three major banks in Denmark. Each bank had their own system, thus forced to develop a new platform and the necessary transformation services.
Modeling and development of a new common platform (OS2 and UNIX), doing C++ and DB2.
1994-1998 Private Enterprise, Copenhagen, Denmark
Funder, Managing director and co-developer in Software Company called ParteILCoure, based in Copenhagen, Denmark.
The company made one single product, aimed at the prediction of industrial injuries. County Councils, municipalities, and major public workplaces in Denmark from 1995 until around 2002 used the product.
The product was mainly developed in Lisp, Prolog, VB, and VBA in a 3-4 tier configuration, using MsAccess on the client side, Ms Sql Server 6.5 on server; and taking advantage of the MsGraph.Api and the reporting facilities in MsAccess.
1987-1991 Ingénieur spécialisé dans les communications par satellite.
Engineer at Société Nationale d'Industrie Aérospatiale. Satellite communication and radar technology. Based in Paris and Toulouse, France.
• Engineering related to the French word for “flying fishes”.
Education
Msc. with Qualification Profile in Software Development, RUC, Denmark 1991-1994 (never finished, due to a very promising job offer, but studied for 4 years, probably equal to a bachelor degree + some more).
Msc.E.E. 1982-1987, DTH, Denmark
Languages
English (oral and written).
Danish (Being native Dane, presumably spoken with an outrageous accent).
Competence scheme
Competence Level Experience (Years)Last used
DB2 Intermediate 2 1998
Lotus Notes 3.2 Good knowledge 1 1994
Ms Access Expert 16 2009
Ms SqlServer (6...2008) Developing Expert 13 2009
Ms SqlServer (6...2008) DTS Expert 8 2009
Ms SqlServer (6...2008) Modeling Expert 13 2009
Ms SqlServer (6...2008) Tuning Expert 12 2009
Ms SqlServer (6...2008) CLR Advanced 4 2009
Ms SqlServer (6...2008) MDX Good knowledge 2 2007
Ms SqlServer (6...2008) TSql Expert 13 2009
Ms SqlServer (6...2008) UDF Advanced 8 2009
Ms SqlServer (6...2008) Replication Good knowledge 11 2009
Ms SqlServer (6...2008) SSAS Good knowledge 1 2008
Ms SqlServer (6...2008) SSIS Expert 4 2009
Ms SqlServer (6...2008) SSRS Good knowledge 1 2009
Ms SqlServer (6...2008) Administration Advanced 13 2009
Ms SqlServer (6...2008) Native Client Good knowledge 1 2006
Ms SqlServer (6...2008) Configuration Advanced 13 2009
Sql Azure Premature 0 2009
Oracle Intermediate 2 2002
Sybase Good knowledge 4 2004
ADO.NET Good knowledge 3 2009
ASP Advanced 4 2004
BPML Good knowledge 1 2008
C# Good knowledge 3 2008
C++ (Borland) Good knowledge 5 2004
Java Intermediate 0,75 2003
Lisp Intermediate 1 2002
Objective C Intermediate 1 1998
PowerBuilder Intermediate 4 2003
Prolog Good knowledge 2 2001
VB.Net Advanced 8 2009
VB5 Good knowledge 1 1998
VB6 Good knowledge 4 2004
VBA Expert 16 2009
XLST Good knowledge 2 2009
XML Good knowledge 2 2009
Data Management Expert 14 2009
Data Warehousing Good knowledge 3 2007
Master Data Advanced 9 2009
Metadata Advanced 15 2008
Methodology Advanced 14 2008
VMware Intermediate 4 2009
OS2 Good knowledge 2 2000
Linux Intermediate 0,5 2001
Unix Intermediate 2 1999
Windows Advanced 16 2009
MS Graph Expert 7 2002
ITIL Intermediate 0,5 2006
Interpersonal skills I laugh a lot 35 2009
Leadership Good knowledge 7 2008
Project Managing Good knowledge 6 2008
Resource planning Good knowledge 6 2009
Project experience
Customer: Dmpartner
Period/Location: 2008 Nov. – 2009 Jan. Copenhagen, Denmark
Description: User application. Userinterfaces on top of SSIS.
A common problem using SSIS, is the UI. For a non-programmer, just to run a package, tends to be a bit complicated.
The project aimed at creating a layer/interface between the Dtsruntime namespace and Winforms allowing a developer to easyly build WinForms applications, interacting with any given SSIS-package.
Responsibility: Project managing, Release and Test manager.
Technology: SSIS, .Net, UML2.0, Sql 2008 Beta
Method: SCRUM
Role: Software engineer. The project was not completed due to lack of resources.
Customer. Dmpartner
Period/Location: 2008 Nov. – 2009 Jan. Copenhagen, Denmark
Description: AdressDenmark. A Database aimed at being able to deliver all kinds of information related to any given address in Denmark. Eg. Number of kids, parents age, household income, type of neighbors ... and a lot more.
Responsibility: Project managing, Release and Test manager.
Technology: SSIS, SSRS, SSAS, SqlServer 2005, .Net, UML2.0. Replication Services.
Method: SCRUM
Role: Database designer, developer and administrator. ETL designer.
Customer: Insurance company in Denmark
Period/Location: 2008 March – 2008 June. Copenhagen, Denmark
Description: A major ETL system that creates a specialized weekly update to the customer, based on the data established by the ABC project.
Responsibility: Project managing, Release and Test manager. Design of all SSIS packages. Design of major recovery facilities.
Technology: SSIS, SSRS, SSAS, SqlServer 2005, .Net, UML2.0, WMWare, Replication Services
Method: RUP
Role: System designer, ETL-developer.
Customer. Dmpartner.
Period/Location: 2006 - 2007. Copenhagen, Denmark
Description: Implementation of the ABC databases and SSIS packages into production bases and DW’s, all maintainence, administration and recovery included. Creation of SSIS package template-libraries (Why doesn’t Microsoft support it ?). Creation of 300+ SSIS packages, the first 100 from scratch, before the templates emerged.
Responsibility: Project managing, Release and Test manager.
Technology: SSIS, SqlServer 2005, vb.net, win2003, UML2.0, XML, XLST, VMWare, Notification Services, Replication Services.
Method: Agile.
Role: Database designer, developer and administrator. ETL designer.
Customer. Dmpartner.
Period/Location: 2005 May, Copenhagen, Denmark
Description: Migration from one live production database to another.
Problem was to load around 140 gb production data to a new database, without “hurting” the production server.
Responsibility: Software engineer and probably being the only one who would dared do it.
Technology: SSIS
Method: Planning, test, planning, test…
Role: ETL solution architect, ETL-programmer.
Customer: Dmpartner.
Period/Location: 2005 Jan. – 2005 April, Copenhagen, Denmark.
Description: ABC, - Configuration, Designing, implementing and documenting the databases and DW’s.
Responsibility: Enterprise Architect. System developer.
Technology: Sql Server 2005 Beta, UML.
Method: Not totally aware, just did it
Role: System and database designer. Test & Release manager.
Customer: Dmpartner.
Period/Location: 2004 May – 2004 Dec. Copenhagen, Denmark.
Description: ABC. The ABC project was a database centered solution, merging a huge amount of data from various “official” databases in Denmark.
Among sources: Statistics Denmark (The official Denmark put to numbers), Ois (all facts about real estate and buildings), CPR (Central Personal Register, information about all Danes since 1924), KMS (All topographic data), Data from all major telephone companies and more, both white and yellow pages… and much more. Extremely mission critical and involving a huge monitoring system.
Purpose: Establishing one weekly version of the truth, or lets say: Master Data Denmark.
Responsibility Enterprise Architect. DBA.
Technology: Paper and pencil, Microsoft Visio, Sparx EA and some part of the brain. Win2003, Linux, Oracle, MsSqlserver 2000, VMWare, UML, BPML...
Method: RUP, XP, ITIL and Coffee.
Role: Do it.
Customer: Dmpartner.
Period/Location: 2004 April – 2004 Oct. Copenhagen, Denmark.
Description: Know everything ASAP.
Responsibility: DBA, Software engineer, coach.
Technology: SqlServer 2000, TSQL, DTS, .Net, VBA, UML.
Method: Long working hours.
Role: Design and implementation of recovery functionality, documentation and everything else a DBA does, arriving at a new company.
System administrator, Software engineer.
Coaching on Ms Sql Server Best practices.
Customer: Microsoft.
Period/Location: 2004 Feb. – 2004 April, Dublin, Ireland.
Description: Data quality management on Microsoft Customer & License database.
Responsibility: Software engineer.
Technology: SqlServer 2000, TSQL, DTS.
Method: Solving one problem at a time.
Role: Database programmer.
Customer: Nordisk film and Scandirect.
Period/Location: 2001-2004. Based primarily in Copenhagen, Denmark.
Description: Make the website biozonen.dk run 24/7 and then teach us how to do it.
Responsibility: YES!!
Technology: SqlServer 2000, SqlProfiler, vb6, vb.net, Java.
Method: Awareness, Awareness, Awareness and some SCRUM
Role: DBA, System administrator, trainee, supporter…
Customer. Orkla Media.
Period/Location: 2001 April – 2001 Sep., based in Küngsbacke and Helsingborg, Sweden.
Description: Migration from three database designs and manufactures into one database. Database owned by World Wildlife Foundation. The original database was in fact three databases running on two different platforms. A SqlServer running on NT3.5 and an Oracle and DB2 running on Linux.
Responsibility: Consultant.
Technology: Db2, Oracle, Sqlserver2000, DTS, VB6, Linux, WinNT, Win2000.
Method: Paper, coffee and get things done. Waterfall (Right method but wrong conditions)
Role: Software engineer with primary focus on DTS-development.
Customer: Nordisk film.
Period/Location: 2000 Dec. – 2001 April, Copenhagen, Denmark.
Description: Biozonen. A member website initiated and later owned by Nordisk Film. To this date probably the largest member site in Scandinavia. The underlying program facilitated, at that time, some unseen profiling algorithms extending the capabilities offered by Sql2000, and making the website a “state of the art” in terms of sheer speed and responsiveness.
Responsibility: DBA, System administrator, System Architect, Software engineer.
Technology: Sqlserver2000, DTS, VB6, VBA, MsAccess, Java, ASP and more.
Method: Waterfall for some parts, Agile (Scrum) for others.
Role: Apart from graphics, some Html and Asp, developed entirely by yours sincerely.
Customer: British Tourist Council in Denmark.
Period/Location: 2000 Jan., Copenhagen, Denmark.
Description: Database application used to store larger questionnaires, and create some intelligent graphs and reporting facilities.
Responsibility: Project manager, Software engineer.
Technology: VBA, MsAccess.
Method: Waterfall.
Role: Software engineer.
Customer: Scandirect.
Period/Location: 1999-2004, Copenhagen, Denmark
Description: Numerous data management and data quality applications, mostly done using MsAccess, SqlServer and Powerbuilder (Sybase).
Responsibility: DBA, Software engineer.
Technology: Sybase, VBA, MsAccess.
Method: Whatever it takes.
Role: Software engineer.
Customer: Microsoft.
Period/Location: 1998 May -1999 Feb., Redmond, WA US.
Description: Implementation of some of the DTS features on the forthcoming Ms Sql Server 2000, and some on MsAccess.
Responsibility: None.
Technology: C++, VBA.
Method: None really, more like “find a solution, - quick”.
Role: Software engineer, Architecture.
Customer. Den Danske Bank
Period/Location: 1998 Jan. – 1998 April, Høje Tåstrup, Denmark.
Description: Data transformation services between three old banking systems and a new one, all being developed simultaneously.
Responsibility: None
Technology. C++, Unix, Os2, Db2, Oracle, AS400.
Method: Rational (RUP) and “Get things done”.
Role: Software engineer, Architecture.
Customer. County Councils in Denmark.
Period/Location: 1996-1998, Denmark.
Description: Consultant.
Responsibility: Management.
Technology: MsSql 7.0., MsAccess, VBA
Method: A Mix of RUP and Participatory Design.
Role: Working CEO, project manager, Co-developer.
Customer: County Council of Vest Zeeland.
Period/Location: 1994-1996, Copenhagen, Denmark.
Description: User interfaces. A project involving anthropologists, office workers and other stakeholders.
Responsibility: Management.
Technology: DAO, ODBC, ADO, VBA, C++, vb4.0, TSql, HTML.
Method: Participatory Design, Field studies.
Role: Project manager, Software engineer, Architecture.
Customer: County Council of Vest Zeeland.
Period/Location: 1994-1996, Copenhagen, Denmark.
Description: DW modeling and implementation of a star-topology on a Ms Sql Server 6.5.
Responsibility: Management, Database developer.
Technology: Ms Sql Server 6.5, Sybase Adaptive Server 11.0, MsAccess95, TSql, C++.
Method: Paper and pencils.
Role: Database designer. Test & release manager.
Customer: County Council of Vest Zeeland.
Period/Location: 1995-1996, Copenhagen, Denmark.
Description: Creating of a series of API, using a functional language, to control the msgraph.api and the reporting facilities in MsAccess.
Responsibility: Management.
Technology: Prolog, Lisp, C, Objective C, C++, MsGraph.
Method: Brainstorming, trial and error, coffee.
Role: Project manager. Test & release manager. Software engineer.
Customer: County Council of Vest Zeeland.
Period/Location: 1994-1996, Copenhagen, Denmark.
Description: Project Foundation. The Council ordered a system that would enable the council to predict work related incidents, and establish the necessary means preventing the very same. It was the first attempt in Denmark to create a combined ESDH & BI solution in one single system, on a Microsoft platform.
Responsibility: Management.
Technology: Ms Sql Server 6.0, MsAccess, TSql, Word.
Method: Paper, Tape Recorder, interviews and a lot of brainstorming.
Role: Project manager, System architect.
Customer: Deloitte & Touche
Period/Location: 1994 Feb. – 1994 June, Copenhagen, Denmark.
Description: An investigation into the possibilities of using Lotus Notes 3.2 as an ESDH system on a corporate level.
Responsibility: Consultant and Software designer.
Technology: Lotus Notes 3.2
Method: Interviews, programming, mock ups.
Role: Consultant and Software designer.
Courses and Certification
Member of EaCommunity.com 2005-2007
Developing High-Performance SQL Server 2003
Agile Programming: Principles and Practices 2003
Advanced Sql Server Administration (useless) 2002
Gender: Male
Year of birth: 1959
Working hours: Full time, part time and freelance.
Job seeker would like to work in the following countries: All countries in Europe.
The resume was last changed: April 05, 2010.
