: 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
·
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.
·
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
*
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.
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.