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. Turn the product backlog in sprint backlogs (user stories, acceptance criteria, estimate, definition of done...) Write-up workshops minutes of meetings, traceability matrix of functional points, agendas, functional documents Design (model) datamart: conceptual, logical and physical models (SAP Power Designer) Develop SQL scripts to create the datamart structure in DEV, TEST, QA environments (Oracle 11g) Develop ETL flows (mappings, workflows...), execute with Unix scrips, integrations, tests (Informatica)
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 t
Context Such as a BI Consultant and Confirmed BI Consultant (2nd year) at ATS (Accenture Technology Solution) in Paris (France), I have worked for two clients in France and Switzerland (Finance and Banking). My role (inside 4-8 people teams) was to analyze functionally and technically and develop Business Intelligence solutions (ETL, Reporting, Data Visualization) Tasks – Business Analyst Role (All these tasks concern deliveries such as DB/ETL/Universes/Reports deliveries) Received the requirements of the worldwide agencies on Lotus platform (new projects, correction, evolutions...) Analyzed and described the potential viable technical solution to implement Defined detailed costings depending of the technical solution and the available resources (in d/m) Wrote-up or updated functional and technical specification that explained the new/corrected/evolved solution Tasks – Technical Role Developed and tested SQL scripts for creation or updates of datawarehouse
Tasks Managed data with MySQL and data quality with Talend for Data Quality Designed BI models with MySQL Designer and extracted, transformed, loaded data with Talend DI Developed Qlikview dashboarding applications: dashboards with Qlikview 11.0 Integrated data from MySQL into Qlikview 11.0 for analysis and visualization Wrote-up and updated technical specifications Technical Environment Qlikview 11.0, Talend Data Integration, Talend for Data Quality, MySQL, Microsoft Office 2011 (Vision, Word, Power Point, Access)
Context Such as a BI Specialist Assistant in the division Business Survey Methods and Analytics (project team of 20 people), my role was to participate to a project about the Statistics Canada survey decision making, strategic decision, in order to reduce the global cost of the project. Tasks Extracted, transformed and loaded complex SAS data with macros developed on SAS Base Applied a ‘RAKING’ process (iterative process) to manage data quality and get estimated data Data Analysis – OLAP: compared the produced data with the estimated data Intensive Learning in the Statistics Canada Institute + Seminars / Conferences Organization o SAS Beginner and Advanced Levels o Big Data For New Analytics View Technical Environment SAS Base, SAS Enterprise Guide, SAS Graph, Oracle 11g
Wil je CV's van professionals downloaden? Bekijk onze opties voor recruiters.