jeanrodrigot

Most relevant resolved issues: ✔️ Creation of dashboards to improve the performance of the sales team and calculate market share for a client with 10-digit global revenue in dollars in the cosmetics industry. ✔️ Data governance with RLS in Power BI dashboards for a client with 11-digit global revenue in dollars in the plastics industry. ✔️ Correction of a formula in a BI system, reducing an SLA from above 5% to 2%, preventing the company from facing a huge fine for not meeting the service target. ✔️ Performed and tuning complex SQL queries to extract data from the database in service desk sector. Applied processes and tools used: ✔️ Data Ingestion (Azure Data Factory, Pipelines, ELT); ✔️ Data Storage (Azure Data Lake Storage, Big Data); ✔️ Data Transformation (Azure Databricks, Python, Pandas, Pyspark, T-SQL); ✔️ Data Modeling (Azure Synapse Analytics, DataBase, Star Schema, Data Warehouse, Power Query M); ✔️ Data Visualization (Power BI, DAX, Direct Query, Measure Killer, Tabular Editor, Dashboard, Report); ✔️ Data Governance (Power BI Service, RLS, DataFlow); ✔️ Agile Methodologies (Kanban, Planner); ✔️ Other tools (Excel, Power Automate, SharePoint, OneDrive, Postgre, Dbeaver, Zoho, Power Point)

Most relevant resolved issues: ✔️ Creation of a package of indicators for the hospital industry. ✔️ Creation of a heat map to adjust supply and demand of doctors. ✔️ Performed and tuning complex SQL queries to extract data from the database in a big hospital. Applied processes and tools used: ✔️ Data Modeling (Oracle, DataBase, Star Schema, DataWarehouse, PL/SQL, ETL, PowerQuery M); ✔️ Data Visualization (PowerBI, DAX, Figma, Dashboard); ✔️ Agile Methodologies (Kanban, Trello) ✔️ Other tools (Excel, Postgre, ODBC, Dbeaver, PowerPoint, Weknow, Metabase)

Participation in the creation of a dashboard to monitor revenue and stock of distributors of a large agribusiness company.

Most relevant resolved issues: ✔️ Participation in the creation of a dashboard to monitor revenue and stock of distributors of a large agribusiness company. Applied processes and tools used: ✔️ Data Modeling (Amazon Redshift, Dremio, DataBase, SQL, Data Warehouse, ETL, Power Query M); ✔️ Data Visualization (Power BI, DAX, Dashboard); ✔️ Data Quality (Excel); ✔️ Agile Methodologies (Scrum, Kanban, Azure Boards);