Software Management, AS400 development/analysis/consulting
Resume:
R. Worth Allen
**** ******** ***** ***** ***/***-6970 Cellular
Matthews, NC 28105
Email: **********@***.***
Professional Summary
Senior Consultant and information technology specialist with over twenty-five years of diversified computer experience including extensive skills in software design, analysis, programming, and implementation. Designed and implemented complex systems and relational databases increasing client return on investment and IT efficiency. Worked and communicated with senior executives, diverse user groups, vendors, customers, and technical staffs as either a team member or an independent consultant.
SKILLS SUMMARY
Industry
Hardware Languages Systems Experience
AS/400 RPGILE* SOX Financial
System 38 RPG 400 Hawkeye Retail
System 36 RPG 3 DBU Distribution
RPG 2 Harbinger/Premenos Manufacturing
CL Data Warehousing Banking
RPGIV DB2/400 Transportation
SQL SDLC Textiles
RPG Free Change Management Insurance
* IBM Certified Specialist
Professional Experience
Selray Systems, Inc., Charlotte, NC 1995 – Present
Owner/President
Below is a list of contracts since 1995:
Hanes Brands Inc. – Winston-Salem - 2014 to 2015
Development and analysis using SQL, RPG Free, and RPG IV ILE on various data bases and software.
Organized, analyzed, and prioritized user requests and problems.
Researched data and software requirements to meet user needs.
Used MKS/Implementer change management software and adhere to SOX standards.
Kubota – Gainesville, GA – 2013 - 2014
Business Analysis and Development on BPCS software ERP
package. Worked with users and technical staff doing analysis, design, development,
and troubleshooting using RPG IV ILE, RPG Free, and SQL to meet project needs and
modernize software.
R. Worth Allen
Page 2 of 7
Atotech –Rock Hill, SC 2013
• Software analysis, business analysis, trouble shooting, documentation. User support,
training, and testing of existing software.
Humana Insurance Co – Lancaster, SC 2011/2012
Business Analysis and Development using SQL, RPG IV ILE and RPG Free on custom in house developed software. Performed both new development and modifications to existing software. Also developed in RPG Free.
Used Turnover/Soft Landing change management software.
EZGO/Textron – Augusta, GA – 2011 second contract
Business Analysis and Development on JBA software ERP
package. Worked with users and technical staff doing analysis, design, development,
and troubleshooting using RPG IV ILE, RPG Free, and SQL to meet project needs and
modernize software.
Used Soft Landing/Turnover software for change management.
Palmetto Bank – Laurens, SC 2010
Business Analysis and Development using SQL and RPG IV ILE on custom in house developed software.
Maintained and installed new versions of FISERV software..
Used MKS/Implementer change management software.
Pike Electric Company – Mt Airy, NC -2008/2009 second contract
Business Analysis and Development using SQL, RPG Free, and RPG IV ILE on various data bases and software.
Organized, analyzed, and prioritized user requests and problems.
Researched data and software requirements to meet user needs.
Used MKS/Implementer change management software and adhere to SOX standards.
United Guaranty Insurance Company – Greensboro, NC - 2008
Business Analysis and Development to keep in house
developed software current and leading edge.
Worked with users and technical staff doing analysis, design, development,
and troubleshooting using RPG IV ILE, RPG Free, and SQL to meet project needs.
Used Soft Landing/Turnover for change management.
EZGO/Textron – Augusta, GA – 2007-2008
Business Analysis and Development on JBA software ERP
package.
Worked with users and technical staff doing analysis, design, development,
and troubleshooting using RPG IV ILE, RPG Free, and SQL to meet project needs and
modernize software.
Used Soft Landing/Turnover software for change management.
Pike Electric Company – Mt Airy, NC 2006-2007
Business Analysis and Development using SQL on various
data bases and software.
Organized, analyzed, and prioritized user requests and problems.
R. Worth Allen
Page 3 of 7
Researched data and software requirements to meet user needs.
Used SQL and RPG IV ILE to accomplish projects..
Helped implement MKS/Implementer change management software and SOX requirements.
Preferred People Staffing – Charlotte, NC - 2006
Consultant/Developer/Analyst – AS400 – RPGILE
Preferred is day labor staffing company with an AS400, packaged software, and no IT staff.
Analyzed their software problems, designed, developed, and implemented solutions.
Consulted with them on IT issues and helped design procedures and processes to obtain better results from their system.
Time Warner Cable – Charlotte, NC- 2005
Developer/Analyst – AS400 – RPG ILE
Worked with users and staff to resolve issues and requests.
Solved help desk calls with problem situations. Performed small projects for new development
Tyco/Scott Health & Safety – Monroe, NC – 2004-2005
Safety Products - Manufacturer – Developer/Analyst – AS400 – RPG IV
Maintained MAPICS software customizing it to meet client needs.
Performed impact analysis, research, gathered requirements, programmed, tested, and implemented solutions.
Also analyzed procedures and security to meet SOX requirements.
Food Services of America – Seattle, WA - 2004
Food Distributor – Developer/Analyst – AS400 – RPG ILE, RPG Free, and SQL
Worked with interactive, embedded, and batch SQL on a Data Warehouse to increase performance and reliability.
Integrated business process flows with data warehousing data flows.
Because it was a live system extensive testing and change management was required.
Did program and procedure analysis on their data warehouse to help enhance and develop their system allowing for greater depth, detail, and faster more accurate information retrieval.
Sara Lee Textiles – Winston-Salem, NC 2001-2003
Developer/Analyst – AS400 – RPGIII and RPG IV
Modified and modernized their Supply Chain. Sara Lee is a 24/7/365 operation with plants on every continent and most time zones. Their supply chain had evolved over the years and developed cracks and loop holes.
Performed gap analysis, design, programming, testing, and implementation.
Required extensive use of change management to implement the modified processes and procedures.
R. Worth Allen
Page 4 of 7
During my tenure we closed major loop holes and problem areas allowing the corporation to do its business with greater confidence in the integrity of its data.
Belks Inc. – Charlotte, NC – 1999-2001
Retailer – Developer/Analyst – AS400 – RPG400
Y2K software conversion, analysis, modernization, and documentation.
Client had old (15 years) J D Edwards software package that had been heavily modified.
Served as part of a team to analyze and evaluate programs to replicate modifications to new Y2K compliant version of the software. The project was completed 3 months ahead of schedule.
Next, served as an independent consultant to perform Y2K conversion on a smaller legacy warehousing package. As at Wesley Hall I analyzed, reviewed, and procured software to do the conversion and managed the process from start to finish. The project was completed one month ahead of time.
From there I documented several small home grown applications that had been developed in the past without any documentation satisfying auditor requirements.
While consulting at Belks the corporation reorganized itself from over 30 entities to 1. The IRS required Belks to consolidate 30 different 1099 systems/procedures into 1. I took ownership and served as the focal point with users, staff, and management to bring data from multiple locations and platforms to 1 system for a single 1099 filing on the AS400. The new filing system was automated and used the internet to file.
Wesley Hall – Hickory, NC – 1997-1998
Furniture Manufacturer – Developer/Analyst – AS400 – RPG400
Y2Kconversion and software modernization. Company had a small staff in a remote location.
Gathered requirements, researched, designed, and made software modifications.
Managed the entire process performing quality control and any new training needed.
Biggers Brothers Food distributors – Fort Mill, SC - 1997
Developer/Analyst – AS400 – RPG400
The company had been bought by a larger organization and was growing rapidly, adding new lines of business, people, and locations.
Performed software analysis, gathered requirements, developed, and implemented changes helping to integrate IT with their business and locations thus helping increase efficiency, flow, and responsiveness of their systems.
.
American Barmag – Charlotte, NC - 1997
Textiles – AS400 – Developer/Analyst – RPG400 and EDI
Client did not have an IT staff.
Maintained and expanded BPCS software and Premenous EDI translator allowing client to continue to operate with minimal staff.
R. Worth Allen
Page 5 of 7
Tekmatex – Textiles – Charlotte, NC - 1997
Developer/Analyst – AS400 – RPG400 and EDI
Developed an EDI system from scratch to do invoicing and purchasing usingSDLC.
Analyzed and reviewed requirements, created a project plan to procure and utilize Harbinger EDI software.
Interacted with and gathered requirements from users, management, and IT staff to design procedures and processes to implement the system.
Did the necessary research, design, and development to totally integrate the Harbinger system into their JBS software system.
Trained their staff to maintain current applications and procedures and how to develop new applications and procedures.
Completed under budget and without having to add any new staff.
Lance Inc. – Charlotte, NC – 1996-1997
Food/Snack Company – Developer/Analyst – AS400 – RPG400 and EDI
Helped migrate from homegrown legacy software to BPCS software package.
Took ownership of a specific set of legacy files. Gathered requirements on the package files that would be migrated to, interacted with users and management to create a plan to determine how old numbering and coding systems would be converted to be a part of the new software’s numbering and coding systems. Wrote and tested conversion programs
Also researched, developed, and executed plans to acquire and implement an EDI system integrating it to their new software.
R B Alexander – Charlotte, NC - 1996
Import/Exporter – Developer/Analyst – AS400 – RPG400 and EDI
Developed an EDI system using SDLC to comply with mapping standards for invoicing, purchasing, and catalog sales.
Client had manual operations for interacting with foreign exporters. Every exporter had different ways it did business reflecting their countries laws and culture. Situation required researching and extensive data gathering on all major export vendors and designing/developing one system to process data into their AS400 system.
Then, train employees how to use the system.
The automation of their systems allowed them to increase sales, cut lead times, better maintain inventory, and do better forecasting/planning with the same number of employees.
Also, modified their AS400 financial system to modernize.
R. Worth Allen
Page 6 of 7
Avesta Sheffield – Richburg, SC - 1995
Stainless Steel Manufacturer – Developer/Analyst – AS400 – RPG400
Served on a team designing/developing a system to track inventory at multiple sites from raw materials to finished products for an international steel manufacturer with several recent acquisitions.
Responsible for handling all IT issues at one of their distribution centers. They had a system that had come about by merging multiple systems. They had many gaps.
Interacted with users and management to do gap analysis, communicated with corporate IT to gather requirements and design/develop/implement solutions (procedural, technical, and process).
Was successful in improving inventory control and purchasing allowing them to reduce inventory on hand while maintaining service levels.
Also, defined and developed a sales analysis driven by their customer sales application.
Below are positions held before Selray Systems.
Professional Experience (continued)
Info Systems of North Carolina, Product Manager Charlotte, NC 1988 – 1995
Managed and sold consulting services for corporate system design and troubleshooting
with local, regional and national corporations.
Modified several BPCS systems to meet unique customer specifications.
Led a team of consultants developing a complex nationwide wholesale distribution package integrated with/to EDI software.
Created a customized, affordable, simplified bill of material processor program for a novelty goods company.
Information Systems Consultant Charlotte, NC 1986 – 1988
Consulted with local and regional companies on computer technology requirements, software systems design, staff development and training.
Endata, Inc., Project Manager Charlotte, NC 1983 – 1986
Coordinated local services as part of a nationwide team charged with designing
and implementing a route accounting and distribution system for nationwide group
of beverage and food distributors.
Managed a team creating a program to manage an electronic, paperless membership
and billing system for a regional office of a national travel organization.
Quality Oil Company, Software Manager Winston-Salem, NC 1981 – 1983
Managed all software applications development and installation for an oil distribution company.
Authored a complex degree-day accounting and dispatch/delivery system for an oil company based on weather conditions, customer equipment and use patterns.
R. Worth Allen
Page 7 of 7
Pepsi-Cola Bottling Company, Data Processing Manager Charlotte, NC 1979 – 1981
Managed complex data processing systems, redesigning existing and developing new systems for timely wholesale and retail sales, ordering, and distribution.
IBM, Systems Engineer Charlotte, NC 1974 – 1979
Handled a wide range of computer systems development projects; recognized for ability
to integrate multiple goals and complete projects in an efficient, timely manner.
Co-authored a parts inventory control and vehicle analysis system, marketed nationally
to trucking companies, projecting exact amounts of inventory to have available at each site.
Designed billing and payment tracking systems for medical, hospital, service, professional office, retail and manufacturing facilities.
Developed work-in-process tracking systems for a highly time sensitive facilities.
Automated corporate billing processes, achieving increased accuracy and staff productivity.
Education
University of North Carolina at Chapel Hill
Bachelor of Science, Industrial Relations, 1974
Extensive continuing education in computer programming and software design.
Contact this candidate