Microsoft DB- & BI-Specialist

Erdöl BIRAMEN +41-77-462-**-** ****@*******.*** www.biramen.com Page 1 of 20

Erdöl BIRAMEN

About me: born in 1968, Austrian, single, 1 child, living in Suhr/AG in CH Languages: Language Level (http://www.europaeischer-referenzrahmen.de/) Turkish mother-tongue

German C2

English C2

Russian C1

Slovak A2

Highest education: Business Administration at the University of Economics in Vienna Majors: Informatics, Finance & Financial Markets and Statistics Academic title: Mag.rer.soc.oec.

Diploma, Thesis (Web Services)

Work authorizations: EU (passport), Switzerland (C-permit), Turkey (blue card) Competencies

Experience in: MS SQL (Architecture, Development, Administration, Support, Upgrades & Migration, Performance Tuning, Training) MS BI & DWH (Architecture, Development, Administration) Application- & Systems Integration

Data-Migration

Office Automation, VBA- Development

Soft-skills: structured way of working, methodical approach independent yet capable of working as part of a team eager to learn new things

creative, imaginative, able to improvise

analytical and connected thinking

written & spoken language competency, persuasive style Focus: MSSQL (TSQL, SSIS, SSAS, SSRS, MDS, DQS),

MDX, DAX, Power Query, PowerPivot, Power BI

MS Access, MS Excel, VBA, XML, UML

Other skills: C#, VB.Net, PowerShell, UML, OOAD, SharePoint System Center (SCOM, SCCM, SCVMM), Hyper-V

Certifications: MCSE – Data Platform (MS SQL 2012) MCSE – Business Intelligence (MS SQL 2012)

MCITP – DBA (MS SQL 2008)

MCITP – Business Intelligence (MS SQL 2008)

MCTS – SCCM 2012

MCTS – SharePoint 2007

MCSD.NET, XML / XSLT, UML / OOAD …

Page 2 of 20

PROJECTS / ROLES / EXPERIENCES: (newest on top)

Year Industry Company Location Main Role Main Products & Technologies used 2020 Telecommunication QuickLine Biel/CH Senior DB- & Application Developer MSSQL .Net EF VS TFS FireDaemon PRTG PowerShell 2018 Government OIZ Zurich/CH Senior DB- & Application Developer MSSQL .Net EF VS Git TFS 2017 Insurance SwissLife Asset Mgmt. Zurich/CH DWH & Microsoft BI Developer MSSQL MDS SSRS SSIS SSAS VS Excel VBA SimCorp Jira Bitbucket

2016 Business Consulting PlanPros Kharkov/UA Office Automation/DB- & Reports Developer MSSQL/SharePoint/Excel/Word/VBA/C#/PowerBI 2015-16 Energy Varo Energy Zug/Cham, ZG Microsoft BI Developer/Excel Developer MSSQL SSIS BIDS Helper VS C# Excel VBA Access 2015 E-Commerce PC-OstSchweiz / Steg Remote, SH, LU Data migration / ETL-Specialist MSSQL SSIS BIDS Helper VS 2015 C# 2014 IT PlanPros Remote Reports Developer / BI-Developer SharePoint MSSQL SSRS SSAS Excel VS 2015 C# 2014 Insurance SwissRe Zurich / CH Microsoft BI-Architect MSSQL 2014 SSAS SSIS SSRS SharePoint 2013 2014 IT Xerox Zurich / CH Developer/DBA/Performance Tuning Expert MSSQL Windows Server VMware vSphere Client 2013 Energy ALSTOM Power AG Baden / CH BI-Developer / .Net Developer MSSQL SSIS SSAS SSRS Sharepoint Excel VB.Net 2010-12 Energy ALSTOM Power AG Baden / CH DBA/Architect & System Center Engineer MSSQL System Center SCOM SCCM 2011-12 Investment Banking Vontobel AG Zurich / CH BI-Developer SQL2K5 SSIS BIDS 2005 2010 IT ASSIST (SK) s.r.o. Bratislava BI-Developer & .NET Developer .NET SQL2K8 SSIS SSAS SSRS IIS TFS 2010 IT ASSIST (SK) s.r.o. Bratislava Developer/DBA & Systems Engineer SQL Server SSIS SSRS W2K8 IIS C# 2009 IT ASSIST (SK) s.r.o. Bratislava Systems Engineer Win2K8 R2, Hyper-V, iSCSI 2009 Telco T-COM Kiel BI-Developer / DBA SQL Server SSIS SSAS SSRS IIS C# VB 2008 Investment Banking DWS Fund Luxembourg DBA & ETL-Developer SQL Server SSIS SSAS SSRS 2007-08 Banking HELABA Offenbach DB- & ETL-Developer SQL Server SSRS DTS VB 2007 IT ASSIST (SK) s.r.o. Bratislava DB-Developer / Web Developer SQL Server ASP.Net C# 2007 IT ASSIST (SK) s.r.o. Bratislava VBA Developer Excel VB.Net 2007 IT ASSIST (SK) s.r.o. Bratislava Web Developer XML HTML CSS JavaScript ASP.Net 2007 IT ASSIST (SK) s.r.o. Bratislava Web Developer XML HTML CSS JavaScript AJAX 2006 IT Hewlett Packard Dublin DB-Support Engineer (2nd Level) SQL Server SSIS SSAS SSRS 2006 IT ASSIST (SK) s.r.o. Bratislava Web Developer XML HTML CSS JavaScript ASP.Net 2005 Investment Banking DRKW Frankfurt BI-Developer SQL Server SSAS SSRS ASP.Net VB.Net 2004 IT / Governmental Getronics Brussels .NET Developer DBA SQL Server ASP.Net C# 2002-04 Consulting Dimaro Vienna .NET Developer .NET C# VB.Net 2001-02 IT Hewlett Packard Grenoble BI-Developer SQL Server SSIS SSAS Excel VBA 2000-01 Online games PlusLotto/ZABADOO Eschen Web Developer ASP VB SQL Server Development 2000 Telecommunications Primus PTI GmbH. Munich VB Developer VB SQL Server 1999-00 Internet retailer Global New Media Munich DBA / DB Developer SQL Server Replication Load Balancing

<1999 Consulting Trust Consult Vienna DB-Developer / VB-Developer SQL Server Access VB 1999-00 Asset Management AVBG GmbH Vienna DB-Developer / VBA-Developer Access VBA 1998-99 Property Management ERSTE Bank Vienna DB-Developer / VBA-Developer Access VBA 1997-98 Training & Education Various CTECS Austria Trainer SQL Server IIS VB Access Excel 1994-97 Pharmaceutical Baxter Inc./Immuno Vienna DB-Developer / VBA-Developer Access VBA Word VBA 1996-97 Training & Education ACP GmbH Vienna Trainer Access VBA Excel VBA 1992-95 Banking ERSTE Bank Vienna DB-Developer / VBA-Developer Access VBA Excel VBA Page 3 of 20

Page 4 of 20

WORK HISTORY (latest roles first)

Overview

My professional career so far consists of the following major phases: 01/92 - 12/93 Ms Access & Ms Excel VBA Developer

01/93 - 12/97 Contact-based Ms Access/SQL Server/VB Developer + MS Office and VB Trainer 01/98 - 09/99 Certification exams

04/99 - 09/99 MCT for various CTEC’s in Austria and Germany 09/99 - now Contracting

POSITION: Senior DB- & Application Developer / Supporter / Performance Tuning Specialist

TYPE: Contract

FOR: Coopers

CLIENT: QuickLine

LOCATION: Biel/CH - remote

FROM: 01/2020

TO:

DUTIES:

Finding and fixing bugs

Performance Tuning of .Net code and T-SQL queries and stored procedures

Index tuning

Writing queries for monitoring data quality issues and creating PRTG sensors

Writing queries for automatic data correction

Administrating the jobs scheduling system based on SQL Agent and FireDaemon Products & technologies used:

MSSQL

.Net

EF

VS

TFS

SentryOne Plan Explorer

Idera QueryStore Optimizer

Idera StaticticsAggregator

sp_BlitzIndex

POSITION: Senior DB- & Application Developer / Supporter / Performance Tuning Specialist

TYPE: Contract

FOR: BBV

CLIENT: OIZ – Organization Informatics Zurich

LOCATION: Zurich/CH - remote

FROM: 01/2018

TO:

DUTIES:

Finding and fixing bugs in .NET-based applications and MSSQL-based databases

Performance Tuning of .Net code and T-SQL queries and stored procedures

Index tuning

Automating repetitive business-related tasks

Automating repetitive technical tasks (creating monitoring and troubleshooting scripts) Page 5 of 20

Introduction of SPLUNK for monitoring and alerting based on log-mining

Implementing integration & migration projects

Replacing direct data-exchange via Linked Server through indirect data-exchange via SSIS consuming Web Services and files

Products & technologies used:

MSSQL

.Net

EF

VS

Git

TFS

SOAPUI

SPLUNK

SentryOne Plan Explorer

Idera QueryStore Optimizer

Idera StaticticsAggregator

sp_BlitzIndex

POSITION: DWH & Microsoft BI Developer

TYPE: Contract

FOR: HAYS

CLIENT: Swiss Life Asset Management

LOCATION: Zurich/CH

FROM: 01/2017

TO: 06/2017

DUTIES:

Creating SSRS reports and the supporting DB objects (tables, views, SPs, UDFs)

Bringing in proposals to improve the data model, the development environment & processes as well as coding practices

Bug-fixing of an internally developer query tool for self-service BI

DB performance tuning of long running queries

Products & technologies used:

MSSQL, MDS, SSRS, SSAS, SSIS

Visual Studio 2015 with Git Integration

Excel incl. VBA

SourceTree

SimCorp

Atlassian JIRA, Bitbucket, Bamboo, Confluence

POSITION: Office & Workflow Automation, DB-, SharePoint-, and Power BI Development TYPE: Contract

FOR: Direct client

CLIENT: Business Consulting company with HQ in Iowa LOCATION: Kharkov/UA

FROM: 08/2016

TO: 10/2016

DUTIES:

Setting up a SharePoint Online environment for document management, collaboration and full-text search

Setting up Azure Blob as cloud storage for files

Creating a solution for selectively saving/uploading emails from Outlook to SharePoint Page 6 of 20

Creation of Excel calculation models for different industries for estimation of potential turnover, cost & profit and their expected deviations

Setting up a database for storing customer data along with the relevant figures, regulatory information and legal citations to be used in reports and business plans to be created

Creating Word templates with static text and placeholders for automation

Programming Word automation for automatic creation of reports and business plans using information in the database and Excel calculation models

Setting up Power BI environment for internal business reporting Products & technologies used:

SharePoint Online (Office 365 Enterprise E3 plan)

Microsoft Flow (for Outlook to SharePoint integration) Azure Blob

Power BI Pro

Power BI Desktop

Excel incl. VBA

Word incl. VBA

C# (using Excel and Word Interop libraries)

SQL Server incl. T-SQL

Access (as Front-End of SQL Server DB)

POSITION: Data-Integration / ETL / DWH / Application Migration / Excel Development TYPE: Contract

FOR: People Business AG

CLIENT: Varo Energy

LOCATION: Cham/Zug

FROM: 09/2015

TO: 07/2016

DUTIES:

Installing the development environment (client & server environment)

Porting of an existing MS Access-based data-import and reporting solution to one using SQL Server as back-end and MS Excel as front-end

Designing a central DWH

Developing a framework for importing data to the central DWH, logging, synchronizing of imported data to down-stream (application) databases along with email-based reporting of the whole import & synchronization process

Creating SSIS packages to import data from various heterogeneous data sources (Oracle, MSSQL, Excel, flat-files) into the central DWH

Introducing naming conventions for AD user groups & service accounts, MS SQL logins, credentials, SQL Agent proxy accounts, SQL Agent jobs, SSIS packages

Introducing naming conventions for DB objects

Evaluating an SSAS-based Actuals vs Budget comparison solution option

Designing a database and an Excel VBA-based solution for importing (from bank budget model), manually entering (through the custom-developed Excel-GUI), calculating and comparing budget vs actual values, supporting for multiple model versions, model instances, users scenarios, user-based security and historization of facts and dimensions

Developing a Excel VBA macro to analyze the Excel-based budget model (as defined by borrowing bank consortium) and extract the budget hierarchy implicitly defined therein

Developing an Excel-based UI with user-based security (to define who can see, add or change what) for viewing and saving actual values with full historization and logging

Developing an Excel VBA-based UI implementing various business and process-flow rules to allow authorized users to enter corrections for actuals values previously imported and/or manually entered.

Compiling & deploying UDFs and CLR functions to increase productivity and use of standardized code

Page 7 of 20

Introducing TFS online, importing all work artifacts created so far into the TFS, managing TFS

Creating an Excel workbook pulling from the DB the Actuals data-series (which have been previously entered by users), automatically defining named-ranges on them (through a VBA macro) thus enabling the users to refer to these data series in their calculations and diagrams by name.

Setting up the UAT environment

Creating maintenance plans for DEV, UAT and PROD environments

Adminstration & troubleshooting of developed solutions

Technical documentation and hand-over

Products & technologies used:

Windows Server 2012 R2

SQL Server 2014 (DB design, development of stored procedures, UDFs and triggers, index tuning) SSIS

SSMS, SSDT, SSDT-BI, BIDSHelper

APEX Toolbelt

MS SQL Server Migration Assistant (SSMA) for Access MS Access incl. Access VBA

VS 2013/2015 Community Edition

MS Excel incl. VBA

Excel Dependency Auditor

PowerPivot

Power Query

Power Update

TFS Online

ADO.Net (during Excel VBA development)

C# (in script tasks and script components during SSIS development) POSITION: Data-Migration & ETL & Performance Tuning TYPE: Contract

FOR: -

CLIENT: Direct-Client (A Swiss web-shop with a large network of branches) LOCATION: Remote

FROM: 03/2015

TO: 07/2015

DUTIES:

Migration of existing data from client’s ERP systems (OPACC and SAGE) into the self- developed MSSQL DB. Performance-Tuning of the DB-Server and the target DB. Products & technologies used:

SQL Server 2014

SSIS

SSMS, VS 2015, SSDT, SSDT-BI

BIDSHelper

Excel 2013

C#

POSITION: Reports-Developer & BI-Developer

TYPE: Contract

FOR: -

CLIENT: Direct-Client (Consulting company)

LOCATION: Remote

FROM: 09/2014

TO: 12/2014

Page 8 of 20

DUTIES:

Creating a time-tracking DB and SSRS-based management reports to overview the time spent by subcontractors on client projects.

Products & technologies used:

SQL Server 2012/2014 (incl. SSIS, SSAS, SSRS)

SSMS, VS 2015, SSDT, SSDT-BI

BIDSHelper

Excel 2013, PowerPivot

SharePoint 2013

C#

POSITION: MS BI-Architect

TYPE: Contract

FOR: 7N-SYNLOGIC

CLIENT: SwissRe

LOCATION: Zürich

FROM: 07/2014

TO: 09/2014

DUTIES:

Contributing to deployment planning of the components of the BI-Stack (MSSQL, SSIS, SSAS, SSRS)

Designing & documenting the security architecture of the new Microsoft BI-platforms o authentication & authorization within the components of the BI-stack o impersonation & Kerberos delegation during the interactions between the components

Supporting the project manager in technical meetings and during her interactions with other teams

Products & technologies used:

SQL Server 2012/2014 (incl. SSIS, SSAS, SSRS)

Excel 2013, PowerPivot

SharePoint 2013 (Excel Services, PowerPivot Services, PerformancePoint Services, Visio Services) POSITION: DBA / Developer / Tuning Expert

TYPE: Contract

FOR: HAYS

CLIENT: Xerox

LOCATION: Zurich

FROM: 01/2014

TO: 06/2014

DUTIES:

Analysis of bad performance of VRLBs, making tuning recommendations and implementing them

Writing T-SQL queries, stored procedures, triggers and .NET-based client application code Products & technologies used:

SQL Server 2008 R2

Windows Server 2008 R2

VMware ESX

VMWare vSphere Client

Page 9 of 20

POSITION: DB & Web Developer

TYPE: Contract

FOR: Assist-IT GmbH

CLIENT: Direct-client (a SME in the area of telecommunication) LOCATION: Bern

FROM: 09/2013

TO: open

DUTIES:

Re-implementing an existing in house windows-application as web-application with the aim of enabling the clients to access it thus eliminating the need for manual data entry and manual data imports/exports. As a one-man show, I’ve full life-cycle responsibility i.e.

Gathering and analysis of requirements

Creating the functional specification document

Designing and implementing the application (Full-life-cycle)

Training the staff

Support

Products & technologies used:

Access 2012

SQL Server 2012

Visual Studio 2013

VSTest.Console.exe

NUnit

log4net

.NET 4.5.1

C#

ASP.NET MVC

LightSwitch (for HTML5)

WCF RIA Services

jQuery

AJAX

Razor

JSON

Telerik 2013 Q3

Parental leave

FROM: 05/2013

TO: 09/2013

POSITION: BI-Developer / .Net Developer

TYPE: Contract

FOR: Assist-IT GmbH

CLIENT: ALSTOM Power AG

LOCATION: Baden / Switzerland

FROM: 01/2013

TO: 05/2013

DUTIES:

Developing a discovery tool by building a wrapper (using SSIS and .Net programming) around a well-known hacking tool (SqlPing3) to discover unknown installations of MSSQL within the company’s global network consisting of locations in over 100 countries. Page 10 of 20

Physical and logical modeling of a data warehouse for storing data about the globally dispersed HW & SW assets (i.e. computers with Windows OS hosting MSSQL components)

Conversion of the company’s list of subnets from the CIDR notation (as provided by the network team) into the address-ranges (with start-address and end-address) as required by the discovery tool. This conversion was performed by building on top of the open-source .NET DLL published at http://ipnetwork.codeplex.com/

Developing of SSIS-Packages for loading data into the data warehouse from several source- systems with HW & SW asset information (Altiris, CMDB, SerMan-Server Manager, SCOM, SCCM), various Excel Sheets, flat-files and the discovery results of the discovery tool.

Modeling of a SSAS database for multidimensional analysis and reporting

Creating of various SSRS reports based on the data warehouse and the cubes

Setting up a SharePoint server for reporting purposes

Making the data available for use analysis via Power Pivot and Power View Products & technologies used:

SQL Server 2012

SSIS 2012

SSAS 2012

SSRS 2012

SharePoint 2013 (PerformancePoint, Excel Services) Power Pivot

Power View

Excel

POSITION: SQL Server DBA / Architect & System Center Engineer TYPE: Contract

FOR: Assist-IT GmbH

CLIENT: ALSTOM Power AG.

LOCATION: Baden / Switzerland

FROM: 05/2010

TO: 11/2012

DUTIES:

Administration as well as 2nd and 3rd level Support of the globally dispersed SQL Server landscape

Analysis and Troubleshooting of performance problems

Support of SW-development teams in all database-related issues (DB-Design, data-modelling, DB-connections, data-access technologies (ADO.net, OLEDB, Entity Framework), performance, backup & restore, High-Availability (mirroring, replication, failover-clustering, availability groups, log-shipping, hot/cold stand-by server), DTC on stand-alone servers and on clusters, batch processing, maintenance jobs, reporting, SharePoint-integration, BI etc.)

Multi-server & multi-site deployment of System Center suite (SCCM, SCOM and SCVMM) for deployment, administration and monitoring of the globally dispersed SQL Server landscape

Creation of SCOM Agent Tasks and Console Tasks for repetitive administrative tasks

Creation of custom SCOM reports

ZTI and LTI of Windows Servers along with SQL Server on both physical and virtual servers

(using SCCM, MDT, WDS, WAIK / Windows ADK)

Patching of Windows Servers and SQL Server instances using SCCM and WSUS

Deploying of 3rd party tools and utilities to central management servers and DBA workstations (using SCCM and SCUP)

Creation of deployment guides for SSIS, SSAS and SSRS (native or SharePoint-integrated mode) on stand-alone servers and failover clusters

Creation of a concept for the delegation of permissions to various user groups (owners of dedicated servers, owners of dedicated instances on shared servers, DB owners on shared- instances)

Page 11 of 20

Development of a PBM-solution with automatic application of policies on target instances, polling of policy validation results, consolidation of results in a central database and creation of SSRS-based summary reports on the collected data

Substituting maintenance plan based DB-maintenance through a stored procedure based maintenance-plan solution (index-maintenance, DB-consistency checks, statistic updates) Creation of SSRS-based reports for tracking the success of their execution.

Substituting of maintenance plan based backups through EMC-Networker based backups

Developing an Excel-based license-cost calculators for calculating the license-fees of MSSQL 2012 licenses for various deployment scenarios and licensing modes

Creation of a migration concept for the migration of DBs from older SQL Server versions

Troubleshooting of double-hop authentication issues due to Kerberos-Authentication problems

(due to missing or duplicate or wrong SPNs, DNS issues etc.)

MSSQL-related AD-tasks (creation of service accounts, user accounts and groups, creating and fixing SPNs, SCOM integration, SCCM schema extension etc.)

MSSQL-related DNS-tasks (checking that host-name => IP-address => host-name (reverse lookup) returns the exact same host-name which is a prerequisite for successful Kerberos authentication)

Products & technologies used:

Windows Server 2008 / Windows Server 2008 R2

SQL Server 2008 / SQL Server 2008 R2 / SQL Server 2012 Analysis Services 2008 / 2008R2 / 2012

Reporting Services 2008 / 2008R2 / 2012

Integration Services 2008 / 2008R2 / 2012

SharePoint 2010

System Center 2007/2007R2/2012 (SCCM, SCOM, SCVMM, SCSM, Orchestrator) MAP Toolkit

Sqlping3

CMS – Central Management Server

PBM – Policy Based Management

Multi-Server Administration

UCP – Utility Control Point

WinRM, WinRS, WMI, PowerShell

AD/DS Tools, DNS Tools

BMC Remedy 7.5

Quest TOAD for SQL Server

Quest Spotlight Enterprise

Quest Foglight Performance Analysis

Redgate SQL Toolbelt

Idera SQL Job Manager

SQL Sentry Event Manager

SQLEMS

EMC PowerPath

PortQry / DTCPing / DTCTester

POSITION: BI-Developer

TYPE: Contract

FOR: Assist-IT GmbH

CLIENT: Vontobel AG

LOCATION: Zurich / Switzerland

FROM: 12/2010

TO: 12/2011

DUTIES:

integrating data-feeds (from providers like SMI, JPM, Barclays, S&P, Merrill Lynch etc..) for bond indices into the main portfolio management application (Allocare AMS). DB-Programming as well as Page 12 of 20

designing of SSIS-packages and Windows Batch-Scripts to implement data-interfaces between various systems (Allocare AMS, Princeton DVS, Avaloq etc.) Products & technologies used:

SQL Server 2005, SSIS

VB.NET

BIDS 2005

BIDS Helper

Excel 2003 / Word 2003

XML Notepad 2007

SourceSafe

POSITION: BI- Developer & .NET-Developer

TYPE: Contract

FOR: ASSIST (SK) s.r.o.

LOCATION: Bratislava

FROM: 03/2010

TO: 05/2010

DUTIES:

Developing a windows client application for pricing offers, considering various user-defined parameters for taking into account specifics of the order, the terms of the contract, various environmental factors and personnel preferences.

Modeling a database for storing pricing sessions & scenarios (sector categorization, user- defined parameters, user-defined parameter weights, resulting price-ranges)

Developing the uploading of pricing sessions & scenarios

Creation of SSRS reports for analysis of the frequency of used parameters and their weights from sector, country and various demographic properties like age. Products & technologies used:

SQL Server 2008 R2

Analysis Services

Reporting Services

Windows 2008 Server R2 Core Server

IIS 7.5

.NET 3.5

VB.NET

WCF (Windows Communication Foundation)

Visual Studio 2008

TFS (Team Foundation Server)

POSITION: SQL Server Developer / DBA + Systems Engineer TYPE: Contract

FOR: ASSIST (SK) s.r.o.

LOCATION: Bratislava

FROM: 01/2010

TO: 02/2010

DUTIES:

Migration of Windows 2003 Failover Clusters to Windows 2008 R2 Changing from Quick-Migration to Live-Migration (trough using a CSV) Cluster-Installation of SQL Server 2008 on Windows 2008 R2 Migration of SQL Server 2005 Databases to Version 2008 Migration of SSIS Packages to Version 2008

Migration of SSRS instances and reports to version 2008 Code- and Index- Review for performance optimization of databases Page 13 of 20

Performance tuning of databases

Products & technologies used:

Windows Server 2008 R2

IIS 7.5

SQL Server 2008

SSIS

POSITION: System Engineer

TYPE: Contract-based

FOR: ASSIST (SK) s.r.o.

LOCATION: Bratislava

FROM: 07/2009

TO: 12/2009

DUTIES: Virtualizing the entire IT infrastructure (servers, desktops, applications and storage) Setting up the virtualization hosts (using Hyper-V) Setting up failover clustering for Hyper-V servers Setting up Clustered Shared Volume using Starwind iSCSI Enterprise as iSCSI target UEFI-based installation of guest OS

Setting up virtual networking

Setting up virtual storage using iSCSI SAN (Starwind) Setting up network infrastructure services (AD & DS, DHCP, RRAS etc.) as guest OS Setting up SQL Server (in clustered setting) and IIS, both as VMs Setting up Visual Studio 2008 Team Foundation Server Installing applications to be used for App-V (Microsoft Application Virtualization) Setting up desktop virtualization using MED-V

Setting up remote management station for servers, services and storage Setting up locked-down guests for use by staff working off-site on laptops P2V (Physical to virtual conversions)

V2V (virtual to virtual conversions), mostly from VMware to Hyper-V Performance tests and benchmarking for various storage and memory configurations for SQL Server

Products & technologies used:

DELL PowerEdge R610 and R710 servers

Windows 2008 R2 and Windows 2008 R2 Core

Windows 2008 x32 (for installing Visual Studio 2008 Team Foundation Server)

CoreConfigurator

Rocket Division Starwind iSCSI Enterprise HA (iSCSI target) and Starport (iSCSI initiator)

Microsoft SCVMM (System Center Virtual Machine Manager)

Microsoft SCOM (System Center Opeartions Manager)

Microsoft Hyper-V Manager

Microsoft RSAT tools (Remote Server Administrator Tools)

SQL Server

VMware ACE, VMware Workstation (6.5.2. and 7), VMware Player, VMware vConverter

SQL Server 2005/2008

Sharepoint Server 2007

POSITION: BI-developer / DBA

TYPE: Contract-based

FOR: T-COM Germany

LOCATION: Kiel

FROM: 02/2009

Page 14 of 20

TO: 07/2009

DUTIES: Migrating and enhancing an existing MS Access-based sales forecasting application to SQL Server 2005.

Creating a multidimensional analysis database

Configuring Reporting Services, creating reports

Installing & configuring the development, test and production web servers using IIS 6 Creating necessary models and documentation using ErWin Products & technologies used:

Windows 2003 / Windows 2008 with Terminal Services (Remote Desktop Services)

IIS 6.0

Virtual Server 2007

SQL Server 2005

Analysis Services

Reporting Services

SSIS

BIDS (Business Intelligence Development Studio) with BIDSHelper 2005

VB.NET / C#

ErWin

Visual Studio 2008 Team System,

Visual Studio 2008 Team Foundation Server

Excel 2003/2007

Quest TOAD for SQL Server, ApexSQL Diff, Redgate SQL POSITION: DBA & ETL-Developer

TYPE: Contract-based

FOR: DWS Fund Luxembourg

LOCATION: Luxembourg City / Luxembourg

FROM: 09/2008

TO: 12/2008

DUTIES: Comparing and synchronizing the schema of production and development databases Creating new SSIS packages for loading and transforming data from host systems Re-configuring the replication to cater for the changed database schema. Creating SSRS reports to monitor the success of schema synchronization and data loads. Products & technologies used:

SQL Server 2000 / 2005

Visual Studio 2005

DTS / SSIS

SSRS

VB.NET

C#

SourceSafe

Excel 2003

Quest TOAD for SQL Server, ApexSQL Diff, Redgate SQL Compare, DBGhost POSITION: DB- & ETL-Developer

TYPE: Contract-based

FOR: HELABA - LandesBank von Hessen und Thüringen

LOCATION: Frankfurt a. M. / Germany

FROM: 12/2007

TO: 07/2008

Page 15 of 20

DUTIES: Extending an existing web application and its backend database designed for evaluation of credit risk according to IFRS.

Products & technologies used:

SQL Server 2000 / 2005

Visual Studio 2005

DTS / SSIS

SSRS Reports

Excel 2003

POSITION: Database and Web Developer

TYPE: Contract-based

FOR: ASSIST (SK) s.r.o.

LOCATION: Bratislava/Slovakia

FROM: 12/02/07

TO: 01/11/08

DUTIES: Creating a membership-based community website for online skills verification through online video conferencing conducted by experts and real-time exams Products & technologies used:

SQL Server 2005

Visual Studio 2005, Visual Web Developer 2005

Code Charge Studio 4

IIS

SourceSafe

ASP.NET, C#, ADO.NET

HTML

XML/XSLT

JavaScript

Excel 2007

POSITION: EXCEL VBA Developer

TYPE: Contract-based

FOR: ASSIST (SK) s.r.o.

LOCATION: Trnava/Slovakia

FROM: 01/02/07

TO: 01/03/07

DUTIES: Creating an EXCEL-based hotel booking management system with XML/XSLT interface to update

Products & technologies used:

Excel 2007 VBA

XML / XSLT

POSITION: Web Developer (www.narinapart.com)

TYPE: Contract-based

FOR: ASSIST (SK) s.r.o.

LOCATION: Trnava/Slovakia

FROM: 01/01/07

TO: 01/02/07

Page 16 of 20

DUTIES: Creating the internet presence of a holiday apartments facility in Marmaris/Turkey along with online availability check and the integration of an online booking engine Products & technologies used:

FrontPage Server Extensions

Microsoft Expressions Designer

HTML

XML / XSLT

JavaScript

Visual Web Developer 2005

ASP.Net

POSITION: Web Developer (www.assist.sk)

TYPE: Contract-based

FOR: ASSIST (SK) s.r.o.

LOCATION: Bratislava/Slovakia

FROM: 01/01/07

TO: 01/02/07

DUTIES: Creating the corporate online presence

Products & technologies used:

Microsoft Expressions Designer

HTML

XML

AJAX / JavaScript

Photoshop

POSITION: Microsoft Product Support Engineer for SQL Server 2000/2005 TYPE: Contract-based

FOR: Hewlett Packard

LOCATION: Dublin / Ireland

FROM: 22/11/06

TO: 22/12/06

DUTIES: Supporting Microsoft SQL Server customers in German speaking countries Products & technologies used:

SQL Server 2000 / 2005

SQL Server Profiler

Windows 2000 / 2003

Clarify

Terminal Services

Virtual Server

Easy Session

MPS-Reports & Viewer

RowSetViewer

ReplDiag

PSSDiag

ODBC-Trace

Windows Debugger

Debug Monitor

Page 17 of 20

CloneDB

DTCPing

LeakDiag

LDGrapher,

POSITION: Web Developer (www.seascootersafari.com) TYPE: Contract-based

FOR: ASSIST (SK) s.r.o.

LOCATION: Bratislava / Slovakia

FROM: 01/01/06

TO: 30/09/06

DUTIES: Developing the company website

SEO (Search Engine Optimization)

Building XML data interfaces to exchange booking data with travel agencies and tour operators

Integrating online payment

Products & technologies used:

XML/ HTML/CSS/JavaScript/

FrontPage 2003

Xara Webstyles 2

Macromedia Flash MX 2004

Contact this candidate