Anil J Keswani

1835 Caddington Drive, # 66

Rancho Palos Verdes, CA 90275.

Phone (Residence): (310) 831-6346

(Cellular): (310) 292-6405

Email : akeswani@sbcglobal.net

· Over 20 years of experience in Information Technology on IBM mainframe, VAX and Burroughs machines as Business Analyst (4 yrs), Quality Analyst (5 yrs), Systems Analyst (7 yrs) and Application Programmer (18 yrs).

· Experienced in complete life cycle of system development. Strong technical and analytical skills. Demonstrates excellent troubleshooting, communications and people skills. Hardworking Individual who gets the job done and meets deadlines.

· Over 16 years experience on IBM Mainframe Platform with Cobol, DB2, CICS, MQ Series, IMS, VSAM, EDI(GENTRAN), QMF and debugging tools.

Objective: To obtain position as Systems or Business Analyst/Application Programmer.

Education

Bachelor degree in Mechanical Engineering from College Of Engineering, Pune, India in 1985
Advanced training on IBM mainframe (CICS, SQL, DB2, CSP) from University Of New South Wales Sydney Australia in 1989.

Technical Summary

Hardware

Operating System

Languages/Software

Years of experience

IBM Mainframe ES9000

MVS/XA

Cobol370, JCL, DB2, IMS, TSO, CICS, SQL, Expedite Base, MQ Series, QMF, GENTRAN, EXCEL

16

VAX 3500

VMS

Cobol II, FMS, DCL, Oracle

2

Burroughs 6800

MCP

Cobol

2

Professional Experience

American Honda Motors, Torrance, CA (May 1990 – Jan 2007)

Position: Consultant (Business Analyst/ System Analyst/Application Programmer)

Job responsibilities include User requirements gathering, analysis, feasibility study of applications, design, development, testing activities and implementation.
System Analysis Experience with skills to translate Business Requirements into Technical Specifications using Unified Modeling Language Use Case, Activity and Class Diagrams.
Attended JAD sessions as Business Analyst and used RAD Rational Tools.
I am responsible for maintaining quality of auto systems performance of night batch window and on-line CICS uptime.
In addition, I am responsible for maintenance enhancement and primary production on-call person for following systems:

Dealer Financial System –

This is an on-line and batch system to capture each dealer’s financial data monthly and produce composite trends and expense trends for dealer, district, zone and national. The Host legacy system was converted to DB2 using Cobol CICS DB2 and MQ.

Freight Payment System –

This system deals with Freight Payment to all the Carriers (Truck & Rail) for the movement of cars from Origin to Destination via EDI using IBM Expedite Manager and GENTRAN.

Auto Logistics Sales Information System –

In BA role attended JAD sessions using RAD methodology and UML.
Resolving discrepancies from users and creating new Management Information Reports.
Cash Drafting with banks using EDI (NACHA Format).
Developed Web based Dealer applications using MQ series for real time communication with Mainframe. Dealers request for Retail Sales, Inventory and Availability reports was converted from overnight batch process to Real time using MQ series. Every request submitted by dealer to the Mainframe message queue triggered a CICS transaction in Cobol DB2 and MQ commands which processed the request and sent back the formatted report to the Windows NT MQ server. This complete process was designed developed tested and implemented using MQ, CICS, Cobol, and DB2.
The Customer Retail information RDR from Dealers was converted to MQ by triggering a batch job when a request was submitted in a defined message queue. This batch job was triggered by MQ and ran a COBOL DB2 MQ program to process the customer info in batch jcl and sent back the acknowledgment to the dealer using the MQ Header Queue Manager, Queue Name and message id to match and close the original request.

Management Information Decision Assistance System –

· Create management reports and Key Plans that are used in executive decisions. This system uses Cobol, QMF, IMS, VSAM and Excel.

Attended JAD sessions for Data Warehouse Sales and Inventory Data Extraction using Business Objects.

Environment: IBM ES-9000 mainframe, MVS/XA, IBM PC, Windows NT, Microsoft Project, EXCEL, DB2, CICS, COBOL370, JCL, File-Aid, Abend-Aid, MQ Series, DB2 connect, Expedite Manager, EDI GENTRAN, QMF, IMS, VSAM.

Telco, India (July 1985 – April 1989)

Position: Systems engineer/Application Programmer

Job responsibilities include analysis, feasibility study of applications, design, development, testing activities and implementation. I was responsible for the following systems.

Machine Utilization System

Designing Developing Testing and Implementation to Production. This system produced reports highlighting Machine Utilization on the shop floor.

Rejection Analysis System

Developed on Oracle using SQL*PLUS, SQL*FORMS.

This system used the scrap memos from the shop and developed reports for management to show Rejection percentage.

Manufacturing Planning System

Development and Maintenance on VAX using FMS & Cobol.

This system gives details of operations done on a component to get a final part. Details like machine time, labor time, machine number, tools required.

Unit Cost System

Costing of the commercial vehicle at different levels of assembly starting from the components to sub assembly and then final assembly. I was responsible for the maintenance and enhancements to the above system.

Productivity Indicator System

This system deals with the Labor Utilization and it gives an idea of work done in Standard Man Hours. Development of overtime and absenteeism effect to use net men instead of men on roll. Reduction in stationary consumption and processor time.

Environment: VAX, VMS, Cobol, FMS, Oracle, DCL, Burroughs 6800.