REETHAMMA GEORGE

*** ****** ***** ****, ******, IL 60143 630-***-**** adhrdy@r.postjobfree.com

SUMMARY

Professional with excellent educational background, and over 19 years of comprehensive AS/400 & Lotus Notes experience, including programming, analysis, and operations. Extensive experience in various business modules such as Accounts Receivables, Accounts Payables, General Ledger, Sales, Purchasing, Inventory, Order Entry, and others. Ability to work independently and as a team player. Enjoy working with people. Ability to learn quickly new software, procedures, and methods.

TECHNICAL SKILLS

Programming Languages: Free RPG, RPGLE, RPGII, RPGIII, CL, OCL, SQL, AS/400 Query, LOTUS Script,

Lotus Formula, JAVA

Operating Systems: OS/400, Windows, Domino 8.5.1

ERP Packages/Software: DPS9000, MOVEX, PRMS, WynStar, Lotus Notes, GOANYWHERE, WMS, Implementor, Robot, Turnover

EDUCATION: B.S. in Medical Technology — University of Illinois, Chicago.

Certificate in Computer Programming AS400— CSI, Skokie.

Certificate in Lotus Notes Intermediate Development

Certificate in SQL Query – CST Training, Schaumburg.

PROFESSIONAL EXPERIENCE:

North America Corporation. Northbrook, IL 03/18- Present

Industry: Distribution

AS400 System Analyst

Conducted system analysis and design of the following business modules:

AR/AP, Order Entry, Distribution, Sales Analysis.

Projects:

Worked on multiple data projects transferring data from different FTP servers to iSeries to manipulate, process and update data in iSeries files.

Created many summary files for the top management to use it with “BI” tools and other Third-Party Tools to analyze the data to get better understanding of our warehouse operations and customer buying patterns.

Worked along with our EDI consultant to put together a new process for one of our major customers.

Silveredge Consulting. Westchester, IL 02/13- 02/17

Industry: Consulting

AS400 Staff Consultant

Conducted system analysis and design of the following business modules:

Order Entry, Distribution, Sales Analysis.

Project: International Invoice Print program

Developed a demand on Invoice print program to allow shipping to print invoices on demand for international orders

Created a Reprint function, so shipping can reprint demand invoices, as they needed.

Create an inquiry screen showing open international orders & demand on invoice data

Change nightly invoice program to use temporary demand invoice number as the main invoice number and update files

Project: Created Journal Utility

Created Journal (GETJRN) utility to be used by PRMS base support to display the journal of a file in the format of the file being journaled.

This utility would allow for easier analysis of journaled data for trouble-shooting purposes.

Project: Medical device excise Tax (MDET)

Developed programs to generate MDET data (customer, Product, Sales) that will be pulled from PRMS

and sent to target server using MBOX interface.

Automate the transfer (FTP) of the MDET data using interface MBOX to servers.

Project: Pricing Data extraction

Get data from business that currently does not reside on PRMS through spreadsheet and convert it to AS400 data and merge custom data & PRMS Data to create files to send to third party software.

Create programs that will extract pricing data from PRMS, summarize it according to business requirements and transmit the final data to third party software for analysis via FTP.

Project: Company Logo & Name change on all business forms

Changed company logo & name on all our forms such as – Invoice, Credit, Fax cover, Order form etc.

Recreated all these forms in Excel and converted to AS400 utility Overlay, which can be used by Printer files.

Transilwrap, Inc., Franklin Park, IL 07/05-02/13

Industry: Manufacturing and Plastic Conversion

AS400 & Lotus Notes Programmer/Analyst

MOVEX ERP – AS/400:

Conducted system analysis and design of the following business modules:

Order Entry, Distribution, Manufacturing, Warehouse Management, Accounting, Tax, Sales Analysis and Forecasting

Evaluated operation methods and procedures:

Worked with subject matter experts and end users to identify and document existing business functions, required enhancements and technical solutions

Developed, tested, implemented and maintained MOVEX and legacy business applications using RPGII, RPG400, RPGLE and CL languages.

Contributed to increasing company’s profitability by automating manual processes and enhancing existing core business applications:

-Enhanced Customer Maintenance application that maintains tax-exempt status and affects order hold business logic

-Improved Item Master Maintenance and Buyers applications by incorporating suppliers’ Item Number, price and other properties

-Modified Order Entry application to store Ship-to and Bill-to information at shipment time

-Customized Manufacturing Order Application, enabled mass update functions, auto skid assignment and optimized material allocation process

-Improved user interfaces in Quality Control application that resulted in providing users with more concise and accurate information

-Facilitated immediate customer and order information updates between Movex and Legacy system by invoking trigger programs

-Made major enhancements in Inventory Handing applications by developing programs that work wireless guns and portable label printers and scanners

-Multiple improvements to Finance, Sales Analysis and Forecasting reports and inquiry programs to provide business users with easier access to the pertinent information.

Lotus Notes:

Developed an application to provide the managers of the Research & Development, Marketing and Purchasing, a user-friendly method of initiating, reporting and tracking new product development projects and trials.

Developed an Application to provide a method of requesting and tracking the status of maintenance work orders as generated by the Corporate maintenance department.

Developed an efficient method of reporting quality-related problems that occur internally at Transilwrap and externally when a customer complaint is registered. Once the issue is recorded and analyzed, corrective action can be carried out through workflow set up

Developed database to track and schedule various ISO-9002 audits to Transilwrap systems and documents.

Created HR Application to automate time and attendance collection for exempt employees by using electronic version of paper timesheet.

Automated an application to collect data on company car mileage & usage by salesmen which saved a lot of data entry time.

Ammeraal Beltech, USA, Skokie, IL 03/2000 — 05/2005

Programmer/Analyst –Notes Developer

AS/400

·Developed new sub file and report programs using RPG and CL.

·Modified existing RPG and CL programs.

·Worked extensively with SQL and Queries.

·Program Testing, and Debugging.

·Worked on all business modules of the company, such as

Accounts Receivables, Accounts Payables, General

Ledger, Sales, Purchasing, Inventory, Order Entry, and others.

·Provided User Support.

·Created menus for users according to their needs.

·AS/400 operations such as Back-Up from tape, Restore, System Power-Down, etc.

Lotus Notes

·Worked as Lotus Notes Designer and Administrator.

·Created Databases with complex views and design elements.

·Registered users and groups.

·Database Backup and Restore.

Help Desk

·Provided User Support at all levels of the company (from the CEO downwards — 250 users).

·Help users with network and printer problems.

· Installing Applications such as Lotus Notes, VPN, Client Access, Norton Anti-

Virus software through TCP/IP

REFERENCES: Available upon Request.

Contact this candidate