Ibrahim Mohamed Nabil

A-Systems

• Senior Application Analyst Full Time

  Jan 2011 - Mar 2012 -1 yr, 2 months

  Egypt , Cairo

  • Job Details:Project: ZAIN Telecom IT Operations Senior Application Analyst (CRM & BSS) ­ Managing, supporting and maintaining the CRM application, order fulfillment and Billing modules, trouble-shooting, root cause analysis and proposing solutions for enhancements. ­ Investigating and analysis of incidents related to CRM, Rating, Roaming and Provisioning modules. ­ Testing application update batches and preparing rollback plans and after deployment sanity checks. ­ Managing the call center daily issues as well as the customer’s complaints and resolving them on an efficient time. ­ resolving the daily incidents reported by the outlets and agents across the country. ­ Responsible for configuring and testing all business requirements before the go live (services, promotions, subsides, etc.) ­ Preparing the billing samples and performing the pre and post checks of each bill cycle to ensure the successful generation of the invoices. ­ Managing application security policy, access groups, user creation and managing access permissions as part of the CRM administration rule. ­ Investigation, identifying root causes for the general issues on the application by doing a day to day analysis of the users and customers repeated issues. ­ Working on joint projects to integrate with other applications like Fraud management system, Dealer Management System, newly created web applications and services. ­ Designing and applying bulk data fixes to solve invalid business case, subscriber attributes and charges. Achievements ­ Participated in the BSS application upgrade UAT, Go Live and successfully managed the call center operations during the cut off period.
• Senior Application Analyst Full Time

  Dec 2008 - Jan 2011 -2 yrs, 1 month

  Egypt , Cairo

  • Job Details:Projects: VIVA Telecom IT Operations Senior Application Analyst (BI & Reporting) ­ Soul owner of the entire operator reporting requirements including but not limited to designing new ad-hock reports, integrating new reports into the existing framework, investigated and fixing issues with existing reports. ­ Developing and modifying existing / new ETL to support the rapidly increasing reporting requirements. ­ Customer reporting portal, reporting database Administration and support. ­ Analyzing all aspects of subscriber’s data and transactions to design efficient marketing reports using various trends segmentations. ­ Working closely with external IT Auditors, revenue assurance department and designing the internal IT Audit queries and reports. ­ Building complex queries to provide Comprehensive data analysis as required by different business departments. ­ Working closely with finance department and RA Team to build Revenue Assurance and financial analysis report with the purpose of identifying fraud cases and revenue leaks. ­ Customer meeting and discussions to Gather requirements and analyze the business cases for the newly requested reports ­ Creating data Reconciliation queries and reports across CRM, Billing, Provisioning, Credit Control, Roaming, mediation and web applications. ­ Responsible for the daily ETL process and 24/7 on call to fix any issues and successfully resume and ensure data consistency. ­ Working as Business consultant to a 3rd party vendor to ensure efficient oracle BIEE implementation. Achievements ­ Improved the quality and reduced the time used to provide the quarterly marketing data analysis from 10 to 3 days by gathering proper requirements on the methodology used and implementing the proper daily processes to prepare the required output. ­ Successfully developed over 150 automated reports to cover the business requirements for the below areas  Finance, account receivables and cash flow.  Marketing campaigns analysis.  Revenue assurance Analysis.  Complex Calls and subscriber usage Analysis.  Roaming charges analysis  Sales and products evaluation.  Services and customer behavior analysis  Billing and Invoices.  Daily operation follow-up.  Demographic analysis.