r
rohit_bandala

Sanjay B

@rohit_bandala

ETL Developer Business Analyst

Inde
Hindi, Telugu, Anglais
Certaines informations sont présentées en anglais.
À propos de moi
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.... Plus d’infos

Compétences

r
rohit_bandala
Sanjay B
hors ligne • 
Temps de réponse moyen de 1 heure

Voir mes services

Rédaction technique
I will review and improve your data specification document
De75 $US / projetPlus de détails

Portfolio

Expérience professionnelle

PwC

Data Business Analyst and ETL developer

PwC • Temps plein

May 2025 - Present • 1 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 • Temps plein

Apr 2023 - Apr 2025 • 2 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 • Temps plein

Jan 2021 - Apr 2023 • 2 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.