Project Sql
Resume:
Kathy Motlaq
Middletown, NJ
*****.******@*******.***
OBJECTIVE: Project Leader/Senior Programmer Analyst in a professional and
growth oriented environment.
Skills: AS/400, RPG AS/400, RPG III, RPG II, RPG IV, ILE/400, SQL, DB2,
Free Form, API, UIM, DS, CLP, SDA, SEU, DFU, RLU, FTP, Client Access,
Query, EDI, .NET, ORACLE, FLASH, SFLEX, VB, VR, HTM.
Packages: J.D EDWARDS, VERTAX, S2000, LAWSON, JBA, BPCS, JDA, MAPICS,
PKMS, TRUSTED LINK, GENTRAN, SIEBEL
Areas of Expertise include:
. Strong Knowledge with SQL.
. Knowledge of Applications/Development Methodologies:
. Knowledge of Software installation and maintenance.
. Strong knowledge AS/400 and RPG III, RPG IV, ILE, DB2,
Subfiles, Stored Procedures, Embedded SQL, Triggers.
. Knowledge of Oracle.
. Knowledge in EDI.
. Skilled in Troubleshooting/Diagnostic Tools.
. Skilled in Testing and Applications Development/Support.
. Skilled in Research and Documentation.
. Ability to communicate effectively both verbally and
written.
. Ability to work within a tight timeframe on multiple
assignments
EXPERIENCE:
8/08 - Present World Merchandise
Project Leader/Consultant
JD EDWARD, RPG/400, DB2, RPG III, IV,
ILE, CLP, DDS, SQL
. Upgraded from JD Edward 7.3 to 9.2
Inventory/Warehouse/Distribution.
. Create, Review, analyze, and modify programs. Including
testing, debugging and installing. Created
specifications document, Create test scripts.
8/06 - 8/08 PINNACLE FOOD GROUP
Project Leader/Lead Programmer Analyst
MAPICS, BPCS, RPG/400, ILE,
Visual RPG, RPG III, IV, .NET,
DB2, ILE, CLP, DDS, EDI, FTP, SFLEX, SQL, SDA
. Create new 879 Price List, 888 Item Maintenance, 947 Lot
Code Inventory, using VICS Standards.
. Create, Review, analyze, and modify programming systems.
Including testing, debugging and installing. Created
specifications document.
. Transit Time project for TL, LTL gathered requirements
from users.
. Created specifications document and coded the programs
in accordance and Created test scripts.
. Rotation of the help desk.
. Design and write code to support the warehouse
management.
1/02 - 7/06 World Merchandise
Project Leader/Lead Programmer Analyst
JDE, RPG/400, RPG III, IV, ILE,
CLP, DDS, EDI, DB2, Client
Access, .NET, FTP, SQL, SDA,
Oracle, Flash, RPG Embedded
SQL, Oracle
. Review, analyze, and modify programming systems
including testing, debugging and installing.
. Gathered requirements from the users understanding their
business goals, create a specifications document and
code the program in accordance.
. Design and write code to support existing applications.
. Major modifications and enhancements to the JD Edward's
Finance, Distribution- warehouse, Inventory.
. Implement Trusted Link (EDI).
. Modification to the POS system.
. Design and write code to support the warehouse
management.
.
1/01-11/01 ZENITH
Consultant
JDE, MAPICS, RPG/400, RPG III,
IV, ILE, CLP, DDS,
FTP, SQL, SDA, RPG Embedded SQL
. Major modifications and enhancements to the Warehouse
management, and Manufacturing.
. Created new reports for the AP, AR.
8/98-12/00 Tommy Hilfiger
Consultant
RPG/400, RPG III, IV, ILE, CLP,
DDS, EDI,
FTP, SQL, SDA, RPG Embedded SQL
. Implemented Trusted Link
. Mapped to version 4010 and 4030(310-315-810-850-856-820-
860-864
. 824-944-852). Develop, test, and implement.
. Created program to resend ASN.
. Supported users with charge backs.
. Implemented FTP
. Had to find a provider for UPC ticket.
. Work with factory so they can print their own UPC
tickets.
4/97-6/98 Solgar (Division of American Home Products)
Consultant
JDE, RPG/400, RPG III, IV, ILE,
CLP, DDS, EDI,
FTP, SQL, SDA
. Participated in TARGET 400, which consisted of
modifications and the conversion of System 36 programs
to native AS/400.
. Setup INTO 2000 and scheduled all Y2K modifications.
. Enhanced existing programs while maintaining strong user
interface.
. Converted JD Edwards's programs
(Address Book and Financial System)
. Supported South Africa, UK, and US for operations
support.
EDUCATION: E.C.P.I
IBM Midrange Seminars
Fairleigh Dickinson
Brookdale Community College
Contact this candidate