Experience

  • Data Warehouse Engineer

    at Citigroup

    October 2015 - at Present

    Leinster

    @ Data Warehouse modelling & development as part of a migration from Oracle to IBM Netezza. @ Bash-based script development of the Data Integration layer to validate & process files into Netezza. @ IBM Netezza PL/SQL development of data workflows serving data to Qlikview dashboards. @ Qlik script programming to validate data and generate QVD files for reporting. @ Lead on design and implementation of in-house built PL/SQL Unit Testing framework. @ Lead on design and implementation of DevOps practices through the development of Database-oriented frameworks to carry out Continuous Integration, Continuous Testing, Pre-deployment staging & Automated Release testing. @ Implementation of serving layer for the new Hadoop-based IBOR Funds data visualisation platform and Performance Tuning in Cloudera Impala/Hive.

  • Oracle DB Analyst Developer

    at Citigroup

    June 2013 - October 2015

    Leinster

    @ Design and development of the key database components in the next generation of Investors Services data delivery and reporting system in Citi Securities and Fund Services group. @ Oracle Data Warehousing & ETL development (Ab Initio) of Citi’s new IBOR reporting platform. @ Lead on design & development of a fully metadata-driven Data Quality application as part of automated testing to deliver MIS testing progress metrics and meet our client’s IBOR requirements. @ UI development with Oracle APEX on top of a Data Quality engine and to enable internal data reporting and visualisation. @ Requirements gathering & Data Modelling (Oracle SQL Data Modeler) of database components. @ Analysis of IBOR Data testing results based on the transaction lifecycle and asset class agreed with the client as part of SIT & UAT testing.

  • QA Engineer Intern

    at Telefónica I+D

    November 2011 - May 2012

    Madrid

    @ Provides back-end technical support to Telefonica's web & mobile applications. @ Testing, debugging and identifying reported issues, mostly in the application's database layer (T-SQL/Stored Procedures). @ Database performance analysis in SQL Server as part of the troubleshooting tasks. @ Documentation and liaising with the development team as well as application SIT/UAT testing. @ Unix & Oracle 11g 4-week training.

  • Business Analyst

    at American Express Europe Limited UK

    October 2009 - September 2011

    Brighton and Hove

    @ Large corporations account maintenance across several European markets. @ VBA development of Excel-based applications to automate account maintenance procedures which involved processing input data, executing actions in a console user interface and creating reports on those actions output. @ Analysis of the team's procedures to identify areas for possible automation or workflow enhancement. @ Documentation of newly automated processes to build a knowledge base and remove dependencies on individuals knowledge. @ Line Instructor for new recruits.

Education

  • Certified Scrum DeveloperSM (CSD®)

    at Scrum Alliance

    2018 - 2018 (1 year) Leinster

  • International Financial Markets

    at Universidad Nacional de Educación a Distancia - U.N.E.D.

    2014 - 2016 (2 years) Madrid

  • Computer Science Engineering (Erasmus)

    at Sapienza Università di Roma

    2008 - 2009 (1 year) Lazio

  • Computer Science Engineering

    at Universidad Complutense de Madrid

    2004 - 2009 (5 years) Madrid

Languages

  • English Negotiation

  • Spanish Native

  • Italian Negotiation

Hives