Lucas H.
Data Analyst

Skills

Microsoft Excel (Advanced Analytics Add-ons)

Microsoft Sql Server

Mysql

Lucas is available for hire

Hire Lucas H.

All Howdy Candidates are vetted for skills and english proficiency.

Bio

An experienced professional with a diverse background spanning both private and public sectors, consistently engaging with clients and stakeholders. Possesses strong skills in customer service and the management of legal data, supported by formal education in the field. Currently transitioning into a career in data science, leveraging existing expertise to adapt and excel in this new domain.

Data Analyst
2/1/2024 - Present

Developed proficiency in managing and controlling activities via ClickUp. Created, maintained, and enhanced operational dashboards focused on purchase orders, shipping, and inventory. Demonstrated skills in database maintenance and provided support in preparing reports and spreadsheets.
BI Analyst
5/1/2023 - 2/1/2024

Developed proficiency in BI project management, overseeing the development of medium/high complexity dashboards with strategic indicators to generate business insights. Managed direct contact with managers to understand business rules and ensure data validation. Demonstrated technical skills in M and DAX languages for creating critical business metrics and data analysis. Utilized HTML/CSS for creating animations integrated into dashboards and managed ongoing dashboard maintenance. Oversaw access management and release via SharePoint, generated specific reports using Excel, and managed workspaces, deployments, and updates. Responsible for extensive management of data sets.

In data engineering, performed complex queries and data manipulation in SQL Server, MySQL, and PostgreSQL databases. Handled gateway configuration and management, and created, maintained, and managed data flows. Automated data flows using Power Automate and extracted and validated information from Totvs/Protheus databases.
Business Intelligence Assistant
2/1/2023 - Present

Developed proficiency in the creation of dashboards featuring strategic indicators to generate actionable insights. Ensured the maintenance and optimization of operational dashboards for the company. Demonstrated expertise in querying and manipulating databases using SQL Server, alongside extracting and validating information from Totvs/Protheus systems.
Assistant Public Defender
4/1/2022 - 2/1/2023

Managed large-scale in-person and online event attendance, ensuring seamless coordination and participant satisfaction. Handled various legal-administrative routines with precision, including the collection and organization of critical documents. Demonstrated expertise in analyzing and explaining complex situations to diverse stakeholders. Efficiently performed data entry tasks within spreadsheets and managed other administrative activities to maintain accurate records. Oversaw the control of internal schedules, ensuring adherence to deadlines and compliance with regulatory requirements. Prepared and produced detailed reports, providing actionable insights for continuous improvement.
Legal Assistant
11/1/2021 - 1/1/2022

Developed extensive skills in personnel administration, contracted management, and labor document handling, including CTPS and Time Sheets. Expertise gained in monitoring terminations and providing labor rights guidelines for both the company and employees. Accomplished in petitioning complaints and operating judicial systems. Proficient in writing civil and labor defense documents, as well as drafting letters, notifications, and powers of attorney. Skilled in formulating calculations for labor documents and delivering consultative legal support and general process guidance. Demonstrated analytical abilities through the evaluation of various legal and labor-related documents.
Career Transition - BI Consultant
7/1/2021 - 1/1/2023

Led data project management initiatives, providing expert consultations on Business Intelligence solutions. Crafted and implemented strategic and customized dashboards, addressing complex problems in data management including data warehousing (DW), Enterprise Resource Planning (ERP) suggestions, and database optimization. Maintained and updated ongoing dashboards to ensure their relevance and effectiveness.

Acquired certifications in data visualization programs such as Power BI, Google Looker, and QlikView, alongside certifications in SQL Server, MySQL, and PL/SQL. Completed CS50's Introduction to Programming with Python to further enhance technical proficiency. Successfully enriched the professional portfolio with robust projects and advanced language skills from intermediate to advanced level in English.
Legal Intern
7/1/2019 - 7/1/2021

Demonstrated experience in both home office and in-person environments, with a focus on legal-administrative routines. Acted as a consultant, providing monitoring and guidance on high demand routines. Acquired proficiency in analyzing calculations and demonstrated extensive typing skills in Word and Excel. Managed the control and compliance of internal deadlines schedules. Assisted in negotiating agreements through conducting in-person and online hearings. Developed expertise in drafting and preparing comprehensive reports.
Legal Assistant
9/1/2018 - 1/1/2019

Handled legal-administrative routines, providing face-to-face and online customer service. Managed document collection, title discounting, and negotiations with clients and partners. Demonstrated expertise in drafting, negotiating, and reviewing contracts. Displayed proficiency in fast typing of files and information, as well as formulating and monitoring Excel spreadsheets concerning clients, deadlines, and finances. Conducted consultation and management of information, ensuring effective organization of files.