NeuroPsychGDB is an annotated gene database for research studies concerning Schizophrenia, Autism and other complex epigenetic disorders. Worked on the initial development of the in house database as part of a team and later developed custom modules as part of Masters project.
As it currently stands, the database provides basic tools to obtain information about linked genes, microRNA, pathways among other functions. The database was developed in a phased manner to include functionalities that were required in accordance to current research practices at the Molecular Biotechnology Research Laboratory to accommodate functions such as linkage studies for highly inherited/linked genes.
As part of Masters project, developed modules for the Database that allows users to analyze the presence of CpG islands and Tandem repeats in genes linked to Schizophrenia/Autism. This was built over Tandem Repeat Finder from Laboratory for Biocomputing and Informatics and CpG plot from EMBL's EMBOSS. The modules allow for short pattern repeats and corresponding expression level analysis. These information are linked to gene level maps on NCBI's gene viewer.
The back end of the database is built over MySQL normalized data and uses Perl (Perl CGI, DBI, Bioperl modules) for handling web requests, data fetching from NCBI and processing. Statistical analysis of gene expression is done using R and a custom Perl module interface. In addition, Python scripts have been written to aid in data consistency checks and data population.
SmokeDB is an in house research database that focuses on the analysis of mutations in smoking population and linked small RNA mutations. This was developed as a coursework requirement in collaboration with researchers from the Boston University School of Medicine.
Designed the schema for the database in addition to User interface design and data processing modules. The data processing and data normalization modules at the back end were designed with Python and PHP was utilized in the interface design. The database is built over normalized data tables using a PostgreSQL server.
Developed as a freelance project during Summer '10, kuRaL is a custom PHP framework driven web application to fetch specific poetry lines based on the user specified index. Fetches data over nonstandard/custom API calls from an external repository. Current extensions include url shortening and analytics.
Working on adding feature sets using third party APIs such as OAuth for Twitter, Facebook and other social platforms along with converting the same application into a Wordpress sidebar/Blogger widget for use outside the current homepage.
Front end is done with PHP and the backend is purely PHP-curl with minor MySQL calls for url shortening management.
Designed a front end
built over Django for data analytics and presentation for demographics data from the Political Science Program, Boston University.
Skills: Django, JQuery, CSS.
Duration: December '10 - Present'
Worked on creating custom pattern matching Regex configuration files for BU Information Services & Technology (IS&T)'s PHP based content import/migration scripts to aid in static web content to Wordpress page migration.
Skillsets: PHP, Pattern matching, Shell scripting.
Duration: October 2010 – December 2010 (3 months).
Worked on the maintenance of the data from the FoM program consisting of program operational details and the outcomes of past programs/associated details and to devise methods to extract meaningful details out of the large data sets. Front end design with PHP for a MySQL driven database back end.
Skillsets: PHP, MySQL, Shell scripting.
Duration: April 2008 – June 2008.
Ported the Boston University School of Law's financial transaction data from Excel to a MS-Access/Visual Basic Runtime based end database. Worked on designing the schema for the data for data consistency along with the migration. Also provided support in migrating the same database into a MySQL database with a PHP driven web interface for intranet usage.
Skillsets: VBA, MS-Access, PHP.
Duration: July 2008-May 2009.