Project Description :
A leading bank of Singapore is continuing on its Mx.3 migration journey and incorporating Bank's report development requirement to cover various user streams such as Front Office, Back Office, Market Risk, Finance and credit risk related end user or interfaces reports.
Skills required :
- 3-5 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 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 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, Credit Derivatives, Currency Derivatives, Swaps, Futures, Options, FRA, etc.
Nice To Have :
Murex knowledge around - Pricing, Trade repository, Trade validation, MDCS, MxML exchange and workflowsTechnical skills - PL / SQL, Shell scripting, Java, Excel VBAResponsibilities :
Understand the Murex system setup at the client, organisation of the support teams, end of day procedures and the report delivery processCollect and provide detailed technical specifications / business requirement specificationsParticipates in peer review of requirements, technical and / or testing documentation and assists mentors junior members with sameAnalyse 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 objectsSegregate reports by users, products, creation classes, fields needed, complexity and frequency of executionDevelop a generic datamodel and then create datamart objects as required for the reportsExecute processing scripts and batches manually or through the use of a scheduling tool like Control-MReconcile report extraction output with the onscreen / mreport outputAnalyse differences caused by adding or removing some filter conditions / dynamic table flags / launcher flagsCreate and suggest processes, templates and tools to streamline the development, testing and implementation phasesAnalyses issues during planning and test execution phasesProvide relevant and accurate information about defects and help the business reproduce errorsPrepare and send effective periodic and timely status reportsTrack the testing progress and escalate the issue well in advanceAssists in the preparation and execution of test plansIdentifies the conditions that create errors to occur and escalates outstanding issues for clarification and resolutionEscalates identified issues / risks in a timely fashion to the team lead.Assist team lead with effort estimation related to the development and UATEnsures test documentation and deliverables are consistent with defined standardsCoordinate with development and infrastructure team for availability of Mx environments and databaseCreate and maintain report delivery plan with relevant traceabilityHave excellent communication skills, both written and oral