We provide IT Staff Augmentation Services!

Sql Programmer/system Architect Resume

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.
  • 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

Hire Now