Lalit Chhangani
Pune
Summary
Results-driven Python Developer and Data Engineer with over 6+ 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
7
7
years of professional experience
Work History
Senior Consultant (Data Engineer)
Capgemini
Pune
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 least-privilege permissions.
- Built pipelines to ingest data from S3 into SQL/Redshift using Python (boto3, psycopg2, Pandas), 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
Pune
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
Pune
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.
Education
B.E. - Information Technology
Prof. Ram Meghe Institute of Technology & Research
Amravati01.2016
Diploma in Engineering -
Dr. Panjabrao Deshmukh Polytechnic
Amravati01.2013
SSC - 10th Grade
Maharashtra Board
01.2010
Skills
- Python
- SQL
- AWS (S3, Lambda, IAM)
- Dataiku
- Flask
- Pandas
- NumPy
- MySQL
- SQL Server
- CI/CD pipelines
- Unit testing
- Logging decorators
- Incident Management
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
B.E. - Information Technology
Prof. Ram Meghe Institute of Technology & Research
Diploma in Engineering -
Dr. Panjabrao Deshmukh Polytechnic
SSC - 10th Grade
Maharashtra Board
Similar Profiles
V S S R K RAJU KATARIV S S R K RAJU KATARI
Senior Analyst at CapgeminiSenior Analyst at Capgemini
Thierry MaurelThierry Maurel
Engagement Manager at CAPGEMINIEngagement Manager at CAPGEMINI
Karan TalwarKaran Talwar
Associate Consultant | Cloud Infrastructure Services at CapgeminiAssociate Consultant | Cloud Infrastructure Services at Capgemini
Priya Dharshini JPriya Dharshini J
QA Automation Lead at CapgeminiQA Automation Lead at Capgemini
Vibhav TripathiVibhav Tripathi
Lead Technology at SynechronLead Technology at Synechron