CAREER OBJECTIVE
To obtain challenging and responsible position with hardworking and performance, which will further enhance my knowledge and skills.
EDUCATION
Qualification University Graduating Year
Master of Business Administration (Fin) Andhra University-India 1999-2002
Master of Commerce (Accounts) Andhra University-India 1997-1999
Bachelor of Commerce (Cost & Mgt) Andhra University-India 1993-1996
PROJECT EXPERIENCE (MBA)
Organization Hindustan Petroleum Corp. Ltd., Visakhapatnam.
Dissertation Financial Analysis of Hindustan Petroleum Corp. Ltd.
Profile The Company’s performance as analyzed on the basis of Five-year data from April 96-97 to November 2000-2001 applying the technique of Ratio Analysis
WORK EXPERIENCE
COMPANY NAME
NOKIA SIEMENS NETWORKS, BANGALORE
Designation Sr. Executive MIS – Managed Services (KAR & AP)
Duration Aug 2009 – Till Date
• Preparing Core Related Reports on daily basis:
a. MSS wise Capacity Vs Utilization Report, b. Traffic Analysis c. BU Reports, d. POI Utilization Report, e. Daily Customer Report
• Preparing RF Related Reports on daily basis:
a. SDCCH Reports, b. SDCCH Drop Report, c. TCH Drop, d. TCH Blocking e. SR Tracker, f. Handover Success Rate, CSSR & PSR Reports for 2G & 3G.
• BSS Related Reports on weekly basis:
a. Maintain AT Data, b. Preparing Network Outage Report.
• Preparing the Network Dash Board and Core Customer Presentations on daily basis for KK & AP Circles.
• Preparing the Weekly and Monthly Presentations for KK & AP Circles.
• Coordinating with Regional Managers for End-to-End MIS Coordination, parallely supporting the BSS National Head for other regional reports.
COMPANY NAME
RELIANCE COMMUNICATIONS LIMITED, HYDERABAD
Designation MIS Executive
Duration Sept 2006 – Aug 2009
Responsibilities:
• Coordinating with Web world Expresses, Mini Expresses across Hyderabad & Secunderabad for their sales activities, collections and customer care operations.
• Calculating commission payouts, monthly incentive schemes and coordinating with commercial for releasing all payments in stipulated time.
• Communicate to stores and train all Field sales executives for new Plans and tariffs, new handset models with features.
• Coordinating with marketing department for banners, posters, dummy handsets placed at all stores at Hyderabad & Secunderabad.
• Coordinate with RCO and CDC from Purchase order to stock delivery along with updating stores about stock availability.
• Managing database for studying sales trends, analytical analysis; interpretation of the data and presentations to the top management; Audited and corrected Commission process
• Updating all the information about new franchisee details in the portal.
MIS:
• Preparing the MIS reports by organizing the raw data obtained from complex systems running SAP and SQL Server on daily basis.
• Maintaining MIS data related to Prepaid Schemes, Daily Marketing Updates, Monthly Branch Presentations, Market information etc.
• Monitoring reports of dealers and Co coordinators for Sales and Collection analysis.
• Working out sales targets, collection targets and sales budgeting for the field offices all over Hyderabad & Secunderabad.
• Design sales and collection strategies with Sales Managers and supporting the Retail Sales and Finance Collection Team.
• Communicating to Channel Partner and Distributors regarding new schemes and new products and tariffs and updating on timely basis.
• Calculating commission payouts and incentive calculations and scheme qualifiers and coordinate with commercial to reach out the incentive in proper time.
COMPANY NAME
IDEA CELLULAR LIMITED, VISAKHAPATNAM
Designation Sales & Distribution Coordinator & MIS
Duration July 2004 – August 2006
Responsibilities – Sales & Distribution Coordinator
• Handling Prepaid Schemes and issues of Zone1 consists of Prepaid & Postpaid Distributors.
• Handling queries of Distributors on Distributor, Retailer and FOS Schemes.
• Raising Vtopup orders and ensuring timely Recharge to the Distributors.
• Handling ISMS and resolving ICARE Queries related to Prepaid & Updations.
• Appoint the new Prepaid & PCO distributors and creating business purpose activities.
• Visited the INUs and Channel partners monthly twice and solved pending issues.
• Coordinating and documenting the new PCO Distributors and Prepaid Distributors.
• Handling queries from all distributors/dealers and ensuring resolution of their concerns.
• Handling Stock of Prepaid vouchers, PCO FCTs, Sims etc, Receipt and Distribution to various dealers and distributors.
• Issue and settlement of daily stock issued to Customer Care and Handing over to Finance.
• Coordinating in physical verification of stock and receipts from Materials HO.
• Preparation and maintain the invoice data of various stock issued to the distributors.
• Postpaid dealer coordination in various issues and supplying data to the TSS and Managers from time to time in absence of postpaid sales coordinator.
• Coordinating with Finance in various stock related issues and invoicing to ensure good controls over stock related issues
MIS:
• Preparing the MIS reports by organizing the raw data obtained from Circle Office on Daily basis.
• Maintaining MIS data related to Prepaid Schemes, Daily Marketing Updates, Monthly Branch Presentations, Market information etc.
• Preparing the Stock Reports on every month end and send the MIS Reports to Commercial.
COMPANY NAME
RELIANCE COMMUNICATIONS LIMITED, HYDERABAD
Designation Commercial Coordinator
Duration Sept 2003 – July 2004
Responsibilities:
1. Responsible for collections of 2 Districts and 12 Agencies.
• Handled collections in Nizamabad and Nalgonda Districts
• Responsible for collections with 5 Web Worlds and 7 Dealers
• Each Web World and Dealers will have their own portfolio
• Meeting Daily Targets
• Periodic Tour visits
2. Coordinating with Agencies for clearance of pending bills of customers.
• Regular collections review with Web World & Dealers in achieving daily targets.
• Visiting customers and giving clarification to customers in clearance of pending bills.
• Doing settlement of accounts of by giving waivers.
• Tracing skipped cases
3. Handling of Daily Cash & Bank Transactions.
• Verification of daily collections Vs Deposits through reconciliation
• Monitoring of receipt numbers in collection statements.
4. Preparing MIS Reports in Tally 6.3.
• Sending daily collection data to Hyderabad to update pending payments
• Daily Target Vs Achievement report.
COMPANY NAME
ASTER TELESERVICES PVT. LTD., HYDERABAD
Designation Executive cum Account Assistant (Pune Region)
Duration December 2001 - August 2003
Responsibilities:
• Preparing company cash & bank activities.
• Preparing Expenses Statement and Petty Cash Book.
• Handling of sub-contractors accounts.
• Preparing the Employee details on Leger wise.
• Payroll accounting and leave administration of employees for Maharashtra region.
• Relationship management with Bharati Teleservices for final settlements.
• MIS report generation on daily and monthly basis.
TECHNICAL SKILLS
ERP SAP S&D
Accounting Package Tally 6.3
Package MS-Office 2003 & 2007
Database MS-SQL Server
PROFESSIONAL ACHIEVEMENTS
• Appreciation from Mr.Sashikanth G (Stock Distribution) for excellence performance in 100% Stock maintance in Zone1 –Idea Cellular Ltd., Vizag.
• Appreciation from Mr.T.Srinivasa Choudhary for Prepaing Monthly Branch Presentations in Zone1 –Idea Cellular Ltd., Vizag.
• Appreciation from Mr.Vivek Aryasri for completing the Secondary Sales in time for Hyderabad & Secunderabad Clusters in Reliance Communications Ltd.
PERSONAL DETAILS
Father's Name P.R.Malleswara Rao
Date of Birth 09th April 1976
Marital Status Married
Passport Number A5234298
Passport Validity 05th May 2018
Permanent Address Flat No: 2, Siddhartha Towers, Abid Nagar, Akkayyapalem, Visakhapatnam - 530 016
Languages Known English, Telugu & Hindi