Chaker - Consultant ORACLE DISCOVERER
Ref : 160421G001-
Domicile
2074 TUNIS (Tunisie)
-
Profil
Consultant, Consultant technique, Consultant fonctionnel (55 ans)
-
StatutFreelance
-
Oracle Application Manager + IT manager (Consultant)
Position in Company Company Name Company Industry LocationJan 2017 - aujourd'hui -
Oracle Application Manager (Consultant)
SWICORP Banking/Financial Services Tunisia- TunisJan 2016 - aujourd'huiAchievement
-Upgrade EBS DB from 11g to 12c
-KSA tax implementation
From Jul 2013 ➔ 31 Mar 2016
Oracle Applications Manager (employee)
SWICORP -
Position in Company Oracle Applications Manager
Company Name SWICORP Company Industry Location Banking/Financial Services Saudi Arabia (Riyadh + Jeddah)Jan 2007 - Jan 2013Work 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 -
Position in Company Oracle application consultant 11i (OE Module), IT Manager
Company Name RANDA - Hchicha Group –Tunis Company IndustryJan 2004 - Jan 2007Company 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 -
Position in Company Oracle application consultant 11i (OE Module)
Company Name Jasmine Engineering- Hchicha Group –TunisJan 2002 - Jan 2004Company 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 -
IT Analyst & Developer
Group(ITG)Jan 2001 - Jan 2002Information Technology services
Technical Expertise JAVA, Visual Basic 6, SQL server
Synchronization between server and cashier terminal (CASH PRO) -
Software Developer
Societe Informatique et Communication(SINCOM)Jan 1996 - Jan 1998Information 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 -
SWICORP Banking/Financial Services Tunisia- Tunisaujourd'hui
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 -
Functional + DBA duty
SWICORP Banking/Financial Services Tunisia- Tunisaujourd'huiAchievement
-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 -
IT Analyst & Software Developer
(Tunis & Belgique)Societe Tunisienneaujourd'huiDeveloppement Informatique(STDI)
Traffic management system for MIMA FILMS company on Belgium (Visual Basic 6 + SQL Server)
Information Technology services
IT Analyst & Software Developer
GPAO
Orders management system
Traffic management system
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 10 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 Months
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
Office 365 (MS Access, MS Excel, MS Word, MS PowerPoint)… Expert More than 10 years Actually
Languages
Language Skill Level Years of Experience Last Used
Arabic Expert
French Expert
English Fluently
Training
Oracle Financial Modules (AP (Oracle Payables), CE (Oracle Cash Management), GL (General Ledger)) : INTRACOM JORDAN
OTD -Training for R12.x Oracle E-Business Suite Essentials for Implementers (Oracle)
OTD -R12.x Install/Patch/Maintain Oracle E-Business Suite
Certifications
ITIL-F (Information Technology Infrastructure Library)
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 10 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 Months
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
Office 365 (MS Access, MS Excel, MS Word, MS PowerPoint)… Expert More than 10 years Actually
Languages
Language Skill Level Years of Experience Last Used
Arabic Expert
French Expert
English Fluently
Training
Oracle Financial Modules (AP (Oracle Payables), CE (Oracle Cash Management), GL (General Ledger)) : INTRACOM JORDAN
OTD -Training for R12.x Oracle E-Business Suite Essentials for Implementers (Oracle)
OTD -R12.x Install/Patch/Maintain Oracle E-Business Suite
Certifications
ITIL-F (Information Technology Infrastructure Library)