We began by developing a deep understanding of the intricate business logic and processes to be mirrored and streamlined in the new tool. This involved reverse engineering from existing Excel spreadsheets and databases, along with integrating human experience and judgment.