IT Application & BI\ETL Senior Consultant
STC Specialized
Total years of experience :18 years, 7 Months
Responsible of all ZAIN KSA BI/DWH operations
Responsible of operation of all Zain KSA DWH/BI, including the ETL's loading and quality checks
• New system Migration.
o Responsible of migration all of PostPaid data to the new system.
o
• Tariff Activation on Ericsson System.
o Monthly Tariff Checks:-
Do a montly checks for PrePaid / Postpaid tariff and send it to marketing Dept to make sure that there is no changes and to avoid the fraud.
o Tariff Activation:-
New Tariff Setup Voice/SMS/MMS, .. etc required by Marketing Department.
• Handeling Marketing New Offers:-
o Analyzing and implementing marketing, customer care and sales road maps.
o Fulfilling Zain products and services life cycle from conceptual phase to go live and post-go live activities.
o Lead vendors on projects execution phase by monitoring the SLAs and testing and QA the
delivered solutions.
o Lead launching and go live process of Zain products and conduct required training for training department as train-the-trainer and handover the solution to operational team.
o Health checking the solutions after go-live and assuring its efficiency and working closely to IT operational teams.
o Provides technical leadership and consultancy for different Zain departments.
Document Billing Process:-
Document all of the billing department process an KPI’s to be reviewd quartly for internal/external audit.
Extracting Customers invoices. (Bill Cycle)
Customer Care Support.
Support Zain shops and call center agent in all matters to zain customer pre/post paid.
Corporate - Sales Support
Users Management
+Responsible of creating and granting access to new staff and do a quartly checks and send it to managers to agree on the access due to zain emplyee originaztion changes and to be allein with internal/external audit yearly checks.
Post Paid Help Desk
E-mail Alarm System for Zain Billing servers
Achievmetns
+Build Security Tracing Module:-
+Monitor users actions and report security breach if any.
Build VIP Customer Module:-
+VIP Customer (UN, NGO’s, Government and Large Companies)
Below Modules built using Oracle Form/Report Builder
+Build the Invoice Module
+Build the Mailing services:-
+Build the Itemize Invoices:-
+Build the new Cash Collection Module:-
+Build the Bad Debit History and backup Module:-
+Build Collection PDF Module:-
+Bill Present changes (Invoice Layout changing and amendment)
\{+Build Archiving Module
Reporting:-
I build a reporting Module that generate below reports:-
Number of CDR’s Generated.
Number of suspended calls with suspended cause, and log the error and fix it.
Number of calls for all Traffic Types and compare it with files sent from mediation.
Number of Sold/suspended voucher and log it.
Daily Ticket status Solved and pending.
RBT Missing CDR’s.
Subscribers with invalid package setup.
Subscribers with invalid disconnection scenarios.
wrong charge customers.
Delayed Roaming CDR’s.
Bill Cycle Report.
Contracts with invalid billgroups
Subscribers with invalid status
Subscribers with invalid billgroup or prepost_paid and postpaid package
Subscribers Active without main package
Subscribers which are NOT rented up to the end of the current month
Subscribers with duplicated rental fees services.
Miss Rated CDRs reference to rating setup.
Validate new chargetypes & new Tariffgroups with the layout format.
Provisioning Accuracy check
Failed SIM swap commdands.
PostPaid Traffic Report.
Roaming Duplication CDR’s
Daily Disconnected, Warning and Bad Debit Customers.
History and Aggregation table comparison.
since 2006-oct
responsible of billing system and all customer care inquiries,
developed a invoice system for zain sudan since 2008
working on the core billing system and well known with the billing system in the telecommunication side
using oracle DB and application server
developing shell script to monitor all Zain Post Paid process.
Developing an ERP System
Developing a system for National Aviation Authority
Responsible of all the company ERP system, Network and Maintenance
since 2006-oct responsible of billing system and all customer care inquiries, developed a invoice system for zain sudan since 2008 working on the core billing system and well known with the billing system in the telecommunication side using oracle DB and application server developing shell script to monitor all Zain Post Paid process.