Mehak Sikka (Palau, Financial Institutions Commission, FIC) Mehak converted a complex excel spreadsheet application into a MySQL database application for the Financial Institutions Commission, the banking regulator in Palau, an island country location in the western Pacific Ocean. The Financial Institutions Commission, the banking regulator of Palau, regularly receives summarized banking records from the five banks on the island and consolidates it on excel. Six years of banking information on excel made it difficult to segregate the data and conduct additional analysis. The CMU student converted the various excel sheets into a MySQL database, creating a backup scheme and a more user friend

Vipasha Awasthi (Palau, National Development Bank of Palau, NDBP) Vipasha automated monthly reports and proposed a business continuity plan for the National Development Bank of Palau, an island country located in the western Pacific Ocean. The National Development Bank of Palau provides commercial and residential loans to Palauan citizens. They had recently suffered from a ransomware attack which disrupted their operations and put their data at risk. The CMU student developed a business continuity plan covering their ongoing operations and emergency processes for the bank. She created a technical backup and recovery plan to be deployed when the appropriate funding is made available. While

Pavan Gollapalli and Jeevika Ghosh (Palau, Ministry of Education, MOE) Pavan and Jeevika deployed a new classroom supplies procurement application for the Ministry of Education in the Republic of Palau, an island country located in the western Pacific Ocean. The Ministry of Education (MOE), responsible for the public school system and the national educational curricula, was having trouble keeping track of paper orders, deliveries and receipts for teacher’s classroom supplies. The CMU students developed four modules to track requisitions, receiving, distribution and inventory management for MOE classroom supplies. The students tested and implemented the solution on the MOE intranet and train

Max Kornyev ( Palau, Foreign Investment Board, FIB) Max installed a new document management solution (DMS) for the Foreign Investment Board (FIB), an organization that ensures that foreign investment truly works for the Republic of Palau, an island country located in the western Pacific Ocean. The Foreign Investment Board (FIB) vets incoming foreign investment in Palau and audits already established foreign-owned enterprises for regulatory compliance. These processes result in a vast amount of paper documentation, creating inefficiencies in storage and retrieval. The CMU student researched, evaluated, selected and implemented a commercial document management system (DMS) and developed and d

Allison Scibisz ( Palau, Belau Medical Clinic) Allison researched the solution, configured and set up the computer network for the Belau Medical Clinic, a privately owned medical clinic in the Republic of Palau, an island country located in the western Pacific Ocean. The Belau Medical Clinic’s thirty-eight employees used computers and took advantage of a broadband internet connection, but the computers were not consistently backed up nor were they connected to a local office network. Patient records are on paper, and the clinic is interested in moving to electronic record storage. The CMU student selected, installed and configured a Windows Server Essentials 2016 operating system and connec

Ryan Eckert and Aditya Chanana (Marshall Islands, Majuro Stevedore & Terminal Co) Ryan and Aditya upgraded the yard control, receiving and billing/collections application for the Majuro Stevedore & Terminal Co, a cargo transportation and logistics company in the Majuro Atoll of the Republic of the Marshall Islands (RMI), in the central Pacific Ocean. The Majuro Stevedore & Terminal Co’s (MSTC) yard control, receiving and billing /collections database application had fallen into disuse. The CMU students redesigned and simplified the data entry forms, redesigned and improved validation for the database model, rigorously tested the revised application and trained /cross-trained MSTC personnel

Sudipto Das (Palau, Financial Intelligence Unit, FIU) Sudipto worked on the systems that analyze suspicious or illegal financial activity for the Financial Intelligence Unit (FIU), a government organization that detects, disrupts and deters money laundering and terrorist financing activity in Palau’s banking system. The Financial Intelligence Unit’s (FIU’s) process for collecting bank transactions and conducting risk analysis required the Senior Intelligence Analyst to manually review transactions in order to assign a risk level to each transaction set. The CMU student enhanced the existing system with a rule-based ‘expert’ model, based on the Senior Analyst’s manual logic, to automatically

Cesar Ruiz and Carolina Quintana (Chimbote, La Maternidad de Maria Hospital) La Maternidad de Maria grew over fifty years from a simple maternity hospital in 1966 to a full-service hospital with nine departments and 24/7 services. Cesar and Carolina documented the IT systems and then tackled several high-priority technology issues (including a physical therapy patient database and a redesigned pharmacy payment process) for La Maternidad de Maria, a hospital which has for over fifty years served the Chimbote Peru destitute poor in need of medical assistance. La Maternidad de Maria grew over fifty years from a simple maternity hospital in 1966 to a full-service hospital with nine departments a