João Gomes Email & Phone Number

Porto, Portugal

I work as a Business Analyst, collaborating with stakeholders to translate business needs into technical solutions. My focus is on analyzing requirements, performing data analysis, and working closely with development teams to deliver impactful solutions. I specialize in projects related to financial statements, credit risk, ratings, credit defaults, recoveries, and ESG, using Power Platform and BI technologies.Key Responsibilities:- Gather and document business requirements for financial, credit risk, and ESG projects.- Perform data analysis to support the development of Power BI reports and dashboards.- Liaise between business and technical teams to ensure alignment with project goals.- Assist in migrating data from legacy systems (Excel/SharePoint) to SQL databases, improving report accuracy and performance.- Create and maintain technical and business documentation.- Provide ongoing support for existing systems, continuously identifying opportunities for improvement.Key Achievements:- Delivered comprehensive reporting solutions for financial statements, credit risk assessments, and ESG compliance.- Improved system performance through migration to SQL databases for key financial and credit reporting.- Enhanced collaboration between business and technical teams, resulting in more efficient project outcomes.- Developed Power BI dashboards that empower business units to make data-driven decisions.Tools and Technologies:PowerApps, Power BI, Power Automate, SQL, Snowflake, DB2, Oracle DB, Excel, SharePoint, Jira, DAX, M Query

Multiple projects in different areas like transportion, logistic, health and energy. Analyze the requests of theclient and implement in the right way possible. Experience in SQL, Power BI, Power Apps, Power Automateand Power Query.

Porto, Portugal

As a Business Analyst at Efacec, I was responsible for gathering business requirements and developing solutions using the Power Platform. I led the migration of workflows from Excel to Power Platform, enhancing efficiency and automation across various business processes. Additionally, I developed Power BI reports to provide insights into project management, commercial leads, stock analysis, and operational control. I also implemented Power Automate flows to streamline workflows, improving delivery times and allowing the team to focus on high-value tasks.Key Responsibilities:- Collected and analyzed business requirements from stakeholders, translating them into effective technical solutions.- Developed Power Platform solutions to migrate workflows from Excel, enhancing operational efficiency and data management.- Created multiple Power BI reports to support project management, commercial leads, stock analysis, and operational control.- Designed and implemented Power Automate flows to automate key workflows, increasing productivity and freeing up time for more critical work.- Collaborated with cross-functional teams to ensure the successful deployment of solutions that met business needs and improved overall performance.Key Achievements:- Successfully migrated legacy Excel workflows to Power Platform, reducing manual tasks and improving workflow efficiency.- Developed insightful Power BI reports that enabled better decision-making across project management, sales, and operations.- Streamlined operational workflows using Power Automate, leading to faster deliveries and more time allocated to high-priority tasks.Tools and Technologies:PowerApps, Power BI, Power Automate, SQL, Excel, SharePoint

Porto E Região, Portugal

Operationalization of the project within the deadlines and budgets foreseen, ensuring the integrity of the technical solution, as well as the standardization of the technical solutions implemented.

Master'S Degree, Bigdata & Decision Making

Degree, Management, 15

Education record