Power Bi Data Analyst

Ammar Shariq Arifi

Data Analyst Power BI Developer Dashboarding Expert

+91-703******* ***********@*****.*** linkedin.com/in/ammar-shariq-arifi Professional Summary

Data Analyst with 3+ years of experience building data-driven dashboards and BI solutions using Power BI Desktop & Service, DAX, Power Query (M language), Excel and advanced SQL. Delivered measurable impact by improving report performance by 35%, enhancing forecasting accuracy by 15%, and reducing production downtime by 25%. Proficient in designing optimized data models (Star/Snowflake schema), developing ETL pipelines, and automating reporting workflows. Adept at translating business needs into actionable KPIs and visualizations, with strong collaboration skills in Agile, cross-functional environments. Skills

Data Analysis & Visualization: Power BI (Desktop & Service), DAX, Power Query (M Language), Python (Pandas), SQL (Joins, Subqueries, Excel (PivotTables, Charts, VLOOKUP), Data Warehousing, ETL Concepts, EDA (Exploratory Data Analysis) Dashboarding & Reporting: KPI Development, Real-time Dashboards, Reporting Automation, Static Reports, Data Storytelling Data Processing &Modeling: Data Cleaning, Data Transformation, Data Wrangling, Preprocessing, Star/Snowflake Schema Modeling Programming & Tools: Python, SQL, Jupyter Notebook, Git, GitHub, VS Code, Command Line (basic Git) Database & Platforms: Oracle SQL Developer, Excel, Google Sheets. Collaboration & Methodology: Stakeholder Communication, Cross-functional Collaboration, Requirement Gathering, Agile Methodology, Critical Thinking, Problem Solving

Experience

Capgemini Technology Services India Limited April 2022 – October 2024 Sr. Analyst Power BI Developer Mumbai, Maharashtra

• Developed and deployed 15+ Power BI dashboards using DAX and Power Query, improving real-time visibility for 10+ key operational KPIs and compliance metrics.

• Designed Star schema-based data models and implemented row-level security (RLS), improving report performance by 35% and enhancing data access control across business units.

• Created SQL views and stored procedures to support report backend logic, reducing manual data refresh effort by 40%.

• Collaborated in Agile environment with cross-functional stakeholders to gather reporting requirements and delivering iterative dashboard updates that accelerated project turnaround by 25%.

• Automated data ingestion using parameterized Power BI datasets, streamlining daily reporting processes.

• Selected for Germany onsite assignment, driving global collaboration and facilitating knowledge transfer with onshore development and QA teams.

Imminent Engineering Endeavours June 2021 – March 2022 Data Analyst Aurangabad, Maharashtra

• Built interactive dashboards tracking sales, customer retention, and inventory, leading to a 15% increase in forecasting accuracy and 10% reduction in stockouts.

• Designed ETL workflows that improved data pipeline efficiency, reducing manual effort by 25% and enabling faster insights delivery.

• Conducted EDA and developed data stories that helped leadership uncover 3 new customer segments, contributing to a 20% boost in targeted marketing ROI.

• Increased production efficiency by 25% by leveraging market insights and implementing targeted process improvements.

• Boosted customer retention by 20% through analysis of usage data and market trends, optimizing product offerings early on. Projects

Power BI Optimization & Tuning

(Power BI, DAX, Power Query, SQL, Excel)

• Built Power BI dashboards using DAX and M language with optimized data models, reducing report load time by 40%.

• Applied best practices in performance tuning (e.g., aggregations, query reduction, efficient relationships). Retail Sales Data Analysis

(Power BI, Python, Pandas, Matplotlib, Seaborn, SQL, Excel)

• Analysed 100K+ retail transactions to uncover sales trends and customer segments, enhancing targeted marketing strategies.

• Built interactive dashboards and performed data cleaning to ensure 99% accuracy, driving 30% improvement in sales strategy adoption. Education

Bachelor of Technology in Mechanical Engineering August 2017 – June 2021 Deogiri Institute of Engineering and Management Studies CGPA: 8.2/10 Relevant Coursework: Engineering Mathematics, Data Analysis, Statistics, Computer Programming Certifications

Microsoft Power BI- certification-Udemy

Contact this candidate