Utah County Insurance Pool

The Opportunity

The Utah County Insurance Pool was migrating from an antiquated system to WordPress for their website and needed to migrate their data and forms to input and display data in the backend.

The Ask

Three main challenges presented themselves in this project.
  • The data being transferred was not related properly and had to be migrated to a better database schema
  • The antiquated code had to be refactored to modern OOP(Object Oriented Programming) standards.   
  • Making sure the site was secure and that only certain people could see the data

Resolution

In order to make the site scalable, secure, and private we had to refactor all the antiquated code.  This meant that we had to completely code everything from the ground up. Before starting the refactoring process we created the new database schema.  After the schema was created we created a database map to migrate the old database to the new one.  A PHP migration script was then created to transfer the data to the new database. After the new database was populated we could then successfully refactor the code to represent the new database structure and security features that were needed.  We created roles and implemented security hashes that would make sure that if someone did get a hold of the database they could not decipher the data without the security key.  In the end, we successfully migrated the data and refactored the code to give the Utah Insurance Pool an essential tool for their organization.
    • Categories: Wordpress
Jacob Billings
During my career, I have worked in a number of different roles that have helped me understand the overall software development process. These roles include project management, senior developer, Linux administrator, technical sales consultant, and company owner. Working within these roles has given me an in-depth knowledge of best practices in software development.
I offer a strong aptitude for learning new technologies and a proven track record of meeting aggressive goals. My most notable skills include:

Software Development: I bring over 13 years of experience in developing software for multiple clients in various environments. I have a solid knowledge of PHP, Javascript, MySQL, Python, and Java.

Over my career, I have had the opportunity to work on projects for some of the most recognized brands on the planet. Brands like Marriott Hotels, Microsoft, Ashland Chemical, Capital One Credit Cards, Cadbury Schweppes, GE and more. This has given me an in-depth understanding of my client's challenges as they grow. I know how to get a company from startup to maturity with technology. My specialties are in E-commerce(specifically Magento), process automation, and security.