Data Analyst – Resume Sample in PDF

• Leading the technical and execution front
• Processing JSON files and loading data into the production environment using JSON and Pandas libraries in Python.
• ETL with SQL SERVER data and loading processed data into Google Sheets using Pandas, NumPy, OS, Pickle, Pyodbc, PygSheets, DateTime, and GoogleApiClient libraries.
• Administration of RLS access permissions in PowerBI Embedded, publishing improvements in the production workspace.
• Gathering usability, governance, risk, and data compliance logs via Microsoft Purview in the Azure environment, consuming this data via Power BI to define and understand which environments should be prioritized in scheduled updates.
• Studying needs and requirements for dashboard enhancement and creating measures with DAX according to business needs.
• Creating and modifying views in SQL SERVER, both for BI environment consumption and system consumption
• Maintenance related to the performance of views consumed by the system and tuning for cases where scripts are compromised in terms of speed at the time they are executed.
• Data modeling within Power BI for new dashboards, constructing visualization considering relevant Data Storytelling for the business, validating the displayed data.

• Implementation of marketing intelligence for the sales department using the tools and methods below:
• Responsible for building, maintaining, and generating management dashboards in Qlik Sense and migrating views from Qlik View to Sense, utilizing the Qlik View Converter to migrate variables and calculations.
• Utilizing Qlik’s customizable reporting module for sending AD HOC reports, considering P&L and cash flow information.
• Administration, governance of permissions, licenses, and connections within the QMC (Qlik Management Console).
• Responsible for sales force tracking metrics for both B2C and B2B.
• Creating and sending mass reports via N PRINTING.

• Full implementation of the company’s BI department from scratch, understanding the business needs of each business unit, creating internal and external monitoring KPIs from the core sector to the point of sales and representatives using Power BI to provide insights to leadership.
• Handling ad-hoc requests when it comes to BI, such as calculation changes, aesthetics, and studying future improvements.
• Utilizing Pentaho for ETL and data ingestion into Snowflake, and Grafana for monitoring executions.
• Responsible for creating a data quality testing workflow to ensure that processes and information generated by the data are robust.
• Creation of facts and dimensions in a multidimensional model in Power BI, using both Star Schema and Snowflake Schema, creating calculations with DAX when necessary, and utilizing Power Query for data transformation and data treatment layer.

• Worked with extracting insights, conducting study projections, and creating dashboards in Tableau for both internal and external clients.
• Conducted requirement gathering and needs assessment for the development of new data products.
• Built ETL routines (using Pentaho) to populate the company’s Data Warehouse.
• Prepared new leaders on the use and understanding of each visualization, including the fields utilized, seasonalities, update frequency, and calculations for KPIs.
• Addressed requests for enhancements or incidents related to the Health Analytics and Pharma Analytics products, making improvements to the database or modifying visualization rules, both in Tableau and in the data loading processes on the Tableau Server.

• Continued involvement in the process of migrating systems from other insurers to the TELEPORT system, migrating and adapting data to our internal structure, evaluating customer databases to ensure data integrity and quality.
• Played an active role in the encryption changes proposed by SUSEP (Superintendence of Private Insurance) in the insurance market due to LGPD (Brazil’s General Data Protection Law) regulations.
• Validated tickets and executed scripts written by other analysts or developers in the production environment.
• Performed data loading and bulk updates in claims and endorsement databases.
• Updated FIPE codes for automotive insurance to ensure the multicalculation system captures the correct vehicle information.
• Utilized POWER BI for data visualization and programming in DAX to provide relevant information for the management of Customer Service and Support teams.
• Created Procedures and Views in the database.
• Generation of reports via database.
• Development and improvement of SQL scripts.
• Updating and resolving tickets through Zendesk

• Support in maintenance, issuance, unlocking, and configuration related to digital certification.
• Issuance of reports, generation of certificates for exceptional cases, and case-by-case analysis for referral to the ombudsman.
• Configurations of Windows and Mac for A1 and A3 certifications.
• Creation of impact dossiers within digital protection systems.
• Identification of fraud or phishing attempts, as well as general technical support for certification in the Cloud.

• Identification of hardware and software errors on iPhone and Mac
platforms running the iOS 12.0 operating system, as well as MacOS
High Sierra and Mojav

• Responsible for managing the company’s network and system. Hardware and software maintenance.
• Mapping of networks and administration of ODBC connections. Configuration of the Kinghost Webmail Service.
• Installation of drivers on computers. TCP-IP configuration on servers.
• Administration and troubleshooting within the ERP-NC, BDE system.
• Responsible for opening and closing accounting periods, customer registration, opening of managerial accounts, tax linking rules, report generation, and system recalibration.