Summary
Overview
Work history
Education
Skills
Websites
Volunteer Experience
Quote
Timeline
CustomerServiceRepresentative
ANKIT MEHANI

ANKIT MEHANI

Reading,United Kingdom

Summary

Committed data engineer with over 10 years of experience spanning various industries, leading projects exceeding $100M. Skilled in ETL/ELT, metadata management, modelling, and data integration. Currently pursuing an MSc in Business Analytics, consistently achieving distinction in all projects. Seeking roles that leverage business acumen, analytical prowess, and enthusiasm for automation.

Overview

11
11
years of professional experience
5
5
years of post-secondary education

Work history

Data Science Intern

BATFAST CRICKET CENTRES LIMITED
United Kingdom
04.2024 - Current
  • Utilized advanced statistical and machine learning techniques to analyze 27M deliveries, enhancing user gameplay algorithm and increasing user engagement by 20%.

Senior Data Consultant

PRUDENTIAL ASSURANCE COMPANY SINGAPORE
Singapore
08.2021 - 09.2023
  • Led IFRS17 implementation with agile methods , creating interoperable data ecosystem for finance transformation.
  • Engineered 100+ ETL pipelines , simplifying data migration to reduce project costs and enhance performance.
  • Optimised ETL execution , cutting processing time from days to hours and reducing month-end SLA by 30%.
  • Implemented Azure data governance for IFRS17, ensuring data privacy and access for 1M+ customer records.
  • Led and coached data teams , fostering productivity and personal development for significant achievements.

Manager - Data Consultant

GREAT EASTERN LIFE ASSURANCE
Singapore
11.2016 - 07.2021
  • Orchestrated Python ETL processes via Airflow to migrate 1000TB+ data to Redshift and S3, catalysing finance transformation.
  • Implemented AWS CI/CD with CodePipeline, CodeBuild, and CodeDeploy, cutting deployment time by 50%.
  • Integrated Financial Module with General Ledger postings into IFRS17 through Kafka/BigQuery , reducing latency.
  • Collaborated with DevOps and QA to optimize AWS cloud performance.
  • Utilized Tableau for reports, implemented API integration for TPAs, cutting claim processing time by 20%.
  • Secured two off-cycle promotions for digital transformation initiatives.

Application Consultant

AMK TECHNOLOGY SDN BERHAD, MALAYSIA
Kuala Lumpur
10.2015 - 10.2016
  • Elevated operations at Syarikat Takaful Malaysia Berhad, achieving 25% faster processing through automation and enhancing customer satisfaction and operational efficiency.

Application Developer

COMPUTER SCIENCES CORPORATION
Mumbai
08.2013 - 08.2015
  • Led end-to-end requirement gathering and product development at HDFC Life Insurance, streamlining testing cycles by 25%, reducing post-release defects by 30%, and expediting customer payouts by 50%.

Education

Master of Science - Business Analytics

UNIVERSITY COLLEGE LONDON
London
09.2023 - 08.2024

Bachelor of Engineering - Information Technology

LAKSHMI NARAIN COLLEGE OF TECHNOLOGY
India
06.2009 - 05.2013

Skills

  • Programming: Python, R, SQL and PowerShell Scripting
  • Database Management Systems: MySQL, PostgreSQL, DB2, T-SQL and NoSQL: MongoDB
  • Data Warehousing Tools: Amazon Redshift, Snowflake, or Microsoft Azure Synapse Analytics
  • ETL/ELT and Data Lakes: Skills to develop and orchestrate automated ETL pipelines and data transformations on platforms like Talend, Informatica
  • Cloud Platforms: Microsoft Azure : ADLS, SSIS, SSAS, SSMS, Azure Data Factory, Databricks, and CI/CD automation AWS : EC2, S3, RDS, Glue, Athena, Lambda, QuickSight and Kafka
  • Tools and Platforms: Tableau, Power BI, Spark, RESTful APIs, Jupyter Labs, R Studio, and Tectia
  • Deployment Tools and Version Control: Github , Dockers, Jenkins, Kubernetes(K8s)
  • Data Modelling: Regressions, Decision trees, Reinforcement learning, Neural networks, LLMs and RAG
  • Others: Jira, Share Point, Kanban Board, Trello and MS Office
  • Analytical Skills: Proficient in identifying data issues, optimising performance, and troubleshooting data pipelines
  • Communication Skills: Effective in collaborating with teams to deliver data solutions aligned with business needs

Volunteer Experience

KITH AND KIDS AND UCL, London, Volunteer, 09/2023, Present.


  • Supported 20+ young adults with autism and learning disabilities during activities and events.
  • Organized events for more than 500 students as Student and Volunteer Representative at UCL.

Quote

There’s no shortage of remarkable ideas, what’s missing is the will to execute them.
Seth Godin

Timeline

Data Science Intern

BATFAST CRICKET CENTRES LIMITED
04.2024 - Current

Master of Science - Business Analytics

UNIVERSITY COLLEGE LONDON
09.2023 - 08.2024

Senior Data Consultant

PRUDENTIAL ASSURANCE COMPANY SINGAPORE
08.2021 - 09.2023

Manager - Data Consultant

GREAT EASTERN LIFE ASSURANCE
11.2016 - 07.2021

Application Consultant

AMK TECHNOLOGY SDN BERHAD, MALAYSIA
10.2015 - 10.2016

Application Developer

COMPUTER SCIENCES CORPORATION
08.2013 - 08.2015

Bachelor of Engineering - Information Technology

LAKSHMI NARAIN COLLEGE OF TECHNOLOGY
06.2009 - 05.2013
ANKIT MEHANI