Guilherme Costa

Guilherme Costa Email and Phone Number

Business Intelligence Specialist with Expertise in Data Management and Process Improvement -Business Intelligence | Data Analytics | SQL Server | Python
Guilherme Costa's Location
Guará, Federal District, Brazil, Brazil
About Guilherme Costa

With a solid professional trajectory focused on Business Intelligence and data management, I have dedicated my career to driving efficiency, quality, and innovation in various corporate contexts.I began my journey as a BI Analyst in Diverse Risks, where I conceived and developed a robust Data Warehouse project, unifying legacy systems to offer simplified access via self-service BI. My expertise in predictive modeling using machine learning techniques resulted in significant achievements, such as improving the churn rate of a product and creating a customer score project to mitigate risks.Subsequently, I worked as a Financial BI Analyst, where I optimized internal processes by gathering and organizing essential financial data. My strategic approach to creating data structures and Power BI dashboards streamlined operations and enabled detailed expense tracking by sector, contributing to more effective financial management.Currently, as a Business Intelligence Specialist in the Ombudsman department at CNP Seguros Holding Brasil, I lead crucial initiatives in data organization and analysis, ensuring compliance with regulations and providing actionable insights to senior management. My expertise ranges from creating databases to automating processes, resulting in agile deliveries and quality reports.I continually seek challenges that allow me to apply my data knowledge innovatively, collaborating with multidisciplinary teams to drive operational efficiency and organizational growth. My professional aspirations include exploring new technologies and methodologies to further enhance my skills and add value in dynamic, data-driven environments.

Guilherme Costa's Current Company Details

Business Intelligence Specialist with Expertise in Data Management and Process Improvement -Business Intelligence | Data Analytics | SQL Server | Python
Guilherme Costa Work Experience Details
  • Cnp Seguros Holding Brasil
    Business Intelligence Specialist - Ombudsman Department
    Cnp Seguros Holding Brasil Mar 2023 - Oct 2024
    Brasília, Distrito Federal, Brasil
    Creation of a database to organize the information used in the Ombudsman department of the company, which is utilized for legal submissions to SUSEP, internal and external audits, weekly, monthly, semi-annual, and annual reports to top management. Automation of processes to expedite deliveries and timely resolution of routine issues, development of Power BI dashboards for monitoring the operation, quality, and management teams.Suggesting improvements for departmental deliveries by recommending more suitable tools, providing new knowledge and insights to guide process improvements, presenting better methods, ensuring automation of routines and operational activities. Developing other team members by sharing knowledge of technical skills with data and analysis tools.Applying best practices for analysis to produce effective data reports, implementing actions and routines to ensure the correction of discrepancies, and guaranteeing the quality of the information presented.
  • Cnp Seguros Holding Brasil
    Bi Analyst - Financial
    Cnp Seguros Holding Brasil Jul 2022 - Mar 2023
    Brasília, Federal District, Brazil
    Gathering financial data on an internal basis to assist with internal processing and the creation of dashboards in Power BI; creating a data structure to assist with the re-billing and closing process; automating the monthly Total Expenses report published to areas in BI; performing the monthly routine of re-billing Administrative Expenses, including: processing routines in ABB; generating information for accounting records; generating files for the opening of expenses in TM1 (simplified and complete); evaluating expense allocations in relation to requests for activity closures; generating analytical cost statements for each affected company.Results: Streamlining existing processes by creating multiple DMs to expedite audit responses and monitoring views for managers; creating a data structure to improve: expense tracking by department; expense distribution process among holding companies and closing; and tracking of provisions.
  • Cnp Seguros Holding Brasil
    Bi Analyst - Miscellaneous Risks
    Cnp Seguros Holding Brasil May 2021 - Jun 2022
    Brasília, Federal District, Brazil
    Developing and implementing a data project, creating a Data Warehouse for themanagement, unifying legacy systems in one location to provideself-service BI to all interested parties; conducting studies and creatingpredictive models using machine learning techniques (e.g., customer retention/churn study); creating and maintaining automated routines for daily extractions to load into databases and createreports, developing and assisting in data extraction, transformation,and loading processes, daily monitoring of data storage(SQL Server) for Business Intelligence projects, creating dashboardswith Power BI for daily monitoring (e.g., decline, issuance,cancellation, claims...) and monthly (e.g., executive summary); creatingreports and assisting with conformity reports for audits (internal andexternal) and regulatory bodies (SUSEP).Results:Cost reduction with data by creating a DW to expedite responses (Audits/SUSEP)Opportunity for improvement in the churn rate of a product (Customer Retention);Creation of customer score project to monitor issuance risks;Creation of customer monitoring processes for COAF (COAF - According to Law No. 9.613/1998 and Circular SUSEP No. 612/2020);Monitoring processes for the application of PLD and SAPIN II rules (PLD - Circular SUSEP No. 612/2020 - Loi SAPIN II – French Anti-Corruption Law).
  • Caixa Seguradora
    Analista Bi - Riscos Diversos
    Caixa Seguradora Jun 2019 - May 2021
    Brasília E Região, Brasil
    Elaboração e desenvolvimento de projeto de dados, criação de Data Warehouse paradiretoria, unificando os sistemas legados em um só local para disponibilizarvia self-service BI a todos interessados; laboração de estudos e criação demodelos preditivos utilizando técnicas de machine learning (ex: Estudo deretenção de clientes / Churn); criação e manutenção de rotinasautomatizadas de extrações diárias para carga em bancos e criação derelatórios, desenvolver e auxiliar nos processos de extração, transformaçãoe carga de dados, acompanhamento diário do armazenamento dos dados(SQL Server) para os projetos de Business Intelligence, criação de painéiscom Power BI para acompanhamento diário (ex: declínio, emissão,cancelamento, sinistro...) e mensais (ex: resumo executivo); criação derelatórios e auxílio em reports da conformidade para auditorias (internas eexternas) e órgãos fiscalizadores (SUSEP).Resultados: Redução de custos com dados com a criação de DW para agilizar respostas (Auditorias/SUSEP)Oportunidade de melhoria na taxa de churn de um produto (Retenção de Clientes);Criação de projeto de score de clientes para acompanha riscos de emissão;Criação de processos de acompanhamento de clientes para COAF (COAF - Segundo a Lei nº 9.613/1998 e a Circular SUSEP nº 612/2020);Processos de acompanhamento para aplicação das regras da PLD e SAPIN II (PLD - Circular SUSEP nº 612/2020 - Loi SAPIN II – Lei Anticorrupção Francesa).
  • Millenium Tecnologia
    Systems Analyst
    Millenium Tecnologia Apr 2017 - May 2019
    Brasília, Federal District, Brazil
    Extracting, processing, and analyzing data related to the insurance business, creating reports, monitoring indicators, and creating dashboards with Power BI used by leaders in decision-making.Results:Reduced expenses with report creation and processes;Time savings in responses to audits and regulatory agencies.Better monitoring of the operationBetter vision for prospecting campaigns and future product analysis.
  • Baluweb Criação De Sites E Portais
    Owner
    Baluweb Criação De Sites E Portais Aug 2009 - Jun 2018
    Brasília E Região, Brasil
    Diretor de MarketingDiretor ComercialDiretor FinaceiroAnalista de RequisitoDesenvolvendorWeb designer
  • Millenium Tecnologia
    Systems Analyst / Web Designer
    Millenium Tecnologia Feb 2013 - Apr 2015
    Brasília, Federal District, Brazil
    Prototyping to assist the requirements and development teams in the project.
  • Ibrowse Consultoria E Informática
    Systems Analyst / Web Designer
    Ibrowse Consultoria E Informática Nov 2011 - Feb 2013
    Brasília, Federal District, Brazil
    Creation and maintenance of the Incra portal and Intranet using the Joomla! CMS; Creation of survey forms using LimeSurvey; PHP development for the portal and Intranet; Creation of templates and adjustment of systems using tabless and CSS.
  • Politec
    Analyst/Developer
    Politec Dec 2009 - Nov 2011
    Brasília, Federal District, Brazil
    Analysis, corrective maintenance and evolutionary demands in ASP systems with SQL Server.
  • Hepta Informática Ltda
    Web Designer
    Hepta Informática Ltda May 2007 - Dec 2009
    Creation of animations and presentations with Flash for the AGU website, creation of animations with Swish integrated with Flash, image editing (Photoshop, CorelDraw), maintenance and development of small ASP applications for the website and intranet.

Guilherme Costa Education Details

Frequently Asked Questions about Guilherme Costa

What is Guilherme Costa's role at the current company?

Guilherme Costa's current role is Business Intelligence Specialist with Expertise in Data Management and Process Improvement -Business Intelligence | Data Analytics | SQL Server | Python.

What schools did Guilherme Costa attend?

Guilherme Costa attended Faculdade Vincit, Senac Technology College, Uniplan - Planalto District Federal University Center..

Not the Guilherme Costa you were looking for?

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.