Riadh - Consultant SQL

DETAILED PROFESSIONAL EXPERIENCE

May/2011 to Present: Orange Tunisie

May/2011 to present: IT Senior Manager - Business Support Systems
Monitor and coordinate the activities of the service/department
Plan and allocate tasks to the employees
Monitor and support the activities of the team
Reports to the hierarchy of the service/department activity
Manage projects: design, development, control, planning, coordination, costing, reporting, risk management and alerts, documentation, deadlines and the project boundary, etc.
In charge of the requirements gathering/analysis and solution design for the whole Order and Service Management area. Scope define and design solution offering ; Lead the solution architecture definition (bscs/billing, CRM, provisioning, Web Services, …etc.); handle requirements changes during developement and driving end-to-end technical solution.
Manage the performance of the integrators and the relationship with suppliers
Negotiating for benefits, contracts or agreements with various integrators

Nov/2010 to May/2011: Business Analyst Consultant @Alcatel Lucent
BSCS Business Analyst and Here are some of my basic functions, responsibilities and achievements:
Assisting client in requirement definition.
Translating business needs into technical implementation and customization inside the billing system.
Analyzing client requirements regarding all Billing related processes and DCR.
Conducting global feasibility studies related to customer’s new evolutions or change requests, including description of the proposed solutions and estimated charges.
Develop and Implementation of solution approved and validated.
Providing technical assistance for development/production/test & integrations teams.


Jan/2010 to Nov/2010: Tunisie Telecom

Jan/2010 to Nov/2010: BSCS/Billing Expert
BSCS Expert for Tunisie Telecom operator in multi-market (GSM, Fixed and Data) convergent BSCS iX Release II Migration project and here are some of my basic functions, responsibilities:-
Assist operational team in exploitation tasks after (Raiting, Roaming, Billling, and Provisioning) and provide support for BSCS production.
Work closely with business to define/clarify requirement.
Interface with business and technical teams to elaborate/validate functional and technical design of the solution (BSCS, mediation, provisioning….).
Work closely with team leads of the implementation team, who takes on the delivery of the final agreed solution. Additionally would review such that BSCS is correctly configured and implemented.
Monitor the development and testing phases until setting solution in production
Sharing in planning and reviewing testing plan and testing strategy.
Reviewing and approving test cases and testing documents.

July/2009 to Dec 2009: Xpress Integration

July/2009 to Dec/2009: BSCS Consultant
Assist Tunisia Telecom operational team in resolving exploitation problem related to payment processes.
Design and Implementation of a Promotion Tool application “Smart Promo Tool”.



Feb/2009 to June/2009: Tunisie Telecom

Feb/2009 to June/2009: PMO and UAT Manager with “Tunisie Télécom” operator
Working in the Project Management Office at Tunisie Telecom in the BSCS iX Release II Mobile Migration project and here are some of my basic functions, responsibilities:

UAT Manager
Performs detailed planning and manage project throughout the test execution.
Create test cases and obtain Business input and agreement
Create test plans and test execution schedule.
Develop and/or extract detailed test data required for the execution of test cases.

Validate test results and verify all enhancements, programs and/or system(s) meet the expected results.
Report and track system defects where output and/or behavior do not meet expected results.
Follow up and ensure re-test is performed upon delivery of fix.
Work closely with Development staff dealing with any issues identified by the test execution team.
Maintain regression test beds as required based on new functionality.
Document test results for project team sign off.
Provide status reports on all testing issues related to the project under test.

PMO
Review and validate functional design documents
Assisting client for requirement definition.
Verifying dependency between BSCS and external systems.
Obtain clarifications during the planning stages.
provide feedback
Propose better solution if any
Ensure that the application architecture, design and implementation is conforms to the business and system requirements and is robust and integrated seamlessly into existing networks and systems

Assist Tunisia Telecom operational team in starting of exploitation tasks after cutover (Raiting, Roaming, Billling, and Provisioning) and provide support for BSCS production.

Technical area : BSCS iX, PVCS Tracker

Nov 2007 – Present Atos Origin, Orascom Telecom Tunisia Mobile Project, Contractor, BSCS 7 Consultant

Nov 2004 – Nov 2007 Atos Origin, Maroc Telecom Mobile Project, Contractor, BSCS 7 Consultant

Jul 2000 – Nov 2004 Tunisia Telecom – Billing engineer
Since November 2007: BSCS Consultant with Orascom Telecom Tunisia “TUNISIANA”
Working with Atos Origin in the project of technical maintenance of BSCS V7 for Orascom Telecom Tunisia Operator “TUNISIANA”.

Principal tasks are:
 Providing Support for BSCS production.
 Assisting client for requirement definition.
 Base line configuration.

From November 2004 to November 2007: BSCS Consultant with Atos Origin Morocco
Working with Atos Origin in the project of technical maintenance of BSCS V7 for Morocco Telecom Operator “Ittisalat Al Maghreb (IAM)”.

Principal tasks are:
 BSCS team leader since September 2006: Managing a BSCS team composed by 5 persons, this task includes the ability to manage the work load and meet aggressive deadlines and deliverables. This task allowed me to develop the communication (written and verbal), interpersonal, good planning and organizing skills by working in a client-facing environment.
 Base line configuration (new rate plans, packages, services, business scenarios, free-units, Zones etc) with both online modules and PL/SQL scripts.
 Making the design and the implementation of the Mobile Number portability “MNP” solution commercialized by Maroc Telecom.
 Making the design and the implementation of the 3G services (Visiophony and Internet) commercialized by Maroc Telecom.
 Responsible for problem notification, design change requests, analysis/implementation of new user requirements, performance improvement on existing processes etc.
 Maintaining fault and troubleshooting the BSCS platform.
 Performing all user acceptances testing of billing related changes into production.
 Testing new commercial offers (Rate plans, services …etc).
 Testing new shipments of BSCS online and batch modules.
 Providing 2nd line support for BSCS production.
 Investigating and resolving all complex Billing related Back Office service requests from customer billing complaints.
 Performing root cause analysis of identified problems and take ownership for implementing resolution.
 Providing operation onsite support.
 Analyzing problems and processing error reports from users.
 Analyzing errors and rejections generated by the rating and billing chain then taking the necessary actions for timely resolutions.
 Ensuring that problems related to all processes are solved on time.
 Making investigations and suggesting solutions and workarounds.
 Elaborating procedures for recycling the rejected calls.
 Analyzing rating and billing chain performance and taking the necessary actions in order to ameliorate it.
 Developing scripts (shell and PL/SQL) for exploitation.
 Optimizing production scripts.
 Generating statistics covering billing activities.
 Analyzing the requirements feasibility and cost.
 Providing new strategies and solutions to implement non kernel functionalities.
 Writing of detailed specification, design, installation and exploitation documents.
 Assisting client for requirement definition.
 Translating business needs into technical implementation and customization inside the billing system.
 Elaborating impacts & feasibility studies.
Technical area : BSCS7.0, Oracle, SQL, PL/SQL, AWK, Shell, PROC.

July 2000- November 2004: Tunisie Télécom

December 2001 – November 2004: Working in the billing GSM service.
Expertise in BSCS: BSCS is a leading convergent billing solution for wireline and wireless network operators. The version used by Tunisie Telecom is 6.0.

Principal tasks are:
Production Support:
 Supporting customer care for all problems related to their needs.
 Installing hardware and software tools used by Tunisie Telecom agencies.
 Analyzing problems and processing error reports from users.
 Putting in place indicators to track volume of activity to take actions to schedule and to prioritize activities.
 Managing Resources (SIM cards, MSISDN): generation, declaration on the system, logical distribution to points of sale.
 Supervising contracts processes & customers administration as well as mastering of the related database tables.
 Performing complete analysis on data logs and taking the necessary actions for timely resolutions to any eventual problems.
 Troubleshooting for the communication with HLRs-MSCs.
 Ensuring the processed on time of all data files.
 Declaring roaming agreements.
 Generating TAP3 file and IR fraud alert report.
 Dealing with other operators and our suppliers for solving any problems OR creating new issues
 Ensuring delivery and reception of all data IN and OUT with other operators and our suppliers
 Developing tools for processing roaming files.

RATING experience:
 Monitoring the Rating chain.
 Developing tools for monitoring incoming CDRs and generating alarms for any encountered delay.
 Performing complete analysis on data logs and taking the necessary actions for timely resolutions to any eventual problems.
 Developing tools for monitoring Rating chain and detecting errors.
 Developing tools for generating regular reports on the Rejected CDRS.
 Developing tools for recycling the rejected calls, and for fixing the rejection reason if possible.

BILLING experience:
 Monitoring the Billing chain.
 Ensuring the accuracy of bills.
 Taking all the preliminary steps to ensure readiness for a successful bill run.
 Following bill cycles performance and reporting on a regular basis.
 Creating billing procedure and plans.
 Designing control group for all possible criteria & developing tool to generate this control group automatically.
 Developing several pre-checks which are applied always before any cycle to prevent facing any expected errors during the real bill cycle.
 Planning & monitoring capacity tools.
 Optimizing production scripts, promotions or workarounds in order to minimize the whole duration of the bill cycle.
 Developing of workarounds if needed for the bill cycle.

Expertise in EMM (Billing GateWay): it is a solution implemented by Ericsson allowing the collection, processing and the distribution of files from MSCs.

Principal tasks are:
 Monitoring the collection and distribution of CDRs from MSCs to Billing System.
 Checking alarms generated by the BGW.
 Editing statistics status.
 Customising new services (International SMS, GPRS and MMS).
 Testing and verifying new configurations.
 Checking disk capacity and CPU load.
 Analyzing and reporting problems to the helpdesk.
 Managing emergency cases.

Expertise in EMA (Service Order GateWay): it is a solution implemented by Ericsson allowing the communication between HLRs and billing system. The actual version used by Tunisia Telecom is R9.2.

Principal tasks are:
 Verifying HLRs redundancy.
 Monitoring the communication between Billing system, SOG and HLR.
 Verifying batch processing.
 Loading IMSI and EKI numbers in the AUC.
 Analyzing and reporting problems to the helpdesk.
 Managing emergency cases.
 Checking alarms generated by the SOG.
 Editing statistics status.

Training:
 October 2003 : One week training in SoftWay Tunisie on Backup and
Restore of ORACLE Database.

 October 2003 : One week training in SoftWay Tunisie on SOLARIS user.

 June 2003 : Three weeks training in Technical training Center of Tunis (CFT) on ORACLE (DBAI, DBAII and Tuning).

 June 2003 : One week training in Ericsson Education Center on the Billing GateWay (BGW). (Place : Gotebörg Suede)

 March 2002 : Training in Thuraya on the modules KV and DB of the software BSCS 5.21. (Place : United Arab Emirates)
Technical area : BSCS6.0, EMM, EMA, Oracle, AWK, Shell.

July 2000 – December 2001: Working in the prepaid department.
Administration of MINSAT system. MINSAT is software developed by Ericsson allowing the management of the prepaid customers.
Principal Tasks are:
 Participate to the preparation and launching of prepaid service.
 Administrating MINSAT system : control of processes, Users and access rights management, System Backup, etc …
 Managing a team of 4 persons.
 Making acceptance tests with the provider (Ericsson).
 Provisioning and removing Voucher and Subscriber.
 Managing SIM Swap.
 Editing statistics status.
 Providing technical assistance to agencies.
 Analyzing and reporting problems to the helpdesk.
 Managing emergency cases.
 Administrating Voucher Server.
 Elaborate procedures and documents for launching of prepaid service.

Training:
 Training in SAGEM on the SIM Toolkit cards. (Place : SAGEM France)
Technical area : Minsat 3.2, Sybase, AWK, Shell.