•Implemented DWH solution consisting of ETLs, On Premise to Cloud Migration and expertise building and deploying batch and streaming data pipelines on cloud environment.•leveraging features such as virtual warehouses, data sharing, and clustering to enhance performance and scalability.•Designed and implemented partitioning strategies for large datasets within Snowflake, improving query performance by optimizing data distribution and minimizing I/O operations.•implement SnowPipe pipelines for real-time data ingestion into Snowflake, enabling seamless and automated data loading from external sources such as cloud storage or streaming platforms.•Use DBT to debug complex chains of queries. They can be split into multiple models and macros that can be tested separately.•implement incremental data processing techniques in DBT to optimize performance and reduce processing time for large datasets, enhancing efficiency in data pipelines.•Created Pipelines in ADF using Linked Services / Datasets / Pipeline to Extract, Transform, and load data from different sources like Azure SQL, Blob storage, Azure SQL DWH.•Implemented complex data transformations using ADF Data Flow activities, leveraging transformations like Filter, Derived Column, Lookup, Conditional Split.•Writing in Python Code for Data Manipulation, ETL Tools, utilizing libraries such as Pandas, NumPy, windows functions to clean, transform, and analyze large datasets.•Develop ETL pipelines in and out of data warehouse using combination of Databricks (PySpark, Spark SQL), Python and SnowSQL.•Develop Spark applications using PySpark and Spark-SQL for data extraction, transformation, and aggregation from multiple file formats for analyzing, transforming the data to uncover insights into customer usage patterns.•Developed spark scripts and python functions that involve performing transformations and actions on data sets.

• Used Model Mart of ER win for effective model management of sharing, dividing, and reusing model information and design for productivity improvement.• Designed SSIS packages to populate the data into MDS using staging tables and stored procedures from SQL server.• Handled Performance Tuning and Optimization on SSIS and MDX, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.• Created Data-driven Packages in SSIS as part of the automating the process for the Referral Process.• Developed SSIS packages for data transformation from legacy claims processing systems and built Cubes from fact/dimension tables (OLAP). Ad-hoc reporting using Report Server.• Involved in Designing, Analyzing, building, and testing OLAP cubes in SSAS and adding calculations using MDX.• Involved in Tabular Datawarehouse and DAX operations for SSAS 2012 and 2008 OLAP databases.• Design and implemented custom scripts. Extensive use of version controller Team Foundation Server (TFS).• Calculating columns, Measures query’s in Power BI desktop to show good data analysis techniques• Creating Static Reports using MDX queries and creating MDX Base Report Definition.• Maintaining the SQL Server monitoring using the PowerShell scripts to collect the performance related, DDL related and deadlock related events.• Creating Custom Azure Templates for quick deployments and advanced PowerShell scripting.• Developed scripts for MongoDB collection changes and implementation of the Business logic layer for Services.• Established robust techniques raw data exchanges, built & maintained SSRS, ETL package.• Developing complex Queries using Stored procedures, common table expressions (CTEs), temporary tables to support Power BI and SSRS reports.• Recommend and Review Backup and Recovery Strategies and test plans for failure scenarios and designed SQL Server Security (Server hardening, Auditing).

• Writing MDX queries while creating and customizing Cubes using SQL Server Analysis Services (SSAS).• Created Scheduled task of SSIS packages to load data from SQL server into SQL data warehouse. • Use reverse engineering to create Graphical Representation (ER diagram) and to connect to existing database.• Defining relationships between Dimensions and Measure groups. Involved in the design and development of the SSAS cubes and MDX queries.• Developed front end web base dashboard with trending data, animated pipeline charts, and demographic charts with drill downs functions that displays a breakdown of Regional/States sales, utilizing data aggregation from SQL statements.• Migrated existing self-service reports and ad-hoc reports to Power BI• Designed and created data extracts, supporting SSRS, Power BI visualization tools reporting applications.• Involved in implementation of Master Data Services through Data Quality Services, Designed the SSIS packages move the data between MDS and EDW.• Running synchronization process between production, staging, testing and development environment.• Created PowerShell Scripts to patch DLLs across various servers and automate database deployments using SSDT.• Performed Administrative tasks in SQL Server using PowerShell.• Scheduled and maintained packages by daily, weekly and monthly using SQL Server Agent in SSMS.• Created T-SQL objects & scripts used to maintain data integrity across all databases throughout database servers (Stored Procedures, Triggers, Functions).• Implemented Table Partitioning, Advanced Error handling, Common Table Expression (CTE) and LINQ.• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.• Designed and developed application in sending Emails of Daily Reports using DB Mail configuration.• Database corruption (checks database status, and periodically Verifies database integrity).