RECENT WEBSITES
CUSTOM development
Data management and informatics
Develop code to process data for various purposes
- merge multiple spreadsheets (i.e. tabular data) into one data file based on matched IDs or matched patterns
- insert/update data in relational databases from various data sources such as text files or other databases
- build relational databases from the ground up from heterogeneous sources for data analysis or to serve data on the web
- Project examples: various genotypic & phenotypic datasets for ricediversity.org
- merge multiple spreadsheets (i.e. tabular data) into one data file based on matched IDs or matched patterns
- insert/update data in relational databases from various data sources such as text files or other databases
- build relational databases from the ground up from heterogeneous sources for data analysis or to serve data on the web
- Project examples: various genotypic & phenotypic datasets for ricediversity.org
Data modeling and database desigN
Build data storage solutions that fit
- carefully interview stakeholders about what the data needs and project goals are
- analyze current data management strategy
- determine management and access needs and develop data model that accurately describes all data types and their interrelationships
- build database(s) and corresponding user interface(s) to view, query, edit data
- develop add-on features that allow for more sophisticated interaction with data, e.g. graphical visualization, advanced searching, etc
- carefully interview stakeholders about what the data needs and project goals are
- analyze current data management strategy
- determine management and access needs and develop data model that accurately describes all data types and their interrelationships
- build database(s) and corresponding user interface(s) to view, query, edit data
- develop add-on features that allow for more sophisticated interaction with data, e.g. graphical visualization, advanced searching, etc
Contact Relation management systems
CRM development and data management. Installed and configured a Contact/Constituent Relationship Management system for several different organizations. With this system the clients no longer need to manually manage data across several spreadsheets to project members are able to much more easily understand and access data about their constituents, donation history, memberships, event participants, and automate donation transactions.
|
Custom development
Project example: Implemented a number of updates to the WordPress/PHP code and MySQL database back-end of the Cornell Meat Price & Yield Calculator WordPress web application, a project of Meat Suite.
Project example: Developed a custom data management web application for internal use at local business. Webform were developed to gather info from users for storage in a custom MySQL database. Additional data from a remote database (connected to via web services/API) is brought into application on the fly. A search page was developed for data querying and report generation. Barcode labels are generated and printed to a networked Zebra label printer for labeling inventory units.
|