Sakshi More

• Applied security measures into systems development, supporting final products' resistance to intrusion and exploitation.
• Devised automation, backup and recovery protocols to preserve and safeguard data.

Project 1 - Item Ledger Entry Report.

• Designed and developed an interactive Power BI report using data from Microsoft Dynamics 365 Business Central and SQL Server Analysis Services (SSAS).
• Developed DAX measures and implemented time-intelligence functions to support financial reconciliation and audit reporting.
• Focused on item ledger entries to track inventory movements, quantities, and costs across purchases, sales, transfers, and adjustments.
• Enabled end users to monitor stock flow, item-level history, and valuation trends with dynamic filters and time-based analytics.

Project 2 - Inventory Valuation Forecast Report.

• Developed a Power BI financial report to forecast inventory valuation using historical data from Dynamics 365 Business Central, and multidimensional models in SSAS.
• Designed data models to project future stock value based on consumption trends, lead times, and cost patterns.
• Implemented advanced DAX calculations for valuation forecasts, variance analysis, and inventory aging to support strategic financial planning.

Project 3 - Sales Report.

• Developed a scalable Power BI Sales Report by integrating fact and dimension data from SSAS cubes and Microsoft Dynamics 365 Business Central.
• Implemented DAX measures to calculate KPIs such as total sales, gross margin, year-over-year growth, and customer segmentation.
• Utilized star schema modeling, row-level security, and drill-through actions to support performance analysis across product, customer, and region dimensions.

Project 4 - Accounts Receivable Report

• Created a Power BI report using data from Business Central and SSAS to track customer balances, overdue invoices, and aging summaries.
• Helped the finance team monitor receivables, improve collections, and manage credit risk with clear visualizations and filters.

• DFM Foods is a leading player in the manufacturing of packaged snacks business.
• Responsibilities include advanced data visualization and modeling projects as outlined below.

Project 1 - DMF Foods Sales and Margin.

• Analysis in different ways, like YTD, MTD, QTD, and total revenue.
• Understanding the existing architecture of EPICOR ERP and SQL Server data warehousing system, the required tables, and columns, and documenting the same.
• Maintenance of the reports, workspaces for precise numbers, and data reporting; resolving issues related to reports, finding root causes, and providing optimized solutions.

Project 2 - Financial Health Analysis.

• Integrate data from various financial sources, such as income statements, balance sheets, cash flow statements, and financial KPIs, into a unified dataset.
• Design visually appealing and interactive charts, graphs, and tables to represent essential financial metrics.
• Implement dynamic filters and slicers to allow users to customize the dashboard according to their specific requirements.
• DFM Foods is a leading player in the manufacturing of packaged snacks business.

• Data Collection and Cleaning: Gather data from diverse sources such as databases and surveys.
• Clean and preprocess this data to maintain accuracy and consistency.
• Data Visualization: Develop charts, graphs, and dashboards to illustrate data insights using tools like Tableau, Power BI, and matplotlib.
• Data Mining: Apply statistical methods and algorithms to uncover patterns and trends.
• Use techniques including clustering, classification, and regression analysis.
• Database Management: Design, implement, and manage databases, ensuring secure storage and efficient data retrieval.