- Explored and build models for enhancing segmentations on Commercial Auto Territories- Conducted studies and analysis to revise coefficients for Commercial Lines underwriting models- Created reporting procedure for Commercial Auto uninsured motorist experience to monitor profitability- Implemented and enhanced new rate comparison template for better accuracy and efficiency for the Commercial Auto rate review process

- Created tool to pull, analyze competitors' rate filings for competitive analysis- Developed web scraping tool to improve zip codes rating for Commercial Auto- Pricing work for Commercial Auto

- Develop and verify rating algorithms for General Liability and Inland Marine for Guidewire platform migration- Facilitated SAS query conversions during data server migration from SQL to Netezza

- Develop and maintain data source for competitive modeling process to ensure accuracy- Develop and analyze on indications for Commercial Lines Package policies

- Converted and enhanced indication spreadsheets from Lotus to Excel platform- Prepare each state rate change and filing support for Commercial Lines Package policies- Prepare, analyze and present quarterly financial reports to supervisor

• Modify Crystal Reports to improve accuracy in modeling process for cancer products• Compute health reserves using completion factor method for cancer products• Calculate statutory, tax and GAAP reserve factors for life and annuity products• Download product specifications and test new Universal Life reproposal system - developing spreadsheets to verify all calculations are consistent with policy administration system • Developed automated procedures in quarterly financial reporting - reduced turnaround time consuming by 30% and improve accuracy by avoiding human error• Validate illustrations for new Universal Life product

-Developed spreadsheets to validate results from projection system-Reserve calculations from LifePRO Administrative System -Calculated reserves and net premium for a new product design-Built an user-friendly spreadsheet for product illustrations.