Noel James Colwell

**C Buckingham Dr.

Manchester, NJ 08759

Cell: 862-***-**** Email: dspqy3@r.postjobfree.com

_____________________________________________________________________________________________________________________________________

Technical Business Analyst

Results driven Senior lead programmer/analyst with extensive experience in business analysis and programming in complex systems. Responsibilities included design, development, training, and implementation of applications. Excellent team player who provided mentoring and technical training to junior team members. Industry experience includes apparel, retail, and automotive.

HARDWARE/SOFTWARE: iSeries, AS400, Windows XP, RPG ILE/400/III, CL, SDA, DFU, SEU, Query, ACS, ODBC, RLM, DBU, TL Ashford, Gentran, Aldon Management, PKMS, Extol, Lawson, Codescope, Mapics, Premenos, JD Edwards, ACI, Mapics, SAP, SQL, MS SQL, DB2, Access, Excel, Word

PROFESSIONAL EXPERIENCE

Jordache Enterprise, New York, New York 2007 -2008

Project Leader/Manager

Responsible for development, implementation and management of all phases of software development efforts. Supported Warehousing, Distribution, Order Processing, EDI, Finance, Sales, and Purchasing departments.

• Reduced time to customer invoice by 3 days by implementing a bar-coded manifest system that captured carton information and interfaced the information back to the mainframe.

• Created UCC128 labels that achieved vendor label compliance utilizing TL Ashford.

• Responsible for EDI testing and compliance utilizing Extol.

• Enhanced inventory and sales reporting using SQL, RPG III/400/ILE, CL, and Query tools.

• Modified Ron Lynn Management system as directed by executives.

The Connaught Group, New York, New York 2005 - 2007

Senior Programmer/Analyst

• Designed and created inventory control reports to better manage inventory in ACS and RLM.

• Developed Retail Sales Reports and Sales Rep commissions/bonus incentive reporting using SQL, RPG, CL, and Query tools.

• Created applications and processes to allow company to ship internationally.

• Developed FTP processes for interfacing retail store info to KWI.

• Interfaced UPS and Fed Ex using ODBC with AS400.

• Interfaced RLM invoice information to Lawson using RPG III/400.

Ron Lynn Management Consultants, Fairfield, New Jersey 2004- 2005 Customer Service Representative

• Responsible for all Warehousing and Distribution utilizing RLM System.

• Developed FTP processes to interface with Maersk International using data from the RLM System.

• Created specifications and programs according to client requests using RPG III/400/ILE and CL.

Calvin Klein Jeanswear Co., Secaucus, New Jersey 1996- 2003

Director of Distribution

• Responsible for managing inventory and distribution at 550,000 sq. ft and 125,000 sq. ft warehouses including receiving, pick/pack, shipping/manifesting, invoicing/credits/returns, customer compliance,

and physical inventory. Inventory value: $36,000,0000.

• Maintained relationships with third party warehouse management.

• Managed communication equipment including phones, routers, servers, wiring, and T1’s.

• Created two-way data interfaces from/to AS/400 and UPS PC’s using ODBC.

Noel James Colwell

Cell: 862-***-****

Calvin Klein Jeanswear Co. - continued

Senior Programmer/Analyst

• Responsible for startup of NJ Distribution Center.

• Designed business processes, programmed, and trained warehouse personnel in all RF scanning programs/processes in the RLM Warehouse Management System (WMS).

• Created reports using Query 400 and RPG III/400 utilizing PKMS database.

• Mentored 4 employees in design, development, and implementation.

• Reduced warehouse processes by over 75% by implementation of an RF stock location system.

• Implemented unattended scale station which interfaced carton weight info to the mainframe.

• Designed, developed, and implemented UPC labels using LLWIN and Monarch 2095 software.

• Designed, developed, and implemented UCC128 labels using TL Ashford in RPG III/400 programs.

• Responsible for moving source code through Aldon Management.

• Created data conversion programs to move data from legacy mainframe to new SAP ERP system.

• Develop and maintain programs in the Ron Lynn Management Systems for all departments.

E. S. Originals, New York, New York 1995- 1995

Senior Programmer/Analyst

• Created Air Freight Authorization System using RPG II/III.

• Developed and maintain Sales Analysis programs for shoe division.

• Maintained EDI(Gentran), AR, AP, GL, invoicing, sales, order, and purchase order modules.

• Provided direction and mentoring during system performance issues.

Young World, Bayonne, New Jersey 1993- 1993

Senior Programmer/Analyst

• Developed programs to interface payroll information to JD Edwards using RPG II/III.

• Maintained an existing Retail Point of Sale (POS) on AS400 and System 36.

Kem ManufacturingCo, Inc., Fair Lawn, New Jersey 1990- 1993

Assistant Data Processing Manager

• Installed all packages, system releases, and PTF's on the AS400 including conversion from System 38.

• Increased picking productivity, invoicing, and physical inventory accuracy by 85% by implementation of a bar-coded Inventory Control System using RPG II/III and CL.

• Reduced costs by 75% by the implementation of an online Credit and Order Entry System.

• Member of the I.T. Steering, Inventory Control, and Barcode Committees.

• Maintained programs in Mapics using RPG III.

• Reduced costs by 75% by the implementation of an online Credit and Order Entry System.

Polo Ralph Lauren, Moonache, New Jersey 1989- 1990

Senior Programmer/Analyst

• Developed an Executive Information Reporting system using RPG III.

• Developed and implemented online Sales Analysis reporting and Merchandising system.

Parklane Hosiery, Teterboro, New Jersey 1988- 1989

Programmer/Analyst

• Developed an order entry which allowed one order to be sent to 450 stores.

• Converted data from a Wang System to AS400 using RPG III.

Liz Claiborne, North Bergen, New Jersey 1983- 1988

Programmer/Analyst

• Programmed credit system for startup Cosmetics division.

• Wrote system application to monitor system file/program cross references using RPG III and CL.

• Modified various programs including those for: inventory control, warehousing, Sales Analysis, production planning, AP, AR, Customer Service, Order Processing, and Order Entry.

EDUCATION: A.A.S., PASSAIC COUNTY COMMUNITY COLLEGE

Contact this candidate