test manager / requirement engineer / database specialist

2/2012 – 2/2013

High and Detail Level Conceptions for Identity Management and Reconciliation
Collecting identities from several internal systems and mapping into one central database
Implementing (pl/sql) LDAP file generation, optimizing, tuning
Integration into bank infrastructure

Oracle-Anwendungen, Active Directory, PL/SQL, Inbetriebnahme (allg.), Management (allg.), Öffentlichkeitsarbeit

5/2010 – 1/2012

Ongoing functional replacement of several independent data feeds within a new market data center (MDC). This includes data analysis, consistency checks, design, implementation, testing and improvement of catalogues, data feeds, validation, enrichment, subscriptions, data export and reporting/monitoring of the production system. Definition of a deployment process.

Environment: Jira, Oracle 10g/11g, PL/SQL, SQL Developer, SVN, Requisite Pro, TOAD

1/2010 – 4/2010

Redesign of a data mart (multidimensional analysis)
ETL analysis
intensely data consistency analysis
data mart modelling
implementation (pl/sql) and documentation
Realization of a Business Object Universe with performance tuning

9/2009 – 1/2010

Functional specification for a new media archive
25 structured interviews
documentation: introduction, stakeholder, sources, definitions, object structure, functional and non functional requirements, conceptual data design

1/2009 – 1/2010

Launching of SS&C Sylvan:
complete setup 4 environments including network and security considerations
follow internal standards and workflows
planning and controlling all deployment processes
integration of the application into all environments
ETL: enhance data feed with tatial asset allocation (taa) and performance tuning

9/2006 – 9/2008

Application Manager for SS&C Trade Thru (OTC Derivates)
Requirement engineering for:
adoption to new banking infra structure (multi tenant, reconciliation, payment system adoption, booking system adoption)
design of a generic booking adapter and an extraction tool
redesign of 10 data feeds
project initiation
project staffing

2/2005 – 5/2006

Design and implementation of an MIS for performance measurement (on base of kpi) of relation ship managers:
etl, kpi
implementation of reports
multidimension preparation of data (olap)
deployment processec
data and system migrations

9/2004 – 1/2005

Stabilization EKIP: implementation of several reports with SQR
Basel II Migration: end of year processing, technical workflows

5/2003 – 6/2004

redesign of a hospital information system
Database system independent solution (Oracle, SQL Server)
Dispose old compatibility structures
Design with Sybase PowerDesigner 9.5 (CDM and PDM)
Data migration planning and testing (very high database size)
Definition of standards and typing (base, meta, catalogues, relation data, ..)
Migration of older databases, data transformations
Conversion of catalogues (DRG, ICD,..)
Business modelling Use cases
Replacement of all business keys with numerical IDs and remove of compatibility objects

10/2002 – 5/2003

Launching of INFOR.COM:
design of several documents and implementation within Crystal Report
Database support

9/2001 – 7/2002

Implementation with Oracle Case, Forms, Reports
Realization of access permissions
and more

9/1991 – 3/1998

Technical affaires of an application system for special waste controlling
Work in comprehensive workgroup to develop the application
Procurement, bid invitations and execution
Leading of an IT group (up to 6 co-workers)
Formular design, Migration of several databases, Testing, quality assurance
Management for several projects