CASE STUDIES

Learn how Trianz has enabled smarter businesses with advanced cloud, analytics, digital, infrastructure, security solutions.

Digital Apps

STREAMLINING IT OPERATIONS FOR A REAL ESTATE INVESTMENT COMPANY

Real Estate Firm Seeks IT Infrastructure Modernization Trianz was approached by a US-based tier 1 real estate debt and equity investment client that needed assistance with its digital transformation initiative. The company had a dependence on physical documentation and manual workflows, which was leading to duplicated efforts for employees and data inconsistencies during data entry. Business Challenges for the Real Estate Client with Manual Processes and Paper Documents The firm was struggling to communicate with external clients due to its aging email system not being fit for its purpose. Employees similarly could not collaborate on client work, as emails went to individual inboxes rather than shared inboxes accessible by the entire department. Paper documentation was leading to knowledge access problems, and the client lacked a content management system (CMS) to host any converted documents. Inconsistent datasets meant that business intelligence workflows were outputting inaccurate insights. This reduced visibility into the deal lifecycle for the client and led to misinformed investment decisions based on poor insight. Technology Components Suggested by Trianz for the Real Estate Firm After consultation, Trianz identified the following technology components for the client: ASP.NET was chosen as an open-source framework for creating web applications and services using .NET and C# programming languages. SharePoint was chosen as an internal CMS to host files, documents, and facilitate collaboration between team members using intranet services. Custom Controls were also established and implemented due to the sensitive nature of real estate communications and sales processes. How Did Trianz Streamline IT Operations for the Real Estate Client? Trianz started by implementing a centralized business process management system. This new system captured pertinent data across deal submissions, deal funding, and other sales workflows to streamline the deal lifecycle. Next, digitalized workflows were introduced as a framework for administration teams. This assisted with real estate loan management workflows from inception through to completion. SharePoint hosted a new documentation repository. This involved the conversion of paper documents to digital formats. Then, employees could use search functions to find policy documents and similar, with extended sharing capabilities to communicate digital documents with external parties. Digitalized calculators were introduced using ASP.NET, helping the client to accurately estimate costs and revenues when working with external parties. This assisted with deal lifecycle management and improved accuracy when calculating yields. Employees could also access this calculator easily thanks to a web application architecture that is compatible with all devices. Finally, an online self-service portal was created to assist borrowers. The client’s customers could now access historical and current financial statements. Similarly, stakeholders had a centralized view of all statements, improving risk management and chase-up procedures. Transformational Effects for the Real Estate Client After Digital Transformation After Trianz completed the project, manual processes were eliminated, improving accuracy during data entry and overall process efficiency. Stakeholders and employees had greater visibility into the status of each transaction throughout the deal lifecycle. This allowed for proactive measures such as follow-ups, chasing payments, and nurturing prospective customers to drive up sales numbers. Similarly, the capacity to handle deals increased for the client. It could handle more transactions at once without additional human resources, and new deals could be acquired and processed more quickly in the new system. Stakeholders had a new centralized and unified view of all real estate operations, leading to more predictive action and risk mitigation thanks to greater insight and awareness. This also improved the quality of decisions relating to investments. Finally, new collaboration features enabled the client to share documents and communicate with external parties in a digital-first manner. This streamlined communications and improved response rates, expediting deal closures. Experience the Trianz Difference Trianz enables digital transformations through effective strategies and excellence in execution. Collaborating with business and technology leaders, we help formulate and execute operational strategies to achieve intended business outcomes by bringing the best of consulting, technology expertise, and execution models. Powered by knowledge, research, and experience, we enable clients to transform their business ecosystems and achieve superior performance by leveraging infrastructure, cloud, analytics, digital, and security paradigms. Reach out to get in touch or learn more.

Explore
Cloud

BUILDING A GLOBAL DATA PLATFORM ON THE AWS CLOUD FOR A HEALTHCARE CLIENT

Healthcare Provider Seeks Advanced Cloud Analytics Capabilities Trianz was approached by a leading global healthcare provider that wanted to leverage cloud infrastructure to build a new secure, scalable, and industry-compliant cloud IT platform. Its internal teams would use this platform for large-scale and complex analytics in the US and EU geographic areas. Business Challenges for the Healthcare Provider The healthcare client lacked any form of data analytics solution and was in need of modern and highly compliant analytics capabilities to generate healthcare insights. This new analytics solution needed to be flexible, scalable, secure, and aligned with strict guidelines and regulations like HIPAA and GDPR. Technology Components Introduced to the Client by Trianz Trianz identified a range of relevant technology components that would help the healthcare provider achieve its goals: Amazon Elastic Map Reduce was used to rapidly apply processing and analytics to big data sources. Amazon Elastic Container Service was chosen to host containerized processes and applications with autoscaling during peak and low demand. Amazon Elastic Kubernetes Service was used to deploy managed Kubernetes clusters across numerous AWS availability zones. AWS Glue was selected as a serverless extract-transform-load solution for data crawling, data catalogs, and data transformation workflows. AWS Virtual Private Cloud was chosen instead of the public cloud due to the sensitive nature of healthcare-related to personally identifiable information (PII). SageMaker is a fully managed service to build, train, and deploy machine learning algorithms. AWS Lambda was introduced to enable serverless, event-driven compute workloads. Amazon CloudWatch centralizes data on AWS resources, applications, and services to streamline application and infrastructure monitoring. Amazon Simple Notification Service is a fully managed capacity planning, provisioning, monitoring, and patching solution. Amazon Elastic Compute 2 (EC2) is a compute node service with autoscaling support. Amazon Relational Database Service was used to configure and orchestrate the client’s RDMBS solution on AWS. The AWS Key Management Service was added to provide robust FIPS 140-2 compliant, hardware-based security standards in the cloud. AWS Simple Storage Service was chosen as an economical, scalable, and configurable data storage platform. Elastic Search was introduced as a web crawling solution with RESTful support and a built-in analytics engine. Amazon Cognito provides solutions to control access to AWS resources from the client software applications, including role definitions and user mapping. AWS DynamoDB is a NoSQL fully managed and serverless database service based on key values, that can support high-performance applications at scale. Trianz also helped the healthcare client to adopt HashiCorp Terraform, GitHub, Jenkins, Newrelic, Ansible, and Chef as part of the project. The Trianz Approach to Implementing a New Cloud Infrastructure Solution The first focus was automation, where continuous integration and deployment (CI/CD) pipelines were used to deploy AWS components using Infrastructure-as-Code (IaC). This included GitHub for code versioning and source control, and Hashicorp Terraform as an open source IaC tool. Next, automation rules were established for system software configuration and patch management using Chef and Ansible. This adhered to the healthcare client’s internal compliance and security controls, a critical milestone for the project. Transformational Effects After Building a New AWS Infrastructure Environment The healthcare client can now manage its entire cloud infrastructure system using automated IaC tools. This includes deployment to various platform environments and different geographic availability zones on AWS. The viability of the infrastructure design was proven to attract additional stakeholder interest, with the EU area being the first successful integration attempt. IT maintenance activities, including monitoring and stabilization, were streamlined and automated to reduce manual workloads for the IT team. The US region is under construction and awaiting testing approval from a selection of teams trialing the architecture. Operational automation had an immensely beneficial impact, with downtime metrics reducing by over 80%. This is thanks to the blue/green method used during application rollout on AWS. Similarly, application spool times were significantly reduced in K8S clusters, improving latency and performance on the network. By using managed services, security offloaded from the client to AWS. This security-as-standard helped the healthcare client to pass all internal and external auditing procedures after adoption and was critical in protecting sensitive PII. The availability of IT services increased measurably, with fewer false alarms, reduced event noise, and automation playbooks to remediate common system anomalies. Experience the Trianz Difference Trianz enables digital transformations through effective strategies and excellence in execution. Collaborating with business and technology leaders, we help formulate and execute operational strategies to achieve intended business outcomes by bringing the best of consulting, technology expertise, and execution models. Powered by knowledge, research, and experience, we enable clients to transform their business ecosystems and achieve superior performance by leveraging infrastructure, cloud, analytics, digital, and security paradigms. Reach out to get in touch or learn more.

Explore
Infrastructure

BUILDING A CENTRALIZED ENDPOINT MANAGEMENT SOLUTION FOR A MANAGED SERVICES PROVIDER

Managing All Servers, Desktops, and Laptops Within a Single Console Trianz was approached by a managed services provider (MSP) that wanted to build an endpoint management system. As part of the FinTech 100, this client represents the best in financial technology implementation and managed service provision. Business Challenges for the FinTech Managed Services Provider With hundreds of clients and dozens of servers to manage with each client, the managed services provider needed a way to automate server patching and security management workflows. Disparate tools were in use, creating inconsistencies between different managed service plans delivered to each client. This complicated reporting and implementation procedures and did not support automation resulting in manual patch updates. How Trianz Built a New Centralized Endpoint Management Solution Trianz worked with the managed services provider by conducting workshops to educate personnel on new automation tools. Then, a plan was created to deploy automations in a phased manner according to the managed service provider’s customer requirements. IBM BigFix Patching was implemented to convert manual patch processes into tried-and-tested automation playbooks. Realize Orchestration is a modern workflow automation platform that was combined with BigFix to create new virtual machines on-demand with up-to-date software and security patches. A new process for detecting the host operating system vendor was designed and implemented, helping the managed service provider to deploy the right updates to the right environment. By automating the orchestration of new virtual machines, the managed service provider could deliver the latest software patches at a much faster rate than previously seen with its manual build processes. A new software distribution automation solution was created containing fixlets, or software management scripts. This allowed automated fixlets to conduct installations, updates, and uninstallations without human intervention. Transformational Effects for the Managed Services Provider with a New Automated Patching Solution The managed services provider now has a centralized and automated solution that can patch all servers, including operating systems and installed applications. It is now possible to orchestrate updates and view servers through a unified management console, greatly simplifying client endpoint management for the MSP. This led to efficiency improvements in patch deployment, software deployment, and server automation, promoting higher standards of managed service provision to its customers. Newly built servers were also covered with an automated approach for server updates, including Sophos virus definition updates, pattern updates to heuristically detect malware, and agent updates. Experience the Trianz Difference Trianz enables digital transformations through effective strategies and excellence in execution. Collaborating with business and technology leaders, we help formulate and execute operational strategies to achieve intended business outcomes by bringing the best of consulting, technology expertise, and execution models. Powered by knowledge, research, and experience, we enable clients to transform their business ecosystems and achieve superior performance by leveraging infrastructure, cloud, analytics, digital, and security paradigms. Reach out to get in touch or learn more.

Explore
Cloud

IMPLEMENTING DIRECT RESOLUTION VIA REAL-TIME VIRTUAL ASSISTANCE FOR PHARMA CLIENT

Pharmaceuticals Provider Seeks Cloud Service Platform to Access Knowledge in Real-Time An international pharmaceuticals provider was seeking to adopt a new real-time virtual assistance platform to assist with ticket resolution. The provider offers research and development, production, marketing, and sale of drugs for patients with central nervous system (CNS) disorders. Business Challenges for the Pharma Provider in Ticket Management New employees were encountering problems with accessing company resources. Similarly, when requesting help accessing these resources, response times were too high. Internationally, the client’s helpdesk ticketing system had a lot of overhead and experienced latency and performance problems when routing tickets. Technology Components Selected for the Virtual Assistant Project Trianz decided upon the following technology components to enable the pharma client’s new virtual assistant: Microsoft Azure was chosen as a cloud service platform. It had supplementary services available which would integrate seamlessly with monitoring, orchestration, and deployment functions. The Azure Bot Service was chosen as a managed service for serverless bot deployment using AI and conversational natural language processing (NLP). Q&A Maker was used to create question-and-answer relations, enabling conversational dialogue for FAQs within the virtual assistant bot for the pharma client. Language Understanding Intelligent Service (LUIS) was chosen as part of the Microsoft Cognitive Services on Azure to process utterances, interpret user intent, distill user sentences into entities, and intuitively respond with relevant information or actions. How Did Trianz Approach the Virtual Assistant Project for the Pharma Client? Trianz started by developing a virtual assistant bot on the Microsoft Azure cloud. The Azure Bot Service hosted the virtual assistant, with Q&A Maker allowing the client to create an initial FAQ framework, and continuously update this framework into the future. LUIS would see continuous updates and improvements, ensuring the client had access to the latest and greatest NLP technologies for better virtual assistant experiences. This virtual assistant bot could be accessed across all platforms with a HTML5 web browser, including desktop, mobile, smart TVs, and even potential expansion to voice assistants like Microsoft Cortana. Employees in the field could use the bot to request information, regardless of their location or device. Transformational Effects for the Pharma Client After Adopting the Virtual Assistant The pharma client’s employees could now access knowledge in real-time, 24 hours a day using conversational language. The assistant formed a foundational platform for employees to reach automated resources and the latest corporate information, offloading ticket workloads from overloaded helpdesk employees. Automated responses significantly reduced the number of inbound tickets on the helpdesk, assisting with ticket number reductions. Remote employees were more engaged and connected with headquarters thanks to on-demand 24/7 access to corporate knowledge. Experience the Trianz Difference Trianz enables digital transformations through effective strategies and excellence in execution. Collaborating with business and technology leaders, we help formulate and execute operational strategies to achieve intended business outcomes by bringing the best of consulting, technology expertise, and execution models. Powered by knowledge, research, and experience, we enable clients to transform their business ecosystems and achieve superior performance by leveraging infrastructure, cloud, analytics, digital, and security paradigms. Reach out to get in touch or learn more.

Explore
Infrastructure

PREDICTIVE ANALYTICS TO ASSIST WITH IT OPERATIONS MANAGEMENT FOR A DATA CENTER PROVIDER

Global Data Center Provider Seeks to Forecast Incidents and Generate Trend Reports Trianz was approached by one of the world’s largest data center and co-location service providers. The company provides fast compute services for application performance, low latency network routes worldwide, and a digital ecosystem of financial, content, media, and enterprise cloud networking services. Business Challenges for the Global Data Center Provider The client lacked visibility into problematic infrastructure components as part of its IT operations management strategy. This meant it could not gain any insight necessary to guide infrastructure capacity expansion plans with its current monitoring solution. In action, this led to a high number of IT incidents which negatively impacted business service availability. It also could not proactively forecast incidents and event trends, leading to a reactive remediation approach that lowered overall service quality. Technology Components Installed During the Project by Trianz for the Client Trianz implemented the following technology components for the client project: R System and Kaggle were used to enable QA testing, advanced analytics, machine learning, and data science workflows. This was needed to build statistical models for the client. PowerBI was used as a data visualization layer for interactive dashboards and reports relating to IT operations management metrics and KPIs. IT Operations data was merged, centralizing data from numerous monitoring tools in a single unified location for ease of reporting. How Did Trianz Approach the Predictive Analytics Project? Trianz conducted workshops with business and IT stakeholders to understand critical inter-departmental challenges relating to IT operations management and infrastructure visibility. Sample data was then collated from numerous monitoring tools to provide insight on how to configure the new predictive analytics solution. Data preparation took place alongside data cleansing within a Proof-of-Concept environment, showing the value of the new predictive analytics solution ready for stakeholder approval. Then, three statistical models were created—ARIMA, Negative Binomial and Zero Inflation — to assist the client when predicting IT operations management incidents. Next, data correlations were formed based on the Pearson Correlation Coefficient to derive linear relations between each cloud IT system. Kaggle was then integrated with Microsoft PowerBI to enable interactive and visual dashboards that could be accessed on desktop and mobile. Finally, the completed solution was presented to key stakeholders across the business. Transformational Effects for the Global Data Center Provider Following this initiative, the global data center provider could forecast incidents and generate trend reports relating to IT operations management processes on its global server network. It could also proactively forecast disk usage, network utilization, and memory usage when planning capacity expansions on its network. Network events and IT incidents were continuously analyzed to generate patterns and trends, providing visibility and insight for future IT network improvements and mitigation efforts. Finally, incident and event correlation offered unprecedented insight into the relationships between servers, networking equipment, software, and other areas. Experience the Trianz Difference Trianz enables digital transformations through effective strategies and excellence in execution. Collaborating with business and technology leaders, we help formulate and execute operational strategies to achieve intended business outcomes by bringing the best of consulting, technology expertise, and execution models. Powered by knowledge, research, and experience, we enable clients to transform their business ecosystems and achieve superior performance by leveraging infrastructure, cloud, analytics, digital, and security paradigms. Reach out to get in touch or learn more.

Explore
Cloud

MIGRATING PAYMENT GATEWAY APPLICATION TO CLOUD AND MULTI-YEAR MANAGED SERVICES

Hosting, Monitoring and Support of a Large Payment Gateway Trianz was approached by a global FinTech provider that manages millions of credit and debit card transactions each year. It needed a partner to host, monitor, and continuously improve its payment gateway application, which was critical to its overall market penetration strategy. Business Challenges for the Global FinTech Provider The FinTech provider needed a partner to support, enhance, and deploy market-specific software programs as part of its payment and transaction service portfolio. These programs are critical to business operations, and the client desired managed services to minimize negative business impacts and drive business success without increasing its internal IT workloads. Technology Components Implemented During the Payment Gateway Project Trianz worked with the global FinTech provider to implement the following technology components: Microsoft Azure was chosen as a cloud service platform with autoscaling, pay as you go billing, and broad integration support. EDB Postgres extends the capabilities of PostgreSQL databases with increased security and Kubernetes container support. The client’s proprietary payment gateway solution was migrated to and hosted on Microsoft Azure. Splunk was selected as a data platform that can identify patterns, provide metrics, and diagnose problems with data sources using machine learning. Dynatrace was chosen to facilitate application and infrastructure security monitoring with automation support and AI functionality in the cloud. Vormetric was used to encrypt any at-rest data contained within EDB Postgres for the FinTech client, using centralized access policies and an encryption key management repository. Thales HSMs provided hardware-based security devices that are compatible with Microsoft Azure cloud services, known as hardware security modules (HSMs). RSA SecureID was chosen as a two-factor authentication layer for internal staff when accessing sensitive applications and data in Azure. Citrix Application Delivery Controller (formerly Netscaler) was used to load balance applications hosted in containers across Azure, promoting security and visibility. How Trianz Transformed the FinTech Client’s Payment Gateway on Azure Trianz devised a plan for managed services around the payment gateway. This would include hosting, infrastructure and application monitoring, and continuous enhancements to the platform over time as requested by the client. Next, the infrastructure architecture was designed on Azure, alongside a migration strategy and rapid stabilization strategy. Stakeholders were communicated with during this phase to understand inter-departmental business requirements. A Business-as-a-Service managed services framework was adopted, encapsulating the core capabilities required for the FinTech client’s payment gateway to operate efficiently. This included transitionary processes, management over time, and scheduled enhancements to the payment gateway solution. The entire payment gateway was then migrated to Azure alongside security, data, and access control configuration. The Azure architecture was designed around the client’s strict security and compliance requirements. Finally, service level agreements and support processes were agreed upon, based on cloud service utilization and different Infrastructure-as-a-Service and Platform-as-a-Service modules. Transformational Effects After Migrating the Payment Gateway to Azure for the FinTech Client At the end of the project, the client’s payment gateway had been successfully migrated to Microsoft Azure. First, end-to-end support for Level 1 and 2 support workloads was in place as part of the managed service. This included general IT support and the design of incident resolution workflows by Trianz’ managed services team. A broad range of production support activities were undertaken by the Trianz managed services team across application stacks to improve IT network security and compliance The client could now automate processes and workflows using automation playbooks, streamlining productivity and efficiency. Network optimization was continuous to ensure the payment gateway adhered to strict governance and security rules. Trianz assisted with agile product development, and took the initiative to continuously improve IT services for the client as part of the managed service plan. Experience the Trianz Difference Trianz enables digital transformations through effective strategies and excellence in execution. Collaborating with business and technology leaders, we help formulate and execute operational strategies to achieve intended business outcomes by bringing the best of consulting, technology expertise, and execution models. Powered by knowledge, research, and experience, we enable clients to transform their business ecosystems and achieve superior performance by leveraging infrastructure, cloud, analytics, digital, and security paradigms. Reach out to get in touch or learn more.

Explore
Analytics

IMPLEMENTING SALESFORCE CRM FOR AN EMERGING PHARMACEUTICAL COMPANY

Enabling Healthcare Analytics in the Cloud Trianz was approached by an emerging pharmaceutical company that was looking to adopt Salesforce CRM. It wanted to improve field activity and prescribing activity monitoring capabilities, alongside more visibility into formulary and claim trends. Business Challenges for the Pharmaceutical Company The pharmaceutical company had no way to monitor field or prescribing activities with its partnered pharmacies. Similarly, it had no way to proactively strategize due to a lack of formulary and claim trend data. Technology Components Supplied to the Pharmaceutical Company by Trianz The pharmaceutical company was supplied with the following technology components: Microsoft PowerBI enabled visual dashboards and reports that were easier to interpret for employees in the field. Microsoft Azure was chosen as the cloud service platform, with Infrastructure-as-a-Service offerings relating to virtual machines, networking, blob storage, and disaster recovery. Microsoft SQL Server was chosen as a relational database management system. The Trianz Approach to PowerBI Configuration and Azure Architecting Trianz developed a data warehouse using the Microsoft SQL Server component. PowerBI was highly compatible with SQL Server, reducing the likelihood of future incompatibility for long-term viability. Various data sources were centralized in the data warehouse, acting as a master data repository to reconcile operational reference data. PowerBI could then access the database to deliver reports and dashboards to stakeholders and pharmaceutical employees. Transformational Effects with a New MS SQL Database and PowerBI on Azure After architecting the new cloud environment, the pharmaceutical company’s leadership team gained insight into company performance, competitor trends, and the flow of products through the delivery pipeline. This allowed for proactive strategies to smoothen supply chains, outmaneuver competitors, and manage company performance. The field sales team could now access mobile-enabled dashboards access mobile-enabled dashboards thanks to PowerBI. This enhanced capabilities in the field, improving service quality when interacting with clinicians and revealing prescribing behavior trends. Finally, sales employees were empowered to monitor their own call activity KPIs, improving motivation and productivity. Experience the Trianz Difference Trianz enables digital transformations through effective strategies and excellence in execution. Collaborating with business and technology leaders, we help formulate and execute operational strategies to achieve intended business outcomes by bringing the best of consulting, technology expertise, and execution models. Powered by knowledge, research, and experience, we enable clients to transform their business ecosystems and achieve superior performance by leveraging infrastructure, cloud, analytics, digital, and security paradigms. Reach out to get in touch or learn more.

Explore
Infrastructure

TRANSFORMING AUDITING PROCESSES WITH SERVICENOW GRC

Client Seeks to Promote Auditing Transparency, Accuracy, and Accountability Trianz was approached by a client that was looking to streamline its auditing processes. It had already identified ServiceNow GRC as a suitable candidate and needed assistance in implementing, configuring and launching the solution on its IT network. Business Challenges for the Client in Auditing, Governance, and Regulatory Management The client wanted to empower its internal auditing teams by developing a single, centralized governance risk compliance (GRC) platform. This platform, hosted on ServiceNow, would help the audit team to plan and execute engagements, collaborate with other departments, view audit report findings and monitor enterprise-wide compliance against requirements outlined in HIPAA and PCI-DSS 3.0. Before, the existing GRC system lacked transparency and accountability. There was also a lack of time tracking functionality, reporting capabilities, and historical data access. Finally, the client wanted its manual dependencies replaced as they were increasing the duration of audit executions. Technology Components Implemented by Trianz for the GRC Project Trianz implemented the client’s requested technology components: ServiceNow was introduced as a foundation, offering future expandability with its workflow optimization and orchestration features. ServiceNow Governance Risk Compliance (GRC) was the focus, improving business resilience with real-time GRC visibility, greater productivity with auditing procedures, and tools to streamline stakeholder risk communications. How Did Trianz Install ServiceNow GRC for the Client? First, a specialist team at Trianz conducted interviews with key stakeholders across the business. The focus was on process owners so that Trianz could understand current GRC processes, controls, sources, and exemptions. From here, the team identified internal and external Active Directory policies, controls, and exemptions to determine the current state of governance, risk, and compliance on the IT network. Next, profiles were created for specific scenarios helping to establish risk and compliance indicators and govern role-based access controls. Finally, auditing processes were assessed and mapped, allowing audit findings to be closed automatically using automation playbooks. Transformational Effects After Adopting ServiceNow GRC for the Client After adopting ServiceNow GRC, the entire GRC process was automated, offloading manual processes from the auditing team to drive productivity. Audit engagements and executions could be performed within a centralized system rather than department-specific repositories, improving risk and compliance awareness. The internal auditing team reduced the time spent on managing audits by 50%. GRC workflows benefitted from greater transparency and accuracy, with analytics and reporting functions enabling accountability monitoring relating to process compliance. The client could now access real-time dashboards for various processes and compliance workflows. Process compliance was automated with findings being supplied within familiar employee workflows, reducing manual processing requirements. Improvements to processes and tighter GRC worked together to eliminate a number of redundancies and exemptions, streamlining auditing procedures. Experience the Trianz Difference Trianz enables digital transformations through effective strategies and excellence in execution. Collaborating with business and technology leaders, we help formulate and execute operational strategies to achieve intended business outcomes by bringing the best of consulting, technology expertise, and execution models. Powered by knowledge, research, and experience, we enable clients to transform their business ecosystems and achieve superior performance by leveraging infrastructure, cloud, analytics, digital, and security paradigms. Reach out to get in touch or learn more.

Explore
Analytics

BUILDING A CUSTOMER SURVEY ANALYTICS DASHBOARD FOR COMCAST

Comcast Seeks Centralized Reporting System Trianz was approached by the global telecommunications giant Comcast, provider of television broadcasts, home broadband, and telephony services. Comcast was looking to build a customer survey analytics dashboard to nurture passive customers and monitor net promoter scores (NPS). Business Challenges for Comcast with Passive Customers and NPS Comcast needed help with the maintenance of extract-transform-load pipelines business intelligence within its call centers, customer experience analytics, and customer survey monitoring. This would come together in a centralized reporting system to show NPS promoter, detractor, and passive customer metrics. NPS values would also be linked back to various business operations, providing insight to guide future business strategies. Who Worked on the Project and What Were the Timescales? A specialist team from Trianz adopted the Agile methodology throughout this project. Comcast had a range of priorities across different business arms which the Trianz team had to balance. This included integrating the centralized reporting system with departmental IT systems in a staggered approach. The Agile Development Approach Used by Trianz During This Project Trianz worked with Comcast across the full development lifecycle for each dashboard. These dashboards are related to different business arms, such as the call center, and differing service offerings across broadcasting, broadband, and telephony. The Trianz team integrated numerous third-party survey responses into the centralized reporting system. This enabled a centralized view of organization-wide NPS metrics and other key performance indicators (KPIs). Transformational Effects for Comcast with its New Centralized Reporting System After project completion, Comcast had new capabilities with its centralized reporting system. Customer experience management was streamlined by greater visibility into KPIs and other metrics. Some metrics include relational net promoter scores, reliability, unique contact rates, and first call-in rates. An enterprise-wide performance dashboard was also enabled, offering a centralized view of major metrics to all business stakeholders with future trend projections. Trianz also configured eight box reports that run weekly and monthly. These unique dashboards showcase trends over a weekly and monthly basis to promote key stakeholder awareness and visibility into business performance. Experience the Trianz Difference Trianz enables digital transformations through effective strategies and excellence in execution. Collaborating with business and technology leaders, we help formulate and execute operational strategies to achieve intended business outcomes by bringing the best of consulting, technology expertise, and execution models. Powered by knowledge, research, and experience, we enable clients to transform their business ecosystems and achieve superior performance by leveraging infrastructure, cloud, analytics, digital, and security paradigms. Reach out to get in touch or learn more.

Explore
Analytics

ASSESSMENT AND CREATION OF A ROADMAP FOR MASTER DATA GOVERNANCE

Chemical Manufacturing Company Seeks MDM Framework Trianz was recently approached by a leading provider of emulsion polymers, specialty chemicals, and functional decorative surfaces. The client needed a partner to conduct a master data governance (MDM) assessment and devise a roadmap for MDM in its SAP enterprise resource planning platform. Business Challenges for the Client with SAP The client had implemented SAP around twelve years prior to engaging with Trianz. This system supported all aspects of the enterprise resource planning (ERP) process, alongside an acquired business arm from six years prior. After the acquisition, the acquired businesses’ SAP instance was not harmonized with the main SAP implementation, creating redundancies and siloed datasets that prevented holistic reporting. How Trianz Executed the SAP Integration Project for the Client Trianz started by interviewing eighteen different stakeholders across the business to identify departmental requirements, and perform root cause analysis. Both data systems were then assessed to understand data availability and determine constraints. This gave insight into how Trianz could merge the systems. Next, business use cases with specific business values were modeled to guide the harmonization process. A future-state analytical architecture was designed alongside the merging of both SAP instances, enabling new analytics and business intelligence functions across the client’s operations. A high-level roadmap encompassing all project areas was developed to provide estimates to key business stakeholders. Finally, a detailed initial project plan was developed and shared to assist with staff capacity planning, timeline estimates, and cost projections. Transformational Effects After Receiving the Roadmap The client now had a clear roadmap to implement its Master Data Governance framework, alongside a roadmap to implement new analytics infrastructure and services. Estimates contained within both roadmaps could feed into the client’s planning and budgeting exercises, managing capital expense and monetary risk. Clear business values were established across both roadmaps in specific areas, giving the green light to stakeholders with a proof of value statement. A clear methodology towards harmonizing both SAP instances was provided, offering guidance on resources, budgets, and roadmap constraints. Experience the Trianz Difference Trianz enables digital transformations through effective strategies and excellence in execution. Collaborating with business and technology leaders, we help formulate and execute operational strategies to achieve intended business outcomes by bringing the best of consulting, technology expertise, and execution models. Powered by knowledge, research, and experience, we enable clients to transform their business ecosystems and achieve superior performance by leveraging infrastructure, cloud, analytics, digital, and security paradigms. Reach out to get in touch or learn more.

Explore
Digital Apps

PART NUMBER AUDITING SYSTEM FOR DATA STORAGE COMPANY

Proactive Part Number Monitoring A leading data storage company in the US approached Trianz for help with a part number auditing system. The client wanted to automate this part number auditing process with robotic process automation (RPA) technology to reduce manual workloads and the prevalence of human error. Business Challenges for the Data Storage Company with Part Number Auditing The client’s part number creation process spanned across numerous disparate systems with different stakeholder owners for each. Products were also being made available before part numbers had been uploaded to the auditing system, namely due to cumbersome manual processes rather than automated auditing. Technology Components Suggested by Trianz for the Data Storage Company Trianz decided on the following technology components for the data storage company: UIPath was selected as a robotic process automation (RPA) vendor, as it streamlines processes, uncovers efficiencies, and provides insights to help with automating workflows. A number of existing software application were automated using UIPath, including Lotus Notes for email and an Agile to SAP migration. How Trianz Approached the Part Number Auditing Project for the Data Storage Company A specialist team from Trianz identified the manual steps involved in the data storage company’s end-to-end part number auditing process. During this phase, Trianz highlighted the business benefits and estimated returns on investment (ROI) with the RPA solution to business stakeholders. Next, an outreach program took place to communicate the benefits of RPA to all departments and educate employees. Finally, a pilot scheme to test automation playbooks was created within ten days. This offered a proof of concept for stakeholders reflecting the value of the technology and approach. Transformational Effects for the Data Storage Company After adopting the new RPA solution, the data storage company experienced reduced cycle times by over 80% in their part number auditing system. This was driven by improvements to accuracy through the omission of manual human input to the system. The solution resulted in fewer missed or late part orders, as a reactive audit process was now possible using RPA. Experience the Trianz Difference Trianz enables digital transformations through effective strategies and excellence in execution. Collaborating with business and technology leaders, we help formulate and execute operational strategies to achieve intended business outcomes by bringing the best of consulting, technology expertise, and execution models. Powered by knowledge, research, and experience, we enable clients to transform their business ecosystems and achieve superior performance by leveraging infrastructure, cloud, analytics, digital, and security paradigms. Reach out to get in touch or learn more.

Explore
Analytics

IMPLEMENTING BUSINESS INTELLIGENCE AND DATA MONETIZATION FRAMEWORKS

Global Payment Provider Seeks Customer Dashboard Experience Trianz was approached by a global payments provider that needed assistance with digitalizing data access for its customers. This would involve the creation of a business intelligence and data monetization framework, giving the client’s customers a 360-degree customer view. Business Challenges for the Global Payments Provider in Merchant Management A data monetization solution was needed targeting sales and marketing divisions in partnered retail merchants across the globe. This would provide insight on shopping trends and customer behaviors using transactional data, something which was not possible with their current system. The solution was cutting edge, and the client had aggressive timescales for project completion. The project needed to be managed in tandem with supporting the flexibility of the customer experience, platform capabilities, and technologies. Technology Components Sourced by Trianz for the Global Payments Provider Trianz sourced the following technology components to help the global payments provider achieve its project goals: Hadoop was chosen as a software library framework for distributed big dataset processing using compute resources in the cloud. The Hadoop Distributed File System (HFDS) was chosen as it can run on commodity hardware and uses the Hadoop software library to facilitate processing. Apache HBase is a Hadoop database that operates in distributed, scalable big data environments with leading real-time read/write performance. HIVE is an open-source data warehousing platform built by the creators of Hadoop. FLUME was chosen as a distributed service for collating, aggregating, and translating the location of large amounts of log data. Pentaho was chosen as a data integration and analytics solution, offering access, preparation, and analytics for all data from any source, in any environment. Oracle was chosen as the cloud distribution platform to host these components. How Trianz Approached the Data Monetization and Business Intelligence Project A specialist Trianz team established internal team responsibilities and mapped development processes. From there, the team adopted an agile development methodology due to the distributed nature of employees within. This would help orchestrate software development despite time zone differences. Next, an application framework was developed alongside a future to-be-extended service framework. This would govern how data monetization and business intelligence would operate on the network. This framework was then monitored in close alignment with customer needs, with remediation steps taken to ensure suitability for the client’s partnered merchants. An assessment of application quality and candidacy for live deployment took place, achieving a green light from key stakeholders. This was followed by management buy-in and a release phase where the system was announced across the business and to its global merchant network. Transformational Effects for the Global Payments Provider The global payments provider enhanced its engagement with merchants by offering better quality services for data access and insight generation. Trianz helped to instill new software development best practices in the payment providers internal team, assisting with any future dual-shore development models. Finally, support for multiple business models and geographic locations was enabled for the data monetization and analytics platforms. Configuration frameworks ensured that the right functionality and security rules were in place for the target merchant. Experience the Trianz Difference Trianz enables digital transformations through effective strategies and excellence in execution. Collaborating with business and technology leaders, we help formulate and execute operational strategies to achieve intended business outcomes by bringing the best of consulting, technology expertise, and execution models. Powered by knowledge, research, and experience, we enable clients to transform their business ecosystems and achieve superior performance by leveraging infrastructure, cloud, analytics, digital, and security paradigms. Reach out to get in touch or learn more.

Explore
Infrastructure

IMPLEMENTING AN ENDPOINT INVENTORY TO INCREASE BUSINESS PROFITABILITY

Healthcare Systems Provider Seeks a Modern Endpoint Inventory Solution A leading integrated healthcare delivery systems provider approached Trianz as it was struggling with poor infrastructure discovery processes. It also had imperfect application affinity mapping, causing a lack of awareness and visibility into IT system and software dependencies. Business Challenges for the Healthcare System Provider in Infrastructure and Application Visibility The healthcare delivery systems provider needed a modern endpoint inventory solution to overcome its problems with infrastructure discovery and application affinity mapping. A lack of infrastructure visibility makes it difficult to understand how their servers, networking equipment, and client devices worked together. Similarly, application affinity mapping was needed to organize ideas and insights related to software used by the provider during service provision. The objective was to accurately assess the impact of critical incidents, as these incidents were leading to a loss in transactions and general business engagement numbers. Technology Components Selected by Trianz to Map Dependencies and Assist with Discovery Trianz chose a selection of targeted solutions that would help the client meet its objectives: Tivoli Application Dependency Discovery Manager (TADDM) was chosen for its excellent automated infrastructure and application dependency mapping capabilities. Tivoli Asset Discovery for Distributed [TAD4D] monitors for distributed hardware assets, software assets, and metadata from software applications on the network. BigFix Inventory acted as a centralized repository to store software and metadata asset information, improving network security and preparing the client for future auditing procedures. How Trianz Implemented New Discovery and Dependency Mapping Tools for the Client Trianz started by developing an execution roadmap for the project, outlining processes and prioritizing implementation stages to meet the client objectives and adhere to project timescales. From here, Trianz conducted workshops so business and IT stakeholders could better understand the business challenge, and how the new solution would impact existing processes and workflows. Next, all existing processes, tools, integration points, and data sources were assessed to ensure they were compatible with the new technology solutions introduced through the project. This was also an opportunity to remove dead weight with redundant or inefficient IT solutions. An architectural design for TADDM was created, including five secondary storage servers and 14 discovery servers to uplift network visibility. This would enhance discovery capabilities and provide redundancy if one or multiple discovery servers were to go offline. A new standardized method for processing incidents and service requests was discussed with stakeholders before being implemented across the entire business. This reduced service desk workloads and improved response and remediation times. New monitoring solutions were installed with a focus on reducing event noise and duplicate incidents. The monitoring solution also tracked operational efficiency across software products. Transformational Effects After Implementing Discovery and Dependency Tools The client was able to migrate from TAD4D to BigFix Inventory, enabling bundled rules and software exclusions for more targeted discovery processes. Application performance and health monitoring was initiated through application affinity mapping functions in TADDM, providing valuable insight into IT performance. The accuracy of sub-capacity reporting in BigFix Inventory increased, improving invoicing processes. The new discovery tools collectively identified thirty-three thousand servers and forty-five-thousand network components, with automated weekly refresh cycles to keep the asset list updated. Business processes and workflows were optimized and improved, and customer satisfaction increased measurably for the healthcare systems client. This was possible while still reducing operating costs through a carefully executed metric-based improvement approach. Scan errors were reduced from relatively high numbers, all the way down to an incidence rate of less than 3%. Finally, administration and support processes were streamlined to optimize day-to-day engagements between the client and healthcare service users. Experience the Trianz Difference Trianz enables digital transformations through effective strategies and excellence in execution. Collaborating with business and technology leaders, we help formulate and execute operational strategies to achieve intended business outcomes by bringing the best of consulting, technology expertise, and execution models. Powered by knowledge, research, and experience, we enable clients to transform their business ecosystems and achieve superior performance by leveraging infrastructure, cloud, analytics, digital, and security paradigms. Reach out to get in touch or learn more.

Explore
Analytics

UNCOVERING THE BUSINESS VALUE OF DATA FOR A FORTUNE 500 P&C INSURANCE FIRM

Global P&C Insurer Seeks to Build an Enterprise Data Warehouse A Fortune 500 property and casualty firm approached Trianz to help them establish a more accurate and integrable way to organize, store, and manage its business datasets. As a global firm, its datasets were widely distributed across geographical areas and various business departments. Business Challenges Around Data Silos and Reporting The P&C client had data distributed across multiple geographies, business IT platforms, and departmental data silos. This data needed to be centralized. Reports were manually created, collated, and reconciled, leading to inconsistencies, errors, and little potential for real-time business insight into revenue and profitability. Technology Components Supplied by Trianz to Build the Enterprise Data Warehouse The team at Trianz identified technology components that aligned with project requirements for the P&C insurer: Infosphere CDC was chosen for low-impact capture and delivery of data changes for key information management initiatives. Informatica PowerCenter offered scalable, high-performance data integration functionality to centralize the client’s datasets. IBM PureData System for Analytics (PDA) is a hyperconverged data warehousing solution that accelerates analytics and business intelligence operations with dedicated field-programmable gate array (FPGA) hardware. Qlik was selected to provide visual analytical dashboards and interactive reports. Aginity was chosen as an active analytics catalog to reuse SQL queries in analytics tools. Cognos Framework and Active Reports were used to model metadata in the data warehouse, and to create active and easy-to-use reports. How Trianz Worked to Implement a Data Warehouse for the Fortune 500 P&C Client The client partnered with Trianz to develop an actionable roadmap for a data warehouse in its Personal and Business Insurance (P&BI) division. Existing data sources were assessed, mitigating risk with data from unexpected sources. This also covered existing data sources and mapping business needs to arrive at common definitions across departments. Trianz also created a data tree view for the client’s ease of use. Next, a Proof of Concept was piloted by ingesting data from a small selection of distributed data sources. Then, the enterprise data warehouse and data mart were constructed and integrated with reporting and analytics tools. This data warehouse was further developed at the late stages to integrate the client’s auto insurance arm. Transformational Effects After Enterprise Data Warehouse Implementation Trianz was able to mitigate risk by addressing data quality issues upfront for the client. Manual collation and reconciliation workflows were reduced, lowering the possibility of introducing human error. By establishing common business definitions using Aginity, the client had data and reporting consistency across regions and countries. Business users could now analyze and generate insight on revenues and profitability across all lines of business. This expanded analytics access to all employees, enabling greater awareness and productivity. Finally, a return-on-investment model was created for the data warehouse, giving stakeholders clarity on the long-term value of the new solution. Experience the Trianz Difference Trianz enables digital transformations through effective strategies and excellence in execution. Collaborating with business and technology leaders, we help formulate and execute operational strategies to achieve intended business outcomes by bringing the best of consulting, technology expertise, and execution models. Powered by knowledge, research, and experience, we enable clients to transform their business ecosystems and achieve superior performance by leveraging infrastructure, cloud, analytics, digital, and security paradigms. Reach out to get in touch or learn more.

Explore
Analytics

TERADATA TO SNOWFLAKE MIGRATION

Technology Conglomerate Seeks to Migrate from Teradata A multinational technology conglomerate needed assistance with its database services after encountering high licensing costs and performance problems. The conglomerate manufactures and sells networking hardware, software, and telecommunications equipment alongside other high-tech services and products. Business Challenges Surrounding Teradata and Database Performance The company wanted to migrate away from its legacy solution to a new modern data warehousing platform. This would involve migrating away from an existing Teradata database platform to a cloud-native Snowflake data warehouse. Teradata used a specific SQL syntax within SAP Business Objects, and the company was in the process of migrating to Snowflake. These SQL syntaxes needed to be rewritten and reintegrated to work in the new Snowflake platform. A Proof-of-Concept Design for Teradata-to-Snowflake Conversion Trianz designed a Proof of Concept to automate the conversion of SQL queries. This included five web intelligence reports contained within one centralized business objects universe. Then, a semantic layer conversion tool was used to automate SQL conversion between Teradata and Snowflake. The timeline from project commencement to completion was set at one month. How Trianz Approached Teradata-to-Snowflake Migration A team from Trianz, consisting of two Snowflake data engineers and one Business Objects architect, oversaw this project. They started by analyzing and documenting SAP Business Object requirements, designs, and business processes. This would assist with successful implementation during migration to Snowflake. Next, the Trianz EVOVE platform was used to translate SQL syntaxes into a Snowflake compatible format, before Trianz reintegrated converted syntaxes in a centralized Business Objects Universe. Around 90% of the SQL tables were automatically converted, with the final 10% requiring manual intervention by Trianz. Considering the technology client was manually converting queries, the switch saved them an immense amount of time. To validate the conversion, Webl reports were tested against the new Snowflake environment. This would ensure that reports run successfully, and that data matches in both Teradata and Snowflake. All reports were executed successfully alongside data matching checks. Transformational Effects After Migrating to Snowflake Around 75% of Business Object instances were programmatically converted to Snowflake during this project. Trianz EVOVE was a great help here, automating the conversion of more than 95% of derived tables, with six tables requiring manual conversion. Within the first week of project commencement, 40% of reports had achieved the intended result. Within a month, the entire conversion and migration process was finalized. Typically, such a process would take up to three months to complete manually. Additionally, Trianz identified seven tables outside of the project scope that could be optimized for use in Snowflake. The client could also scale up in future with five or six SAP universes, future-proofing its data operations on Snowflake. Universe Business Objects Count Converted Programmatically 460 Converted Manually 219 No Conversion Needed ~300 Total ~1900 Derived Tables Count Converted Programmatically 100 Converted Manually 6     Total 106 Break-down of Programmatic Errors Resolved after compiler fix Manually fixed items Underlying database items No issue items 245 219 35 30 Experience the Trianz Difference Trianz enables digital transformations through effective strategies and excellence in execution. Collaborating with business and technology leaders, we help formulate and execute operational strategies to achieve intended business outcomes by bringing the best of consulting, technology expertise, and execution models. Powered by knowledge, research, and experience, we enable clients to transform their business ecosystems and achieve superior performance by leveraging infrastructure, cloud, analytics, digital, and security paradigms. Reach out to get in touch or learn more.

Explore
Cloud

BUILDING A GLOBAL DATA PLATFORM ON THE AWS CLOUD FOR A HEALTHCARE CLIENT

Healthcare Provider Seeks Advanced Cloud Analytics Capabilities Trianz was approached by a leading global healthcare provider that wanted to leverage cloud infrastructure to build a new secure, scalable, and industry-compliant cloud IT platform. Its internal teams would use this platform for large-scale and complex analytics in the US and EU geographic areas. Business Challenges for the Healthcare Provider The healthcare client lacked any form of data analytics solution and was in need of modern and highly compliant analytics capabilities to generate healthcare insights. This new analytics solution needed to be flexible, scalable, secure, and aligned with strict guidelines and regulations like HIPAA and GDPR. Technology Components Introduced to the Client by Trianz Trianz identified a range of relevant technology components that would help the healthcare provider achieve its goals: Amazon Elastic Map Reduce was used to rapidly apply processing and analytics to big data sources. Amazon Elastic Container Service was chosen to host containerized processes and applications with autoscaling during peak and low demand. Amazon Elastic Kubernetes Service was used to deploy managed Kubernetes clusters across numerous AWS availability zones. AWS Glue was selected as a serverless extract-transform-load solution for data crawling, data catalogs, and data transformation workflows. AWS Virtual Private Cloud was chosen instead of the public cloud due to the sensitive nature of healthcare-related to personally identifiable information (PII). SageMaker is a fully managed service to build, train, and deploy machine learning algorithms. AWS Lambda was introduced to enable serverless, event-driven compute workloads. Amazon CloudWatch centralizes data on AWS resources, applications, and services to streamline application and infrastructure monitoring. Amazon Simple Notification Service is a fully managed capacity planning, provisioning, monitoring, and patching solution. Amazon Elastic Compute 2 (EC2) is a compute node service with autoscaling support. Amazon Relational Database Service was used to configure and orchestrate the client’s RDMBS solution on AWS. The AWS Key Management Service was added to provide robust FIPS 140-2 compliant, hardware-based security standards in the cloud. AWS Simple Storage Service was chosen as an economical, scalable, and configurable data storage platform. Elastic Search was introduced as a web crawling solution with RESTful support and a built-in analytics engine. Amazon Cognito provides solutions to control access to AWS resources from the client software applications, including role definitions and user mapping. AWS DynamoDB is a NoSQL fully managed and serverless database service based on key values, that can support high-performance applications at scale. Trianz also helped the healthcare client to adopt HashiCorp Terraform, GitHub, Jenkins, Newrelic, Ansible, and Chef as part of the project. The Trianz Approach to Implementing a New Cloud Infrastructure Solution The first focus was automation, where continuous integration and deployment (CI/CD) pipelines were used to deploy AWS components using Infrastructure-as-Code (IaC). This included GitHub for code versioning and source control, and Hashicorp Terraform as an open source IaC tool. Next, automation rules were established for system software configuration and patch management using Chef and Ansible. This adhered to the healthcare client’s internal compliance and security controls, a critical milestone for the project. Transformational Effects After Building a New AWS Infrastructure Environment The healthcare client can now manage its entire cloud infrastructure system using automated IaC tools. This includes deployment to various platform environments and different geographic availability zones on AWS. The viability of the infrastructure design was proven to attract additional stakeholder interest, with the EU area being the first successful integration attempt. IT maintenance activities, including monitoring and stabilization, were streamlined and automated to reduce manual workloads for the IT team. The US region is under construction and awaiting testing approval from a selection of teams trialing the architecture. Operational automation had an immensely beneficial impact, with downtime metrics reducing by over 80%. This is thanks to the blue/green method used during application rollout on AWS. Similarly, application spool times were significantly reduced in K8S clusters, improving latency and performance on the network. By using managed services, security offloaded from the client to AWS. This security-as-standard helped the healthcare client to pass all internal and external auditing procedures after adoption and was critical in protecting sensitive PII. The availability of IT services increased measurably, with fewer false alarms, reduced event noise, and automation playbooks to remediate common system anomalies. Experience the Trianz Difference Trianz enables digital transformations through effective strategies and excellence in execution. Collaborating with business and technology leaders, we help formulate and execute operational strategies to achieve intended business outcomes by bringing the best of consulting, technology expertise, and execution models. Powered by knowledge, research, and experience, we enable clients to transform their business ecosystems and achieve superior performance by leveraging infrastructure, cloud, analytics, digital, and security paradigms. Reach out to get in touch or learn more.

Explore
Cloud

IMPLEMENTING DIRECT RESOLUTION VIA REAL-TIME VIRTUAL ASSISTANCE FOR PHARMA CLIENT

Pharmaceuticals Provider Seeks Cloud Service Platform to Access Knowledge in Real-Time An international pharmaceuticals provider was seeking to adopt a new real-time virtual assistance platform to assist with ticket resolution. The provider offers research and development, production, marketing, and sale of drugs for patients with central nervous system (CNS) disorders. Business Challenges for the Pharma Provider in Ticket Management New employees were encountering problems with accessing company resources. Similarly, when requesting help accessing these resources, response times were too high. Internationally, the client’s helpdesk ticketing system had a lot of overhead and experienced latency and performance problems when routing tickets. Technology Components Selected for the Virtual Assistant Project Trianz decided upon the following technology components to enable the pharma client’s new virtual assistant: Microsoft Azure was chosen as a cloud service platform. It had supplementary services available which would integrate seamlessly with monitoring, orchestration, and deployment functions. The Azure Bot Service was chosen as a managed service for serverless bot deployment using AI and conversational natural language processing (NLP). Q&A Maker was used to create question-and-answer relations, enabling conversational dialogue for FAQs within the virtual assistant bot for the pharma client. Language Understanding Intelligent Service (LUIS) was chosen as part of the Microsoft Cognitive Services on Azure to process utterances, interpret user intent, distill user sentences into entities, and intuitively respond with relevant information or actions. How Did Trianz Approach the Virtual Assistant Project for the Pharma Client? Trianz started by developing a virtual assistant bot on the Microsoft Azure cloud. The Azure Bot Service hosted the virtual assistant, with Q&A Maker allowing the client to create an initial FAQ framework, and continuously update this framework into the future. LUIS would see continuous updates and improvements, ensuring the client had access to the latest and greatest NLP technologies for better virtual assistant experiences. This virtual assistant bot could be accessed across all platforms with a HTML5 web browser, including desktop, mobile, smart TVs, and even potential expansion to voice assistants like Microsoft Cortana. Employees in the field could use the bot to request information, regardless of their location or device. Transformational Effects for the Pharma Client After Adopting the Virtual Assistant The pharma client’s employees could now access knowledge in real-time, 24 hours a day using conversational language. The assistant formed a foundational platform for employees to reach automated resources and the latest corporate information, offloading ticket workloads from overloaded helpdesk employees. Automated responses significantly reduced the number of inbound tickets on the helpdesk, assisting with ticket number reductions. Remote employees were more engaged and connected with headquarters thanks to on-demand 24/7 access to corporate knowledge. Experience the Trianz Difference Trianz enables digital transformations through effective strategies and excellence in execution. Collaborating with business and technology leaders, we help formulate and execute operational strategies to achieve intended business outcomes by bringing the best of consulting, technology expertise, and execution models. Powered by knowledge, research, and experience, we enable clients to transform their business ecosystems and achieve superior performance by leveraging infrastructure, cloud, analytics, digital, and security paradigms. Reach out to get in touch or learn more.

Explore
Cloud

MIGRATING PAYMENT GATEWAY APPLICATION TO CLOUD AND MULTI-YEAR MANAGED SERVICES

Hosting, Monitoring and Support of a Large Payment Gateway Trianz was approached by a global FinTech provider that manages millions of credit and debit card transactions each year. It needed a partner to host, monitor, and continuously improve its payment gateway application, which was critical to its overall market penetration strategy. Business Challenges for the Global FinTech Provider The FinTech provider needed a partner to support, enhance, and deploy market-specific software programs as part of its payment and transaction service portfolio. These programs are critical to business operations, and the client desired managed services to minimize negative business impacts and drive business success without increasing its internal IT workloads. Technology Components Implemented During the Payment Gateway Project Trianz worked with the global FinTech provider to implement the following technology components: Microsoft Azure was chosen as a cloud service platform with autoscaling, pay as you go billing, and broad integration support. EDB Postgres extends the capabilities of PostgreSQL databases with increased security and Kubernetes container support. The client’s proprietary payment gateway solution was migrated to and hosted on Microsoft Azure. Splunk was selected as a data platform that can identify patterns, provide metrics, and diagnose problems with data sources using machine learning. Dynatrace was chosen to facilitate application and infrastructure security monitoring with automation support and AI functionality in the cloud. Vormetric was used to encrypt any at-rest data contained within EDB Postgres for the FinTech client, using centralized access policies and an encryption key management repository. Thales HSMs provided hardware-based security devices that are compatible with Microsoft Azure cloud services, known as hardware security modules (HSMs). RSA SecureID was chosen as a two-factor authentication layer for internal staff when accessing sensitive applications and data in Azure. Citrix Application Delivery Controller (formerly Netscaler) was used to load balance applications hosted in containers across Azure, promoting security and visibility. How Trianz Transformed the FinTech Client’s Payment Gateway on Azure Trianz devised a plan for managed services around the payment gateway. This would include hosting, infrastructure and application monitoring, and continuous enhancements to the platform over time as requested by the client. Next, the infrastructure architecture was designed on Azure, alongside a migration strategy and rapid stabilization strategy. Stakeholders were communicated with during this phase to understand inter-departmental business requirements. A Business-as-a-Service managed services framework was adopted, encapsulating the core capabilities required for the FinTech client’s payment gateway to operate efficiently. This included transitionary processes, management over time, and scheduled enhancements to the payment gateway solution. The entire payment gateway was then migrated to Azure alongside security, data, and access control configuration. The Azure architecture was designed around the client’s strict security and compliance requirements. Finally, service level agreements and support processes were agreed upon, based on cloud service utilization and different Infrastructure-as-a-Service and Platform-as-a-Service modules. Transformational Effects After Migrating the Payment Gateway to Azure for the FinTech Client At the end of the project, the client’s payment gateway had been successfully migrated to Microsoft Azure. First, end-to-end support for Level 1 and 2 support workloads was in place as part of the managed service. This included general IT support and the design of incident resolution workflows by Trianz’ managed services team. A broad range of production support activities were undertaken by the Trianz managed services team across application stacks to improve IT network security and compliance The client could now automate processes and workflows using automation playbooks, streamlining productivity and efficiency. Network optimization was continuous to ensure the payment gateway adhered to strict governance and security rules. Trianz assisted with agile product development, and took the initiative to continuously improve IT services for the client as part of the managed service plan. Experience the Trianz Difference Trianz enables digital transformations through effective strategies and excellence in execution. Collaborating with business and technology leaders, we help formulate and execute operational strategies to achieve intended business outcomes by bringing the best of consulting, technology expertise, and execution models. Powered by knowledge, research, and experience, we enable clients to transform their business ecosystems and achieve superior performance by leveraging infrastructure, cloud, analytics, digital, and security paradigms. Reach out to get in touch or learn more.

Explore
Cloud

CLOUD HOSTING WITH AUTO-SCALING AND AUTO-REMEDIATION

Airfare Consolidation Company Seeks Cloud Hosting Upgrades Trianz worked with a global airfare consolidation services company in response to growing technical, performance, and reliability problems on its cloud services platform. The customer experience (CX) was suffering as service availability faltered, and the company had expended much time and capital fighting recurring IT fires. Challenges for the Airfare Consolidation Company Stemmed from Cloud Hosting The airfare consolidation services company's current cloud hosting platform suffered from a lack of scalability. Since demand peaks led to server overutilization and resource scarcity, customer demand fluctuated wildly on its cloud platform. The result for customers was slow, sluggish, or unavailable services. To troubleshoot the issues, the company needed to map and document its entire application suite. Unfortunately, it lacked knowledge of the intricacies of its network and architecture, making it difficult to identify and remediate the root cause of service problems. The company required a digital transformation that introduced 24x7 elastic auto-scaling or resource provisioning in response to demand and monitoring to keep scaling costs under control. They also needed alerts whenever auto-scaling was activated, to monitor and proactively plan for peaks in demand.   Technology Components Used on AWS Hosting Platform With help from the Trianz cloud experts, the company decided on the following technology components: Windows Server was used, as the cloud platform relied on .NET and Microsoft SQL to operate. .NET Framework enabled application interoperability in the cloud for developers, working cross-platform and on an open-source basis. MS SQL was used for its compatibility with .NET and Windows, functioning as a database solution for the airfare cloud application. Application Load Balancers were implemented in the cloud environment to monitor for and remediate peaks in service demand. Application Caching Engines were used to reduce bandwidth and processing requirements by serving pre-loaded data to users from edge data centers. Web Application Firewalls were implemented to monitor and protect the network against HTTP and HTTPS traffic, along with RESTful requests and other traffic. A Content Delivery Network was built to store and serve audio, image, and video assets to users with greater efficiency and response times than the previous solution. Enterprise DNS Services were configured to map application server IP addresses, redirect traffic to the old platform, and ensure full accessibility for users. A Virtual Private Network was configured to encrypt data in transit between the cloud servers and platform users, alongside improving cybersecurity for employees working remotely. Audit Logs were configured and activated to ensure all changes were monitored, tracked, and held to account. Airfare Platform Development and Implementation with Trianz Using the above solutions, Trianz cloud experts began with an assessment of platform requirements and how much processing capacity was needed to ensure a smooth and reliable operation of the airfare platform. Trianz measured this using application performance management (APM) tools, which drilled down at the process level to identify CPU, RAM, and storage utilization metrics. The Trianz cloud experts then deployed a new architecture on AWS as the client's platform of choice. Here, network design took place to allow access through firewalls, DNS subnet masks, and the overarching VPN service used for security. This included routing for the caching engines and load balancers, both of which increased response times and overall availability. Finally, a monitoring system was implemented that operates 24x7 and sends real-time alerts to IT personnel in reference to outages, bottlenecks, security risks, and overspend with the airfare application platform. Transformational Effects and Impact After implementation, the airfare services platform was capable of auto-scaling and auto-remediation in response to peaks and troughs in network demand. The entire platform was benchmarked and stress-tested to analyze performance under load and ensure auto-scaling worked effectively. Multiple layers were created within the platform, each with its own auto-scaling ruleset for more granular control and greater cost savings. After the infrastructure was in place, the Trianz experts made detailed documentation to guide the airfare company’s IT team in the future. This included how to set up the cloud infrastructure, blueprints for ease of deployment, and how to configure various service integrations required by the platform. Today, the airfare company has a resilient digital-first platform that can auto-scale to meet demand. Cybersecurity was improved with a VPN and firewall services. Caching, load balancing, and content delivery networks improved performance and response times for users, enhancing the overall customer experience (CX). Future development or configuration work on the cloud platform, both internally and externally, can now be tracked thanks to audit logs tied to specific user accounts on AWS. Experience the Trianz Difference Trianz enables digital transformations through effective strategies and excellence in execution. Collaborating with business and technology leaders, we help formulate and execute operational strategies to achieve intended business outcomes by bringing the best of consulting, technology expertise, and execution models. Powered by knowledge, research, and experience, we enable clients to transform their business ecosystems and achieve superior performance by leveraging infrastructure, cloud, analytics, digital, and security paradigms. Reach out to get in touch or learn more.

Explore
Cloud

CLOUD AUTOMATION, SECURITY AND MANAGED SERVICES FOR A SOFTWARE COMPANY

ServiceMax Seeks to Rearchitect its AWS Environment With a need to implement a cloud automation solution to streamline digital processes and workflows, ServiceMax — a global leader in field service management software — was looking to re-architect, configure, and manage its field service management platform. What was ServiceMax Looking to Achieve? ServiceMax uses the AWS cloud platform to process work orders via its Software-as-a-Service solution. With more than 1 million work orders processed per month, and 300,000+ technicians working across the globe to manage 150+ million customer devices, their goal was to elevate cloud performance, security, and availability within the ServiceMax SaaS platform. In addition, they sought to identify more suitable cloud-service candidates that align with business requirements on the AWS cloud. Challenges for ServiceMax on the AWS Cloud ServiceMax was seeking a partner to assist with building a highly resilient, scalable, and secure infrastructure on AWS, coupled with minimal downtime and data governance. The new platform needed to support script automation, as ServiceMax encountered manual processing errors that reduced productivity and data accuracy. ServiceMax was also threatened by recurring downtime on its network, requiring enhanced network performance through agile applications that could handle dynamic bandwidth needs and network topology changes. To achieve these goals, Trianz experts completed an initial assessment of existing IT capabilities with ServiceMax to explore the possibilities of executing a time-bound, object-oriented, proof-of-concept-based deployment on AWS. After approval, Trianz experts reduced operational costs by identifying a low-cost solution on AWS that targeted high-bandwidth application environments. Technology Components Used by ServiceMax on AWS After consultation and implementation, the ServiceMax platform was underpinned by the following AWS components: Amazon Virtual Private Cloud (VPC) for secure, private local area networks in the cloud Amazon Route 53 for domain name server (DNS) routing and management within the AWS ecosystem Amazon CloudFront for global edge-caching and edge-serving of media through a content delivery network (CDN) Elastic Load Balancing for adaptive processing and resource allocation as platform demand rises and falls Amazon EC2 (with AutoScaling) for fully automated, scalable compute nodes AWS Lambda for serverless compute without provisioning or managing servers Amazon Simple Storage Service (S3) for low-cost cloud storage, archiving, and disaster recovery backups Elastic Block Store (EBS) for storing and managing data in blocks within relational database management systems (RDBMS) AWS Identity Access Management (IAM) to control user account access to sensitive datasets and software, along with two-factor authentication (2FA) support Amazon GuardDuty to continuously monitor for AWS account or compute workload threats using heuristic threat scanning Amazon Inspector to automate security and compliance assessments for business applications running on AWS AWS Secrets Manager to store and govern access to secret hashes, salts, and passwords used when accessing sensitive applications, services, and IT resources AWS WAF and Shield to monitor HTTP and HTTPS requests forwarded to Amazon services, acting as a web firewall AWS CloudFormation to generate and manage Infrastructure-as-Code templates for AWS and third-party services AWS CloudTrail to monitor governance, compliance, audits, and risk for specific AWS user accounts AWS CloudWatch to collect and centralize application and infrastructure monitoring data for a 360-degree holistic cloud network overview AWS Config to assess, audit, and evaluate AWS resource configurations Trianz also implemented Sumologic, Qualys, OpenVPN, Wazuh, AVI, Bro & Suricata, HashiCorp Terraform, GitHub, Jenkins, Newrelic, and Jumpcloud to further enhance the platform with cloud-based automation, machine learning, and advanced security capabilities. How the Trianz Approach Upgraded ServiceMax’s IT Infrastructure The Trianz experts followed a roadmap to reinvent the ServiceMax IT infrastructure network and deliver on project objectives. It started with a complete redesign of the infrastructure environment, in alignment with AWS best practices using Infrastructure-as-a-Code. Terraform modules were deployed across the new infrastructure environment to enable full scaling support. A hub-spoke architecture allowed for centralized connectivity between virtual networks (or spokes) acting as a central zone for ingress and egress traffic. Trianz introduced ServiceMax IT personnel to security best practices, including boundary defense, CIS hardening, endpoint security, credential management, multi-factor authentication, monitoring, auditing, logging, certificate and key management, and vulnerability management. A “blue-green” approach was used to gradually transition users to the latest web application version — it was implemented using Terraform and Jenkins continuous integration and deployment (CI/CD) pipelines.Finally, Jumpcloud was used for all eligible services as a single sign-on (SSO) solution. How Trianz Helped ServiceMax Realize Their Business Goals After successfully executing its re-architecture with Trianz, ServiceMax’s platform performance increased noticeably with improved efficiency and high availability, leading to less wasted spend and better customer experiences. Application rollouts were streamlined, reducing workloads for IT developers through automation. ServiceMax can redeploy IT assets in record time thanks to Infrastructure-as-Code templates and Jenkins CI/CD pipelines. Operating costs for the ServiceMax SaaS platform were also greatly reduced, and service level agreements (SLAs) improved while meeting customer security requirements. The Transformational Effects and Impact Downtime was reduced by up to 80% due to the “blue-green” approach used with Terraform and Jenkins. The time to spin-up new applications PoPs was reduced from one month to one week. Security standards were greatly improved, enabling ServiceMax to pass internal and external audits with ease. Finally, the IT department has reduced the number of false alarms on the IT network. Now, using advanced alert monitoring, threats are automatically remediated using common anomaly resolution playbooks. Experience the Trianz Difference Trianz enables digital transformations through effective strategies and excellence in execution. Collaborating with business and technology leaders, we help formulate and execute operational strategies to achieve intended business outcomes by bringing the best of consulting, technology experiences and execution models. Powered by knowledge, research, and perspectives, we enable clients to transform their business ecosystems and achieve superior performance by leveraging infrastructure, cloud, analytics, digital and security paradigms. Reach out or get in touch to learn more. ×

Explore
Cloud, Analytics

CENTRALIZED ENTERPRISE DATA REPOSITORY FOR A PACKAGING AND SHIPPING SUPPLIES PROVIDER

Accelerating Business Efficiency with a Centralized Enterprise Data Repository Trianz was approached by a packaging and shipping supplies provider based in North America. The client wanted to combine siloed data repositories into a single-source-of-truth (SSOT) to promote data integrity, validity, and accuracy. Business Challenges for the Shipping Supplies Provider with Data Management The client was dealing with data siloes across the business, meaning there was no SSOT to derive insight from. This created inconsistency between departments as they used analytics and business intelligence (BI) tools to generate insights, leading to inaccurate insights that negatively impacted business decision-making. To resolve this, the client needed a new centralized enterprise data repository that combines these siloed datasets into a SSOT. This would improve capabilities around data validity, verification, and integrity monitoring, leading to more accurate data and more accurate insight from analytics and BI tools. Technology Components Selected for the Shipping Client by Trianz After a comprehensive assessment of the shipping client’s IT infrastructure and services, Trianz selected the following technology components: Informatica was chosen as an end-to-end data operations platform for data engineering, integration, governance, and quality assurance processes. SQL Server was used as a relational database management system (RDBMS), chosen for integrations and live connector optimizations with PowerBI. Lastly, PowerBI was chosen as a Microsoft ecosystem solution for BI operations, including analytics, dataset unification, visualizations, and more. How Trianz Helped the Shipping Supplier to Build a SSOT and Transform Analytics and BI Operations Our data experts started with asset discovery and analysis to formulate an end-to-end picture of business IT systems and services. This helped with the identification of appropriate technology components, ensuring compatibility and integrability. From here, Trianz took control of data operations and systematically optimized the architecture for high availability, accuracy, and validity. The target was operational availability 24 hours a day, 7 days a week as part of a 99.9% uptime service level agreement. Next, existing data models were simplified to assist with downstream analysis. These models could then be used across the business to generate insights with greater efficiency. Trianz collaborated with the client’s IT department to standardize business IT applications and services, and transform IT and data governance frameworks. This would prevent unauthorized data access and improve data security as the same rules could now be applied holistically. Finally, Trianz worked within Informatica to centralize structured datasets on SQL Server. This included the configuration of optimized data connectors between SQL Server and PowerBI to streamline analytics and BI data operations. Transformational Effects After Building a New SSOT for the Shipping Client Now, the client could generate holistic, 360-degree analytical overviews of various business operations to derive insight for use in business decisions. This improved the quality of decisions, directly impacting the top and bottom line. Statutory reporting timescales were shortened significantly, improving awareness across the business in relation to mandatory government information-sharing requirements. Data availability was greatly improved alongside workforce trust in the validity and accuracy of datasets. This meant the business had access to quality data sources with sharp turnaround times when submitting queries. Experience the Trianz Difference Trianz enables digital transformations through effective strategies and excellence in execution. Collaborating with business and technology leaders, we help formulate and execute operational strategies to achieve intended business outcomes by bringing the best of consulting, technology expertise, and execution models. Powered by knowledge, research, and experience, we enable clients to transform their business ecosystems and achieve superior performance by leveraging infrastructure, cloud, analytics, digital, and security paradigms. Reach out to get in touch or learn more.

Explore
Cloud

ALFRESCO DEPLOYMENT ON THE AWS CLOUD

Alfresco Deployment on the AWS Cloud for a Fortune 100 Insurance Company Trianz was approached by a Fortune 100 insurance company looking for help with its Alfresco documentation management platform. It was seeking to migrate Alfresco from an on-premises environment to the AWS cloud to simplify documentation management, collaboration, auditing, and compliance. Business Challenges for the Fortune 100 Insurer with Documentation, Collaboration, and Compliance As the Alfresco deployment was on-premises, the client was struggling with performance bottlenecks and scalability limitations. As a recourse, the insurance client wanted to migrate to the AWS cloud. The AWS cloud environment would need to be flexible and agile to accommodate the client’s documentation management and enterprise collaboration requirements. Technology Components Chosen for the Insurance Company by Trianz After assessing the current-state and future requirements for the insurance client, Trianz decided on the following technology components: AWS Cloud was the cloud service platform (CSP) of choice, with broad and varied features across compute, data, networking, and cybersecurity. Red Hat Enterprise Linux was the operating system (OS) of choice, as it allowed for unmatched flexibility and agility thanks to the customizability and modularity of the Linux kernel. Alfresco was already selected as a content management system (CMS) to connect, manage, and secure important enterprise documentation. MySQL was chosen as a relational database management system (RDBMS) thanks to its querying performance and response times. Elastic Bamboo was adopted to expedite run builds using compute resources on the AWS Elastic Compute Cloud (EC2). The Java programming language was used as it is a critical dependency for Alfresco. SharePoint was selected as an intranet and content collaboration solution to share and host internal documentation. BMC Remedy was selected to orchestrate all IT service management processes and principles on the new AWS cloud architecture. How Trianz Helped the Fortune 100 Insurance Company to Deploy Alfresco on AWS Trianz started by analyzing the servers required for the new Alfresco content repository. These analyses were revisited at the development, quality assurance, staging, and production phases to ensure we adhered to the project roadmap. Alfresco itself was upgraded from version 4.2 to version 5.0.3, before existing content was migrated to the new Amazon EC2 architecture. Next, Alfresco was reconfigured and optimized around the new EC2 architecture to enhance performance and scalability. Application integration using Web Service APIs came next, enhancing support across all lines of business for applications and third-party systems. Finally, a two-week evaluation period took place to ensure the live environment met expectations and fulfilled all project milestones. This included a Hypercare support phase, and knowledge transfer to the client’s enterprise content management (ECM) support team and personnel. Transformational Effects For the Fortune 100 Insurer After Migrating Alfresco to the AWS Cloud After migrating Alfresco to the AWS cloud, the insurance client reduced costs significantly while also enhancing its regulatory and legal compliance capabilities. The cost savings came thanks to the economical nature of public cloud infrastructure, using compute nodes and pay-as-you-go billing models. File sharing and collaboration was streamlined as existing business and IT services used Alfresco as a centralized ECM system. By upgrading Alfresco, valuable new documentation management capabilities were enabled with version 5.0.3. Task management and workflow management frameworks were redeveloped to drive consistency and efficiency across all lines of business. The IT department now has complete control over security and data access thanks to AWS role-based access control (RBAC) policies on EC2. The insurance company also had flexibility as it could choose between Software-as-a-Service (SaaS) or private AWS instances, depending on future requirements. The most impactful transformation was around metadata and full-text search functionality, allowing employees across the business to drill deeper into datasets and form more comprehensive insights. Experience the Trianz Difference Trianz enables digital transformations through effective strategies and excellence in execution. Collaborating with business and technology leaders, we help formulate and execute operational strategies to achieve intended business outcomes by bringing the best of consulting, technology expertise, and execution models. Powered by knowledge, research, and experience, we enable clients to transform their business ecosystems and achieve superior performance by leveraging infrastructure, cloud, analytics, digital, and security paradigms. Reach out to get in touch or learn more.

Explore
Cloud

A CASE STUDY IN LARGE INFRASTRUCTURE MIGRATION TO AWS

Helping a Global Software Giant Subsidiary Migrate from Public Cloud to AWS Trianz was approached by a global software giant subsidiary for assistance in migrating from the public cloud to AWS. This client provides innovative software products that can be hosted either on-premises or in the cloud. Challenges for the Software Giant Subsidiary in Infrastructure Scaling and Security The client was struggling to scale its cloud infrastructure in an efficient and reliable manner. This coincided with problems hosting in a multi-tenant environment, where cloud instance separation and data governance workflows was difficult. The software giant subsidiary lacked a central security management system and inherited the deployed architecture without sufficient documentation to understand its inner workings. Technology Components Introduced by Trianz for the Software Giant Subsidiary To start, Trianz performed a top-down assessment of the client’s infrastructure environment before introducing the following technology components: CloudTrail was used for monitoring audit trails. Identity Access Management was used to govern applications and data with role-based access controls. Virtual Private Cloud (VPC) enabled private, isolated cloud instances to improve multi-tenant orchestration within its software platform. Network Security Groups were added to govern firewall operations. Elastic Compute 2 was used to elastically auto-scale compute workloads, ensuring resource availability at peak utilization and cost savings during quieter periods. Elastic Load Balancing was adopted to distribute incoming application network requests and balance workloads across EC2, containers, and other network resources. The existing Infrastructure-as-a-Service platform was replaced with Platform-as-a-Service (PaaS). This included a migration from virtual-machine-based MySQL to the AWS Relational Database Service for MySQL. Network Address Translation workloads were redirected to the AWS NAT Gateway. Object-based storage was offloaded to the AWS Simple Storage Service. AWS CloudWatch was the monitoring and alerting solution of choice. How Trianz Helped the Subsidiary to Scale and Secure its Software Platform By using PaaS, Trianz could quickly develop and implement a scalable, architecture-based deployment for the software subsidiary. Multiple availability zones were added to distribute network traffic and get closer to the edge, reducing latency and increasing bandwidth throughput. A centralized and dedicated VPC environment was created to host multi-tenant shared services, eliminating the previous cloud instance separation and data governance challenges. Each application type was provisioned its own VPC to improve reliability, stability, and predictability. This coincided with a complete redevelopment of the application stack by the application team at Trianz. Transformational Effects with the New PaaS Software Environment for the Software Subsidiary Omni-channel commerce operations were successfully migrated from the previous public cloud architecture to AWS. AWS enabled elastic auto-scaling on a per-service level, greatly improving granularity of control for the software subsidiary. A new Central Security Management solution plugged security holes and compliance problems at the infrastructure level. The PaaS adoption resulted in new service level agreements (SLAs) that offloaded the IT operations management burden from the software subsidiary to AWS, thus reducing workloads. This new solution was fault-tolerant and highly available thanks to these new SLAs, greatly improving the quality of application service delivery over the web. Trianz conducted workshops to educate stakeholders and the workforce on operational best practices. Finally, a full library of documentation was written and supplied to the software subsidiary, ensuring clarity and technical understanding in the years to come. Experience the Trianz Difference Trianz enables digital transformations through effective strategies and excellence in execution. Collaborating with business and technology leaders, we help formulate and execute operational strategies to achieve intended business outcomes by bringing the best of consulting, technology expertise, and execution models. Powered by knowledge, research, and experience, we enable clients to transform their business ecosystems and achieve superior performance by leveraging infrastructure, cloud, analytics, digital, and security paradigms. Reach out to get in touch or learn more.

Explore
Cloud

CLOUD COMPLIANCE FOR HEALTHCARE START-UP

Healthcare Startup Seeks a HIPAA-Compliant IT Environment on AWS With stringent regulations governing its industry, a US-based healthcare startup needed assistance in architecting a HIPAA-compliant IT infrastructure environment. Alongside HIPAA compliance, the startup needed a better way to protect sensitive personal health information (PHI) after experiencing problems with its previous systems. What Was the Healthcare Startup Looking to Achieve? The healthcare startup wanted the AWS cloud platform to host and orchestrate its digital services. This infrastructure needed to support full audit trails, HIPAA regulatory frameworks, resolve security holes from the previous architecture with PHI, and be executed in a cost-sensitive manner. Challenges for the Healthcare Startup on the AWS Cloud These sweeping changes would help the healthcare startup adhere to HIPAA regulations, avoiding fines and reputational damage. Audit trails would provide clear breadcrumbs for changes on the network, improving accountability and awareness of infrastructure activities. Finally, protecting PHI with more stringent security measures would mitigate any potential data breaches in the future. Trianz began by assessing the current state of the client’s architecture. Here, our experts could identify misconfigured modules, insecure security rules, and fast-track the digital transformation process for the startup by recommending AWS services. Technology Components Used by the Healthcare Startup on AWS After consultation, the healthcare startup had a new IT infrastructure environment on AWS consisting of the following technology components: Amazon Relational Database System (RDBS) for encrypted structured database storage to improve PHI data management and subsequent security procedures AWS CloudTrail for cloud audit trail monitoring using application programming interface (API) logs, with a goal of improving accountability and root cause identification Amazon Virtual Private Cloud Security Groups were used to shape and monitor network traffic using internet protocol (IP) whitelisting rules, which was necessary to ingest wearable and health device data using encryption Secure Socket Layer (SSL) Certificates were used to implement hypertext transfer protocol secure (HTTPS) rather than the non-secure HTTP, again bolstering cybersecurity and PHI protection for HIPAA compliance How the Trianz Approach Upgraded the Healthcare Startup’s IT Infrastructure The Trianz experts devised a comprehensive roadmap for this digital transformation project. The healthcare startup’s existing services and data were backed up before being migrated to the new infrastructure environment. This helped to prevent service outages and subsequent customer dissatisfaction during the migration process. Existing PHI and pharmaceutical data were imported to the new Amazon RDS system, enabling cloud database storage and the associated accessibility and cost-saving improvements. Trianz also developed an ingestion system for wearables and personal health monitoring devices, taking Real-World Data (RWD) direct from the source to the database with full encryption. Trianz also created an interface for medical practitioners to upload patient data on a day-by-day basis. Finally, analytics and reporting were implemented using dedicated compute resources on AWS as the system went fully live. The Transformational Effect and Impacts After this digital transformation, the healthcare startup had greater control over its PHI data in Amazon RDS. Additional security with user accounts and overarching data governance policies on AWS helped streamline governance and regulatory workflows. Full audit trails increased accountability and assisted with the root cause remediation of problems. Overall, the result was a faster and more secure healthcare PHI data storage solution for the healthcare startup, enabling greater integration and access across digital services used by the business. This greatly improved business agility and enabled new innovative digital-first health initiatives. Experience the Trianz Difference Trianz enables digital transformations through effective strategies and excellence in execution. Collaborating with business and technology leaders, we help formulate and execute operational strategies to achieve intended business outcomes by bringing the best of consulting, technology expertise, and execution models. Powered by knowledge, research, and experience, we enable clients to transform their business ecosystems and achieve superior performance by leveraging infrastructure, cloud, analytics, digital, and security paradigms. Reach out to get in touch or learn more.

Explore
Cloud, Analytics

AWS OPERATIONAL DATA STORE: A CASE STUDY

A Fortune 100 P&C Insurer Uses AWS ODS for Efficient Operations Challenge Continuous innovation in insurance analytics enables many P&C insurers to improve their plans for customer-centricity, telematics, and claim management efficiency. However, P&C insurers often struggle with leveraging enterprise-level data due to inaccessible data formats or a lack of trust in the underlying data quality and semantics. A Fortune 100 P&C insurer in the US, who we will call WesternShores, needed a next-gen operational data store (ODS). The company’s leaders found it challenging to manage operations efficiently with slow development life cycles, limited data processing capability, and heavy dependence on IT. They were looking for low-cost infrastructure and analytics solutions as they migrated their existing applications to event-based architecture. Knowing there was a better way, they set out to deploy an intelligent, state-of-the-art ODS and analytics solution. Our Approach To foster greater trust among stakeholders, WesternShores collaborated with Trianz to start user research through a focused questionnaire and conducted executive interviews and workshops to uncover key issues and gather data points. To suggest a smarter analytics solution, WesternShores needed to know the costs of a big data platform on the cloud to make the right choice. They were already using Hadoop-as-a-Service (HDaaS) as an alternative to on-premises Hadoop deployments; however, due to a lack of skilled resources, were struggling to use it to its full advantage. After evaluating their existing analytics landscape and infrastructure and analyzing data points, we suggested deploying Hortonworks Data Platform (HDP) on Amazon Web Services (AWS) Cloud. We leveraged our proprietary total cost of ownership (TCO) calculator to compare their HDaaS with Hortonworks Data Platform deployed on AWS Elastic Compute Cloud (EC2) to estimate the total cost of ownership (TCO). We also defined a roadmap to deploy the HDP on the cloud. Considering all the internal and external factors, we proposed three storage options to WesternShores in the Hadoop deployment architectures on AWS: Simple Storage Service (S3) - Amazon Simple Storage Service or Amazon S3 can store vast numbers of backups or user files, which are readily available when needed. There are no resource procurement cycles or investments upfront, which means they can keep their data safe from errors, failures, and threats. WesternShores can easily hold their content and media files in S3, which may be served efficiently from AWS CloudFront. Plus, S3 can easily create a data lake to hold raw data in its native format and then use machine learning tools, query-in-place, and analytics to draw insights. Elastic Block Store (EBS) - Amazon’s block-level storage solution, where they can keep the data on the AWS EBS servers even when the EC2 instances are shut down. EBS offers them high availability and low-latency performance within the selected availability zone, allowing them to easily scale storage capacity at a low subscription-based pricing model. AWS EC2 instance store - An AWS instance store is a temporary storage type located on disks that are physically attached to a host machine. Out of the three instance store volumes, we suggested Ephemeral storage to WesternShores. Also known as virtual devices, this was suitable for low-latency storage. Transformational Effects Our ODS best practices and implementations for building an ODS - AWS’ next-gen Hadoop-based platform - resulted in accurate, real time estimates for WesternShores’s TCO in the first year. They also benefitted from our cost projections of operational data storage, resulting in a better performance. Experience the Trianz Difference Trianz enables digital transformations through effective strategies and excellence in execution. Collaborating with business and technology leaders, we help formulate and execute operational strategies to achieve intended business outcomes by bringing the best of consulting, technology experiences and execution models. Powered by knowledge, research, and perspectives, we enable clients to transform their business ecosystems and achieve superior performance by leveraging infrastructure, cloud, analytics, digital, and security paradigms. Reach out to learn more.

Explore
Cloud, Cybersecurity

CLOUD SECURITY POSTURE MANAGEMENT

Trillium Targets Secure, Compliant Cloud Infrastructure With cloud computing rapidly phasing out legacy and on-premise applications and infrastructure, one of the leading payment services and mobile payment gateway providers in the Middle East/North Africa (MENA) region – we’ll call them Trillium – recognized the need for a secure, fully compliant hybrid cloud environment for their e-wallet application. This application, that required lifting and shifting into the cloud, would serve all of Trillium’s e-wallet users in the Egypt area, with a full data migration that needed to be conducted within the short span of a year. Because Trillium had an existing relationship with Trianz, they turned to us to handle the e-wallet application’s platform migration, rearchitecting, and data governance. Addressing Cloud Challenges In June 2018, Trillium was looking to ensure that their cloud platform was up to standard, with a customized architecture to handle their approximately 300 vendor management systems (VMS) and appliances, as well as the more than 300,000 transactions made through the app in a day. This was especially important considering that these applications were financial inclusion products used by a large segment of Egypt’s population lacking access to full-scale banking services, as well as by small businesses. In addition to this, Trillium needed to establish multiple front-end and back-end connectivity for the customers and for failover, while also having an environment that was compliant and secure according to PCI, SOC, and ISO 27001 regulatory standards, at all times. Trillium required a thorough cloud security posture management (CSPM) process to help them detect misconfigurations, encryptions and inappropriate permissions, while also ascertaining regulatory policy compliance, monitoring suspicious activities, and enabling real-time protection for the cloud. The Trianz Approach to CSPM As an enterprise with considerable experience in the areas of cloud security and CSPM, Trianz partnered with Trillium to revamp their hybrid cloud environment. Our cloud experts sat down with the Trillium team to conduct a thorough cloud security posture audit. This included discovering how and where their resources were being consumed, investigating the types of transactions that occurred on each resource, and identifying who accessed them. A Secure Pathway To Data Access Copyright © 2021 Trianz When the teams were able to procure this information and identify Trillium’s cloud security needs, the Trianz consultants leveraged Azure Security Center, Key Store, and Defender – as well as other technologies like Sophos and Checkpoint – to monitor data access activities and configure alerts that would detect suspicious behavior. With these alerts, Trillium’s hybrid cloud system would be able to automatically detect anomalies, firewall rules changes, and IP address ranges. Coupled with these upgrades, Trianz also worked with the client to perform a thorough assessment of their cloud platform misconfigurations. Now armed with a deep understanding of the issues at play, the Trianz team was able to resolve Trillium’s key cloud platform misconfigurations in such a way that they achieved 100% in Azure’s Security Benchmark, as well as hitting their regulatory compliance targets. The Technical Takeaways Along with helping Trillium obtain their goal of being fully adherent to SOC, ISO 27001, PCI, and DSS data governance policies, Trianz was able to maintain their cloud environment misconfiguration-free, along with generating regulatory reports whenever requested. Furthermore, our team was able to protect the cloud platform from data leakage by automatically blocking downloads to their infrastructure, as well as rejecting uploads of any malicious files. This was a clear step forward in terms of Trillium’s data security. Impacts to the Business Through our engagement with Trillium, we were also able to help them realize several impactful changes to their business. As a result of the increased security and higher data quality, the accuracy of insights improved, as did customer relations. Higher regulatory compliance further strengthened the company’s reputation, while simultaneously lowering incident rates and consequently, the resources and hours wasted on resolutions as well. This would also guarantee smooth, uninterrupted service delivery to customers. The hybrid cloud environment’s scalability meant that the e-wallet platform went gradually from being able to handle 300,000 transactions daily to 3 million, allowing them to onboard even more customers – whether private individuals or small businesses. All this, while remaining fully secure. Furthermore, Trillium needed their data to be fully migrated and secured in the new cloud environment within the span of a year (i.e. by July 2019). By partnering with Trianz, they were able to achieve this goal and avoid the significant financial penalties that would come with a delay. The Transformational Effects By bringing their application platform and data from a legacy warehouse into a hybrid cloud environment that met their business needs and global regulatory compliance standards, Trianz was able to help Trillium become more a more cloud-native, customer-focused, and digitally empowered organization overall. The Trianz Difference Trianz enables digital transformations through effective strategies and excellence in execution. Collaborating with business and technology leaders, we help formulate and execute operational strategies to achieve intended business outcomes by bringing the best of consulting, technology experiences and execution models. Powered by knowledge, research, and perspectives, we enable clients to transform their business ecosystems and achieve superior performance by leveraging infrastructure, cloud, analytics, digital, and security paradigms. Reach out to get in touch or learn more.

Explore
Cloud

MICRO-SERVICES MIGRATION FROM ON-PREMISE TO AWS CLOUD

The client is a leading provider of prepaid debit cards for personal and commercial use. The products are designed to be used as tools for people without a traditional bank account or who prefer to use alternative financial services. The client was looking to migrate their micro-services from on-prem to AWS Cloud with the help of the latest technologies like Docker, Kubernetes, Terraform, and other required AWS automation.The Client engaged Trianz to containerize the Microservices on AWS. THE BUSINESS CHALLENGE The client needed to build a dependable, robust and secure technology infrastructure for: Migrating the micro-services from on-prem to the cloud (AWS) Containerizing the micro-services and using Kubernetes as a container orchestration system for automating deployments, scaling and management of containerized application TECHNOLOGY COMPONENTS AWS AWS IAM Amazon VPC Amazon EC2 Amazon EC2 Elastic Load Balancing Amazon S3 Amazon EBS Amazon Route53 Amazon CloudFront Amazon CloudWatch Amazon AWS Config AWS Lambda AWS EKS AWS ECS Other Platforms: Splunk, HashiCorp Terraform, Python 2.x 3.x,  GitHub, Jenkins, Inspec Testing THE APPROACH Trianz adopted the following implementation approach in a phased manner: Understanding the existing infrastructure Migrating prospect services for Dev/QA environments from on-prem to the cloud (AWS) Containerizing the micro-services and deploying them using Kubernetes clusters built from the scratch Configuring Jenkins pipelines to build and deploy to micro-services on Kubernetes cluster TRANSFORMATIONAL EFFECTS Facilitated on-demand supply of the necessary infrastructure for Dev/QA teams to develop and test the scenarios. Users can run a Jenkins pipeline to build or deploy a micro-service, deploy the resources like S3 buckets, SNS, SQS, Lambdas, or deploy a fully functioning EKS (Kubernetes) cluster. Users can easily create, update or delete the existing infrastructure within minutes with the help of Terraform automation. Better performance with improved efficiency.

Explore
Cloud

CLOUD APP

Designing and Deploying a Secure B2C Public Cloud Platform One of the leading mobile apps based gifting merchants wanted its services to be compliant with PCI-DSS for users to make the purchases confidently using their credit cards. Business Challenge The challenge was to design, build and deploy a mobile application with stringent security features for both Android and iOS platforms that are PCI-DSS compliant. Technology Components Application level de/encryption – AWS KMS Encrypted database table data – AWS RDS Application and host level logging – ELK Stack File Finger printing – OSSEC Security Incident Management (SIM)/ Security Information and Event Management (SIEM) – OSSEC Cloud API logging – AWS CloudTrail Cloud infrastructure change audit trail – AWS Config Alert notification – AWS Simple Notification Service IP whitelisting – AWS VPC Security Group Layer 7 – Web Application Firewall Host-level firewalls – IP tables Patch management – Spacewalk Vulnerability assessment – VAPT (OpenVAS + Nessus) Data in Transit encryption HTTPS – SSL Certificates Approach Designed and deployed the cloud environment leveraging several Amazon Web Services (AWS) security services alongside multiple open source solutions to achieve PCI compliance. Engaged Business and Technology teams of the client – from initial audit to multiple re-audits. Implemented a complete CI/ CD pipeline to ensure that a blue green deployment can be achieved. Completed the engagement end-to-end from design to go-live in 16 weeks. Enforced a targeted approach for the public cloud deployment due to the nature of the platform. Transformational Effects AWS services that are PCI compliant are used to set up infrastructure. Application as well as its environment are PCI-certified. Created a secure application that can be trusted by customers to use their credit cards.

Explore
Cloud

CLOUD DEPLOYMENT

Supporting Alfresco Deployment on AWS cloud A Fortune 100 insurance company was facing challenges with its Alfresco implementation and needed to migrate the existing environment to Amazon Web Services (AWS) Cloud to enable easy document management, collaboration and support audits and compliance inquiries requirements. Business Challenge The client needed a flexible and agile AWS Cloud environment for its Alfresco implementation that improves document management and enterprise collaboration. Technology Components AWS Cloud, RHEL, Alfresco, MySQL, Elastic Bamboo, Java, SharePoint, BMC Remedy Approach Analyzed servers needed for the new Alfresco content repository at development, QA, staging and production phases. Migrated the content from Alfresco 4.2 to Alfresco 5.0.3 version on Amazon EC2 as per client’s priorities. Enhanced Alfresco internals for performance and scalability to support the migrated content types Provided application integration (Web Services APIs) support for LOB applications and third party systems. Provided two weeks of post go-live (Hypercare) support per phase and knowledge transfer to the client’s enterprise content management (ECM) support team. Transformational Effects Provided a low-cost cloud solution which complies with regulations, acts and mandates Enabled easy file sharing and collaboration Equipped the client’s systems with powerful document management features Developed and streamlined task management and workflow Provided complete IT control of security and access Provided choice of full SaaS or private AWS instance Enabled powerful metadata and full-text search features

Explore
Analytics

IMPLEMENTING SALESFORCE CRM FOR AN EMERGING PHARMACEUTICAL COMPANY

Enabling Healthcare Analytics in the Cloud Trianz was approached by an emerging pharmaceutical company that was looking to adopt Salesforce CRM. It wanted to improve field activity and prescribing activity monitoring capabilities, alongside more visibility into formulary and claim trends. Business Challenges for the Pharmaceutical Company The pharmaceutical company had no way to monitor field or prescribing activities with its partnered pharmacies. Similarly, it had no way to proactively strategize due to a lack of formulary and claim trend data. Technology Components Supplied to the Pharmaceutical Company by Trianz The pharmaceutical company was supplied with the following technology components: Microsoft PowerBI enabled visual dashboards and reports that were easier to interpret for employees in the field. Microsoft Azure was chosen as the cloud service platform, with Infrastructure-as-a-Service offerings relating to virtual machines, networking, blob storage, and disaster recovery. Microsoft SQL Server was chosen as a relational database management system. The Trianz Approach to PowerBI Configuration and Azure Architecting Trianz developed a data warehouse using the Microsoft SQL Server component. PowerBI was highly compatible with SQL Server, reducing the likelihood of future incompatibility for long-term viability. Various data sources were centralized in the data warehouse, acting as a master data repository to reconcile operational reference data. PowerBI could then access the database to deliver reports and dashboards to stakeholders and pharmaceutical employees. Transformational Effects with a New MS SQL Database and PowerBI on Azure After architecting the new cloud environment, the pharmaceutical company’s leadership team gained insight into company performance, competitor trends, and the flow of products through the delivery pipeline. This allowed for proactive strategies to smoothen supply chains, outmaneuver competitors, and manage company performance. The field sales team could now access mobile-enabled dashboards access mobile-enabled dashboards thanks to PowerBI. This enhanced capabilities in the field, improving service quality when interacting with clinicians and revealing prescribing behavior trends. Finally, sales employees were empowered to monitor their own call activity KPIs, improving motivation and productivity. Experience the Trianz Difference Trianz enables digital transformations through effective strategies and excellence in execution. Collaborating with business and technology leaders, we help formulate and execute operational strategies to achieve intended business outcomes by bringing the best of consulting, technology expertise, and execution models. Powered by knowledge, research, and experience, we enable clients to transform their business ecosystems and achieve superior performance by leveraging infrastructure, cloud, analytics, digital, and security paradigms. Reach out to get in touch or learn more.

Explore
Analytics

BUILDING A CUSTOMER SURVEY ANALYTICS DASHBOARD FOR COMCAST

Comcast Seeks Centralized Reporting System Trianz was approached by the global telecommunications giant Comcast, provider of television broadcasts, home broadband, and telephony services. Comcast was looking to build a customer survey analytics dashboard to nurture passive customers and monitor net promoter scores (NPS). Business Challenges for Comcast with Passive Customers and NPS Comcast needed help with the maintenance of extract-transform-load pipelines business intelligence within its call centers, customer experience analytics, and customer survey monitoring. This would come together in a centralized reporting system to show NPS promoter, detractor, and passive customer metrics. NPS values would also be linked back to various business operations, providing insight to guide future business strategies. Who Worked on the Project and What Were the Timescales? A specialist team from Trianz adopted the Agile methodology throughout this project. Comcast had a range of priorities across different business arms which the Trianz team had to balance. This included integrating the centralized reporting system with departmental IT systems in a staggered approach. The Agile Development Approach Used by Trianz During This Project Trianz worked with Comcast across the full development lifecycle for each dashboard. These dashboards are related to different business arms, such as the call center, and differing service offerings across broadcasting, broadband, and telephony. The Trianz team integrated numerous third-party survey responses into the centralized reporting system. This enabled a centralized view of organization-wide NPS metrics and other key performance indicators (KPIs). Transformational Effects for Comcast with its New Centralized Reporting System After project completion, Comcast had new capabilities with its centralized reporting system. Customer experience management was streamlined by greater visibility into KPIs and other metrics. Some metrics include relational net promoter scores, reliability, unique contact rates, and first call-in rates. An enterprise-wide performance dashboard was also enabled, offering a centralized view of major metrics to all business stakeholders with future trend projections. Trianz also configured eight box reports that run weekly and monthly. These unique dashboards showcase trends over a weekly and monthly basis to promote key stakeholder awareness and visibility into business performance. Experience the Trianz Difference Trianz enables digital transformations through effective strategies and excellence in execution. Collaborating with business and technology leaders, we help formulate and execute operational strategies to achieve intended business outcomes by bringing the best of consulting, technology expertise, and execution models. Powered by knowledge, research, and experience, we enable clients to transform their business ecosystems and achieve superior performance by leveraging infrastructure, cloud, analytics, digital, and security paradigms. Reach out to get in touch or learn more.

Explore
Analytics

ASSESSMENT AND CREATION OF A ROADMAP FOR MASTER DATA GOVERNANCE

Chemical Manufacturing Company Seeks MDM Framework Trianz was recently approached by a leading provider of emulsion polymers, specialty chemicals, and functional decorative surfaces. The client needed a partner to conduct a master data governance (MDM) assessment and devise a roadmap for MDM in its SAP enterprise resource planning platform. Business Challenges for the Client with SAP The client had implemented SAP around twelve years prior to engaging with Trianz. This system supported all aspects of the enterprise resource planning (ERP) process, alongside an acquired business arm from six years prior. After the acquisition, the acquired businesses’ SAP instance was not harmonized with the main SAP implementation, creating redundancies and siloed datasets that prevented holistic reporting. How Trianz Executed the SAP Integration Project for the Client Trianz started by interviewing eighteen different stakeholders across the business to identify departmental requirements, and perform root cause analysis. Both data systems were then assessed to understand data availability and determine constraints. This gave insight into how Trianz could merge the systems. Next, business use cases with specific business values were modeled to guide the harmonization process. A future-state analytical architecture was designed alongside the merging of both SAP instances, enabling new analytics and business intelligence functions across the client’s operations. A high-level roadmap encompassing all project areas was developed to provide estimates to key business stakeholders. Finally, a detailed initial project plan was developed and shared to assist with staff capacity planning, timeline estimates, and cost projections. Transformational Effects After Receiving the Roadmap The client now had a clear roadmap to implement its Master Data Governance framework, alongside a roadmap to implement new analytics infrastructure and services. Estimates contained within both roadmaps could feed into the client’s planning and budgeting exercises, managing capital expense and monetary risk. Clear business values were established across both roadmaps in specific areas, giving the green light to stakeholders with a proof of value statement. A clear methodology towards harmonizing both SAP instances was provided, offering guidance on resources, budgets, and roadmap constraints. Experience the Trianz Difference Trianz enables digital transformations through effective strategies and excellence in execution. Collaborating with business and technology leaders, we help formulate and execute operational strategies to achieve intended business outcomes by bringing the best of consulting, technology expertise, and execution models. Powered by knowledge, research, and experience, we enable clients to transform their business ecosystems and achieve superior performance by leveraging infrastructure, cloud, analytics, digital, and security paradigms. Reach out to get in touch or learn more.

Explore
Analytics

IMPLEMENTING BUSINESS INTELLIGENCE AND DATA MONETIZATION FRAMEWORKS

Global Payment Provider Seeks Customer Dashboard Experience Trianz was approached by a global payments provider that needed assistance with digitalizing data access for its customers. This would involve the creation of a business intelligence and data monetization framework, giving the client’s customers a 360-degree customer view. Business Challenges for the Global Payments Provider in Merchant Management A data monetization solution was needed targeting sales and marketing divisions in partnered retail merchants across the globe. This would provide insight on shopping trends and customer behaviors using transactional data, something which was not possible with their current system. The solution was cutting edge, and the client had aggressive timescales for project completion. The project needed to be managed in tandem with supporting the flexibility of the customer experience, platform capabilities, and technologies. Technology Components Sourced by Trianz for the Global Payments Provider Trianz sourced the following technology components to help the global payments provider achieve its project goals: Hadoop was chosen as a software library framework for distributed big dataset processing using compute resources in the cloud. The Hadoop Distributed File System (HFDS) was chosen as it can run on commodity hardware and uses the Hadoop software library to facilitate processing. Apache HBase is a Hadoop database that operates in distributed, scalable big data environments with leading real-time read/write performance. HIVE is an open-source data warehousing platform built by the creators of Hadoop. FLUME was chosen as a distributed service for collating, aggregating, and translating the location of large amounts of log data. Pentaho was chosen as a data integration and analytics solution, offering access, preparation, and analytics for all data from any source, in any environment. Oracle was chosen as the cloud distribution platform to host these components. How Trianz Approached the Data Monetization and Business Intelligence Project A specialist Trianz team established internal team responsibilities and mapped development processes. From there, the team adopted an agile development methodology due to the distributed nature of employees within. This would help orchestrate software development despite time zone differences. Next, an application framework was developed alongside a future to-be-extended service framework. This would govern how data monetization and business intelligence would operate on the network. This framework was then monitored in close alignment with customer needs, with remediation steps taken to ensure suitability for the client’s partnered merchants. An assessment of application quality and candidacy for live deployment took place, achieving a green light from key stakeholders. This was followed by management buy-in and a release phase where the system was announced across the business and to its global merchant network. Transformational Effects for the Global Payments Provider The global payments provider enhanced its engagement with merchants by offering better quality services for data access and insight generation. Trianz helped to instill new software development best practices in the payment providers internal team, assisting with any future dual-shore development models. Finally, support for multiple business models and geographic locations was enabled for the data monetization and analytics platforms. Configuration frameworks ensured that the right functionality and security rules were in place for the target merchant. Experience the Trianz Difference Trianz enables digital transformations through effective strategies and excellence in execution. Collaborating with business and technology leaders, we help formulate and execute operational strategies to achieve intended business outcomes by bringing the best of consulting, technology expertise, and execution models. Powered by knowledge, research, and experience, we enable clients to transform their business ecosystems and achieve superior performance by leveraging infrastructure, cloud, analytics, digital, and security paradigms. Reach out to get in touch or learn more.

Explore
Analytics

UNCOVERING THE BUSINESS VALUE OF DATA FOR A FORTUNE 500 P&C INSURANCE FIRM

Global P&C Insurer Seeks to Build an Enterprise Data Warehouse A Fortune 500 property and casualty firm approached Trianz to help them establish a more accurate and integrable way to organize, store, and manage its business datasets. As a global firm, its datasets were widely distributed across geographical areas and various business departments. Business Challenges Around Data Silos and Reporting The P&C client had data distributed across multiple geographies, business IT platforms, and departmental data silos. This data needed to be centralized. Reports were manually created, collated, and reconciled, leading to inconsistencies, errors, and little potential for real-time business insight into revenue and profitability. Technology Components Supplied by Trianz to Build the Enterprise Data Warehouse The team at Trianz identified technology components that aligned with project requirements for the P&C insurer: Infosphere CDC was chosen for low-impact capture and delivery of data changes for key information management initiatives. Informatica PowerCenter offered scalable, high-performance data integration functionality to centralize the client’s datasets. IBM PureData System for Analytics (PDA) is a hyperconverged data warehousing solution that accelerates analytics and business intelligence operations with dedicated field-programmable gate array (FPGA) hardware. Qlik was selected to provide visual analytical dashboards and interactive reports. Aginity was chosen as an active analytics catalog to reuse SQL queries in analytics tools. Cognos Framework and Active Reports were used to model metadata in the data warehouse, and to create active and easy-to-use reports. How Trianz Worked to Implement a Data Warehouse for the Fortune 500 P&C Client The client partnered with Trianz to develop an actionable roadmap for a data warehouse in its Personal and Business Insurance (P&BI) division. Existing data sources were assessed, mitigating risk with data from unexpected sources. This also covered existing data sources and mapping business needs to arrive at common definitions across departments. Trianz also created a data tree view for the client’s ease of use. Next, a Proof of Concept was piloted by ingesting data from a small selection of distributed data sources. Then, the enterprise data warehouse and data mart were constructed and integrated with reporting and analytics tools. This data warehouse was further developed at the late stages to integrate the client’s auto insurance arm. Transformational Effects After Enterprise Data Warehouse Implementation Trianz was able to mitigate risk by addressing data quality issues upfront for the client. Manual collation and reconciliation workflows were reduced, lowering the possibility of introducing human error. By establishing common business definitions using Aginity, the client had data and reporting consistency across regions and countries. Business users could now analyze and generate insight on revenues and profitability across all lines of business. This expanded analytics access to all employees, enabling greater awareness and productivity. Finally, a return-on-investment model was created for the data warehouse, giving stakeholders clarity on the long-term value of the new solution. Experience the Trianz Difference Trianz enables digital transformations through effective strategies and excellence in execution. Collaborating with business and technology leaders, we help formulate and execute operational strategies to achieve intended business outcomes by bringing the best of consulting, technology expertise, and execution models. Powered by knowledge, research, and experience, we enable clients to transform their business ecosystems and achieve superior performance by leveraging infrastructure, cloud, analytics, digital, and security paradigms. Reach out to get in touch or learn more.

Explore
Analytics

TERADATA TO SNOWFLAKE MIGRATION

Technology Conglomerate Seeks to Migrate from Teradata A multinational technology conglomerate needed assistance with its database services after encountering high licensing costs and performance problems. The conglomerate manufactures and sells networking hardware, software, and telecommunications equipment alongside other high-tech services and products. Business Challenges Surrounding Teradata and Database Performance The company wanted to migrate away from its legacy solution to a new modern data warehousing platform. This would involve migrating away from an existing Teradata database platform to a cloud-native Snowflake data warehouse. Teradata used a specific SQL syntax within SAP Business Objects, and the company was in the process of migrating to Snowflake. These SQL syntaxes needed to be rewritten and reintegrated to work in the new Snowflake platform. A Proof-of-Concept Design for Teradata-to-Snowflake Conversion Trianz designed a Proof of Concept to automate the conversion of SQL queries. This included five web intelligence reports contained within one centralized business objects universe. Then, a semantic layer conversion tool was used to automate SQL conversion between Teradata and Snowflake. The timeline from project commencement to completion was set at one month. How Trianz Approached Teradata-to-Snowflake Migration A team from Trianz, consisting of two Snowflake data engineers and one Business Objects architect, oversaw this project. They started by analyzing and documenting SAP Business Object requirements, designs, and business processes. This would assist with successful implementation during migration to Snowflake. Next, the Trianz EVOVE platform was used to translate SQL syntaxes into a Snowflake compatible format, before Trianz reintegrated converted syntaxes in a centralized Business Objects Universe. Around 90% of the SQL tables were automatically converted, with the final 10% requiring manual intervention by Trianz. Considering the technology client was manually converting queries, the switch saved them an immense amount of time. To validate the conversion, Webl reports were tested against the new Snowflake environment. This would ensure that reports run successfully, and that data matches in both Teradata and Snowflake. All reports were executed successfully alongside data matching checks. Transformational Effects After Migrating to Snowflake Around 75% of Business Object instances were programmatically converted to Snowflake during this project. Trianz EVOVE was a great help here, automating the conversion of more than 95% of derived tables, with six tables requiring manual conversion. Within the first week of project commencement, 40% of reports had achieved the intended result. Within a month, the entire conversion and migration process was finalized. Typically, such a process would take up to three months to complete manually. Additionally, Trianz identified seven tables outside of the project scope that could be optimized for use in Snowflake. The client could also scale up in future with five or six SAP universes, future-proofing its data operations on Snowflake. Universe Business Objects Count Converted Programmatically 460 Converted Manually 219 No Conversion Needed ~300 Total ~1900 Derived Tables Count Converted Programmatically 100 Converted Manually 6     Total 106 Break-down of Programmatic Errors Resolved after compiler fix Manually fixed items Underlying database items No issue items 245 219 35 30 Experience the Trianz Difference Trianz enables digital transformations through effective strategies and excellence in execution. Collaborating with business and technology leaders, we help formulate and execute operational strategies to achieve intended business outcomes by bringing the best of consulting, technology expertise, and execution models. Powered by knowledge, research, and experience, we enable clients to transform their business ecosystems and achieve superior performance by leveraging infrastructure, cloud, analytics, digital, and security paradigms. Reach out to get in touch or learn more.

Explore
Analytics

DATA MIGRATION AND ANALYTICS FOR A FORTUNE 500 INSURANCE CLIENT

Deploying Analytics & Reporting for Historical Data Trianz was approached by a Fortune 500 insurance company that needed assistance with large-scale professional indemnity (PI) data migration. The timeline was rapid, and strict compliance rules needed to be integrated at the architectural level to comply with auditing requirements. Business Challenges for the Fortune 500 Insurer in Data Migration The client needed to migrate voluminous datasets from its mainframe system to a modern database environment. The data consisted of historical datasets and highly sensitive PI datasets. The rapid turnaround was necessary so that the client could achieve compliance ready for imminent auditing procedures. Technology Components Sourced by Trianz for the Insurance Company Trianz identified a range of suitable technology components to achieve the project’s objectives: Microsoft SQL Server was chosen on the Azure cloud as a database solution. SQL Server Reporting Services (SSRS) was used to create, deploy, and manage paginated insight reports, accessible across the company. SQL Server Integration Services (SSIS) was used to integrate historical and PI datasets and enable data transformation functions. Microsoft .NET was used to run compiled SSRS and SSIS packages with C# code. Python was used to interface with the MS SQL database, compatible across Windows, Linux, and macOS. How Trianz Executed the Data Migration and Implemented Analytics Functionality Trianz started by developing a reusable migration assistant tool for the insurance client. This would enable automation features for creating source metadata, control files for source data analysis, and dynamic SSIS packages. End-to-end extract-transform-load (ETL) automation allowed for several heterogeneous systems to converge into one structured database. Historical data was migrated from source transactional systems built on Mainframe, SAP, and the client’s enterprise data warehouse (EDW) to a unified and scalable SQL Server database. Robust data models were created to logically group data ready for predictive analytics and other ongoing business needs. This resulted in a centralized reporting architecture that met departmental requirements across the business. Finally, MS SQL Server FileStream and FileTable enabled the integration of unstructured data relating to insurance policies and claims. These datapoints were stored as BLOBS and CLOBS in the source transactional system to enable a user interface for direct access to analytics tools. Transformational Effects for the Fortune 500 Insurer After Migration Historical data is now readily available for ongoing business needs, including in-force policy conversion, open claims conversion, and billing conversion. A unified and scalable data model allows for easy access to business information. The model supports predictive analytics, product development, underwriting, claims, distribution, operations, and billing workflows. Hierarchical data was extracted from the legacy mainframe and added to MS SQL. This enabled immediate access to data across all business departments, with a centralized reporting architecture for business intelligence operations. Experience the Trianz Difference Trianz enables digital transformations through effective strategies and excellence in execution. Collaborating with business and technology leaders, we help formulate and execute operational strategies to achieve intended business outcomes by bringing the best of consulting, technology expertise, and execution models. Powered by knowledge, research, and experience, we enable clients to transform their business ecosystems and achieve superior performance by leveraging infrastructure, cloud, analytics, digital, and security paradigms. Reach out to get in touch or learn more.

Explore
Analytics

DATA ENGINEERING, ADVANCED ANALYTICS, AND CLOUD PLATFORM DEVELOPMENT FOR A RE-INSURANCE FIRM

Creating a Single Source of Truth Using Azure Trianz was engaged by a reinsurance company to help with the development of predictive analytics applications. As part of its business, the company acquires existing books of reinsurance policies and manages claims associated with them, and they needed analytics capabilities in order to manage policy claims more effectively. Business Objectives with Predictive Analytics By developing a predictive analytics solution, the objective for the reinsurance company was to enable its legal team to detect fraudulent claims more effectively. The reinsurance firm also needed a way to predict claim settlement amounts before dues are paid, assisting with financial planning and cashflow. Finally, a new alerting system was required to proactively alert employees upon receipt of high-risk or high-value claims, ones which would require a significant cash windfall for full settlement. Data sources were mixed and siloed on the IT network. The company shared information using large documents with attachments and non-standardized file formats, creating an accessibility challenge. The reinsurance firm had no data warehouse to act as a single-source-of-truth (SSOT), leading to data credibility concerns and technical bandwidth limitations during data analysis. Most critical were the manual data input workflows, where hundreds of documents and files were manually uploaded to the system to be analyzed. No automated ingestion method existed on the reinsurance firm’s IT network. Technology Components Highlighted Trianz worked closely with the reinsurance provider to identify suitable technology components for its predictive analytics project: Azure Data Lake was chosen to act as a data repository and SSOT from which all IT resources could reference and verify the validity of data. Azure Data Factory was chosen as an extract-transform-load pipeline solution operating on an economical pay-as-you-go model. Databricks was chosen as a data management platform using the Lakehouse architecture for simpler data infrastructure operations. Azure Data Catalog was selected to store metadata relating to data sources and simplify data asset discovery. Azure DevOps was used to orchestrate agile software development, create and manage continuous integration and deployment (CI/CD) pipelines, and facilitate source control. Python is the coding language used to build the predictive analytics algorithm model for the reinsurance firm. R-Shiny is an open-source, code-first data science platform that helped with deployment of data-based web applications, referred to as Shiny Web Apps. Docker was used to host serverless containerized applications and resources in tandem with Kubernetes. Spark Natural Language Processing (NLP) was adopted to annotate conversational audio and text files with relevant metadata using machine learning (ML) and Python. DataRobot Prediction Server sits in a Docker container acting as an execution environment for DataRobot model packages (.mlpkg files). Word2vec is a technique for NLP. It consists of an algorithmic neural network that learns word associations to create meaning using cosine similarities between vectors. Jira was adopted to track issues and keep projects on track for DevOps and data science teams, using agile development methodologies. Enabling Predictive Analytics and Reducing Manual Workflows Trianz worked with the reinsurance company to recruit a team of cloud architects, data scientists, data architects, and data engineers. The team consisted of native and overseas personnel in different time zones, meaning a point of contact was always available for the reinsurance company. As part of the roadmap, Microsoft Azure technology components were developed first, forming the data science foundation for applications and datasets. The predictive analytics application was enhanced to include entity recognition, NLP, custom analytics models, and robotic process automation (RPA). Finally, a cloud-based data mart was established with production-ready data models and processes to support data querying operations, analytical reports, and data monetization initiatives. The Agile development methodology was customized to suit the reinsurance company’s needs. This supported data pipeline development, predictive analytics modelling, and CI/CD deployment and testing during the development phase. Transformational Effects of New Data Mart and Analytics After adopting the new technologies, the reinsurance firm experienced tangible transformational effects: RPA saved time and effort for the data science team by consistently and effectively automating previously manual processes and workflows. New data models enhanced scoring capabilities to improve predictive forecasting, mitigating risk, and smoothing cashflow when dealing with reinsurance claims. Entity explorer graphs were used to identify people and create relations between people, places, and business datasets. The purpose was to detect fraud and mitigate risk to the business. NLP can now drill through phone conversations, email conversations, and other datasets to proactively alert legal teams when claim numbers increase sharply and suddenly, which also serves to mitigate risk. Experience the Trianz Difference Trianz enables digital transformations through effective strategies and excellence in execution. Collaborating with business and technology leaders, we help formulate and execute operational strategies to achieve intended business outcomes by bringing the best of consulting, technology expertise, and execution models. Powered by knowledge, research, and experience, we enable clients to transform their business ecosystems and achieve superior performance by leveraging infrastructure, cloud, analytics, digital, and security paradigms. Reach out to get in touch or learn more.

Explore
Analytics

DATA WAREHOUSE FOR A GLOBAL HEALTHCARE, PHARMACEUTICAL, AND MEDICAL DEVICE MANUFACTURING COMPANY

Planning, Designing, and Development a Clinical Datamart Trianz was recently approached by a global healthcare, pharmaceutical, and medical device manufacturing company to plan, design, and develop a new data warehousing solution in the cloud. The client conducts clinical trials, storing vast swathes of personally identifiable information (PII) which must be effectively governed to adhere with regulations like HIPAA. Timely Business Challenges for the Healthcare Company The healthcare client had multiple urgent challenges relating to capturing, storing, and providing highly regulated access to datasets containing healthcare information and sensitive PII. Data analysts needed accurate, timely, and secure access to these datasets to provide reports for clinical trials, as well as submissions to regulatory authorities when obtaining medical product approval. Similarly, physicians participating in trials needed the capability to run data-mining algorithms for predictive demographic and trend analysis among patient cohorts. Technology Components Recommended Our data experts performed a full assessment of the healthcare client’s requirements before identifying an ideal mix of technology components: Oracle Database was chosen as an all-in-one cloud solution for creating and orchestrating data marts, data lakes, operational reporting workflows, and batch data processing. IBM Cognos Analytics is a business intelligence (BI) platform that supports web-based data modelling, data preparation, and analytical reports. Informatica is a data integration platform that offers products relating to extract-transform-load processes, data masking, data orchestration, and master data management. A New Data Warehouse and Improved Compliance To start, our data warehousing experts orchestrated the planning, architecting, design, and development of a new data warehouse and BI platform. This helped Trianz determine a Scope of Work in alignment with the client’s expectations and business objectives. Additionally, Trianz developed multiple task-specific data marts to simplify querying and data identification for the client’s physicians and data scientists. A data mart is best described as a room in the wider data warehouse, where each data mart is occupied by one business department. This process was expedited within an aggressive four-month period, resulting in numerous task-specific data marts for client-facing operations. Transformational Effects After Implementing a New Data Warehouse for the Healthcare Client After the expedited development of the data warehouse and supplementary data marts, the healthcare client was more than satisfied with the results. This led to the digital transformation project acting as a model to follow for future initiatives across the business—a testament to our data experts’ performance. With new data operations and orchestration tools, the client could capture, store, and provide access to highly sensitive healthcare datasets. Compliance was greatly improved within the confines of HIPAA, along with faster data querying times, reduced latency, and greater data accessibility across all business departments. Experience the Trianz Difference Trianz enables digital transformations through effective strategies and excellence in execution. Collaborating with business and technology leaders, we help formulate and execute operational strategies to achieve intended business outcomes by bringing the best of consulting, technology expertise, and execution models. Powered by knowledge, research, and experience, we enable clients to transform their business ecosystems and achieve superior performance by leveraging infrastructure, cloud, analytics, digital, and security paradigms. Reach out to get in touch or learn more.

Explore
Analytics

CUSTOMER MASTER DATA MANAGEMENT FOR A GLOBAL PHARMACEUTICAL COMPANY

Better Datasets to Improve Sales Operations Trianz was enlisted to help a global pharmaceutical enterprise develop a new customer master data management (MDM) system. This solution would cleanse and standardize customer datasets, helping the pharmaceutical company with sales operations and internal business decisions. The MDM system would also enable data monetization opportunities such as co-promotion agreements and data feeding for external partners. Challenges in Sales Ops and Data Management The pharmaceutical company was plagued by non-standardized, uncleansed, and unmerged datasets across 20 different sources. This made it impossible to create a single-source-of-truth (SSOT), leading to unfocused IT operations and data siloes across the company. Alongside these data issues, the pharmaceutical client needed an automated solution to consolidate and integrate data sources. This would eliminate excessive workflows and processes to simplify data orchestration, while enhancing data governance and IT security standards. Technology Components Identified to Enable MDM and Automation Trianz worked with the pharmaceutical company to identify suitable technology components: SQL Server 2012 Enterprise was chosen as a relational database management system. SQL Server Master Data Services was used to control master datasets and organize into data models, with rules and governance for data ingestion and querying workflows. Microsoft Data Quality Services was used to create a knowledge base for datasets and automate data integrity and quality management. SQL Server Integration Services is an extract-transform-load solution for data migration, ingestion, and integration. SQL Server Reporting Services is a server-based reporting solution compatible with SQL databases, interfaced through the Visual Studio IDE and code editor tool. QlikSense was chosen as a cloud-native data analytics platform with business intelligence (BI) and artificial intelligence capabilities. Jitterbit 5 was used as an API integration platform to infuse knowledge base entries into business processes and workflows for greater awareness. Salesforce Veeva was chosen as a customer relationship management platform, centralizing customer data, compliant content, and multi-channel engagement for sales teams. Melissa is a big data processing engine that helps companies cross-reference address details and personal identities using cloud, on-premises, and secondary data sources. Helping the Client Enable MDM and Automation Our data experts started by studying the client’s existing MDM processes to identify areas for improvement. This spanned across customer identification, field change management, incentive compensation processes, Salesforce alignment, roster management, sales forecasting and goal tracking, product roll-up, market basket definitions, market research, and external data vendor integrations. The MDM solution was upgraded, ready as a SSOT for additional data warehousing and BI tools. The new MDM solution was made to be bi-directional, enabling downstream data movement to Veeva and upstream data ingestion as one example. Data is governed throughout its entire lifecycle to adhere with strict compliance and regulatory requirements as defined and approved by the client and its partners. This applies particularly to patient confidentiality and doctors’ privacy via the Health Insurance Portability and Accountability Act. Finally, Trianz implemented the data warehousing solution alongside several interactive analytics and BI dashboards. This analytics solution cross-references the central MDM solution for validity and quality of data, ensuring insights are valid and relevant. This project took place under significant time constraints, as the pharmaceutical company needed project finalization before the approval and launch of a new product line. Transformational Effects for the Pharmaceutical Client After Adopting New MDM and Automation Technologies The implementation costs were minimized thanks to the leveraging of existing technologies, eliminating the need for expensive replacement solutions. A single master data source was created on the MDM platform, feeding all 20+ areas of the business, both internal and external. The number of manual processes across all IT data services was reduced by 90%. Partnership agreement compliance was maintained thanks to enhanced data cleansing, monitoring, and quality improvement capabilities, fulfilling and exceeding expectations for pharmaceutical partners. Regulatory compliance was simplified thanks to centralized datasets with full source lineage. A new best-in-class data architecture meant the client could scale and grow into the future without worrying about bottlenecks and technical limitations. Ultimately, the sales team had greater confidence and morale thanks to the addition of analytics and BI dashboards, elucidating hidden trends to assist with sales strategies. Experience the Trianz Difference Trianz enables digital transformations through effective strategies and excellence in execution. Collaborating with business and technology leaders, we help formulate and execute operational strategies to achieve intended business outcomes by bringing the best of consulting, technology expertise, and execution models. Powered by knowledge, research, and experience, we enable clients to transform their business ecosystems and achieve superior performance by leveraging infrastructure, cloud, analytics, digital, and security paradigms. Reach out to get in touch or learn more.

Explore
Analytics

AWS DATA ANALYTICS PLATFORM: A CASE STUDY

Accelerating Decision-Making for a Global HealthTech Provider Challenge The client whom we will call GlacierPeak is a global medical technology and digital solutions innovator, enabling clinicians to make faster, more informed decisions through intelligent devices, data analytics, applications, and services. When the pandemic outbreak hit, GlacierPeak’s digital transformation process was accelerated by implementing an agile culture, work and organizational philosophy based on collaboration, and iterative processes oriented to providing quality solutions to serve changing customer needs. They were looking to build a highly available, scalable, resilient data analytics platform for their various teams based in Europe and the US. The platform must be fault-tolerant, secure, and compliant with the company and industry standards. They also saw an opportunity to invest in infrastructure automation to eliminate manual process-related errors and scale the applications to equip them for future on-demand growth to manage changes in real-time. At the same time, to address problems caused by monolithic applications, they wanted to leverage containers to build a microservices architecture for faster automation, scalability, availability, and fault tolerance. Our Approach Working with GlacierPeak, our team first focused on learning more about their existing needs and operating processes. Our goal was to replace as many repetitive tasks as possible through DevOps and by building continuous integration and continuous delivery (CI/CD) workflows to deploy Amazon Web Service (AWS) cloud components, which can automate the entire lifestyle of the infrastructure deployment. We identified automation opportunities and created a complete roadmap with a business case illustrating the potential economic impact. Once the identified processes were approved, we seamlessly synchronized the implementation of systems software configuration/patching automation pipelines to adhere to the firm’s compliance and security controls. To enable GlacierPeak to enhance security access permissions for the AWS Simple Storage Service (S3) buckets – the object storage built to store and retrieve any data from anywhere - we implemented the auto-remediation of public access using AWS Lambda with Amazon config and CloudWatch events. Integration with Prisma Cloud further complemented cloud governance, compliance, and security. The team continued to focus on continuous innovation and improving existing processes while exploring new trends and solutions. We implemented a tool called New Relic for infrastructure and application monitoring for GlacierPeak. Transformational Effects Within a few months, through automated IAC (infrastructure as a code), GlacierPeak’s teams were able to manage the entire cloud Infrastructure and systems configuration and deploy various platform environments across geographies. The CI/CD pipelines that we built using GitHub, Jenkins, and Terraform to provision the infrastructure, now eliminate manual, error-prone creation of cloud resources within minutes instead of hours and achieve repeatable infrastructure provision. Our decision to implement specific management tools like Azure Bastion to run containers prompted GlacierPeak to adopt more suitable tools and services for the new container framework. They also saw significant operational excellence through automated system patches, cloud resource monitoring, and automated ticket assignments to their platform in case of threshold and metrics deviations. Perhaps, the most notable outcome of Trianz engagement has been the overall security through organization and department segmentation with multi-factor authentication using GE OneIDM Single Sign On (SSO) for least privilege access for developers using distribution lists. As all the tools were integrated with GE OneIDM SSO, the firm could manage security access using Lightweight Directory Access Protocol (LDAP) groups. Automation also reduced costs and improved efficiency by auto-scaling groups and network implementations to handle spikes in traffic and snapshots, as well as leverage advanced metering infrastructure (AMI) to tackle immediate deployment or disaster recovery issues. Now, as a more efficient organization, GlacierPeak can engage its application teams to educate them on the cost analysis using reports extracted from AWS offerings like Trusted Advisor and Cost Reports/Explorer. Additionally, they can leverage chargeback by tagging resources with specific tags by team or project and use confluence pages to record the findings and action items. We also trained their teams on the usage patterns and downsizing AWS resources for potential cost savings. Today, GlacierPeak is focused on accelerating its search for new ways to better serve customers, with a focus on continuous improvement. Experience the Trianz Difference Trianz enables digital transformations through effective strategies and excellence in execution. Collaborating with business and technology leaders, we help formulate and execute operational strategies to achieve intended business outcomes by bringing the best of consulting, technology experiences and execution models. Powered by knowledge, research, and perspectives, we enable clients to transform their business ecosystems and achieve superior performance by leveraging infrastructure, cloud, analytics, digital, and security paradigms. Reach out to learn more.

Explore
Analytics

ENTERPRISE DATA MANAGEMENT AND REPORTING PROGRAM FOR A MEDICAL CENTER

Medical Center Seeks Strategic Planning Support for an Enterprise Data Management and Reporting Program A non-profit medical center sought help for the strategic planning and implementation of an Enterprise Data Management (EDW) platform, along with supplementary analytics and reporting functionality. The medical center’s previous data warehouse (DW) and analytics reporting solutions were not fit for purpose, leading to multiple challenges in generating insight and accessing data. Challenges With Data and Analytics for the Medical Center The existing reporting and analytics environment had numerous limitations due to the age of the underlying infrastructure and software packages. The medical center needed a complete redesign of its data warehousing (DW) and business intelligence (BI) tools. It also required a brand-new enterprise resource planning (ERP) solution to be installed, coordinated alongside DW and BI installations. Finally, EPIC CarePATH is a specialist solution that needed to be integrated with Oracle cloud infrastructure. What Was the Medical Center Looking to Achieve? By replacing the aging data warehouse and business intelligence solutions, the medical center would gain more throughput with analytics and reporting. The old solution was bottlenecked, forcing employees to wait for insight while the data warehouse environment responded to queries. Newer business intelligence tools opened an avenue for more targeted insight and greater value extraction from existing datasets. This would help guide business decisions, allowing the non-profit meet business objectives. Technology Components Used by the Medical Center on Oracle After consultation and implementation, the medical center leveraged the following technology components: Oracle DB was used as a healthcare database solution due to schema-agnostic storage support, allowing for diverse and differing datasets in a centralized repository. Business Objects allowed the medical center to store and comprehensively tag all types of assets, such as insurance policy documents, medical records, and purchase orders within the Oracle DB environment. It also supports object relations to expedite database querying and data-matching. Clarity was enabled to facilitate bi-directional e-commerce integration on both Software-as-a-Service (SaaS) cloud platforms and on-premises environments. EPIC CarePATH was used to integrate and streamline modern healthcare workflows with cross-data-source querying. SAP Crystal Reports was the reporting solution of choice as it supported the offloading of data processing workloads to remote datacenters whenever usage peaked, with real-time report generation and sharing. How Did Trianz Implement These Technologies for the Medical Center Client? Trianz worked closely with the medical center’s IT team to plan, strategize, and manage the data and analytics for the digital transformation project. This included devising a work plan, determining business and technical requirements with iterative release scheduling, the provisioning of ETL pipelines, and data application architecting. The workforce was educated on best-of-breed data warehousing tools and architectures, while developing techniques to move forward with an enterprise strategy and implementation plan. Trianz defined specific requirements for the data warehouse information system, data architecture, and technical database operations. A range of database types were integrated as part of the data warehousing platform, including conceptual, logical, and physical. A high-level redesign of extract-transform-load processes in and out of the data warehouse environment brought efficiency and reliability improvements to data procedures and any reliant programs. Business Objects was upgraded to XI R2 for its latest features and security improvements. Finally, a User Group and Advisory Board were created to assist with the implementation and roll-out of the enterprise data warehouse across all departments. Transformational Effects and Business Impacts After the digital transformation, the medical center experienced tangible real-world benefits. User self-service was enabled, directly tackling growing database support requirements across the business. Company adherence with HIPAA regulations was streamlined thanks to governance frameworks built into the data warehouse ruleset, essentially automating data governance. Standardized reporting templates and data visualization capabilities enhanced insight generation across all modalities. Online paperless reporting reduced the medical center’s carbon footprint and paper usage, while improving usability and shareability with other employees. Custom reports were reduced with pre-defined and approved templates taking their place. These report templates are contained within a catalog for ease of access. Data bandwidth, response times, and data integrity were improved thanks to faster processing times, lower I/O latency, and more stringent validation both in-transit and at-rest for data packets. Experience the Trianz Difference Trianz enables digital transformations through effective strategies and excellence in execution. Collaborating with business and technology leaders, we help formulate and execute operational strategies to achieve intended business outcomes by bringing the best of consulting, technology experiences and execution models. Powered by knowledge, research, and perspectives, we enable clients to transform their business ecosystems and achieve superior performance by leveraging infrastructure, cloud, analytics, digital and security paradigms. Reach out or get in touch to learn more. ×

Explore
Cloud, Analytics

CENTRALIZED ENTERPRISE DATA REPOSITORY FOR A PACKAGING AND SHIPPING SUPPLIES PROVIDER

Accelerating Business Efficiency with a Centralized Enterprise Data Repository Trianz was approached by a packaging and shipping supplies provider based in North America. The client wanted to combine siloed data repositories into a single-source-of-truth (SSOT) to promote data integrity, validity, and accuracy. Business Challenges for the Shipping Supplies Provider with Data Management The client was dealing with data siloes across the business, meaning there was no SSOT to derive insight from. This created inconsistency between departments as they used analytics and business intelligence (BI) tools to generate insights, leading to inaccurate insights that negatively impacted business decision-making. To resolve this, the client needed a new centralized enterprise data repository that combines these siloed datasets into a SSOT. This would improve capabilities around data validity, verification, and integrity monitoring, leading to more accurate data and more accurate insight from analytics and BI tools. Technology Components Selected for the Shipping Client by Trianz After a comprehensive assessment of the shipping client’s IT infrastructure and services, Trianz selected the following technology components: Informatica was chosen as an end-to-end data operations platform for data engineering, integration, governance, and quality assurance processes. SQL Server was used as a relational database management system (RDBMS), chosen for integrations and live connector optimizations with PowerBI. Lastly, PowerBI was chosen as a Microsoft ecosystem solution for BI operations, including analytics, dataset unification, visualizations, and more. How Trianz Helped the Shipping Supplier to Build a SSOT and Transform Analytics and BI Operations Our data experts started with asset discovery and analysis to formulate an end-to-end picture of business IT systems and services. This helped with the identification of appropriate technology components, ensuring compatibility and integrability. From here, Trianz took control of data operations and systematically optimized the architecture for high availability, accuracy, and validity. The target was operational availability 24 hours a day, 7 days a week as part of a 99.9% uptime service level agreement. Next, existing data models were simplified to assist with downstream analysis. These models could then be used across the business to generate insights with greater efficiency. Trianz collaborated with the client’s IT department to standardize business IT applications and services, and transform IT and data governance frameworks. This would prevent unauthorized data access and improve data security as the same rules could now be applied holistically. Finally, Trianz worked within Informatica to centralize structured datasets on SQL Server. This included the configuration of optimized data connectors between SQL Server and PowerBI to streamline analytics and BI data operations. Transformational Effects After Building a New SSOT for the Shipping Client Now, the client could generate holistic, 360-degree analytical overviews of various business operations to derive insight for use in business decisions. This improved the quality of decisions, directly impacting the top and bottom line. Statutory reporting timescales were shortened significantly, improving awareness across the business in relation to mandatory government information-sharing requirements. Data availability was greatly improved alongside workforce trust in the validity and accuracy of datasets. This meant the business had access to quality data sources with sharp turnaround times when submitting queries. Experience the Trianz Difference Trianz enables digital transformations through effective strategies and excellence in execution. Collaborating with business and technology leaders, we help formulate and execute operational strategies to achieve intended business outcomes by bringing the best of consulting, technology expertise, and execution models. Powered by knowledge, research, and experience, we enable clients to transform their business ecosystems and achieve superior performance by leveraging infrastructure, cloud, analytics, digital, and security paradigms. Reach out to get in touch or learn more.

Explore
Analytics

FLEXIBLE ANALYTICS IN TABLEAU FOR LOGISTICS CLIENT

Real Estate Logistics Company Seeks Dynamic Visualized Analytical Dashboards Trianz was approached by a real estate logistics client that needed assistance with visualized analytics. The client needed dynamic visualized analytical dashboards to replace an aging 100+ page PDF document that had become more of a hinderance than a help. Business Challenges for the Real Estate Logistics Company The client was storing earnings preparations in a 100+ page PDF document, which every employee and stakeholder had access to. This meant answers to questions were not readily available during public presentations. The real estate logistics company needed to replace this PDF solution with a flexible and adaptable data visualization analytics platform. This would enable faster queries compared to the PDF document and lower the barrier of entry to analysis thanks to visual dashboards and charts. Technology Components Selected by Trianz After consulting with the real estate client, Trianz decided on the following technology components: Tableau was selected as an analytical reporting and visualization tool. This would allow stakeholders and employees to take structured data, visualize it, and share insights with colleagues. AWS Virtual Cloud Servers were chosen to provide virtual machines in the cloud that could be interfaced with using Denodo, acting as compute nodes for analytical querying workflows. Snowflake was chosen as a data warehousing and data lake solution. Denodo Virtualization technology enabled data abstraction, integration, and virtualization in partnership with AWS Virtual Cloud Servers using Snowflake as a data repository. How Trianz Helped the Real Estate Logistics Client to Enable Visualized Analytics in Tableau Trianz started by condensing the 100+ page PDF source file into a 3-tab dynamic analytics dashboard. This allowed teams to evaluate multiple metrics across multiple dimensions, geographies, and timeframes, greatly improving the depth and breadth of generated insights. Next, operating parameters were established to enable employees to create dynamic dashboards that can move vertically through data hierarchies. Data availability was greatly improved using Snowflake, easily surpassing the previous PDF solution. Transformational Effects After Replacing PDFs with Tableau Visualizations After adopting Tableau and Snowflake, the real estate logistics company’s stakeholder team could generate more valuable insights around company performance, competitor trends, and product flow through the delivery pipeline. The field sales team had new access to a remote-friendly PowerBI solution, enabling mobile visualization dashboards that helped sales personnel to monitor key performance indicators relating to call activity. Experience the Trianz Difference Trianz enables digital transformations through effective strategies and excellence in execution. Collaborating with business and technology leaders, we help formulate and execute operational strategies to achieve intended business outcomes by bringing the best of consulting, technology expertise, and execution models. Powered by knowledge, research, and experience, we enable clients to transform their business ecosystems and achieve superior performance by leveraging infrastructure, cloud, analytics, digital, and security paradigms. Reach out to get in touch or learn more.

Explore
Analytics

DATA VIRTUALIZATION USING DENODO

Data Virtualization Using Denodo for Multi-National Logistics and Real Estate Client Trianz teamed up with a multi-national logistics and real estate investment company to modernize its data warehousing platform. The aim was to help the client scale and cater to growing business needs, enabled by on-demand virtual data models in Denodo. Challenges for the Logistics and Real Estate Company in Data Operations The client had numerous business departments which needed reliable, real-time access to datasets. Data sources were diverse and varied, complicating any attempts to integrate data and form a single-source-of-truth. This logistics and real estate company wanted a quick turnaround on development, and for the new solution to eliminate the need for excess data replication and extract-transform-load processes. They also wanted a self-service option to further reduce workloads for data and IT personnel. Technology Components Identified by Our Experts After assessing the current state of its infrastructure and project requirements, Trianz and the client agreed on the following technology components: Denodo is a data virtualization platform that provides agile, high-performance data integration and abstraction services with zero data replication as-standard. Snowflake is a cloud data warehousing and data lake platform that supports pay-as-you-go (PAYG) billing and high-throughput raw data processing. AWS Lambda is a serverless platform for compute operations that runs software processes with zero provisioning for a minimal IT operations management (ITOM) burden. Informatica Intelligent Cloud Services (IICS) is a cloud data integration service that supports synchronization, replication, and the mass ingestion of datasets. Tableau was chosen as a data visualization and business intelligence platform, creating more valuable insights by converting raw data into visual dashboards and scorecards. How Trianz Helped the Logistics and Real Estate Client Meet its Data Objectives There were three primary pillars to the approach taken by our data experts. First is the Canonical Building Blocks Model. This constituted the building of a reusable, consistent, and governed accessibility layer using the Denodo Logical Data Warehouse, Data Catalog, Embedded Metadata and Row-level Security. Second is a Data Science Toolkit. Denodo uses a microservices architecture—this allowed our experts to develop HTTP data inputs and data API outputs, alongside data caching parameters. As a toolkit, the client could use this in the future to develop on-demand data analytics models. The third and final pillar is the Pipeline-based Deployment Model. We used Terraform to automate data ingestion and loading, building CI/CD pipelines to connect back to Snowflake and AWS Lambda. Denodo Config Backup was adopted to reduce routine downtime, enable effective configuration management, and streamline disaster recovery operations. Transformational Effects for the Logistics and Real Estate Client with Denodo Virtualized building blocks in Denodo were targeted to well-documented business areas for faster analysis, insight generation and return on investment. Other business areas included as definitions were established. On-demand data models reduced initiation times for analytics projects, reducing the time needed to generate insight. This also helped with the development of API-based models and faster go-to-market. CI/CD pipelines streamlined data orchestration for the client. The end-state was one-click data deployment in Denodo with streamlined upgrade processes, a centralized configuration management database (CMDB), and auto-scaling of data and compute resources in Snowflake and AWS Lambda. Experience the Trianz Difference Trianz enables digital transformations through effective strategies and excellence in execution. Collaborating with business and technology leaders, we help formulate and execute operational strategies to achieve intended business outcomes by bringing the best of consulting, technology expertise, and execution models. Powered by knowledge, research, and experience, we enable clients to transform their business ecosystems and achieve superior performance by leveraging infrastructure, cloud, analytics, digital, and security paradigms. Reach out to get in touch or learn more.

Explore
Digital Apps

STREAMLINING IT OPERATIONS FOR A REAL ESTATE INVESTMENT COMPANY

Real Estate Firm Seeks IT Infrastructure Modernization Trianz was approached by a US-based tier 1 real estate debt and equity investment client that needed assistance with its digital transformation initiative. The company had a dependence on physical documentation and manual workflows, which was leading to duplicated efforts for employees and data inconsistencies during data entry. Business Challenges for the Real Estate Client with Manual Processes and Paper Documents The firm was struggling to communicate with external clients due to its aging email system not being fit for its purpose. Employees similarly could not collaborate on client work, as emails went to individual inboxes rather than shared inboxes accessible by the entire department. Paper documentation was leading to knowledge access problems, and the client lacked a content management system (CMS) to host any converted documents. Inconsistent datasets meant that business intelligence workflows were outputting inaccurate insights. This reduced visibility into the deal lifecycle for the client and led to misinformed investment decisions based on poor insight. Technology Components Suggested by Trianz for the Real Estate Firm After consultation, Trianz identified the following technology components for the client: ASP.NET was chosen as an open-source framework for creating web applications and services using .NET and C# programming languages. SharePoint was chosen as an internal CMS to host files, documents, and facilitate collaboration between team members using intranet services. Custom Controls were also established and implemented due to the sensitive nature of real estate communications and sales processes. How Did Trianz Streamline IT Operations for the Real Estate Client? Trianz started by implementing a centralized business process management system. This new system captured pertinent data across deal submissions, deal funding, and other sales workflows to streamline the deal lifecycle. Next, digitalized workflows were introduced as a framework for administration teams. This assisted with real estate loan management workflows from inception through to completion. SharePoint hosted a new documentation repository. This involved the conversion of paper documents to digital formats. Then, employees could use search functions to find policy documents and similar, with extended sharing capabilities to communicate digital documents with external parties. Digitalized calculators were introduced using ASP.NET, helping the client to accurately estimate costs and revenues when working with external parties. This assisted with deal lifecycle management and improved accuracy when calculating yields. Employees could also access this calculator easily thanks to a web application architecture that is compatible with all devices. Finally, an online self-service portal was created to assist borrowers. The client’s customers could now access historical and current financial statements. Similarly, stakeholders had a centralized view of all statements, improving risk management and chase-up procedures. Transformational Effects for the Real Estate Client After Digital Transformation After Trianz completed the project, manual processes were eliminated, improving accuracy during data entry and overall process efficiency. Stakeholders and employees had greater visibility into the status of each transaction throughout the deal lifecycle. This allowed for proactive measures such as follow-ups, chasing payments, and nurturing prospective customers to drive up sales numbers. Similarly, the capacity to handle deals increased for the client. It could handle more transactions at once without additional human resources, and new deals could be acquired and processed more quickly in the new system. Stakeholders had a new centralized and unified view of all real estate operations, leading to more predictive action and risk mitigation thanks to greater insight and awareness. This also improved the quality of decisions relating to investments. Finally, new collaboration features enabled the client to share documents and communicate with external parties in a digital-first manner. This streamlined communications and improved response rates, expediting deal closures. Experience the Trianz Difference Trianz enables digital transformations through effective strategies and excellence in execution. Collaborating with business and technology leaders, we help formulate and execute operational strategies to achieve intended business outcomes by bringing the best of consulting, technology expertise, and execution models. Powered by knowledge, research, and experience, we enable clients to transform their business ecosystems and achieve superior performance by leveraging infrastructure, cloud, analytics, digital, and security paradigms. Reach out to get in touch or learn more.

Explore
Digital Apps

PART NUMBER AUDITING SYSTEM FOR DATA STORAGE COMPANY

Proactive Part Number Monitoring A leading data storage company in the US approached Trianz for help with a part number auditing system. The client wanted to automate this part number auditing process with robotic process automation (RPA) technology to reduce manual workloads and the prevalence of human error. Business Challenges for the Data Storage Company with Part Number Auditing The client’s part number creation process spanned across numerous disparate systems with different stakeholder owners for each. Products were also being made available before part numbers had been uploaded to the auditing system, namely due to cumbersome manual processes rather than automated auditing. Technology Components Suggested by Trianz for the Data Storage Company Trianz decided on the following technology components for the data storage company: UIPath was selected as a robotic process automation (RPA) vendor, as it streamlines processes, uncovers efficiencies, and provides insights to help with automating workflows. A number of existing software application were automated using UIPath, including Lotus Notes for email and an Agile to SAP migration. How Trianz Approached the Part Number Auditing Project for the Data Storage Company A specialist team from Trianz identified the manual steps involved in the data storage company’s end-to-end part number auditing process. During this phase, Trianz highlighted the business benefits and estimated returns on investment (ROI) with the RPA solution to business stakeholders. Next, an outreach program took place to communicate the benefits of RPA to all departments and educate employees. Finally, a pilot scheme to test automation playbooks was created within ten days. This offered a proof of concept for stakeholders reflecting the value of the technology and approach. Transformational Effects for the Data Storage Company After adopting the new RPA solution, the data storage company experienced reduced cycle times by over 80% in their part number auditing system. This was driven by improvements to accuracy through the omission of manual human input to the system. The solution resulted in fewer missed or late part orders, as a reactive audit process was now possible using RPA. Experience the Trianz Difference Trianz enables digital transformations through effective strategies and excellence in execution. Collaborating with business and technology leaders, we help formulate and execute operational strategies to achieve intended business outcomes by bringing the best of consulting, technology expertise, and execution models. Powered by knowledge, research, and experience, we enable clients to transform their business ecosystems and achieve superior performance by leveraging infrastructure, cloud, analytics, digital, and security paradigms. Reach out to get in touch or learn more.

Explore
Digital Apps

CENTRALIZED CRM FOR LIFE INSURANCE PROVIDER

Partner Centric Sales Driven with Centralized CRM Trianz was tasked with helping a Fortune 100 life insurance provider that works with individuals and families of all income levels and backgrounds. They are predominantly an asset management firm, helping individuals and families manage their asset portfolios. Challenges for the Life Insurance Provider in Sales Operations The life insurer had multiple sales channels operating simultaneously, including third-party distribution and agency sales & services channels. Due to this complexity, the system was struggling to process workloads consistently and efficiently. The life insurance provider needed a single, centralized platform to manage all sales goals and daily targets. With multiple source systems, converging these environments would be difficult due to the customized extract-transform-load (ETL) processes it uses — in addition to the 900+ end users heavily reliant on this service-system across the entire business group. Technology Components Trianz identified and implemented the following technology components to help the Fortune 100 life insurer reach its IT objectives: Salesforce.com (SFDC) is the sales operations platform of choice, enabling customer relationship management (CRM), sales orchestration and subscriptions, marketing automation, sales and customer analytics, and custom app hosting or development. Informatica is an enterprise cloud data management platform powered by artificial intelligence. It was chosen as a centralized data warehousing solution, with stringent data governance and risk management, automated data discovery and preparation, large-scale analytics using serverless compute, and centralized 360-degree elucidation of business data operations. Data Interfaces were created specifically for Simple Object Access Protocol (SOAP) and Representational State Transfer (REST) request fulfillment. This was particularly useful for data integration and orchestration between Salesforce and Informatica. How Trianz Helped the Life Insurer to Enable Digitalized Sales Operations and End-to-End Data Orchestration Due to the scale of the project, our data experts identified digital champions across the business to assist with development and project support. This coincided with key stakeholder meetings to garner support for the sales and data digital transformation project. Next, a scalable team structure was established. Knowledge assets across all sales processes were documented and centralized in a knowledge base. A new dedicated team was onboarded with the help of our data and sales experts, educating personnel to use the new system with competence and confidence. A governance model was established to protect data security and comply with regulations like PCI-DSS and GDPR — an essential measure considering the 900+ end users on the platform. The engagement model was transformed to accommodate the new technologies, adhere with service level agreements (SLAs) and prioritize support for business-critical customers. Finally, a distributed support team was deployed to enable 18-hour, 6-day per week customer support globally. Transformational Effects with SFDC and Informatica The new system offered predictable delivery and continuous engagement with potential customers: a key target for the digital transformation project. This greatly improved platform adoption for the life insurance company. As the new system was future-proofed in terms of both technicality and capability, multiple business departments were confident to adopt and utilize the new system in their daily operations. Rather than custom solutions, Trianz stuck to an out-of-box-experience (OOBE) in Salesforce and Informatica. This meant the business could rely on the new platform’s long-term existing functionality, rather than perpetuating a cycle of redevelopment and troubleshooting with custom solutions. Experience the Trianz Difference Trianz enables digital transformations through effective strategies and excellence in execution. Collaborating with business and technology leaders, we help formulate and execute operational strategies to achieve intended business outcomes by bringing the best of consulting, technology expertise, and execution models. Powered by knowledge, research, and experience, we enable clients to transform their business ecosystems and achieve superior performance by leveraging infrastructure, cloud, analytics, digital, and security paradigms. Reach out to get in touch or learn more.

Explore
Digital Apps

24/7 APPLICATION AVAILABILITY FOR P&C INSURANCE PROVIDER

Enabling 24/7 Application Availability for a Property and Casualty (P&C) Insurance Provider Trianz was asked to manage a corporate application suite for a property and casualty insurance services provider. The client’s Enterprise Technology Services (ETS) needed a digital transformation to enable 24/7 availability and reliably high-performance despite a high number of globally distributed internal stakeholders and external users. Challenges for the P&C Insurance Provider in Request Management and System Stability The client was encountering system stability challenges that required constant software updates. This resulted in persistent downtime as applications were taken offline for updates. There was no standardized approach to request management, leading to complicated user requests with excessive follow-up communication. Responsibility for upstream and downstream systems was stakeholder-dependent rather than documented and divided among the workforce. Stakeholder unavailability meant this people-dependent approach was unsustainable. Frequent system errors, outages, and failures led to unavailability, unreliability, and poor quality of digital service delivery. Technology Components Recommended by Trianz for the P&C Insurance Provider Trianz worked closely with the P&C insurance provider to identify suitable technology components: An existing 50+ enterprise applications and 15+ technology solutions were active on the corporate IT network. These applications and technologies needed reconfiguring and integration to achieve reliable 24/7 operations. Java, Mainframe Modernization, Oracle Human Resources, Informatica, Documentum Captiva, UNIX, and Linux were major technology areas to adapt and adopt. How Trianz Enabled 24/7 Application Availability for the P&C Insurance Company To start, Trianz created virtual processes to enable enterprise-wide workflow automation. A full assessment of existing technologies and applications allowed our application performance management experts to systematically identify and develop targeted improvements. This included a high number of permanent fixes, improving on earlier recurrent temporary fixes. For problems that could not be immediately resolved, repeatable workarounds were identified and modelled to improve customer satisfaction when requesting support. The new technology platforms were integrated with the ETS. This included Informatica to streamline enterprise cloud data management, and OpenText Documentum to centralize and create a single-source-of-truth for corporate content assets. A metric-driven framework was developed to accurately measure successes and failures in real time on the ETS. Finally, iterative functions were added to promote competency in regular tasks. Transformational Effects for the P&C Insurance Provider with 24/7 Application Availability The client was pleased that total cost of ownership for the ETS was significantly reduced. Customer satisfaction rose considerably due to better system uptime, service level optimization, and faster incident resolution times. Customer experience was also streamlined as a result. Incident resolution playbooks improved clarity and consistency in remediation efforts, both automated and manually executed by IT personnel. Generally, processes were simplified to improve service maturity and impact while minimizing process overhead on the ETS. Experience the Trianz Difference Trianz enables digital transformations through effective strategies and excellence in execution. Collaborating with business and technology leaders, we help formulate and execute operational strategies to achieve intended business outcomes by bringing the best of consulting, technology expertise, and execution models. Powered by knowledge, research, and experience, we enable clients to transform their business ecosystems and achieve superior performance by leveraging infrastructure, cloud, analytics, digital, and security paradigms. Reach out to get in touch or learn more.

Explore
Digital Apps

A WEB-BASED CASH LOGISTICS DEVELOPMENT CASE STUDY

Web-Based Cash Logistics Development for a Cash Logistics Company Trianz was enlisted to help an armored car transport, ATM servicing, currency and coin processing company with its business IT applications and cybersecurity. Specifically, our custom development experts built a centralized web-based cash logistics system to streamline data management workflows for the client. Challenges for the Cash Logistics Company in Data Management The cash logistics company was encountering problems with data management, data retrieval, and database operating costs. It was leveraging an end-to-end solution called oneSystem but the solution was not meeting business requirements. As a replacement, the client wanted a centralized data management system that all business departments could use simultaneously. New Technology Components for the Cash Logistics Company Trianz worked to implement these technology components for the cash logistics company: .NET Framework was used in tandem with C# (C-sharp) to develop the web application within the ASP.NET framework. This included .NET Framework Data Providers to interface with the database solution. Oracle Database 10g was the database solution of choice. It supports enterprise grid computing, offering the cash logistics company great flexibility and cost reductions compared to other database solutions. How Trianz Helped the Cash Logistics Company to Build a Centralized Data Management System Our data experts started with software development, creating a web-based cash logistics system using the .NET Framework and C# under the ASP.NET web application development framework. This enabled the creation of dynamic real-time services for data ingestion and retrieval. Data itself was loaded into Oracle Database 10g, an enterprise grid computing solution that offers superior flexibility and cost-savings when running web applications. It creates large modular storage pools in the cloud, distributing data with a focus on throughput, latency, and cost reductions. Trianz started with a waterfall development approach, developing a plan of action and sticking to it. From here, our data experts observed that the scope of work was wider than planned, which led them to shift to an agile development methodology. In a span of two years of development, Trianz presented a production-ready version of the product to the cash logistics company. During this time, our experts also trained system users. The project was finalized with a dedicated Offshore Development Center. Its purpose was to orchestrate engagement with development and delivery teams, and the logistics company itself. Transformational Effects with the New Data Management System and Oracle After project completion, the client possessed automated cash logistics information processing on Oracle 10g. It could manage data operations using the ASP.NET web application from anywhere with an internet connection. Sensitive account details for the client’s customers and partners were protected by new data governance policies and encryption both in-transit and at-rest. Further protection was enabled with Role-Based Access Controls, preventing unauthorized access to datasets. In summary, the client’s aging system from 2004 was replaced by Trianz, who became its Technology Partner of choice. This ongoing partnership means development work continues to maintain and improve upon the data management system, via our data experts. Experience the Trianz Difference Trianz enables digital transformations through effective strategies and excellence in execution. Collaborating with business and technology leaders, we help formulate and execute operational strategies to achieve intended business outcomes by bringing the best of consulting, technology expertise, and execution models. Powered by knowledge, research, and experience, we enable clients to transform their business ecosystems and achieve superior performance by leveraging infrastructure, cloud, analytics, digital, and security paradigms. Reach out to get in touch or learn more.

Explore
Digital Apps

AUTOMATION CENTRAL FOR HEALTHCARE INSURANCE PROVIDER

Healthcare Insurance Provider Seeks to Develop a Center of Excellence for Robotic Process Automation A leading healthcare insurance provider in the U.S. was looking to develop a Center of Excellence for their existing Robotic Process Automation (RPA). Their intention was to drive consistent results across digital IT applications and services using automation rules, thereby reducing IT support workloads. What Was the Healthcare Insurer Looking to Achieve? The RPA Center of Excellence sought to resolve issues with automation playbook rules for greater consistency and accuracy. The playbooks would lead to greater efficiency and productivity within the confines of pre-defined automation rulesets, helping the healthcare insurer process more tasks daily. Challenges for the Healthcare Insurer’s RPA Center of Excellence The healthcare insurance company used an unfocused robotic process automation (RPA) process to drive multiple efforts across different business departments. Automation playbook rules were not standardized, resulting in unfocused and detrimental workflow executions, with little consistency between departments. The result was a great deal of manual work after automation had taken place, negating the benefits of RPA itself. Technology Components Used for the RPA Center of Excellence Trianz explored the following technology components to determine the best solution for the healthcare insurer client: Varying Robotic Process Automation Solutions were assessed for congruence with the healthcare insurer’s automation objectives, including players like BluePrism, Automation Anywhere, and UIPath. Everything on its cloud network needed to interface with the RPA solution, enabling centralized automation orchestration. Application Technology Automation was configured to enable direct connections from web users to the server mainframe, specifically including .NET and Java technologies used for its digital insurance services. How the Trianz Approach Upgraded the Healthcare Insurer’s RPA Capabilities Trianz RPA experts started by identifying high-priority automation pathways that would have the most significant business impact. This involved engagement across all business modalities, determining the insurer's return on investment (ROI) with internal Trianz calculators. Trianz established best practices and client-specific scenarios for different business contexts to streamline operations and configure and test continuous deployment capabilities. As part of the RPA Center of Excellence, an outreach service was established to share knowledge and enhance the adoption of RPA across all business areas. This also provided a centralized body to govern automation playbook rules, driving greater consistency. Transformational Effects and Impacts After implementation, the healthcare insurance provider had a Center of Excellence for Robotic Process Automation (RPA). This allowed them to research and develop new approaches well into the future, innovating on automation with a dedicated and centralized repository for relevant data and playbooks. The healthcare insurer increased its bot deployment numbers to scale and grow its operations using the Center of Excellence for RPA, increasing productivity and throughput. Finally, the solution helped the healthcare insurer experience zero business disruptions or delivery gaps after adopting a centralized approach to automation. This is because tried-and-tested scenarios were already saved, providing a solid foundation to adapt and test new automation rules with full compliance and security protection. Experience the Trianz Difference Trianz enables digital transformations through effective strategies and excellence in execution. Collaborating with business and technology leaders, we help formulate and execute operational strategies to achieve intended business outcomes by bringing the best of consulting, technology expertise, and execution models. Powered by knowledge, research, and experience, we enable clients to transform their business ecosystems and achieve superior performance by leveraging infrastructure, cloud, analytics, digital, and security paradigms. Reach out to get in touch or learn more.

Explore
Analytics, Digital Apps

IMPLEMENTING A MICROSERVICES-POWERED, MULTIPLATFORM REPORT ENGAGEMENT APPLICATION

Trasers Seeks to Provide Clients with Interactive and Collaborative Experiences in Real-Time With a need to develop a comprehensive digital reporting platform, Trasers, one of the world’s most extensive research services dedicated to the field of digital transformation decision support, was looking to provide a digitally immersive, interactive, and collaborative report viewing experience for its clients. What Was Trasers Looking to Achieve? The research firm required an immersive, digitally advanced multiplatform state-of-the-art report engagement and report viewing platform to support its growing client base and meet increasing demand. To achieve these goals, Trasers was interested in building a secure, AI-enabled chatbot application that would interact with its users when accessing and purchasing research reports. In addition, this application would enable users to request custom research requirements aligned to the report topics found on the Trasers platform. The multiplatform aimed to help Trasers achieve a highly secure and scalable solution while providing more significant user contribution via survey participation, offline connectivity, real-time reporting, and smoother search functions. To strategically implement the appropriate solutions, the company partnered with AWS and Trianz’s team of analytics experts to build a microservices architecture for faster automation, scalability, and availability. How the Trianz Approach Upgraded Trasers’ Solutions Architecture Trianz’s consultants sat down with Trasers’ leadership to understand their unique business needs and challenges before collaborating with the AWS product team on the ideal solution. Then, after conducting workshops with business and IT stakeholders, Trianz deployed an Amazon S3 intelligent data lake and BDM-MDM suite, which integrated various data sources to produce the Trasers reports. Trasers Solution Architecture Trianz then identified survey and customer analytics solutions to create a set of reusable custom visualizations that could integrate into an open architecture. Once the identified processes were approved, Trianz’s team of analytics experts seamlessly synchronized the implementation of Checkbox, Qlik Sense, SPSS, and Alfresco to offer Trasers consistent, visually appealing, and differentiated reporting services. Ubercart was implemented along with the cloud-based conversational AI service, LUIS chatbot, to support several payment gateways. This increased the performance of the core application and enabled custom machine-learning intelligence to predict overall meaning and pull out relevant, detailed information for customer orders and technical support. Finally, after the application was deployed on AWS cloud, Trasers web, mobile, and desktop apps were validated against security vulnerabilities using Nessus Professional 8.0 and Burp suite. Trasers Deployment Architecture — AWS Cloud How Trianz Helped Trasers Realize Their Business Goals Trasers’ engagement with Trianz enabled them to leverage an intuitive, user-friendly, and smooth report reading experience. With advanced search functionalities, clients were provided with faster insights into multiple industries and business functions on a digitally immersive platform. They also achieved their key goal of enabling users to interact securely with their reporting services through an AI chatbot and connect with the Trasers user community to get responses from fellow community users. As Trasers also engaged with Trianz and AWS as a managed service provider, the team delivered a platform that allowed users to interact with reports and perform multiple functions in real-time. In addition, users can now access interactive reports in online and offline modes where their actions are synced up the moment they establish connectivity. The Transformational Effects and Impact With the new microservices-based architecture, the client realized a spike in productivity due to the inherent features like content negotiation, authentication, scaffolding code, and other methods to provide more efficient connections. This enabled Trasers to prioritize accelerating its search for new ways to serve customers better, focusing on continuous improvement. Thanks to the omnichannel access and streamlined checkout process, user experience improved, interactions became seamless and secure, and Trasers general audience and user base increased. Experience the Trianz Difference Trianz enables digital transformations through effective strategies and excellence in execution. Collaborating with business and technology leaders, we help formulate and execute operational strategies to achieve intended business outcomes by bringing the best of consulting, technology expertise, and execution models. Powered by knowledge, research, and perspectives, we enable clients to transform their business ecosystems and achieve superior performance by leveraging infrastructure, cloud, analytics, digital, and security paradigms. Reach out to get in touch or learn more. ×

Explore
Digital Apps, Cybersecurity

ENRICHED AND SECURED USER EXPERIENCE

A global leader in the security and protection industry was interested in digitizing their B2B customer interactions to improve their customer experience, increase revenue, and reduce the cost of both, infrastructure maintenance and administration. By not having an intuitive system in place, the company’s customers were experiencing inconsistent interactions and turning to other sources. The client partnered with us to build self-service portals and region-specific marketing sites. A responsive design allowed the company to provide a seamless user experience and further integrate their content management system. A user management system and SSO with multi-factor authentication was enabled to secure access across devices and locations. We also facilitated infrastructure sizing, consolidation and hosting for multiple countries with seamless monitoring, logging, and reporting. Finally, analytics were employed to track customers, interactions, and marketing metrics while improving overall Customer Experience. The Business Challenge Customers around the globe were experiencing inconsistencies on the client’s websites and portals while authentication processes provided only limited accessibility. This combination of issues resulted in pileups of unresolved issues and spikes in service calls. Technology Components Liferay, Oracle, Okta – SSO, BizTalk, Dynatrace (monitoring, logging, and reporting), Apache Ant, Eclipse, Liferay MVC portlet The Approach Developed geo-specific marketing portals leveraging content management system Hosted environment in a centralized Liferay 6.2 for seamless experience Enabled application integration including complex workflows Used federated identity management for secure access Build portal interface using ESB pulling information from downstream systems Developed responsive design to support access from multiple devices Built real-time reports and analytics Transformational Effects Redesigned online interactions improved user experience, increasing daily site visits by 30%. The number of help desk calls was reduced 60%, dropping the number of expired credentials tickets by 90%. 25% lower infrastructure costs paved the way for new technology like instant alerts for suspicious activity.

Explore
Digital Apps

E-GOVERNMENT PORTAL

e-Government authority in the Middle East required a large scale e-Governance platform that enables citizen self services. Received best m-Government service award from Prime Minister of UAE Shortlisted for the United Nations Public Service Awards (UNPSA) Awards THE BUSINESS CHALLENGE Government to Citizen: To provide information focusing content on city details, rules, jobs, education, recreation public safety etc. Government to Business: To provide information on economic development, trade regulations and licenses, tax rules, business grants and loan schemes Government to Government: Providing information on, state data, economic development plans, disaster management & public safety norms, response management Internal Efficiency to Effectiveness: Using best practices in government operations – supply chain, HR documentation flow, Finance management TECHNOLOGY COMPONENTS Filenet, Documentum, Liferay, SharePoint , Data Migration, Data Analytics, Creation of Content Stores, Managing Content Stores THE APPROACH Developed a success measurement metrics framework that focuses the execution team on its mission Analyzed internal and external variables that impact the e-Government implementation cycle Representation of the future state covering client’s e-government capabilities, processes, delivery channels, technology infrastructure and organizational models. Developed execution strategy and plan, incorporating contingencies, decision making framework, team structure and governance model. Mobilize technology and process re-engineering team and execute based on selected plan to deliver prioritized capabilities Review success of the initiative based on adoption and performance improvement

Explore
Digital Apps

CASE STUDY: A CUSTOM BI DASHBOARD AND DATA ANALYSIS TOOL

Improved Access Through Digital Tools A global payments and technology company (we’ll call them Transactive) envisioned a digitization of their client’s access to data through a business intelligence dashboard and data analysis tool. Transactive was projecting to implement and release the tool within an aggressive time frame, so that merchants could be provided with parametrized reports, customized settings, and several other capabilities with little interruption to service. Trianz came aboard as Transactive’s development and implementation partner, helping them create and launch a platform that provided an appealing, flexible experience supported by a robust, streamlined technological framework. Thinking Under Time Pressure Due to the accelerated time frame of delivery established by Transactive, the Trianz team had to modify our process. Since the window was narrowed by their requirements, our experts could not exhaustively document the performance of each phase of the process. Modifying our usual rigorous design process, our team iteratively developed prototypes of the dashboard and tools, testing each version to continuously incorporate user feedback. Keeping Transactive’s limited timeline in mind, the team first clearly outlined and established team responsibilities and processes for smooth overall progress. In order to have our agile methodology functioning optimally, we engaged our global workforce in the development process to ensure there were no gaps in continuity and rapid results. Leveraging both client and server technologies to ensure high performance in data-intensive cases, Trianz experts were therefore able to quickly build the application frameworks as well as further, to-be-extended services. Throughout the process, we leaned into our capabilities with .NET, HTML5, JSON Newtonsoft, Tableau, and Microsoft Azure to develop Transactive’s state-of-the-art customer experience dashboard. The Triumph of Transformation Thanks to Trianz’s multitiered approach comprising of clear communication, project management, and delivery assurance processes, the applications were thoroughly aligned with client and stakeholder needs. While delivering an application that delivered competitive advantage was important to us, we also ensured that the tools would adapt quickly to industry verticals, remain compliant with regulations, and maintain system security throughout. By taking special care to create a robust back-end, end users were able to enjoy a dashboard application that was reliable, functional, and intuitive. Product changes were also consistently tracked without impact to the timeline. The final versions of the business intelligence tools were rolled out well in time, and under budget, to boot. Business Intelligence Outcomes The transformative effects of the applications were numerous. To begin with, merchants obtained greater access to their data and insights, enhancing their overall engagement with Transactive as a company. Another important milestone was that software development best practices were instilled, especially regarding multiple-site engagement in the process. And finally, the application was able to accomplish the delicate, important task of providing support for multiple business models and geographic locations through its configurations. Experience the Trianz Difference Trianz enables digital transformations through effective strategies and excellence in execution. Collaborating with business and technology leaders, we help formulate and execute operational strategies to achieve intended business outcomes by bringing the best of consulting, technology experiences and execution models. Powered by knowledge, research, and perspectives, we enable clients to transform their business ecosystems and achieve superior performance by leveraging infrastructure, cloud, analytics, digital, and security paradigms. ×

Explore
Digital Apps

24X7 PRODUCTION SUPPORT FOR ENTERPRISE APPLICATIONS

A large diversified P&C insurer based in US recognized the complexity in managing Legal and Compliance Applications with constantly changing laws and Regulations. Trianz was engaged to provide 24x7 Production Support for all the critical legal and Compliance applications. THE BUSINESS CHALLENGE Client was facing challenge in managing 13 critical corporate legal and compliance applications that needs support 24x7. Reduced budgets in the past 2 years reduced ability to meet service levels. And, increased feature changes and additions due to constantly increasing and changing laws and regulations TECHNOLOGY COMPONENTS J2EE, Informatica, Teradata, Sybase and Oracle Databases, Windows and LINUX Servers THE APPROACH Application Management IT Infrastructure Management Database Migration Advisory Consulting   24x7 Levels 1, 2 and 3 Support of 13 independent applications of varied technologies   Stringent service levels and security requirements   Serviced a user base of 20000 across North America   Development activities included planned enhancements and ad-hoc change requests   Managed weekly, monthly and quarterly releases   Teradata, Oracle and Sybase Database Management   Windows and LINUX Server Administration   Interface with Network Administration team   Migrated Online applications’ databases (9) from Sybase to Oracle   Migrated Reporting databases (7) from Sybase to Teradata   Sybase to Oracle and Teradata Migration Assessment   Application Portfolio Rationalization

Explore
Digital Apps

INTRANET PORTAL DEVELOPMENT FOR FULL-SERVICE RESEARCH AND EVALUATION FIRM

A North American full-service research and evaluation firm, working to create social and health solutions to serve underserved populations globally, needed a cost-effective and scalable intranet portal. THE BUSINESS CHALLENGE Lack of an internal communication channel was hampering information dissemination and collaboration | Absence of centralized space for document management was creating knowledge silos Unavailability of single entry point for applications and personalization, infrastructure, IT and budgetary freedom TECHNOLOGY COMPONENTS Liferay 7 DXP, Apache, Java, jQuery, JavaScript, AJAX Tomcat 7.0 ,MySQL 5.6,Jenkins,SSL, AWS - S3, Clustering, Adobe Creative Suite. THE APPROACH Adopted Show and Tell Approach to provide end-state view to business users Deployed Liferay 7 DXP Portal Infrastructure on Amazon Cloud (FedRAMP?) to enable responsive web design Developed intranet portal for employees and clients | Enabled knowledge and information exchange on scalable and secure architecture capable of personalization Integrated DevOps platforms/ tools identified and leveraged by client with cloud deployment Enabled monitoring, logging, reporting exception, error handling capabilities Conducted performance tests, user training workshops | Made training/ user manuals and videos available Extended support for infrastructure and portal post implementation TRANSFORMATIONAL EFFECTS Increased employee satisfaction and engagement | Improved participation among citizens and communities Enabled multiple integrations and an unified view for employees and clients Reduced time taken to publish updates Brought response time of a page to < 3 seconds Enabled usability across multiple platforms – PCs, mobiles, tablets

Explore
Infrastructure

BUILDING A CENTRALIZED ENDPOINT MANAGEMENT SOLUTION FOR A MANAGED SERVICES PROVIDER

Managing All Servers, Desktops, and Laptops Within a Single Console Trianz was approached by a managed services provider (MSP) that wanted to build an endpoint management system. As part of the FinTech 100, this client represents the best in financial technology implementation and managed service provision. Business Challenges for the FinTech Managed Services Provider With hundreds of clients and dozens of servers to manage with each client, the managed services provider needed a way to automate server patching and security management workflows. Disparate tools were in use, creating inconsistencies between different managed service plans delivered to each client. This complicated reporting and implementation procedures and did not support automation resulting in manual patch updates. How Trianz Built a New Centralized Endpoint Management Solution Trianz worked with the managed services provider by conducting workshops to educate personnel on new automation tools. Then, a plan was created to deploy automations in a phased manner according to the managed service provider’s customer requirements. IBM BigFix Patching was implemented to convert manual patch processes into tried-and-tested automation playbooks. Realize Orchestration is a modern workflow automation platform that was combined with BigFix to create new virtual machines on-demand with up-to-date software and security patches. A new process for detecting the host operating system vendor was designed and implemented, helping the managed service provider to deploy the right updates to the right environment. By automating the orchestration of new virtual machines, the managed service provider could deliver the latest software patches at a much faster rate than previously seen with its manual build processes. A new software distribution automation solution was created containing fixlets, or software management scripts. This allowed automated fixlets to conduct installations, updates, and uninstallations without human intervention. Transformational Effects for the Managed Services Provider with a New Automated Patching Solution The managed services provider now has a centralized and automated solution that can patch all servers, including operating systems and installed applications. It is now possible to orchestrate updates and view servers through a unified management console, greatly simplifying client endpoint management for the MSP. This led to efficiency improvements in patch deployment, software deployment, and server automation, promoting higher standards of managed service provision to its customers. Newly built servers were also covered with an automated approach for server updates, including Sophos virus definition updates, pattern updates to heuristically detect malware, and agent updates. Experience the Trianz Difference Trianz enables digital transformations through effective strategies and excellence in execution. Collaborating with business and technology leaders, we help formulate and execute operational strategies to achieve intended business outcomes by bringing the best of consulting, technology expertise, and execution models. Powered by knowledge, research, and experience, we enable clients to transform their business ecosystems and achieve superior performance by leveraging infrastructure, cloud, analytics, digital, and security paradigms. Reach out to get in touch or learn more.

Explore
Infrastructure

PREDICTIVE ANALYTICS TO ASSIST WITH IT OPERATIONS MANAGEMENT FOR A DATA CENTER PROVIDER

Global Data Center Provider Seeks to Forecast Incidents and Generate Trend Reports Trianz was approached by one of the world’s largest data center and co-location service providers. The company provides fast compute services for application performance, low latency network routes worldwide, and a digital ecosystem of financial, content, media, and enterprise cloud networking services. Business Challenges for the Global Data Center Provider The client lacked visibility into problematic infrastructure components as part of its IT operations management strategy. This meant it could not gain any insight necessary to guide infrastructure capacity expansion plans with its current monitoring solution. In action, this led to a high number of IT incidents which negatively impacted business service availability. It also could not proactively forecast incidents and event trends, leading to a reactive remediation approach that lowered overall service quality. Technology Components Installed During the Project by Trianz for the Client Trianz implemented the following technology components for the client project: R System and Kaggle were used to enable QA testing, advanced analytics, machine learning, and data science workflows. This was needed to build statistical models for the client. PowerBI was used as a data visualization layer for interactive dashboards and reports relating to IT operations management metrics and KPIs. IT Operations data was merged, centralizing data from numerous monitoring tools in a single unified location for ease of reporting. How Did Trianz Approach the Predictive Analytics Project? Trianz conducted workshops with business and IT stakeholders to understand critical inter-departmental challenges relating to IT operations management and infrastructure visibility. Sample data was then collated from numerous monitoring tools to provide insight on how to configure the new predictive analytics solution. Data preparation took place alongside data cleansing within a Proof-of-Concept environment, showing the value of the new predictive analytics solution ready for stakeholder approval. Then, three statistical models were created—ARIMA, Negative Binomial and Zero Inflation — to assist the client when predicting IT operations management incidents. Next, data correlations were formed based on the Pearson Correlation Coefficient to derive linear relations between each cloud IT system. Kaggle was then integrated with Microsoft PowerBI to enable interactive and visual dashboards that could be accessed on desktop and mobile. Finally, the completed solution was presented to key stakeholders across the business. Transformational Effects for the Global Data Center Provider Following this initiative, the global data center provider could forecast incidents and generate trend reports relating to IT operations management processes on its global server network. It could also proactively forecast disk usage, network utilization, and memory usage when planning capacity expansions on its network. Network events and IT incidents were continuously analyzed to generate patterns and trends, providing visibility and insight for future IT network improvements and mitigation efforts. Finally, incident and event correlation offered unprecedented insight into the relationships between servers, networking equipment, software, and other areas. Experience the Trianz Difference Trianz enables digital transformations through effective strategies and excellence in execution. Collaborating with business and technology leaders, we help formulate and execute operational strategies to achieve intended business outcomes by bringing the best of consulting, technology expertise, and execution models. Powered by knowledge, research, and experience, we enable clients to transform their business ecosystems and achieve superior performance by leveraging infrastructure, cloud, analytics, digital, and security paradigms. Reach out to get in touch or learn more.

Explore
Infrastructure

TRANSFORMING AUDITING PROCESSES WITH SERVICENOW GRC

Client Seeks to Promote Auditing Transparency, Accuracy, and Accountability Trianz was approached by a client that was looking to streamline its auditing processes. It had already identified ServiceNow GRC as a suitable candidate and needed assistance in implementing, configuring and launching the solution on its IT network. Business Challenges for the Client in Auditing, Governance, and Regulatory Management The client wanted to empower its internal auditing teams by developing a single, centralized governance risk compliance (GRC) platform. This platform, hosted on ServiceNow, would help the audit team to plan and execute engagements, collaborate with other departments, view audit report findings and monitor enterprise-wide compliance against requirements outlined in HIPAA and PCI-DSS 3.0. Before, the existing GRC system lacked transparency and accountability. There was also a lack of time tracking functionality, reporting capabilities, and historical data access. Finally, the client wanted its manual dependencies replaced as they were increasing the duration of audit executions. Technology Components Implemented by Trianz for the GRC Project Trianz implemented the client’s requested technology components: ServiceNow was introduced as a foundation, offering future expandability with its workflow optimization and orchestration features. ServiceNow Governance Risk Compliance (GRC) was the focus, improving business resilience with real-time GRC visibility, greater productivity with auditing procedures, and tools to streamline stakeholder risk communications. How Did Trianz Install ServiceNow GRC for the Client? First, a specialist team at Trianz conducted interviews with key stakeholders across the business. The focus was on process owners so that Trianz could understand current GRC processes, controls, sources, and exemptions. From here, the team identified internal and external Active Directory policies, controls, and exemptions to determine the current state of governance, risk, and compliance on the IT network. Next, profiles were created for specific scenarios helping to establish risk and compliance indicators and govern role-based access controls. Finally, auditing processes were assessed and mapped, allowing audit findings to be closed automatically using automation playbooks. Transformational Effects After Adopting ServiceNow GRC for the Client After adopting ServiceNow GRC, the entire GRC process was automated, offloading manual processes from the auditing team to drive productivity. Audit engagements and executions could be performed within a centralized system rather than department-specific repositories, improving risk and compliance awareness. The internal auditing team reduced the time spent on managing audits by 50%. GRC workflows benefitted from greater transparency and accuracy, with analytics and reporting functions enabling accountability monitoring relating to process compliance. The client could now access real-time dashboards for various processes and compliance workflows. Process compliance was automated with findings being supplied within familiar employee workflows, reducing manual processing requirements. Improvements to processes and tighter GRC worked together to eliminate a number of redundancies and exemptions, streamlining auditing procedures. Experience the Trianz Difference Trianz enables digital transformations through effective strategies and excellence in execution. Collaborating with business and technology leaders, we help formulate and execute operational strategies to achieve intended business outcomes by bringing the best of consulting, technology expertise, and execution models. Powered by knowledge, research, and experience, we enable clients to transform their business ecosystems and achieve superior performance by leveraging infrastructure, cloud, analytics, digital, and security paradigms. Reach out to get in touch or learn more.

Explore
Infrastructure

IMPLEMENTING AN ENDPOINT INVENTORY TO INCREASE BUSINESS PROFITABILITY

Healthcare Systems Provider Seeks a Modern Endpoint Inventory Solution A leading integrated healthcare delivery systems provider approached Trianz as it was struggling with poor infrastructure discovery processes. It also had imperfect application affinity mapping, causing a lack of awareness and visibility into IT system and software dependencies. Business Challenges for the Healthcare System Provider in Infrastructure and Application Visibility The healthcare delivery systems provider needed a modern endpoint inventory solution to overcome its problems with infrastructure discovery and application affinity mapping. A lack of infrastructure visibility makes it difficult to understand how their servers, networking equipment, and client devices worked together. Similarly, application affinity mapping was needed to organize ideas and insights related to software used by the provider during service provision. The objective was to accurately assess the impact of critical incidents, as these incidents were leading to a loss in transactions and general business engagement numbers. Technology Components Selected by Trianz to Map Dependencies and Assist with Discovery Trianz chose a selection of targeted solutions that would help the client meet its objectives: Tivoli Application Dependency Discovery Manager (TADDM) was chosen for its excellent automated infrastructure and application dependency mapping capabilities. Tivoli Asset Discovery for Distributed [TAD4D] monitors for distributed hardware assets, software assets, and metadata from software applications on the network. BigFix Inventory acted as a centralized repository to store software and metadata asset information, improving network security and preparing the client for future auditing procedures. How Trianz Implemented New Discovery and Dependency Mapping Tools for the Client Trianz started by developing an execution roadmap for the project, outlining processes and prioritizing implementation stages to meet the client objectives and adhere to project timescales. From here, Trianz conducted workshops so business and IT stakeholders could better understand the business challenge, and how the new solution would impact existing processes and workflows. Next, all existing processes, tools, integration points, and data sources were assessed to ensure they were compatible with the new technology solutions introduced through the project. This was also an opportunity to remove dead weight with redundant or inefficient IT solutions. An architectural design for TADDM was created, including five secondary storage servers and 14 discovery servers to uplift network visibility. This would enhance discovery capabilities and provide redundancy if one or multiple discovery servers were to go offline. A new standardized method for processing incidents and service requests was discussed with stakeholders before being implemented across the entire business. This reduced service desk workloads and improved response and remediation times. New monitoring solutions were installed with a focus on reducing event noise and duplicate incidents. The monitoring solution also tracked operational efficiency across software products. Transformational Effects After Implementing Discovery and Dependency Tools The client was able to migrate from TAD4D to BigFix Inventory, enabling bundled rules and software exclusions for more targeted discovery processes. Application performance and health monitoring was initiated through application affinity mapping functions in TADDM, providing valuable insight into IT performance. The accuracy of sub-capacity reporting in BigFix Inventory increased, improving invoicing processes. The new discovery tools collectively identified thirty-three thousand servers and forty-five-thousand network components, with automated weekly refresh cycles to keep the asset list updated. Business processes and workflows were optimized and improved, and customer satisfaction increased measurably for the healthcare systems client. This was possible while still reducing operating costs through a carefully executed metric-based improvement approach. Scan errors were reduced from relatively high numbers, all the way down to an incidence rate of less than 3%. Finally, administration and support processes were streamlined to optimize day-to-day engagements between the client and healthcare service users. Experience the Trianz Difference Trianz enables digital transformations through effective strategies and excellence in execution. Collaborating with business and technology leaders, we help formulate and execute operational strategies to achieve intended business outcomes by bringing the best of consulting, technology expertise, and execution models. Powered by knowledge, research, and experience, we enable clients to transform their business ecosystems and achieve superior performance by leveraging infrastructure, cloud, analytics, digital, and security paradigms. Reach out to get in touch or learn more.

Explore
Infrastructure

ENTERPRISE MONITORING AND MANAGED SERVICES FOR LARGE HEALTHCARE DELIVERY ORGANIZATION

Challenges for a Healthcare Consortium Trianz was engaged by a big-three managed healthcare consortium in the US who at that time had over 7,000 beds, 209,000 employees, 21,250 physicians, and 39 medical centers in operation. 700 full-time IT support engineers managed its IT infrastructure. Manual Process Management, Siloed Data and Tools The healthcare consortium was using manual processes at-scale on its IT network. This resulted in long waits – often three days in duration – to resolve critical IT incidents. Furthermore, a backlog of over 1000 work requests indicated an overworked IT department. The healthcare client had multiple tools in-use and siloed data repositories, leading to a lack of centralization and integration. This included configuration management databases (CMDB), and incident logs. A lack of consistency between departments led to difficulty diagnosing and remediating first-time incidents, with no notes or logs to reference if the problem reoccurred. IT staff were perpetually reactive, fighting fires rather than extinguishing the fuel source. This prevented proactive measures such as process improvement, knowledge management, and remediation playbook creation. Business Objectives: Customer Satisfaction, Reduced Manual Processes, and Healthier Infrastructure The healthcare consortium approached Trianz to achieve the following business objectives: Achieve greater customer satisfaction by reducing the number of manual workflows and operations on the network. This would ensure the timely remediation of incidents in adherence with committed service level agreements (SLAs). Increase capabilities around reporting and visibility with SLA metrics. Eliminate the aging backlog of IT support requests with a combination of remediation and incident redundancy solved by wider system and service improvements. Reduce the prevalence of human error with manual tasks. This would involve the digitalization of workflows and processes, enabling consistent remediation through automation runbooks. Integrations would also be stress-tested, redeveloped, and monitored to reduce incident prevalence. Recommended Technology Components Trianz worked with the healthcare consortium to adopt new technologies and redevelop old services and systems: A new centralized Event Management System (EMS) was created consisting of IBM Netcool for network event management, BMC Remedy for IT service management events (ITSM), and ServiceNow as the centralized integration and orchestration layer. IPSoft was implemented to enable auto-remediation based on events in the EMS. IBM Tivoli enabled self-healing using machine learning (ML) to proactively remediate first-time incidents and escalate a service request only if remediation required human intervention. Correlation rules were developed within IBM Netcool to de-duplicate system events, reducing event noise and fatigue among IT personnel. Custom automation logic for IPSoft was developed to meet business objectives as defined in Scope of Work (SoW) documents. This also supported continuous ongoing development of automation scripts and playbooks. Automating Processes and Reducing Incident Prevalence Trianz worked closely with stakeholders, conducting workshops to identify problems employees were experiencing with current IT processes and tools. Desired outcomes were established and used to guide the digital transformation project. A future-state of architecture and end-state visualization was supplied to promote stakeholder buy-in, showing the benefits of the new integrated solution. The IT support desk was supplemented by temporary employees, including Trianz employees and re-assigned client employees, to reduce the backlog of past system incidents. Infrastructure monitoring and management was delivered as a managed service, offloading IT operations management (ITOM) workloads from the IT department to prevent backlogs from recurring. Transformational Effects for the Healthcare Consortium As a result, the mean-time-to-remediation for incidents was greatly reduced, ensuring the healthcare consortium could maintain adherence with all business SLAs. The backlog shrank by 91% over the course of five months, thanks to a combination of managed service offloading and streamlined incident responses. Overall workforce efficiency was improved approximately 20%, improving service quality and the overall customer experience (CX). Experience the Trianz Difference Trianz enables digital transformations through effective strategies and excellence in execution. Collaborating with business and technology leaders, we help formulate and execute operational strategies to achieve intended business outcomes by bringing the best of consulting, technology expertise, and execution models. Powered by knowledge, research, and experience, we enable clients to transform their business ecosystems and achieve superior performance by leveraging infrastructure, cloud, analytics, digital, and security paradigms. Reach out to get in touch or learn more.

Explore
Infrastructure

TRANSFORMING BUSINESS AND IT OPERATIONS

Transforming Business and IT Operations via Large-Scale Public Cloud Migration Trianz was approached by a Fortune 500 global insurance company that sought to migrate the majority of its business applications and infrastructure workloads to the public cloud. Business Challenges for the Fortune 500 Insurer in Process and Data Orchestration The client was using inconsistent manual processes to input data, and this data was spread across numerous siloed data repositories at the department-level, and more widely across country borders. With data spread across multiple platforms and geographies, manual collation and reconciliation led to inconsistency in datasets, reducing the accuracy and validity of real-time revenue and profitability insights. Technology Components Selected by Trianz for the Fortune 500 Insurance Company After close collaboration with stakeholders and business departments, Trianz decided on the following technology components: Informatica PowerCenter was chosen as a scalable, high-performance solution for data integration and data lifecycle management. IBM PureData System for Analytics (PDA) was chosen as an advanced data warehousing and analytics operations solution. Qlik was chosen as a visualized data analytics solution to enable the creation of interactive, visually represented reports and dashboards. Aginity works as a data catalog for analytics workflows, enabling the reuse of SQL code to return tried-and-tested query results faster. IBM Cognos Framework Manager was chosen to create collective business models using metadata derived from various singular data sources. Cognos Active Reports was chosen to supplement business intelligence workflows with interactive reports containing data insights. How Trianz Helped the Fortune 500 Insurer to Eliminate Manual Processes and Transform Visibility Trianz started by identifying business use cases, as well as assessing the complexity and value of migration to the cloud for each use case. Next, our data experts defined a conceptual cloud architecture that would meet business and IT objectives on the AWS cloud. Then, migration prioritization took place, ensuring low-effort and high-value migration milestones were prioritized first for a faster return on investment. After this, data analysis took place to generate profiles for each geographic area and line of business. During this process, workshops took place to facilitate decisions and agreements on common definitions between business department stakeholders and select digital champions. Finally, a proof of concept was developed for two specific, high-priority countries. After validating the concept, it was then expanded to ten other countries. Transformational Effects After Eliminating Manual Processes and Improving Data Visibility Trianz finalized the project with a roadmap established around business use-cases and incremental development work on AWS. The client would use this as guidance to maintain and upgrade the platform in the future. A return-on-investment model was also created for the global enterprise data warehouse in IBM PDA. By eliminating manual processes, the client mitigated data quality risks proactively to improve the value of its datasets. Business definitions established in Aginity guided operations across countries and departments, promoting analytical consistency. Finally, business users were now able to analyze and unearth insights on revenue and profitability in congruence, regardless of country or department—a critical milestone in the project. Experience the Trianz Difference Trianz enables digital transformations through effective strategies and excellence in execution. Collaborating with business and technology leaders, we help formulate and execute operational strategies to achieve intended business outcomes by bringing the best of consulting, technology expertise, and execution models. Powered by knowledge, research, and experience, we enable clients to transform their business ecosystems and achieve superior performance by leveraging infrastructure, cloud, analytics, digital, and security paradigms. Reach out to get in touch or learn more.

Explore
Infrastructure

INFRASTRUCTURE ANALYTICS AND AIOPS ON BMC CLOUD

Business Service Health Monitoring and Event Correlation to Minimize MTTR Trianz worked with a global insurance provider to enhance its infrastructure analytics and AI-powered remediation capabilities in the cloud. The insurance provider delivers services and products to individuals, families, and corporate customers worldwide. Challenges for the Insurance Provider with Cloud Visibility The insurance provider was struggling with excessive mean-times-to-repair (MTTR) incidents on its network. Gaining visibility into business service health and co-dependent services was difficult, and manual thresholds and rule-based alerts were not fit for purpose. This led to event noise and inefficient IT operations management (ITOM). The client used a diverse multi-cloud architecture but lacked cross-cloud insight, leading to a lack of infrastructure visibility. Trianz was enlisted to build an IT Operations (ITOps) platform with intelligent monitoring algorithms, which would reduce the client’s service incident levels using data-driven analytics and AI remediation playbooks. This would bridge the current multi-cloud canyon, centralizing monitoring for the entire IT network and reducing the mean-time-to-detect (MTTD) incidents through better data correlation. Technology Components Trianz worked with the insurance provider to implement the following technology components: BMC Cloud was used to orchestrate the insurance provider’s multi-cloud IT environment. This included cross-cloud spooling of IT resources, ingesting and centralizing monitoring data, cost management, dependency mapping, inventory management, as well as independent software vendor (ISV) relationship and licensing management. Splunk ITSI was included to enable IT Service Intelligence (ITSI) for the insurance provider. This solution enabled end-to-end service visibility and streamlined incident resolution using real-time event correlation, automated incident prioritization, predictive analytics, and other ITSM orchestration tools. How Trianz Helped the Insurance Provider to Enable Multi-Cloud Analytics and Insight on BMC with Splunk Trianz started by conducting workshops across all business departments, helping key stakeholders to understand the present IT challenges and the plan-of-action to remediate using BMC and Splunk. From here, our infrastructure experts prototyped a solution using the requested technology components before seeking feedback from the insurance provider. After approval, the system was developed further. Sample operations data was collected across numerous monitoring solutions to develop correlation policies for event de-duplication. This eventually constituted a custom algorithm for incident and event correlation, developed in-house by Trianz for the insurance provider’s specific business context. Next, Splunk ITSI was integrated with the BMC multi-cloud platform to enable the collection and analysis of event and incident data, removing IT silos in the process. Visualized dashboards in Splunk enabled customizable monitoring and alerting, accessible by employees on device, or deployable to TV displays for greater IT awareness. Finally, the completed system was stress-tested to demonstrate the final incident prediction model, which uses historical events and trends to proactively predict IT incidents. Transformational Effects The insurance provider experienced tangible transformational effects after adopting the new BMC Splunk platform. To start, root cause analysis (RCA) was greatly simplified and much more efficient. This enabled the insurance provider to quickly and competently remediate IT problems using AI, analytics, and system log data. Anomaly detection acted as a safety net for un-predictable IT events, while the proactive incident remediation algorithm automated a large percentage of incident response workflows. This freed up time for the IT department without sacrificing IT service quality. A centralized, consolidated view of critical key performance indicators (KPIs), server metrics and business service health metrics led to greater awareness, faster incident responses, and a better understanding of the correlation between service health and underlying systems. Historical trends, patterns, and problem areas were tracked and archived, acting as a fuel source for the custom machine learning algorithm to perform incident remediation and event correlation. Experience the Trianz Difference Trianz enables digital transformations through effective strategies and excellence in execution. Collaborating with business and technology leaders, we help formulate and execute operational strategies to achieve intended business outcomes by bringing the best of consulting, technology expertise, and execution models. Powered by knowledge, research, and experience, we enable clients to transform their business ecosystems and achieve superior performance by leveraging infrastructure, cloud, analytics, digital, and security paradigms. Reach out to get in touch or learn more.

Explore
Infrastructure

MANAGED SERVICES FOR IT OPERATIONS MANAGEMENT

Managed Services for IT Operations Management Trianz was enlisted to help a global insurance company that provides products and services to individuals, families, and corporate customers worldwide. The client needed a managed service that involved handing off management responsibility to a third party, as well as develop an IT operations management (ITOM) toolset digital transformation. Business Challenges The insurer was experiencing trouble with its IT service desk ticketing software, leading to backlogged work requests stretching back to 2014. IT Service Management (ITSM) and IT Operations Management(ITOM) operated independently, creating data silos that reduced agility and awareness. This led to complications when staff performed manual incident resolution workflows, with inaccurate insight leading to inconsistencies when applying a fix. Coupled with the scale and frequency of manual tasks within the business, this opened up a significant risk for human error. Technology Components Trianz consulted with the insurance company and decided upon the following technology components: Citrix Intelligent Traffic Management (ITM) was proposed to optimize inbound and outbound network traffic using real-time data analytics, applicable across web apps, digital software applications, content delivery networks (CDNs), and similar platforms. Tivoli Netcool or OMNIbus was chosen as a service level management (SLM) system. It provides real-time, centralized monitoring of multi and hybrid-cloud networks, feeding relevant data back to helpdesk systems, databases, and remote systems. The end-state enables automatic response triggers to incidents and events on the network and monitors the adherence to proposed service level agreements (SLAs). IPSoft was selected as an autonomic, cognitive solutions platform. IPSoft automates IT and related business processes using conversational AI, which is ideal for external customer queries and internal knowledge sharing with employees. BMC Helix ITSM(previously BMC Remedy) was chosen as an industry-leading, next-gen service management platform that upholds and evolves best-practice ITSM principles aligned with business requirements. How Trianz Helped the Insurance Company to Reduce Human Error, Eliminate ITSM/ITOM Data Silos, and Digitally Transform the IT Service Desk Trianz started by running workshops across all business departments, cultivating the understanding of present IT challenges among key stakeholders. Our infrastructure experts then developed a prototype environment using Citrix ITM, Netcool, IPSoft, and BMC Helix. This established a centralized event management system, providing a single source of truth for AI when executing automated ITSM and ITOM workflows. Data and insight correlation policies were developed and tested so the insurance company could de-duplicate events and reduce event noise fatigue among service personnel. IPSoft was integrated with the event management system to enable remediation playbooks and automated incident resolution. This process involves the creation of Scope of Work (SOP) documents, and configuration of automation scripts aligned with business workflows. The final step was validating the automation script parameters and generated outputs, ensuring everything aligned with the insurer’s expectations. Transformational Effects for the Insurance Provider After Enabling Automation After implementing the new system, the insurance company experienced tangible benefits. First, incident remediation timescales were significantly improved using IPSoft automation playbooks, improving mean-time-to-remediation (MTTR) metrics. This indirectly supported SLM and the upholding of SLA agreements. The prevalence of human error was significantly lowered, namely due to consistent and repeatable automation playbooks through IPSoft. This meant the workforce had more time to focus on high-value tasks, rather than low-level workflows. End-customer confidence levels soared exponentially due to improvements in service quality and reliability, driving business growth and supporting revenues. IT service desk backlogs were reduced by 91% with the support of auto-remediation AI over a five-month period. Staff well-being improved with this change thanks to lower workloads. Finally, around 90% of SLA metrics and reports were automated to simplify management and reduce human error. Overall, this meant that 50% of business-wide reporting needs were met through the new system. Experience the Trianz Difference Trianz enables digital transformations through effective strategies and excellence in execution. Collaborating with business and technology leaders, we help formulate and execute operational strategies to achieve intended business outcomes by bringing the best of consulting, technology expertise, and execution models. Powered by knowledge, research, and experience, we enable clients to transform their business ecosystems and achieve superior performance by leveraging infrastructure, cloud, analytics, digital, and security paradigms. Reach out to get in touch or learn more.

Explore
Infrastructure

HARNESSING SOFTWARE ASSET MANAGEMENT EFFECTIVELY TO ITS FULL POTENTIAL

Helping a Logistics Provider Harness Software Asset Management Trianz was approached by a logistics services provider needing help with software asset management. This client was seeking to utilize its asset management function at full efficiency, while adopting new software compliance frameworks and industry best practices as it transitioned to a Software Asset Management (SAM) platform. Challenges for the Logistics Company in Asset Management The logistics company handled hundreds of thousands of assets per day in its delivery network. Tracking, checking in, and reporting lost payloads was difficult, and finding information on ownership and asset handling was slow and inefficient due to outdated systems. The logistics company needed a SAM solution to reduce manual data input workloads, improve data accessibility for drivers performing fieldwork, and adopt more robust data security and governance processes. Technology Components Curated by Trianz for the Logistics Provider After consulting with the logistics firm, Trianz identified a number of solutions that would help it meet project objectives: ServiceNow was chosen as an end-to-end solution for IT service management (ITSM) and IT operations management. The platform can orchestrate IT resources, obfuscate interactions between services through a centralized accessibility layer, and automate numerous workflows to simplify work for employees. Business DNA (BDNA) Discover is a software and hardware asset identification platform that uses agentless technologies to perform horizontal and vertical network discovery workflows. Level 1 can identify hardware and software assets, with Level 2 revealing asset metadata, and Level 3 offering application identification in runtime environments. How Trianz Helped the Logistics Provider to Develop a SAM Platform To start, Trianz developed and implemented asset and configuration management best-practice frameworks for the logistics provider. This is a form of process engineering. Next, a solution architecture was built. This involved the design, development, and implementation of ServiceNow CMDB and ServiceNow Asset Management tools, with data pipeline creation to centralize all configuration item and asset datasets in ServiceNow. The IT Infrastructure Library framework was adopted to manage processes around configuration management. This eliminated gaps in existing processes to improve overall service management efficiency by 25%. Consultation and thought leadership with key stakeholders communicated the importance of compliance frameworks and industry best practices. Our data experts also guided stakeholders in transforming their individual departments’ processes and workflows to align with new policies and frameworks. New, repeatable processes and workflows were developed to reduce administrative overhead. Overall visibility into ITSM was greatly improved as configuration items and contractual information were readily available in a centralized location. Transformational Effects for the Logistics Provider With SAM Custom parameters were replaced with standardized parameters in alignment with the ServiceNow out-of-box-experience. This reduced the number of configuration variables, streamlining configuration item lifecycle management. All critical-priority hardware and software assets were identified with comprehensive metadata by integrating ServiceNow with BDNA Discover. Reporting frameworks were established to help the organization identify software contract data, including license volumes, licensing permissions, and license compliance versus runtime. The new SAM platform was proactive rather than reactive, helping the logistics provider to plan ahead and foresee challenges and trends. Trianz conducted ongoing workshops to help elevate understanding among stakeholders and the workforce on software or hardware asset management best practices. Experience the Trianz Difference Trianz enables digital transformations through effective strategies and excellence in execution. Collaborating with business and technology leaders, we help formulate and execute operational strategies to achieve intended business outcomes by bringing the best of consulting, technology expertise, and execution models. Powered by knowledge, research, and experience, we enable clients to transform their business ecosystems and achieve superior performance by leveraging infrastructure, cloud, analytics, digital, and security paradigms. Reach out to get in touch or learn more.

Explore
Infrastructure

EVENT ANALYTICS

IT Operations with actionable insights from Event Data The client is a leading provider of in-flight broadband internet service around the world and also offers other connectivity services for commercial and business aircraft. It is headquartered in Chicago. Business Challenge The client had multiple tools with overlapping functions and interfaces that hampered visibility into IT operations. Multiple trouble tickets were generated because of duplicate events for single issues, negatively impacting the effectiveness of the IT operation team. Also, the inability to identify actionable events and recognize trend patterns from real-time and archive events were preventing the decision-making ability on capacity planning. Technology Component IBM Netcool Operations Insights, IT Operational Analytics, IBM Dash and ServiceNow Insight Packs for event data analytics, ITOM data from various monitoring tools Approach Conducted workshops with business and IT stakeholders to understand business needs Implemented Netcool Operations Insight solutions (NOI) with IBM Operations Analytics to identify bottlenecks and problems from operational data including events, infrastructure and application monitoring metrics  Integrated various monitoring solutions with NOI and developed correlation polices to de-duplicate events. Created dashboards to monitor business services health and performance Integrated NOI solution with ServiceNow Incident management to automate tickets Implemented customized XinY threshold UI interface for NOC team to modify the threshold values on demand Transformational Effects Reduced events load and improved MTTR Integrated visualization and dashboarding to provide a single interface for the entire IT operation Implemented user-friendly and easy-to-use event analysis and search functionalities for incidents Gained visibility into event patterns which enabled NOC team to proactively address potential outages and reduce problem tickets

Explore
Infrastructure

ITSM PROCESS CONSULTING

A centralized event management, self-healing and auto-remediation of incidents A payment processing network operator - supporting more than 725 million credit and debit card transactions globally - was facing visibility issues. Due to a lack of insight into IT infrastructure and applications and an inability to assess critical incidents in real-time, the company was losing transactions and business. The client wanted to ensure it complies with the data security standards requirements of the Payment Card industry and see that its inbound processes are well-equipped with these standards. It was also looking to enhance its existing tools with the industry’s current best practices and apply security recommendations as defined in the security policies for monitoring infrastructure. Business Challenge The client had deployed a separate ServiceNow instance for Service Management and the resulting process gaps were leading to issues related to audits, especially Change Management. The client was looking to conduct an assessment of all of its ITIL processes to address the gaps and identify areas for improvisation. Their objective was to conduct specific workshops focused on aligning processes with the Payment Card Industry – Data Security Standards (PCI-DSS). The client also wanted to enhance the ServiceNow instance and process modules with industry best practices. Also, CSF and KPIs were not configured/measured properly. Approach Conducted classroom workshops leveraging a scenario-based approach to understand the current state of the "AS-IS" process based on the Gap Analysis report. Determined the desired "TO-BE" state during the workshop and understand current pain points and challenges by conducting interview sessions with the relevant stakeholders. Identified action items during the process based on the concepts discussed and distributed amongst both parties depending on the required output. Defined the process by adopting best practices as per the ITIL v3 framework aligned to business needs. Provided a walkthrough for the final sign-off. Transformational Effects Alignment of the current processes with PCI-DSS requirements and created detailed knowledge articles/reference guides beneficial for practical use. Highly efficient KPIs and metrics defined to enhance user experience. Defined step-by-step flowcharts that aligns with GBT organization structure.

Explore
Infrastructure

REMOTE INFRASTRUCTURE SERVICES

An SOC-compliant, 24x7 network operations center utilizing ITIL framework for operations and incident management One of the largest data center hosting services provider that currently operates 175+ data centers in 44 major metropolitan areas in 22 countries across five continents. Business Challenge Availability of multiple tools for performing similar functionalities Lack of centralized repository Identifying patch vulnerabilities, non-compliance configurations across the network Compliance issues with OS patching and 3rd party application patching Business Objectives To manage software across different platforms To enforce continuous security compliance that validates the security threats and remediates the issues in real-time Policy visibility between IT Operations and Security Support and control of workstations from a central location Real-time visibility to endpoint changes Speed and accuracy The Approach Strategy to build BigFix Infrastructure and distribute BigFix agent to all servers/desktops/laptops Implementation of Bigfix to eliminate the drawbacks with the existing solution and to secure the servers/desktop./laptops in an effective manner Process for deploying patches related to operating system vendor Automated Bigfix agent deployment solution to install BigFix agent and configure all client related settings Distribute remote control agent to all servers/desktops/laptops to manage/access those machines remotely Deploy scanners across all servers/desktops/laptops to discover software and hardware data Configure all security health check related settings based on customer agreed technical specification documents and scan all machines to find and remediate all non-compliant settings Transformational Effects Provided a centralized solution to manage all servers, desktops and laptops within single console (patch deployment, software deployment, software & hardware inventory, remote control, security and compliance). Provided an automated approach to update all servers with security related policies, which includes virus definition updates, pattern updates and agent updates. Effective handling of security threats and vulnerabilities, and real-time visualization of current status. Facility to control/access desktops/laptops/servers remotely Perform security health check scan and ensure all configurations are compliant

Explore
Infrastructure

INFRASTRUCTURE SUPPORT SERVICES

24x7 Integrated NOC center for service desk, data center, network and cyber security utilizing ITIL framework for operations support and incident management A global manufacturer that provides innovative plumbing, heating and water quality products and solutions for commercial, residential, and industrial applications. $1.5 B global company that is headquartered in the USA with approximately 4800 employees spread across 87 countries in North America, Europe and Asia Pacific regions. Business Challenge Inefficient Service Desk, Data Center and Network operations resulting in low customer satisfaction scores Lack of visibility and effective monitoring capabilities for Network devices Reactive way of incident management and outdated change management process. Incomplete 24x7 coverage across geographies resulted in gaps and delays Existing processes are not aligned with the ITIL best practices Business Objective Transition from existing (10 years) vendor to Trianz Centralized support for Servers, Network, Cyber Security and Operational Management Products Improve customer satisfaction level by improving response times and region/ time coverage Reduction in incident escalations through better internal communications and coordination Enable client stakeholders to focus on core business objectives instead of operational issues Key Deliverables Single pane of glass for real time monitoring and alerting for Servers, network devices and other critical services. Provide 24x7 support for Servers, Network and ServiceDesk operations Timely weekly, monthly quarterly reports and metrics for KPIs Well documented SoPs, KB articles and guidelines for command center roles for day to day operations Custom script based automated backup solution for Network devices Upgrade and configuration of Service Management tool (ServiceNow) to improve efficiency of operations. Identify, plan and execute critical projects for Data Center and Network Compliance analysis for all network devices for best practices and plan for upgrade / replacement of out of warranty devices. The Approach Set up of 24x7 NOC Center staffed with certified SMEs and cross trained across various technologies Successful completion of knowledge transition from existing vendor within a time span of 8-weeks Configuration of SolarWinds for realtime monitoring of Servers, Network devices, critical services and printer Round the clock monitoring and management of server components and network devices to reduce incident ITIL Framework based service approach for effective handling of tickets (best practices like shift handover, ticket auditing) Transformational Effects Improved customer satisfaction and reduced churn Consistent round the clock customer support Reduced Incident Aging and MTTR Process alignment with ITIL best practice Significant reduction in P1 (outages) for network Custom backup solution for critical network devices eliminated manual efforts and costs for a licensed backup solution

Explore
Infrastructure

AUTO DISCOVERY & SAM IMPLEMENTATION

Implementation of centralized Software Asset Management (SAM) solution for a single source of truth The client is one of the largest drinking water and wastewater utilities in the nation, with a network of nearly 5,742 miles of fresh water pipeline and over 5,546 miles of sewer pipeline. It was looking for a single platform to auto discover the assets and centrally manage the software assets & IT Service Management platform. Business Challenge The client didn’t have complete infrastructure dependency information, which was leading to multiple unplanned outages. It also lacked visibility into the business view of IT infrastructure and workstations scattered across different locations. Due to these issues, the client was unable to identify the risk before implementing the change as well as understand or manage complex licensing models and software lifecycle effectively. Additionally, there were increasing security threats and other risks due to unauthorized software installation by end-users. Technology Components ServiceNow, SCCM and Microsoft O365 Portal Approach Conducted workshops with various business units to gather requirements. Designed a ServiceNow discovery architecture consisting of 2 MID servers to meet business and IT needs. Designed a Daily Automated Discovery solution for nearly 4k devices across 22 locations. Created software models for Microsoft & Oracle publishers; enabled normalization and reconciliation of software products; integrated SCCM to pull the software metering information and automated license harvesting; integrated the architecture with O365 Portal and imported the user subscriptions. Configured dashboards and license expiry notifications. Transformational Effects Consolidated single source of reference, configuration data in CMDB with greater visibility into infrastructure components and its relationships to applications. Gained better insights into data about software ownership and usage; re-harvested and re-allocated unused software licenses. Enabled the tracking of overused licenses and compliant software using the publisher overview dashboards.

Explore
Cloud, Cybersecurity

CLOUD SECURITY POSTURE MANAGEMENT

Trillium Targets Secure, Compliant Cloud Infrastructure With cloud computing rapidly phasing out legacy and on-premise applications and infrastructure, one of the leading payment services and mobile payment gateway providers in the Middle East/North Africa (MENA) region – we’ll call them Trillium – recognized the need for a secure, fully compliant hybrid cloud environment for their e-wallet application. This application, that required lifting and shifting into the cloud, would serve all of Trillium’s e-wallet users in the Egypt area, with a full data migration that needed to be conducted within the short span of a year. Because Trillium had an existing relationship with Trianz, they turned to us to handle the e-wallet application’s platform migration, rearchitecting, and data governance. Addressing Cloud Challenges In June 2018, Trillium was looking to ensure that their cloud platform was up to standard, with a customized architecture to handle their approximately 300 vendor management systems (VMS) and appliances, as well as the more than 300,000 transactions made through the app in a day. This was especially important considering that these applications were financial inclusion products used by a large segment of Egypt’s population lacking access to full-scale banking services, as well as by small businesses. In addition to this, Trillium needed to establish multiple front-end and back-end connectivity for the customers and for failover, while also having an environment that was compliant and secure according to PCI, SOC, and ISO 27001 regulatory standards, at all times. Trillium required a thorough cloud security posture management (CSPM) process to help them detect misconfigurations, encryptions and inappropriate permissions, while also ascertaining regulatory policy compliance, monitoring suspicious activities, and enabling real-time protection for the cloud. The Trianz Approach to CSPM As an enterprise with considerable experience in the areas of cloud security and CSPM, Trianz partnered with Trillium to revamp their hybrid cloud environment. Our cloud experts sat down with the Trillium team to conduct a thorough cloud security posture audit. This included discovering how and where their resources were being consumed, investigating the types of transactions that occurred on each resource, and identifying who accessed them. A Secure Pathway To Data Access Copyright © 2021 Trianz When the teams were able to procure this information and identify Trillium’s cloud security needs, the Trianz consultants leveraged Azure Security Center, Key Store, and Defender – as well as other technologies like Sophos and Checkpoint – to monitor data access activities and configure alerts that would detect suspicious behavior. With these alerts, Trillium’s hybrid cloud system would be able to automatically detect anomalies, firewall rules changes, and IP address ranges. Coupled with these upgrades, Trianz also worked with the client to perform a thorough assessment of their cloud platform misconfigurations. Now armed with a deep understanding of the issues at play, the Trianz team was able to resolve Trillium’s key cloud platform misconfigurations in such a way that they achieved 100% in Azure’s Security Benchmark, as well as hitting their regulatory compliance targets. The Technical Takeaways Along with helping Trillium obtain their goal of being fully adherent to SOC, ISO 27001, PCI, and DSS data governance policies, Trianz was able to maintain their cloud environment misconfiguration-free, along with generating regulatory reports whenever requested. Furthermore, our team was able to protect the cloud platform from data leakage by automatically blocking downloads to their infrastructure, as well as rejecting uploads of any malicious files. This was a clear step forward in terms of Trillium’s data security. Impacts to the Business Through our engagement with Trillium, we were also able to help them realize several impactful changes to their business. As a result of the increased security and higher data quality, the accuracy of insights improved, as did customer relations. Higher regulatory compliance further strengthened the company’s reputation, while simultaneously lowering incident rates and consequently, the resources and hours wasted on resolutions as well. This would also guarantee smooth, uninterrupted service delivery to customers. The hybrid cloud environment’s scalability meant that the e-wallet platform went gradually from being able to handle 300,000 transactions daily to 3 million, allowing them to onboard even more customers – whether private individuals or small businesses. All this, while remaining fully secure. Furthermore, Trillium needed their data to be fully migrated and secured in the new cloud environment within the span of a year (i.e. by July 2019). By partnering with Trianz, they were able to achieve this goal and avoid the significant financial penalties that would come with a delay. The Transformational Effects By bringing their application platform and data from a legacy warehouse into a hybrid cloud environment that met their business needs and global regulatory compliance standards, Trianz was able to help Trillium become more a more cloud-native, customer-focused, and digitally empowered organization overall. The Trianz Difference Trianz enables digital transformations through effective strategies and excellence in execution. Collaborating with business and technology leaders, we help formulate and execute operational strategies to achieve intended business outcomes by bringing the best of consulting, technology experiences and execution models. Powered by knowledge, research, and perspectives, we enable clients to transform their business ecosystems and achieve superior performance by leveraging infrastructure, cloud, analytics, digital, and security paradigms. Reach out to get in touch or learn more.

Explore
Digital Apps, Cybersecurity

ENRICHED AND SECURED USER EXPERIENCE

A global leader in the security and protection industry was interested in digitizing their B2B customer interactions to improve their customer experience, increase revenue, and reduce the cost of both, infrastructure maintenance and administration. By not having an intuitive system in place, the company’s customers were experiencing inconsistent interactions and turning to other sources. The client partnered with us to build self-service portals and region-specific marketing sites. A responsive design allowed the company to provide a seamless user experience and further integrate their content management system. A user management system and SSO with multi-factor authentication was enabled to secure access across devices and locations. We also facilitated infrastructure sizing, consolidation and hosting for multiple countries with seamless monitoring, logging, and reporting. Finally, analytics were employed to track customers, interactions, and marketing metrics while improving overall Customer Experience. The Business Challenge Customers around the globe were experiencing inconsistencies on the client’s websites and portals while authentication processes provided only limited accessibility. This combination of issues resulted in pileups of unresolved issues and spikes in service calls. Technology Components Liferay, Oracle, Okta – SSO, BizTalk, Dynatrace (monitoring, logging, and reporting), Apache Ant, Eclipse, Liferay MVC portlet The Approach Developed geo-specific marketing portals leveraging content management system Hosted environment in a centralized Liferay 6.2 for seamless experience Enabled application integration including complex workflows Used federated identity management for secure access Build portal interface using ESB pulling information from downstream systems Developed responsive design to support access from multiple devices Built real-time reports and analytics Transformational Effects Redesigned online interactions improved user experience, increasing daily site visits by 30%. The number of help desk calls was reduced 60%, dropping the number of expired credentials tickets by 90%. 25% lower infrastructure costs paved the way for new technology like instant alerts for suspicious activity.

Explore
Cybersecurity

A SECURITY SOLUTION FIT FOR A GLOBAL SECURITY IMPERATIVES PROVIDER

A leading provider of identity-based data security imperatives to global enterprises, financial institutions and governments needed a comprehensive end-to-end security solution. Trianz deployed a single identity and security profile across the entire identity management, provisioning, infrastructure, workflow, auditing, reporting and self-service capabilities spectrum. Centralized session management was introduced, including support for idle and session timeouts, and real-time user revocation. We also facilitated easy administration and deployment with N-level delegation administration and rules-based access (open and interoperable based on industry standards). Finally, we designed fully conformant interoperable SAML 2.0 identity federation capabilities to provide seamless integration, apart from extending continuous L1, L2 and L3 customer support. THE BUSINESS CHALLENGE Increasing demand for data privacy, mission-critical need to ensure appropriate access to resources across increasingly heterogeneous technology environments, and a need to meet rigorous compliance requirements within critical time-to-market deadlines. TECHNOLOGY COMPONENTS Technologies: Core Java, Servlets, Java Sockets, Jax RS, C++, SSL/certificates, SAML, SOAP, Tomcat, Angular JS, and Axis web services. Repositories: Oracle, MS SQL server, and LDAPs. Tools: Eclipse, JIRA, OpenSSL, GIT, vSphere, Wireshark, etc. THE APPROACH Periodic maintenance and enhancements to stay abreast of evolving technologies and security needs Enabled single sign-on moving from SAML 1.0 to SAML 2.0 Architectural changes to support common deployment tool for the product (supporting multiple platforms and webservers) Revamped GUI for enhanced user experience Enhanced the product to support other single sign-on frameworks - OAuth and OpenID support Rolled out deployments (onsite), post-development maintenance, and enhancements TRANSFORMATIONAL EFFECTS Roadmap established based on business use cases and incremental development of AWS services ROI model developed for the global enterprise data warehouse initiative Risks mitigated from addressing data quality issues upfront Common business definitions established across regions and countries Enabled business users to analyze and unearth insights on revenue and profitability across LoBs Developed an ROI model for global enterprise data warehouse initiative

Explore

Our Success Stories

TRUSTED BY BUSINESS & TECHNOLOGY LEADERS

Our engagement with Trianz has now exceeded three years, and together we have delivered many significant initiatives in that time. Many of our successes could not have been achieved without our partnership. In many ways, Trianz has already put our products ahead of the curve.

Director of Quality Assurance

Top 10 US Life Insurance Company

The white glove approach, agility, and flexibility of the team helped us to tap opportunities in the ever-changing business environment.

Director of Customer and Partner Services

A Leading Global IT And Networking Organization

Trianz team worked side-by-side with us to transform our sales operations. Now, we have complete visibility into everything from our supply chain to sales and pricing. Our partnership with Trianz has been exceptional.

Director – Accounts and Cost

A National Cattle Feed Supplier

The team at Trianz worked tirelessly to propose a system that overcame our business challenges. Rising to the occasion, they simplified our processes, enhanced the system and increased productivity. There’s no doubt; our ongoing success was enabled by our partnership with Trianz.

Director

A Leading Commercial Automobile Liability Insurance Provider

Trianz commitment to taking end-to-end ownership of developing the e-commerce web app is exemplary. Their dedicated involvement was key to us garnering the advantages of automated test suite development and manual testing

VP of Marketing

Global Storage Systems And Data Management Company

Get in Touch

Let us help you
transform and grow


Let’s Talk

x

Status message

We're eager to assist you! Please leave a message and we'll get back to you shortly.

By submitting your information, you agree to our revised  Privacy Policy.