IT: iSeries, AS/400 Analyst

KEY SKILLS

Programming Languages:

RPG/*** (** yrs: II, III, IV/ILE, /FREE, SQLRPGLE), CL/400, SQL/400, HTML

Applications and Software Packages:

AS/400 / iSeries:

Wynne RentalMan(5yrs), JDA Merchandise Management(5yrs), Aldon LMI(3yrs), Relavis(1yr), ICMS Telephony(1yr), DB2/400(12yrs), Query/400, FTP

Windows:

Gentran EDI Server (2yrs), Sterling WebSuites(2yrs), Cyclone IDX (2 yrs), i2 Trade Matrix: Rhythm Demand Planner module(1yr), IIS (1yr), SQL7 (1yr), WebSphere Development Studio Client (3yrs), Microsoft Office Suite, Lotus Notes, Client Access

KEY ATTRIBUTES

• Committed to deepening and widening my software development skills.

• Comfortable working in an evolving environment with new/unfamiliar tools.

• Demonstrated ability to develop a rapport with business users/customers.

INDUSTRY EXPERIENCE

Sr. Programmer / Analyst - RSC Rental Equipment

Houston, TX. August 2005 – Present Industry: Rental Services

Team Projects:

• Creation of an inside sales system that tracks leads and employee statistics. The new system distributes the workload for adding new customers and rewarding employees that assist in the process more efficiently, and was a factor in increasing sales in the first year of operation.

• Creation and maintenance of database interfaces (via stored procedures) to an SQL Server database for mobile devices. By integrating our core operational systems with a remote field service application, technicians are able to access real-time data, improving overall effectiveness while reducing maintenance costs.

• Maintenance of database interfaces between iSeres, third parties Dodge and PEC, and Relavis Notes server. Coordinating data between multiple sources gives the sales team a broad source of information to make better decisions.

• Creation of custom Sales Prospects Repository. Creation of a repository that can list potential clients thru internal and external sources. The data can be accessed by all company locations and workloads assigned based on geographic data.

Individual Projects:

• Creation of a credit card information repository within the Wynne rental system. This helps speed the process of customer checkout for recurring accounts and customers while keeping the data encrypted with PCI compliance.

• Creation and maintenance of a data synchronization process. This recurring data refresh process is between production and multiple test environments on separate machines using data subsets. This allows for a small and current database for testing and development mirroring production while using less disk space and led to an overall reduction in release defects.

Responsibilities:

• Maintenance and development of the Wynne Systems rental package RentalMan. Numerous changes to all aspects of the Wynne package. Example areas of the package include rentals, purchases, exchanges (screens and hand held devices), and financial reporting.

• Developing under a Sarbanes-Oxley (SOX) compliant software development life cycle. This was implemented while transitioning from a privately held company to a public company.

• QA Unit Testing. SOX compliant quarterly testing of the Wynne package and its modifications.

Software Engineer - Garden Ridge

Houston, TX. May 2002 – August 2005 Industry: Retail

EDI Technical Lead:

• Migration and support of 1100+ vendors to Web based EDI solution.

• New vendor setups and mapping implementation and support.

• Maintenance of two EDI Websites, and four Win2000 servers,

• JDA EDI interface support for 810, 850, 856, and 997 documents maintaining X12 standards compliance.

• ASP and VB code updates to third party software.

• Creation of ASN interfaces between Gentran and JDA.

• Training of new EDI staff

RPG & CL Programming (JDA MMS)

• New logic to warehouse distribution based on ASNs.

• Rewrite of logic and user interface for replenishment in purchasing system.

• New development of gift card processing.

• Update UPC level information to GTIN standards.

• AP, PO, Store Data Interfacing, and POS support

Programmer / Analyst - Westpoint Stevens

Clemson, SC. February 2001 – May 2002 Industry: Manufacturing - Textiles

i2 Database Administrator:

• Administration, maintenance, and security of i2 Rhythm Demand Planner Module 5.2 and Win2000 servers.

• Database Redesign, Migration of i2 database to new server hardware, Creation of test databases.

RPG & CL Programming (Custom Software):

• AS/400 integration of legacy Cobol programs and RPG development.

• Upgrade of i2 Demand Planner to version 5.2.

Programmer - Oshman's Sporting Goods

Houston, TX. September 1999 – January 2001 Industry: Retail

RPG & CL Programming (JDA MMS):

• AP, POS, Purchase Order, Replenishment, & Warehousing module modifications.

• On-call problem solving. Shared responsibility for 24 hour processing.

• JDA maintenance and support in RPG II, III, and RPG IV / ILE.

Consultant / Programmer – Ciber

Houston, TX. May 1998 - August 1999 Industry: Consulting

Client: IBM / DPI May 1998 - July 1999 Industry: Software Development - Telecommunications

RPG & CL Programming (TFS, ICMS):

• Updates of telecommunications software package ICMS.

• Y2K upgrade for telecommunications software package TFS.

EDUCATION

Bachelor of Science

University of Houston, College of Technology Graduation: Spring, 1998

Major: Information Systems Technology

Minor: Industrial Supervision

Contact this candidate