Reshma Shalgar

Development

Objective:

To consolidate multi-source financial data and create interactive dashboards for real-time tracking of revenues, expenses, budgets, and cash flow, enabling leadership to make data-driven financial decisions.

Scope & Activities:

• Data Integration:
• Gathered raw financial data (revenues, expenses, and budgets) from multiple Excel sheets used across departments.
• Standardized data formats and automated the ETL (Extract, Transform, Load) process into Tabulae and Power BI to ensure consistency and minimize manual intervention.
• Dashboard Development:
• Designed P&L Dashboards to monitor revenue vs. expense trends, unit-level profitability, and budget utilization.
• Built Cost Variance Dashboards with drill-down features for department, region, and time-period comparisons.
• Developed Cash Flow Forecasting Dashboards using Power BI’s forecasting visuals to predict short-term and long-term liquidity.
• Leveraged Tabulae’s storytelling features to create interactive presentations that communicated financial health to stakeholders.
• Automation & Efficiency Gains:
• Automated Excel-based variance analysis, reducing manual reporting effort by 40%.
• Implemented scheduled data refresh pipelines to keep dashboards live and error-free.
• Business Impact:
• Provided future cash position insights, enabling proactive liquidity management.
• Helped leadership reallocate budgets from low-performing to high-performing business units, improving profitability and resource utilization.
• Enhanced financial transparency and reduced reporting cycle time from days to hours.

Project: HR Analytics & Attrition Prediction Dashboard

Objective:

To design an HR analytics system that integrates workforce data, tracks employee trends, and predicts attrition, thereby supporting HR leadership in improving retention and optimizing recruitment strategies.

Scope & Activities:

• Data Integration:
• Consolidated employee headcount, attrition, absenteeism, and performance data from multiple Excel sources.
• Established automated pipelines to transfer and clean data into Tabulae and Power BI, reducing dependency on manual uploads and ensuring real-time refreshes.
• Dashboard Development:
• Built Attrition Trend Dashboards to track voluntary and involuntary attrition across time periods and departments.
• Designed Absenteeism Dashboards highlighting attendance patterns, frequent leave categories, and peak absenteeism periods.
• Developed Workforce Distribution Dashboards showing gender diversity, department strength, and tenure-based employee segmentation.
• Predictive Modeling:
• Created Attrition Prediction Models in Power BI to identify high-risk employee groups using factors such as absenteeism rate, performance rating, and tenure.
• Added interactive storytelling features in Tabulae, allowing HR leadership to visualize and present employee risk clusters with context-driven narratives.
• Automation & Efficiency Gains:
• Reduced manual report generation effort by automating Excel-to-Tabulae refresh pipelines.
• Enabled dynamic HR dashboards with self-service filters for location, department, and job role insights.
• Business Impact:
• Helped HR leadership identify at-risk employees early, enabling targeted retention strategies (mentorship, training, incentives).
• Improved employee retention rates and reduced recruitment costs by optimizing hiring strategy for high-attrition roles.
• Enhanced workforce visibility and streamlined HR decision-making with interactive dashboards and predictive analyti