Experience

: La Presse - Canada :

Environment: SQL Server, MySQL, SAN, TCP/IP, C Sharp, ASP.NET, VB.NET, XML, WINDOWS XP / 2003.

Responsibilities: * As a Database Administrator dedicated to support production database maintenance and development in multiple environments SQL Server 2005 / SQL Server 2000 / MySQL 5

Hyperlink: www.cyberpresse.ca | lapresseaffaires.cyberpresse.ca | monvolant.cyberpresse.ca | technaute.cyberpresse.ca

  • Maintaining and administering databases (SQL Server 2000 / 2005, MySQL):

· Providing consultation on SQL Server to our development teams

· Developing and maintaining logical schema, physical records, SSIS modules and SQL queries

· Troubleshooting performance issues and fine-tuning queries and stored procedures

· Troubleshooting problems involving process management, I/O operations, network, file operations, and memory.

· Implementing and administering database replication.

· Oversaw application design, development and maintenance as team leader of project involving performance benchmarking comparisons of SQL Server and MySQL

· Conducting performance benchmarking comparisons of SQL Server, MySQL and .Net

· Creating jobs to achieve automate administrative tasks and business workflows using Integration Services / DTS

· Installing, configuring, administering and securing production servers.

· Coming up with custom-tailored backup/restore and disaster recovery plans for production servers.

  • System Analysis and programming:

· Installing and developing business reports with Reportings Services

· Developing features for extended character set support between web application and foreign e-mail systems

· Developing XML/XSL schema and graphical user interface for Portal web service queries

· Creating e-mail based notification system for activities of concurrent managers

· Upgrading and providing improvements plans for existing applications

· Developing and testing XML functionalities from SQL Server 2005 and integrated with SQL applications

· Conducting tests for profiling and performance benchmarking and enhanced execution manager using object-oriented programming in C Sharp/VB .Net.

: PCG - Canada :

Environment: SQL Server 2000 / 2005 /2008, Sharepoint, SQL Server Analysis, WINDOWS XP / 2003 / 2008.

Hyperlink: www.merkurium.com

  • Business Analyst :

· Analysis business needs with customer

· Design the data warehouse schema according to analysis

· Translate business rules and logic to ETL

· Provide dashboard and reporting solution

  • Maintaining and administering databases (SQL Server 2000 / 2005):

· Providing consultation on SQL Server to our development teams

· Developing and maintaining logical schema, physical records, SQL queries

· Troubleshooting performance issues and fine-tuning queries and stored procedures

· Installing, configuring, administering and securing production servers.

  • ETL Developer:

· Ensure the ETL code delivered is running, conforms to specifications and design guidelines.

· Developing to estimated timelines or updating management on deviations to these estimates.

· Unit testing ETL code to ensure it can be delivered and run in a system testing environment.

· Raise critical technical issues to the ETL Design Lead that may impact on the timeline.

· Participation and contribution in quality assurance walk through of ETL components

: Relizon - Canada :

Environment: SQL Server, C Sharp, ASP.NET, VB.NET, DELPHI, XML, Eclipse, TCP/IP, WINDOWS XP / 2003.

Responsibilities: * As a Database Administrator dedicated to support production database maintenance and development in multiple environments SQL Server 2005 / SQL Server 2000

* As a Business Analyst dedicated to document our technical and design needs. I was dedicated to writing all the requirements, use cases to settle the migration of our legacy system to Oracle.

Hyperlink: www.relizon.ca | www.datagroup.ca

  • Maintaining and administering SQL Server databases (2005 / 2000)

  • Troubleshooting performance issues and fine-tuning databases indexes

  • Creating ASP.Net web sites to manage ordering application / intranet website and other client needs using the technology C Sharp, VB.Net and XML .

  • Creating web services in order to automatically retrieve XML requisition from our customers into our system. Using the technology C Sharp, XML (using Xquery).

  • Updating and adding new functionalities to our portal, Relizonline. Managing the communication between the e-procurement web site Ariba and our system. Using cXML and ASP.

  • Designing JSP website for internal purposes, handling database query data. Using JSP, Servlet and SQL Server

: IBM - Canada :

Environment: MySQL , PHP, WINDOWS 97/2000, NOVELL, MAINFRAME, TCP/IP, IPX/SPX, SNA, TELNET, INTERNET,

INTRANET,TOKEN RING, ETHERNET, MCAFEE, MS-OFFICE 97/2000, EMULATORS, IBM, HEWLETT PACKARD

Responsibilities: As a CSC Analyst dedicated to provide 24/7, 1st level customer support to the worldwide Air Canada (AC) network, AT&T and CIBC

Hyperlink: www.ibm.ca

  • In a professional and calm manner, assist A.C employees worldwide with computer/network related problems.

  • In a quick and efficient manner, being able to analyze the severity of an outage/problem and its impact on the AC network and act accordingly.

  • Navigating the Corporate Novell Directory Structure.

  • Updating profiles and map drives. Capturing printer ports. Unlocking accounts and adding to login scripts.

** Development of a secure intranet website for helpdesk agents to access accurate information, technical documentation, contact phone numbers, trouble report examples. Create procedure to easily transfer information to emulator 3270. Using Php, MySql / InterBase Server, Session functions, Javascript,.

: MP-Concept - France :

Environment:

DELPHI 7, INTERBASE SERVER, INTERBASE CLIENT, TCP/IP, INTERNET, INTRANET, WINDOWS 97/2000, MS-OFFICE 97/2000

Responsibilities:

Analyst programmer dedicated to develop a real estate application. I conducted the analysis, the tests and determined what programming language and database to use

Hyperlink: www.mp-concept.fr

  • xxx.

  • xxxx.

  • xxx.

  • xxxx.

[ Mp Concept - France ]

* As a Analyst programer dedicated to document our technical and design needs. I was dedicated to writing all the requirements, use cases to settle the migration of our legacy system to Oracle.

Responsabilités: Analyste programmeur dédié au développement d’une application pour gérer les biens des agences immobilières. J’ai effectué l’analyse complète et déterminé quel langage de programmation et base de données à utiliser, mes tâches incluaient :

Création du modèle de données ainsi que du modèle de traitement de l’application.

Installation et configuration d’ InterBase server / client v6.

Création des tables, relations, liens, procédures stockées, triggers pour la nouvelle base de données.

Développement sous Delphi 7 des classes globales, fonctions et moteur de recherche qui seront utilisés ultérieurement dans l’application.

[ Proxpert – Canada ]

Environnement: WINDOWS NT/2000, DELPHI 5, SQL Server, TCP/IP, INTERNET, INTRANET, MS ACCESS 2000, MS-OFFICE 97/2000.

Responsabilités: Analyste programmeur dédié au développement d’application de base de données client/server, d’application web, de sites Internet, une partie de mes projets d’envergure étaient :

Modification, réparation et ajout de nouvelles fonctionnalités à l’application (System 1) pour la simulation des coûts liés aux gros travaux d’imprimeries, impression de formulaires et d’étiquettes pour la société Relizon sous Delphi 5 en relation avec une base de données Sql Server.

Conception et réalisation d’une application pour gérer la maintenance préventive et courante de la société Cameocrafts. Utilisation de SQL Server et Delphi 5. Création de sites Internet en Php, Javascript, MySql et Actives X tels que : - www.cameocrafts.com

- www.proxpert.qc.ca

[ Sud Peri Soft – France ]

Environnement: WINDOWS 97/2000, VISUAL BASIC, TCP/IP, INTERNET, MS ACESS 2-97-2000, DELPHI 5, MSOFFICE 97/2000.

Responsabilités: Analyste programmeur dédié au développement d’application de base de données, la création de rapports financiers et la gestion d’une société immobilière. J’ai effectué l’analyse complète et déterminé quel langage de programmation et base de données à utiliser, mes tâches incluaient:

Développement d’une application pour une compagnie de cosmétique pour prévoir les différents besoin à travers une simulation du marché décomposé en plusieurs niveaux de nomenclature sous Access 2000.

Conception d’une application pour gérer les changements d’horaires pour les programmeurs sous Delphi 5 avec base de données Paradox. Utilisation de Quick Report v7 pour les rapports statistiques.

Création de deux balances agées sous Crystal Report v7, une pour les clients et l’autre pour les fournisseurs se basant directement sur les écritures comptables du logiciel SAGE. Conception d’un moteur d’importation ODBC sous Access 97-2000 dans le but de récupérer les données depuis n’importe quel DSN(Data Source Name) existant dans l’ordinateur.