Project Portfolio
A complete record of my strategic HR consulting and payroll automation projects in Bangladesh.
"mudivai.online" Shop Management App
A high-performance retail management application designed for the Bangladeshi market. It handles inventory tracking, POS (Point of Sale) operations, and daily sales reporting with multi-tenant database architecture. Check: https://mudivai.online/
Automated Payroll Summary & OT Calculation (Advanced Excel)
An automated Excel-based Payroll & OT Management system designed to streamline monthly salary disbursement. This project features dynamic formulas for Overtime (OT) calculation, basic salary structuring, and comprehensive gross salary reporting. It reduces manual entry errors by 40% and ensures full transparency for HR and Finance audits, providing management with a one-click summary of workforce costs.
HR Monthly Report & Headcount Summary (Advanced Excel Analytics)
A high-impact HR Analytics Dashboard built in Excel to monitor real-time workforce stability, department-wise headcount distribution, and monthly turnover trends. This project automates the transition from raw employee data to executive-level visual summaries using dynamic Pivot Tables and automated data cleansing logic. It provides leadership with a clear view of hiring velocity, gender diversity ratios, and attrition risks, enabling faster, data-driven HR decision-making.
Recruitment Tracker & Hiring Pipeline (Advanced Excel)
A dynamic Recruitment Lifecycle Tracker designed to monitor candidates from application to onboarding. This Excel-based tool provides real-time visibility into the hiring funnel, tracking Source Effectiveness, Time-to-Hire, and Cost-per-Hire. It features an automated dashboard that summarizes applicant status across multiple departments, ensuring no top-tier talent is lost in the process and providing HR teams with a data-driven approach to talent acquisition.