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• Performed web scraping and data extraction using Python, streamlining data collection processes for analytics and reporting• Designed and executed data migration strategies, ensuring seamless transitions of datasets between DEV, UAT, and PROD environments with minimal downtime• Collaborated with cross-functional teams using JIRA, Confluence, and Azure DevOps, ensuring effective project coordination and delivery• Integrated diverse data formats (e.g., CSV, JSON, XML, TXT) into centralized systems, synchronizing data across platforms like SSMS and PostgreSQL• Streamlined incident management in production environments, reducing resolution times with automated alerting and root cause analysis• Collaborated in Agile environments, contributing to sprint planning, daily stand-ups, and retrospectives• Mentored junior team members, promoting skill development in SQL, Python, and ETL pipeline design• Enhanced process automation and system workflows, optimizing data pipelines for performance and scalability

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.• Automated UAT Validation processes using Alteryx, streamlining the testing process, and increasing efficiency during user acceptance testing (UAT).• Wrote and executed UAT test scenarios and cases, collaborating closely with end-users to ensure thorough testing and proper documentation of results.• Optimized SQL Server stored procedures and queries, reducing execution times by 30% and enhancing database performance.• Developed interactive dashboards and advanced visualizations in Tableau and MS Excel, providing actionable insights to stakeholders.• Automated data validation and reporting workflows using Python, improving data accuracy by 20% and reducing manual effort.• Implemented data profiling, cleansing, and quality assurance techniques, improving data integrity and reliability for analytics and reporting.• Collaborated with cross-functional teams using project management tools such as JIRA, Confluence, and Azure DevOps, ensuring efficient delivery of data-driven solutions.

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