CASE STUDIES

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

Cloud, Analytics

TRANSFORMING OPERATIONAL ANALYTICS THROUGH A SCALABLE AWS PLATFORM

Yancoal Seeks to Evolve Their Analytics Capabilities With the recent wave of digital evolution in the natural resources industries, Australia’s largest pure-play coal producer Yancoal, was looking to maximize new opportunities by expanding their growth strategy. Specifically, the enterprise was aiming to enhance their business agility through advanced analytics and improve the efficiency of their mining operations, particularly in the area of logistics. What Was Yancoal Looking to Achieve? The enterprise sought to reduce costs, implement operational efficiencies and shared services, and provide all customers with the certainty of product quality and delivery. In order to achieve these goals, Yancoal was interested in building a strategic data ecosystem to store and analyze operational data in line with the industry best practices. This data ecosystem would support and enhance their current business operations, while simultaneously accommodating newer technologies and business strategies via futureproofing. The projected business value that Yancoal hoped to actualize included better supply and demand management, reduced fuel consumption, increased energy efficiency and consequently enhance their reputation as one of the few eco-conscious enterprises in the coal industry. In order to strategically implement the appropriate solutions, the company partnered with Trianz’ team of analytics experts. How the Trianz Approach Upgraded Yancoal’s Analytics Platform Trianz’ consultants sat down with Yancoal’s leadership to first understand their unique business needs and challenges before collaborating with Amazon Web Services (AWS) on the ideal solution. Through a thorough analysis of the client’s existing data warehouse, Trianz and AWS created migration blueprints that addressed their specific requirements, significantly improving the outcomes of the transformation. The Trianz subject matter experts created a well-integrated AWS Cloud platform to host the client’s new operational analytics systems. By working with a single vendor, Yancoal was confident that their new platform would be fully supported in the long term, because AWS provides inbuilt updates and integrations. Finally, by engaging Trianz as their managed services partner, Yancoal was able to streamline ongoing operations support to maintain and enhance the capabilities of their analytics platform. This would ensure swift communication and issue resolutions, increasing the availability and resilience of the platform. Cloud analytics companies exist to absorb the costs of expert employees, specialized hardware, and maintenance associated with cloud analytics. These services provide valuable assets to clients who could not otherwise support these demands on their own. Dennis DeGregor, Vice President - Analytics Practice Leader Setting up the Operational Analytics Platform on AWS Yancoal’s analytics platform was built by Trianz on the pillars of AWS’s well-architected framework. The team implemented AWS Transit Gateway, Managed Active Directory and Single Sign-On, deployed infrastructure as code, enabled automation using DevOps including continuous integration and development, and used services like CodeCommit, CodeDeploy, and Terraform for migration. The Trianz team further applied architecture patterns like serverless and event-based compute, leveraging the AWS Lambda service for event-driven code execution. This enabled near real-time automated data processing and propagation from source to AWS S3 Storage using AWS Glue jobs. The team also leveraged lean architecture principles for data architecture design, such as data virtualization, by storing data on S3 buckets, and using AWS Athena to perform interactive queries. This eliminated the need for multiple extract-transform-load (ETL) and data movement operations, saving substantial data processing and storage costs. Trianz implemented application and platform monitoring using AWS CloudWatch. It was used to monitor Glue job status through CloudWatch logs, as well as to oversee infrastructure like EC2 instances for CPU and memory availability and utilization, triggering events to SNS topic in failure scenarios. The team made use of a market-leading data visualization tool, Tableau, to deliver key performance indicators (KPIs) and metrics through rich visualizations, enabling accurate and timely insights into day-to-day operations. How Trianz Helped Yancoal Realize Their Business Goals Yancoal’s engagement with Trianz enabled them to overhaul their data and analytics capabilities by working together to construct a solid operational analytics platform. They were able to achieve their key goal of proactive supply chain management to reduce costs, enhance services, and improve their carbon footprint through increased operational efficiency. Trianz also delivered significant business impact by implementing automated, real-time, and consistent reporting, as well as standardizing data. Because Yancoal also engaged Trianz as a managed services partner, the team was also able to deliver key metrics such as 100% data and dashboard availability with no downtime, 100% response and resolution, and significantly increased customer experience. The Transformational Effects and Impact Thanks to the high levels of automation that were integrated into Yancoal’s analytics capabilities, the company experienced an annual cost reduction of at least AUD 300,000, a manual effort reduction of at least 50% in report generation, and sharply reduced month-end report durations. Finally, Trianz’ implementation of the AWS solution empowered Yancoal to transform into a data-driven enterprise whose robust analytics platform now provides timely, trusted, and actionable 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 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

BUILDING A PCI-DSS COMPLIANT REWARDS MANAGEMENT PLATFORM ON THE CLOUD

Reward360 Global Services is a premier Loyalty Technology and Solutions Company. It wanted to develop a PCI-DSS compliant rewards management platform for banks in the country. THE BUSINESS CHALLENGE To design and build a loyalty management platform on the public cloud that would not only comply with stringent auditing requirements but also be scalable to other businesses TECHNOLOGY COMPONENTS Linux, Apache/Nginx/PHP/NodeJS, MySQL/MongoDB, Redis Cache, Application Load Balancers, Web Application Firewall, Application and host level Logging – ELK Stack, OSSEC, Security Incident Event Management – OSSEC, Cloud API log – AWS CloudTrail, Alert notification – AWS Simple Notification Service, IP whitelisting – AWS VPC Security Group, Layer 7 – Web Application Firewall, Host level firewall – iptables Vulnerability assessment – VAPT (OpenVAS + Nessus), Data in Transit encryption HTTPS – SSL Certificates THE APPROACH Suggested and implemented a templatized cookie cutter model for predictable deployment on AWS Cloud due to the repetitive nature of audit requirements with the banking business Made significant changes to the application architecture to accommodate compliance controls at various layers of the platform and to facilitate platform scalability Leveraged a combination of various AWS services, open source solutions, and third party solutions to achieve the necessary compliance Redesigned and redeployed the environment on AWS TRANSFORMATIONAL EFFECTS Reduced deployment time from 12 weeks to one week Highly scalable environment Option to deploy the platform as is for clients similar to banks in a cookie cutter mode Published: 2019-12-10

Explore
Infrastructure

CONSOLIDATING INFORMATION TO IMPROVE IT EFFECTIVENESS

A leading school district in Georgia, U.S., was using a helpdesk system with no automation, and no authorized process to track IT assets spread across more than 100 sites. Frequent changes to infrastructure caused unanticipated outages, and lack of a well-defined process to resolve such incidents resulted in frequent SLA breaches. The client partnered with Trianz to map applications, as well as organize and consolidate information to enable effective service management. Trianz installed and configured the IBM Tivoli Application Dependency Discovery Manager (TADDM) solution to discover a complex infrastructure with multiple firewalls, air gaps and hardened security. We also implemented ITSM operational and process management tools, including endpoint management, configuration and change management, in addition to integrating TADDM and BigFix solution to populate Configuration Management Database (CMDB). Additionally, Trianz developed a process to automate impact analysis and view Request for Change (RFC) details from the TADDM application. Rolling out Endpoint Manager (BigFix) was critical to ensuring all hardware and software assets and their usage across sites were tracked in a centralized repository. The Business Challenge A reliable source of data was needed to accurately track IT assets and a dearth of well-defined processes to analyze and resolve critical outages. Technology Components IBM Tivoli Application Dependency and Discovery Manager IBM Control Desk Endpoint Manager (BigFix) The Approach Rolled out a service management and application affinity solution in a phased approach. Initial focus was to build an authorized asset repository for an end-to-end integrated service management solution. Implementation was completed within 9 months of kick off. Performed a steady state run and maintenance for another 2 years before transitioning the engagement to client personnel. The solution has been deployed across more than 100 sites within the state of GA, and is the primary help desk and asset management solution for the school district. Trianz ensured sufficient training to IT and non-IT users within the first few weeks of solution go-live. Transformational Effects Automated analysis and inputs prior to infrastructure change Minimized downtime from elimination of trial and error Enhanced visibility to software-hardware allocations and capacity monitoring Facilitated usage-based allocations to revenue/cost centers directly into general ledger Streamlined new hire onboarding process using a single self-service offering and auto routing of those requests, reducing manual effort

Explore
Infrastructure

ENTERPRISE MONITORING MANAGED SERVICES

Centralized Event Management, Self-healing and Auto-remediation of incidents A Leading Auto and Personal Insurance Provider’s current homegrown IT Service Request Management tool was nearing end of vendor support and was facing frequent performance and stability problems. Given the significant growth in capabilities in ITSM tools over the last five years, a replacement will move the client to a new platform with improved usability for the end user and a significant increase in automation and integration capabilities. Business Challenge Manual processes and growing complexity of the environment was overloading IT staff, resulting in longer times (approx. three days) to resolve critical incidents and growing backlog (~1000) of work requests IT staff was consumed with reactive tasks leaving no time for process improvement. Low level of integration of multiple tools and siloed repositories of information (CMDB, incident logs, ITOM) made it difficult to correctly diagnose and resolve incidents first time, resulting in a significant rework effort and time to close incidents. Business Objectives Increase customer satisfaction level by reducing manual operation errors and ensure resolution of incidents within the committed SLA. Increase visibility and reporting to SLA metrics and elimination of aged backlog work. Reduce human errors related to manual tasks and improve efficiency through targeted automation and integrations. Key Deliverables Integrated existing monitoring and incident management tools (IBM and Netcool monitoring, BMC Remedy/ServiceNow) into a centralized event management system. Implemented auto-remediation of events using IPSoft. Developed correlation rules within Netcool to de-duplicate events. Validated automation logic and created SOP documents for IPSoft to support continuous development of automation scripts. Provided necessary 24x7 support for server monitoring. Implemented self healing by Netcool & IP-Center AI integrated with ServiceNow. The Approach Performed workshops with business and IT stakeholders to identify people, process, tool issues and desired outcomes for eight weeks. Created future state architecture and end-state visualization for integrated solution. Staffed a blended team of client and Trianz onshore/offshore resources to attack backlog Took complete control over the server monitoring by providing the necessary support. Transformational Effects Decreased the incident remediation time and ensured adherence to all committed business SLAs. Reduced the backlog of work requests by 91% over a period of five months. Estimated improvement of 20% in staff efficiency.

Explore
Infrastructure

IT SERVICE MANAGEMENT : END POINT MANAGEMENT AS MANAGED SERVICE

The client is an $18B engineering firm and a global provider of technical, professional, and scientific services, looking for a unified ITSM and endpoint management platform. It also wanted integration between ITSM and the endpoint management system. The client’s main aim was to reduce all the current manual processes. THE BUSINESS CHALLENGE Lightly used ITSM instance with little attention to process initiatives; Underutilized request management, no self service portal; No analytics or baselines to drive/manage improvement No integration to other capabilities; Endpoint operations causing lots of overhead on network and hitting performance bottle necks; SCCM infrastructure was aging and too expensive to manage Lack of automation for IT operations; Pending M&A activity threatening to slow things even more. Business Objectives Key Deliverables  Lightly used ITSM instance with little attention to process initiatives; Underutilized request management, no self service portal; No analytics or baselines to drive/manage improvement  No integration to other capabilities; Endpoint operations causing lots of overhead on network and hitting performance bottle necks; SCCM infrastructure was aging and too expensive to manage  Lack of automation for IT operations; Pending M&A activity threatening to slow things even more  Unified ITSM platform through ServiceNow  Endpoint management through BigFix and SCCM  Integration of ServiceNow with BigFix and SCCM THE APPROACH Assessed current state and growth including M&A to develop strategy and execution roadmap Performed detailed assessment on the existing ITSM applications, tools, integrations and relation with other ITSM process / initiatives. Provided a detailed gap analysis document Conducted workshops with various business units, gathered requirements and developed functional requirements document Defined a conceptual end state ITSM & endpoint architecture to meet business and IT needs Delivered holistic solution as a service; Endpoint as a service covering patch management, OS Distribution, Software Distribution, Power Management and Remote Control Self Service Portal and Automated Password Reset; Buildout for automated change management; Normalization and reconciliation of CMDB; Monitoring Analysis and process improvement; Event Management Integration; IT Operations Center Buildout

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

DEPLOYING A COMPREHENSIVE ENDPOINT MANAGEMENT PLATFORM

A leading vehicle rental provider (operates multiple car rental brands in nearly 10,000 corporate and franchisee locations across the globe) was finding it difficult to seamlessly roll out patch management across its 3,000-plus locations. Inadequate asset discovery and management, authorized assets management and license compliance management, besides network congestion and poor network performance were some of the other problems the company was experiencing. Trianz successfully replaced the company’s then-existing SCCM with BigFix to eventually deliver a comprehensive Endpoint Management Platform. The Business Challenge The organization needed to streamline its asset management process, make patch management rollout seamless, bring all its authorized assets under a single umbrella for effective service management, introduce license compliance management, and remove network congestion to improve network performance. Technology Components BigFix 9.5.3.211 BigFix Inventory 9.2.5.1 The Approach Installed BigFix 9.5.3.211 and BigFix Inventory 9.2.5.1 Installed NMAP scan for network discovery and managing network inventory Deployed BigFix Inventory Configured Relay Affiliation (a more sophisticated control system for automatic relay selection) for better endpoint management Configured Tivoli Remote Controller, OS Deployment, Power Management and MaaS360 Configured Lifecycle Management, Patch Management (Windows, AIX, Linux), Security Compliance Management Provided steady state support for BigFix and its related/ integrated tools Maintained KEDB, usage of technical and process SOPs Reproduced best practices and recommendations Provided lucrative solutions after understanding the big picture and post meticulous Transformational Effects Achieved effective and efficient Patch Management rollout for more than 3,000 global locations Segmented BigFix infrastructure into separate logical groups through relay affiliation configuration for better management of endpoints Rolled out Maa360 helping in effectively handling thin clients Arrested identification of newly added assets to the network through NMAP scan – a supported, acclaimed, powerful and flexible tool for network asset discovery Integrated BigFix to ICD to manage all authorized assets for ticketing and maintain a centralized asset repository

Explore
Analytics

CASE STUDIES: HOW BUSINESS INTELLIGENCE ELEVATES BUSINESS IMPACT

As the broader apparatus responsible for data analysis, business intelligence (BI) provides historical and current insights on business operations. But now, with modern technological evolutions such as cloud platforms, data warehousing, and artificial intelligence, BI can be enhanced and harnessed to empower predictive insights and proactive solutions. As a digital transformation services firm, Trianz realizes that there is nothing more important than keeping your organization’s “data brain” constantly primed and functioning at optimum levels. Our experts help clients tap into the significant advantages that these technologies can bring to your business intelligence apparatus. Cognitive computer systems are a good example. These systems are programmed and trained using AI and ML, with algorithms that can interpret and sometimes even build upon human cognitive capacity. This makes a wider range of more refined, real-time, and accurate data, analysis, and solutions available to businesses. Whether operational or strategic, our solutions elevate and streamline BI by making data more accessible to your team with user-friendly dashboards and clear insights free of data inconsistencies. We have helped numerous clients overcome challenges and impediments such as unclear, inconsistent, and confusing data, lagging testing frameworks and reporting architecture, and migrating entirely analog systems to the cloud. In bringing these enterprises’ business intelligence mechanisms up to current and even future standards, we have always adhered to our standards of excellence in execution. What follows are just a few of our case studies of business intelligence engagements: Custom BI Dashboard and Data Analysis Tool A global payments and technology company envisioned a digitization of their client’s access to data through a business intelligence dashboard and data analysis tool. The company 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 their development and implementation partner, helping them create and launch a platform that provided an appealing, flexible experience supported by a robust, streamlined technological framework. Cloud Migration: A Business and IT Ops Transformation A Fortune 500 global insurance enterprise approached the Trianz team to streamline their business applications and infrastructure workloads onto the public cloud. After opting to migrate 70% of its information management data, the client needed to eliminate inconsistences, improve data collection and collation, and unify their data source. This meant also moving dependent apps, infrastructure, and other support programs to the public cloud. The time frame required to complete the entire migration was three years. Trianz was chosen in a competitive process from a pool of several peers, working closely with the company’s business and IT leadership, joining a program governance task force to deploy an accelerated migration using our unique execution model. Optimized ETL Testing: Better Data Management Trianz partnered with a US-based Fortune 100 insurance company to optimize their lagging extract-transform-load (ETL) testing, which was affecting their operational data storage costs and compromising data quality, security, and privacy. The enterprise also found themselves recording unusually long durations for test data prep by both quality assurance and development teams, which was delaying their release cycles. Our team worked with them to not only optimize their ETL testing, but also to enhance their product quality and decrease operational costs. Furthermore, Trianz’s in-house TDM experts continued to provide ongoing support even following the closure of the project. We hold excellence in service and execution to be core values, and our commitment to our clients means always being on standby for guidance, troubleshooting, and other support. 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
Analytics

DESIGN AND BUILD AN OPERATIONAL MASTER DATA MANAGEMENT SYSTEM AND IMPLEMENT A DATA GOVERNANCE PROGRAM

One of the world’s leaders in higher education association and business education networks, that provides accreditation to schools of business, needed an operational master data management system that can bring together the information from multiple systems in a streamlined manner. The Business Challenge To provide a complete picture of the data about their members and the organizations that are part of the larger business education community, the association turned to Trianz to develop a solution that would aggregate, cleanse, standardize, and publish organizational master data. Technology Components Microsoft Azure Platform - Infrastructure As A Service (IaaS), Microsoft SQL Server, Microsoft Master Data Services & Microsoft SQL Server Integration Services The Approach Trianz leveraged Microsoft Azure to provide the required infrastructure and host the solution for the client. Azure offers a quick way to reduce the local infrastructure footprint while developing a new platform that would allow for future technology growth Microsoft Master Data Services was chosen as the software platform because the SQL Server back-end would pave the way for future data warehouse and data integration efforts while the front-end integration with Microsoft Excel enabled data stewards to quickly take control of their data. SQL Server Integration Services was the logical choice for data movement activities due to its inclusion with SQL Server database services. Finally, the technology solution was complemented by Trianz’ Data Governance framework that provided a vision and a plan for the right stakeholders to be involved in rules and decisions for the organization’s master data. The end result of the solution architecture was to ingest data from the company ERP system, marry that information with data from the member Survey system, provide updates to the member Survey system, and make the association’s master data available to other internal and external systems.

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
Analytics

TERADATA TO SNOWFLAKE MIGRATION

The client is an American multinational technology conglomerate that develops, manufactures and sells networking hardware, software, telecommunications equipment and other high-technology services and products. To utilize a new Database Technology, the client needed to migrate the Teradata code in their Business Objects Instance to the Snowflake platform. Business Challenge Owing to the licensing cost, performance issues and an overall mandate to migrate to the cloud, the client was in the middle of a migration of Teradata code to Snowflake platform. To ensure that the business was able to utilize the new database environment, the Teradata specific SQL syntax within the Business Objects environment had to be converted to Snowflake and reintegrated into the Business Objects Environment. Scope of POC Five Web-Intelligence Reports 1 Business Objects Universe Timeline: One month Teradata to Snowflake SemanticLayer Conversion The Approach The Trianz team, consisting of two Snowflake data engineers and one Business Objects Architect, thoroughly analyzed and documented the client’s Business Objects requirements, design and business processes needed to successfully implement the migration. Utilizing Proprietary Code, we extracted the SQL code from the Business Objects Universe, translated it with our custom-designed Evove software solution and then reinserted it into the Business Objects Universe. SQL Syntax proved to be programmatically successful by converting 90% of the tables, with only 10% manual conversions. The conversion was tested by running the WebI reports against the new Snowflake environment to ensure that (a) the reports run successfully and (b) the data match. In the live environment, Trianz was able to successfully run all the reports and match the data at the expected rate. Transformational Effects As a result, above 75% of Business Object instances were programmatically converted to Snowflake. Evove was able to automate the conversion of over 95% of derived tables, with only 6 tables converted manually. Not only was Trianz able to provide initial results on 40% of the reports within the first week, but they were able to complete the migration within a month. Trianz was also able to identify 6 to 7 tables that could be optimized for further Snowflake usage. This process would normally take 2 – 3 months to complete manually, and the solution can be scaled to do 5 to 6 universes within the same time frame, due to the programmatic nature of our application. 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

Explore
Analytics

ENTERPRISE DATA WAREHOUSE: CASE STUDIES

An enterprise data warehouse (EDW) can only perform at its peak if all aspects of the process – from data to analysis to reports and insights – are streamlined and purged of all confusion. Despite the rapid and continuous evolutions brought about by recent technology, many organizations still lag behind. They are weighed down by antiquated analog data collection and management systems, scattered sources of information, and inconsistent data that creates unusable insights. With the advent of the cloud, serverless data, artificial intelligence, and machine learning, the enterprise data warehouse has the potential to be transformed into a thriving center of the organization’s information and analytics. Legacy and analog data can be cleaned, verified, migrated to the cloud using extract-transform-load (ETL) processing. This way, your data can be double-checked for duplication and inaccuracies, contextualized, and curated for tailored insights. A well-maintained data warehouse brings significant value as a time- and resource-saver because it can aggregate high volumes of ostensibly random information automatically. And when an organization’s data is structured in such a methodical, automated way, its growth potential expands exponentially. As a digital transformation services firm, Trianz helps clients tap into the significant advantages that technological developments can bring to your data warehouse capabilities. In bringing these EDWs up to current and even future standards, we have always adhered to our motto of excellence in execution. What follows are just a few of our case studies of enterprise data warehouse engagements. A Game-Changing Platform on an Azure Data Lake for a Global Reinsurer A large reinsurance organization was looking to build a centralized modern data and analytics platform, leveraging cloud services that not just met its current, future, functional, and non-functional requirements, but also offered a global business view into operational insights. Looking at their existing applications, systems, reports, and challenges, we recommended a federated data management solution and laid out a roadmap to finalize the cloud infrastructure with a federated architecture. Next Gen Data and Analytics Platform on AWS for a P&C Insurer A property and casualty insurer needed a scalable solution that could not only ingest and analyze new data sources quickly and efficiently, but also cost-effectively. Their goal was to spend more time on insights and action and less time on set-up. After a thorough assessment of their existing reporting strategy, alignment, and challenges, we recommended deploying the cloud force analytics platform using AWS Cloud Managed services. Data Warehouse: From Strategy to Implementation for a Nonprofit A leading nonprofit that coordinates organ donations needed to redesign and build the legacy reporting and analytics environment of. The organization had to tackle challenges posed by an aging and poorly functioning legacy environment, including weak reporting functions and limited data access, quality, and integrity. Our data experts strategized how to best meet their goals of improved information management while overcoming these significant hurdles. Trianz experts teamed with the organization to develop and test a transformative business intelligence solution. Developing a Data Warehouse and Business Intelligence Environment A well-known university in the US needed to implement an updated computing system to phase out its legacy environment. They required an update to their information access, reporting, and analysis to shift from manual, analog reports to a digitalized solution. The primary task was to develop best practices and strategies for providing timely and accurate access to information. The goal was to effectively and efficiently keep track of and manage important data such as registration, financial aid, grades, grants, and financial information. Our team teamed with university staff to design and implement an upgraded warehouse and streamlined reporting environment. Elevating Higher Education with Better Reporting Architecture An internationally recognized leader in higher education based in Indiana needed to upgrade their enterprise resource planning (ERP) system and gain more visibility into the university finances. The challenges they faced included a lack of financial reporting capabilities needed for planning and operations, as well as more thorough and extensive auditing of financial information migrated into the new ERP environment. Trianz helped university staff by strategizing, designing, and developing an updated digital reporting environment to meet their goals. 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
Analytics

A GAME-CHANGING ENTERPRISE ANALYTICS PLATFORM FOR A GLOBAL REINSURER

Challenge Changing customer expectations, disruption of the value chain, emerging technologies – all of these call for reinsurers to turn data into a strategic asset. That’s exactly what this large reinsurance organization, which we’ll call Pacific Atlantic Reinsurance (PAR), hoped to accomplish with an analytics platform that was efficient, effective, and addressed its data and analytics requirements. PAR was looking to build a centralized modern data and analytics platform, leveraging cloud services that not just met its current, future, functional, and non-functional requirements, but also offered a global business view into operational insights. The goals were simple. The platform should: Enable self-service discovery and analysis Offer automated architecture and governance Provide faster access to raw data sets Scale for additional lines of business LOBs Accommodate different file formats for data integration Act as both a predictive and prescriptive analytics solution Our Approach We had our work cut out for us. Looking at PAR’s existing applications, systems, reports, and challenges, we recommended a federated data management solution and laid out a roadmap to finalize the cloud infrastructure with a federated architecture. Next, we built a data lake using Azure to consolidate all the client’s information in one place. We chose a data lake over traditional database management because of PAR’s need to capture internal data beyond predefined formats. This requirement was an ideal use-case for data lakes. For PAR to stay ahead in the game, it was imperative to capture diverse types of data, generate comprehensive insights, and integrate data with decision-making. With these new insights, the client could pursue their goal of becoming a customer-driven reinsurer with the ability to predict and address customer needs. Trianz specialists devised and executed a framework for reporting platform implementation approach. We also built the foundational analytics capabilities, extended the security framework for the federated solution, and fine-tuned the data governance and quality controls for data governance. Subsequent execution initiatives included deploying a regional data information model and analytics capabilities and introducing DevOps to automate the data pipeline and reporting deployment . Transformational Effects Building a global data lake turned out to be a transformative business enabler for PAR. The robust analytics platform with extensive capabilities has been delivering solid operational insights for the business. The comprehensive framework we devised for the client can be extended to handle complex data types and advanced machine learning applications for regional and global users. This also helped them gain insight into the global business view. 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
Analytics

NEXT GEN DATA AND ANALYTICS PLATFORM ON AWS FOR A P&C INSURER

Challenge A Fortune 100 Property & Casualty (P&C) insurer, we’ll call P&CDirect (PCD), had limited compute resources to perform analytics on second-by-second telematics data. The queries would take hours to resolve, which was negatively impacting PCD’s bottom line and reputation. The insurer was looking for a robust cloud analytics platform with real-time and complex analytics capabilities to use data as a strategic asset, putting information in the hands of the right people at the right time. PCD needed a scalable solution that could not only ingest and analyze new data sources quickly and efficiently, but also cost-effectively. Their goal was to spend more time on insights and action and less time on set-up. Having complete access to all their data would help PCD’s team uncover new opportunities and actionable insights across the business. So PCD tapped Trianz to implement an analytics platform that could offer custom solutions with more self-serve capabilities and manage an end-to-end catalog of data assets with searchable metadata and data lake assets. Our Approach PCD’s operational goal was to choose the right tools and migrate to the next-generation information management and analytics platform on AWS. After a thorough assessment of their existing reporting strategy, alignment, and challenges, we recommended deploying the cloud force analytics platform using AWS Cloud Managed services. Trianz’ goal was to help the client identify capabilities needs beyond data analytics. After extensive sessions of research and tool bake-offs, our specialists designed Proof of Concepts (POCs) to build capabilities and prepared feature comparison charts to map to client requirements. We developed a phase-wise migration approach for a Minimum Viable Product (MVP) by first migrating 60 TB of telematics data to AWS. We then designed their analytics platform with a reusable code. Transformational Effects Our innovative approach yielded positive results. Queries that took hours earlier could now be executed within minutes via our new analytics platform with built-in, fail-fast capabilities. The new platform is scalable enough to handle huge data ingress in the future and flexible enough to accommodate or adapt to future technology trends. It can also easily integrate with other existing or future cloud tools. 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
Cloud, Analytics

TRANSFORMING OPERATIONAL ANALYTICS THROUGH A SCALABLE AWS PLATFORM

Yancoal Seeks to Evolve Their Analytics Capabilities With the recent wave of digital evolution in the natural resources industries, Australia’s largest pure-play coal producer Yancoal, was looking to maximize new opportunities by expanding their growth strategy. Specifically, the enterprise was aiming to enhance their business agility through advanced analytics and improve the efficiency of their mining operations, particularly in the area of logistics. What Was Yancoal Looking to Achieve? The enterprise sought to reduce costs, implement operational efficiencies and shared services, and provide all customers with the certainty of product quality and delivery. In order to achieve these goals, Yancoal was interested in building a strategic data ecosystem to store and analyze operational data in line with the industry best practices. This data ecosystem would support and enhance their current business operations, while simultaneously accommodating newer technologies and business strategies via futureproofing. The projected business value that Yancoal hoped to actualize included better supply and demand management, reduced fuel consumption, increased energy efficiency and consequently enhance their reputation as one of the few eco-conscious enterprises in the coal industry. In order to strategically implement the appropriate solutions, the company partnered with Trianz’ team of analytics experts. How the Trianz Approach Upgraded Yancoal’s Analytics Platform Trianz’ consultants sat down with Yancoal’s leadership to first understand their unique business needs and challenges before collaborating with Amazon Web Services (AWS) on the ideal solution. Through a thorough analysis of the client’s existing data warehouse, Trianz and AWS created migration blueprints that addressed their specific requirements, significantly improving the outcomes of the transformation. The Trianz subject matter experts created a well-integrated AWS Cloud platform to host the client’s new operational analytics systems. By working with a single vendor, Yancoal was confident that their new platform would be fully supported in the long term, because AWS provides inbuilt updates and integrations. Finally, by engaging Trianz as their managed services partner, Yancoal was able to streamline ongoing operations support to maintain and enhance the capabilities of their analytics platform. This would ensure swift communication and issue resolutions, increasing the availability and resilience of the platform. Cloud analytics companies exist to absorb the costs of expert employees, specialized hardware, and maintenance associated with cloud analytics. These services provide valuable assets to clients who could not otherwise support these demands on their own. Dennis DeGregor, Vice President - Analytics Practice Leader Setting up the Operational Analytics Platform on AWS Yancoal’s analytics platform was built by Trianz on the pillars of AWS’s well-architected framework. The team implemented AWS Transit Gateway, Managed Active Directory and Single Sign-On, deployed infrastructure as code, enabled automation using DevOps including continuous integration and development, and used services like CodeCommit, CodeDeploy, and Terraform for migration. The Trianz team further applied architecture patterns like serverless and event-based compute, leveraging the AWS Lambda service for event-driven code execution. This enabled near real-time automated data processing and propagation from source to AWS S3 Storage using AWS Glue jobs. The team also leveraged lean architecture principles for data architecture design, such as data virtualization, by storing data on S3 buckets, and using AWS Athena to perform interactive queries. This eliminated the need for multiple extract-transform-load (ETL) and data movement operations, saving substantial data processing and storage costs. Trianz implemented application and platform monitoring using AWS CloudWatch. It was used to monitor Glue job status through CloudWatch logs, as well as to oversee infrastructure like EC2 instances for CPU and memory availability and utilization, triggering events to SNS topic in failure scenarios. The team made use of a market-leading data visualization tool, Tableau, to deliver key performance indicators (KPIs) and metrics through rich visualizations, enabling accurate and timely insights into day-to-day operations. How Trianz Helped Yancoal Realize Their Business Goals Yancoal’s engagement with Trianz enabled them to overhaul their data and analytics capabilities by working together to construct a solid operational analytics platform. They were able to achieve their key goal of proactive supply chain management to reduce costs, enhance services, and improve their carbon footprint through increased operational efficiency. Trianz also delivered significant business impact by implementing automated, real-time, and consistent reporting, as well as standardizing data. Because Yancoal also engaged Trianz as a managed services partner, the team was also able to deliver key metrics such as 100% data and dashboard availability with no downtime, 100% response and resolution, and significantly increased customer experience. The Transformational Effects and Impact Thanks to the high levels of automation that were integrated into Yancoal’s analytics capabilities, the company experienced an annual cost reduction of at least AUD 300,000, a manual effort reduction of at least 50% in report generation, and sharply reduced month-end report durations. Finally, Trianz’ implementation of the AWS solution empowered Yancoal to transform into a data-driven enterprise whose robust analytics platform now provides timely, trusted, and actionable 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 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

BUILDING A PCI-DSS COMPLIANT REWARDS MANAGEMENT PLATFORM ON THE CLOUD

Reward360 Global Services is a premier Loyalty Technology and Solutions Company. It wanted to develop a PCI-DSS compliant rewards management platform for banks in the country. THE BUSINESS CHALLENGE To design and build a loyalty management platform on the public cloud that would not only comply with stringent auditing requirements but also be scalable to other businesses TECHNOLOGY COMPONENTS Linux, Apache/Nginx/PHP/NodeJS, MySQL/MongoDB, Redis Cache, Application Load Balancers, Web Application Firewall, Application and host level Logging – ELK Stack, OSSEC, Security Incident Event Management – OSSEC, Cloud API log – AWS CloudTrail, Alert notification – AWS Simple Notification Service, IP whitelisting – AWS VPC Security Group, Layer 7 – Web Application Firewall, Host level firewall – iptables Vulnerability assessment – VAPT (OpenVAS + Nessus), Data in Transit encryption HTTPS – SSL Certificates THE APPROACH Suggested and implemented a templatized cookie cutter model for predictable deployment on AWS Cloud due to the repetitive nature of audit requirements with the banking business Made significant changes to the application architecture to accommodate compliance controls at various layers of the platform and to facilitate platform scalability Leveraged a combination of various AWS services, open source solutions, and third party solutions to achieve the necessary compliance Redesigned and redeployed the environment on AWS TRANSFORMATIONAL EFFECTS Reduced deployment time from 12 weeks to one week Highly scalable environment Option to deploy the platform as is for clients similar to banks in a cookie cutter mode Published: 2019-12-10

Explore
Cloud

CLOUD AUTOMATION, SECURITY AND MANAGED SERVICES

Re-architecture of AWS Environment, Build infrastructure as a code, Implementation of security controls & Infrastructure Managed services ServiceMax is one of the world’s leading providers of field service management software for equipment manufacturers and service providers. ServiceMax’s AWS cloud-based SaaS solution processes more than a million work orders per month, scheduling more than 300,000 technicians worldwide and managing 150 million customer devices. Trianz was selected to re-architect and manage ServiceMax’s existing Amazon Web Services (AWS) environment to achieve higher levels of performance, security and availability. The Business Challenge The client was seeking a partner to explore the use of a cloud platform as a key strategy to address infrastructure growth needs. In the given context, Trianz has initiated assessment of the Amazon Web Services (AWS) Cloud platform with the client to help explore the possibilities of executing a time bound, object-oriented, proof-of-concept based deployment on AWS. The client also wanted to build a dependable, robust and secure technology infrastructure on AWS that could: Facilitate script automation to eliminate manual process-related errors Reduce the cost of operations, as more bandwidth means more complexity and increased operational expense Minimize downtime to prevent revenue loss as network outages significantly disrupt business operations, adversely impacting customer loyalty Protect enterprise data to tackle the ever-increasing threat of cyberattacks and data breaches incidents Scale the network to equip it for future 'on-demand' growth to manage changes in real-time Enhance network performance through agile applications that can handle dynamic bandwidth needs and network topology changes Technology Components AWS Amazon VPC Amazon Route53 Amazon CloudFront Elastic Load Balancing Amazon EC2 & EC2 Autoscaling AWS Lambda Amazon s3 Elastic Block Store AWS IAM Amazon GuardDuty Amazon Inspector AWS Secret Manager AWS WAF & Shield AWS CloudFormation AWS CloudTrail AWS CloudWatch AWS Config Other Platforms: Sumologic,Qualys, OpenVPN, Wazuh, AVI, Bro & Suricata, HashiCorp Terraform, GitHub, Jenkins, Newrelic, Jumpcloud The Approach In order tore-architect and manage the client’s existing Amazon Web Services (AWS) environment., here’s what we did: Redesigned the infrastructure with AWS best practices including 'Infrastructure as Code. Developed Terraform modules to deploy the entire infrastructure, making it scalable and flexible. Introduced hub-spoke architecture and deployments for increased resilience. Introduced best practices in security such as boundary defense, CIS hardening, endpoint security, credential management, MFA, monitoring, auditing, logging, certificate and key management and vulnerability management. Implemented blue/green method of application rollouts using Terraform and Jenkins pipelines. Implemented Single Sign-On using Jumpcloud for all eligible services. Transformational Effects Better performance with improved efficiency & high availability Improved application rollout Easy to redeploy environments using infrastructure-as-a-code for CI/CD as well as disaster recovery Optimized costs and improved SLAs, while meeting customer security requirements Reduced Downtime & Improved Efficiency: Reduced 80% of downtime with the blue/green method of application rollout Reduced the timespan to spin up new application PoPs from 1 month to 1 week Enhanced Security: Passed external & internal audits Operations Excellence: Reduced false alarms Auto-remediated common anomalies Published: 2019-10-22

Explore
Cloud

MIGRATED PAYMENT GATEWAY APPLICATION TO CLOUD FOLLOWED BY MULTI-YEAR MANAGED SERVICES SUPPORT

Hosting, Monitoring and Support of a Large Payment Gateway A global fintech that manages millions of payments and credit and debit card transactions needed a partner to host, monitor and enhance their large payment gateway application, critical to their overall market penetration strategy. Business Challenge The client needed a reliable partner to host, monitor and enhance their large payment gateway application for the ME market. The firm was looking for the right partnership to support, enhance and deploy market specific programs that are critical to ensure business is not impacted and succeed beyond the transition period. Technology Components Microsoft Azure, EDB Postgres,  Payment Gateway, Splunk, Dynatrace, Vormetric, Thales HSMs, RSA SecureID and Netscaler The Approach Client partnered with Trianz to manage all aspects of MPG starting from hosting and infra & application monitoring to support and enhancements. Designed the right infrastructure solution architecture, migration strategy, rapid stabilization strategy and established the stakeholder communications. Devised Business as a Service Managed services framework that encapsulates the core capabilities required to ensure that the payment gateway application is transitioned/managed/enhanced to support current and future needs of the market. The payment gateway host on Azure followed the security, data and access requirements. Also, the architecture and design was provided based on the security requirement. SLAs and support processes aligned based on type of cloud services utilization and the format (IaaS, PaaS) of services. Transformational Effects End-to-end support for L1 / L2 activities, integrated support and incident to resolution workflow. Broader categories of production support activities across application stacks and improved security. Supports automation, optimization, agile product development and continuous improvement.

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

ESTABLISHING MANAGED INFRASTRUCTURE FOR A GLOBAL SOFTWARE CONGLOMERATE

A global software conglomerate’s subsidiary that develops and offers innovative software products wanted support to manage its OS, application deployment and production. The Business Challenge The organization wanted to establish a managed infrastructure environment by partnering with an experienced technology and consulting services provider who would extend proactive and reactive support to manage their OS, application deployment and production. Technology Components Trianz’ Cloud Support Portal The Approach Performed the automation through scripts, tools etc. to enhance efficiency, provide constant monitoring and easy infrastructure management Integrated client-identified DevOps platforms/tools and leveraged with cloud deployment Periodically reviewed and implemented necessary architectural changes Provided necessary feedback towards (cost) optimization as per best practices Load tested a target test infrastructure on need basis to establish performance patterns for performance tuning of infrastructure Provided a cloud support portal login for client’s team to raise support requests and access relevant information about the supported environment Transformational Effects Maximized effectiveness and minimized costs related to acquisition, implementation and operation of IT systems Established policies and procedures to ensure protection of client’s IT assets and integrity of their data Ensured effective compliance to security / privacy requirements Put in place industry standard security controls

Explore
Cloud

ENABLING CLOUD AUTOMATION INFRASTRUCTURE

TSYS is a leading provider of payment processing, merchant and related payment services to financial and non-financial institutions. The company operates in the credit card issuers market, ranking third in payment processing in the US. In September 2019, Global Payments Inc. (NYSE: GPN), a leading worldwide provider of payments technology and software solutions completed its merger with TSYS, forming the premier pure-play payments technology company with an extensive scale and unmatched global reach. The Business Challenge The client wanted to build a dependable, robust and secure technology infrastructure that could: Facilitate script automation to eliminate manual process-related errors. Reduce the cost of operations as more bandwidth means more complexity and increased operational expense. Minimize downtime to prevent revenue loss as network outages significantly disrupt business operations, adversely impacting customer loyalty. Protect enterprise data to tackle the ever-increasing threat of cyberattacks and data breaches incidents. Scale the network to equip it for future 'on-demand' growth to manage changes in real-time. Enhance network performance through agile applications that can handle dynamic bandwidth needs and network topology changes. Technology Components AWS Organization structure separated to departments with service control policy AWS-S3, EC2, AIM, Snapshots, EIP, NAT, AWS-VPC, Public-Private Subnets, NACLs, VPN, VGW, Endpoint Security Groups, IAM, Roles, Policy, MFA, SAML, AD Federated AWS WAF, AWS DDoS CloudTrail, CloudWatch Other Platforms: Jira 7, Splunk, Git bucket, Jenkins The Approach TSYS selected Trianz to build a continuous integration and continuous delivery (CI/CD) pipeline, which can automate the entire code deployment process. Additionally, Trianz implemented the following solutions: Created PoC for multiple cloud framework models to meet business requirements for multiple lines of business. Developed the cloud agnostic automation process (Infrastructure as a Code) through scripts like Terraform, Python, Cloud formation, etc. Improved deliverables' efficiency, monitoring and infrastructure management. Enabled continuous delivery with built-in DevOps capabilities; integration with Jenkins and platforms/ tools identified and leveraged by the client within a cloud deployment. Guided the client on implementing industry best practices while meeting deliverables' timelines. Periodically reviewed architecture and provided necessary feedback towards (cost) optimization as per best practices and industry recommendations. Provided cloud support portal login to help the client raise support requests and get access to relevant information about the supported environment. Transformational Effects Streamlined the new hire onboarding process using a single self-service offering and auto-routing of those requests, reducing manual effort. Implemented Enterprise Splunk on the cloud. Integrated on-prem cost model tool (Apptio) on the cloud using tagging technology. Enhanced visibility to software-hardware allocations and capacity monitoring. Operation Automation: The new CI/CD pipeline uses GitHub, CodeDeploy and CodePipeline to remove friction while deploying the new code. As a result, TSYS is now able to push small, incremental updates to its software, version control and documentation updates to match the pace of innovation. Enhanced Security: Organization and department segmentation with multi-factor authentication, active-directory federation control and least privilege access for developers. High-Availability: The implementation of Auto Scaling Groups, ec2, and network to handle spikes in traffic, snapshots and AIM usages to tackle immediate deployment or disaster recovery issues. Published: 2019-02-19

Explore
Cloud, Infrastructure

ENSURING 24/7 AVAILABILITY OF IT INFRASTRUCTURE

One of the largest resellers in a leading online shopping marketplace in India needed help to keep pace with its rapid growth. Existing technologies, information systems and staffing needed to be evaluated regularly. There was also a need to maximize the availability of telephony, email, messaging, network connectivity, business infrastructure, office automation, and process automation systems. The client partnered with Trianz to set up a managed services center to support its IT Infrastructure on AWS, thereby proactively and reactively addressing and resolving issues. We recommended processes that were not only compliant with industry standards and practices, but also rooted in experience with clients worldwide. With a well-defined governance structure and skilled resources across portfolios, Trianz built a managed services center that ensured infrastructure availability on a 24x7x365 basis. We also adopted a phased approach to transition work from in-house support teams to a fully managed services model. The Business Challenge Proactive and reactive support was needed to manage IT infrastructure on AWS, as well as govern associated policies, processes, contracts and documentation. Technology Components Infrastructure management through Ctrl-Dock Device management on Amazon Web Services (AWS) cloud infrastructure The Approach Studied the existing support structure and practices, including the environment for support and points of contact. Defined the mechanism for on-going support Trianz’ project management and technology teams collaborated with the client to seamlessly transition the business process and production support activities Gained familiarity with client-specific tools, call sharing between the client’s and Trianz’ team, review meetings, and reporting Recommended a core service based on a ‘business as usual’ approach, including streamlined communication, ticketing, and periodic reporting Transformational Effects Improved operational efficiency and minimized costs related to acquisition, implementation, and operation of IT systems Defined policy and procedures to secure the client’s IT assets and integrity of data, while ensuring compliance to security/ privacy requirements Established comprehensive license management process for all IT assets Increased visibility through robust service documentation and reporting structure

Explore
Cloud

GLOBAL DATA PLATFORM ON AWS - CLOUD PHASE

A leading global healthcare provider sought to leverage cloud infrastructure to build a secure, scalable and industry-compliant cloud platform that its internal teams can use for large and complex analytics in the US and Europe. The platform must follow the region-wise compliance requirements. The entire engagement encompassed a multi-vendor, multi-region deployment with a tight timeline. The Business Challenge The client wanted to build a data analytics platform for its teams to use across Europe and the US. The platform must be flexible, scalable, secure and conform to the regional standards and compliance on healthcare data. Technology Components AWS AWS EMR AWS ECS AWS EKS AWS Glue AWS VPC SageMaker AWS Lambda AWS CloudWatch/Trial AWS SNS AWS EC2 AWS RDS AWS KMS AWS S3 Elasticsearch AWS Cognito AWS DynamoDB Other Platforms: Jenkins, HashiCorp Terraform, GitHub, Chef, Ansible, New Relic The Approach Automation - Built CI/CD Jenkins pipelines to deploy AWS cloud components using Infrastructure as code (IaC) - (Git + Terraform). Implemented systems software configuration/patching automation using Chef and Ansible to adhere with GEHC compliance and security controls. Transformational Effects Client’s teams can now manage the entire cloud infrastructure and systems configuration using Automation IaC to deploy various platform environments across geographies. After proving the viability of the design to various internal customers, the Europe region has been launched and is deemed a successful platform. All maintenance activities, including monitoring and stabilization has started. The US region platform is now in the final phase of testing by various teams and is expected to be launched by the end of this year. Operation Automation: Reduced 80% of downtime with the blue/green method of application rollout Reduced the timespan to spin up a new application based on demand Enhanced Security: Passed external & internal audits High-Availability: Reduced false alarms Auto-remediated common anomalies

Explore
Cloud

CLOUD COLLABORATION

Building a collaborative workforce through robust infrastructure An education-focused, non-profit organization needed to enable collaboration among its diverse workforce of educationalists, teachers, social workers and operations staff from remote locations by leveraging technology. Business Challenge The client needed to facilitate collaboration across its rank and file – especially in remote locations – to be able to expand its presence across the country, while strengthening its workforce count. Technology Components Oracle PeopleSoft & AWS Approach Validated and finalized the cloud strategy for Oracle PeopleSoft implementation with the client. Led the assessment of the application stack for readiness. Discussed the assessed data with two cloud service providers and mapped infrastructure to services offered by these providers. The process involved mapping attributes such as: Operating systems comprised of Windows and Red Hat Linux Oracle Technology Stack Database services relying on Oracle, RDS options Notification systems based on standard SMTP services, email systems, and other push notifications Licensing models for a pay-as-you-go approach Followed up the assessment for selecting the right cloud platform with a roadmap development for a full-scale implementation including architecting a pioneering Amazon Web Services (AWS) solution, planning the project and driving the implementation cycle. Transformational Effects Scaled up infrastructure fuelling business growth for the client. Reduced execution efforts significantly due to the inherent nature of the cloud.

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 HOSTING

Migrating Host Applications on AWS A global airfare consolidation services company was unable to resolve the technical, performance and reliability problems because of being hosted on a well-known cloud services platform. Business Challenge The client needed to meet its changing capacity demands through a 24x7 elastic monitoring and alerting mechanism, and create sufficient documentation for the entire application suite where its operations were hosted. Technology Components Windows, IIS, .Net, MS SQL, Application Load Balancers, Application Caching Engines, Web Application Firewall, Content Delivery Network, Enterprise DNS Services, Virtual Private Network, Audit Logs Approach Started with requirement gathering; proceeded to application performance management. Deployed necessary architecture to ensure proper network design and implementation, code base lining, auto scaling, server bootstrapping, security implementation and load testing. Established 24x7 monitoring and management system. Transformational Effects Adopted consultative approach to develop requisite architecture for customer infrastructure on Amazon Web Services (AWS) -- between customer, AWS and AWS Advanced Partner teams. Hosted application on AWS, baselined and load tested to operate within requirements. Auto scaled layers to meet changing performance needs. Set up necessary infrastructure and documented service integration in detail. Enabled 24x7 monitoring and support after go-live in October 2015.

Explore
Cloud, Analytics

TRANSFORMING OPERATIONAL ANALYTICS THROUGH A SCALABLE AWS PLATFORM

Yancoal Seeks to Evolve Their Analytics Capabilities With the recent wave of digital evolution in the natural resources industries, Australia’s largest pure-play coal producer Yancoal, was looking to maximize new opportunities by expanding their growth strategy. Specifically, the enterprise was aiming to enhance their business agility through advanced analytics and improve the efficiency of their mining operations, particularly in the area of logistics. What Was Yancoal Looking to Achieve? The enterprise sought to reduce costs, implement operational efficiencies and shared services, and provide all customers with the certainty of product quality and delivery. In order to achieve these goals, Yancoal was interested in building a strategic data ecosystem to store and analyze operational data in line with the industry best practices. This data ecosystem would support and enhance their current business operations, while simultaneously accommodating newer technologies and business strategies via futureproofing. The projected business value that Yancoal hoped to actualize included better supply and demand management, reduced fuel consumption, increased energy efficiency and consequently enhance their reputation as one of the few eco-conscious enterprises in the coal industry. In order to strategically implement the appropriate solutions, the company partnered with Trianz’ team of analytics experts. How the Trianz Approach Upgraded Yancoal’s Analytics Platform Trianz’ consultants sat down with Yancoal’s leadership to first understand their unique business needs and challenges before collaborating with Amazon Web Services (AWS) on the ideal solution. Through a thorough analysis of the client’s existing data warehouse, Trianz and AWS created migration blueprints that addressed their specific requirements, significantly improving the outcomes of the transformation. The Trianz subject matter experts created a well-integrated AWS Cloud platform to host the client’s new operational analytics systems. By working with a single vendor, Yancoal was confident that their new platform would be fully supported in the long term, because AWS provides inbuilt updates and integrations. Finally, by engaging Trianz as their managed services partner, Yancoal was able to streamline ongoing operations support to maintain and enhance the capabilities of their analytics platform. This would ensure swift communication and issue resolutions, increasing the availability and resilience of the platform. Cloud analytics companies exist to absorb the costs of expert employees, specialized hardware, and maintenance associated with cloud analytics. These services provide valuable assets to clients who could not otherwise support these demands on their own. Dennis DeGregor, Vice President - Analytics Practice Leader Setting up the Operational Analytics Platform on AWS Yancoal’s analytics platform was built by Trianz on the pillars of AWS’s well-architected framework. The team implemented AWS Transit Gateway, Managed Active Directory and Single Sign-On, deployed infrastructure as code, enabled automation using DevOps including continuous integration and development, and used services like CodeCommit, CodeDeploy, and Terraform for migration. The Trianz team further applied architecture patterns like serverless and event-based compute, leveraging the AWS Lambda service for event-driven code execution. This enabled near real-time automated data processing and propagation from source to AWS S3 Storage using AWS Glue jobs. The team also leveraged lean architecture principles for data architecture design, such as data virtualization, by storing data on S3 buckets, and using AWS Athena to perform interactive queries. This eliminated the need for multiple extract-transform-load (ETL) and data movement operations, saving substantial data processing and storage costs. Trianz implemented application and platform monitoring using AWS CloudWatch. It was used to monitor Glue job status through CloudWatch logs, as well as to oversee infrastructure like EC2 instances for CPU and memory availability and utilization, triggering events to SNS topic in failure scenarios. The team made use of a market-leading data visualization tool, Tableau, to deliver key performance indicators (KPIs) and metrics through rich visualizations, enabling accurate and timely insights into day-to-day operations. How Trianz Helped Yancoal Realize Their Business Goals Yancoal’s engagement with Trianz enabled them to overhaul their data and analytics capabilities by working together to construct a solid operational analytics platform. They were able to achieve their key goal of proactive supply chain management to reduce costs, enhance services, and improve their carbon footprint through increased operational efficiency. Trianz also delivered significant business impact by implementing automated, real-time, and consistent reporting, as well as standardizing data. Because Yancoal also engaged Trianz as a managed services partner, the team was also able to deliver key metrics such as 100% data and dashboard availability with no downtime, 100% response and resolution, and significantly increased customer experience. The Transformational Effects and Impact Thanks to the high levels of automation that were integrated into Yancoal’s analytics capabilities, the company experienced an annual cost reduction of at least AUD 300,000, a manual effort reduction of at least 50% in report generation, and sharply reduced month-end report durations. Finally, Trianz’ implementation of the AWS solution empowered Yancoal to transform into a data-driven enterprise whose robust analytics platform now provides timely, trusted, and actionable 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 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
Analytics

CASE STUDIES: HOW BUSINESS INTELLIGENCE ELEVATES BUSINESS IMPACT

As the broader apparatus responsible for data analysis, business intelligence (BI) provides historical and current insights on business operations. But now, with modern technological evolutions such as cloud platforms, data warehousing, and artificial intelligence, BI can be enhanced and harnessed to empower predictive insights and proactive solutions. As a digital transformation services firm, Trianz realizes that there is nothing more important than keeping your organization’s “data brain” constantly primed and functioning at optimum levels. Our experts help clients tap into the significant advantages that these technologies can bring to your business intelligence apparatus. Cognitive computer systems are a good example. These systems are programmed and trained using AI and ML, with algorithms that can interpret and sometimes even build upon human cognitive capacity. This makes a wider range of more refined, real-time, and accurate data, analysis, and solutions available to businesses. Whether operational or strategic, our solutions elevate and streamline BI by making data more accessible to your team with user-friendly dashboards and clear insights free of data inconsistencies. We have helped numerous clients overcome challenges and impediments such as unclear, inconsistent, and confusing data, lagging testing frameworks and reporting architecture, and migrating entirely analog systems to the cloud. In bringing these enterprises’ business intelligence mechanisms up to current and even future standards, we have always adhered to our standards of excellence in execution. What follows are just a few of our case studies of business intelligence engagements: Custom BI Dashboard and Data Analysis Tool A global payments and technology company envisioned a digitization of their client’s access to data through a business intelligence dashboard and data analysis tool. The company 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 their development and implementation partner, helping them create and launch a platform that provided an appealing, flexible experience supported by a robust, streamlined technological framework. Cloud Migration: A Business and IT Ops Transformation A Fortune 500 global insurance enterprise approached the Trianz team to streamline their business applications and infrastructure workloads onto the public cloud. After opting to migrate 70% of its information management data, the client needed to eliminate inconsistences, improve data collection and collation, and unify their data source. This meant also moving dependent apps, infrastructure, and other support programs to the public cloud. The time frame required to complete the entire migration was three years. Trianz was chosen in a competitive process from a pool of several peers, working closely with the company’s business and IT leadership, joining a program governance task force to deploy an accelerated migration using our unique execution model. Optimized ETL Testing: Better Data Management Trianz partnered with a US-based Fortune 100 insurance company to optimize their lagging extract-transform-load (ETL) testing, which was affecting their operational data storage costs and compromising data quality, security, and privacy. The enterprise also found themselves recording unusually long durations for test data prep by both quality assurance and development teams, which was delaying their release cycles. Our team worked with them to not only optimize their ETL testing, but also to enhance their product quality and decrease operational costs. Furthermore, Trianz’s in-house TDM experts continued to provide ongoing support even following the closure of the project. We hold excellence in service and execution to be core values, and our commitment to our clients means always being on standby for guidance, troubleshooting, and other support. 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
Analytics

DESIGN AND BUILD AN OPERATIONAL MASTER DATA MANAGEMENT SYSTEM AND IMPLEMENT A DATA GOVERNANCE PROGRAM

One of the world’s leaders in higher education association and business education networks, that provides accreditation to schools of business, needed an operational master data management system that can bring together the information from multiple systems in a streamlined manner. The Business Challenge To provide a complete picture of the data about their members and the organizations that are part of the larger business education community, the association turned to Trianz to develop a solution that would aggregate, cleanse, standardize, and publish organizational master data. Technology Components Microsoft Azure Platform - Infrastructure As A Service (IaaS), Microsoft SQL Server, Microsoft Master Data Services & Microsoft SQL Server Integration Services The Approach Trianz leveraged Microsoft Azure to provide the required infrastructure and host the solution for the client. Azure offers a quick way to reduce the local infrastructure footprint while developing a new platform that would allow for future technology growth Microsoft Master Data Services was chosen as the software platform because the SQL Server back-end would pave the way for future data warehouse and data integration efforts while the front-end integration with Microsoft Excel enabled data stewards to quickly take control of their data. SQL Server Integration Services was the logical choice for data movement activities due to its inclusion with SQL Server database services. Finally, the technology solution was complemented by Trianz’ Data Governance framework that provided a vision and a plan for the right stakeholders to be involved in rules and decisions for the organization’s master data. The end result of the solution architecture was to ingest data from the company ERP system, marry that information with data from the member Survey system, provide updates to the member Survey system, and make the association’s master data available to other internal and external systems.

Explore
Analytics

TERADATA TO SNOWFLAKE MIGRATION

The client is an American multinational technology conglomerate that develops, manufactures and sells networking hardware, software, telecommunications equipment and other high-technology services and products. To utilize a new Database Technology, the client needed to migrate the Teradata code in their Business Objects Instance to the Snowflake platform. Business Challenge Owing to the licensing cost, performance issues and an overall mandate to migrate to the cloud, the client was in the middle of a migration of Teradata code to Snowflake platform. To ensure that the business was able to utilize the new database environment, the Teradata specific SQL syntax within the Business Objects environment had to be converted to Snowflake and reintegrated into the Business Objects Environment. Scope of POC Five Web-Intelligence Reports 1 Business Objects Universe Timeline: One month Teradata to Snowflake SemanticLayer Conversion The Approach The Trianz team, consisting of two Snowflake data engineers and one Business Objects Architect, thoroughly analyzed and documented the client’s Business Objects requirements, design and business processes needed to successfully implement the migration. Utilizing Proprietary Code, we extracted the SQL code from the Business Objects Universe, translated it with our custom-designed Evove software solution and then reinserted it into the Business Objects Universe. SQL Syntax proved to be programmatically successful by converting 90% of the tables, with only 10% manual conversions. The conversion was tested by running the WebI reports against the new Snowflake environment to ensure that (a) the reports run successfully and (b) the data match. In the live environment, Trianz was able to successfully run all the reports and match the data at the expected rate. Transformational Effects As a result, above 75% of Business Object instances were programmatically converted to Snowflake. Evove was able to automate the conversion of over 95% of derived tables, with only 6 tables converted manually. Not only was Trianz able to provide initial results on 40% of the reports within the first week, but they were able to complete the migration within a month. Trianz was also able to identify 6 to 7 tables that could be optimized for further Snowflake usage. This process would normally take 2 – 3 months to complete manually, and the solution can be scaled to do 5 to 6 universes within the same time frame, due to the programmatic nature of our application. 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

Explore
Analytics

ENTERPRISE DATA WAREHOUSE: CASE STUDIES

An enterprise data warehouse (EDW) can only perform at its peak if all aspects of the process – from data to analysis to reports and insights – are streamlined and purged of all confusion. Despite the rapid and continuous evolutions brought about by recent technology, many organizations still lag behind. They are weighed down by antiquated analog data collection and management systems, scattered sources of information, and inconsistent data that creates unusable insights. With the advent of the cloud, serverless data, artificial intelligence, and machine learning, the enterprise data warehouse has the potential to be transformed into a thriving center of the organization’s information and analytics. Legacy and analog data can be cleaned, verified, migrated to the cloud using extract-transform-load (ETL) processing. This way, your data can be double-checked for duplication and inaccuracies, contextualized, and curated for tailored insights. A well-maintained data warehouse brings significant value as a time- and resource-saver because it can aggregate high volumes of ostensibly random information automatically. And when an organization’s data is structured in such a methodical, automated way, its growth potential expands exponentially. As a digital transformation services firm, Trianz helps clients tap into the significant advantages that technological developments can bring to your data warehouse capabilities. In bringing these EDWs up to current and even future standards, we have always adhered to our motto of excellence in execution. What follows are just a few of our case studies of enterprise data warehouse engagements. A Game-Changing Platform on an Azure Data Lake for a Global Reinsurer A large reinsurance organization was looking to build a centralized modern data and analytics platform, leveraging cloud services that not just met its current, future, functional, and non-functional requirements, but also offered a global business view into operational insights. Looking at their existing applications, systems, reports, and challenges, we recommended a federated data management solution and laid out a roadmap to finalize the cloud infrastructure with a federated architecture. Next Gen Data and Analytics Platform on AWS for a P&C Insurer A property and casualty insurer needed a scalable solution that could not only ingest and analyze new data sources quickly and efficiently, but also cost-effectively. Their goal was to spend more time on insights and action and less time on set-up. After a thorough assessment of their existing reporting strategy, alignment, and challenges, we recommended deploying the cloud force analytics platform using AWS Cloud Managed services. Data Warehouse: From Strategy to Implementation for a Nonprofit A leading nonprofit that coordinates organ donations needed to redesign and build the legacy reporting and analytics environment of. The organization had to tackle challenges posed by an aging and poorly functioning legacy environment, including weak reporting functions and limited data access, quality, and integrity. Our data experts strategized how to best meet their goals of improved information management while overcoming these significant hurdles. Trianz experts teamed with the organization to develop and test a transformative business intelligence solution. Developing a Data Warehouse and Business Intelligence Environment A well-known university in the US needed to implement an updated computing system to phase out its legacy environment. They required an update to their information access, reporting, and analysis to shift from manual, analog reports to a digitalized solution. The primary task was to develop best practices and strategies for providing timely and accurate access to information. The goal was to effectively and efficiently keep track of and manage important data such as registration, financial aid, grades, grants, and financial information. Our team teamed with university staff to design and implement an upgraded warehouse and streamlined reporting environment. Elevating Higher Education with Better Reporting Architecture An internationally recognized leader in higher education based in Indiana needed to upgrade their enterprise resource planning (ERP) system and gain more visibility into the university finances. The challenges they faced included a lack of financial reporting capabilities needed for planning and operations, as well as more thorough and extensive auditing of financial information migrated into the new ERP environment. Trianz helped university staff by strategizing, designing, and developing an updated digital reporting environment to meet their goals. 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
Analytics

A GAME-CHANGING ENTERPRISE ANALYTICS PLATFORM FOR A GLOBAL REINSURER

Challenge Changing customer expectations, disruption of the value chain, emerging technologies – all of these call for reinsurers to turn data into a strategic asset. That’s exactly what this large reinsurance organization, which we’ll call Pacific Atlantic Reinsurance (PAR), hoped to accomplish with an analytics platform that was efficient, effective, and addressed its data and analytics requirements. PAR was looking to build a centralized modern data and analytics platform, leveraging cloud services that not just met its current, future, functional, and non-functional requirements, but also offered a global business view into operational insights. The goals were simple. The platform should: Enable self-service discovery and analysis Offer automated architecture and governance Provide faster access to raw data sets Scale for additional lines of business LOBs Accommodate different file formats for data integration Act as both a predictive and prescriptive analytics solution Our Approach We had our work cut out for us. Looking at PAR’s existing applications, systems, reports, and challenges, we recommended a federated data management solution and laid out a roadmap to finalize the cloud infrastructure with a federated architecture. Next, we built a data lake using Azure to consolidate all the client’s information in one place. We chose a data lake over traditional database management because of PAR’s need to capture internal data beyond predefined formats. This requirement was an ideal use-case for data lakes. For PAR to stay ahead in the game, it was imperative to capture diverse types of data, generate comprehensive insights, and integrate data with decision-making. With these new insights, the client could pursue their goal of becoming a customer-driven reinsurer with the ability to predict and address customer needs. Trianz specialists devised and executed a framework for reporting platform implementation approach. We also built the foundational analytics capabilities, extended the security framework for the federated solution, and fine-tuned the data governance and quality controls for data governance. Subsequent execution initiatives included deploying a regional data information model and analytics capabilities and introducing DevOps to automate the data pipeline and reporting deployment . Transformational Effects Building a global data lake turned out to be a transformative business enabler for PAR. The robust analytics platform with extensive capabilities has been delivering solid operational insights for the business. The comprehensive framework we devised for the client can be extended to handle complex data types and advanced machine learning applications for regional and global users. This also helped them gain insight into the global business view. 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
Analytics

NEXT GEN DATA AND ANALYTICS PLATFORM ON AWS FOR A P&C INSURER

Challenge A Fortune 100 Property & Casualty (P&C) insurer, we’ll call P&CDirect (PCD), had limited compute resources to perform analytics on second-by-second telematics data. The queries would take hours to resolve, which was negatively impacting PCD’s bottom line and reputation. The insurer was looking for a robust cloud analytics platform with real-time and complex analytics capabilities to use data as a strategic asset, putting information in the hands of the right people at the right time. PCD needed a scalable solution that could not only ingest and analyze new data sources quickly and efficiently, but also cost-effectively. Their goal was to spend more time on insights and action and less time on set-up. Having complete access to all their data would help PCD’s team uncover new opportunities and actionable insights across the business. So PCD tapped Trianz to implement an analytics platform that could offer custom solutions with more self-serve capabilities and manage an end-to-end catalog of data assets with searchable metadata and data lake assets. Our Approach PCD’s operational goal was to choose the right tools and migrate to the next-generation information management and analytics platform on AWS. After a thorough assessment of their existing reporting strategy, alignment, and challenges, we recommended deploying the cloud force analytics platform using AWS Cloud Managed services. Trianz’ goal was to help the client identify capabilities needs beyond data analytics. After extensive sessions of research and tool bake-offs, our specialists designed Proof of Concepts (POCs) to build capabilities and prepared feature comparison charts to map to client requirements. We developed a phase-wise migration approach for a Minimum Viable Product (MVP) by first migrating 60 TB of telematics data to AWS. We then designed their analytics platform with a reusable code. Transformational Effects Our innovative approach yielded positive results. Queries that took hours earlier could now be executed within minutes via our new analytics platform with built-in, fail-fast capabilities. The new platform is scalable enough to handle huge data ingress in the future and flexible enough to accommodate or adapt to future technology trends. It can also easily integrate with other existing or future cloud tools. 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
Analytics

SCALABLE ANALYTICS PLATFORM ON CLOUD

An analytics platform that will scale with data growth A major financial services corporation’s principal business is to process payments between the banks of merchants and the card issuing banks or credit unions, which leverage the brand’s debit or credit services. As part of the financial inclusion initiatives globally, the client in partnership with financial institutions, governments & NGO’s, is leveraging its core digital technologies to advance agriculture, transform informal to formal financial distribution channels and increase the reach of health service by providing visibility into the overall value chain. The client needed an analytics platform that will scale with data growth from identified sources, handle data ingestions processes, transform data, and continue to ingest new data sources to develop new program level KPI’s & generate insights on how each program is performing. Business Challenge Existing analytics process is not robust and scalable, and is time-consuming. Nil or inconsistent view of data / insights; prone to manual errors. Existing platform can’t support the growing external reporting needs and the user community with program maturity. Dependent on the merchants & banks to share the information systems. Tools and Technology Stack Data LakeStore SQL DW Data Factory V2 SQL Server Databricks Power BI Python R .NET ANGULARJs Visual Studio Team Services Approach Data & ETL: Move the data from on-prem using ADF V2 to Azure Data Lake Store and perform the ETL operations using Azure Data Lake Analytics using U-SQL & SQL Stored procedures. Perform the data orchestration leveraging the ADF V2 & load to SQL DW. Visualization: Rewrite the canned reports using Power BI User Portal : A user portal is developed using MS.Net and Angular.js to render the power Bi reports and display the KPIs based on the user role access Data Science : Data scientists provided with the capability of leveraging Azure Databricks service to perform advanced analytics & ad-hoc querying Security :Leveraged Azure AD service with Service Principal MFA and authorization maintained in DevOps: Leverage MS VSTS to create a CI/CD pipeline to achieve end-to-end automated build and deployment Monitoring:Use Azure monitoring service to monitor the service and infrastructure health and availability Transformational Effects Data Lake with Azure Analytics was unique and instrumental in engaging business upfront & throughout the solution. End-to-end automated deployment process leveraging DevOps increased the frequency of the data availability to the business. Also, the platform provided robust environment scalability with better performance results. Comprehensive data security framework by leveraging cloud based encryption techniques helped secure the PII and other sensitive data. Actionable insights from data were generated using PowerBI with different user access roles.

Explore
Analytics

A SCALABLE ANALYTICS PLATFORM BUILT FOR SPEED AND GROWTH

Needing Data Insights to Forecast and Adapt A company we’ll call TeraDebit needed an analytics platform that could scale with its growing data, and handle data ingestion and transformation processes. Their key objective was to provide a comprehensive business intelligence capability for portfolio leaders to evaluate and compare program performance using on standard KPIs. A major financial services corporation, TeraDebit’s primary business is to process payments between the merchant banks and other debit card issuers, had partnered with various financial institutions, governments, and NGOs to leverage its core digital technologies. Its hope was to advance agriculture, transform informal to formal financial distributions channels, and increase the reach of health services by providing visibility into the overall value chain. TeraDebit was seeking to use analytics to foresee and adapt changing customer service expectations and need. However, TeraDebit’s heavy reliance on the merchants and banks to share information limited its capacity to generate actionable insights. Their existing analytics process was not robust or scalable and was therefore unable to support their external reporting needs. Like many companies undertaking digitalization and business intelligence initiatives, TeraDebit found the time-consuming process required to gain insights prohibitive. Additionally, an incomplete and inconsistent view of data/insights made results prone to manual errors, which could impact the client’s reputation. Business Challenges and Our Approach To summarize, we validated the client’s issues and challenges as: The existing analytics process was slow, not robust, and not scalable. There was little to no view of data. Insights were inconsistent and prone to manual errors. The existing platform couldn’t support external reporting needs nor accommodate projected growth. The client was dependent on merchants and banks for data, which further slowed insights. After a thorough analysis of the client’s existing analytics platform, we shared our perspective on Azure solutions and recommended Azure Data Lake Analytics as one of the options best-suited to the client’s needs. Working within a tight timeline requirement, we started by moving the client’s on-premise data using ADF V2 to Azure Data Lake Storage. Our specialists identified best-in class tools in the Azure environment for the extract, transform, and load (ETL) operations. For a powerful and all-encompassing view of the actionable insights generated, we rewrote canned reports using Power BI and further developed a user portal using MS.Net and Angular.js. These tools helped render the Power BI reports and enabled the client to have a clear and transparent view of key performance indicators based on the user role access. Tools & Technology Stack To make the client’s analytics process robust, we leveraged Azure’s Databricks service to perform advanced analytics and ad-hoc querying. We also introduced Azure AD service with service principal multi-factor authentication and database authorization to make the complete process secure. To achieve an end-to-end automated build and deployment process, we implemented Azure DevOps, creating a CI/CD pipeline. Finally, to enable an “always-on” service, we used Azure’s monitoring service to monitor the service and infrastructure health and availability. Transformational Effects Our innovative approaches yielded tremendously positive results. Our solution included an end-end automated deployment process leveraging DevOps, which increased the frequency of the data availability to business and enabled data consistency and removal of manual errors during key sections of the data flow. Our comprehensive data security framework leveraged cloud-based encryption techniques to secure the PII and other sensitive data using different levels of user access roles. The client’s users are now able to quickly generate actionable insights in real-time using PowerBI. Implementing a data lake with Azure Analytics was unique and instrumental in engaging the client’s business throughout the entire journey of solution design and build. The client has realized far better performance results and their analytics platform’s robust scalability. 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
Analytics

STRATEGY, DEVELOPMENT AND IMPLEMENTATION OF AN ENTERPRISE DATA WAREHOUSE AND BUSINESS INTELLIGENCE ENVIRONMENT

A reputed university in the US looking for a new series of computing systems to replace its legacy environment. It needed to develop best practice solutions and strategies to provide timely and accurate access to information to track and manage registration, financial aid, grades, grants, purchases, and staff compensation. The Business Challenge The university required analytical capabilities and skills to facilitate information access, reporting, analysis and distribution and replace its legacy environment that used a set of paper reports from siloed legacy systems that were often untimely and contained conflicting data. Technology Components Oracle, BusinessObjects, Cognos and Informatica. The Approach Trianz was engaged by the university to develop the overall strategy of the future business intelligence environment, plan the rollout of the program and assist the university staff with the development, testing, training and implementation of the solution. Trianz worked with the management of the university to determine a top-down business strategy that was then decomposed into the business, data, technical, application, organization and process requirements. Trianz assisted the university in selecting the proper toolsets, trained staff on BI/ DW best practices and drove the development while mentoring the staff through implementation. Transformational Effects Assisted the university in developing their governance, processes and organization while implementing the Business Intelligence solution serving several hundred users and 70,000 students executing thousands of queries in the areas of registration, operations, financial analysis and planning.

Explore
Analytics

STRATEGY, DEVELOPMENT AND IMPLEMENTATION OF AN ENTERPRISE DATA WAREHOUSE AND BI

A leading not-for-profit organization coordinates organ and tissue donation and provides public education on donation, needed a complete redesign and build of their legacy reporting and analytics environment. The goals were to provide improved information management capability with better reporting functions, executive dashboards; and better data access, quality, consistency and integrity. The Business Challenge The organization needed a new reporting and analytical environment to replace an aging and poorly functioning legacy environment. A key part of the strategy centered around the planned implementation of a new medical records system with enhanced data capture capabilities combined with the integration of referral data. The end-goal was to provide a robust analytical environment that enabled a complete view of the process, the efficacy of transplants, the efficiency of the matching and overall management of operations. Aside from the standard data integration challenges, major data integrity issues had to be resolved to increase the accuracy of the data and improve the acceptance by users of the system. Technology Components EMR, MS SQL Server, Oracle, Power BI & SSRS The Approach Professionals from Trianz were engaged by the organization to develop the overall strategy of the future business intelligence environment, plan the rollout of the program and assist their staff with the development, testing, training and implementation of the solution. Trianz’s role included working with the organization’s management team to determine a top-down business strategy that was then decomposed into the business, data, technical, application, organization and process requirements. Trianz consultants assisted them in selecting the proper toolsets, trained staff on BI/DW best practices and drove the development while mentoring the staff through implementation. During the engagement, Trianz worked closely in assisting the not-for-profit firm to develop their governance, processes and organization while implementing the Business Intelligence solution serving all levels of management and operations. Transformational Effects The new environment provides users with instant ad-hoc and guided analytical functions along with self-service visualization capabilities. Furthermore, users can now access critical business information and insights in seconds, rather than days.

Explore
Analytics

DATA WAREHOUSE REPORTING ARCHITECTURE PLANNING, REPORT DESIGN AND DEVELOPMENT

The Indiana based client, an internationally recognized leader in higher education, required financial reports to audit the implementation of a new ERP system and to provide much needed visibility into the finances of the University. The Business Challenge As part the implementation of an ERP application the University embarked on the development of a financial reporting capability. The design and development of the phase one reporting architecture was critical for the auditing of the financial information being moved into the new ERP environment and provided long sought financial reporting capabilities needed for planning and operations. The audience for the initial roll-out of the reporting environment included the President of the University, the Controllers office, auditors and financial planners. Technology Components Oracle 11i & Business Objects The Approach Working closely with the Universities staff, Trianz led the planning, design, development of a Business Objects reporting environment. This being the first iteration of reports utilizing a new data structure, Trianz assisted in the overall performance turning of the environment, design of the BO reporting Universes, layout of the reports, development, user acceptance and implementation turnover. Transformational Effects The architecture and process Trianz designed and implemented and transferred to the University staff will be used to implement other reporting applications as well.

Explore
Analytics

DATA MIGRATION ANALYTICS FOR A MAJOR SEMICONDUCTOR MANUFACTURER

Deploying DW with Analytics & Custom Reporting Capabilities A major US-based semiconductor manufacturer was facing several performance issues with its disparate databases and transactional systems. The urgent need was for a centralized data warehouse with reporting capabilities. Business Challenge Designing and implementing a data warehouse and custom analytics capabilities to reduce the burden on the client’s IT and create a single source of truth. Technology Components Oracle Database, Oracle Data Integrator, OBIEE Approach Finalized end-state vision for an enterprise data warehouse solution including tools and processes Prepared program roadmap with phases and deliverables Analyzed source systems and captured detailed business requirements Architected EDW solution and designed Dimensional Data Model and ETL and BI interfaces Created entity-level and attribute-level relationship documents Created reusable ETL components that could be used across various mappings Created physical layer, business view layer and presentation layer in OBIEE for operational and analytical reporting Implemented EDW system across the client’s departments by organizing workshops, imparting trainings, and bringing necessary organizational changes Defined KPIs and built live queries to build prototypes based on excel dumps for more than 20 different dashboards in a set of business workshops Enabled data extraction using queries built during prototype and validated the data plumbing, KPI derivation and dashboard development driving the adoption Transformational Effects Provided a single source of truth for all strategic, tactical and operational reporting to help reduce cost and increase revenue Deployed a centralized data governance and stewardship to facilitate multi-stakeholder usage Implemented real-time reporting and analytics to help analyze financial performance, trends and risks at each business function level

Explore
Analytics

OPTIMIZING ETL TESTING THROUGH TEST DATA MANAGEMENT

A US-based Fortune 100 property and casualty insurance company was suffering from sub-optimal ETL testing which, in turn, was leading to increased operational data storage costs, compromised data quality, and inadequate test data security and privacy. The company was also clocking unusually high time spans for test data preparation by QA and DEV teams, which was adversely affecting release cycles. Trianz not only optimized the company’s ETL testing to enhance its product quality, but also decreased operational data storage costs while improving test data security and privacy. It also ensured that time spent by QA and DEV teams on test data preparation was reduced, which eventually improved release cycles. THE BUSINESS CHALLENGE The organization was facing challenges like high operational data storage costs, compromised data quality, and inadequate test data security and privacy due to sub-optimal ETL testing. TECHNOLOGY COMPONENTS Informatica ILM Tool THE APPROACH Analyzed test data requirements, existing systems, and table relationships Imported all the driving tables into ILM workbench Designed 20 masking rules to mask secured columns Created 97 and 44 tables entity for the two identified subjects | Moved data into test environment based on two months’ data as subset criteria Ran ETL code on top of subset data created in test environment and identified valid defects TRANSFORMATIONAL EFFECTS Built ready-to-use test data to reduce Dev team’s deployment time (approximately four cycles down) Enabled defect detection in early stages of lifecycle due to qualified test data Implemented TDM best practices to create realistic, referential intact and secure test data without impacting business information Improved test coverage by enabling production like data in DEV and test environments for testing all valid business scenarios Solution is currently deployed in multiple projects for the client, and is being leveraged successfully for executing projects Trianz is equipped with in-house capability -- with TDM experts -- for providing ongoing support

Explore
Analytics

ENTERPRISE DATA WAREHOUSE STRATEGY, STUDENT AND FACULTY DATA MART PLANNING, DESIGN & DEVELOPMENT

A premier Catholic university rooted in the Jesuit and Marymount traditions, wanted to implement an information management environment that could provide user-friendly data reports and analyses. The Business Challenge The University wanted to implement an information management environment to facilitate a culture of fact-based data analysis by providing easy and timely access to accurate and user-friendly data reports and analyses. This information would support both strategic and tactical analysis, decision making and planning at all levels of University operations. Technology Components SQL Server, Oracle & Business Objects The Approach Trianz was engaged to assist the University’s Information Technology, Institutional Research and several other departments by leading the planning, design and deployment of a data warehouse and business intelligence architecture. Transformational Effects Initially, the University engaged Trianz to design a student data mart, but strong project success resulted in an expansion of scope to take a step back and look across the entire University’s information needs and rapidly deploy a strategy for a coherent and tightly coupled data architecture The next tactical projects focused on the design and build of a faculty data mart and reengineering ETL routines while beginning to grow the enterprise data warehouse. Future plans include addressing other areas of the University that demand better information access including: alumni, advancement & development and student records.

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
Digital Apps

DEFINING DIGITAL TRANSFORMATION FOR A GLOBAL INSURANCE LEADER

IT Strategy and Execution Plan to Align Initiatives to Corporate Objectives of Digital Transformation and Spend Optimization from ‘Run’ to ‘Growth’ The IT organization of a global insurance leader needed to align with the corporate-wide transformation. Trianz was engaged to collaborate in defining and articulating the client’s 3-year strategy to enable business growth while servicing technology debt and upgrading the existing team skills. Business Challenge/Objective The client had a decentralized organization, which became expensive and slow to react to change. We identified the core principles needed to drive the articulation of IT’s vision and specific action plans along with detailed financial models and organization changes. Approach Identified outside influences through our research capabilities to define the impact of digital transformation Worked with the IT leaders to position this within the context of their current IT architecture, business needs and organization capabilities Articulated the strategy to business leaders, IT leaders and IT teams Transformational Effects Alignment of IT teams across organization with a clear call to action Clear definition of the IT strategy themes such as “Modernize the Architecture” and “Build for Local Experiences” Alignment with business priorities and identification of synergies between the Business and IT needs​ Detailed next steps and roadmap for each theme Governance model to ensure change Ability to move forward on a number of new initiatives to enable new business capabilities and pay tech debt

Explore
Digital Apps

WEB-BASED CASH LOGISTICS

Custom Application Development for a Leading Cash Logistics Service Provider A large provider of armored car transportation, ATM servicing, currency and coin processing in business and security services, needed a web based cash logistics system. Trianz was engaged to develop a centralized web-based cash logistics system to streamline the data management and retrieval process. Business Challenge The client has several branches that are operating individually, leveraging a system called “One System.” It was becoming increasingly complex to manage and retrieve data, and the maintenance costs of the database were also high. The organization was looking for a centralized system to be consistently used everywhere. Technology Components .NET Framework & Oracle Database 10g Approach Trianz developed a web-based cash logistics solution on .Net framework and Oracle database 10g Started with Waterfall model and shifted to agile Delivered first production-ready product in a span of 2 years and trained all system users Managed a dedicated Offshore Development Center for the engagement with specialized development and delivery teams Transformational Effects Automated cash logistics information processing Secured the storage of account details of the client’s customers and enabled automated money processing The client has been using the system since 2004 since then, Trianz has been the client’s Technology Partner, providing industry-best features to its end-customers.

Explore
Digital Apps

BRINGING SMART-CLIENT AUTOMATION TO THE FIELD

A home security surveillance solutions provider had challenges with data synchronization and user-based security of mobile applications used by field service personnel. Lack of intuitive, lightweight applications and limited connectivity options both increased cost and hampered productivity. To allow for systematic coupling of technician payroll time and related job time, the client partnered with Trianz to develop an SOA-enabled smart-client application. This application had a self-version upgradation feature, and consumed minimal wireless bandwidth. The application was built leveraging Microsoft technologies, design patterns and Microsoft’s best pattern and practices. It integrates seamlessly with handheld barcode scanners, and provides real-time insights into equipment inventory to increase technician’s productivity on the field. THE BUSINESS CHALLENGE Client needed an intuitive, secure mobile application that improves productivity of field service technicians’ while reducing operating cost. TECHNOLOGY COMPONENTS Microsoft Dynamics MASterMind Integrated Software Platform MASterMind Integrated Software Platform THE APPROACH Developed a SOA-enabled smart-client application, by adhering to International Standard ISO/ IEC 17799:2000 and PCI Security Standard. Phased out the existing Windows CE based solution while rolling out the new solutions Requirements gathering was done at client’s location, whereas analysis, design, coding and testing was carried out at Trianz’s offshore development center. TRANSFORMATIONAL EFFECTS Reduced technician time spent on completing a job in the field Reduced cost of operation through minimal usage of cellular wireless bandwidth Provided field security to ensure right information to right person Reduced rollout time through self-version upgradation feature Supported multiple connection protocols such as Wireless, Dialup, Ethernet

Explore
Digital Apps

UNIFYING SALES OPERATIONS WITH A DEAL MANAGEMENT PLAYBOOK

A Fortune 100 network equipment and services provider sought to organize deal managers together regionally under a Deal Management Office (DMO). The DMO was envisioned to be the single operational and execution arm for managing deal types within seven different monetization models. To establish the proper steps for managing deals and provide end-to-end visibility on deal status, the client first needed to develop management playbooks. Trianz worked closely with the client to establish best practices, optimize processes, and define roles and responsibilities for key stakeholders. DMO playbooks were created to provide an overview of the key steps involved in the Customer and Partner Services (CPS) organization’s deal management lifecycle, aligned with the client’s monetization models. The playbooks are meant to guide new deal managers to understand, follow and track key activities for deal variations for each monetization model. THE BUSINESS CHALLENGE Deal managers lacked standardized reference documents to understand deal types and monetization models, leading to inefficiencies and constraining end-to-end visibility. TECHNOLOGY COMPONENTS PEGA (used later to create workflows) THE APPROACH Mapped all deal types to the seven monetization models, and defined playbooks according to models Collected the necessary documents to define, bring structure to, and validate the process steps for each playbook Navigated complexity of different CPS teams having their own steps to manage and execute deals TRANSFORMATIONAL EFFECTS Established consistent and scalable deal management process Optimized deal cycles across regions Optimized resourcing model for deal management Provided end-to-end visibility on deal status throughout lifecycle Enhanced collaboration between deal managers and other groups Playbooks now used as inputs for workflow managements in PEGA

Explore
Digital Apps

IMPROVED PROCESS EFFICIENCY WITH DIGITIZED WORKFLOWS

A Tier 1 insurance company needed a centralized workflow system to create and maintain mortgage loan transactions. Their old processes generated excessive paperwork, making tracking status and reconciling data both time consuming and inefficient. With only a fraction of documents digitized, hard copies of loan documents were stored in vaults. Further manual reconciliation led to costly inconsistencies and lack of transparency. Trianz implemented a centralized workflow system with the ability to create, index, archive, and retrieve mortgage documents and communications. Configured an audit trail to seamlessly track documents at various stages. Enabled users to quickly estimate payments with an online loan calculator. Then added a centralized reporting dashboard to make the process transparent. The result? Faster, more effective decision-making related to mortgages, and beyond. THE BUSINESS CHALLENGE Lack of digitization and manual reconciliation lead to inefficiencies, inconsistencies, and lack of transparency in loan administration, accounting, tech services, and field offices. TECHNOLOGY COMPONENTS ASP.NET, SharePoint 2010, Telerik Controls, and Quartz.NET. THE APPROACH Configured workflow with pre-defined events, tasks and subtasks Executed delegation component for parallel processing Built enterprise search feature to fetch deal documents Enabled entitlement implementation based on roles Created SharePoint repository for easy document migration Established centralized dashboard with reporting and charting TRANSFORMATIONAL EFFECTS Reduced dependency on paper documents Increase productivity from workflow automation Removed redundancy / duplication Document vaulting in seconds Increased transparency between groups Reporting Dashboard

Explore
Digital Apps

STREAMLINED OPERATIONS THROUGH INCREASED COLLABORATION

A US-based tier 1 real estate debt and equity investment company had issues with disparate business practices across divisions. Dependence on physical documents and manual processes resulted in duplicated efforts and data inconsistencies. Additionally, limited collaboration and snail mail communication with external partners increased turnaround times. Lack of a centralized structured data and reporting had further limited the management’s visibly into processes. The client partnered with Trianz to build a solution to streamline operations for its real estate investment division. Trianz digitized document archival and retrieval, automated workflows for core processes, built self-service portals for borrowers, and enabled dashboard and reports for executives. THE BUSINESS CHALLENGE Disparate systems and manual processes hampered the management’s visibility into the deal lifecycle and its ability to make informed investment decisions. Further lack of collaboration with external stakeholders had increased turnaround times. TECHNOLOGY COMPONENTS ASP.NET SharePoint 2010 Custom Controls THE APPROACH Implemented a centralized business process management system that captures all pertinent data from deal submission to deal funding of deals. Established workflow- enabled processes for administration of loans from its inception to maturity. Created a centralized document repository with a search feature and the ability to share and collaborate with external parties. Digitized calculators for use at every stage of the deal lifecycle to accurately calculate yield and other critical parameters. Built an online self-service portal for borrowers to seamlessly access current and historical statements—and a centralized dashboard with reporting for executive management TRANSFORMATIONAL EFFECTS Elimination of manual efforts with improved accuracy and process efficiency Improved visibility into status of each transaction throughout deal life cycle Increased deal acquisition with the ability to process high number of deals Management ability to analyze trends and make informed investment decision Improved collaboration with external parties resulted in faster deal closures

Explore
Digital Apps

24/7 APPLICATION AVAILABILITY FOR P&C INSURANCE PROVIDER

Application Support in a 24/7 Model Ensuring High Application Availability and Performance A large Property and Casualty insurance provider was looking for a reliable partner to manage its corporate applications - the Enterprise Technology Services (ETS). Trianz was engaged to manage the application in a 24/7 model ensuring high application availability and performance despite complicated user requests, involvement of multiple stakeholders and high volumes of customer interactions with the application. Business Challenge The client had to provide regular and frequent updates due to system stability challenges. Complicated user requests were necessitating regular follow-ups and communication. Also, the upstream and downstream systems and people dependency on multiple stakeholders were creating issues. The system was unavailable due to frequent critical errors. Technology Components 50+ enterprise applications & 15+ technologies Major technology areas – Java, Mainframe , Oracle HR, Informatica, Documentum Captiva, Unix and Linux Approach Completed automation of key processes Identified improvements in different applications through investigations and analysis Completed a high number of permanent fixes Provided faster and reliable workarounds for quick customer satisfaction Performed new technology platform migrations Established metrics-driven framework to measure success and failure Built iterative functions to develop competency in regular tasks Transformational Effects Improved the overall total cost of ownership Increased customer satisfaction by increasing system uptimes and service level optimization & quick turnaround on issues Enhanced user experience by improving the resolution times of the issues Elimination of issues through incident resolution Streamlining of process to become more mature and impactful

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

SALESFORCE ASSESSMENT, DATA GOVERNANCE

Assessment, Roadmap and Data Governance Consulting to Enhance and Automate Salesforce.com Effectiveness The client is a leading provider of unified solution for IT Security, IT Service Management, IT Asset Management, Unified Endpoint Management, Identity Management and Supply Chain Management. Through a merger of two prominent firms and other acquisitions, the firm has grown to become a global enterprise with 1,600 employees in 23 countries. The client engaged Trianz to enhance and automate salesforce.com effectiveness. Business Challenge The firm leverages SalesForce.com to manage its customer leads, contacts and accounts and assign sales territories. Their new unified sales strategy required integrating customer and sales rep hierarchies to more effectively cross-sell and upsell. However, a recent acquisition resulted in a significant amount of duplicate customer and account records within Salesforce. The Approach In early 2017, the organization engaged Trianz to perform a detailed assessment of the situation and develop a strategy and roadmap to resolve their biggest issues. This included the following recommendations: Adopt new governance structures and align resources to support the firm’s new unified sales strategy. Fix data at rest and enhance the ‘sales lead to order’ process with automated duplicate checking. Automate their complex Sales Territory Assignment rules. Upon acceptance of Trianz’ recommendations, the organization created an in-house project to fix data at rest. In addition, they engaged consultants from Trianz’ Digital and Analytics practices to perform the following: Implement a Corporate Data Governance Council, including senior leaders from all major areas of the business: Corporate Strategy, Engineering, Finance, Sales, Marketing, Product Management and Human Resources. Integrate DupeBlocker with Salesforce. Custom build a rules engine to automate the complex sales territory assignment rules. Transformational Effects The newly formed Data Governance Council advised and approved decisions made by data stewards and technical architects, to automate and govern their Account and Contact data. Within a short period, the firm deleted roughly 20% of their duplicate and erroneous account data, automated the deduplication of lead, contact and account data using DupeBlocker, and automated the sales territory assignment rules within Salesforce. This cross-functional effort significantly improved the effectiveness of the firm’s sales team and allowed them to regain valuable hours they previously spent sifting through duplicate customer accounts. The Data Governance Council has continued to adopt similar data governance policies and procedures for their Employee, Opportunity & Product data domains.

Explore
Digital Apps

CREATING A MODEL FOR GLOBAL REVENUE ASSURANCE

A global network equipment manufacturing company envisioned establishing a strong, auditable revenue assurance processes and controls for its sales organization. For strategic deals, the client’s sales organization had the power to create non-standard arrangements. As a result, sales contracts may cover multi-year products and services and may have dual or even multiple sales contracts—including unique volume purchase agreements, rights of return, demo evaluations, special acceptance terms, and other exceptional terms and conditions. Due to non-standard sales deals, the existing processes and controls could not consistently capture all revenue deferrals. And with disparate processes and different business owners in the sales lifecycle, the client could not determine the revenue streams and establish proper evidence of revenue, or verify whether the deferred revenue for nonstandard terms was being treated by their policies. To build a robust revenue assurance framework, our team of consultants first established work groups to channel contracts and orders through reviewing, identifying non-standard terms and conditions, confirming revenue-impacting terms, matching orders to contracts and ensuring internal systems and processes captured appropriate deferrals. We further segmented revenue based on geography, deal sizes, and standard vs. non-standard terms and conditions to conduct a comprehensive contract, customer and transaction review. Trianz experts collaborated with a team of over 90 controllers worldwide to review exceptions and enable decision-making around revenue recognition and reserves policies. THE BUSINESS CHALLENGE To track and measure revenue across the lifecycle of complex non-standard deals, the client needed a robust revenue assurance model and a technology platform to automate related finance processes. THE APPROACH Ensured proper revenue documentation and treatment by performing contract reviews, order matching, system checking, and by interviewing the client's controllers to discuss and uncover problems. Sustained existing controls and defining long-term remediation for future process improvements that would be aligned with the client's IT strategy. TRANSFORMATIONAL EFFECTS Created a sound, auditable revenue assurance processes and controls on time for the client's external audit. Transitioned into a monitoring phase to take on the responsibility for meeting continued revenue assurance requirements. Outlined a roadmap for fundamental processes and policy changes, and introduced systemic controls aligned with long-term business strategies and initiatives.

Explore
Infrastructure

CONSOLIDATING INFORMATION TO IMPROVE IT EFFECTIVENESS

A leading school district in Georgia, U.S., was using a helpdesk system with no automation, and no authorized process to track IT assets spread across more than 100 sites. Frequent changes to infrastructure caused unanticipated outages, and lack of a well-defined process to resolve such incidents resulted in frequent SLA breaches. The client partnered with Trianz to map applications, as well as organize and consolidate information to enable effective service management. Trianz installed and configured the IBM Tivoli Application Dependency Discovery Manager (TADDM) solution to discover a complex infrastructure with multiple firewalls, air gaps and hardened security. We also implemented ITSM operational and process management tools, including endpoint management, configuration and change management, in addition to integrating TADDM and BigFix solution to populate Configuration Management Database (CMDB). Additionally, Trianz developed a process to automate impact analysis and view Request for Change (RFC) details from the TADDM application. Rolling out Endpoint Manager (BigFix) was critical to ensuring all hardware and software assets and their usage across sites were tracked in a centralized repository. The Business Challenge A reliable source of data was needed to accurately track IT assets and a dearth of well-defined processes to analyze and resolve critical outages. Technology Components IBM Tivoli Application Dependency and Discovery Manager IBM Control Desk Endpoint Manager (BigFix) The Approach Rolled out a service management and application affinity solution in a phased approach. Initial focus was to build an authorized asset repository for an end-to-end integrated service management solution. Implementation was completed within 9 months of kick off. Performed a steady state run and maintenance for another 2 years before transitioning the engagement to client personnel. The solution has been deployed across more than 100 sites within the state of GA, and is the primary help desk and asset management solution for the school district. Trianz ensured sufficient training to IT and non-IT users within the first few weeks of solution go-live. Transformational Effects Automated analysis and inputs prior to infrastructure change Minimized downtime from elimination of trial and error Enhanced visibility to software-hardware allocations and capacity monitoring Facilitated usage-based allocations to revenue/cost centers directly into general ledger Streamlined new hire onboarding process using a single self-service offering and auto routing of those requests, reducing manual effort

Explore
Infrastructure

ENTERPRISE MONITORING MANAGED SERVICES

Centralized Event Management, Self-healing and Auto-remediation of incidents A Leading Auto and Personal Insurance Provider’s current homegrown IT Service Request Management tool was nearing end of vendor support and was facing frequent performance and stability problems. Given the significant growth in capabilities in ITSM tools over the last five years, a replacement will move the client to a new platform with improved usability for the end user and a significant increase in automation and integration capabilities. Business Challenge Manual processes and growing complexity of the environment was overloading IT staff, resulting in longer times (approx. three days) to resolve critical incidents and growing backlog (~1000) of work requests IT staff was consumed with reactive tasks leaving no time for process improvement. Low level of integration of multiple tools and siloed repositories of information (CMDB, incident logs, ITOM) made it difficult to correctly diagnose and resolve incidents first time, resulting in a significant rework effort and time to close incidents. Business Objectives Increase customer satisfaction level by reducing manual operation errors and ensure resolution of incidents within the committed SLA. Increase visibility and reporting to SLA metrics and elimination of aged backlog work. Reduce human errors related to manual tasks and improve efficiency through targeted automation and integrations. Key Deliverables Integrated existing monitoring and incident management tools (IBM and Netcool monitoring, BMC Remedy/ServiceNow) into a centralized event management system. Implemented auto-remediation of events using IPSoft. Developed correlation rules within Netcool to de-duplicate events. Validated automation logic and created SOP documents for IPSoft to support continuous development of automation scripts. Provided necessary 24x7 support for server monitoring. Implemented self healing by Netcool & IP-Center AI integrated with ServiceNow. The Approach Performed workshops with business and IT stakeholders to identify people, process, tool issues and desired outcomes for eight weeks. Created future state architecture and end-state visualization for integrated solution. Staffed a blended team of client and Trianz onshore/offshore resources to attack backlog Took complete control over the server monitoring by providing the necessary support. Transformational Effects Decreased the incident remediation time and ensured adherence to all committed business SLAs. Reduced the backlog of work requests by 91% over a period of five months. Estimated improvement of 20% in staff efficiency.

Explore
Infrastructure

IT SERVICE MANAGEMENT : END POINT MANAGEMENT AS MANAGED SERVICE

The client is an $18B engineering firm and a global provider of technical, professional, and scientific services, looking for a unified ITSM and endpoint management platform. It also wanted integration between ITSM and the endpoint management system. The client’s main aim was to reduce all the current manual processes. THE BUSINESS CHALLENGE Lightly used ITSM instance with little attention to process initiatives; Underutilized request management, no self service portal; No analytics or baselines to drive/manage improvement No integration to other capabilities; Endpoint operations causing lots of overhead on network and hitting performance bottle necks; SCCM infrastructure was aging and too expensive to manage Lack of automation for IT operations; Pending M&A activity threatening to slow things even more. Business Objectives Key Deliverables  Lightly used ITSM instance with little attention to process initiatives; Underutilized request management, no self service portal; No analytics or baselines to drive/manage improvement  No integration to other capabilities; Endpoint operations causing lots of overhead on network and hitting performance bottle necks; SCCM infrastructure was aging and too expensive to manage  Lack of automation for IT operations; Pending M&A activity threatening to slow things even more  Unified ITSM platform through ServiceNow  Endpoint management through BigFix and SCCM  Integration of ServiceNow with BigFix and SCCM THE APPROACH Assessed current state and growth including M&A to develop strategy and execution roadmap Performed detailed assessment on the existing ITSM applications, tools, integrations and relation with other ITSM process / initiatives. Provided a detailed gap analysis document Conducted workshops with various business units, gathered requirements and developed functional requirements document Defined a conceptual end state ITSM & endpoint architecture to meet business and IT needs Delivered holistic solution as a service; Endpoint as a service covering patch management, OS Distribution, Software Distribution, Power Management and Remote Control Self Service Portal and Automated Password Reset; Buildout for automated change management; Normalization and reconciliation of CMDB; Monitoring Analysis and process improvement; Event Management Integration; IT Operations Center Buildout

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

DEPLOYING A COMPREHENSIVE ENDPOINT MANAGEMENT PLATFORM

A leading vehicle rental provider (operates multiple car rental brands in nearly 10,000 corporate and franchisee locations across the globe) was finding it difficult to seamlessly roll out patch management across its 3,000-plus locations. Inadequate asset discovery and management, authorized assets management and license compliance management, besides network congestion and poor network performance were some of the other problems the company was experiencing. Trianz successfully replaced the company’s then-existing SCCM with BigFix to eventually deliver a comprehensive Endpoint Management Platform. The Business Challenge The organization needed to streamline its asset management process, make patch management rollout seamless, bring all its authorized assets under a single umbrella for effective service management, introduce license compliance management, and remove network congestion to improve network performance. Technology Components BigFix 9.5.3.211 BigFix Inventory 9.2.5.1 The Approach Installed BigFix 9.5.3.211 and BigFix Inventory 9.2.5.1 Installed NMAP scan for network discovery and managing network inventory Deployed BigFix Inventory Configured Relay Affiliation (a more sophisticated control system for automatic relay selection) for better endpoint management Configured Tivoli Remote Controller, OS Deployment, Power Management and MaaS360 Configured Lifecycle Management, Patch Management (Windows, AIX, Linux), Security Compliance Management Provided steady state support for BigFix and its related/ integrated tools Maintained KEDB, usage of technical and process SOPs Reproduced best practices and recommendations Provided lucrative solutions after understanding the big picture and post meticulous Transformational Effects Achieved effective and efficient Patch Management rollout for more than 3,000 global locations Segmented BigFix infrastructure into separate logical groups through relay affiliation configuration for better management of endpoints Rolled out Maa360 helping in effectively handling thin clients Arrested identification of newly added assets to the network through NMAP scan – a supported, acclaimed, powerful and flexible tool for network asset discovery Integrated BigFix to ICD to manage all authorized assets for ticketing and maintain a centralized asset repository

Explore
Infrastructure

SERVICENOW DOMAIN SEPARATION IMPLEMENTATION

A leading healthcare data center company (which we’ll call DeltaAlphaHealth or DAH) had a vision to streamline and deliver consistent processes across all its affiliates and organizations. However, they needed to maintain data separation between different business entities with shared infrastructure services support. Trianz was brought in to help DAH onboard several of their affiliates with ITSM capabilities in a different hierarchy level by leveraging ServiceNow domain separation. Affiliate Integration Challenges DAH reported a lack of unified business processes across their multiple tenant affiliates. This led to redundant data scattering across multiple systems, with no proper security controls. Additionally, their affiliates were using various ITSM tools that were not integrated with each other, leading to delays in approvals and request fulfillments. As a result, DAH was experiencing increased support and licensing costs, along with a lack of ownership and accountability in the event of any outages. With these pain points in mind, DAH turned to Trianz for a number of key deliverables. DAH wanted ITIL process definition and implementation of Incident, Problem, Change, Request, Asset, and Config management as well as defined domain hierarchy with better data access security controls and business process segregation. In addition, the company sought predefined templates to onboard new affiliates to minimize their efforts. DAH also needed to deploy automated data center service catalogs in the global domain for their affiliates’ use. Finally, they wanted defined global business processes for better manageability and easy maintenance. Delivering a Multi-tenant Architected ServiceNow Instance After investigating other technologies, DAH made the decision to leverage a ServiceNow domain separation implementation through Trianz. Trianz first conducted workshops with various business units to gather the critical project requirements. The much-needed multiple domain hierarchy was implemented with data access controls along with data encryption providing highest level of security. ServiceNow Multitenant Platform using Domain Separation Trianz was then able to develop and implement the change and configuration management process based ITIL best practices. Workflows were configured to clearly define their cross-domain approval process. Automating the entire process removed the issues caused by the poor integration of legacy ITSM tools. Better Multiple Affiliate Management – Transformative Impact For DAH, the results were clear. With the newly improved and automated data center, they have now established business processes with a global UI for better manageability and easy maintenance. Their incident request creation, change and request approval, and SLA configuration have been automated, resulting in improved efficiency. DAH’s approval process now has better transparency with faster affiliate onboarding using Trianz’s ServiceNow prebuilt processes and core capabilities, allowing affiliate users to track the progress of their own requests. This ServiceNow domain separation enabled DAH to greatly improve their full audit capabilities, providing them with seamless and effective audit practices with minimal or zero-non compliances. Additionally, the domain separation optimized their license and support costs, significantly reducing the costs from the original use of the old ITSM tools. 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
Infrastructure

ITSM PROCESS CONSULTING FOR MULTINATIONAL TRAVEL COMPANY

ITSM process assessment & roadmap development A large US based multinational travel and meetings program management company engaged Trianz to assess and develop a comprehensive roadmap for Service Management instance. Business Challenge The client has a separate ServiceNow instance for Service Management and the resulting process gaps were leading to issues related to audits, especially change management. Also, the CSF and KPIs were not configured/measured properly. It was looking to engage with a firm to conduct an assessment of all of its ITIL processes to address the gaps and identify areas for improvisation. Approach Understand the current state of process through classroom based workshops in client location for key process areas – Incident, Problem, Change, IT Asset and Service Request Management. Conducted workshop through a scenario based approach to understand AS-IS process that is followed through Gap Analysis Report To determine the desired state (TO-BE) during the workshop and conduct interview sessions with the relevant stakeholders to understand current pain points and challenges. To identify action items during the process based on the concepts discussed; action Items will be distributed amongst both parties depending on the output required. Define the process by adopting best practices as per ITIL v3 Framework aligned to business needs. To provide a walkthrough for final sign-off. Transformational Effects Aligning current processes with PCI-DSS requirements. 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

ITOM IMPLEMENTATION (DISCOVERY, SERVICE MAPPING AND EVENT MANAGEMENT)

ServiceNow ITOM to Proactively Eliminate Service Outages The client is the world’s leading technologies provider for enterprise-level data capture and automatic identification solutions that provide businesses with operational visibility. Business Challenge No authorized source of truth for infrastructure assets and service/application mapping to analyze the service impact during change request. No monitoring tool integration with incident management and lack of automation for IT operations. Event noise and inability to pinpoint the root cause for service disruptions. Technology Components ServiceNow, IBM Netcool Business Objectives Enhance visibility Manage service health Optimize service delivery and spend Reduce event floods from monitoring tools and provide a single dashboard to proactively identify service issues Create a single system of record for IT infrastructure Automate IT processes, eliminate manual tasks & remediate service issues Key Deliverables ITOM capabilities through ServiceNow Auto discovery of assets Mapped relationships between IT components and business services Integrated ServiceNow ITOM with IBM Netcool The Approach Trianz’s unique assessment approach covered all the relevant areas to accurately layout the findings, observations, issues & gaps. Designed and implemented ServiceNow ITSM/ITOM modules and integrated IBM Netcool solution with ServiceNow. Identified top 10 business services and mapped all the critical dependencies using Service Mapping. Transformational Effects Integration of monitoring tools with event management to monitor critical business services and perform automated resolutions for known issues. Clear visibility to top 10 business services and its impacts. Improved service delivery and reduced MTTR.

Explore
Infrastructure

ENTERPRISE MONITORING AND MANAGED SERVICES FOR LARGE HEALTHCARE DELIVERY ORGANIZATION

One of the three largest US  integrated managed care consortiums. Over 7000 beds, 209,000 employees, 21,250 physicians, and 39 medical centers, across the US. The enterprise currently runs with 30,00 servers with an IT employee strength of 700 FTE. The Business Challenge Manual processes and growing scale of the environment was overloading IT staff, resulting in very long time (approximately 3 days) to resolve critical incidents and growing backlog (~1000) of work requests Low level of integration of multiple tools and siloed repositories of information (CMDB, incident logs, ITOM) made it difficult to correctly diagnose and resolve incidents first time, resulting significant rework effort and time to close incidents IT staff consumed with reactive tasks leaving no time for process improvement Business Objective Increase customer satisfaction level by reducing manual operation errors, and ensure the resolution of incidents within the committed SLA Increase visibility and reporting to SLA metrics and elimination of aged backlog work Reduction in human error related to manual tasks, and also improve efficiency through targeted automation and integrations. Key Deliverables Integrated existing monitoring and incident management tools (IBM and Netcool monitoring, BMC Remedy/ServiceNow) into a centralized event management system Implemented auto-remediation of events using IPSoft, self healing by Netcool & IP-Center AI integrated with ServiceNow. Developed correlation rules within Netcool to de-duplicate events Validated automation logic and created SOP documents for IPSoft to support continuous development of automation scripts. The Approach Performed workshops with business and IT stakeholders to identify people, process, tool issues and desired outcomes Create future state architecture and end-state visualization for an integrated solution Staffed a blended team of client and Trianz onshore/offshore resources to reduce backlogged requests Managed monitoring infrastructure as a service Transformational Effects Decreased the incident remediation time and ensured adherence to all committed business SLA’s Reduced the backlog of work requests by 91% over a period of 5 months. Estimated improvement of 20% in staff efficiency

Explore
Infrastructure

IMPLEMENTING ENDPOINT INVENTORY FOR BUSINESS PROFITABILITY

A leading provider of private integrated healthcare delivery systems in the US was struggling with a poor infrastructure discovery process and imperfect application affinity mapping. Consequently, it was unable to assess the impact of critical incidents, leading to a loss in business. As part of the engagement, Trianz implemented several best practices, from the client’s processes as well as the tools perspective, and also reduced the incidents tally to close to zero without production outages. The Business Challenge The organization needed to implement an Endpoint Inventory solution to address is problems of poor infrastructure discovery and application affinity mapping. The objective was to accurately assess the impact of critical incidents which were otherwise leading to a loss in transactions, and consequently, of business. Technology Components Tivoli Application Dependency Discovery Manager [TADDM] Tivoli Asset Discovery for Distributed [TAD4D] BigFix and BigFix Inventory The Approach Developed an execution roadmap sequencing the implementation of technology stacks based on the client’s business priorities Conducted workshops with business and IT stakeholders to understand challenges/ business needs Assessed existing processes, tools, integration points, and data sources Designed the TADDM architecture which consisted of five Secondary Storage Servers and 14 Discovery Servers Standardized the process for managing incidents and service requests Implemented monitoring solutions, further reducing the duplicate events count and improving operational efficiency of software products Transformational Effects Enabled migration from TAD4D to BFI, including bundling rules and software exclusions Initiated business applications’ health monitoring through application affinity mapping in TADDM Improved accuracy of sub-capacity reporting in BFI for invoicing Automated discovery of 33K servers and 45K network components once every week Achieved sustained process improvements, higher customer satisfaction and lowered operating costs through a step-by-step, metrics-oriented improvement approach Reduced scan errors from high volume to less than 3% Streamlined the administration and support process for day-to-day engagements

Explore
Infrastructure

ENABLING BUSINESS SERVICE MANAGEMENT THROUGH INTEGRATED IT SERVICE MANAGEMENT PLATFORM

An SOC-compliant, 24x7 support model for global monitoring and service management infrastructure The client operates the world’s fastest payment processing network in more than 210 countries and territories that support transactions of over 725 million credit & debit cards globally. It wanted to build a business view for IT infrastructure and applications. It was also looking to ensure data integrity by implementing a robust process for managing changes to the IT infrastructure. Business Challenge The client had no visibility into the business view of IT infrastructure and applications. It was unable to assess the impact of critical incidents, resulting in loss of transactions/business. It also needed a 24 x 7 support for Enterprise Monitoring and Enterprise Service Management solution, especially when multiple vendor products are involved. Lack of automation was leading to the representation of incorrect data, resulting in low user adoption of the CMDB solution. Approach Conducted workshops with business and IT stakeholders to understand the challenges/business needs Assessed the existing processes, tools, integration points and data sources Developed the Self Service offering in Service Catalog to automate building business application in TADDM through run-book automation Automated requests for network related service requests that dynamically populates questions based on the request to minimize manual intervention Standardization of process for managing incidents and service requests Established a successful 24 x 7 model to support global monitoring and service management infrastructure Transformational Effects Our unique automated business application mapping solution not only provided a platform to build the business view of IT infrastructure and applications rapidly but also ensured data integrity by implementing a robust process for managing changes to the IT infrastructure Global Infrastructure Dashboard for business critical applications provided better insights to business impact of critical incidents enabling client to take preventive and corrective actions Predictable Steady State Support operations with strict adherence to SLAs

Explore
Infrastructure

BUSINESS SERVICE MANAGEMENT FOR DEEPER VISIBILITY

A payment processing network operator supporting more than 725 million credit and debit card transactions globally faced an issue of visibility. Due to 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. Further, multiple vendor products led to inconsistent support for enterprise monitoring and service management imperatives. Customer escalations were managed through manual spreadsheets, and exhaustive processes without proper catalog for managing software and hardware products added to the problem. Working with key stakeholders, Trianz did an in-depth assessment of existing processes, tools, integration points, and data sources. We then enabled an automated business application mapping solution, as well as automated processes around network related service requests. We developed a custom solution to automate the consumer escalation process, and implemented a service catalog to auto-populate and auto-route requests based on the product. The process for managing incidents and service requests was also standardized and integrated with other client systems/applications for better, more efficient API based interaction. THE BUSINESS CHALLENGE Lack of visibility into IT infrastructure and business applications limited the ability to assess the business impact of critical incidents. TECHNOLOGY COMPONENTS IBM Integrated Control Desk v7.5.1.3, Tivoli Application Dependency and Discovery Manager, BIRT Oracle 11g ALM (Application Lifecycle Management) which is a CA tool THE APPROACH Developed a self-service service catalog to automate building of business applications in TADDM (Tivoli Application Dependency Discovery Manager) through run-book automation. Developed a custom solution that automated all the network-related service requests. Dynamically populates questions based on the request to minimize manual intervention and provide the implementation steps based on the answers provided. Created a custom application and solution that automated the creation of customer escalations received through mail. This application was also built with custom reports and SLAs configured, aiding monitoring and ensuring SLAs were not missed. Designed service catalogs for onboarding. Created automation scripts to pre-populate the values on the offering request, perform required validations on the offering request fields, and assign requests to various groups based on business requirements. TRANSFORMATIONAL EFFECTS Enabled business view of IT infrastructure and applications Eliminated manual processes for improved process efficiencies Established integrity of CMDB data across the enterprise Created predictable steady state support operation with strict adherence to SLAs Streamlined new hire onboarding process, reducing manual effort Allowed for preventive and corrective actions with real-time insight into business impact of critical incidents

Explore
Cloud, Infrastructure

ENSURING 24/7 AVAILABILITY OF IT INFRASTRUCTURE

One of the largest resellers in a leading online shopping marketplace in India needed help to keep pace with its rapid growth. Existing technologies, information systems and staffing needed to be evaluated regularly. There was also a need to maximize the availability of telephony, email, messaging, network connectivity, business infrastructure, office automation, and process automation systems. The client partnered with Trianz to set up a managed services center to support its IT Infrastructure on AWS, thereby proactively and reactively addressing and resolving issues. We recommended processes that were not only compliant with industry standards and practices, but also rooted in experience with clients worldwide. With a well-defined governance structure and skilled resources across portfolios, Trianz built a managed services center that ensured infrastructure availability on a 24x7x365 basis. We also adopted a phased approach to transition work from in-house support teams to a fully managed services model. The Business Challenge Proactive and reactive support was needed to manage IT infrastructure on AWS, as well as govern associated policies, processes, contracts and documentation. Technology Components Infrastructure management through Ctrl-Dock Device management on Amazon Web Services (AWS) cloud infrastructure The Approach Studied the existing support structure and practices, including the environment for support and points of contact. Defined the mechanism for on-going support Trianz’ project management and technology teams collaborated with the client to seamlessly transition the business process and production support activities Gained familiarity with client-specific tools, call sharing between the client’s and Trianz’ team, review meetings, and reporting Recommended a core service based on a ‘business as usual’ approach, including streamlined communication, ticketing, and periodic reporting Transformational Effects Improved operational efficiency and minimized costs related to acquisition, implementation, and operation of IT systems Defined policy and procedures to secure the client’s IT assets and integrity of data, while ensuring compliance to security/ privacy requirements Established comprehensive license management process for all IT assets Increased visibility through robust service documentation and reporting structure

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
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

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.