Principal Data Performance Engineer at Bajaj Allianz Insurance (2024-03 – 2025-07)
- Tuned and optimized data processes and procedures to enhance performance across large datasets.
- Optimizing data processes across the OLTP/OLAP environments for better scalability, portability and readability.
- Identifying and resolving bottlenecks in complex pipelines and workflows.
- Reduced data pipeline processing time by 35% through optimization.
- Managing a team of Data Engineers and Analysts.
- Stakeholder management.
- Optimizing ETL/ELT batch jobs, ensuring efficiency and reliability.
- Ensured all data processes complied with defined SLAs and delivery timelines.
- Provided structured knowledge transfer (KT) sessions and internal training to support project handover.
- Advised senior stakeholders on technology procurement decisions, aligning with data architecture needs.
- Ensured full compliance with organisational standards, policies, and data governance frameworks.
Database Developer at OVO Energy (2022-11 – 2023-12)
- Designed and developed new data processes to align with evolving business requirements.
- Rebuilt and modernized legacy data workflows for improved scalability and maintainability.
- Enhanced performance of data processes and procedures for large and high-volume data sets.
- Analysed server performance data in high-load environments to proactively detect and resolve system issues.
- Performed data migrations between heterogeneous platforms, ensuring accuracy and minimal downtime.
- Built and fine-tuned ETL/ELT batch jobs.
- Created real-time data acquisition and validation pipelines to support business-critical applications.
- Implemented and supported HADR solutions, including failover strategies and backup configurations.
- Providing knowledge transfer (KT).
Technical Manager at DBS Bank (2020-07 – 2022-10)
- Led the data team, ensuring efficient delivery and alignment with project goals.
- Oversaw stakeholder engagement and ensured all SLAs and project timelines were consistently met.
- Developed and implemented data management strategies tailored to varied business requirements.
- Resolved technical and functional escalations, acting as a key decision-maker in critical scenarios.
- Authored data validation procedures to maintain data integrity across systems.
- Planned and executed large-scale data migrations, ensuring minimal downtime and data accuracy.
- Designed and built data processes for efficient pipeline orchestration and data flow.
- Developed, monitored, and resolved issues in complex ETL/ELT pipelines.
- Handled ad-hoc data requests and functional requirements from business units.
- Performed in-depth SQL/T-SQL performance tuning to improve system throughput.
- Delivered technical knowledge transfer (KT) and process training sessions to internal staff.
SQL Server DBA / Developer at British Heart Foundation (2019-12 – 2020-05)
- Designed and developed robust T-SQL procedures to support business operations and reporting.
- Tuned and optimized SQL scripts to improve system performance and query efficiency.
- Created and scheduled ETL/ELT batch processes for data transformation and integration.
- Developed backend procedures to support the Blackbaud CRM application, ensuring data consistency and reliability.
- Re-engineered legacy data workflows to enhance scalability, maintainability, and execution speed.
- Executed complex data migrations across multiple environments.
- Engaged in stakeholder management, translating technical solutions into business value.
- Implemented and enforced data security standards across SQL environments.
- Configured and maintained Always On Availability Groups to ensure high availability.
- Administered and supported the HADR infrastructure, including replication and failover mechanisms.
Sr. SQL Developer at Santander Technology (2018-10 – 2019-11)
- Designed and automated robust data processes and pipelines for both transactional (OLTP) and analytical (OLAP) systems.
- Collaborated closely with data scientists and analysts to support advanced analytics and reporting initiatives.
- Performed extensive data cleansing and exploratory data analysis (EDA) to improve data quality and usability.
- Developed and maintained interactive reports using SSRS and Power BI, ensuring secure access and data integrity.
- Implemented data and report-level security controls in line with compliance requirements.
- Authored comprehensive technical and process documentation to support knowledge sharing and operational continuity.
Lead Database Developer / DBA at AUTONET Insurance (2011-07 – 2018-06)
- Led the Data & Analytics teams, driving the development and maintenance of scalable, high-performance data platforms.
- Acted as a technical liaison with stakeholders, contributing to project planning, architecture reviews, and data strategy initiatives.
- Designed enterprise-level data models, flowcharts, and dictionaries, aligning data structures with evolving business requirements.
- Developed real-time data ingestion pipelines from legacy VMS systems to SQL Server using Dynamic SQL and SSIS, enabling seamless integration.
- Built robust ETL/ELT processes to migrate and transform data across hybrid environments (on-premise to Azure/Snowflake).
- Created comprehensive data validation and quality frameworks for mission-critical processes such as payment processing.
- Developed and integrated backend systems for bespoke HR applications, leveraging Cascade and Worksmart(WFM) for compliance reporting.
- Designed WFM dashboards using IEX and integrated telecom datasets (Mitel CCM, Rostrvm) to support call centre operations.
- Delivered SSRS reports and real-time analytics for HR, recruitment, and operational teams, boosting decision-making capabilities.
- Conducted thorough data profiling, cleansing, and normalization to enhance data reliability and cross-system consistency.
- Ensured compliance with FCA, PCI DSS, and GDPR through secure architecture and data governance protocols.
- Implemented automation and performance tuning to improve throughput and minimize system latency for data pipelines.
- Managed SQL Server infrastructure, including HA/DR configurations (Always On, Replication, Mirroring, Log Shipping).
- Diagnosed and resolved high-impact database/server issues, maintaining continuous uptime and performance benchmarks.
- Partnered with Web and MI teams to architect unified, end-to-end data workflows for enterprise applications.
- Advised senior leadership on technology investments and infrastructure upgrades based on cost-benefit analysis.
- Created in-depth documentation and led training and knowledge transfer sessions to upskill internal teams.
Database Developer / DBA at CMS Infosystems (2009-04 – 2011-05)
- Developed and optimized T-SQL scripts, stored procedures, and backend workflows to support operational systems.
- Built and maintained ETL pipelines using SSIS for automated data integration.
- Designed and generated SSRS reports for business users and operational insights.
- Executed data migrations from legacy systems into upgraded SQL Server environments.
- Managed database backups and implemented recovery strategies for business continuity.
- Configured disaster recovery solutions including Log Shipping and Mirroring.
- Contributed to a secure data governance strategy to ensure data integrity and compliance.
- Installed, configured, and upgraded SQL Server instances to meet business needs.
- Wrote and maintained custom SQL procedures aligned with functional requirements.
- Documented key processes and configurations to support audits and internal training.
Database Developer at Dell Technologies (2007-02 – 2008-08)
- Supported backend development for enterprise data systems; contributed to database upgrades and scripting.
