Sreedhar Aldandi
Jacksonville,FL
Summary
Results-driven Senior Data Engineer with 15+ years of experience in design, develop and modernizing large-scale data platforms at major insurance companies like Direct Line, Liberty Mutual, XLCatlin,WestBend Insurance, Philly Insurance, USAA and Kemper. Experienced in delivering high-impact data products like GL integration, Pricing Cube and Actuarial eco systems. Built scalable solutions and reconciliation pipelines for Policy, Claims and Billing Data warehouse / Data vault products using Snowflake, Python, Informatica cloud to ensure data integrity across various environments supporting mission-critical analytics and reporting. Led cross-functional collaboration with data engineers, data science, and business stakeholders to establish data governance standards, mentor junior engineers, and drive continuous improvements. Possessing strong problem solving and analytical skills with the ability to handle multiple projects concurrently
Actively implementing AI agents / skills as applicable to reduce the cost and improve the efficiency in day to day work.
Overview
1
1
Certification
20
20
years of professional experience
Work History
Sr Data Engineer
Kemper
Jacksonville, Florida
02.2022 - Current
- - Designed and developed Data Analytical Platforms using Snowflake, Python, Informatica Cloud to extract data from Guidewire Policy Center, apply business rules to transform and load into Data vault 2.0
- - Designed and developed snowflake code, including complex queries, views, python based stored procedures.
- Designed and developed re-usable snowflake python based parsing mechanism to parse Json, XML files and detect schema changes
- Built Snowflake Snow pipe, internal & external stages integrating with cloud platforms to read real time data, parse and load into PCDM and downstream systems.
- - Developed data observability and validation strategy for PCDM and General Ledger systems, ensuring data accuracy.
- - Tuned the long running jobs and reduced load window to meet SLAs
- - Analyzed source data and provided recommendations to address data quality issues, enhancing data integrity.
- - Reviewed data for cleanliness and worked with data architect on cleansing routines.
- - Coordinated code promotion efforts with DBAs, Informatica admins, and data modelers to streamline deployment processes.
- - Supported offshore design and development activities through coordination, work product review, and guidance.
- - Built AI agents on Snowflake for Policy In-force counts, written premium, daily and monthly earned premium engines.
- - Involved in building AI skill to convert the ETL orchestration from IDMC to Control M with dependencies
- - Worked with insurance source system SMEs to analyze and define data transformation requirements for loading data into EDW and GL systems from Guidewire Policy, Claims, Billing centers, and legacy source systems.
Sr Data Engineer
Capgemini America, Inc.
Chicago, Illinois
04.2007 - 01.2022
- Worked with Guidewire BAs in defining requirements, created BRD, mapping documents, led development teams in delivering large scale DWH, Data mart and Data migration projects at various Insurance Companies with mainly Guidewire policy, claims and billing as source applications
- Built high performance, data analytical platforms on Snowflake, Oracle, SQL Server, Informatica tools with data quality and batch control mechanism including robust error handling, fail over mechanisms
- Tuned long running jobs in various technologies like IDMC, Power Center, Oracle, Snowflake etc
- Designed reconciliation and validation approach for data migration, enhancing data integrity and reliability.
- Profiled source data and suggested ways to fix data issues.
- Coordinated offshore teams on design and development work while reviewing team deliverables and providing guidance to ensure alignment with project objectives.
Education
Master of Science -
Osmania University
01-2003
Bachelor of Computer Science -
Kakatiya University
01-2000
Skills
- Languages: Python, SQL, PySpark, Shell Script, Bash
- Data Engineering: Snowflake Cloud Data Platform, Python Based Stored Procs, Informatica Cloud Tools and Power Center, Apache Spark, Kafka, Airflow, DBT, Apache Beam, Dataflow, Dataproc, Flink, Hadoop, Hive, Presto, NiFi
- Cloud: AWS (S3, Glue, EMR, Redshift, Kinesis), Snowflake Cloud Data Platforms, Azure (Databricks, Data Factory, Synapse, ADLS Gen2, Fabric), GCP (BigQuery, Cloud Storage, Composer, Pub/Sub)
- Architecture & Delivery: ETL/ELT, Streaming, Dimensional Modeling, Data Quality/Observability, Data Governance, Jenkins, DevOps, GitHub Actions, CI/CD, Data Vault 20, Informatica IDMC and PowerCenter, Control-M, Data Warehousing
- Industry Knowledge: P&C Auto Insuranc
Certification
- INS21 (PROPERTY AND LIABILITY INSURANCE PRINCIPLES)
- Informatica MDM Multidomain 10.1: Developer, Specialist Certification
- SnowPro Core Certification: Snowflake
Professional Organizations
- Work Experience Details
Capgemini - April 2007 to January 2022
Kemper Insurance - Feb 2022 to current
Timeline
Sr Data Engineer
Kemper
02.2022 - Current
Sr Data Engineer
Capgemini America, Inc.
04.2007 - 01.2022
Master of Science -
Osmania University
Bachelor of Computer Science -
Kakatiya University