STEVE C. JORGENSEN, PROFESSIONAL SOFTWARE DEVELOPER 29030 SW Town Center Loop East PMB 234 ~ Suite 202 Wilsonville, OR 97070 503-703-2386 ~ jorgens@coho.net ----------------------------------------------------------------- A skilled professional software developer with over 25 years of experience in a wide range of technologies, industries, and applications. Focuses on the consistent delivery of high quality software functionality. === TECHNICAL EXPERTISE === -- PROGRAMMING LANGUAGES -- Ruby ~ JavaScript ~ Python ~ Java ~ Apex (Salesforce) ~ Clojure ~ PHP ~ SQL ~ Bash ~ Microsoft VBA ~ Shopify -- WEB AND USER INTERFACE TECHNOLOGIES -- HTML ~ CSS ~SCSS ~ ERB ~ Apache HTTP Server ~ Varnish Cache ~ VisualForce (Salesforce) -- SOFTWARE FRAMEWORKS AND TOOLKITS -- Ruby on Rails ~ AngularJS ~ Django ~ Ruby Rack ~ Sinatra ~ jQuery ~ Concrete 5 ~ Force.com (Salesforce) ~ Java SE ~ Swing ~ Microsoft Access ~ Microsoft Office -- DATABASE TECHNOLOGIES -- PostgreSQL ~ MySQL ~ Microsoft SQL Server ~ SQLite ~ HyperSQL (HSQLDB) ~ Oracle Database ~ Redis ~ S3 ~ Memcached ~ ActiveRecord ~ JDBC ~ ODBC ~ OLE DB ~ hstore ~ Legacy databases (FoxPro, Paradox) -- CONCEPTS AND PROCESSES -- TDD ~ BDD ~ Agile ~ Coupling and Cohesion ~ REST ~ Continuous Integration ~ Relational Database Design ~ Extract, Transform, and Load (ETL) -- EDITORS, ENVIRONMENTS AND TOOLS -- Vim ~ tmux & wemux ~ Hamachi ~ RubyMine (IntelliJ IDEA) ~ Eclipse ~ NetBeans ~ Microsoft Office & Access IDEs ~ Ruby Debugger ~ ruby-prof ~ RSpec ~ Cucumber ~ Jasmine ~ jUnit ~ TeamCity ~ Git ~ HitHub ~ Subversion ~ CVS ~ RCS ~ Jira ~ PivotalTracker ~ Screenhero ~ ssh ~ scp ~ rsync -- DATA FORMATS -- CSV ~ JSON ~ YARD ~ Swagger ~ XML ~ XML Schema ~ YAML ~ Rich Text (RTF) ~ MIME ~ HTTP ~ LDAP -- OPERATING SYSTEMS AND ENVIRONMENTS -- Linux ~ OS X ~ Microsoft Windows ~ Cygwin ~ VirtualBox ~ VMWare ~ Vagrant -- APPLICATIONS AND INDUSTRIES -- Intellectual Property Managment ~ Daily Deals ~ Marketing ~ Energy Efficiency Promotion ~ Elderly Care ~ Customer Relationship Management (CRM) ~ Inventory ~ Bill of Materials ~ Online Shopping ~ Material Requirements Planning (MRP) ~ Real Estate ~ Higher Education ~ Unit Testing Frameworks ~ Training and Certification === ORGANIZATIONS AND PROJECTS === * Contributor to Ruby on Rails core * Contributor of several patches to various Ruby gems * President in 2003 and Vice President in 2004 of Portland Access User Group (PAUG). * Author of VB Lite Unit testing tool (http://sourceforge.net/projects/vb-lite-unit) === PROFESSIONAL EXPERIENCE === CLIOSOFT INC * Fremont, CA (remote) JUL 1016 to PRESENT Senior Software Developer Working with a distributed, 7-person team, developing, supporting, and enhancing Web applications, primarily involved with management of System on Chip (SoC) intellectual property using Django (Python) and AngularJS. * Developed and maintained software components using Django, AngularJS, Python and JavaScript. * Developed and maintained Linux software installation system using Bash. * Participated in research and planning for software architectural decision making. * Participated in team process engineering. LIVING-SOCIAL * WASHINGTON, DC (remote) SEP 2013 to MAY 2016 Senior Software Developer Working with a distributed, 6-person team, developing, supporting, and enhancing Web applications and SOA services, primarily involved with merchant payments and salesperson commissions using Ruby on Rails, Salesforce Apex, JavaScript, and Clojure languages. * Developed and maintained software components using Ruby on Rails, Salesforce Apex, JavaScript, Clojure, MySQL, Redis, Resque, and Kafka. * Remotely collaborated and pair-programmed with teammates using Google Hangouts, ssh, tmux, and Screenhero. * Developed and maintained automated test coverage using RSpec and Cucumber. * Created and maintained continuous integration tasks in TeamCity and Jenkins. * Participated in ongoing directed evolution of the team's process for development and delivery of software. * Developed and implemented APIs and message structures for interaction between services running in Ruby, Salesforce, and Clojure. * Collaborated with software architects and members of other teams on multi-domain projects. ANALOG ANALYTICS (via ATSI) * PORTLAND, OR MAR 2013 to AUG 2013 Software Developer Maintained and improved the Super Banner multitenant, Web-based daily deals application as part of an 8-person distributed team of software developers. * Developed and maintained application functionality using Ruby on Rails, MySQL, and Resque. * Remotely collaborated and pair-programmed with teammates using Skype, Google+, Screenhero, ssh, and tmux. * Developed and maintained automated test coverage using Test::Unit, Shoulda, Mocha, and parallel_tests. RENEWABLE FUNDING * PORTLAND, OREGON MAR 2011 to MAR 2013 Senior Software Developer Engaged in Web application development, process improvement, and software architecture innovation for a 5-to-8 member Agile software development team. * Developed and maintained applications built with Ruby on Rails, PostgreSQL, and JavaScript for the promotion of renewable energy and energy efficiency initiatives. * Developed and maintained automated test coverage using Cucumber and RSpec. * Created and maintained TeamCity continuous integration tasks. * Participated in ongoing innovation to improve the team's process and streamlined software development and delivery. * Planned and developed integrations between Ruby on Rails applications and Salesforce. * Contributed to the Ruby on Rails framework. VIGILAN, INCORPORATED * WILSONVILLE, OR APR 2005 TO FEB 2011 Senior Software Engineer Developed and maintained marketing and administration software for the Assisted Living and Long-Term Care industries, written in Java, Ruby, Visual Basic, Microsoft Access, and the Salesforce Force.com platform. * Implemented data synchronization between different Vigilan products and between Vigilan and 3rd party products, including Salesforce, ACT!, Microsoft Dynamics SL and GP (formerly Solomon and Great Plains), Peachtree, You've Got Leads, and REPS. * Designed and implemented improvements to resident monthly and prorated billing logic to make reports more informative and customer bills more clear. * Developed an HTML-email billing system in Ruby, integrating with Vigilan software and the PaySimple (http://paysimple.com/) on-line payment system. * Developed the audio/video presentation section of Vigilan's Web with lead capturing using the Salesforce Force.com platform. * Was the primary developer of an on-line store for product and service sales with PayPal integration, written in Ruby on Rails. * Participated in installation and customization of Concrete5 CMS to manage Vigilan's public Web site. * Developed a Java desktop application for email and postal mail marketing campaigns, generating SMTP email messages Microsoft Word documents. * Developed a Web-based navigation system for a new unified application suite interface using JSP and SiteMesh. * Instituted unit testing for new code in legacy VB and VBA applications using a custom-built framework. Independent Consulting * Portland, Oregon Feb 2002 to Present Monumental - Portland, OR Implemented front end and back end enhancements to Shopify-based online retail stores. * Implemented transfer of updates product information from a product catalog service to a Shopify-based online store. * Added up-sell functionality to the dynamic, AJAX-driven shopping cart of a Shopify-based online store. Jordan Lev - Portland, OR Developed server and client functionality for Web applications built using the Concrete 5 framework and JavaScript, and provided Ruby development support. * Developed the administration for Riley Weiss' "Curious" page content which arrives as image, video, and text content through email, Twitter, and MMS. * Implemented the majority of the ePad tool for Metabolic Maintenance, allowing a users to construct nutritional supplement packages, dynamically computing nutrient amount totals and total price. * Answered questions regarding Ruby and Sinatra application development. BirdFellow - Wilsonville, OR Engaged in the development of new features and enhancements to a social networking service for Bird enthusiasts written in Ruby on Rails. * Implemented new annotation and commenting features. * Implemented new activity-reporting features. * Wrote new automated unit tests, functional tests, and Cucumber feature specifications. The Service Department - Portland, OR Performed maintenance and implemented enhancements to a service request tracking and billing application in Ruby on Rails with a PostgreSQL database. Enhanced and improved the public-facing Web site, using HTML, CSS, PHP, and Apache configuration. * Added new customer fields and searching/sorting capabilities. * Maintained and developed PDF output functionality using Prawn and wkhtmltopdf. * Added Testimonials section and Testimonial-submission to Web site. * Added randomly-selected Testimonials to Home page. * Made Web site URLs more friendly and robust, with 301 redirection from older URLs and canonical links for URLs in the "www" subdomain. * Re-implemented some image-only captions using image-replacement for better SEO and accessibility. DataWing Software - Portland, OR Implemented improvements and enhancements to several product lines. * Improved performance and source code structure of a medical payment reconciliation application written in Microsoft Access/VBA, with data storage in either of Microsoft SQL Server 2000 or 2005 databases. * Implemented a high-performance, HIPPA 820 file import procedure. * Profiled and optimized the performance of a Web page data scraping application. Zocalo Software - Brooklyn, New York (remote from Portland) Maintenained and improvemed Ruby on Rails applications in use by non-profit, educational organizations, including Columbia University and The READ Foundation * Created new reports and CSV file exports of student disability accommodation data. * Implemented several bug fixes and enhancements to existing capabilities. Optomec, Inc. (via Jordan Lev) - Albuquerque, NM (remote) Made improvements to an existing customer support Web application written in Ruby on Rails. * Added uploading of attachments to new trouble tickets. * Added recording and forwarding of attachments included in customer email replies received by support system. * Added ticket text content search capability. * Modified existing ticket assignment logic. Krause Team Real Estate Group (via Jordan Lev) - Portland, OR Helped complete the http://allportlandcondos.com Web site written in Ruby on Rails. * Created the administrative content management interface. * Integrated with Google Maps to display property locations in embedded maps on site pages. Adidas, US (via Meridian Technology Group) - Portland, Oregon * Developed a prototype system to help reduce costs incurred by having inconsistent data between several legacy systems in several countries. Implementation: ~ A data-driven, rule based application written in Access and VBA that compares data-extract batches from new and legacy systems containing parallel data in different schemas. Features: ~ Identifies and reports updates required to synchronize legacy data to be consistent with current authoritative data. Reports in a format similar to the automated TIB data update messages to be generated by the future, fully automated system. ~ Reports discrepancy rates for measurement of data quality for progress tracking of on-going data clean-up efforts. Used as a key performance indicator (KPI). Whitney and Associates, Inc. - Portland, Oregon Trained the primary developer and assisted in the development of an Access ADP and Microsoft SQL Server application to plan mailing campaigns and analyze campaign results for non-profit organizations. Bates Private Capital (via Compass Computing) - Lake Oswego, OR Authored new software and enhanced existing software to support investment fund analysis processes. Helped establish new software development processes and practices. Performed large- scale refactoring of legacy code, improving structure and maintainability. Mentored new developers. * Developed a rule-based ETL application in Access to load and normalize fund performance data from exported spreadsheets into a PostgreSQL database back-end. * Enhanced and maintained VB and VBA programs for investment fund activity input/extraction and analysis/output. * Migrated database in MS Access to PostgreSQL to improve reliability with >50 users. Used an Access database with table links to PostgreSQL as middle-layer to preserve compatibility with legacy front-end applications in Excel, Access, and .NET, pending future code updates. * Performed recovery from corruption of mission-critical PostgreSQL database through the use of Linux command line tools, MS Access queries, Excel formulas, and VBA. * Developed a system to track request and receipt of missing financial statements identified during input and review. * Provided advice on new development processes for expanded development team, borrowing concepts from Extreme Programming and other processes and methodologies. * Mentored programmers on how to efficiently produce high- quality, maintainable code. Applied Test Systems - Hillsboro, Oregon Authored new software and enhanced existing software in MS Access to streamline purchasing and repair authorization (RA) processes, and to enable significant new sales options. * Developed a "System Configurator" to price construction of circuit boards or entire large systems: pricing computed from bill of materials (BOM), current inventory, construction costs, and standard purchase prices. * Developed an RA and component repair tracking system: tracking of shipping, receiving, and inventory; generation of shipping documents; support for combined shipments for multiple RAs. * Developed a component purchase ordering (PO) system. * Developed a module to specify and track manufacturing jobs: required parts determined from BOM; reservation and back- ordering of components; job progress tracking. * Developed an employee-task scheduling and tracking system. * Developed an automated data migration tool from the older to the newer generation of BOM/Inventory system: data remapping from older flat model to new, normalized model; up-front checking/reporting of consistency errors that impede successful migration; automatic resolution of many common forms of inconsistency. CSG, Inc. - Portland, Oregon Developed applications and worked on teams developing applications for CSG's clients. * Developed the administration interface for a large travel agency's outward-facing Web site, using MS Access as a front- end to PostgreSQL. * Salvaged a project (nearing final deadline) for generating reports and graphs in MS Access from data collected by an Intranet QA application. * Worked on a 4-person team, overhauling a Web-based billing application written in ASP and ASP.NET for use by an intellectual property escrow company. NDE Professionals (through Compass Computing) - Portland, OR Rearchitected projects, formerly in Access 2.0, for sale to companies that perform non-destructive inspection of architectural structures and machine parts. One application component tracks certification status of test engineers; the other generates certification exams from sets of possible questions in various classifications. * Implemented a more modern, intuitive, and attractive user interface design. * Merged database schemas of separate applications, and improved data normalization. * Extended database schema to support multiple companies per database. * Implemented importation of data from old versions of one or both old applications, including cross-application data merging. * Implemented import/export of reusable question banks with awareness of question revisions. Fisher Nursery (through Compass Computing) - Gaston, Oregon Produced new MS Access reports for a legacy, vertical business application written in FoxPro for DOS, fixed bugs in legacy FoxPro code, and wrote new FoxPro code for data clean-up operations. EverGuard Insurance (through Bradson Technology) - Seattle, WA Enhanced scalability of existing insurance policy tracking application to handle more complex business cases by migrating the data storage from MS Access to MS SQL Server. * Developed rule-based custom code to upsize database schema to Microsoft SQL Server 2000. * Developed system to infer default up-sizing rules from Access database object characteristics. Times Lithograph - Portland, Oregon Developed an Access application to produce printed output for a lobbying organization's annual membership directory, including a lobbyist section with photos and lists of clients, a clients section, and page numbering for the combined package. Earlier Employment/Contracting - Seattle & Santa Clara May 1989 to Jan 2002 Developed software applications and performed IT services. * Developed software for MRP, Bill of Materials, A/R, and A/P, Invoicing, Payroll, Labor Tracking, Shipping/Receiving, and vehicle maintenance scheduling. * Developed highly flexible data reporting and graphing systems for management decision support and warehouse inventory management. * Developed I.T. Help Desk operation software. * Trained and mentored other programmers and IT personnel. * Developed graphical editing and HPGL2 image printing software. * Developed software using Microsoft Access, Microsoft SQL Server, Oracle Database, FoxPro, Paradox, and Revelation. * Installed and administered Microsoft SQL Server, Windows NT networks, Microsoft Exchange Server, and automated data backup systems. * Installed computers and local area networks. === EDUCATION === * Highline Community College, AA (Physics & Mathematics emphasis) * North Seattle Community College, Electronic Engineering Technology