Garcia Rogério

Data Analyst

Winning Consulting•  February 2024 - Present•  Lisbon, Portugal

● Designs and develops robust Power BI dashboards to monitor project progress and track employee performance metrics, enhancing overall transparency and efficiency within the organization ● Reduced over 95% of time spent searching for and organizing missing employee timesheets, while identifying and rectifying those filled incorrectly ● Applies row security level to ensure data protection and security ● Conducts ad-hoc analysis for rapid decision-making and problem-solving

Continuous Improvement Data Analyst

Visteon Portuguesa•  October 2022 - January 2024•  Setubal, Portugal

● With SQL, Power Bi, Excel constructed & monitored monthly losses, reducing information search by more than 90% ● Reduced about 80% of data input time in failure roadmap using Excel VBA ● With VBA, Power Pivot and Power Query, constructed dashboards that allows team leader to share best practices and Kaizens within Visteon corporation and monitor the projects that lead to these improvements ● Presented solutions to address threats and weaknesses of SWOT analysis

Project Management Intern

Brainnest Consulting •  November 2021 - December 2021•  Bremen, Gemany (Remote)

● Collaborated with 5 coworkers to develop projects from business cases ● Utilized tools (like Gantt Charts, Jira, and WBS) to conduct the projects ● Presented the results weekly to an audience of 25 people

Logistics and Operations Trainee

idD Portugal Defense •  July 2021 - October 2021•  Lisbon, Portugal

● Constructed Process Mapping Diagram depicting inputs and outputs ● Developed KPI dashboards in Excel to monitor the production process ● Defined KPIs for evaluating the production process and production plan