Cloud Computing Technology in Healthcare Sector

Cloud computing is Internet based computing whereby services are provided to the end users on demand.  In initial days, the computer was local, software and application was local and data was local to a user. As the internet technologies started to grow, the data was transmitted from server to local system, and finally the data ended up locally. Then, the few companies started architecting their site in order to use the capabilities of the browsers like Internet Explorer.  The companies started to enhance the technologies and stared to provide the service through the Internet and hence evolved “Cloud computing”. Cloud computing in general, is a service such as software, operating system etc., is available to the end user on demand and the user has to pay only for what he is using.

Security is only the major factor which, lot of them argues against cloud computing in Healthcare. A patient record is too personal and it is to be maintained with high security. In cloud based applications, the data will be maintained globally with the provider. As cloud based computing inherits the advantages of internet it also inherits the vulnerability of getting hacked by hackers.  Since security is a threat in Cloud computing, the cloud computing providers like salesforce.com, Microsoft, Google, Amazon are providing higher level of security to the user data. The Cloud Security Alliance is a non-profit organization formed to promote the use of best practices for providing security assurance within Cloud Computing.

There is lot of advantages in cloud computing which overcomes its few disadvantages. With correct analysis of the requirement and implementing the hybrid of local and cloud computing applications, healthcare service providers can benefit improved outcomes. The Healthcare service providers can  create integrated online environments where one user can create and store personal records, get information, find doctors, make medical appointments, communicate online, manage medications, share information with providers and more.

Download Cloud Computing Technology in Healthcare Sector

Technical Testing in Datawarehousing Paper Presentation

Introduction

The basic intention of every tester would be “To break the code” for which the tester will carry out various types of testing such as Functional, Regression, Performance, Adhoc and End to End testing etc. over the application to find defects.  But at the same time, developer of the application also will work with the intention to “Save the code from the Tester and make a bug free application”.  Hence the development team nowadays is concentrating more on these aspects and infact they are also carrying out one round of these testing along with Unit testing.

This creates a big challenge to every tester and testers are now looking for new ways of approach of testing to find more defects.  Following chapters will discuss one of such new way of approach that would yield good number of defects.  No doubt, after release of this document, when development team come to know about this approach, again testers need to look for some other approach, giving room to a never ending learning process in finding newer testing approach.

Normal Approach

In this approach, a tester will design his test cases and test data based on the Requirement Specifications, Use Case documents and other Supplementary specification documents.

He/She will carry out various types of testing such as “System” / “Regression” / “Adhoc” / “End to End’ but all these testing mainly concentrate on the functionalities.

Alternate Approach

Apart from the traditional approach (since it is mandatory to confirm that the application delivers the expected functionalities), a tester have to confirm that the application works as expected on the technical aspects.  The technical aspects will vary depending on the technology that the application uses. For eg Technical aspects of Datawarehousing application will vary from a Web application.  When a tester puts more efforts on technical aspects, definitely he will discover a lot of defects.  For each catchability, we can call this approach as Technical testing.  You may like to call it as “Negative testing”

The below some thoughts on technical testing for Web as well as Datawarehousing application since most of the State Street applications currently using either web or Datawarehousing or both technologies.

Technical Testing for Data Warehousing Applications

For Data warehousing application, following technical test scenarios/cases can be tested in addition to the functionality testing.  Test cases were written for ETL environment that have Load Driver functionality.  Suitable modification can be made to these test cases according to the current test environment considering DWH tool is being used.

Test Description

Execution Method

Expected Result

To check for correct load process status in the load driver table before the load starts. Run a query to verify the process status in the load driver table before the load process. Load process status of the loaded table should be updated with correct status in load driver table.
To check whether load process status in the load driver table is correctly updated at the end of the successful load process. Run a query to verify the process status in the load driver table after the load process. Load process status of the loaded table should be updated with correct status in load driver table.
To check if the number of records extracted from the source is equal to the number of records loaded into the staging table. Count records in source using SQL query [for relational sources] or from Unix shell [for files sources.Count records in staging table using SQL query. The counts from source and staging table should match.
To check the staging table column values match with source column values. Run a MINUS SQL query between the source and staging tables in case of relational sources.In case of files sources select 10 sample records from source and staging table and inspect manually. The MINUS query should return zero records in case of relational sources.In case of files sources the manually inspected records should match.
To check that the specific reference columns in staging table only contain values from the corresponding specific lists. Run a query to select count of records from staging table where the values for the particular column are in specified list or range. This count should match the total count of records in the table.
To check if the values of the Surrogate keys in the staging table are in sequence. Run a query to select the values of the surrogate key from the staging table.  Manually check that the values are in sequence. The values should be in sequence.
To validate uniqueness of assumed business keys in the staging table. Run a query to select the count of distinct combinations of the columns that constitute the business key from the staging table. This count should match the total count of records in the table.
To check if the maximum sized field values (full value check) are extracted from the source and loaded into the staging table properly. Run query to select 10 sample records from source with maximum sized column values.Run query to select corresponding records from the staging table. The records should be identical.
To check NULLABLE columns in Target are loaded correctly (Null value Check). Before running the mapping, insert a record in the source table with null values for the fields which are not mandatory. 

After running the mapping run an SQL query to select the record from the stage table.

The corresponding fields should have NULL value in the Staging table.
To check for correct last update date and time value during Insert in to the tables Run a query to select the STG_LAST_UPDATE_DATE_ TIME from staging table for inserted records. 

Run a query to select the EXTRACT END DATE TIME from the Load Driver table for the corresponding Function group and Function name.

The STG_LAST_UPDATE_DATE_TIME for inserted records should be same as LOAD END DATE TIME.

 Technical Testing for Web Applications

For Web Application, following various testing can be carried out (in addition to the functional testing) to find more defects

  • Broken Link Testing

    Test to ensure that links provided in the application, upon selection, is directed

    to the correct page.

  • Navigation Testing

           Test to ensure that navigation among different pages are proper.  Also to

           ensure navigational buttons (Previous, Next, First, Last etc.) are working

           properly

  • Compatibility Testing

           Test to ensure that the application is compatible with various versions of

           Operating System, Browsers etc. as mentioned in the installation guide.

  • Useability Testing

           Test to find how the application is user friendly.  Testing will be concentrated

           on Screen Appearances, colour combination, meaningful error messages etc..

  • Security Testing

            Test to ensure the authentication process of the application.  Since scope of

            testing is very vast (such as hack testing, accessing directly the IP address of

            the given  URL etc..), we can select few features applicable to the current

            testing.

  • Other general testing which check for
  • Orphan Page

    Test to ensure that when parent window is closed, child window also gets closed.  Also to ensure that none of the application page gets displayed when the application itself is closed.

  • Page weight

          Test to ensure that the web page has the overall weight (may be

           between 60 to 70KB – depends on the custom design specifications)

           To know the web page weight, right click on the current web

           page and select Properties.  Page weight going beyond the

           recommended range may takes more time in loading the entire page

           thereby hindering the performance.

  • Session Timeout

           Test to ensure that the application is not timed out before the given  time range when no activity was carried out.  This time range may be  available with the design document or with the development team.

  • Static and Dynamic Pages

                     Test to ensure that the content in Dynamic pages are refreshed properly   on the specified interval without affecting the performance.  Also to   ensure that this refresh feature does not affect static pages.

  • Auto Refreshing mechanism

      Test to ensure that refreshing mechanism (wherever is applicable) is functioning properly on the specified interval without affecting the  performance.

Industrial Safety Measures System with Sensors and Webcam Abstract

Industrial safety measures system with sensors and webcam projects main idea is to develop a application which can provide security for industries by using sensors and webcams. In industries like pharmaceuticals and chemical industries contnous monitoring is very important so this application will be very useful for in reality. 

For any application in the industries there are many parameters to be handled. In this project we are concentrating on temperature and smoke sensors. These sensors are fixed at specified locations, for our application to be performed. The Sensors gather the values and sends the information to the microcontroller continuously. The microcontroller receives the values and sends the corresponding values to the LCD to display. This is a cyclic process which performs till our requirement is done.

In order to reach project requirement we need to reach our standards by allotting certain set points for every sensor for monitoring. If the Temperature Sensor crosses its specific Set-Point the microcontroller drives the Fan ‘ON’ and starts cooling. If the Smoke sensor crosses its specific Set-Point the microcontroller drives the Buzzer ‘ON’ and alerts the operator. This is under safety process. In this project we are connecting the webcam for visibility of changing the parameter conditions.

  Applications for this are Industries with heavy parameters to handle, complicated areas where we can’t monitor the conditions manually; these are Now-a-days used in all kind of industrial and commercial complexes.

download  Industrial Safety Measures System with Sensors and Webcam Abstract.

Speech Analytics Paper Presentation

Speech analytics has been in existence since last ten years and the traditional setup is more captive centric. Speech Analytics is Operational enhancement as in they use this Analysis to improve their performance matrices like AHT reduction, FCR improvement & determining TNI for agents. The approach followed is primarily towards working on Agent improvement.

However, Corporate Companies look at Business process Re-engineering end to end. These Corporate companies not only work on Agent skill set enhancement but simultaneously making the process & policies so Robust that the opportunity of error is reduced along with agent empowerment. The results derived these analytics gives an in-depth insight to the management team as to what exactly are the deterrents for the process (issue wise / Agent wise breakup) in terms of achieving respective objectives. Also on the other hand, it highlights process related issues like certain policies imposed by client are unpopular amongst the customers and that drives maximum customer dissatisfaction. The management team can take this up with the client and act as Partner in highlighting such issues and sharing recommendations for process improvement.

The Contact Center handling voice interactions might have some pain areas in terms of ensuring customer satisfaction along with better business benefits. Below is the list of a few commonly experienced challenges while handling a Contact Center.

  1. Volumetric Analysis: To identify why customers are calling. This can be further used to optimize the contact center staffing and SLA management. Key objectives under this header could be:
    1. Identify contact drivers
    2. Uncover trends and customer needs
    3. Increase the usage and effectiveness of self-service channels
    4. Customer Complaints: To understand the typical issues and escalation causes from the customers.
      1. Reduce customer defections
      2. Reduce costly escalations
      3. First Contact Resolution: FCR is a key cost driver for contact centers. Speech Analytics can help in improving FCR by understanding process gaps, knowledge gaps and any product/ service issues etc.
      4. Sales Effectiveness: Sales effectiveness of a process can be improved by:
        1. Pinpointing best (and worst) selling circumstances and behaviors
        2. Improve up-selling/cross-selling capabilities of the associates
        3. Increase closing rates by understanding why a deal gets closed or why is it dropped
        4. Customer Retention: Customer churn is one of the most important factors for driving business objectives. Speech Analytics can help to proactively identify the reasons why customers want to move out and what is competition offering.
        5. Handling Time: Features like quantification of dead-air (mute time), hold time etc. can help understand why calls are exceeding the target. Agent wise call type analysis can help designing the call routing system to ensure best agents are utilized for specific call types.
        6. Communication Issues: Speech analytics can proactively identify agents that need specific communication trainings. Talk-Over Analysis, Diction, and Comprehension etc. can be identified and coaching plan can be developed to improve these.
        7. Campaign Management: Monitor and quantify the benefits of any campaign launched by the client.
        8. Market Positioning: Customers often mention what competitors in market are offering and how the client’s product/ service are perceived by their existing customers. This can be a key input to R&D and Marketing teams of the customers.
        9. Product/ Service Design: Understand what is most useful for the end user and what the end user is willing to pay for? Also, understand what offering is not seen as a value add from end user perspective.
        10. Collections Effectiveness Improvement

The management team might know these problems from the weekly reports /dashboards but might face challenges in getting to the root cause of the problem. There is a lot of important information on customer insights which goes unattended because of lack of ability to leverage unstructured sources of customer communications which is available in the customer interaction. This insight can be provided by leveraging Speech Analytics.

Details of the proposed solution

 As mentioned earlier, Speech Analytics can be utilized to analyze get insight on customer emotion, behavior & experience basis customer verbatim. It can also help analyze the training needs along with agent level drill down on various call handling aspects like adherence to standard scripted verbatim, talk over, silence time etc. The solution which we are looking at is offered by NICE. This solution primarily works on these five approaches.

The attached document contains the below Table of Contents:

Introduction to Speech Analytics

Objective of Speech Analytics

Problems/Challenges Faced at Previous Speech Analytics System

Details of the proposed solution for Speech Analytics

New Approach for Speech Analytics

Discovery Session for Speech Analytics

Creating Lexicons

Creating & Fine tuning categories

Conclusion/Summary of Speech Analytics

Download Speech Analytics Paper Presentation

Paper Presentation on Social Media & Social Media Sites

Social sites is today’s market demand where customer’s are encouraged to share their thoughts and give necessary feedback.Advertising and publishing a secure web, blog, Forum or blogspot would encourage more participation and transparent feedback for the company product. Hence creating such media would help an industry to create their own nyshe by understanding customer’s transparent feedback on such social media.

The Attached document contains the below Table of Contents

Introduction to Social Media sites

Problems/Challenges Faced in Social Media sites

Details of the proposed solution

Benefits of Social sites

Success Stories of Social sites

Conclusion/Summary of Social sites

Download Paper Presentation on Social Media & Social Media Sites

Vehicle Accessing Using Authentication Project Abstract

Vehicle accessing using authentication project main aim of this project is to develop a RFID based system for vehicle authentication. In this system RFID tags will communicate with RFID reader module at a frequency of 125KHZ. This frequency is passed to controllers for further usage. RFID reader and RFID tags must be set to same frequency for communication between them.

                        To obtain the required parameters we assign different RFID tags to every vehicle that is to be authorized to pass through. These RFID tags have a range of 8-10cm when ever the vehicle that is assigned with these RFID tags enters the ENTRY/EXIT gates the RFID reader recognizes the RFID Tag and accesses the prior permission to the vehicle by opening the gate. The Microcontroller reads the RFID tag code and displays the time of the vehicle ENTRY/EXIT by using RTC (Real Time Clock) and displays it on the LCD.

                        Application of this kind can be used in offices, apartments, industries, colleges, Government or Private Sectors where there is a need to allow only authorized or secured vehicles to ENTER/EXIT in a particular area or zone.

download  Vehicle Accessing Using Authentication Project Abstract.

RFID Based Home/Office security system Project Abstract

This project RFID based Home/Office security system is developed to build a security system for a home/office to prevent the other persons to enter into the important room/chamber by controlling radio frequency identification by checking a suitable rfid card. 

            The rfid tag gives the unique id when ever it reads the card information. This id information is send to the micro controller to check the correct card to take a security action. If the card id matches with the original information, it allows entering into the room, if not gives the buzzer as an indication of wrong person tried to enter into the room.

In present system there are no efficient methods for accurate identifications, there are certain places where accuracy is important mainly in banking, health care and government sectors. This application will provide RFID tag based system which uses micro controller. 

RFID is one the fast growing technology all over the world for identifying and tracing goods. This system can help hospitals to find expensive equipment in less time and provide better services for patients. This technology is also widely used in pharmaceuticals and logistics.     

APPLICATIONS:

  • Item visibility and status
  • Location tracking
  • Access control
  • Traceability
  •  Easy billing 
download  RFID Based Home/Office security system  Project Abstract.

Blind Stick Robot Projects Abstract

AIM:

Blind stick Robot projects main idea is to implement a application which can sense the vehicle path and trace details using a wireless system for a autonomous robot.

This project use Infrared technology to trace the shorter distance objects. Infrared works as a remote wireless system which is mainly used for shorter distance communication like television and audio systems. This paper contains working principle of the project with hardware requirement along with block diagram.

Blind-Stick-Robot-projects-Abstract


DESCRIPTION:
     

  Robot direction control is based on the obstacle sensing using IR sensor which gives the voltage depends on the distance of object. This voltage is fed to the analog to digital converter.  Micro controller reads the digital data and controls the robot direction to the left or right. 

COMPONENTS: 

  • At89s52
  • LCD
  • L293d
  • Robot
  • IR sensor
  • MCP 3208 

SKILL SET: 

  • Functionality of Microcontroller
  • Embedded C programming
  • Concept of IR sensor 
download  Blind Stick Robot  Project Abstract.

Autonomous Robot Project Abstract

Autonomous robot project main objective is to develop a application which can sense objects in the path when vehicle is in move. This application uses Infra red sensor technology to sense objects which are present in front of the moving object. Infra red is a regularly used in short distance remote systems like audio and video systems like tv and audio systems. This application works for only short distance. 

This application uses GP2Y0A21YK0F which is a distance measuring sensor which is integrated with IR,PSD and IRED. In general there are many factors like temperature, and environmental factors which will cause sensors a wrong information or errors in calculating distance but in this system triangular method is used which solve this problem and calculate accurate distance between objects. This sensors can also be used as proximity sensors and the distance measurement is from 10 to 80 cm. 


The micro controller always measures the voltage giving by the sensor and whenever the obstacle occurs it takes a control action to turn into a left/right direction. Hence the robot avoids the colliding from any object. 

APPLICATIONS: 

  • In military applications
  • Industrial automation
download  Autonomous Robot Project Abstract.

Manchester Code Decoding Controls the Robot Direction by TV Remote

Manchester code decoding controls the robots direction by TV remote projects explains about developing a robotics application which can run just by a TV remote. Basically small range remote control systems like video and audio controls run using infrared rays which is just a light which cannot visible to human eye. So developing a remote controlled robot using IR technology will be cheaper and easy but which can work at small range.

         This projects main idea is to sense robots motion and control its motion using wireless IR data communication. When we access the remote by pressing a key, the IR transmitter sends a signal to the Receiver which is assembled to the robot as bursts of non-visible light. The Receiver in the other end is a photodiode or photo receptor that detects and captures the light pulses, which are then processed to retrieve the information they contain.

Here we are using TSOP1738 receiver, it collects the signal that is transmitted from the IR transmitter and it gives the signal in the form of RC5. Then the microcontroller captures the RC5 format and controller performs the necessary action by sending the data to the robot through a DC motor driver L293D, like moving the robot LEFT, RIGHT, FRONT or BACK. Advantages are easy to use, simpler and quicker. Applications are for sending robot’s to harsh environments, industrial applications etc.

download  Manchester Code Decoding Controls the Robot Direction by TV Remote project.