Tanmay Bhatnagar

Experience

• 

  Attar Logistics Pvt. Ltd.

  Oct 2023 - Jan 2024

  MIS Operator

  A Logistics firm specializing in Warehousing and Logistics Management with a strong presence in North India since 1966 with 250+ employees & 2700 Cr in Annual Business Volume.As an MIS Operator, I was responsible for the complete spectrum of Data Entry Operations pertaining to the Great-White Electricals Depot. Tasked with ensuring timely delivery of Electrical Goods to the dealers by establishing cross - communication between various transporters & dealer touch points.- MIS/Reporting: Successfully Maintained & Updated a Large Data Set of Records pertaining to the depot’s inbound & outbound inventory on MS Excel & clubbing this data with detailed information of Logistics Partners/Transporters.- Automating & Optimizing: Used my analytical & logical reasoning skills to make advanced formulas in MS Excel (using functions like INDEX - MATCH, V-Lookup, IF/AND/OR Conditions) which resulted in ~85% automation on daily data entry tasks on MS Excel & finishing daily task in 2.5 hours instead of 7 hours. Show less

• 

  Passion Gaming

  Jan 2024 - Mar 2024

  Management Information System Executive

  An Innovative Online Gaming firm with 90+ employees, and 10M + Players Across India with 12M + App Downloads.- As an MIS Executive, I am responsible for Accurately Maintaining Datasets, Generating Daily/Weekly/Monthly/Ad-Hoc Reports, Distributing the Organized Data to concerned team members & presenting the findings to the upper management in a Clear & Concise Manner. - MIS/Reporting: Made Weekly Reports identifying top revenue generating players for the company using a 3 - Step process of fetching/importing data from Tableau, Analyzing the Raw Data using Advanced Excel Formulas (using INDEX - MATCH, V/X-Lookup, IF/AND/OR Conditions) & presenting the findings Aesthetically on Google Sheets.- Automating & Optimizing Tasks: Successfully established links/inter-connected Google Sheets of multiple departments using IMPORT-RANGE Function & FILTER Criteria thereby eliminating the need for manual data entry & saving multiple hours of unproductive time loss resulting in faster & more efficient outcomes. Additionally created MACROS on EXCEL for various daily repetitive tasks thereby further increasing efficiency & time management. Show less

• 

  CRED

  Apr 2024 - now

  ⭐**KEY ACHIEVEMENTS AT CRED** 🔹 Automated FLDG Credit Loss TrackingDesigned and implemented a dynamic dashboard model (based on NPA Mathematics) to monitor Net Critical POS, resolved accounts, and expected loss — directly impacting credit risk mitigation and P&L.🔹 SMA Portfolio Analytics SystemLed end-to-end automation (using Python) and analysis of SMA (Special Mention Accounts) for Newtap (NBFC acquired by CRED). Developed location-based allocation logic, flagged risky multi-loan users, and introduced payment behavior-based focus tagging.🔹 Streamlined Recovery Performance DashboardsBuilt Tableau dashboards and automation tools to surface key recovery metrics, enabling data-driven decisions on collection agency performance and accountability.🔹 BNPL Collections Monitoring DashboardBuilt a comprehensive ‘Buy Now - Pay Later’ Delinquency Dashboard on Tableau, consolidating data from multiple sources. Delivered real-time visibility and actionable intelligence for all stakeholders.🔹 Real-Time Collections Performance TrackingCreated a dashboard to track 25+ agencies pan-India across all Lending Partners. Included RazorPay payment logic (with 24–48 hr delays) to ensure accurate same-day recovery % tracking. Enabled Collections Head to monitor agency performance and drive month-end interventions.🔹 India-Wide Manpower Planning LogicBuilt a SQL-based framework to analyze agent-level allocation across risk buckets and lenders, driving FY25–26 hiring & resource strategies.🔹 High-Risk Non-Contactable User ClassificationUsed SQL to analyze field visit logs and resolution data, enabling strategic offloading of unserviceable portfolios at the pincode level.🔹 BNPL Incentive & Rewards Data AutomationOwned end-to-end calculation of agency and agent-level incentives based on POS and bucket-wise performance. Created plug-and-play templates for monthly and campaign-based (Sep–Dec) payouts of ₹3–5 lakhs — a high-stakes, leadership-trusted automation. Show less 🔹 Field Ops Intelligence SuiteBuilt a two-part field operations toolkit:“Expected Outcome Summary” Dashboard covering ₹150+ Lakhs in collectable dues across 750+ overdue usersMonthly Tracker for Non-Contactable Users to identify follow-up gaps and sharpen on-ground execution🔹 BNPL Incentive & Rewards Data AutomationOwned end-to-end calculation of agency and agent-level incentives for BNPL recovery across India. Built plug-and-play templates to automate monthly and Sep–Dec campaign-based payouts. This high-stakes system disbursed ₹3–5 Lakhs/month and was fully managed by me.🔹 Automated Vendor Billing Dashboard (Retool)Eliminated manual invoice processing for 25+ collection agencies. Integrated SQL rules to auto-calculate payouts, bonuses, and incentives — a leadership-trusted solution that became a benchmark for cost/time efficiency.🔹 Daily Data Sync Automation (Google Apps Script)Streamlined spreadsheet updates for 50+ agencies, reducing manual effort by 75% and significantly boosting efficiency and accuracy.🔹 File Upload Automation (Python + Chromedriver)Automated the upload of 70+ files to vendor platforms, eliminating manual work and improving accuracy and speed of file handling.🔹 India-Wide Manpower Planning LogicBuilt a SQL-based framework to analyze agent-level allocation across risk buckets and lenders, driving FY25–26 hiring and resource distribution strategy. Show less

  • Data Analyst [Collections & Recovery]

    Aug 2024 - now

  • MIS Analyst [Collections & Recovery]

    Apr 2024 - Aug 2024