Business Intelligence and Reporting Specialist
Zain Telecom Kuwait
Total years of experience :22 years, 3 Months
• Commercial Reporting, Business Reporting, Analytical Reporting, Geo-spatial analysis, Dashboard development
• Reporting Tools: OBIEE, Tableau, Excel Database: Green Plum, Oracle
• Analyzed IVR data to drive customer satisfaction and maximize lifetime value
• Traffic data analysis including VAS, GPRS, Voice, SMS and roaming from multiple dimensions. Analyzed tapin and tapout files.
• Supported business strategy and planning for prepaid customers.
• Analyzing postpaid products, and based on the customer current packages and usage trends; promoting new offers to the customers.
• Prepaid subscribers Gross Adds, Churn, Recharge Revenue day level comparative analysis.
• Campaign Management Reporting
• Business performance dashboards
• Comparison of Zain with other Competitors using usage data analysis
• Reducing churn through real-time targeted marketing offers
• Geo-Spatial analysis of the customer base and usage analysis
• Conceptualizing on the current demand of maintaining the ARPU generating customers based on consumer’s behavior
• Profitability analysis to identify revenue gaps & potential opportunities to bridge gaps
• Customer Segmentation on the basis of Usage behavior, Traffic pattern, ARPU & recharge pattern of consumer for preparing revenue enhancement plans
• Implement various Reporting for base evaluation
• Research activities like Competitor Analysis & gathering Market Intelligence
• Monthly Preparation and support on the information’s required for Operations Review
• Product Management & Subscriptions dashboards
• Revenue Reporting and Revenue impact from promotions
• Revenue Analysis based upon Zero Usage, MOU, Recharge Trends, Locational Analysis, Customer Segmentation, Unique Recharge Trends etc
• Products in-depth analysis after launch
• Finance KPI’s related to Recharges and Billing
• Coordinating with the various Functional Units & Corporate
• Requirement Gathering and Analysis sessions with stakeholders
• Designing proper tracking Mechanism for the various Functions
• Implement various Reporting & Analytical Processes
• Project deployment, insuring customer satisfaction, post deployment feedback gathering
• OBIEE, ODI, Informatica, Oracle, Linux
Projects:
• MIS OBIEE Migration, Zain Telecom, Kuwait
• ZKDW Geo Spatial Marketing for Zain Telecom, Kuwait
• Data Warehouse for Public Authority for Industry (PAI), Kuwait
• Data Warehouse for Ministry of Electricity and Water (MEW) Kuwait
• CRM
• Supporting service agents in there day to day tasks
• Create and work upon Functional Requirements and Business Requirements from time to time
• Worked on new promotion in coordination with marketing
• Helping clients with regards to technical issues with our widgets
• Answering questions from customers and prospective customers about the features and capabilities of our widgets.
• Communicating customer needs to our vendors.
• Provided functional and technical support, troubleshooting and diagnosing hardware and software problems
• Remedy system configurations and support
• Project: Data Warehouse for Cendant Car Rental, USA
• Oracle SQL / PLSQL / Functions / Procedures / Triggers Development and Maintenance
• Providing 1st level support to operations team for Data Integration & ETL jobs
• Responsible for developing ETL jobs
• Performance tuning of packages
• Monitoring of jobs
• Scheduling the processes
• Creating workflows
• Responsible for smooth operations of ETL jobs
• Insure timely fixes of any issues reported during execution of jobs.
Job Responsibility:
Development of Forms and Reports in Oracle Developer Suit 2000
Creating PLSQL Procedure, Packages and triggers
Deployment, UAT and Training of the end users.
I worked with a dynamic team of 10 highly qualified members. With the support of CBR Tax Experts we were able to develop the application of Sales Tax Refund. We had visited all the major cities for implementation of the database application and training of the end users.
Degree: Masters in Information Technology Final Project: Database