Open to opportunities

Rajat Roy

@rajatroy

Message

Associate Consultant specializing in AI & data engineering for insurance analytics platforms.

India

Message

What I'm looking for

I’m looking for a role where I can build governed cloud data platforms and real-time pipelines, and apply Generative AI (RAG/agentic workflows) to deliver measurable business impact in regulated environments.

I’m an Associate Consultant focused on AI & Data Engineering, with a strong track record across insurance platforms and core modules like Policy Administration, Claims Management, Payments, Underwriting, and Actuarial Analytics. I partner with both business and technology stakeholders to turn complex requirements into scalable, governed data and AI solutions.

I recently designed and implemented a Neo4j-based graph knowledge platform, modeling relationships across insurance entities and operational workflows—improving business onboarding efficiency by over 70%. I also modernized legacy insurance data systems with an AWS Data Lake on S3, building Glue/ PySpark ETL and Debezium-based CDC pipelines to deliver analytics-ready datasets into Redshift for actuarial and regulatory analytics.

For real-time outcomes, I built event-driven streaming pipelines with AWS Kinesis, Glue jobs, and PySpark to enable near real-time pricing and unit allocation visibility, increasing operational visibility and decision efficiency by over 65%. I further integrate Generative AI using RAG and agentic workflows (AWS Bedrock/OpenAI, LangChain/LangGraph) with observability via LangSmith, and I carry a systems mindset from earlier microservices and integration engineering work.

Experience

Work history, roles, and key accomplishments

Current

Associate Consultant AI & Data

Current

Tata Consultancy Services

Mar 2020 - Present (6 years 3 months)

Designed and implemented a Neo4j graph knowledge platform for insurance onboarding, improving BAU transition and knowledge access by over 70%. Built AWS data lake and ETL/CDC pipelines (Glue, Debezium, Redshift) and delivered real-time Kinesis-based pipelines to increase operational visibility by over 65%, enabling RAG and agentic assistants with LangChain/LangSmith.

Neo4j AWS S3 AWS Glue Amazon Redshift Debezium AWS Kinesis Pyspark Lang Chain Langsmith

Associate Consultant Product Integration

Tata Consultancy Services

Feb 2016 - Feb 2020 (4 years)

Developed a wrapper integration layer to expose BaNCS insurance services and transition monolithic capabilities to microservices-based OMNI channel services. Built REST APIs with Java/Spring MVC and implemented reconciliation processes that achieved over 99% transaction accuracy.

Java Spring MVC REST APIs Microservices Saga Pattern Oracle SQL Integration Engineering

IT Analyst & Application Developer

Tata Consultancy Services

Jan 2014 - Jan 2016 (2 years)

Provided L2/L3 production support for insurance platforms, troubleshooting batch and real-time failures across core modules including policy administration, claims, and payments. Built reconciliation and validation scripts to achieve over 99% accuracy and managed BAU incident resolution and change requests.

Production Support Data Reconciliation Batch Job Troubleshooting Incident Management System Monitoring

System Engineer

Tata Consultancy Services

Nov 2010 - Jan 2014 (3 years 2 months)

Designed and built APIs for cross-platform integration and maintained Oracle databases using Oracle PL/SQL/SQL to improve consistency and performance. Led data synchronization work between core banking systems and contributed to scalable architecture initiatives.

API Development Java Spring Framework Oracle PL SQL SQL Synchronization System Architecture Enterprise Integration

Technical Analyst - CRM

Cognizant Technology Solutions

Mar 2010 - Nov 2010 (8 months)

Assisted with the design and development of Pega applications, including process flows, user interfaces, and business rules. Conducted unit testing and debugging to resolve issues and improve application quality and performance.

Pega Development Process Flow Business Rules UI Development Unit Testing Debugging Application Support

System Engineer

Bennet Coleman & Co Ltd

Mar 2007 - Feb 2010 (2 years 11 months)

Developed and optimized MIS tools and web interfaces using PHP, JavaScript/AJAX, HTML/CSS, XML, and MySQL. Worked with press, pre-press, and product management teams to incorporate client feedback and improve user experience.