1 von 91.893 IT- und Engineering-Profilen

Fachlicher Schwerpunkt dieses Freiberuflers

Projektleitung, Migration, Architektur, DB2, SQL, Performance

verfügbar ab
01.01.2018
verfügbar zu
100 %
davon vor Ort
100 %
PLZ-Gebiet, Land

D0

D1

D2

D3

D4

D5

D6

D7

D8

D9

Österreich

Schweiz

Einsatzort unbestimmt

Städte
München
500 km

Projekthistorie

05/2016 – today    

Client: eigene Firma [Name auf Anfrage], Wangen


05/2016 – 11/2017    

Client: Mercedes Benz Financial Services AG, Zurich

Role: Migration Expert, Project Leader & Business Analyst

  • Migrate over 280’000 leasing contracts from a 20 years old legacy Client Relationship & Contract Management System
  • Define cleansing work packages to guarantee correct consistent data transformation
  • Organize regular workshops & meetings with business representatives and software provider
  • Gathering business requirements to implement into the new system
  • Accountable for the migrated data in the new system
  • Setting up the appropriate testing strategies among testing team

 


2013 – 2016                 

Client: CREDIT SUISSE, Zurich                                                                                     

Role: Vice President, Migration Expert, Solution Architect, Project & Stream Lead

  • Redesign of the very complex existing ELAR (electronical document archive) data base architecture with 10’000 Tables, 50 billion of documents and 200 TB of data
  • With the DB refactoring we could cut the yearly running costs from 11 to 7 million and in the same time increase stability and quality of the system
  • Coordinate work packages with our on-/off-shoring partner Cognizant as well for our local team
  • Responsible for the migration of all data within two years
  • Conduct proactively strategies with our sponsor to improve usability of our system
  • Manage and coordinate system stability with internal and external support teams, i.e. Storage Management, Business Owner, Program Management, Performance Management, DB2 Engineering, PTG, Operation Supervisor, Line Management, Requirement Engineering
  • Report regularly to our sponsor and Senior Management the progress of our projects and keep tracking issues regarding milestones, deadline and budget
  • Introduce appropriate measures in case of deviations from the project plan
  • Support different Tax Taskforces
  • Coach team members in establishing best performant SQL queries & strategies
  • Supporting Anti Money Laundering/Flow of Funds (“Geldfluss” over the whole bank) team for further application improvement and as reporting specialist. This application is a significant data provider of DWH & MIS

2004 – 2013

Client: eigene Firma [Name auf Anfrage], Freienbach


2010 – 2013              

Client: Credit Suisse, Zurich                                                                                        

Role: Migration Expert, Solution Architect, Project & Stream Lead

  • External mandate, same content as in the preceding description

2009 – 2009              

Client: State Pension Fund (AHV), Geneva                                        

Role: Data base administrator

  • Supported the development team in implementing new access strategy
  • Improved the performance of DB access
  • Developed very complex SQL for the internal automated reporting system

2004 – 2009              

Client: UBS, Zurich                                                                                                      

Role: Solution Architect, Chief Programmer

  • Designed a complex interface between server and client by using XML and UML for the complete new designed Payment system
  • Implemented new Back-end transactions for Client Positions (Assets & Liabilities)
  • Supported the team members as Chief Programmer
  • Evaluated new strategy, how to improve response time for the new online requests

1996 – 2004                 

Client: ODZ, Hünikon  


2001 – 2004              

Client: Credit Suisse, Zurich

Role: Solution Architect, Data base administrator

  • Redesigned the existing Database Flow of Funds with introducing an automatic archive system
  • Supported the team members as DBA
  • Improved and optimized the batch processing of the application Anti Money Laundering

2000 – 2001              

Client: Migros Genossenschaft, Zurich                                          

Role: Software Engineer

  • Implemented a new marketing information GUI
  • Analysed new SAP interfaces
  • Extensive usage of PL/SQL on Oracle

1998 – 2000              

Client: Zurich Insurance, Zurich                                                        

Role: Software Engineer

  • Main test responsible for Y2K (2000) in the Life system
  • Coordinated the deployment with different stakeholders

1996 – 1998              

Client: Zürcher Kantonalbank. Zurich                                              

Role: Software Engineer

  • Responsible for the implementation of a new SAP interface
  • Responsible for the implementation of VAT (MWST) in the accounting

1984 – 1995                 

Client: SWISS REINSURANCE, Zurich                                                               

Role: Staff, Software Engineer, Project Leader

                          

  • Implemented a new financial accounting/main ledger system with the new DB DB2
  • Implemented an aggregated view of client contracts in the Life system

1992 – 1994                 

Client: SWISS REINSURANCE, Melbourne                                       

Role: Staff, Software Engineer

  • Implemented a new Life system with DB DB2

1981 – 1983                 

Client: ALLIANZ INSURANCE (formerly Helvetia Unfall), Zurich     

Role: Staff, Software Engineer

 

  • In-house training program as Solution Engineer
  • Started with testing and developing of new programs

Kompetenzen

Sprachkenntnisse
English
Fluent
French
Conversant
German
Native
Italian
Native

Produkte / Standards / Erfahrungen

Mindset and personal behaviour

I am an analytical thinker with exceptional problem-solving skills and logical approach. In my last two mandates my core tasks were to consolidate the existing data and analyse the business requirements, in order to bring the raw data into the next level of business need. With determinacy and strong focused mindset, I was able to implement an improved solution by involving different stakeholders and amalgamate the heterogeneous business requirements to an overall solution. At the same time, we improved operational efficiency.

As a multilingual communicator with strong influencing abilities, I am confident presenting across organisational structures. My strong sense of responsibility and teamwork combined with leadership and ownership make me an integrator and motivator.

Technical skills

Data, Object and Interface Modelling - Expert

DB2, SQL, QMF, BMC, FileAid, Startool, MainView, TOAD - Expert

MVS, z/OS, TSO/ISPF, JCL, SDSF - Expert

Cobol, Delta - Expert

IMS/DB & DC - Advanced

PL/1, REXX - Advanced

Debugging tools: Smarttest, Xpediter, Omegamon, Strobe, IBM Debugger, Easytrieve - Advanced

ChangeMan (version control), OPC & ControlM (job scheduler) - Advanced

CICS, AFP, SDF - Advanced

UML/XML - Intermediate

Test Director & HP Quality Center/ALM, JIRA - Intermediate

Unix, Javascript & HTML - Intermediate

Oracle & PL/SQL - Intermediate


Ausbildungshistorie

2016                     

Business Data Modelling Zurich                                              

TwentyEighty Strategy Execution

2015                     

Estimating and Planning Agile Projects Zurich   

Certified by ESI International

2014                     

SCRUM Practitioner Zurich                                        

Certified by Scaled Agile Academy

2003                     

Database Administration IBM DB2, Nice             

Certified as DBA IBM DB2

1987 – 1990       

IT Business Engineer School, Zurich                       

State-certified as IT Engineer in Economics

1978 – 1981       

Higher Commercial School, Zürich                          

State-certified in Commercial

×
×