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
ETL Tools: SSIS
Languages: SQL, VBA (Macros)
Databases: SQL Server, Oracle
ERP Systems: SAP
Other Tools: Excel (Advanced), DAX, OLAP/OLTP concepts
Advanced Excel
Sales analysis
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)