Implementation of a AML (Anti Money Laundering) tool for the automation of the AML process and the generation of the XML reports for MROS (Money Laundering Reporting Organisation Switzerland) in the goAML web application
Activities:
Requirements specification
Mapping of the goAML XML interface on the data model of the core banking systems Avaloq and DIALBA2000
Implementation of the regulatory requirements for a systemically important bank: implementation of the prudential requirements for equity capital, risk allocation, liquidity (incl. Emergency Liquidity Assistance = ELA) and regulatory reporting. Implementation of the processes for ELA including the implementation of SIX Nominee (fiduciary administration of registry encumbrances on real estate) and the integration in the mortgage process. Creation of the emergency plan.
Activities:
Documentation of the emergency plan
Coordination with FINMA concerning the emergency plan and with SNB concerning ELA
Coordination of legal opinions for the emergency plan
Use case specification for the mortgage process and the ELA process
Specification of the SNB reporting
Specification of the software requirements for Terravis (SIX Nominee), Avaloq and DIALBA2000
Project planning and project budgeting
Test management E2E test, specification of test cases and test scripts
Business support for the mass mutation of the registry encumbrances for SIX Nominee
Implementation and integration of the standard softwarev tool IBM Interact to personalize the near-time offerings and suggestions for new products on the channels of E-Banking and mobile banking.
Activities:
specification of the software requirements
interface specification with data mapping from the data warehouse to IBM Interact
Design and implementation of a new financial product for cooperatives (similar to a participation certificate) which increases the core capital of Raiffeisen Schweiz.
Activities:
Definition of the product features based on the Swiss law for cooperatives
modeling of the business use cases and the system use cases for Avaloq
Implementation of the Swiss Final Withholding Tax agreements with UK and Austria.
Activities:
Modeling of the business use cases and the system use cases
specification of the data model for a data base which feeds the tax calculation software EasyTax with the data from the source systems (Avaloq, DIALBA)
Redevelopment of the payment systems based on the software components Avaloq and dips. All payment products have been migrated to the new core systems: pay-in slips, card transactions (KTB), SIC incoming and outgoing payments (A10, A11, A15, B10, B11), SWIFT payments (MT103, MT202, MT202COV, MT191), SEPA payments (pacs.008, pacs.004), direct debit (LSV+), online banking, DTA, Postfinance (ESR, EGA-B, EGA-V).
Activities:
requirements specification for archiving, reporting, audit trail, and data warehouse (modelling of the data marts),
Conceptual design of an unified tool for the export logistics processing for several Siemens business divisions. The software tool supports and automates the generation of the required export documents, the export declaration via ATLAS, the compliance with the export control and customs regulations and the processing of the letters of credit.
Development of a system for the automatic verification of the invoices which are submitted to a health insurance by the insurance holders and the care providers. The invoices are checked automatically for formal correctness and correctness of the contents. The system corrects and logs any occurring errors. It also supports the manual post-processing, if necessary. The interfacing systems are supplied with the required data (e.g. for payments).
Activities:
development of the business class model for the tariff data, product data and partner data.
Development of a cash management system for the optimisation of the cash supply of cash points (ATM’s, Cash Recyclers, bank branches). The optimal amount of cash and the optimal day for the cash delivery is calculated via the minimisation of the cost function. This requires a forecast of the cash volumes. The system delivers cost-optimised orders for the cash supply of the cash points.
Activities:
Mathematical-statistical analysis: time series analysis, development of the forecast models for the time series
nonlinear optimisation / operations research
use case specification
requirements elicitation
functional design of the optimisation and forecast modules
Development of a management information system for the reporting of operational risk. The cause of the risk are reconciliation breaks from investment banking / proprietary trading. The break data are imported from the reconciliation and trading systems (i.a. Murex, TLM, Corona). The expected loss is calculated and several types of reports for the management are generated.
Implementation of the IBM OnDemand software within an ePayment solution. OnDemand allows for the indexing and archiving of electronic documents on hard disk and on several archiving media. Archived documents can be retrieved and restored via OnDemand.
Development of a document management system for the credit risk operations department. Paper documents are scanned in the Province Management Offices and filed in a central Content Management System which provides remote access via Intranet. The processing of the documents is handled via a predefined workflow that is automated by a workflow management system.
Development of the new web site www.AlFransi.com.sa. The portal integrates the existing Online banking applications of the bank. It enables the visitors to customize and personalize the web content and it supports PDA’s. The business users maintain their content using a web content management system. In addition, the portal allows the business lines to target the visitors with the right marketing campaigns (products & service offerings) depending on their profiles.
Processing of electronic credit advices for the payment products ESR (Einzahlungsschein mit Referenznummer) and IPI (International Payment Instruction, XML format) within the card processing system Advantage.
Planning, preparation and implementation of business acceptance tests and technical tests for the projects ‘GSM-Rail’ and ‘Trassenportal’. Planning and coordination of the production rollout. Project ‘GSM-Rail’: Customer Care and Billing system and SIM card management system for the train control via cellular phone network. Project ‘Trassenportal’: Web based application to receive XML-orders for railway routes and to send the corresponding proposals.
Activities:
Test planning (defining activities and milestones, budgeting, resource planning, identifying project risks)
test strategy development
test case specification
coordination of the set-up of the test environment
Business Analyst, Project Manager, Test Designer, Tester
Customer
Commerzbank AG
Place of work
Frankfurt am Main
Tasks
Development of a billing system for the international payment products (international credit transfer, direct debit request, request for transfer) and for the products of the financial information system (e.g. electronic account statements, transaction statements, account balance statements). Archiving of the billing data.
Development of the risk management component which calculates prices (market prices and theoretical prices for financial derivatives), the market risk (Value at Risk), and the Profit and Loss for securities and portfolios. The component was designed for the integration into a web based trading system.
Activities:
Project management (deputy of the project manager in a team of seven team members)
tender preparation
documentation oft the software development process according to the Rational Unified Process
Development of an application for the end-to-end tracking of the processing of international payments (international credit transfer and request for transfer). The processing extends to different platforms: UNIX, IBM-Mainframe, DEC-Alpha.
Specification and implementation of a module for a warehouse management system. The module extracts the transaction data which are used for billing. For a future release the data are intended to form the basis of a data warehouse.
Development and maintenance of a database for warehouse management and transport data of parcels. Specification and implementation of billing programs which use the transaction data from the database.
Description: Development of a Client-Server-Application for the management of condition data and turnover data of the suppliers for the purchasing department of a wholesaler.
Business analysis of the assortment of a wholesaler of car spare parts. The cost-optimised way of distribution (one central warehouse vs. a number of smaller spare parts stores) was calculated comparing the capital lockup costs and the costs of transport and handling.
Activities:
Programming of the cost calculation algorithm
Skills
Software Development
Products
Visual Basic for Applications
VBA
MS Access
Industries
Banking
Financial Services
Industry
Logistics
Skills
Programming Languages
C
Cobol
Emacs
Excel VBA
Fortran
Informix 4GL
Oracle SQL
PL/SQL
SAS
HPF (High Performance Forecasting)
Shell
TeX, LaTeX
VBA
Visual Basic for Applications
Operating Systems
HPUX
MS-DOS
MVS
MVS, OS/390
OS/2
SUN OS, Solaris
Unix
VM
Windows
Databases
Access
DB2
Informix
Lotus Domino
Lotus Notes
MS Access
MySQL
Oracle
SAS
SQL
Language Skills
English
excellent
French
school knowledge
German
native language
Hardware
Cray
HP
IBM mainframe
PC
Silicon-Graphics
SUN
Vector & parallel computer
Data Communication
Connect:Direct
Products / Standards / Experiences
Advantage
AltovaXMLSpy
Avaloq
Business Objects
CMM
Connect:Direct
CrystalReports
data warehouse (proprietary)
Datawarehouse
dips
EasyTax
Enterprise Architect
EViews
Financial mathematics
HP QualityCenter
IBM Campaign
IBM Content Manager
IBM Interact
IBM Lotus Workplace Web Content Management
IBM OnDemand
IBM Rational
IBM WebSphere Application Server
IBM WebSphere Portal
Kofax Ascent Capture
Lotus Workflow
MantisBT
Mathematica
MS Excel
MS Office
MS Project
MS Visio
MS-Office
OO Analysis and Design (SE-Method Commerzbank)
OOA
Oracle Designer
Oracle Developer
Oracle Forms
PMI
Rational Unified Process
Rollout
RPA
RUP
SAS (HPF - High Performance Forecasting)
SE-method of Commerzbank (OO analysis & design)
SE-method of Commerzbank (structured Analysis)
Software Development
Structured Analysis (SE-Method Commerzbank)
SWIFT
Terravis
Testframeworks
Testmanagement
Tivoli Storage Manager
Tivoli Web Site Analyzer
Together/J
UiPath
XML
Design / Development / Construction
Design/1
Entity Relation Model
Install/1
Method/1
UML
Key Aspects
Business analysis
Data analysis
Project management
Requirements engineering
Test
Test management
Comments
Publications (banking): "Die Grenzen im Zahlungsverkehr fallen" geldinstitute 10/99, S. 66