Management Data

LUIS MORA

****(*)771-***-**** - *****.****.*****@*****.***

Professional Profile

Dedicated, diligent and highly accomplished Economist with a MSc in

Management and a wide experience in financial markets gained undertaking

roles in companies ranging from money transfer organizations to investment

banks. Possesses a deep knowledge of MS Excel, Essbase, XLCubed, MS

Access, VBA and SQL Server and is quick to grasp new ideas and concepts

whilst identifying key improvements to working practices and procedures to

maximise efficiency and reduce risk without compromising quality. Proven

capacity to lead teams towards the consecution of objectives as well as

building and maintaining business relations with clients and stakeholders.

Employment History

Senior Analyst

McLagan, London, UK - February 2012 - present

McLagan is a management consulting firm that works with financial service

firms. Clients include virtually every leading global financial services

company, including investment, commercial and retail banks, securities

firms, investment management organizations, hedge funds, and insurance

companies.

o Member of the team responsible for supporting SQL databases and

ensuring their performance, availability, scalability and security.

o Working on developing McLagan's financial benchmarking capabilities

for Corporate Banking and Investors

o Liaise with business stakeholder to gather and understand their

objectives and requirements

o Designing, developing, and maintaining data warehouse and Business

Intelligence solutions

o Participate in providing data gap analysis, from a technical

perspective, highlighting current state, future state, stakeholder

needs and best practices.

o Playing an active role in helping to develop Gauge core Data &

Analytics capabilities, products and services to meet client needs.

o Prepare and deliver accurate, concise and clear reports, analysis,

presentations including: Revenue & Productivity Analysis, Payout

Ratios, Cost by Detailed Expense Line: Comp & Non Comp, Location

Strategy & Trends / Cost, etc.

o Management of allocation processes for the back office business units.

o Work closely with clients, to deliver the potential for improved

performance through the use of data and analysis

FX Accounting Control - Associate - senior derivatives and data analyst

Bank of America, London, UK - February 2010 - December 2011

Key achievements: Designed, developed and implemented scorecards and

reports for senior Management currently used in GFX Accounting Control and

EMEA FX Investigations. Created user friendly interfaces between various

bank systems and Excel to improve access to information. Designed

exceptional Excel based reports using macros and VBA increasing the

accuracy of the MIS reporting process. Developed the GFX confirmations

reporting tool - an outstanding Excel/VBA based application that sends

automatic emails to counterparties attaching the trades to be confirmed.

o Senior member of the FX MLIB Accounting and Control team. In charge of

the design and implementation of the daily and monthly reports to

Management

o Re-engineered of existing business processes and reporting tools for

various departments ensuring that data controls are sufficient

o Built the new Front Office vs Back Office GFX Cash Position

Reconciliation.

o Identified business requirements through analysis by working with

users/stakeholders

o Produced and maintained training documentation to facilitate knowledge

transfer

o Planed and coordinated the development, testing and delivery of

tools/applications for various departments with users and development

teams

o Examined data inaccuracies and generated improvements in data

cleansing processes

o Suggested and successfully developed reporting tools to open, export

and convert files from web based banking systems to Excel spreadsheets

o Designed and enhanced MIS reports for GFX Accounting and Control, GFX

Investigations, Fixed Income and Treasury

o Actively involved in the UAT testing leading to the migration process

of the FX trades from the BANA environment to MLIB

o Designed maintain and improve the Key Performance Indicators (KPI),

the Scorecards and the reporting for MLIB Settlements

Swaps and Derivatives Operations and data analyst

Bank of America, London, UK - December 2007 - January 2010

Key Achievements: Redesigned the Rates and Credit Derivatives Funding

Reconciliation, improving the daily report from a manual reconciliation of

two currencies to an automated process that reconciles 17 currencies.

Reduced report preparation process by 95% (from over 2 hours to less than 5

minutes). Decreased the average daily variation of balances from over 45%

to under 3%

o Senior Member of the Control Group within the legacy BofA Back Office

covering different lines of business (Fixed Income, Treasury, FX,

Derivatives)

o Responsible for the Derivatives Funding Reconciliation team

o Designed the process to capture data and populate the Markit month end

metrics for Derivatives, Treasury, and Fixed Income.

o Successfully migrated the Derivatives reconciliation processes from

the old Meridian environment to Cash Manager

o Proposed and successfully developed the daily funding report for the

Interest Derivatives Settlements team, reducing the processing time

from over two and a half hours to less than 5 minutes.

. Wrote VBA macros to capture data from the Settlements systems

into excel

. Developed macros that exclude trades with booking errors and

include those amended from previous days to generate accurate

settlement balances

. Anticipated the need for reporting tools and created robust macros to

generate the daily metrics and KRI.

Senior Financial and Data Analyst

Money Express Ltd, London, UK - January 2007 to June 2007

o Senior financial and data analyst for money Remittance Company with 7

million in annual turnover.

o Managed a multidiscipline team, including accounting, reconciliations

and client service

o Designed excellent FX, bank and intercompany balances controls using

MS Excel Macros

. Increased frequency of intercompany and FX balances

reconciliation from monthly to daily.

. Designed and implemented FX balance control increasing accuracy.

. Reduced daily bank reconciliation processing time by 80%

. Liaised with daily FX transactions of $200K, as well as booking

deals

Data Analyst - November 2006 to January 2007

Matrix Registrar Ltd, London, UK - November 2006 to January 2007

Part of the VCT (Venture Capital Trusts) and Registrars team

. Processed data and gave regular updated reports regarding

investors' holdings to other departments including Marketing,

Sales and Properties.

. Addressed and resolved investors' queries related to stock

prices and stock transfers.

. Developed and implemented an MS Access and MS Excel based system

for the VCT division which generated accurate and reliable

monthly statements of stock holdings

Market Research (Internship)

Argus Vickers Ltd, London, UK - August 2006 to October 2006

Worked in the development of a new asset management product for a

company specialized in reporting equity ownership.

. Designed an MS Excel spreadsheet to summarize all information

gathered.

Senior Financial and Data Analyst - International Liaison

LCC Trans Sending Ltd, London, UK - April 2004 to October 2005

Redesigned and managed financial procedures for a Money transfer

company with 100 million in annual turnover.

. Redesigned daily and monthly inter-companies balances with the 5

branches abroad, improving the accuracy of the data and reducing

the information flow

Improved accuracy and functionality of all 16 payees of the South

American Channel

. Designed and applied a MS Excel and MS Access database reducing

processing times by 50%

. Prepared the profits and forecast reports of the South American

and Asian Markets.

. Liaised with banks within the UK and abroad regarding daily

balances, Chap transfers, bank charges and foreign exchange

rates.

LANGUAGE SKILLS

Fluent in English, reading, writing and speaking

Spanish is native language

Intermediate level in Portuguese, reading and speaking

INFIRMATION TECHNOLOGIES SKILLS

o MS Excel (Macros, Pivot tables, VBA)

o MS Access

o SQL server

o Essbase

o XLCubed

o Visual Studio

o Qlikview

EDUCATION

2007 - John Moores University, UK, MSc Management

2006 - University of Wales Institute, UK, MBA - Marketing

1998 - Universidad Militar Nueva Granada, School of Economics,

Colombia - BA in Economics (5 years)

INTERESTS

Squash

Travel - I have visited 16 different countries on 3 different

continents

Contact this candidate