João H.Data Analyst
Skills
Specializing in the transformation of raw data into actionable insights, this professional leverages a background in Production Engineering and a commitment to ongoing education in data analytics. Proficient in data analysis and agile methodologies, the focus is on enabling informed decision-making that drives business success. Key technical competencies include Python, SQL, Postgres, MySQL, Power BI, DAX, Power Query, Looker, and Google Analytics.
Data Science and Analytics Student
10/1/2023 - Present
Demonstrated expertise in consulting for relational databases using SQL with a focus on PostgreSQL, MySQL, and BigQuery. Conducted in-depth data analysis to extract valuable insights utilizing Power BI, employing DAX and Power Query for sophisticated data manipulation. Leveraged Python libraries such as Pandas and Numpy for advanced data treatment, and utilized Jupyter Notebook and VS Code for efficient code editing. Developed and built comprehensive dashboards using Power BI, ensuring effective visualization of data. Maintained collaborative code versioning practices using Git and GitHub. Applied statistical methods for thorough data analysis to support informed decision-making.Product and Analytics Intern
9/1/2022 - 12/1/2023
Leveraged expertise in relational databases using SQL through Databricks, providing consultation services. Conducted extensive data collection and analysis utilizing Excel, Databricks, and Google Analytics, ensuring accurate and actionable insights. Mapped requirements with various business areas to align technical implementations with organizational needs. Spearheaded the implementation of agile methodologies within a team, significantly enhancing productivity and organizational efficiency.Product and Analytics Intern
8/1/2021 - 8/1/2022
Developed expertise in building dashboards using Looker for data visualization. Proficient in data collection and analysis utilizing Excel and Metabase. Experienced in querying data within CRM software such as HubSpot and Zendesk. Provided support in backlog refinement and prioritization through Jira software. Constructed detailed documentation for features, APIs, and tables. Conducted comprehensive benchmarking and effectively mapped internal processes.Self-Employed Entrepreneur
4/1/2020 - 10/1/2020
Developed proficiency in marketing, sales, and SEO strategy, creating, managing, and analyzing metrics for campaigns on Facebook/Meta ADS and Google ADS. Utilized Google Tag Manager for efficient tag management and conducted competitor benchmarking and market analysis to inform strategic decisions. Offered exceptional customer service to drive engagement and satisfaction.Quality Intern
9/1/2019 - 11/1/2020
Achieved a 10% reduction in return cost indicator by spearheading an improvement project focused on the return process. Provided support in the cause analysis and development of action plans for Non-Conformity Records. Monitored key performance indicators (KPIs) and ensured the effective follow-up of actions. Utilized ERP systems, specifically SAP, to perform queries, input data, and generate insightful reports.
Production Engineering at Unichristus
2018 - 2023Data Analytics at Ada Tech
2023 - 2024
Data Science with Python | Potência Tech powered by iFood at DIO
9/1/2023Scrum Foundation Professional Certificate - SFPC™ at CertiProf International
4/1/2022User Experience at FIAP
12/1/2021DevOps & Agile Culture at FIAP
12/1/2021Lean Six Sigma Yellow Belt at Yokoten Desenvolvimento Pessoal e Empresarial
6/1/2021Agile Project Management at Universidade Presbiteriana Mackenzie
6/1/2021Microsoft Advanced Excel at Fundação Bradesco
5/1/2021
João is available for hire
Meet João H.
All Howdy Candidates are vetted for skills and english proficiency.
