Maninder Rattan
Email: -
Mobile: -
Professional Synopsis
Business Analyst (FP&A) profile in Tata Teleservices Ltd. (Nov'10 to Jun'18) and in Virgin Mobile India Ltd. (Jan'09 to Sep'10).
MIS Co Ordinator in Idea Cellular Ltd. & Bharti Airtel Ltd.
Core Strengths
Very good command over Database management & Backend working tools (MS Access, SQL, MS Excel, etc) and front end reporting & Presentation tools (MS Power Point, Dashboard and Reporting in MS Excel). These are some basic tools to manage and work on the huge raw data to make it in summarized form that can easily be analysed.
Special Assignments & Rewards
In addition of my routine activities some special projects having been assigned to me by top management and post successful completion I having been rewarded many a times:
Surrendering of Non Profitable POIs with BSNL: this special project Im working with Corp Network strategy and services team, we identify non profitable low utilization POIs for surrender that further helping in saving big amount, post successful completion of Phase 1/2/3 I having been rewarded as Star Performer award in 2014-15.
Automation of Business KPIs: having worked with IT team to automate various Business KPIs like Gross Adds, Churn, EOP Base, REC Base calculation, Revenue calculation, Quality of Acquisition analysis in M2, M4 & M6 buckets, Base Decay analysis etc in SAP and BI Cognos applications.
Having automated the Credit Limit Updation process on various criterias like
Pre AV/CV.
Post AV/CV.
Category Basis.
Usage and payment history basis.
The Career Graph with Noteworthy Contributions
Present Assignment
Tata Teleservices Ltd. Business Analyst (Nov’10 to Jun'18)
Handling FP&A Mobility (Corporate Office)
Handling ICR Reporting and periodic site wise analysis, preparation, analysis and reporting Weekly and Monthly basis.
Weekly Report on GET Product (Get Easy Talk time), tracking and analysis of Daily Impression Viewed, Daily Downloads, Daily Registrations, Revenue generated through impression burning of Active Campaigns.
Monthly Profitability on NVS Products (Vehicle Tracking, GET, E-Learning).
Monthly Reporting of Non Financial Business KPIs (Gross Activation, Churn, EOP Base, REC Base, REC%, Postpay Revenue Calculation, ER, ARPU Sub Base, ARPU REC Base, etc):
Monthly Trend Analysis.
Achievement over AOP.
Benchmarking with Compotators.
SAP Vs MIS - Reconciliation & GAP analysis.
SAP Vs RMS (Front End Retail Application) - GAP analysis.
Monthly analysis on Quality of Acquisition (Postpay Business) and month on month decreasing base analysis in various age buckets M2/M4/M6 etc.
Stores Profitability & P&L presentation to BU teams on monthly CCM. Financials to be concurred by BU team. Finance to make effective Presentation in CCM.
Computation of channel commission for Retail Segment channel partners
Preparation of Data Business health check & periodic reviews.
Past Assignment
Virgin Mobile India (Jan’09 to Oct’10)
Handling Financials Planning & Analysis, Revenue & Subscriber KPI Reporting, Benchmarking to competition & Trend Analysis.
Responsible for analysis of revenue and subscribers KPI, ER, RPM, ARPU, tracking leg wise trends of Minutes of Usages (MOUs), Performance monitoring against AOP (Annual Operating Plan).
Monthly Circle Profitability reporting and trend analysis, also the performance monitoring against AOP.
Monthly revenue & subscriber KPI benchmarking comparative to competition.
Weekly report on Quality of Acquisition analysis and Base decay analysis preparation and reporting.
Sales order processing
Timely supplies and correct accounting for Sale of Items like E Recharge.
Ensuring of dispatch of monthly statement of accounts and invoices of purchases of channel partners
Special Assignments
Worked with IT team for automation of the various Non Financial KPIs.
Past Assignment
Idea Cellular Ltd. (Nov’07 to Jan09)
Collection / Retention MIS Reporting, Channel Analysis and Handling the 3 My Idea Showroom.
Daily, Weekly, Fortnightly & Monthly Gross Adds, Churn, Revenue, Collection reporting.
Monitoring of AV/CV process, Monthly Bill Dispatch reports, and analysis of failure cases with the Welcome letter Data Base.
Daily Usage monitoring and prepare daily barring and TSP reports.
Monthly Collection bucket movement monitoring and reporting.
Monthly Finalisation of Bad Debt with Finance team and reporting.
Periodic Retention MIS and analysis of voluntary churn case.
Monthly Channel wise analysis report to analyse the highlight the channels that are major contributors of Churn & Bad Debt.
Daily and Monthly Store wise Gross Adds, Churn, Revenue, Collection reports.
Store wise Collection Bucket movement reporting.
Past Assignment
Airtel Tele. Ltd. (Mar03 to Nov07)
Worked with Airtel Tele. Ltd as an off roll employee and was the part of CSD team.
Exposure Monitoring, Fraud Management, Credit Limit Updation, AV CV process.
Daily, Weekly & Monthly usage monitoring and prepare barring and TSP data.
Periodic Credit Limit Updation process, Pre AV CV / Post AV CV / Monthly on the Usage and payment history.
Monitoring of AV/CV process, Monthly Bill Dispatch reports, and analysis of failure cases with the Welcome letter Data Base.
Daily and monthly monitoring the Fraud case on various criterias and barring / TSP accordingly.
Daily Exposure monitoring dashboard.
IT Credentials
Well conversant with Lotus, Outlook, MS Office, SQL, Internet, SAP, BI-Cognos, CRM, ARBOR, RMS.
Professional & Educational Credentials
Post Graduate Diploma in Computer Application (PGDCA) form Punjab Technical University.
Economics Graduate Punjab University Chandigarh.
Personal Details
Date of Birth:
06th July 1979
Fathers Name:
Sh. Harbhinder Singh.
Marital Status: Married.
Nationality: Indian.
Language Known: Punjabi, Hindi & English.
Permanent Address :
Maninder Rattan, House No 129, Ward No 4, VPO Garhdiwala, Distt. Hoshiarpur, Punjab
Pin Code 144207.