MIS Executive
Triveda Broking Pvt. Ltd. · Sep 2026 – Oct 2026
- Built a lead data cleaning and reporting workbook in Excel (Power Query, formulas, pivots) to replace manual lead tracking for a sales calling team.
- Tracked the lead funnel by person and by day (assignments, 1,100+ calls, 200+ visits, revisits) and built a dashboard showing unique %, calls, visits and visits per call.
- Improved data accuracy by standardising phone numbers and removing duplicates by phone and by company plus address.
- On 3,700+ collected leads, isolated 1,686 unique leads (45.5%) and flagged 131 invalid numbers for correction.
- Added about 20 automated data-quality checks that reconcile totals across reports, so numbers are verified before they are shared.
- Created a review workflow where manual Unique or Duplicate decisions are saved and re-applied on every refresh, plus a name-spelling map so each person's work is credited correctly.

