Summary
Overview
Work History
Education
Skills
Additional Information
Timeline
Generic

Lalit Chhangani

Pune

Summary

Results-driven Python Developer and Data Engineer with over 7+ years of experience in creating scalable, cloud-based data solutions for BFSI and enterprise sectors. Proficient in Python, SQL, and ETL pipeline development, with extensive knowledge of AWS services including S3, Lambda, and Redshift. Demonstrated success in automating workflows and enhancing performance, alongside expertise in developing KPI dashboards using Power BI and Spotfire.

Overview

8
8
years of professional experience

Work History

Senior Consultant (Data Engineer)

Capgemini
06.2022 - Current
  • Developed and maintained Python-based ETL pipelines in Dataiku and AWS (S3, Lambda, Redshift), improving data reliability and processing speed.
  • Automated workflows triggered via AWS Lambda on S3 uploads, eliminating manual intervention and increasing efficiency.
  • Designed and configured IAM roles to securely grant Lambda access to S3 buckets and Redshift, ensuring leastprivilege permissions.
  • Built pipelines to ingest data from S3 into SQL/Redshift using Python (boto3, psycopg2, Pandas, Numpy), enabling seamless analytics.
  • Created Spotfire dashboards to report cost variance, exposure %, scrap %, and leakage across GE engine families.
  • Designed robust data models and ingestion flows integrating Oracle and Redshift data, optimized with SQL and Pandas.
  • Monitored, profiled, and optimized data pipelines using logs, performance flags, and retry logic to ensure high availability.

Python Developer

Tata Consultancy Services
03.2021 - 06.2022
  • Developed Python-based tools to automate and optimize data processing workflows.
  • Improved SQL Server performance via index tuning and efficient stored procedures.
  • Designed reusable scripts for data validation and transformation.
  • Participated in code reviews and CI/CD practices to maintain coding standards.

SQL BI & Python Developer

Survik Software
10.2018 - 02.2021
  • Built Python-based tools for batch processing and BI automation.
  • Improved SQL Server efficiency via index tuning and stored procedures.
  • Created Power BI dashboards, reducing reporting time by 40%.
  • Utilized Pandas and NumPy for deep data analysis and automated data validation.
  • Delivered high-performance SQL queries for production environments.

Trainee Engineer

Etkin Infotech
08.2017 - 08.2018
  • Delivered high-performance SQL queries optimizing production environments.
  • Participated in code reviews and CI/CD pipelines to uphold code quality standards.
  • Assisted in designing and developing engineering projects, enhancing overall functionality.
  • Collaborated with team members to resolve technical challenges efficiently.

Education

B.E. - Information Technology

Prof. Ram Meghe Institute of Technology & Research
08.2016

Diploma in Engineering - undefined

Dr. Panjabrao Deshmukh Polytechnic
08.2013

SSC - 10th Grade

Maharashtra Board
06.2010

Skills

  • Python
  • SQL
  • AWS (S3, Lambda, IAM)
  • Dataiku
  • Flask
  • Pandas
  • NumPy
  • MySQL
  • SQL Server
  • CI/CD pipelines
  • Unit testing
  • Logging decorators
  • Incident Management

Additional Information

Notice Period: Serving | Last Working Day: 22 Oct 2025

Timeline

Senior Consultant (Data Engineer)

Capgemini
06.2022 - Current

Python Developer

Tata Consultancy Services
03.2021 - 06.2022

SQL BI & Python Developer

Survik Software
10.2018 - 02.2021

Trainee Engineer

Etkin Infotech
08.2017 - 08.2018

Diploma in Engineering - undefined

Dr. Panjabrao Deshmukh Polytechnic

SSC - 10th Grade

Maharashtra Board

B.E. - Information Technology

Prof. Ram Meghe Institute of Technology & Research
Lalit Chhangani