Martin BelliardExperience Summary

Martin Belliard

1419 de Dolbeau

Gatineau, Qc

J8R-2V1

819-773-2356

Experience

  • 12+ years as an Independent IT Consultant
  • 16+ years of information technology experience, specializing in microcomputer - client-server environments

… Education

Studies in Informatics 1993

HullUniversity

Certificate studies in System Informatics 1994

HullUniversity

Studies in Statistics1989-92

ConcordiaUniversity

… Language

English

French

…Security

Secret

… Employment History

Programmer Analyst / HRSDC / May 2010 - Present
Project Manager and Programmer Analyst / ATIB Industry Canada / Jan 2007 – June 2007
Project Manager and Programmer Analyst / Groupe Santé Sentinelle / Oct 2005- Dec 2005
Project Manager and Programmer Analyst / AUCC / May 2003 – Present
Project Manager and Programmer Analyst / AUCC / May 2002 – April 2003
Programmer Analyst / Industry Canada / April 2003 – May 2010
Programmer Analyst / Industry Canada / Jan 2002 – Mar 2003
Programmer Analyst / Industry Canada / Jan 1998 – Dec 2001
Programmer Analyst / Industry Canada / Jun 1995 – Dec 1997
Various Roles / Revenue Canada Taxation / Jul 1991 – Dec 1994

… Experience Summary

Project: Common System for Grant and Contribution (CSGC)

Client: Human Resources and Skills Development Canada (HRSDC)

Position: Programmer Analyst

May 2010– Present

  • Analysed requirements and prepared appropriate specifications.
  • Modified CSGC, using PL/SQL according to specifications
  • Performed unit and integration test.
  • Prepared solutions and recommended best options

Project: Autotrade Application

Client: Industry Canada - Automotive and Transportation Industries Branch

Position: Project Manager and Programmer Analyst

January 2007 – June 2007

  • Converted existing application to CLF 2.0 (Common Look and Feel)
  • Interacted with the client to analyse, implement and document user requirements.
  • Prepared proposal
  • Created MS Access database to collect specific information from central database
  • Developed software, using VBScript, to upload and update data for a MS Access database
  • Produced HTML and CSS(DHTML) from MS Access database to export data to departmental Web site.
  • Created software user guide and provided training.
  • Performed unit and integration testing.
  • Provided technical support.

Project: Web Professional Contact System

Client: Groupe Santé Sentinelle

Position: Project Manager and Programmer Analyst

October 2005 – December 2005

  • Developed a data model to convert a Word document into a MS Access database.
  • Interacted with the client to analyse, implement and document user requirements.
  • Developed ASP.NETinterface, using Visual C#.NET, for a web based professional contact tracking application for a MS Access database. ADO.Net was used for data connectivity.
  • Formatted web layout using HTML code and CSS.
  • Performed unit and integration testing.
  • Provided technical support

Project: Web Grant Tracking System

Client: Association of Colleges and Universities of Canada (AUCC)

Position: Project Manager and Programmer Analyst

May 2003 - Present

  • Provided, to the client, software recommendation for the development, design, and system integration of the Web component.
  • Created and executed project work plans and revises as appropriate to meet changing needs and requirements of the project.
  • Provided cost estimate of project implementation to the client including screen mock-ups.
  • Managed technical risks throughout the project.
  • Managed assessment of the work performed by the technical team.
  • For GrantAgency, developed a data model for a Grant tracking application using Erwin 4.0 by converting business requirements to model.
  • Generated Oracle schema and table triggers from the data model (RDBMS).
  • Create and maintained the data dictionaryfor the oracle schema.
  • Developed several reports, store procedures and functions, using PL/SQL and SQL, to integrate special features to the Grant tracking application.
  • As Programmer Analyst, developed ASP.NETinterface, using Visual VB.NET , for a web based Grant tracking application for an Oracle database.ADO.Net was used for data connectivity.
  • Developed ASP.NETclient application, using Visual C#.NET, to configure a Grant tracking application.
  • Developed a ASP.NETinterface software component to remotely access client Oracle databases, using Visual VB.NET
  • Planned the synchronization process strategy to convert data from the Client to the Web database.
  • Interacted with the client to analyse, implement and document user requirements.
  • Developed graphical web pages using PhotoShop.
  • Formatted web layout using HTML code and CSS (DHTML).
  • Enhanced and modified a Grant management application using Java, JavaScript and HTML and Oracle 8i.

Project: Client Grant Management System

Client: Association of Colleges and Universities of Canada (AUCC)

Position: Project Manager and Programmer Analyst

May 2002 – April 2003

  • Provided integration guidance to client for system implementation.
  • Interacted with client to analyse and documented user requirements.
  • Managed day-to-day operational aspects of the project. Including, revision of needs, requirements and deliverables of the project.
  • Supervised and provided guidance to the team members during project development
  • Provided cost estimate of changes implementation to the client including screen mock-ups
  • Enhanced and maintained HTML pages
  • Generated graphical buttons using PhotoShop for a Grant tracking application demo.
  • Created and modified reports using Crystal Report from an Oracle Database.
  • Integrated reports, created in Crystal Report, to a Student Grant Management Application.
  • Developed software component for a XML data exchange process to transfer data from a web based application to a Financial System.
  • Created Oracle queries, stored procedures and triggers in Oracle PL/SQL and SQLto interact with a Grant Management Application.
  • Created Oracle PL/SQL and SQL programs to convert data from Oracle 7 to a new structure in Oracle 8i database.
  • Assisted the upgrade of an Oracle 8i database to an Oracle 9 database.
  • Installed Oracle 8i and managed database for a Grant Management application, using Oracledatabase administration tools (RDBMS).
  • Developed a data model using Erwin 3.5 and 4.0 for a Grant Management System (RDBMS).
  • Generated Oracle schema and table triggers from the model (RDBMS).
  • MS Project utilized as project planning tool
  • Developed Grant tracking application using Oracle Form for an Oracle Database.
  • Responsible for problem analysis and resolution
  • Identified and documented system requirement using UML on Rational Rose 2002.05.00. Business rules and final data model was generated using UML to show activities and data for each business process.
  • Implemented a correspondence system, using HTML, CSS, MS Word, Report Builder and Oracle database (DHTML).
  • Identified requirements and implemented a XML Financial interface with Sun Financial system and Oracle database.
  • Performed unit and integration testingand prepared and delivered training

Project: Conversion/ Maintenance of Contribution Management Information System (CMIS)

Client: Industry Canada

Position: Team leader and Programmer Analyst

April 2003–May 2010

  • Provided guidance to client for a ASP application to comply with CLF 2.0.
  • Updated CMIS interface with IFMS to comply with SAP Unicode upgrade.
  • Proposed software to interact with Proactive Disclosure Application.
  • ProvidedCIO management and program specialists a cost estimate CMIS replacement.
  • Interfaced with program specialists and team leads to resolve issues with the System and ensured that client requirements were met
  • Managed technical resources and their projects
  • Provided technical support for a ASP application.
  • Planned and developed the data conversion strategy from CMIS to a COTS (commercial off-the-shelf ) application
  • Provided and maintained the data conversion specifications documents presented to the client.
  • Oversaw conversion scripts of team member.
  • Updated XML interface with IFMS to comply with SAP Unicode upgrade.
  • Planned implementation of CMIS graphical user interface (GUI) replacement.
  • Provided technical guidance for CMIS GUI replacement to developers.
  • Planned implementation of new system requirements for CMIS.
  • Implemented new system requirements for CMIS.
  • Performed unit and integration testing.
  • Oversaw user acceptance testing.
  • Tested individual changes and additions.
  • Technical support for a Grants and Contribution application operating in UNIX/ Oracle/ Lotus Notes / LEI environment.
  • Developed an XML interface between a Grant & Contribution application and a Financial System (SAP).
  • Planned and developed data conversion strategy from CMIS to a COTS application.
  • Maintained the data conversion specifications documents.
  • Created Oracle PL/SQL programs to convert complex Grants & Contribution application data to a new COTSOracle database.
  • Improved Oracle PL/SQL existing conversion programs to accelerate data conversion.
  • Developed Oracle PL/SQL utility to extract data from Oracle database.
  • Wrote Oracle PL/SQL tool to copy stored procedures from an Oracle instance to another (RDBMS).
  • Debugged Grant Management application (COTS) triggers and stored procedures in Oracle PL/SQL to complete data conversion.
  • Debugged Grant Management application (COTS) JavaScript routines.
  • Enhanced HTML code for a Grant Management application (COTS).
  • Enhanced Visual FoxPro tools to extract data from an Oracle database
  • Developed several ETL jobs, using WebFocus, to transfer data from CMIS to the reporting system.
  • Involved in the migration of ETL jobs from the Test environment to the Production environment

Project: Enhancement of Contribution Management Information System (CMIS)

Client: Industry Canada

Position: Programmer Analyst

January 2002 – March 2003

  • Was the senior developer, providing technical advice (guidance) for the installation and configuration of the hardware and software and construction of the software components, required to develop a generic construction tool used to develop a web based applications for an Oracle database.
  • As Programmer analyst, was responsible the Installation and configuration of all software
  • Developed the required forms to facilitate data entry and provide generic access to Oracle tables
  • Created the Classes and Objects to implement reusable form software components as well as the Libraries to include functions used in the various forms, in order to extend web form functionality JavaScript, Java beans and Java applets were developed using OracleJDeveloper.
  • Created graphical, using PhotoShop, HTML pages to navigate within a web based application.
  • Generated the required report templates to support and generate Reports and Correspondence
  • Developed packages to interact with forms, triggers to support business rules and data integrity and created the required functions and procedures required to support requirements in the various forms.
  • Assisted with the installation and configuration of the Oracle form server, Database design and configuration as well as the server configuration.
  • Responsible for the installation of Oracle Enterprise Edition on a number of Laptops and personal computers to facilitate workshops and training.
  • The landscape for this project included the following products: Oracle Version v8.1.6, Oracle Version 8.17, Oracle Form v4.5/v6, JDeveloper v3.2, Oracle reports v2.5/ v6, PL/SQL v1/v2, Developer Server v1.6.1/ v6I, NET8 with ADO
  • Developed all applications under Windows environment (Windows NT, 95, 98, 2000). Installed all development tools and connectivity software.
  • Developed a prototype with Cold Fusion 5.0 as an alternative to an existing client base application. Used MS Data Access ODBC to communicate with an Oracle database.
  • Created a PHP software component for an existing Client based application as a solution to Webbased application deployment. The application used MS Data Access ADO component and Native Oracle drivers for connectivity.
  • Developed HTML modules accessing the Web from a Lotus Notes 4.5/4.6 application.
  • Reverse-engineered existing schema for a Grant and Contribution prototype using Erwin 3.5/4.0.
  • Developed several applications using Web Server using Apache and PWS. Installed and configured software and components
  • Performed unit and integration testing

Project: Development of Contribution Management Information System (CMIS)

Client: Industry Canada

Position: Programmer Analyst

January 1998 – December 2001

  • As a programmer analyst, participated in the user requirements with the client, planning, design, development, implementation, maintenance and support of a complex Federal Government Grants & Contribution object oriented application, operating in a UNIX / Oracle / Lotus Notes environment and interfacing with the departmental SAP R/3 Financial and Material system
  • Enhanced software component for a web basedapplication for an Oracle database using HTML, JavaScript and Notes Script (object oriented programming) for a Grant and Contribution application.
  • MS Project utilized as project planning tool.
  • Analyzed tables and indexes, calculated table sizes
  • Provided technical suggestions, analysed and resolved problems
  • Performed database and process data modelling (ERWin) and database schema design (created tables, indexes, relationships, primary and foreign keys…)
  • Performed data migration and conversion using SQL* Loader, import and export utilities.
  • Designed, developed, granted and documented PL/SQL stored procedures, triggers, snapshots and views
  • Performed unit and integration testing and prepared and delivered training
  • Wrote user, operations and training manuals
  • Created batch jobs in UNIX using Oracle Enterprise Manager
  • Developed and executed a unit test plan that tests all aspects of a module
  • Designed, developed, tested and documented various data entry forms and reports
  • Performed analysis, design and development of PL/SQL – Lotus Notes (Lotus Script, Notes Pump, Domino) - ABAP/4 inbound/outbound interface procedures
  • Wrote, monitored, reviewed and corrected interfaces to departmental SAP financial/materiel system
  • Wrote, maintained and enhanced Lotus Notes Documents as per change requests
  • Deleted, inserted or updated documents in CMIS as per business analysts recommendations
  • Programmed script or command language agents to perform specific updates
  • Performed Lotus Notes Design / Oracle maintenance
  • Monitored and corrected the Oracle Error Log
  • Liaised with CIO technical support / Database Management Group (Oracle)
  • Managed end users profiles / access
  • Monitored the status of all scheduled processing agents and ad hoc batch processing on the Host Server
  • Managed transport and correction of modules between development, QA and production
  • Monitored the performance statistics on large tables and optimized databases
  • Defined and installed new fields in Oracle tables and maintained the data dictionary
  • Developed new batch processing agents as required
  • Maintained Oracle stored procedures and triggers
  • Provided ad hoc support
  • Designed refresh of CMIS Development Core to client groups
  • Analyzed and actioned change requests to applications
  • Performed screen modifications, field changes, Notes design modifications, enhancements and Business rule modifications as necessary
  • Performed table maintenance as needed for financial coding and program specific coding
  • Performed data extracts, data batch updates and data conversions
  • Undertook specific interface testing with IFMS (SAP system) staff to validate data test criteria
  • Performed Database maintenance
  • Programmed agents to perform internal database tuning to reduce size, delete orphaned documents and improve database performance
  • Converted Financial coding and financial records in Lotus Notes and Oracle
  • Created new modules (object oriented programming) in CMIS
  • Converted from Lotus Notes 4.5 to R5
  • Tested CMIS designs, interfaces and scheduled Agents
  • Maintained a Crystal Reports 6.0/7.0 Reporting System for a Grant and Contribution application
  • Developed an application to display financial transactions in Oracle, using Visual Basic 5/ Visual SourceSafe. Used ODBC connectivity to access Oracle data.
  • Created Lotus Notes navigator using Photoshop for a Grant and Contribution application

Project: Maintenance and enhancement of CMIS VB version

Client: Industry Canada

Position: Programmer Analyst

June 1995 – December 1997

  • Participated in the user requirements with the client, planning, design, development, implementation, maintenance and support of a complex Federal Government Grants & Contribution application, operating in a client server Visual Basic environment and interfacing with the departmental mainframe financial application
  • Performed technical support for the Dos and Windows versions of a contribution information system
  • Wrote NATURAL ad hoc programs for analysis purposes
  • Developed a control version software for a contribution information system in VISUAL FOXPRO 3.0
  • Trained and presented a contribution information reporting system for all users across Canada
  • Performed Technical support for a reporting system developed in FOXPRO 2.6 and FOXFIRE 3.0
  • Developed an application for data conversion, on FOXPRO 2.6
  • Performed unit and integration testingand prepared and delivered training
  • Provided technical suggestions, analysed and resolved problems

Revenue Canada Taxation July 1991 – December 1994

ProjectA: Revenue Canada Taxation

Statistics Services Division

Position: Programmer

October 1993 – December 1994

  • As a programmer analyst, created an informatics system for tax return capture, on FOXPRO 2.5 AND CLIPPER 5.2
  • Performed analysis and production of files, submitted to the minister of finance, related to corporation's tax return
  • Programmed, using SAS and PL/1, for statistical analysis purposes
  • Performed testing, resolved problems
  • Created automated system for quarterly report, on FOXPRO 2.0 and ACCESS 2.0

Project B: Revenue Canada Taxation

Security Directorate Department and Statistics Services Section

Position: Programmer

July 1991 – September 1993

  • As a programmer, created informatics systems for data management, on DBASE IV and CLIPPER 5.2
  • Provided informatics support for the network and the software for employees of the Security Directorate Department
  • Integrated a new network (NOVELL 3.11) for the department
  • Created sample and population files
  • Performed statistical analysis of sample and population files
  • Programmed, using SAS and PL/1, for statistical analysis purposes
  • Performed testing, resolved problems
  • Performed statistical tabulation of client requests

… Technical Summary

Languages, Tools & ERP: Oracle Designer, Oracle Forms, Reports ,Oracle Enterprise, Manager, Oracle Developer 2000, PL/SQL, SQL* Loader ,Lotus Notes, Lotus Script, Notes Pump, Domino, LEI, SAP / ABAP, Visual Basic, Visual .NET, Delphi,,Visual FoxPro and FoxFire
Java, JavaScript, JSP, VBScript, ASP, PHP, Cold Fusion,HTML, XML ,Crystal Reports, Natural

Hardware: IBM PC, IBM SP, RS 6000