I am a Senior BI and Data Engineering Leader with 25+ years of IT experience, including 15+ years delivering enterprise BI, data platforms, and cloud solutions across Insurance, Finance, Wealth Management, Telecoms, and Education. In my work, I focus on turning complex business requirements into scalable, high-quality BI solutions that drive real business value. I enjoy collaborating with stakeholders and mentoring onshore and offshore teams to deliver results. I specialise in end-to-end BI, ETL, and analytics using the Microsoft SQL Server BI stack (SSIS, SSRS, Power BI), Snowflake, AWS, Azure, and Wherescape, and I’m committed to delivering robust data platforms that support regulatory, governance, and compliance needs.

Anil Nanu Puthalath

I am a Senior BI and Data Engineering Leader with 25+ years of IT experience, including 15+ years delivering enterprise BI, data platforms, and cloud solutions across Insurance, Finance, Wealth Management, Telecoms, and Education. In my work, I focus on turning complex business requirements into scalable, high-quality BI solutions that drive real business value. I enjoy collaborating with stakeholders and mentoring onshore and offshore teams to deliver results. I specialise in end-to-end BI, ETL, and analytics using the Microsoft SQL Server BI stack (SSIS, SSRS, Power BI), Snowflake, AWS, Azure, and Wherescape, and I’m committed to delivering robust data platforms that support regulatory, governance, and compliance needs.

Available to hire

I am a Senior BI and Data Engineering Leader with 25+ years of IT experience, including 15+ years delivering enterprise BI, data platforms, and cloud solutions across Insurance, Finance, Wealth Management, Telecoms, and Education. In my work, I focus on turning complex business requirements into scalable, high-quality BI solutions that drive real business value. I enjoy collaborating with stakeholders and mentoring onshore and offshore teams to deliver results.

I specialise in end-to-end BI, ETL, and analytics using the Microsoft SQL Server BI stack (SSIS, SSRS, Power BI), Snowflake, AWS, Azure, and Wherescape, and I’m committed to delivering robust data platforms that support regulatory, governance, and compliance needs.

See more

Experience Level

Expert
Expert
Expert
Expert
Expert
Expert
Intermediate

Language

English
Fluent

Work Experience

Data Engineering Platform Change Lead at MS Amlin
October 1, 2022 - Present
Led dataset mapping and development for the Marine Cargo Data Lake, aligning implementation with underwriting and finance business rules. Provided technical leadership for the SQL Server migration from IRL1 to IRL2, managing risks and delivering within project timelines. Supported Solvency II Step B reporting enhancements to improve data accuracy and regulatory submissions. Designed and developed SSIS packages to feed BI platforms with validated data. Implemented a flexible, parameter-driven reconciliation framework across multiple data sources. Delivered internal Wherescape training and contributed to capability uplift of the ABS team. Hands-on use of Wherescape RED for ETL automation, scheduling, documentation, and deployment. Championed best practices and documentation standards across BI and Data Engineering teams.
Senior Cloud Developer at Analytics8 (Client: Legal & General)
June 1, 2021 - September 1, 2022
Designed and delivered end-to-end IFRS17 data pipelines ensuring regulatory compliance and auditability. Built Wherescape RED-based ETL, automated workflows, and scheduled pipelines. Produced business requirements, technical specifications, and end-to-end solution documentation. Developed conceptual, logical, and physical data models aligned to insurance reporting needs. Worked closely with senior stakeholders to translate regulatory requirements into scalable technical solutions.
Senior SQL Server Developer at Smith & Williamson
July 1, 2020 - June 1, 2021
Delivered full-lifecycle BI/ETL development using SSIS, SSRS, Power BI, and T-SQL. Enhanced existing Wherescape RED packages and improved ETL performance. Provided production support, root-cause analysis, and on-call monitoring. Created efficient reporting solutions and detailed system documentation.
Senior SQL Server Developer at Kier Group
October 1, 2019 - April 1, 2020
Built SSIS ETL pipelines, developed Power BI dashboards, and optimized SQL queries for facilities management reporting.
SQL Server Developer at Tilney Group
October 1, 2018 - October 1, 2019
Delivered BI solutions, automated manual reports, and developed key SSIS/SSRS components for financial operations. Automated previously manual reporting processes, significantly reducing turnaround times while improving accuracy and consistency.
SQL Server Developer at Grant Thornton UK LLP
August 1, 2018 - October 1, 2018
Built high-performance SSIS ETL packages, reducing load times from 1 hour to minutes; Supported data loading and automation for CFO Insights and Place Analytics platforms.
SQL Server Developer at London Metal Exchange
February 1, 2017 - April 1, 2018
Delivered BI and regulatory reporting (MiFID), migrated legacy MicroStrategy reports to SSRS, and built a SQL-based compliance solution to validate market-making activities against contractual terms.
SQL Server Developer at Lloyds Banking Group
February 1, 2015 - December 1, 2016
Delivered BI and reconciliation solutions supporting finance and compliance initiatives, including SOX/SS4 database migration.
SQL Server Developer at Ericsson
December 1, 2012 - October 1, 2014
Delivered telecom ETL solutions and SSRS reporting for O2/Vodafone/LTE projects, automated legacy VBA reporting.
Senior Data Engineer at Virgin Media
February 1, 2011 - December 1, 2012
Developed BI/ETL solutions for Revenue Assurance, migrated DTS to SSIS, and built compliance automation using Netezza.

Education

Postgraduate Diploma – Advanced Computing Technologies at University of London
January 11, 2030 - January 22, 2026
Bachelor of Engineering (Electronics) at Dr Babasaheb Ambedkar Marathwada University
January 11, 2030 - January 22, 2026
Short Course – Financial Markets at London School of Economics (LSE)
January 11, 2030 - January 22, 2026

Qualifications

LM1 London Market Insurance Essentials
January 11, 2030 - January 22, 2026
Microsoft AZ-900 (Azure Fundamentals)
January 11, 2030 - January 22, 2026
Snowflake SnowPro Core Certification
January 11, 2030 - January 22, 2026
ITIL v3 Foundation Certification
January 11, 2030 - January 22, 2026
Microsoft Certified Application Developer (MCAD)
January 11, 2030 - January 22, 2026
Microsoft Certified: SQL Server 2008 – Business Intelligence Development & Maintenance
January 11, 2030 - January 22, 2026
dbt (In Progress)
January 11, 2030 - January 22, 2026

Industry Experience

Education, Financial Services, Telecommunications, Professional Services, Software & Internet

Experience Level

Expert
Expert
Expert
Expert
Expert
Expert
Intermediate

Hire a Database Developer

We have the best database developer experts on Twine. Hire a database developer in Basingstoke today.