Pooja P Email and Phone Number

• Worked closely with business analysts and stakeholders to understand requirements, translating them into Snowflake data models and Data pipelines.• Implemented Azure Data Factory Pipelines for Daily Full and Incremental loads and improved by 40% compared to on-premises daily load.• Created Pipelines in Azure Synapse using Linked Services/Datasets/Pipelines to Extract, Transform, and load data from different sources like Azure SQL, Blob storage, Azure SQLDW, and Azure Data Lake.• Created Delta tables for transformations from ADLS.• Utilized diverse data flow activities encompassing data movement, transformations, and control processes, including Copy Data, Data Flow, Get Metadata, Lookup, Stored Procedure, and Execute Pipeline. Proficiently managed Storage Services, specifically Data Lake Storage Gen 2 (ADLS), for hosting data in CSV, JSON, and Parquet formats, while efficiently administering access across storage accounts.• Deployed the codes to multiple environments with the help of the CI/CD process worked on code defects during the UAT testing and provided support to data loads for testing

• Worked closely with business analysts and stakeholders to understand requirements, translating them into Snowflake data models and ETL pipelines.• Implemented ETL processes using Microsoft BI tools (SSIS, Azure Data Factory) for data extraction, transformation, and loading from heterogeneous sources (Excel, Flat files, DB2) to destinations such as Azure SQL DB, Azure SQL Data Warehouse, and Flat Files, which led to time reduction in data extraction.• Designed and developed Power BI dashboards from Azure Analysis Services, effectively communicating insights and trends by improving of data visualization.• Maintained SQL tables, indexes, stored procedures, views, and triggers for Power BI reporting.• Created, maintained, and optimized databases, schema objects, SQL queries, stored procedures, indexes, functions, and views for data migration and ad-hoc reporting.• Automated data validation for tables through dynamic stored procedures and views, enhancing efficiency.• Managed structured and unstructured data from different sources (CSV, JSON, Flat) and performed data cleaning and preparation using Python.

• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages.• Experience in publishing the Power BI Desktop models to Power BI Service to create highly informative dashboards, collaborate using workspaces, apps, and to get quick insights about datasets.• Incorporated filters to narrow down data presented and slicers for appropriate user interaction, conditional formatting to spotlight alarming or profitable numbers• Created notifications and alerts, subscriptions to reports in the Power BI service.• Involved in Created Complex ad-hoc Reports, Sub Reports, Linked Reports, Charts, Drill through Report Models and Drill down Report.• Involved in Creating User Security and Roles in Power BI.• Responsible for building reports in Power BI from the Scratch.

• Reported daily on returned survey data and thoroughly communicated survey progress statistics, data issues, and their resolution.• Involved in Data analysis and quality check. Extracted data from source files, transformed and loaded to generate CSV data files with Python programming and SQL queries. Stored and retrieved data from data-warehouses.• Created the source to target mapping spreadsheet detailing the source, target data structure and transformation rule around it.• Wrote Python scripts to parse files and load the data in database, used Python to extract weekly information from the files, Developed Python scripts to clean the raw data.• Worked extensively with Tableau Business Intelligence tool to develop various dashboards.• Worked on datasets of various file types including HTML, Excel, PDF, Word and its conversions.• Analysed data from company databases to drive optimization and improvement of product development, marketing techniques and business strategies