Alan Koskelin
al@koskelin.com | (608) 577-7913
7211 Elmwood Ave. Middleton, WI 53562
Qualifications & Skill Set
- Software & web development: Oracle PL/SQL, XML, HTML, Javascript, PHP
- Databases
- Logical and physical database modeling and implementation
- Oracle, MySQL, SQL Server, Microsoft Access
- System analysis and design, requirements gathering and analysis
- Project management, particularly iterative and agile methods
- Applications: TOAD, SQL Developer, XMLSpy, Oracle Designer, Dia, Visio
- System documentation, technical and creative writing
- Integrity, leadership, and strong problem solving and communication skills
- Ability to work independently and on diverse teams coordinating with business analysts, project managers, supervisors, database administrators, software developers, graphic designers, marketing and support staff
Work Experience
Project Manager
Netconcepts - Madison, WI - July 2008 to October 2008
- Improve project delivery process, namely by introducing agile and iterative development and delivery
- Manage the needs and expectations of clients and coworkers
- Manage the concurrent delivery of four web development projects including ecommerce sites for companies selling:
- Ecommerce site for a company selling cancer awareness products that donates 10% of sales to cancer research
- Ecommerce site for a company selling commercial, industrial, and military carrying cases
- Ecommerce enhancements for a company selling emergency medical supplies and equipment and school nurse supplies
- Ensure projects conform 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 - Madison, WI - 2003 to 2008
- 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)
- 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)
- 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
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
- Wrote 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 hospitali 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 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
This resume is also availible as a PDF
