ITSM Solution Engineer at OIZ City of Zurich
Jan 2023 - present
ITSM: Automation, Interfaces and Architecture, Infrastructure
Data Analysis
Specifications and Documentation
Solutions in Reporting and Monitoring (Dashboards and beyond)
Scrum on daily basis
Deputy Team Lead and Product Owner
IT-/Service Manager at Finform AG
Sept 2020 - Dec 2022
Triage (1st and 2nd Level Support)
Application Management
Process Automation
DWH Reporting
DevOps
Data Analysis & science
Senior Business Analyst at Hypothekarbank Lenzburg
Mar 2016 - May 2020
Coding in SQL, C#, C++, VB6, VBA
SQL Server (SSIS, SQL, stored procedures, UDF*)
Oracle DB
CouchDB
Standalone C#/C++ Systems
Kanban
Bloomberg Data License
VDF (Valor Data Feed from SIX)
Finstar (User and Developer, Data Model, Backend Operations)
Application and Business Support (from 1st to Last Level)
Testing Applications and Interfaces
Project Management
Quant Analyst Operations at Suva
Dec 2014 - Feb 2016
Coding in SQL (jobs, stored procedure, UDF, Visual Studio), C# using Devexpress
SQL Server (SSRS, SSIS)
Oracle DB (Toad, Linked Server)
XML, XLST (Swift Automation in SimcorpDimension)
Automatic Prossesing of Swift Messages (SQL Server)
Bloomberg Data License
Bloomberg Terminal
SimCorp Dimension
Application and Business Level (from 1st till last Level)
Testing Applications and Interfaces
Project Management
Investment Reporting Specialist at Credit Suisse
Sept 2011 - Nov 2014
Coding in CAIRE, SQL (Access, Oracle, SQL Server, mixed), C# and VBA (Excel, Word, mixed)
Code Generation based on XML configuration (WPF, C#)
Application and Business Support (from 1st till Last Level)
Testing Applications and Interfaces
Scrum
Project Management
Product Engineer at ABB
Jan 2008 - Aug 2011
Coding in VBA
Analysis in Cornerstone and in Excel
DoE**, FMEA***, Six Sigma Analysis in Cornerstone
BI Analysis and Presentations for Decisions
Six Sigma Green Belt
Project Management
* UDF = User Defined Functions (common for SQL Server, in lack of real functions like in PL-SQL of Oracle)
** DoE = Design of Experiment
*** FMEA = Failure Mode and Effect Analysis
ITSM & Architecture
CMDB (Configuration Management Database)
Service Management
2nd and 3rd Level Support
Application Management
Data Analysis & Quality
Scrum Methodology
Requirement Engineering
Integration and Automation
Reporting and Monitoring
Finance
Reporting
AEOI (Automatic Exchange Of Information) - XML, Data Extraction, Client Master Data, Screening, Data Validation
FATCA (Foreign Account Tax Compliance Act) - XML, Data Extraction, Client Master Data, Screening, Data Validation
FinMIA (Financial Market Infrastructure Act)
Art. 39 (Transparency Report on SIX Reportable Securities)
Art. 104 (Derivative Trading)
ALM (Asset Liability Management) - Ambit Focus, MS Excel, C# Interface Service
Collateral Management
Investment
Performance Measurement (including GIPS, Attribution, Risk Analysis)
Allocation and Rebalancing
Portfolio Valuation
FX Hedging
Tax Reporting (CH, DE, US, generic) - XML, Excel,
Back Office Operations
Reconciliation
Trading
Regulatory
Automation
Swift and SECOM Messaging
Industry
Six Sigma
Business Intelligence
Business Analysis
Production of complex devices (incl. supply chain)
Coding
Higher Languages
C/C++/C#
Visual Basic
Turbo Pascal
Small Talk
Macro Languages
SQL (T-SQL, PL-SQL, MS Access, JDBC)
WebFocus
VBA
Matlab
R
XHTML with CSS and Java
Scripting Languages
Command Prompt
PowerShell
Bash
JavaScript
XML/XLST
JSON
CAIRE
Applications
MS Office (from Lotus era till M365)
including VBA in Excel, Word, Access
Office Web
Office 365
Sharepoint
MS Teams
Confluence
Jira
BMC Remedy ITSM Suite and Helix ITSM Suite
Discovery
CMDB
BMC Dashboards
SAP Business Objects
DWP and DWPC
BIRT Reporting
Innovation Studio
Developer Studio
Databases
SQL Server (SSMS, SSRS, SSIS, SSAS)
Oracle DB (Toad, Linked Servers)
MS Access
PostgreSQL (on premise, Google Cloud, SaaS BMC)
Core Banking
Finstar
Host
Asset Management
SimCorp Dimension
PM1
Netfolio
PortfolioNet
Operating Systems
Windows (from 3.11 to 11)
Linux (Debian, RedHat, Ubuntu)
Doctor of Sciences ETH Zurich
2003 - 2007
Employed by Paul Scherrer Institute (Prof. Frithjof Nolting at SLS, Prof. Laura Heydermann at LMN)
Doctor father Prof. Danilo Pescia
Nanomagnetism (magnetic imaging and manufacturing of thin films)
Master of Sciences
1998 - 2003
Diploma supervisor: Prof. Rafal Abdank-Kozubski
Micro-metallurgy (ordering dynamics in binary alloys)
Medical Physics (5 semesters)
Solid State Physics (5 semesters)
Natural sciences Olympics
Chemistry (4th in voivodeship small Poland in 1994)
Physics
Mathematics
Model building
Static reduction models (multiple polish champion titles)
Time competition on rocket models (multiple polish champion titles)
Chemistry studies during High School (additional lectures on Universities in Cracow)
Private lessons in natural sciences
starting from helping school class friends
Earning money in High School and during studies
Published papers
R. Kozubski et al., Journal of Alloys and Compounds 378 (1-2), 302 (2004)
R. Kozubski et al., Defects and Diffusion Forum 237-240, 609 (2004)
T. Brys et al., Journal of Research of The National Institute of Standards and Technology 110 (3), 173 (2005)
T. Brys et al., Nuclear Instruments and Methods in Physics Research Section A 554 (1-3), 527 (2005)
S. Czekaj et al., Physical Review B 73, 020401(R) (2006)
L. J. Heyderman et al., Journal of Applied Physics 99, 1 (2006)
L. J. Heyderman et al., Physical Review B 73, 214429 (2006)
S. Czekaj et al., Journal of Physics: Condensed Matter, 19(38), 386214 (2007)
Conference Contributions
L. Messad et al., Colloque Scientifique Algéro-Français TAM-MAT 2003 Les Matériaux émergents, Tamanrasset, Algeria, February 2003 (Talk)
R. Kozubski et al., 9th International Symposium on Physics of Materials ISPMA-9, Praha, Czech Republic, 1 – 4 September 2003 (Talk)
E. Partyka et al., VIIIth Seminar Diffusion and Thermodynamics of Materials, Brno, Czech Republic, 4 – 6 September 2002 (Poster)
R. Henneck et al., Verhandlungen der Deutschen Physikalischen Gesellschaft, Regensburg, 8 – 12 March 2004 (Poster)
R. Kozubski et al., Summer School on Mass and Charge Transport in Materials, Krakow, 13 – 17 July 2004 (Talk)
R. Kozubski et al., Sixth International Confernce On Diffusion In Materials, Krakow, Poland, 18 – 23 July 2004 (Talk)
S. Czekaj et al., Joint European Magnetic Symposia Conference, Dresden, Germany, 5-10 September 2004 (Talk)
S. Czekaj et al., 5th SLS Users’ Meeting, Paul Scherrer Institut, Villigen PSI, 4 – 5 October 2004 (Poster)
F. Nolting et al., 338th WE Heraeus Seminar: Nanomagnetism: New Insights with SynchrotronRadiation, Bad Honnef, Germany, 5 – 7 January 2005 (Poster)
F. Nolting et al., 21st SAOG-GSSI Annual Meeting , Advanced Nano Probe Techniques, Université de Fribourg, 21 January 2005 (Talk)
S. Czekaj et al., The 13th General Conference of the European Physical Society, University of Bern, Bern, Switzerland, 11 – 15 July 2005
J. Raabe et al., Microscopy Conference Davos, Switzerland, 28 August – 2 September 2005 (Talk)
L.J. Heyderman et al., Microscopy Conference Davos, Switzerland, 28 August – 2 September 2005 (Talk)
S. Czekaj et al., 6th SLS Users’ Meeting, Villigen, Switzerland, 17 – 18 October 2005 (Best Poster Award)
S. Czekaj et al., X-Ray Spectroscopy of Magnetic Solids, Villigen, Switzerland, 18 – 20 2005 (Poster)
S. Czekaj et al., 50th Conference on Magnetism and Magnetic Materials, San Jose, USA, 30 October – 3 November 2005 (Poster nominated for Poster Session Award)
L. J. Heyderman et al., Magnetism and Spintronics at the Nanoscale, Annual Meeting of the Swiss Physical Society Meeting, Lausanne, Switzerland, 13 – 14 February 2006 (Poster)
S. Czekaj et al., Magnetism and Spintronics at the Nanoscale, Annual Meeting of the Swiss Physical Society Meeting, Lausanne, Switzerland, 13 – 14 February (Talk)
S. Czekaj et al., Joint European Magnetism Symposium, San Sebastian, Spain, 26 – 30 June 2006 (Poster)
S. Czekaj et al., CEAC “Nanoanalysis” Workshop, Zürich, Switzerland, 10 – 11 July 2006 (Poster)
S. Czekaj et al., 7th SLS Users’ Meeting, Villigen, Switzerland, 28 – 29 September 2006 (Poster)
Attended Schools
XI International Summer School Nicolás Cabrera Frontiers in Science and Technology: Magnetic Nanostructures, Miraflores de la Sierra, Spain, 13 – 17 September 2004 (Poster)
Summer School on Condensed Matter Research, Zuoz, Switzerland, 14 – 21 August 2005 (Poster)
List of skills in Business and IT (en + de):
Here is a full CV in English and German:
in German
Slawomir Czekaj
Slawomir Czekaj