Carlos S.
Data Analyst

Skills

Vba

Microsoft Excel (Advanced Analytics Add-ons)

Microsoft Sql Server

Java

Python

C++

Carlos is available for hire

Hire Carlos S.

All Howdy Candidates are vetted for skills and english proficiency.

Bio

A graduate in Actuarial Science from UFMG, currently advancing studies in Computing at UNA, with professional experience in data analysis, manipulation, and interpretation to identify potential risks or impactful variations. Proficient in generating detailed reports that include tables, graphs, and statistical analysis. Skilled in using data science algorithms to price products, leveraging tools such as R, Excel VBA, SAS, SQL, and Power BI. Demonstrates dedication to process improvement through technology and conducts thorough research to find solutions when necessary.

Data Analyst and Developer
10/1/2023 - Present

Developed proficiency in handling, crossing, extracting, and consolidating data primarily using Excel-VBA and Python. Skilled in web scraping for efficient data extraction. Built web solutions leveraging Google Sheets and Google AppSheet, using JavaScript to automate repetitive tasks through event triggers. Created simple front-end web pages to enhance user experience. These efforts significantly boosted the productivity of the operational team.
Consulting Actuary
4/1/2019 - Present

Developed expertise in ETL processes and data analysis, executing comprehensive statistical fit tests and improving existing codes using Excel-VBA and R. Responsible for the creation of detailed reports featuring statistical charts, providing actionable insights and ensuring report automation to enhance efficiency and data accessibility.
Insurance Actuarial Analyst III
6/1/2013 - 10/1/2013

Developed proficiency in reserving estimation and audit support while enhancing data foundations collaboratively with the IT team, specifically for insurance pension contracts. Utilized SAS, SQL, Excel, and Access to manage and analyze data effectively, ensuring precise estimations and robust audit processes.
Actuary
3/1/2013 - 6/1/2013

Developed actuarial assessments and technical underwriting studies in alignment with required ROI and other hypotheses, ensuring accurate technical acceptance or rejection of pension corporate plans. Conducted comprehensive new product studies and facilitated their release, while performing detailed statistical analysis. Collaborated closely with the sales and products departments to align technical insights with business goals. Acquired in-depth knowledge and expertise in life and pension insurance, enhancing skills in actuarial science, statistical analysis, and technical underwriting.
Judicial Actuarial Expert
9/1/2009 - Present

Analyzed and interpreted laws, regulations, and actuarial concepts to deliver impartial reports providing technical insights into insurance, pension, and healthcare plans. These reports aided judges and attorneys in their decision-making processes during judicial proceedings. Engaged in preparing evidence to support various perspectives or clarify complex concepts and their impacts on companies. Majority of projects involved engagements funded by companies, with additional volunteer or pro bono contributions to support judicial needs.
Actuary Jr.
9/1/2008 - 11/1/2009

Acquired expertise in actuarial assessment and auditing, focusing on evaluating risk and financial stability through comprehensive data analysis. Delivered pension management advising services, including strategic planning for pension schemes and optimizing fund performance. Conducted rigorous technical studies to inform decision-making processes and provide actionable insights for financial management. Offered financial advising, specializing in investment strategies and portfolio diversification to maximize client returns. Mastered the use of Excel, VBA, and R for complex data modeling and statistical analysis, while utilizing Python for automating actuarial calculations. Developed proficiency in pension fund software and financial planning tools, ensuring accurate and efficient management of client portfolios.
Academic Assistant
4/1/2005 - 10/1/2007

Provided technical support for network and computer systems, specifically assisting students in utilizing statistical software such as Stata, S-Plus, R, and SPSS within a university statistical department. Developed an actuarial functions calculator using C++ in collaboration with a team of students. Initiated the development of a Pension Fund Simulator under the supervision of experienced professors Renato Martins Assunção and Marcus Antonio da Cunha.