Mohan Verma Email & Phone Number

Mumbai Area, India

Company – Reliance Jio Infocomm Limited as Manager - for. (Apr – 2016 to Till Date)Role:-I am currently working in Navi Mumbai, as Sr. Business Analyst and Manager Business Operations (Telecom Domain). I am involved in Telecom Business Data Analysis & churning, UAT & Deployment, and SDL Web Content Management. Activities involved in the following products / solutions from Team:JIO On-Boarding (CAF Process automation / Reports)Regulatory Reports management & its reconciliation using Tableau.System integration with CNUM, OpenText.SDL Web Content Management system for LYF & Jio.Hadoop (Hive), Green Plum (SQL) for BI – Business Queries & data mining.Projects Undertaken:Web Content Management:Content Management Module: The Modules solution involves ingestion of Telecom data from web to WCM SDL-Tridion.Server Management: Various activities involved in server data analysis for server management, and integration with the Business & Infra stakeholders for BCP program. Customer Onboarding – CAF Verification process:DI Module: The Modules solution involves the integration of CAF system with the automated product development for image recognition, scanning and validation process. This module covers the complete life cycle of CAF Cropped imagesValidation: Correction in Automation of system for issue resolution.Lawful Intercept Management System – LIMSIPDR Module: The Modules solution involves the extraction of IPDR on the bases of Input given by the LEAs as per their requirements for the specific windowsValidation: Correction in Automation of system for the data extracted by the moduleBOTNET Module: The Modules solution involves the extraction of Subscriber’s Info for the particular IPs (IPv4 & IPv6) & Post data provided by CERT (Computer Emergency Response Team) Team to preventing malwares on handsets. This is a part of Govt. Cyber Swachhta Kendra.

Gurgaon, India

• Interaction with the Business for the requirement gathering & solution design as SME.• Manage CLIENT interaction wrt IT, Business and scope management for time, cost and quality.• Working extensively in Social Media Analytics , Web Analytics & Digital Marketing for some project like Airtel Money, WhatsApp, etc for customer behavior in order to support marketing & CS Activities & to help the traffic measurement and popularity trends which is useful for market research.• Strong skills as Data Analyst with the approach to, Data Modelling LDM, PDM.• Responsible for UAT / Implementation of new projects, integration with new/ existing project ventures, handling/ controlling change of requirements in existing projects.• E2E participation in team planning, helping project identify critical path activities, resolving potential bottlenecks and prioritizing requirements with Business.• Experience in playing a continuing role in development of project track by providing helpful suggestions to team members to develop their knowledge, awareness and skills, encourag-ing team members to provide continuous feedback to each other and share information openly.• Experience in working closely with the Onsite Tech Lead for the respective module to under-stand the project requirement, to come up with the phased design appropriate to the module and the project, and timely interact with client for requirement clarification and design con-straints.• Excellent communication, Leadership, Interpersonal, Organizational, Analytical and Man-agement skills.

Gurgaon, India

Role: Bharti Airtel Limited implemented a data warehouse to better plan and manage Revenue realization, customer retention and acquisition and also to establish a data warehouse of usage, billing and provisioning information for the Mobility and Telemedia business units. The main ob-jectives of the data warehouse are as follows:• Designing & developing reports, making daily, weekly & monthly reports & analysis as per departmental requirements at the different levels.• Reduction in churn through provision of churn analysis and predictive modeling. • Reduction of revenue leakage from under billing of usage and usage analysis. • Development of basic campaign list generation functionality. • Basic Profitability Analysis to identify customers who are profitable to Bharti based on their usage behavior. • Identify the target audience for a proposed tariff plan based on usage behavior of sub-scriber. • Identify the Impact of a Tariff Plan based on change in usage behavior after the tariff plan introduction. • Identify Target market of subscribers from analysis of the incoming calls (From the Calling Number). • CDR Reconciliation across Interconnect, Mediation and Billing.

Noida Area, India

This is a customized ERP system IMIS2000i (Integrated Management Information System) IMIS 2000i system creates information network among the various departments of the organization. IMIS 2000i data is updated from all Units/Depots to Corporate Office and vice-versa through RBI (Remote Business Intelligence) system. Role:To develop new modules as per departmental requirements at the different levels.Extensively working on Forms6i, Reports6i.Development and customization of Reports and Interfaces, as per user's requirements.Provide timely solutions of ERP (MIS for Accounts, Sales & Marketing, and Production) in Corpo rate Office including all the units/depots to the utmost satisfaction of the users.To handle RBI (Remote Business Intelligence) module to centralize data in Corporate Office and all units/depots.To work as an interface between ERP and various other departments for Data administration.Technical training for the system to the user.