Rajeev Ranjan

Rajeev Ranjan : 91 - - Summary: 5+ years’ experience in Backend operation, Call & Content Logs, MIS Reporting, Documentation, MS SQL, MS ACCESS, MS EXCEL & SAS Base ,SAP. Expertise in making queries through SQL server and MS Access. Automation of Report’s through VBA and Excel Formula’s. Have experience of different areas of Real Estate(investor Mis) & telecom (Broadband Services(DSL,Voice,IPTV,FTTH) &VAS Services (Music product, M-Banking & Commerce, live Aarti , Astro service & VCS service, Mobile Apps(Spice gang & Google Play) and audit like Documents, Waiver, Unauthorized reconnection/unbarring dashboards, Mobility reports etc). Reporting flash reports with the performances of our Across Operator products Good interpersonal skills, commitment, result oriented, hard working with a quest and zeal to learn new technologies and undertake challenging task. ProFESSIONAL ExPRERIANCE BPTP LTD Location : New Delhi Department : Investor Relations & Mis Roll : Senior Executive Duration : oct’16 to till Responsibilities and Achievements: Description:Analyzing Data and creating and sending report to investors & dealer and according to required information top management. These Reports helps organization to run their business in respective fields smoothly Application Software: Ms-Office 2016, SAP, salesforce Roles and Responsibilities: Handle and resolve customer complaints. Responsible for various MIS(s) & Trackers to Top Management, Promoter & Investors including Financial & Non-financial (Sales, Billing, Collection, Inventory ,contractor payment,COC(COST OF CONSTRUCTION) etc..) information Creating management decision support models and reports that derive the information from various projects to help direct and quantify sales and marketing efforts. Tracking of sales, collection & billing performance, construction milestones, inventory & stock tracking on a periodic basis Creating Investor’s report about their investment and profit in projects of BPTP. Creating Weekly Business Report which shows business made by all regions for different segment and Product, This report helps business strategy team to identify the lack in strategy and improve the business. Creating Report for Dealer for showing their performance in term of revenue generated by them Creating Report of Customer care (Employee Productivity, Calling Report). • Other Adhoc Report as required by Manager’s & others. And Automation of Report’s through VBA and Excel Formula’s. TELESONIC NETWORK LTD a Bharti Airtel Group Location : Gurgaon, Haryana Department : Installation & Fault Repair Roll : KPI Analyst Duration : Nov’14 to 15th Oct ’16 Payroll : TDS Management Consultant Pvt.Ltd. Responsibilities and Achievements: Analyzed PAN India activity and releasing monthly/weekly dashboards KPI reporting for all circles. Preparation of daily, weekly analysis reports. Driving DSL & Voice KPI’s along complete PAN INDIA. Root cause analysis on faults & ensuring proper implementation of corrective actions. Prepares and maintains weekly and monthly KPI status reports Responsible for submission of weekly, monthly, Quarterly performance and EIS Tool Managing all Final agreed with customer performance related record. Consolidation, analysis and interpretation of various data pertaining to Performance KPI Parameter. Facilitated to identify areas of improvement and drive performance improvement Technical reviews with airtel management Preparation of Monthly review KPI Report for IFR. Bharti Airtel Limited– Airtel Business (Airtel) Location : Gurgaon, Haryana Department : Marketing Roll : Revenue Planning and Analysis Duration : Mar’14 to till Nov’14 Payroll : Manpower group services India Pvt. Ltd. Responsibilities and Achievements: Managing sales funnel and order booking in proper case analytic, circulating to RM Analyze project implementation action cycle of order booking, resulting in reduction in internet orders by 1.2 days, MPLS order by 2.4 days. Creating vertical wise 360 degree view of all KPI’s (Funnel, Order Booking, Project Implementation, Rate Renewal and Churn). Vertical wise and product wise revenue analysis for last 3 years, leading to insights on upsell and cross sell opportunities Prepared and analyzed key business KPIs and provide pointed information to decision makers for making business strategies Preparing data for Revenue Planning & 3G Analysis. Working on all Company profile who listed in Airtel AES Account, like Company of nature, Area of business & Brand value and Annual Income. Jan 11 to Dec 13 Spice Digital Ltd. as Senior Executive Job Profile:- Coordinating between Product and technical resources with internals & Externals team for fulfilling all the requirements of client. Worked In CEO Function (prepare the data analysis, PPT, Meeting Review & Follow-up the concern person as well as report to CEO). Circulating Across Operator/ Products' Monthly/ Weekly subscriber usage engagement studies/insights to higher management/ various internal teams like Business/ Product/ Content/ Technical teams which help them in their daily operations which further led to revenue enhancement. Profiling the Content, Balance, MOU usage & of end customers which helped in targeting them with customized & meaningful Promotions. To review and identify any non-compliance in the daily MIS (online & manual). Communicate with the onsite Engg. and Vendors regarding timely generation of reports in a specific format & business promotion Working on Call & content log file of All airtel services as monthly basis and make a summary report as well as share the all Airtel Team Member & Top management person which help to promotion the VAS service activity.. Generate the consolidate VAS Activity MIS of Airtel vas services(Radio(Movie pack,playlist,Raat-baaki,B-Radio,N-Radio),R-dhun,Mirchi,Big-Fm,live aarti & Astro) & Education & Family Infotainment. Various MIS are designed on the basis of monthly, weekly & daily for analysis point of view like Daily Education & Family Infotainment Run Rate, Product Wise MIS, Circle Wise MIS, Rural Vertical Summary, Review MIS, Base Revenue Churn, Comparison sheet & etc. Development and Design of Vodafone V-Chat Call Center MIS Module, Designed the MIS add many required fields which make more easy to analysis the Vodafone V-Chat Business reports like Analysis Report, Call Center Analysis, Center Wise MIS, FL Call Center Analysis, FL Center Wise MIS, Hourly MIS Of Agents Productivity Working on Sql server query and share with onsite eng and get the accurate data from Billing & Subscriber table across airtel circle. Make the summary report (Hourly, day, weekly) wise from Call & content log of across circle with All airtel VAS Services. Make the target VS achievement report & Rev Tracker of across circle on daily basis and share the All AM airtel team & Top management person. Tracking the All KPI Rev(Subcription,Re-subcription,Topup,Browsing), Gross Add (sub, Renewal), churn (vol, non-voluntary) & call Details (Call (Live, Non live), MOU’s (Live, Non Live), unique user (Live, Non-Live). Previous Employer:- Airtel Dec 08 – DEC-10 Backend Executive Gurgaon Vendor: Goyal SERVICES Responsibility: Maintaining and creating different Databases in Access. Making different queries in Access for manipulation of data. Maintaining various type of MIS on Daily Basis Fresh Activation Incomplete Documents Name Transfer and Market Transfer Reinstallation Dot Audit Error resolve related to Incomplete Docs Maintain and audit all types data (daily collection, name transfer Market transfer, waiver black Barry etc) which is send for scanning. Data maintain of activation report ,taking from report server and send all concern departments Working on daily collection and master validation data Audit Sef receiving & Scanning data & highlight mismatch Handling D.O.T , Nodal officer & legal department cases related to scan image & CDR. Provide scan image all concern departments Progress Control and MIS reporting to management on Daily/Weekly/Monthly Basic with help of Excel & Access Audit the documents (SEF) through scan Responsible for all types of mail related to Omni helpdesk Uploading of SEF’s scan on server through OMNI Docs Handling with clients for scanning and storing of Sef Uploading of SEF’s scan on server through OMNI Docs Work Environment: MS SQL, MS Excel, MS-Access, Arbor Launcher, ICRM, Airtel URLs. TECHNICAL QUALIFICATION: Databases : MS-Access, SQL Server. Others : MS-Excel, Vlookup, pivot table, advance excel, IIS, ICRM, Arbor Launcher, VBA Macro,qlikview ,Tableau SAS, SAP &salesforce SAS (Statistical Analysis System):- Training taken from Multisoft Systems (Noida) in the year 2013.. EDUCATION QUALIFICATION: “Executive MBA” from Shridhar University. “Bachelor in Computer Application (BCA)” from IGNOU in 2006. Three month course in ASP.net from ITBS. Six Month Educational Project and Training Activities in Apeejay, Patna. ICRM Certification. Communication skill: English, Hindi. Area of interest: computer, cooking, listening music, playing Cricket, interacting with people, internet Surfing. PERSONAL DETAIL: Father’s name:Shri Prem Chand Kumar Date of birth: 05-Jan-1986 Sex:Male Marital status:Married Pan no: ASOPR924H Place: New Delhi Date: _ _/_ _/_ _ _ _[Rajeev Ranjan]