jahangir iqbal

• Manage a team of MIS specialist to support business on-going and adhoc commercial decision making by distilling data requirements and driving analysis.
• Pull data from different databases using SQL and analyze/create reports and give recommendations for marketing, promotions, and strategy initiatives accordingly.
• Support team by providing timely analysis of various campaigns that have launched and impact seen on usage, rate, ARPU and other operator customer/traffic.
• Assist customer segmentation leaders in implementing optimal customer segments for Ooredoo’ s marketing strategies, products and services planning, and pricing strategies.
• Assist in planning, monitoring, and conducting analysis of customers and revenue information across all dimensions, such as; product subscriptions, campaign performance, demographic profiles, and usage/reload.
• Provide insight on customer behavior to support Ooredoo’ s strategic initiatives, new product launches, marketing and advertising efforts, internal and cross- functional process improvements, overall customer satisfaction and operational excellence from a customer centric perspective.
• Understand the DB structure and data flow thoroughly and lead the automation of recurring data requests, come up with data mart requirements, and suggest more efficient way of data pulling.
• Assist in ongoing BI projects which include requirements gathering, documenting, and document sharing, and participating in UAT.

• Responsible for steering the direction of all commercial divisions (Marketing Department, Sales & Distribution Department, Customer Operations Department) and Marketing Department’s Revenue Centers (Mass Segment Team, Business Segment Team, VAS Team) for achieving the Business Targets/KPI’s set by the Business Plan.

• Responsible for analyzing the performance of all commercial divisions and marketing department’s revenue centers, conducting the variance analysis between business targets and actual performance, drilling down to the root causes/problematic areas and recommending corrective measures for bringing the company back on track towards achieving the business targets.

• Supervising teams for developing the new products, making sure that data availability in EDW as per standard for smooth reporting.

• Responsible for conducting business reviews with Segment Heads, CMO and CCO and provide advisory on the steps that’s can be taken to improve performance

• Responsible for tracking and analyzing the ongoing promotions.

• Responsible for preparing the Commercial Reports for CxO team, CEO and Etisalat Board in order to keep them updated about Commercial Department’s performance, Industry Performance, and the future direction of the company.

• Forecast the behavior of ongoing campaigns and promotions.

• Responsible for Developing and maintain the BI layer by monitoring data loading in business marts .

• Different business users (Marketing, Sales, Finance, COPs ets) have different business requirements and promotion to capture market needs. We extract the exact analysis for them from EDWH.
• Different data analysis for Mass Segment, VAS, Revenue, Promotions, CLM, Churn, Active Subscribers on hourly daily and monthly bases.
• Managing the team of Microstrategy and training new resources.
• Architecting Microstrategy BI semantic layer.
• Mobile BI and dashboard enhancements.
• Managing operations of campaign and provisioning systems .
• Training & educating commercial teams about Microstrategy
utilization for various sorts of analysis
• Data validation (charging, tax deductions, promotions limits, buckets usability etc)
• Reconciliation of data with different sources. (CRM, IRIS, CCBS, MNP etc)
 Under BI developed following projects.
o Commissioning of SO to ` level.
As per sale (recharge, new sale, port IN ) we needs to provide incentive to sales officers, retailers and Franchisees. Developed retention commission process which calculate all the information and generate the commission details respectively.
Finance got the auto generated reports and dispatches the incentives to concerns.
o Tax data for Tax certificates.
For TAX return customer needs year end certificate to show the paid TAX on his bill. Developed the process which calculate 30 million subscribers charging details and calculate TAX accordingly. Generate the certificate report.
o PTA data.
Regularity needs subscriber information on monthly bases, so that they can monitor the operator subscription as per license provided. Report provided to them should be as per license. Incorporate all the checks in process which generate the report.
o Retention and loyalty of subscriber.
Developed the process which marked the life cycle of subscribers according to activities 30 days 60 days and 90 days and Churn. This process runs on daily bases and monitors the dormancy of subscribers.
This process gave value to customer value management, customer retention and Loyalty and customer behavior management.
o Active subscriber.
Marked customer as per commercial activity. Some Activities gave revenue and some are free we have to prioritize the activates according to usage. These processes have a major value addition on daily stats.
o Revenue reports for Marketing, COPs.
Business plans and strategy always depends upon what the business is earning. Developed revenue generating reports which cover all revenue streams.
o Inventory details reports for Finance.
Developed CRM base inventory system, which cover all the details of SIMs and Scratch Card from warehouse to franchise and retails. This report is hourly base report which gave significant value to finance operations.

Responsibilities:
 Installation/Commissioning/Routing(X-connections) of Nokia’s transmission equipment i.e. FlexiHopper 18/23/38Ghz, FXCRRI and FIU19
 Commissioning the Power One rectifier using POWCOM software.
 Commissioning/ Integration /Troubleshooting of the NOKIA Ultra Site EDGE BTS.
 Patching /Testing of media over different PDH/SDH systems, Dealing all kind of media related issues with PTCL and other transmission providers.
 Re-parenting of the BTS sites and BSC Aters between Different Nokia BSC’s.
 Adequate knowledge of handling the cell sites from BackOffice.including making X-connection of On-Air sites, Capacity upgrades, Equipment license upgrades.
 Uploading of all the TI related documents to Nokia Online Services (NOLS).
Telenor Pakistan EXPANSION project
 Integration of new cell as per customer request (MAR).
 Creating NCT as per requirement for expansion.
 Coordination with NOC for pre and post launch activities.
 Over all coordination for optimization of Network as per agreed KPIs
 Monitor alarms from back office using NetAct.