Engineer Manager

Gayathri Rao Phone: 847-***-****

Email: ******@*****.***

Professional Profile:

iSeries/ AS/400 expert with over 13 years of experience.

Roles performed include Systems Analyst/ Developer on System i including

System administration and Helpdesk Support.

Considered a "knowledge engineer," with various industry exposure -

Manufacturing, Hospitality, Telecommunications, Banking and Finance.

Have strong technical skills complemented by excellent communication

skills.

Technologies:

. iSeries 5.4

. JD Edwards EnterpriseOne 8.12

. OS400 (V5.4), ILE RPG, CL, SQL/400, DB2/400, Query Manager

. MQSeries (V5.3)

. ERP, KBM by Infor (Manufacturing)

. Websphere Development Studio Client

. ROBOT job scheduler

. MRC

. iTera Vault - Remote journaling, Backup and recovery

. IBM BRMS

. TURNOVER, HAWKEYE, PDM, SDA, RLU, DBU, DFU, SEU, DDS,

. MS Visio, Word, Excel, PowerPoint

. File Transfer Protocol (FTP) Batch & Interactive

. Integrated File System (IFS)

. XML, HTML (Limited Exposure)

. Erwin (Data Dictionary)

. ACOM EZ Designer

. MPLUS

. SAP access

. TLABARCODE

. RJS for data transfer between systems

. Quick command for Labels (QLS)

. Worldclass RF scanners

Training/ Certification:

. IBM iSeries System Adminstration Certification

. IBM MQ Series System Administrator Certification

. JD Edwards Enterprise One 8.12 Certification from Oracle Corporation

. ERP- MOVEX v9.8 by Intentia, Sweden

Awards:

Medline Industries: Spirit of caring award - recognition for "above and

beyond attitude"

McLeaodUSA: Best Employee of the year award for the year 1999.

Professional Experience

iSeries (Mapics) / JD Edwards Independent Consultant

September 2012 to June 2013

Responsibilities include:

Conversion of the Kanban AS400 Application System from Mapics ERP (AS400)

to JDE 8.12

. Analyze and work with AS400 Kanban applications in Mapics

. Build new applications in JDE using version 8.12

. Data conversion programs

Medline Industries, IL

Systems Analyst and Developer /Tech Lead

Oct 2006 to September 2012

Responsibilities include:

Application Analysis, Design and Development of various applications using

ILE RPG (free form and embedded SQL) CL, DDS, DBU, SQL, WRKQRY, Operations

navigator, RAD (Rational Application development).

. Part of KBM (ERP software) Manufacturing team involved in designing

(BPD, BSD), development (Using RPGLE, CL, DDS, SQL, DBU, RAD,

Operations Navigator) testing (Unit and String) and UAT for various

applications used in the manufacturing industry.

. Backbone of a high profile project involving customs and Border patrol

(CBP) and FDA validation helping goods cross the US /Mexico border.

Working with Jamco International.

. Worked on In house vendor label manufacturing and setup using QLS

software saving company million dollars every year.

. Worked with ACOM designer to convert word documents into AS400

automated documents saving time and money for the business user group.

. Setup and responsible for iTera backup software for backup (using

remote journaling)

. Worked on integrating RPG process using JAVA and XI. Tools used

include WDSC (Eclipse IDE), Web services (SOA technology) to

communicate with XI Service. Used Java technology from RPG to interact

and send data to SAP for Pedigree Process (Drug FDA regulation)

. Constantly work with the Quality department in the areas of document

control, Protocols and validation of Sterilization process and Insert

Printing process.

. Leading the Color Insert printing process on the iSeries side,

. Manufacturing work experience includes BOM management, Work order

packet management, Wave management, QPC and Carton changes, Material

group and division consolidation, Rush order processing and many more.

. Fully responsible for DR recovery process - Setup DR iSeries box,

Involved in DR recovery documentation, Mock conversion, obtaining

licenses and keys, Restore backups to the DR box.

. Lead the BRMS project (Backup and Recovery Media services) for

unmonitored backup of Production system,

. Setting up license keys for OS products.

. Setting up users on the ERP software.

. Setup iTera (Vision solutions) vault for backup/ journaling of

production system.

. Worked with TIMI Tools, ROBOT job scheduler, SAP, KBM ERP software,

MRC, TLABARCODE software for barcode labels etc

Shell Vacations LLC, Northbrook, IL

Software Engineer

May 2002 to Oct 2006

At Shell Vacations I was involved in designing, developing and testing

various applications used in the hospitality industry. Systems worked on

include Members Reservation System, Contract Processing system and PMS

system used at various resorts.

Responsibilities include:

. MQSeries System Administration - underwent IBM training

. Application Analysis, Design and Development of various hospitality

applications like Member reservations, Point based membership using

ILE RPG and CL.

. Developing MQSeries applications using MQI to communicate between the

AS400 and the Sales KIOSK to display Membership information

. Unit & Integration testing and Implementation of solutions as

requested by the business users.

. Performance Tuning of various applications.

. Data mining and analysis of data using Query Manager and SQL

. Worked on Erwin data model to provide file definitions to the Data

Mart from the AS400

McLeodUSA ATS Division, Cedar Rapids IA

AS400 Consultant

Oct 1998 - April 2001

Team Player in the ATS team involved in creating new applications using ILE

PRG, CL/400, SQL/400, PDM, SDA for the DTG, SQL/400, XML conversion project

used for telecommunications and mainly involved line feeds.

Responsibilities include:

. Examples of some project include

1. Line Equipment Grid Process - Involved creation of User

interface screens and triggering CL and RPG process based on

user selection.

2. Toll feed Analysis Process - This involved generating user

report based on data feed.

3. Various performance enhancements to existing applications

. Invoice Archiving consisted of exporting customer invoices to the we

site from the 400 using XML, DJDE and MQSeries

. Modified applications to generate XML from AS400 data.

. Worked on the Xerox DJDE print format used for online Invoice/Bill

Generation.

. Automation of Magnetic Media process - Automating the process of

transferring customer's paper bill data on to Magnetic Media's like

CD, Diskettes.

. Batch FTP of Customers Invoices to the UNIX servers from AS/400

Education

. Bachelor of Science (University Rank Holder) University of Chennai,

India

. Certification in Computer Applications United C-LAN, Chennai, India

. Post Graduate Diploma in Financial Management New Delhi Management

School, India

Contact this candidate