Somphathay - Consultant technique PL SQL ORACLE

Oracle 12

PROJECT RELATED SKILLS

Agile Methodology
Data Modelling
Technical Design
Technical Analysis
Programming
Testing
Involved in the development, testing, maintenance and support of an Invoice Creation application, from the design of the data model in 3NF to the development of the application using PL/SQL. A web interface was developed by an external company and TIBCO web services along with Oracle packages were used to communicate between the web interface and the oracle backend solution.

Involved in the development, testing, maintenance and support of a C++ program that was used to decode binary files containing data from the cashier system.
Use of SQL Loader to load the data into an Oracle database and PL/SQL procedures and packages to manipulate this data and transform it so that it could be send to different legacy applications such as SAP Retail, Datamart marketing and different suppliers.

Oracle 9i

Creation of a new Translation workflow system to cater for the growing need of the company. Use of Oracle Workflow and PL/SQL.
Support of the databases in the different environments.

Oracle 10g

Datawarehouse project :Involved in the creation and population of a datawarehouse to support the Credit Risk Department ( BASLE 2 ) at Dexia Bank. Involved in the design of the 3 tiers-architecture and the implementation of the flow to extract and populate the datawarehouse. Development done with Business Object Data Integrator and PL/SQL to extract and transform the data.

Development of import/export applications using Visual Basic. These applications are used to synchronize Partners’ data with the company’s data to be used in Siebel.

Visual C++

Development of an application that describes the complete trail of a leased line from a specific point in the trail. This application is to help field teams find out if a cross connection within a network equipment is actually used. If the cross connection was no longer used, the field team could potentially get rid of it and hence free it up for another trail.
The tool was developed in Visual C++ with CORBA interfaces to some Oracle databases.

Customization of Siebel 2000 interfaces to facilitate the sales of HP products and services.
Use of standard Siebel 2000 tools and Visual basic to develop the screens. Modifications of standard data model with extension tables and columns whenever necessary.

Oracle 9i

Implementation of a workflow process to automate the translation of documents in multiple languages. Involved from the design of the Data model in the 3NF and the functional analysis to the development and testing of the application.
Involved in the development of the workflow using Oracle Workflow 2.6 to define the step by step process of the translation and the interaction with the legacy systems.
Use of Oracle Internet File System to store the different documents throughout the translation process.
Use of JAVA and PL/SQL to interface the workflow with IFS and the Graphical User Interface which is developed in JAVA.
Use of Designer to store and document the data model.

Oracle 8i

Datawarehouse project : Involved in the creation and population of data marts using PL/SQL to support the pharmaceuticals Sales team with relevant sales figures. Extraction of information coming from different sources using Datastage V4 to populate the different data marts.
Heavy use of PL/SQL scripts and SQL scripts to complement Datastage.
Involved in the Administration of Oracle 8i databases in the development, test and production environments for the datawarehouse. Also involved in the tuning for the different environments.
Creation and maintenance of databases to support Siebel Pharmaceuticals tools using Oracle Enterprise Manager tools.

Oracle 8i

Implementation of an application using Forms 6.0 to record and manage Secondary Surveillance Radar codes used to identify aircrafts.
Implementation of statistics reports that deals with the number of aircrafts crossing the European sky. Use of PL/SQL and Discoverer r3.1 to define the data to be displayed and HTML to display the results.
Beta test of Discoverer 3i, installation and creation of small reports.

Oracle 7.3, 8i

Implementation of a Number Portability application, which will enable a person to switch telecom operator and still keep the same telephone number. This project was split in 2 phases.
The first phase consisted of a stand-alone application that was to be used as an emergency solution.
Involved in the creation of the data model in the 3NF and the writing of the Technical specifications.
Involved in the development of the user interfaces and the testing of the application.
Use of Designer 2000 r2.1 to create the data model, to generate the DDL creating the database and to generate the first cut of the module.
Use of Developer 2000, Forms 5 and reports 3 to develop the application.

The second phase consists of integrating the Oracle Service Delivery Platform together with Oracle Workflow to implement the final solution.
Followed an introduction to Oracle workflow.
Involved in the functional design and in the development of interfaces between the legacy systems ( systems belonging to Belgacom ) and the Oracle Service Delivery Platform.
Heavy use of PL/SQL and SQL Loader to write the interface.