Yann - Consultant SQL PLUS

Expérience professionnelle

National Bank of Canada, Montréal, Canada DataStage senior Developer
Aug 2018 to now

National Bank of Canada – Business intelligence service
My mission were to reinforce the operational efficiency team of the bank in charge of optimizations
and improving performances. I also interact with the DBA, some analysts and other developers in
an agile process in order to find the best way to deliver continuously. I am also a team member of
the production support team in charge of monitoring the technical environment and make continuous
reporting of the production environment.
My tasks
• Daily meetings with the different teams (operations & Development)
• Optimization and improvement of process performances (DataStage)
• Infosphere Governance Catalog editor and reviewer
• Technical coaching
• 24/7 production support
• Agile method (Scrum)
• Documentation on a SharePoint/wiki to capitalize the technical and functional actions

Facilite Informatique, Montréal, CanadaDevops Developer Aug
2017 to now Nationa l Bank of Canada –Business intelligence service
My mission as a consultant were to reinforce the operational efficiency team of the bank in charge
of optimizations and improving performances. I also inter
act with the DBA, some analysts and other developers in an agile process in order to find the best way to deliver continuously.
I am also a team member of the production support team in charge of monitoring the technical environment
and make continuous reporting of the production environment.
My tasks
Daily meetings with the different teams (operations & Development)
Optimization and improvement of process performances(DataStage)
Technical coaching
24/7 production support
Agile method (Scrum)
Documentation on a SharePoint/wiki to capitalize the technical and functional actions Windyam Yann Régis ********
BNP Paribas
–Leasing Solutions
My mission as an analyst developer were to work with the different chiefs of services on the
common data shared by their different services.
I also worked to give a score for each professional
client of the bank based on many criteria in
order to determine their solvency when they are asking for a credit. The professional client were
the unique enterprises or the enterprises which have branches in Europe.
My tasks
Analyze of needs and conception of specifications with project managers
Project costings
Development of DataStage jobs/sequences
Scripting SQL and KSH
Redaction of tests using ALM
Technical Coaching.
Sopra Steria, Aix en Provence, France
DataStage Developer and integratorSep 2016 to May 2017 Pole Emploi –AGSID
This business intelligence project has for functionnal principle the individuals’career managment for who the company is near liquidation.
The individuals whose companies are part of the group AGSID will be not only compensate until their company
closes but also will be accompanied in their job seeking.
My tasks
Development of DataStage PX jobs/sequence
Development of SQL and KSH scripts
Redaction of qualification and acceptance tests
Redaction of unit test files via Excel
Partial support to the acceptance and integration teams to the customer
Redaction and diffusion of technical and professional documentation to the teams
Meeting event to the customer for the production
In charge of the delivery to the customer for the center of service
Windyam Yann Régis ********
Citizenship: French
Skype: yannzongo
Sopra Steria, Aix en Provence, France
DataStage Developer and conceptor
Sep 2015 to Sep 2016 Pole Emploi –SISP
This business intelligence project has for functionnal principle to federate a few business applications for the customer Pole Emploi in France.
My tasks
Development of DataStage PX jobs/sequence
Development of SQL and KSH scripts
Redaction of qualification and acceptance tests
Technical coaching of trainees et new comers
Redaction of unit test files via Excel
Participation to modelization and specifications
Redaction of technical and specification documents
Partial support to the acceptance and integration teams to the customer Sopra Steria, Aix en Provence, France
DataStage Developer Feb 2014 to Sep 2015 Pole Emploi –STMAT
This business intelligence project has for functionnal principle
the implementation of the labour market statistics in France.
In other words we provide to the unemployment figures to the DARES,a department of the labor ministry in France.
The DARES then applies from the figures received some new statiscal rulesin order to publish each month the real unemployment figures.
The DARES is a department of the labor ministry.
My tasks
Development of DataStage PX jobs/sequence
Development of SQL and KSH scripts
Project costing
Redaction of unit test files via Exce