Murex Senior Systems Analyst

Project Description:

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

Responsibilities:

1. Understand the Murex system setup at the client, organisation of the support teams, end of day procedures and the report delivery process.
2. Collect and provide detailed technical specifications / business requirement specifications.
3. Participate in peer review of requirements, technical and/or testing documentation and assist in mentoring junior members.
4. Analyse datamart setup and the table structures for the purpose of identifying redundant objects to minimise execution time of batches and seek the possibility of reuse of objects.
5. Segregate reports by users, products, creation classes, fields needed, complexity and frequency of execution.
6. Develop a generic datamodel and create datamart objects as required for the reports.
7. Execute processing scripts and batches manually or through the use of a scheduling tool like Control-M.
8. Reconcile report extraction output with the onscreen / mreport output.
9. Analyse differences caused by adding or removing some filter conditions / dynamic table flags / launcher flags.
10. Create and suggest processes, templates and tools to streamline the development, testing and implementation phases.
11. Analyse issues during planning and test execution phases.
12. Provide relevant and accurate information about defects and help the business reproduce errors.
13. Prepare and send effective periodic and timely status reports.
14. Track the testing progress and escalate issues well in advance.
15. Assist in the preparation and execution of test plans.
16. Identify conditions that create errors to occur and escalate outstanding issues for clarification and resolution.
17. Escalate identified issues/risks in a timely fashion to the team lead.
18. Assist team lead with effort estimation related to development and UAT.
19. Ensure test documentation and deliverables are consistent with defined standards.

Mandatory Skills Description:

1. At least 8+ years of experience on MX3.1 Datamart.
2. Understanding of the Murex system as a whole.
3. Good understanding of capital market products.
4. In-depth understanding of MX reporting architecture, MX datamodel, and MX Datamart configuration.
5. Familiarity with mxres configuration files and launcher flags.
6. Thorough knowledge of Datamart objects - dynamic tables, feeders, batch of feeders, scanner templates etc.
7. Exposure to Mreports; Mreport to Datamart migration experience is desirable.
8. Experience with Simulation and Risk Matrices.
9. Experience with Market risk and credit risk report development.
10. Experience with RDBMS, e.g. Oracle, Sybase.
11. Excellent SQL programming skills.
12. Unix experience necessary; shell programming experience highly desirable; awk, sed, and Perl scripting experience would be a bonus.
13. Experience with at least one reporting tool, preferably Actuate eRD Pro.
14. Other programming experience a plus, especially MS Excel VBA.
15. Product knowledge (Any one or more, FX mandatory) - FX, IRD, FI, EQD, CRD.
16. Technical skills - Very good knowledge of SQL (Sybase and Oracle), at least one reporting tool (Actuate, Crystal reports, Micro Strategy), basic Unix commands.
17. Understanding of Trade Life Cycle.
18. Should possess an understanding of financial markets.
19. Basic knowledge of financial instruments such as Interest Rate Derivatives.