Blair McLean
abng4b@r.postjobfree.com
801-***-**** home
801-***-**** cell
PROFESSIONAL SUMMARY:
• Reliable, resourceful IT Professional with 23+ years experience supporting product development and
quality initiatives for diverse organizations, such as Weider Nutrition, UPS Freight. Broad expertise spans
software quality assurance, EDI, full life cycle development and implementation of projects.
• Demonstrated business acumen with ability to accurately assess technical challenges and transform creative
ideas into workable solutions.
• Strong team leader, adept at training and motivating others to exceed goals.
• Exceptional ability to research, analyze and translate complex technical information to end-users at all
levels.
• Productive contributor to team efforts; successfully deliver multiple concurrent projects under the tightest
deadlines.
EDUCATION AND PROFESSIONAL CERTIFICATIONS:
Associate Degree in Data Processing for Business – Ricks College - 1983
TECHNICAL SKILLS:
Platforms: OS400
Software: JD Edwards World, Medseries4, MS Office Suite, Lotus Notes, Premenos
Hardware: AS400 and associated peripherals
Other: RPGII, RPGIII, RPGIV, RPG400, RPGLE, CL, SQL, DFU, PDM, Debug, Query, SDA, Sub-files, Logical
files, Join logicals, Open Query, Report writing, EDI, VB.Net Experience using ILE concepts such as bound
modules, service programs, procedures, binding directories, and free style RPGLE.
PROFESSIONAL EXPERIENCE:
UPS Freight/Motor Cargo 04/2003-04/2009
Programmer Special Projects
Re-write of freight management software using ILE and object oriented concepts. Address book data specialist for
conversion of customers to mainframe software. Handled systems administration on the AS400 including security.
Managed an In-fax process that fed through the AS400. Handled data extractions and reporting for legacy data as
needed for lawsuits and other informational reporting.
Key Accomplishments:
• Helped migrate legacy AS400 data to an IBM mainframe.
• Worked on a team to clean up the numerous Access user created databases and upgrade those remaining to
the latest version of Access.
• Managed a team to bring the IS department into SOX compliancy for system access and system access
reporting.
• Wrote a process in 24 hours to interface driver trip records that needed verification before being moved into
payroll.
Skills: AS400, RPGLE, Microsoft Access, TOAD, DBU, CLLE, SQL
Computer Marketing Corporation (CMC) 01/2003-04/2003
Programmer
Worked with customers (credit unions) to customize the AS400 CMC software to meet their needs.
Key Accomplishments:
• Showed company how to use AS400 journaling to replace the hard coded methodology of tracking program
use and data access. This resulted in a broader scope for checking user access to information. Wrote the
process to extract and display the journaled information.
Skills: AS400, RPGIV, CL, SQL
1
Application Programming Specialists 05/2001-12/2002
Programmer Self Employed
Contract work for hospitals using Medseries4 software installed on the AS400.
Key Accomplishments:
• Created flat file data extractions for 3rd party evaluation of patient throughput.
Skills: AS400, RPGIV, CL, SQL
Amerinet/PCS IT Services 08/1997-05/2001
Programmer/Analyst
Contract work for hospitals using Medseries4 software installed on the AS400.
Key Accomplishments:
• Successfully completed a 2 year Y2K project with one other programmer to prepare 8 hospitals for Y2K.
This involved bringing customized code up to the software vendor standard and being onsite for each
installation. All 8 hospitals experienced zero fallout from the code changes we made.
Skills: AS400, RPGIV, CL, SQL
Assist International, Inc. 10/1995-08/1997
Programmer/Analyst
AS400 work installing and supporting the Assist financial software. This included enhancements, bug fixes and
customizations for clients.
Key Accomplishments:
• Successfully learned the Assist software package and database. I was able to work in house to enhance the
software and on the road to support Assist customers with problems and customization.
Skills: AS400, RPGIII, CL
Weider Nutrition 06/1991-10/1995
Programmer/Analyst
Project leader over several contract programmers. Specific duties over Order Entry and Distribution. Custom
reporting management. AS400 systems management including data base integrity.
Key Accomplishments:
• Helped install new AS400 and JDE software.
• Assistant to the IS director. Over a staff of 8.
• Received six JDE training certificates.
Skills: AS400, RPGIV, CL
Native Plants 07/1986-05/1991
Programmer/Analyst
Software systems Maintenance and troubleshooting. User interface and problem resolution. System operations
Sys/38. Helped with the installation and migration to JDE software and handled all JDE upgrades.
Key Accomplishments:
• Helped install and maintain JDE software.
• Wrote a system backup process that prompted for specific tape numbers by schedule and allowed a non-IS
person to handle backups.
• Project managed the creation a full feature order entry system for 5 nurseries. The company was convinced
they would be out of business with out this software and we wrote, tested and delivered in a 6 month
period.
Skills: Sys38, RPG, CL
2
American Protectors Insurance 05/1985-06/1986
Programmer/Analyst
Modify and maintain Universal Life policy programs. Maintenance of Proposal programs and Reporting programs.
Wrote Electronic debits to Tape program for Accounts Receivable. Modified Cash Receipts to interface with the G/
L.
Key Accomplishments:
• Policy schedules were sold from PC print outs but maintained on the Sysem 38. I worked closely with the
PC programmers to ensure that the numbers were the same. This was a problem because of rounding
differences but we managed to get them to sync.
Skills: Sys38, RPG, CL
Art Porter, Inc. 12/1983-05/1985
Programmer
Operations on Sys/38. Managed daily reports to users. Created reports as needed from database. Program
modifications and bug fixes as requested.
Key Accomplishments:
• This was my first level entry job. My accomplishment was that I paid my dues, did the grunt work and
really started to learn my trade after the college experience.
Skills: Sys38, RPG, CL
Summit Software 04/1983-11/1983
Programmer
Helped maintain a G/L program for an Apple Computer. We worked with a custom package for Diet Center
franchise owners.
3