Data Template

Data Template

Smartphone-based Clinical Decision Support System for Hypertension and Diabetes Care at Primary Health Care Facilities in Solan, Himachal Pradesh: the mPower Heart Project

Hypertension and Diabetes have emerged as major public health challenges in India. Although these two conditions can be effectively managed at primary care settings, poor quality of primary care services results in huge burden of undiagnosed and under-treated cases of hypertension and diabetes at the community level. In order to address such critical gaps in care the Centre for Chronic Disease Control and the All India Institute of Medical Sciences attempted to develop a mobile phone technology enabled intervention in the Solan District in collaboration with the Government of Himachal Pradesh.

A carefully developed smartphone based clinical management decision support tool was developed for the use of nurses at the outpatient clinics of five Community Health Centres (CHCs) in Solan in order to help the Medical Officers in screening and provision of treatment of hypertension and diabetes. The smartphone tool helped the nurses to run a clinical risk score to identify people with likelihood of having undetected diabetes.

outpatient clinic attendees, above the age of thirty, for diabetes and hypertension. Using the smartphone DSS a personalized management plan is computed for such diagnosed patients with the concurrence of the Medical Officers. The DSS computes management plan based on evidence based clinical management guidelines in order to reduce medical errors and standardise the care from all the CHCs. In addition, the patient record generated by the software is helping patient evaluation during follow-up visits.

Judicious use of medicines, medical investigations, surgical interventions and follow-up care in health care is fundamental to high-quality health care delivery. There are several barriers to disseminate medical practice guidelines to health care professionals to ensure such judicious practice in health care. The vast number of health care professionals, different levels of training of health care professionals, multiple providers (public, private), language barriers etc are some of the barriers. Advances in information and communication technology is a potential solution for addressing many of these challenges For example, software applications can compute personalized management plan for patients, considering various clinical parameters such as age, severity of the conditions, pregnancy, co-existing disease conditions etc. A structured format for assessing the patient though computerized prompts will help the physicians to do the clinical evaluation without loopholes. Using these inputs the software application can compute the management plan using the most recent medical practice guideline. Such computerized decision support software systems (CDSS) has been tried in the developed countries for specific conditions such as hypertension and diabetes. However, the feasibility and effectiveness such computerized systems are yet to be formally evaluated in India. Datatemplate is developing a software solution for Public Health Foundation of India for the use of Physicians in Public Health Hospitals of Andhra Pradesh to promote high quality care for hypertension patients. This novel software is capable of computing medications as per the latest Indian Hypertension Management Guidelines. In addition, the software will compute laboratory investigations, life-style interventions, referral suggestion and follow-up plan in accordance with the clinical profile of the patient. This internet-capable software will also leave a copy of the patient details in a central server which can be retrieved by the physician for subsequent follow-up visits thereby enabling sound follow-up care. The evaluation of the software is currently being carried out in Andhra Pradesh.

Mobile phones are transforming the lives of millions and has tremendous potential to improve health care delivery in low income countries. Mobile phones are ubiquitous, and the technology is used by millions, even by the most poor and illiterate. Portability, low consumption of power, internet capability, lower cost and minimal infrastructure requirement are superior features/advantages of mobile phone technology for low-resource, developing country settings. Thus communication and computing capabilities of mobile phones make it an ideal health care tool. Datatemplate is developing a mHealth solution for the Public Health Foundation of India for the use of Physicians in Public Health Hospitals of Himachal Pradesh to promote high quality care for hypertension and diabetes patients. Mobile phones loaded with this software will help in building an organized system of care for hypertension and diabetes care in public health hospitals. The software will aid the physician to compute clinical risk scores to identify people at high risk of diabetes; and generate guideline based treatment plan (therapeutic lifestyle, pharmacologic, laboratory investigations, and follow-up schedule) tailored to individual subjects. This internet-capable software will also leave a copy of the patient details in a central server which can be retrieved by the physician for subsequent follow-up visits thereby enabling sound follow-up care. Automated transmission of patient reminders (drug intake and follow-up visits) through short-messaging services to the patients is another feature of this software. The evaluation of the software will be carried out in Himachal Pradesh.

After a series of discussion we had across our innovation team, we decided to start a product implementation based on IOT which could provide the live temperature and the continuous data pushing to the data server with the help of Kaa Server and Hadoop.

Design/Methodology/Approach

•   We Started with a detailed R&D on choosing a suitable open source middleware platform for the Internet of Things. Looking at the feature rich toolkit and the user-friendly UI for the IOT product development, we chosen the Kaa IOT development platform for establishing the end point communication (HADOOP, MongoDB, etc)
•   Identified and implemented the Hardware architecture using Raspberry Pi 3 Model B for interfacing the Temperature Sensor (DHT22).
•   Built our own customised OS (Debian Linux), for enjoying the OS level flexibility to modify things according to the User requirement (Eg: UI design while booting) and implemented the same OS in Raspberry Pi.
•   Developed the code in ‘C’ for reading the live Temperature and Humidity value from the Sensor.
•   Used the Kaa Server to push the live Data from the sensor to reach the local Data Servers.
•   Considering the scope of Multiple Data Sources across the countries, we selected and Implemented Hadoop technology in our architure for handling the Big Data.
•   Representation of the Data in graphs was achieved using the D3 charts, since it provide us more flexibility in scaling and displaying the data.

Achievements

•   Successfully achieved the project flow from reading the sensor data to storing in Data Servers and Displaying the D3 Data Chart.
•   Implemented the alerting system via Email and Text messages, when temperature overcomes the threshold value.
•   Interfaced the LCD Touch screen with the Raspberry Pi and provided user selection UI for Temperature and Humidity to display the Live Sensor Data.

The objective is to automate the process to the maximum extent possible by utilizing advances in technology such as Mobile, third party services, etc and speed up the lending process by bringing efficiencies across the lending supply chain to the extent possible.

Client Situation

Client required us to bring efficiencies in the direct to consumer sub-prime auto lending workflow by automating the tasks where possible and provide a seamless experience for human intervention where necessary.

Our Solution

At the beginning of the engagement, we were required to address following;

•   Identify and freeze the list of third party services need to be integrated as part of solution
•   Understand the suitable methods available in each service and which is useful for the proposed application
•   Design and implement an optimized way to call different APIs using a generic method

To overcome the above challenges, we designed and implemented Web api architecture by considering below points

•  Implemented architecture of the application with 3 layers for easy code maintenance
•   Used Dapper ORM: Object Relationship Mapper that maps your database directly with C# objects.
•  Used XSLT transformation to generate third party API input dynamically
•  Used NUnit for unit testing
•  Used MongoDB to store input/output data in JSON format. MongoDB uses JSON-like documents with schemas
•  Used Redis for caching. This is an open-source  in-memory database project implementing a distributed, in-memory key-value store with optional durability

How DT delivered business value

•  Identified the right methods offered by different third-party services to be integrated in the proposed solution. Discussed and confirmed with client
•  Brocken the features into sub tasks and assigned to team as part of each sprint.
•  Demonstrated each sprint deliverable on the last day of sprint. This helped to identify any changes in the early stages and addressed quickly

Various Technologies and Tools we use for Automation

Microsoft Visual Studio 2015, Framework 4.5, C#.NET, Web API and Microsoft SQL Server 2014

End-to-end test UI automation for iPad application of a leading US based Mortgage Industry.

Client Situation

Every time we add new features to our apps and fire up the simulator to make sure we didn’t break anything and every time we tap on the same button over and over to see if we have a memory leak. To build a useful and bug free software for our customers while keeping up with Apple’s fast pace. So we use Apple’s built-in UI Automation tool to capture and play back a very simple script of user interactions.

Our QA consultants undertook an assessment initiative to identify the current automation challenges and design the optimal solution for the client’s needs.

Our Solution

At the beginning of the engagement, we were required to address these issues;

•   Overcome consistent and repeatable manipulation of the user interface.
•   To change our tests fast, so we can easily keep up with the UI changes.

To overcome the above challenges, we designed and implemented feasible test strategy

•   Implemented ‘UIAutomation’ framework-based test automation approach using Instruments (UIAutomation tool in XCode) which used with the scripting languages like JavaScript.
•   Build & Run the source code on the targets (iOS Simulator & iPad) to be automated in XCode.
•   Performed risk-based test case analysis to optimize the number of test cases executed.

How DT delivered business value

•   Identified defects early in the lifecycle by implementing early automation.
•   Automation became highly scalable, easy to maintain, and considerably reduced execution time and cost
•   Identified 80 percent more defects before go-live due to early automation strategy.

Various Technologies and Tools we use for Automation

Scripting languages
Javascript

Tools
Instruments- UIAutomation tool in Xcode

Framework
UIAutomation Framework

Relationships are at the heart of business for any enterprise. Customers that are emotionally connected to a brand are more likely to purchase a product or service, and are even more likely to defend their purchase decision. Yet, over the years, customers trust has only built up within individual business divisions, and as a result, officials in each division had a different and very incomplete picture of their interactions. Customer relationship management (CRM) is a technology that allows businesses (of any size) to organize, automate and synchronize every facet of customer interaction.

The Challenge

Every business, have their own uniqueness associated with their company. The way one functions is not the same like the other. Many fear the changes associated while taking up Sales force CRM. The Data Template’s approach is to recognize the ultimate goal and to ensure reliable operation for mission critical applications across the teams. To enable, hassle free services, we closely understand the business and provide a unique business solution that is simple, not complex.

Our Solution

“Data Template” is an expert in Salesforce application development and optimization.” Many businesses have assumes that it was not flexible enough to fit their specific business needs and finding their business was hard to maintain. We assure you to change the CRM application to fit the way your business needs. Something which you wouldn’t have known is that Sales force CRM is highly customizable by design.

•  Custom Development - By leveraging our strong expertise to provide custom solutions for your business.
•  Data migration - Implement industry ‘s best techniques to perform data migration and ensure data quality.
•  Integration - Seamlessly integrate and synchronize salesforce CRM with on-premise applications.
•  Implementation - We combine a streamlined implement approach with pre-configured options to quickly deliver business results.
•  Training & Adoption - We ensure to educate and train your teams and helps them overcome the difficulties that are embraced .

In order to ensure a successful implementation, we will start with the implementation process with a series of discovery calls with businesses to understand their business needs and what they required from Salesforce. We interact with heads of different departments to understand their individual department needs to create a solution that would work for all departments.

The Outcome

All our customers are actively using Salesforce and it is customized and automated to fit their business needs.

•   A unified approach forges stronger high touch customer relationships.
•   Mobility brings together all the users and their customers where ever they go.
•   Advanced reporting capabilities, allowing businesses to run reports on all of their data.
•   Highly secured and can easily manage the security measures.
•   Training speeds up employee adoption and are able to maximize their Salesforce usage.
•   The innovation team explores new frontiers on the platform.

Salesforce CRM is being embraced by a number of organizations as it has proven results of being an effective and powerful technology. Despite being such a robust technology, companies are just using the cream of it. With partial usage of this technology, companies are finding an increase in user resistance as well as organizational noise. Ultimately the projected return on investment is not realized.

A cloud friendly apps development involves changes in how developers work with databases, an emphasis on stateless applications, and dealing with various frameworks. Data Template, with a team of experienced and professional Apps developers can develop Apps, based on the specific requirements of the individual client.

Creation of ethereum based blockchain platform for authenticating a Payee and the designated account to which the funds would be transferred.

Client Situation

As result of a business discussion with the client company, we proposed an idea of creating a banking application with all the important features required for a customer to do his banking with a user friendly UI and operation features. Later on by doing the analysis and feasibility study on the client system functionality, we committed to implement an ethereum based blockchain platform for authenticating a Payee and the designated account to which the funds would be transferred.

Our Implementation

At the beginning of the engagement,

We started with a detailed R&D on choosing a suitable open source middleware platform for developing a single page application.

•   Block chain is an immutable, security rich and transparent shared network, provides each participant end-to-end visibility based on their level of permission.
•   Looking at the feature functionalities and the user-friendly UI we chosen the angular as Development platform for establishing the end point communication from UI to DB ( NODE(API),MongoDB, etc)
•   Considering scope of npm tool that allows downloading libraries and packages in using angular.
•   Adding Payee details in a platform which provides required fields like name and address etc on submitting through ajax call to node API.
•   Posted to DB(MongoDB) and send back intimation to the user about registration status of the payee.

To overcome the above challenges, we designed and implemented feasible test strategy

•   Implemented ‘UIAutomation’ framework-based test automation approach using Instruments (UIAutomation tool in XCode) which used with the scripting languages like JavaScript.
•   Build & Run the source code on the targets (iOS Simulator & iPad) to be automated in XCode.
•   Performed risk-based test case analysis to optimize the number of test cases executed.

How DT delivered business value

•   People to carry out transactions at never-before levels of privacy, security and non-intrusion.
•   Fast responsive and more reliable.

Various Technologies and Tools we use for Automation

Scripting languages
angular 4, node js, Type Script, ethereum/Solidity, Golang.

Tools
Visual studio code, npm


Client Situation

Since the new feature’s development, enhancement activities have become more for the application, the client wanted to reach hundreds of test coverages as part of regression testing to make sure the new implementations have not affected the existing features. Later, realizing the manual verification of end to end features in a daily basis goal seems difficult as the client could not provide the feature deliverables to their end users. This curtailed the client’s ability to meet their expected delivery of verified features as the new implementations started affecting the existing features.

Our Quality Assurance consultants undertook an assessment initiative to identify the current automation challenges and design the optimal solution for the client’s needs.


Our Solution

At the beginning of the engagement, we were required to address these issues

•   Overcome high execution cycle time, which was resulting in timeout issues and execution failures.
•   Fixing of the inaccurate result reporting in the existing scripts, which led to low confidence in automation.
•   API as well as different database testing which posed more challenges in achieving efficient automation coverage.



To overcome the above challenges, we designed and implemented feasible test strategy

•   Implemented ‘TestNG’ framework-based test automation approach using Selenium which used with the scripting languages like java, python, Perl etc.
•   Introduced the idea of cleaning up of the test environment/application and installation of new environment with all the latest feature commits and execution of test cases using Jenkins tool by creating multiple jobs.
•   Performed risk-based test case analysis to optimize the number of test cases executed.
•   Implemented multilayer expert test reports with server logs attachments and issue root causes.
•   Email summaries and web dashboards to visualize the graphical representation of test suite executions, thus increasing the confidence in automated script and easy troubleshooting.

How we delivered business value

•   Identified defects early in the lifecycle by implementing early automation.
•  Automation became highly scalable, easy to maintain, and considerably reduced execution time and cost
•  Identified eighty percent more defects before go-live due to early automation strategy.
•  Reduced test cycle time by fifty percent by code optimization and frequent memory clearance through automation scripts.

Scripting languages
Java, JS, Python, Perl, Ruby, C#, Shell.

Technology & Tools
Selenium -Webdriver, Appium, Jenkins, CircleCI, Ansible Playbook.


Client Requirement

Since the client was in a situation that, ‘n’ number of users from their thousands of customer companies need to identify the availability of several types of services of a time point and at range of time in the form of availability percentage as well as in a graphical representation. As this implementation was a very critical challenge to the client organization, we had a detailed discussion with client to understand the existing system and its present functionalities for coming up with an idea.

Our Solution
An analysis is carried out first on what way of implementation can be approached by studying the present client system and their Databus stream details, we decided to implement a framework and the output of the framework as different APIs which can be used for services to register their metric on databus to be monitored for calculating a daily, weekly and monthly service availability number as well as to get it in a graphical representation.

Design/methodology
•   Created a framework contains settings file for the environment setup and other scripts, framework infrastructure using cloud formation feature of AWS.
•   Execution of register service, availability calculation functionalities using AWS Lambda functions feature.
•   Analysed and opted DynamoDB as a suitable database for storing the continues data in a well-defined table structure.
•   Extra addition of security features to the user APIs by integration AWS IAM authentication technique.
•  Provided modifiable settings and infrastructure build file which can be deployed in different AWS regions to get different API urls for the different availability zones.
•  Added addition features as MTTR (Mean Time to Repair) feature which will help the user to identify the failure metric for a particular time period which is most helpful to identify the health of a service.
•  Implementation of MTBF (Mean time between failures), is to predict elapsed time between inherent failures of the service during normal system.
•  Integrated Grafana for displaying the availability graph for the registered services.

Key Benefits

•   Provision of user friendly APIs to the client for registering a service, calculation of availability percentage in hourly, daily and monthly basis.
•   Provided a very rich set of graphing option for matrices using Grafana
•   High accuracy in availability calculation of service health.
•   DB backup options up to one month.
•   High secured APIs with AWS IAM authentication.
•   MTTR and MTBF features to check the frequent service health.

Technologies and Tools, we used

•   Different AWS features like DynamoDB, Lambda, CloudWatch, S3 buckets.
•   Python Scripting.
•   Operating System: Linux

Client Situation

Since the network traffic is getting increased day by day the following problems will occurs in ASN like Network traffic, unable to register the network, unable to manage the traffics using base station, unable to login to the device, DHCP is unable to assign ip to the subscribers etc.

Our Solution

• Using R6 simulator we will reproduce the same scenario again to confirm the issue, if issue confirmed then immediately start debugging the code using GDB.
• Initially our goal is to find the root cause for the issue, there might be two chances in all the cases.
i) One is logical issue with ASN source code.
ii) The other one is ASN configuration issue.
• Once we got the clear picture about the root cause then we will start fixing the issue according to that.
• We have enhanced the feature of R6 simulator, from single network entry to multiple network entry with R6 simulator.
• We have done fix for DHCP pool load balancing and renew subscriber to get old IP if its lease time did not get over and service type is same.

How DT delivered business value

•   Identified defects as soon as possible and deploy the code into the ASN.
•   Fixing the issues consistently and made the ASN device more stable
•   Effectively improved the ASN performance.
•   Identified 60 percent real-time defects and fixed before it get affects the client execution.
•   Optimized the code and frequent memory clearance for ASN.

Various Technologies and Tools we use for Automation

Scripting languages
Python and Shell.

Programming language
C



Client Situation
Since we use a tool like Docker in our workflow and also want to run it on CI, It was difficult to use Jenkins as it doesn't provide any built-in support for this, also Client want the features such as checking out source from GitHub or Bitbucket, running builds and tests with our favourite tools, parsing test output, and storing artifacts to be plugin free also need to overcome the difficulty of sharing configuration settings information within a team or organization.
Our QA consultants undertook an assessment initiative to identify an all-in-one build management, testing, and deployment solution that satisfies the client’s needs.

Our Solution

At the beginning of the engagement, we were required to address these issues;

•   Making CI configuration easy to manage and share like any other source code.
•   Avoid rely on team of engineers on-call to install dependencies and troubleshoot issues for maintaining a CI   system.
•   Overcome the trouble of managing and installing plugin to do almost anything as followed in Jenkins
•   Increase the parallelism in any project’s settings without cause subtle issues related to shared resources like   databases and file systems.
•   Finding a built-in support for running a work flow with Docker on CI rather than installing it manually within build   environment.

To overcome the above challenges, we came up with Circle CI. Circle CI is a very different product from Jenkins with a lot of different concepts on how to manage CI and CD.

To overcome the above challenges, we designed and implemented feasible test strategy

How we done!

•   Implemented ‘Robot’ framework-based test automation approach using Selenium which used with the scripting languages like python, Jython etc.
•   Created an account by logging in with GitHub, As CircleCI is intimately tied to GitHub.
•   Created a Repository in GitHub by initializing with a README
•   Set up the project on Circle CI by selecting the Operating system and scripting language
•   Implemented Workflow in Circle CI for Build deployment & triggering the test suites and scheduled the work flow.
•   Stored the job results in an empty directory and export its path in the read only CIRCLE_ARTIFACTS environment variable.
•   Enabled the Debug via SSH option to troubleshoot problems by SSH into a running or finished build.

How we delivered business value

•  Reduced Operational Overhead, as CircleCI saves the trouble of managing and installing plugins because all core CI functionality is built in.

Minimized developer downtime

•  Instant parallelism at any scale dramatically cuts build times for even the most demanding test suites.
•  Configurable build environments and caching of dependencies and source code speeds up build times.
•  Configuration in code puts power in the hands of developers to tweak the build without waiting for centralized resources to free up.


Continually optimize software delivery

•  Insights on trends and behaviours inside and across the builds, lets team to quickly identify bottlenecks that waste everyone’s time.
•  Visibility on the state of your builds gives everyone across the team a clear picture of throughput
•  Easy per-branch build configuration lets developers experiment without interrupting each other’s builds.


Security

Source Code security
•  Circle CI use oAuth to GitHub and/or Bitbucket as primary authentication mechanism and mirror the permissions to code in those systems.
•  Access of CI systems to source code is always encrypted over the wire using SSH and/or HTTPS.

Run time isolation
•  Each run of test will happen in a secure sandbox, either a Docker /LXC container or a virtual machine. Each sandbox is firewalled, and it is not possible to access a sandbox from another sandbox, or from the internet at large. Each job starts in a fresh sandbox, and each sandbox is destroyed after each job.

Environment Variables (Secrets)
•  All environment variables encrypted and stored at rest associated with a specific repository in source control.
•  Access to environment variables is restricted only to those with access to the repo associated with the environment variables.
•  Environment variables are unencrypted and injected into the runtime environment when each job starts and disappear after the sandbox running the job disappears after the job if finished.

Console Output and Artifacts
•  Artifacts are stored in private S3 buckets and available only by authenticated users with read access to the underlying repository. In both cases, encryption is employed over the wire using SSH and/or HTTPS.

Various Technologies and Tools we use for CI/CD

•  Scripting languages
Java, JS, Python, Perl, Ruby, C#, Shell.

•  Tools
Selenium -Webdriver, Appium, Jenkins, CircleCI, Ansible Playbook.

Dunmy text Mobile phones are transforming the lives of millions and has tremendous potential to improve health care delivery in low income countries. Mobile phones are ubiquitous, and the technology is used by millions, even by the most poor and illiterate. Portability, low consumption of power, internet capability, lower cost and minimal infrastructure requirement are superior features/advantages of mobile phone technology for low-resource, developing country settings. Thus communication and computing capabilities of mobile phones make it an ideal health care tool. Datatemplate is developing a mHealth solution for the Public Health Foundation of India for the use of Physicians in Public Health Hospitals of Himachal Pradesh to promote high quality care for hypertension and diabetes patients. Mobile phones loaded with this software will help in building an organized system of care for hypertension and diabetes care in public health hospitals. The software will aid the physician to compute clinical risk scores to identify people at high risk of diabetes; and generate guideline based treatment plan (therapeutic lifestyle, pharmacologic, laboratory investigations, and follow-up schedule) tailored to individual subjects. This internet-capable software will also leave a copy of the patient details in a central server which can be retrieved by the physician for subsequent follow-up visits thereby enabling sound follow-up care. Automated transmission of patient reminders (drug intake and follow-up visits) through short-messaging services to the patients is another feature of this software. The evaluation of the software will be carried out in Himachal Pradesh.

Change your device orientation

Portrait mode, please.