Indu Prakash Shahi
**** ******* *****, ***. # ** Sacramento, CA 95826
781-***-**** ******@********.***
Fully Work Authorized No Visa Sponsorship Required
PROFESSIONAL SUMMARY
Actuaral analyst/professional with more than 10 years of extensive experience in non-profit and business sectors
Key Skills:
Expertise in quantitative analysis, actuarial valuation and pensions schemes
Experience in Data Analysis Using R, STATA and Excel
Proficient in MS Office, STATA, working knowledge in SQL, R, Python and TreeAge for cost-effectiveness analysis
Fluent in English; Hindi and Nepali (native), basic knowledge in Spanish & German
PROFESSIONAL EXPERIENCE
Researcher 09/2016 - 06/2017
Friends of Nepal, New Jersey, USA
Non-profit organization associated with Rotary International
Conducted data analysis on deaths of women covered by insurance against those not covered by insurance
Projected a 30% reduction on maternal mortality rate for women with insurance coverage
Increased number of women insured in the project-implemented area by 10% over a 4-month period
National Consultant 03/2015 – 07/2015
International Labor Organization (ILO), Kathmandu, Nepal
A United Nations’ agency working for global labor issues
Data Mining and cleaning on employee’s sickness, maternity, work place injury and benefits
Liaised with actuary and stakeholder; collected employee data for actuarial valuation of social insurance
Analyzed data, modeled and Data visualization for actuarial valuation of social insurance
Insurance Consultant 11/2014 – 08/2015
Katahira International Japan and Full Bright Consultancy, Kathmandu, Nepal
A leading consulting firm in Nepal with more than 100 office employees and 200 + senior engineers and other experts
Prepared written inputs on literature reviews, concept notes & background papers on casulty insurance
Analyzed casualty insurance data in using R and Excel after their careful mining and cleaning
Identified excess insurance claim and recomended it to an amount of USD5K
Disseminated reports, concept notes, presentations, briefs and data visualizations to corporate partners
Prepared a study report with recommendation to existing insurance provisions
Social Insurance Design Consultant 12/2012 - 07/2013
Social Security Fund Secretariat, Kathmandu, Nepal
Nepal Government Entity with 100K+ employees
Conducted literature review on social insurance models in Thailand, South Korea, India, Tunisia and Turkey
Data mining from various sources including web and offices and cleaning them using R
Concluded suitable actuarial assumption and set parameters for actuarial calculation of social insurance
Designed four insuracne products and calibrated and compared them with international experience
Developed business procedure for premium collection, it’s investment and claim payment
Conducted data visualization, presentations, disseminated highlights of report and answered queries of stakeholders
Acomplished, independently, a policy report on social insurance and submitted it to the government of Nepal
Assistant Professor of Insurance
Atlantic International College, Kathmandu, Nepal 08/2011 – 07/2015
Top rated management school with approximately 150 faculty/staff
Apex College, Kathmandu, Nepal 07/2010 – 07/2015
Leading management school with approximately 350 faculty/staff
Taught US life & health insurance, retirement benefits, Managed care, HMO, PPOs to undergraduate students
Explained knowledge of domestic and international multi-payer insurance payment mechanism
Supervised, evaluated & graded students’ assignments, presentation, project on health insurance
Actuarial Officer 04/2010 – 03/2011
National Life Insurance Co., Ltd., Kathmandu, Nepal
One of the oldest insurance companies throughout the country with a capital of more than USD15M
Analyzed existing insurance products and recommended riders to modify them
Analyzed group and individual insurance premiums and designed premium collection strategy
Developed computer-generated performance measurement report for more than 500 sales team
Actuarial Analyst 04/2009 – 01/2010
Ranadey Professional Services, Pune, India
Actuarial valuation consulting firm with more than 200 firms in India and some in USA
Analyzed large data set in excel and communicated to clients for update or clarification on the data set
Reconciled data in excel and processed for gratuity benefit calculation
Forecast future life expectancy and estimated interest rate using long-term bond rate
Generated gratuity and leave encashment valuation report for employees
Analyzed the actuarial outputs reports on valuation, Accounting Standard15, FASS 88 and GAAP
Pensions Administrator 02/2005 – 05/2008
Lloyds TSB, (Scottish Widows), Edinburgh, UK
Brand name for insurance and banking sector in the UK, with more than 50k staff and more than 100 B in assets
Analyzed the large pensioner’s data in excel, generated their pension benefits and communicated to clients
Calculated early, normal and late retirement pensions benefit
Generated contribution-based retirement benefits including Additional Voluntary Contribution
Developed internal and external communication skills
ADDITIONAL WORK EXPERIENCE
Customer Service Representative 01/2017 - 08/2017
ARCO AmPm, Rancho Cordova, Sacramento, CA
Handled cash, generated daily sales report and dealt with customer inquiries and complaints
Managed quality services in all aspect of regulatory requirement
Improved office efficiency and customer service by overhauling previously haphazard pricing,inventory system
EDUCATION
MS in Global Health Policy and Management 2016
Brandeis University, Waltham, MA
Ranked top 10 in the USA by the Heller School of Social Policy
M Sc in Actuarial Science 2005
Heriot-Watt University, Edinburgh, Scotland
Ranked 47th in world, 3rd in UK, and 1st in Scotland
M Sc in Mathematics 2000
BA/B ED (Math and Economics) 1996
Tribhuvan Universisty, Kathmandu, Nepal
Top university in Nepal
PROFESSIONAL DEVELOPMENT/AFFILIATIONS
Actuarial Profession of USA (SOA), member since 2017
Member of Rotary International
PROFESSIONAL TRAININGS/CERTIFICATION
R Programming A-Z™: R for Data Science with Real Exercises: from Udemy
Data Science and Machine Learning Bootcamp with R: from Udemy
R Programming: Advanced Analytics in R for Data Science: from Udemy