Position

Murex Datamart and Reports Developer


Project Description

Reporting and Batch Integration Enhancements and fixes on Murex 2.11 - BAU development for a large Australian Bank

Responsibilities

General Responsibility:
2. Self driven and able to delegate work to team members
3. Able to review work from team members
4. Strong analytic and technical skills
5. Gone through at least 2 full cycles of SDLC
6. Good understanding of usage of various dynamic tables
7. Good knowledge of one or more development tools
8. Able to configure, execute and troubleshoot batch report in MXG
9. Able to design and optimize usage of dynamic tables
10. Able to guide team members
11. Ensure all deliverables are good and timely
12. Able to escalate issues/risks in a timely manner to supervisor
13. Good communication skills

Murex Application Responsibility:
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. Participates in peer review of requirements, technical and/or testing documentation and assists mentors junior members with same
4. 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
5. Segregate reports by users, products, creation classes, fields needed, complexity and frequency of execution
6. Develop a generic datamodel and then 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. Analyses 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 the issue well in advance
15. Assists in the preparation and execution of test plans
16. Identifies the conditions that create errors to occur and escalates outstanding issues for clarification and resolution
17. Escalates identified issues/risks in a timely fashion to the team lead.
18. Assist team lead with effort estimation related to the development and UAT
19. Ensures test documentation and deliverables are consistent with defined standards
20. Coordinate with development and infrastructure team for availability of Mx environments and database
21. Create and maintain report delivery plan with relevant traceability
22. Have excellent communication skills, both written and oral
23. Try to increase team's domain and application knowledge through formal / informal sessions or discussion

Skills Required

Mandatory Skills: •

At least 3+ years of experience on MX G2000/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 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
• Experience with Simulation and Risk Matrices
• 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

Desired Experience: Murex knowledge around - Pricing, Trade repository, Trade validation, MDCS, MxML exchange and workflows
Technical skills - PL/SQL, Shell scripting, Java, Excel VBA


Understanding of Trade Life Cycle (Pricing>>Booking>>Validation>>Confirmation>>Settlements>>Accounting>>Reporting>>Events>>Market Risk>>Credit Risk>>Market Data etc)
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.
Bachelors Degree from a reputed university with good passing scores