Резюме: Database / Data Analyst

DATABASE DEVELOPMENT:

(PostgreSQL Management System):
→Demonstrated leadership in coding an invoice generator for a university's financial team. This system automated monthly invoice execution, significantly streamlining the institution's workflow.
Standardized all SQL reports for seamless import into Metabase, enabling users to extract reports quickly and independently.
→Developed Joins and Subqueries to simplify linking between multiple tables and enhance the performance of educational data queries. This optimization facilitated data export to formats like CSV or Excel.

(PL/SQL Management System):
→Utilized PL/SQL scripts in Oracle to implement electronic documents for various healthcare professionals involved in patient care, including doctors, nurses, physiotherapists, psychologists, nutritionists, and social service providers. These scripts improved document issuance, enhancing patient care and record-keeping.

BUSINESS INTELLIGENCE (DATA ANALYST):

→Assisted the chief statistician of the internal affairs department in developing QlikSense applications to address statistical problems requested by court magistrates.
→Implemented a workflow using the Business Process Modeling Notation (BPMN) process to track requests within the Court's information systems, ensuring efficient management.
→Developed scripts in Qlik Sense to load data from QVD (Qlik View Data), incorporating user-requested filters to provide tailored insights.
→Created key performance indicators (KPIs) to help magistrates monitor the Court's legal indicators effectively.
→Designed and implemented diverse dashboards, including line charts, pie charts, pivot tables, calendars, and other visualizations, to present data in an intuitive manner.
→Delivered comprehensive reports on criminal transactions using the QlikSense program to the 2nd Vice President of the Court, addressing their specific needs and providing insightful answers.
→Collaborated with the National Council of Justice of Brazil (CNJ) to develop a prison monitoring application, enabling magistrates to track the progress of criminal proceedings in prisons across all districts of the State of Paraná using interactive maps.

PROFESSIONAL EXPERIENCE
EY - Tech Risk Compliance Analyst (June 2022 - April 2023)
Court of Justice of the State of Paraná - Graduate Intern (September 2021 - June 2022)
Atos - Database Developer (June 2021 - October 2021)
Court of Justice of the State of Paraná - Intern (August 2019 - August 2021)
Bank of Brazil - Intern at Sysadmin Linux and Java Development (August 2018 - July 2019)
Hospital Pequeno Príncipe - Database Intern (November 2015 - May 2017)

EDUCATION
Systems Analyst - Educational College of Lapa - November 2020

LANGUAGES
Portuguese: Native
English: Upper-Intermediate
Russian and Slavic Languages: Basic