Data Analyst
Resume:
Anna Novak
*******@*****.***
Objective:
Experienced analyst with actuarial training seeks transition to data analysis or data driven business analyst.
Key Work Traits:
Problem solving, developing a deep understanding of the subject matter, persistence, professionalism, dedication to client satisfaction, obsession with accuracy
Education:
University of Washington
BA Mathematics/History
Enrolled in Georgia Tech Online Masters in Analytics
Starting Fall 2020
Summary of Experience:
December 2015 to April 2020
Business Analyst
Panasonic Avionics Corporation
Performed business analysis for key group of seven airline customers, including invoicing, forecasting, budgeting, 5 year planning and credit analysis
Routine duties included preparing slides for monthly and quarterly meetings, creating multiple scenarios for business review, and communicated with program management and marketing to identify improvements to customer service and revenue collection
Maintain Oracle database of warranty and identification information for over 15,000 airplanes
Review customer contracts to extract key terms relevant to repair, maintenance and analysts.
Assisted in transition between Oracle database and custom programmed database by gathering and collating data from multiple sources, including excel files, databases, and customer contracts
Spear-headed project to collect data from thousands of sources into a collection of large Excel files using VBA. The Excel files would later be uploaded into a database custom written for the purpose.
April 2013 to December 2015
Customer Account Representative
Panasonic Avionics Corporation (contracted through Kelly Services from April 2013 to January 2014)
July 2012 to April 2013
Department Coordinator
Panasonic Avionics Corporation (contracted through Kelly Services)
January 2010 to November 2010
Associate Consultant
Actuaries Northwest
Priced new business and additions to existing business for health care trusts
Used VBA tools to predict IBNR and IBNP information
Performed underwriting duties for both renewals and new business for health care trusts
Drafted monthly and quarterly reports for public clients, and for health care trusts
Used claims data in MS Excel and MS Access (Access SQL) for a variety of purposes, including
adjusting claims data to predict claims in non-identical groups of employees, analyzing
claims to determine geographic differences in provider fees, and ratesetting for future
claims periods
February 2008 to January 2010
Analyst
MCM, A Meisenbach Company
Designed funding strategies for deferred compensation and executive benefit plans, using multiple proprietary life insurance illustration software programs (COLI)
Worked with existing customer base to administer non-qualified deferred compensation plans
Developed and maintained annual, quarterly, monthly, and ad-hoc reporting standards for corporate owned life insurance and non-qualified deferred compensation plans
Analyzed efficiencies of different investment strategies, including taxable and tax-free options
Assisted sales personnel with many aspects of the sales process, including scheduling, designing and printing sales materials, and customizing proposals for prospective clients
Attended conferences and seminars on life insurance, annuities, deferred compensation, underwriting and retirement planning
Developed relationships with marketers, underwriters, clients and team-members, using all resources to ensure positive outcomes to immediate and future projects
Actuarial Exam Progress:
Credit Earned for: Exam P, Exam FM, Exam MLC, Exam MFE, Exam C
VEE Coursework completed
Topics covered: Probability, Statistics, Mathematics of Interest, Corporate Finance, Microeconomics, Macroeconomics, Modeling
Technical Skills:
Microsoft Excel – advanced/expert – including VBA
Microsoft Word, Outlook and Powerpoint – proficient
SQL (Access SQL, MySQL)
R, Python, C#
Contact this candidate