SQL Programmer/System Architect Ressume Profile Richardson, TX

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.

PBM Pharmacy Benefit Management business knowledge. Project leadership at Hyundai with Project-Management-Professional Certificate.

Work Experience

Confidential

SQL Programmer/System Architect

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.

Confidential

SQL Programmer/System Architect

Responsible for IT system development and maintenance of Client, 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 cargo from Asia to USA ports. SKILL: IBM AS400, DB2, RPGLE, CLLE, SQL, DDS, SDA, RLU, SUBFILE

Confidential

SQL Programmer/Analyst

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

Confidential

SQL Programmer/Analyst

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.4 Major Client Groups: USA,Canada,Panama Customs/Port Authority Truck,Rail BNSF,UP,CN, On-Dock Terminal Customer Ashly Furniture,ToysRus,Samsung,LG etc SKILL: RPGLE,CL,DB2,SQL,DDS,SUBFILE,SDA,PRTF, FTP etc

Confidential

HTML DB2 Developer

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

Confidential

SQL Programmer/Analyst

Support two foreign office-establishment Hyundai Thailand, China LTD . Install and adjust all IT system such as Accounting,Operation,Documentation,Sales for a given short schedule 5 months 2 IT staffs . 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

Confidential

DB2 SQL Programmer

Responsible for Cargo movement data from cargo-origin to final destination. Provide equipment visibility to internal organization and cargo tracking information to client. Real time data gathering through various automatic system development such as EDI with Container Terminal, Inland Container yard, Truck Rail company and customs. 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

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship