Alan Patterson Email & Phone Number

Spokane, Wa, Us

Spokane, Wa, Us

RPG/LE, CL, SQL programming and development duties

Us

RPG/LE, CL, SQL programming and development duties, as well as iSeries systems administration and maintenance for daily operations and Disaster Recovery planning/testing.

AS400 Programmer/Analyst ­ RPGLE, CLLE, OS/400 QuerySQL ­ extensive database work in converting traditional DB File System to SQL-Based DB table set for java-based portal construction.Use of IBM EGL for JSP and Web Services integration into existing portal code.Basic JSP, javascript, and HTML coding and maintenance in portal code.Maintained and updated all base system software code (java, CL, RPG, SQL).Customer Support Liaison to help determine programmatic/system nature of client requests/problems.Debugging/Data Mining/Research on client systems nationwide to aid with various issues and projects for thecompany or client.

Responsible for providing comprehensive database support for client and in-house needs at a privately-held health and fitness billing corporation.i550 programmer ­ RPGLE, CLLE, OS/400 Query, MQ Series.SQL ­ extensive database querying and maintenance, ranging from embedded SQL coding in RPG to daily data updates and management for individual client needs.Increased collection call effectiveness by developing selection and randomization code to assure an even call volume across clients and time zones by amount owed and predicted likelihood of payment.Developed back-end triggering and SQL query/update system for I3 IVR phone system and dialer setup.Increased company collections by developing a vendor outsource data-sharing program set for collections processing.Reduced end-of-day processing time by six to eight hours by developing programs to convert batch client dataupdates to live, synchronous communications processes for DataTrak proprietary check-in/billing software.Reduced code volume and maintenance load by converting DataTrak account maintenance processes to usewebsite modules.Developed and maintained transaction modules for Company's website.Ensured largest-ever client of quality control with development and implementation of custom database update processes through Data Conversion / Upload.Leader and team player in building relations with primary clients through detailed customizations of code,processes and reporting structures.Reduced mail room workload by over 40% by developing customizable outsourcing code for all Late Letter and Marketing material processing.Reduced postal expenses by developing a mass postal coding update.Handled 24/7 on-call rotation for any system or user problems on holidays, weekends, and nights.Duties included routine system operations duties, request-based programming, maintenance of any existingsystems, and any emergent problem-handling, either client or system based.

Responsible for providing complete support to incoming new clients to ease their transition into the company'smethodology.Created department for training, handling, and accommodating new clients ­ acclimating new clients to theprocessing, reporting, and management styles of the Company.Helped reduce programming load by taking a self-instruction course in OS/400 Query and handling customreporting requests from new clients.Implemented a curriculum to help standardize the first stages of importing/uploading a new client into the ABCbusiness model .

Responsible for all manners of clients needs, from billing figures and explanations to account changes andproblem resolution.Provided phone support to clients as needed for updates and management of their data and reporting services.Served as liaison for clients to help service their accounts, as well as providing instruct on understanding andbenefiting from Company's reports and services.

Provided phone support for incoming member calls related to their membership accounts.Served as intermediary between client and member for conflict resolution.Handled overflow for Client Services Department

Bs, Recording Engineering

High School Diploma, General