About
Data Analyst with 3 years of experience driving insights through data analysis, visualization, and reporting. Expertise in SQL, Power BI, and Excel to analyse large datasets and build automated dashboards. Known for improving reporting efficiency, identifying trends, and supporting business growth through data-backed recommendations.
Skills & Expertise (39)
Work Experience
Data Analyst
Optimum Data Analytics
Mar 2023 - Present
Collect, clean, and analyse large datasets from various sources including Snowflake and SQL server to support business decision-making. Integrated data from multiple sources into Power BI to design and deploy interactive reports and custom dashboards, driving data driven decision-making across teams. Design and develop interactive dashboards and reports in Power BI to visualize KPIs and performance metrics for stakeholders. Developed and optimized custom DAX measures and calculated columns to improve report accuracy, time intelligence, and business insights. Managed scheduled data refreshes in Power BI Workspaces, ensuring real-time data availability for stakeholders. Developed and optimized complex SQL queries involving Joins, Aggregate functions, and various SQL clauses to extract, manipulate, and transform data for analytical purposes. Optimized SQL queries by applying indexing, query refactoring, and performance tuning techniques, achieving a 20% reduction in query execution times. Support the deployment and monitoring of data workflows in ADF, ensuring timely data availability for analytics. Created and maintained database tables, views, and indexes to support data storage. Built Azure Data Factory (ADF) pipelines for automated ETL processes, reducing manual workflows by 15%. Monitored and troubleshooted ADF pipeline failures and scheduled triggers, ensuring prompt remediation and minimal disruptions in data workflows.
Education
Bachelor of Engineering (BE) - Shivaji University
- · Afghanistan
