Manager Sales
Resume:
Rajesh Kumar
SUMMARY
More than Seven years of experience in Application Study, Systems Analysis, Design, Development, Testing, Implementation, Maintenance, Process and Migration as a Mainframe Consultant
Two years of experience as a Business Systems Analyst at Offshore with respect to gathering of business knowledge and covering entire life cycle of the system in Mainframe applications of in the Sales & Marketing Division(Vehicle Distribution)
Rich programming experience in COBOL, COBOL II, PL1, DB2, IMS DB/DC, CICS, SPUFI, JCL, VSAM, MVS, MVS/ESA, BMC, OS-390, IBM Debug, SQL, Expeditor, SQL, File-Aid, File-Aid (IMS), TSO, QMF, ISPF/PDF, SDF, ENDEVOR, Super-C
Involved in the complete SDLC life cycle of an application which includes but not only Analysis, Design, Estimation & Testing
Ability to provide solutions to complex problems considering the operation time
Proficient in Workflow Design, Functional, Technical Specifications and Batch programming
Worked on Mainframe interfacing with other applications using Windows 95/98/2000 and NT
Proficient in writing Test Plans & Test Scenarios/Test Cases and documentation of test results
Good experience in trouble shooting and system performance tuning
Consistently met tight deadline schedules within dynamic environments
Worked as a Programmer, Tester, Systems Analyst and Offshore Team Lead
Good team player and equally effective while working independently
Excellent Analytical, Interpersonal skills, Strong communication, technical writing and presentation skills
TECHNICAL SUMMARY
PROGRAMMING COBOL, PL1, CICS, SQL, JCL, RPL, RPL Maps
TOOLS TSO/ISPF, BMC, PACBASE, VSAM, SPUFI, ISPF/PDF, FILE-AID, QMF, DB2-FileAid, Super-C, FTP, Expeditor(Online & Batch), ENDEVOR & DB2 Visualizer, OPC Scheduler, LDD+
ENVIRONMENT MVS/ESA, S/390, Windows 95/98/2000/XP/Vista, DOS
DATABASES DB2, IMS DB
MICROSOFT TECHNOLOGIES MS Power point, MS Word 2000, MS Excel, MS Outlook 2000
CERTIFICATIONS
o IBM DB2 v7.1
o French Language 1-A Course
PROFESSIONAL EXPERIENCE
MMIS – MISSOURI
DEVELOPER – PRODAPT NA
MEDICAID MANAGEMENT INFORMATION SYSTEMS JAN ’10 –TILL DATE
MO Health Division buys health care services for low income and vulnerable citizens of the State of Missouri. The agency provides health care through development of service delivery systems, standards setting and enforcement, and education of providers and participants. Better understanding of Batch processing with respect to Claims was performed
Role
o In-depth study of the MMIS application understanding Claims, Provider, Financials etc
o Participated in the complete SDLC life cycle process of the project
o Modify the procedure to access DB2 database from the existing VSAM access
o Identify the VSAM files and prepare equivalent SQL queries for the intended purpose of the file
o Replace the VSAM files with the prepared SQL’s
o Fine-tune the SQL’s for better performance
o Introducing BMC Code for programs which performs updates or when the execution time is > 45 minutes
o Modification of the PROC & the JCL for the DB2 Environment
o Preparation of test JCL’s for the production and the test run
o Unit testing of the modified programs
o Wrote the test plan/test cases for all the programs modified
o Raising JIRA, for any production bug, if found
o Record the run time of the production and the test run
Environment COBOL, JCL, BMC, DB2, CICS, IMS, VSAM, OS/390, QMF, SQL, SQL, MS SQL Server Query Analyzer, DB2 Visualizer, Expeditor, FTP, File-Aid, TSO, ISPF, MS Visio 2000, MS Power point, MS Word 2000, MS Excel, MS Outlook 2000
RENAULT NISSAN
SENIOR SOFTWARE ENGINEER – SALES & MARKETING DIVISION
BCV – BASE CONTROL VEHICLE
ROD – REAL TIME ORDERING & DELIVERIES
BDF - PRODUCTION REQUEST BASE
JAN ’08 – JAN‘10
Renault S.A. (Euronext: RNO) is a French automaker producing cars, vans, buses, tractors, and trucks, and, in the past, auto rail vehicles. Due to its alliance with Nissan, it is currently the world's fourth largest automaker. BCV is a core application in the Sales & Marketing Domain which tracks from the order to the birth of a vehicle. It employs two way distributions with all the applications of the domain. BCV gives authorization to BDF which enables special vehicles to be released centrally without going through the standard network interfaces. The commercial performance of BCV is followed by ROD which records the number of vehicles ordered and delivered, with respect to each region and tracks the performance of sales with respect to the previous 4 years
Role
o Acquisition of Business Knowledge of all the 3 applications from the current vendor at Renault, Paris Il-de-France
o Understood the business landscape, gathered functional requirements through facilitated group sessions, consulting with customers on various business issues
o Knowledge transition of the business knowledge which summed up to 9500 function points for all the 3 applications to the Offshore team in Chennai
o Responsible for version control, movement of code and components from development area to integration system/ production system
o Performed System Analysis for all the 3 applications for the chosen modules
o Estimation of the proposed enhancement with respect to the weight age of the function point and its functional complexity
o Ensuring all the elements are correctly elevated to the respective region as a part of pre-implementation process
o Conducting Internal and External Quality assurance activities using Renault-Nissan Guidelines
o Preparation of Functional, technical documents and development of the enhancement for a particular release
o Co-ordinate user testing & Integration testing with the branches
o Compilation of test cases in the form of query and execute the test
o Monitoring of ROD on daily basis and preparing a report on the same
o Debug the existing code for production issues and performance tuning
o Translation of French documents to English, if required
o Preparation of the Weekly Status Report for all the applications
Environment PL1, COBOL II, RPL, RPL Maps, UNIX, JCL, BMC, SQL, DB2, IMS DB, CICS, VSAM, OS/390, QMF, Expeditor, OPC Scheduler, FTP, LDD+, FILE-AID, TSO, ISPF, MS Visio 2000, MS Power point, MS Word 2000, MS Excel, MS Outlook 2000
MINDTREE LIMITED
ASSOCIATE
ABCS - AVIS BUDGET CONSTRAINT RELIEF
AVIS RENT A CAR, INC. PARSIPPANY, NEW JERSEY
JUL’07 – JAN ‘08
Avis Rent A Car System, LLC and its subsidiaries operate the world's second largest general-use car rental business, providing business and leisure customers with a wide range of services. This application is for creating new rental and hierarchy locations. The hierarchical set up of data is migrated to the relational type which introduces more flexibility. The objective behind this project is to introduce relational access to the data for more efficiency & durability by replacing the current VSAM files with that of DB2 tables
Role
o Setting up of the test process for the Unit test purposes
o Preparation of Functional & Technical document for the program
o Modification of current JCL for test purposes
o Wrote the test plan/test cases for any particular component
o Environment setup by loading & unloading of all the required tables and files
o Raising Change Request tickets if any bug being found
o Technical documentation of the process and the scenarios
Environment COBOL II, CICS, VSAM, JCL, DB2, IMS DB, FTP, Expeditor, SQL, QMF, TSO / ISPF, FILE-AID, OS/390, MS Tools
PACCAR MIGRATION – WA
PROGRAMMER ANALYST
PACCAR TRUCKS, BELLEVUE, WA FEB ‘07 – JUL ‘07
PACCAR is a global technology leader in the design, manufacture and customer support of premium light-, medium- and heavy-duty trucks. This migration project was taken up for the conversion of existing OS/VS COBOL and COBOL II codes to ENTERPRISE COBOL. The prime objective is to reduce the time consumption of the running jobs and allow CICS to support the COBOL codes
Role
o Making entries into the log sheet for each program which lists the changes required for the version conversion of COBOL
o Modification of the program as per the prepared log sheet
o Development of DB2 Stored Procedures
o Modification of JCL for test purposes
o Wrote the test plan/test cases for the program
o Environment setup by loading & unloading of all the required tables and files
o Comparison of the Baseline and the test run and providing fixes, if necessary
o Raising Change Request tickets if any bug being found
Environment COBOL, CICS, DB2, JCL, SQL, File Aid, Expeditor, File Manager, ISPF, SPUFI and QMF
COBOL REMEDIAL
PROGRAMMER ANALYST
VOLVO, LYON - FRANCE JUL ‘06 –JAN ’07
AB Volvo is a Swedish builder of commercial vehicles, including trucks, buses and construction equipment. Volvo supplies marine and industrial drive systems, aerospace components and financial services. The objective of the project is to convert the current VS COBOL programs to COBOL II version as the former is no longer supported by IBM
Role
o Making entries into the log sheet for each program which lists the changes required for the version conversion of COBOL & PACBASE program
o Modification of the program as per the prepared log sheet
o Modification of JCL for test purposes
o Wrote the test plan/test cases for the program
o Environment setup by loading & unloading of all the required tables and files
o Conducted reviews on Unit testing
o Comparison of the Baseline and the test run and providing fixes, if necessary
o Raised RFI’s for bugs, if found
Environment COBOL, CICS, PACBASE, DB2, JCL, SQL, File Aid, Expeditor, IBM Debug, File Manager, ISPF, SPUFI and QMF
CKD – COMPLETELY KNOCKED DOWN
PROGRAMMER ANALYST
VOLVO, LYON - FRANCE MAY ‘05 – JUN ’06
AB Volvo is a Swedish builder of commercial vehicles, including trucks, buses and equipment. Volvo supplies marine and industrial drive systems, aerospace components and financial services. This application which was developed does the packing of the detached parts of vehicles and delivering the same to international assemblers with all the necessary documentation for unpacking and assembling n vehicles of the lot
Role
o Prepared System Design Specifications (Internal & External) based on System Requirements Specifications
o Wrote the test plan/ test cases for the developed programs
o Coding & Unit testing of the programs
o Creation of a new PROC & JCL for the programs
o Environment setup by loading & unloading of all the required tables and files
o Conducted reviews on Unit testing
o Raising RFI’s for non compliant functional requirement
Environment :COBOL, PACBASE, DB2, JCL, SQL, MS SQL Server Query Analyzer, Stored Procedures, File Aid, Expeditor, IBM Debug, File Manager, ISPF, SPUFI and QMF
GSM – GLOBAL SYSTEMS MAP
VOLVO, LYON - FRANCE
PROGRAMMER ANALYST
MAY ’04 – APR ‘05
AB Volvo is a Swedish builder of commercial vehicles, including trucks, buses and construction equipment. Volvo supplies marine and industrial drive systems, aerospace components and financial services. GSM is an order to delivery process for all the current and future MD products. It provides common information systems for all VPT sites.
Role
o Prepared System Design Specifications (Internal & External) based on System Requirements Specifications
o Wrote the test plan/ test cases for the developed programs
o Coding & Unit testing of the programs
o Creation of a new PROC & JCL for the programs
o Environment setup by loading & unloading of all the required tables and files
o Conducted reviews on Unit testing
o Raising RFI’s for non compliant functional requirement
Environment: COBOL, PACBASE, DB2, SQL, MS SQL Server Query Analyzer,JCL, File Aid, Expeditor, IBM Debug, File Manager, ISPF, SPUFI and QMF
BAS – BANK APPLICATION SYSTEM
PROGRAMMER ANALYST
GETRONICS, AMSTERDAM AUG ’03 – APR ‘04
Getronics N.V. is a company, subsidiary of the Dutch IT & Telecommunications firm KPN since October 2007, focused on creating value for IT Workspace Management Services, Applications & Software Development Services. Getronics designs, integrates, and manages ICT systems & applications for many global and local companies and organisations. This application is used by UWV, to manage the transactions & archival of 2 year data. The uniformity and manageability of the same are achieved through BAS
Role
o Renaming the old column names, copybooks with that of the new ones
o Removing the unnecessary copybooks by studying the requirement of the program
o Running the jobs and generate log files
o Wrote the test plan/ test cases for the developed programs
o Modify the DCL for test purposes
o Comparison of Baseline & Test run
o Raising RFI for unmatched logs
Environment: COBOL, DB2, DCL, SQL, File Aid, File Manager, Open VMS, ISPF, SPUFI and QMF
EDUCATION
Bachelor of Engineering in Computer Science – University of Madras, India
Contact this candidate