Alan Koskelin

abplak@r.postjobfree.com 608-***-****

**** ******* ***. *********, ** 53562

Qualifications & Skill SetSoftware & web development: Python, C#/ASP/.NET, Oracle PL/SQL & APEX, Ruby on Rails, Perl, PHP, XML,

Javascript / JQuery / AJAX, HTML / XHTML, JavaDatabases

Logical and physical database modeling and implementationOracle, SQL Server, MySQL, PostgreSQL /, Microsoft AccessRegular expressions, object-oriented programming (OOP), software engineering

Source code / revision control: Subversion,, CVSBug/issue tracking, project management software: FogBugz,,,, Microsoft Dynamics CRMApplication / system architecture, analysis, and design; requirements gathering and analysisSystem documentation, technical and creative writingProject management, including and other

agile / iterative / incremental methodsAbility to work independently and on diverse teams coordinating with scientists, software developers,

project managers, database administrators, graphic designers, marketing and support staff, business analystsIntegrity, leadership, and strong problem solving and communication skillsWork ExperienceBusiness Systems Developer

- Middleton, WI - 2011 to present

Develop software and business systems using C#.NET, ASP.NET, MS SQL Server, Microsoft Dynamics GPBioinformatics Programmer/Analyst

/ - Madison, WI - 2012

Introduced unit testing in a bioinformatics system written with Ruby on RailsDatabase Software Developer

- Madison, WI - 2010 to 2011

Developed software in object-oriented Python, PL/SQL; transformd data with Perl; wrote complex SQLWorked with multiple healthcare / medical informatics databases simultaneously

Constructed new databases

from disparate data sources including electronic health records (EHR)Augmented existing databases with additional data sourcesExpanded and improved a physician relationship management product and the implementation processDeveloped Python training program including examples of object-oriented programming and implementing and (TDD)Ported code from Oracle to GreenplumConducted root cause analysis on existing systems and databasesPerformed data quality assurance (QA)Contributed documentation to the company wiki Company focus

Healthcare CRM, Physician Relationship Management, and Planning & ForecastingTechnical environment:

Python,

Oracle,

Greenplum (PostgreSQL),,

Linux

Tools:,,

PL/SQL Developer,

FogBugz,

internal ETL tool,

Microsoft Dynamics CRM

Software Developer & Consultant

2009 to 2010

Developed software for real-time PCR /

qPCR data analysis.

Technical environment: Python, XML & XPath,

Developed web software that allows radio station listeners to influence the songs that play on-air.

Technical environment: JQuery / AJAX / Javascript,

APIs, XHTML, PHPDeveloped software, as a part of a Scrum team,

that automates

(SEO) as it pertains to .

Improved and scaled the implementation of a new algorithm, so that it could be more widely used, by

refactoring code and writing complex SQL queries that leveraged a data warehouse software and

databases in order to support multi-byte characters / Participated in multiple sprints and a formal testing process

Technical environment: PHP, proprietary framework, MySQL databases and

data warehouse Tools: Eclipse,,,

Developed software to generate online monitoring data

Technical environment:, Javascript, PHP,

MySQLBioinformatics Scientist & Data Manager, an company -

Madison, WI - 2008 to 2009

Collaborated in all steps of the Software Development Lifecycle (SDLC)

Wrote and revised software development plans and specificationsDeveloped and maintained Oracle Web applications to track product performance and/or enable researchers to mine medical

informaticsWrote, revised, executed, and reported on validation procedures to ensure software performanceProvided expertise via code reviewsWorked in an,

(GMP),

and environment

as a member of the R&D department of an

registered company

Worked in the life science industry in a biotechnology manufacturing environment and molecular diagnostics setting

using

:

detection of DNA base pair changes using,

Förster / fluorescence resonance energy

transfer (FRET) probes, DNA-cleaving enzymes, and 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 customersApplication to track and visualize water quality dataTechnical environment:

Oracle: three databases, at least three schemas in each with dozens of tables consisting mostly of bioinformatics

data; Oracle Application Express, PL/SQL, most in packages to support APEX applications and data flow

Tools:

SQL Developer, JDeveloper, TOADERD / logical & physical modeling tools: JDeveloper, Project Manager

- Madison, WI - 2008

Improved project delivery process, namely by introducing agile and iterative development and deliveryManaged the needs and expectations of clients and coworkersManaged the concurrent delivery of four web development projects including ecommerce sites for companies selling:

cancer awareness products that donates 10% of sales to cancer researchcommercial, industrial, and military carrying casesemergency medical supplies and equipment and school nurse suppliesEnsured projects conformed to search engine optimization (SEO) best practicesTechnical environment: LAMP (Linux, Apache, MySQL, PHP) with in-house MVC (model-view-controller) framework and PEAR librariesSoftware Project Coordinator / Lead Developer, now a 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 systemsImplemented 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 reportingWeb content management and ecommerceLead and trained technical staff

Implemented and championed an internal wiki for effective documentation and communication, thus reducing implementation and support overheadOrganized and lead inter-department meetings to redesign user interfaces of core software systemsTrained and mentored developers, database administrators, and other technical staff on the design and architecture of software products and the development environmentCoordinated software development

Built consensus and acted as a catalyst among executive management, clients, software architects, developers, graphic designers, survey & report designers, support staffAdvised 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 integrityDetermined time and resource estimationsPrioritized and delegated tasksReviewed past performance relative to estimations and expectationsNotable projects:

Online salary survey site for an organization related to credit union compensationBusiness-to-business (B2B) site for a company selling food safety, counter service, and washroom productsContributed to human resources survey site for a Fortune 500 companyIdentified and demonstrated SQL-injection vulnerability; worked as a part of a team to develop a workaroundTechnical environment:

Oracle 8-10g: eight databases, three application servers, dozens of schemas with hundreds of tables in each, numerous database linksOracle PL/SQL: most in packages, about 1.5 million lines of code, much shared across schemasHTML, Javascript, XML, XEP (render XML to PDF), Java (ecom transactions, Excel & XML conversion, data integration via JDBC)Tools:

TOAD & SQL DeveloperERD / logical & physical modeling tools: Dia, Visio, and Oracle DesignerXMLSpy (test & troubleshoot transformation of XML & XSLT to XSL-FO, generate XML schema definitions)Software Developer / Analyst

Other software, database, web development, and system administration work since January, 1997

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 specialtiesState-wide high school football statistics and playoff web softwareCustom, from-scratch e-commerce system including industry-specific featuresCustom database-driven desktop applicationTechnical environments & tools: HTML, Javascript, IIS, SQL Server, Cold Fusion, Classic ASP, Photoshop, Apache, Perl, shell scripting / Bash, BIND, SendmailEducation, August 2001

Bachelor of Science degree in, minor in Writing.

Relevant topics studied: C++, Oracle and SQL, system analysis & design, systems documentation, Visual Basic., Fall 2010

course. Relevant topics studied:

design and implementation of bioinformatics software,

molecular biology,,

DNA/RNA/protein & sequence comparison,,,,

Perl and regular expressions,,

(ORF) and gene-finding,

Copyright 2002-2012 Alan Koskelin

Copyright 2002-2012 Alan Koskelin

Contact this candidate