PRACHI MADHUKAR KAND

Enthusiastic and results-driven Software Engineer with extensive experience in VBA, Advanced Excel, Power BI, and MySQL. Adept at developing automated solutions for data analysis and reporting, optimizing workflows, and enhancing decision-making processes. Skilled in translating complex user requirements into dynamic dashboards and interactive visualizations, enabling data-driven business insights. Strong background in collaborative team environments, leveraging technical expertise to drive efficiency, accuracy, and process automation. Proven success in implementing Volume Incentive Discount VID solutions and profit analysis dashboards to support financial and operational strategies.

• The association is dependable in offering full assistance for administrative center help in the reporting of global shipments (export and import) across the globe Furthermore, in order to maintain a good customer relationship, it also provides discounts to its clients on certain monetary terms, for which the need for creating a Carrier VID (Volume Incentive) arises. Discount emerges. It has been created by me first in Excel, and then in Power BI using Power Query (joints, clean up data), DAX (Sum, Sumx, Calculate, Filter, MTD, YTD, QTD), and visualization (Column Custer Chart, Pie Chart, Donut Chart, Multi cards, and Sicers)
• Created an interactive dashboard to track and analyze profit data, used complex parameters to drill down in the worksheet, and customization using filters and slicers, created connections, joined new tables, and made calculations to manipulate data enable user driven parameters for visualizations. Used different types of customized visualizations (bar chart, pie chart, donut chart, clustered bar chart, scatter chart, line chart, area chart, map, slicers, etc.)