System Analyst Resume Louisville KY - Hire IT People

SUMMARY:

IT professional with more than 15 years of experience working with IBM AS400 ISeries using RPG ILE, RPG400, CL400, QRY400, SQL400, RPG Free Format. Provide support for financial and manufacturing software JBA ERP package, Payroll and HR Software Pus Applications, Vertex Sales tax, Acom/Ezprint, Qtracs, Varsity Logistics/Shipsoft, Double - Take data replication recovery software.
Hands on experience in various business applications to support and improve business operations including day to day administrations of IBM AS400 ISeries.

PROFESSIONAL EXPERIENCE:

Confidential, Louisville KY

AS400 JBA Programmer/ System Analyst

Responsibilities:

Work on the project of migrating Confidential IBM AS400 I Series Environment version V5R4 to new CVS Environment running on version V7R1.
Write utility programs in RPG and CL in order to move libraries, data files and applications.
Test functionality of the new system and customize existing programs.
Use SQL to create Stored Procedures for Ecommerce portal to allow .Net applications to call RPG400 programs and process orders.
Work on the project of implementing new Electronic Product Code standards. Develop programs allowing trading partners to know the status of trade item at any time.

Confidential, Santa Ana, CA

IBM AS400 Programmer

Responsibilities:

Design, program and implement manufacturing production system reports and interfaces using RPG, CL and SQL.
Develop Costing control application procedure for manufacturing item cost accounting,
Summarized Bill of Material Report and conversion programs to fill data into AS400 system.

Confidential, Norwalk, CT

SAP Business Integration Project Mgr/ Data Management.

Responsibilities:

Develop RPG400 conversion programs to feed JBA database files into SAP.
Analyze and compare files in JBA with SAP templates.
Responsible for data integrity audit processes; played significant role in data clean up in JBA system.
Generate numerous database audit reports using SQL and QRY400 to simplify process of implementation.
Test functionality of the SAP B1 system and use SQL to run reports to compare output to the JBA system.

Confidential

IBM AS400 ISeries Administrator

Responsibilities:

Perform daily system monitoring, verifying the integrity and availability of all hardware, server resources, reviewing system logs, and verifying completion of scheduled jobs.
Manage and monitor daily, weekly, and monthly backups and restore procedures, ensuring all required file systems and data are successfully backed up, and media is recycled and sent off site as necessary.
Troubleshoots AS400 hardware, PC client workstations and software problems.
Responsible for AS400 user management. Create, change, and delete user accounts and authority.
Monitor and manage JBA DB400 database. Use QRY400 and SQL to create, run, and analyze various reports.
Manage JBA software ERP package, apply updates, monitor and generate standard reports for end users. Generate daily order processing reports.
Perform monthly Vertex Sales tax updates and generate monthly contract invoices.
Perform year end setup for JBA software package.

Confidential, Norwalk CT

RPG400-JBA Programmer Analyst

Responsibilities:

Writing file maintenance and management reporting modules using RPG, CL programs and embedded SQL.
Utilizing Subfiles processing, Message Subfiles, Windows.
Writing report generation modules to support weekly, monthly and year end processing.
Support of Billing, Accounts Receivable, Accounts Payable and Service Subsystems.
Responsible to manage monthly updates of tax tables in Billing System.
Coding and testing reports using Queries and SQL.
Maintain standard Software Plus applications used for Payroll and Human Rsources.
Writing technical and functional documentation.
Responsible for writing daily requested custom made financial reports.