a Randstad company

Techno-Functional Oracle EBS consultant. Deep knowledge of PL SQL and EBS data model.

Profil
Top-Skills
PL/SQL Oracle APEX Oracle Forms Oracle RAC Oracle DBA Oracle Data Guard Reporting Tool Oracle BI EE Oracle BI Publisher
Verfügbar ab
16.11.2022
Aktuell verfügbar - Der Experte steht für neue Projektangebote zur Verfügung.
Verfügbar zu
100%
davon vor Ort
25%
Einsatzorte

PLZ-Gebiete
Länder
Ganz Deutschland
Remote-Arbeit
möglich
Art des Profiles
Freiberufler / Selbstständiger
Der Experte ist als Einzelperson freiberuflich oder selbstständig tätig.

4 Jahre 7 Monate

2018-05

heute

Oracle Applications Developer & Support

Consultant
Rolle
Consultant
Projektinhalte

  • Develop extensions for Oracle Applications, which are used for internal management of Nato Base.
  • Migration of reporting system from Oracle Discoverer / Oracle Reports into Oracle Apex.
  • Developing new applications on Oracle Apex platform.
  • Suport for existing applications, by solving incidents reported by users.
  • Forms migration into 12c version.

Produkte
Oracle Database 11g Oracle Forms Oracle PL/SQL
Kunde
NATO
Einsatzort
Nato Base, Geilenkirchen, Germany
17 Jahre 3 Monate

2005-09

heute

Supporting prepaid system in Vodafone Albania and Albanian Mobile Communication

Support Engineer
Rolle
Support Engineer
Projektinhalte

  • Onsite support engineer, covering hardware and OS problems (25 servers, platform: HP 9000, RP series, shared storage VA7500, EVA 6000 series, OS platform: HPUX 11.11) for prepaid messaging system in Vodafone, Albania and AMC Albania.

Produkte
HP 9000 RP series shared storage VA7500 EVA 6000 series OS platform: HPUX 11.11
Kunde
Vodafone, Albania, AMC Albania
2 Monate

2021-06

2021-07

Cloning Oracle EBusiness Suite with platform migration

Technical Consultant
Rolle
Technical Consultant
Projektinhalte

  • Cloning Oracle EBusiness Suite R12.1.1 from Windows 2003 environment into RedHat Linux 7 environment.
  • Repair damaged data, mainly on multilingual tables, through datafixes.
  • Testing and documentation

Produkte
Oracle EBusiness Suite R12.1.1
Kunde
Kosovo Airport
Einsatzort
Kosovo
1 Jahr 3 Monate

2020-02

2021-04

Implementation of ERP Oracle EBS in Electrical Power Corporation in Kosovo

Techno-Functional Implementation Consultant
Rolle
Techno-Functional Implementation Consultant
Projektinhalte

Customer interviews and business processes analysis.

System functional analysis, tie business processes to EBusiness Suite process flows.

Reporting system functional analysis.

Technical analysis, design and installation of EBusiness Suite R12.1.3 technology stack in PROD and TEST environments.

Application configuration.

 

Modules:

  • General Ledger
  • Account Payables
  • Account Receivables
  • Fixed Assets
  • Cash Management
  • EBTax Management
  • Inventory
  • Purchasing

 

Patching application. 

Customization of applications including form personalization and database custom tables according to business needs. 

Configuration of reporting system (repository) Oracle Business Intelligence  

Configure applications security for each implemented module.

Data migration for modules: GL, AP, AR, CM, FA, HR.

Users and administrators trainings.

Develop custom functionalities for Oracle Assets according to local legislation of assets depreciation and revaluation.

 

Application infrastructure maintenance:

  • Clonning and refreshing environments (PROD, TEST)
  • Patching environments 

Continuous support

Produkte
Oracle EBusiness Suite R12.1.3 Oracle Database 11gR2 Oracle Business Intelligence 12c RedHat Linux
Kunde
Kosovo Power Electrical Corporation
Einsatzort
Kosovo
5 Monate

2017-05

2017-09

Installation of Loan Collection and Provision modules for ?Societe Generale? bank, Serbia subsidiary.

Consultant
Rolle
Consultant
Projektinhalte

  • Installation of ?Collecte? module, version 9.x (9.1.3 to 9.1.5.2) and ?Provision? module, versions 3.1.8, 3.1.10. 
  • Testing of workflow of these modules.
  • Bug fixing.
  • Creation of scripts in Oracle PL/SQL to automate several business processes an data flows

Produkte
Java Javascript Linux BASH scripting Oracle Database 12c Oracle DataGuard RedHat Linux Management software: JIRA Collecte? and ?Provision? modules
Kunde
auf Anfrage
Einsatzort
?Societe Generale? bank, Serbia subsidiary
13 Jahre 3 Monate

2004-03

2017-05

Supporting SCCP system in Vodafone Albania

Support Engineer
Rolle
Support Engineer
Projektinhalte

  • Onsite support engineer, covering hardware and OS problems for SCCP system in Vodafone, Albania.

Produkte
Hardware platform: Alpha ES40 OS platform: OpenVMS and 15 servers platform: HP 9000 RP series shared storage VA7500 EVA 6000 series OS platform: HPUX 11.11
Kunde
Vodafone, Albania
5 Monate

2016-12

2017-04

Build a Business Process Management Software

Project Technico-functional Leader and main database developer.
Rolle
Project Technico-functional Leader and main database developer.
Projektinhalte

  • Build from scratch the software for managing business processes workflows, using Oracle Database PL/SQL programming for implementing business logic and Java for front-end user interface.
  • The system was used mainly for managing complex workflow of documents, reducing their processing time up to 70%.
  • In this project my role was the techno-functional leader and also main database developer.

Produkte
Oracle Database Oracle PL/SQL Java Javascript RedHat Linux
Kunde
Albanian General Elektrical Power Corporation
4 Monate

2016-01

2016-04

Asset revaluation according to Albanian legislation - Oracle EBusiness Suite R12

Project Technico-functional Leader
Rolle
Project Technico-functional Leader
Projektinhalte

Build asset revaluation functionalities according albanian legislation revaluation procedures.

Build main functionalities for: 

  • Initial revaluation transactions which will credit initially the revaluation reserve.
  • Monthly revaluation transactions which will adjust revaluation reserve according to Albanian legislation for each type of transaction, like period depreciation, retirement, transfer between cost centers, etc.
  • Automate ?Create accounting? for revaluation transaction.

Produkte
Oracle EBusiness Suite R12.1.3 Oracle Database 11gR2 Oracle DataGuard Oracle Business Intelligence 11g RedHat Linux Java / Java script
Kunde
Electrical Power Transmission Operator
3 Jahre

2013-01

2015-12

Financial Systems - Oracle EBusiness Suite R12

Project Technico-functional Leader
Rolle
Project Technico-functional Leader
Projektinhalte

  • Team Leader 
  • Customer interviews and business processes analysis.
  • System functional analysis, tie business processes to EBusiness Suite process flows.
  • Reporting system functional analysis.
  • Technical analysis, design and installation of hardware (Virtualized blades HP BC series, RedHat) and software components. 
  • Installation of EBusiness Suite R12.1.3 technology stack in PROD and TEST environments.
  • Application configuration.


Modules:

  • General Ledger
  • Account Payables
  • Account Receivables
  • Fixed Assets
  • Cash Management
  • Tax Management
  • Human Resources
  • SelfService Human Resources
  • Inventory
  • Purchasing

 Patching application.


Functional configurations

 

Configuration of HR module

  • Setting up business group and security profile.
  • Setup organizations, jobs and positions (setup also DFF to fulfill customer requirements).
  • Configure all assignment requirements (full time / part time / contingent worker)
  • Temporary realignment (person is assigned to a position but temporarily filling another position).
  • Setting up Special Information Types for requirements that cannot be fulfilled by standard forms functionalities.
  • Setting up task flows.
  • Setup competencies, qualifications, historical employment, pensions, work seniority.
  • Setup security model using security profiles (using either assignment organization as "top node" of security hierarchy or a static one). Schedule concurrent request for security maintenance.

 

Configuration of GL module using UAM standards:

  • Ledger
  • Chart of Accounts (6 segments)
  • Configure the Business group, GRE/Legal entity, Operating Unit in Organizations Form.
  • Calendar including adjusting periods.
  • Currencies
  • Accounting Methods (using custom method for Inventory Costing from Cost Management module)
  • Approval workflows (using people from HR installed in shared mode).
  • Setup security (using security by ledger model, valueset security, qualifying "Cost Center" segment as "management segment")

  

Configuration of AP

  • Setup vendors and vendor sites.
  • Configure operating units
  • Setup financial and payables options.
  • Setup payment terms

 

Configuration of AR

  • Setup customers and customers sites.
  • Configure operating units
  • Setup financial and receivables options.
  • Setup memo lines
  • Setup payment methods, documents

  

Configuration of CE:

  • Creation of 3 different taxes and making them available for transactions.

 

Configuration of FA

  • Categories, Locations, Asset Keys
  • Books (corporate and fiscal for each operating unit).
  • Depreciation methods, prorate/retirement conventions.
  • Setup security by book model (using security profiles)
  • Configuration of functionalities not available in the module: Asset Transfer between operating units (between corporate books).

 

Configuration of INV

  • Item templates
  • Item categories and organization assignments
  • All Key and Descriptive flexfields
  • Inventory organizations, subinventories, stock locators.


 Configuration of users, menus and responsibilities.

 

Customization of applications including form personalization and database custom tables according to business needs.

 

Configuration of reporting system (repository) Oracle Business Intelligence 11g and build around 100 custom reports.

 

Build interfaces with external Payroll Management systems (Interface HR-Payroll, Payroll-GL).

 

Design and implementations of backup and disaster/recovery strategies (RMAN, Data Guard).

 

Configure applications security for each implemented module.

Data migration for modules: GL, AP, AR, FA, HR.

Users and administrators trainings.

 

Develop custom functionalities for Oracle Assets according to local legislation of assets depreciation and revaluation.


Data migration:

GL:

  • Chart of accounts (data loader).
  • Account opening balances (data loader).

 

AP:

  • List of vendors (interface tables)
  • Vendor opening balances (data loader).

 

AR:

  • List of customers (interface tables)
  • Customer opening balances (data loader)

  

FA:

  • List of all assets for each corporate book (two books for each operating unit ? 11 OU in total) (interface tables)
  • Asset financial information (NBV, accumulated depreciation, etc) for each book (interface tables)

 

HR:

  • List of organizations, jobs, positions (data loader).
  • Hierarchy of organizations (data loader)
  • List of employees including information configured to be stored in DFF (HR APIs),.
  • Assignment of each employee (HR APIs),
  • All information which was configured to be stored in SITs (data loader)

 

INV:

  • Item Categories (data loader)
  • Items (interface tables)
  • Item assignments (interface tables)

 

Application infrastructure maintenance:

Clonning and refreshing environments (PROD, TEST)

Patching environments

 

Continuous support

Management of TETRA support team for end-users.

Produkte
Oracle EBusiness Suite R12.1.3 Oracle Database 11gR2 Oracle DataGuard Oracle Business Intelligence 11g RedHat Linux
Kunde
Electrical Power Transmission Operator
2 Jahre 1 Monat

2010-12

2012-12

Akunet Deployment over Country

Business Consultant
Rolle
Business Consultant
Projektinhalte

  • Customization on NFA workflow procedures of management software according to business processes (AKUNet application).
  • Managing the rollup process for NFA on-line and off-line sites (router, switches, wi-fi switch, off-line replication servers, servers, smart card readers, laptops)
  • Analysis and implementation of reporting system: Oracle Business Intelligence

Produkte
Java platform for software development Oracle Database 11gR2 Oracle DataGuard Oracle Business Intelligence 11g RedHat Linux
Kunde
National Food Authority
7 Monate

2010-02

2010-08

Besa Fund

Project Technico-functional Leader
Rolle
Project Technico-functional Leader
Projektinhalte

Team Leader 

  • Design and installation of hardware (Proliant blade platform, RedHat Linux 5.0).
  • Installation of EBusiness Suite 11.5.10.2 technology stack in PROD and TEST environments.
  • Application configuration of modules:
  • General Ledger
  • Account Payables
  • Fixed Assets
  • Cash Management 

Customization of applications, form personalization 

Configuration of reporting system in Oracle Business Intelligence 10g (configuration of repository and data warehouse). Build and customize reports according to user requirements. 

Build interfaces with external Loan Management System

 

Application infrastructure maintenance:

  • Clonning environments (PROD, TEST)
  • Patching environments

 

Design and implementations of backup and disaster/recovery strategies (RMAN, Data Guard).

Data migration

User trainings

Produkte
Oracle EBusiness Suite 11.5.10.2 Oracle Database 9i Oracle DataGuard Oracle Business Intelligence 10g RedHat Linux 5.0
Kunde
Besa Fund
1 Jahr 9 Monate

2008-11

2010-07

Anti-Money Laundering System

Consultant
Rolle
Consultant
Projektinhalte

  • Installation of servers (Platform: HPUX, Windows 2003 on HPUX virtual server environment). Installation and customization of Oracle Database 110g.
  • Configure system security, auditing feature.
  • Installation, configuration and maintenance of Anti-Money Laundering System.
  • Configuring reporting system and building reports.
  • Building interfaces with external systems.
  • Design and implementations of backup and disaster/recovery strategies.
  • User trainings

Kunde
Financial Intelligence Unit
3 Jahre 9 Monate

2006-11

2010-07

Resource Management Information System

Consultant
Rolle
Consultant
Projektinhalte

Activities performed:

Design and installation of hardware (Proliant platform, Windows 2003).

 

Installation of EBusiness Suite 11.5.10.2 technology stack in PROD, TEST, DEV environments.

  • Application configuration. Modules:
  • General Ledger
  • Account Payables
  • Account Receivables
  • Fixed Assets
  • Cash Management
  • Human Resources
  • SelfService Human Resources
  • Inventory

 

Functional configurations

 

Configuration of HR module

  • Setting up business group and security profile.
  • Setup organizations, jobs and positions.
  • Configure all assignment requirements (full time / part time / contingent worker)
  • Temporary realignment (person is assigned to a position but temporarily filling another position).
  • Setting up Special Information Types for around 20 different requirements which does not come with the system, like disciplinary measures, history of prosecutions, previous career related to military, etc.
  • Setting up task flows used in People main form.
  • Setup competencies, qualifications, trainings, pensions, etc.
  • Setup event bookings.
  • Setup security model using security profiles (using either assignment organization as "top node" of security hierarchy, a static one or a list of organizations).
  • Security maintenance.
  • Recruitment process (3 different phases).
  • Setup people leave schedules (yearly, sick, additional granted leave, etc).

 

Configuration of HR Self-Service module:

  • Setup appraisal workflow (.jsp pages).
  • Configure templates in RTF format and upload in the system.
  • Setup security

  

Customization of applications including form personalization, design database custom tables, stored procedures and triggers to meet business needs.

 

Configuration of reporting system in Oracle Reports and Oracle Discoverer and build around 50 custom reports.

 

Build interfaces with external systems.

 

Application infrastructure maintenance:

  • Clonning environments (PROD, TEST, DEV)
  • Patching environments

 

Design and implementations of backup and disaster/recovery strategies (RMAN, Data Guard).

Configure applications security, auditing feature.

Data migration for AP, AR and HR module

Configure applications security, auditing feature.

 

User trainings.

Produkte
Oracle EBusiness Suite 11.5.10.2 Oracle Database 9i Oracle DataGuard Oracle Discoverer Microsoft Windows 2003
Kunde
Albanian State Police
1 Monat

2008-06

2008-06

Installation of Oracle database for Trouble-Ticket system

Consultant
Rolle
Consultant
Projektinhalte

  • Installation of hardware platform Alpha ES40
  • Installation and configuration of Operating System Compaq Tru64 Unix
  • Installation and configuration of Oracle Database 9i

Produkte
Oracle Database 9i Compaq Tru64
Kunde
Albanian Telecom
5 Monate

2003-01

2003-05

RTGS management

Consultant
Rolle
Consultant
Projektinhalte

  • Installation of EBusiness Suite 11.5 technology stack.
  • Consultancy, support and user training for modules: GL and AP.
  • Data migration

Produkte
Oracle EBusiness Suite 11.5. Oracle Database Oracle Standby Database Microsoft Windows 2000 Server
Kunde
Bank of Albania

more Projects on request

2001

Tirana University

graduated in "Computer Sciences, Informatics"


Specializations

2016-12

  • Oracle Database 12c Certified Implementation Specialist
  • Oracle E-Business Suite 12 Financial Management Certified Implementation Specialist: Oracle Payables
  • Oracle E-Business Suite 12 Financial Management Certified Implementation Specialist: Oracle Receivables


2014-11

  • Oracle Linux Certified Implementation Specialist
  • Oracle PL/SQL Developer Certified Associate
  • Oracle E-Business Suite 12 Financial Management Certified
  • Implementation Specialist: Oracle General Ledger


2012-09

Certification: Oracle EBS R12 Support Specialist


2011-01

  • Project Management Training organized by AITA organization.
  • Benefits 21 PDU toward PMP certification.


2010-12

Oracle Business Intelligence Foundation 10 Certified Implementation Specialist


2010-05

Certification: CompTIA CTT+ Certified Classroom Trainer


2009-12

  • Certification: CSA HP HPUX 11i v3
  • Certification: CSA HP Open VMS v8
  • Certification: Oracle Support Champion


208-06 - 2008-07

racle Financials R12 configuring and Administering (modules GL, AR, AP, CM, FA).


2007-11

  • ISV MIGRATION CENTER, Turkey: Oracle Identity Management workshop
  • ISV MIGRATION CENTER, Turkey: RAC Validation workshop.


2007-06

Certification: Oracle Presales Champion.


2007-04

Oracle BPEL Training


2007-03

Certification: Oracle Certified Associate.


2006-11 - 2006-12

Oracle Financials 11i Bootcamp.


2005-11 - 2005-12

Microsoft Navision Administration


2005-09

Certification: HPUX System Administration (I and II)


2004-02

Certification: OpenVMS System Administrator (I and II).


2003-03 - 2003-04

Certification: Tru64 UNIX V5.0 Sys Admin, Support & Integration.


2002-02

Certification: APS: Compaq System Products Architecture.


2001-01- 2001-02

Course in Siegen University.

Subject: ?Improving the science in Tirana university?.

English fluent
French good

Top Skills
PL/SQL Oracle APEX Oracle Forms Oracle RAC Oracle DBA Oracle Data Guard Reporting Tool Oracle BI EE Oracle BI Publisher
Produkte / Standards / Erfahrungen / Methoden
HR GL AR AP CE EBTax FA INV PUR Forms/Reports Oracle BI Oracle Apex Oracle Discoverer Oracle Database Administrator

Summary of career development and experience

2013 ? present

Role: EBS R12 Techno-Functional Consultant. 


Tasks:

Expanded into the other functional areas:

  • AR
  • PUR
  • INV
  • Oracle Apex


2010 ? 2013

Role: EBS 11i Techno-Functional Consultant. 


Tasks:

Beside HR module, expanded into the functional areas financial modules:

  • GL
  • AP
  • CE
  • FA
  • Started working with newly released Oracle BI 10g.


2006 ? 2010

Role: EBS 11i Techno-Functional Consultant. 


Tasks:

Beside technical experience, expanded into functional consultant, HR module for the biggest HR project in Albania for Albanian State Police. Configured also self-service HR, mainly for appraisals.

  • Technical configuration for database (standby database, cloning, backup, interfaces).
  • Oracle Reports and Oracle Discoverer developer.


2002 ? 2006

Role: Unix engineer (Compaq Tru64, HPUX)., Hardware engineer (Compaq Alpha Server, HP mid-class (9000 series), also Compaq Proliant servers)


2001 ? 2002

Role: EBS 11i Database Administrator.

Company: Computer & Copier Systems. 


Project

Customer: Bank of Albania.


1999 ? 2001

Role: Programmer for Financial Software Suite ? HR Module

Customer: Datech ltd software house company. 


Tasks:

  • Using Gupta/Centura and SQL Base database.
  • Preparation of Voter's list for elections of October 2000.


Applications

Financial Administration:

Oracle E-Business Suite (11i, R12)


Applications: 

General Ledger, Account Payables, Account Receivables, Cash Management, Fixed Assets, Inventory, Human Resources, Self-service HR.


Technology stack: 

Installation, maintenance and patching, cloning, Oracle Forms.

 

Microsoft Business Solution 

Navision (4.0, 5.0) ? basic knowledge


Reporting

  • Oracle Business Intelligence (10g, 11g, 12c)
  • Oracle Reports
  • Oracle Discoverer
  • Oracle BI Publisher
  • Crystal Reports


Management tools

  • Microsoft Project
  • JIRA


Other software tools

  • Oracle Workflow
  • Oracle BPEL
  • NewGen OmniDoc,
  • NewGen OmniFlow
  • NewGen OmniScan
  • Kofax Scan with VRS

Other

NATO Security Clearance Certificate (valid until  June 2022, enrolled for renewal for another 5 years period).


Job History

2017-07 - today

Role: Freelancer, working as contractor 

Customer: NATO base in Geilenkirchen, Germany, registered under German Taxation Law


2007-08 - 2017-05

Customer: TETRA Solutions


2001-11 - 2007-08

Customer: Computer & Copier Systems (CCS)


2001-04 - 2001-11

Customer: First Investment Bank


1999 -07 - 2001-04

Customer: Datech ltd.

Betriebssysteme
UNIX OpenVMS RedHat Linux Oracle Linux CentOS Windows Server
NT, 2000, 2003, 2008
Novell 5.x
Programmiersprachen

Programming and scripting languages

  • Oracle Forms (10g, 11g, 12c)
  • Oracle PL/SQL
  • Java SPRING, Apache, Maven, JavaScript,
  • Oracle Apex
  • SQLWindows (Gupta, Centura)
  • Visual Basic 6.0

Datenbanken
ORACLE
8i, 9i, 10g, 11g, 12c, 18c, 19c
Microsoft SqlServer
2000, 2005, 2008
Centura SQLBase
Ihr Kontakt zu Gulp

Fragen? Rufen Sie uns an +49 89 500316-300 oder schreiben Sie uns:

Jetzt bei GULP Direkt registrieren und Freelancer kontaktieren