● Designed and developed comprehensive reports and interactive dashboards using Power BI. Utilized Power Query for data extraction, transformation, and loading (ETL) from diverse sources including MySQL and Excel.● Developed a sales performance dashboard, resulting in easily identifiable insights that helped increase sales revenue and reduce manpower.● Conducted in-depth inventory analysis, utilizing advanced Excel techniques, which resulted in a notable 9% revenue growth by optimizing stock levels, minimizing overstock, identifying slow moving categories and unhealthy inventory.● Optimized dashboard performance by implementing indexing and applying DAX functions resulting in a dynamic dashboard with decrease in load time.● Developed logical data models based on analyzed business requirements, capturing data and relationship descriptions.● Collaborated with the finance team to develop a financial reporting dashboard resulting in a 50% reduction in report development time.● Uploaded daily inventory reports, master inventory, and purchase orders in the database, and calculated loss in transit.● Prepared daily, monthly, quarterly, and YOY sales and profit reports in Excel, and also tracked daily movement of inventory stocks.

● Worked in the Documentation and Planning department, with excellent knowledge of advanced Excel, SQL, Power BI, and PowerPoint.● Collected, organized, and maintained data from various sources within the organization. This includes customer information, sales data, inventory records and other relevant information.● Created and maintained Power BI reports and published them for management daily/weekly/monthly.● Performed modifications, edits, and deletions to the database using SQL on authorized documents.● Developed informatic mapping utilizing various transformations such as joins, aggregate, expression, filter, and update strategy.● Identified problematic data during the entry and comparison process.● To keep the report data bank ready for any request received from time to time.