add photo
William
WJHasbun@gmail.com
520-248-8002
2133 E Oregon St.
Tucson, AZ 85706
Sr. Programmer Analyst
27 years experience W2
2
Recommendations
Average rating
1122
Profile views
Summary

  • Senior Programmer Analyst with 15+ years IBM iSeries (System i/AS400) experience on applications written in RPGLE (FREE and Fixed format), interactive/embedded SQL, Java such as Accounting, Billing, Credit, Financial, Order Entry, Inventory, etc.

EXPERIENCE AND SKILLS

  • SQL, Embedded & Dynamic SQL, DB2 SQL Functions & Stored Procedures, DB2, IBM Power Systems, iSeries, AS/400, DBU, SEU, RLU, RDA, SDA, System i OS (OS400) APIs, RPGLE (ILE RPG IV) (Fixed & Free-Form), RPG/400, Procedures, Service Programs, ILE COBOL, COBOL/400, ROBOT, FTP, PGP, Linoma's RPG Toolbox, QSH (QShell) Scripts, System i OS V7R1, V6R1, V5R4
  • IBM RDI (Rational Developer for System i), WAS Webfacing
  • Build Excel files using Apache POI from RPG IV, .PDF file text & page extraction using Apache PDFBOX from RPG IV.
  • IFS directory & file processing using iSeries C functions in RPG
  • Turnover, Aldon, HawkEye, CrediCheck, GROUP1, eCMS
  • ILE RPG IV CGI programs using CGIDEV2
  • Microsoft Office, MS Sharepoint
  • MS Word/Excel Visual Basic for Applications & Visual Basic
  • Project Requirements Gathering
  • Sarbanes-Oxley compliance projects
  • Java, JDBC, Servlets, JavaMail, Eclipse, Hibernate, Spring
  • MS SQL Server and Stored Procedures
  • iSeries Page Segments, Overlays & AFPDS printing
  • ISIS-Papyrus Overview AFP Designer & Image Editor
  • Adobe Illustrator & Adobe Photoshop
  • Crystal Reports
  • Windows XP, Windows 7 and Windows 8
  • HTML Code & Javascript
  • Strong Customer Service & Organizational Skills
  • Customer Systems Support via WebEx sessions
  • Strong Proof Reading, Editing & Communication Skills
  • Excellent documentation skills
  • Fluent English / Spanish translation & interpretation;
  • basic to intermediate Italian
  • US Citizen

Experience
Education
Bachelor's in Civil Engineering
Universidad Nacional Autonoma de Honduras
Related Courses
Crystal Reports 2008, 2009
Isis-Papyrus Overview AFP Designer & Image Editor, 2005
Free format ILE RPG IV, 2001
Java Programming & OOP, 2001
Crystal Reports, 1998
ATS AS/400 Database Administration III (SQL), 1998
ATS AS/400 CL & Programming Techniques, 1997
ATS AS/400 Control Language Programming, 1997
ATS AS/400 Operations & CL Programming, 1997
ILE RPG IV (RPGLE), 1997
ILE COBOL (CBLLE), 1997
JAVA Programming Introduction, 1997
Skills
FTP
2014
1
Documentation
2014
16
Microsoft Excel
2014
16
Microsoft Word
2014
16
SQL
2014
16
AS/400
2014
15
CL
2014
15
ILE RPG
2014
15
OS/400
2014
15
RPG
2014
15
Eclipse
2014
14
RPG IV
2014
13
iSeries
2014
12
Java
2014
12
RPG/400
2008
10
Adobe Illustrator
2008
9
Adobe Photoshop
2008
9
Application Design
2008
9
Cobol
2008
9
Java Servlet
2008
9
JavaScript
2008
9
JDBC
2008
9
Basic
2014
1
Credit/Collections Analysis
2014
1
DB2
2014
1
Microsoft Office
2015
1
Turnover
2008
1
Windows
2015
1
Windows 7
2015
1
Windows XP
2013
1
VBA
2014
6
Crystal Reports
2009
1
RPG III
1999
1
Spring
2009
1
Telephony
2004
1
Visual Basic
2009
1
Windows 8
2015
1
Quality Control
2012
3
Stored Procedure
2014
3
Aldon LMI
2012
2
Apache
2014
2
IBM WebSphere
2012
2
JSP
2012
2
Rational Developer for i
2012
2
Compliance
1999
1
Hibernate
2009
1
Microsoft SourceSafe
2009
1
Product Management
2009
1
SQL Server
2009
1
Subversion
2009
1
SVN
2009
1
Hawkeye
0
1
HTML
0
1
Requirements Gathering
0
1
Languages
English, Fluent/Bilingual
Spanish, Fluent/Bilingual
Italian, Basic