Urs Müller

Design and development of SICAF, the new strategic DWH Integration, Calculation & Reporting Platform for Finance Department, spanning 2 projects ... - IFRS 17 International Financial Reporting Standard 2017 - LARS Life Actuarial Reserving System Data architecture, data modeling for staging/integration/calculation/reporting components, reference data & business rules & assumptions design, metadata & automation design, workflow & runtime configuration design, automated data quality checks, testing automation

Data architecture, data modeling, reference data design for Smart Data DWH. Consulting in modeling and architecture topics, support in the development and realization of the new strategic DWH for CSS as a replacement for the legacy DWH

Analysis and implementation of requirements for regulatory reporting (SNB, FINMA) for Switzerland and BJB Group. Integration of financial instrument master data

Data Vault 2.0 PoC to validate the DV 2.0 modelling methodology, agile/SCRUM project management approach. SIA DWH project to build the new strategic reporting platform for Management Accounting, Risk & Finance applying DV 2.0 methodology and metadata based automation. SIA acts as a highly agile integration layer for tactical/legacy sources as well as for golden sources . The approach allows the seamless integration of raw with harmonized/refined data = combining or comparing reports of multiple data areas.

Core responsibility for data architecture & data modeling of the new Private Banking & Wealth Management DHW. This DWH serves as as consolidated global data base for analytical platforms and is aligned with ex-isting bank’s internal reference data models from various data domains. The integration covers all analytically relevant feeds from CS Swiss Banking Platform SBIP as well as feeds of the international CS locations.

Conceptual design and lead solution architect of a global data platform DWH for international locations. The multi layer DWH solution supports local & global MIS reporting and further data delivery requirements. Successful implementation and rollout for Singapore, Hong Kong, London, Guernsey, Gibraltar and USA. Core responsabilities for requirements analysis, solution concepts & architecture, data modelling, mapping specifications, testing methodologies, etc.

Modification of a local finance & reporting mart to establish a global and scalable architecture including redesign and reengineering of the data mart model, architecture and ETL processes / report and interface design for credit risk and credit applications iRSC and iLOAD / setup & rollout (Frankfurt) of the GSM DWH with sourcing from Olympic as part of the GOAL'06 project (new accounting and operations platform for UBS Deutschland AG)

Business analysis, concept and database administration incl. release management and deployment / concept for meta data management and history management/ interfaces & meta data management for data provider WM

Consulting and business analysis & hands on supervision during the implementation of the securities data application FIVS (Module of the GEOS securities administration system) / concept, setup and customizing of the baseline version / guidelines for data input including use cases / gap analysis & coordination of change requests / product support &trouble shooting / establish concept for FIVS outbound interface

Consulting, business analysis, project management and conceptional work; project management for the implementation of the VDF feed from Telekurs Financial Ltd / concept for data approval framework, generic inbound interface, housekeeping processes, financial static data / analysis of change requests to adapt the GEOS/FIVS software to Swiss banking standards & regulatory requirements/ support for Swiss clients regarding gap analysis, requirement engineering and change request management.

Project management, architecture design, analysis & development; for FX back office system (B+S) interfaces, new SWX release requirements, setup of Kondor+, credit application authentication and risk evaluation framework modules

Analysis and development; development of an interface for the client server application CERES thru Oracle-gateway and EDA/SQL to the respective LCVS (Laboratory chemical supply systems) IMS- and DB/2 host databases as well as integration of the existing order system, maintenance and further development of existing LCVS, LABCHEM and PERIS applications

Business analysis of DWH framework components to extract and transform data from various sources into a relational DWH environment, various modules for securities administration, portfolio management, securities trading, safekeeping of securities, SWIFT, SIS/SECOM, Telekurs Titelbulletin