Treselle systems services
Treselle systems services
Treselle systems services
Treselle systems services

Technology & Integration

OVERVIEW

Whether you are leading Engineering, IT, Product Development, or any other business function, we know that your business initiatives involve technology and integration quite a bit. Over time, executives will inevitably have to grapple with the decision to bring in change to their existing infrastructure, applications, and tools, and IT environment. This change not only requires a vision and budget, but also talented resources with a capacity to understand the current technology in place and execute the vision. We have helped executives accomplish change and execute their vision. Whether you’re trying to trim technology costs or radically implement major application changes, your infrastructure should support your organization’s business strategy. Technology and integration helps to structure, manage, and implement solutions that enhance your business processes, operation, and underlying technology assets to achieve business value. The questions are: what to do, how to do, and where to start? Over the years, through our consulting and implementation practice, we have gained insights into the challenges CxO’s face. We can help. Contact us.

Capabilities

  • Product Development for Startups

  • Application Development & Maintenance

  • Microservice Architecture

  • Cloud Services

  • SQL & NoSQL Database Services

Product development, especially for Startups is very different from project development. The role of the product organization is to consistently deliver significant new value to the business through continuous product innovation. Product development has some of the following characteristics:

  • No well-defined start and end dates
  • Ambiguous requirements
  • Extremely agile driven
  • Vision is up to 2 to 3 sprints only
  • Not scared of throwing away unwanted stuff
  • Constant feedback loop and adjust the course
  • Highly research oriented
  • Starts with minimal viable product
  • Executes lot of quick proof of concepts
  • Component ownership
  • Multiple quick demos to customers

Teams working in product development exhibit different mindset than those in IT project development. Treselle has extensive experience in working with product development for Startups and enables them to turn their raw ideas into high growth business by supporting technology & operation capabilities, create product roadmap plan, work with ambiguous requirements in agile methodology, perform research & prototyping, and build Minimal Viable Product to a full-fledged product. Treselle has depth & breadth of skillsets to develop complete solutions – Architects, backend, frontend, database, testing, DevOps, project managers, data integrators, etc…

To remain competitive, businesses should make sure that their applications are working efficiently and supporting all their business needs. Businesses are constantly looking for custom solutions to support internal and external users and modernizing legacy systems while enhancing existing systems and applications. Treselle has helped businesses by taking complete responsibilities from analysis, design, implementation, testing and integration of systems and have experience in the following:

  • Legacy application modernization: Often times, businesses have to re-purpose, refactor and consolidate legacy applications to align it more closely with current business needs. This is to create new business value from existing applications and keeping legacy applications running smoothly can be a time-consuming, resource-intensive process, especially when the application becomes very outdated.
  • Backoffice integration & automation: Businesses generally starts with manual way of tracking and monitoring multiple backoffice systems and partners using tools such as excel, emails, shared drive, etc and realizes at a point where more time is spent doing rudimentary tasks over and over resulting in inefficiency. These manual error-prone process can be automated, and integrate with existing backoffice solutions and partner systems with better tools and technologies
  • Salesforce integration: Businesses use Salesforce CRM system assuming it will be used for sales team only and a standalone system disconnected from rest of the business systems. However, over the time businesses sees more needs to integrate it with rest of their systems to keep the information flow in both ways that will enable sales team to be more efficient as they have more knowledge about accounts, leads, and contacts
  • Custom application development: Businesses do face situations where the software that suits their specific needs isn’t available on the market. It is essential to build time and cost-effective customized applications that help businesses address their business goals efficiently
  • Single Page Application Development: Scrolling no longer is an annoying experience for users and SPA makes it happen with responsive apps. SPAs provide for a better performance and can handle load distribution more efficiently through dynamic data load from the server-side API and connection with RESTful web services. Application such as SaaS, business apps, data visualization apps, and social apps can all make use of SPA methodology. Technologies and their capabilities such as AngularJS, Backbone.js, Node.js ecosystem, HTML5, CSS3, and JQuery are the main reasons for businesses opting for SPA. Treselle has extensive experience in building SPA using the above mentioned tools and technologies
  • Mechanical Turk force for data: We have seen many businesses don’t have enough human resource power to perform various data validation checks, associate, correlate and map data, filter and normalize based on some business rules, check the accuracy of data in multiple web location and prepare reasonable data. Treselle has helped businesses with these needs using internally trained Mechanical Turk force

A plethora of tools and technologies to solve different problems rather than force fitting the solution to the existing technology, and popularity of agile methodology, continuous integration & deployment, containerization, cloud, and DevOps is making businesses to realize about the disadvantages of their monolithic applications and start thinking about microservices that has some of the following benefits:

  • Services are focused on doing one thing and doing it well
  • Lessens dependencies between teams, resulting in faster code to production
  • Allows lots of initiatives to run in parallel
  • Allows polyglot programming and storage persistence to use best technology for the use case
  • Enables graceful degradation of service
  • Promotes ease of innovation through disposable code—it is easy to fail and move on
  • Continuous integration, development, and deployment
  • Ability to scale services independently and provide high availability

Treselle has extensive experience in building microservice architecture and implementing the solution using both custom and cloud based solutions depending on business needs. Treselle teams diversed skillsets on multiple programming languages, SQL/NoSQL exposure, DevOps & containerization capabilities, and deep experience with AWS cloud makes them an apt team for microservice journey

Cloud computing has been exploiting recent advances in software, networking, storage, and processor technologies with key characteristics: agility, cost (pay-as-you-go), multi-tenancy, scalability, elasticity, and sustainability. Cloud computing not only lowers power, people, and capital costs, but also provides resilience without redundancy. However, there are potential pitfalls in migrating applications to the cloud. Treselle has helped businesses in building applications using AWS web services, migrate their on-premise systems to AWS cloud, and manage AWS cloud infrastructure.

  • AWS Cloud Application Development: Treselle has experience building different types of applications on cloud such as complete SaaS product, batch data processing, long running process, streaming data, data storage persistence using different AWS storage services, event and notification execution model, etc
  • AWS Cloud Migration: Businesses are increasingly moving to cloud based services for computing, elasticity, cheap storage, better security and access controls, and other managed services to save cost, achieve scalability, and prepare for capacity growth plan. Treselle has helped businesses in migrating on-premise and private data center applications to AWS cloud services based on business needs
  • AWS Cloud Infrastructure Management: Treselle has helped clients in managing their AWS cloud infrastructure with continuous cost saving plans by using reserved or spot instead of on-demand instances, migrate old and degraded instances to new instances, monitor health of different services using cloudwatch, manage security across different AWS services using IAM & security groups, prepare roadmap plan based on business requirements, automation of mundane tasks using AWS CLI & SDK, and others

For years, the relational model has been the de facto option for data problems big and small. We don’t expect relational databases to fade away and they will continue to have a huge role in serving business’ needs. However, enterprises are emerging from the relational databases fog to discover alternate options, such as schema-less or alternate data structures, simple replication, high availability, horizontal scaling, and new query methods. It’s very important to remember that enterprises can solve most of their data challenges by one or a combination of multiple types of databases. The question is which database or combination of databases is best suitable for your problem space and usage patterns.

  • SQL Database Service on Cloud: Many businesses have moved to cloud based AWS RDS database systems running on MySQL, Oracle, Postgres, and Aurora providing same on-premise capabilities minus administration tasks related to upgrades, patching, backups, etc. Treselle has helped clients implementing SQL database solutions on AWS that includes data modeling for master and transaction data, schema evolution, implementing complex statistical computations on stored procedures, etc.
  • NoSQL Database Service: There are specialized databases to handle different types of data. The hybrid approach of mixing different database technologies and designing database architectures to meet the specifics of business requirements is called Polyglot Persistence, which has been a crucial factor in the rise of NoSQL databases. Treselle has extensive experience with multiple NoSQL databases such as MongoDB for Geo-Spatial needs, Redis for caching needs, Neo4j/OrientDB for graphing needs, Cassandra for time-series needs, Elastic Search for text and search capabilities, and others.

RESULTS

Global Client Goes Polyglot with Persistence Storage
  One of our clients, with variety of data types, invested in different persistent storage that included connections and recommendations in Neo4j, Geospatial in MongoDB, Time series in Cassandra, User Preferences & Reporting Data in MySQL, Authorization & Authentication in LDAP, and User Sessions & Caches in Hazelcast. The client faced challenges to integrate variety of these data stores to provide one unified view to their SaaS application. One of Treselle’s engineering teams designed and architected:

  • A polyglot persistence integration framework using Spring Data, MVEL, and Apache Camel.
  • Spring Data was very useful as it has many out of the box connectors to various data stores. Custom connectors were built for those that were not available.
  • MVEL for expression language to convert the user queries into respective data store queries, and
  • Camel for routing to proper service based on request metadata that interacts with a target data store.

Business benefits delivered:

  • Ability to use the data on client’s SaaS product within 4 weeks for the most demanding capabilities in the first phase.
  • ZERO changes to the client’s persistence layer.
  • Ability for our client to easily create custom connectors to new data stores in the future.
  • Thousands of dollars savings in resource cost as the chosen framework stack abstracted all the complexities and reduced the dependency on specific persistence expertise.
  • A unified data access layer was achieved, which the client was struggling with during the previous 18 months.
Investment Firm Migrates Legacy Publishing System to Activiti BPM
  One of our clients had a 7-year old publishing system written using obsolete Symfony PHP framework and the engineers who built it were no longer with the client’s team. Our client had lot of challenges to create new business process workflow, change existing or add new templates, track the activities in a process, and other reporting capabilities. One of Treselle’s engineering teams was chosen to either continue the work on old system or create a new system in a cost-effective way. In the absence of requirements and other technical documentation, our team reverse engineered the old system and understood what was done in the Symfony code. We then created an understanding document followed by requirements document from the reverse engineering activity, held a session with our client to confirm the requirements, decided which requirements are needed from the old system and added the new requirements for project planning and estimation purposes. Based on the requirements, Treselle team chose and implemented the publishing system using Activiti BPM from Alfresco as it has many out of the box functionalities that satisfies 60% of the requirements with some tweaking. Activiti was a good fit for several reasons. It is based on Spring and we could use engineers with already Spring knowledge. Activiti Designer enabled us to create different BPM workflows graphically. Activiti Engine was easily extensible to add custom functionalities. Activiti Explorer helped address human based workflow task so that we do not have to create any UI for task management. Activiti REST enabled us to integrate with other applications.

Business benefits delivered:

  • Helped our client to understand and decide what was done, what’s needed, what to throw away, and what was missing via requirements documents created from reversed engineering activity.
  • Acquired the ability to use the new system within 2 months and completely scrap the old system, which was error prone. Mitigated the risk of a lack of internal knowledge to troubleshoot if something goes wrong.
  • Incorporated new business workflows based on INFRA standards to follow compliance.
  • Ability to monitor different human tasks in different workflows using Activiti Explorer provided great insights on what’s going on with various publishing documents.
  • Capability to generate reports on current and historical reports was helpful to adhere to INFRA standards.
Global Client Centralizes Payment Service
One of our clients accumulated multiple payment gateways over a period of couple of decades and faced impediments to integrate with a unified payment system. Treselle was challenged to build a centralized payment service that talks to a single payment gateway system and integrate all our client’s legacy and new systems with new payment service. The project also required using different single use credit card system for virtual card processing with the client’s business partners. The system to be developed was architected to possess QoS capabilities such as high performance, no shared architecture, high availability with failover capabilities, and a powerful admin system to manage all the transactions. We also had to integrate with many older platforms ranging from a green terminal in C, PHP, and Java, and back office systems. After the new project’s launch, we also properly retired the old payment gateway system.

Business benefits delivered:

  • Saved quarter million dollars in annual license and transaction fees by consolidating multiple payment gateways into one.
  • We offered the ability to operate in many more countries with different currencies. This allowed the client to go global.
  • Saved thousands of dollars from human errors, duplicate transactions, and missing transactions by automating the back-office accounting system integration with unified payment system.
  • Enabled a high availability and scalable platform with 99% up time. This allowed our client to successfully operate round the clock without missing on any transactions.
  • Socket level encryption and tamper proof cryptography enabled the client to achieve PCI compliance.
  • Increased the productivity of the accounts and finance department to easily track the transactions occurring in the system on the fly with the admin system by removing paper-based follow-ups. This also reduced the human operating cost.
Large Tourism Operator goes from 4000 to 22,000 Hotel Connections
Our client was operating in offline mode with 4000 hotels worldwide and exchanging crucial information such as availability, promotions, events, and cost of the rooms and conferences everyday via faxes, spreadsheets, and phone calls. They then updated their backend system with these details constantly. This entire process was slow, error prone, and not real time. Our client incurred significant revenue loss by their inability to connect to more hotels due to a high manpower overhead. Treselle’s team of engineers designed, architected, and implemented the integration of client systems with different hotel partners API. This increased the hotel connections from 4000 to 22,000.

Business benefits delivered:

  • Ability to quickly find the availability, and cost of different types of rooms at 22,000 hotels in real time.
  • Increased the revenue by offering these hotel connections to tour agencies world wide.
  • Reduced the human and operational cost in exchanging the hotel availability and cost via fax, spreadsheet, phone, and other offline mode.
  • Ability to integrate with different hotel partner APIs that are exposed with multiple API protocols, and response formats into unified API and avoided point to point integration for expanding future hotel connections.
  • Ability to integrate with different internal data sources: Availability/cost store, accounting system, payment system, and others to improve the operational efficiency.

LATEST THINKING

  • Dynamic Jasper Reports Automated in Talend
    26
    Apr, 2017

    Dynamic Jasper is a great tool for designing and creating simple or complex dynamic reports. Talend is not only used as the most common tool for data transformation. It is also used for dynamic Jasper report generation using tJasperInput component. Automation with context parameters is the most important value add to it. It helps to resolve many challenges involved in dynamic report creation such as on the fly changes like column name, report header, date, and so on. It helped developers in saving the report generation time. read more

  • Dynamic Jasper Reports Automated in Talend
    26
    Apr, 2017

    Dynamic Jasper is a great tool for designing and creating simple or complex dynamic reports. Talend is not only used as the most common tool for data transformation. It is also used for dynamic Jasper report generation using tJasperInput component. Automation with context parameters is the most important value add to it. It helps to resolve many challenges involved in dynamic report creation such as on the fly changes like column name, report header, date, and so on. It helped developers in saving the report generation time. read more

  • Microservices – Rules of Engagement
    14
    Apr, 2017

    Rules of Engagement is a set of principles and best practices that are valuable to follow to ensure an efficient microservices environment. Treselle Systems captured these rules while going thru the book "Microservices From Day One" by Cloves Carneiro Jr & Tim Schmelmer. Guiding principles like these help the development team spend less time thinking about high-level architecture, and more time writing business-related code and providing value to stakeholders. Check out how one of our microservice architecture implementation is inline with these Rules of Engagement read more