Ales - Consultant KONDOR+

Consultant

TREMA Finance Kit (Wall Street Systems) treasury management system support, occasional support about 1-2 man days monthly.

Kondor+ Consultant

Business analysis, preparation SKK to EUR changeover in investment banking systems (Kondor+, Reuters BO system KTP, other in-house interfaced systems). Building documents: Expressions Of Needs, Test Targets, Test Scenarios, Test Data, Project Plan etc.
Approx. 5 mandays per month

TREMA Consultant

TREMA Finance Kit treasury management system implementation.
Leading business workshops, analysing client requirements.
Creating formal description of the target functionality.
Suggestion of solution architecture and data models for e.g. auctions procedures, mandatory minimum reserves, eligible assets management etc.
Architecture for calculating Value at Risk RiskMetrics datasets based on historical data in a database for VaR calculations (planned Perl development).
Creating strategy for static data and deals migration from legacy systems to the new one.
The contract is not directly with NBS, it goes via a consulting company PreFIS, Bratislava. Utilisation 11 mandays per months.

Consultant

Reuters Kondor+ remote implementation in Prague with access to Vienna server (12 users, small project, one man show).
Explaining Kondor+ functionality, mainly FX position keeping.
Building workaround for the local currency CZK profit loss calculations, retrieving Czech cen-bank official rates (SYBASE T-SQL development, FTP script and MS Excel small VBA development).
Adding functionality for back office: client confirmations based on Kondor+ database with layouts built in MS Excel.
Customisation development, e.g. adding margin trading functionality to Kondor+, nostro account cash flow reports, FX position for local currency CZK (Vienna server uses EUR), etc. (Mostly SYBASE SQL, UNIX Bourn shell and Perl development.)
Troubleshooting Reuters Dealing 3000 interface.
After finishing project, occasional support about 1-2 man days monthly.

Kondor+ Consultant

Short change project realising Kondor+ and Kondor Global Limit (KGL) responsibility move from one department to another one.
Kondor+ application, administration and custom reports development training for the new Kondor+ administrators.
Building sample SQL custom scripts with automation using Kondor+ ReportBatch and UNIX Bourn shell script.

position: Kondor+ Project Manager and Consultant

Migration from TREMA Finance Kit to REUTERS Kondor+ and KGL (24 users).
Starting as a Reuter’s employee, finishing the project as a freelancer.
Building project plan, preparing weekly project management meetings, managing Reuters consulting resources from SK, CZ, RU and F.
Configuration for FX and MM markets: writing business studies with agreed configuration.

Supervising a junior consultant configuring security market.
Clarifying yield curve calculations, profit loss methodologies, cost of carry etc.
Creating the strategy for migration weekend, keeping continuity for positions, PL, cost of carry on FX positions.
Development of batch deal interfaces from Kondor+ to data warehouse system and portfolio management system (SQL, UNIX sh script development).
Architecture and development for interfaces to Kondor+ (KplusImport utility automated with PERL script).

Transferring market values to back office system (Kondor+ report script, using ReportBatch and UNIX sh script for reformatting the results, FTP transfer script).
Kondor+ Custom Windows development for extra data saving and adding functionality to Kondor+ deal capture (e.g. more details on stock exchange brokerage fees, changing default values selected on MM deal capture).
Development of external calculation of cost of carry index and importing to Kondor+ database using KplusImport (PERL scripting).
Writing documentation after development of each customisation.

Freelance Financial Systems Consultant

Outsourcing treasury management system, Reuters Kondor+ administration and maintenance.
Clarifying and recalculating Kondor+ results, like market values and profit / loss calculations, bond accrued interest, cost of carry, Gap Analysis etc.
Development of SYBASE T-SQL code, K+ Open Reports, UNIX Bourn shell scripts, Perl scripts.
Takeover of old report scripts, their enhancements.
IT administration tasks: establishing SYBASE backup routines, full UNIX UFS file dump procedures, building scripts for creating UNIX user logins, installation of some simple UNIX software like Adobe Reader, maintaining Kondor+ standard documentation (HTML and PDF format).
Troubleshooting Kondor+ KplusBatch error messages.
Administration of internal contribution server (DDS) with the contribution tool Reuters Powerplus Pro.
Administration of Reuters DACS system. DACS daemon installation on Kondor+ servers.
2.5 mandays per month.

Job position: Senior Treasury Solutions Consultant

The main projects:
06/2004-01/2005 PPF Banka, position: Kondor+ Consultant
o REUTERS Kondor+ and Kondor Global Limits (KGL) implementation
o Acting as a business consultant (FX, MM, yield curves configurations, PL on bonds, other methodologies description, limits configuration, etc.)
o Acting as a Kondor+ developer (K+ Custom Windows, K+ Open Reports, K+ deal tickets, custom calculations on limits utilisation).