Edward Tweedly

C.V. 2008
Freelance only.
UK, or will commute weekly in Europe.

Available end July 2008.

Home

Business


Download my CV (in English) in MS Word97 format

email me

Orientation

Technical, Siebel

Applications

Data migration, extract, and loading in Siebel and Oracle or DB2
Siebel configuration.

Technical skills:

Siebel (Tools, configuration, EIM)
Oracle, PL/SQL, SQL Loader
unix, SQL, C, C++, Oracle Pro*C
Legacy skills: IBM mainframe, COBOL, CICS, 370 Assembler, JCL, CLISTs, panels, VSAM, REXX.

Application areas:

Banking, finance, industrial

Languages:

English mother tongue,
fluent French,
read write and speak German

Notes:

I am not a DBA.
I am not a siebel Administrator.
I will not work in or from France.

Experience:

February 2008-present - Rabobank

Business:

Bank

Application:

CRM

Technical skills:

Siebel 7.5, DB2, SQL

Project:

Customer representatives' CRM system.

Duties:

Batch & Data Team Lead
Responsible for developing and implementing datafixes, and data imports and exports, for next release of CRM system, leading 2 offshore programmers.

September 2006-Date IBM Frankfurt for Deutsche Telekom.

Business:

Telecommunications (Mobile phone operator T-Com)

Application:

CRM

Technical skills:

Siebel 7.8, Oracle 10g, unix :
Siebel Tools, EIM, unix shell scripting.
Oracle PL/SQL, Pipelined Table Functions.

Project:

Migration of CRM system.

Duties:

Migration of legacy data, batch loads.
Configuration, testing, performance testing, tuning.
 

The project loads over 3 billion records, in one of the largest Siebel databases in Europe (1.5 Terabytes). Short timescale for the actual migration run means performance testing and tuning is vital. The legacy system is also Siebel, but configuration changes mean that an update is not possible, so migration is done by Extract, Transform & Load, then by EIM. Oracle Pipelined Table Functions are used to maximise parallel processing.

July 2006-August 2006 - Accenture Madrid for Accenture Brussels.

Business:

Telecommunications (Mobile phone operator)

Application:

CRM

Technical skills:

Siebel 7.8, Oracle 9i, unix;
Siebel Tools, EIM, SQL*Loader, PL/SQL, unix shell scripting.

Project:

Customer representatives' CRM system.

Duties:

Migration of legacy data, batch loads.
Configuration, testing, loading, debugging.

May 2006-June 2006 - Novartis.

Business:

Pharmaceutical

Application:

CRM

Technical skills:

Siebel 7.7 ePharma, Oracle 9i

Project:

Customer representatives' CRM system.

Duties:

- Siebel tools

July 2005-April 2006 - Zurcher Kantonalbank.

Business:

Banking

Application:

CRM

Technical skills:

Siebel 7.5, Oracle 9i

Project:

Customer representatives' CRM system.

Duties:

- Siebel tools
- EIM: data load
- Batch data load analysis and development.

April 2005-June 2005 - Boehringer Ingelheim.

Business:

Pharmaceutical

Application:

CRM

Technical skills:

Siebel 7.5 ePharma, Oracle 9i

Project:

Customer representatives' CRM system.

Duties:

- Siebel tools
- EIM: data load

March 2004-March 2005 - Rabobank

Business:

Bank

Application:

CRM

Technical skills:

Siebel 7.5, DB2, SQL, unix, OS/390

Project:

Customer representatives' CRM system.

Duties:

- Siebel tools: configuration analysis
- EIM: data load and datafix
- knowledge transfer

February 2002-February 2004 - Hewlett Packard

Business:

IT systems and hardware

Application:

Sales discounting and offers CRM system

Technical skills:

Siebel, Oracle, SQL, unix, Windows NT

Project:

Pricing, deals, retailer/wholesaler discounts system.
Development / support of Siebel CRM system.

Duties:

"Development Support": between development and support, using the skills of both.
- implementation of system
- analysis of Data Model, and study of feasibility/impact of architecture changes
- development of unix scripts and Oracle SQL queries
- Siebel configuration
- installation of Siebel servers, migration of server hosts
- tuning of Oracle database
- SQL*Plus
- Oracle database administrator tasks
- Siebel task administration

December 2001-January 2002 - IBM

Client:

Bouyges Telecom

Business:

Telecommunications

Application:

Third-party resellers system

Technical skills:

Siebel EIM, Siebel Tools

Project:

Data conversion from legacy systems
Interfacing with existing systems

Duties:

Testing interface procedures
Documenting Siebel Tools configuration
Preparation of document to present EIM system to Siebel for review

June 2001-October 2001 - Accenture

Client:

Credit Lyonnais Asset Management

Business:

Investment Banking

Application:

Investment Products Reference

Technical skills:

Siebel EIM, Siebel Tools, Oracle SQL*Loader, SQL, PL/SQL

Project:

Data conversion from legacy systems
Interfacing with existing systems

Duties:

Designing interface tables and applying to database;
design, coding, testing and implementation of data load scripts;
running Siebel EIM to load database.
Working with client users, technical staff of existing systems, and Siebel application developers.

1990-2001 SEMA Group - Paris: 2 internal projects and 5 on client sites, as follows:

November 1998-June 2001 - Hewlett Packard

Business:

IT systems and hardware

Application:

Reseller Profiling CRM System

Technical skills:

Siebel, Oracle, SQL, unix, Windows NT

Project:

Data conversion from existing system
Installation and support of new Siebel system.

Duties:

- creation and maintenance of installation package
- maintenance of unix scripts and Oracle SQL queries
- tuning of Oracle database
- SQL*Plus
- Oracle database administrator tasks
- Siebel task administration

August 1998-November 1998 - Credit du Nord

Business:

Banking

Application:

Various

Technical skills:

COBOL, CICS, MVS

Project:

Y2K compliance

Duties:

Maintenance programming.

February 1998-August 1998 - Caisse des Depots

Business:

State organisation for holding private deposits

Application:

Shares trading system

Technical skills:

C++, unix, Sybase, SQL, Windows NT, NS-DK, Tuxedo

Project:

Development of shares management and trading system

Duties:

C programming for unix and Tuxedo
C++ programming for Windows NT
creation of unix scripts
creation and implementation of SQL queries
development of GUI applications in NS-DK.

May 1996-February 1998 - Banque Sudameris

Business:

Banking

Application:

Credit management

Technical skills:

Centura, Windows NT, C++

Project:

Development, programming and testing of credit assessment and management system for large loans (shipbuilding, etc)

Duties:

Development of user database application in Centura
development of SQL queries
development of Windows NT DLLs in C++
development of batch programs in C.

October 1995-April 1996 - Compagnie des Eaux de Paris

Business:

Water utility

Application:

Account management and work planning

Technical skills:

Oracle, Pro*C, PL/SQL, unix, Centura

Project:

Development of system to manage consumer water accounts and plan construction and installation work for subcontractors

Duties:

Development of batch programs in C and Pro*C
development of PL/SQL queries
development of user applications in Centura.

1995-1995 - SEMA Group

Business:

Software house

Application:

BAFI: Bank fiscal reporting to Government

Technical skills:

IBM mainframe MVS, COBOL, CICS

Project:

Installation of SEMA package on client sites

Duties:

Installation of package customisation and optimisation user training

February 1990-October 1995 - SEMA Group

Business:

Software house

Application:

CARDPAC: credit card management package

Technical skills:

IBM mainframe MVS, COBOL, CICS

Project:

Maintenance and support of package

Duties:

installation support (of large users, for example Auchan, GAN)
maintenance.

1986-1990 Freelance - London
BASF: Industrial System/36 RPGII
Standard Chartered Bank: Banking IBM mainframe RPGII
Reuters: Information Services IBM mainframe COBOL & Assembler  

1981-1985 General Electric Information Services - New York
General Foods: Food Manufacturing
A.T.&T.: Telephone
Rawlplug: Manufacturing
Pepsi-Cola: Drinks Manufacturing IBM mainframe COBOL  

1978-1980 Freelance: Various - London, Germany, Netherlands, Africa
IBM mainframe COBOL, IBM System 34 RPGII

1977-1977 Faberge: Manufacturing - London
IBM mainframe COBOL & RPGII

1975-1976 National Savings Bank - Scotland
IBM mainframe COBOL & Assembler

Education:

B.Sc. (Mathematics) Glasgow University, Scotland.

Training:

Oracle University DBA 1 & 2
Open University advanced computing course M358 Relational Databases
Windows NT Administration
Oracle 7.0, PL/SQL and Forms v4
Unix

Download my CV (in English) in MS Word97 format.


Home

Business