Lazare Essono

System migration, data model optimization.

Redesign and optimization of financial investment applications, SGBD improvement. Support the PO for Product Backlog organization and contribute to Data Management.

• Requirements gathering: collect and analyze user requests regarding data and business.

• Translate requirements into stories and work closely with the 'PO'.

• Write functional specifications for developers.

• Assist in the development of various database systems.

• Provide support and maintenance for data and BI applications and tools.

• Ensure data quality in compliance with current regulations.

• Translate needs into functional and technical specifications.

• Testing via SQL, DENODO, POWER BI queries.

• Contribute to proposing solutions for application rationalization.

• Conduct various testing sessions via X-Ray and analyze discrepancies.

• Support users post-production.

Technical Environment: NET, AZURE, Power BI, Denodo, Snowflake, MS SQL, XRay, Postman.

As part of the improvement of the course and personnel management tool at ULaval, my intervention focused on two areas: (1) coordinate and monitor project progress while reporting to project management, (2) assist developers as a BA.

• Assess the existing situation (understand and read PL/SQL code).

• Write functional specifications for the new application.

• Implement improvements requested by the business unit and clients.

• Collaborate with business partners on requirement definition and product backlog management in Jira and Confluence.

Redesign of applications developed in COBOL and PL/SQL, and code and database refactoring on obsolete systems.

• Act as Backlog owner for projects.

• Ensure the solution aligns with business needs.

• Establish deliverable stories according to the Product Manager's orientations and priorities.

• Prioritize sprints to maximize delivered business value.

• Prioritize stories and project requests.

• Diagnose issues, challenges, needs, and problems to be solved within the multidisciplinary team dedicated to your squad to agree on the targeted outcomes.

• Define acceptance criteria and use cases.

• Review and approve deliverables.

Technical Environment: Power BI, Database, Oracle-PLSQL, Miro, HPLM, XRAY.