Datamart Reporting Consultant

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

Execute processing scripts and batches manually or through the use of a scheduling tool like Control-M

Reconcile report extraction output with the onscreen / mreport output

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