Designed and optimized relational databases across 15+ tables using normalization standards, ensuring data integrity and structured storage. Improved performance by optimizing 50+ SQL queries through indexing and execution tuning, reducing execution time by 40% while enhancing query efficiency and overall database performance reliability.
• SQL
• Database Design
• Query Optimization
• Data Modeling
• Performance Tuning
Developed a comprehensive business intelligence solution using Power BI, integrating 10+ data sources through Power Query transformations. Designed star-schema data models and 30+ DAX measures to improve query performance by 25%, enabling accurate KPI tracking, enhanced reporting insights, and improved business decision-making efficiency.
• Power BI
• Data Modeling
• DAX
• Power Query
• Data Analysis