Senior Consultant
Zain
Total years of experience :17 years, 2 Months
As a Data Warehouse/Business Intelligence Analyst, I was responsible for the operations of large-scale DWH/BI solution (Oracle Communication Data Model) to support the ETL and the operational, tactical and strategic reporting by ensuring Timely Delivery of KPIs within SLA, along with Problem analysis and resolution, RCAs, Trend monitoring, Data consistency.
•I am responsible for daily DWH/BI operations related to (ETL, Staging/Target Area, OLAP, Dimensional Modeling, Data Marts).
•My JDs include completion of daily ETLs life cycle, and ensuring its data quality and consistency along with troubleshooting, RFC implementation, liaison with L3 support for problem fixing related to ODI and OBIEE platforms.
•Played key role in OCDM Re-design project, designed to implement extensive process automation, OGG (Oracle Golden Gate) to ensure data quality with speed. The result has been incredible in terms of data availability to the customer. The data availability time has fallen down from 6:00 PM (for sysdate-1) to 09:00 AM.
•Led the Ops team in End-2-End verification and validation of DWH/BI operations during the Hardware Migration of Exadata Machines during the parallel run.
•Provided the essential input for above required enhancement in the project by doing the gap analysis and identification of problematic areas.
•Supporting the business by making data recovery and special processing, when required and coordinating with management and business teams to ensure the smooth running of the operations.
Consultant for Network & IT Quality Assurance at
As Sr. Consultant for SQC - (A SOC solution provided by IBM to monitor and improve the IT/Network QoS provided by Mobily-KSA to its consumer and corporate customers), worked with SQM Project Team for handover of Operations of these Services: GSM/GPRS/LTE/Corporate/SMS/Applications. The solution was based on complex design - a conglomerate of Tivoli Net cool/Omnibus software, Data Stage & Adapter processing, Oracle DB, SAP BI with a background of Core, RAN knowledge about 2G/3G/LTE/FDD networks, so all the operational knowledge handover and transition from Project Team to Operations team was my responsibility from SQC side. Implementation of SQM solution by IBM for monitoring Mobily’s Network & IT performance to ensure Quality of Service to the customers.
• ETL processing of PM/FM Data and Alarms received from multiple Networks (2G/3G/4G) and translating it to standardized KQIs and KPIs on data stage server and converted to KPIs & KQIs for Voice, SMS, Connect, LTE services.
• Analysis of the Quality Model, Incident Management and follow ups with the stakeholders
• Documentation of the RCAs and continual improvement of the Quality Model in place.
• Designed, developed, automated and scheduled the BO reports for the top management’s daily review.
• Customized the COTS reports, to provide in-depth analysis for the daily, weekly and monthly trending to top management on daily basis.
• Developed Customized reports and Dashboard level automated reports and scheduled for top management, with weekly change impact in the trend analysis.
• Automated 2G/3G/Connect/LTE services reports on Quality and Performance data to provide SQC team with the readily available reports for degradation analysis of the incidents.
• Performed the internal testing of IBM Service Quality Management (SQM) Solution and UAT for any new service implementation in the SQM system.
• Supervised Performance Management Engineers on incident management for reporting Network degradation issues using SQM solution.
• Defined and implemented the SQC Operations by formulating and enhancing SOPs to run the daily tasks by the team.
• Created a knowledge base for the team to provide support for technical details and RCAs of important incidents.
In CCBS team of Zain-KSA, our team’s function was to monitor and enhance BSS operations related to mediation/rating/billing/service provisioning/Commissioning modules. My role as Sr. Business Analyst was to gather requirements and transforming them into functional requirement in order to assist new rollout projects, and to ensure MPS implementation, conducting UATs etc. along with monitoring of operations.
•As Sr. Business Analyst in Zain KSA, played key roles in Project Management of various solutions for billing system upgrades and process enhancements including MOI Application, Roaming Re-rating, NRTRDE, GDC-ITO transition (Off-shore IT Operations by GDC in Egypt), DRM (Dealer Retailers’ Management)
•MPS implementation (of New Products and Services) in TABS billing system and handled requests to integrate TABS with I platform (Hybrid for postpaid and prepaid subscribers for VAS), RBT, SCB (Seamless Call back), FHOP for Premium SMS charging solution services and platforms.
•From Zain Business side, I supervised the MS team for below BSS related operations like mediation processing, rating, billing, invoicing and invoice distribution processes.
In Mobilink Pakistan, the main function of our team was to run rating and billing operations, starting from data collection from NEs on mediation to the final invoice generation. I was leading the team for this 24X7 billing operations:
• Team Lead of System Administration Team to administer Geneva Billing System
• Responsible for CDR collection from MSC/IN/GGSN/SGSN, processing and distribution to the downstream systems of Billing System, Data Warehouse, Revenue Assurance, Fraud Management and Interconnect system.
• Actively played role in different Projects for implementation, integration and Migrations from Jupiter Billing System to Geneva Billing System and Migration of Data Center from Mobilink Head Office to FRF location.
• Member of the Quality Management System (QMS) and played the role of Internal Auditor for implementing the ISO standards in IT Department for earning ISO certification.
• Liaison with Data Clearing House and Mobile Operators across the globe for bilateral roaming agreements implementation and service commissioning.