Work Projects
At PROVOST OFFICE, UT AUSTIN
Provost Approval System
Description: This is a secure and centralized web portal for the Provost to log in and approve myraid of requests that are submitted from all over the campus for his approval (e.g. request for approving 'XXX' as Department Chair for Chemical Engineering). Previously departments/colleges used to submit paper application to the provost's office and staff memebers used to process them. In many occations this led to human error and it was a tremendous burden on the office to keep track of so many requests or maintain a history of the approved requets. The web based application solved those issues. It has three main parts:
Submit request page : where user can submit their requests, upload documents etc.
Pending request page: lists outstanding requests awaiting approval from the Provost. He can review and approve a request and send email notification to the requester from here.
History page: list of recently approved requests.
I had to integrate with third party libraries and extensively use Jquery to implement the document viewer - where you can scroll through multiple uploaded documents (ref: screenshot of Pending Requests Page). Also the security/authorization permission to the page is very strict due to the nature of the request. Besides regular credential verification, role based authorization to each page was implemented as well. Also, role - specific view was required to allow multiple user using the same page for different use.
Technology: Django/Python, Oracle, Jquery, CSS
Contribution: Designed and developed the application end-to-end including back-end, buisness logic, and front-end
Submit Request Page
Pending Requests Page
History Page
Space Update System
Description: This is a revised version of an existing legacy system on campus, called Worqspace. The new system is going to be more user-friendly and efficient in making updates to the various attributes of a room on campus. The room usage statistics (e.g. occupant data) must be maintained and reported to the Texas co-ordinating board, which is then used for various nation-wide surveys and university related news. The system I'm building will be used heavily all over the campus and so the accuracy and efficiency of the system is very critical.
I analyzed the workflow of the existing system by researching the existing code base. Then I came up with the UI design and prototyping of the system. I also designed & developed the back-end, finally I integrated all the pieces together to make it functional. Since this page is a single-page design using JQuery dialog, I used JQuery and Ajax heavily for the front-end of the system.
Technology: Django/Python, Oracle, Jquery, Ajax, CSS
Contribution: Designed and developed the application end-to-end including back-end, buisness logic, and front-end
Room Details update page
At CIERP, UTEP
Dashboard
Description: A dashboard application for University President, Provosts, Deans, & Chairs. There are 100's of key metrics, system metrics and control metrics that represents the University overall growth or decline over the years. The idea was to create a tool that has a rich graphical interface and is informative. Besides the basic authentication, the tool is secured by hierarchical access. It means based on a person's role in the University, he/she can view only those departments or colleges to which they are the Deans or Chairs. This tool is been highly appreciated by the University President.
Technology: ASP.NET, C#, CSS, JQuery, AJAX, MSSQL
Contribution: Designed and developed the application end-to-end including back-end, buisness logic, and front-end
Provost-Report
Description: A reporting application secured by hierarchical access with visual graph and chart elements. Before the tool was created, each year, UTEP used to create 100s of reports for over 13 colleges and 80 departments manually using excel file and text-based data files. Naturally it was time-consuming and error-prone. I was assigned to develop a web-based dynamic application for automating this task. The tool is now supported by a background stored procedure which retrieves the data and presents it to the user with a nice visual interface. This tool is been highly appreciated by the University President.
Technology: ASP.NET, C#, CSS, JQuery, AJAX, MSSQL
Contribution: Designed and developed the end-to-end application, which reduced the reporting time by 80%
Screenshot of Provost-Report tool
Web-based Project Tracker
Description: online project tracking system to monitor numerous ongoing projects in our organization. It has three main modules:
Project Submit Portal : Anyone with right access permission can log in and submit their project. On each submission this portal will generate a unique token based on the Year, Month, Day, and the order of submission. Then the Project Owner can assign the project to a group of people. Each one in the group will then receive an email notification about the project. This module is been secured by all kinds of form validation techniques to protect against SQL injection attack or XSS attack.
Project View Portal : After logging into this portal, the tools shows a list of all the projects page by page. The tool provides various search options to navigate to a group of projects or an individual project. E.g., you can search "What are the projects that are assigned to person "X" and due by this week".
Project Update Portal : Each project in the view portal contains a link to update portal. On update of any of the parameters of the original project, each one working on the project will receive an email about the updates. Also there is an option to provide evaluational comment by the Project Owner to the individual member working on the project. Those comments are encrypted and only seen by the Project Owner.
Technology: ASP.NET, C#, CSS, JQuery, AJAX, MSSQL
Contribution: I have taken the initiative to come up with the idea of building such an onlile tracking system and designed and developed the end-to-end application.
View Portal
Submit Portal
Web-based Scheduler
Description: online scheduler to monitor the availablity of an individual or the availability of a team as a whole at a particular time period during a day. It has two main modules:
View Status : This interface is designed to easily see if someone is unavailable at a particular time. It allows individuals to change the status of their availability (e.g. available/ unavailable/ meeting etc). Also it has link, on click of which, the historical leave records of a person is displayed (See fig. Leave History Page). Another important part here is the graph (at the bottom of the page) which shows the trends of "% of availability" during a time period or on a specific day.
Leave History : User can enter a new leave revord or edit or delete any existing record from this page.
Technology: ASP.NET, C#, CSS, JQuery, AJAX, MSSQL
Contribution: I have taken the initiative to come up with the idea of building this online scheduler. I designed and developed the application end-to-end.
Scheduler Home
Leave History Page
Faculty Effort Allocation Tool
Description: This is a tool for high risk data analysis such as Faculty Teaching Load Allocation, based on which salary package is determined for individual faculty in the University. This tool is used by the Provost who is reponsible for cross checking such information. This tool allows him to enter comments or flag records if necessary. This tool improved the efficiency of high-risk faculty data analysis by 50%.
Technology: ASP.NET, C#, CSS, JavScript, AJAX, MSSQL
Contribution: Designed and developed the application end-to-end
Screenshot of Faculty Effort Allocation Tool
Enrollment Flow Model
Description: A visual flow chart of the enrollment patterns of the University over past 10 years and projection of future enrollment. This tool helps the administrative department to better analyze the student population and to take immediate action. E.g. first-time undergraduate students tend to leave in the next semester for many unforseen reasons. University admistration pays special attention to those folks to pursue them to come back and complete their education. Such at-risk students are easily identified using this tool. This tool is now the most powerful tool in our University.
Technology: ASP.NET, C#, CSS, MSSQL.
Contribution: Designed and developed the end-end application
Screenshot of Enrollment Flow Model tool
Web-based High School Profiles Reporting System
Description: The High School Profile provides information on local high school graduates who attend UTEP, their first-year performance at UTEP, and who have persisted or graduated from UTEP with a bachelor's degree. The Profile focuses on the group of local students who complete high school each academic year and who enroll at UTEP in the following fall semester. They are identified by the academic year of their graduation from high school. The Profile uses a rolling 10-year model.
Technology: ASP.NET, C#, CSS, MSSQL.
Contribution: I maintain the back-end and front-end of this tool. I created the pdf report generation module for this report.
At Interactive Systems Group, UTEP
Language Modeling: Modeling Beyond Syntax
Description: A language model which improved the speech recognition accuracy by up to 8% considering not only the word's lexical context but also the time at which the word appears, a varying prosody (e.g. volume, speaking rate, pitch, etc.) and underlying cognitive states.
Technology: C, Unix, Shell scripting.
Contribution: I helped in generating various test cases of this model. Worked with mutiple corpus and did experiments to provide sufficient information to prove the accuracy increae of 8%.
At Oracle Finanicial Services Software Ltd.
Fund Tansfer Integration Project
Description: E-banking solution for Citi bank. It is the banking interface that millions of users use for fund transfer or other banking related transactions.
Technology: HTML, CSS, JavaScript, VB.NET, PL/SQL
Contribution: I created the back-end report generation module, created custom web templates for the tool, and participated in QA analysis and testing
Work Order & Invoice Tracking System
Description: Web-based application for internal project planning and scheduling. It was an invoice tracking system for the organization.
Technology: JAVA, JSP, Struts, JavaScript, MySQL
Contribution: Built the web portal and some of the business logics of this system
Download Code Samples Here