Ranjit Kumar

Experience

• 

  DHFL Pramerica Life Insurance

  Mar 2008 - May 2012

  Sr. executive

   PIS generation through bulk upload: Responsible to generate the PIS which comes from the different payment options PPG Compliance- Monitoring all kinds of transactions and the documentation as per the programs & policies. Revival of the policy: Responsible to revive the policy into the system as per the program policy guidelines. MIS analysis of functional data (Daily, Monthly, Yearly). Renewal Dashboard for Management Monthly sales reporting analysis by product and category - highlighting variances for the month and the year to date viz. Channel collection & Variance Analysis Incentive calculation & Monitoring the performance of Renewal collection employee Co-coordinating the various R&R activities for the Zone and Head office. Responsible for submission of vendor billing for timely payout to the vendor Show less

• 

  Campuseai Consortium Private Limited.

  Jun 2014 - May 2017

  Data Analyst

   ⮚ Responsible to generate various reports for client using SQL queries, Stored procedure& Function.⮚ Responsible to visualize the report by using BI tool like Power BI.⮚ Data mining using advance excel formulas.⮚ Responsible to generate report for the management.⮚ Responsible for generating various reports for clients.⮚ Responsible for the others day-to-day reports⮚ Coordination with the finance team for revenue and expense analysis for the department.

• 

  Tiger logistics (India) Ltd.

  Dec 2017 - Jun 2020

  Data Analyst

   MIS Preparation & Reporting. Annual budgeting and variance Analysis. Responsible for Biometric based attendance management for employee. Attrition analysis. Various Daily, weekly, monthly and yearly dashboard reports Quarterly Financial Reporting. Financial Analysis to provide business Insights to Management. Incentive calculation &monitoring the performance of Sales employees Reporting to Managing director and chairman of the company.

• 

  BPTP Ltd.

  Sept 2020 - now

  Assistant Manager

   Managed project activities by tracking monthly costs on a project-wise basis, ensuring effective cost control. Generated and released monthly payment and work done reports, detailing project-wise and vendor-wise cost allocations. Tracked work done and payments on a vendor and work order basis. Payment released reports correspondent to cost incurred project wise and vendor wise monthly. Preparing various management reports like Demand and collection reports. SR reports, OOP etc. Incentive calculation for collection/broker/sales team. Responsible for the preparation of MIS and maintaining database. Timeline and accuracy in preparation of MIS as required by Management. Responsible to prepare accurate reports for Regulatory authority on time. Preparation of the Project Budget with the coordination from the Projects team. Preparation and analysing variance between budgeted and actual. Responsible for preparing variance analysis of monthly sales target and actual for sales team. Responsible to prepare Open and Closed BPTP SR Report for CRM team. Responsible to track the inventory status across the projects. Responsible to prepare various other ad hoc reports when required by the management. Responsible for maintaining Handing over status of units in SAP for all projects. Knowledge of Managing all post sales activities that includes verification of rates for respecting bookings as per the deal offered, generating welcome letters, MOU and agreement, Allotment letters, demand etc Show less