Understand the Murex system setup at the client, organization of the support teams, end of day procedures and the report delivery process
Collect and provide detailed technical specifications / business requirement specifications.
Develop a generic datamodel and then create datamart objects as required for the reports.
Reconcile report extraction output with the onscreen / mreport output.
Analyze differences caused by adding or removing some filter conditions / dynamic table flags / launcher flags.
Analyze DataMart setup and the table structures for the purpose of identifying redundant objects, to minimize execution time of batches, and to seek possibility of reuse of objects.
Skills
Must have
10+ years of experience on MX3.1 Datamart
Understanding of the Murex system as a whole
In-depth understanding of MX reporting architecture, MX datamodel, and MX Datamart configuration
Familiarity with mxres configuration files, and launcher flags
Thorough knowledge of Datamart objects
dynamic tables, feeders, batch of feeders, scanner templates etc.
Exposed to Mreports; Mreport to Datamart migration experience is desirable
Technical skills
Very good knowledge of SQL (Sybase and Oracle), At least one reporting tool (Actuate, Crystal reports, Micro Strategy), Basic unix commands
Understanding of Trade Life Cycle
Basic knowledge on financial instruments such as Interest Rate Derivatives, Credit Derivatives, Currency Derivatives, Swaps, Futures, Options, FRA, etc.
