I am a senior data engineer with 13+ years of experience turning data into actionable insights and building scalable data platforms. I currently work with Axis Capital to refine reinsurance data and help migrate architecture to Azure, while addressing storage and data quality challenges. I enjoy collaborating with cross-functional teams to deliver data-driven solutions that align with business goals. I thrive on delivering robust dashboards and automated data workflows using Power BI, Tableau, Power Automate, and cloud-based ETL pipelines. I value sustainable data models, clear documentation, and transparency in reporting to support regulatory and business decision-making.I am Microsoft Certified Power BI and SQL developer and working on Power BI since its birth.

Ankit Kumar

I am a senior data engineer with 13+ years of experience turning data into actionable insights and building scalable data platforms. I currently work with Axis Capital to refine reinsurance data and help migrate architecture to Azure, while addressing storage and data quality challenges. I enjoy collaborating with cross-functional teams to deliver data-driven solutions that align with business goals. I thrive on delivering robust dashboards and automated data workflows using Power BI, Tableau, Power Automate, and cloud-based ETL pipelines. I value sustainable data models, clear documentation, and transparency in reporting to support regulatory and business decision-making.I am Microsoft Certified Power BI and SQL developer and working on Power BI since its birth.

Available to hire

I am a senior data engineer with 13+ years of experience turning data into actionable insights and building scalable data platforms. I currently work with Axis Capital to refine reinsurance data and help migrate architecture to Azure, while addressing storage and data quality challenges. I enjoy collaborating with cross-functional teams to deliver data-driven solutions that align with business goals.

I thrive on delivering robust dashboards and automated data workflows using Power BI, Tableau, Power Automate, and cloud-based ETL pipelines. I value sustainable data models, clear documentation, and transparency in reporting to support regulatory and business decision-making.I am Microsoft Certified Power BI and SQL developer and working on Power BI since its birth.

See more

Experience Level

Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert

Language

English
Fluent

Work Experience

Data Engineer at HALIFAX WATER
May 1, 2022 - Present
Developed and maintained interactive dashboards and data visualizations using Power BI to provide actionable insights for end users. Automated routine workflows and approval processes using Microsoft Power Automate, reducing manual effort and turnaround time. Designed and optimized SQL queries to retrieve, transform, and validate large datasets from multiple sources. Collaborated with cross-functional teams, including PMO and engineering, to implement data-driven solutions aligned with business goals. Performed data cleansing and transformation to ensure data integrity and quality across reporting layers. Created and maintained documentation for reports, workflows, and data models to ensure sustainability and transparency. Participated in regulatory compliance data reporting and built custom Power BI reports for real-time monitoring.
Senior Data Engineer at AXIS CAPITAL
September 1, 2020 - December 1, 2021
Designed and built database objects like tables, views, and triggers. Developed queries for ad-hoc business requirements and ongoing reporting. Optimized long-running SQL queries. Designed and created ETL packages using SSIS and Azure Data Factory. Solved customer queries using data and created dashboards using Power BI. Defined the data flow process for large datasets (approximately 120 million records).
Data Engineer at CGI CONSULTING INC.
March 1, 2020 - September 1, 2020
Designed and built database objects like tables, views, and triggers. Optimized long-running SQL queries. Designed and created ETL packages using SSIS. Solved customer queries using data and SQL queries. Created dashboards using Tableau. Designed the overall process using a Data Vault model.
Data Engineer at NTT DATA Inc.
October 1, 2019 - March 1, 2020
Designed and built database objects like tables, views, and triggers. Optimized long-running SQL queries. Designed and created ETL packages using SSIS. Solved customer queries using data and SQL queries. Created dashboards using Power BI. Created scripts using PowerShell to avoid third-party software in SSIS.
Data Scientist at DIRECTECH LABS
November 1, 2017 - October 1, 2019
Analyzed Customer Information (order history, network and payouts) and created a retention model using XGBoost, achieving model accuracy of 81%. Wrote complex SQL queries and query optimization. Created and maintained ETL jobs to automate daily processes using ADF. Performed data cleaning using SQL Server and MS Excel. Created interactive dashboards for visualizing model performance using Power BI. Tested model effectiveness by splitting members into Test/Control groups. Led a team of 8 and delivered multiple changes for onshore clients.
BI Developer at BUREAU VERITAS
May 1, 2017 - November 1, 2017
Developed and maintained various reports for coal and minerals. Gathered requirements directly from end users. Optimized long-running SQL queries. Created ETL jobs for daily/monthly/quarterly processes using SSIS. Helped end users with Tableau reports.
Team Lead - Mortgages Application at Accenture India and Accenture UK
May 1, 2015 - May 1, 2017
Point of contact for new business development, automations, on-call processes, and knowledge transfer onshore. Created SQL Query Builder that reduced cross-database querying. Wrote complex SQL queries and performed performance optimization. Created MI ETL tool using SSIS with multiple transformations. Led a team of 8, delivering 8+ changes across the application. Built reusable components and documentation for ongoing maintenance and onshore knowledge transfer.
ASP.NET Developer at BEST BUY
January 1, 2015 - May 1, 2015
Created various screens using ASP.NET for web applications; Optimized SQL queries to improve performance. Created SQL Agent jobs and SSIS packages. Developed custom workflows across content lists and associated with ASP.NET applications. Delivered 5 SSRS reports; Active member of Production Support and Development Teams; Received business appreciation.
SQL Developer at HILTON HOTELS
February 1, 2013 - January 1, 2015
Created a SQL-based audit mechanism for daily reporting. Implemented department-based access controls. Created unit test scripts. Developed stored procedures, triggers, functions, and views using MS SQL 2012. Built an ETL process using SSIS 2008 to forecast Hilton’s business.

Education

Bachelor’s in Technology (Computer Science) at 9th Best University of India
June 1, 2008 - May 1, 2012

Qualifications

MCPD and MCSD (ASP.NET) certifications
January 11, 2030 - December 25, 2025
SQL Server Certifications (70-461, 70-462)
January 11, 2030 - December 25, 2025
SSIS Certification (70-463)
January 11, 2030 - December 25, 2025
Power BI Certification (70-778)
January 11, 2030 - December 25, 2025
Master of Data Science Using R (Edureka)
January 11, 2030 - December 25, 2025
Python Certification (Edureka)
January 11, 2030 - December 25, 2025

Industry Experience

Financial Services, Professional Services, Energy & Utilities, Travel & Hospitality