Summary: •
•
•
•
•
•
•
• •
•
•
• • •
• • •
•
8 year years s of experi experienc ence e in sof softwa tware re analys analysis, is, design design,, develo developme pment nt and testin testing g online online// batch batch applications and experience in Production Support activities. Experience working in various sectors like Insurance and Pharmaceutical Investments. Expertise in COBOL, DB2, CICS, JCL, Telon, VSAM and worked in various types of projects like Development, Maintenance, Enhancement and Production support. Expertise in quality tools software configuration management tool like Change man, Endevor , FileAid, Control-M, Panvalet. Panvalet. Self Self-m -mot otiv ivat ated ed indiv individ idua uall with with appl applic icat atio ion n deve develo lopm pmen entt on IBM IBM Ma Mainf infra rame mes s usin using g COBO COBOL/ L/ CICS/DB2/VSAM /JCL on TSO/ISPF environment. Excellent development and system testing skills in batch COBOL and online CICS programs using DB2. DB2. Good in carrying out impact analysis and redesigning applications based on client requirements. And And have have hand handss-on on in prep prepar arin ing g prog progrram spec specif ific icat atio ions ns,, JCL, JCL, PROC PROC,, STOR STORED ED PROC PROCS, S, COPYBOOKS. Proficien Proficientt in relational relational data bases bases like DB2, ORACLE ORACLE and SQLServer SQLServer,, including complex SQL accessing a large, complex application databases. Experienced in writing SQL queries with SPUFI /QMF Experienced in testing in a mainframe mainframe environment & Creation of test plans, test schedules schedules and test cases Efficient to work with all clients, take a very high level issue, run with it, develop a system solution and support through the entire Project Lifecycle. Experienced in documenting the detailed application specifications translate technical requirements into programmed application modules and develop/enhance application modules. Basic Understanding of IMS Databases , MQ Series Having Effective communications communications with all levels of internal and external external customers Participated actively in meetings & teleconferences with Users, Business Analyst teams, Development teams, QA team members and Managers. Extensive experience in working with Rational Clear Quest and HP Service Center. Good experience in various QA tools like Quality center 9.0, Test director. Excellent analytical, problem-solving, self-learning abilities & Good analytical skills, able to prioritize and capable to handle multiple tasks. Fluent and Impressive Communication Communication and Interpersonal Skills.
Technical Skills: Operating Systems Languages Transaction Server Database Version Control Tools Schedulers Other M/F Tools Testing Tools Office Tools
IBM MVS, UNIX, OS/390, WINDOWS, DOS/VSE, MS-DOS COBOL-II, COBOL-II, JCL, XML, PL/SQL, WEB SERVICES. CICS, TSO/ISPF DB2, VSAM, ORACLE, SQLSERVER 2000/2005 and MS ACCESS PANVALET, ENDEVOR, CHANGEMAN CA-7 XPEDITER, INTERTEST, FILE-AID, FILE-AID/DB2, QMF, SPUFI, RACF, WinSQL, FTP, FTP, CLISTS, IDCAMS, REPRO, ABEND-AID, MQSeries, IBM UTILITIES. Quality center 9.0, Test director and Manual testing (Batch/Online) Lotus Notes, MS Outlook
Education: Master Degree in Computer Applications, Madras University, University, India.
Professional Experience: xxxxxxxxxxxxxx, IN. Nov’08 to till date. Senior Developer Project: Regional Agency Markets- Agency Management.
xxxxxxxxxxxx is one of the leading Insurance Company providing Auto, Property and Casualty Insurance. Various web based and Client server applications are used to support the User needs. Personal Line Internet Quote is designed for getting Quick Auto quote and transform into the application request for the policy. Customer Quote’s can be Auto, Home, Watercraft and Umbrella. It is used for New Business, Transfers, Re-writes etc. PLIQ works for all states. Based on the rules that are created for each state the transaction differs. This project Agency Management (Client/Diary) involves Enhancement/Production support activities for the applications like Client & Diary and developed under mainframe technologies. This application system deals with Liberty Mutual client information and their corresponding diaries information which store/maintain data in the system after validation. Rational tools are used to track the change tickets between the applications or modules. This project is now being executing on-site/ offshore model. Responsibilities: • •
•
•
•
•
• •
•
Provided Development, maintenance and prod support for AGS Project On-line and Batch applications. Requirements gathering, Impact Analysis, Design, Coding, debugging and testing (Unit/ System/ Integration test plans and testing), Quality Reviews, Implementation/deployment and client signoff for Client and Diary application changes. Coding new COBOL- DB2 programs for CLIENT and AGENCY to retrieve data from VSAM files, Flat files and DB2 tables based on the adhoc Project Requirement Document sent by client depending on end customer’s requirement. Enhancement of the TELON-DB2 DT30PA online program for Diary transfer and notifications and validated USER ID with QUIX system according to the requirement. Worked on MQ Series for the OFAC changes. Data for OFAC changes will be retrieved from the webservices accessed by MQ series programs . Provided Root cause analysis and permanent fixes for Agency batch application Job abends and online user issues. Creating the test data in various environments and Running Test Cycles based on client request. Setting up of Test Environment including modifying the JCL, creating data using SPUFI, QMF and executing the JCLs for validating the data in DB2 tables. Provided business manager with test results in timely manner to support their review and obtain approval.
•
Assists in Unit, Integration, User acceptance, Regression and other related testing as needed. Load data to Production and support validation
•
•
Used FILE-AID/DB2 for loading the data from Production. Coordinating with DBA to get the approval for all the modified DB2 programs. Providing production support activities to the users of the system and resolved it based on priority.
•
Data Load to various Test Regions using BMC LOAD/UNLOAD and reformatting data upon request.
•
Resolved IBM Rational Clear quest and HP Service Center tickets raised by the users within the SLA.
•
Compiled the application’s using Endevor and end up by tracing and solving the errors. Validated database insertion and deletion by executing SQL statements to verify the output data with ref to inputs entered on the application.
•
•
• • •
•
• •
Testing of new SQL queries by executing using QMF. Responsible for trouble shooting and solving the problems related to production deployment. Assisted in production Validation of the application and helping the business users with the site navigation. Responsible for FTPing the file to the customer server. Maintained detailed test logs and report test results in Quality Center. Documenting and updating production support team prior to application release.
Environment: COBOL, JCL, DB2, TELON, CICS, MVS/ESA, OS/390, ENDEVOR, XPEDITER, MQSERIES, VSAM, TCP/IP and Rational Tools, Quality Center, QMF, SUPER C, SQL, CA7, File-Aid, Panvalet, HP Service Center.
XXXXXXXXXXXX, Boca Raton, FL Senior Developer
May ’07 to Oct’08
xxxxxxxxx or also know as Uriah Spray Epperson (USE) Underwriting Company, provides diverse insurance services to the Lumber Industry in both USA and Canada. xxxxxxxxxx is handling both Online and Batch processes on mainframes. During day time the online process works and in the night the batch process starts. Both of these are daily activities. The Report generations are mainly user requested and some on regular basis. This was a complete Analysis Project that involved analysis of all the mainframe programs along with adhoc request to create new reports for client’s internal use. This was completed successfully. Responsibilities: •
•
Responsible for COBOL DB2 Batch and CICS DB2 COBOL Online program code analysis (Program Mining). Involved in Requirement analysis, Coding, Quality review, Documentation, Issue Resolution.
•
Coding new COBOL DB2 programs for xxxxxxxxxxx to create the reports used by client for their internal process.
•
Analyzed system requirements and involved in developing test plans, test cases and test schedules based on high-level and detailed designs.
•
Created PSBs in testing environment. Transmitted Production libraries and members to the test region and edited them for testing purposes
•
•
Updated rating tables on monthly basis for various states. Involved in modifying factors modifying while calculating premium for the policies.
•
Run the application using JCL’s and PROC’s.
• •
Executing all tests at various levels including Integration, System, UAT and Regression testing. Analyzed the results and identified the bottlenecks of the application.
•
Involved in the analysis of existing SQL Queries to improve its performance
•
Involved in Impact Analysis and responsible to keep track of the code versions and changes through Change Man. Involved in the interaction with end user and provided timely technical support to end users.
•
•
•
Carried out unit testing of new programs in Development region to ensure that the new program would produce the desired results as per client requirement.
•
Coordinating with Client as and when required: To take the feedback of the client regarding the work done and also discuss in case of any concern. Conducted defect review meetings and test progress meetings with the QA team and the development team and pointed out functional gaps and suggestions for creating a more stable system.
•
• •
Training new members of the offshore team to make them familiar with the project. Inducted new team members in the project. The team members had to be familiarized with the project and trained to take up the responsibilities.
Environment: COBOL, JCL, VSAM, DB2, CICS, SAS, File-Aid, CA7, Xpediter, Change Man, HP Quality Center, TSO/ISPF, QMF, Panvalet, Sync sort, Z/OS.
xxxxxxxxxxxxxxx,Sanjose, CA Software Engineer
Nov’05 to Apr’07
Genesys- Enhancement This project is developed for Kaiser Permanente, USA. Genesys is a package for human resource management system, which is used to support all non-physician employees of Southern California (SCAL),around 45,000 of them online module is used to process HR Employee actions by people solutions. Batch module is used to process Employee Benefits and Payroll Financial Transactions. Responsibilities: •
Developed new screen using Telon Design Facility (TDF) under DB2 environment.
•
• • • •
• •
•
•
• • • • • •
• •
Enhancement of COBOL-DB2 program for HR Resource Management System for calculating the bonus and commission of the employees. Solved peregrine tickets raised by users. Responsible for Code writing based on program specification. Assisted in integration, User acceptance and other related testing as needed. Developed system test strategy to validate end-to-end processing for each of the business processes that were part of the new platform. Created test cases, test scripts and executed them. Analyzed test data requirements and established a process to create test data required to support testing Once the testing is done successfully in UAT region then the component will be promoted to Production Involved in System Integration Testing and giving list of instructions for the User Acceptance Testing & support the users to perform User Acceptance testing of product for the written test cases based on new functionality added. Involved in all these activities till the component is promoted to Production Participated in document Reviews, inspections, Risk calls and GO calls. Testing of peer code based on unit test plan. Peer review of code and logging of defect log into Rational clear Quest. Developed queries to verify the data populated in DB2 Database. Responsible for bug tracking using Rational clear Quest. Provide technical and business support for users ensuring online availability for IBM mainframe CICS inquiry/update, and batch processing of incoming/outgoing interface files from other applications. Worked on XML Generate and Parsing to provide the data file through MQ to Customer Involved in preparation of Weekly and daily status reports.
Environment: COBOL, JCL, DB2, MQSERIES, XML, J2EE, Oracle, Change Man, Xpediter, Rational Clear Quest.
xxxxxxxxxxxxxxxxxxx, Singapore
Apr’04 to Oct’ 05
Mainframe Developer Warehouse Management System Warehouse Management System was using Mainframe Technology which controls the movement and storage of materials within the warehouse. WMS included Order management, receiving, stocking, replenishment, picking, labor control, warehouse task management, tracking and inquiries. The system enabled real-time tracking and provided on-line drive instructions to all forktruck drivers as well as providing monthly summaries of cargo movements and productivity. Customers can log into the system at any time, to get an update on the status of their cargo. Cargo tracking provided access of up-todate information on cargo held on-site, on a twenty four hour basis. This Warehouse Management application allows authorized personnel to view inventory levels, reserve quantities, place warehouse orders and review order status. Warehouse Management System offers the flexibility to run one wave that allocates inventory for multiple customers within a single warehouse and generates the billing transactions necessary to invoice each individual customer. Responsibilities: • • • • •
•
• •
Analyzed business and system requirements. Modified the Existing screens using CICS under DB/2 environment. Coding for the module Application was handled independently. Creating the required Functions and procedures was part of the coding standards. Tested the software with the real time system and used the application to get the accurate results in the measurements. Prepared test cases so that various scenarios are covered. Documenting the Unit Test Plan and preparing the Unit Test Results. Performed database testing by passing SQL Queries to retrieve data. Document test case criteria for releases.
Environment: COBOL, CICS, JCL, DB2, MVS/ESA and Z/OS, File-Aid, Panvalet, SQL, TSO/ISPF, VSAM, QMF, .net, Sync Sort.
xxxxxxxxxxxxx, Bangalore, INDIA Software Engineer
APr’02 to Mar ’04
CHEMTRAC (Chemical Tracking System) The CHEMTRAC is designed for QC and R&D labs. CHEMTRAC can store and report the entire lab’s data. By using CHEMTRAC user can assign rights on Reaction Tree. User can attach images, raw data files and processed data files.CHEMTRAC is as easy to use as a word process but offers the reporting and searching capabilities of a relational database and its tracks chemicals and laboratory supplies. The system stores a variety of essential information about each chemical and supply used of each level of Research. This is will give various reports regarding how much chemicals used for each research and it gives estimated cost of each level of the research. Responsibilities: •
• •
• •
• •
Analyze requirements and create Low level designs. Build COBOL and JCL elements for CHEMTRAC laboratory supplies. Worked in Production Support of CHEMTRAC module which involves Chemicals and laboratory and processing them based on the customer history and relevant information and subsequently decisioning the application. Ensured that deliverables meet requirements. Modified the existing Programs and generalized the existing PROCs such that it works for existing and new company Performed code reviews to meet the company standards Involved in Manual execution of testing and the creation of defect reports
•
Developed Test strategies & Test plans including modifying the JCL, creating data using SPUFI,QMF and executing the JCLs for validating the data in DB2 tables. Performed Unit Testing & System Testing using written test cases Monitored Test progress and preparing Summary Report Involved in doing Rush Install during implementation if any issue is identified Maintaining the defects using Defect tracking system and bug review.
•
Monitoring the interaction of Code and test database using COBOL and DB2
•
Preparation & execution JCL using JCLPREP prior to execution and created GDG bases and empty VSAM files when necessary. Creation of new processes from supplied client request documentation and testing of new processes Resolving CICS transaction abends. Involved in different Cycles of Testing after fixing the bugs and before moving the Programs into Production Region. Involved in enhancement of the existing DB2 Stored Procedures Performed Integration testing to verify the interface between various application modules
•
• • •
• • •
• •
• •
Used Test Director for defect tracking and maintained log information for the defects. Involved in preparation of Weekly and daily status reports.
Environment: Mainframe – COBOL, JCL, DB2, MVS/ESA and OS/390, TSO/ISPF, File-Aid, Endevor, File-Aid, TSO/ISPF, VSAM, Xpediter.
