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.
-
Business Intelligence Specialist - Ombudsman DepartmentCnp Seguros Holding Brasil Mar 2023 - Oct 2024Brasília, Distrito Federal, BrasilCreation 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. -
Bi Analyst - FinancialCnp Seguros Holding Brasil Jul 2022 - Mar 2023Brasília, Federal District, BrazilGathering 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. -
Bi Analyst - Miscellaneous RisksCnp Seguros Holding Brasil May 2021 - Jun 2022Brasília, Federal District, BrazilDeveloping 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). -
Analista Bi - Riscos DiversosCaixa Seguradora Jun 2019 - May 2021Brasília E Região, BrasilElaboraçã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). -
Systems AnalystMillenium Tecnologia Apr 2017 - May 2019Brasília, Federal District, BrazilExtracting, 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.
-
OwnerBaluweb Criação De Sites E Portais Aug 2009 - Jun 2018Brasília E Região, BrasilDiretor de MarketingDiretor ComercialDiretor FinaceiroAnalista de RequisitoDesenvolvendorWeb designer
-
Systems Analyst / Web DesignerMillenium Tecnologia Feb 2013 - Apr 2015Brasília, Federal District, BrazilPrototyping to assist the requirements and development teams in the project.
-
Systems Analyst / Web DesignerIbrowse Consultoria E Informática Nov 2011 - Feb 2013Brasília, Federal District, BrazilCreation 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.
-
Analyst/DeveloperPolitec Dec 2009 - Nov 2011Brasília, Federal District, BrazilAnalysis, corrective maintenance and evolutionary demands in ASP systems with SQL Server. -
Web DesignerHepta Informática Ltda May 2007 - Dec 2009Creation 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
-
Em Parceria Com A Data Science Academy -
Information Technology -
Uniplan - Planalto District Federal University Center.Informatics
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?
-
Guilherme Costa
São Paulo, Sp -
-
2syngenta.com, vivo.com.br
-
2swmb.com.br, swmintl.com
-
Guilherme Costa
São Paulo, Sp
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
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.
Start your free trial