Wrangle LLC is an ERISA Reporting company founded by Kari and Michael Schneider, based out of Junction City, Oregon. Kari and Michael started Wrangle to leverage their combined 45 years of experience as Certified Employee Benefit Specialists, and to bring their unique knowledge of ERISA reporting to customers.
ERISA (Employee Retirement Income Security Act) is a federal law enacted in 1974 that establishes legal guidelines for private pension and employee benefit plans. ERISA Reporting establishes the standards and procedures for pension and benefits plans that designate fiduciaries, delegate responsibility, manage plan funds and define prohibited transactions.
Wrangle LLC came to Amadeus Consulting to assist them with the creation of a custom database design to help them keep track of the policies and procedures they send to clients. In order to keep up with its rapid growth, Wrangle needed to optimize an existing reporting process. Wrangle LLC needed a database that could input, filter, sort and report data in a more meaningful and faster way than Excel would allow. The company was confident in our ability to take existing Excel-based process and make it into a scalable, user-friendly database.
Often the transfer of Excel-based procedures to databases can pose challenges due to lack of requirements. However, as a result of Amadeus Consulting extensive experience with databases, our Directors were able to capture all of the client's needs in the requirement phase, insuring a smooth transition from project beginning to end.
Hosted in Amazon's S3 Cloud, Wrangle LLC's Database Tracking System allowed them all the functionality required to search, filter and report on their procedures as well as track policies sent to clients. Using Visual Studio to create built-in user functionality, Wrangle LLC was able to import all of their historical data quickly and with ease. Using SQL Server 2005 gave Wrangle the ability to continue to grow past its current 1,000 clients in a scalable environment.
The custom-built data tracking system made their reporting process extremely efficient, and is currently assisting them with their rapid growth. Wrangle LLC was extremely pleased with the results, and is looking forward to enhancing this database to meet Wrangle LLC's future needs.