EDUCATION
Confidential College
Bachelor of Arts Degree in Music,

Confidential University
Associate in Applied Science, Data Processing.

COMPUTER KNOWLEDGE
Hardware Experience:
AS400, System 36, Personal Computers
Software Experience:
RPG ILE, RPGIII, RPGII, Free Form RPG, CL, OCL, SDA, Query400, SQL, Embedded SQL in RPG ILE, OS400, SSP, SQL, Websphere, Turnover, Track-It, Infor XA, ERP, MOVEX ERP, Design Systems Software ERP, Realvision Imaging Software, Computer Keyes Fax and Email Software, Tivoli Backup System, Windows Server 2003, Client Access, PC Support, EDI, HTML, CGIdev, PHP, MySQL, Apache.

WORK EXPERIENCE

Confidential July 2009 – May 2012
Programmer/Analyst

• Wrote programs in RPG ILE free for client using CGI dev and embedded SQL for client in Albany, NY on site
• Wrote programs in RPG ILE free for Banco De Brasil in Westchester, NY on site
• Maintains existing programs for Roburn Agencies on the AS400 using RPG ILE
• Helps with network enhancements and disk space requirements
• Makes hardware software recommendations for management
• Moved Company to a new location
• Diagnosed and fixed a problem the controller had during the year end processing.

Confidential Kingston, New York Sept 2008 – July 2009
Programmer/Analyst

• Enhanced Movex ERP package using customized programming using RPG ILE.
• Automated credit processing by cloning existing MOVEX receipts and invoicing programs, adding work files and custom coding. Simplified shipping receipts paperwork to a single bar code-enhanced report using RPGIII, CL, Movex, Websphere, Track-It and OS400. Managed the project by running meetings with users and monitoring conversion progress.
• Designed Out Of Stock Report, replacing manual process, saving five hours each night and eliminating human error using embedded SQL in RPG ILE.
• Promoted modified programs to production using Websphere Turnover environment.
• Monitored project management with Track-It software.

Confidential Brooklyn, New York Sept 2003 – Sept 2008
Programmer/Analyst

• Rewrote INFOR XA customer inquiry program using DB2 and embedded SQL
• Created, coded and tested RPG-based solutions using RPG ILE, DB2 and embedded SQL in RPG ILE, CL, INFOR XA, and RPG III and SDA.
• Handled INFOR XA user’s program enhancement requests using RPG III, SDA and CL.
• Automated month-end reports, saving 30 man-hours per month using RPG ILE, DB2 and embedded SQL in RPG ILE and CL.
• Designed tracking programs to monitor database consistency using RPG ILE and CL, DB2 and embedded SQL in RPG ILE.
• Wrote a bank deposit package to generate digital archive of customer checks, replacing manual processing to track payments using RPG ILE, CL, DB2 and embedded SQL in RPG ILE.
• Monitored email server using Windows 2003.
• Managed semiannual physical inventories using the INFOR XA ERP and custom programming, QUERY 400 and RPG ILE.
• Enhanced A/R, A/P, O/E and Inventory modules of INFOR XA ERP package with custom programming using RPG III and CL.
• Developed all new projects in RPG ILE using procedure calls, DB2 and embedded SQL.
• Modified existing RPG III programs.
• Wrote monitoring programs to verify consistency of the Realvision physical files.
• Monitored network backups and problems using Tivoli.

Confidential New Paltz, New York Sept 2001 – Sept 2003
Programmer/Analyst

• Was an adjunct support person assigned to Monroe Woodbury School District
• Wrote a scheduling package for district monitoring of facilities usage using RPG ILE and CL. This package used the date functions of RPG ILE. The package maximized facilities use in the district and eliminated double bookings.
• Wrote cash management system to track district payments. This system gave the district a better handle on the cash payments received from taxpayers
• Taught other AS400 programmers RPG ILE new functionality
• Helped users with software issues

Confidential. Hartsdale, New York Sept 1999 - Sept 2001
Programmer/Analyst

• Wrote inventory programs for various clients
• Helped clients to learn to use the warehouse software in their businesses
• Fixed bugs in the software

Confidential. Yonkers, New York Mar. 1993 – Sept 1999
Data Processing Manager/Administrator

• Managed information technology for export company on the AS400 and System 36.
• Wrote, tested, applied, put online all Y2K changes to Design Systems ERP.
• Modified Design Systems Software to enhance throughput and automate some processes.
• Wrote an EDI translator and enabled EDI transmission of PO and Functional Acknowledgements to vendor. Modified O/E to create EDI files and run the upload to PC Support and to GE network and the return Functional Acknowledgement from vendor.
• Transitioned System 36 operations to AS400.
• Developed targeted mailing package to send product literature to international customers using Computer Keyes Software package.
• Wrote a Proforma package to furnish customers with merchandise quotes using RPGII SDA and OCL.
• Applied PTFs and OS upgrades.
• Automated invoice and order acknowledgements to customers via Computer Keyes fax/email software.
• Wrote merge programs in RPGII and OCL, and RPG ILE and CL to convert vendor files to the item master format. Ran the update programs to do the merges.
• Worked with CEO of Roburn to design new systems and purchase of new software packages.