Widigleidson Jordão

Experience

• 

  GT Consultoria Planejamento Tributário | Inovação

  Apr 2016 - Jul 2016

  Business Analytics - Intern

  RD&I Consulting Department (Research, Development and Innovation)Activities:- Assistance to national and multinational companies for mapping projects in the IT, Chemical and Engineering sectors to begin calculating expenditure with the purpose of collecting data to reduce the tax burden of companies granted by the tax benefit of the Lei do Bem (Research , Development and Innovation);- Assistance in preparing requests and sending them to the Ministry of Science, Technology and Innovation (MCTI);- Support in preparing project schedules and updating working papers;- Carrying out data analysis (quantitative, qualitative and diagnostic) for the "Lei do Bem" project application, using SQL and Excel;- Business Plan: ABC and SWOT Cost Analysis;- Carrying out follow-up with the client and updating sector documentation.- Preparation of reports and graphs for projects. Show less

• 

  Sinaf Seguros

  Jan 2018 - Nov 2018

  Business Analytics - Assistant

  Claims DepartmentActivities:- Data Analysis: Collect, organize and analyze claims data to identify patterns and trends (SQL);- Reports: Create periodic reports on claims performance, including frequency, costs and resolution time;- Dashboards: Develop and maintain interactive dashboards to visualize data and key metrics;- Report Automation: Development of scripts and processes to automate report generation (VBA);- Process Improvement: Analyze and suggest improvements in claims management processes to increase operational efficiency. Increased earnings by 65% ​​in SLA.Actuarial DepartmentActivities:- Creation of reports and studies with information generated from legacy databases (Collection, Claims and Legal Actions) using SQL and Office package (Excel and Word), aiming to contribute to meeting the demands of the Actuarial Coordination;- Analysis and Validation of Movements for Technical Provisions - PSL, PDR and Contingency Provision on a monthly basis;- Calculation of Reinsurance Transfer and Recovery (IRB);- Analysis of PSL Reserves. Show less

• 

  Seguradora Líder-DPVAT

  Nov 2018 - Mar 2021

  • MS MIS (Master's of Science in Management Information Systems - MS MIS) in the Financial Department.• Calculation and Consistency of Technical Provisions: PSL, PDR, IBNR, PPNG, PVR, PDA and PET;• Studies on accident rates;• Calculation of the Minimum Capital Required SUSEP;• Updating, crossing and analyzing Provision Consistency Tests;• Performance Indicators and Claims Analysis through Dashboards using Power BI;• Responsible for Projections of Future Scenarios using Statistical Modeling; • Assistance to Actuarial Audit and SUSEP and other bodies;• Interaction with related business areas (Accounting, Claims, Statistics, Collection, Legal, IT, Compliance, Anti-Fraud and Controlling). Show less

  • Data Analyst/Actuary II

    Aug 2020 - Mar 2021

  • Data Analyst/Actuary I

    Nov 2018 - Aug 2020
• 

  Icatu Seguros

  Apr 2021 - Dec 2021

  Actuary II

  • Calculation and Consistency of Technical Provisions;• Analyze, compile and monitor information from files and reports received, to support database maintenance;• Data Modeling - SQL;• Statistical Tables;• Assistance to Actuarial Audit and SUSEP;• Technical Support for the Operational and Customer Service area;• Interaction with related business areas (Accounting, Claims, Statistics, Collection, Legal, IT, Compliance, Anti-Fraud and Controlling).

• 

  Bradesco Seguros

  Mar 2022 - now

  • Technical Pricing Studies and impact analysis;• Development of Queries and Dashboards for data analysis (SQL/SAS, PowerBI - DAX, Power Query);• Tariff Process: validate monitors, decide and schedule price adjustments, subscription rules;• Execution of Pricing analyses: cost-to-serve, profit-to-serve, competitive pricing;• Analysis of actuarial products and indicators (current, exposed items, earned premium, risk premium, risk rate, frequency, accident rate, severity, average degree of damage, etc.); • Monitoring market prices, competitiveness analysis and price positioning based on market comparisons; Show less

  • Sr Pricing Analyst

    Aug 2024 - now

  • Pricing Analyst

    Mar 2022 - Jul 2024