Necima - Consultant SQL

EMPLOYMENT HISTORY

March 2014 to present
Tunisie Telecom, Tunisia

BSCS Support
Capgemini, Tunisie Telecom, Tunisia, May 2008 to present.
BSCS iX R2 Migration Project, Consultant, Computing Engineer
 Designing and implementing Mobile, fixed and data networks solutions
 Providing technical support to UAT/Training teams
 Making trainings to Tunisie Telecom staff.
 Contribute in Workshop about mobile and network architectures.
 Writing functional specification document (design of solutions related to mobile, fixed and data markets)
 Designing and implementing new features (using Shell scripts, SQL scripts, Centura online module, Pro*C batches, APL language)
 Creating test plans and performing tests for rating, customer management (GSM)
 Fixing anomalies related to existing features (using Shell scripts, SQL scripts)
 Design and implementation of an interface Application between oracle finance and BSCS iX system. This is a Pro*C application that is used for generating billing and payment files for oracle finance.
 Design and implementation of an interface Application between Simplus and BSCS iX system. This application is used for generating resources for Simplus application
 Design and implementation of a deactivation application. This application is used for deactivating the contracts and their services which haven’t been successfully activated on the HLR.
 Design and implementation of an interface application between all extern payment systems (SNE, Post, Bank, Actel, USSD) and BSCS iX system. This is a Pro*C application that is used for adapting the file format of the difference payment sources to the PIH file format
 Updating of the SFS payment document according to the operator needs
 Customization of the PIH process
 Design and implementation of an interface application between the bank and the operator for direct debit (IOH customization, implementation an interface application between SNE and BSCS, implementation of an application for generating domiciliation files to the bank)
 Implementation of collect and processing workflows for processing fixed and data files generated by the different network equipments (IXMediation)
 CX customization (jsp files)
 Customization of non kernel RA interface (dll files)
 Design and implementation of the BSCS iX online module.
 CX (Customer Center) customization. Adding functionalities to CX throw new external JAR and XML Bundle files.
 Writing of detailed design documents, installation manuals and exploitation manuals
 Implementation of baseline setup scripts and rate plans for commercial offer’s configuration “fixed market and data”
 Writing system functional specifications document for Standing order (Direct debit)
 Implementation of pre-billing scripts for specific needs
 Creating test plans and performing tests for fixed and data markets (customer management, commercial offers, interface between BSCS and external systems)
 Implementation of Customer management solution for fixed and data markets (web services, interface between ESB and BSCS,…)

High institute of accounting, Tunisia, Feb 2008 to May 2008
University Teacher (TOA (Merise) and Operating Systems)

SOTELEC, Tunisia, August 2007 to May 2008
Systems Developer

INFOSYSTEME, Tunisia, June 2007 to July 2007
Systems Developer

BSCS Expertise
Versions of BSCS: BSCS iX R2
Trainings: BSCS iX Overview, 7 days, by BILLCOM CONSULTING in Tunisie Telecom training centre, 2008.

Areas of BSCS: Java/JSP, NK Development, CX (customization),IXMediation Development, PIH && IOH (customization), Commercial Offer development, Accounting, payment, RA, Database scripts (SQL, PL/SQL), AR, Pro*C, Centura.