Data Warehouse Engineer
October 2015 - at Present
@ 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
June 2013 - October 2015
@ 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
@ 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.
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.
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
Knowledge and keywords