About
Business Intelligence Developer specialising in Power BI, DAX and Power Query, with hands-on ownership of an end-to-end pharmaceutical sales and supply-chain analytics solution. Designs star-schema semantic models over multi-source data, builds measure logic that holds up under matrix aggregation and returns handling, and delivers self-service reporting that replaces manual Excel cycles. Experienced in inventory, expiry-risk, supplier and sales-agent analytics for commercial and supply-chain stakeholders.
Skills & Expertise (34)
Work Experience
Data Analyst
Global Brands E-commerce / Amazon Seller Domain
May 2025 - Aug 2026
Improved sales and inventory reporting by developing Power BI dashboards for SKU-wise and fulfillment-center analysis across 1,400+ SKUs and 110 FCs, providing a consolidated view of sales, inventory and stock movement. Automated operational data ingestion by connecting Power Query to JSON APIs, bringing external reporting data directly into the Power BI data preparation workflow and reducing dependency on manual data collection. Cleansed and standardised source data in Power Query through duplicate removal, data-type conversion, column standardisation, data transformation and data integration, improving data quality for reporting. Built a structured Power BI data model using a Galaxy Schema, connecting multiple fact and dimension tables including Sales, Inventory, In-Transit, SKU, EAN, FC and Calendar datasets for integrated sales and inventory analysis. Developed DAX measures using CALCULATE, SUMX, SUMMARIZE, VALUES, SUM, TREATAS and USERELATIONSHIP to calculate business KPIs and perform SKU- and FC-level analysis. Analysed 7-day, 14-day, 21-day and 30-day sales trends to measure sales velocity and identify fast-moving, slow-moving, understocked and overstocked SKUs. Supported inventory and replenishment planning by analysing available inventory, sales performance and in-transit quantities, helping identify stock shortages, excess inventory and replenishment requirements. Developed Power BI dashboards and interactive reports with KPI cards, filters and drill-down analysis to provide visibility into sales, inventory and fulfillment-center performance. Automated repetitive reporting activities using Google Sheets, applying VLOOKUP, XLOOKUP, SUMIFS, FILTER and IMPORTRANGE for data lookup, consolidation and reporting. Used Advanced Excel Pivot Tables to summarise and analyse large sales and inventory datasets, creating SKU-wise, FC-wise and product-level reports for operational decision-making. Used Advanced Excel for sales and inventory analysis, reconciliation, reporting and business calculations using VLOOKUP, XLOOKUP, SUMIFS, FILTER and Pivot Tables. Performed SKU-wise and FC-wise analysis to identify stock availability, inventory movement and product performance, supporting operational and stock allocation decisions. Maintained and validated large operational datasets across multiple sources to improve reporting accuracy, data consistency and reliability. Built reporting solutions combining Power BI, Power Query, DAX, Advanced Excel Pivot Tables and Google Sheets to support recurring sales, inventory and replenishment analysis.
MIS Analyst
Partha Dental, Skin & Hair
Mar 2022 - Apr 2025
Prepared and analysed daily branch revenue reports using Advanced Excel and Pivot Tables, monitoring revenue performance across multiple branches. Analysed branch-wise cash flow and revenue collections, helping management monitor daily financial performance and identify variations between branches. Analysed treatment-wise revenue using Excel Pivot Tables to identify high-performing and low-performing treatments and their contribution to overall revenue. Compared branch-wise revenue and cash-flow performance to identify top-performing and underperforming branches. Created branch-wise and treatment-wise Pivot Table reports for daily and monthly management review. Monitored daily revenue trends, treatment volumes and collections to support branch-level performance analysis. Prepared daily and monthly MIS reports by consolidating and validating operational data received from multiple branches. Reconciled branch-level revenue and collection data, identifying discrepancies and maintaining accuracy in recurring MIS reports. Developed Excel-based reports to compare revenue, cash flow, treatment performance and branch contribution, supporting management decision-making. Automated repetitive MIS reporting activities using Excel formulas, Pivot Tables and structured reporting templates.
Education
Bsc Aquaculture - Telangana University
2019 - · Afghanistan
Certifications
No certifications added yet
Interested in this developer?
Profile Score Breakdown
Profile Overview
Skills (34)
Click a skill to find developers with the same skill
