Start Survey

Course Overview

Advanced Report Writing (RWA)
Objectives
Upon successful completion of this course every participant will:
  • thoroughly comprehend the concept of the Report Writer Engine
  • take advantage of the functionality offered by the task framework
  • group and sort in reports by almost any criteria required
  • master aggregation functions of a report datamart
  • be able to apply the vector concept
  • create lean and performing reports
  • bring various layout features offered by Report Writer into action
Course content
Introduction
  • report writer layers of the report engine
  • interactions between the report writer layers
  • Task Definition and Task Templates
  • the importance of choosing the right task definition
  • important task definitions in connection with business requirements
 
Grouping and Sorting
  • group and sort reports by almost any criteria required
  • master sorting functionality provided for flat reports
 
Aggregation and Consolidation
  • apply aggregation and assignment functions offered by Avaloq
  • take advantage of the resolution sequence of fields in the datamart
 
Layout Functionality
  • apply the latest layout functionality
  • understand the concept and limitations of extended reports
 
Best Practice
  • execute reports from Avaloq script
  • point out report specific performance traps
Target audience
Avaloq Parameterisation specialists who specify or develop reports basic reports.
Duration
2 days
Prerequisites
Before participating in this course, prior attendance of the course “Fundamentals of Avaloq Customisation (ACP)” is mandatory.
Avaloq Foundation (FOU)
Objectives
Upon successful completion of this course every participant will know:
  • Be familiar with the ABS user interface, ribbon tabs, sub windows and icons
  • Be familiar with the Avaloq Navigator, order books and desks
  • Understand main concepts and the basic object model.
  • Be able to create a basic client relationship.
  • Be able to enter standard transactions.
Course content
General overview of the interface (application)
Ribbons, tabs, sub windows and icons
Avaloq Navigator, order books, desks
Avaloq Object Model and object attributes
Form structure and design as well as desks
Workflow and context actions
Target audience
Everybody who is interested in the Avaloq Banking System
Duration
2 – 4 hours of self-study
We recommend that participants start the self-study phase no later than 10 days prior to the course. Please note that to be awarded full education points, all self-study exercises must be completed
 
4 – 5 hours of virtual classroom training
Prerequisites
Banking knowledge recommended
Follow-up courses
Please see the Avaloq course catalogue
Best Practices for Report Writer (BRW)
Objectives
Upon successful completion of this course, participants will be able to:
  • comprehend the concept of the Report Writer Engine and its parts
  • understand the functionality offered by the task framework
  • group and sort reports by almost any criteria required
  • master aggregation functions of a report datamart
  • apply the vector concept
  • create lean and performing reports
  • bring various layout features offered by Report Writer into action
Target audience
Avaloq customisation specialists who specify or develop reports.
 
Duration
2 – 4 hours of self-study
We recommend that participants start the self-study phase no later than 10 days prior to the course. Please note that to be awarded full education points, all self-study exercises must be completed
 
4 – 5 hours of virtual classroom training
Prerequisites
Prior attendance of the course “Fundamentals of Avaloq Customisation” is mandatory.
Follow-up courses
Mastering Advanced Report Writer Techniques (ASC)
Best Practices for using Avaloq Script (BSC)
Objectives
Upon successful completion of this course every participant will:
  • Understand the coding principles.
  • Be able to write code which is accepted by code auditors.
  • Apply the “do’s” and avoid the “don’ts”
Course content
Avaloq Script structure - overview and examples
Coding Guidelines – how to write ‘audit-proof’ code
Coding Guidelines – how to write ‘performant’ code
Report Writer considerations
Target audience
All Avaloq Certified Professionals who have contact with Avaloq Script on a regular basis
Duration
2 – 4 hours of self-study
We recommend that participants start the self-study phase no later than 10 days prior to the course. Please note that to be awarded full education points, all self-study exercises must be completed
 
4 – 5 hours of virtual classroom training
Prerequisites
Before participating in this course, prior attendance of the course “Fundamentals of Avaloq Customisation (ACP)” is mandatory.
Follow-up courses
Mastering Advanced Avaloq Script Techniques (ASC)
Cash Reconciliation (REC)
Objectives
Upon successful completion of this course every participant will:
  • Recognize the importance of the regular reconciliation
  • Understand the interaction between ABS and external systems
  • Learn the concepts of the reconciliation solution
  • Get in touch with orders books used in daily business
  • Get known the tools used to support the investigation process
Course content
Cash Reconciliation
  • Accounts, account types and bookings
  • Transactions and messages
  • Concepts (Technical aspects)
  • Business Functionalities in ABS
Target audience
Key business users - reconciliation agents who work in a back office as well as reconciliation agents with supervisory capacities – who deal with reconciliation.
Duration
2 – 4 hours of self-study
We recommend that participants start the self-study phase no later than 10 days prior to the course. Please note that to be awarded full education points, all self-study exercises must be completed
 
4 – 5 hours of virtual classroom training
Prerequisites
Before participating in this course, participants must have either attended the course “Avaloq Foundation (FOU)” or have equivalent knowledge and experience with the Avaloq Banking System.
Collateral Management (CLM)
Objectives
Upon successful completion of this course every participant will:
  • Set up collateral agreements for counterparties and clients
  • Use the collateral management desk for daily margining with counterparties
  • Use the collateral availability desk to have a detailed overview of current and projected collateral available
  • Use the lending availability desk to see all lendable assets
  • Obtain specific and qualified information by browsing Order Books and Reports
  • Use the collateral movement transaction to transfer multiple collateral items
Course content
Collateral Management model within Avaloq
 
Avaloq CLTM-relevant business types
  • Set-up of customised collateral agreements
  • Evaluation and monitoring of exposure in CLTM Desk
  • Collateral Movement, triggered by other business types (e.g. REPO), margin call or manually
 
Collateral Maintenance
  • CLTM Desk for daily margining
  • CLTM Desk with projection (upcoming collateral movements)
  • Calculation & automatic payment of interest for cash collateral positions
 
Information provisioning: CLTM Reports & Order books
 
CLTM integration with other Avaloq modules, i.e.:
  • Securities Lending and Borrowing (SLB)
  • Repurchase Agreements (REPO)
  • Financing Engine
  • Settlement
  • Bookings & Balancing
Target audience
Key Business Users and Implementation (Migration) Partners
Duration
1 day
Prerequisites
Before participating in this course, participants must have either attended the course “Avaloq Foundation (FOU)” or have equivalent knowledge and experience with the Avaloq Banking System.
Additionally, participants should have knowledge in the area of Collateral Management.
Follow-up courses
Securities Lending and Borrowing (SLB)
Repo Contract (REP)
Concepts of Message Processing (OMP)
Objectives
Upon successful completion of this course every participant will know:
  • The concept of Avaloq message processing
  • How to manage the different message types
  • The elements and customisation areas of the Avaloq Message Interface (AMI) Framework and their purpose
  • How to debug and troubleshoot the processing of messages
Course content
The architecture of the Avaloq Message Interface
The concept and tools of the message processing
Operation aspects and trouble shooting
The customisation areas of the Avaloq Message Interface
Target audience
Members of IT Operations at customer or partner sites. Also application managers and application operation managers as well as customisation specialists.
Duration
2 – 4 hours of self-study
We recommend that participants start the self-study phase no later than 10 days prior to the course. Please note that to be awarded full education points, all self-study exercises must be completed
 
4 – 5 hours of virtual classroom training
Prerequisites
Before participating in this course, participants must have knowledge in the following areas:
  • Toad or SQL Developer
  • Understanding of simple PL/SQL statements
  • Attended to the course "Fundamentals of Avaloq Application Operations" (OAO)
Follow-up courses
Monitoring and Log Administration (OML)
End-of-Period Concepts (OEP)
Concepts of Output Management (OOM)
Concepts of Output Management (OOM)
Objectives
Upon successful completion of this course every participant will know:
  • The concept of Avaloq output management
  • How to create and track the different output types
  • The elements and customisation areas of Avaloq output management and their purpose
  • How to debug and troubleshoot the processing of output
Course content
The elements of Avaloq output management
  • Mailing Products
  • Mailing Instructions
  • Mailing Composition and Streaming Rules
  • Mail Generation
  • Mail Pools
  • Mail Streaming
  • Mail Channels
  • Mail Despatching
 
The process of output generation including mailing tasks and process queues
 
The customisation areas of Avaloq output management
 
Operation aspects of the output processing
Target audience
Members of IT Operations organisations at customers or partners side. Also application managers and application operation managers.
Duration
2 – 4 hours of self-study
We recommend that participants start the self-study phase no later than 10 days prior to the course. Please note that to be awarded full education points, all self-study exercises must be completed
 
4 – 5 hours of virtual classroom training
Prerequisites
Before participating in this course, participants must have either attended the course “Fundamentals of Avaloq Application Operations (OAO)” or have equivalent knowledge and experience with the Avaloq Banking System.
Additionally, participants should have knowledge in the area of Toad or SQL developer; have an understanding of simple PL/SQL statements as well as basic knowledge of Avaloq code tables.
Follow-up courses
Monitoring and Log Administration (OML)
End-of-Period Concepts (OEP)
Position- and Bookkeeping (PKP)
System Performance (OSP)
Credit Modelling (CFM)
Objectives
Upon successful completion of this course every participant will:
  • Understand the concept of the Credit Application module
  • Know the different modelling features of the main credit relevant Positions (Limit, Loan and Collaterals)
  • Understand how the different credit relevant Positions are related to each other
Course content
Introduction to Credit Application
Credit Application with Filter Concept
Modelling features of the Limit Position
Modelling features of the Loan Position
Real Security and Realty Object
Other Security Modelling
Credit Application related Use Cases
Target audience
Avaloq Certified Professionals and/or Avaloq End Users working/interested in the Credit area
Duration
3 – 4 hours of self-study
We recommend that participants start the self-study phase no later than 10 days prior to the course. Please note that to be awarded full education points, all self-study exercises must be completed
 
4 – 5 hours of virtual classroom training
Prerequisites
Participants should have a general Avaloq and business know-how regarding credits.
Customising the Avaloq Banking Suite using ASMD - Avaloq Solution Model Development (MDE)
Objectives
Upon successful completion of this course every participant will:
  • Understand the functionality provided by ASMD
  • Be able to use ASMD features to be more efficient, as well as to produce good-quality code according to Avaloq standards
Course content
Introduction to ASMD concepts
Overview of the ASMD Context
ASMD-related documentation
Implementing Avaloq Script
Content assist templates
Analysing errors in the source code
Viewing and editing code tables
Using the Graphical Editor for workflows
Customising the ASMD environment using Preferences
Advanced usage of the ASMD Context
Target audience
Customisation experts
Duration
2 – 4 hours of self-study
We recommend that participants start the self-study phase no later than 10 days prior to the course. Please note that to be awarded full education points, all self-study exercises must be completed
 
4 – 5 hours of virtual classroom training
Prerequisites
Before participating in this course, participants must have either attended the course “Avaloq Foundation (FOU)” or have equivalent knowledge and experience with the Avaloq Banking Suite.
Dealing with complex Corporate Actions (CAC)
Objectives
Upon successful completion of this course every participant will:
  • Be able to treat complex Corporate Actions efficiently and correctly
Course content
Complex Corporate Actions
SWIFT 56n, Task 890, Business Bus
Cost propagation / Cost aggregation
Cost price adjustments
Taxes (EUSD, QI, Withholding Taxes, Swiss Stamp tax, IUP)
Order books, reports, work-items
Generation of SECEVT orders
Working with multi business units
Target audience
This course is aimed at corporate actions staff who already have experience with the Avaloq SECEVT-module.
Duration
1 day
Prerequisites
Before participating in this course, participants must have either attended the course “Avaloq Foundation (FOU)” or have equivalent knowledge and experience with the Avaloq Banking System.
End-of-Period Concepts (OEP)
Objectives
Upon successful completion of this course every participant will know:
  • The purpose of the typical tasks within end-of-period (EOP) processing
  • The most important topics to manage different timezones within end-of-period (EOP) processing
  • How to use the job and EoP interfaces
  • How to operate the processing of jobs regularly and in exceptional situations
  • How to create and manage jobs with the Avaloq Banking System
Course content
Book date switch
Garbage collection and statistics
Pillars
Imports/exports
MESI aspects
Job management
Job and EoP interface
Target audience
Members of customer or partner IT Operations organisations. Also, application managers and application operation managers.
Prerequisites
We recommend having attended the course "Fundamentals of Avaloq Application Operations (OAO)” previously.
Additionally, participants should have knowledge in the area of Toad or SQL Developer, understanding of simple PL/SQL statements.
 
Follow-up courses
Monitoring and Log Administration (OML)
Concepts of Message Processing (OMP)
Concepts of Output Management (OOM)
Foreign Exchange Management (FXM)
Objectives
Upon successful completion of this course every participant will:
  • understand the functionality of the Foreign Exchange market
  • have a common understanding of the Avaloq concepts in the Foreign Exchange module
  • to be able to process and analyse Foreign Exchange transactions
  • to know, apply, and exchange Avaloq best practice
Course content
Foreign Exchange (FX) Market
FX Management in the Avaloq Banking System
FX Life Cycle Management  
Exchange Rate Calculation
Monitoring of FX Positions
Accounting and Booking
Miscellaneous
Duration
4 – 5 hours of hands-on training and
2 – 4 hours of self-study
Prerequisites
Before participating in this course, participants must have either attended the course “Avaloq Foundation (FOU)” or have equivalent knowledge and experience with the Avaloq Banking Suite.
Fundamentals of Avaloq Application Operations (OAO)
Objectives
Upon successful completion of this course every participant will know:
  • The typical tasks within end of period (EOP) processing
  • How to schedule jobs with the Avaloq Banking System
  • Hot to monitor the elements of the Avaloq Banking System
  • How to analyse log entries
Course content
Tools (Central Services, Task Application
Job Management / End of Period (EOP)
Process Queues
Monitoring
Log analysis
Target audience
Members of IT operations organisations, application managers and application operation managers with no or limited knowledge/experience of Avaloq Application Operations
Duration
4 – 5 hours of hands-on training and
2 – 4 hours of self-study
Prerequisites
Before participating in this course, participants must have basic knowledge in the areas of Toad and SQL Developer as well as understanding of simple PL/SQL statements
Follow-up courses
End-of-Period Concepts (OEP)
Position- and Bookkeeping (PKP)
System Performance (OSP
Fundamentals of Avaloq Customisation (ACP)
Objectives
Get the basic Avaloq know-how to start working in an Avaloq project:
  • First steps with the Avaloq Banking System
  • Fundamentals of Avaloq Customisation
  • Implementation of use cases based on examples
Target audience
Future customisation specialists working on Avaloq customisation, configuration or migration projects.
We strongly suggest that participants bring their own laptop or tablet computer to be able to access course material outside of course hours. Please note that the device must have a USB port.
Duration
15.5 days
Prerequisites
Understanding of IT-related topics (e.g. database concepts, programming know-how, SQL) is required. Basic knowledge of banking is recommended.
Furthermore, participants must be able to read and understand large quantities of documentation written in English.
 
We strongly suggest that participants bring their own laptop or tablet computer to be able to access course material outside of course hours. Please note that the device must have a USB port.
Follow-up courses
A variety of courses are published on
http://www.avaloq.com/solutions/academy/
Fundamentals of Avaloq Customisation (ACP) by Orbium
Objectives
Get the basic Avaloq know-how to start working in an Avaloq project:
  • First steps with the Avaloq Banking System
  • Fundamentals of Avaloq Customisation
  • Implementation of use cases based on examples
Target audience
Future customisation specialists working on Avaloq customisation, configuration or migration projects.
We strongly suggest that participants bring their own laptop or tablet computer to be able to access course material outside of course hours. Please note that the device must have a USB port.
Duration
15.5 days
Prerequisites
Understanding of IT-related topics (e.g. database concepts, programming know-how, SQL) is required. Basic knowledge of banking is recommended.
Furthermore, participants must be able to read and understand large quantities of documentation written in English.
 
We strongly suggest that participants bring their own laptop or tablet computer to be able to access course material outside of course hours. Please note that the device must have a USB port.
Follow-up courses
A variety of courses are published on
http://www.avaloq.com/solutions/academy/
Fundamentals of Credit Functionality Parameterisation (PCF)
Objectives
Upon successful completion of this course every participant will
  • Know the relevant metatypes and objects of credit operation area
  • be able to implement specific parameterisation needs for the objects and metatypes covered in the course
  • know the basic concepts of the interest engine
  • know best practices and how to avoid pitfalls
Course content
Objectmodel & Metatypes (Engines / Basic Concept)
  • Financing Object
  • Metatypes
  • Concept of Financing Engine
  • Pillars & Reports
  •  
Details of Metatypes, Interest model & Pricing
  • Loan Details
  • Modelling & Classification model
  • Booking & Balance rules
  • Interest model
  • Credit processing
Target audience
Parameterisation specialists working in the credit area
Duration
2 days
Prerequisites
Before attending this course, participants must have attended Avaloq Certified Professional (ACP) course.
Knowledge of the Avaloq credit functionality from a business point of view, see course "Working with Credit Functionality" (CFW)
Handling Cashier Operations Functionality (COF)
Objectives
Upon successful completion of this course every participant will:
  • understand the general concepts, functionalities and relations between the business types Cashier Operations (COP), Cashier Management (CMG) and the object Terminal as well as their utilisation
  • take the business decisions for the functional area Cashier Operations considering the dependencies between the available functionalities
  • write a functional concept for the functional area Cashier Operations
  • define the scenario for the usage of the teller safe
Course content
Introduction
  • Relation between COP, CMG, Terminal and Teller Safe
  • Object Modelling of Bank branches
Object Terminal
  • Concepts and Benefits
  • Usage of the object Terminal
Cashier Operations
  • Concepts and Benefits
  • Restrictions and Business Rules
  • Order Types
  • World Money Direct (WMD)
  • Card Reader
  • Sign Base
Cashier Notes Exchange Rates
  • Concepts and Benefits
  • Usage of Cashier Notes Exchange Rates
Business Type Cashier Management (CMG)
  • Concepts and Benefits
  • Usage of Cashier Management
  • CMG Mass Entry
Teller Safe
  • Concepts and Benefits
  • Usage of Teller Safes in COP and CMG
Target audience
Parameterisation specialists and key business users
Duration
1 day
Prerequisites
Before attending this course, participants must have attended course Avaloq Foundation (FOU).
We recommend reading the following guide as a preparation for the course. The guide is published in the Avaloq Community:
Cashier Operations; Business User Guide (ID: 2063)
Follow-up courses
Parameterisation of Functional Area Cashier Operations (COP)
INTRO Online Live Training Introduction
Objectives
After attending this virtual class, participants will:
  • understand the Avaloq Online Live Training method
  • know how to plan for the self-study phase
  • be able to independently use the Online Live Training software, self-study platform, and virtual classroom environment
Course content
Introduction to Avaloq Online Live Training Method
  • Introduction to the self-study learning environment
  • Introduction to the virtual classroom software
  • Guidance on study approaches, theoretical exercise assignments, and exercise upload procedures
Target audience
Mandatory for all first-time Avaloq Online Live Training participants.
Optional for participants who have attended a past Online Live Training course.
Duration
1 hour
Prerequisites
none
Follow-up courses
none
Introduction to Accounting Parameterisation - Brush up (PAF)
Objectives
Upon successful completion of this course, participants will:
  • have a fresh and current view on the concepts around the parameterisation of the Cost-, Book- and Balance Engine.
  • have seen in demonstrations how to parameterise a business case in the cost-, book-, and balance engine.
 
Course content
Cost Engine
  • cost versus Feed in Avaloq
  • cost calculation methods
  • cost concept in Avaloq
  • cost parameterisation
Book Engine
  • object model of a Vostro Relation
  • book engine functionalities
  • booking principles
  • useful things to know before parameterisation of the book engine
  • parameterisation of the book engine
Balance Engine
  • Balancing overview
  • Creation of a chart of accounts in Avaloq
  • Pillar based balancing
  • Parameterisation of the balance engine
 
Target audience
Parameterisers responsible for the implementation of the requirements in the accounting department
Duration
2 days
Prerequisites
Before attending this course, participants must have attended
course Fundamentals of Avaloq Customisation (ACP).
Introduction to Avaloq Portfolio Management (PFM)
Objectives
Upon successful completion of this course every participant will:
  • Understand the portfolio management object model
  • Be able to create and maintain all portfolio management objects
  • Understand the different restriction types available
  • Be able to create, link and evaluate restrictions
Course content
HOBS (Hierarchical Object Breakdown Scheme)
Asset Allocation
Model Portfolio
Benchmark
Index
Investment Policy Statement
7 different restriction types to model any kind of restriction.
Linking restrictions to clients.
Pre-deal evaluation (before each transaction).
Ex-post evaluation (/ex. during night)
Target audience
Portfolio managers / analysts, Middle / Back office employees, Key business users
Duration
2 – 4 hours of self-study
We recommend that participants start the self-study phase no later than 10 days prior to the course. Please note that to be awarded full education points, all self-study exercises must be completed
 
4 – 5 hours of virtual classroom training
Prerequisites
Before participating in this course, participants must have either attended the course “Avaloq Foundation (FOU)” or have equivalent knowledge and experience with the Avaloq Banking System.
Follow-up courses
Performance measurement concepts in the Avaloq Banking Suite (PFP)
Rebalancing methods in the Avaloq Banking Suite (PFR)
Introduction to tax processing in Avaloq (TIN)
Objectives
Upon successful completion of this course every participant will:
  • Have an overview of the current international tax requirements.
  • Understand the general concepts of tax within Avaloq.
  • Be able to create and maintain tax input parameters.
  • Understand the different tax concepts available.
  • Be able to design a solution for new tax requirements.
  • Be able to plan and structure the parameterisation of tax based on a checklist
Course content
Introduction to tax in general (e.g. EUSD, FATCA,)
Introduction to tax concepts in Avaloq
Tax impact on static data
Tax impact on business transactions
Design and Definition of tax input parameters
Design and Definition of tax calculation
Control and monitoring features
Reporting requirements
Pre-deal evaluation (before validation of transaction)
Ex-post evaluation/corrections (e.g. during night)
Checklist for introduction of new tax requirements
Target audience
Tax Experts, Static data employees, Middle / Back office employees, Key business users
Duration
2 – 4 hours of self-study
We recommend that participants start the self-study phase no later than 10 days prior to the course. Please note that to be awarded full education points, all self-study exercises must be completed
 
4 – 5 hours of virtual classroom training
Prerequisites
Before participating in this course, participants must have either attended the course “Avaloq Foundation (FOU)” or have equivalent knowledge and experience with the Avaloq Banking System
Limit System - Business Application (LIS)
Objectives
Upon successful completion of this course every participant will:
  • Understand the available functionality, components and architecture of the Limit System
  • Know how to set up and model Limit Hierarchy (LIHI) structures and know all capabilities of the system
  • Work confidently and become proficient in using the functionalities provided in the Limit System Deck
  • Know all available reports and understand their role in your day-to-day business
Course content
Introduction to the Avaloq Limit System
Modelling of business and product hierarchies for various risk aspects
Easy hierarchy management with template functionality
Setup of limits and associated exposure aggregation filters
Definition of limit calculation criteria
Audit and limit management functionalities
Reporting and monitoring features
Target audience
Key Users working in credit or risk management departments of a bank and being in charge of limit management as well as parameterisation specialists
Duration
1 day
Prerequisites
Before participating in this course, participants must have either attended the course “Avaloq Foundation (FOU)” or have equivalent knowledge and experience with the Avaloq Banking System.
Additionally, participants should have knowledge in the area of risk management and limit.
Follow-up courses
Parameterising the Limit System (LIP)
Mastering Advanced Avaloq Script Techniques (ASC)
Objectives
Upon successful completion of this course every participant will:
  • Understand how the compiler works
  • Create and use tasks using Avaloq Script
  • Understand and master order processing using Avaloq Script
  • Take advantage of existing script utilities to enhance both flexibility and performance
  • Understand and evaluate different implementations in regards to their performance
Course content
Avaloq Script Explained
  • Understand compilation results
  • Use fast recompilation
 
Report Writer Techniques related:
  • Create your own task
  • Synchronise the task execution
  • Execute work in another business unit (BU)
 
Efficient order processing with Avaloq Script
  • Commit efficiently and use bulk processing
  • Used named transactions to control complex workflows
  • Know about optimisation and memory management
 
Avaloq Script Utilities and Goodies
  • Arrays and table equivalents in Avaloq Script
  • Begin – end block issue
  • Optimisation and performance measurement
  • Efficient logging techniques
  • Diverse script package
  • Exception handling
  • Source overriding and overwriting
 
Executing arbitrary PL/SQL in the GUI
Using a real debugger in Avaloq
Target audience
All Avaloq Certified Professionals who have contact with Avaloq Script on a regular basis.
Duration
2 days
Prerequisites
Before attending this course, prior attendance of the course “Fundamentals of Avaloq Customisation (ACP)” is mandatory.
Participants must have either attended the course “ (BSC)” or have equivalent knowledge.
Additionally, participants must have at least 2 years of in-depth customisation expertise.
Mastering Advanced Report Writer Techniques (ARW)
Objectives
Upon successful completion of this course, participants will be able to:
  • thoroughly comprehend the technology behind the Report Writer Engine
  • take advantage of the functionality offered by the task framework
  • understand the process of parallelising, sorting and grouping data
  • extend aggregation functions of a report datamart
  • create very complex but performing reports
  • extend the interactive functionalities of screen reports
 
Target audience
Avaloq customisation specialists who implement complicated reports or have to address technical aspects of Report Writer performance issues.
 
Duration
2 – 4 hours of self-study
We recommend that participants start the self-study phase no later than 10 days prior to the course. Please note that to be awarded full education points, all self-study exercises must be completed
 
4 – 5 hours of virtual classroom training
Prerequisites
Before attending this course, prior attendance to the following courses is mandatory:
  • Fundamentals of Avaloq Customisation (ACP)
  • Best Practices for Report Writer” (BRW)
  • Mastering Advanced Avaloq Script Techniques (ASC)
 
Participants should be familiar with SQL and PL/SQL and have a good understanding of Report Writer in general with at least 2 years of practice of writing and maintaining reports on projects.
 
Monitoring and Log Administration (OML)
Objectives
Upon successful completion of this course every participant will know:
  • Importance of default checks
  • How to override the default checks and create new ones
  • How to use the Avaloq Log for root cause analysis
  • How to interface external Monitoring Solutions
  • How to use tracing & profiling
Course content
The architecture of the Avaloq Message Interface
The concept and tools of the message processing
Operation aspects and trouble shooting
The customisation areas of the Avaloq Message Interface
Target audience
Members of IT Operations at customer or partner sites. Also application managers and application operation managers as well as customisation specialists.
Duration
2 – 4 hours of self-study
We recommend that participants start the self-study phase no later than 10 days prior to the course. Please note that to be awarded full education points, all self-study exercises must be completed
 
4 – 5 hours of virtual classroom training
Prerequisites
Before participating in this course, participants must have knowledge in the following areas:
  • Toad or SQL Developer
  • Understanding of simple PL/SQL statements
  • Attended the course "Fundamentals of Avaloq Application Operations" (OAO)
Follow-up courses
Monitoring and Log Administration (OML)
End-of-Period Concepts (OEP)
Concepts of Output Management (OOM)
Organisational Structure Security (OSS)
Objectives
Upon successful completion of this course every participant will be able to:
  • understand the concepts of the generic Avaloq access security
  • understand the additional concept of the organisational structure related access security
  • set up security based on the organisational structure
Course content
Concept of:
  • Access Codes and securable areas
  • Resource vs. Function access
  • Run time recalculation of security settings
 
Usage of:
  • User and Customisation interfaces (APIs) enabling OSS
  • Reporting and other tasks
 
What are the:
  • Elements of Organisational Structure Security
  • Organisational Entity (OE) and Job objects
  • Run time Recalculation of security settings
 
Target audience
Avaloq Customisation Specialists who would like to refresh their knowledge of Avaloq security, and learn to use and understand the new solution of organisational structure security.
Duration
4 - 6 hours of self-study
We recommend that participants start the self-study phase no later than 10 days prior to the course. Please note that to be awarded full education points, all self-study exercises must be completed
 
4 – 5 hours of virtual classroom training
Prerequisites
Prior attendance of the course “Fundamentals of Avaloq Customisation” is mandatory.
Parameterisation of Functional Area Cashier Operations (COP)
Objectives
Upon successful completion of this course every participant will:
  • Write a migration to set up terminal objects
  • Parameterise the business type COP including order type trailers, specific workflow commands, field rules, base parameters and cost rules
  • Adapt the parameterisation for Cashier Notes Exchange Rates
  • Adapt the parameterisation for 3rd-party systems
  • Parameterise the business type CMG including order type groups, money stock types, banknote denominations
Course content
Object Terminal
  • Migration
  • Tasks
  • Configuration
Cashier Operations
  • Order Type Trailers
  • Workflow Commands
  • Field Rules
  • Code Tables
  • Base Parameters
  • Printing
Cashier Notes Exchange Rates
  • Workflow Parameterisation
3rd-Party Systems
  • World Money Direct
  • Card Reader
  • Sign Base
  • Twin Safe / Cashpro
Business Type Cashier Management (CMG)
  • Order Type Groups
  • Code Tables
  • Context Actions
Target audience
Parameterisation specialists
Duration
1 day
Prerequisites
Before attending this course, participants must have attended the course Handling Cashier Operations Functionality (COF) as well as course Fundamentals of Avaloq Customisation (ACP).
We recommend reading the following guide as a preparation for the course. The guide is published in the Avaloq Community:
Cashier Operations; Parameterisation Guide (ID: 2064)
Parameterisation Principles (PAP)
Objectives
Participants will get the necessary knowledge to participate in or manage an Avaloq implementation / parameterisation project.
Course content
Customisation
Avaloq ice – integrated customisation environment
Rule Engine and Automatic Field Calculation
Object Keys, Additions and Classifications
Avaloq Script
Report Writer
Workflow & Context Action
Order Validation  
Avaloq Forms and Structured Extensions
Avaloq Message Interface
Access Security and Rules
Target audience
Project leaders, Key Business Users, Business Analysts and Consultants involved in Avaloq parameterisation, configuration or migration projects
Duration
5 days
Prerequisites
Before participating in this course, participants must have either attended the course “Avaloq Foundation (FOU)” or have equivalent knowledge and experience with the Avaloq Banking System.
Parameterising the Avaloq Anti-Money Laundering Solution (AML)
Objectives
Upon successful completion of this course every participant will:
  • Understand business and technical details of the AML solution
  • Know the parameterisation possibilities of the AML solution
  • Be able to implement the AML solution at a customer site
Course content
Introduction to the Avaloq AML Solution
AML – Object Modelling
AML – Consolidator
Know Your Customers (KYC)
Know Your Transactions (KYT)
Know Your Processes (KYP)
Target audience
Parameterisation specialists
Duration
1 day
Prerequisites
Before participating in this course, prior attendance of the course “Fundamentals of Avaloq Customisation (ACP)” is mandatory.
Parameterising the Avaloq User Interface (PSC)
Objectives
Upon successful completion of this course every participant will:
  • Have received an overview of the SmartClient features
  • Know the customisation possibilities of the SmartClient
  • Be able to set up and customise some of the features
Course content
Application Title and Icon Text
Auto Refresh and Refresh Interval
Modifying existing Business Applications
System Environment
 
Customer Logo
  • Colour (Background, Status, Icon, Forms)
  • Colour of Header in Order Forms
 
Language of the Login Window
Creating and distributing Standard Favourites
Customise the Help Link
Customise the Ribbon
View mode restrictions
Target audience
All Avaloq Certified Professionals.
Duration
2 - 4 hours of self-study
We recommend that participants start the self-study phase no later than 10 days prior to the course. Please note that to be awarded full education points, all self-study exercises must be completed
 
4 – 5 hours of virtual classroom training
Prerequisites
Before participating in this course, prior attendance of the course “Fundamentals of Avaloq Customisation (ACP)” is mandatory.
Parameterising the Cost Engine (CAD)
Objectives
Upon successful completion of this course every participant will:
  • Understand in depth concepts of the Avaloq Cost Engine like the Cost Profiles,
  • S-Rules and Cost Reporting
  • Create Cost Profiles, Cost on Costs Info Bookings, Cost Quantity Types
  • Take advantage of good examples for Info Bookings and Cost Profiles
Course content
IPlain vanilla cost parameterisation
Repetition of the use of the tables:
(COST_RULE_LD, _MERGE, CODE_BOOK_KIND, CODE_COST_QTY_TYPE, etc.)
Cost Profiles (concept, possibilities and limitations)
Special Conditions
Costs on Costs
Cost Rule Debugging
Cost Rule Loading
Zero Billing
Costs & Output: Layout-Ordering, Text
S-Rules
Target audience
Avaloq Certified Professionals who have contact with Avaloq Costs on a regular basis.
Duration
2 - 4 hours of self-study
We recommend that participants start the self-study phase no later than 10 days prior to the course. Please note that to be awarded full education points, all self-study exercises must be completed
 
4 – 5 hours of virtual classroom training
Prerequisites
Before participating in this course, prior attendance of the course “Fundamentals of Avaloq Customisation (ACP)” is mandatory.
 
Additionally, participants should have a general business know-how regarding commissions.
Follow-up courses
Parameterising the Fee Engine (FEE)
Parameterising the CRM Module (CRP)
Objectives
Upon successful completion of this course every participant will be able to parameterise:
  • the CRM Desk
  • the business type Sales Opportunity
  • the business type Issue Management
  • the business type Contact Management V2
  • the business type Campaign Management
 
Course content
CRM Desk Parameterisation
Sales Opportunity Parameterisation including Issues and Contacts on Sales Opportunities
CRM Issues Parameterisation
Contact Parameterisation including the Integration on other meta types as automatic or manual Contact
Campaign Management Parameterisation with the Creation of new Campaign Tasks
Target audience
Parameterisation specialists
Duration
1 day
Prerequisites
Before participating in this course, prior attendance of the courses “Fundamentals of Avaloq Customisation (ACP)” and “Working with the CRM Module (CRM)” is mandatory.
Parameterising the Fee Engine (FEE)
Objectives
Upon successful completion of this course every participant will:
  • Overview Fee Engine concepts and topics
  • Set up and customise fees and commissions (including deferred costs)
  • Set up and customise the Fee Engine
  • Navigate through the components of common Fee Engine applications
  • Master advanced Fee Engine parameterisation task
Course content
Introduction
  • Business Background
  • Fees vs. Costs
  • Business Type XFERFEE
 
Basic Fee Concepts:
  • Pillar, Flat Datamart and Table Report
  • Task TASK_FEE and FEE Script Package
  • Fee Calculation Process
  • Maestro Card Fee Run
  • Custody Fee Run
  • Deferred Costs
  • Payment Charges
  • Manual Fee Transfer
  • XFERFEE Book Kind and Advice Text
 
Advanced Concepts
  • Tariffs and Conditions, Cost Rules
  • Duplicate Check
  • Total Asset
  • Accrued Fees (Deferred XFERFEE)
  • Splitting and Parallelisation
  • best Practices and Pitfalls
Target audience
Parameterisation specialists and key business users in the area of cost and fees.
Duration
2 days
Prerequisites
Before participating in this course, prior attendance of the course “Fundamentals of Avaloq Customisation (ACP)” is mandatory.
 
Additionally, participants should have a sound business know-how regarding commissions and fees.
Follow-up courses
Parameterising the Cost Engine (CAD)
Parameterising the Limit System (LIP)
Objectives
Upon successful completion of this course every participant will:
  • Understand the building blocks of the Limit System
  • Know the Limit System parameterisation options
  • Work confidentially with the setup of new limit families and exposure & limit dimension
  • Be able to extend the business type with the generic limit check
  • Be proficient in producing new limit reports
Course content
Parameterisation techniques for the modelling of new risk aspects and risk families
Sample business use case in the bank
Limit related APIs
Generation of risk and limit related reports  
Example: Limit System Setup
Target audience
Parameterisation specialists with assignments in the limit and risk system of a bank.
Duration
1 day
Prerequisites
Before participating in this course, prior attendance of the course “Fundamentals of Avaloq Customisation (ACP)” is mandatory.
Before participating in this course, participants must have either attended the course “Limit System – Business Application (LIS)” or have equivalent knowledge and experience with the Avaloq Banking System.
 
Additionally, participants should have knowledge in the area of risk management and limit.
Follow-up courses
Parameterising the Limit System (LIP)
Position- and Book Keeping (PKP)
Objectives
Upon successful completion of this course, participants will be able to:
  • understand the concepts of position and book keeping
  • understand the procedures for exporting bookings
Course content
ATRX Heartbeat and Subscriber
  • ATRX number & subscriber
Book & position keeping
  • Introduction concepts, lot bookings and PKO functionality
  • Impact of the certain object modifications
  • Rebook functionality
Pillar adjustment
  • Pillar basics
  • Complexity of PBAL, PTOV, LBAL and LTOV
  • Position keeping process (PKP) overview
  • PKP triggers
Book Engine and ATRX monitoring
  • ATRX monitoring
  • Book Engine monitor views: ATRX and subscribers
  • Monitor Book Engine procedures
Book-related garbage collection
  • An overview of standard garbage collection
  • Showing the impact of base parameter
Object and booking reporting
  • Overview of an object and booking extraction architecture
  • Introduction to document logging
  • Defining and setup of a doc log consumer
Target audience
Customisation specialists who would like to further their knowledge of position- and bookkeeping, and better understand the options for monitoring the booking engine.
 
Duration
3 - 4 hours of self-study
We recommend that participants start the self-study phase no later than 10 days prior to the course. Please note that to be awarded full education points, all self-study exercises must be completed
 
4 – 5 hours of virtual classroom training
Prerequisites
Participants
  • Successful completion of the course “Fundamentals of Avaloq Customisation”
  • Basic knowledge of the Book Engine, pillars and their calculation, as well as knowledge of background processes and SQL
 
Processing Money Market Trades in the Avaloq Banking Suite (MMA)
Objectives
Upon successful completion of this course every participant will be able to:
  • understand supported business use cases
  • create and modify money market deposits
  • understand the different renewal types
  • manually set mark-ups, retrocession and instructed money accounts
Target audience
Client Relationship Managers, Key Business Users and Parameterisation Specialists
Duration
2 - 3 hours of self-study
We recommend that participants start the self-study phase no later than 10 days prior to the course. Please note that to be awarded full education points, all self-study exercises must be completed
 
4 – 6 hours of virtual classroom training
Prerequisites
Participants must either
  • have attended the course “Avaloq Foundation (FOU)” or
  • have equivalent knowledge and experience with the Avaloq Banking Suite
Repo Contract (REP)
Objectives
  • Upon successful completion of this course every participant will:
  • Open and maintain individual GMRA (Global Master Repurchase Agreement) with their clients
  • Trade OTC Repo contracts
  • Understand the automatic processing of Triparty Repo contracts
  • Monitor net-exposure against counterparties
  • Mark-to-Market of outstanding Repo Contracts
  • Obtain specific and qualified information by browsing order books and reports
Course content
Repo trading model within Avaloq
 
Avaloq Repo-relevant business types
  • Set-up of customised GMRA
  • Opening, keeping up-to-date and closing of Repo trades
  • Net-Exposure evaluation and Mark-to-Market operations
 
Information provisioning: Repo reports and order books
 
Repo integration with other Avaloq modules, i.e.
  • Collateral Management
  • Settlement
  • Bookings and Balancing
Target audience
Key Business Users and Implementation (Migration) Partners
Duration
1 day
Prerequisites
Before participating in this course, participants must have either attended the course “Avaloq Foundation (FOU)” or have equivalent knowledge and experience with the Avaloq Banking System.
The participants must have also attended the courses “Collateral Management (CLM)”.
 
Additionally, participants should have knowledge in the area of Repo.
Responsive Forms / Webforms (RSP)
Objectives
Upon successful completion of this course, participants will be able to:
  • understand the concepts behind responsive forms / webformsunderstand where and for what presentation object types are needed
  • create responsive forms / webforms
  • create presentation object types and use them in responsive formshave an idea about how webforms can be used and tested in the Front Workplace
Course content
Responsive forms concepts
  • Form structure & type
  • Widgets & form binding
  • Design essentials
Presentation object types
  • Introduction to the concept of presentation object types
  • Business entities and selection sets
  • Customisation of presentation object types
Responsive forms customisation
  • Naming conventions & source structure
  • Coding examples
  • Emphasising good coding practice
Webforms usage in the Front Workplace
  • Usage of webforms in the Front Workplace
  • Placing a new responsive doc definition in the menu of the workbook
Target audience
Avaloq customisation specialists interested in the customisation of interfaces.
Duration
4 - 5 hours of self-study
We recommend that participants start the self-study phase no later than 10 days prior to the course. Please note that to be awarded full education points, all self-study exercises must be completed
 
4 – 6 hours of virtual classroom training
Prerequisites
Before participating in this course, prior attendance of the course “Fundamentals of Avaloq Customisation (ACP)” is mandatory.
Follow-up courses
Mastering Advanced Report Writer Techniques (ARW)
Securities Lending and Borrowing (SLB)
Objectives
Upon successful completion of this course every participant will be able to:
Set-up trades by deployment of relevant SLB business types:
  • Open and maintain individual lending & borrowing agreements with their clients
  • Initiate street-side transactions followed by allocation of customer participation
  • Display & book arising commission accruals, due to/from clients and counterparties
 
Obtain specific and qualified information by browsing Order Books and Reports. In particular, the participants will learn how to benefit from:
  • Availability listings for securities, adequate for external counterparties
  • Real-time overview of lendable positions.
Course content
SLB trading model within Avaloq
 
Avaloq SLB-relevant business types:
  • Set-up of customised lending & borrowing agreements
  • Opening, keeping up-to-date and closing of SLB trades
  • Selection of participating clients based on predefined allocation methods
 
Integration of SLB with collateral management
 
Lifecycle & maintenance of SLB trades
  • Increase or decrease (partial returns) of contracts
  • Substitution of participating clients
  • Calculation & automatic booking of commissions
  • Contract re-rating
 
Information provisioning: SLB reports & Order Books
 
SLB integration with other Avaloq modules, i.e.:
  • Stock Exchange
  • Settlement
  • Corporate Actions
  • Bookings & Balancing
 
Target audience
Key Business Users and Implementation (Migration) Partners
Duration
2 days
Prerequisites
Before participating in this course, participants must have either attended the course “Avaloq Foundation (FOU)” or have equivalent knowledge and experience with the Avaloq Banking System.
We recommend that participants have attended the course “Collateral Management (CLM)”.
 
Additionally, participants should have sound business knowledge in the area of Securities Lending and Borrowing.
Stock Exchange (STX)
Objectives
Upon successful completion of this course every participant will:
  • Know how to describe the Stock Exchange module of the model bank for business users
Course content
Day 1
  • One-to-One Execution, One-to-Many Execution
  • Various basic concepts – basic order attributes – calculated order attributes
  • Workflows
  • Position driven trading
  • Rectify and Reversal
  • Billing groups, partial execution and reduction
  • Trading Order books, Reporting and Advices
 
Day 2
  • Forward Pooling
  • Netting
  • Partial Billing
  • Client Pricing in Subscription process
  • Rectify and Reversal in pooling structures
  • Cost Propagation
  • Backward pooling (allocating process)
  • Money driven trading
  • Warehousing
Target audience
Client relationship managers, portfolio managers, back office employees, securities trader and parameterisation specialists.
Duration
2 day
Prerequisites
Before participating in this course, participants must have either attended the course “Avaloq Foundation (FOU)” or have equivalent knowledge and experience with the Avaloq Banking System.
Additionally, participants should have advanced knowledge in the area of securities trading.
System Performance (OSP)
Objectives
  • Know the basic setup and approach to analyse performance problems in the Avaloq system
  • Know the tools to analyse of system performance provided by Avaloq and Oracle
Course content
  • System performance: Overview, configuration, documentation
  • Avaloq and Oracle tools for analysis of system performance problems. System performance testing
  • Oracle statistics - and how they are handled in the Avaloq Banking System
  • System performance issues
  • Best Practices for well-performing Avaloq source code
  • End-Of-Period and Performance
Target audience
Parameterisation specialists, Oracle specialists
Duration
1 days
Prerequisites
Before participating in this course, prior attendance of the courses “Fundamentals of Avaloq Customisation (ACP)”: Additionally, participants must have knowledge of SQL and PL/SQL and programming.
Understanding and using the "Person object" (POM)
Objectives
Upon successful completion of this course every participant will:
  • Know the Person object, its use and capabilities
  • Be able to design customer models that answer the banks requirements and will make best use of Avaloq’s capabilities
  • Be able to implement both external parties and internal entities using the Person object
Course content
Introduction to the Person object model, person types and legal forms
Business Partner categories and Ownerships
Example Models & Model Validations
Person-Person Relations
Communication Preferences & Additional Features
Target audience
Bank staff working with customer data including those responsible for static data management, tax, regulatory and credit specialists and Avaloq parameterisation experts requiring an introduction to the Person object and its features.
Duration
4 - 5 hours of self-study
We recommend that participants start the self-study phase no later than 10 days prior to the course. Please note that to be awarded full education points, all self-study exercises must be completed
 
4 – 6 hours of virtual classroom training
Prerequisites
Before participating in this course, participants must have either attended the course “Avaloq Foundation (FOU)” or have equivalent knowledge and experience with the Avaloq Banking System.
Working with Credit Functionalities (CFW)
Objectives
Upon successful completion of this course every participant will
  • Apply the credit functionality independently and completely
  • Understand the implemented business processes and functionality in Avaloq for credits
  • Participate in further workshops in the implementation project to define new or adapted bank processes and/or define parameterisation items for the credit facilities
Course content
Theory: Concepts for credit functionality
Financing: Metatypes and forms
Group Business Partner Credit (including rating)
Group Home Financing (including Economic Viability)
 
Group Credit Initiation
  • Credit Application (with new Credit Front Data Model)
  • Credit Scoring
  • Economic Entity
  • Credit Volume Limit Application
  • Collective Application
 
Group Credit
  • Loan (including new Annuity and Outpayment)
  • Limit
  • Guarantee Credit
  • Syndicate
Group Collateral
  • Realty
  • Real Security
  • Other Securities
 
Group Control
  • Financing
  • Collateral Rules
  • Credit Violation
 
Group Real Estate Evaluation
Group Desk
Practical work on the SmartClient with the metatypes and forms
 
Introduction to new interest engine
  • Basics
  • Fixings
  • Interest change for variable mortgage, money market financing
  • Process
 
Collateral allocation
 
Different items
  • Asset flow
  • End of day
  • Reports
  • Pfandbrief items
  • Active position with value of zero
  • Recovery
  • Credit Check Tolerance
  • Dynamic Limits and Blank Limit Amounts
Target audience
Key Business User, implementations partners and parameterisation specialists from banks which are in the Avaloq implementation process.
Duration
3 days
Prerequisites
Before participating in this course, participants must have either attended the course “Avaloq Foundation (FOU)” or have equivalent knowledge and experience with the Avaloq Banking System.
Additionally, participants should have business knowledge in the area of credits, loans and mortgages.
Working with the CRM Module (CRM)
Objectives
Upon successful completion of this course every participant will know:
  • Understand the general concepts, functionalities and relations between the business Types.
  • Understand the implemented business processes in Avaloq CRM
Course content
Working with the Avaloq Desks
Relationship Manager Workplace and the CRM Desk
Sales Opportunity with Mass Entry and Sales Pipeline
Issues and Contacts including the Issue sync to MS Exchange
Campaign Management with internal and external lead list and the different Campaign definitions
Sales Opportunity (SALESOPP)
Issue Management (ISSUE)
Contact Management V2 (CTACT2)
Campaign Management (CAMPGN)
Target audience
Key Business Users and Parameterisation specialists
Duration
1 day
Prerequisites
Before participating in this course, participants must have either attended the course “Avaloq Foundation (FOU)” or have equivalent knowledge and experience with the Avaloq Banking System.
Follow-up courses
Parameterising the CRM Module (CRP)
  • © 2017 Avaloq