Alan Koskelin
al@koskelin.com | (608) 577-7913
7211 Elmwood Ave. Middleton, WI 53562
Qualifications & Skill Set
- System architecture, analysis, and design; requirements gathering and analysis
- Software & web development, application architecture: PHP, Oracle PL/SQL & APEX, XML, Javascript, HTML
- Databases
- Logical and physical database modeling and implementation
- Database architecture
- Oracle, MySQL, SQL Server, Microsoft Access
- Project management, particularly iterative and agile methods
- Applications: TOAD, SQL Developer, JDeveloper, XMLSpy, Oracle Designer, Dia, Visio
- System documentation, technical and creative writing
- Ability to work independently and on diverse teams coordinating with scientists, business analysts, project managers, supervisors, database administrators, software developers, graphic designers, marketing and support staff
- Integrity, leadership, and strong problem solving and communication skills
Work Experience
Bioinformatics Scientist & Data Manager
Third Wave Technologies, an Hologic company -
Madison, WI - 2008 to 2009
- 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
- Oracle 10g, XE: three databases, at least three schemas in each with dozens of tables consisting mostly of
bioinformatics data
- Tools:
- SQL Developer, JDeveloper, TOAD
- ERD / logical & physical modeling tools: JDeveloper, SQL Developer Data Modeling
Project Manager
Netconcepts - Madison, WI - 2008
- 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
Software Project Coordinator / Lead Developer
enetrix, now a Gallup company - Madison, WI - 2003 to 2008
- 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)
Programmer / Analyst
Eastbay / Footlocker.com
- Wausau, WI - 2002 to 2003
- 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
Software Developer / Analyst
Independent Contractor - 2000 to 2002
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
other
Other database, web development, and system administration work since January, 1997
- Technical environments & tools: HTML, Javascript, IIS, SQL Server, Cold Fusion, Classic ASP, Photoshop, Apache, Perl, shell scripting / Bash, BIND, Sendmail
Education
University of Wisconsin Stevens Point, August 2001
Bachelor of Science degree in Computer Information Systems, minor in Writing. Relevant topics studied: applied software development, system analysis & design, Oracle and SQL, systems documentation, networking and network management, computer architecture, C++, Visual Basic, and English composition.
Professional Development
- Two-day Tom Kyte seminar covering performance, scalability, and schema design
- Two-day Steven Feuerstein seminar, "Best of Oracle PL/SQL"
- 2007 Wisconsin Entrepreneurs' Conference, including a presentation by Jason Fried of 37signals

