Sunila Hedawoo

Led multi-cycle release projects over 3 years, delivering scalable, cloud-based data solutions for D365 F&O modules, including AR, AP, and Credit & Collections. Designed and implemented end-to-end data engineering and analytics solutions, transforming F&O data into actionable insights through KPI dashboards, reconciliations, and reporting solutions in collaboration with business and finance stakeholders.

Databricks(D365 F&O -Contract Management module)

• Designed a KPI dashboard project , integrating D365 F&O → Azure Data Lake → Databricks Lakehouse → Power BI.
• Worked with Bronze–Silver–Gold architecture using Delta Lake for data transformation, cleaning, and preparation for reporting.
• Queried Gold layer using Databricks SQL Warehouse to deliver business-ready insights on contract KPIs.
• Gained exposure to Azure permissions, workspace peering, and mount point setup as part of pipeline configuration.

Microsoft Fabric (F&O Finance Modules)

• Designed and deployed scalable Lakehouse architecture in Fabric using the Medallion (Bronze/Silver/Gold) pattern for D365 F&O data.
• Integrated Fabric Link with OneLake for near real-time ingestion from F&O modules.
• Delivered Timesheet and Leave of Absence (LOA) reconciliation solutions using Microsoft Fabric and Power BI, reducing month-end processing effort by 30%.
• Working on designing and implementing a dashboard for ISVs A365 product, leveraging OneLake integration, Azure Data Lake, and Power BI for near real-time reporting.
• Defined Power BI deployment and governance standards (RLS, storage mode, workspace setup) and drove cloud adoption across the data platform.
• Designed and implemented a cloud-based F&O data solution across finance modules, leveraging Azure Data Lake, Synapse Link, and SSMS to build robust data pipelines.
• Provisioned and managed Synapse workspaces, including Spark pools and SQL views, to support ingestion and transformation workflows.
• Integrated Power BI with Synapse Analytics and Fabric Lakehouse for real-time reporting across F&O modules.
• Developed and maintained robust Power BI semantic models to optimize performance and ensure consistent financial reporting.

• Developed real-time sales performance dashboards, increasing revenue by 15% through actionable insights.
• Enhanced client understanding of market trends, leading to informed decision making.

• Provided programming and data management expertise to support Business Technology Group in resolving DevOps backlog for D365 applications.
• Designed and developed automated, immersive business process flow for HR Onboarding Process.
• Performed data integration using Dataverse to streamline connectivity between D365 F&O and HR.

• Providing data support to the Surveillance Oncology Team for ongoing clinical trials.
• Led migration of Business Objects reports to Power BI, enhancing reporting efficiency and usability.
• Redesigned InfoPath forms into PowerApps as part of Office 365 migration initiatives.
• Providing reporting, coding, and validation expertise.

• Designed self-query reports and developed reporting templates using macros to automate monthly reports

• Collaborated with the EMEA VSOE sales team to generate sales renewal reports, analyse new contracts, and assess renewals and quotes across multiple quarters