106 14th St NW
Watertown, SD 57201
ryan@jonasson.org
Graduate of Jamestown College May 2000. Bachelor of Arts Degree in Computer Science
and Management Information Science.
Programmer Analyst. Daktronics, Inc. July 2007 - Present. Brookings, South
Dakota
Duties include:
- Developer and Data Architect on Amdocs ClarifyCRM application for Customer Service.
- Extensive Java, JavaScript, and SQL Server stored procedure development to support
the Amdocs CRM application.
- SQL Server Integration Services developer providing ETL solutions between Glovia
ERP and Amdocs CRM.
- Highlight of this task was rewriting a one-time data load tool that originally would
have taken 8 months to execute. Final load time was 4 days.
- T-SQL Stored Procedures to extract data for use in Reporting Services reports and
SharePoint Intranet web sites, and import data through SSIS.
- Backup System Administrator for Windows 2003 servers running BEA WebLogic application
servers.
Systems/Network Administrator. ANZA Incorporated.February 2002 - July 2007. Watertown, South Dakota.
Duties include:
- Transferred from Midcom, Inc. to parent company ANZA Incorporated.
- Provide IT support and development for the ANZA family of companies including Midcom,
Inc. and Persona, Inc.
- Leader (non-managerial) of four person IT team. Coordinate resources and communicate
with designated users at each company about project and development status.
- Project Management duties for various projects including conversion of Oracle Payroll
to ADP Pay eXpert, and upgrade of Oracle Applications 11.0 to E-Business Suite 11i
- Developed Extranet sites integrating Oracle Applications data in a user friendly
manner for sales representatives, distributers, and end customers using ASP, JavaScript,
and DHTML technologies.
- Management of network built on Windows NT and Linux.
- Network administration of global WAN using Frame Relay, Private, and VPN circuits.
- Oracle Forms and Oracle Reports development of custom applications to integrate
with Oracle Applications 11.0 and E-Business Suite 11i.
- SQL and PL/SQL programming on Oracle 8i and 9i databases.
- User administration on Oracle Applications Release 11.0 and E-Business Suite 11i.
- Backup Database Administrator for Oracle 8i and 9i databases.
- Implement EDI transactions using EDIFACT and ANSI X.12 standards with Oracle Applications
using Oracle EDI Gateway and custom extraction scripts.
System Administrator. Midcom, Inc. January 2000 - February 2002. Watertown,
South Dakota
Duties include:
- Implement EDI transactions using EDIFACT and ANSI X.12 standards with Oracle Applications
using Oracle EDI Gateway and custom extraction scripts.
- Developed custom applications using Oracle Forms, adhering to the Oracle Applications
User Interface requirements.
- Midcom, Inc. Developed back-end systems that presentation developers use to easily
deploy parts catalog. Also built a
Product Guide using AJAX technologies for fast, easy selection of parts
by selecting user-driven criteria.
- Persona, Inc. Developed secured Extranet sites for Persona customers to view sales
order and project status.
- Midcom RepNet. A secured Extranet site for Midcom sales representatives and distributers
to receive price quotes, view sales order and invoice status, and view stock availability.
- Google Maps vs Bing Maps. Utilizing
API's published by both Microsoft and Google, developed a web page for users to view
the satellite imagery both sites offer side-by-side to make comparisons of image
quality. Done as a hobby that was featured on
MSNBC.com,
Internet Week magazine, and numerous articles on
Via Virtual Earth.
Programming Languages: Java, JavaScript (DHTML), T-SQL, C#, Perl, PHP, SQL, PL/SQL
8.0, Visual Basic .NET, VBScript / ASP, C / C++.
Operating Systems: Windows 9x/NT 4.0/2000/XP/2003/Vista/7, Linux, Solaris,
and Novell Netware.
Database Systems: Microsoft SQL Server, Oracle, MySQL, PostgreSQL, Microsoft Access.
Certified Novell Netware 4.x Administrator, 1999
Online version can be found at http://www.jonasson.org/resume.html