Rodrigo C.

Data Analyst

Data Analyst Consultant - BI
10/1/2023 - 12/1/2023

Gained expertise in the development, maintenance, and tuning of queries, procedures, functions, triggers, and jobs using SQL Server databases. Demonstrated skills in the development and maintenance of interactive dashboards in Power BI, leveraging data sources such as SQL, Excel, and DAX. Built and maintained ETL processes using SSIS. Ensured robust version control practices using Tortoise SVN.

Mid-Level Data Analyst
9/1/2021 - 10/1/2023

Developed and maintained queries, procedures, functions, triggers, and jobs utilizing SQL Server and PostgreSQL databases. Demonstrated expertise in creating and optimizing complex SQL scripts to enhance database performance and data retrieval efficiency. Delivered and maintained comprehensive dashboards and reports using Power BI, ensuring data visualization best practices and accuracy in analytics reporting.

Systems Analyst
11/1/2019 - 9/1/2021

Analyzed and developed systems using T-SQL, contributing to both corrective and evolutionary maintenance, while spearheading new project initiatives. Identified and rectified system errors and defects through meticulous problem-solving and code adjustments. Worked extensively with SQL Server databases, crafting analysis scripts, views, procedures, functions, and tables to ensure optimal performance and data integrity. Demonstrated expertise in business rules analysis and requirements gathering to inform system design and functionality. Maintained a strong focus on SQL Database programming and maintenance, showcasing solid experience with T-SQL in various operational contexts.

IT Development Analyst
1/2/2019 - 1/2/1900

Gained extensive experience in the development and support of Linx ERP solutions with a focus on T-SQL and VisualFoxPro. Led efforts in system documentation and applied principles of object-oriented development. Provided support for various solutions and projects in close collaboration with different client departments. Managed the administration, maintenance, and development of solutions using the Redmine call portal tool, leveraging Ruby on Rails and MySQL to ensure robust and efficient performance.

IT Development Analyst
7/2/2017 - 6/2/2018

Stationed internally at an IT firm in Rio de Janeiro and Region, Brazil, focused on developing new features and maintaining internal websites and applications as well as those of clients. Utilized GIT for version control and leveraged the MEAN.js stack for full-stack JavaScript development. Worked extensively with Ionic for mobile app development and implemented responsive designs using HTML and CSS. Developed and maintained websites using Wordpress and managed databases with MySQL.

IT Development Analyst
1/2/2016 - 6/2/2017

Developed proficiency in SQL Server, T-SQL, DML, triggers, and procedures. Gained experience in remote access and JavaScript web programming language. Addressed critical incidents to identify and resolve potential bugs, ensuring operational stability. Extracted and analyzed reports from databases based on open demands. Provided support for ticketing systems, snack bar operations, and RPS monitor with call services. Managed on-call duties on weekends on a rotating schedule, demonstrating strong problem-solving skills and reliability.

PL/SQL Programmer Analyst
12/2/2015 - 12/2/2015

Demonstrated expertise in developing, executing, and maintaining DATAFIX scripts using PL/SQL within Oracle databases. Gained extensive experience working across testing, development, and production environments to support the Synchro fiscal solution system.

Junior Support Analyst
12/2/2013 - 9/2/2015

Provided second-level support for main systems, addressing incident corrections and infrastructure maintenance according to established service levels. Managed systems and services from third-party providers including Google, Microsoft, Atex, and Electronic Invoice. Administered physical and virtual servers, as well as web services, overseeing the deployment and management of applications in development and production environments. Coordinated with user areas to understand requirements, analyze solutions, and suggest smart alternatives; estimated and negotiated deadlines effectively. Administered services based on ITIL standards, and actively participated in projects of small to medium complexity. Documented procedures and facilitated knowledge transfer. Participated in external events to support implemented solutions.

Mid-Level Support Analyst
4/2/2013 - 12/2/2013

Assigned to a client in Rio de Janeiro and Region, Brazil as part of a project with Lan Designers. Contributed significantly to the PC Refresh project focused on migrating systems from Windows XP to Windows 7. During this assignment, developed technical expertise in Windows operating systems, particularly in the setup and optimization of Windows 7 environments. Utilized tools for migration, software installation, and system configuration. Ensured smooth transition and minimal downtime for end-users while maintaining system integrity and data security. Gained skills in troubleshooting hardware and software issues and ensuring compatibility with new operating systems.

IT Systems Assistant
5/2/2012 - 3/2/2013

Carried out payment write-offs in the billing system and generated HTML invoices and CNAB collection files. Built queries in Oracle and MySQL databases for generating management reports. Participated in projects and gathered requirements using the QlikView business intelligence tool. Used the data modeling tool DataModeler to support system development. Provided support to company system users by handling help desk tickets and assisted in documenting the processes and business rules of the billing system. Prepared system manuals to facilitate user understanding and usage. Assisted in training and monitoring billing area users on utilizing the developed system. Demonstrated technical expertise in billing systems, database management, and business intelligence tools.

Technical Support
1/2/2011 - 5/2/2012

Provided comprehensive support to internal and external network technicians throughout Brazil, specializing in the registration and activation of equipment, such as Cable Modems and Decoders. Managed active communication to schedule technical visits and execute checklists with subscribers. Effectively handled occurrences and treatments, ensuring the accurate completion of service orders, and the meticulous opening and closing of schedules.

Technical Support
8/2/2009 - 7/2/2010

Provided comprehensive support for connectivity and microinformatics related to Velox broadband internet. Developed technical expertise in troubleshooting and resolving connectivity issues, ensuring optimal network performance. Utilized advanced diagnostic tools to identify and rectify hardware and software malfunctions. Implemented solutions to enhance user experience and streamline operations. Demonstrated proficiency in configuring modems, routers, and network settings. Ensured seamless internet service by collaborating with technical teams and adhering to service protocols.

Intern
6/2/2008 - 12/2/2008

Operated and provided support for HNMD systems, ensuring smooth and efficient user experiences. Conducted assembly and maintenance of computers and printers, ensuring optimal performance of hardware. Developed proficiency in basic configuration of Suse Linux, handling installation and configuration processes with expertise. Configured and maintained Lotus Notes, facilitating effective communication and collaboration within the organization.

Intern
10/2/2006 - 10/2/2007

Provided support in the operation of the CACIC tool, focusing on searching the OS base and applications installed on the network developed by DATAPREV. Assisted in the migration from MSOFFICE to OPENOFFICE. Configured MySQL databases for CACIC operations and developed applications using PHP and PostgreSQL databases. Utilized CASE tools and performed database modeling to enhance project efficiency and accuracy.

Intern
11/2/2005 - 2/2/2006

Developed proficiency in user support, including the adaptation of existing programs within the CAC-CENTER. Managed taxpayer service interactions, ensuring efficient and accurate assistance. Demonstrated expertise in software installation and the installation and administration of network printers. Utilized technical skills to resolve end-user issues and streamline the functionality of IT components. Ensured optimal performance and reliability of software and hardware resources in a high-demand environment.

Computer Science at Veiga de Almeida University
2004 - 2010

Modeling/Warehousing and Database Administration at MIT Postgraduate Degree in Database Management with Oracle, Data
2013 - 2016