Fabio Mocci

Experienced Business Intelligence Consultant and Data Warehouse Developer with over 11 years of experience in the field. Proven track record in managing complex DW systems, including work with cloud technology. My expertise lies in enhancing coding efficiency, leading to significant reductions in execution time. Worked with renowned organizations such as Equifax and HSBC Bank, where I developed and supervised the testing of new platforms and implemented new requirements from regulatory or business stakeholders. Skilled in various tools and methodologies including SAS, Agile, Scrum, and Jira. Now seeking new opportunities to leverage and develop new skills and experience in a challenging role, currently on a self-learning Python path.

Early optimisation is the root of all evil [D. Knuth]. My list of priorities is making it work, making it pretty, making it fast. 

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.

Master’s degree in Computer Science, University of Rome “La Sapienza”, 2006 – 2010

Bachelor’s degree in Computer Science, University of Cagliari, 2002 – 2006

SAS Base Certified programmer for SAS 9 (BP035770v9), October 2013