Asad Rehman
Operations & Data Specialist | Excel Dashboards & Workflows
New to Contra
Asad is building their profile!
š Customer Lifecycle Segmentation: Active, Dormant & Churned Analysis
Key Highlights:
šÆ Identified & Segmented: Comprehensive customer database auditing to isolate active, dormant, and transacting customer cohorts.
š Uncovered: Hidden revenue leakage by flagging high-value dormant accounts ready for re-engagement campaigns.
š Automated: Dynamic reporting frameworks to track transaction frequency recency, and lifecycle status in real-time.
š” Optimized: Actionable insights delivered to management to drive targeted customer retention and reactivation strategies.
š ļø Tools Used: Advanced Excel/Google Sheets, Customer Segmentation, Data Auditing, Lifecycle Analytics.
0
27
šļø Comprehensive HR Annual Leave Tracker, Roster & Planner
Key Highlights:
š Engineered: A 12-month annual leave planner and dynamic employee roster system to track leaves, absences, and lates in one centralized view.
š Tracked: Real-time visibility into leave balances, absence patterns, and tardiness records for complete workforce oversight.
āļø Automated: Integrated status indicators that instantly calculate remaining allowances and flag scheduling bottlenecks.
šÆ Streamlined: Replaced manual HR record-keeping with an intuitive, error-free tracking dashboard.
š Tools Used: Advanced Excel/Google Sheets Formulas, Conditional Formatting, HR Analytics, Workforce Scheduling.
0
28
āļø Real-Time Agent Accountability & Rate Update Tracker
Key Highlights:
š Engineered: A dynamic Google Sheets logging system featuring interactive tickboxes, auto-stamped dates/times, and agent dropdown menus.
š Enforced: Strict compliance rules that prevent agents from backdating or logging missed entries for previous days, ensuring absolute data integrity.
š Automated: Seamless data pipeline feeding directly into a live summary dashboard with real-time charts and discrepancy tables.
šÆ Tracked: Corridor update frequencies, missed reporting windows, and individual agent compliance metrics.
š ļøļø Tools Used: Google Sheets Formulas, Data Validation, Automated Workflows, Performance Dashboards.
0
32
šø Streamlining Multi-Corridor Transaction & Reconciliation Trackers
Key Highlights:
šļø Built: Automated transaction difference auditors and discrepancy logs.
š Managed: Partner payout sheets and liquidity tracking systems.
š Audited: Multi-year financial data to minimize errors.
āļø Tools Used: Excel, Google Sheets, Automated Difference Tracking.
0
36