Elie Geagea

Software Analysis, Database, Design, Development, Quality Assurance, Implementation, Support and Misc.
•Development of HR project for Managers KPI (Key Performance Index) / CPD (Country Performance Driver).
• Development of HR project for Agents Sales-Commissions project .
•Redevelopment and improvement Ads sales program to support Unicode (Delphi XE3).
• Development of Distribution management project.
•Development of DSS project (Decisional Support System) to consolidate periodically sales data from most of AWI international branches. The database warehouse built was Oracle10g and the end user Ad-hoc tool was Oracle BI-Discoverer.
•Design and Implement AWI TV Oracle database for Display Ads filtering.
•Development and improvement of general AWI Intelligent Reporting tool.
•Redevelopment of Accounting module.

DBA tasks, Replication, SQL Tuning, SQL Developing
•Development of most of the SQL part of “PACE” retail service application (it uses PDA interface to consolidate the client “The Home Depot” stores daily surveys data collected by over 2000 Reps) for ‘enfoTrust.com’ (US co.)
•Design and implement from scratch 2 database models “Telemetry” and “Ad Hoc Reporting” using MS-Visio and Sybase Power-Designer with SQL Server 2005.


2004 Profiles (PIMS) Dbayeh-Lebanon
Firebird Training Courses
•Giving advanced training courses on mastering Firebird database.

Mainly involved in the design and coding of big retail project: ‘Pricing’
•Implement major and critical projects sources codes (base classes, functions library and procedures) using Delphi4-7 and Oracle 8i-9iR2
Clients hotline and on site supports (France):
‘Carrefour’, ‘Auchan’, ‘Monoprix’, ‘Decathlon’ and ‘Castorama.

Data Integration and Migration - Team Leader
•Major part of the design and data model of ‘Soft Suite’ .Net project: ‘Referential’, ‘Pricing’, ‘Promo’, ‘Workflow’ and ‘Query Builder Engine’.
•Implement the major databases parts (tables, indexes, triggers, constraints, data dictionary, etc…) and control procedures under Oracle 9iR2 PL/SQL.

Successfully leading and implementing several critical data Integration and migration processes.
Many clients and among are ‘GLD (group Louis-Delhaize Europe)’ and ‘Smart & & Final’ (USA) run Soft Solutions ‘Referential’ and ‘Pricing’ programs after integrating their complex information
systems and different databases sources (flat files, IBM db2, Sybase, Informix, etc.) into
Soft Solutions Central Data Warehouse.

Programs Experience and Misc.

•Delphi XE3+ pascal-base programming language.
•Sybase SQL Anywhere, PowerDesigner & MS Visio: Designing application database starting from UML Model -> Conceptual Data Model -> Business Data Model -> Physical Data Model -> Creation of the Database.
•MS Power Point, Excel and Word: Presentation & documentation purposes.
•PL/SQL developer (favorite tool is Quest-TOAD): Writing Oracle scripts DDL, DML and procedures.
•Linux OS excellent knowledge
•Networking and hardware skills and troubleshooting.