r
rohit_bandala

Sanjay B

@rohit_bandala

ETL Developer Business Analyst

Índia
Hindi, Telugu, Inglês
Algumas informações são exibidas no idioma inglês.
Sobre mim
I specialise in insurance data and am a Certified Guidewire DataHub and InfoCenter Specialist. With 5+ years across P&C Insurance and BFSI, I build and optimise ETL pipelines that power policy, claims, billing and financial reporting for global insurers.... Saiba mais

Habilidades

r
rohit_bandala
Sanjay B
offline • 
Tempo médio de resposta: 1 hora

Conheça meus serviços

Redação Técnica
I will review and improve your data specification document

Portfólio

Experiência profissional

PwC

Data Business Analyst and ETL developer

PwC • Período integral

May 2025 - Present1 yr

• Working as a Business Analyst and ETL Developer on a Guidewire DataHub and InfoCenter program, transforming legacy P&C insurance data to align with the Guidewire data model using Snowflake and Azure Databricks. • Gathering business requirements from stakeholders and translating them into detailed data specifications (SCD Type 1/2, PublicID, BeanVersion, Retired flags) for developer and QA consumption. • Designing and executing data transformation logic across Policy Center, Billing Center, and Claims Center domains — mapping legacy source structures to Guidewire ODS and IC layers.

EY

Analyst

EY • Período integral

Apr 2023 - Apr 20252 yrs

Developed and maintained ETL pipelines using SAP BODS and Guidewire DHIC framework (Policy Center, Billing Center, Claims Center) for P&C insurance clients, supporting end-to-end data flows from source to reporting layer. Designed SQL-based transformations and data validation routines for insurance data warehouse pipelines, ensuring accuracy for actuarial, finance, and compliance reporting. Worked within the Guidewire DataHub and InfoCenter ecosystem.

Tata_Consultancy Services

ETL Developer

Tata Consultancy Services • Período integral

Jan 2021 - Apr 20232 yrs 3 mos

Developed and maintained ETL pipelines using Oracle SQL and PL/SQL, supporting data extraction, transformation, and loading for BFSI clients including Silicon Valley Bank. Designed and debugged new and existing ETL workflows, resolving data quality issues and ensuring consistent data delivery to downstream reporting systems. Worked on data validation, unit testing, and defect resolution across multiple project deliverables within tight deadlines.