Neeraj Agarwal
Summary
Attaining Professional Excellence through Smart Work and Commitment in corporate sector and contributing to growth of the organization.
Responsible for Analyze data received from circles, identify trends, insights & making better collection projections, Support the head collection in carrying out feasibility studies and cost benefit analysis by ways to reduce DSO, 180+ outstanding etc. Generate reports, develop dashboards and presentations. Follow up with circles and corporate sales & collection team for timely dispute resolution, Parameter correction in system as agreed with customer and ensure debit not reversal.
Overview
21
21
years of professional experience
Work History
Collection Manager & Analyst
ATC Telecom infrastructure Pvt Ltd.
09.2019 - Current
- Company Overview: India’s largest independent telecommunications infrastructure company engaged in the deployment and commissioning of telecommunication towers across India and enjoys strategic relationships with all leading telecom operators in India
- Responsible for Analyze data received from circles, identify trends, insights & making better collection projections, Support the head collection in carrying out feasibility studies and cost benefit analysis by ways to reduce DSO, 180+ outstanding etc
- Generate reports, develop dashboards and presentations
- Follow up with circles and corporate sales & collection team for timely dispute resolution, Parameter correction in system as agreed with customer and ensure debit not reversal
- Preparing annual collection targets and keeping track
- Manage DSO, 180+ outstanding & Billing vs Collection Ratio as per targets
- Prepare monthly collection performance including DSO movement, analysis of AR outstanding, commitment vs achievement etc
- Tracking of unapplied payment & CRN under approval
- Provide support to circle team to get CRN approved from corporate team
- Prepare detailed and intuitive management dashboards on key SLAs and targets across regions / circles
- Flashing dashboards weekly, monthly & alternate days bases
- Coordination with NAM / CAM, regional and circles team, gather data from them and analyze the same for collection purpose, arranging meeting & calls as per business requirement
- Close co-ordination with billing and finance teams internally for all AR reporting etc
- Collecting detail of billing issues from collection team, maintain tracker & resolve with IT & billing team with close coordination & follow up
- Identifying revenue leakage: ensure billing of exit penalty for the tenancies beyond permitted exit limit, billing of tenancies found in IP Vs PF billing RECO etc
- India’s largest independent telecommunications infrastructure company engaged in the deployment and commissioning of telecommunication towers across India and enjoys strategic relationships with all leading telecom operators in India
Deputy Manager
Mobile Commerce Solution Ltd.
08.2011 - 06.2013
- Company Overview: MCSL is 100% subsidiary of Vodafone India Ltd
- The Company is providing banking correspondent services and semi closed prepaid wallet (M-pesa) services to its customers
- Responsible for overall accounting of newly launched business with help of SSC
- Tracking of M-pesa system including e-money creation against money received, transactions accuracy, commission calculations of channel partners etc
- Handled overall accounting of newly launched business including payable, revenue, MIS, payroll, treasury, channel accounting etc
- With help of SSC
- Accounting and Reconciliation of receipts and e-money created with bank statements and other reports in M-pesa system
- Accounting for commission paid to channel as per M-pesa system and SAC calculation, accounting and disbursement as per business case
- Monthly expense accounting and provisions for each circle
- Coordinating with Bank for all bank related activity like various MIS from Bank, virtual account creation, internet banking, follow up for payment and signatory updating in bank record etc
- Preparation of schedules, ageing, reconciliation and variations for auditors and insure timely completion of audit
- Month end closing with circle wise provision of expenses and revenue and reporting with respect to corporate calendar, SSC Calendar, and SOX Compliance
- Monthly Schedule preparation & variance report submission
- Raise Invoices on Bank as per MOU and payment follow up
- MCSL is 100% subsidiary of Vodafone India Ltd
- The Company is providing banking correspondent services and semi closed prepaid wallet (M-pesa) services to its customers
Assistant Manager
Vodafone (UPE – Circle)
08.2006 - 07.2011
- Company Overview: Vodafone India ltd
- Is one of India’s leading private telecom service providers and offers integrated telecom solutions
- Two Major Profile Fixed Assets and IUC & roaming were handled during the tenure
- Responsible for collection of inter uses & Roaming charges from other opco & government body like BSNL/MTNL
- Responsible for capex accounting, depreciation calculation, asset impairment, tracking and updating assets movement, timely CWIP utilization etc
- Responsible for Interconnect Bill reconciliation with Intec report
- Monitoring IUC invoicing on BSNL & Private operators
- Insure of timely billing with accuracy
- Verification of invoices raised by other operators with Intec report and CDRs (Outgoing) and with Tap In and Tap Out reports in case of roamers
- Monthly collection of IUC from BSNL & Roaming Dues from all roaming operators/Clearing house
- Coordination for AGR Audit and Filling AGR audit report with DOT
- Submission of proof of IUC & roaming cost to DOT
- Maintaining of Fixed Assets Register
- Site wise capitalization of MSC, BSC and BTS sites including OFC route and other Misc
- Fixed assets on monthly basis
- Calculation of depreciation on monthly basis
- Reconciliation of Material lying at various sites and warehouses with books
- Coordinating with Physical verification team to reconcile the network equipment lying at sites and other assets lying at office premises with FAR
- Preparing various management information reports as CWIP ageing report, Depreciation analytical, Lead schedule, backbone laying detail and other report as & when desired
- Reconciliation of sites FAR Vs Network on quarterly basis and updating the FAR accordingly
- Tracking of all purchase Orders against budget and requisitions approved from corporate hence ensuring that the PO's do not exceed the approved Capex value
- Vodafone India ltd
- Is one of India’s leading private telecom service providers and offers integrated telecom solutions
Officer
HFCL Infotel Ltd.
04.2006 - 07.2006
- Company Overview: The company was providing landline services in the mentioned period in PAN Punjab
- Maintenance of Fixed Assets Register of the company
- Capitalization on a monthly basis including network equipment, OFC & Copper laying and other fixed assets with calculation of depreciation
- Preparation of FA Schedule for Balance sheet and coordinating with statutory and internal auditors
- Checking in insurance adequacy of fixed assets, coordinating periodical physical verification and reconciliation of fixed assets and material lying at various sites and warehouses with books
- The company was providing landline services in the mentioned period in PAN Punjab
Team Leader of Fixed Management Team
Mynd Solution Pvt Ltd.
04.2004 - 03.2006
- Company Overview: The company is a top player in the BPO/KPO and offer finance & account and HR solutions to its customer
- Handled Fixed Asset Register at HFCL Infotel Ltd., Mohali
- Periodical preparation of Internal Audit Reports, Physical verification report and insurance adequacy report etc
- The company is a top player in the BPO/KPO and offer finance & account and HR solutions to its customer
Education
M.Com. -
Agra University
01.2002
B.Com. -
Agra University
01.2000
Skills
- B2B collection
- Finance
- Accounts
- Taxation
- Risk Analysis
- Analytical ability
- Problem anticipation
- Cost effective solutions
- Business relationship management
- MS Office
- ERP systems
- SAP
- ORACLE
Personal Information
- Father's Name: Kunj Bihari Agarwal
- Date of Birth: 05/24/78
- Marital Status: Married
Timeline
Collection Manager & Analyst
ATC Telecom infrastructure Pvt Ltd.
09.2019 - Current
Deputy Manager
Mobile Commerce Solution Ltd.
08.2011 - 06.2013
Assistant Manager
Vodafone (UPE – Circle)
08.2006 - 07.2011
Officer
HFCL Infotel Ltd.
04.2006 - 07.2006
Team Leader of Fixed Management Team
Mynd Solution Pvt Ltd.
04.2004 - 03.2006
M.Com. -
Agra University
B.Com. -
Agra University
Similar Profiles
SANJIV BHADARISANJIV BHADARI
Manager – Corporate Collections at ATC Telecom Infrastructure Pvt. LtdManager – Corporate Collections at ATC Telecom Infrastructure Pvt. Ltd
Kumaravel NKumaravel N
Manager - Estate Management & Compliance Incharge at ATC Telecom Infrastructure Pvt LtdManager - Estate Management & Compliance Incharge at ATC Telecom Infrastructure Pvt Ltd
Khoob Chand GoswamiKhoob Chand Goswami
Collection Account Manager at ATC Telecom Infrastructure Pvt LtdCollection Account Manager at ATC Telecom Infrastructure Pvt Ltd