Collin College Preston Ridge - Mathematics
Product Manager at UPC Insurance
Insurance
John Michael
Meléndez Casellas
Saint Petersburg, Florida
With a passion for logic and critical thinking, using programming languages like SQL, Visual Basic, and SAS to analyze data within the insurance industry to develop Personal Lines products. I am eager to continue to develop technical skills in coding as well as learn the insurance industry intricacies in order to increase my ability to create products and solutions.
Product Manager
• Lead product development efforts in my assigned states, refresh and new homeowner’s product launches, and closely support delivery partners in Project Management, Sales, Marketing, Claims, other departments and external partners.
• Work with a team of Product Managers for new top of the line initiatives across states.
• Responsible for compliance and profitability for all products in my assigned states.
• Conduct regular periodic in-depth loss analysis of the Homeowners and Dwelling Fire programs in my assigned states.
• Implement and monitor ongoing portfolio optimization process in order to minimize reinsurance costs.
• Continue all prior responsibilities as an Assistant Product Manager.
Assistant Product Manager
• Led product development efforts for Hawaii, refresh and new homeowner’s product launches, and closely support delivery partners in Project Management, Sales, Marketing, Claims, other departments, and external partners.
• Supported product development effort for products in Texas and Georgia.
• Conducted market analysis for competitive positioning and rate making as well as product features, forms, and underwriting for the states and products afore mentioned.
• Use of data mining and statistical tools such as Excel, SAS and SQL to collect, create, and maintain up-to-date InForce data and rating algorithms used to support decision making and impact.
Research Assistant
• Developed the ability to recognize key and relevant information from insurance filings
• Performed peers reviews and accurately address issues to eliminate future occurrences
• Required to multitask and change priorities in a quick and efficient manner
• Managed written and verbal communications with out-of-state outsourcing company
• Resolved errors and issues as they arise relating to filing entries in our website
Associate
September 2015 - McGraw Hill Financial acquired SNL Financial
April 2015 - SNL Financial acquired RateFilings.com, a division of Perr & Knight,
• Responsible of maintaining the rate analysis competitive intelligence product, RateWatch
for over 400 insurance companies in eight states
• Required to research, collect and maintain manual libraries for homeowner insurance filings
for over 400 insurance companies in eight states
• Performed peers review to ensure quality and accuracy
• Compile current insurance manuals for ad-hoc projects
• Required to multi task and change priorities in a quick and efficient manner
Product Analyst
• Create business strategy and pricing plans as part of a team
• Gather, consolidate, and disseminate data
• Work with state regulators to ensure pricing plans are in compliance
• Create, develop, and automate reports for analyzing large data sets using SQL, VBA, Excel and PowerShell
Adjunct Associate Professor
• Teach Elementary Statistical Methods which includes:
-Preparing lectures, homework, exams and study materials
-Create and update a gradebook
-Incorporate technology to facilitate learning
Master of Science (M.S.)
Mathematics
Engineering
One year as part of National Student Exchange program (NSE).
Bachelor of Science (BS)
Mathematics