AJEET KUMAR
Peterborough
Summary
Accomplished professional with over 20 years of experience in data management, automation, and business intelligence. Expertise in SAS, Python, Power BI, and SQL, with a strong focus on data modeling, pipeline automation, and reporting. Good knowledge of cloud platforms, including Azure, Snowflake, and DataBricks, along with regulatory reporting and data governance. Proven leader of cross-functional teams, improving data quality, and reducing manual processes through automation. Skilled in stakeholder engagement, agile project management, and designing data solutions to drive business insights and performance optimization.
Overview
22
22
years of professional experience
Work History
Senior Data Engineer, Python Automation & Power BI Dashboard Lead
TCS
2024.10 - Current
- Led data modelling and Python automation projects to streamline data processes and cut down manual work.
- Created and maintained Power BI dashboards, integrating data from ServiceNow and other systems.
- Automated data pipelines with Python to improve data quality and support reporting.
- Worked with tech and business teams to standardise and improve data management processes.
Data Modeller and Tech Lead
TCS
2023.12 - 2024.10
- Designed data models and oversaw migration of data from on-premises sources (DB2, SQL Server, flat files) to Azure Data Lake.
- Applied data transformations in Databricks and Azure Synapse to meet the Suade FIRE schema.
- Mapped and transformed source data to support regulatory reporting.
- Collaborated with cross-functional teams to ensure data accuracy, lineage, and auditability.
Delivery Manager & Tech Lead
TCS
2021.04 - 2023.12
- Developed end-to-end SQL Server ETL processes, including data extraction, complex transformations, and reporting.
- Designed and supported Power BI dashboards to track KPIs, sales, inventory, and customer trends.
- Revamped telephony reporting database structures to improve performance.
- Worked with business teams to convert requirements into scalable data solutions.
- (Lloyds Banking Group, UK)
Project Manager
Diligenta (TCS)
2017.11 - 2021.03
- Managed small automation projects as part of a Customer Services Transformation program.
- Built an Excel VBA Early Warning System to analyse customer feedback and reduce complaints.
- Created tools to streamline processes, reducing turnaround time from 52 days to 5 days.
- Developed an Excel VBA tool that improved letter generation, cutting production time drastically.
Delivery Owner
TCS
2012.06 - 2017.10
- Led analytics and reporting for APAC credit operations, focusing on capacity planning and performance.
- Automated reports with SQL, SAS, and Excel VBA, cutting down manual effort.
- Created dashboards to help senior stakeholders with resource planning and process optimisation.
- (Citi Bank Credit Operations (APAC Region))
Delivery Manager
TCS
2006.09 - 2012.05
- Managed analytics for North America credit card portfolios, including acquisition and performance tracking.
- Built models for segmentation and campaign analysis using SQL and SAS.
- Automated reporting processes, improving efficiency and the quality of insights.
- (Citi Bank (NA Region))
Business Analyst
Genpact Ltd.
2004.11 - 2006.09
- Supported BFSI clients with analysis and reporting on operational and financial metrics.
- Developed automated solutions in SQL, SAS, and Excel to reduce manual effort and improve accuracy.
Education
M.Sc. - Statistics
Indian Agricultural Statistics Research Institute
New Delhi08.2002
B.Sc. - Agriculture
Institute of Agricultural Sciences, Banaras Hindu University
Varanasi06.2000
Skills
- Data Analysis & Reporting
- SQL & ETL
- Python
- SAS
- Excel VBA
- Snowflake
Certifications Courses
- Snowflake: SnowPro Core Certification
- Microsoft Certified: Azure Data Fundamentals (DP-900)
- Microsoft Certified: Azure AI Fundamentals (AI-900)
- Green Belt Certification
Timeline
Senior Data Engineer, Python Automation & Power BI Dashboard Lead
TCS
2024.10 - Current
Data Modeller and Tech Lead
TCS
2023.12 - 2024.10
Delivery Manager & Tech Lead
TCS
2021.04 - 2023.12
Project Manager
Diligenta (TCS)
2017.11 - 2021.03
Delivery Owner
TCS
2012.06 - 2017.10
Delivery Manager
TCS
2006.09 - 2012.05
Business Analyst
Genpact Ltd.
2004.11 - 2006.09
M.Sc. - Statistics
Indian Agricultural Statistics Research Institute
B.Sc. - Agriculture
Institute of Agricultural Sciences, Banaras Hindu University