MS SQL Server BI/DWH Developer and DBA
Resume:
Technical Competencies
MS SQL (Architecture/Development/Administration/Support/Migration/Performance Tuning) ETL Development / Data-Migration
MS BI / DWH (Architecture/Development/Administration/Support/Performance Tuning)
.NET Application Support
Application- & Systems Integration
Web Services / API-Development
Office Automation, VBA- Development
Soft-Skills
Analytical thinking
Courage to raise questions, to question established practices Cleaning & correcting data
Extracting the knowledge inherent in the data
Reporting
Finding bugs, suggesting alternative solutions to fix the issues, communicating their pros & cons Finding shortcomings in applications & processes, suggesting improvements Structured way of working, methodical approach (SCRUM, Kanban, XP) Ability to operate as one-man-show as well as part of a team Ability to quickly work myself into new subject areas Ability to improvise, to think out-of-the-box
Erdöl BIRAMEN +41-77-462**** 5034 Suhr ****@*******.*** www.biramen.com Page 1 of 21 Professional Development
Trainer for MS Office applications
MS Access & MS Excel Developer
MS Certified Trainer for MS SQL Server, Windows Server, IIS, MS Access VBA, MS Excel VBA MS SQL Developer / DBA
DTS/SSIS/SSAS Developer
SCOM Developer
.NET Developer
XML / Web Services / API Developer
Erdöl BIRAMEN +41-77-462**** 5034 Suhr ****@*******.*** www.biramen.com Page 2 of 21 PROJECTS OVERVIEW:(newest on top)For details of projects, pls click HERE Year Industry Company Location Main Role Main Products & Technologies used 2024 Banking PostFinance Bern MSSQL DWH Specialist MSSQL VS SSIS SSRS SSAS MIK 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 Jira Bitbucke t
2016 Business Consulting PlanPros Kharkov/U
A
Office Automation/DB- & Reports Developer MSSQL/SharePoint/Excel/Word/VBA/C#/PowerBI 2015-16 Energy Varo Energy Zug/CH Microsoft BI Developer/Excel Developer MSSQL SSIS BIDS Helper VS C# Excel VBA Access 2015 E-Commerce PC-OstSchweiz / Steg Remote 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 Luxembour
g
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 Page 3 of 21
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 4 of 21
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:MSSQL DWH Specialist
TYPE:Contract
FOR:ProStaff
CLIENT:PostFinance
LOCATION:Bern/CH - remote
FROM:01/2024
TO:07/2024
DUTIES:
● Gathering and analysis of requirements, conducting impact analysis, design & implementation
● T-SQL coding
● Building ETL chains with SSIS
● Loading SSAS and MIK cubes
● Creating SSRS reports
● Writing technical documentation
● 2nd-level support
Products & technologies used:
MSSQL / SSIS / SSRS / SSAS / MIK
MS Access
Confluence / JIRA
VS, SSDT,
Git
Excel, Pivot Tables, PowerPivot
2023-2024 Sabbatjahr
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 Page 5 of 21
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
● Performance Tuning of .Net code and T-SQL queries and stored procedures
● Index tuning
● Automating repetitive business-related tasks
● Automating repetitive technical tasks e.g. disabling services and scheduled jobs before server maintenance and re-enabling them afterwards & executing jobs whose schedules were missed
● Project-management for integration & migration projects
● Development of .NET-based integrations with Web Services interfaces
● Development of SSIS packages for integrations with file-based interfaces Products & technologies used:
MSSQL
.Net
EF
VS
Git
TFS
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
Page 6 of 21
● 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
● 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) Page 7 of 21
● 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
● 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:-
Page 8 of 21
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
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)
Page 9 of 21
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
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
Page 10 of 21
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.
● 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:
Page 11 of 21
● 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)
● 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
Page 12 of 21
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 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
Page 13 of 21
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 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
Page 14 of 21
● 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
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. Page 15 of 21
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
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
Page 16 of 21
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
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 Page 17 of 21
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
●
Contact this candidate