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