Working as a Deputy Manager - MIS in Sales & Distribution Department. I am coordinating with Pan India Region with KAM, RSM, ASM & Sales officer of Sales Departments (General Trade & Modern Trade) regarding for Data/Queries.Job Profile:- Maintaining MIS & Performance for Pan India on Daily, Weekly & Monthly basics:-1 Maintaining Dashboard for Target Vs. Achievement (LMTD Vs. MTD) for Primary, Secondary on Daily, Weekly & Monthly basics – Source ERP & Botree - MIS… Show more Working as a Deputy Manager - MIS in Sales & Distribution Department. I am coordinating with Pan India Region with KAM, RSM, ASM & Sales officer of Sales Departments (General Trade & Modern Trade) regarding for Data/Queries.Job Profile:- Maintaining MIS & Performance for Pan India on Daily, Weekly & Monthly basics:-1 Maintaining Dashboard for Target Vs. Achievement (LMTD Vs. MTD) for Primary, Secondary on Daily, Weekly & Monthly basics – Source ERP & Botree - MIS dashboards to be given to Sales Head, CSMO, TMM and RSM’s /ASM’s.2 Preparing MIS Dashboard for CSMO (Head) on Daily / Weekly & Monthly Review data.3 Preparing data inputs for AOP TGT process for Brands, Product, Super Distributor, SUB Distributor & Employee (General Trade & Modern Trade) wise sales targets and targeting for next year - Yearly.4 Preparation, collation and publishing of MIS Dashboards for NPD Launches – Daily, Weekly & Monthly.5 SUB DB wise Closing Stock Statement (SSS) for Pan India Dashboard on Monthly basics.6 Preparation Forecast for Firm & Rolling every month on 20th Day and given to Management & Supply Chain Division (Compare with Last 2 Year and Current AOP TGT) – Monthly.7 Preparation for Monthly & Quarterly Incentive for Super Distributor / SUB Distributor / General Trade FF Employee (RSM’s, ASM’s & BE’s) & Modern Trade FF Employee (KAM’s, ASM’s & BE’s) 8 Prepared KPI Annual Performance data for Pan India Employee for Sr. GM, KAM, RSM’s, ASM’s & BE’s (Quarterly & Half Yearly Performance Review).9 Maintaining PPT for Sales & Distribution Monthly review.10 Adhoc Report as per requirement: - Compilation of SSS, Employee & Stockiest Mapping in Botree. Show less

Worked as a Project Manager - Data Acquisition and Coordinating with Pan India Region with 6 Regional Manager, 60 Data Auditor and 2 Backend Support (reporting to me) regarding for Data Collection Submission /Queries of Client (GFK). Job Profile: -Maintaining MIS & Performance for Pan India on Daily, Weekly & Monthly basics:- 1) Maintaining Dashboard for Store collection data wise Target Vs Achievement on Daily, Weekly & Monthly basics. 2) Maintaining Dashboard… Show more Worked as a Project Manager - Data Acquisition and Coordinating with Pan India Region with 6 Regional Manager, 60 Data Auditor and 2 Backend Support (reporting to me) regarding for Data Collection Submission /Queries of Client (GFK). Job Profile: -Maintaining MIS & Performance for Pan India on Daily, Weekly & Monthly basics:- 1) Maintaining Dashboard for Store collection data wise Target Vs Achievement on Daily, Weekly & Monthly basics. 2) Maintaining Dashboard for IA Store (New Store) recruitment wise Target Vs Achievement on Daily, Weekly & Monthly Basics.3) Manage the field team of 50+ FOS & 6 Regional Manager PAN India for data collection activities to client specification and ensure timely data submissions to client (GFK).4) Daily tracking of field team as per PJP and Manage field PJPs and reports, including roster and field check reports, end to end.5) Briefings to Field Team regarding client requirements around data collection and quality processes.6) Preparing Data analysis (MIS) and drafting story-driven client facing reports for senior review and evaluate data quality for client submissions.7) Define and oversee Quality processes for collected data8) Evaluate audit and auditor quality via regular field visits and timely completion9) Adhoc Report as per requirement: - Compilation of New Store recruitment, Employee & Store Mapping in Application, Store allocation to Team and etc as per requirement of organization. Show less

Ø Himalaya Drug Company. (Regional Office - Kaushambi) – Pharmaceutical Co. Feb’2020 - Till DateOn Company Payroll.Worked as an Manager - MIS Team Lead in Wellness Zindel Key Account Sales Department. Coordinating with Pan India with SM, NKAM, ZM, RM, ASE & Sales officer of Wellness Sales Departments regarding for Data/Queries.Job profile:- Maintaining MIS & Performance for Pan India (General Trade, Modern Trade, Canteen Store Department, Pharma & Fitnesses… Show more Ø Himalaya Drug Company. (Regional Office - Kaushambi) – Pharmaceutical Co. Feb’2020 - Till DateOn Company Payroll.Worked as an Manager - MIS Team Lead in Wellness Zindel Key Account Sales Department. Coordinating with Pan India with SM, NKAM, ZM, RM, ASE & Sales officer of Wellness Sales Departments regarding for Data/Queries.Job profile:- Maintaining MIS & Performance for Pan India (General Trade, Modern Trade, Canteen Store Department, Pharma & Fitnesses Department) on Daily, Weekly & Monthly basics:-1) Maintaining Dashboard for Target Vs. Achievement (LMTD Vs. MTD) for Primary on Daily, Weekly & Monthly basics – Source SAP.2) DCR report Pan India wise GT, MT, CSD, Pharma & Fitness Department on Daily & Monthly basics - Source Ethos.4) Employee Expenses & Reimbursement report for validation Hardcopy & Soft-copy on Monthly basics - Source Ethos.5) Employee wise Annual Target validation and update in System on Annually - Source SAP.6) Adhoc Report as per requirement: - Scheme/ Forecast/ Claim / Stockiest NOC/ Associate user ID & Password, Active or Deactivate In Ethos. Show less

Ø Hamdard Laboratory India. (Asaf Ali Road-New Delhi) – FMCG Co. & Pharma Sept'2015 - Till DateOn Company Payroll.Worked as an Asst. Manager - MIS in Sales & Marketing Department. Coordinating with Pan India Region with RSM, SH, ASM & Sales officer of Sales Departments regarding for Data/Queries.Job profile:- Maintaining MIS & Performance for Pan India on Daily, Weekly & Monthly basics:-1) Maintaining Dashboard for H1 & H2 wise Target Vs. Achievement (LMTD Vs… Show more Ø Hamdard Laboratory India. (Asaf Ali Road-New Delhi) – FMCG Co. & Pharma Sept'2015 - Till DateOn Company Payroll.Worked as an Asst. Manager - MIS in Sales & Marketing Department. Coordinating with Pan India Region with RSM, SH, ASM & Sales officer of Sales Departments regarding for Data/Queries.Job profile:- Maintaining MIS & Performance for Pan India on Daily, Weekly & Monthly basics:-1) Maintaining Dashboard for H1 & H2 wise Target Vs. Achievement (LMTD Vs. MTD) for Primary, Aaghaz, Secondary on Daily, Weekly & Monthly basics – Source ERP.2) Duniya-e-Hamdard (DEH) & Product wise Secondary dashboard on Daily & Monthly basics3) Log sheet Productivity, Sales & Stock Statement (SSS) & Control Stock Statement for H1 & H2 Division Dashboard on Monthly basics.4) Prepared Annual Performance data for Pan India Employee & Field Force Incentive (Quarterly & Half Yearly Performance Review).5) Field Assist Project for Secondary Sales / Retailing / Retails Outlets / Beat Mapping / Employee Mapping & Attendance and tracking there performance on Daily, Weekly & Monthly basics6) Maintaining PPT for Sales & Distribution Monthly review.7) Adhoc Report as per requirement: - Compilation of SSS, Aaghaz Undertaking, TM Bonanza Phase – 1 & 2, Employee & Stockiest Mapping in web portal. Show less

Ø Beetel Teletech Ltd. (Gurgaon) – Handset Co. March'2015 - Aug'2015On Company Payroll.Worked as Senior MIS Executive & Coordinator in Sales & Distribution Department. I am coordinating with North India Region with RSM, ASM & Sales officer (15) of Sales Departments regarding for Data/Queries.Job profile:- Maintaining MIS & Performance for North India on Daily, Weekly & Monthly basics:-1) Maintaining Dashboard for Model & Employee wise Target Vs Achievement (LMTD… Show more Ø Beetel Teletech Ltd. (Gurgaon) – Handset Co. March'2015 - Aug'2015On Company Payroll.Worked as Senior MIS Executive & Coordinator in Sales & Distribution Department. I am coordinating with North India Region with RSM, ASM & Sales officer (15) of Sales Departments regarding for Data/Queries.Job profile:- Maintaining MIS & Performance for North India on Daily, Weekly & Monthly basics:-1) Maintaining Dashboard for Model & Employee wise Target Vs Achievement (LMTD Vs MTD) for Primary, Secondary & Tertiary on Daily, Weekly & Monthly basics – Source SAP.2) Tracking Model wise Tertiary dashboard on Daily, Weekly & Monthly basics3) Tracking Closing Stock from Ware-house, Super Distributor, Distributor & Dealer Management System (DMS) for inventory & Sales Tracking on Weekly & Monthly basics.4) Maintaining PPT for Sales & Distribution Monthly.5) Adhoc Report as per requirement: - Distributor Registration & Bank Guarantee Validation from legal & finance and then processes to create their code in system, Material stock dispatch tracking with Logistic & Employee Monthly Claim and etc. Show less

Ø Magicon Impex Pvt Ltd. (Ramesh Nagar) – Handset Co. April' 2013 - March'2015On Company Payroll.Worked as a Sales MIS Executive & Coordinator in Sales & Distribution Department. I am coordinating with PAN India National Sales Head, Region Head, State Head, TSM, ASM & States Coordinator (23) of Sales Departments regarding for Data/Queries.Job profile:- Maintaining MIS & Performance for PAN India on Daily, Weekly & Monthly basics:-1. Tracking Primary, Secondary &… Show more Ø Magicon Impex Pvt Ltd. (Ramesh Nagar) – Handset Co. April' 2013 - March'2015On Company Payroll.Worked as a Sales MIS Executive & Coordinator in Sales & Distribution Department. I am coordinating with PAN India National Sales Head, Region Head, State Head, TSM, ASM & States Coordinator (23) of Sales Departments regarding for Data/Queries.Job profile:- Maintaining MIS & Performance for PAN India on Daily, Weekly & Monthly basics:-1. Tracking Primary, Secondary & Tertiary for Supper Distributor Daily, Weekly & Monthly basics. 2. Tracking Supper Distributor billing to Distributor Monthly Basics.3. Maintaining PPT for Sales & Distribution Monthly.4. Collecting data form State Head for Primary, Secondary, Collection & Handset for Achievement & Plan on Daily basis.5. Tracking Tertiary dashboard of Network Operator Daily weekly & Monthly basics6. Tracking Model wise Primary billing for Super Distributor – Daily, Weekly & Monthly basics.7. Maintaining Target Vs Achievement for Primary, Secondary, Tertiary, New Outlet & Distributor performance every Monthly.8. Tracking New Distributors and New Retailers outlet every weekly. Show less

Ø Aircel Limited. (Gurgaon) – Prepaid Base (Feb 2011 – Mar 2013)Payroll of Adecco Flexione.Working as a Sales MIS Coordinator in Sales & Distribution of all Aircel Circle PAN India. I am coordinating with PAN India Sales Coordinator (23) their Reporting Manager and Assistant Manager, Manager, DGM, Circle Business Head & Circle Sale Head of Sales Departments regarding for Data/Queries.Job profile:- Maintaining MIS & Performance for PAN India on Daily, Weekly & Monthly… Show more Ø Aircel Limited. (Gurgaon) – Prepaid Base (Feb 2011 – Mar 2013)Payroll of Adecco Flexione.Working as a Sales MIS Coordinator in Sales & Distribution of all Aircel Circle PAN India. I am coordinating with PAN India Sales Coordinator (23) their Reporting Manager and Assistant Manager, Manager, DGM, Circle Business Head & Circle Sale Head of Sales Departments regarding for Data/Queries.Job profile:- Maintaining MIS & Performance for PAN India on Daily, Weekly & Monthly basics:- Tracking Modern Trade performance on Activation, Revenue, T2M DREC% on Daily, Weekly & Monthly basics.  Creating, Error and Deleting Pan India Employee ID for Distributor & Retailers in SAP Maintaining PPT for Base Transceiver Station (BTS) LUT Utilization Performance for PAN India on monthly. Collecting data for Network Team for Busy Bouncing Hours (BBH) Traffic Trend on Monthly. Tracking BTS Performance on Activation, Tertiary and Revenue on Monthly basics Collecting data for New APP, Modern Trade & Sales Coordination Matrix updated List on Monthly. Maintaining Target Vs Achievement for R&R & SIP performance every Quarter. Maintaining MIS for Subscriber Base, Activation, Tertiary (Etops & Paper) and DREC on Daily, Weekly & Monthly. Maintaining Retailers wise BTS Sites ID performance on Activation, Tertiary and Revenue on Monthly Show less

Ø Reliance Communication Ltd. (Noida) Prepaid - Postpaid (Nov 2009 To Feb 2011)Payroll of Varnsave Infotech Pvt Ltd.Worked as a MIS Executive in Operations of Reliance Communication Retention Outbound Process for Delhi & NCR Area.I am responsible to handle Queries / Data from – 15 Team Members.Job profile:- Maintaining MIS & Performance for Delhi & NCR Area on Daily, Weekly & Monthly basics:- Data Allocation to Team members (Vol Churn & Migration and… Show more Ø Reliance Communication Ltd. (Noida) Prepaid - Postpaid (Nov 2009 To Feb 2011)Payroll of Varnsave Infotech Pvt Ltd.Worked as a MIS Executive in Operations of Reliance Communication Retention Outbound Process for Delhi & NCR Area.I am responsible to handle Queries / Data from – 15 Team Members.Job profile:- Maintaining MIS & Performance for Delhi & NCR Area on Daily, Weekly & Monthly basics:- Data Allocation to Team members (Vol Churn & Migration and In-circle Data) Vol Churn & Migration Performance Dashboard,  Dashboard for High ARPU Customer, Bulk SR and SR Trend,  Agent Performance for Telecaller and Field Executive,  Dashboard for FTR & Reliance World (Cluster, Location and RW wise),  Projection for the Month,  Day wise Performance for Vol Churn, Migration & Field,  Retention Efficiency Dashboard (Cluster, Product, AON, Segment Wise performance). Show less

Ø Bharti Airtel LTD. (Gurgaon) - Postpaid July 2007 to Oct 2009 Payroll of Kouchan Knowledge Convergence (P) Ltd.Worked as a CSD Zonal Coordinator & Data Analysis of all Airtel Relationship Centre at Delhi & NCR Area. I am responsible to handle Queries / Data from:- Assistant Managers Retail Experience (13), Showroom Manager (44) & Backend Office & CRO (7).Job profile:-  Coordinating with Assistant Manager, Showroom Manager, Backend officer… Show more Ø Bharti Airtel LTD. (Gurgaon) - Postpaid July 2007 to Oct 2009 Payroll of Kouchan Knowledge Convergence (P) Ltd.Worked as a CSD Zonal Coordinator & Data Analysis of all Airtel Relationship Centre at Delhi & NCR Area. I am responsible to handle Queries / Data from:- Assistant Managers Retail Experience (13), Showroom Manager (44) & Backend Office & CRO (7).Job profile:-  Coordinating with Assistant Manager, Showroom Manager, Backend officer, Mobility & Other Departments. Customer Handling to resolving there query and problem at frontend. To help Team members in solving their problems that they are facing with Data, Collection or etc. Data Allocation to Assistant Manager (PTP Failure, Barring Data & DL wise NC unpaid Data) Maintaining MIS & Performance for all Delhi & NCR Area like Retention, Payment Collection, Wrap-up capture, Manpower, Finance, Baddebt and other Dashboard on Daily, Weekly and Monthly basics performance. Show less

Ø Bharti Airtel LTD. (Okhla Ph-1) – Postpaid May 2006 to June 2007Payroll of Orion Dialog & AEGIS BPO Ltd. Worked as a Retention, Collection & Taking care of all Airtel Relationship Centre at South Delhi. I am responsible to handle Queries / Data from all 20 Airtel Relationship Outlet & 2 Collection Agency at South Delhi.Job profile:-  Coordinating with ARC’s, Agency & other Departments to ensure proactive retentions & Collection. Reducing churn… Show more Ø Bharti Airtel LTD. (Okhla Ph-1) – Postpaid May 2006 to June 2007Payroll of Orion Dialog & AEGIS BPO Ltd. Worked as a Retention, Collection & Taking care of all Airtel Relationship Centre at South Delhi. I am responsible to handle Queries / Data from all 20 Airtel Relationship Outlet & 2 Collection Agency at South Delhi.Job profile:-  Coordinating with ARC’s, Agency & other Departments to ensure proactive retentions & Collection. Reducing churn Voluntary & Involuntary and Collection Baddebt.  Introduction of New Retention plan and taking care of relocation process. Resolving Sales and dealers wrong commitment. To help Team members in solving their problems that they are facing with product and services. Identifying reasons responsible for customer dissatisfaction & churn and taking necessary actions to eliminate them. Data Allocation to ARC's (Winback, Misc Prebar, Misc Preda, PTP Failure & DL wise NC unpaid Data). Maintaining MIS for Retention & Collection. Show less

Ø Bharti Airtel LTD. (Okhla Ph-3) – Postpaid Oct 2004 to April 2006Payroll of Solutions Integrated Marketing Service Pvt. Ltd Worked as a Asst. Team Leader AIRTEL at Retention Dept. (Airtel Outbound Process).I am responsible to handle Queries / Data from – 30 Team Members.Job profile:-  Resolving Sales and dealers wrong commitment. To help Team members in solving their problems that they are facing with product and services. Identifying reasons… Show more Ø Bharti Airtel LTD. (Okhla Ph-3) – Postpaid Oct 2004 to April 2006Payroll of Solutions Integrated Marketing Service Pvt. Ltd Worked as a Asst. Team Leader AIRTEL at Retention Dept. (Airtel Outbound Process).I am responsible to handle Queries / Data from – 30 Team Members.Job profile:-  Resolving Sales and dealers wrong commitment. To help Team members in solving their problems that they are facing with product and services. Identifying reasons responsible for customer dissatisfaction & churn and taking necessary actions to eliminate them. Data Allocation to Team members (Winback, Misc Prebar, Misc Preda, PTP Failure & DL wise NC unpaid Data). Maintaining MIS for Retention & Collection. Show less