# Shyamli Gupta

Shyamli Gupta is a remote worker on Himalayas, Senior Business Data Analyst at PwC, based in India.

Source: https://himalayas.app/@shyamligupta

```text
Business Data Analyst at PwC working on Guidewire Cloud migrations, including data conversion and reconciliation for PolicyCenter, ClaimCenter, and BillingCenter.
```

| Detail | Value |
| --- | --- |
| Availability | Open to opportunities |
| Location | India |
| Authorized to work in | India |
| Salary expectations | 251k+ INR |
| Job categories | Business Data Analyst, ETL Developer, Data Analyst, Informatica Developer |
| Skills | Data Analysis, ETL Development, Data Conversion, Data Migration, Data Reconciliation, Data Validation, Data Profiling, Data Mapping, Guidewire Policy Center, Guidewire Claim Center, Guidewire Billing Center, Informatica PowerCenter, IICS, Snowflake, SQL |
| LinkedIn | https://linkedin.com/in/shyamli-gupta-78287318 |

## What I'm looking for

```text
I’m aiming to leverage my abilities in a role where I can apply my expertise in data analysis and process improvement, and develop strategies to reduce costs and increase efficiency.
```

## About

```text
At PwC, I work as a Business Data Analyst on a Guidewire BillingCenter upgrade to Cloud, supporting the CDA pipeline and automated reconciliation framework. I analyze billing data structures and document requirements and mappings for the upgrade.

For PwC’s PolicyCenter and ClaimCenter data conversion, I led a team of business analysts, developers, and QA through legacy-to-Guidewire conversion. I directed ETL build, validation, and reconciliation, and managed UAT readiness, cutover, and go-live planning.

At Capgemini, I worked on insurance data modernization and Guidewire implementation projects using IICS and Snowflake. Earlier, I developed Informatica ETL workflows and an automated data-loading flow using Python; I also hold Guidewire and IICS certifications.
```

## Experience

### Senior Business Data Analyst (current)

[PwC](https://himalayas.app/companies/pwc). Nov 2023 - Present

```text
Working as Data Business Analyst for CDA pipeline and automated reconciliation framework in BillingCenter Cloud Migration project. Led Data Conversion team for legacy-to-Guidewire data conversion, managed UAT readiness, and executed cutover and go-live.
```

Skills: Guidewire-Billing-Center, SQL-Server, Snowflake, SQL, SSIS, Azure, Data-Conversion, Data-Validation, Reconciliations, UAT, Cutover-Planning

### ETL Developer Lead

[Capgemini](https://himalayas.app/companies/capgemini-technology-services). May 2023 - Nov 2023

```text
Led P&C Data Modernization project, managing resources and ensuring timely delivery. Implemented data migration from on-premises to cloud using IICS and Snowflake, and produced project estimations and plans.
```

Skills: IICS, Snowflake, Data-Migration, ETL, Stored-Procedures, DataVault-2.0, Project-Management, Stakeholder-Management

### Data Analyst & ETL Lead

[Capgemini](https://himalayas.app/companies/capgemini-technology-services). Jun 2022 - Apr 2023

```text
Involved in gathering requirements, analyzing data, and creating mapping transformation rules for Guidewire implementation. Collaborated with Business Analysts to ensure data accuracy and integrity.
```

Skills: IICS, Snowflake, Data-Analysis, Data-Profiling, ETL, Requirements-Gathering, Data-Mapping

### Senior Informatica Developer

[Capgemini](https://himalayas.app/companies/capgemini-technology-services). Mar 2021 - Jun 2022

```text
Developed automated data loading flows using Python scripts and Informatica PowerCenter. Involved in coding, performance tuning, and providing technical guidance to junior team members.
```

Skills: Informatica-PowerCenter, SQL-Server, Python, Unix, ETL, Performance-Optimization, GitHub, Jenkins, Rally

### ETL Informatica Developer

[Capgemini](https://himalayas.app/companies/capgemini-technology-services). Oct 2017 - Feb 2021

```text
Developed ETL mappings and workflows for Guidewire Policy Center conversion. Participated in coding, defect fixing, and performance tuning of Informatica mappings.
```

Skills: Informatica-PowerCenter, SQL-Server, Guidewire-Policy-Center, ETL, Data-Quality, Performance-Optimization

### ETL Informatica Developer

[Cognizant Technology Solutions](https://himalayas.app/companies/cognizant). Jun 2016 - Aug 2017

```text
Developed Informatica mappings and Unix wrappers for retail data integration. Created complex mappings and performed performance tuning.
```

Skills: Informatica-PowerCenter, SQL-Server, UNIX-Shell-Scripting, ETL, Performance-Optimization

### ETL DataStage Developer

[Cognizant Technology Solutions](https://himalayas.app/companies/cognizant). Dec 2015 - May 2016

```text
Created DataStage jobs for Guidewire Claim Center conversion, including data profiling and extraction from DB2 to Oracle. Performed unit testing and peer reviews.
```

Skills: DataStage, Oracle, UNIX-Shell-Scripting, ETL, Data-Profiling, DB2

## Education

### West Bengal University of Technology

Master of Computer Applications, Computer Applications. 2011 - 2014

```text
Pursued Master of Computer Applications, focusing on advanced computing and application development.
```

### Shri Shikshayatan College

B.Sc., Computer Applications. 2008 - 2011

```text
Completed B.Sc. in Computer Applications with a major in the field, building a strong foundation in computer science.
```

### Coursera

Python 3 Programming (5 Course Specialization), Python Programming

```text
Completed Python 3 Programming specialization (5 courses) from Coursera.
```

### Data Modelling and Data Analytics Training

Training in Data Modelling and Data Analytics, Data Modelling and Analytics

```text
Completed training in Data Modelling and Data Analytics.
```

### Microsoft

Power BI Training, Power BI

```text
Completed training in Power BI.
```

### Snowflake

Cloud Lakehouse Data Management Foundation Series Certification, Data Management

```text
Certified in Cloud Lakehouse Data Management Foundation Series.
```

### Snowflake

Snowflake Pro - Hands on Badges 1 & 3, Snowflake

```text
Completed Snowflake Pro Hands-on Badges 1 & 3.
```

### Guidewire

Guidewire Certified Associate - InsuranceSuite Analyst, InsuranceSuite

```text
Certified as Guidewire Certified Associate - InsuranceSuite Analyst.
```

### Informatica

IICS: Cloud Data Integration Services R38, Cloud Data Integration

```text
Certified in IICS: Cloud Data Integration Services R38.
```

### Informatica

Cloud Application Integration Services for Developers R39, Cloud Application Integration

```text
Certified in Cloud Application Integration Services for Developers R39.
```

## Tech stack

- Snowflake
- GitHub
- Jenkins
- Oracle
- Python
- SQL
- Informatica PowerCenter
- Power BI

To contact Shyamli, message them from this profile with a Himalayas employer account: [Hire on Himalayas](https://himalayas.app/hire).

## People also viewed

- [Anitha Joshi](https://himalayas.app/@anithajoshi): Lead Data Analyst, AT&T Communication Services India Pvt. Ltd.
- [Basabdutta Mohanty](https://himalayas.app/@basabduttamohanty): ETL Lead, KleverMind
- [Vidit Jain](https://himalayas.app/@viditjain): Senior Consultant, Deloitte Consulting India Pvt Ltd
- [Rohith MS](https://himalayas.app/@rohithms02): Associate Consultant – Data Management / ETL Developer, Infosys Ltd
- [Umesh R Gowda](https://himalayas.app/@umeshrgowda): Senior Specialist, Data Engineering, LTM
- [Lucky TWL](https://himalayas.app/@luckytwl): Sr. Data Engineer, Cognizant Technology Solutions
- [K Balurajan](https://himalayas.app/@kbalurajan): Business Intelligence Consultant, Allstate India Private Limited
- [Sindhuja Manchala](https://himalayas.app/@sindhujamanchala): Senior Data Engineer, IBM India Pvt Ltd
- [Chhaya Sanodiya](https://himalayas.app/@chhayasanodiya): Lead Data Engineering, Teradata
- [Vanshika semwal](https://himalayas.app/@vanshikasemwal): Senior Software Engineer, Capgemini
