Senior BI Consultant | Architect

12/2017 – 12/2019

• Applied a high level of professionalism, structured sense of organization and qualitative way of communication to prepare, schedule, drove, present workshops meetings to the project worldwide actors: IT teams (BI, DBA, Infra based in UAE, India), businesses (based in UAE, Irak), systems vendors (based in Greece).
• Guided strategic workshops with suitable communication in order to capture/take the target needed information about the initial needs/ requirements from the businesses, transform the businesses requirements into a data warehousing system and BI analytical solutions.
• Turned PM and BI strong knowledges into practice in order to design/write-up and present the project calendar complete roadmap, divide the project roadmap into several deliveries’ packages, anticipate the resources non-availabilities, potential changes of scope of work.
• Applied Agile/Scrum, Product Owner qualified skills to quickly take in consideration the stakeholders priorities requests, organize the project in features, EPIC, releases, sprints, keep up-to-date the product backlog.
• Engaged BI strong technical expertise + interactions with the internal teams (DBA, Infra) to design/define the right maintainable and performant new data warehousing system (infrastructure architecture, data strategy, data governance, approaches of building a data warehousing system, Power BI dashboards/reports mock-ups).
• Wrote-up the high level and detailed project costing: delivery packages, features, EPIC, users’ stories, tasks (complexity level of development, seniority of the resource, % risk, dependencies…).
• Applied BI management strong competences by onboarding, carrying-out and completing the global functional analysis with two other BI team resources: prepared/planned/carried-out workshops, wrote-up functional and technical BI specification documents; trained and improved the level of the BI team as a leader.
• Used acquired competences from professional past experiences in order to manage, train and interact with international and multicultural teams’ mates: BI team (India, Poland, Turkey), DBAs (Philippines), Infra (Egypt).
• Managed and controlled the quality of the deliverables (Modeling, SQL, ETL, SSAS, Power BI…) - Supported the BI team about the technical developments in order to respect the deadlines, rules, BI guidelines and methodologies.

Business Intelligence (BI)

8/2017 – 8/2018

Context
BI Consultant inside the MiFID Reporting Squad (TRIBE BI), I am responsible of the delivery of the product MiFID Reporting – Audimart. The objective is analyze functionally the solution, design, implement and load the datamart that contains MiFID Regulatory Reporting data and that enable to stakeholders to control banking transactions.

Project Coordinator (Internal Stakeholders/IT Teams/Testers) / Functional BI Consultant
• Organized structured and strategic weekly meetings with the stakeholders in order to keep all the attention of the attended participants and all the information needed to carry-out the business and functional analysis of the useful BI solutions to build.
• Established and wrote-up presentable and referenced workshops supports in order to keep the project follow-up and traceability (workshop supports presentations re used by the team mates).
o Traceability matrix and functional points discussed in meeting (with status).
o Agendas of Workshops, Minutes of Meetings with the updates historic.
• Exchanged and frequently communicated with the internal IT teams (transversal scrum teams - functional analysts) and the technical developers of the MiFID scrum team to identify the sources data, ensure that the BI solution functional specification was up-to-date within the development’s status, ensure about the viability of the developed solution.
• BI Data Modeling - Applied strong competences, knowledges and SAP best practices to model the conceptual, logical and physical models of the datawarehouse and the datamarts by keeping a high level of traceability in the deliverables (Inmon Approach).
• Wrote / Kept up-to-date the Mapping Sheet Document (ETL Technical Specification, Source/Target).
• Designed and built unitaries and business tests plans; structured in scenarios, sub scenarios, tests, sub-tests, design steps with descriptions and status (implementation and execution on HP Quality Center).
• Developed structured SQL Scripts with comments (current product versions, changes references, dates...) to ensure a high-quality visibility in the SQL code and the deliveries listings to integrate in the other environments

Support - Product Owner Role
• Strong add-value in the product ownership defining, keeping up-to-date the living products backlogs with the corresponding PBI’s (Stakeholders, Development Team...) / Features / User Stories (Product Backlog Grooming).
• Communicated with a strong BI technical expertise (all projects steps) and brought a high-level project vision: assign estimates (in term of effort, time, risk) on the user stories and tasks, turn the product backlog in sprint backlogs (features, EPIC, user stories, tasks, acceptance criteria, definition of done...), define the releases and sprints planning (respectively during QAPs and sprint planning meetings).
• Increased the quality and the performance of the team by drafting, generating and presenting AGILE performance charts (monthly) such as releases burn down/up charts as well as sprints burn down/up charts.

Support - BI Architecture
• Responsible of the design of the data architecture schemas and updates (high level and detailed views).
• Sent the built schemas to the architecture board direction of the bank for approval.

SAP BusinessObjects (BO), Crystal Reports, Informatica, Agile Methodologie, Jira

9/2016 – 6/2018

Context
Integrated in the department Cloud Analytics of Amazon Services (entity Costa Rica), sub-contracted by a consultancy company, my role of project manager is to manage two (2) Agile teams about the development of BI analytics solutions and reports delivered for banking end users located in Central America and Caribbean market (Wealth Management); and report the team performances + results to the Sr Project Manager. From Sept 2016 until May 2017, work on site and work in remote (50% - night hours) from June 2017.
Tasks – Management Role
 Follow-up advancement of the teams and performance reporting with JIRA
 Generate project follow up advancement KPIs – Drive the project between the business and internal teams
 Built monthly reports about the squad teams performances and sent to the general directions.Tasks - Product
Owner Role
 Define the product vision with the stakeholders
 Build and update the products backlogs with the stakeholders and development teams’ items
 Assign estimates (in terms of effort, charge, complexity) in collaboration with the development teams
 Prioritize the stakeholders’ product backlog items (PBI) aligned to the up-to-date requirements. (each sprint)
 Build the products release/sprint burndown(up) charts for presentation at the sprint review meetings (in Spanish)
Tasks – Technical Role
 Business Intelligence solution applicative management (maintenance): DB (Sybase IQ), ETL (Informatica)  Develop complex SQL scripts (packages PL-SQL), Procedures, Trigger, CREATE, UPDATE + test
 Develop/update of the Informatica/Datastage dataflows on the BI architecture + test
 Develop and update SAP Business Objects universes (30) with associated specification + test
 Develop and update SAP Business Objects Webi documents (55) with associated specification + test
o Creation of the new reports: blocks, sections, entry controls, documents and reports filters
o Webi complex queries: sub-queries, operators of joins, queries crossing, union, intersections...
o Management of the user’s right accesses (LDAP / Universes access / Mode Full, Semi and Reader)
Technical Environment
JIRA, IBM Datastage PX, Informatica Power Center, SAP Business Objects 4.1 (Crystal Report, Web Intelligence, Design Studio, Lumira), HP Quality Center

Business Intelligence (BI), Data Warehousing, SAP BusinessObjects (BO)