Senior BI ETL / SQL Analyst / Developer / Integrator Mario Guevremont’s Curriculum Vitae

Mr. Guevremont is seeking a permanent opportunity in Ottawa / Gatineau area or a contract outside is living region.
Mr. Guevremont is aSenior BI ETL/SQL Analyst / Developer / Integrator, Informatica ETL-SQLwith DBA experience acquiredduring an extensive career asaBI ETL/SQL developer couple with DataIntegrationsand complex Interfaces using the latest up-to-date software’s versions including Microsoft Server 2008 R2 Enterprise, Oracle ODI 11g, Informatica 9.6.2 Power Exchange Real-Time and many more. Mr. Guevremont isa skilled BI analyst developer with more than 20 years of IT programming, Business Intelligent (BI), Data Integration, Informatica, Oracle ODI, CrystalReports, Manufacturing Efficacy (ME)and DBA experience within the Canadian government, European bank and privates industries.
Mr. Guevremont has extensive experience in all phases of the system development life cycle. He has developed analytical, programming, and problem-solving skills that enable him to analyze, design, program, and implement BI applications solutions for users based on large cluster databases and data warehouse as well as real-time Server database applications, design for Client-Web/Server networks architecture.
Mr. Guevremont spent all is career on the implementation success applications, process and Business Intelligent (BI) solutions forPublic and private organization named Ottawa University (Oracle ODI 11g), Transcontinental Headquarter (Radius SAP Crystal Reports 2014), BROOKFIELD RENOUABLE (BI Informatica 9.6.1), BRIGIL (DBA, ETL Talend Studio BI Data Integration specialist), Health Agency of Canada (BI Informatica), La Cité collégiale (Crystal PeopleSoft BI), D4iS Solutions (BI and .NET), l’Université Laval de Québec (BI Informatica), Brookfield Power generating and marketing operations (Cognos & BI Informatica) and implement Oracle PeopleSoft Human Resource Management HRMS/Payroll for the Bank of Canada, Correctional Services Canada, Ernst & Young International London United Kingdom, National Defence Canada DND, Agriculture Canada, DANONE Group France and UBS AG Switzerland. For the entirety career, Mr. Guevremont’s primary skill focus has been as a senior Business Intelligent (BI) ETL/Reports/Complex Data Integration and programmer/analyst for data integration and data warehouse multiprocessing.
Mr. Guevremont is a hands-on problem-solver known as a hard worker coupled with a high degree of professionalism. He has positive interpersonal skills which steering committees, end-users and technical staff appreciates. Mr. Guevremont always produces high quality results while respecting tight deadlines. He is bilingual and holds “Secret” security clearance (2021). / Mario Guevremont
Senior BI ETL / SQL Analyst / Developer/ Integrator+ DBA experience.
Phone:819.607.1777


PROFESSIONAL EXPERIENCE / ACADEMICEDUCATION

PROFESSIONAL EXPERIENCE

Information Technology:

  • Informatica Business Intelligence (BI) Consultant
  • Informatica Business (BI) Oracle Business Integration (ODI) Consultant
  • DBA and Informatica administrator
  • Technical Team Leader experience
  • Data centralization and management(Data Warehouse)
  • Highly motivated and respecting tight deadlines

Technical Skills:

  • Oracle ODI, Extract Transform Load 11g PeopleSoft Campus Solution Data Warehouse
  • Informatica, Extract Transform Load Power Center 7.1, 8.1, 8.5, 8.6, 9.6.0,9.6.1 et 9.6.2
  • Informatica, ETC d'Informatica Power Exchange 8.1, 8.5
  • DBA, Informatica Administrator
  • Server performance tuning, hardware upgrades and resource optimization as required
  • Open Source like Talend, PostgreSQLSoftware implementation and configuration
  • BI Architect, ETL/SQL & Communication / Services
  • Data Warehouse Records Mapping and Complex Interfaces Specialist
  • SQL/SQR, PS/Query & Crystal specialist complexes interfaces developer
  • MS Excel all version, support and extreme macros and forms specialist
  • Analyze, Design, Develop and Implement server and other PC products

DIPLOMAS AND INSTITUTIONS

Diploma in Data Processing L'institut d'informatique appliquée (1987)

Diploma in Electronics Technology Le CEGEP de l'Outaouais (1979 - partial)

Diploma in VAX System Management Digital Research Corporation (Ottawa- 1989)

Professional Development / Certificates:

Oracle BI ODI Applications 11g Oracle University (Ottawa University 2016)

Informatica PowerExchange Real-TimeCDCInformatica-formation (Québec-2009)

Informatica Power Center et Workflow 8.5 Informatica - formation Web 4jours(Ottawa-2009)

Informatica PowerExchange et Admin. 8.1 Informatica - formation (Québec-2009)

Informatica Power Center and Workflow Brookfield Power Corporation (Gatineau 2007)

Delta in PeopleTools I, II v8.2 PeopleSoft (Ottawa - 2001)

PeopleSoft SQL/SQR Reports PeopleSoft (Ottawa - 1998)

PeopleTools I PeopleSoft (Ottawa - 1996)

PS/Query and Crystal Reports PeopleSoft (San Francisco - 1994)

Business Requirements DMR Productivity - Bank of Canada (1994)

Visual Basic Programming Microsoft University (Toronto - 1993)

AWARDS

Crystal Reports Decisions: The North American "I-can't-live-without-it" Top 2001Report.

CSC Adjoin Commissary : The smooth manner with which PeopleSoft upgrade was completed.

LANGUAGES SPOKEN: French, English

LANGUAGES WRITTEN: French, English

SECURITY CLEARANCE: SECRET (Valid to 2021)

ACHIEVEMENTS SYNOPSIS
Employer / Mandate / Period / Function / Nbrs
# / Client / mm-aa à mm-aa / Months
Independent Consultant
28 / OTTAWA UNIVERSITY Programmer Senior Analyst in ETL Oracle Data Integration / Develop and Implement Oracle Data Integrator (ODI ETL/ELT) process extracting PeopleSoft Campus Solutions data to load an Oracle data Warehouse. / 03-16 to 08-16 / Working with Deloitte PeopleSoft team, my function was to Develop and implement mappings, process and Load Plan using Oracle Data Integrator (ODI ETL/ELT) to extract PeopleSoft Campus Solutions data to load a data warehouse used to support all theOttawa University Business Intelligence (BI) requirement. / 6
27 / TRANSCONTINENTAL MEDIA, Manufacture Efficiency and Radius SAP Crystal Reports analyst and developer / Analyse, propose, develop and implement Manufacture Efficiency Solutionusing SAP Crystal Reports 2014 in a Progress and Windows Server environment. / 08-15 to 12-15 / Whit the Manufacturingresponsible people, we draw lists of requirement and solutions and define that the most rapid and efficiency way to resolved the efficacy drag was the Radius lack of real-time business Ad Hoc Reports. Which I developed to increase the TC business productivity. / 4
26 / BROOKFIELD RENEWABLE POWER, System Analyst as Informatica specialist / Analyse, propose, develop and implement InformaticaETL Data Integration solutions to convert iWay Information Builders PFlow into Informatica PowerCenter 9.6.0 upgraded to PowerCenter 9.6.1 and 9.6.2, plus many Server installation. / 03-14 to 05-15 / Integration and Business Intelligence ETL Solutions, Informatica Administrator, ETL BI Data Integration Optimizations to convert iWay Information Builders PFlow into Informatica PowerCenter, Informatica, Server installation / 14
25 / BRIGIL Constructions, DBA and ITleader and specialist / Restructure data flowing between all departments, analyse, propose, implement and lead solutions for different department data redundancy problems. / 12-12 to 11-13 / DBA, Integration and Business Intelligence ETL Solutions, Excel visual basicand Task Applications Optimizations, ETL BI Data Integration Open Source Specialist and SAP Crystal Reports developer. / 12
24 / Freelance, DBA and IT leader and informatics specialist. / Analyse, propose, implement and lead solutions for different small clients. Mostly Web Site support, development and graphics designs. / 10-11 to 11-12 / Be aside of each client to help them on every IT levels and develop small applications to make sure they have a happy informatics development. / -
23 / Public Health Agency ofCanada (PHAC) Information Management\Information Technology Directorate (IMIT). Data support section. / ETL/SQL InformaticaBI solutions / 07-10 to 09-11 / Provide ETL Informatica mentorship to the ETL programmer’s team and Develop mappings and maintain technical design specification. / 15
La Cité collégiale
22 / La Cité collégiale / Analyze, Optimize, Develop and maintain Business Intelligent BI PS/Query Crystal reports, including staffs trainings. / 01-10 to 06-10 / BI Architect, Developer and trainer on PeopleSoft PS/Query / Crystal reports. / 5.5
D4iS Solutions
21 / D4iS Solutions / Project manager/Analyst / Programmer / develop a solution on .NET to support the D4is Methodology. / 11-09 to 01-10 / Leader / Architect / Developer on .NET application / 2.5
20 / Université Laval (Québec) / Analyst, develop and maintain an ETL BI solution d’Informatica distributed on a real-time multiplatform Oracle database. / 09-07 to 10-09 / Consultant and Informatica ETC senior analyst. Programmer / develop an integrate Power Exchange and Power Center in Real-Time exchange central point. / 26
19 / Brookfield Power generating and marketing operations / BI Informatica, ETL developer and Data Modeller Process Designer for the Brookfield Actual, planning and corporate financial forecast / 09-06 to 08-07 / BI Informatica, Extract Transform Load Developer and ERStudio Process Designer / 12
18 / INSPQ / BI Analyst of the complete SISAT ‘portefolio’ environment / 05-06 to 08-06 / Team leader and senior BI Analyst / 4
Télédoo Communications
17 / Public / IT Manager and Broadband Wireless WI-FI Communications Specialist / 11-04 to 02-06 / IT Manager and Broadband Wireless WI-FI Communications Specialist / 15
Independent Consultant
16 / UBS AG Bank of Switzerland / Analyze, Develop and maintain reports for the Wealth Management & Business Banking (WM&BB Switzerland) / 04-03 to 10-04 / PSQuery / Crystal Consultant / 19
15 / Groupe Danone France (Paris) / Analyze, develop and maintain PeopleSoft Crystal reports / 11-02 to 01-03 / PSQuery / Crystal Consultant / 2,5
14 / Agriculture Canada / Analyze, develop and maintain Brio Crystal reports and Oracle SQL/SQR / 07-02 to 09-02 / Query / Crystal Consultant / 3
13 / National Defence (DND) / Team lead / Analyze and Develop Military training information conversion code/process / 10-01 to 06-02 / Team leader and programmer / analyst / 9
12 / City of Ottawa / Analyze, develop and maintain Brio Crystal reports and Oracle SQL/SQR / 03-00 to 09-01 / Query / Crystal Consultant / 18
11 / Ernst & Young International / London UK / Analyze and develop an Oracle SQL/SQR base program to standardize future development / 11-99 to 12-99 / Oracle SQL/SQR Consultant / 1,1
10 / Correctional Services Canada / Analyst, develop and maintain Brio Crystal reports and Oracle SQL/SQR / 07-97 to 11-99 / Oracle SQL/SQR Consultant / 29
Bank of Canada permanent employee
09 / Bank of Canada / Implement PeopleSoft Hr suite and Analyze, Develop and Maintain Brio Crystal reports / 1994 to 1997 / Business System Analyst / 42
Independent Consultant
08 / Information Holding Management Branch / Programmer/analyst for a multimedia center / 01-93 to 12-93 / Programmer / analyst / 12
07 / Environment
Canada / Analyze, develop and maintain VAX/VMS systems and DEC/Pathwork topologies / 01-89 to 12-92 / DIGITAL system Administrator / 48.1
CGI Group Consultant - Permanent employee
06 / Elections Ontario / Develop and implement a full management integrated porte-folio / 12-88 to 11-89 / Programmer / analyst / 12
05 / La Communauté régionale de l'Outaouais / Develop and implement civic system modules and trained system personals / 11-88 to 11-88 / Programmer / analyst / 1
04 / Agriculture Canada / Analyze, develop and maintain a system to integrate and control horticulture tariffs called "Snapback". / 06-88 to 10-88 / Programmer / analyst / 5
03 / National energy board / Analyze, develop and maintain a watching pipelines exploitations companies financial request system / 03-88 to 05-88 / Programmer / analyst / 3
02 / Canada Post / Analyze, develop and maintain COBOL and d'IDMS system programs / 01-88 to 02-88 / Programmer / analyst / 2
01 / City of Gatineau / Analyze, develop and maintain many informatics’ systems / 06-87 to 12-87 / Programmer / analyst / 7
* : This total does not consider the vacation periods. / 329,7*

SKILLS you required where M. Guevremontcan FULFILLS your expectations:

  • Strong understanding of databases, metadata, data access code and performance issues
  • Proven ability to deal with complexity and solve difficult problems
  • Ability to work well both within a team and unsupervisedor lead the team when the mandate is given
  • Proficiency in object-oriented software design, and development.
  • Demonstrable expertise with Web environment: PHP4/PHP5, SQL, MySQL, HTML/XHTML, HTML5, CSS, XML/XSLT, JavaScript, AJAX, open-source tools (CPanel, OpenCart…)
/
  • Data Warehousing- Proven experience in development of enterprise level data warehouse(s), data marts and data integration solutions.
  • Database Design-modeling experience, with good understanding of both relational and data warehouse data modeling standards. Experience with enterprise databases- MS SQL Server, Oracle.
  • Informatica Administrator-experience with Informatica multi-Installation, documentation and Informatica Administration.
/
  • Data Integration- design and development ETL/SQL processes using industry standard ETL tools e.g. DI, MS. ETL to cover batch and real time integration.
  • Reporting-experience with report design using enterprise reporting tools (e.g. SAP Crystal Reports 2014, Cognos, MS or others)
  • Software Lifecycle-experience with agile development, unit tests, build scripts and the deployment.
  • Analytics -experience with OLAP technologies

WORKING EXPERIENCES
Project 28
Mars 2016
to
September 2016 / Role: OTTAWA UNIVERSITY
Programmer Senior Analyst in ETL Oracle Data Integrator
Details and responsibilities for the Project :
Working with University of Ottawa Deloitte PeopleSoft team, my responsibilities was to Develop and implement mappings, process and Load Plan using Oracle Data Integrator (ODI ETL/ELT) to extract PeopleSoft Campus Solutions data to load anOracle data Warehouse used to support all the Ottawa University Business Intelligence (BI) requirement. / Oracle Data Integrator (ODI ETL/ELT)
PeopleSoft
PL/SQL Developer
Project 27
August 2015
to
December 2015 / Role: TRANSCONTINENTAL MEDIA, Manufacture Efficiency and Radius SAP Crystal Reports analyst and developer
Details and responsibilities for the Project :
In and after the acquisition of the Capri Packaging, a producer of flexible packaging, operating two facilities located in Clinton, Missouri. M. Guevremont as a member of the Manufacturing Efficiency and with the factory manager, start by Analyze, Propose, Develop and Implement Manufacture Efficiency Solution using SAP Crystal Reports 2014 in a Radius Progress and Windows Server environment. / Radius Manufacturing 15.11
SAP Crystal Reports 2014
MS Office 2010
Project 26
March 2014
to
May 2015 / BROOKFIELD RENEWABLE POWER, System Analyst as Informatica specialist
Role: Analyse, propose, develop and implement Informatica ETL Data Integration solutions to convert iWay Information Builders PFlow into Informatica PowerCenter 9.6.0 upgraded to PowerCenter 9.6.1 and 9.6.2 , plus many Server installation.
Details and responsibilities for the Project :
As an IT analyst and Informatica Integrator Solutions, M. Guevremont start by converting all theiWay Information BuildersPFlow data flows to Informatica mapping and workflows base on the analyzedand specifications previously created and documentedby the internal team.
During his mandate, M. Guevremont Develop new and maintain existing Informatica process,produce specifications, ETL process, unit tests, mappings and workflows, Stored Procedures and Functions linking Web Services and many other external Services.
In the role of the Informatica Server Administrator, M. Guevremont validate, install and document Informatica multi installations onto VMWares Server environment.
M. Guevremont participate in functional test planning and testing for the developed convert Informatica ETL, he also was a problem solver and troubleshooting for the Informatica Power Center 9.6.0 installationupgraded to 9.6.1. As usual, M.Guevremont documents all new and modified works according to current Brookfield standards. / Informatica Power Center 9.6.0 upgraded to 9.6.1 and 9.6.2
Informatica Administrator Console
SQL/ PLSQL Oracle
PLSQL Developer 10.0.5
SQL Server management Studio
Widows Server 2008 R2 Ent.
Oracle 11g
My SQL
Project 25
December 2012
to
November 2013 / Constructions BRIGIL, DBA and IT leader and specialist.
Role: Restructure data flowing between all departments, analyse, propose, implement and lead solutions for different department data redundancy problems.
Details and responsibilities for the Project :
As anIT analyst and Solutions leaders, M. Guevremont start by analyzing all the data flows shared between departments and propose to the steering committee a central database solution with high Open Source reputation with what, the entire department will share their data. After the acceptation and the installation of a new server, M. Guevremont start by configuring and setup the server, immediately after, he install and configure PostgreSQL (The database), Talend Open Studio (the ETL software) and create all the appropriate ODBC required to link all the sub system and database. During his mandate, M. Guevremont also act as the Microsoft Office user support and develop for them, extensive Excel and Word macro to reduce time spend on multiples tasks.
As requested by the client, Mr. Guevremont trained the internal staff using the one to one approaches, and produced many steps by steps procedures and sources codes documentation. / Open Sources
- SQL/ PLSQL Talend Open Studio for data Integration 5.3
PostgreSQL Tools 1.16.1 Full Oracle compatible
MS Office 2007,2010
Masetro Construction Software
Project 24
October 2011
to
November 2012 / Freelance, DBA and IT leader and specialist.
Role: Analyse, propose, implement and lead solutions for different small clients. Mostly Web Site support, development and graphics designs.
Details and responsibilities for the Project :
For many small contracts, M. Guevremont help different client to accomplish their need. M. Guevremont has been aside of each client to help them on every IT levels and develop small applications to make sure they have a happy informatics development. / CS-6 Adobe Master Collection
MS Office 2007,2010
CPanel, Dreamweaver
Project 23
July 2010
to
September2011 / Public Health Agency of Canada (PHAC) Information Management\Information Technology Directorate (IMIT). Data support section.
Role: Provide ETL Informatica mentorship to the ETL programmer’s team, analyze, optimize, develop and maintain Informatica Business Intelligent and technical design specification.
Details and responsibilities for the Project :
As a PHAC/IMITcontractual Full Time andETL Informatica mentorshipstaffs, Mr. Guevremont main responsibilities was to propose and develop new optimize BI Architectures approaches for the Canadian Notifiabe Disease Surverillance System (CNDSS) Infectious Disease Reporting System (IDRS). The achieved objective of the CNDSS system was to collect the mass of data coming from all the medical institutions establish across all the Canadian provinces. The solution now summarize and transform the collectedhealth data and load the result into a data warehouse use has a central Cognos framework, for the PHAC statisticians planning different Canadian health decisions and scenarios. Furthermore, during his mandate, Mr. Guevremont participates in the Informatica 8.5 to 8.6 upgrade. / Informatica Power Center 8.5 and 8.6
SQL/ PLSQL Oracle
Oracle 11g
MS Office
TOAD 9.0
RDIMS government email system
Project 22
January 2010
to
June 2010 / La Cité collégiale– Informatics staff Ottawa.
Role: Analyze, Optimize, Develop and maintain Business Intelligent BI PS/Query Crystal reports, including staffs trainings.
The development platform was Windows based on Oracle 10g, PeopleSoft 8.46, WEB PS/Query, Crystal Reports and Windows Vista & XP.
Details and responsibilities for the Project :
As a La Cité collégialeTemporary Full TimeInformatics staffemployee, Mr. Guevremont main responsibilities was to propose new optimize BI Architectures approaches and oversee thedata reports record mappingand designs to optimize BI responses performance for the actual andfuture PeopleSoft PS/Query / Crystal development and maintenance solutions. Further more, during is assignment and as a request from the client to ensure the knowledge transfer. Mr. Guevremont acted as a reports and extraction information mentor. To fulfill the client requirement, Mr. Guevremonttrained and refreshes PeopleSoft PS/Query / Crystal knowledge of the internal staff using multiple workshops approaches, process and sources codes documentations. / PeopleTools Application Designer, Application Engine, Process Scheduler, Tree Security Manager,