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
Similar Profiles
Abhishek SinghAbhishek Singh
Associate Tax Manager at PWC IndiaAssociate Tax Manager at PWC India
Prashant TripathiPrashant Tripathi
Manager, Digital Supply Chain Transformation at PwC IndiaManager, Digital Supply Chain Transformation at PwC India
Anant Kumar SrivastavaAnant Kumar Srivastava
Manager at PWC IndiaManager at PWC India
SATYARANJAN DEYSATYARANJAN DEY
Network Engineer at Tata Consultancy ServicesNetwork Engineer at Tata Consultancy Services
ASWINI KUMAR SHARMAASWINI KUMAR SHARMA
Associate General Manager – Procurement at AMPIN Energy Transition Pvt. Ltd.Associate General Manager – Procurement at AMPIN Energy Transition Pvt. Ltd.