12/14/2022 updated
100 % available
IT Analyst (Native Portuguese)
Quatro Barras, Brazil
Brazil
Systems AnalysisAdvertisingBusiness IntelligenceHealth InformaticsDigital MarketingWeb DevelopmentGoogle AnalyticsSystems AnalysisSQL DatabasesPortugueseInformation Technology
Systems Analyst with experience and activities in the areas of health informatics, business intelligence, web development, SQL coding and IT infrastructure.
Sometimes I worked with Digital Marketing, making services for a company named by Best Digital Marketing, in activities such as Google Analytics, Yandex Metrica and Yandex Advertising Network configurations.
Write texts on www.etxt.biz copywriting exchange platform, with themes about information technology and internet.
I developed some telegram bot projects, that can be seen in this link: https://www.telegramideas.com/blog
Sometimes I worked with Digital Marketing, making services for a company named by Best Digital Marketing, in activities such as Google Analytics, Yandex Metrica and Yandex Advertising Network configurations.
Write texts on www.etxt.biz copywriting exchange platform, with themes about information technology and internet.
I developed some telegram bot projects, that can be seen in this link: https://www.telegramideas.com/blog
Experience
Professional experience0 - 5 years
Languages
EnglishFluentPortugueseNative speakerRussianBasic knowledge
Project history
→Wrote SOC Reports about Information Technology General Controls, explaning extracted evidences about, Access Management, Changes Management and IT technology operations.
→Developed assessment reports and presents, related information security risk with cooperative clients, identifying if the policies them companies are compliance from Central Bank of Brazil rules.
→Identified GAP’s about cybersecurity policies, evidences of information security tools, signaling the companies each critical point that were finded on your processes.
→Implemented a Business Process Modelling Notation (BPMN) tool, to help the implement an audit process in financial institutions.
→Developed assessment reports and presents, related information security risk with cooperative clients, identifying if the policies them companies are compliance from Central Bank of Brazil rules.
→Identified GAP’s about cybersecurity policies, evidences of information security tools, signaling the companies each critical point that were finded on your processes.
→Implemented a Business Process Modelling Notation (BPMN) tool, to help the implement an audit process in financial institutions.
→ Developed an application in Python to identify the IP (Internet Protocol) of geographic coordinates about users that accessed the Court network and verify if the accesses are legitimate or from a bot, in which this application was implemented on EC2 environment service of AWS (Amazon Web Services).
→ Implemented a script on Qlik Sense to call a REST API, that return the geographic coordinates of users sending the IP number that accesses the network of Court.
→ Developed of an application in Qlik Sense to monitor all warrant centers in the state of Paraná.
→ Created map charts to verifiy the positions of important addresses of the state of Paraná.
→ Developed charts with color combinations to help the magistrates, on analysis of legal data.
→ Assistance to the chief statistician of the internal affairs department in the development of applications with QlikSense to solve statistical problems, requested by the court magistrates
→ Developed workflow to follow up requests on the Court's information systems, using the BPMN process ( Business Process Modeling Notaiton).
→ Implemented scripts in Qlik Sense to load data from QVD (Qlik View Data), with filters requested by users.
→ Created KPI's to help magistrates know the Court's legal indicators.
→ Implemented dashboards such as line charts, pie charts, pivot tables, calendars and charts viz.
→ Delivery of reports regarding criminal transactions with the QlikSense program to the 2nd Vice President of the Court, understanding their needs and answering questions.
→ Developed an application for prison monitoring, developed together with the CNJ - National Council of Justice of Brazil - to monitor criminal proceedings in the state.
→ Implemented interactive maps, so that magistrates can monitor the progress of criminal proceedings in prisons in all districts of the State of Paraná.
→ Implemented a script on Qlik Sense to call a REST API, that return the geographic coordinates of users sending the IP number that accesses the network of Court.
→ Developed of an application in Qlik Sense to monitor all warrant centers in the state of Paraná.
→ Created map charts to verifiy the positions of important addresses of the state of Paraná.
→ Developed charts with color combinations to help the magistrates, on analysis of legal data.
→ Assistance to the chief statistician of the internal affairs department in the development of applications with QlikSense to solve statistical problems, requested by the court magistrates
→ Developed workflow to follow up requests on the Court's information systems, using the BPMN process ( Business Process Modeling Notaiton).
→ Implemented scripts in Qlik Sense to load data from QVD (Qlik View Data), with filters requested by users.
→ Created KPI's to help magistrates know the Court's legal indicators.
→ Implemented dashboards such as line charts, pie charts, pivot tables, calendars and charts viz.
→ Delivery of reports regarding criminal transactions with the QlikSense program to the 2nd Vice President of the Court, understanding their needs and answering questions.
→ Developed an application for prison monitoring, developed together with the CNJ - National Council of Justice of Brazil - to monitor criminal proceedings in the state.
→ Implemented interactive maps, so that magistrates can monitor the progress of criminal proceedings in prisons in all districts of the State of Paraná.
Coding of reports in SQL with the Postgresql tool to coordinate the billing of a client in the education area of ​​the company Atos. This client is known as Grupo Cogna, with 2.4 million students from all over Brazil.
DATABASE DEVELOPMENT:
→ Leadership in coding an invoice generator for the financial team of a university, in which these invoices must be executed once a month, making the work of this educational institution faster and more modern.
→ Standardization of all reports produced in SQL to be imported into Metabase. This process made it easy for users to extract reports quickly and autonomously.
→ Developed Joins and Subqueries to simplify linking between multiple tables and improve the performance of educational data queries by optimizing export to CSV or Excel.
TRAINING AND DEVELOPMENT:
→ Tutored new developers on the main procedures performed in the development team. This allowed the environment to become conducive to learning and growth.
DATABASE DEVELOPMENT:
→ Leadership in coding an invoice generator for the financial team of a university, in which these invoices must be executed once a month, making the work of this educational institution faster and more modern.
→ Standardization of all reports produced in SQL to be imported into Metabase. This process made it easy for users to extract reports quickly and autonomously.
→ Developed Joins and Subqueries to simplify linking between multiple tables and improve the performance of educational data queries by optimizing export to CSV or Excel.
TRAINING AND DEVELOPMENT:
→ Tutored new developers on the main procedures performed in the development team. This allowed the environment to become conducive to learning and growth.