#References

SUCCESSFUL COOPERATIONS

IV. Guria, Varanasi

The Organisation

Guria Swayam Sevi Sansthan is an organization fighting sex trafficking in India since 1993. Located in Varanasi, Guria works towards fighting the sexual exploitation of women & children, especially forced prostitution & sex trafficking. In recent years the issues has become more severe and complex due to sex tourism and the wide spread of HIV/AIDS. Guria strongly believes that not charity but justice needed in the world to live in a more civilised world where human beings can co-exist in harmony.

Guria-India-NG3O-Logo-Cooperation
Guria-NG3O-Digital-Case-Screenshot-App

1. Database Development for Case Document Management

The founder and director of Guria India challanged us: The organisatiion was in desperate need of a system to manage thousands of documents for hundreds of cases Guria is fighting in several courts all over India. Additionally the access and editing rights need to be individually given for each account and lawyers have to be able to upload new documents using a smartphone app.

Using an american cloud-service provider, we managed to create a system that meets almost all of the requirements: We developed a database on the basis of an Excel sheet that was maintained by the Guria office. Domenic tidied up all the hundreds of rows and columns to import the existent information to the system without creating countless corrupted data points. Tom worked closely with Guria‘s lawyers to improve the database structure to meet the daily requirements of the lawyers. We carefully designed several forms to enter new information to the database trying to decrease the likelihood of information being inserted falsely. We redesigned the app interface to maximize usability and enable lawyers to easily update information and upload recent documents on the go.

As an additional feature we created a calendar that sends reminders via e-Mail and push-notifications to lawyers about upcoming trial hearings based on the dates that were entered into the database.

Lastly we held extensive workshops teaching the staff members thoroughly in using the system implemented by us. We simulated different scenarios to walk the staff through a variety of cases and provided detailed manuals including screenshots for most of the functionalities of the system. We are continuously cooperating with Guria in case questions or complications arise.

1. Database Development for Case Document Management

The founder and director of Guria India challanged us: The organisatiion was in desperate need of a system to manage thousands of documents for hundreds of cases Guria is fighting in several courts all over India. Additionally the access and editing rights need to be individually given for each account and lawyers have to be able to upload new documents using a smartphone app.

Using an american cloud-service provider, we managed to create a system that meets almost all of the requirements: We developed a database on the basis of an Excel sheet that was maintained by the Guria office. Domenic tidied up all the hundreds of rows and columns to import the existent information to the system without creating countless corrupted data points. Tom worked closely with Guria‘s lawyers to improve the database structure to meet the daily requirements of the lawyers. We carefully designed several forms to enter new information to the database trying to decrease the likelihood of information being inserted falsely. We redesigned the app interface to maximize usability and enable lawyers to easily update information and upload recent documents on the go.

As an additional feature we created a calendar that sends reminders via e-Mail and push-notifications to lawyers about upcoming trial hearings based on the dates that were entered into the database.

Lastly we held extensive workshops teaching the staff members thoroughly in using the system implemented by us. We simulated different scenarios to walk the staff through a variety of cases and provided detailed manuals including screenshots for most of the functionalities of the system. We are continuously cooperating with Guria in case questions or complications arise.

Guria-NG3O-Digital-Case-Screenshot-App
Guria-India-NG3O-Coop-Pic-Library-Pic-1
Guria-India-NG3O-Coop-Pic-Library-Pic-2
Guria-India-NG3O-Coop-Pic-Library-Pic-4

2. Website Improvements

Due to the high workload of establishing the document management system, we focussed on updateing figures and improving the usability. We prepared an extensive document with detailed suggestions for changes that will improve the likelihood of visitors engaging with Gurias website. Furthermore we selected 60 of our pictures, edited them and wrote insightful captions to update the gallery. After a revision with the Guria office we forwared the document and pictures to sunSTRATEGIC, the company that maintains Gurias website. Johannes took over the communication between Guria und sunSTRATEGIC to make sure the changes are incorporated as intended.

Guria-India-NG3O-Website-Improvements

Sanjeeva de Mel, Founder and Director of SERVEDomenic, Tom and Yoyo…

… did a remarkable job supporting Guria and our fight against sex trafficking! The NG3O team developed a digital document management system that enables our lawyers to quickly search for a specific information that might be essential to win a case against a criminal. Initially I asked Domenic, Tom and Yoyo to write a requirement profile I can hand over to a software company so they can develop the needed solution. The three Germans exceeded my expectations with developing and implementing the system as well as teaching Guria staff how to use it. I hope they will come again to Varansi to work with us!

Ajeet Singh, Founder and Director of Guria India

4. Video Editing

We edited a video for the landing page of Gurias Website for two reasons: Firstly, we wanted to offer people who encouter the Guria Website for the first time the opportunity to get a quick overview of the wide range of programms Guria is running. Secondly we wanted to increase the time spent on the Website to increase SEO Ratings, which helps Guria get the most out of Googles’ AdGrants as well.
The Video is composed of archive material and footage we took during a visit in the Gurias Center in the red-light district.

4. Video Editing

We edited a video for the landing page of Gurias Website for two reasons: Firstly, we wanted to offer people who encouter the Guria Website for the first time the opportunity to get a quick overview of the wide range of programms Guria is running. Secondly we wanted to increase the time spent on the Website to increase SEO Ratings, which helps Guria get the most out of Googles’ AdGrants as well.
The Video is composed of archive material and footage we took during a visit in the Gurias Center in the red-light district.

Guria-India-NG3O-Coop-Pic-Library-Pic-5
Guria-India-NG3O-Coop-Pic-Library-Pic-6
Guria-India-NG3O-Coop-Pic-Library-Pic-7
Guria-India-NG3O-Coop-Pic-Library-Pic-8
NG3O Logo with claim NG30