Erdöl Biramen

DUTIES: Administering and supporting of SQL Server running on Windows failover clusters. Patching (via SCCM & WSUS) Multi-Server Deployment of System Center Suite Inventory & Assessment Kerberos Troubleshooting Active Directory Management & Troubleshooting DNS Management & Troubleshooting Products and technologies used: SCCM, SCOM, SCSM, Orchestrator MAP Toolkit Sqlping3 CMS – Central Management Server PBM – Policy Based Management Multi-Server Administration UCP – Utility Control Point

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#

DUTIES: Several smaller projects in the area of Reporting & BI Products & technologies used: SQL Server 2012/2014 (incl. SSIS, SSAS, SSRS) SSMS, VS 2015, SSDT, SSDT-BI BIDSHelper Excel 2013, PowerPivot SharePoint 2013 C#

• Contributing to deployment planning of the BI-Stack components • 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 between the components • Supporting the project manager in technical meetings and in her interactions with other teams SQL Server 2012/2014 (incl. SSIS, SSAS, SSRS) Excel 2013 SharePoint 2013 (Excel Services, PowerPivot, PerformancePoint)

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

Re-implementing an existing in house application as a web application so that the clients could access it thus eliminating work related to manual data entry and imports/exports. • Gathering and analysis of requirements • Creating the functional specification document • Designing and implementing the application (Full-life-cycle) Products used: Access SQL Server Visual Studio VSTest NUnit log4net .NET 4.5.1 C# ASP.NET WCF AJAX Razor JSON

• Developing a tool using SSIS and .Net to discover MS SQL instances within the company’s global network • Modeling of a DWH for storing data about servers hosting MS SQL components • Developing SSIS-Packages for loading into the DWH data about HW & SW assets from several source-systems • Modeling of a SSAS database for analysis & reporting • Creating various cube-based SSRS reports • Setting up a SharePoint site for reporting via Power Pivot, Power View

DUTIES: Administering and supporting of SQL Server running on Windows failover clusters. Products and technologies used Windows Server 2003 R2 / Windows Server 2008 / Windows Server 2008 R2 SQL Server 2005 / SQL Server 2008 / SQL Server 2008 R2 Analysis Services 2005 / Analysis Services 2008 Reporting Services 2005 / Reporting Services 2008 Integration Services 2005 / Integration Services 2008 Sharepoint 2010 Cluster Admin System Center Operations Manager (SCOM 2007 R2) System Center Configurat

DUTIES: .) integrating data-feeds for bond indices as benchmark portfolios 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 usw) Products and technologies used: SQL Server 2005 BIDS 2005 BIDS Helper Excel 2003 / Word 2003 XML Notepad 2007 SourceSafe

DUTIES: Developing a Windows client application for freelancers to help them decide the hourly-rates they should charge for their services considering various job- and location related factors as well as their personal preferences. Includes a multidimensional, multivariate analysis of the dependencies between the calculated rates and users’ subjective selection and weighting of various factors. Products and technologies used SQL Server 2008 R2 Analysis Services Reporting Services Windows 2008 Serve

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 Code- and Index- Review for performance optimization of databases Products and technologies used: • Windows Server 2008 R2 • IIS 7.5 • SQL Server 2008 • SSIS

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 SQL Server (in clustered setting) and IIS, both as VMs Setting up Visual Studio 2008 Team Foundation Server

DUTIES: Migrating and enchancing 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 Products and technologies used: • Win2003/2008 • IIS 6.0 • Virtual Server 2007 • SQL Server • SSAS • SSRS • SSIS • BIDS • VB.NET / C# • ErWin • Visual Studio

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 Products and technologies used: • SQL Server 2000 / 2005 • Visual Studio 2005 • DTS / SSIS • VB.NET • C# • SourceSafe • Excel 2003 • Quest TOAD for SQL Server, ApexSQL Diff, Redgate SQL Compare, DBGhost

DUTIES: Enhancing an existing web application and its backend database designed for management and evaluation of endangered bank loans according to IFRS. Products and technologies used: • SQL Server 2000 / 2005 • Visual Studio 2005 • DTS / SSIS • Excel 2003

DUTIES: Supporting Microsoft SQL Server customers in German speaking countries Products and 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 • CloneDB • DTCPing • LeakDiag • LDGrapher

DUTIES: Developing financials reports and the underlying architecture Products and technologies used: • SQL Server 2000 • Analysis Server • SQL Server 2000 Reporting Services • DTS-programming, • ASP.NET • C# • Visual Studio .NET 2003 • Visual SourceSafe 6

DUTIES: SQL Server DBA / Developer tasks and some .NET Testing Products and technologies used: • Microsoft SQL Server 2000 DBA tasks • Programming of stored Procedures and triggers • DTS-programming, • SQL Best Practices Analyzer • ApexSQL • DBGhost • Visual Studio .NET 2003 • Visual SourceSafe 6

DUTIES: Developing a new multidimensional analytical solution for the finance department to better track and analyze all customer support related activities in Europe. Products and technologies used: • SQL Server 2000 and DTS • Analysis Services 2000 • Knosys ProClarity 4.0 • Excel 2000