Unlock the Power of Salesforce CRM

Unlock the Power of Salesforce CRM

Challenge:

It’s exciting when organizations grow, however, growth can also cause an array of challenges.

• Higher operational cost and maintenance involved in existing spreadsheet-based approach for managing customer support queries proving increasingly problematic.
• Integrating multiple applications On Demand and Local server to align key business functions in support of sales.
• Resulting in lack of timely response to customers, failure to meet SLAs and limited case visibility.
• Sales people have poor understanding of customer issues at an individual or company level.

Implementation:

We’ll analyze your specific needs and provide a customized implementation to overcome such challenges.

• Reviewing the business and developing a long-term plan for success by identifying the key problems.
• Moving from legacy software and systems.
• Staying on the cutting edge of Salesforce with our innovation.
• Providing unified user experience by multi app integration with a “single pane of glass” view.

Technologies used:

Salescloud had Empowered their sales team by leveraging best practices throughout the company.

Salesforce CPQ delivers fast and accurate proposals to boost sales and maximize company revenue.

Salesforce billing had seamlessly integrated the entire billing process with salesforce.

Conga Composer delivers sophisticated documents, presentations and reports from Salesforce

Differentiator:

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.

Business Benefits:

Access to the entire historical data in a centralized system.

Ensured proposals are created accurately that can be approved quickly and transmitted to customer easily - all within the Salesforce CRM.

Automated the billing process to speed up payment collection and improve the cash flow.

Streamlined automated document generation and reporting saves time and cost.

Enhanced Customer Satisfaction Using Standard Quality

Enhanced Customer Satisfaction using ISO 9001:2015

ISO 9001:2015 has enabled Data Template to achieve International recognition as a company which consistently delivers high-quality services with the use of emerging technologies.

Data Template has turn out to be more efficient and advantageous in numerous ways. Quality auditing is performed quarterly and continues to spotlight opportunities for process improvements. Post the audits the Non-conformities i.e. the deviations from the quality process are tracked down via traditional Root Cause approach thereby enabling the company to learn from the errors and perform the process in a standard way.

Quality Management Audits

Quality Management audits are structured reviews of the standard management activities like ISO 9001:2015 implementation process that facilitates & establish lessons to be learned, that may improve the performance on current or future project activities. These Quality audits are carried out by company on itself to confirm to management that their documented quality management system is working effectively.

This method of Quality Management System (QMS) also ensures to capture the customer feedback. Feedback from customers is taken based on a defined frequency which is generally yearly basis. Based on the feedback received from the customers, the company tries to implement new strategies that will help in upholding the quality of service and also the customer relation.

The intention of quality audits is to examine how the project is using its internal processes like ISO implementation to produce the service it will release to the clients.

Major goal is to discover ways to improve the techniques and processes that create the products and services. If issues are detected during the standard audits, corrective action are going to be necessary to the tools, processes and procedures to guarantee quality is re-established.

API Test Automation with Python

API Test Automation with Python

The Client

The Client is a multi-sourced national property data warehouse that contains tax, deed, mortgage, foreclosure, environmental risk, natural hazard, health hazard, neighborhood characteristic and property characteristic data for over 155 million U.S. properties, delivering actionable data to customers.

Challenge:

With the ever growing APIs, our client constantly has to run regression testing on the massive set of APIs and test the new APIs. Their QA staff was overstretched, and they did not have time to develop new test cases for the new APIs.
Moreover, our Client provide services to various customers, and their customer often request changes to how the API behaves. The client is responsive to these requests, but incorporating them requires additional testing.

Technologies Used:

MS Excel, pytest Framework, Python.

The Process

• Get familiar with the APIs.
• Create a pytest framework and prepare the scripts that will make assertions with the database and API response
• Transfer knowledge to the client.

Data Template Helped

We decided that automating API testing would help our client to run the regression tests efficiently and ease the QA workload.
In the beginning we learnt about their APIs, and we got an understanding of how to use their APIs in their processes.
Then we started automating their APIs by creating python scripts that will make assertions with the database and the API response. Manually comparing the API response fields with its database will be time consuming as we need to compare multiple number of fields.
In the end, we handed over the framework and part of the automated regression test to our client.

Benefits

• Automating the API response helped us to compare multiple API fields at one time only which is manually time consuming.
• Helped us identifying issues much faster than ever before.
• Any new fields if newly added can be tested easily by only making changes in the scripts.

Selenium Python Automation

Selenium Python Automation

Challenges

One of the main challenges that clients has faced during their application production releases is, certifying the application by completing the new feature testing along with manual regression testing within a short period of time. As number of manual test cases are more and its execution is very time consuming one. To overcome this difficulty, in every production release, client has asked us to automate their testing process to manage the production releases very effectively.

Solutions

We have proposed selenium framework which uses python scripting as programming language to generate test scripts.

The components we used are robot framework, Customized Issue log tracking report within the automation tool and Automatic Email setup for sending report to track test results.

The main advantages of using python is its faster execution time, its capability to run tests across different browsers and Supports parallel execution across browser. Also, Python is Open Source

Result

Using this automation framework and test scripts generated client can effectively manage their releases. Also, we were able to lower development costs for our client

Achievement of WCAG-2.0

Achievement of WCAG-2.0

Client:

The Client is a multi-sourced national property data warehouse that contains tax, deed, mortgage, foreclosure, environmental risk, natural hazard, health hazard, neighbourhood characteristic and property characteristic data for over 155 million U.S. properties, delivering actionable data to customers.

Challenge:

Accessibility for the websites by the physically disabled people i.e. (blindness including low vision photo-sensitivity; deafness, hearing loss, learning disabilities and speech disabilities) with an ease.

Our Solution:

To have accessibility of application for physically disabled people, we have taken WCAG 2.0 that was proposed by Americans with Disabilities Act (ADA). Web Content Accessibility Guidelines (WCAG) 2.0 a technical guideline, which explains how to make web content more accessible to people with disabilities. Web content in this scenario, generally refers to the information in a web page or web application, including text, images, sounds, code or mark-up that defines structure and presentation.

WCAG 2.0 have three levels of conformance, beginning with Level A (the minimum), Level AA, and finally Level AAA. WCAG 2.0 guidelines are organized under four principles: perceivable, operable, understandable and robust.

We have used the tools like “NVDA Screen recorder” and “Wave Tool”. Wave Tool helps to know the accurate areas of the application in which changes in the code need to be updated as per WCAG 2.0 guidelines (List A, List AA, List AAA). Whereas NVDA Screen recorder, it is the tool Blind people will be using for accessing the Web application. So we may take use of these tools for updating the code. Such that we will come to know, if we have missed any content/images/sounds/links those are not pronounced in NVDA Screen reader tool.

Technology and Tools:

Web technologies: Net MVC framework, HTML, CSS styles, jQuery

Tools: NVDA Screen recorder and Wave Tool

Benefits:

A company that incorporates accessibility using the WCAG 2.0 guidelines ensures that their brand’s digital properties are globally accessible, and reduces the need for resources to meet geographic-specific standards. We were able to lower development costs for our client. They found the project provided a significant return on investment as well.

As responsive of the application is part of WCAG 2.0 guidelines; we have made responsive for an existing application and retard the separately developed Mobile application. Such that the client gets benefitted in-terms of Revenue, Usage (no of people accessed) of the application also to have one type of code for entire application.

Achievement of Data Accuracy

Achievement of Data Accuracy

Client:

The Client is a US-based, Clothing, footwear and accessories provider for women through Stores and ecom in Retail sector. Here we are migrating the data from source system to target system by using this data we generate reports. Customer team do analysis on top of the reports for further improvement in business.

Challenge:

Finding data mismatch or data swapping or unavailability of complete data or finding the null values in Target system after loading data from Source system to Target system.

Our Solution:

We can achieve accuracy of data by comparing the Source system data with Target system, Write a query to fetch data from Source and write an equivalent query to fetch data from Target

We executed above query sets in Source and Target system and we fetch the data and compare the result data in a tool like Excel. After comparison data and count should be same in both Source and Target system.

Technology and Tools:

Integration Tool: SSIS

Database: Oracle, SAP Hana Studio, SQL server 2017 and HIVE

Reporting Tool: SAP BO, Power BI, SSRS and MS-Excel

Benefits:

Since business users can quickly access critical data from a number of sources they can rapidly make informed decisions on key initiatives. Data and analytics have become indispensable to businesses to stay competitive. Businesses use reports, dashboards, and analytics tools to extract insights from their data, monitor business performance, and support decision making.

Providing business solution for calculation of availability of Services for a leading US based network telecom company Viasat Inc

Client:

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.

Implementation:

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

Technology and Tools:

•   Different AWS features like DynamoDB, Lambda, CloudWatch, S3 buckets.

•   Python Scripting.

•   Operating System: Linux

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.

Bug fixing for a 9100 Tellabs device of a leading US based telecommunications company

Client:

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.

Technology and Tools:

Scripting languages: Python, and Shell.

Programming language: C.

Operating System: Linux.

Tools: R6-simulator.

End-to-end test automation for a Cloud computing application of a leading US based telecommunications company

Client:

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 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 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 DT delivered business value:

•  Identified defects early in 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.

•  Reduced test cycle time by 50 percent by code optimization and frequent memory clearance through automation scripts.

Technology and Tools:

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

Tools: Selenium Webdriver, Appium, Jenkins, CircleCI, Ansible Playbook.

Achievement on Security and Localization

Client:

The Client needed a local search engine website for the Companies and Classifieds. This search engine should provide the product details of the Companies and Classifieds registered here.

Challenging Situation:

As the project scaled up, it became increasingly difficult not only to gather all needed information but to execute as soon as possible. We knew that it needed a better Framework to make it secure enough for the people, who really want to trust And the project needed localization for every international user. In addition, the project was not well-versed in best practices and did not have the skills to either kick the project off or bring it to the next phase.

Our Solution:

We hosted a planning session and decided to kick off the project with the open-source PHP framework i.e. Laravel. Learning a new framework is daunting, but it's also exciting. To develop the website localized we decided to develop the project with keywords in place of every text.

We created a file with

• keywords of the text

• Language Required

• Language Required

We linked the file in the environment section to get those words, related to the keyword that we are calling. After changing the language itself we were able to get the localized website. Such that in place of creating the projects in different languages, we created one project and used keywords for texts and according to the requirement we are fetching the translated texts.

Technology Used:

Open Source PHP framework Laravel ,MySql

Benefits:

The decision to use this framework took the pain out of development by easing common tasks used in the project, such as authentication, routing, sessions, and caching. Localization helps the project to be international with less effort.

Employee Engagement with Data Template

The Challenge:

Our employees use to compare the compensation & benefit with the big MNC’s. so we thought to understand what will make our employees to have a Better work place?

As per our research we changed our approach in 3 major aspects.

Our Approach

The best compensation & benefit that all the employees would like to have is like Growth opportunities, work-life balance and company culture. Here we concentrate & do this for our employees.

A. Growth opportunities:

We are providing a cut edge service in to various new technology in US & Europe market to our client, which currently not even started by the big company in Indian market. By that we are providing the opportunity to our employees to Learn, Work & R&D in the new technologies, adding to that we do have an efficient Library, monthly magazines & some training in place related to the technology upgradations.

We not only concentrate on the Skills & technology growth of our employees, but we do promote them for the next level (Designation) & appraise them by financially.

Every quarterly we do have a feedback session of all our employees to address the good practice & the area of improvement. It was helping then to concentrate the gap for their carrier growth.

B. Work-life balance:

Work-Life Balance is important for keeping employees happy, motivated, and productive—but employees can’t achieve work-life balance on their own—there’s an opportunity to boost engagement by developing policies that enforce work-life balance.

For that we do have various options & policies in place.

Time policy: We made a regular office timing of 9.30 am to 6.30 pm. We made our employees to follow the same, so that the employees can complete their work on time & spend their sweet times with their family. next

WFH: We do have the WFH option that the employees can avail on the required base.

C. Company culture:

Company culture is the personality of a company. It defines the environment in which employees work. Company culture includes a variety of elements, including work environment, company mission, value, ethics, expectations, and goals.

mPower Heart e-Suit for Patient–Centred Chronic Diseases Care through Clinical Decision Support, Big-data Analytics and Machine Learning

mPower Heart e-Suit for Patient–Centred Chronic Diseases Care through Clinical Decision Support, Big-data Analytics and Machine Learning

Overview

Chronic disease such as hypertension, diabetes, dyslipidemia, chronic obstructive pulmonary disease/asthma, etc are major challenges to health systems worldwide. Despite recognition of the benefits associated with early detection and treating chronic diseases and its risk factors, control rates remain suboptimal. Personalized medicine, the treatment process that is tailored to the individual needs of each patient, is recently gaining increasing attention for its prospect in the development of effective chronic disease treatment regimens.

We have developed a software application, namely mPower Heart e-Suit, to facilitate evidence-based, personalized medicine practice by doctors. It is designed to help doctors in computing clinical management plan in accordance with the latest clinical management guidelines/protocols. In addition, the mPower Heart e-Suit helps in standardizing care and setting benchmarks across health facilities.

The e-Suit as the following features such as:

• Computing clinical risk scores;
• Electronic storage of patient data for life-long follow-up;
• Clinical Decision Support Feature – i.e. generating personalized management plan for patients by computing through complex clinical management algorithms for suggesting optimal drugs, their dosage and warning contra-indications, etc. The Clinical Decision Support feature makes it unique, which is missing in electronic health record systems (EHR) available in the market.

The scientific development of the mPower Heart e-Suit has been published in the Journal of the American Heart Association. Currently two state governments – Tripura and Mizoram - have adopted the mPower Heart e-Suit covering 56 government primary care facilities. The system is also helping in healthcare planning by assessing cost of chronic disease programs, workforce management, planning logistics etc.

The mPower Heart e-Suit has won several accolades. It has been presented at the Royal Academy of Engineering, held at Oxford Union, UK during 18-20 Sep 2017. Furthermore, the World Health Organization has selected us to develop an App for promoting the use of WHO PEN Package in the clinical management of non-communicable diseases using the mPower Heart e-Suit platform. The new variant - mPEN App – is currently being piloted in Maldives which is likely to be promoted by the WHO in the South – East Asian Countries

mPower Heart Project:

Results from Himachal Pradesh

Impact on Process of Care

•   Access to evidence based guidelines

•   Task shifting

•   Less paper work

•   Self confidence & knowledge

•   Access to patient records

•   Standardized care

•   Better Follow-ups

•   Lifestyle advices

•   Assurance of providing best health care at Primary Health Care facilities

•   Real-time, Reliable, Accurate, and Secure data

mPower Heart Project: Tripura

•  Funded by the NHM and State-wide implementation

•   40 hospitals: 2 PHCs, 19 CHCs, 12 sub-district hospitals, 6 district hospitals & 1 State Hospital

•  Technical Coordination Cum Support Team:

•  State Health Officials and Project team
•  Software updates
•  Operational updates

•   Dedicated website for project: https://tripurancd.org/

•  Server Access for state government

•  Patients enrolled/benefited: ~70,000

mPower Heart Project: Mizoram

•  Adopted for state-wide implementation in Tripura

•   16 hospitals: 5 CHCs, 3 sub-district hospitals & 8 district hospitals

•  Server Access for state government

•  Patients enrolled/benefited: ~8000

Recognition and Awareness

•  ICMR selected mPower Heart System as a showpiece for the ‘Exhibition on Innovations in Medical Science & Biotechnology’ at the Rashtrapati Bhavan in 2015

•   “mPower Heart Model for NCD” selected for oral presentation at Fourth National Summit on Good, Replicable Practices & Innovations in Public Health Care Systems in India, Indore, Madhya Pradesh 6th July to 8th July 2017

•  Presented at the ‘Frontiers of Engineering for Development’, organized by the Royal Academy of Engineering, at the Oxford Union during 18-20 Sept 2017

mPEN App for WHO

•  Clinical Decision Support Software for management of NCDs as per WHO PEN Package

•   Powered by mPower Heart e-Suit

•  Being piloted in Maldives

•  With the Support from WHO-SEARO

Adopted by Government of India

•  Ayushman Bharat Program (National Health Protection Program) – Largest ever Health Insurance Program covering 500 million population

•  Dell-EMC developing a Software Application for the Program with funding from TATA Trust

•  Government of India is integrating mPower Heart e-Suit with the Software Application as the clinical decision support module

Courtesy: Public Health Foundation of India & Centre For Chronic Disease Control