- Featured in:
-
More Actuarial Intern Resumes
Use these Actuarial Intern samples as a guideline or visit our extensive library of customizable resume templates.
Select
Customize
Download
Find out what is the best resume for you in our Ultimate Resume Format Guide.
Additional Statistics Resume Samples
Actuarial Intern Resume Samples
No results found
0-5 years of experience
Designed an Excel annuitizaiton quote tool to calculate premium according to individual basic information
- Improved Excel skill in pivot table and other functions when creating annuitization quote tool
- Collaborated with senior actuaries in every detailed process and verified premium and surrender value in production annual statements for clients
- Assisted senior actuaries with pricing the premium of annuity product for new clients
- Managed several projects simultaneously and planned to-do-list from high priority to low priority
0-5 years of experience
- Administrated 500+ bancassurance policies and 300+ group insurance policies
- Developed brief VBA codes summarizing sales reports of 3 products over passing half year
- Helped to build a multiple linear-regression based accident insurance pricing model
- Promoted policies recorder program and reduced manpower cost by 75%
6-10 years of experience
Performed data mining and manipulation on large amounts of insurance data. Projects involved determining catastrophe thresholds by state to improve forecasts, use of Mean Excess plots in forecasting, and the designation and removal of large losses/extreme events. Project work led to department wide changes in forecasting procedures.
- Lead Intern on five projects, assumed responsibilities of project manager in such cases. Promoted to project manager after 2 internships.
- Created presentation materials and reports & delivered oral presentations to corporate and senior staff during each internship. Also gave high level SAS trainings to other interns.
- Worked full-time for 3 summers, part time 5 semesters.
- Heavy emphasis on higher level predictive modeling work & how project results affect company growth. Daily use of SAS, SQL, Excel, Access, and Powerpoint to perform statistical analysis & prepare presentations to explain results.
0-5 years of experience
- Analyzed sales trends and demographics for Disability Income, Critical Illness, and Accident Products
- Recommended changes in expected persistency rates and evaluated the impact of irregular persistency behavior in recent years
- Created new SAS and Excel programs, improved existing ones and documented changes
- Presented study results and internship experience through emails, Word summaries and meetings
- Discussed topics of reserving, pricing, and ethics, summarized survey results and wrote VBA formatting code
0-5 years of experience
Participated in test of annual yield rate of bancassurance products under maturity
- Used Excel and VBA to complete draft of annual dividend plan of participating insurance
- Coordinated with IT department and verified the amount of dividends for each product with given data
- Optimized a data conversion system of policies and reduced the processing time by 90 percent
0-5 years of experience
Assisted in rate filing for the Individual Medical and Small Group lines of business
- Streamlined creation of state mandated exhibits through VBA macros
- Pulled historical data using SQL used to justify proposed rates
- Created membership projections at the plan level for each state in which filings were submitted
- Supplied necessary written justification and Excel exhibits in response to state objections to proposed rates
0-5 years of experience
- Compared and analyzed company products with competitors by calculating Internal Rate of Return (IRR) and Cost of Insurance (COI), suggested changes in several product prices
- Scrutinized matured products and presented results by using functions such as vlookup, index match and pivot table to extract data and created graph to illustrate results
- Helped migrate products by compiling product log book and have sufficient understanding on life products and riders
- Evaluated products by performing User Acceptance Testing (UAT) testing with software such as PSIP and also Excel spreadsheets
0-5 years of experience
This company specializes in analysis on climate change risk and natural resource impacts
- Developed climate actuarial model to evaluate property loss with Exceedance Probability curve
- Inspected FEMA claim dataset and adjusted climate model accordingly
- Directed research on catastrophe models from AIR, RMS and EQECAT
- Supported product development team on data collection and model analysis
0-5 years of experience
- Created and implemented a daily life claims report using Excel and SQL for use by Chief Actuary
- Designed an incident management process to save money for the company and presented the idea to CEOs
- Redesigned an old C program into an Excel worksheet
- Automated Excel reports using VBA macros
- Automated exporting and importing data to and from Excel and SQL server database using SQL and Excel VBA
- Reduced weekly report formatting and submission time by an average of 30 minutes
0-5 years of experience
- Conducted a comprehensive review of Defined Benefit, Defined Contribution and Cash Balance Plans to access various pros and cons of each plan and to educate the client
- Successfully reduced the funding and accounting costs by 20% through pension plan reforms and rigorous actuarial valuation
- Presented recommendations to the client with detailed product design and analytical report
0-5 years of experience
- Maximized Medicare Advantage revenue and optimized member targeting strategy by developing an advanced statistical model that predicted future diseases for members
- Performed ad-hoc analyses by utilizing Excel to summarize retrospective and prospective analytics of 26 different vendors
- Researched new Medicare implementations and updated actuarial department SQL tables to account for new risk adjustment model changes
- Automated provider forms by writing VBA code to pre-fill forms based on a table of member
0-5 years of experience
Gathered and organized sales information to create a detailed seasonal report by segments including new products, best sellers and most changed
- Analyzed regional sales on supplemental insurance and compared it against major competitors’ offer to generate new product design suggestions
- Transited client data from sales system to actuarial system and prepared reserve valuation under the supervision of an actuary
- Analyzed mortality rate from different perspectives, such as ages, sales channels and areas using Experience Analysis System, and interpreted the results to underwriters to improve risk controlling process.
0-5 years of experience
Assisted actuaries with pricing treaty reinsurance policy (Hospital Professional Liability with $80MM premium) by using Experience rating and Exposure rating models
- Projected ultimate loss ratios for each Professional Liability line of business by using BF and LDF
- Conducted statistical analysis of frequency and severity trends by studying industry reports and doing data mining in Access and Excel
- Updated Excess Layer LDFs(Loss Development Factors) for each Professional Liability line of business by using the Pinto-Gogol method
0-5 years of experience
Analyzed data from over two hundred thousand policies in order to report statistics
- Created tables via Microsoft Access queries and Excel functions to show policy changes between periods of time, which were easily updated when new data was available
- Used GGY Axis program to calculate liability and asset durations that were used to re-evaluate the company’s manual calculation tables
- Experienced working alongside a close team with frequent communication
- Gained knowledge of the Life insurance industry and New York State Laws
- Worked full time while studying for and passing the FM exam
0-5 years of experience
- Created automated process to run 1000+ policies through variable annuity model to improve efficiency of projections
- Organized and summarized results with VBA and SQL for 10000+ scenarios into readable data to pinpoint model errors
- Calculated conditional tail expectation calculations for each rider type using Excel to assist manager with deliverables
- Created documentation to train coworkers on projects
0-5 years of experience
- Performed extensive experience studies on lapse and withdraw behaviors, estimated decrement rates for different cohorts based on certain characteristics, presented the study results to managers, and helped adjust assumptions
- Constructed 20+ VBA macros and SAS programs to automatically import data files from clients, report claims, update monthly
- Created different scenarios and shocked assumptions including lapse, costs, discount rate for sensitivity testing
- Evaluated major risks and profitability by examining CTE, VaR, and profit margins; composed risk assessment reports
0-5 years of experience
- Improved efficiency in monthly reporting for lapses, claims, reserves and valuation analysis
- Analyzed portfolio assets and modeled cash flow projections using MG-ALFA
- Prepared and reviewed annual statement schedules and exhibits
- Conducted experience studies and sensitivity testing to determine reasonableness of model assumptions
- Upgraded custom MG-ALFA actuarial database for faster simulation run time on large data sets
0-5 years of experience
- Determined rate level indications, developed rate filings and rate pages by state
- Coordinated the completion of pricing evaluations and partnered with the Product Managers in developing rate proposals, and publishing rate proposals
- Created new spreadsheet for premium planning by importing and validating data from IBM Cognos and other data source, and used VBA, VLOOKUP in Excel to improve productivity, yielding a 1600% increase in workforce efficiency
- Extracted data and built tables in SQL server to create multiple Pivot Tables in Excel on AP&E, IRPM, Quote Volume for Top Agency Monitoring Project to monitor the performance of agencies
0-5 years of experience
- Performed insurance payout and segmentation calculations for a retirement product
- Conducted comprehensive cash flow scenario forecast for a health insurance product
- Supported the development of required reserve funds model for health insurance (e.g., critical illness) products
- Documented and distributed regulatory and internal compliant requirements to all associates within the department
- Organized and attended monthly business meeting for 30+ senior leaders and associates
0-5 years of experience
Developed a SQL Database to calculate the Tax Reserve of Deferred Annuities
- Reduced run time of calculations from 16+ hours to under 2 hours
- Presented SQL database to entire department of approximately 30 actuaries
- Developed User Guide for future use of the Database
- Database is currently being used as the primary calculation of the Tax Reserve
0-5 years of experience
Routinely used basic and advanced Excel functions to extract electronic data.
- Designed and modified Excel VBA macros and custom functions to streamline processes.
- Performed preliminary actuarial analyses of workers’ compensation insurance accounts.
- Proposed solutions for data issues, ensured high levels of data confidence.
- Communicated discrepancies to Underwriters and Pricing Analysts.
- Completed ad hoc projects for Actuarial Operations department.
- Provided assistance with training of new pricing technicians in use of Excel and VBA.
0-5 years of experience
- Supported month end financial reporting and production with Individual Life Valuation team
- Mapped valuation data for the conversion to new administration system. Reverse engineered calculation of premiums, reserves and benefits that lack of documentation, analyzed their compatibility with new models and quantified the financial impact of changes
- Processed requests for in-force policy illustration under various economic scenarios
- Maintained PC-based analytical programs(VBA, MG-Triton and APL) for admin system conversion
- Delivered presentation on Variable Annuity and Guaranteed Minimum Benefits
0-5 years of experience
- Compiled competitive credited rate reports in excel used by product management for rate setting
- Modeled reserves for cash-flow testing with a variety of annuity products using ALFA software
- Analyzed effects on reserves of fixed index annuities with respect to rates, market indexes and other factors
- Created summary reports for ORSA validation and other lines of business enhancing my dexterity with macros
- Devised a query-based method in Access to generate inforce files for ALFA production models
0-5 years of experience
- Achieved 50% time saving on monthly summary analysis of large scale claim data with Excel macros
- Improved the VBA Group Pricing Quotation Model effectively by testing and validating results
- Calculated IBNR Reserve with new risk factors and claim data from Access database
- Perfomed comparison report of profitabiity for different group insurance before and after reinsurance cover
0-5 years of experience
- Analyzed effect of early reported claims on overall loss ratio of a $60 million Liability portfolio
- Enhanced data that was initially insufficient by using similar data to find relativity trends
- Investigated recent shifts in claim payment speed within Employment Practices Liability
0-5 years of experience
- Performed Defined Contribution and Defined Benefit reserve calculations for our clients to satisfy PBGC’s requirements.
- Filed more than 20 government schedules for clients’ pension programs under stringent deadlines.
- Advocated “going green” project and helped develop flow charts to uncover opportunistic savings.
0-5 years of experience
- Streamlined the reporting process of key metrics by creating interactive dashboards and report
- Collaborated with IT department to set up sales quotation software for two new life insurance products.
- Researched product features of competitors and reported findings to senior management.
0-5 years of experience
Ran valuations on Defined Benefit and Defined contribution plans using ASC pension software.
- Performed annual administration of pension plans, including calculating required contributions and reconciling plan assets and earnings, in addition to preparing annual valuation reports.
- Prepared Forms 5500SF, its schedules, and Forms 5500EZ.
- Assembled Plan Documents for new pension plans using Plan Document generating software.
- Transitioned client data from existing Defined Contribution plan evaluation system to new software platform.
0-5 years of experience
- Conducted a loss analysis to provide quantitative descriptions for storms in 2014
- Collected and compared competitors’ loss cost multiplier and deviation for Business Owners Policy
- Researched and summarized competitors’ general liability A rates
- Verified the accuracy of the company’s new General Liability System using simulated data
0-5 years of experience
- Assisted in the preparation of documentation for local administrative insurance plan system
- Developed projection reports in the valuation system (PolySystem, Life Master) and performed analysis on the traditional life products
- Modified and enhanced the SAS codes which were used to generate the excel data files for surrender analysis
- Prepared surrender analysis reports by summarizing the data files with the excel tool
0-5 years of experience
- Created a pricing model for perpetual homeowners insurance product using Excel and VBA
- Evaluated profitability of current homeowners insurance rates
- Independently led a comprehensive pricing study and presented results to Board of Directors
- Conducted exploratory data analysis of historical client data
- Performed detailed analysis of customer retention rate over time
- Analyzed financial reports to allocate expenses and to determine investment portfolio yields
0-5 years of experience
- Supported valuation process maintenance and actuarial model development
- Assisted in new products coding in Prophet system and compiled the data of GAAP, Statutory Reserve and Embedded
- Double checked statistics from main and supplemental insurance products through Excel for accuracy
- Prepared and maintained effective documentation for universal and unit-linked insurance products
- Facilitated data collection from pricing reports and spreadsheets
0-5 years of experience
Assisted with the development of the firm’s CarePlus client services product. CarePlus is a multiple employer purchasing cooperative allowing mid-market employers access to quality insurance products that guarantee future prices based on behavior-based plan design and employee health management activities
- Analyze data sets in Excel to perform initial client reviews
- Created and maintained client accounts
- Provided benchmarking PowerPoint presentations for clients
- Prepared reports using excel used by managers for review processes
- Worked alongside analysts and consultants on project teams
0-5 years of experience
- Consolidation of data collected in tens of thousands of Excel workbooks in order to create a master database.
- Consolidated data will serve as input into an in depth review of historical pricing/underwriting practices and lead to enhancements to current practices.
- Project required a high attention to detail and advanced analysis in Excel, including writing VBA macros.
- Key challenges included identification and solving of nuances presented by the changing workbook structures used for storing the rating and underwriting data; due to evolving approach over a ten year period.
- Learned to code in VBA while on the job.
0-5 years of experience
Created and Implemented queries in MS Access to manipulate data from multiple sources to increase efficiencies
- Created exhibits that monitor sales and exception activity to reduce risk
- Analyzed data for accuracy
- Collaborated with team members to compile and analyze quarterly reports
0-5 years of experience
- Participated in life insurance projects contracted from various companies across Asia
- Performed actuarial attestation for assumptions, calculations and the reserve valuations; organized products’
- Utilized Excel VBA to conduct the sample crosscheck of the difference between TVOG and RSV
- Created a VBS application which could batch processing the merge of two Excel tables
0-5 years of experience
- Researched over 100 life insurance products and visualized sales of top ten products in the market
- Summarized monthly data and assisted in quarter-end business reserving report
- Studied Models for life insurance products and developed a calculator using Visual Basic for cash value at time of surrender
0-5 years of experience
- Work involved workers compensation, general liability, professional liability
- Constructed workbook to project IBNR workers compensation claims for a newly acquired client
- Updated data files such as loss runs and physician lists
- Tech reviewed workbooks as well as data files
0-5 years of experience
- Developed IBNR reserve triangle and performed risk margin analysis
- Updated data of all property and casualty companies in Sichuan and analyzed trends
- Created daily and monthly performance reports of whole company to managers
- Modeled worksheets more user friendly based on previous version
0-5 years of experience
- Analyzed Asset/Liability cash flow projections at different rate scenarios
- Measured the extent and direction of duration mismatches between assets and liabilities
- Performed sensitivity analysis on the impact of crediting strategy in a Fixed Index Annuity model
- Provided inputs to setting asset benchmark and presented results to Senior Executives
0-5 years of experience
- Participated in creating simulation tool which show how clients portfolio can varies depend on client information input.
- Assisted a chief actuary of Retirement Pension Department in preparation of the company’s products presentation for potential clients.
- Attended Retirement Pension Training seminars and obtained concept of DB/DC/IRA methods and PUC method.
- Evaluated and analyzed retirement pension contracts and reported to analysts.
0-5 years of experience
- Worked on reserving projects for self-insured and large deductible clients for Workers’ Compensation, Directors & Officers, General Liability, Property Liability and Auto Liability coverages
- Compiled and analyzed loss data for a countrywide Workers’ Compensation industry study
- Assisted in a Rate Level Indication Analysis for a Directors & Officers coverage line
- Performed Data Mining and Visualization (including Dashboards) using R and Tableau
- Created and Updated VBA macros for a range of different purposes, including optimizing actuarial models
- Drafted client reports and presentations as well as other deliverables
0-5 years of experience
- Converted individual life treaty data to a generic form using AXIS, Excel, and Access
- Created mortality assumption tables in Excel and imported them into AXIS to begin financial
- Analyzed and valuated AXIS calculation of lapse and mortality
- Reviewed, compared, and documented the interest rates, lapses, mortality benefits, and switches used in AXIS models for IFRS, STAT, and Tax valuations.
- Audited individual life model assumptions based on treaty data and gave documented feedback
- Assisted actuarial team with analysis projects
0-5 years of experience
- Calculated monthly cushion to guarantee for team rate-setting meetings
- Produced annuity pricing quotes for sample SPIAs using macro enabled spreadsheets
- Created macros to automate routine calculations using VBA and MS Access
- Developed a new process to create the monthly Hedging Reports
- Presented findings to entire actuarial community
0-5 years of experience
- Recoded raw data to input data for loan information of 40,000 insurance policies
- Diagnosed and evaluated risk in frequent, overdue and large loans
- Developed recommendation for modification in insurance policies
0-5 years of experience
Perform experience analysis and reserving in short term and long term health care
- Conduct data analysis as well as computer modeling using SAS, Excel, VBA
- Facilitate benfit plan & insurance pricing for 2014 health insurance rates
- Engage in 2015 Medicare Part D bids for a Fortune 100 pharmacy benefit management company
- Engage in 2015 Medicare Part C bids for a large HMO plan in the state of Florida
- Assist in 2015 Medicaid reserving and pricing for the state of South Carolina
0-5 years of experience
- Designed and constructed a comprehensive quoting tool (Quick Quotes) able to deliver any combination of dental, vision and health quotes for a business from 2 to 500 members in size
- Utilized a combination of MySQL, Access, and Excel to compile data for inclusion into Quick Quotes
- Crafted a user-friendly interface using ActiveX controls, VBA macros, and company branding
- Collaborated directly with website vendor to make sure project transition to a web environment was smooth
0-5 years of experience
- Assisted in quarter end MCCSR reporting and sensitivity testing by changing assumptions
- Accelerated stochastic run process through creating a VBA macro that extracts 200 market return
- Run GGY AXIS models for Embedded Value movement analysis, performed initial review of results
- Implemented basis changes into the Segregated Funds models
Rate This Article
[Actuarial Intern]
Last edited by: Gabriela Barcenas, CPRW, Content Writer II -
Gabriela Barcenas
CPRW, Content Writer IIGabriela is a Certified Professional Resume Writer (CPRW) and career adviser. With 10 years of digital media experience and five years of resume writing expertise, her publication history includes fashion, education, travel, social justice, equitable design and career advice.
