Senior Murex Datamart Reporting Consultant

Project description

One of our client (a leading bank of Singapore) is undertaking a strategic upgrade of its Murex MX.3 platform to enhance system resilience, support new product capabilities, and align with evolving regulatory and operational requirements. This initiative includes upgrading from version b to 3.1.6x.x, onboarding the EQA and OSP Excess modules, and implementing comprehensive reconciliation, testing automation, and governance frameworks.

Responsibilities

• Understand the Murex system setup at the client, organisation of the support teams, end of day procedures, and the report delivery process
• Collect and provide detailed technical specifications/business requirement specifications
• Participates in peer review of requirements, technical, and/or testing documentation, and assists mentors junior members with same
• Analyse Datamart setup and the table structures for the purpose of identifying redundant objects, to minimise execution time of batches, and to seek possibility of reuse of objects
• Segregate reports by users, products, creation classes, fields needed, complexity and frequency of execution
• Develop a generic datamodel and then create datamart objects as required for the reports
• Analyse differences caused by adding or removing some filter conditions / dynamic table flags/launcher flags
• Create and suggest processes, templates, and tools to streamline the development, testing, and implementation phases
• Analyses issues during planning and test execution phases
• Provide relevant and accurate information about defects and help the business reproduce errors
• Prepare and send effective periodic and timely status reports
• Track the testing progress and escalate the issue well in advance
• Assists in the preparation and execution of test plans
• Identifies the conditions that create errors to occur and escalates outstanding issues for clarification and resolution
• Escalates identified issues/risks in a timely fashion to the team lead.
• Assist team lead with effort estimation related to the development and UAT
• Ensures test documentation and deliverables are consistent with defined standards
• Coordinate with development and infrastructure team for availability of Mx environments and database
• Create and maintain report delivery plan with relevant traceability

SKILLS

Must have

• 4-8 years of experience on MX3.1 Datamart
• Understanding of the Murex system as a whole
• Good understanding of capital market products
• In-depth understanding of MX reporting architecture, MX data model, 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
• Experience with Simulation and Risk Matrices
• Experience with Market risk and credit risk report development
• Experience with RDBMS, e.g., Oracle, Sybase
• Excellent SQL programming skills
• Unix experience necessary; shell programming experience highly desirable; awk, sed, and Perl scripting experience would be a bonus
• Experience with at least one reporting tool, preferably Actuate eRD Pro
• Other programming experience a plus, esp MS Excel VBA
• Product knowledge (Any one or more, FX mandatory) - FX, IRD, FI, EQD, CRD
• Technical skills - Very good knowledge of SQL (Sybase and Oracle), at least one reporting tool (Actuate, Crystal Reports, MicroStrategy), Basic Unix commands
• Understanding of Trade Life Cycle
• Should possess an understanding of financial markets
• Basic knowledge on financial instruments such as Interest Rate Derivatives, Credit Derivatives, Currency Derivatives, Swaps, Futures, Options, FRA, etc

Nice to have

• Any reconciliation tools experience
• Experience in Murex upgrade project