IT Specialist (BI, DWH) & Investment Compliance Analyst

2/2014 – 2/2015

Integration of Compliance System incl. Reporting
The challenges of the project were optimizing the processes of gathering the data, parallel multitasking for a better performance to achieve the daily compliance tasks within the business time limits and checking complex regulatory and private rules for portfolio's benchmarks.13 (incl. client) employees involved

Datawarehouse / DWH, Reporting, ODBC (Open Database Connectivity), ETL, Projektmanagement (IT), Testing (IT), PL/SQL, Migration, Compliance management, Asset management

10/2013 – 9/2014

Migration of Compliance System with pre-trade function
The fund portfolios in private banking are complex which leads to very complex check processes and data structures, in specific for pre-trade.
The challenges of the project were optimizing the performance and maintaining the same business results and processes after the migration. 10 (incl. client) employees involved

Datawarehouse / DWH, Reporting, ETL, Projektmanagement (IT), Testing (IT), PL/SQL, Asset management

2/2013 – 1/2014

Integration of Compliance System:
An optimization of the performance has been achieved by a parallel processing of the Data and implementing a new concept of the interfaces to the sources. incl. Project Manager Role ( from Analysis, Planning, Budget, ressources, conception, development, testing, Delivery ) 8 (incl. client) employees involved

Oracle Business Intelligence (BI), Datawarehouse / DWH, Reporting, ETL, Projektmanagement (IT), Testing (IT), PL/SQL, Migration, Asset management

3/2012 – 1/2013

Global Exposure: Implementation+Reporting
Implementing the CESR's guidelines on Risk Management and the calculation of global exposure . It considers the different types of risk within the portfolio and uses the Look through principle for the investments. The results of the new calculation were also integrated within several complex automated reports in an additional phase of the project. 7 (incl. client) employees involved

Datawarehouse / DWH, Reporting, ETL, Projektmanagement (IT), .Net Framework (Microsoft), PL/SQL, Migration, Compliance management, Asset management, Risikomanagement (Finan.)

8/2009 – 2/2012

Implementing projects for the largest telecommunication firms
- Off-Shoring and Near-Shoring Projects
- Design, Documentation, testing.
- Management: Planning and conception of new projects.
- Business Intelligence
- KPI & Analytics for Performance Management
- Dashboards & Scorecards
- Native and html5 Mobile Apps
- Data Integration/Mining & ETL processes
- create and optimize OLAP Cubes for business management
- Reports creation and optimization

Online Analytical Processing (OLAP), Datawarehouse / DWH, Pentaho Open-Source-BI-Suite, Reporting, ETL, Projektmanagement (IT), Java (allg.), Mobile Entwicklung (allg.), PL/SQL, HTML5, JavaScript, Balanced Scorecard, Kennzahlensysteme

2/2009 – 7/2009

Testing und Documenting a self developed DWH Incl. Market data interfaces ( Bloomberg, BHF..), Xentis interface and Business Objects Universe

Datawarehouse / DWH, Pentaho Open-Source-BI-Suite, Business Intelligence and Reporting Tools (BIRT), SAP BusinessObjects (BO), Reporting, ETL, Java (allg.), PL/SQL, Asset management

10/2008 – 2/2009

Portfolios Risk Management System Migration for Royal Bank of Scotland from Risk metrics to PMS.
- Design and Implementation of the flows for the automation of importing the Data feeds from RBS’ clients like Northentrust, Mizuho, State Street, RBCDexia, Caceis, BNP and BBH into PMS.
- Design and development of the Portfolios Management Dashboard for the Funds Administrators

Datawarehouse / DWH, Pentaho Open-Source-BI-Suite, Reporting, ETL, Java (allg.), PL/SQL, Balanced Scorecard, Asset management

6/2008 – 10/2008

Harmonization of accounts and accounts settings between Frankfurt and Luxembourg in Multifonds/ the funds accounting system from IGEFI

Datawarehouse / DWH, Reporting, ETL, Visual Basic Script (VBS), Asset management, Wertpapierhandel

2/2008 – 6/2008

ATIS: Automation of transactions interfaces and inserting the transactions into Multifonds Database.

Datawarehouse / DWH, ETL, PL/SQL, HTML, Webdesign, Asset management, Wertpapierhandel

8/2007 – 2/2008

Order Booking Management: Automation of Swift Connections (ISO 15022 and ISO 20022), import the orders in eBase Order Booking system, and send the answer and reports back to eBase clients; optimization of Back Office processes.

Datawarehouse / DWH, ETL, PL/SQL, SWIFT, Asset management, Wertpapierhandel

3/2007 – 7/2007

Funds Migration to Multifonds/ IGEFI and reconciliation after the migration of the funds between the old and the new accounting system.

Oracle (allg.), ODBC (Open Database Connectivity), ETL, SQL, Visual Basic Script (VBS), Compliance management, Asset management, Wertpapierhandel

5/2006 – 12/2006

SCTP protocol: research in the security and the applications of the protocol and realize the implementation in Linux Kernel.

UNIX, Kernel Programmierung, Linux (Kernel), C++, User Red Hat Package Manager (von Mandriva Linux), TCP/IP, RTP (Real-Time Transport Protocol)

10/2005 – 4/2006

OMS Web Services: Automated documentation and Implementation of supported T-Online Web Services for the Partners and points of sales (B2B Web Services)

Datawarehouse / DWH, Reporting, ETL, Java (allg.), Webservices

3/2005 – 9/2005

Network Management: Development of interfaces between the management systems of Arcor’s networks like AWS, TNMS and ACI and migration to one fault management system (IFM for Integrated Fault Management).

Datawarehouse / DWH, Reporting, ETL, Incident Management

12/2003 – 3/2005

Research Assistant : Research on a modified Viterbi equalizer for a new model of a multi-carrier channel
Professor Assistant for Analysis for Informatics students in German language and Mathematics for ICE master students in English

Mathematik

7/2002 – 10/2002

Executing the GSM/PABX interface done in one of my university projects, and 'Project Study' to commercialize it (markets, fabrication, budgets and benefits ...)

Mikrocontroller

4/2002 – 6/2002

Installation and maintenance of Cisco products, networks and connections

Cisco Switch, Cisco Router, Mathematik