CASE STUDIES

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

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

ENABLING DATA ACCESS, INTEGRATION, ANALYSIS AND REPORTING

A not-for-profit organization dedicated to promoting patient safety by enhancing provider quality in the field of nurse anesthesia through development and implementation of credentialing programs, experienced difficulty in accessing and trusting their data, which primarily revolved around the nurse population and test results. THE BUSINESS CHALLENGE Creating reports for consumption was a difficult process for the average user, and as a result, they had to rely on third-party Aptify consultants to simply pull data they wanted to see. Multiple variations of the same reports had been created over time, and different users were utilizing different reports. Client wanted to centralize their data to ensure its integrity as well as make it easily accessible and consumable for end-users. The client was seeking the ability to integrate and analyze test-item data with their nurse and exam-level data, which they had never done before, and which was not possible in Aptify’s ERP solution environment. TECHNOLOGY COMPONENTS Microsoft SQL Server 2016, SSIS, Microsoft Azure and Tableau (Desktop, Online, Bridge) THE APPROACH Trianz adopted a two-phased approach for providing a “Lean EDW” solution with Tableau reporting capabilities. The first phase involved the build and implementation of a Microsoft SQL Server EDW that was configured in a Microsoft Azure environment. Tableau Bridge was used to allow automated refreshes, as the underlying data was hosted in a private environment in Azure. Subject area-based views were created to facilitate intuitive querying and reporting capabilities. Initially, Despite initial consideration Trianz implemented a new EDW due to the need to integrate item-level test data from separate third-party testing vendors. The second phase involves incorporating test item-level data into the EDW. This data was sourced from two primary vendors, Pearson Vue and Castle. No enterprise-level dashboards were built during this phase, but weekly Tableau training sessions were held for all Tableau users to encourage ad-hoc analysis and self-service analytics. TRANSFORMATIONAL EFFECTS Enhanced the ability of all users to easily access trustworthy and validated Aptify data – both with pre-built dashboards as well as ad-hoc analysis. Users could now dig into this data in ways they never had accesses before without relying on others to access it. Improved the ability to look at individual test questions and results, and tie these back to individuals, education programs, geographical regions, or look at them across all test takers.

Explore
Analytics

DEVICE DATA INTEGRATION AND ANALYTICS PLATFORM

A Fortune 500 Storage Systems and Software company was looking for a next-gen Data Integration & Analytics platform to process device diagnostic data to enable product and customer support. Business Challenge Storage devices (from ~75% of the install base) around the world sends configuration, performance and log information as Auto Support (ASUP) messages. The client’s legacy DW platform was unable to process this huge amount of data (1TB/wk) in time and support real-time analytics of device logs to identify issues upfront. With growing ASUP volumes, it was posing serious challenges in meeting the mission critical SLAs. Additionally, there were no customer, sales, service and support insights available for cross- and up-selling. Key Technology Components 117 Node CDH cluster with 1.15PB data. Tech stack - MD, Flume, HDFS, Hbase, Hive, Pig, Solr, Java, Config Loader, Pl/Sql, Shell Scripting, Datameer, Tableau, Pentaho DI, Oracle, SQL Server, OBIEE, MSBI Approach As a strategic partner, Trianz helped in implementing the next-gen DW platform on big data technologies, and is currently involved in promoting its enhanced usage to drive sales & services (beyond product support). Strategy/Roadmap Assessment of current state, future requirements and gap analysis through interactions with IT & Business Technology evaluation and recommendation Execution Requirements gathering and development of new platform Implemented multiple releases to enhance functionality and developed downstream applications like MyASUP and SmartSolve etc. Maintaining the platform (L3 support) since 2011 Transformational Effects Highly robust, scalable and reliable ASUP.Next platform ensured smooth and uninterrupted business operations Improved product support and customer service Huge opportunity to monetize this platform by generating actionable insights to support sales & service operations

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

IMPLEMENTING MDM TO BOOST CUSTOMER SERVICE

A Fortune 100 insurance company partnered with Trianz to implement CDI to obtain a 360° customer view (master data management - MDM) and derive meaningful insights. As part of the engagement, Trianz and Informatica together developed a CDI Hub which loads and remediates customers’ information from multiple sources to base objects. In addition, the partnership developed interfaces for the CDI Hub to interact with the source and downstream applications. The MDM platform manages customer-related reference data in each source and addresses data accuracy and quality issues, reducing manual effort and saving time. THE BUSINESS CHALLENGE Implement a master data management platform to reduce the time and manual effort needed for analyzing and rectifying the accuracy, quality, and management of customer data obtained from different sources. TECHNOLOGY COMPONENTS Informatica ETL and MDM J2EE MicroStrategy Oracle GoldenGate, Oracle 11g, Teradata THE APPROACH Reviewed data governance and organizational standards and policies Defined data management strategy for current and future organizational needs Analyzed source systems and captured detailed requirements Architected CDI solution, defined interfaces, and designed data model Created CDI Hub to load data 24x7 from source to base objects Standardized and cleansed data Applied match rules and automated match and merge process Developed interfaces for CDI Hub to source and downstream applications Established MDM governance and new/ key roles essential for successful execution TRANSFORMATIONAL EFFECTS Enabled holistic customer record view which was integrated back to the source system Streamlined process for maintaining and updating customers’ information Improved representation of customer information Generated cross-sell opportunities

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

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
Analytics

UNCOVERING THE BUSINESS VALUE OF DATA

A Fortune 500 property and causality insurer needed a more accurate, integrated way to organize, store, and manage data. Having a global footprint, their data was dispersed across multiple regions, platforms, and lines of business. Reports from respective regions were being manually collated and reconciled, creating inconsistencies and rendering real-time business insights impossible. The client partnered with Trianz to develop a strategy and an actionable roadmap for a data warehouse for its Personal and Business Insurance (P&BI) division. We thoroughly assessed the client’s exiting data sources; mitigated risk for data from unexpected sources; mapped business needs and arrived at common definitions across lines of business; even built a business view of their data tree for ease of use. We then piloted a PoC by ingesting data from a few locations, and built an enterprise data warehouse and data mart with reporting capabilities. The data warehouse was later extended to include other data sources, including their auto insurance, creating an enterprise data warehouse. The Business Challenge With data spread across multiple platforms and geographies, manual collation and reconciliation resulted in inconsistent information that prevented real-time insights into revenue and profitability. Technology Components Infosphere CDC Informatica Powercenter Netezza(PDA) Qlik Aginity Cognos Framework Cognos Active Reports The Approach Started with data analysis and profiling across geographies and LOB Conducted workshops to facilitate decisions and agreement on common definitions Centralized all source data in a staging area and built data tree Developed proof of concept for two countries and later extended to ten other countries Rolled out enterprise data warehouse to include auto lines of business across all countries Transformational Effects Mitigated risks by addressing data quality issues upfront Established common business definitions across regions and countries Enabled business users to analyze and unearth insight on revenue & profitability across LOB Developed an ROI model for global enterprise data warehouse initiative

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
Business 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
Business Apps, Security

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

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

CLOUD DEPLOYMENT

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

Explore
Cloud

MIGRATION TO CLOUD ANALYTICS PLATFORM

Migrate from on-prem current state legacy analytics platform to a scalable and fully managed analytics platform on Azure A leading P&C insurance company based in the United States realized the need to move from the legacy architecture to a more stable cloud-based platform to attain better insights on operational parameters. Trianz was engaged by the client to perform migration from legacy architecture to a fully managed analytics platform. Business Challenge Owing to the legacy architecture, the client was burdened with higher operating costs and was not able to provide agile insights. Although senior management has set ambitious and aggressive goals for moving to the cloud, the obstacles on the ground were daunting. Approach Trianz proposed to collaborate with the client to establish a reference architecture with a pilot engagement where every technical component was evaluated, benchmarked and assessed for functional & non-functional requirements/use cases. Transformational Effects A stable solution architecture on Azure ready to migrate the data & analytics platform from on-prem to Azure in a managed services model. Established an ingestion and integration framework to migrate the existing Informatica workloads to ADF2.0 to leverage the power of distributed compute and scale on demand. An on-demand, scalable, cost effective data lake platform on Azure for migrating the existing data from Teradata reduced the cost of licenses and operations significantly. Created the ELT architecture with data lake to enable the raw data discovery, analysis & self service requirements. Azure Data Lake Analytics (ADLA) driven by U-SQL enabled more efficient ways of running the machine running algorithms and models. End-to-end Automated Deployment process leveraging DevOps increased the frequency of the data availability to the business.

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
Analytics

ENABLING DATA ACCESS, INTEGRATION, ANALYSIS AND REPORTING

A not-for-profit organization dedicated to promoting patient safety by enhancing provider quality in the field of nurse anesthesia through development and implementation of credentialing programs, experienced difficulty in accessing and trusting their data, which primarily revolved around the nurse population and test results. THE BUSINESS CHALLENGE Creating reports for consumption was a difficult process for the average user, and as a result, they had to rely on third-party Aptify consultants to simply pull data they wanted to see. Multiple variations of the same reports had been created over time, and different users were utilizing different reports. Client wanted to centralize their data to ensure its integrity as well as make it easily accessible and consumable for end-users. The client was seeking the ability to integrate and analyze test-item data with their nurse and exam-level data, which they had never done before, and which was not possible in Aptify’s ERP solution environment. TECHNOLOGY COMPONENTS Microsoft SQL Server 2016, SSIS, Microsoft Azure and Tableau (Desktop, Online, Bridge) THE APPROACH Trianz adopted a two-phased approach for providing a “Lean EDW” solution with Tableau reporting capabilities. The first phase involved the build and implementation of a Microsoft SQL Server EDW that was configured in a Microsoft Azure environment. Tableau Bridge was used to allow automated refreshes, as the underlying data was hosted in a private environment in Azure. Subject area-based views were created to facilitate intuitive querying and reporting capabilities. Initially, Despite initial consideration Trianz implemented a new EDW due to the need to integrate item-level test data from separate third-party testing vendors. The second phase involves incorporating test item-level data into the EDW. This data was sourced from two primary vendors, Pearson Vue and Castle. No enterprise-level dashboards were built during this phase, but weekly Tableau training sessions were held for all Tableau users to encourage ad-hoc analysis and self-service analytics. TRANSFORMATIONAL EFFECTS Enhanced the ability of all users to easily access trustworthy and validated Aptify data – both with pre-built dashboards as well as ad-hoc analysis. Users could now dig into this data in ways they never had accesses before without relying on others to access it. Improved the ability to look at individual test questions and results, and tie these back to individuals, education programs, geographical regions, or look at them across all test takers.

Explore
Analytics

DEVICE DATA INTEGRATION AND ANALYTICS PLATFORM

A Fortune 500 Storage Systems and Software company was looking for a next-gen Data Integration & Analytics platform to process device diagnostic data to enable product and customer support. Business Challenge Storage devices (from ~75% of the install base) around the world sends configuration, performance and log information as Auto Support (ASUP) messages. The client’s legacy DW platform was unable to process this huge amount of data (1TB/wk) in time and support real-time analytics of device logs to identify issues upfront. With growing ASUP volumes, it was posing serious challenges in meeting the mission critical SLAs. Additionally, there were no customer, sales, service and support insights available for cross- and up-selling. Key Technology Components 117 Node CDH cluster with 1.15PB data. Tech stack - MD, Flume, HDFS, Hbase, Hive, Pig, Solr, Java, Config Loader, Pl/Sql, Shell Scripting, Datameer, Tableau, Pentaho DI, Oracle, SQL Server, OBIEE, MSBI Approach As a strategic partner, Trianz helped in implementing the next-gen DW platform on big data technologies, and is currently involved in promoting its enhanced usage to drive sales & services (beyond product support). Strategy/Roadmap Assessment of current state, future requirements and gap analysis through interactions with IT & Business Technology evaluation and recommendation Execution Requirements gathering and development of new platform Implemented multiple releases to enhance functionality and developed downstream applications like MyASUP and SmartSolve etc. Maintaining the platform (L3 support) since 2011 Transformational Effects Highly robust, scalable and reliable ASUP.Next platform ensured smooth and uninterrupted business operations Improved product support and customer service Huge opportunity to monetize this platform by generating actionable insights to support sales & service operations

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

IMPLEMENTING MDM TO BOOST CUSTOMER SERVICE

A Fortune 100 insurance company partnered with Trianz to implement CDI to obtain a 360° customer view (master data management - MDM) and derive meaningful insights. As part of the engagement, Trianz and Informatica together developed a CDI Hub which loads and remediates customers’ information from multiple sources to base objects. In addition, the partnership developed interfaces for the CDI Hub to interact with the source and downstream applications. The MDM platform manages customer-related reference data in each source and addresses data accuracy and quality issues, reducing manual effort and saving time. THE BUSINESS CHALLENGE Implement a master data management platform to reduce the time and manual effort needed for analyzing and rectifying the accuracy, quality, and management of customer data obtained from different sources. TECHNOLOGY COMPONENTS Informatica ETL and MDM J2EE MicroStrategy Oracle GoldenGate, Oracle 11g, Teradata THE APPROACH Reviewed data governance and organizational standards and policies Defined data management strategy for current and future organizational needs Analyzed source systems and captured detailed requirements Architected CDI solution, defined interfaces, and designed data model Created CDI Hub to load data 24x7 from source to base objects Standardized and cleansed data Applied match rules and automated match and merge process Developed interfaces for CDI Hub to source and downstream applications Established MDM governance and new/ key roles essential for successful execution TRANSFORMATIONAL EFFECTS Enabled holistic customer record view which was integrated back to the source system Streamlined process for maintaining and updating customers’ information Improved representation of customer information Generated cross-sell opportunities

Explore
Analytics

UNCOVERING THE BUSINESS VALUE OF DATA

A Fortune 500 property and causality insurer needed a more accurate, integrated way to organize, store, and manage data. Having a global footprint, their data was dispersed across multiple regions, platforms, and lines of business. Reports from respective regions were being manually collated and reconciled, creating inconsistencies and rendering real-time business insights impossible. The client partnered with Trianz to develop a strategy and an actionable roadmap for a data warehouse for its Personal and Business Insurance (P&BI) division. We thoroughly assessed the client’s exiting data sources; mitigated risk for data from unexpected sources; mapped business needs and arrived at common definitions across lines of business; even built a business view of their data tree for ease of use. We then piloted a PoC by ingesting data from a few locations, and built an enterprise data warehouse and data mart with reporting capabilities. The data warehouse was later extended to include other data sources, including their auto insurance, creating an enterprise data warehouse. The Business Challenge With data spread across multiple platforms and geographies, manual collation and reconciliation resulted in inconsistent information that prevented real-time insights into revenue and profitability. Technology Components Infosphere CDC Informatica Powercenter Netezza(PDA) Qlik Aginity Cognos Framework Cognos Active Reports The Approach Started with data analysis and profiling across geographies and LOB Conducted workshops to facilitate decisions and agreement on common definitions Centralized all source data in a staging area and built data tree Developed proof of concept for two countries and later extended to ten other countries Rolled out enterprise data warehouse to include auto lines of business across all countries Transformational Effects Mitigated risks by addressing data quality issues upfront Established common business definitions across regions and countries Enabled business users to analyze and unearth insight on revenue & profitability across LOB Developed an ROI model for global enterprise data warehouse initiative

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

DW/BI TRANSFORMATION

Strategy, Planning & Management of an Enterprise Data Management and Reporting Program A non-profit, academic medical center was facing multiple challenges with its antiquated data warehouse and reporting applications and was in need of implementing a new, enterprise-wide ERP application (EPIC). Business Challenge The current reporting and analytical environment of the client had many limitations and constraints. The redesign of the current DW/ BI environment had to be coordinated with the implementation of EPIC, which had its own reporting requirements and was highly dependent on the successful redesign and rebuild of the DW/ BI applications. Technology Components Oracle, Business Objects, Clarity, EPIC and Crystal Reports Approach Trianz assisted the client’s project team in the overall planning, strategy and management of the engagement. This included defining the work plans, business and technical requirements with multiple iterative releases; and overseeing the design of the ETL, data and application architectures and management of the engagement. Education on best-of-breed data warehousing tools, techniques and architectures while developing an enterprise strategy and implementation plan Identification and recommendation of a data warehouse scope, data architecture and technical architecture Development of data warehouse information requirements to meet the goals of the enterprise and the pilot Assisted in development of the conceptual, logical and physical databases High-level design and review of the data extract, load and transform procedures and programs Performed the upgrade of Business Objects to XI R2 Facilitated the creation of a User Group and Advisory Board, and created an implementation and roll-out plan Transformational Effects Implemented EPIC reporting and the new DW/ BI environments successfully on time. The key successes included: Appropriate end user self-service Adherence to HIPAA regulations Standards for report templates and data presentation Online/paperless reporting Enterprise reporting strategy and tool Fewer custom-developed reports Report library catalog (user documentation) Reliable, accurate, timely data available to meet end user requirements Meaningful integration of data to meet end user needs across all areas IT support for complex reports and analytics

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

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 MONETIZATION

Data Monetization Market Opportunity Analysis and Proof-of-Value One of the world’s largest global shipping companies intended to identify new revenue opportunities to monetize its data and to build other related business intelligence products for different industries. Business Challenge Client needed to quickly vet the concepts across many different dimensions of risk, legal and competitive barriers, data availability, and delivery options while considering the cultural and political appetite to adopt. The end-goal was to perform a rigorous analysis that would determine concepts and drive a sustainable and significant financial return to the company, far above the investment required to implement. Technology Components Oracle, Tableau, MS SQL Server and Hadoop The Approach Trianz consulting team worked closely with the client’s marketing innovation group, legal department and all areas of IT and business to execute a full market opportunity analysis and proof-of-value exercise. The engagement entailed performing an overall market analysis to determine the potential monetary value, opportunities, competitive landscape and barriers to entry. This involved analyzing the options to deliver an intelligent data product to the market – by capability, segments, channels and geographies while assessing costs, risks and potential monetary return of each option. Developed prototypes of selected concepts and performed in-depth primary and secondary research to validate the viability, feasibility and desirability of each; and presented final consolidated findings, recommendations and a roadmap of implementation options to the management. Transformational Effects Identified a wide variety of monetization opportunities including complementary and new business revenue streams across the medical, online purchasing, B2B commerce and distribution center services industries.

Explore
Analytics

MIGRATING HISTORICAL DATA POST M&A

A Fortune 500 property and casualty insurance company needed help carrying out a large-scale historical data migration. A voluminous quantity of professional indemnity insurance (PI) data was acquired from another financial services company—and the transitional service agreement mandated execution within a stringent timeline. As part of the engagement, we migrated 30 years of PI data from multiple heterogeneous systems to a unified, scalable platform, enabling its audit, compliance and analysis. Trianz also partnered with the client to design and develop a solution for migration of historical data for NA personal lines. THE BUSINESS CHALLENGE Migrating 30 years of data from a newly acquired business’ multiple heterogeneous systems. The data needed to be moved to a unified scalable platform within the scheduled time before systems were shut down. Technology Components Microsoft SQL Server Microsoft SQL Server Reporting Services (SSRS) Microsoft SQL Server Integration Services (SSIS) Microsoft .NET Python THE APPROACH Developed a reusable migration assistant tool with features like source metadata generation, control files creation for source data analysis, and dynamic SSIS package generation. The former gives an end-to-end automated ETL solution for data migration from several heterogeneous systems to a structured database. Migrated historical data from the source transactional systems built on Mainframe, SAP and the EDW data to a unified scalable database. Created a robust data model by logically grouping the data needs for predictive analytics and on-going business needs with centralized reporting architecture. Used MS SQL Server FileStream and FileTable to integrate the documents and attachments related to policies and claims stored as BLOBs and CLOBs in the source transactional systems. Created a direct access UI for the users. TRANSFORMATIONAL EFFECTS Historical data made available for ongoing business needs such as in-force policy conversion, open claims conversion, and billing conversion. A unified and scalable data model made available for predictive analytics. Supports actuarial, product development, UW support, claims, risk services, distribution, operations, and billing. All types of user needs met by centralized reporting architecture built with a tool-agnostic data platform for reporting.

Explore
Analytics

BIG DATA AT WORK

A Fortune 500 storage systems and data management company wanted actionable intelligence with device diagnostic data transmitted from across client locations. With nearly a terabyte of data per week and without a robust big data platform limited proactive identification and resolution of issues and missed opportunities to upsell and cross-sell services. We developed a strategy and roadmap to unleash the potential of Big Data. Deployed data Integration and Analytics platform to process data and gain insights. Then, put it into the hands of service teams to resolve issues, and sales operations to uncover hidden opportunities. The result? Formerly raw data is now intelligence, thanks to Big Data Analytics. THE BUSINESS CHALLENGE The company’s products are designed to transmit configuration, performance, and log information as auto support messages to technical support for problem determination and resolution. The legacy DW platform was unable to process this huge amount of data (1TB/week) and provide real-time analytics to resolve issues leading to serious challenges in fulfilling SLAs. The lack of insights further limited the opportunity to cross-sell and upsell services. TECHNOLOGY COMPONENTS Java/J2EE, FLUME, Pearl, Python, Shell Scripting, Hadoop - HDFS, Hbase, HIVE, Solr, Pentaho, Oracle, Kafka, Spark, and Scala. THE APPROACH Strategy and roadmap development: Assesses current state and future technology platforms and made recommendations Implementation: Gathered requirements, implemented the new platform, enhanced functionality and developed downstream analytical applications Operations: Maintaining the platform and providing L3 support TRANSFORMATIONAL EFFECTS Simplified consumption of data across the enterprise with a robust, scalable, and reliable platform. Thereby ensuring uninterrupted business operations, improved product supportability, and elevated customer service. And a huge opportunity to monetize data by cross-selling and upselling services!

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
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
Business 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
Business 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
Business Apps, Security

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

TAILORING AN ECOMMERCE EXPERIENCE

A reputed Indian textile manufacturer wanted to become a leading consumer lifestyle player in the digital space by engaging in several globally scalable business models. Trianz was chosen to build India’s first omnichannel fashion shopping experience by seamlessly integrating clicks with bricks. Trianz was instrumental in providing the client with omnichannel strategy, store digitalization, and an experiential retail experience by combining technology with fashion and style. We successfully developed an e-commerce web application for their technology and fashion hybrid online arm. We enabled a seamless experience across web browsers, developed technology adoption strategies, established key compliance objectives, built product architecture and design, and allowed secure best practices and guidelines. Trianz was also responsible for the roll out, deployments, and post-development maintenance and enhancements, including automated test suite development and manual testing. The Business Challenge Build a world-class customer lifestyle organization by leveraging digital technologies to offer a seamless, personalized omnichannel shopping experience. Technology COMPONENTS PHP, Java, Apache Tomcat, MySQL-Server, JavaScript UI – AngularJS, Bootstrap, BackboneJS, KnockoutJS, jQuery, HTML5, CSS3, JSON The Approach Enabled browsing and customization of garments from over 10,000 fabrics, innumerable style possibilities such as personalized monograms, suit lapels, shirt cuffs, fittings, etc. Built a customization studio that allowed customers to see their garment customizations in digital 3D format before stitching. Introduced flexible authentication, including enhanced identification. Introduced Single Sign-On (SSO) to web applications. TRANSFORMATIONAL EFFECTS Personalized shopping experience online, in store, or at home A perfect and custom fit based on 25 measurements 3D visualization inspired customers’ confidence before placing order Enhanced customer experience through home delivered wardrobes

Explore
Business Apps

CUSTOMER DASHBOARD EXPERIENCE

A global payments and technology company partnered with Trianz to digitize its clients’ access to data with a business intelligence dashboard and data analysis tool. The tool provided merchants with parameterized reports, customized settings, and download/ export capabilities deployed through the web and mobile interfaces. Using this tool, merchants were able to drive growth by identifying insights using drill down and customized reports. Trianz’ approach spanned design, project management, development, testing and deployment of the custom application by leveraging a dual-shore delivery model. In a quickly changing environment where exhaustive documentation was not feasible, iterative development cycles ensured alignment with customer needs. Application development leveraged both client and server technologies to ensure performance in data intensive cases, while enabling and aligning to stringent customer data security requirements. Clear communication, project management, and delivery assurance processes further ensured alignment with client needs, and also facilitated tracking product changes without impact. The tool was released on time and under budget. The Business Challenge Implement a cutting-edge tool within an aggressive timeline, while still supporting flexibility of experience, platform and technology. Technology COMPONENTS .NET HTML5 & CSS3 JSON Newton Knockout D3 Microsoft Identity framework MS SQL Server The Approach Clearly established team responsibilities and development processes Adopted an agile development methodology spanning the global workforce Ensured development of application framework and to-be-extended services Closely monitored alignment with customer needs Assessed application quality and readiness for release Obtained management buyin, conduct communications for release TRANSFORMATIONAL EFFECTS Enhanced engagement with merchants, providing better access to their data and insights Instilled software development best practices, especially with dual-shore development models Provided support for multiple business models and geographic locations with the help of configurations

Explore
Business 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
Business 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
Business Apps

E-GOVERNMENT PORTAL

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

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

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

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

IMPLEMENTATION OF END TO END AUDITING PROCESS

ServiceNow GRC implementation to promote transparency, accuracy and accountability - making GRC a core discipline The client was looking to streamline its audit process by implementing GRC on the ServiceNow platform. It wanted to empower its internal audit teams with a single platform that can help them plan and execute engagements, collaborate with teams, view report findings and monitor the compliance requirements for various policies like HIPAA and PCI DSS 3.0. Business Challenge The client wanted to streamline its manual auditing process and create a common platform to centralize audit engagements, executions and findings as there was no transparency and accountability in the current system. Also, there was no proper time tracking, reporting and historical data available for future engagements. There were issues with longer duration of audit executions and heavy manual dependencies. Technology Components ServiceNow Platform and Governance, Risk, Compliance subscriptions Approach Identify and conduct interviews with process owners to understand the process, controls, sources and exemptions Identify External / Internal AD’s, policies, controls and exemptions Create profiles, and identify indicators and link to controls . Identify the automation requirements to close audit findings on the controls . Transformational Effects Automated governance and risk . Audit engagements and executions from a centralized location Internal audit team now spends 50% less time managing audits Transparency, accuracy and accountability of process compliance Real-time dashboards of various processes and compliances . Automation of process compliance findings though workflow Process improvements and tighter controls by eliminating redundancies and exemptions

Explore
Infrastructure

ITSM PROCESS CONSULTING

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

Explore
Infrastructure

AUTO DISCOVERY & SAM IMPLEMENTATION

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

Explore
Infrastructure

PROJECT PORTFOLIO MANAGEMENT

A ServiceNow PPM implementation to deliver higher quality services faster A Fortune 500 engineering firm and global provider of technical, professional, and scientific services wanted to integrate its newly-acquired IT service management (ITSM) platform with the existing ServiceNow instance. The client was also looking to define a process for software asset management and integration between ITSM and endpoint management systems. Business Challenge The client was facing issues with tracking project approvals, budgets and timelines. There was no centralized data repository to identify resource availability and no time tracking, reporting, or historical data available to check performance. The client was looking to improve the end-user experience and customer satisfaction. Technology Components ServiceNow Project Portfolio Management Approach Implemented new timesheet functionality to roll up all the hours on which a user can submit time cards for multiple tasks assigned to him and created a custom approval workflow as per the organization process. Populated different skills to help in the skill-based assignment as well as labor rate cards to align labor rates for employees and contractors. Created different reports for tracking project Actuals vs Planned. Transformational Effects 45% improvement in resource forecasts in the first 6 months Improved transparency and clarity on budget and status of projects Improved focus on priority projects and better involvement of stakeholders in decision making Significant reduction in staffing costs with better resource utilization with a single system of record and readily available reports Data-driven decision making, project and resource dashboards

Explore
Infrastructure

SERVICE OFFERINGS FOR DATA CENTER OPERATIONS

Implementation of service catalogs for improved cloud infra ops A leading data center hosting services company was finding it difficult to support its IT processes & efficiently manage changes in its IT infrastructure. The client was looking to have service catalogs that can automate workflows and approvals for the cloud operations to improve the customer experience, accelerate service delivery and reduce operational costs without writing codes. Business Challenge The client was looking to have service catalogs that can automate workflows and approvals for the cloud operations to improve the customer experience, accelerate service delivery and reduce operational costs – without writing codes. Technology Components ServiceNow Service Catalog Approach Implemented several best practices -- from gathering clear and specific requirements from the organization’s business and IT teams and detailing the plan considering both processes and tools -- to implementing the service catalog. Transformational Effects Empowered the business and technical users to interact and order the services they need to do their job Brought transparency into the approval process and allowed users to track the progress of their own requests Service Catalog enabled client to deliver standardized services, capture data for an array of department services, coordinate transfer pricing between departments, and improve internal controls with full audit capabilities Provided services that are relevant, reliable and easy to understand (more intuitive) Provided more seamless automation and data sharing with most ITSM functions now residing on ServiceNow (Incident, Problem, Change, Asset) Provided thought leadership in driving efficiency and best practices Delivered IT services through a single IT operations portal Improved data center efficiencies through automation Created automatic incident requests, approval and SLA configuration, resulting in better efficiency with minimal effort Automation through orchestration resulted in better efficiency

Explore
Infrastructure

AUTOMATED SERVICE REQUEST MANAGEMENT

Service Request Management implementation with end-to-end automation A Leading Auto and Personal Insurance provider’s current homegrown IT Service Request Management tool was nearing end of vendor support with frequent performance and stability problems. The client's major focus was to enhance the service request and streamline the approval process. It was also looking to automate the change request process. Business Challenge The client was looking to input data into both home-grown systems and BMC SRM when there is a need to change tickets because both the systems are on different platforms. Data silos across systems were making it difficult to maintain. Also, there was poor visibility on the fulfillment process and work order routing. Technology Components BMC Remedy, BMC Atrium, Atrium Orchestrator & BladeLogic Key Deliverable BMC Remedy Integration with Atrium. IDM and BladeLogic Automated work order creation with repeatable process Approach Successful automation/integration with Atrium Orchestrator, IDM, BladeLogic using Web Service and scripts through synchronous and asynchronous calls Automatic work order creations, polling external system and updating WO status to help reduce manual intervention and time-to-service requests Developed and implemented repeatable process, reducing administrative overhead Transformational Effects Enhanced usability of service based requests, streamlined approvals and workflows Provided thought leadership in driving efficiency and best practices Automated the change request process, avoiding significant manhours Covered a wide variety of categories: Monitoring & Performance, Messaging & Collaboration, Network & Telephony, Identity & Access Management and HR Management

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

LICENSES VISIBILITY

A centralized system for managing contracts/vendors and ITSM integration for overall compliance A payment processing network operator supporting more than 725 million credit and debit card transactions globally was facing visibility issues. 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. The client wanted to have a clear visibility on the existing software contracts (both SKU and SAAS based products) including license visibility, renewal, and a complete track of software usage. Business Challenge The client had no centralized tool to achieve license compliance across the vendors. There was a lack of visibility on contract renewals with a lot of dollars being spent on software. There was no proper visibility on application usage and no proper utilization of ITSM solution for asset management. The client was also finding it difficult to manage assets without a centralized asset repository. Technology Components Flexera FlexNet manager suite & Flexera App portal Approach Implemented the Flexera FlexNet and App portal Integrated the Flexera FlexNet with ITSM tools (ICD and BMC) Provided a steady-state support Transformational Effects A single dashboard representation for license compliances from various vendors in a centralized tool A centralized system for managing contracts and vendors besides tracking application use Reclamation of the licenses for the application which are not in use Get an overall compliance position of the organization for various publishers through ITSM integration Easy creation of assets during the procurement phase and linking to the device after discovering the asset in the network Tracking of the whole lifecycle of the assets within the tool from the procurement stage until it is phased out

Explore
Business Apps, Security

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
Security

A SECURITY SOLUTION FIT FOR A GLOBAL SECURITY IMPERATIVES PROVIDER

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

Explore

Our Success Stories

TRUSTED BY BUSINESS & TECHNOLOGY LEADERS

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

Director of Quality Assurance

Top 10 US Life Insurance Company

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

Director of Customer and Partner Services

A Leading Global IT And Networking Organization

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

Director – Accounts and Cost

A National Cattle Feed Supplier

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

Director

A Leading Commercial Automobile Liability Insurance Provider

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

VP of Marketing

Global Storage Systems And Data Management Company

Get in Touch

Let us help you
transform and grow


Let’s Talk

x

Status message

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

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