Independent Senior and Management Consultant, Senior Technical Consultant

Project: Risk Management in Analytical Processing (APR) for Data Warehouse
(DWH) and BI Services

Role: Senior Business Analyst & later additionally Senior Project Manager

* Analysed and led the solution finding process for identified risk
and action items in the corporate DWH and APR infrastructure
* Designed document structure in SharePoint for documenting
the analysis results and evidences of the Risk and Action
Items
Tasks: * Defined data structures for Master and Reference Data

Management
* Defined document workflow for the integration of risk items into
the corresponding documents
* Challenged and co-developed the concept for software

CV_PascalWalz_RE&SWArch_V058.docx Page 12 of 27




component inventory system (i-SAC) for the corporate DWH
and APR infrastructure
* Worked together with software architect to "cut" software
components within APR to support the APR software
development life cycle (SDLC)
* Led a team of highly skilled developers and managed the
project i-SAC for Data Sourcing Framework (DSF) and its
technical frameworks, called i-SAC@TFW
* Led the analysis and documentation task to elicit the
requirements for i-SAC@TFW in order to operate within i-SAC
environment
* Led the IT specification task for i-SAC@TFW

* Delivered stakeholder communication

* Instrumentalized i-SAC for the development and deployment
teams

Methods/Tools: Essential Systems Analysis, SDLC (RUP Variant); MS Office,
SharePoint, Enterprise Architect by Sparx Systems

Project: International risk and compliance application and data warehouse
(DWH)

Role: Senior Business Analyst




CV_PascalWalz_RE&SWArch_V058.docx Page 16 of 27




Tasks: Authored a specification of requirements for an international risk and
compliance application and DWH
* Developed IT Strategy, starting from the UBS enterprise strategy
to evaluating third party solutions, which finally led to the solution
package Fortent.
* Developed strategic scenarios of the Anti Money Laundry (AML)
application of UBS Switzerland by means of the AML software by
Fortent:
o Designed extensive test cases
o Supported the development of highly complex AML
rules (customer and transaction based): rule-based
development within Fortent
o Created highly complex and sophisticated SQL
scripts
Developed a conceptual data model for the DWH as the crucial
component including both, the Swiss model and an international data
model of UBS from operative data:
* Analysed SWIFT messages
* Compared an existing internationally deployed UBS data model
to extract relevant payment information Developed several fully
dressed use cases to gather the required AML-related data fields
* Supported the extension of the original project focus being anti
money laundering (AML) to enhanced risk and compliance
applications such as fraud detection (respecting Sarbanes-Oxley
(SOX) requirements) and fraud suitability analysis
* Developed a concept for a comprehensive business event model
to react on very complex fraud detection scenarios

Methods/Tools: Data modelling for DWH, AML, SOX; PowerDesigner, MS Office, Fortent
(Searchspace), SQL, SQL Navigator

Project: Set-up a holding structure for a consulting and software company.

Role: Lead Senior Business Analyst and Lead Senior Architect

* Advised on and influenced business strategy

* Advised on the conception and evaluation of a software stack -
based on open source - for front banking applications
Tasks: * Analysed software product for insurances and advised on domain
models
* Analysed software product for insurance and advised on software
architecture

Strategy Analysis, Domain Modelling, Modelling for a Service Oriented
Methods/Tools: Architecture (SOA); MS Office; BPMS Tools Activiti and Stardust,
Enterprise Architect by Sparx Systems

Was instrumental in the development of a global Data Mart which
transformed several local non-conformant analytical solutions into one
Project: global platform. This platform was planned to centralize data and
business logic while retaining analytical flexibility. Conformity to security
and IT architectural standards was a further goal.

Role: Lead Senior Business Analyst (Led a team of three highly skilled
business analysts)

* Analysed data from operational banking system (Olympic and
Host)
* Elicited and documented data requirements for Data Mart
(several hundred data fields)
* Elicited and documented functional and quality requirements for
Data Mart
Tasks: * Designed part of the conceptual data model, including models
and ontologies for financial instruments as well fact and
dimensional models
* Advised in Master and Reference Data Management

* Documented data enrichments from static and reference data
* Developed hierarchy and categorization for financial instrument
types
* Developed and documented rules for data population and

CV_PascalWalz_RE&SWArch_V058.docx Page 11 of 27




derived data fields
* Suggested concept for data temporality in Data Mart (Star
Schema)
* Co-Developed test concept and test cases for Data Mart

* Co-Developed security concept for data access in Data Mart

* Suggested concept for data governance as a data foundation for
Data Mart

time)

Role: Senior Requirements Engineer

Project: Developed an essential and conceptual model for "Foreign Account Tax
Compliance Act (FATCA)": Reporting requirements in addition to
reporting of foreign financial assets to the US Treasury Department.

* Analysed document with the "Final Regulations", authored by the
"Department of the Treasury"
Tasks: * Extracted static model structure as an information model

* Extracted dynamic model structure as business rules

Methods/Tools: Essential Systems Analysis; MS Office, Enterprise Architect by Sparx
Systems

November 2011 - Sabbatical leave
March 2012




October 2011 - International Bank (CS, Risk, Finance & Corporate Systems IT,
November 2011 Zürich), Switzerland
(part-time)
Project: Suitability Monitoring
Role: Senior Requirements Engineer

* Advised the formalization of Monitoring Controls to be used in
reporting
* Developed data dictionary for data fields used in the Monitoring
Tasks: Controls
* Formulated business rules to support the Monitoring Controls

* Defined data structures for Master and Reference Data
Management

Methods/Tools: Essential Systems Analysis; MS Excel

CV_PascalWalz_RE&SWArch_V058.docx Page 13 of 27




October 2011 Switzerland

Securities Intelligence - Optimizing the Sales Credit Calculation
Project: Processing for trades in the context of an international data warehouse
(DWH) program and a Swiss local DWH

Role: Senior Requirements Engineer & later Senior Solution Architect

* Supported the project management in setting up the
requirements engineering tasks
* Developed a meta data model to document the data feeds with
their data fields and data flows
* Defined and set up a way to gather information from several
distributed data feeds
* Formalized and documented formulas for the sales credit
calculation
* Documented and structured data enrichments
Tasks: * Documented and structured business requirements in a business
requirements specification
* Developed an architecture and a design documents for the data
warehouse
* Developed life cycle models for trades originating from several
data feeds for alignment in the local DHW
* Developed ETL logic for the local DWH

* Analysed and documented two Sales Credit Calculation systems
which would eventually both be decommissioned by the local
DWH

Data modelling for DHWs, Temporality Data Modelling, Structured
Methods/Tools: Interviewing, DWH architecting; MS Office, SharePoint, MS Access,
Oracle 11g, Toad for Oracle, PL-SQL, Enterprise Architect by Sparx
Systems, SAP BusinessObjects

Project: Evaluation of two solution concepts to associate financial instruments to
markets for portfolio benchmarks

Role: Senior Business Analyst

* Supported the business and IT side in finding a common solution
for portfolio benchmarking and reporting by modelling two
alternatives
Tasks: * Investigated several options for portfolio benchmarks

* Developed the software requirements specification for these
portfolio benchmarks models

CV_PascalWalz_RE&SWArch_V058.docx Page 14 of 27




* Worked in a CMMI Level 3 environment

Methods/Tools: CMMI Level 3, Essential Systems Analysis, Structured Interviewing;
UML2 Rational Tool Suite, MS Office, SharePoint, Java EE

Project: Output Management System and application integration

Role: Senior Business Analyst & Senior Requirements Engineer

* Had the functional lead for team of five to six Java developers

* Collaboration both in the conception and in the IT specification
for the client output management system, which supplied - within
a modern service-oriented inter-banking application - the
complete functionality as formatting the output according to
templates, creating output as XML files, and controlling output
channels. In this context, a service-oriented architecture was also
created within this output system such that the services of the
architecture were made available to the components of the interbanking
solution via events
* Developed IT Strategy for the Output Management System from
the overall RTC enterprise strategy of their main software product
IBIS 3G
* Worked extensively with IT program and IT project management.

* A third party software application generating client output had to
Tasks: be integrated

Special challenges were:
* Consistent requirements engineering for the processes and the
events generating about 100 client output document types
* Integration of structured data records into semi-structured
electronic output documents
* Sophisticated event design in a way that the client output
became highly configurable for complex business processes (e.
g. corporate actions)
* Integration of several applications via web services, e.g. Legando
Corporate Action
* Created and monitored quality standards for output management
architecture
* Consistent data field mapping between the external applications
and the client output management system

Content and Document Management, Essential Systems Analysis,
Methods/Tools: Structured Interviewing; IBIS 3G, MS Office, SharePoint, Altova Tool
Suite, Java EE, SQL Navigator Legando Corporate Actions, Borland

Project: Credit Risk Control Data Warehouse International (17 locations world
wide), Model Driven Change Management

Role: Senior Business Analyst

* Initiated and worked on a project with IT project management
and project sponsor on how the modelling approach could be
used to improve documentation and change management in data
warehouses. This procedure led to Model Driven Change
Management (MDCM). In contrast to other approaches, MDCM
focused on the business decisions and the derived requirements,
rather than implementation specific details. Additionally the
Sarbanes-Oxley (SOX) regulations had to be respected in the
Tasks: context of loans.
* MDCM has been developed initially for the risk & compliance
data warehouse of UBS Switzerland and is now applied for the
credit risk data warehouse of 17 international UBS locations.
Leveraged the existing tools in order to model not only various
viewpoints on data (business people, implementation, local
views, transaction and analysis of the system's view), but also
the various business decisions and their connections to business
rules, data mappings, and interface definitions.

Methods/Tools: Essential Systems Analysis, Model-Driven Design, Structured
Interviewing; MS Office, Sybase PowerDesigner, Excel VB, SQL

Project: Solution in the area of logistics for vehicle and cargo tracking using data
from a geographical information system (GIS)

Role: Co-founder / Chief IT Architect / Senior Enterprise Architect

* Led the integration of complex business logic into GIS data using
the method of model-driven software development
Tasks: * Developed product strategy for vehicle and cargo tracking
* Developed software architecture
* Developed object and data model


CV_PascalWalz_RE&SWArch_V058.docx Page 17 of 27




* Was involved in the software development

Methods/Tools: Essential Systems Analysis, Data and Object Modelling, RUP; MS
Office, Enterprise Architect by Sparx Systems; Ruby On Rails, MySQL

time, June - Switzerland

CV_PascalWalz_RE&SWArch_V058.docx Page 18 of 27




September)

Project: Architecture Review and Enhancement

Role: Senior Software Architect

* Led regular architecture and design reviews
Tasks: * Enhanced software architecture
* Enhanced object and data model
* Was involved in the software development

Methods/Tools: Essential Systems Analysis; MS Office, C++, Oracle DBMS

Project: Implementation of a new ERP solution for a car importation business

Role: Senior Business Analyst & Technical Component Project Leader

* Was involved in the development of the component
"Replacement Parts" for a new ERP solution for the management
of car importation, out of two existing legacy systems
* Reverse engineered the functionality of these two legacy
systems
* Developed several fully dressed use cases, part of which were
highly complex, modelled as UML use case diagrams and
structured prose text
* Developed the requirements as well as the conceptual data and
class model from these two existing legacy systems, modelled as
UML class diagrams
* Was involved in the specification of dozens of highly complex
forms
Tasks: * Was involved in the specification of several complex state

transitions, modelled as UML state diagrams
* Was involved in the specification of several complex business
processes for the order entry, modelled as UML activity and
interaction diagrams
* Formulated several complex business rules in OCL to ease
implementation in PL-SQL
* Developed several SQL views to extract key performance
indicator numbers
* Conducted regular audits, design reviews, and walk-throughs
* Was architecturally involved in the specification of a bi-directional
interface for an existing third party warehouse management
system

Methods/Tools: Essential Systems Analysis, UML, Data and Object Modelling, RUP;
QDesigner, OCL, Oracle, PL-SQL, MS Office

Project: Enterprise Architecture

Role: Senior Enterprise Architect

* Developed the initial part of a conceptual architectural model for
the payment PostFinance services to be aligned and integrated
within the enterprise architecture
* Represented the IT strategy and architecture for the payment
PostFinance services
* Communicated IT architecture regularly to different project
stakeholders (architects and designers, end users, and sponsors)
Tasks: * Defined quality attributes: Business Qualities (time to market,
cost and benefit. projected lifetime of the system) and
Architecture Qualities (conceptual integrity, correctness and
completeness, buildability)
* Defined data structures for Master and Reference Data
Management
* Documented and extended payments application landscape
* Reconciled application architecture with outbound systems
* Used part of the TOGAF framework

Methods/Tools: TOGAF framework, Essential Systems Analysis, Structured Interviewing;
MS Office, SQL Navigator, Java 2 EE

Infrastructure project for the new strategic company-wide accounting
Project: platform, adopted by the company management. Interface between
infrastructure and strategic company-wide accounting platform realized

CV_PascalWalz_RE&SWArch_V058.docx Page 19 of 27




as a data warehouse (DWH).

Role: Senior Business Analyst & later Senior Solution Architect

* Worked out the conception and specification for data sourcing
applications feeding the company-wide accounting system.
Worked closely with IT and business project management
* Was involved in the development of a global partner model for
Tasks: global customers ("Partner Shared")

* Supported and reviewed the development of a contingency plan
* Developed data models supporting bi-temporality
* Specified interfaces for both reporting and DWH applications

Methods/Tools: DWH and (Temporality) Data Modelling; agile development; MS Office,
SQL Navigator, SSP Tools, Oracle Tools, PL-SQL, Perl

Project: Conception of a standard application software for the administration of
fire brigades on the request of fire insurances and at community levels

Role: Senior Software Architect & Senior Requirements Engineer

* Performed requirements engineering
* Applied and customized software development process: RUP
* Designed object and data model
Tasks: * Designed software architecture
* Was involved in the software development by using the Steps
Software Factory
* Was involved in software testing
* Wrote software documentation

Essential Systems Analysis, Data and Object Modelling; RUP; MS
Methods/Tools: Office, Steps Software Factory from Step Ahead Software, .Net, Visual
Basic 6

Project: Conception of a document management system / Cooperation in the
fundamentals concerning software aspects

(ex Sandoz, Clariant and Bayer Schering Pharma)