Programmer/Analyst
Philadelphia, Pa
Developed a web-based application using Perl and MySQL, which presented, collected, stored and scored on-line psychological tests. Additional utilities developed using Perl and SAS were used to distribute data for data analysis.As a member of a small IT team, my duties had also involved system administration (Linux and MAC), database administration (MySQL) and tech support. This team supported the research efforts of a research group at the University of Pennsylvania and provided resources to the research community.Example projects were:Refactored and redesigned the file upload processes to enable more code reuse and to simplify the process that non-technical personal used to upload data to a central database. This was crucial to enable successful completion of several grants which involved the upload of approximately 10,000 sessions while losing only 5 due to system crashes and people not following the streamlined process.Initial design, development and maintenance of a reporting system. The goals here were to simplify the report generation process. Before this there was a minimal reporting system that had severe limitations in terms of quantity of data that could be exported at a time, as well as being extraordinarily difficult to setup. After development, there were 2 basic ways to export data. One was through a GUI to define reports and to get data. The second was to specify the reports through the GUI and a command line process could be run to export the data.Designed and created a working prototype test using Xcode to demonstrate: 1) Cross platform development 2) Running an example psychological test on mobile devices as well as laptops 3) Adaptive testing of subjects 4) Test Driven Development Tools used: MySQL, SQL, Perl, CGI, HTML/DHTML, Mac OSX, Linux, Apache, SAS, R, Objective C, C/C++, iOS.