Responsible for the delivery and management of Risk and Finance Business Intelligence platform. Provide analysis, functional and technical documentation of universe and reporting strategy. Develop universe meta-layers using best practice of aggregate awareness, internal views, objects and class definition to ensure structured star schemas. Development of bespoke reporting objects within the data warehouses. Manage financial reports, reconciliations and static reporting. Communication with Product Control, Operations, Front office Support teams, Back office reconciliation teams. Performed scalable upgrade, then migration and consolidation of several reporting streams into clustered BOVXI r2 v3/Oracle repository/Wintel BI server environment. Modelled security, then implemented model and farmed out account creation to systems account management team. Management of products change process, Disaster recovery and failover Provide production support within the Slice IRD department to ensure overnight and intraday batch success, user maintenance and Manual Journal support. Assist the business in data mining, Balance sheet cleansing, month and year end processing. Set up of GL Accounts, books currencies and other static data. Management of the decommissioning process for sub ledger.

Responsible for delivery of projects core financial, selected regulatory and batch processing rec-reports. To document and maintain related business/technical specifications. Develop several star schema universe designs over Oracle data warehouse and Peoplesoft Ledger.Enrichment of the reporting schema to include additional views, tables & procedures flattening of Peoplesoft Tree hierarchies called through Business Objects. Oversee the development of VBA scripting to enhance/automate specific user requirements.Project administration including release management utilising Noad’s QM extension, full test cycle support though to acceptance tracked through Test Director.

Analysis of existing 200+ production reports to determine crossover, classification into planned release of new reporting solution consolidating where possible. Additional development/enhancement of reporting schema within data warehouse to include additional reporting views, procedures & static data loading from clients MM, FX, CRM applications. Development of several universes. Dismantling of complex excel spreadsheets embedded with VBA scripting, rewritten with BO universes or PL/SQL procedures as appropriate. Develop of Bails & Leasing funding program, enhancement of standard GL reports.