Available to hire
I am a Data Analyst with expertise in the Banking and Insurance sectors, specializing in data analysis, reporting, and visualization. Skilled in Power BI, DAX, Power Query, MS SQL, QlikView and Advanced Excel to deliver actionable insights.
Hands-on experience with SSMA and data migration projects, including migrating data from Oracle to MS SQL, performing data validation, and integrating source Oracle databases with target MS SQL systems. Experienced in database management, data governance, and automating reports to enhance efficiency and accuracy. Adept at transforming complex datasets into meaningful visualizations and collaborating with stakeholders to support strategic decision-making.
Experience Level
Language
English
Fluent
Work Experience
Data Migration Engineer at The Access Group
September 1, 2025 - September 1, 2025Collaborated within a team to migrate a business-critical system from a third-party hosted data center to an internal on-premises environment. Utilized SSMA, SQL and Oracle to transfer legacy Oracle data onto MS SQL Server databases, enabling the new data center infrastructure.
MI Analyst at BTO Solicitors LLP
January 1, 2025 - January 1, 2025Developed and maintained Power BI reports and dashboards, integrating data from multiple sources to provide meaningful insights for Insurance business. Used DAX and Power Query to create complex calculated measures, transform data and optimize reporting processes. Designed and implemented data models in Power BI, improving reporting efficiency and visualization capabilities. Migrated reports to Power BI ensuring accuracy and consistency with legacy data. Automated financial and operational reports in Excel using VBA macros, reducing manual effort.
PPI Data Gatherer at Lloyds Banking Group
October 1, 2019 - October 1, 2019Collected and consolidated PPI data from multiple banking systems and external sources (CSV & ASCII files). Validated PPI data and applied PPI rules to determine appropriate actions, such as requesting additional details from customer, confirming refund eligibility, escalating cases to the PPI admin for further review.
Business Data Analyst at Royal Bank of Scotland (RBS)
July 1, 2019 - July 1, 2019Provided actionable insights by identifying data discrepancies and recommending improvements to enhance the data lifecycle for seamless system integration. Collaborated with business stakeholders to define business rules and translated them into technical requirements for data transformation and mapping. Mapped data items for transformation to build customer database, ensuring GDPR compliance and company security policies. Designed and developed SQL stored procedures to retrieve data; monitored data integrations, Oracle packages, and SQL scripts to ensure optimal performance. Created data governance artifacts including a Business Data Dictionary to support data quality and regulatory compliance.
Senior Consultant at Capgemini UK (Client – Barclays Bank)
February 1, 2018 - February 1, 2018Collaborated with business users to understand requirements and transform data, supporting ETL processes; developed and maintained a Business Data Dictionary; published HMRC MIFID II Top 5 reports; created data marts and dashboards in QlikView; used SSIS/SSMA for data transfer from Oracle and Teradata to MS SQL Server 2012; supported DBA with data structures, partitioning, indexing, and materialized views.
Data Analyst at AIB Bank Centre
April 1, 2016 - April 1, 2016Involved in banking campaigns using Teradata and QVD servers; created sample datasets; maintained Hyperion BI tool reports; developed QlikView sales dashboards; retrieved campaign data from Teradata for client marketing promotions; collaborated with Consumer Insights to support data-driven decision-making.
Data Scientist at Hewlett Packard
October 1, 2015 - October 1, 2015Defined KPI dashboards in QlikView for KPI monitoring by manufacturing line; integrated data from shop floor monitoring nodes and hand-held tills into HP Vertica; presented KPI data by production line, hour and shift for operational insights; supported data analytics and variance reporting.
Data Analyst at AIG
December 1, 2014 - December 1, 2014Led the MBR project, managing the monthly data mart for business reports across EMEA and APAC regions and developed QVD format files for QlikView applications. Validated and cleansed EMEA and APAC data; wrote SQL scripts for data manipulation and reporting using DB2 and SYBASE; developed physical and logical data models using ERWIN; managed database migration from Sybase to DB2 with DataStage to build ETL scripts.
Database Engineer at Storm Technologies
July 1, 2014 - July 1, 2014Fine-tuned complex PL/SQL scripts, leading to significant performance improvements in Oracle databases; enhanced stored procedures and packages; enabled built-in analytical functions and integrated user-defined business rules; provided consulting for VB-based pricing and quotation systems.
Education
Qualifications
Master of Science (Applied Mathematics)
January 11, 2030 - November 5, 2025System Engineering (Software Technology) - Certificate
January 11, 2030 - November 5, 2025Master of Science (Applied Mathematics)
January 11, 2030 - November 5, 2025System Engineering (Software Technology) - Certificate
January 11, 2030 - November 5, 2025Industry Experience
Financial Services, Professional Services, Telecommunications
Experience Level
Hire a Data Analyst
We have the best data analyst experts on Twine. Hire a data analyst in Glasgow today.