
Erdöl Biramen
Fähigkeiten und Kenntnisse
Werdegang
Berufserfahrung von Erdöl Biramen
- Bis heute 14 Jahre und 7 Monate, seit 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
- Bis heute
Developer
ISPS Software Nicosia/CY
- 5 Monate, März 2015 - Juli 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 Monate, Sep. 2014 - Dez. 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#
• 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 Monate, Jan. 2014 - Juni 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 Monate, 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 Monate, Jan. 2013 - Mai 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 Jahre und 8 Monate, Mai 2010 - Dez. 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 Jahr und 1 Monat, Dez. 2010 - Dez. 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 Monate, März 2010 - Mai 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 Monate, 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 Monate, Juli 2009 - Dez. 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 Monate, Feb. 2009 - Juni 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 Monate, Sep. 2008 - Dez. 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 Monate, Dez. 2007 - Juli 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 Monate, Nov. 2006 - Dez. 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 Jahr, Jan. 2005 - Dez. 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 Monate, Nov. 2004 - Dez. 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 Monate, 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
Ausbildung von Erdöl Biramen
University of Economics in Vienna
Sprachen
Deutsch
Fließend
Englisch
Fließend
Türkisch
Muttersprache
Russisch
Gut
XING Mitglieder mit ähnlichen Profilangaben
XING – Das Jobs-Netzwerk
Über eine Million Jobs
Entdecke mit XING genau den Job, der wirklich zu Dir passt.
Persönliche Job-Angebote
Lass Dich finden von Arbeitgebern und über 20.000 Recruiter·innen.
22 Mio. Mitglieder
Knüpf neue Kontakte und erhalte Impulse für ein besseres Job-Leben.
Kostenlos profitieren
Schon als Basis-Mitglied kannst Du Deine Job-Suche deutlich optimieren.