Engineering Innovation Around the Nation's Capital

Theseus created easy-to-use Splunk dashboards to help an investment management firm track and understand the activity of their software development tools on AWS and Azure. These dashboards used detailed logs from Bamboo, organized and labeled, to show real-time updates on any errors that happened during the process of building and launching software. The dashboards made it simple for teams to see how often problems occurred, how serious they were, and how long different steps of the process took. This gave the firm a clear picture of their projects and helped them quickly spot and fix issues.

Theseus helped a $200 billion investment firm evaluate cloud analytics platforms—BigQuery, Snowflake, and Redshift—to determine the best fit for their extensive data needs. The team conducted rigorous load-testing, assessing scalability, efficiency, and maintenance. Migration feasibility was analyzed, ensuring compatibility with Splunk, Power BI, Aladdin, LDAP, and database schemas. The study also covered database auto-shutdown, industry trends, and integration ease. This analysis empowered the client to optimize performance, scalability, and cost-efficiency.

In early 2024, Theseus designed and implemented a feature in a web portal used to manage logistics and research history related to financial securities. The project involved creating a file upload functionality that allowed analysts to send financial modeling calculations to an application hosted in a Docker container. The application, using its IAM permissions, posted the files to an AWS S3 bucket. Once uploaded, an AWS Lambda function performed quality checks on the data, ensuring proper structure and error screening by comparing calculations across the firm.

Theseus helped LMI optimize data management with Collibra. After a Proof of Concept, the team customized Collibra to fit LMI's needs, creating custom agents and automating deployment on EC2 using Ansible. They carefully planned task handling to ensure seamless integration. This improved data organization, governance, and tracking, making information easier to manage and use. The project enhanced efficiency, reliability, and scalability, enabling LMI to streamline operations and optimize long-term data management.

Theseus documented key LMI Architecture components, focusing on data pipelines, Snowflake integration, and Control-M job orchestration. Guides detailed secure SA pipelines, Snowflake setup, and Control-M automation standards for scheduling, monitoring, and error handling. Security documentation covered access controls, encryption, and data integrity. These resources ensure system security, consistency, and maintainability.

Theseus strengthened security across two data integration platforms, Snowflake and SnapLogic. For Snowflake, the team implemented fine-grained access controls, encryption for data at rest and in transit, and regular compliance audits. In SnapLogic, they introduced role-based access controls, secured API connections, and real-time threat monitoring. Automated security assessments were deployed to continuously evaluate and enhance protection, ensuring a resilient and secure data infrastructure.

Theseus improved a financial investment firm's Earnings Survey reporting by integrating an auto-refresh feature in PowerBI. The project started with a Microsoft Forms survey collecting analysts' opinions on sector events. Data was sent to Snowflake via Power Automate, then sourced into a PowerBI dataset for a 10-page analysis report. The report displayed current results and quarterly changes. Auto-refresh kept data updated in real time, eliminating manual updates and enhancing decision-making.

Theseus set a front-end standard at an investment bank to eliminate unnecessary, costly frameworks. The bank's unconventional tech growth led to integration challenges and inefficiencies from uncoordinated software leadership. By uniting UX, product, architecture, and front-end teams, Theseus created a unified approach to tech decisions. This strategic coordination mitigated risks, enabling a scalable ecosystem that boosted code reusability and strengthened cross-team collaboration for future application development.