Priyanka Bansal Email & Phone Number

US

• Designed and implemented ETL pipelines using SSIS, Visual Studio, and cloud platforms (e.g., Azure Data Factory) for seamless data integration and transformation across multiple systems
• Managed and led an international team in the Philippines for a data verification project, ensuring quality control, adherence to project timelines, and effective communication
• Optimized SQL Server stored procedures and queries, reducing execution times by 30% and improving database performance
• Automated data validation and reporting processes with Python, enhancing data accuracy by 20% and minimizing manual intervention
• Developed and administered PostgreSQL databases, focusing on performance tuning and query optimization using pgAdmin
• Created interactive dashboards and advanced visualizations in Tableau, MS Excel, empowering stakeholders with actionable insights

Dallas, Texas, US

• Led end-to-end ETL processes, integrating data from multiple sources into Snowflake Data Warehouse, ensuring seamless data ingestion and quality
• Created and managed database and table structures within data warehouses, establishing API connections with external databases for smooth data integration
• Developed robust Azure Data Factory (ADF) pipelines for seamless data movement, transformation, and scheduling, leveraging SQL queries for high-quality data extraction and loading into MDM systems.
• Built and managed scalable cloud-based data pipelines using Azure SQL Database, Snowflake, and tools like SnowSQL, ensuring reliable and efficient data infrastructure.
• Demonstrated expertise in data preparation, including cleansing, extraction, mapping, import, transformation, and validation, to ensure data consistency and usability.
• Designed and implemented Source-to-Target Detailed Mapping and Transformation Rules, ensuring data accuracy and alignment with business requirements.

Noida, Uttar Pradesh, IN

• Collaborated with clients to gather requirements and deliver effective data solutions
• Managed and streamlined data flow processes to improve operational efficiency
• Created performance reports using MS Excel, implementing advanced features like pivot tables and macros
• Executed SQL queries to validate data integrity across target systems

CA

• Proficient in data analysis, validation to ensure data accuracy and reliability
• Created data reports and visualizations to support management decision-making processes
• Thoroughly documented and shared test results, promptly addressing and escalating any issues encountered
• Played a key role in training team members on newly developed enhancements and features
• Successfully resolved data-related issues, including data quality assessment, consolidation, and evaluation of existing data sources

Ludhiana, Punjab, IN

• Consolidated data from multiple sources into a user-friendly format and seamlessly transferred it to the SAP PP module
• Generated daily reports and took ownership of resolving any data-related issues that arose
• Leveraged the SAP PP module for efficient data extraction, transformation, and loading processes
• Managed end-to-end tracking of customer orders, ensuring smooth operations from initiation to dispatch using SAP
• Expertly manipulated, cleansed, and processed data using advanced Excel functions like Pivot Tables and V-Lookups

Sql Nanodegree Program, Sql With Advanced Features

Master'S Degree, Information Technology

Bachelor'S Degree, Mathematics And Computers