Aurore - DBA SQL

Database Development, Design & Administration
N-tier/Internet Development & Architecture
Data-warehouse Development & Architecture

Developed my own company selling these skills



SOFTWEB, Geneva (Switzerland)
Since Jan 2001 IT Consultant / Co-Founder
Responsibilities Softweb provides business and technology consulting services with a strong focus in business information architecture. Main domains of activity include database architectures, document and knowledge management systems and Web application design.
• Responsible for the administrative and technical company set-up
• Engaged actively on customer projects
Softweb has developed its corporate web site ******** for marketing purposes. It also allows individuals to use this platform to publish personal information.
• Development of the corporate web site
• Responsible for the development of a Travel Web Site, using database support
Technical Environment: HTML, PHP, MySQL, Javascript

Projects
Web & Database Developer – DSRD, Sydney (2 months)
The NSW Department of State and Regional Development (DSRD) is in the process of migrating its applications to the .NET framework and merging & migrating its databases to MS SQL Server.
• Migration of the Intranet from ASP to ASP.NET/C#
• Integration with Content Management System
• Data Migration and Cleaning
Technical Environment: ASP.NET, C#, ASP, MS SQL Server, XML, CMS

Web Application Developer – CALTEX, Sydney (2 months)
CALTEX has designed an Intranet/Extranet Application to report Losses & plan corrective actions. This application needs to evolve to include new functionalities.
• Development of business & data layer objects
• Development of PL/SQL Queries to extract and format data
• Development of web pages and report tools
Technical Environment: Oracle, PL/SQL, COM+/DCOM, VB, XML, ASP

Web Development Manager – OXFAM Australia, Sydney (8 months)
The web site ******** has been designed to promote the Oxfam International Youth Parliament and to provide knowledge sharing tools.
• Management of the team of on-site and on-line Web Volunteers
• Development of a Private Site for Knowledge Sharing between Delegates and with OXFAM
• Development of e-Commerce Applications to sell publications and fund-raising events
• Maintenance of the Public Web Site
Technical Environment: ASP, HTML/CSS, VBScript, Javascript, Access, SSL, SQL

Database Designer – Morgan Stanley Capital International, Geneva (18 months)
MSCI has developed a new enterprise application called Index Factory (IF). This object-oriented application generates financial reference indexes in a flexible way, allowing to adapt rapidly to new or evolving customer requirements.
• Design of the Enterprise Application Data Model
• Development of the back-end Stored Procedures for loading & writing data to & from IF
• Project Manager for application extensions
• Definition of the development environments
• Database Migration from Sybase 11.9.2 to 12.5
Technical environment: Sybase, Transact-SQL, Java, Perl, Unix



SOFTWEB (continued)
Database & Data-warehousing Expert – Japan Tobacco International, Geneva (10 months)
JTI provides his sales managers with a data-warehouse, analyzing sales & marketing data. This application must evolve to include new markets, new Key Performance Indicators (KPIs) and be rolled out worldwide.
• Redefinition of the data-warehousing architecture and data-flow
• Design of a database optimized for decision support
• Development & Optimization of automated procedures to transfer data from OLTP database
• Cube developments for the new KPIs
• Development & Roll-out of an outline administration tool
• Database Migration from MS SQL 7.0 to MS SQL 2000
Technical environment: MS SQL 7.0 and 2000, DTS, VB/Access, Essbase, HIS/EIS, T-SQL



CAST, Paris (France) / Geneva (Switzerland)
Mar 1999 - Oct 2000 IT Consultant
Responsibilities • Systems & Database Administration of CAST Switzerland network (Windows NT servers, MS SQL Server & Sybase Databases)
• Implementation of an Intranet application for managing staff information within CAST Group
• Responsible for the technology watch on XML within the CAST R&D activities (2 years): implementation of multi-tier architectures using XML technology & publication a technical article on the XML language and architectures in the magazine "IT-Expert" from 15/09/2000
Technical Environment: ASP, COM, VB, MS SQL 7, IIS 4.0, XML, XSL, CSS, Transact-SQL

Projects
Web Development Manager – France Télécom Mobiles (4 months)
France Télécom Mobiles has set up a web site intended to be an interface between investors & entrepreneurs in the m-commerce field. Entrepreneurs submit their projects online and France Telecom can analyze & select the submitted projects through a data-warehousing application.
• Database Design & Implementation
• Development of templates for business objects, stored procedures & web pages
• Project Management
• Development of the secured web application for online project submission
• Implementation of a full-text search functionality for static & dynamic information
• Implementation of an event management functionality, incl. automated e-mail/newsletter
Technical Environment : MS SQL 7.0, ASP, COM, VB, IIS 4.0, Index Server, SSL, Transact-SQL

Web & Data-warehouse Application Developer - COTECNA (5 months)
COTECNA has set up a workflow for managing the imports and exports of Ghana. In this multi-tier Microsoft application, the business module is accessed either through a Web-based client (online submissions from 150 offices worldwide) or a Windows-based client (internal validation).
• Database Optimization
• Implementation of online modules for managers: data-warehouse & services billing module
• Development of the Web client
• Web Servers Administration (development and production environments)
Technical Environment : MS SQL 7.0, Crystal Reports, ASP, COM, VB, IIS 4.0, Transact-SQL

Web Architect & Developer - ILO (International Labor Office) (4 months)
ILO needed to harmonize and upgrade its Intra- and Internet architectures. The main goals included centralizing all existing applications and implementing the first dynamic applications.
• Definition of the new Intranet architecture
• Database Design & Data Migration
• Database Administration ; Database Migration from MS SQL 6.5 to MS SQL 7.0
• Development of Intranet Applications
Technical Environment : MS SQL 6.5 and 7.0, Access, Transact-SQL, IIS 4.0, ASP, Visual C++



CAST (continued)

Consulting for Database/Application Migration – BIORG (1 month)
BIORG has developed for the European market an « expert system », using data from analog biological measurement devices to generate online analytical medical reports.
• Recommendations on the technology migration to XML and VB6/ADO
• Database migration to MS SQL Server. Normalization & Optimization
Technical Environment : MS SQL 7.0, VB6/ADO, XML, Transact-SQL, Access, VBA/DAO

Database & Data-warehouse Developer – Kronenbourg Breweries (3 months)
The Kronenbourg Breweries have set up a data-warehouse covering several business areas, based on a Sybase 11.5.1 environment, including a datamart for business stocks and components.
• Participation to the database design and application architecture definition
• Development of the back-end stored procedures
• Development of the client application using Powerplay and Impromptu
• Development of Windows applications allowing users to modify their outlines remotely
Technical Environment : Unix, Sybase 11.5, Cognos Powerplay & Impromptu, Visual C++, T-SQL

Consulting for Database Migration- CARAC (3 months)
The CARAC database production server was relying on a Sybase Adaptive Server 11.02. The migration 11.5.1. led to an optimization of the production databases & administration procedures.
• Definition of the different migration scenarios, including setting-up a replication server
• Migration of the production database server from Sybase 11.02 to 11.5.1
• Redesign & Optimization of the administration procedures (SQL and scripting)
Technical Environment : Sybase 11.0.2 and 11.5.1, Unix AIX, Transact-SQL



Agence Centrale des Organismes de Sécurité Sociale, Paris (France)
Jan 1997- Jan 1999 Engineer in the department of Computer Systems and Equipment in charge of the computer equipment of 150 branches.
Responsibilities • Systems Administration (Windows NT and UNIX servers, with clusters, 30-workstation LAN)
• Hardware and Software Testing to establish national recommendations
• Implementation of knowledge management applications:
o Definition and setup of a document management and workflow system supporting the national IT planning process
o Implementation of Intranet applications integrating databases and document repositories
o Definition of an Internet site model – Organization of Internet trainings
• Participation to national technology migration projects :
o Architecture migration towards Internet technologies : Coaching of an expert group for the selection of servers and development tools and the definition of the Internet architecture
o Migration of the national application SNV2 from a mainframe environment towards UNIX/Oracle/Tuxedo platforms
Technical Environment : Lotus Notes, Domino, GED, Workflow, UNIX, NT, Oracle, Tuxedo



Centre for Telecommunications Research, King's College London (UK)
Oct 1995 – Sep 1996 Research Project within a program for the improvement of 3rd generation mobile communications systems
• Development of a simulation environment for mobile phone transmission systems
• Testing of various coding techniques for the optimization of high-speed data transmission
Technical Environment : CDMA (Code Division Multiple Access), C, C++, UNIX