Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic
Isita Paul

Isita Paul

Kolkata

Summary

Data professional with extensive expertise in P&C Insurance, Telecommunications, and Utility sectors. Successfully led complex data transformation projects, including business analysis, data quality assessment, and data migration. Proficient in SQL, PL/SQL, T-SQL, Oracle, and Snowflake, with a strong track record of delivering high-quality outcomes on large-scale initiatives. Experienced in managing cross-functional teams and serving as a Business Analyst for a major U.S. insurance client.

Overview

11
11
years of professional experience
1
1
Certification

Work History

Senior Associate

PwC India
Kolkata
07.2022 - Current
  • Led multiple data conversion projects as technical lead, guiding ETL developers to ensure project success using Oracle, PLSQL, TSQL and Snowflake,
  • Collaborated with stakeholders to define requirements, prioritize tasks, and conduct regular progress meetings.
  • Designed and implemented configuration-driven ETL framework, enhancing development and maintenance efficiency.
  • Established best practices to ensure effectiveness and maintainability of the ETL framework.
  • Successfully led end-to-end data conversion from IICS to Snowflake for US insurance client transitioning to Guidewire Cloud.
  • Developed robust data quality framework for validation using Snowflake external tables, automating record management.
  • Implemented Snowpipe for real-time ingestion from S3 bucket, streamlining data loading processes.
  • Designed scalable, cost-effective cloud architecture using Snowflake and DBT, aligning with cloud-first strategy.

Senior Solution Integrator

Ericsson India
Kolkata
09.2017 - 06.2022
  • Created scripts for automation and EAI migration to enhance system integration.
  • Developed PL/SQL packages, procedures, and functions for efficient data conversion.
  • Participated in data modeling for new nodes to support project expansion.
  • Implemented external user login via Active Directory using core Java technology.
  • Designed a Tabular Data Model in Azure Analysis Services for streamlined reporting.
  • Utilized Power BI for comprehensive reporting on data conversion metrics.

Senior Systems Engineer

Infosys Limited
Bhubaneswar
02.2014 - 08.2017
  • Extracted data from Oracle sources and created tables in Teradata/Hadoop core layer for business reporting.
  • Defined data validation and migration rules to ensure accurate data profiling and cleansing.
  • Developed ETL processes to facilitate efficient data movement and reporting capabilities.
  • Conducted data reconciliation to maintain integrity and consistency across systems.

Education

B. Tech - Electronics & Communication Engineering

WBUT

Skills

  • PL/SQL
  • T-SQL
  • Snowflake
  • Oracle
  • SQL Server
  • MS Excel
  • Power BI
  • JIRA
  • Shell
  • Python

Certification

  • Infosys Certified Java Programmer 201a
  • Oracle 1Z0-051 SQL

Timeline

Senior Associate

PwC India
07.2022 - Current

Senior Solution Integrator

Ericsson India
09.2017 - 06.2022

Senior Systems Engineer

Infosys Limited
02.2014 - 08.2017

B. Tech - Electronics & Communication Engineering

WBUT
Isita Paul