P R O F E S S I O N A L E X P E R I E N C E

Confidential

Programmer/Analyst

Responsible for maintenance of TELL interactive/batch transportation software and development of new software within the TELL transportation system. Software languages include RPG ILE, CLLE and SQL. Created unit test files when necessary using CL commands and SQL. Interfaced with business analyst during the user testing stage.

• With quality assurance in mind, I always performed thorough testing in preparation for user system testing.
• Developed and maintained software with user productivity in mind, to facilitate workflow.
• Provided functional specifications, technical specifications, implementation documents and user documentation.
• Responsible for off-hours technical support.
• Development tools include the CITRIX Windows to I-series connectivity software, RPG ILE, RPGIV, Free Format RPG, Control Language, CLP, CLLE , DB2 database file constructs, DBU, ABSTRACT development utility, ALDON change management software, interactive SQL, embedded SQL, SQLLITE, IFS methodologies, I-series debug tool and the TELL transportation software.

Project Leader/Programmer Analyst

Maintained custom software and created add-on software in a JDA retail applications software environment, MMS, SODA . Integrated external data sources into the DB2 database using interactive SQL, or, by incorporating the SQL into a control language program. Developed Control Language Programs which used SQL's to identify data inconsistencies for business analysts to interrogate and resolve. Designed and developed Control Language Programs, incorporating SQL's used to monitor and maintain disk utilization. Designed and developed utilities to facilitate workflow in the user environment. Performed concurrent applications maintenance and development across multiple systems, JDA Retail System environment and Legacy DOS based environment . Performed thorough unit and quality assurance testing in development and integration test environments. Migrated applications software from the development stage into the integration test and production environments. Provided off-hours coverage and problem resolution. Responsible for weekly and or monthly project status reporting. Performed monthly attended IPL procedures. Prepared user and technical documentation. Developed and maintained CLIPPER DOS based business applications software along with MS DOS batch files. Development tools included I-Series Access for Windows, RPG ILE, RPG IV, RPG Free maintenance , Control Language Programming CLP, CLLE , Query/400, Subfile programming, Screen Design Aid SDA , DB2 table and database file constructs, DFU, IFS, utility, Batch SQL, Interactive SQL, Embedded SQL, SQLLITE, AS400 debug tools, JDA Retail software system functions and development utilities, MS DOS, CLIPPER DOS based language, MS Word and MS Excel.

Confidential

Sr. Programmer Analyst

• Designed, developed and maintained applications software, within Sarbanes Oxley guidelines , for sales, order entry, billing, payroll, accounting and marketing applications.
• Performed acquisition data integration from external sources to the I-series platform via the I-series Integrated File System, IFS . Then used SQL's to integrate the data into the respective DB2 file structure.
• Converted legacy RPG II and RPG III to RPG IV or RPG ILE code. Also converted legacy OCL to CLP or CLLE control language.
• Enhanced Trust application to allow certain inventory items to be released from Trust, thus realizing revenues early and increasing profits for the reporting period.
• Enhanced on-line payroll G/L feed system to facilitate user productivity by eliminating unnecessary key entry functions.
• Developed a reporting system for senior level management, to identify marginal and substandard sales activity.
• Created a new customer database and accompanying maintenance system to eliminate redundant customer add/update functionality.
• Automated office procedures to facilitate records keeping functions at remote sites.
• Maintained third party Harris Data payroll software which included ILE program/module binding functionality within its development environment. Installed periodic upgrades.
• Provided user documentation and applications support to both home and field offices.
• Performed thorough unit and quality assurance testing in development and integration test environments.
• Provided a weekly on-line account of project status.
• Prepared user and technical documentation.
• Software languages, development tools and third party software included, I-Series Access for Windows, RPG ILE, RPG/400, RPG III, RPG II, Control Language Programming CLP, CLLE , Subfile programming, Screen Design Aid SDA , IBM DB2 database, SQL Interactive and Embedded , SQLLITE, Query/400, DB2 table and database file constructs, VPN remote connectivity software, IFS, TAATOOLS, ABSTRACT, Harris Data payroll package, MS Excel, MS Word and in-house change management software.

Confidential Programmer Analyst Designed, developed and maintained interactive and batch applications software for the global marketing division utilizing AS400 COBOL, RPG and Control Language Programming CLP languages. Automated interactive key entry processes, including command line file transfer procedures, to eliminate time-consuming manual tasks. This was accomplished by incorporating manual functions into CL batch programs. Performed thorough unit and quality assurance testing in development and integration test environments. Documented applications software and prepared user documentation. Software, development tools and database utilities included, AS/400 Subfiles, COBOL ILE, COBOL/400, RPG/400, RPG ILE, SQL/400 Stored, Interactive and Embedded , Query Manager, Query/400, CL Programming, DB2 table and database file constructs, DBU, DFU, SDA, Pathfinder database utilities, Windows 98 and TCP/IP file transfer protocol. Confidential Programmer Was responsible for the conversion of in-house applications software to accommodate YEAR 2000 date handling routines. Enhanced customized purchased software American Software Inc. to meet Y2K requirements. Also responsible for miscellaneous maintenance and development of accounting and financial software on IBM AS/400 platforms. Automated an interactive EDI file extract system along with the automation of other manual functions to increase user productivity. Performed iterative unit testing and integration testing for quality assurance purposes. Software languages and utilities included AS/400 Subfiles, COBOL ILE, COBOL/400, CL Programming, SQL/400 Stored, Interactive and Embedded , RPG/400, and RPG ILE. Query/400, DB2/400 Query manager programs, DB2 table and database file constructs, TCP/IP file transfer protocol, Pathfinder database utilities and MS Windows.

Confidential

Was responsible for the design, development and maintenance of batch and interactive software specific to environmental risk management and insurance applications. Was also responsible for the maintenance of the Wheatley Insurance Group software package. Designed and created commands to perform frequently used routines. Thoroughly tested software with quality assurance in mind. Software development tools included COBOL/400, AS/400 Subfiles, CL programming, including extensive use of Open Query File Functionality , SEU, SDA, SQL/400 Stored, Interactive and Embedded , DB2 table and database file constructs, Query Manager, Query/400, UIM, Office Vision for OS/400 and Windows 95.

Confidential

Was responsible for the design, development and maintenance of user exit routines related to IBM AS/400 Image-Plus applications and vendor supplied COBOL imaging software. Created a monitoring system to intercept and backup data files automatically, by transferring lease contract data from a Honeywell Bull GCOS mainframe to the AS400 imaging database, then update the AS400 imaging files. Performed thorough unit and quality assurance testing in development and integration test environments. Mainframe exposure included the design, development and maintenance of interactive and batch applications software on a Honeywell-Bull DPS7000 GCOS platform. Mainframe applications included lease contracting, accounting and billing. Development tools and utilities on the Honeywell Bull DPS7000 Mainframe included Honeywell Bull JCL, COBOL, development utilities and PC based Micro Focus COBOL. Development tools and utilities on the AS/400 included Aldon Change Management software, COBOL/400, AS/400 Subfiles, CL programming, UIM, SQL/400, DB2 table and database file constructs, RPG400, SQL, TCP/IP and IBM API's.