Yash Dubey

- Developed real-time, role-specific dashboards for PMO, Sales, Operations, Finance, HR, and Technology teams to track CRM data, workloads, and project progress, enhancing cross-functional visibility and enabling faster, data-driven decisions.
- Defined and implemented KPI frameworks and governance, aligning metrics with business objectives to strengthen performance monitoring and accountability across teams.
- Automated AI-enabled workflows using custom templates, APIs, and VBA, streamlining processes across CRM and ERP systems, reducing manual effort and improving operational efficiency.
- Integrated multiple applications with Monday.com via APIs and custom connectors, including ERP integrations, optimizing CRM and operational data flow, enhancing reporting accuracy, and boosting overall efficiency.

- Delivered 10 end-to-end Power BI projects for spend and usage analysis, providing actionable insights that empowered data-driven decision-making across the organization.
- Automated data transformation and reporting pipelines using VBA and Macros, significantly reducing manual effort and enhancing operational efficiency.
- Leveraged Azure data services to integrate, manage, and analyze large datasets, enabling real-time business intelligence and supporting strategic decision-making.

- Integrated multiple database systems with analytics platforms to deliver real-time business insights through interactive dashboards, enabling faster and data-driven decision-making.
- Automated financial audit and reporting processes using VBA and Macros, streamlining data transformation and analysis, significantly improving accuracy, efficiency, and reporting turnaround.
- Prepared weekly MIS reports and contributed to product development by providing research-backed insights and feedback, enhancing business performance and strategic decision-making.

- Delivered 19 end-to-end spend analytics and CRM data analytics projects, managing requirements gathering, development, and final delivery, including insights derived from ERP and CRM systems.
- Designed and developed custom Power BI dashboards providing domain-specific insights across Banking, Real Estate, Financial Services, Retail, E-commerce, F&B, Hospitality, and Technology, enhancing strategic decision-making.
- Automated monthly data refresh and reporting workflows using VBA and Macros, improving operational efficiency and reducing manual effort.
- Developed custom visuals and KPI-driven dashboards to support data-driven decision-making across departments.
- Integrated data from multiple sources, including SQL databases, CRM, and ERP systems, and applied machine learning techniques for data classification and normalization, ensuring consistent and accurate reporting.