Advanced Analytics Intern Resume HARTFORD, CT - Hire IT People

TECHNICAL SKILLS

Proficient in: R, SAS, SQL, Microsoft Access, Microsoft Excel, and Microsoft Visual Basic

Working knowledge of: Microsoft Access, Python, Tableau and C++

PROFESSIONAL EXPERIENCE

Advanced Analytics Intern

Confidential, HARTFORD, CT

Responsibilities:

Perform data cleansing and data validation activities on large and complex datasets by leveraging property and casualty insurance domain knowledge to ensure data integrity and maintain data quality
Enhance the small business auto pricing model by analyzing individual’s risks and incorporating actuarial concepts using SAS EG and R
Use 10 - fold cross validation to build penalized double generalized linear model and choose the penalty parameters based on the Gini Index and mean squared error
Conduct loss ratio tabulation analysis and dual lift charts to evaluate current model, and interpret the model results assessment from a practical and business perspective
Participate in internal meetings and visually presented strategic solutions on company’s operation based on quantitative results generated from data analysis

Summer Business Analyst

Confidential

Responsibilities:

Monitor and consolidate data sources from various marketing related systems, and then build a SQL database in SQL Server to make analysis easier
Develop Business Intelligence dashboards using various exploratory analysis and data visualization techniques through advanced SQL to identify the root cause behind financial trends

Actuarial Analyst Intern

Confidential

Responsibilities:

Build a product recommendation tool by analyzing insurance products’ features and customers’ behaviors
Conduct profit tests on annuity products using self-constructed models to help price products
Evaluate products’ profitability based on the portfolio convexity, Macaulay duration and Yield to Maturity in order to select potential investments

Finance Intern

Confidential

Responsibilities:

Conduct customer companies’ credit risk analysis based on leverage ratios, Interest Coverage Ratios and financial structures to gather investment details
Participate in meetings with targeted companies and took notes regarding terms negotiation and future plan
Conduct bank reconciliations for six bank accounts and prepared monthly petty cash reports using Excel

Organizer/ Photographer

Confidential

Responsibilities:

Found the first libraiy in Baishui, Gansu with a team of five volunteers from three different countries
Start weekly reading and discussing events with local teachers and motivated 300+ students to learn and share opinions

Secretary/ Fundraising Director

Confidential

Responsibilities:

Organize the UConn Idol and Bubble Tea Festival, attracting more than 200 students to attend
Raise $2,500 in 8 months for the Confidential by selling bubble teas, holding culture events and cooperating with other members
Manage daily operation of the association by constantly maintaining social media platforms and recording meeting minutes for 11-E board members