-- Implemented efficient SQL queries to replace hard-coded product-values in Cognos version for enterprise data, making them more user-friendly and easier to access for data visualization.-- Created databases for large sales data on Snowflake servers by extracting legacy data models from SSAS.-- Developed pipelines for lookup value tables for different data, by replacing initial queries to enhance data retrieval by 50%.-- Worked on Cognos-generated SQL to build dynamic queries, improving query performance, cost, and scalability by achieving a target of 70hr of manual work by automating the reports.-- Implemented Pivot Tables and optimized underused SSAS OLAP data cubes to Snowflake, resulting in a 30% reduction in license costs and $1.3 Million cost savings.-- Transformed Power BI and Excel reporting solutions that sourced data of SQL database queries to Snowflake.-- Developed validation queries and performed detailed analytics, achieving an outstanding accuracy rate of 99%.-- Designed, automated, robust and meaningful measures for MTD, QTD, and YTD using DAX expressions for paginated reports in Power BI for analyzing the data using POWER BI Report Builder to draw conclusions for betterment of item sales.

● Responsible for ingesting large volumes of user behavioral data and customer profile data to Analytics data store.● Experienced in analyzing, designing, and developing ETL Strategies, processes, and writing ETL specifications.● Designed and developed ETL jobs to extract data from different data sources like Oracle, and Microsoft SQLServer, transformed it using Hive Query Language (HQL) & loaded it into Hadoop Distributed file system(HDFS).● Developed Python scripts using Hadoop Distributed File System APIs to generate Curl commands and migratedata to work in different environments.● Responsible for design, implementation, test, & maintenance of database solutions using Oracle & MSSQL Server● Developed data pipelines to perform automated extraction, transformation, and load data between data sourceswhen working with large data sets.

Developed and maintained ETL pipelines using control flow containers, user-defined functions, cascading reports,parameterized reports, and stored procedures to process the data using various SQL operations.● Built and Deployed packages using SSIS Catalogs and was involved in Job Scheduling.● Delivered the product on time with 99% accuracy and received recognition and appreciation from clients.● Improved pipeline efficiency by creating a utility to clear intermediate storage and logging space at regular intervals.