Basic

Erdöl Biramen

Freelancer/Self-employed, SQL Server DBA / Engineer / System Core Infrastructure Architect, ALSTOM Power Schweiz AG

Suhr, Switzerland

Skills

IT-Services: Experience in Databases
RDBMS
SQL Server
Analysis Services
SSAS
Reporting Services
SSRS
Integration Services
SSIS
DTS
OLAP
DW
Datawarehousing
BI
Business Intelligence
DBA
TSQL
Stored Procedures
Tirggers
Development
Programming
Replication
Clustering
.NET
VB.NET
C#
ASP.NET
XML
XSLT
XML Schemas
XPath
XPointer
XQuery
System Center Operations Manager (SCOM )
System Center Virtual Machine Manager (SCVMM)
Hyper-V
IIS

Timeline

Professional experience for Erdöl Biramen

  • Current , since Jan 2011

    SQL Server DBA / Engineer / System Core Infrastructure Architect

    ALSTOM Power Schweiz AG

    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

  • Current

    Developer

    ISPS Software Nicosia/CY

  • 5 months, Mar 2015 - Jul 2015

    Data-Migration & ETL & Performance Tuning

    Direct client

    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#

  • 4 months, Sep 2014 - Dec 2014

    Reports-Developer & BI-Developer

    Direct client

    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#

  • 3 months, Jul 2014 - Sep 2014

    BI-Architect

    Swiss Re

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

  • 6 months, Jan 2014 - Jun 2014

    DBA / Developer / Performance Tuning Expert

    XEROX Legal Services

    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

  • 3 months, Sep 2013 - Nov 2013

    DB & Web Developer

    Direct 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

  • 5 months, Jan 2013 - May 2013

    BI-Developer / .Net Developer

    ALSTOM Power AG

    • 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

  • 2 years and 8 months, May 2010 - Dec 2012

    SQL Server DBA / Windows Server Admin

    ALSTOM Power Schweiz AG.

    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

  • 1 year and 1 month, Dec 2010 - Dec 2011

    BI Developer

    VONTOBEL Bank AG

    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

  • 3 months, Mar 2010 - May 2010

    .NET / SQL Server Developer

    ASSIST (SK) s.r.o.

    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

  • 2 months, Jan 2010 - Feb 2010

    SQL Server Developer / DBA + Windows/IIS Admin

    Assist (SK) s.r.o.

    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

  • 6 months, Jul 2009 - Dec 2009

    System Administrator

    Assist (SK) s.r.o.

    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

  • 5 months, Feb 2009 - Jun 2009

    Database development / BI-Development

    T-COM

    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

  • 4 months, Sep 2008 - Dec 2008

    Migration Specialist & ETL/BI - Developer

    DWS Fund Luxembourg

    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

  • 8 months, Dec 2007 - Jul 2008

    Database / ETL Developer

    LandesBank von Hessen und Thüringen

    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

  • 2 months, Nov 2006 - Dec 2006

    Product Support Specialist for SQL Server

    Hewlett Packard in Dublin/IE

    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

  • 1 year, Jan 2005 - Dec 2005

    Reports & Reporting Architecture Developer

    Dresdner Bank Kleinwort Wasserstein Frankfurt/D

    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

  • 2 months, Nov 2004 - Dec 2004

    Senior .NET Developer / SQL Server Developer/DBA

    Getronics Bruxelles/B

    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

  • 7 months, Aug 2001 - Feb 2002

    Multidimensional Reporting with Ms Analysis Server

    Hewlett Packard in Grenoble/FR

    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

Educational background for Erdöl Biramen

  • University of Economics in Vienna

Languages

  • German

    Fluent

  • English

    Fluent

  • Turkish

    First language

  • Russian

    Intermediate

Wants

clients
projects
project-based work
co-operations
contacts to technical experts in the area of Microsoft server products

Interests

SW
Partnerships
Technicians
Clients for Remote Monitoring - Remote Administration - Remote Support Off-shore / Near-shore SW-Development in East Europe / Russia / Turkey Swiss Tax Planning / International Tax Planning Legal aspects of freelancing in Switzerland Retirement saving schemes Online brokers Capital investment techniques & opportunities

Browse over 18 million XING members