John Varady Email & Phone Number

Philadelphia, Pa, Us

San Diego, California, Us

System implementer for the Weblinc Workarea Platform

Ruby on Rails developer

Fort Washington, Pa, Us

Responsible for the upgrade and development of TrakWare, a web-based Clinical Trial Management System, used to assist in the tracking of personnel, sites, subjects and required documents through the clinical trial process. TrakWare currently maintains 325 clinical studies and supports over 350 active users.As lead developer, migrated the code base from legacy HTML with in-line styles and server side validation to modern coding practices. The CTMS now features multi-skinned CSS integration, RESTful Web services communicating with the CF server via AJAX/JSON, and jQuery to enhance the user experience.Coding in ColdFusion MX 7 and 8.0, MSSQL, CSS, JavaScript, AJAX/JSON and jQuery.Received “RPS Rookie of the Year” award in 2010 for outstanding performance.

- Lead developer of "PowerPDA", consisting of four main applications for the food distribution industry including Sales Reps/Route Accounting, Retail Store EOS, Competitive Pricing, and Delivery Confirmation.- Streamlined the transfer of large volumes of data between an AS400 host system, a Windows-based synchronization server and PDA. Data volume of 100,000+ records on a PDA was not uncommon, with some peak volumes of over 200,000 records.- PDA applications was written in AppForge CrossFire Mobile VB 6.0 and deployed on PocketPC and Palm OS based PDAs from a single set of source code.- Data synchronization used Sybase's OneBridge Mobile Server and Extended Systems XCS Server. - Incorporated full ERP pricing logic on the PDA including sales taxes, tobacco taxes, item allowances and price overrides. - Originally hired by Integrated Distribution Solutions, LLC which was purchased by Retalix in 2005

See Retalix entry. IDS, LLC was purchased by Retalix in 2005.

- Primary functions included taking database applications through the design phase, programming user interface and reports using Oracle tools, and then serving as database administrator and providing application support.- Responsible for the design and development of an asset management system using Oracle Developer 2000 tools. Provided clients with data conversion, on-site installation and training, ongoing database consultation, and DBA support services.- Responsible for the design and development of a call reporting system used by the pharmaceutical sector. Provided clients with a federal government compliant inventory system, as well as marketing and penetration reporting.- Served as database consultant to the Manufacturers Appraisal Company, a division of PricewaterhouseCoopers. Provided database expertise during countless university and corporate inventory/appraisal projects.- Developed applications for Palm OS-based PDAs using Puma Technologies Satellite Forms.

Us

Managed the Propecia account for Merck Pharmaceuticals, including web site, e-mail campaign, and patient usage and efficacy tracking. Duties include programming web pages in ColdFusion, database programming in Oracle PL/SQL and web reporting.