Ali asgar Shad

Roles & Responsibility

Developed and managed end-to-end data workflows by extracting raw field data from the Rupeez App, utilizing Python or Advanced Excel to clean, transform, and validate attendance for a large-scale workforce, ensuring 100% data accuracy before reporting. Engineered a robust multi-stage verification process for sales expense reporting; cross-referenced geographic town data and mileage against DWR (Daily Work Report) logs using advanced functions (VLOOKUP, Logical Formulas) to identify discrepancies and prevent financial leakage. Streamlined the monthly reporting cycle by maintaining a centralized MS Access database; performed regular data hygiene (active/inactive employee modeling) and delivered automated performance insights to Team Leaders to drive operational decision-making.