Mohamed - Consultant technique SQL

Ref : 111125J001

1000 TUNIS (Tunisie)
Consultant technique, Business Analyst (45 ans)
Freelance

Photo de Mohamed, Consultant technique SQL

Compétences

SQL

Expériences professionnelles

BSCS Consultant& Validation and Test Engineer

Orange TunisiaQualification team
Jan 2018 - Jan 2018
• Writing & Implementing test books and validation scenario.
• Shipment Testing and validation (CRM,CX,WS,Pos).
• Provisioning (GMD,KPSA) Testing and validation.
• Rating & Billing Testing and validation.
• Business Configuration (Free Unit,Promotion,Cost Control,Rateplan …) testing and validation.
• Customer Technical Support (Rating,billing,CX, Business Configuration).
• Support Production Orange’s Operation Team (BSCS integration IXR2).
• Validation of Changes on Orange Portal.
• Packaging of deliverables
Charging & Billing IN One 2.2 (CBiO 2.2)CBIO & BSCS Consultan

ERICSSON: Libya ALMADAR CBIO
Jan 2015 - Jan 2017
• BSCS Integration and System Tests (SIT & UAT).
• BSCS Business Configuration and Testing (Services , Rateplan , Promotion ,Free Unit ...).
• Integration and testing of Charging System solutions (CS 5.1).
• BSCS Integration With CS nodes (SDP,AIR,EMM,EMA ...)
• CX,Rating,Billing,Finance,Roaming and Interconect SIT (Sytem Integration Test) and UAT (User Acceptance Test).
• BSCS Billing & Rating Activity (Integration,Support,Testing ,Statistics, operations, performance ,Workaround Solution).
• PL/SQL and Shell scripting ( developpement,adaptation, Performance Test).
• Writing test cases and validation (technical and software) billing, rating, payment, provisioning….
• Define SIT/UAT testing strategy : Planning and writing scenarios and validation.
• Change Requests Management (Analysis and study).
• Design and development of new requirements for MBB (3G launch).
• Writing Solution's technical and functional specifications.
• Solution Implementation,Configuration and Testing.
• Analyze customer technology and define business requirements for BSCS Domain.
• Prepare HLD & LLD for billing domain & ensure alignment with other streams.
CBIO & BSCS Consultant

ERICSSON: Algeria Telecom LTE BSCS
Jan 2015 - Jan 2015
• Define UAT testing strategy : Planning and writing scenarios and validation.
• Functional and technical administration of the BSCS iX 4.0 environment.
• Studying, design and development of new requirements of 4G launch for Algeria Telecom CBiO 3
• Validation of RA,CX, AX, MX, ADMX.
• Writing test cases and validation (technical and software) evaluation functions, billing, rating, payment, provisioning….
• Fix and Validations corrective bugs and incidents detected in production.
• BSCS Integration and Unit Tests.
• BSCS Specification & Documentation.
• Shipments Installation and Testing.
• BSCS Solution Implementation,Configuration and Testing
• Design, implement, document, and maintain automated test cases used to execute acceptance and regression tests.
• Billing & Rating Activity (Support,Testing ,Statistics, operations, performance ,Workaround Solution).
• Analyze trends and propose corrective action.
BSCS Consultant& Back Office Support

TALAN Tunisia International: Qualification team
Jan 2012 - Jan 2015
• Writing Solution's technical and functional specifications.
• Change Requests Management (Solution Analysis, Feasibility study and development) .
• Writing and Implementing test books and validation scenario.
• Shipment Installation ,Testing and validation (CX, CMS, WS, Java Tools ...).
• Back office support activity (developpement ,Installation,Testing)
• Billing & Rating Activity (Testing ,Statistics, operations, performance ,Workaround Solution) .
• PL/SQL and SHELLscripting ( developpement,adaptation, Performance Test).
• Validation of WEB Applications
BSCS Consultant& Validation and Test Engineer

Orange Tunisia: Qualification team
Jan 2011 - Jan 2012
• Writing & Implementing test books and validation scenario.
• Shipment Testing and validation (CRM,CX,WS,Pos).
• Provisioning (GMD,KPSA) Testing and validation.
• Rating & Billing Testing and validation.
• Business Configuration (Free Unit,Promotion,Cost Control,Rateplan …) testing and validation.
• Customer Technical Support (Rating,billing,CX, Business Configuration).
• Support Production Orange’s Operation Team (BSCS integration IXR2).
• Support Rating (Monotoring, statistics, Rating_Rejection).
• Support Billing (Monotoring, statistics, Billing_Rejection).
• Support CRM, PLATINE (Mediation) and Provisioning System (KPSA).
BSCS Consultant

Alcatel-Lucent: Morocco Telecom
Jan 2010 - Jan 2011
• Integration Tester of Non-Kernel Batch :
o Preparation of test scenarios, running batch and report the errors to developers.
o User guide and operation manual preparation for using and integration.
• Non-Kernel BSCS Developer: ProC, SQL, PLSQL, shell :
o Part of a developer’s team to migrate Non-Kernel applications and batchused by MoroccoTelecom.
• Analysis and implementation of Non-kernel batch.
o Adaptation and performance improvement of existing Non-Kernel batch in different domain (Dunning, Billing, Payment, Promotion, Portability, Interface …)
• Reporting script (adaptation , integration, performance Test, SIT and UAT).
• PL/SQL and SHELL scripting
• Analysis, design and development of new Non-kernel solutions:
o Development of new packages, functions and procedures.
BSCS Consultant & Business Analyst

Alcatel-Lucent: BSCS IX MIGRATION MOBINIL – ORASCOM EGYPT
Jan 2009 - Jan 2010
• BSCS Configuration (Baseline Setup, Service configuration, Rate plan…)
• Rating and Billing configuration
• Configure and test the roaming agreements
• Integration tests on rating and billing
• Performance testing for all Rating and Billing modules (Fih, Rih, Rlh, Bch…)
• Change Request Implementation.
• Writing Solution's technical and functional specifications.
• Shipments Installation, Testing and Deployment.
• Participation in SIT (System Integration Testing), UAT (User Acceptance Test).
• Support client (installation, Integration, performance Test and Testing).
• Monitor Rating and Billing Process.
BSCS iX R2 Architecture definition

BILLCOM Consulting: BSCS iX TRAINING – Globacom
Jan 2008 - Jan 2009
• BSCS Configuration (Baseline Setup, Service configuration, Rate plan, systemscenarios, business scenarios …)
• Rating and Billing configuration
• Cost Control Configuration
• Promotion Configuration
• Free unit Configuration
• Roaming Configuration
• Monitor all Billing Process
• Provisioning and Dunning
• Monitor all Modules BSCS iX R2 (PX, EI, CX, …)
• Oracle Developer (Tuning, create triggers, procedures, views, cursor, …)
• Rating process responsible (FIH,FOH,RIH,RLH…etc)
• Performance testing for all Rating and Billing modules (Fih, Rih, Rlh, Bch…)
• PL/SQL and SHELLscripting ( developpement,adaptation, Performance Test).
BILLCOM Consulting: Mediation Training:
• Design and specification features of Platin mediation (collection, treatment "conversion, mapping, filtering ..." distribution) for Orange Tunisia.
• Study of the call scenarios in mediating Platin.
Project Graduation
COMPUTER PROGRESS
• Conception,Development of an ERP in the dispensary
Skills:
- BSCS V6,BSCS V7 and BSCS iX Experience (Migration ,Integration and Support)
- Overview SDPX
- Installation
- Integration
- Base line setup
- Business configuration
- Support
- Tuning & Performance Evaluation
- Operations Tasks
- ORACLE/PLSQL
- Database Administration
- Unix &Shell Scripting
- Change Requests Implementation
- Writing Solution's technical and functional specifications
- Shipments Installation, Testing and Deployment
Computer Ability:
• Microsoft Project , Microsoft Visio & Office
• Programming Language and Database: Oracle Database, SQL Server, PL/SQL,
• OS Platforms:Unix Solaris, Linux, Windows NT & XP
• Hardware & Network Maintenance
• Oracle Developer (Tuning, create triggers, procedures, views, functions...)

Études et formations

Education: Computer Programming Institute (June 2007)
Master Degree, Programmer (Tunisia)

Language:

English: Good writing, reading, and speaking ability.
French: Excellent writing, reading, speaking ability.
Arabic: Native Language.

Autres compétences

Education: Computer Programming Institute (June 2007)
Master Degree, Programmer (Tunisia)

Language:

English: Good writing, reading, and speaking ability.
French: Excellent writing, reading, speaking ability.
Arabic: Native Language.