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.

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.

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.

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.

Business:

Pharmaceutical

Application:

CRM

Technical skills:

Siebel 7.7 ePharma, Oracle 9i

Project:

Customer representatives' CRM system.

Duties:

- Siebel tools

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.

Business:

Pharmaceutical

Application:

CRM

Technical skills:

Siebel 7.5 ePharma, Oracle 9i

Project:

Customer representatives' CRM system.

Duties:

- Siebel tools
- EIM: data load

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

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

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

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.

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

Business:

Banking

Application:

Various

Technical skills:

COBOL, CICS, MVS

Project:

Y2K compliance

Duties:

Maintenance programming.

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.

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.

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.

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

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.

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

Home

Business