Service Sales
Resume:
LORANN MOORE
********@*******.***
AS/400 Consumer Products Goods Programmer/Analyst
• Consumer Products Goods (CPG) Information Technology professional with extensive experience
in CPG IT.
• Specialize in a full range of products and programs involving the areas of analysis, design,
development, testing, maintenance, and production support of software on the AS/400.
• Gather all information (analysis/design, development, testing and implementation) and work
closely with the user community.
• Experienced in preparation and execution of test plans, test cases and functional testing.
• Understanding client’s expectations, requirements and developing solutions.
• Ability to work independently and manage business expectations with a delivery-focused
approach to work.
• Detail oriented with good organizational and interpersonal skills, as well as a strong work ethic.
.
HARDWARE:
• AS/400
LANGUAGES/TECHNICAL SUMMARY:
• Extensive experience working with RPG ILE, RPG IV, RPGIII, RPG Free, CL, SQL Data Queues,
Triggers, and FTP.
DATABASES/OPERATING SYSTEMS/UTILITIES:
• DB2/400, Forms Sprint, Embedded SQL, Query/400, Embedded SQL, OS/400, UNIX, Windows
XP/NT and MS-DOS, SDA, DBU, TL ASHFORD, HAWEYE, FTP
EXPERIENCE:
COMPUSYSTEMS; Broadview, IL February 2013 to Present
CompuSystems (CSI) was founded in 1976 and has enjoyed many years as a major registration service provider for
the convention trade show industry. We service clients from a corporate office and centralized data center in Broadview,
Illinois.
Programmer/Data Analyst:
• Responsible for designing, coding, testing, enhancing, maintaining, and debugging programs.
• Involved in meetings with Business Analysts to understand the business requirements.
• Interact with business users (requirements gathering) for program specifications .
• Work closely with the Development Manager and Business Architects on business functionalities
requirements.
• Develop web service programs to transport DB2 Database as WSDL file using SOAP on Web
Sphere.
• Verify accuracy of data, and compile spreadsheets by combining data from various systems.
Lorann Moore - page 2
DEARBORN WHOLSALE GROCERS; Chicago, IL June 1980 to February 2013
Dearborn Wholesale Grocers is a full service CPG distributor, and the largest independent grocery wholesaler in the
Chicago area. Dearborn Wholesale Grocers provides a full range of products (more than 23,000 different items) to
Supermarkets, Convenience Stores, and Mini Marts. Dearborn Wholesale Grocers uses the AS/400. This system
maintains all the data for internal business units and needs, as well as its members, providers and vendors.
Programmer/Analyst:
• Created new programs in RPG ILE, CLLE and SQLRPGLE.
• Coded programs using Free Format RPG with Embedded SQL.
• Modified existing RPG/400, and CL/400 programs and batch programs.
• Wrote and created subfile programs.
• Created new database files using SQL in AS/400.
• Responsible for changes to existing RPG/CL/RPGLE FREE programs according to the specs.
• Participated in design walkthroughs with appropriate groups and related users to verify accuracy
of design.
• Developed programs to generate labels and update transaction and inventory files upon scanning
orders using hand-held scanners.
• Designed and developed user maintenance screens and files for the order categorization.
• Developed programs to generate month end reports for sales analysis.
• Developed new sets of programs to generate assembly reports and labels at the point of
assembling orders.
• Automated programs to generated Bill of Lading and shipping documents at the point of billing.
• Automated weekly and monthly reports to be FTP to the external server.
• Involved in meeting with QA teams to discuss defects assigned.
• Authored step-by-step training materials in a user friendly approach.
• Reduced turnover through proper application software training.
• Supported production issues and resolved them quickly.
• Automation to clean up and create backups for specific transaction files used for EDI processing.
• Worked on TL Ashford for creating labels.
• MS Office is used to track the object list and download/uploaded the data (FTP) from Excel to the
AS400 system physical files and vice-versa.
Environment:
IBM AS/400 V5R3 (iSeries), RPGIV/RPG ILE, RPGIII/RPG/400, Embedded SQL, CLLE, CL/400,
COBOL/400, SDA, RLU, Hawkeye, Query/400, SQL/400, DB2/400 and Implementer.
Technical Skills:
• MS Word (full suite)
• MS Excel
• Database Management/Database Design
• Customer Needs Assessments
• GUI Tools
REFERENCES:
• Available on request.
Contact this candidate