• Imported and transformed over 15,000 rows of raw data from Excel sheets using advanced techniques like pivot tables and complex formulas; prepared datasets for Power BI analysis resulting in faster reporting times by 30%. • Designed and launched advanced Power BI dashboards that integrated real-time sales data, stock levels, and seasonal trends, enabling inventory management decisions that improved stock turnover rate by 25% within three months. • Built advanced analytical reports leveraging DAX functions, merging data from MySQL and Excel; this initiative resulted in a 30% reduction in time spent on data wrangling, enabling quicker access to critical business insights. • Engineered data visualization by implementing measures and calculated columns to generate insights on customer preferences, popular product categories, and profitability across different seasons. • Partnered with the sales team to evaluate historical purchasing trends; refined reorder point accuracy leading to a significant decrease of 20% in both stockouts and excess inventory within three months. • Spearheaded seasonal sales forecasting initiatives that analyzed over 2 years of historical data and occasion-specific insights, optimizing inventory levels for peak periods such as holidays and product launches to meet customer demand.

• Developed SQL scripts for five databases, driving a 25% rise in operational efficiency through actionable reporting and optimized resource allocation. Leveraged Window Functions and Joins for fast, accurate data retrieval.• Automated business processes with stored procedures, cutting manual data entry by 70% and improving efficiency by 25%. Enhanced workflow automation and consistency.• Mastered T-SQL, Views, Triggers, Indexes, and Window Functions. Improved data processing by 40% through optimized query performance and faster reporting.• Partnered with teams to translate business needs into efficient SQL solutions, reducing processing time with advanced optimization techniques.• Expertise in Power BI Suite, including Power Query, DAX, and KPI dashboards, delivering clear insights and enabling data-driven decision-making.• Proficient in data modeling and ETL processes, transforming raw data into structured formats. Improved dashboard usability by 40% with Power Query and DAX.• Optimized reporting through stored procedures, consolidating data from multiple sources for faster retrieval and enhanced reporting efficiency using CRUD operations and temp tables.• Implemented real-time data validation queries, reducing errors by 20% and boosting data processing speed with accurate monitoring.