Lucas D.Data Analyst
Skills
A Data Analyst and Data Engineer with a decade of experience specializing in relational databases including SQL Server, MySQL, and Oracle Database. Proficient in Microsoft BI tools such as SSIS, SSAS, SSRS, and Power BI, and adherent to agile methodologies. Recently acquired proficiency in Python to enhance capabilities in data analysis and broaden the analytical toolset. Committed to leveraging data analysis and engineering expertise to enhance efficiency, drive innovation, and optimize processes and products, with an emphasis on maintaining a people-centered approach.
BI Analyst
7/1/2023 - 12/1/2023
Responsible for the implementation and deployment of services including SSIS, SSAS, and SSRS. Delivered comprehensive reports and actionable insights utilizing DataViz tools such as SQL Server Reporting Services and PowerBI. Cultivated deep technical expertise in SQL Server environments, ensuring robust data integration, analysis, and reporting processes.Data Analyst
6/1/2022 - 8/1/2023
Developed and maintained complex queries for Oracle 11g, MySQL, and SQL Server, including tuning, logic, and other optimizations. Expertise in creating and managing database objects such as Tables, Triggers, Materialized Views, Functions, Procedures, and Packages. Proficient in the creation and maintenance of Mobile Reports and Paginated Reports using SQL Server Reporting Services (SSRS) through Visual Studio, and managed interactions with the Microsoft Power BI portal. Demonstrated skills in report creation with Power BI Desktop and their subsequent publication on SSRSPBI. Administered SSRS and its Power BI version, from installation and configuration to access control and portal modifications. Supported the Processes department by creating new workflows and modifying existing ones through data and workflow analysis. Implemented process automation using RPA tools. Skilled in Azure DevOps and experienced in code versioning with Git and TFVS.Product Owner
11/1/2021 - 5/1/2022
Applied SCRUM methodology to execute all planned ceremonies within the development team and project/product stakeholders. Led the creation and management of the product lifecycle, from inception to determining business value. Developed a mobile application and its web extension for use in SUS medical services. Planned deliveries by creating, refining, and updating the product backlog, prioritizing the most relevant items, and managing stakeholder expectations. Detailed user stories and defined clear acceptance criteria for the development team.BI Analyst
12/1/2020 - 11/1/2021
Developed proficiency in SQL Server for tuning, creating, and maintaining complex queries and database objects like Tables, Triggers, Materialized Views, Functions, Procedures, and Packages. Demonstrated expertise in creating and publishing reports using Power BI Desktop and SSRSPBI. Showcased capabilities in Excel VBA for creating and maintaining Macros and ensuring seamless integration with Microsoft Access.BI Analyst
2/1/2020 - 10/1/2020
Developed proficiency in the creation and maintenance of queries for Oracle 11g, MySQL, and SQL Server, as well as the management of database objects including Tables, Triggers, Materialized Views, Functions, Procedures, and Packages. Demonstrated expertise in creating and maintaining Mobile Reports and Paginated Reports in SSRS (SQL Server Reporting Services) utilizing Visual Studio, alongside effective usage of the Microsoft Power BI portal. Designed and published reports using Power BI Desktop in SSRSPBI, as well as managed the SSRS application and its Power BI version, overseeing tasks from installation to access control and portal modifications. Contributed to the Process department by developing and modifying workflows through comprehensive data analysis. Enhanced process efficiency via automation using RPA tools. Gained experience with Azure DevOps and maintained code versioning using Git and TFVS.Junior Development Analyst
4/1/2019 - 2/1/2020
Developed and maintained Mobile Reports and Paginated Reports using SSRS (SQL Server Reporting Services) through Visual Studio. Administered the SSRS application including installation, access control, and portal modifications. Optimized and enhanced queries for Oracle 11g, MySQL, and SQL Server, alongside the creation and maintenance of database objects such as Tables, Triggers, Materialized Views, Functions, Procedures, and Packages. Contributed to the development and maintenance of a primary application using C# ASP.NET Web Forms. Gained experience in Azure DevOps and managed code versioning with Git and TFVS. Worked with omnichannel digital customer service tools. Collaborated with the IT team on various projects and activities.Junior Programmer
7/1/2017 - 12/1/2018
Developed proficiency in the creation and maintenance of Reports on SSRS (SQL Server Reporting Services) using Visual Studio - Business Intelligence, along with comprehensive SSRS application administration, including installation and access control management. Acquired substantial experience in creating and managing SSIS packages, as well as developing proficient SQL Server queries, including Selects, Views, Functions, and Procedures, while consistently improving their performance. Developed web applications using C# with the Razor framework, incorporating HTML, Bootstrap, JS, and jQuery in Visual Studio, ensuring seamless database communication with MySQL and SQL Server. Led the implementation of the GLPI application, handling all aspects from installation and configuration to full-scale deployment.IT Intern
3/1/2016 - 2/1/2017
Provided Level 1, 2, and 3 user support, showcasing advanced troubleshooting and problem-solving abilities. Managed the installation and maintenance of corporate software for financial institutions and government agencies, ensuring smooth and secure operations. Executed and controlled the inventory of the machine park, maintaining an organized and up-to-date database of all hardware assets. Expertly handled the creation and maintenance of user accounts through Active Directory, demonstrating proficiency in user management and security protocols. Offered comprehensive support for landline telephony, mobile telephony, and printers, resolving technical issues quickly and efficiently. Developed automations and scripts to streamline processes, enhancing overall productivity and reducing manual effort.Computer Assistant
3/1/2013 - 12/1/2014
Gained proficiency in Level 1 and 2 support, focusing on the installation and management of software. Developed skills in the maintenance of software and hardware, including the formatting and installation of operating systems such as Windows, Ubuntu, Fedora, Debian, and openSUSE. Demonstrated expertise in maintaining the internal network (Intranet) and data-sharing server. Acquired experience in maintaining Linux servers, specifically for proxies, and performed installation and maintenance of various peripherals.Computer Assistant
2/1/2010 - 11/1/2012
Developed expertise in providing Level 1 and 2 support through both remote and onsite assistance. Gained proficiency in formatting computers operating on Windows and Ubuntu. Acquired substantial experience in hardware maintenance, including troubleshooting, repairs, and upgrades. Demonstrated capability in the installation and management of various software applications to meet user requirements and maintain system integrity.
Bachelor's Degree in Information Systems at Positive University
2017 - 2023Technical High School Diploma in Industrial Mechanics combined with High School Education at Integrated Unit SESI SENAI Fernando Bezerra
2010 - 2012
EF SET English Certificate 72/100 (C2 Proficient) at EF Standard English Test (EF SET)
3/1/2024RPA Starter at UiPath
1/1/2021Get Connected at Cisco Networking Academy
5/1/2017
Lucas is available for hire
Hire Lucas D.
All Howdy Candidates are vetted for skills and english proficiency.
