Chaitanya Kandhare

Cigna Healthcare | Feb 2025 – Present

• Architected and led development of an AWS-based Fulfillment platform (Glue, Lambda, S3) to process ~5M+ daily claims and member records, ensuring end-to-end automation of data ingestion, transformation, and outbound communication.
• Automated ingestion workflows from Facets and TCS (upstream) using event-driven Lambda + S3 triggers, eliminating manual file loads and reducing operational effort by 30%.
• Designed and optimized Glue ETL pipelines to enforce schema consistency, apply business rules, and integrate validations/audit checks, achieving 99.5%+ data accuracy and reducing fallout cases by ~20%.
• Implemented Fulfillment DB with status tracking & audit proofing, enabling traceability and compliance for regulatory audits.
• Integrated with downstream vendors (RRD, Fiserv) to deliver outbound packages (XML, RPT, RJT, RCV, PDF), cutting member communication turnaround time from 48 hrs to
• Led a team of 5 engineers, mentoring on AWS best practices, code reviews, and solution design, while collaborating with Cigna business stakeholders and vendors to align technical solutions with business needs.

Supply Chain Management System – Comcast | 1 year 2 months

• Led a team of 6 developers and testers in designing, developing, and maintaining scalable data pipelines, ensuring timely delivery of high-quality supply chain insights.
• Collaborated with business and engineering stakeholders to translate requirements into reliable data models, supporting multi-million-dollar inventory and logistics decisions.
• Developed and optimized ETL workflows using internal frameworks, improving pipeline performance, and cutting average processing time by ~25%.
• Implemented monitoring and incident resolution practices, reducing production downtime and improving SLA compliance to >97%.
• Conducted sprint planning and daily stand-ups under Agile, aligning cross-functional teams and achieving 95%+ on-time delivery of sprint commitments.
• Performed code reviews and debugging, driving best practices in reliability and maintainability across the data engineering team.
• Coordinated with QA teams for end-to-end validation and regression testing, ensuring smooth deployments with zero critical defects in production rollouts.

AIG | 11 months

• Migrated 30+ complex applications in 4 phases from on-premise to AWS and Snowflake.
• Performed historical data migration to S3, validating samples and ensuring functional/regression accuracy.
• Re-engineered pipelines, optimized AWS configurations, and created Git repositories for application code.
• Delivered final runbooks for production readiness and seamless handover.

BMS | 6 months

• Creating ingestion jobs in the well- defined UI-based in-house framework (which is developed in spark) application.
• Operating massive datasets in TBs and converting it into different data formats like parquet for optimization and storing it in S3 bucket.
• Developed a pyspark external script for data validation

Morgan Stanley – Wealth Management

• Developed data processing applications to ingest, curate and distribute data from Hadoop Datalake using Agile methodologies (SCRUM/Kanban).
• Built data pipelines to ingest slowly changing dimension data in Hive from Text, Mainframe, JSON files and export data into Data Warehouse like Teradata.
• Used Apache Spark (Python PySpark scripts) effectively in projects for data transformation and ETL operations. Used BitBucket (GitBash, Git Extensions) for version control, TeamCity to promote and build configuration for deployment.

India Post Insurance

• Creating different types of Reports as per requirements from client.
• Involved in performance monitoring, tuning and Managing and creating Database structure, storage allocation of database, Backups etc.