Texas General Land Office

AleroSoft has been working with the General Land Office since 2011, consulting on numerous major and minor projects. The General Land Office earns money for the State of Texas in a variety of ways, including leasing the state's vast land and mineral holdings for energy and mineral development. There are approximately 13 million acres of state land and mineral rights that the GLO manages. Permitting, leasing, and management of oil and gas development on state lands is a core responsibility of the Texas GLO.

Asset, Surface, Oil and Gas Managment System
Each business unit within the GLO managed different aspects of lease management, and each unit had its own methodologies and system in place. Our effort was an 18 month contract with the GLO to consolidate and modernize 14 disparate Access databases and systems into one application. The goal of this effort was to have a one-stop-shop via a web-browser where all data is stored in one central location and business units could view its information in a consistent manner.

We accomplished this by developing a Flex front-end User Interface, a Jboss middle-tier Application Server, and a MS SQL database that stores and retrieves information. We have provided a single system for GLO customers to create, edit, view, delete all lease related information in once central place.

Financial Datamart Query Tool

In addition to our previous effort with Texas GLO, we also developed a web-based User Interface that allowed GLO customers to execute a defined set of filtered queries against the financial system database. This functionality served about 200 users across the different program areas and allowed non-programmers to easily build dynamic ad hoc queries.

The basic functionality of the tool allows a user to select the type of query to run and limit the results by one or more filters (e.g. Lease Status, Date, Land ID, etc.). The results are presented back to the user in tabular format where they can sort and filter the results, add/remove columns to display, as well as drill-down functionality to display more information. The user can then print the results or export the information to Excel, Word, PDF, leveraging SSRS.



We believe in keeping it simple, from requirements gathering, to defining user stories, to developing software ... Read more


We specialize in providing custom software solutions to our clients by understanding your business needs ... Read more


Our value-add is delivering simple solutions to complex problems your organization faces everyday. Most... Read more