SUMMARY:

• 15+ years of IBM iSeries, RPG III/ILE/Free/SQLRPG, CL, SQL, DB2 developer experience.
• 05+ years of EDI Setup and Operation experience - ANXI X12 301,304,310,315,322 etc.
• 03+ years of JAVA Servlet, Java Applet, Java Script, HTML developer experience.
• Ocean and inland transportation logistics business Knowledge.

• Strong background 15 years in OS400
• Primary DB2 Systems programmer responsible for installation, system tuning and support for all DB2 and OEM DB2 tools (Compuware and CA Platinum).
• 15 years’ experience with DB2 database design and administration.
• Perform structural changes to Databases for corporate business structure changes to ensure that company business standards are followed.
• Work with Audit Staff to review data access of Db2 data thru ACF2 policies and DB2 security policies.
• DB2 Migrate, Copy and Restore execution.
• Supervise db2 and sql data changes to production data.
• Expert knowledge of OS/400, JCL, SQL, DB2.
• Optimize Database SQL access with developers thru code review and analysis and tuning using DB2 .
• Maintain Backup and Recover policy for all company data on SQL server and DB2 to insure protection of company data both onsite and offsite.
• Primary Disaster Recovery Database support person participate in twice yearly tests.
• Work closely with Applications and Operations Support in reviewing batch workload for performance efficiency.
• Microsoft Windows Server 2008 installation and create db.

TECHNICAL SKILLS:

Skills: OS/400, AS400, DB2/400 RPG III, RPG IV, ILE RPG, SQLRPGLE, CLP, CLLE,DDS,DDM,SDA(Screen Design, Sub-File etc),RLU(Print File Design) SQL/400, JAVA Applet/Servlet, JAVA Script, HTML,AS400 Client Access, iAccess, EDI ANSI X12, EDI UN/EDIFACT, WINDOWS XP, WINDOWS 7, MS-SQL SERVER, PROJECT MANAGER, IBM MQ, FTP, JDBC, Embeded SQL,TCP/IP

WORK EXPERIENCE:

SQL Programmer/System Architect

Confidential, Richardson, TX

Responsibilities:

• Responsible for testing various clients to make sure they will behave correctly in production once they go - live (3 test environment: CTE,ACE and CERT all IBM AS400 iSeries)
• Processing Medical and Pharmacy claim and verify if the system works correctly.
• Iserise subsystem(Batch, Interactive) monitoring and fixing if it has error status(Like message wait).
• Various reports generation of Claim Statement and analysis/fix program when value is incorrect.
• Uploading claim data into Web-site so the client/pharmacy could check it through the WEB site.

SKILL: IBM AS400 ILE RPG, CL, DB2, SQL, FTP, DDS,ALDON and HP Quality Center, JCL etc.

IBM iSeries AS400 RPG CL DB2 SQL Programmer/System Architect

Confidential

Responsibilities:

• Responsible for IT system development and maintenance with AS400,RPGLE,CL and Java programs.
• Every 3 months, being evaluated by client and got over-scored of target SLA score.
• Develop USA-Customs-EDI system for import Confidential from Asia to USA ports.

SKILL: IBM AS400, DB2, RPGLE, CLLE, SQL, DDS, SDA, RLU, SUBFILE

IBM iSeries AS400 RPG CL DB2 SQL Programmer/Analyst

Confidential, Irving, TX

Responsibilities:

• Responsible for Transportation-Equipment Maintenance n Repair System which keeps every repair history and its cost as well as Equipment Stock Control.
• Develop rate-request system in which client and sales makes final rate by rate offer & count offer process.
• Support Sales, Marketing IT system adjusting program for local business practice.

SKILL: RPGLE,CL,DB2,SQL,DDS, JAVA Application, JAVA Swing Interface etc

IBM iSeries AS400 RPG CL DB2 SQL Programmer/Analyst

Confidential, Denver, CO

Responsibilities:

• EDI processing for various clients.
• Additional clients added to EDI service programs.
• Support of Easy Link interfaces using FTP for clients.
• Some maintenance of existing programs. Heavy maintenance and development of RPG ILE, and CL programs.
• Utilize Query or SQL to review data for analysis, unit testing and Q/A testing.

SKILL: RPGLE,CL,DB2,SQL,DDS,SUBFILE,SDA,PRTF, FTP etc

JAVA SERVLET SCRIPT HTML DB2 Developer

Confidential

Responsibilities:

• Perform several web projects for staff education & credit service.
• For example, eTraining & eLearning System which provide internal staff education & credit control system
• Company Asset & Property Control System which register all the material the company purchase and trace the location.

SKILL: Java applet,servlet,jdbc,DB2,tomcat web server, HTML, Java script

IBM iSeries AS400 RPG CL DB2 SQL Programmer/Analyst

Confidential

Responsibilities:

• Support two foreign office-establishment.
• Install and adjust all IT system such as Accounting,Operation,Documentation,Sales for a given short schedule.
• Responsible for Y2K compliance system migration.
• Analysis entire IT system and data base length addition with all related program change including DB conversion and test.
• Perform ISP(Information Strategy Planning) in order to align IT system with business objective.

SKILL: RPGLE,CL,DB2,SQL,DDS,SUBFILE,SDA,PRTF,FTP,MS-OFFICE etc

IBM iSeries AS400 RPG CL DB2 SQL Programmer

Confidential

Responsibilities:

• Responsible for Confidential movement data from Confidential -origin to final destination.
• Provide equipment visibility to internal organization and Confidential tracking information to client.
• Real time data gathering through various automatic system development.
• Lots of Data Entry, EDI data loading, Reporting and Analysis program maintenance and development.

SKILL: RPG,CL,DB2,SQL,DDS,SUBFILE,SDA,PRTF,QSANDS,IBM-MQ etc