Dipali Pawar

OneStream Planning – Transport Industry (Public Sector ), Australia

• Led the end-to-end design and development of two OneStream planning solutions, translating operational requirements into scalable financial models.
• Built complex allocation and driver-based planning models for budgeting, forecasting, and scenario analysis.
• Developed business rules, reports, and dashboards, providing actionable insights for finance and operations.
• Conducted requirement workshops, user training, and knowledge transfer to Deloitte teams.
• Served as the primary consultant during SIT, UAT, and Go-Live, resolving issues and ensuring smooth adoption.

OneStream Consolidation – Automotive Manufacturing Industry, Australia.

• Delivered an end-to-end OneStream Consolidation implementation with statutory and management reporting.
• Designed and built consolidation architecture, including cube configuration, dimensional modeling, workflow, and security for controlled close processes.
• Developed data integrations, transformation rules, consolidation calculations, and intercompany eliminations.
• Implemented certification and validation rules, supporting SIT, UAT, and production close cycles.
• Provided period-end close support and post Go-Live stabilization, resolving consolidation, workflow, and data issues with finance stakeholders.

OneStream Planning – Materials Manufacturing Industry, US

• Designed and implemented strategic planning and cash flow models.
• Configured cube structures, workflows, and security settings to support controlled planning cycles.
• Built driver-based forecasts models, enhancing visibility into operational and financial performance.
• Conducted training, workshops, and post Go-Live support, ensuring solution adoption and reliability.

OneStream Consolidation Support – Alcoholic Beverages Company, US

• Provided OneStream consolidation support, resolving client-facing issues that had persisted for five years.
• Implemented enhancements to the daily load process, including daily error counts for each dimension member, and resolution of daily mapping issues through transformation rules, ensuring accurate and reliable data loads.
• Optimized business rules to resolve critical consolidation and performance issues, significantly improving consolidation speed and efficiency.
• Delivered measurable process improvements, enabling smoother daily operations, faster issue resolution, and enhanced reporting accuracy.

OneStream Consolidation – Insurance Company,India

• Migrated HFM-based consolidation application to OneStream XF, replicating end-to-end business rules for opening balances, PL transfers, and translation.
• Developed and optimized Validation & Transformation Rules, No Input, and Confirmation Rules, ensuring accurate daily data loads and consolidation integrity.
• Built dashboards and Cube Views, automated FX rate updates via CSV and Excel functions, and managed user security & access, improving reporting efficiency and control.
• Delivered a fully functional consolidation solution, enhancing data accuracy, system performance, and enabling seamless HFM-to-OneStream transition.

Billing Application – Power Apps & Power BI

• Designed and developed a billing application to streamline staff outsourcing and service management using Power Apps, Power Automate, and Power BI.
• Migrated SharePoint data to SQL tables, built web forms and data tables for user-friendly interaction, and implemented bulk upload/download functionality.
• Automated reminders and approval emails via Power Automate and implemented double-billing logic to prevent duplicate entries.
• Developed Power BI reports with access control, providing actionable insights and improving billing accuracy, process efficiency, and decision-making.

OneStream Consolidation – PCB Testing Company

• Migrated HFM to OneStream XF for 100+ users, designing dimension hierarchies, cubes, and business rules for P&L, balance sheet, and cash flow consolidation.
• Developed dashboards, CEO-level reports, Quick Views, and automated workflows, improving reporting efficiency.
• Reconciled OneStream data with HFM historical data, managed user security and confirmation rules, ensuring accurate and reliable financial reporting post-migration.