Data Analyst
Current● Designed star/snowflake schema structures using Kimball methodology for data modeling, implementing a scalable and efficient data warehouse on SQL Server.● Executed ETL process, Data Mapping for dimension and fact creation using SSIS to validate, extract, transform, and load data into Data Warehouse, concurrently processing SSAS cubes to efficiently store data in OLAP Databases.● Scripted and optimized SQL queries and stored procedures, ensuring the implementation of precise business logic for analytical and reporting purposes, thereby improving overall performance.● Demonstrated expertise in DAX, Power Query, Data Visuals, and Data Connectors, optimizing data analysis and visualization capabilities for impactful insights.● Published and maintained reports on Power BI and Tableau servers, conducting walkthroughs with business users to ensure comprehension and obtaining timely sign-offs, improving report adoption.● Analyzed data from 210 monthly active retailers and used outputs to guide marketing and product strategies; increased average sales by 2x and decreased return rate by 23%.● Designed merchandising strategies for retailers based on regression analysis identifying key store attributes to increase traffic and conversion; resulting in a 17% sales lift.