About
Results-driven Power BI Developer with 4+ years of experience in designing, developing, and maintaining data models, reports, and dashboards. Expert in transforming business requirements into insightful and interactive visualizations using Power BI and SQL. Proficient in DAX, Power Query, and creating optimized data models using Star and Snowflake schemas. Skilled in Power BI Service, including dataflows, RLS, scheduled refreshes, and deployment pipelines. Strong collaboration and communication skills with a focus on accuracy, efficiency, and business impact.
Skills & Expertise (12)
Work Experience
Software Analyst ( Power BI Developer )
Capgemini
Mar 2023 - Aug 2024
Designed and developed an Operations Dashboard in Power BI to monitor and analyze key logistics KPIs, shipment data, and revenue metrics. Data was sourced from flat CSV files, which were cleaned and transformed using Power Query (M) to build a reliable and scalable data model. Created a star schema structure with clearly separated Fact and Dimension tables to optimize performance and ensure easy data slicing. Built interactive and visually compelling reports showing: Overall Performance Summary, Global & Regional Container Volume, Revenue vs Target, Revenue Trends Over Time, Month-over-Month (MoM) Revenue Change, Quarter-over-Quarter (QoQ) Revenue Change. Used advanced DAX measures to compute growth percentages, trend lines, and variance comparisons across time periods. Implemented filters, slicers, and tooltips to enable intuitive, self-service analytics for business users. Collaborated with operations and finance stakeholders to ensure dashboard KPIs aligned with business objectives and reporting needs.
Software Analyst ( Power BI Developer )
Capgemini
Jun 2022 - Mar 2023
Developed a comprehensive Power BI dashboard to monitor and analyze Alpha performance metrics over the past two years. Integrated and modeled data across multiple time periods to ensure consistent tracking of KPIs year over-year. Designed clear visualizations to track: Year-over-Year (YoY) performance, Operational KPIs, Target vs Actual metrics, Location-wise performance trends. Implemented time intelligence DAX functions to provide comparison across months, quarters, and years. Created custom date tables to support flexible filtering and trend analysis across different time windows. Used Power Query for cleaning and shaping raw input data from internal systems or flat files. Collaborated with regional leads to define key metrics and validate dashboard accuracy.
Senior Software Analyst ( Power BI Developer )
Capgemini
Jul 2025 - Present
Designed and developed an end-to-end Monthly Business Review (MBR) dashboard in Power BI to track business performance, trends, and KPIs across multiple dimensions. Consolidated data from multiple data sources (SQL databases and flat files) and built a clean, optimized data model using star/snowflake schema. Created interactive visuals with drill-down, drill-through, and slicers to enable leadership to analyze MoM performance and identify key drivers. Implemented DAX measures for YoY/MoM growth, cumulative metrics, variance analysis, and KPI benchmarking. Automated monthly refresh and distribution through Power BI Service, reducing manual reporting effort and turnaround time. Enabled self-service analytics for stakeholders by designing user-friendly layouts and intuitive navigation. Improved decision-making efficiency by providing single-view insights into revenue, usage, and operational metrics.
Senior Software Analyst ( Power BI Developer )
Capgemini
Aug 2024 - Jun 2025
Designed and developed an interactive Email Marketing Performance dashboard in Power BI, enabling stakeholders to track open rates, click-through rates (CTR), bounce rates, and conversions across multiple campaigns. Connected Power BI to MySQL database hosted on AWS RDS using DirectQuery to enable real-time data analysis and ensure up-to-date insights without data import delays. Established a DirectQuery connection between Power BI and AWS RDS (MySQL) via On-Premises Data Gateway, enabling secure, real-time access to cloud-hosted data for live dashboard updates. Built custom DAX measures to calculate KPIs such as Revenue, MoM & QoQ Revenues, used Line charts to analyze the Revenue Trends over Months. Implemented dynamic filtering and segmentation to analyze campaign performance by region, device type and customer segment. Developed custom visuals, including violin and radar charts, by integrating Python libraries (e.g., Matplotlib, Seaborn, Plotly) within Power BI to enhance advanced statistical and comparative data analysis.
Education
Bachelor of Engineering ( BE - Mechanical ) - Pune University
2017 - 2021 · Afghanistan
