Aadarsh

Experienced Data Professional with 15 years in Financial, Energy and services sectors. Proven expertise in development, administration, and Business Intelligence (BI) solutions. Skilled in team leadership, stakeholder engagement, and building high-performance, compliant data systems.

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.

MSc in Computer Science – Staffordshire University (2010)

B.Tech in Computer Science Engineering – JNTU (2007)