Simon Dewerson

- Design, implementation, deployment and support of a global datawarehouse for asset revenue data. - Leading a team of 4 software engineers throughout the design and development phase. - Technical analysis with business and implementation of new enhancements.

- Resolving production problems related to database, batch processing and interfaces to partner systems. - Loading, extraction and archival of PeopleSoft Financials General Ledger data. - Database/schema refresh - exp/imp and Data Pump, statistics, partitioned tables and indexes.

- Install and maintenance of DEV, INT, UAT and PROD environments: 4 Oracle and 20 Windows servers. - Support for pilot user groups in Zurich, London and New York. - DBA support: schema refresh, scripting, back-ups, developer access.

- Analyse, implement and test new business requirements in Avaloq. - Investigating and resolving production issues. - Designing and implementing change requests: new classifications/classes, bulk updates of existing classifications/classes, designing and implementing new reports in Report Writer, changes to order workflow and order validation. - Tuning large queries executed against Avaloq database tables. - Carrying out regular end-of-day and end-of-quarter batch processing.

- DBA: performance tuning, maintaining partitioned tables, tuning PFile parameters. - Supporting daily/weekly/monthly batch process for 9 European sites. - Transformation and loading of Olympic AS400 data into Oracle databases. - Processing client asset and transaction data in PL/SQL scripts. - Loading and validation of data in Hyperion Essbase. - Support of fees calculations paid to clients’ agents based on their clients’ assets and revenues.

Designing and developing new functionality in Oracle for the main college examination system in the UK.

- Managing the creation of an e-commerce web-site (www.respectrefugees.org) to sell products made by refugee communities. - Coordinating a team of 10 UN online volunteers from different countries and cultures. - Weekly progress reporting to volunteers and management.

- Roles included DBA, Team Leader, Analyst/Developer and Technical Support. - Database design, scripting, build and maintenance. - Leading a team of 4 analyst/developers for 5 months. - Developing and supporting client/server applications in Delphi and Oracle.

Teaching English in London, UK.

English Teacher in Cali, Colombia.

Teaching English to enlisted men and officers in the Czech Air Force and the Czech Ministry of Defence, Prague. Also teaching, part time, for Komercni Banka and Ceskoslovensko Obchodní Banka, Prague.