Post Job Free

Resume

Sign in

Software Engineer Sql Server

Location:
Portland, OR
Posted:
November 19, 2012

Contact this candidate

Resume:

Scott Willson, Senior Software Engineer

abplt4@r.postjobfree.com

**** ** ******** **., ********, OR 97202

503-***-****

SKILLS

Java, Ruby, Python, Javascript, Perl, VB, HQ9+, AppleScript

WebSphere, Rails, WebObjects, JBoss, Apache, Tomcat, Jetty, EJB, Swing

Eclipse, IDEA, Emacs, JUnit, Ant, Visual Studio, CVS, VSS, SVN, Shockwave Flash

Linux, Mac OS X, Solaris, Windows

Oracle, PostgreSQL, MySQL, SQL Server, DB2, Domino, FileMaker, JDBC, PL/SQL, SQL

Struts, Spring, Hibernate, AJAX, Servlets, JSP, RMI, SOAP, XML, XSLT, DHTML, ASP, PHP

OOP, XP/Agile, Mentoring, UML, Data modeling, Business analysis, UI/HCI design, Full life-cycle

PROFESSIONAL EMPLOYMENT

Senior Software Engineer

Con-way

Portland, OR, May 2004 to Present

Led team of developers to build custom logistics integration system. System

receives shipment status information from a variety of sources -- EDI, XML,

internal applications -- and consolidates it in a standardized data store.

System provides web-based UI for internal and external customers, and for our

"customers' customers." Also provides a web UI for customers to initiate orders

and receive rate quotes, and sends outbound status updates to business partners.

Current system handles approximately 500,000 transactions a month, and is built

to scale to 5 million transactions with no modifications.

Currently adding features to and refactoring bill corrections A/R system.

Con-way field employees enter correction requests and auditors approve requests.

System routes several thousand request per day through fairly complex workflow

logic. Recent features include approval limits for Sarbanes-Oxley compliance and

workflow streamlining. Reduced total lines of code by 10% while adding features.

Prototyped new features with Ruby on Rails.

Worked as technical lead on bit projects. Collaborated in coding, system

architecture, and data modeling. Championed agile development approach. Coached

and mentored other developers.

Set up and maintain automated hourly build, test, and deploy for both projects.

In six months of coding, logistics team wrote 400 unit tests and 70 automated

system tests. Added 125 unit tests and 131 system tests to corrections system.

Built Rails front-end to display historical test results and code metrics.

Systems deployed on Websphere, Tibco, DB2, and Oracle. Uses J2EE, Struts, JSP,

Spring, JUnit, and several Apache libraries. Integrate with i2 TM, UPS

WorldShip, Informix-based OMS and WMS.

Senior Java Programmer

Freightliner (contract)

Portland, OR, December 2003 to May 2004

Designed and developed business object layer for NAFTA online documentation

J2EE extranet.

Also developed J2EE integration application. 'PCS Parsing' extracts truck

specifications from mainframe IMS system, merges it with Catia drawing

information, and stores the composite data in DB2. Business clients in

Freightliner Test Center use the application s web interface to browse and order

parts for prototype trucks. PCS Parsing exports the orders and part information

to a VB-based parts ordering system.

Designed, built, tested, documented, and deployed application in iterative

cycles with full test coverage. Collaborated with Cognos, mainframe, and DBA

team members.

PCS Parsing is a J2EE enterprise application deployed on WebSphere. User

interface is build with JSP and Struts. Service layer implemented with stateless

session EJBs. Data is stored in DB2 and SQL Server with a Hibernate persistence

layer.

Senior Java Programmer

Banfield Pet Hospital, (contract)

Portland, OR, March 2003 to December 2003

Coded, tested, and deployed veterinary services administration system. Worked

with system architect to expand system design. Led development team and mentored

them in agile, test-driven, and pattern-base development.

Administration system is a distributed, web-based J2EE/Oracle application

deployed on iPlanet. Used Eclipse, VSS, JSP, Struts, Jakarta libraries, and

PL/SQL. Developed full-coverage unit and functional tests with JUnit and

Fitnesse. In addition to core customer management features, system also includes

several back-end processes: credit card and bank account billing; medication

shipment; and reporting.

Built robust, high-volume interfaces to existing J2EE and legacy FoxPro systems

using JMS/Oracle Advanced Queuing and PL/SQL. Updated FTP interface with

external medication provider

Senior Java Programmer

Freightliner, (contract)

Portland, OR, March 2003 to July 2003

Expanded, maintained, tested, and deployed truck service knowledge base. Added

new panels and pages, and rewrote database connection mechanism. Made Java

source considerably more consistent and OO. Added unit tests for all code

changes. After refactoring, application contained 40% fewer lines of code and

20% fewer classes, yet performed far faster and more reliably. Completed all

deliverables on-time and under-budget.

"ServicePro" is a hybrid Swing applet/JSP/servlet application deployed on

WebSphere with a SQLServer 2000 back-end. Application interacts with proprietary

case-based reasoning engine via RMI. Used IDEA and PCVS.

Senior Software Engineer

SelectMetrics/MeasureCast, Inc.

Portland, OR, October 2002 to March 2003

Collaboratively designed, built, tested, and deployed Web audience measurement

application. Worked in a full "XP" pair-programming environment with five other

developers. Designed distributed Java application for high-uptime and maximum

scalability. At launch, application included over 2100 unit tests, and records

close to 1000 visitors/second with

Launched Web-based reporting site. Clients can create, save, and run custom

audience reports in real-time. Reports are generated with XSLT and show audience

demographic data.

Reporting system also includes a Swing administration tool delivered via Java

WebStart.

Senior Java Developer

New Edge Networks, (contract)

Vancouver, WA, July 2002 to October 2002

Built J2EE open-source customer and order management system from the ground up.

Designed and implemented servlet-based presentation layer. Wrote and used

business and entity EJBs. Collaborated on automated build, deploy, test process.

JBoss, Oracle, Velocity, Struts, XDoclet.

Lead Java Developer

Synetics Inc., (contract)

Gresham, OR, May 2002 to July 2002

Analyzed business requirements and current code base for migration to

WebSphere/Apache from Tomcat/IIS. Planned migration path. Managed hardware,

software, and network installation. Tested and updated Java code.

Java Developer

Freightliner, (contract)

Vancouver, WA, November 2001 to May 2002

Customized, maintained and expanded complex dealer order system using Java

Swing. Analyzed and fixed bugs using Rational Unified Process. Collaborated on

storyboards and style guides. Rewrote order transmission to use SOAP. Created

custom JTable-based grid component. System is a multi-tier enterprise

application built upon SilverStream, SQL Server, XML, and FirePond BRE.

Lead Java Developer

Synetics Inc., (contract)

Gresham, OR, May 2001 to November 2001

Installed, customized, and expanded PowerCerv ERP System for semiconductor

equipment manufacturer. Integrated PowerCerv with existing databases and file

systems behind a lightweight Web browser interface. The integrated Web site has

fine-grained security, is dynamically customized for individual users, and

available to both employees and external business partners. All integration work

built on a custom multi-tier Java servlet framework.

Deployed and maintained remote source control and automated testing software.

Designed Web user interface.

Senior Web Developer

mySeasons.com

Old Saybrook, CT, September 2000 to April 2001

Led development efforts as the architect for an established transaction-based

e-commerce gardening Web site. Designed and prototyped two complete upgrades of

mySeasons.com: one with WebLogic and Oracle, a second with WebObjects,

FrontBase, and OpenBase. Both prototypes have abstracted, redundant business

object layers. Developed flexible presentation layer to support multiple brands.

Launched WebObjects (Java/Objective-C) prototype on Solaris.

Built and deployed customer management and bulk emailer web applications.

Implemented extreme programming (XP) practices.

Senior Software Engineer

CenterMark Technologies

Higganum, CT, October 1999 to September 2000

Analyzed, designed, developed, tested, and implemented Leasemarket, a

transaction based business-to-business e-commerce web site for small business

equipment leasing. The site contains a data repository of over 2000 clients and

removed the need for the third-party brokers.

Lead developer on a two-person team. Designed site as a multi-tier,

client-server web application. Managed graphic design. Built a customizable

lease auction engine that includes transaction support, integrated messaging and

discussion system with auto-notification, and asynchronous credit report

retrieval. Used SQL Server, Java, Java Applets, XML, COM+, Visual Basic, Visual

C++, ASP, and Active X.

Senior Web Developer

Gap Inc.

San Francisco, CA, May 1997 to October 1999

Evolved Gap Inc.'s intranet (GapWeb) from static HTML to Lotus Domino. GapWeb

uses a distributed authoring model that enables any employee to author intranet

pages. Led and participated in many GapWeb projects detailed below.

Analyzed, designed, developed, tested, and implemented a custom site statistics

application to pool raw data into a reporting mechanism for all Gap Inc.

internal and external websites. Used Java, Access, SQL Server and JDBC.

Performed modification and enhancement to modules in a shrink-wrapped package

used for travel and expense reimbursement. Used Java, HTML, JavaScript, Java

applet client

Analyzed, designed, developed, tested, and implemented a Web browsing front end

for the corporate archive database. Database contains TV adds, store posters,

clothing and other collateral from entire Gap corporate lifetime. Used Java,

Domino as middleware.

Analyzed, designed, developed, tested, and implemented the Web interface for

Lotus Notes. Used Lotus Domino, C and JavaScript.

Analyzed, designed, developed, tested, and implemented a Web-based surveys

application with authoring tools for rapid development by non-technical users.

Created multiple templates. Used Domino and JavaScript.

Analyzed, designed, developed, tested, and implemented customized components for

multiple internal sites. Extended and separated these customized sites

according to the brand identities for Gap US, Banana Republic, and Old Navy.

Used Domino, JavaScript and HTML.

Built self-authoring system for the daily company-wide online news homepage.

Used Domino, JavaScript and Shockwave.

Worked as the internal consultant on retail store messaging system. The

application allowed Gap headquarters to communicate sensitive information to all

retail stores. Analyzed, designed, developed, tested, and implemented the user

interface and workflow. Application replaces an inefficient manual sign off.

Used Domino and JavaScript.

Analyzed, designed, developed, tested, and implemented the company's Online

Employee "How do I guide. Web site contains all benefit information,

enrollment, employee handbook, and full text search capabilities. Used Domino

and JavaScript.

Developed information architecture and user interface standards for intranet,

extranet, and corporate online web site for health benefits and management.

Collaborated on presentation layer. Used ASP, VB and SQL server.

Led development for GapInc.com PDF repository of manufacturing standards and

test results for external business partners. Wrote and edited intranet author

training materials. Used Visual Basic, ASP, and SQL Server.

Principal

Butler Press

San Francisco, CA, March 1997 to Present

Planned, launched, and maintained Internet sites. Used visual graphics and

multimedia interactive capabilities for web, presentations, and print: Flash,

HTML, Dreamweaver, Illustrator, Photoshop, Image Ready, Used CGI, Perl, Java,

ASP, Unix, Netscape Enterprise Server on Solaris, Javascript, C and Visual

Basic:

http://www.mtc.ca.gov/

http://www.steelmancycles.com/

http://www.aheadset.com/

Developing Ruby on Rails site for Truss and Wall Design.

Technical Director, avviso, San Francisco, CA, September 1995 to March 1997

Computer consulting and website creation.

Graphic Designer, freelance, San Francisco, CA, 1993-1995

Flight Attendant, American Trans Air, 1990-1993

Senior Consultant, Wesleyan Computing Center, 1989-1993

VOLUNTEER

Oregon Bicycle Racing Association

Portland, OR, May 2001 to Present

Wrote Java Swing app to parse bicycle racing results and store in mySQL

database. EJB business objects use MySQL data to track standings in a variety

of yearly competitions and calculate category upgrades. Built Web interface with

Struts and JSP. Deployed on JBoss app server.

Migrated Swing/J2EE app to Ruby on Rails. Added real-time results look up by

racers and teams. Created AJAX-based web admin GUI. Created standalone FOX + DRb

client. Administer Mailman lists on SUSE 10 server. Added Rails front-end to

mailing list archives:

http://list.obra.org/posts/obra

http://app.obra.org/bar/

Redesigned and currently maintain www.obra.org website.

EDUCATION

Wesleyan University, 1989-1993

Earned B.A. with honors -- International Politics and

Non-Western History

http://www.butlerpress.com/resume.html



Contact this candidate