Uploaded File
add photo
William
WJHasbun@gmail.com
520-248-8002
2133 E Oregon St.
Tucson, AZ 85706
iSeries Programmer / Analyst
24 years experience W2
2
Recommendations
Average rating
867
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
Sr. Programmer Analyst
Banking/Financial
Jul 2012 - Dec 2014
  • Maintenance, enhancement, development and support of existing and new applications, using Free and Fixed format RPGLE, CL programs, QShell scripts, embedded and dynamically-built SQL, & C functions to process IFS files.
  • Development of applications to parse, validate, format & insert into production new clients’ tab-delimited data files
  • Reporting of account statuses, payments and notes; reporting of account closures, actuarial reports, account inventory reconciliation reports, recalls, etc., as Excel spreadsheets using Apache POI from RPG.
  • Generation of reports as Excel files using Apache POI Java classes, building embedded SQL statements dynamically using different selection criteria options entered by the user, and storing and running multiple report definitions per user.
  • Taught how to use service jobs to debug/diagnose job errors.
  • Created Excel templates with VBA macros to automate importing tab-delimited files, format, pre-validate and/or cleanup data, and exporting it as tab-delimited files to upload to the iSeries, thus eliminating formatting & operator errors.
  • Wrote Java programs to extract phone numbers from call-recording-software catalogs to extract client-specific call recordings to meet client requests
  • Created an addendum RPG procedure prototypes copybook mapping Apache POI Java class methods not defined in Scott Klement’s HSSF_H copybook, thus enabling setting up Excel file headers and footers, margins, border colors, and setting up custom colors, among others.
  • Taught SQL to coworkers, how to use it embedded in RPG programs and to generate tab-delimited files to export
  • Wrote/updated project documentation using MS Word.
iSeries ILE RPG CL Stored Procedure SQL RPG Java Documentation Microsoft Word VBA Eclipse Microsoft Excel AS/400 OS/400 RPG IV Apache
Remove Skill
References
Average Rating

2 recommendations
Sr. Programmer Analyst
Information Technology
May 2010 - Jun 2012
  • CMS & eCMS customer custom code and database file upgrades, conversions, maintenance, and support using both FREE and fixed format RPG, JSPs, Webfacing and embedded and interactive SQL in all eCMS modules.
  • Custom base CMS/eCMS code modifications.
  • Work closely with the QA and Technical Service teams researching/resolving problems
  • Creation and maintenance of .JSP files according to specific socket RPG program requirements.
  • CMS/eCMS new development, maintenance and support.
  • Extensive phone and webex customer support.
  • Display file modifications adding WAS 5.0 to 7.5 webfacing, setting up RDI webfacing projects, and installation of webfacing on WAS servers.
  • Creation and maintenance of tools to start, stop or restart native installations of WAS servers from the command line.
  • Wrote/updated project documentation both in MS Word documents (using Word templates & VBA) and the Wiki.
RPG CL JSP VBA SQL Documentation Microsoft Word Eclipse Microsoft Excel AS/400 OS/400 ILE RPG Quality Control Rational Developer for i IBM WebSphere Aldon LMI
Remove Skill
Java Developer
Information Technology
Jun 2008 - Sep 2009
  • Member of the Xpress product software developers team responsible for maintaining, enhancing and developing new modules for Health Claim entry, maintenance and processing application in Java.
  • Interact with Product Management and Quality Control personnel to gather information to determine needs, write project requirements and design and implement solutions.
  • Part of a team of Java programmers rewriting the Benefits processing module for Xpress.
  • Performed a Visual SourceSafe to Subversion source control conversion.
  • Maintenance of SQL Server stored procedures.
  • Wrote and/or updated project documentation both in MS Word documents and the IT Wiki.
Java SQL Server SQL Quality Control Microsoft Word Documentation Stored Procedure Microsoft Excel Hibernate Eclipse Subversion Microsoft SourceSafe SVN Product Management
Remove Skill
Programmer Analyst
Information Technology
Jun 1999 - Jun 2008
  • Member of the Backend Systems Support team which was responsible for maintaining, enhancing & developing Accounting, Authorizations, Billing, Order Entry & Credit Systems applications in ILE RPG IV & RPG/400.
  • Interact with end users to gather information to determine needs, write project requirements as well as design & implement solutions.
  • Performed a Magnum CrediCheck V5.1 upgrade and all software modifications required for the new interface.
  • Created overlays & page segments to be used to print on invoices, purchase orders, & other forms.
  • Member of the E-Commerce Java programming team for four years.
  • Wrote & maintained Java classes as well as backend programs to enable the company to receive Internet orders.
  • Contributed to the design by writing & enhancing a Java application to process Opt-In, Opt-Out & bounced e-mails.
  • Handled many Credit applications projects that dealt with Order Entry credit card authorizations and Credit Reports.
  • Wrote a Java application according to design specifications to maintain, setup & select e-mail promotions to be sent to customers.
  • Corrected & enhanced in-house-developed Java applications that handle web page generation, telephony and web page inquiry requests.
  • Added / updated documenting comments (JavaDocs) to the in-house-developed Servlet project classes used by the web-page-building application.
  • As member of the Special Projects Team, wrote new applications.
  • Co-designed & wrote RPG utilities designed to aid programmers with the implementation process, which included, but were not limited to, program generation utilities.
  • Converting & creating fonts for the iSeries from Windows based fonts.
  • Wrote and/or updated project or system documentation both in MS Word documents and the IT Wiki.
  • Re-wrote & maintained the E-Commerce Catalog Publishing application in Java.
  • Worked extensively in COBOL programs. About 15% of the programs were COBOL.
ILE RPG RPG IV RPG/400 RPG Java Application Design iSeries Microsoft Word Documentation CL Microsoft Excel Adobe Illustrator Adobe Photoshop JDBC AS/400 OS/400 Eclipse SQL JavaScript Cobol Java Servlet
Remove Skill
Programmer Analyst (part time)
Information Technology
Aug 1998 - Dec 1999
  • Analyzed & modified applications to make them year 2000 compliant for client companies.
  • Worked on a project which involved analyzing & modifying S/36 COBOL & COBOL/400 programs for a client.
  • Analyzed & modified COBOL/400 programs & CL programs & their corresponding display screens as well as the data areas for a client’s application.
  • Unit tested RPG/400 programs verifying year 2000 compliance for a client’s application.
RPG/400 Cobol CL RPG ILE RPG AS/400 iSeries OS/400 SQL Compliance
Remove Skill
Programmer Analyst
Information Technology
Sep 1997 - Jun 1999
  • Maintained & modified applications on the RISC based AS/400 620 system.
  • Responsible for designing & implementing new applications.
  • Provided user support & wrote documentation.
  • Installed, configured & supported 5250 session emulation software for both local & remote users.
  • Assisted with the implementation of the interface that connected our 70 remote branch Client Server systems to the Infinium-based (Software 2000) Payroll & General Ledger applications running on our corporate AS/400 system.
  • Designed & implemented a Solicitor Sales tracking program using ILE RPG IV & Query/400.
  • Worked closely with the payroll department to convert & modify the Employee Loan Tracking System to ILE RPG IV.
  • Applied modifications to report programs & corresponding printer files via RLU to be distributed electronically to our remote locations.
  • Enhanced the software that randomly selects customer account data from our AS/400 database to print year end audit letters.
  • Designed & implemented VBA macros for Word 97 to facilitate merging the data with the form letters.
AS/400 ILE RPG OS/400 VBA RPG IV RPG CL Documentation RPG/400 Microsoft Word SQL Microsoft Excel
Remove Skill
Edit Skills
Non-cloudteam Skill
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