João Paulo Bamberg

• Led the Microsoft Fabric implementation project, delivering a new data architecture with data pipelines, notebooks through a medallion architecture with RLS and DevOps control. (PySpark, SparkSQL, T-SQL, Azure DevOps…) • Delivered an end-to-end process control project over our sales team in Hubspot, controlling our deals and operational output, automating middle funnel strategies and prospecting, retrieving data through their API, creating dashboards, playbooks and procedures to analyze and control the sales team in an operational and tactical level as well as creating cross sales opportunities. (PySpark, Data Flow Gen2, Power automate, Power Apps…)

- Developer and responsible for data warehouse structure, ETL routines and maintenance of API's connected on Pentaho Data Integration/Python (Mainly pyodbc) /Power automate. - DataOps project management using SCRUM & Final review Lead. (Click-up) - Project developer for data analysis/business scalability in Power BI, Power Automate, Power Apps, VBA, Python and SQL. - Responsable for dealing with international stakeholders. (All LATAM) Tools: SSMS (SQL Server), Power BI, Tabular Editor, DAX Studio, Power Automate, Excel (Power query and Power pivot), Figma (Design), Canvas, Azure SQL DB, Azure VM's + Active Directory, Azure Data Studio, Power Point, Planner , Pentaho Data Integration, SQL Analysis services. Languages: DAX, M , Python, SQL, VBA.

- Dashboards and Report development in Power BI to generate operational control and tatical analysis. - UI/UX Dashboards Improvement with Figma. - Project management, requirement analysis and project architecture on BI or automation iniciatives. - Procedures development and automations. - Meetings leadership with international teams to share insights over the company and support a data-driven culture. - Extract, Transform and Load procedures on many data sources. (SQL, Sharepoint, Excel, PDF...) - Develop automations to create scalability between operational and financial teams. - Management of Azure SQL Enviroment. - Development of relational models, measures and complex analysis. - SQL Development on SSMS/SQL-Server. Projects: - Power BI Dashboards in diverse areas and stakeholders. (Financial, operational, HR, C-Level...) - Power Automate, VBA and Python to develop process automation. - Procedures review and innovation. - Development of the ETL/SSAS main structure of the company.