Farana A.

Data Analyst

765 dollar
14 ans

Mon expérience

Voir plus

5i EcomApril 2016 - Présent

Highly rated freelancer in People Per Hour (www.peopleperhour.com).
Provide services in :
- Data Analysis
- Data visualisation
- Tableau dashboards
- Power Bi Dashboards
- Data analytics
- Business Intelligence
Voir plus

RBSFebruary 2015 - April 2016

Analyse and identify Bank's critical applications and infrastructure. Engage with SMEs.
Main Skills: Ms Excel including VLOOKUPs and Pivot Tables to provide a clear view of the data breakdown, SharePoint for document version management, Data management including data import/export, data cleaning, data analysis and reporting.
Voir plus

John LewisJune 2014 - August 2014

Analyse location, control and access of internal data. Analyse options to secure data. Document interview answers and create a list of “Red Flags – Warnings” with any risks or issues found. Create PowerPoint presentation with the “story so far”, to introduce the project, report the findings and provide recommendations to the board of directors.
Voir plus

Ageing Solution Ltd.January 2013 - May 2014

Organise all internal information in Ms Excel and Ms Access Database.
Create a workflow in Ms Visio to automate the insertion of new clients onto the database. Analyse current data and perform a data cleanse, to remove duplication, organize alphabetically and create data mappings on existing information. Create PowerPoint presentations to train staff in the new process.
Voir plus

RBSSeptember 2009 - December 2012

Business Data Analyst for Unicorn Migration from RBS NV to RBS PLC
Apr 2011 – Dec 2012

Facilitate migration and integration of trades from Wall Street NV to Wall Street PLC.
Gather all migration requirements from front office, middle office and technology to create requirements documents and current process flow diagrams.
Attend weekly working groups held with Finance, Operations and Wall Street
Create Ms Access database to automate data in scope, data mappings, data cleansing and reconciliation scripts. This is just a subset of the vast number of actions this database performed.
Create and manage the Run Book for the dress rehearsals and go live.
Maintain and frequently update all lists of portfolios, products, clients and respective mappings.
Reconciliation and data validation checks. Manage an issues log after each Dress Rehearsal.

Senior Change Analyst / Business Analyst

Sep 2009 – Apr 2011

Perform detailed analysis of ATM cash transactions data using MS Access and Advanced Excel to provide different types of trend reports, percentage reports etc.
Understand Business Requirements (BRD) in detail and work together with the Technology team to ensure they create a Functional Spec that correctly reflects these requirements.
Attend and facilitate working group meetings with stakeholders and ensure all actions allocated to the different owners are completed by the designated date.
Create and run User Acceptance Tests (UAT) for Central Telephony Testing.
Coordinate testing during GO LIVE weekend, ensuring all tests are completed and all issues resolved with minimal impact to the customer. - Create and manage the Schedule of Events (SOE).
Create and manage Risks and Issues using RBS standards set by the PMO (Project Management Office).
Voir plus

RBSSeptember 2008 - June 2009

Outlook Email Migration – Migrate over 600 Operations ABN AMRO users as well as the shared mailboxes from Lotus Notes email to Outlook as part of the integration of ABN AMRO into RBS.
Maintain issues log in Ms Excel and ensure any major issues are escalated and resolved.
SWIFT 2008 Upgrade – Manage testing from the Business Side and custodian testing for all the changes applied to Swift.
Calypso 8.04.07 upgrade- Coordinate UAT testing, report test results to stakeholders and document all issues.
SWIFT MT103 Regulatory change to Canadian payments- Support UAT and rollout to all Fixed income business areas. Obtain final sign-off from business.
Voir plus

JPMorgan Chase & Co.March 2008 - September 2008

Test and reconcile in-house data systems with Murex, automate several manual tasks
Create a Stats database in Ms Access to report on the results of UAT tests of the Murex system.
Create an Instrument reconciliation database to report on the breaks in data from Bloomberg, Murex, Front Office, Emerging Markets, ISIS, EMTS. This tool offers further guidance on data issues such as duplication, missing data in certain fields.
Create a Risk reconciliation database that combines risk related data from several systems (FO Risk, Emerge, Bloomberg, EMTS, CHLCIB, and Murex) and outputs the breaks. Known breaks are marked and other breaks investigated by the business. Use of Excel to reconcile data, filter, create pivot tables and VLOOKUP’s to analyse data and SQL within Access to create optimized queries.
Voir plus

HSBCJuly 2007 - February 2008

Design and manage the rollout of a Status Pack that reports data accuracy, data completeness, reconciliation and many other aspects that will affect the RWA (Risk weighted assets) figures for BASEL II.
Create and analyse MI packs to manage the improvements in the data clean-up process.
Create database to report on AGREE data reconciliation and data completeness.
Perform AD-HOC data analysis in Excel and using SQL to extract data.
Voir plus

Barclays Wealth ManagementMarch 2007 - June 2007

Design databases to manage credit exposure and calculate shortfalls using Ms Access and VBA (functions). Map different credit systems such as S&P and Moody’s with the in-house systems, and provide a detailed analysis of the results. Analyse data from different sources and provide reports is Excel and Ms Access.
Voir plus

Deutsche BankOctober 2006 - February 2007

Work closely with Operations and IT to create a monthly Brokerage MIS report. Implementation of MIS reports for Global Equity Derivatives – Over the Counter (GED-OTC) and Agent Banks using Ms Access (including Macros and functions) and Excel (including Pivot and Lookup). Document a user guide and a technical spec. Provide training and support to a team based in Asia. These MIS reports contributed towards a saving of $33 million in 2006.

Mes compétences

Computer Tools

Microsoft Excel, Microsoft PowerPoint


Python, SQL, Swift




Business Analysis, Analytics, Data analysis, Team management, Design, Data Migration

Business Intelligence

Power BI, Business Intelligence, Tableau Software

Application servers

Microsoft SharePoint

Big Data

Hadoop, Big Data


MS Access

Software testing

User Acceptance Testing


Data management, Microsoft Outlook, Microsoft Office, Management Information System, tableau, UAT, SQL databases, Python Programming, Risk reconciliation, Lotus Notes/Domino, Data Mapping, Calypso Financial Software, Pivot Tables, Data Modelling, Microsoft Visio, Visual Basic for Applications, Data Cleansing, Business Analyst, Microsoft Access, Powerpoint

Mes études et formations

Data Science Field Of Study Python for Data Science / Big Data - IBM Cognitive Class

Certification in Big Data, Python, Tableau and Power Bi Data Visualisation - University of California and Edureka2017 - 2018

Information Systems Engineering, Information Technology - University of Westminster1995 - 1998