Experience

G

• Tobacco
• 1 - 100 Employee

• Export Manager

  • Jun 2019 - Present



Lemon Electronics Ltd.

• Greater Noida, India

• MIS Analyst

  • Nov 2017 - Present

   Generate and distribute management reports in accurate and timely manners;  Preparing and publishing Sales & Dispatch Report on daily basis;  Design reports based on Management requirements;  Preparing Dispatch planning report on daily basis;  Preparing & Publishing Warehouses and Manufacturing Units Stock Report on daily basis;  Preparing and publishing Field pendency report on daily basis;  Preparing Product FFR Report to identify quality improvement for increasing business efficiency and effectiveness;  Preparing monthly ASC (Area Service Centre) Service Claim Report;  Preparing & maintaining daily basis Primary and Secondary Dispatch and Delivery tracker.  Prepare PPT for monthly HOD Review meetings;  Automating excel reports using VBA in order to reduce time and efficiency;  Using CRM & ERP applications to fetch the raw data for the reports; Show less



Lava International Limited

• India
• Telecommunications
• 700 & Above Employee

• MIS Executive

  • Apr 2016 - Oct 2017

   Generate timely and accurate reports for analysis;  Create VBA Programme to automatically send Birthday Email on daily basis;  Create VBA Programme to manage hiring processing of Area Retail Officer’s (ARO’s);  Designed reports based on Business and Management requirements;  Creating MIS/Dashboard report and presenting it to the concern Departments and Management;  Managing the Monthly Employee Master, Exit and Transfer Reports Creating in MS-Excel through in depth analysis and producing the actionable information;  Extensive usages of VBA and MS-Excel (Aggregate function, V-lookup, H-lookup, Pivot tables, Pivot Charts, Index & Match, Advance filter, etc.); Show less



Bhairav Embro Designs Pvt Ltd

• Okhla

• MIS Executive

  • Aug 2013 - Mar 2016

   Prepare Monthly Performance Status Reports;  Prepare Daily Processing Reports;  Prepare Daily Dispatching Reports, Monthly Reports and Annually Reports ;  Prepare Dispatching Dashboard/Chart on Monthly basis;  Maintain all Reports in ERP Software as well as MS-Excel;  Reviewed History of current reporting;  Monitored implementation of MIS processes and evaluated their effectiveness;  Maintained and Updated all details of Orders;  Performed Trend Analysis of Data and Automation of Reports;  Prepared variance reports such as Forecast vs. Actual Sales; Show less



Effort BPO

• Delhi

• Collection Cordinator

  • Aug 2010 - Jul 2013

   Prepare Monthly Collection Reports of Cities Wise;  Prepare Daily Collection Reports of Cities wise on daily basis;  Prepare Collection Chart on Monthly basis;  Maintain the annexure (Payment) reports of cities wise on daily basis which are sending by all agencies ;  Resolved the queries of Customers at the time Field Collection through our collection agency;  Maintained and Updated all details of Customers on Software;  Prepare Monthly Collection Reports of Cities Wise;  Prepare Daily Collection Reports of Cities wise on daily basis;  Prepare Collection Chart on Monthly basis;  Maintain the annexure (Payment) reports of cities wise on daily basis which are sending by all agencies ;  Resolved the queries of Customers at the time Field Collection through our collection agency;  Maintained and Updated all details of Customers on Software;