Avinash Sastry - Consulting - http://maxpages.com/itconsultants/Avinash

SUMMARY:
Avinash has over 3 years of experience in software application design and development on AS/400 systems. He has worked on various financial, material management and sales applications. He has a solid business background and the technical ability to take user requirements and develop systems rapidly. Avinash has excellent communication skills and is a team player.

SKILLS:
Hardware: AS/400
O. S.: OS/400, WINDOWS 95/ 3.1, MS-DOS.
Languages: ILE/RPG, RPG/400, RPG III, CL/400 , SQL/400
RDBMS: DB2/400
Tools: Hawkeye,Turnover, PDM, SEU, RLU, DBU, SDA, DFU

EXPERIENCE:

June 99 - Oct 99
Consultant - Object Resources, Overland Park, KS
Countrywide Home Loans, Simi Valley, CA
REO Management System - AS/400 Search/Sort Changes
This project was performed for the REO area. It consisted of a set of technical changes and corrections to existing AS/400 functionality associated with REO properties. After implementation the resulting responsiveness to inquiries about properties will allow for both customer service and REO personnel to be more efficient in handling this area of their responsibilities.
Role:

Design the project so that the overhead on the system is reduced and response time is quicker.

Used SDA to make extensive changes to the existing display files.

Used DBU for working with the database files.

Used DDS for creating the different logical files.

Used TURNOVER to promote the objects to the production level.

Used subfile with overlay concept for user interface.

Environment: AS/400, ILE/RPG, CL/400, DB2/400, DBU, SDA, Hawkeye, Turnover, SEU.

Sep 98 - May 99
Software Engineer - SIBYL Information Systems(I) Pvt. Ltd., India
Madurai Bank - Banking Management System
A banking system application which provides for transaction entries encompassing banking transactions like credit, debit, deposits etc. Interest is calculated as per the account type and time. The project consisted of developing transaction modules, file maintenance & query module, reports module and house keeping module.
Role:

DDS coding of the physical files.

Design of user interface screens using SDA for the end-user facilitating entry of various transactions.

Coding of interest calculation and account maturity module for term deposits based on the period of deposit and type using ILE/RPG .
The key features incorporated in the module are:

data queues used for updating the database

data areas for auto-generation of unique transaction numbers.

event-specific triggers for automatically updating the related database files.

subfiles with overlay concept for user-interface
Team size:14
Environment: AS/400, ILE/RPG, DB2/400, CL/400, OS/400, SDA, RLU, SEU

Jan 98 to Aug 98
Software Engineer - SIBYL Information Systems(I) Pvt. Ltd., India
Visaka Enterprises – Warehouse Management System
A warehouse management system application wherein the stores and spares department manages the procurement of raw material and the automation of the same was achieved here.
The project comprised developing transaction modules, file maintenance & query modules and the reports module and housekeeping module.
Role:

Following reports are generated such as Purchase orders, Reorder reports, Stock ledger, Excess stock, Stock movement, ABC analysis and Stock status using RLU.

Creating the logical files using DDS.

Used data areas for automatic generation of purchase order numbers.

Used data structures for date validations

Used window subfiles with overlay concept onto the single record format screens to fetch the relevant records for inquiry purpose.

Environment: AS/400, OS/400 , RPG/400 , DB2/400 , CL/400

Jan 97 to Dec 97
Software Engineer - SIBYL Information Systems(I) Pvt. Ltd., India
Minesoft Corporation - Sales Order Processing
The organization consists of the Sales & Marketing department, the production department, the stores & spares department and the finance department. The Sales & Marketing department looks after the processing of the sales order and the automation of the same was achieved here.
The project consisted of the following modules, 1. The Master Module 2. The Transaction Module 3. Reports Module
Role:
Generation of the following reports using RLU:

Development of Order Reports, Pending Order Report, Movement of items, Price List, Stock List, Region Wise Sales Reports.

Used data areas used for automatic generation of purchase order numbers , invoice numbers etc.

Used data structures for overcoming run time errors.

Used open query files feature of CL/400 for dynamic selection of records.

Environment: AS/400, RPG/400, DB2/400, CL/400, OS/400

April 96- Dec 96
Software Engineer - SIBYL Information Systems(I) Pvt. Ltd., India
Client: SIRIS - Inventory Control
This maintains the balance between required inventory & available inventory and provides the functional support to material department. Maintains comprehensive information on all inventory items, giving up-to-date status on their availability, usage, receipt, on-order, pending inspection, committed quantities etc.,
Role:

Involved in DDS coding of DB2/400 and created Physical files, Logical files.

Developed CL/400 Programs using Open query files, Error handling (Monitoring messages)

Developed applications in RPG/400, used Subfile techniques, Data structures, Arrays, Data areas etc.,

Generated Reports using RLU and related RPG programs
Environment: AS/400, OS/400, RPG/400, CL/400,

EDUCATION:
Bachelors of Engineering from Nagpur University, India

IT Resources
9401 W. Indian Creek Pkwy., Suite 1100
Overland Park	Kansas	66210
USA
(913) 438-7140 ext. 112
Fax (913) 438-7130
patty.w@orimail.com

Sign Guestbook

View Guestbook

Visitors: 01578

Page Updated Wed Jan 26, 2000 12:42pm EST