operational risk

Eby Ubani

Mob: +447*********, email: **********@*****.***

PROFILE

I am a highly skilled Analyst with extensive technology and business

experience in the financial industry. I have very strong technical

background and proven ability to provide business solutions from carrying

out complex data analysis on large datasets in an ever changing and fast

paced environment utilizing business intelligence/data warehouse

technologies. I have extensive knowledge of Operational risk data;

Operational risk reporting (MI); supporting operational risk framework

(Loss Data, KRI and Scenario analysis) and operational risk systems

functionality build and implementation. My exposure and experiences have

provided me with an in depth understanding of effective and comprehensive

capturing, analysing and reporting of operational risk; and the importance

of data quality/accuracy whilst implementing data quality control measures

to improve operational risk management and measurement.

EDUCATION

. University Of Port-Harcourt - B.sc (Hons) Maths/Computer Science

2005

. University Secondary School -

2000

. MCTS (SQL 2005) 2007

. Investment Operations Certificate - Operational Risk

2011

. Diploma in Business Analysis Essentials (currently studying for)

2013

KEY SKILLS

. Proficient Excel professional, with excellent Macro development

skills.

. Highly technical with good understanding of development tools

including MS SQL Server 2005/2008 R2, Oracle 10g, SSAS, SSIS, Business

Objects, SSRS. Systems: Windows Server 2003/2008, Markit (Trading

Documents) MS Office: Advanced Excel, Power point, Word, Access, VBA,

T- SQL, PL-SQ

. Excellent ability to present data in appropriate formats, like

workflows for business users or technical drawings and documentations

for technical and non-technical stakeholders.

. Resilient and remains calm under pressure with the ability to

prioritise and multitask.

. Strong analytical and problem solving skills with the ability to work

on own initiative

CAREER HISTORY

Mar 2014 - Date JP MORGAN CHASE BANK- CIB

Operational Risk MIS Analyst - Regulatory Risk and Control

July 2013 - Jan 2014 ROYAL BANK OF SCOTLAND

Analyst - M & IB Documentation, Risk Management

Worked with the Legal Documentation Team where ISDA Master Agreements for

OTC, CSA, Repo, Clearing and Sec Lending Trades are negotiated, processed

and managed. I am responsible for generating all MI Reports/metrics for

management on key Credit Risk, Master and Collateral Agreements data.

Data Analysis and MI Reporting

. Working closely with IT support /BI architect to design and build a

robust self-reporting MI tool, utilising data warehouse technologies

and report builder. I was responsible for gathering business

requirements, and using this requirement to produce a technical

specification requirement whilst working with both teams to manage

expectations.

. Support IT in applying improvements to the OTC derivative

documentation system in other to enhance/ improve management

information reporting within the team.

. I developed VBA macro's to automate various MI reports involving

manual and repetition tasks to reduce the risk of error and improve

the reporting time.

. I supported the delivery/implementation of process to abandon ISDA

agreements where negotiations have not progressed.

. Regularly liaising with client on-boarding team to facilitate

successful on-boarding of new clients/counterparty.

. Supporting front office through advising on various stages of ISDA

negotiations and confirmation.

. Mapping credit risk exposures to existing agreements to ascertain

whether certain agreements need to be abandoned due to no credit

limits or exposures.

. Producing accurate and timely MI for various businesses (Front Office,

CIB, and Collateral Management) within the bank;

. Undertaken data reconciliation on all agreements to provide visibility

on the various systems that hold the various types of agreements (

Repo, Sec lending )

Regulatory Reporting

. Supporting credit risk with adhoc regulatory report request as

required

. Maintaining status tracker for EMIR portfolio's within the

documentation team/ updating CTT

. Sending and confirming executed EMIR amendments/EMIR compliance to

client on-boarding

. Supporting Dodd Frank process and fast track funds on-boarding;

running reports to allow fund on-boarding subject to Dodd Frank

Sep 2010 - Jun2012 ASSOCIATION OF BRITISH INSURERS

Operational Risk Analyst - Operational Risk Consortium

Operational Risk, Data Quality & Controls

. Supporting various operational risk frameworks through capturing,

analysing and the reporting of operational risk data/ losses in the

insurance industry on a quarterly basis. Some of the insurers

supported include (Aviva, HSBC, Scottish Widows AXA, RSA, Swiss Re,

Prudential)

. Acting as first point of contact for data loads, with a focus on

validating captured data and resolving any operational risk data

related issue/abnormalities whilst carrying out data quality

assessment on the loss data to ensure accuracy and completeness of the

data as part of solvency II requirements to include external loss

data.

. Analysing operational risk event data (using advanced Excel),

identifying operational risk trends in the data within the insurance

sector and producing commentary high - level business MI risk reports

for stakeholders senior management showing severity and frequency

distributions of Operational risk losses within various business

functions, providing valuable insight in other to enable risk managers

make strategic risk decisions

. Presenting risk reports and communicating identified trends at

management committee meetings along with suggested control measures

based on root cause analysis and findings. I also lead discussions on

data quality issues from source and recommending areas of improvement

from both the source and consortium.

. I successfully drove gap analysis project benchmarking the IT

infrastructure and IS risk against ISO 27001; one of my achievements

from this exercise was the design of an effective and sufficient

business continuity (data disaster and recovery) plan as part of

control/mitigating measures for the organisation utilising my database

administrative skills and experience

. Facilitating IT security risk assessment/audit undertaken by PWC,

worked alongside external auditors to identify risk exposure within IT

systems security and recommend remediation. I documented step by step

process, findings and actions needed to be taken whilst working with

technology and third party vendors to resolve systemic issues to

achieve a robust system

. I ensured timely Implementation of new controls or existing control

enhancement as required (system upgrades and re-configuration, code

updates or changes etc.) to mitigate related risk or reduce its

likelihood of occurrence

. I have implemented various system controls where controls are not

effective, through developing solutions using T-SQL in other to

minimise and mitigate the risk exposure associated with the quality of

the data whilst producing a comprehensive 'data capture control

framework' for the completeness, accuracy and validity of external

operational risk data held by ORIC as part of the quality assurance

strategy.

. Developing and maintaining full systems documentation - I documented

all systems processes and procedures; Risk system functionality and

maintenance procedure; 40 high-level SSRS developed risk reports

highlighting purpose, usage and design structure.

Business Analysis/Technical Support/ (SQL, SSRS, SSIS, RiskSys)

. Responsible for the delivery of new operational risk system

benchmarking functionality

. Led project on the implementation of new bespoke Operational Risk

system (Arc Logics) for ORIC's loss data working through the entire

SDLC life cycle. I was responsible for drafting business case,

requirement gathering from the business, identifying quantifiable

measures for the success of each goal, documenting the business

requirements specification and technical specification, UAT test cases

to its release into production and post-implementation documentation.

The importance of questioning and quantifying business requirements as

to their validity has been critical throughout.

. I managed effective and productive relationships with third party

vendor suppliers and our members; liaising with IT vendors through

regular meetings with senior product managers and developers and,

closely monitoring work in progress relating to development of new

system functionality or upgrades to existing system and working with

them to ensure we meet agreed delivery deadline.

. I drove through strategic solutions focusing particularly on data

quality controls within risk capture system (Arc Logics) and

operational risk benchmarking. Most notable amongst these was the

successful delivery of automated benchmarking operational risk report

using MS SQL business intelligence tools (T-SQL, Stored procedures,

SSRS).

. Engaging with members and stakeholders through working party groups to

capture report specifications, agree on definitions and data

requirements for these benchmarking reports

. Development of high-level operational risk benchmarking reports

allowing members benchmark their operational risk loss exposures with

'like for like' entities based on Numbers of employees, Gross written

premiums and business line( as scaling factors) using SSRS and T-SQL

. Delivering operational risk system training to both existing and

potential stakeholders

Sep 2009 - Sep 2010 JADANT LTD

Technical Helpdesk/Support Analyst - Voluntary

-

Sep 2007 - Sep 2009 Maternity Leave

Jan 2006- Sep 2007 B&I SOLICITORS

SQL/BI Developer

. Overseeing all aspect of this top firm's database, this included

implementation, administration, monitoring, tuning, backup and

recovery, migration, and support.

. Building firms databases scheme, tables, stored procedures, views,

triggers, and permissions

. Develop database utilities and automated reporting

. Analyse and sustain capacity and performance requirements

. Analyse, consolidate and tune database for optimal efficiency

. Monitor systems and platforms for availability.

. Analysing large data set using SSAS ; presenting data in various

dimensions for business users

. Performing ETL processes to migrate data

Contact this candidate