About the client
A Software Development Center for End-to-End Business Modernization
Enhancing Internal Operations and Processes with SharePoint Online
The organization decided to upgrade their existing on-premise version to enhance their internal processes and operations. For better UX and business functionality, they upgraded to SharePoint Online. The organization established a robust application maintenance framework. The team further integrated Microsoft 365 to:
Internal information/data in SharePoint needed to be more structured. Data cleansing and segregation were done in a region-specific pattern. The structured data was then migrated to SharePoint Online. Additionally, leveraging Power Platform, the team proactively took care of several enhancements, such as addressing a change request and building new request forms, to name a few.
Expansion of the Project with Data Migration to Salesforce
Furthermore, Trigent’s QE engineers analyzed the associated risks and identified the source of migration errors. The QE team prepared a testing strategy for the migration process. Object/field level, data integrity, workflow, and ETL load validations were done. Moreover, integration and compatibility testing ensured that the data flow between different components did not break under any condition.
Tracking Progress of Each Case with a Business Intelligence (BI) Solution
Based on the rigorous 2-week analysis, the team created a BI solution. Multi-dimensional data models were designed to understand and analyze the data quickly. Star schema was applied to create the data mart. Extract, transform, and load (ETL) process combined data from several locations and multiple sources, such as home-grown applications and survey tools, and consolidated them into a Datamart. Global dashboards were developed and shared with the leadership team. Tableau was leveraged to create graphical representations of the effectiveness and progress of every case.
Global Technical Support with Centralized and Process-Driven IT Infrastructure
Trigent’s Virtual Command Center (VCC) solution enabled proactive and 24/7 management of the organization’s IT infrastructure. The centralized team also provided support for IT (L1, L2, and L3). Tools like Azure, (x)Matters, IBM Maximo, TeamViewer, and LogicMonitor were leveraged to monitor, address, and manage all the end-user and server tickets across various locations. The tickets were raised on ServiceNow.
The VCC solution enabled the organization to connect with over 150 network elements and extend support to over 150 servers and 2,000 desktops across multiple global locations. IT operations management (ITOM) is the next phase, where Trigent will enable the organization to predict anomalies, analyze root causes, and initiate remediation for smooth IT operations.