- Featured in:
-
High Quality
The best examples from thousands of real-world resumes
Expert Approved
Handpicked by resume experts based on rigorous standards
Diverse Examples
Tailored for various backgrounds and experience levels
Actuarial Intern Resume Samples
No results found
Candidate Info
months in workforce
months at this job
Actuarial Science
Actuarial Science
Actuarial Intern
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
Candidate Info
years in workforce
months at this job
Information And Computational Mathematics
Actuarial Science
Actuarial Intern
- 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%
Candidate Info
years in workforce
years at this job
Statistics
Economics
Property & Casualty Actuarial Intern
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.
Candidate Info
months in workforce
months at this job
Actuarial Science
Actuarial Intern
- 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
Candidate Info
year in workforce
months at this job
Applied Mathematics
Math And Social Science
Actuarial Intern
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
Candidate Info
years in workforce
years at this job
Actuarial Science
Actuarial Intern
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
Candidate Info
years in workforce
months at this job
Business Administration
Actuarial Intern
- 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
Candidate Info
year in workforce
months at this job
Economics
Actuarial Science
Actuarial Intern
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
Candidate Info
months in workforce
months at this job
Mathematics
Actuarial Intern
- 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
Candidate Info
months in workforce
months at this job
Electrical Engineering, Mathematics
Actuarial Science
Actuarial Intern
- 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
Candidate Info
months in workforce
months at this job
Mathematics
Actuarial Intern
- 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
Candidate Info
months in workforce
months at this job
Actuarial Science
Actuarial Intern
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.
Candidate Info
months in workforce
months at this job
Statistics / Mathematics & Economics
Actuarial Intern Professional Liability
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
Candidate Info
months in workforce
months at this job
Mathematics Actuarial Track
Actuarial Intern
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
Candidate Info
months in workforce
months at this job
Applied Mathematics
Finance Study
Actuarial Intern
- 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
Candidate Info
months in workforce
months at this job
Economics
Actuarial Intern
- 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
Candidate Info
years in workforce
months at this job
Applied Math
Actuarial Intern
- 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
Candidate Info
years in workforce
months at this job
Economics
Mathematics
Commercial Line Actuarial Intern
- 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
Candidate Info
months in workforce
months at this job
Actuarial Science
Statistics
Actuarial Intern
- 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
Candidate Info
years in workforce
months at this job
Mathematical Economics
Actuarial Intern
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
Candidate Info
years in workforce
year at this job
Actuarial Science
Actuarial Science (minor
Pricing Technician / Actuarial Intern
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.
Candidate Info
years in workforce
months at this job
Risk Management And Insurance
Mathematics
Actuarial Science
Actuarial Intern
- 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
Candidate Info
months in workforce
months at this job
Actuarial Science
Actuarial Intern
- 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
Candidate Info
years in workforce
months at this job
Actuarial Science
Actuarial Science
Actuarial Intern
- 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
Candidate Info
months in workforce
months at this job
Actuarial Science
Actuarial Intern
- 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
Candidate Info
months in workforce
months at this job
Mathematics - Actuarial Science
Actuarial Intern
- 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.
Candidate Info
months in workforce
months at this job
Actuarial Science
Actuarial Intern
- 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.
Candidate Info
years in workforce
years at this job
Master of Science
Actuarial Intern
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.
Candidate Info
months in workforce
months at this job
Actuarial Science & Risk Management And Insurance
Actuarial Intern
- 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
Candidate Info
months in workforce
months at this job
Mathematics: Statistics And Actuarial Science
Actuarial Intern
- 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
Candidate Info
years in workforce
months at this job
Mathematics
Modern Languages, Linguistics And International Communication - German Concentration
Actuarial Intern
- 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
Candidate Info
months in workforce
months at this job
Mathematics
Actuarial Intern
- 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
Candidate Info
year in workforce
months at this job
Actuarial Science
Health Insurance Actuarial Intern
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
Candidate Info
years in workforce
months at this job
Actuarial Mathematics
Economics
Actuarial Intern
- 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.
Candidate Info
years in workforce
months at this job
Actuarial Science
Intern, Summer Actuarial Internship Program
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
Candidate Info
months in workforce
months at this job
Actuarial Science
Statistics And Financial Economics
Life Insurance Actuarial Intern
- 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
Candidate Info
years in workforce
months at this job
Mathematics
Master of Science
Actuarial Intern
- 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
Candidate Info
months in workforce
months at this job
Statistics
Actuarial Intern
- 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
Candidate Info
months in workforce
months at this job
Actuarial Science And Mathematics
Actuarial Intern
- 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
Candidate Info
years in workforce
months at this job
Actuarial Mathematics
Actuarial Science
Actuarial Intern
- 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
Candidate Info
months in workforce
months at this job
Actuarial Science
Business, Organizations & Society
Actuarial Intern
- 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.
Candidate Info
years in workforce
year at this job
Physics
Actuarial Science
Actuarial Intern (p&c/predictive Analytics)
- 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
Candidate Info
years in workforce
months at this job
Actuarial Science
Corporate Actuarial Intern
- 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
Candidate Info
months in workforce
months at this job
Actuarial Science
Actuarial Intern, Fixed Annuity Pricing
- 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
Candidate Info
months in workforce
months at this job
Statistics
Actuarial Science
Actuarial Intern
- 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
Candidate Info
years in workforce
months at this job
Actuarial Science
Actuarial Intern
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
Candidate Info
years in workforce
months at this job
Statistics
Actuarial Intern
- 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
Candidate Info
months in workforce
months at this job
Finance
Actuarial Science And Statistics
Actuarial Intern
- 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