Joined Fidelity Investments as Analyst Programmer for the Enterprise Data Warehouse team.
Started development of standalone module for insurance investment auditing for UK and Ireland.
Designed architecture for staging environments to process transactional data from various sources.
Implemented ETL processes using Informatica PowerCenter and Kimball methodology for data warehouse design.
Completed implementation of FATCA (US) compliance requirements for the financial datamart.
At Fidelity Investments, I served as a Data Analyst for the Enterprise Data Warehouse team, responsible for development and operations on the EDW and Financial datamart of Fidelity UK (mutual funds) and implementation of FATCA (US) compliance requirements.
My primary focus was on the FIL LIFE project, a standalone module developed to cater to the auditing needs of Fidelity Insurance for UK and Ireland — generating comprehensive reports from relational databases and flat files, containing rolled-up and aggregated client assets and holdings data.
The implementation of the FIL LIFE project significantly enhanced Fidelity Insurance's auditing capabilities for UK and Ireland operations. The improved data aggregation and reporting system provided better tracking of capital flows for compliance purposes, while the implementation of FATCA requirements ensured regulatory compliance. The optimised data warehouse design using the Kimball methodology improved query performance and reporting efficiency.
Happy to discuss the EDW architecture, FATCA compliance implementation, and financial data warehousing approach used in this role.