Tanmay Bhatnagar Email & Phone Number

Bengaluru, Karnataka, India

Bengaluru, Karnataka, India

Panchkula, Haryana, India

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.

Sahibzada Ajit Singh Nagar, Punjab, India

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.