I am an adventure loving person and I dream about flying aircrafts or
being at the summit of Mt.Everest.
Technically, I focus on being a full-data-stack engineer covering the 3 major aspects of a data engineering - extraction, curation and analysis. I have a strong background in relationl database and would like to research more in statistical analysis.
The project was an effort to integrate information about metal music, bands, artsits, instruments played by artists, albums and songs and form a graph from a social network perspective and try to find out relationships between nodes. It is an interactive mashup to perform a comprehensive analysis of this network which helps us to explore influences of genres and their evolution.
The project introduces us to the concept of content extraction and the complexities in search engines. We built an ETL workflow starting from;
This mashup was build at the LA Hacks. Given a wikipedia page, we extracted semantic entites & keywords to understand the context of the given article. Using the top 6 extracted keywords, we perform a search on youtube to get related videos. The idea was to help users who are trying to learn on the internet, to have text content alongside related videos.
We used AlchemyAPI to extract the entities frmo the given wiki page.
This project was an introduction to Oracle Spatial objects and how to query maps. We used the USC map and saved each building as polygons in oracle. Using a java based application, the user can now draw random polygon and query the intersecting buildings.
The map had buildings and fire hydrants across USC. One could simulate a buulding to be on fire and query the nearest fire hydrant.
Tabulated data is used everywhere and there a great need to work on worksheets when users are on the move, using touch devices. In this project I studied and analyzed existing user interface designs for working with tabulated data. MS Excel for iPad was selected as an example in the study. I then proposed design improvements for some of the basic operations the user performs on the worksheets.
An android app to navigate visually impaired people to meet at a point, where they start in the different location in same room. This was developed and presented at the SS12 code challenge 2012 @ USC. The problem statement restricted the use of GPS services, which made us evaluate other methods to connect the devices. We evaluated the bluetooth and wifi adhoc connection modes. In the given time frame, our team decided to use the wifi signal strength in the adhoc connection between the two devices as bluetooth was a weaker source
The project proposed a solution to run applications demanding higher
processing capabilities on thin clients by making use of cloud
instances and the internet. Using VNC – Virtual Network Computing,
only the application interface was rendered over the client
interface, giving the end user an experience of using a locally
installed system. The prototype could render linux or windows based
application, running on EC2 instances, on clients having windows or
Users could seamlessly switch amongst multiple application having a rich user experience, as if the application was running locally.
The application automate the Training and Placement process in an institution. Various task like company scheduling, student listing, HR contact management and report generation were provided. The tool displayed trend analysis against a wide range of data filters.
The software provided a strong user interface for database users to perform various database operations without the need to know syntaxes of SQL. DML and DDL queries could be modeled by simply filling information into a form like interface. The software explored the methodds of Java database medadata API.
A social networking platform that binds students, colleges and industry with the context of projects. Read more...
Role: Played a key role from the inception to the deployment
phase of the product.
Designed a generic context based framework for set of entities to communicate using a context.
Designed Access-Control and User Privacy modules in Yii framework.
Designed a graph based recommendation engine using Neo4j. The graph data model was also used to design search and user specific search result ordering.
The software aimed towards migrating data and structures across different relational database systems. The prototype was developed using DB2 and MS SQL Server. It successfully migrated database objects, constraints and data.
Role: I programmed the connection management module which was designed to establish jdbc connectivity with different database engines and maintain secure credentials. Connection tests were performed using Database metadata classes which further retrieved the schema of the selected database. I was also responsible for user interface designing using Java Swing components.
This application was an alert engine which evaluated a set of user defined rules over periodically fed data of closing prices of various mutual fund units. The effort was to maximize profits by having more number of transactions which are less in value rather than having less transaction and larger holding time of the units.
A web application designed to be used on iPads to manage Electronic Health Records (EHR) and Prescriptions. The application proposed a unique user experience for patients and staffs when interacting with this systems. The first deployment addressed the Rheumatoid arthritis specialty.
Role: Programmed application remote-upgrade module, data
backup routines, replication and encryption modules for MySQL and
Also worked with various data exchange formats like HL7, EDI, NCPDP and XML using Mirth Interface and Quest Diagnostic Test Services. Preliminary study for Meaningful use certification.
I have been awarded a full tuition waiver as part of the
Graduate Assistantship. My work as the database curator continued,
additionally I am developing and maintaining specific web application
under the graduate school banner.
I perform data integration from different sources - csv, flat files, and db dumps, cleaning, filtering and processing the data, and generating statistical reports for the provost office.
My task involves curating the graduate school database. This vast data set entails information about graduate student enrollment, admissions, applications, fellowships and petitions. Data - aggregation, cleaning, and analysis for the graduate school reporting were key aspects of my work assingments.
Worked on health care and social network applications.
This testing tool was built to simulate user interactions with the
web application - PatientScribe.
It was capable to navigate through all the pages, fill randomized values into the required fields and submit the data to the server.
Further, when returning back to the previously traversed pages, the tool was capable to cache the previously entered data and validate against the values returned by the server and print out appropriate log statements.
The tool was designed to simulate multiple users by spawning one thread for each user. It was used to test 1500+ users using the application simultaneously and stress test the server.