Yann - Consultant SQL PLUS
Ref : 180502Z001-
H1V1A6 MONTREAL (Canada)
-
Consultant, Développeur (33 ans)
-
Freelance
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
TECH NICAL SKILLS
ETLDataStage PX 11.5, DataStage PX 9.5, DataStage PX 8.1Databases Netezza, Oracle SQL Developer , Toad Method and process Scrum Development Process OtherTraining, Conception, Specification,
Test, Qualification,
Client Support Infrastructure & OS Linux, Windows
Programming Languages Korn Shell, PL/SQL, SQL, Python
languages
French (mother tongue), English(Operational)
FORMATIONS
2014Polytech Marseille: (School of engineering and applied science) , Industrial Engineering and Computer Science, major in computer science Relevant coursework: Project management, Database management, Methods and conceptions tools for computer science and quality control
2011Polytechnical University of Bobo-Dioulasso
(school of engineering in computer science), analysis and programming.
Relevant coursework: Mathematics, algorithms and programming languages.