r
rohit_bandala

Sanjay B

@rohit_bandala

ETL Developer Business Analyst

India
Hindi, Telugu, Inglese
Alcune informazioni sono riportate in lingua inglese.
Chi sono
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.... Continua a leggere

Competenze

r
rohit_bandala
Sanjay B
offline • 
Tempo di risposta medio: 1 ora

Consulta i miei servizi

Scrittura tecnica
I will review and improve your data specification document

Portfolio

Esperienza lavorativa

PwC

Data Business Analyst and ETL developer

PwC • Full time

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 • Full time

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 • Full time

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.