Priyanka Bansal

About Priyanka Bansal

Data Engineer with 11+ years of experience building scalable data platforms, leading system migrations, and developing automation frameworks across enterprise environments.Recently led end-to-end migration of a provider data platform, designing reusable data frameworks and automation solutions that significantly reduced manual effort and improved operational efficiency.Strong expertise in SQL Server, ETL (ADF, SSIS), and large-scale data processing across multi-client systems.Focused on solving complex data challenges, optimizing performance, and building systems that scale.Worked in Insurance, Retail, and Manufacturing domains in varied roles.Technical Skills:• Data Engineering & Architecture: Data Pipeline Design, Data Migration, ETL Optimization, Data Modeling, Data Cleansing, Workflow Automation, Scalable Data Systems• Programming & Scripting: SQL (Advanced), Python (Pandas, NumPy)• ETL & Data Integration: Azure Data Factory (ADF), SSIS• Databases & Warehousing: SQL Server, Azure SQL Database, Snowflake, PostgreSQL, MySQL• Cloud Platforms & Services: Microsoft Azure (ADF, Azure SQL)• DevOps & Version Control: Azure DevOps (Repos, Pipelines), GitHub• Performance & Optimization: SQL Performance Tuning, Query Optimization, Large Dataset Processing• Tools & Platforms: SSMS, Visual Studio, Jupyter Notebook, PyCharm• Project & Collaboration: Jira, Confluence, Agile/Kanban, Microsoft Teams, SharePoint• Data Formats: CSV, JSON, XML, Excel (XLS/XLSX)

Experience

1. Data Engineer

   Perspecta - Provider Data Management

   May 2023 — Present · US

   Responsibilities:• Led end-to-end migration of provider data platform from legacy system to scalable SQL Server-based architecture, supporting multiple enterprise clients (Optum, AIG, Sedgwick, Liberty Mutual, Genex) • Designed data platform logic supporting multi-state and multi-client configurations, ensuring scalable and reusable system architecture• Built and optimized complex stored procedures, improving query performance by 70-80% for large datasets (100K+ records)• Developed automation frameworks, reducing manual effort by 70%+ and improving processing efficiency across multi-client workflows• Implemented advanced business logic and provider selection algorithms (specialty mapping, radius filtering, network validation) • Led data cleansing and validation framework design, improving data quality and consistency across systems• Troubleshot and resolved critical production issues, ensuring high availability and stability of data pipelines• Collaborated cross-functionally with product, QA, and offshore teams, while also mentoring team members on system workflows and campaign processingKey Achievement:• Successfully delivered full-scale migration and automation of provider data platform independently, enabling scalable multi-client processing and significantly reducing manual operational effort

Education

• Punjabi University

  Bachelor's degree, Mathematics and Computers

  2006 — 2009

• Udacity

  SQL Nanodegree Program, SQL with advanced features

• Punjabi University

  Master's degree, Information Technology

  2009 — 2012

Skills

• Progress Monitoring
• Sap Pp
• IT Operations
• Management
• Interpersonal Communication
• Budget Management
• Order Fulfillment
• Resource Management
• Customer Satisfaction
• Active Learning
• Databases
• Service Coordination
• Inventory Management
• Data Reconciliation
• Planning
• Operational Planning
• Organizational Learning
• Employee Training
• Analytical Skills
• Project Coordination