Summary
Overview
Work History
Education
Skills
Certification
Timeline
Languages
Generic

Pramod Pandey

Data Analyst and Reporting
New Delhi,DL

Summary

Experienced Financial and Data Analyst with over 14 years in cash collection, billing, business intelligence, and automation across telecom, banking, and technology industries. Strong expertise in AR collection, cash flow forecasting, Power BI, SQL, VBA automation, and process optimization. Demonstrated ability to drive efficiency, improve reporting accuracy, and support strategic business decisions.

Innovative technology professional with several years of diverse experience. Skilled in enhancing systems and aligning technical solutions with business objectives. Proven success in leading projects from start to finish and contributing to organizational growth and success.

Overview

16
16
years of professional experience
2008
2008
years of post-secondary education
1
1
Certificate
2
2
Languages

Work History

Cash Collection & Revenue Analyst

Ericsson Global
05.2022 - Current
  • Manage external customer collections & accounts receivables for APAC.
  • Forecast and monitor cash flow for assigned accounts.
  • Engage in AR financing including SOR and LC.
  • Prepare monthly customer statements and reconcile AP balances.
  • Follow up on due and overdue invoices, updating status in SAP.
  • Lead AR collection reviews and send monthly AR aging reports with commentary.
  • Identify and implement process improvements using data and technology tools.
  • Reconcile WHT, follow up on certificates, and clear WHT GL entries.
  • Monitor KPI performance and prepare data for monthly AR governance calls.

Billing & Reporting / Data Analyst

American Tower Corporation
10.2015 - 04.2022
  • Reconciled site-level consumption vs billing.
  • Handled monthly billing, invoice generation, and revenue accruals.
  • Conducted PnL analysis and collaborated on dispute resolution.
  • Drafted BRDs, performed UAT, and supported TOM design.
  • Ensured accuracy of revenue reports and implemented revenue leakage controls.
  • Maintained contract repositories and invoice trackers.
  • Reporting & Data Analytics:
  • Built dashboards using Power BI and DAX.
  • Connected, shaped, and transformed data from Excel and SQL Server.
  • Developed OLTP/OLAP data models and SSAS/SSRS reports.
  • Built ETL pipelines using SSIS and optimized large datasets.
  • Extracted and analysed data using SQL queries to aid business decisions.
  • Key Contributions:
  • Delivered 10+ automation projects.
  • Designed Excel templates with macros and consolidated vendor reconciliations.
  • Produced MIS reports for capex/opex liabilities and dispute resolution.

Analyst – Billing & Reconciliation

Bharti Airtel
09.2014 - 08.2015
  • Designed automation tools and Excel templates for reconciliation.
  • Reviewed vendor reconciliations from all circles.
  • Generated MIS reports for liabilities and reported to Treasury.
  • Managed disputes with vendors and ensured timely resolution.
  • Achievement:
  • Delivered 10 automation projects streamlining reconciliation and reporting.

Team Member – Reconciliation & Reporting

Bank of America
12.2010 - 09.2014
  • Reconciled trading-related balance sheet accounts.
  • Created daily MIS and exception reports.
  • Handled middle/back-office operations for securities, FX, and commodities.
  • Performed 3-way reconciliations and cash clearing.
  • Conducted variance analysis and discrepancy investigation.
  • Led collateral reconciliation and supported client data processes.
  • VBA & Process Automation:
  • Automated reports using VBA to reduce manual effort.
  • Designed interactive dashboards based on stakeholder needs.
  • Achievement:
  • Recognized for reducing manual tasks via legal entity and nostro reconciliation automation.
  • Awarded for GL Dump Formatting Tool, reducing 3-hour task to 10 minutes.

Process Associate – Insurance

Genpact
10.2009 - 11.2010
  • Handled customer retention and processed policy surrenders.
  • Explained policy benefits, charges, and ensured customer satisfaction.
  • Coordinated with Finance for payment processing.

Education

B.Com -

Kanpur University

MBA - undefined

Symbiosis International University

Skills

BI Tools: Power BI, SSRS, SSAS

Certification

Power BI – [Udemy]

Timeline

Cash Collection & Revenue Analyst

Ericsson Global
05.2022 - Current

Billing & Reporting / Data Analyst

American Tower Corporation
10.2015 - 04.2022

Analyst – Billing & Reconciliation

Bharti Airtel
09.2014 - 08.2015

Team Member – Reconciliation & Reporting

Bank of America
12.2010 - 09.2014

Process Associate – Insurance

Genpact
10.2009 - 11.2010

MBA - undefined

Symbiosis International University

B.Com -

Kanpur University

Languages

English
Bilingual or Proficient (C2)
Hindi
Bilingual or Proficient (C2)
Pramod PandeyData Analyst and Reporting