Case Studies

PROJECT: New SharePoint Managed Service which involves migrating the company’s data to SharePoint 2016 and managing the services migration.

CUSTOMER: The customer is a Nigerian Financial Service provider quoted on the Nigeria Stock Exchange with branches nationwide.

CHALLENGE: The Customer ran a corporate portal on SharePoint 2010. The solution served both internal and external users as a single collaboration area. Unfortunately, due to insufficient SharePoint maintenance and support, the portal became hard to manage and use. To put their SharePoint portal back on the rails, the Customer engaged PIQto perform the following activities:

  • Migrate the existing solution from SharePoint 2010 to SharePoint 2016.
  • Redesign the portal leveraging SharePoint 2016 out-of-the-box capabilities.
  • Improve analytical capabilities by integrating the portal with the Microsoft Power BI suite.

First Approach:
The PIQ Team met with the company’s team and performed following activities:

  1. Custom Application Assessment
  2. Custom Workflows Assessment
  3. Custom Code Review
  4. SharePoint Security Audit
  5. SharePoint farm assessment
  6. Load time analysis
  7. User Experience Assessment

After this was done, following the Customer’s requirements, PIQ’s SharePoint team started with migrating the SharePoint 2010 solution to SharePoint 2016, the platform’s latest version at that time. Using the database attach method, a SharePoint developer and a SharePoint administrator performed a two-step migration:

SharePoint 2010 → SharePoint 2013 → SharePoint 2016

Concurrently, we restored all the missing and defective functionality (SharePoint templates, metrics and sources) via Windows PowerShell.

When the migration was completed, the PIQ SharePoint development team moved on to the solution redesign.
The major objective was to rebuild the solution that would serve as:

  • An internal portal ensuring team, departmental and cross-departmental collaboration for the Customer’s employees.
  • An external portal enabling collaboration between the Customer and contractor companies providing their services on behalf of the Customer.

PIQ created a new architecture for the solution.

Currently, the SharePoint portal includes 3 major components:

  • Portal homepage
  • Departmental sites
  • Contractors’ sites

The portal homepage welcomes both internal and external users and lets them see the latest organizational announcements and the corporate calendar. It also provides direct access to numerous portal resources via quick links.

The departmental sites include a variety of SharePoint sites united into a single site collection. The sites support departmental activities, on the one hand, and cover specific business processes, on the other hand.
Thus, the portal hosts the following sites:

  • Human Resources
  • Business Development
  • Operations Management
  • Contracts Management
  • Accounting
  • Information Technology
  • Security
  • Safety Management
  • Quality Management
  • Purchasing

Each site represents a collaboration area with a departmental calendar, announcements and an individual document storage. Each site keeps departmental policies and objectives, department- or domain-specific metrics, as well as includes reports covering different aspects of department activities.

The Contractors’ sites are designed to ensure smooth collaboration between the Customer and their subcontractors and make the activities of the latter streamlined and transparent. The SharePoint sites also enable contractors to manage their internal processes (for example, HR-related activities), as well as to participate in bids, manage customer relationships and report an array of performance and compliance metrics.

Apart from contractor-specific reports, the Customer also wanted to have enterprise-wide reports reflecting the overall business outcomes in different periods. To enable this, PIQ assisted the SharePoint team in integrating the portal with Microsoft Power BI suite. This made the key metrics on the Customer’s and contractors’ performance to be seen right on the portal pages. Using the dynamic Power BI reports, the Customer’s management can compare business results achieved in different years and months and make decisions relying on accurate business data.

The project covered all the Customer’s initial requirements and allowed the organization to:

  • Benefit from the PIQ SharePoint Managed Services
  • Get a more powerful portal built on SharePoint 2016, which improved the company’s performance and opened wider collaboration capabilities for end users.
  • Get a solution that maximizes SharePoint 2016 capabilities, thus reducing the total cost to the business.
  • Extend the reporting capabilities on the portal and make the reporting process easier and more efficient.

The managed services are ongoing and the SharePoint team is continually customizing the portal and adding new business-critical features.

Microsoft SharePoint 2016, Microsoft Power BI, Microsoft SQL Server 2016, SharePoint Designer 2013, Visual Studio 2015, Windows PowerShell.

  • PROJECT: SharePoint Managed Services and customization of a SharePoint online intranet based in Nigeria.

    CUSTOMER: The customer is a part of a large international parcel delivery network with service depots in more than 50 countries. They also have delivery partnership agreements with other courier companies all over the world. In Nigeria, their network has more than 210 agency and branch offices nationwide all collaborating intensively to deliver parcels nationwide and all over the world.

    CHALLENGE: Collaboration has been a challenge in the company and since effective collaboration of employees is business-critical to the company, the Customer decided to develop a fully functional intranet to make the working process more dynamic, let employees connect with their colleagues easily worldwide, provide teams with a quick access to the corporate content and use a variety of collaboration tools.

    SOLUTION: After the Establishment Stage, PIQ’s SharePoint team started with defining the general structure of the future intranet to create a clear-cut and flexible architecture that would allow managing, supporting and extending the intranet effectively.

    Once the general structure of the solution was outlined, the project entered the development stage where PIQ’s SharePoint development team delivered various components of the intranet to make it user-friendly and feature-rich.

    This includes the following:

    • News: The intranet enables users to publish two types of news:
      • Corporate News created by the Internal Communication Department and available across the entire company.
      • Department News created by the Heads of Department, who choose either to publish news on the department site only or make it publicly available.
    • Applications: Custom SharePoint applicationsDemonstration are grouped separately and include:
      • Common Apps, such as TopDeskWho Is WhoTrackingHelp, etc. that are essential for all Intranet users.
      • Optional Apps, such as CRMMy TimetableMy Budget, etc. that users can add and remove according to their preferences.


    A personalized web part is displayed on the intranet homepage. This way users have all the necessary corporate resources at their fingertips.

    • Department sites: Department sites contain department news, useful links to important department-specific and corporate resources, team members’ profiles, team documents, activities, as well as collaboration tools to support effective teamwork. Each site is managed by a department manager and can be customized in line with the departmental needs.
    • Vacancies: The intranet hosts a vacancy page dedicated to open job opportunities. The page includes: The Job Contact web part to enable employees to contact a responsible HR manager and learn about vacancy details. The Top Jobs web part that lists Hot Vacancies displayed on the main page of the Intranet
    • Employees: All the employees are put together on the Who is Who site. Using the site, employees can search for a person by name, department, office and position, read basic information about colleagues and contact them via available collaboration tools.
    • The SharePoint team also helped the Customer to implement Google Analytics to track the overall usage of the intranet.

    In the framework of SharePoint customization, the team also styled the intranet according to the corporate brand book and enabled responsive design of all intranet pages enabling smartphones and tablets availability.

    The new SharePoint online intranet helped the customer to reach several goals:

    • To consolidate corporate activities within a single secure platform
    • To increase employee productivity through Intranet tools and services available 24/7
    • To encourage departmental work through personalized department sites
    • To ensure accessibility of information on the staff thanks to unified personal profiles
    • To Improve employees’ engagement into the corporate life owing to the user-friendly and easy-to-use solution.

    SharePoint Online, HTML, CSS, JavaScript, jQuery, REST, SharePoint Designer, Photoshop.

    PROJECT: Managed Service of the Sales Automation system which can be scaled up to support complex processes according to the demands of the industry.

    CUSTOMER: The customer is our partner’s client, Emirates Integrated Telecommunications Company, DU Telecoms Dubai (DU), a telecommunications services provider for the United Arab Emirates and is a semi-government company based all over the UAE. DU offers fixed line, mobile telephony, internet, and digital television services across the United Arab Emirates. It is one of the two telecom operators in UAE founded in 2005 with more than 2000 employees.

    The customer had been struggling to implement a telecom Sales Force Automation (SFA) system which can be scaled up to support complex processes, product structure, and integrate multiple backend systems. Previous attempts made to implement it using other technology products and platforms had failed twice.


    • PIQ-Binayak Infotech proposed and built an end to end solution template for DU using a combination of Microsoft (MS) Dynamics CRM and SharePoint to automate business processes.
    • The system enabled accurate tracking, reporting, and is integrated with the fulfilment and billing systems.
    • The major modules are: lead to order, product catalogues, discount approval workflows & back-office activities leveraging Dynamics CRM 2016 XRM framework and SharePoint to customize / configure the functional modules & align them to the desired processes.


    • Easy to use, mobile compatible customized, modular and scalable solution
    • Brought in efficiency in tracking efforts to close a sale and thus helping DU optimize their Sales processes
    • Visibility of sales information across the hierarchy; transparent sales pipeline
    • Automated Discount Approval processes
    • Customer 360 View on SFA & Integration with other Du systems

    Dynamics CRM, SharePoint Online, SharePoint Designer.

    PROJECT: To develop a new Employee Portal in Office 365 with SharePoint Online.

    CUSTOMER: The Customer is an insurance company in Nigeria with branches in the United Kingdom and 8 countries in Africa.

    CHALLENGE:  The Customer’s employee portal was based on a third-party platform. The portal had an unattractive design and not user-friendly interface. Also, it didn’t support language localization.

    REQUIREMENT: In order to deliver on the scope of work as defined, after subscribing to the Office 365 Suite, the Customer decided to develop a new employee portal in Office 365.

    SOLUTION:  PIQ’s team developed an employee portal on SharePoint Online according to all requirements of the Customer. The team implemented custom layout of the portal pages’ with the help of tiles (web parts) and in line with group permissions.

    The available tiles included the following:

    • Upcoming Events,
    • Career Opportunities,
    • News Carousel,
    • Top Communities, etc.

    Some of the tiles were designed to be manually controlled by Community Managers (Upcoming Events) or a Global Community Manager (News Carousel). 

    PIQ’s team also created the Actions button on the portal’s home page. This button opens a drop-down menu that allows creating a document, a survey, an event, a community, etc.

    Our specialists developed three levels of navigation for the employee portal:

    • SharePoint Navigation Panel. As the employee portal was deployed in Office 365, it gives access to all other Office 365 applications. This panel also provides access to user profiles, inbox notifications, and SharePoint settings.
    • Employee Portal Navigation Panel. This panel includes such areas as people, communities, and more. It helps employees to locate and navigate to key spaces or registered users.

    We also created the three-level system of automated notifications that differed in their purposes and distribution channels:

    • Low Level Notifications Inform Users about The Company’s Activities, For Example, Upcoming Events and Are Distributed Via Email.
    • Medium Level Notifications Inform Users About Actions They Should Do Or Actions That Were Done In Relation To Them, For Example, A New Comment On A Blog Followed By A User. This Kind Of Notifications Is Distributed Through The Employee Portal Inbox.
    • High Level Notifications Inform Users About Mandatory Actions, For Example, Attending Compliance Training. Such Notifications Are Distributed Both Through The Portal Inbox And Email.

    To improve user adoption, our team also created user manuals intended for two groups of users:

    • All Users. This user manual contains the information about the portal’s layout and navigation, content management, notifications, etc.
    • Community Managers. This manual explains how to add tiles to the portal pages, edit visual content, and manage blogs.

    Our SharePoint experts provided control over the user’s country location through Active Directory. Thus, the intranet can identify users by their country location. Depending on it, the employee portal can display the navigation either in English or in Spanish, as well as the localized content. Besides, users can change the main navigation language manually or via language settings in their user profile. Also, a built-in translation capability relying on the Bing application functionality was introduced into the employee portal. It can be used for translating blogs, news, comments, etc. The supported languages are English and Spanish.


    • The Customer got an employee portal deployed in Office 365 according to the scope of the specification.
    • The flexibility of the employee portal based on SharePoint Online allows updating news or other information easily and freely adding or changing the tiles according to the Customer’s needs. The three-level navigation simplifies moving around the employee portal and Office 365 applications.
    • The new employee portal helps to enable effective formal and informal employee communication and collaboration. The portal keeps the Customer’s employees updated on the company’s policies and latest news and notifies users about all the events and activities related to them.
    • The employee portal is convenient to use by both English and Spanish speaking employees due to the automatic choice of the language depending on a user’s location and the built-in translation capability.

    SharePoint Online, SPFx, Azure App Service, Azure Cognitive Services, Azure WebJobs, React JS

    PROJECT: Migration project using Microsoft Project for project management, SharePoint for content management and Teams for cross-company collaboration, leaving Skype for Business as a backup tool.

    CUSTOMER: The customer is a client of PIQ. It was incorporated in Nov 2007 with the registered office located in West Yorkshire. It is headquartered in England. STG is holding or owning securities of companies other than banks. The Group provides a comprehensive range of construction services to support every stage of the building and property lifecycle, from design and build, refurbishment and regeneration to minor works and long-term maintenance contracts.

    The brief was to achieve the following:

    • The App consisted of two sections, in one section all details of defects were recorded from filling up and shown in another section as soon as it was successfully submitted.
    • There should be a feature for capturing pictures of defects by using the device camera.
    • There is a screen where all the data entered so far will be displayed for review.
    • When a new defect is logged it will automatically send an alert email to select managers .
    • After resolving defects it will remove the defect from the list.

    Procentrics-Binayak delivered an app which provides a centralized repository for tracking defects across projects which automated notifications of Defect details to Defect Manager through an email.

    • It has the ability to provide proper details of defects by capturing pictures of the Defect.
    • It categories Resolve Defect and Record Defect. All the details of Record Defect and Resolve Defect are stored in one place. Easy to update details Record details and Resolve details. It automatically fetches data in Record and Resolve defect Form through the database.
    • It registered the defect and passed it to the desired person to check it and Resolve it.


    • New and innovative IT landscape
    • Reduced IT costs
    • Improved business productivity with new online collaboration tools in mobile
    • High customer satisfaction with running services
    • Easy to handle in mobile and works on every device

    PROJECT: To interface ServiceNow with BMC Remedy in SharePoint using ITIL processes and configure the system.

    CUSTOMER: A multinational company with interests in financial services and sells products in more than 10 countries.

    CHALLENGE: Being a multinational company, the Customer had regional IT service management teams using local ITSM systems based on BMC Remedy. There was therefore a conflict between use of BMC Remedy and ServiceNow.

    (BMC Remedy is an American company offering SaaS-based and on-premises software and services in areas including cloud computing, IT service management, automation, IT operations, and mainframe while  ServiceNow is also an American software company based in Santa Clara, California that develops a cloud computing platform to help companies manage digital workflows for enterprise operations, and was also recognized for innovation).

    This caused inconvenience when planning, managing and coordinating the settlement of IT service issues. Since the customer decided to migrate to ServiceNow, it became important to interface it with BMC Remedy and configure the system. One of the key requirements was to put the system in accordance with the Customer’s business workflows so as to introduce ITIL processes of service transition and service operation, and ensure IT service consistency among regional departments.

    SOLUTION: Applying a deep understanding of ServiceNow and ITIL practices, PIQ’s ITSM experts delivered a solution that supported the following 5 processes:

    • Incident Management
    • Request Fulfillment
    • Change Management
    • Configuration Management
    • Knowledge Management

    Initially, PIQ’s team configured the Workflow module to translate the end Customer’s process diagrams into the language of ServiceNow, as well as determine workflow functionality by using workflow activities. This way, multi-step processes regarding change management, incident management and request fulfillment were automated by bringing together employees and involved configuration items in a single manageable area. For instance, with change management, the consultants defined the entire life cycle of a change from its initiation through approval to closing. PIQ’s experts also implemented the following additional features to make the software smoothly complement the end Customer’s business processes.

    • The Change Management process: Our ITSM specialists tailored the procedure of change evaluation so as to make it more convenient and familiar for the end Customer. The out-of-the-box feature for Risk and Impact Assessment provides user questionnaires to capture the information about possible risks caused by changes. Normally, users are redirected from a change resolving page to complete a risk assessment form, yet this may lead to data losses or changes. To gain more control over the data entered in risk assessment forms, our team implemented a pop-up window for questionnaires and removed redirection. To reinforce tracking of configuration items (CI) that can be affected by a particular change, PIQ’s ITSM developers extended the solution’s standard functionality for observing impacted items in the IT infrastructure. As a result, trackable CI classes include not only business services, but also servers, applications and DB instances.
    • The Knowledge Management process: PIQ’s team brought to life knowledge management versioning to put Knowledge Management processes in line with the end Customer’s routines. This feature enables editing of a published article even by reactivating any of its previous versions displayed in the history. The reactivated version is shown in the history as a new one, marked with “version as of Date X”. This way, the end Customer doesn’t have to unpublish an article, search for its previous versions in the retired article directory and then publish a new one with the needed changes incorporated; instead, it now takes only one click.
    • The Email Notifications module: As a multinational company, the Customer wanted their ITSM system to serve employees speaking 7 languages in addition to English. The company decided to use English as the main language of the software. Yet, 70 notifications were to be translated to make tracking of incidents and requests more convenient for users lacking in English proficiency. Generally, this would mean creating 70 notifications popping up in the same circumstances but for the “user language” parameter. Instead, Procentric came up with 10 notifications with a dynamic script and 70 notification templates. The script helps to identify user language preferences with a language template.

    This brought the following benefits:

    • A transparent notification list with no repetitive items
    • Easy introduction of new notification languages
    • Secure editing of content in templates, no effect on the notification rules
    • Secure editing of rules in the email notification module, no impact on content

    PIQ’s ITSM team also used a dynamic script to implement the end Customer’s idea of translation into English following every notifying message. If compared to changing content in templates, this solution helps the end Customer to quickly and easily edit the English version in all notifications at a time, if required.

    RESULTS: The end Customer received a customized ITSM solution supporting the following processes:

    • Incident Management
    • Request Fulfillment
    • Change Management
    • Knowledge Management
    • Configuration Management.

    The project implementation helped the company to unify and standardize IT service management for all departments.

    The combination of the ServiceNow out-of-the-box functionality and PIQ’s respect to the specifics of the end Customer’s workflows resulted in 3 major benefits for the end Customer:

    • A smooth settlement of IT service disruptions
    • An advanced control over the impact of changes on the IT environment
    • Automation of ITSM while preserving the end Customer’s workflows

    ServiceNow, ITIL,

    PROJECT: Requirement for a long-term professional maintenance of IT infrastructure for a conglomerate using ITIL.

    CUSTOMER: The Customer is a Nigerian group that is into diversified business and needed IT to coordinate their business. Started as an investment outlet, today the company is into insurance, oil and gas and residential real estate developer, whose portfolio includes offices, shopping centers, network of petrol stations, insurance company branches and Micro Finance Bank.

    CHALLENGE: Striving to attract new clients and increase the loyalty of the existing ones, the Customer is continually expanding the scope of their online services and coordination of all its services. Therefore, the company needed long-term professional maintenance of its IT infrastructure for all their companies to increase the quality and achieve sustainability of its products. With that in mind, the company chose to use PIQ’s team of certified ICT professionals.

    SERVICES: The project engages 7 ICT support specialists, some of them are involved on a part-time basis. In compliance with ITIL standard recommendations, IT infrastructure support services are provided by the 2nd and 3rd line support specialists during the Customer’s business hours while the Customer’s in-house IT specialists are responsible for the 1st line support.

    According to the SLA signed, PIQ’s specialists support 28 IT infrastructure elements and provide corresponding services on the following:

      • IT infrastructure elements
      • Servers and server hardware
      • Databases (MS SQL Server, Oracle, Pervasive SQL, Sybase SQL Anywhere)
      • LANs and WANs
      • Antivirus and antispam systems
      • Virtualization systems (VMware 5.1, and 40 Windows Servers)
      • Communication systems (MS Exchange and MS Lync systems)i
      • MS SharePoint platform
      • Backup systems (Symantec BackupExec and Veeam Backup & Replication)
      • 20 internal infrastructure services (including Active Directory, DHCP, DNS and VPN)
      • Support services
      • For servers and server hardware,
      • Databases (Virtualization, communication and backup systems, )
      • SharePoint and internal infrastructure services, we provide:
      • Configuration
      • Monitoring and regular system administration
      • Performance tuning
      • Backup and recovery management
      • Incident management
      • Documentation management
      • For LANs and WANs, we provide:
      • Configuration management
      • Bandwidth and response time management
      • Logging and regulation of network resource usage
      • Access management

    RESULTS: Long-term collaboration between PIQ’s ICT specialists and the Customer is continuing with the IT infrastructure in the hands of our certified professionals thereby saving the Customer from such common problems as frequent network outages, repeated breakdown of critical resources, security breaches and the accumulation of unstructured data. Addressing these challenges, in its turn, ensures flawless performance of the Customer’s IT services.

    Zabbix 2, ManageEngine ServiceDesk Plus, Jira


    PROJECT: To use ITIL to preserve existing integration workflows within the new ITSM system for the client of our customer and make it expandable in future.

    CUSTOMER: The Customer is an IT company focused on providing software development and IT services. CHALLENGE: The customer’s BMC-based ITSM system was integrated with their clients’ ITSM solutions so as to enhance the quality of Service Desk support. This way, the customer’s clients could use their in-house ITSM solutions to track the incidents and requests outsourced for processing. Once the customer decided to migrate to the ServiceNow platform, the challenge was to preserve existing integration workflows within the new ITSM system. (ServiceNow is also an American software company based in Santa Clara, California that develops a cloud computing platform to help companies manage digital workflows for enterprise operations, and was also recognized for innovation) Initially, there were around 20 integrations to migrate. Yet, anticipating similar integrations in the future, they wanted a scalable solution that would make next integrations quick and easy. In addition, the solution had to comply with the strict internal security rules. SOLUTION: Our experience with ITIL processes and both ITSM platforms (BMC and ServiceNow) allowed us to elaborate the concept of the integration solution in line with the customer’s specific requirements. At the first stage, our ITSM experts came up with an integration roadmap and standardized documentation needed for every integration. This included templates for integration workflows, data mapping, and test cases, which were used to formalize clients’ integration requirements at the pre-development stage. As the customer’s policy restricted direct access to their ServiceNow system, the delivered solution involved an intermediary in the integration chain, the Integration Broker. Since the Integration Broker was a third-party web service, PIQ’s team had to establish the connection between the customer’s ServiceNow system and the Integration Broker. INTEGRATION PROCESS Utilizing the ServiceNow platform’s functionality, Procentric delivered an integration application and incorporated it into the customer’s ServiceNow ITSM system. In each instance, the two-way integration process takes the following steps: The integration application retrieves data on an incident / request from the customer’s ServiceNow system and sends it to the Integration Broker. The Integration Broker transforms these data in accordance with the integration rules and sends it to the client’s ITSM system in an acceptable format. Following a similar workflow, data is transmitted from the clients’ ITSM solutions to the customer’s ServiceNow system. This way, the application allows the customer’s clients to use their own ITSM solutions to track the incidents and requests processed via Service Desk support. ServiceNow integration application The ServiceNow-based integration application includes an integration logic and 3 configurable components that can be tailored to each of the customer’s clients: integration parameters, configuration details, and business logic. Integration logic describes the overall integration workflow, that is how the system should work to push and pull messages between the ITSM systems. Integration parameters contain integration rules defining which tickets and how to transmit.  Configuration details include general information about a client and the Integration Broker. And  Business logic contains a client’s specific requirements for data mapping. Additionally, Procentric incorporated integration logging into the app to keep the history of data transactions between the customer’s ServiceNow system and clients’ ITSM solutions. To ensure the consistency of data transactions and a fast service recovery in case of a system fault, our team implemented the status monitoring feature, including email notifications about failed transactions, automatic daily reporting, and the option of automatic / manual resending of the missed data. RESULTS: The project resulted in migrating 20 integrations with the customer’s clients’ ITSM solutions to the new ServiceNow-based system. In addition to providing Service Desk support, the customer can now offer integration with the clients’ ITSM systems as an extra service through the reusable integration application delivered as part of the project. The established workflows and the delivered functionality can be used for future integrations, which leads to reduced integration costs and a decreased integration delivery time (around 2-3 months). As at now around 50 integrations have been performed via the delivered solution. TECHNOLOGIES AND TOOLS ServiceNow.

    PROJECT: Development of a project management solution based on SharePoint Online that would streamline project creation, participation and contribution, especially for simultaneous projects with Pension Fund Administration (PFA)

    CUSTOMER: PIQ’s Customer is a consulting and technology company in Nigeria focused on design, development and integration of enterprise custom applications that work across IBM, Oracle, Microsoft, Adobe, Google and Autodesk platforms to develop for their end Customer which is a federal agency responsible for pension operations who requested for assistance in creating a project management system.

    CHALLENGE: The main target was to get a solution that would streamline project creation, participation and contribution, especially for simultaneous projects with PFAs.

    SOLUTION: To provide secure and convenient access, all projects were allocated to separate spaces, so that in accordance with the security rights users have access only to those projects they participate in.
    In cooperation with the federal agency, a project template was created which possesses such attributes as the following:

    • User groups
    • Document library
    • Security rights
    • Structure of folders
    • Calendars
    • Events
    • Reminders.

    Procentric created a custom workflow that ensures that once a project has been started, the corresponding template is filled in automatically.

    Some other custom workflows were created. For example, one of them notifies the responsible manager about new documents uploaded or the existing files modified. To collect activities regarding all the documents (e.g. for the future notification), SharePoint EventReceiver was implemented. All information about projects is archived in the central storage.

    With the solution users were able to achieve the following:

    • Access the projects they are assigned to
    • Find and study necessary documents and files
    • Track the project progress
    • Assign tasks and manage their fulfillment
    • Create events in the calendar and set reminders.

    The project management solution relies on both out-of-the-box and custom SharePoint features.

    After 3 months of work, the federal agency got the project management solution which, once implemented, helped streamline the project's workflow, providing convenient access to the separate project spaces with all the relevant project materials. The solution is currently being used by the agency.

    SharePoint Online, JavaScript, jQuery, CSS, SharePoint Designer, Workflow Designer

    PROJECT: To create an analytical system for project management purposes and monitor carefully all the efforts and resources spent on projects.

    CUSTOMER: An international IT services provider, an expert in design, development and delivery of custom software solutions, IT consulting and IT outsourcing services. The Customer has attained a number of Microsoft competences as well as has been an IBM PartnerWorld member since 2010.

    CHALLENGE: As an IT services provider, the Customer needed to monitor carefully all the efforts and resources spent on projects, including logged and paid time tracking. In order to record project information accurately as well as to ensure timely preparation of monthly reports, project managers and coordinators were forced to spend a considerable amount of time. Therefore, to facilitate tracking and reporting processes, the Customer needed to create an analytical system for project management purposes.

    SOLUTION: Procentric team developed Data Warehouse (DWH) database structure as well as integration packages to load data from a variety of projects information sources.
    The data sources are:

    • CRM database,
    • Excel workbooks
    • Active Directory (access control system)
    • Task tracking system (Jira 3 and Jira 4)
    • SharePoint Portal
    • Accounting system

    In order to facilitate the project management process, the system was designed to let project coordinators load data outside their workplace.
    To ensure data-driven decision making, a variety of reports, metrics and attributes were implemented to the system.

    A number of tools and techniques were used for the reports building and analysis of pooled data:

    • Reports realized with Microsoft Reporting Services that extract data from the Analytical Cube and OLTP system.
    • PowerPivot models in Excel that do not require external data connection.
    • On-line reports integrated into SharePoint portal.
    • PowerView interactive mechanism integrated with the SharePoint portal.

    The Procentric team created a variety of customizable tables that allow recording each detail and person around a particular project or customer while the information about a particular project can be observed by a project manager or a coordinator, who has specific privileges.

    PIQ created a fully integrated system for project management analysis and reporting that ensures the following:

    • Time saving for project coordinators on their regular responsibilities.
    • The system enables its users to record all the information with respect to the Customer’s projects, thereby accelerating decision making as well as facilitating the whole project management process.
    • The system allows merging all data from different internal sources in a single storage as well as building reports in accordance with specified parameters.
    • While using the system, project managers and coordinators are able to provide reports customization for each customer and increase, thereby, customers’ satisfaction.

    As the solution was successfully implemented, the Customer is able to make use of its reports and analysis. The Customer was satisfied with the quality of the delivered solution and now it is actively being used.

    Microsoft SQL Server 2008R2, Microsoft SQL Server 2012, Microsoft Integration Service 2012, Microsoft Analysis Service 2012 Tabular Model, Microsoft Reporting Service, Microsoft SharePoint, Microsoft Excel, Microsoft PowerPivot, Power View, Silverlight, T-SQL,DAX.


    PROJECT: Upgrading of the Corporate Intranet from SharePoint 2013 to 2016.

    CUSTOMER: The Customer is a Nigerian international IT company that delivers custom software solutions and provides professional IT consulting and IT outsourcing services for businesses all over the world.

    CHALLENGE: The Customer used their SharePoint 2013-based corporate intranet actively as a unified collaboration hub and a central document and workflow management system ensuring the company’s daily business processes and supporting uninterrupted employee collaboration. With SharePoint 2016 released, the company decided to upgrade their intranet. Switching to the newest version of the platform, the Customer wanted to benefit from numerous advantages, including the solution’s better performance, improved data protection, the possibility to adapt the intranet to mobile devices and more.

    SOLUTION: Our team started the SharePoint migration project with assessing the current state of the intranet. Procentric experts analyzed the following:

    • Customer’s SharePoint farm
    • Content databases
    • Assessed the customization level of the intranet
    • Examined custom solutions that could require additional setting after the migration.

    The analysis performed by the SharePoint team allowed the specialists to draw up the migration plan and start the project’s active phase. The project was divided into several stages in order to enable a step-by-step migration of the intranet content and solutions without interrupting the company’s daily business processes.

    The team created the backups of all content databases to ensure data safety and used Windows PowerShell to export the solutions. Procentric paid particular attention to the migration of such vital solutions as a contract management system and quality management system that contained a large number of custom features. All custom workflows within those systems were migrated with SharePoint Designer 2013.

    The marketing and sales site collection was migrated separately to ensure a correct transfer of all materials and keep the integration with the Customer’s website. A deeply customized home page of the intranet was migrated with no deviations in functionality and design.

    At the final stage, our SharePoint developers collaborated with the Customer’s SharePoint administrators to migrate SharePoint MySites, configure them properly, activate files of custom solutions, adjust authentication issues and fix log errors. The administrator’s involvement was also required to ensure the intranet integration with a customer relationship management system and a corporate project management system.

    RESULTS: Procentric fulfilled the SharePoint migration project within the planned timeframe and budget. The upgraded intranet shows a much better performance. Particularly, employees highly appreciated an improved page response time. Furthermore, the upgraded internet now allows users to:

    • Work effectively with large files and benefit from the improved sharing capabilities.
    • Access the intranet from mobile devices to collaborate with colleagues remotely.
    • Work with sensitive information safely owing to the improved security features and data loss prevention mechanisms.

    Moreover, the enhanced security became a great advantage for the Customer’s SharePoint administrators, as they can control the exchange of sensitive data permanently.

    TECHNOLOGIES AND TOOLS: SharePoint 2016, MS SQL Server 2014, Windows PowerShell, REST, JavaScript, HTML, CSS, SharePoint Designer 2013.   


    TECHNICAL: Sample Technical Reference on Strong Project Governance. Following is the client’s requirements and the solution for our client with the forms.


    • Create a Nintex form which will store personal information for every employee.
    • When a user selects multiple account types, it should display the related fields of each account type based on personal type.
    • When a user selects existing and selects Email or Laptop Change in the account type, Email group information (EmailGroup field lookup) should be displayed.


    • Created a Form using Nintex form where users can fill up the necessary data.
    • There are so many hide/show functions for each account type and for multiple account types.
    • When the user selects Email or Laptop change then we use a hide function to display the Email group field data.