Senior Application Consultant

DIGITAL DISRUPTION TECHNOLOGIES PTE. LTD.; Singapore; On-site; SGD 90,000 - 120,000; Full time

Job summary

A consultancy firm based in Singapore is seeking an experienced Murex Specialist with over 12 years of experience on MX3.1 Datamart. The candidate will be responsible for understanding system setups, analyzing data mart configurations, and providing detailed business requirements. Strong SQL skills and familiarity with reporting tools are essential. The ideal candidate will work closely with support teams to optimize reporting processes and ensure effective test documentation and execution.

Qualifications

• At least 12+ years of experience on MX3.1 Datamart.
• In-depth understanding of MX reporting architecture.
• Excellent SQL programming skills are essential.

Responsibilities

• Understand Murex system setup and support teams organization.
• Collect and provide technical specifications.
• Analyze Datamart setup for optimization.

Skills

MX3.1 Datamart experience

Understanding of the Murex system

Capital market product knowledge

SQL programming skills

Experience with RDBMS

Unix experience

Familiarity with reporting tools

Understanding of Trade Life Cycle

Tools

Oracle

Sybase

Actuate eRD Pro

Job description

Project Description:

Mx.3 change request project covering data mart and backoffice related changes. Be a part of change squad.

Responsibilities

• 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 requirementspecifications
• Participates in peer review of requirements, technical and/or testing documentation and assists mentors junior members with same
• 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
• Segregate reports by users, products, creation classes, fields needed, complexity and frequency of execution
• Develop a generic data model and then create Datamart objects as required for the reports
• Execute processing scripts and batches manually or through the scheduling tool like Control‑M
• Reconcile report extraction output with the onscreen / mreport output
• Analyze 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 escape 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

Mandatory Skills

• At least 12+ 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 datamodel, and MXDatamart configuration
• Familiarity with mxres configuration files, and launcher flags
• Thorough knowledge of Datamart objects - dynamic tables, feeders, batch offeeders, scanner templates, etc.
• Exposed to Mreports; Mreport to Datamart migration experience is desirable
• 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), Atleast one reporting tool (Actuate, Crystal reports, Micro Strategy), 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