Aspiring for a career that keeps me in a challenging position within a fast-paced and learning oriented environment for developing my technical and inter-personal skills. To seek and maintain full-time position that offers professional challenges utilizing interpersonal skills, excellent time management and problem-solving skills.
Overview
18
18
years of professional experience
5
5
years of post-secondary education
Work History
Manager DATA Analyst PMO
Gemini Consulting and Services
Hyderabad, India
07.2021 - Current
In Gemini Consultant and Service in, and exposed in the following areas:
Converting data into actionable insights by Predicting and modeling future out comes
Utilized MS Office and VB skills in preparing Dashboards/Visualization toolsets for data analysis
Supported PMO Governance for Project to understand the Utilization
Performed schedule variance analysis and cost variance analysis and implemented corrective action
Responsible for Project Portfolio reporting and analysis, headcount analysis
Conduct and facilitate weekly project team status and updates meetings for more effective project meeting.
Idea Cellular Ltd
08.2008
Accounts Payables and Analysis
Handle the Commission payouts to Prepaid & Post paid Channel partners as per the commission policy
Handled IUC & Roaming Activates in revenue & expenditure part for Interconnect & Roaming business
Handled pre & post paid Billing Activities
Does the analysis of Customer cost Acquisition (COCA) in prepaid & post paid channel on monthly base
Responsible for Ensuring proper Accounting Commission payouts based on Calculations done as per NFA to Distributers/Retailers in AP module in Oracle R12
GL Description wise analysis to ensure that post the all the commission payouts are settled and to know Cost of each scheme in the commission policy
Do the MIS analysis like- Distributor performance analysis, Active inactive distributor Analysis and zone wise Performance Analysis and send the analysis report to High level Management for necessary action plans for Increasing the revenue share
GL Reconciliation with provisions created and actuals incurred on Monthly/Quarterly/Yearly base
Do the cost variance analysis in commission payouts on monthly/Quarterly/Yearly
Budget variance analysis to know the how much budget we have to create for the different type of Commissions and compare with the actual
Accounts Receivables and Revenue
Revenue computation and accounting as per the corporate guidelines on monthly basis and updating the revenue MIS
Revenue Variance analysis and reporting on the trends on monthly/Quarterly/yearly
GL Scrutiny and reconciliations and variance analysis on trending
Reconciliation of revenue with the Revenue assurance team and MIS teams and Variances analyzed
Control accounts reconciliation activity- Debtors control, Market stock liability, System stock liability with GL balances, observations on variances further analyzed and reported
Market stock liability valuation and reconciling with GL balances
Deferment calculations for revenue on monthly basis
Products & pricing configurations in Oracle along with pricing update for billing and periodic reconciliations
Value Added Services- provision for exp Based on Revenue for third party services (RBT/ Applications/ Subscription services etc) and actualization of expenses
Agreements and Masters - product pricing masters, 3rd party VAS Agreements along with Service list masters for vendor wise revenue shares % and coordinating with corporate on masters
Analysis on various activities- Distributor billing performance analysis, inactive distributor analysis, Revenue analysis
Reviewing Debtor management, reconciliations, ageing and collecting NDC confirmation from 3000+ distributors
Monthly Review on prepaid collection accounting and BRS and control process review on receipt and invoice recon to control the exposure
Monthly Review of Distributor Security deposit schedules, Full and final settlements for prepaid and pco
No due certificate status
Do the product wise analysis and how much revenue is Generated from each product on weekly/monthly/Quarterly base and necessary reports to given to higher authority
Do the Product mix Analysis for continue or Discontinue or clubbed with any other product of a particular product and send the analysis report to Higher level for Decision making
Issue the credit notes to Distributers in AR module on the basis of commission eligible for Scheme on monthly base
Reconciliation between the Account Statements of Distributer in AP and AR module
Distributor account reconciliation and getting the balance confirmation for 4000+ distributors on Quarterly basis
Reconciliation between the customer balances and GL balances for Liabilities
Worked as with IDEA as upselling processing Executive since, Working on inbound upselling process at various skills
Choosing the VAS products to be upsold for the month per customers Usage and revenue
Taken initiative in increasing VAS revenue by checking the daily trends
Prepared MIS in order to update the management on the performance on a daily, weekly & monthly basis
SAP, Assistant Manager
Reliance JIO Infocomm Limited
Hyderabad
04.2017 - 07.2021
In Reliance Jio in April 2017 and exposed in the following areas
As Lead Operations:
Lead for Accounts Payables Helpdesk, Invoice Processing and Closing & Reporting
Ensuring the SLA’s of the Company are met and successfully achieved the Toll Gates as per Company deadlines
Monitoring the team’s performance and ensuring that all SLA’s are met on daily basis
Closely monitoring the invoice team’s performance through internal audit/reviews
Ensuring the team is working closely with business units in resolving the queries related hold invoice
Ensuring the helpdesk queries are addressed in timely manner
Monitoring the helpdesk teams performance through customer surveys
Root cause analysis on the errors, planning and implementing corrective action plans
Month / Quarter end Accounts Payables close activities reporting to Management
Responsible for monthly /yearly reviews of the team performance
Liaising with the quality team for the implementation of Lean ideas
Responsible for weekly /monthly Dashboard
Responsible for cross trainings within the team to avoid dependency
Organizing weekly team meetings to discuss updates, statistics and other information
Tracking the attendance, managed leaves and performance appraisals for team members in timely manner
Preparing dashboard on a weekly & Monthly basis
Collaborate with HR Team in ensuring healthy team relations and career enhancements for the team members
Monitoring SOP’s & Error/Exceptions Report and discussing with team members
Monitoring of Budget allocated Vs Actual Expense
Preparing Daily Bank Bookings and reconciliation and assign to the Team
Run and converted trial balance reports and aging summary reports from Fiori into excel spreadsheets & PDF to reconcile the balance sheet for month-end-close
Ensuring Vendor F&F Settlement
Senior Executive
Idea cellular Ltd
Hyderabad
06.2009 - 08.2015
Executive
IDEA
12.2006 - 08.2008
Corporate reports on Idea Cellular CRM Tool “ICare”
Preparing all Reports for call center, Team Managers, Response, Resolution, Tele-callers, and SMS based activities on daily basis on MS Access thru mapping, updating by running various queries
Automated the daily reports
Handled IVR MIS & Reports
Analyzing on Repeat call reasons at IVR
Make necessary changed in IVR tree accordingly
Collecting feedback from the customers on IVR to improve the efficacy of the prompts played
Proactively checking the speed of transactions, applications and escalating to the concerned team incase of any issues with the applications etc., to ensure smooth call flow at call centre
Analyzing the data capture to understand the gaps and suggest alternate methods with details to ensure improvement in performance and increase in First Contact Resolution
Updating the entire transaction checklist as per company norms and updating the management on daily basis
Dip checks done on the accuracy in the data capture of the prepaid team
Timely Updation of product and process information in the common site used by the front end users.
Trainee
07.2005 - 12.2006
6 months - Handled calls of postpaid channel desk (Consumer Dealer desk), also worked on I-chat application simultaneously
For 3 months – Handled customers at Customer Contact Center (CCC) as Representative-CCC in the head office
For 2 months – Handled service recovery desk
For 5 months – Handled Postpaid Escalation calls being a part of Subject Matter Expect (SME) desk.
Education
Bachelor of commerce - computers
Osmania University
01.2000 - 01.2003
10+2 - Commerce
Sri Ram Chandra Jr. College
01.1998 - 01.2000
Skills
TECHNICAL PROFICIENCIESundefined
Accomplishments
For 2 months – Analyzed on Y-repeat calls (Repeat caller)
Projects:
Certified as Green Belt for handling in house projects
Projects handled
Process improvement in terms of reduction of Repeat caller to Customer Care
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Quote
The way to get started is to quit talking and begin doing.