Frank J. French

234 Cedar Creek Lane

Snow Hill, NC  28580

Work: (919) 735-8012

Home: (252) 747-8041

[email protected]

http://www.geocities.com/frankjfrench/

OBJECTIVE:

To use and apply specialized skills, training and knowledge in a full time position as a Senior Business/Systems Analyst, with potential for advancement into a management position or an Information Systems Manager in an IBM  System i environment.   

SKILLS:

> Over twelve years experience as a systems analyst and/or programmer on IBM midrange systems (System i , iSeries).
> Strong modular programming skills using RPG IV RPG/400 and CL in the Integrated Language Environment (ILE). 
> Very experienced AS/400 subfile programmer using IBM Screen Design Aid (SDA).
> Efficient with structured query language (SQL) and SEQUEL.

> Understand and use embedded SQL in RPG code.  
> Very knowledgeable of Query/400 and Query for DB2/400.

> Some exposure to IBM WebFacing Tool.

> Basic understanding of IBM Websphere Host On_Demand.

> Some exposure to IBM iSeries Access for Web.

> Hands on experience using commitment control, referential integrity and database triggers in a DB2/400 environment.

> Proficient with Open Query File (OPNQRYF) command.

> Intermediate COBOL programming skills (AS/400 iSeries Platform).

> Working knowledge of EXTOL's EDI Integrator/Translator.
> Very Experienced Microsoft Access developer.

> Basic understanding of XML formatting, HTML, and VB coding.
> Working knowledge of Novell Netware, SQL Server and Windows Server 2003.

PACKAGED SOFTWARE:

Aldon- Change Management

CDR (Creative Data Research)- Distribution/Warehousing & Logistics

Extol- EDI Translation

Global Software- Financial Applications

IDS (Integrated Distribution Solutions)-  Enterprise/Distribution/Warehousing & Logistics 

Kronos- Time & Attendance

ODS- Order Management and MRP/CRM

Optimum Solutions- Payroll and HR
PkMS- Distribution/Warehousing & Logistics
Real Vision (RVI)- Print/Document Management

SEQUEL- SQL Report Writer

PROFESSIONAL EXPERIENCE:

> Senior Analyst/Programmer

> Southco Distributing Company, Goldsboro, NC

> November 19, 2001 - Present

Hired to help with the analysis and conversion of their ERP/CRM systems as a result of their current software vendor being purchased by Integrated Distribution Solutions, Inc.  The initial phase of the conversion involved working closely with Managers and end users developing “conversion programs” to move required data into the new systems.  The second phase involved designing and developing custom applications to provide information to the Companies customers that were not available from the base package.  The third phase of the conversion involved the implementation of hand held and mobile RF terminals for real time inventory management and tracking, and finally the installation of an IBM Netfinity Server to allow mining of a DB2/400 database that will enable customers, via the internet, to place orders on line, inquire on order status, and check inventory balances.    

> Senior Systems Analyst/Programmer

> Hampton Industries, Inc., Kinston, NC

> June 1998 – October 31, 2001

One of several Business Analysts responsible for the implementation of new legacy, enterprise and warehouse systems on multiple iSeries servers, Novell and Windows/NT networks.  The new systems were implemented to replace the entire corporate Information Systems infrastructure that was running on an Amdahl mainframe. I worked very closely with end users and Managers to determine specific business requirements and then worked with application developers to modify existing systems and create new systems to meet those needs.  Specifically, I worked with the Payroll Department to create procedures that made the Department completely independent of the Information Systems Department. This required modifications to the purchased payroll systems and new “add on” applications.  Also, I worked with warehouse personnel (Managers, Supervisors, and shop floor) to design and develop the interface for a distribution center scale system (using ILE RPG, RPG IV and data queues) to a purchased inventory management system (PkMS).  I was also involved in the analysis and implementation and configuration of their Accounts Payable and General Ledger Systems.  All legacy systems (Order Entry/Accounts Receivable, Payables, Payroll and General Leger) were purchased from different software vendors and ran on multiple AS/400 servers which necessitated the need for bridge applications to interface the systems.  I worked with Managers from these departments to help design and development certain interfaces for these applications.    

> I.S. Manager/Systems Analyst/Programmer

> Goldtex, Inc., Goldsboro, NC

> September 1987 – April 1998

Responsible for maintaining an IBM Ststem/36 and IBM AS/400 model E35 with sixty locally attached devices, two on-line remote sites, and five PC based manufacturing process control systems. Developed, implemented and maintained many AS/400 software packages including: Inventory Management, planning and scheduling, order entry, invoicing, sales analysis, cost, accounts receivable/payable, general ledger, payroll, and time and attendance. Developed most applications in-house using a mixture of RPG III and RPG/400/IV.  Was involved in all aspects of application development from initial concept through training and support.  Applications developed on an IBM/System/36 were migrated to the AS/400 and some eventually converted to native AS/400applications, which in most cases required the re-engineering of the application. Developed electronic data interchange systems for transmitting orders, invoices and payroll data to banks and ACH host systems. Supervised two application programmers and one system operator.


> Staff Programmer/Analyst

> Cates Pickles, Division of Dean Foods, Faison, NC

> October 1985 – August 1987

Intermediate level programmer/analyst. Responsible for the design, coding, testing, implementation, maintenance and support of business systems on an IBM System/36.

EDUCATION:

Mount Olive College, Mt. Olive, NC
Pursuing Bachelors in Business Management

Business Management (32 semester hours remaining)

Wayne Community College, Goldsboro, NC
Associate of Applied Science - Electronic Data Processing

Electronic Data Processing, Business Concentration, GPA 3.5 (Phi Theta Kappa)

Completed Dale Carnegie Speaking and Human Relations Course. (March 1996)
Completed IBM's CL Programming Workshop.  (January 1995)
Completed IBM's AS/400 RPG IV Programming Course. (August 2000)
Completed IBM's AS/400 Advanced Topics for RPG IV Programmers. (January 2001)

INTERESTS:

Web page design, HTML, XML and JAVA languages, Internet/intranet applications, On-line banking systems.

REFERENCES:

Technical and/or personal references are available on request.