Luís Sousa Email & Phone Number

Porto, Portugal

- Empower E-commerce teams to make faster, data-driven decisions through advanced data analysis and streamlined process automation.- Design, develop, and maintain intuitive dashboards, enhancing report clarity and performance for better insights.- Conduct comprehensive data analyses to identify key customer segments and evaluate campaign performance, supporting the development of new initiatives.- Monitor ETL processes to ensure accurate data integration, swiftly resolving issues to maintain data integrity.- Create conceptual, logical, and physical data models that align with business strategies and processes.- Implement and manage data integration solutions with Microsoft Integration Services; ensure accurate integration for OLAP Cube and new developments.- Leverage batch files and PowerShell for automation tasks, facilitating seamless data exchange with FTP servers and applications like Outlook and SharePoint.- Lead the migration of data models to Azure Databricks using PySpark, optimizing performance while ensuring compliance with business requirements.- Tools: SQL Server, Excel (Power Query, Power Pivot, and VBA), Microsoft Visual Studio (SSIS, SSAS) MicroStrategy, Azure Databricks (PySpark)

Porto, Portugal

- Enabling faster and better decision-making by Jumia leaders as well as automation of processes- Developing new dashboards & maintaining and optimizing existing reports- Data exploration to understand current data availability; data mining in order to propose new analysis and evaluate the feasibility of fulfilling new information requests from management- Ensuring that the data contained within the business reporting is accurate, clean, and in line with the definitions as per the business function owner- Contribute to preparing data requests for systems teams in order to facilitate the automation of the reporting domain- Tools: PowerBI (DAX), SQL Server, Data Lake, Big Data (HUE - HIVE), JIRA, Confluence

Maia

- Verification of invoices related to carriers and resolution of discrepancies- Approval of freight invoices for payment- Efficient workflow management in collaboration with the accounting department- Collaboration with the respective warehouse managers to resolve discrepancies- Quality management of customs documents declared to US customs authorities- Realization of reports, controls, KPIs reporting, and Ad hoc analysis- Support to local teams with reports related to cost and customs control- Tools: SAP, Excel (PowerPivot, Power Query, and VBA), PowerPoint

Maia

- Freight invoices auditing: Quantity, Weight, Incoterms and Value- Customs entries validation: Quantity/Weight, HTS and Value

Porto

- Data Collection and processing of the funds' repayment under the POCH (Programa Operacional Capital Humano)- Technical-Pedagogical Dossiers validation- Support in the inventories' preparation

Porto

- Promotion of new products and services- Providing technical assistance in electronic equipments - Clarification of the conditions and the functioning of products and services

Porto

- Promotion of new products and services- Providing technical assistance in electronic equipments - Clarification of the conditions and the functioning of products and services

Postgraduate, Business Intelligence And Analytics

Database & Data Intelligence Academy

Administration of Microsoft SQL Server 2016 database management systems: design, build and implement solutions that make increasing.

Bachelor, Business Administration