Chaker - Consultant ORACLE DISCOVERER

Professional Experience

Date:
Position in Company
Company Name
Company Industry
Location
Work Description
From Apr 2017 till Today
Oracle Application Manager + IT manager (Consultant)
SWICORP
Banking/Financial Services
Tunisia- Tunis
Achievement
-Oracle Cloud Training (Infrastructure) with Oracle Cloud team
-Prepare IT infrastructure (VMs + Network…) at Oracle Cloud
-Testing the move of EBS ERP 12.1.3 from on-prem to cloud by keeping same OS
(windows)
-After many iterations move of the PROD instance from on-prem to Oracle cloud
infrastructure
-OS migration (from windows to LINUX at cloud side) with oracle P2P team
-Move DB from VM to DB system with oracle P2P team
2 | P a g e
Date:
Position in Company
Company Name
Company Industry
Location
Work Description
Date:
Position in Company
Company Name
Company Industry
Location
Work Description
-Publish EBS R12.1.3 thru Internet (******** )…
-Optimization & security (Cloud LB/Firewall implementation)
-Documentations
From Apr 2016 till year end
Oracle Application Manager (Consultant)
SWICORP
Banking/Financial Services
Tunisia- Tunis
Achievement
-Upgrade EBS DB from 11g to 12c
-KSA tax implementation
From Jul 2013 ➔ 31 Mar 2016
Oracle Applications Manager (employee)
SWICORP
Banking/Financial Services
Tunisia- Tunis
Functional + DBA duty
Achievement
-Virtualization (using Hyper-V Manager-Windows 2008)
-OS Migration from Windows server 2003-32bit to Windows server 2008 R2 64bit
-Upgrade EBS release version from 12.0.6 to 12.1.3
-Upgrade Oracle database version from 11.2.0.3 to 11.2.0.4
-Setup new features for appropriate module
-Cloning (Database 11.2.0.4 + Application R12.1.3)
-Patching
-Upgrade Discoverer Desktop 10.1.2.54.25 to Oracle Fusion Middleware 11.1.1.3.0
-Cold Backup (*.VHD database and application files)
3 | P a g e
Date:
-Documentations
-Using Metalink support (requests + documentations+ forums) to fix issues
- Financial reports Translation from English to Arabic language (for Saudi
government)
-XML Publisher
From November 2007 ➔ Jun 2013
Position in Company Oracle Applications Manager
Company Name SWICORP
Company Industry
Location
Banking/Financial Services
Saudi Arabia (Riyadh + Jeddah)
Work Description Achievement
-Participate on Oracle Applications implementation Release 12.0.6 with KSA oracle
Partner for Six legal entities(GL,AP,AR,CE,FA,PA,I-EXPENSE,OTL,HRMS,
PAYROLL,…)
-Analyze and implementation discoverer reports related to financial, projects, Human
resources, Payroll…
-Analyze and implementation of PLSQL package to import data from legacy systems
into oracle applications (Interface tables)
Responsibilities
Functional requirements gathering and definition
Software system Configuration and adaptation for organization need and request,
Create and develop system test scripts and test plans.
Data conversion and developed interfaces from legacy to new system,
End-users training
Develop and prepare users guides
Develop specific API and requests.
Solve technical and functional issues
Patching (upgrade)
Technical Expertise
PLSQL (Toad)
Forms & Reports
Discoverer administration & user and Business intelligence
4 | P a g e
Oracle Interface Tables (GL, AP, AR, PA, CE, HRMS, I-EXPENSE, OTL…)
Metal ink support for critical issues
Oracle applications Desktop Integrator
Data loader…
Oracle Database
Upgrade
Cloning
Patching
Database Tuning
Apps functionalities
Date: Jun 2004 – October 2007
Position in Company Oracle application consultant 11i (OE Module), IT Manager
Company Name RANDA - Hchicha Group –Tunis
Company Industry
Work Description
Food processing industry
Re develop a specific OE(Commercial) module
Develop all the necessary interface tables to integrate with Oracle application
Develop API, Build Reports, discoverer reports…
End users training and assistance
Date: October 2002 – Mai 2004
Position in Company Oracle application consultant 11i (OE Module)
Company Name Jasmine Engineering- Hchicha Group –Tunis
Company Industry Information Technology services
Work Description Set up Oracle application 11i (INV, OE, AR, AP, GL )
Develop new OE external module (Gestcom) and link it to oracle system
Develop API package to link between Oracle ERP (INV) and Coswin ERP
Develop API, Build Reports, discoverer reports…
Training and Assist end users
5 | P a g e
Date:
Position in Company
Company Name
Company Industry
Work Description
Date
Position in Company
Company Name
Company Industry
Work Description
Date
Position in Company
Company Name
Company Industry
Work Description
Mars 2001 – August 2002
IT Analyst & Developer
Information Technology Group(ITG)
Information Technology services
Synchronization between server and cashier terminal (CASH PRO)
Technical Expertise
JAVA, Visual Basic 6, SQL server
January 1998 – December 2000 (Tunis & Belgique)
IT Analyst & Software Developer
Societe Tunisienne de Developpement Informatique(STDI)
Information Technology services
IT Analyst & Software Developer
GPAO
Orders management system
Traffic management system
for MIMA FILMS company on Belgium (Visual Basic 6 + SQL Server)
July 1996 – January 1998
Software Developer
Societe Informatique et Communication(SINCOM)
Information Technology services
Conception and setup an accounting project
Conception and setup a commercial project
Conception and setup export-import project (transportation company)
Visual basic + Microsoft Access
6 | P a g e
Education
Institution: ISG (INSTITUT SUPERIEUR DE GESTION TUNIS)
Location: Bardou, Tunisia
Completion Date Jun 1996
Degree, Major Master's degree – Information Systems
Skills
Skill Skill Level Years of Experience Last Used
Oracle business suite 12.1.3-12.0.6
Oracle application 11.0.3
(GL.AP.AR.FA.CM, I-EXPENSES,
HRMS, OTL, PA, PAYROLL…)
Expert
More than 12 years Actually
Oracle Discoverer 11g,10g, 4i, 3
(admin and user)
Expert More than 10 years Actually
Data load Expert More than 10 years 3 month
Oracle PLSQL+SQL Developer Expert More than 10 years Actually
Oracle applications Desktop
Integrator
Expert More than 10 years 7 month or less
Metalink support
Oracle application Cloning
Patching+Migration
Expert
Expert
Expert
More than 10 years
Around 1 year
Around 1 year
Actually
Actually
Actually
MS Access, MS Excel, MS Word,
MS PowerPoint…
Expert More than 10 years Act