# Pallavi R

Pallavi R is a remote worker on Himalayas, Senior Data Analyst at Boston Medical Center, based in United States.

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

```text
Senior Data Analyst at Boston Medical Center who corrected 340B pharmacy claim data across 44M records and supported state resubmissions.
```

| Detail | Value |
| --- | --- |
| Availability | Looking for a job |
| Location | United States |
| Authorized to work in | United States |
| Salary expectations | 102k+ USD |
| Job categories | Data Analyst, SQL Developer, ETL Developer, Reports Developer |
| Skills | Data Engineering, Data Analysis, ETL ELT, Data Warehouse, Dimensional Modeling, HIPAA compliance, EDI 837, Claims Reconciliation, Data Quality, Data Lineage, Requirements Analysis, Source To Target Mapping, BigQuery, Databricks, Snowflake |

## About

```text
At Boston Medical Center, I corrected 340B pharmacy claim data across 44M records and completed Massachusetts state resubmissions. I also coordinated HIPAA-compliant EDI 837P and 837I processing through Edifecs for state programs in New Hampshire and Massachusetts.

At Black Knight, I produced requirements and source-to-target mappings for Power BI dashboards and analytical solutions, and maintained a logical data dictionary. Across healthcare, banking, insurance, and other data roles, I’ve worked on ETL/ELT pipelines, warehouse solutions, reporting, and cloud-based analytics.
```

## Experience

### Senior Data Analyst

[Boston Medical Center](https://himalayas.app/companies/boston-medical-center). Jan 2025 - Aug 2026

```text
Coordinated end-to-end processing of HIPAA-compliant EDI 837P and 837I files through Edifecs, validating outputs and authoring submission specifications. Corrected 340B pharmacy claim data across 44M records and completed Massachusetts state resubmissions by developing SQL-based solutions.
```

Skills: Edifecs, SQL, BigQuery, Databricks, Alteryx, ETL-ELT, Dimensional-Modeling, Tableau, Looker, Cognos, NCPDP-Claims

### Senior Data Analyst

Black Knight. Jan 2019 - Sep 2024

```text
Composed functional and technical requirements for Power BI dashboards and analytical solutions. Produced source-to-target mapping documents and maintained a Logical Data Dictionary covering data lineage and transformation logic.
```

Skills: Power-BI, Data-Mapping, Data-Lineage, PII, Automation, SQL, Data-Governance

### SQL Server Developer

Texas Capital Bank. Jun 2018 - Jan 2019

```text
Formulated data management and processing solutions in SSIS, covering error handling and slowly changing dimensions. Designed data warehouse schemas and multidimensional cubes in SSAS.
```

Skills: SSIS, SSAS, SSRS, Power-BI, Azure-SQL-Database, SQL-Server, Python, OLAP, Stored-Procedures

### Senior SQL Developer

[JP Morgan Chase](https://himalayas.app/companies/jpmorgan-chase-co). Jun 2016 - Apr 2018

```text
Managed Consumer and Community Banking Operational Risk covering Mortgage Banking functions and Mortgage Services. Owned chain of title process 1556 and certification matching for Fannie Mae and Freddie Mac.
```

Skills: SQL, SSIS, SSRS, ETL, Performance-Optimization, Mortgage, Fannie-Mae, Freddie-Mac

### Senior SQL Developer

[McKesson](https://himalayas.app/companies/mckesson). Dec 2015 - Jun 2016

```text
Developed SSIS packages for Revlog and AP dashboards, payment-method file loads, AP/AR data, GRIR data transfers, and Master Data Management requirements. Designed stored procedures, views, and functions supporting the Vendor Debit Forecast tool.
```

Skills: SSIS, T-SQL, SQL-Server, Netezza, Stored-Procedures, Views, Functions, Master-Data-Management

### Senior Reports Developer

U.S. Risk Insurance. Mar 2014 - Dec 2015

```text
Modernized legacy data integration by migrating SQL Server 2000 DTS packages to SSIS on SQL Server 2008. Migrated PerformancePoint Server reports to SharePoint 2010 BI and established connections to AS400, mainframe DB2, and Oracle systems.
```

Skills: SSIS, DTS, SQL-Server, SharePoint, Tableau, T-SQL, AS-400, DB2, Oracle

### Senior ETL/Hadoop Developer

[Verizon](https://himalayas.app/companies/verizon-wireless). Sep 2011 - Mar 2014

```text
Analyzed Hadoop clusters for Global Security Operations Center project using Pig, Hive, and MapReduce. Gathered and aggregated large volumes of log data through Apache Flume, staging it in HDFS for downstream analysis.
```

Skills: Hadoop, Pig, Hive, MapReduce, Apache-Flume, HDFS, HBase, Oozie, Test-Driven-Development, Continuous-Integration

### SQL Server Senior Developer

Wellpoint

```text
Served as SQL Server Senior Developer at Wellpoint in Alexandria, VA.
```

## Education

### Jawaharlal Nehru Technological University

Bachelor of Technology, Electrical Engineering

```text
Bachelor of Technology in Electrical Engineering from Jawaharlal Nehru Technological University.
```

## Tech stack

- Snowflake
- Pig
- Tableau
- Looker
- SAS
- PySpark
- Sqoop
- Oracle
- Hadoop
- HBase
- Databricks
- Visual Studio
- Azure DevOps
- Python
- C#
- ASP.NET
- XML
- Nagios
- Ganglia
- Windows
- Microsoft Office 365
- Google BigQuery
- SAP
- Power BI
- AWS

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

## People also viewed

- [Daniel Alvarado](https://himalayas.app/@danielalvarado): Provider Relations Lead Analyst, Cigna
- [Andrii Taranov](https://himalayas.app/@andriitaranov): Principal Data Engineer, Providence Health and Services
- [Aliza Khadka](https://himalayas.app/@alizakhadka): Data Analyst, Sentara
- [Yashoda Devi Bommareddy](https://himalayas.app/@yashodadevibommaredd): Lead Analyst, Blue Cross Blue Shield of Arizona
- [Heidi Sceets](https://himalayas.app/@heidisceets): Application Specialist, InformData
- [hemanth Kumar kamma](https://himalayas.app/@hemanthkumarkamma): Senior Business Data Analyst, Optum (UnitedHealth Group)
- [sabira naik](https://himalayas.app/@sabiranaik): Senior Software Architect, KIPP Foundation
- [Biraj Sharma](https://himalayas.app/@birajsharma): Senior Data Engineer, Change Healthcare
- [Upama Mahato](https://himalayas.app/@upamamahato): Senior Data Engineer, Elevance Health
- [Joel Losch](https://himalayas.app/@joellosch): Sr. Business Intelligence Developer, Esquire Deposition Solutions
