Pallavi R

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.

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.

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

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.

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.

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.

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.

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

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