About
Detail-oriented Data Analyst / Business Analyst with hands-on experience in Advanced Microsoft Excel, SQL/T-SQL, and Power BI gained through applied end-to-end analytics projects. Skilled in preparing structured MIS reports, consolidating data from multiple sources, and developing KPI dashboards for business reporting. Experienced in data cleaning, report automation, and analytical reporting while ensuring high accuracy and consistency. Strong communicator who collaborates well with cross-functional teams, with a quick learner's attention to detail and a commitment to continuous improvement.
Skills & Expertise (36)
Work Experience
Project
Sales Analytics
Present - Present
Built an end-to-end sales analytics project using SQL Server and Power BI, analyzing customer, order, product, revenue, and payment data. Developed 10 SQL business analyses using CTEs, window functions, ranking, RFM segmentation, and aggregations. Created an interactive 2-page Power BI dashboard with KPIs covering revenue trends, customer behavior, category performance, city-wise sales, and payment analysis. Implemented DAX measures for month-over-month growth, repeat purchase rate, customer segmentation, and churn analysis.
Project
Cash Application Reconciliation Dashboard
Present - Present
Developed an interactive Cash Application Reconciliation Dashboard in Microsoft Excel to analyze invoice reconciliation, payment matching, and outstanding balances. Created KPI cards to monitor reconciliation metrics, payment status, unapplied cash, and collection performance. Built dynamic reports using Pivot Tables, Pivot Charts, Slicers, Excel Tables, and advanced formulas (SUMIFS, COUNTIFS, AVERAGEIFS, XLOOKUP, INDEX-MATCH, IF, EDATE); documented and published the project on GitHub following professional repository structure and version control practices.
Project
E-Commerce Sales Analytical Dashboard
Present - Present
Developed an interactive E-Commerce Sales Analytics Dashboard using Microsoft Excel; cleaned and transformed sales data. Created KPIs for Total Sales, Profit, Orders, Quantity Sold, and Average Order Value. Built Pivot Tables, Pivot Charts, and Slicers for dynamic filtering by Country, Category, and Year. Used XLOOKUP, INDEX-MATCH, SUMIFS, IF, and other Excel formulas to automate calculations, improving reporting speed and accuracy.
Education
Bachelor of Computer Applications (BCA) - Bengaluru City University
2023 - 2026 · Afghanistan
Certifications
No certifications added yet
Interested in this developer?
Profile Score Breakdown
Profile Overview
Availability Details
Relocation
Depends on Offer
Skills (36)
Click a skill to find developers with the same skill
