William P.

Front-end UX Engineer

Billing Analyst
9/1/2021 - Present

Gained expertise in query language programming and data mining through extensive work on ETL (Extraction, Transformation, and Loading) processes and Business Intelligence projects. Delivered robust solutions leveraging SQL, cloud computing, and various data analytics methodologies, while focusing on enhancing operational efficiency and supporting business decision-making via tangible Key Performance Indicators (KPIs). Demonstrated strong analytical and critical thinking skills, utilizing tools such as Microsoft Excel, Microsoft Power BI, Power Automate, and PowerApps for data collection, analysis, and visualization.

Achieved proficiency in DAX (Data Analysis Expressions) for data modeling and interpretation, contributing to comprehensive data validation, acquisition, and integration practices. Created dynamic dashboards and reports using Microsoft SQL Server and Microsoft Power BI to provide actionable insights. Completed financial and business analyses employing Microsoft Office suite and operated within Microsoft Windows environments to ensure seamless data management and reporting.

Fostered a collaborative and communicative atmosphere, emphasizing teamwork and relationship-building during team integration activities. Developed a solid understanding of operational and cloud-based databases, including TOTVS Protheus. Demonstrated the ability to capture and interpret complex data requirements, producing accurate data models and visualizations to support strategic objectives. Enhanced skills in business intelligence and analytics through continuous learning and application of advanced computing and mathematical techniques.

Administrative Assistant
9/1/2018 - 1/1/2019

Excelled in advanced Excel functionalities, including data analysis, financial modeling, and pivot tables. Developed proficiency in creating complex formulas, including VLOOKUP, HLOOKUP, INDEX, and MATCH functions. Expertly utilized data visualization tools such as charts, graphs, and conditional formatting to present actionable insights. Implemented macros to automate repetitive tasks, significantly improving efficiency. Conducted data cleaning and transformation to prepare datasets for in-depth analysis. Leveraged Power Query for data extraction, transformation, and load (ETL) processes. Utilized Solver for optimization problems and What-If Analysis for scenario planning.

High School Diploma at Paulo da Gama State Institute of Education
2009 - 2012

Computer Systems Analysis at Estácio
2021 - 2023

Power apps at Fundação Bradesco
5/1/2023

Power BI from Beginner to Advanced at Hashtag treinamentos
3/1/2021

Advanced Excel at Fundação Bradesco
1/1/2020

Data Analysis in Power BI at Udemy
1/1/2020