STEVE HONG
**** ****** ***** #* ****** GROVE, CA 92844
714-***-**** **********@*****.***
Objectives
Supervise and directly participate with a team of programmers to write, code, test, and analyze software programs and applications. This position includes researching, designing, documenting, and modifying software specifications throughout the production life cycle.
Experience
Information System Analyst Jul. 2015 – Apr.2017
Lineage Logistics Irvine, CA
Support Warehouse Management System(WMS) with EDI
Created new EDI mapping set 940, 945, 943, 944, 856, 846 based on various Trading Partner requirement by using Dell Boomi Atomsphere
Solve problems and identify bugs
Support CSR for all related EDI, Data flow and existing order
Tools: Dell BOOMI Atomsphere Cloud/Linux 3.10/AWS (Amazon Web Service)
Sr. Application developer Dec. 2007 – Apr.2015
Vanguard Logistics Services (A.K.A NACA Logistics) Long Beach, CA
Developed the corporate application and implemented 16 countries in Asia, Europe, and South America. This system utilizes 400 or more tables (Oracle 11g) and there are five major modules - Sea Import, Sea Export, Load Plan, EDIs, AP/AR, and Cash Receipt. Five languages are supported
Implemented in-house Bill of lading GUI System, include user preview and country specified bill of lading form print
Implemented booking confirmation(BC) GUI and auto generated PDF version of BC, send to customer by email attachment
Implemented real time Cargo Status/Cargo Release GUI by feeding 3PL trading partner’s EDI
Created and used stored procedure to retrieve or/and update cargo status data
Implemented Global transaction log GUI for data and EDI activity
Created and used Oracle View for retrieve where heavy data needed from GUI
Implemented Sailing Schedule maintenance GUI and various reports
Implemented GUI for Daily/Weekly/Monthly/Yearly EDI transaction log and reports
Developed GUI and EDI with Australia Customs (Format - EDIFACT)
Developed GUI and EDI with New Zealand Customs (Format – EDIFACT, XML)
Developed GUI and EDI with Customs Border Protection(CBP) (Format - Proprietary)
Developed GUI and EDI with Japan 24 AFR Customs (Format – XML)
Developed EDI with 3PL (Format – text, cv, xml)
Designed/Developed EDI Core batch system by using Powerbuilder GUI and scripts
Research and document requirements of program users as required.
Consistently write, translate, and code software programs and applications according to specifications.
Administer critical analysis of test results and deliver solutions to problem areas Communicate with management and/or team members on the status of the programming process.
Solve problems and identify bugs
Tools: Power Builder 11.2 and Oracle 11g, PL_SQL, MS Windows NT server 2003, Citrix Meta Frame
Sr. Application developer as contractor Apr. 2007 – Dec.2007
Deutsche Bank Santa Ana, CA
Maintained in-house Loan application and various reports
Tools: Power Builder 9 and Sybase
Sr. Application developer Jan. 2004 – Apr.2007
NACA Logistics Services Carson, CA
Developed the corporate application and implemented 16 countries in Asia, Europe, and South America. This system utilizes 400 or more tables (Oracle 11g) and there are five major modules - Sea Import, Sea Export, Load Plan, EDIs, AP/AR, and Cash Receipt. Five languages are supported
Developed GUI and EDI with Australia Customs (Format - EDIFACT)
Developed GUI and EDI with New Zealand Customs (Format – EDIFACT, XML)
Developed GUI and EDI with 3PL (Format – text, cv, xml)
Designed/Developed EDI Core batch system by using Powerbuilder GUI and scripts
Research and document requirements of program users as required.
Consistently write, translate, and code software programs and applications according to specifications.
Administer critical analysis of test results and deliver solutions to problem areas Communicate with management and/or team members on the status of the programming process.
Solve problems and identify bugs
Tools: Power Builder 9.0.3 and Oracle 9i, MS Windows NT server 2003, Citrix Meta Frame
Sr. System Analyst Apr. 1999 – Dec.2003
Ingram Micro Santa Ana, CA
Maintained Application Security GUI System (Sybase)
Developed Purchase Asset Management GUI System (MS SQL 6.5)
Developed Automatic Replenishment and exception-based GUI System (Oracle 8.1.7)
Write Oracle PL/SQL for real time transaction between IBM Mainframe and Oracle DB
Write JAVA scripts for Real time transaction between mainframe and Oracle
Consistently write, translate, and code software programs and applications according to specifications.
Solve problems and identify bugs
Tools: Power Builder 6.5 and Sybase, Oracle 8.1.7, MS SQL 6.5
System Analyst Oct. 1997 – Mar.1999
Daewoo Motor America, Inc. Compton, CA
Developed Vehicle Distribution System (Vehicle Arrival, sailing Message, Port Inspection and Delivery)
Developed Vehicle Logistics System (Vehicle Tracking, Dealer Distribution)
Developed EDI with Far-East (South Korea)
Maintained Franchise Dealer System
Tools: Power Builder 6.5 and Oracle 7.3
Programmer Analyst Sep. 1989 – Sep.1997
DSL Transportation Services South Gate, CA
Developed Importing Routing System (PO Tracking, Sailing Schedule, Advance Shipping Notice, US Customs Clearance, Bill of lading, Cargo Tracking, Equipment in/out gate, Trans loading and Distribution)
Developed Bar-code Management Information System
Developed Purchase Order Retrieval Tracking System
Tools: Power Builder 4.0 and Informix, Status and VOS Cobol, AS/400 – RPG II
Skills
Language: PowerBuilder 6.5 or higher, PL-SQL, XML, HTML, C#, .NET(beginner), JAVA scripts (beginner), Dell Boomi Atomsphere Cloud
DBMS: Oracle 11g, MS-SQL, Sybase
TOAD 9.x - Database Management tool
PowerDesigner - Modeling Tool
Network: TCP/IP, VPN, VNC, Remote Admin
OS: Windows Server 2003, Windows XP/Vista/7
Citrix, Metaframe - Application Server
EDI format - EDIFACT, XML, X12
MS office(Excel, Word, PowerPoint)
Excellent Problem-Solving skill
Excellent Follow-up
Team Leader
Excellent in communications
Good at coordinating
Self-starter
Quick learner
Good attitude
Flexible
Analytical
Creative
Independent
Goal-directed
Education
Kyung-Ki Technical College
1984-1985 Degree of Business Data processing
Seoul, Korea
Soong-sil University
1984-1984 Bachelor of Science in Computer
Seoul, Korea
Professional Affiliations
Orange County ISUG (international Sybase User Group)
Personal
Fluent in Korean. Willing to Travel
References
AVAILABLE UPON REQUEST