John Meléndez Casellas

 JohnM. Meléndez Casellas

John M. Meléndez Casellas

  • Courses1
  • Reviews1

Biography

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.


Experience

  • UPC Insurance

    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.

  • UPC Insurance

    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.

  • Perr&Knight

    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

  • McGraw Hill Financial

    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

  • Hallmark Financial Services Inc.

    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

  • Collin College

    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

Education

  • Texas A&M University-Commerce

    Master of Science (M.S.)

    Mathematics

  • Oklahoma State University

    Engineering
    One year as part of National Student Exchange program (NSE).

  • Jarvis Christian College

    Bachelor of Science (BS)

    Mathematics