Information Systems Software Applications

Rajiv Saxena

B.S. (Electronics),

National Institute Of Technology Warangal (India)

***********@*******.***

Cell : 319-***-****

Professional Summary

More than 20 years in Design, Analysis, development, Testing and implementation of Business software applications, product and services, ON-LINE and BATCH Processing Systems.

Excellent knowledge of Transforming Business requirement to Technical Specifications.

Excellent knowledge of Mainframe (IBM, Unisys, and UNIX), IBM Z(O/S) Connect, DB2, DMS, IMS (DB/DC), SQL, JCL,Assembler,CICS (Systems Programming and screen design), Control M, Xpediter,Changeman, VSAM,SyncSort, COBOL74/85,Endevor, EZTrieve,CICS Transaction Server(CTS), CICS Gateway(CTG), ICETOOL (DFSORT Utility), CA7, XML,HTMl, Java Script, Assembler,Structured Program Design Skill.

Management Information Systems including best practices of analysis and design, applications development, databases, processes,, procedures, and techniques A broad range knowledge of operating systems,

Excellent skill in Cobol 74/85, MF-Cobol. Program Development Testing & Debugging.

Excellent knowledge of DB2 – DDL, DML and DCL.

Excellent skill in developing Migrating programs(Implementaton) from VSAM, Flat files to DB2 database.

Excellent Functional knowledge of Finance Banking / Manufacturing / Govt. Agencies /Credit Card / Claim processing Applications.

SCRUM / Agile /Water Fall Methodology.

A self-motivated problem solver and team player with excellent communication skills, oriented towards customer satisfaction, Strong problem solving Skill

Worked for Clients like GSA (General Service Administration) Federal Govt. Agency in DC, NY State Govt. Agency (OTDA, OCFS – Child care and Family welfare Services), DCJS (Department of CRIMINAL JUSTICE), UNISYS CORPORATION, Wells Fargo Bank, Peoples Bank, HSBC, CITI Bank, Capital One and many others..

Developed / Maintenance of Cobol 74/85 Programs to use DB2 database and VSAM / files.

Expertise & extensively worked on Credit card payment processing.

Expertise in providing production support(24X7) by handling complex issues and change requests.

Performed as Onsite – Offshore Coordinator in managing the.Project Management Tasks.

Coordination with QA Team in Defect tracking, monitoring and resolving issues.

Experienced in Unit and System Integration Testing. Designed Test cases on modules according to the requirements and development standards.

Technical Skills

Operating Systems

IBM(Z/OS), OS/390, MVS, UNISYS,UNIX, LINUX,Windows, DOS

Programming Languages

SQL,MFCOBOL, COBOL-74/85, AcuCOBOL,.JCL, JAVA, Java Script, ON-DEMAND,ASP,Shell Script in UNIX / Linux environment.VB.NET

Database

DB2, RDBMS, ORACLE, IMS DB/DC, DMS, MS-SQL Server, UNIFY, SAS,SAP FICO(ERP),MS Access

Tools / Utilities

DDL/DMLCICS, HP ALM, JIRA, VSAM, IBM Message Queing, CA scheduler, SPUFI,TSO/ISPF,LDAP,Work Bench,,EasyTrieve,CLIST, FileAid,ChangeMan, Endevor,Xpeditor, SPUFI,Abend-AID,REXX,Crystal Reports, Vi, HP ALM, SBM, FS-RAPID, FTP, MS Project 2000, MSOffice,, ErWin,Adobe Dreamweaver,Visio 2000

Methodology / Technology

SSAD, OOPS (Object Oriented Programming), SCRUM Development Methodology, Water Fall/Agile Methodology

Employer :AKS Software Ltd, VA Nov 19–Present

Project : Development/ Maintenance/ Implementation of COBOL Programs (On –site & Off shore)

Client :Leading Finance / Manufacturing Industry.

Role :Senior IT Consultant/Architect

: Mainframe(Z/OS),, DB2 (Data Base), IMS DB/DC, COBOL,Assembler, CICS,MQ,VSAM,JCL,TSO/ISPF,REXX, LDAP,HTML, XML, WSDL, EasyTrieve, Endevor,Xpeditor, SBM, Windows-NT, MS-Office, Visio, MS Visual studio

Responsibilities

System Requirement Study with customer / End User(s)

Preparation of design document, Program Specifications, Data Flow Diagrams

Maintenance of existing Cobol Programs, running with DB2 (Database)

CICS Optimization, CICS Architectural Analysis & Design

Program testing, debugging and data validation, SQL Error Handling

Developed DB2 Stored procedures, Triggers and used extensively in Cobol Programs.

Program Testing, Preparation of Test Plan, Unit, System and Integration Testing

Independently Program Error handling and providing solution.

Implementaton and customer feedback, Performance monitoring and Review.

Employer :Lockheed Martin Arlington, VA Oct 08–Oct19

Project : Development/Maintenenca & Implmentation of COBOL PROGRAMS FOR FSS System (Procurement module)

Client : General Service Administration (Federal Govt. Agency).

Role :Senior IT Consultant/Associate

Environment :IBM Mainframe(Z/OS),DB2 (Data Base), IMS DB/DC,COBOL74,MF-COBOL, Assembler,TSO/ISPF,CICS,JCL,Endevor, SAS,HTML, XML, EasyTrieveREXX,,CICS, SBM,TCP/IP,Windows-NT, MS-Office, Visio, MS Visual studio, Changeman and other IBM utilities

Responsibilities :

System Requirement Study, Program Analysis, Coding, Testing, Debugging

Analysis of COBOL 74/85 programs running on Mainframe.

Data Visualization using SAS

Users Interaction to discuss their Requirements and to provide best feasible solution to meet their requirements.

Maintenance of existing Cobol Programs, running with DB2 (Database), Agile Methodology.

Program testing, debugging and data validation, Data Load and extraction from DB (Database)

Defect tracking, Monitoring and resolving in coordination with QA/Testing Team.

GSA wanted to develop fresh COBOL programs to find out the list of vendors whose contracts are being terminated and send them System generated e-mail.

Used TADS, LogAnalyzer/SumLog for program Testing and debugging, SQL error handling

Developed a new Module for Billing And Account Receivable(BAAR)

Program Testing, Preparation of Test Plan, Unit, System and Integration Testing

Handled individual tasks and deliverable components in order to complete projects on schedule

OLTP services development experience, Development / Maintenance of COBOL Batch programs.

Actively involved in performing unit tests, Integration testing and user Acceptance tests.

Actively involved in performing Unit tests, Integration testing and user Acceptance tests.

Employer :Amitech Solutions, Albany, NY Jan 08 – Oct 08

Project : Development of System Use case from Legacy Use cases

Client :DCJS (Department OfCriminal Justice Services, NY State)

Role :Sr. Programmer/ Analyst

Environment :IBM Mainframe(Z/OS),DB2(RDBMS), JCL,EasyTrieve,CICS,COBOL74/85, TSO/ISPF,JCL,REXX,,CrystalReports, Windows-NT, MS-Office,FTP,TCP/IP

Responsibilities

System Requirement Study, Program Analysis, Coding, Testing

Analysis of COBOL 74/85 programs running on UNISYS A-series Mainframe

Development of System Use case from Legacy Use Case

Users Interaction to discuss their Requirements and to provide best feasible solution to meet their requirements

Maintenance of existing Cobol Programs running with DMSII (Database)

DCJS using application on UNISYS A-series, COBOL,DMSII for signature verification, Name check

etc., a requirement for Federal government

Project Risk/Time Management, Project Planning and Monitoring.

All System Use cases preparation with the help of DCJS SME’s (Subject Matter Experts)

The objective of this conversion project is to improve Performance Accountability Measures, timeliness of case processing and completeness of disposition

Employer :Amitech Solutions,Albany, NY Jan 06 – Dec 07

Project :Welfare Management System (WMS), Loan Processing System

Client :NY State Govt. Project (OTDA)

Role :Sr. Programmer/ Analyst (Lead)

Environment :IBM Mainframe(Z/OS),DB2, (DataBase), EasyTrieve, COBOL74,Assembler, CICS, VSAM, JCL, Crystal Reports, CICS,TCP/IP, LDAP,Reports Windows-NT, MS-Office

Responsibilities

System Requirement Study, Program Analysis, Coding, Testing

Project program scheduling and tracking.

Users Interaction to discuss their Requirements and to provide best feasible solution to meet their requirements.

Unit, System Integration testing of new programs

Development of fresh common procedures useful for other COBOL74 programs.

Development of New Module – Vendor Receivable to the existing BICS system.

Development of JAVA, HTML, XML, for screen design and interface with COBOL programs.

To make application more flexible towards VENDOR Payments in the existing WMS (Welfare Management System).

Expertise in Program debugging and SQL error handling

BICS application is used to take of the assistance provided by State government for child welfare /temporary Disabled persons (A module of WELFARE MANAGEMENT SYSTEM).

A NY state government project to provide and track of the payments / Contractor receivables.

Employer :HexawareTechnologies,Canton,MI Mar 05 – Dec 05

Project : Development/Maintenance/ Testing COBOL Programs for an International Manufacturing Unit

Client :Unisys Corporation, Canton, MI

Role :Sr. Programmer/ Analyst,On site coordinator

Environment :IBM Mainframe(Z/OS), COBOL74/85, CICS,VSAM,EasyTrieve, Windows-NT, UNIX,FTP, TCP/IP, DARGAL, InfoSuite. MS-Office

Responsibilities

Understanding existing application and knowledge transfer to off-shore team members.

Preparation .of Knowledge transfer document, to be approved by UNISYS FUNCTIONAL ANALYST.(SMEs)

To Provide Production support for DAY-TO-DAY operational / technical problems.

Maintenance / Development of Fresh Programs in COBOL 74/85, DMSII, as per the fresh requirements

Development Of Data Retrieval Programs. Adding / Altering/ Deleting Data Records in DMSII Database using COBOL 74/85.

AGILE/SCRUM Development Methodology

A Business Outsourcing Project to maintain BAMCS (Business AndManufacturing Control System)

BAMCS(Business and Manufacturing Control System) is being used worldwide by UNISYS for their manufacturing / support requirements.

Use of MAPPER for transferring files

Development of fresh DML queries for day-to-day requirements of extracting DATA from DMS database.

Develop fresh queries using DARGAL / URSA to Extract Data from UNISYS DMS Database.

Employer :Kaizen Technologies Bridgeport, CT Aug 02 – Jan 05

Project :Development/Maintenance/ Testing Of A Large Retail Banking / Loan Module System

Client :Peoples Bank

Role :LeadProgrammer/Analyst

Environment :IBM,Unisys A-series, IBM COBOL74/85,JCL,CICS,DB2 BL Source, XGEN, Windows-NT, UNIX, FS-Rapid, FTP, TCP/IP, DARGAL, ON-Demand. InfoSuite. EasyTrieve, MS-Office

Responsibilities

Maintenance of Existing Application & Fresh Development of COBOL 74/85 programs.

Integration of Commercial Loan module with other Modules.

SCRUM Development Methodology

Integration of Commercial Loan system with PBP (Pay By Phone) module

Loan Application till Loan disbursement, Generate letter for loan installment payment

File Transfers between IBM to UNISYS for DAY END processing

Peoples Bank, C.T. uses GFS( Global Financial System) for their Retail banking Applications.

GFS was developed by UNISYS Corp. during 1980.

Project was involved in incorporating new functionality as per the users requirement.

Peoples wanted to develop a fresh module – EFT( Electronic Funds Transfer)

Project involved in development of fresh as well as modifications in existing COBOL programs / Screens

(XGEN) for PAY-BY-PHONE module ( part of EFT module)

Project also required some enhancements in Commercial Loan Applications (CLA) Module.

Redesigned Commercial Loan Application Processing Programs with integration to CIS

( CustomerInformation System) module

Modifications in Lender Referral request form for Commercial Loan.

Developed New reports showing Loan Aging, Mortgage Rates variations

Employer :Tata Infotech Ltd. India July. 1996 – March 2002

Project : Retail Banking & Item Processing System for an International Bank.

Client :Hongkong & Shanghai Banking Corp

Role :Lead Analyst

Environment :UNISYS, DMSII, COMS,UNIX, WFL, COBOL, DMINQ, MARC/CANDE, FS-Rapid, FTP, On- Demand, Microfocus Cobol, MS-Office, Windows-NT. Visio

Responsibilities

Study of The existing System and COBOL Programs.

Unit level of testing so that no “A” or “B” category bugs exists, “C” category bugs were known bugs

and were mentioned in Program Release Note.

New Dataset Creation and upload Data from Flat files to DMS-II-DBMS, with Proper Validation Checks

Fresh Complex COBOL Program Development, Converted existing Unstructured COBOL Programs to Structured Efficient Programs, COBOL Programs Code-walk through to check Efficiency of

Programs.Responsibility of maintaining version Control using BL-Source, Mock Testing of the system before releasing to Production Environment

Acceptance Testing with the criterion defined in the TEST PLAN, System Testing, Quality Assurance, Configuration Management and Documentation.

Application was developed for Front Office operation related to Checking/Savings/Current/Loan Accounts.

To Understand and Clarify the Program specifications( including Screens) given by Project Manager,

Data Flow Diagrams from the Program specifications and from the existing documentation of the software

Unisys COBOL Programs Maintenance & Unit Testing for incorporating Enhancements

Wrote Work Flowfor Batch execution. Used CANDE, MARC Editors, TCL for Screen Changes

Proper Y2K testing of each and every Program before releasing to Production Environment

Program approval from QA and Acceptance testing before releasing to Production.

Program Documentation and Technical Documentation describing functionality of each and every program

Employer :AKS Software Ltd.India July. 1989- Mar 1996

Project :Multiple Projects

Client : Finance, Manufacturing related client

Role :Sr. Programmer / Analyst

Environment :ORACLE,FoxPro, Oracle Power Objects, C, PL / SQL, MF-COBOL, Windows 3.1/ 95, MS-ACCESS, MS-WORD, MS-Excel, Visio

Responsibilities

Requirement Study.

Preparation of design document, Program Specifications

Preparation of Data flow diagrams, Block Diagrams and program specifications

Program development, test cases and unit testing

TRAINING & SELF DEVELOPMENT

COURSE DESCRIPTION

DURATION

Underwent extensive training on IBM, UNISYSMainframes comprising of the following modules:

Oracle, DB2,DMS, MCP, MVS,CICS, VSAM, TSO/ISPF,COBOL, JCL, ChangeMan, MARC/CANDE, WFL,BL-SOURCE, BL-SCHEDULER, UNIX, C, Structured System Analysis and Design (SSAD)

24 weeks

SAP FICO (Finance and Control) Module Comprising of Following Modules –

General Ledger, Accounts Receivable/Payable, Assets and Bank Accounting

4 Weeks

Underwent a comprehensive training on UNIX Architecture, SHELL programming, UNIX System Administration

6 weeks

Underwent comprehensive training program on SAP FICO Module

4 Weeks

Contact this candidate