Equifax, London/UK Apr 2021 – Dec 2023
SAS Consultant
Consumer finance data management
- Fully replicated legacy FORTRAN ETL program (with no documentation) to SAS to ingest and transform financial input text files.
- Created reports showing comparison results between legacy program and new SAS process explaining all differences.
- Developed queries to check Data consistency in migration from SQL server to Google Cloud/BigQuery.
HSBC Bank, London/UK Sep 2017 – Dec 2020
SAS FCD Consultant
Developed and supervised development and testing team for the new Stress Testing SAS platform using Agile and Scrum methodology
- Bank Stress Test full SAS program development and integration with IFRS9 engine on Hadoop/Unix file system.
- Implementation of new requirements from regulatory and business stakeholders, program updates accordingly to specific country Stress Test rules.
- Preparation and update of software documentation according to code changes.
CSP LABS Ltd, London/UK Oct 2015 – Feb 2017
Senior BI Consultant
Delivered DW software to address client’s needs ensuring project goals and requirements were met.
- Allowed clients to formulate customized geographic reports into SAS VA through utilisation of geospatial software ARCGIS.
- Expert advice and suggestions on how to improve and optimise tasks utilising SAS platform for a bank Campaign Management Team through deep process analysis.
- Created automated email alert system into a SAS environment.
- SAS program updates on IFRS9 platform for Italian bank.
MARKERSTUDY LTD, Haywards Heath/UK Nov 2014 – Sep 2015
BI & Data Warehouse Developer
Member of MI Team
- Data extraction for clients internal and external to the company.
- Performance tuning: highly reduced job execution time into SAS DI with execution time reduced by 90%.
- Legacy SAS programs import in SAS DI and major job updates into ETL process.
- Development, promotion and documentation of new jobs.
- Reconciliation from old DW (Base SAS code) to new one (SAS DI): found all discrepancies and ensured that all values were correct in the new DW.
- SAS Platform migration assistance from version 9.3 to 9.4.
- Creation of custom transform and Macro libraries into SAS DI which allowed to automate part of the jobs instead of using user written code.
CRISMA ITALIA, Rome/Italy Sep 2012 – Oct 2014
BI Consultant
Assisted in projects with different clients/businesses
- Data warehouse migration from Oracle/DataStage to Greenplum.
- Creation and implementation of forecast models using decision trees (SPSS Clementine and Enterprise Miner). Created a SAS Macro function to convert SPSS decision tree into a SAS tree improving general performance of models by more than 20%.
- Design of new jobs, code fix and updates into ETL process for several clients (using SAS Enterprise Guide and SAS Data Integration).
IPS, Aprilia/Italy Jun 2011 – Jun 2012
Delivery Services Technician
Provided technical support and installation to law enforcement about proprietary wiretapping software
- Mentored new coworkers.
- Installed and configured server and software (running on either Windows or Red Hat Linux) into police stations and law courts.
- Configured network apparatus in client server architecture with remote sites connected by ISDN and ADSL
- Provided remote and on-site support.
ABLATIV SCRL, Cagliari/Italy May 2010 – July 2010
Technical Support
Provided technical support into local council offices
- Lent technical expertise to optimise client workstations into Portoscuso Municipality and put all workstations into the new Windows Domain.
- Improved system performance by identifying problems and recommending changes. Provided assistance about new VOIP system installed.
