• Collaborate in all steps of the Software Development Lifecycle (SDLC)
  • Gather user needs
  • Write and revise software development plans and specifications
  • Develop and maintain Oracle Web applications to track product performance and/or enable researchers to mine medical informatics
  • Write, revise, execute, and report on validation procedures to ensure software performance
• Provide expertise via code reviews
• Work in a regulated environment as a member of the R&D department
  • FDA-regulated
  • ISO 13485 registered company
  • Quality System (QS)
  • Good Manufacturing Practices (GMP)
• Work in a science / biotechnology environment using Invader chemistry
  • detection of DNA base pair changes
  • oligonucleotides
  • DNA-cleaving enzymes
  • fluorescence resonance energy transfer (FRET) probes
  • fluorescent signal detection
• Notable projects:
  • Collaboration and validation on multiple revisions to the main bioinformatics database application
  • Revision to and maintenance an inventory application used to service agriculture customers
  • Application to track and visualize water quality data
• Technical environment:
  • Oracle 10g, XE: three databases, at least three schemas in each with dozens of tables consisting mostly of bioinformatics data
    • Oracle Application Express (APEX)
    • PL/SQL, most in packages to support APEX applications and data flow
    • Heterogeneous Connectivity to SQL Server
  • Red Hat Enterprise Linux
  • Java for data integration
  • Perl for bioinformatics
  • SAS JMP for statistical analysis
• Tools:
  • SQL Developer, JDeveloper, TOAD
  • ERD / logical & physical modeling tools: JDeveloper, SQL Developer Data Modeling

• Improved project delivery process, namely by introducing agile and iterative development and delivery
• Managed the needs and expectations of clients and coworkers
• Managed the concurrent delivery of four web development projects including ecommerce sites for companies selling:
  • cancer awareness products that donates 10% of sales to cancer research
  • commercial, industrial, and military carrying cases
  • emergency medical supplies and equipment and school nurse supplies
• Ensured projects conformed to search engine optimization (SEO) best practices
• Technical environment: LAMP (Linux, Apache, MySQL, PHP) with in-house MVC (model-view-controller) framework and PEAR libraries

• Developed Web applications using Oracle technologies
  • Refined and expanded database architecture and design (tables, relationships, stored procedures, triggers, other database objects)
  • Performance-tuned SQL, PL/SQL, and software systems
  • Implemented data warehouses for reporting and business intelligence (BI)
  • Extracted, transformed, and loaded data (ETL)
• Maintained the vision, architecture, and integrity of core reusable products:
  • Enterprise Feedback Management, customer relationship management (CRM), surveying, and reporting
  • Web content management and ecommerce
  • Online voting
• Lead and trained technical staff
  • Implemented and championed an internal wiki for effective documentation and communication, thus reducing implementation and support overhead
  • Organized and lead inter-department meetings to redesign user interfaces of core software systems
  • Trained and mentored developers, database administrators, and other technical staff on the design and architecture of software products and the development environment
• Coordinated software development
  • Built consensus and acted as a catalyst among executive management, clients, software architects, developers, graphic designers, survey & report designers, support staff
• Advised executive management on software development strategies
  • Gathered requirements and determined scope and direction of projects in ways that grew core products while maintaining an overall integrity
  • Determined time and resource estimations
  • Prioritized and delegated tasks
  • Reviewed past performance relative to estimations and expectations
• Notable projects:
  • Online salary survey site for an organization related to credit union compensation
  • Business-to-business (B2B) site for a company selling food safety, counter service, and washroom products
  • Contributed to human resources survey site for a Fortune 500 company
  • Identified and demonstrated SQL-injection vulnerability; worked as a part of a team to develop a workaround
• Technical environment:
  • Oracle 8-10g: eight databases, three application servers, dozens of schemas with hundreds of tables in each, numerous database links
  • Oracle PL/SQL: most in packages, about 1.5 million lines of code, much shared across schemas
  • HTML, Javascript, XML, XEP (render XML to PDF), Java (ecom transactions, Excel & XML conversion, data integration via JDBC)
  • SPSS for statistical analysis
• Tools:
  • TOAD & SQL Developer
  • ERD / logical & physical modeling tools: Dia, Visio, and Oracle Designer
  • XMLSpy (test & troubleshoot transformation of XML & XSLT to XSL-FO, generate XML schema definitions)

• Designed logical and physical database models and implemented a database to support an XML integration with Amazon
• Developed and maintained data warehouses and reports
• Supported daily business activities related to accepting Internet and mail orders
• Technical environment: Microsoft SQL Server & Access, Controller+ via ODBC

Gathered requirements to design logical and physical database models; implemented database-driven Web (LAMP, HTML, Javascript, Photoshop) and desktop (Visual Basic, MS Access) applications:

• Document management system for a hospital with over 270 physicians in 35 specialties
• State-wide high school football statistics and playoff web software
• Custom, from-scratch e-commerce system including industry-specific features
• Custom database-driven desktop application

• Technical environments & tools: HTML, Javascript, IIS, SQL Server, Cold Fusion, Classic ASP, Photoshop, Apache, Perl, shell scripting / Bash, BIND, Sendmail