نبذة عني
A meticulous and methodical data analyst with ten years of experience and demonstrable practice in the end-to-end data lifecycle. Previous employment has helped in developing an acute understanding of stakeholder needs a…
A meticulous and methodical data analyst with ten years of experience and demonstrable practice in the end-to-end data lifecycle. Previous employment has helped in developing an acute understanding of stakeholder needs and consistently advancing one’s competency in data analysis. This resulted in the creation of high-quality automated dashboards/reports for any audience through a furthered ability to translate technical output into easily digestible MI. Moreover, a proven critical thinker and solution provider who continuously creates new ideas, develops useful tools and accurately reports data.
الخبرة
Data Analyst
Supported the regulatory reporting process for loan books, ensuring accuracy, timeliness and policy compliance which reduced compliance risk and strengthened audit readiness.
Developed automated reporting and validation tools using Excel VBA to streamline recurring regulatory processes, cutting processing times from days to minutes.
Analysed and reconciled large datasets using SQL & Power Query to identify discrepancies, resolve queries and provide insights for senior stakeholders and regulators to make faster, evidence-based decisions.
Maintained comprehensive reporting glossaries and data dictionaries which enhanced the MI reporting processes.
Designed and built XML generation tools using Power Query/VBA, eliminating significant ongoing manual effort and saving on future outsourcing costs.
Created Excel VBA validation tools to drastically reduce processing times from days to minutes whilst maintaining the required levels of accuracy to comfortably satisfy audit and FCA regulatory deadlines.
Created self-serving Power BI dashboards for senior management to effortlessly maintain an effective overview of loan book testing.
Data Analyst
Supported the regulatory reporting process for loan books, ensuring accuracy, timeliness and policy compliance which reduced compliance risk and strengthened audit readiness., Developed automated reporting and validation tools using Excel VBA to streamline recurring regulatory processes, cutting processing times from days to minutes., Analysed and reconciled large datasets using SQL & Power Query to identify discrepancies, resolve queries and provide insights for senior stakeholders and regulators to make faster, evidence-based decisions., Maintained comprehensive reporting glossaries and data dictionaries which enhanced the MI reporting processes., Designed and built XML generation tools using Power Query/VBA, eliminating significant ongoing manual effort and saving on future outsourcing costs., Created Excel VBA validation tools to drastically reduce processing times from days to minutes whilst maintaining the required levels of accuracy to comfortably satisfy audit and FCA regulatory deadlines., Created self-serving Power BI dashboards for senior management to effortlessly maintain an effective overview of loan book testing.
Data Analyst
Collaborated with IT/Business stakeholders to understand requirements for the new ERP system.
Produced migration files using data sourcing, mapping, transformation & cleansing techniques.
Reviewed existing access rights governance procedures and implemented improved controls.
Built a suite of Power BI reports and dashboards to provide MI for senior management on access rights and invoice SLA KPIs.
First point of contact for all access rights data quality issues.
Created a highly efficient Excel VBA/Power Query script to collate & transform multiple data sources to produce migration files in a reliable and timely manner on the eve of the event.
A comprehensive range of validation and reconciliation measures was also incorporated to ensure high levels of data integrity for a seamless data migration.
Created a real-time dashboard using Power BI Service allowing users to easily access MI on a self-service basis. The inputs were sourced directly from applications/systems which allowed for automated refreshes without the need for any manual intervention.
Data Analyst
Collaborated with IT/Business stakeholders to understand requirements for the new ERP system., Produced migration files using data sourcing, mapping, transformation & cleansing techniques., Reviewed existing access rights governance procedures and implemented improved controls., Built a suite of Power BI reports and dashboards to provide MI for senior management on access rights and invoice SLA KPIs., First point of contact for all access rights data quality issues., Created a highly efficient Excel VBA/Power Query script to collate & transform multiple data sources to produce migration files in a reliable and timely manner on the eve of the event., A comprehensive range of validation and reconciliation measures was also incorporated to ensure high levels of data integrity for a seamless data migration., Created a real-time dashboard using Power BI Service allowing users to easily access MI on a self-service basis. The inputs were sourced directly from applications/systems which allowed for automated refreshes without the need for any manual intervention.
Data Analyst
Created modelling/reporting tools to provide readily available MI for identifying risks and making timely business decisions.
Tracked the FTE and associated training requirements against increasing service demands.
Monitored the defect fixes of code releases and the end-to-end delivery of change requests.
Tracked resource utilisation across the business to provide on demand activity breakdown over a given period.
Demonstrated an upcoming shortfall in the number of trained staff to support the cheque processing service, which maintained SLAs and avoided any reputational damage.
Produced automated dashboards and reporting mechanisms with Power Query, SQL & VBA which were regarded as the ‘one source of truth’ for MI.
Created an in-house alternative solution for resource planning using Excel, which ensured significant cost reductions.
Data Analyst
Created modelling/reporting tools to provide readily available MI for identifying risks and making timely business decisions., Tracked the FTE and associated training requirements against increasing service demands., Monitored the defect fixes of code releases and the end-to-end delivery of change requests., Tracked resource utilisation across the business to provide on demand activity breakdown over a given period., Demonstrated an upcoming shortfall in the number of trained staff to support the cheque processing service, which maintained SLAs and avoided any reputational damage., Produced automated dashboards and reporting mechanisms with Power Query, SQL & VBA which were regarded as the ‘one source of truth’ for MI., Created an in-house alternative solution for resource planning using Excel, which ensured significant cost reductions.
Runbook Analyst
Oversaw the execution of several data migration events leading up to the ‘Go-Live’ date.
Aligned stakeholders and managed the runbook for each event using the Cutover Enterprise Tool.
Produced readiness & incident trackers to ensure the effective handling of all issues and incidents for each event.
Managed incidents throughout their lifecycle via effective stakeholder engagement and thorough root cause analysis.
Designed real-time VBA reporting for stakeholders to obtain meaningful MI in a timely manner.
Liaised with a third party (Cutover Enterprise) to provide enhancements to their tool and drive the change framework going forward to capsulate weaknesses/improvements.
Runbook Analyst
Oversaw the execution of several data migration events leading up to the ‘Go-Live’ date., Aligned stakeholders and managed the runbook for each event using the Cutover Enterprise Tool., Produced readiness & incident trackers to ensure the effective handling of all issues and incidents for each event., Managed incidents throughout their lifecycle via effective stakeholder engagement and thorough root cause analysis., Designed real-time VBA reporting for stakeholders to obtain meaningful MI in a timely manner, Liaised with a third party (Cutover Enterprise) to provide enhancements to their tool and drive the change framework going forward to capsulate weaknesses/improvements