SUMMARY:

• Raghavendra has around 10 years Software development experience in diversified fields of Application software development, maintenance, enhancement and testing Applications.
• 4.5 years of onsite experience, and managed team size from 3 - 10 members both onsite and offshore model.
• Have been involved in full Software Development Life Cycle (SDLC), including requirements gathering, designing, testing, UAT, deployment and maintenance of projects.
• In depth experience and understanding of TSO/ISPF, COBOL, JCL, VSAMs, DB2, IMS and CICS.
• Expert on using the DB2 utilities UNLOAD LOAD, RUNSTATS, REORG, REBIND, IMAGE COPY EXPLAIN etc.
• Proficient in Writing DB2 Stored Procedures and QMF Queries, PROCs and FORMs to generate reports using Batch Jobs.
• Involved Z/OS and DB system maintenance activates on IPL maintenance window.
• Very good capabilities in understanding the Business Process Functionalities which leads to gain excellent domain knowledge.
• Expert on IBM utilities IEBGENER, IEFBR14, IEBCOPY, IDCAMS, SYNCSORT and ICETOOL.
• A Good team player capable of working independently, Strong team orientation & leadership qualities, hardworking and enthusiastic. Excellent communication and presentation skills and Customer Oriented attitude.
• Responsible for managing resources and mentoring. Currently leading team of 8 resources.
• Proficient in preparing various specifications and artifacts to capture business requirements. Specifications involve FRD, BRD, Technical Design documents and Traceability matrix. Also prepared Unit Test and System Test Plans and test cases for the components developed on Mainframes along with their execution in the respective phases of its life cycle.
• Quick learner, self-starter, great communicator and follow good work ethics and mainframe methodologies and a strong team player.
• Excellent analytical, communication and interpersonal skills and consistently being organized by management and peer for producing high quality works.
• Experience in working directly with clients in resolving technical queries
• Training and Mentoring new team members and bring them up to speed.
• Worked on Automated Testing using Microsoft Coded UI for Web based Applications and Manual testing using Quality center for Mainframe apps and web apps

TECHNICAL SKILLS:

Domain: Supply Chain, Energy, Oil &GAS, Power & Water

Languages: JavaScript, COBOL, JCL, VSAM, DB2, CICS, IMS-DB, IDMS

IBM Utilities: IEBGENER, IEFBR14, IEBCOPY, SORT, IDCAMS, SYNCSORT, ICETOOLMQ- series, Easytrieve.

Tools: Sql Developer, TSO/ISPF, SPUFI, QMC, CA7, File-Aid, Endeavor, Panvalet, Expeditor, ELIPS, SAR, Software Administration.

Database: Oracle Pl/Sql, MS Access, DB2, SQL Server, IMS-DB, VSAM

Dimensional Data Modeling:

Data Modeling experience, Star Schema, Snow: Flake Schema

Trained Skills: Informatica pc, Pl/Sql, Tableau.

PROFESSIONAL EXPERIENCE:

Confidential, Schenectady, New York

Tech Lead.

Responsibilities:

• Handled a team of 3 to 10 Members. Involved in work allocation and also responsible to track their work closure.
• Support MRP nightly batch runs and fix if any abends or issues arouse during that period and make sure production region is ready for next Business day for users.
• Worked on user tickets raised on ServiceNow tool and quickly address solutions for each issue.
• Played vital role in reducing the number of outstanding production support Data analysis and ensure data integrity.
• Conducted couple of knowledge sharing sessions to new resource Joined in projects. Conducted may sessions for Team members on Functional as well as Technical skills improvements.
• Lean co-coordinator - Value steam manager, help team in Implement cost savings techniques and lean ideas by fine tuning the SQL queries.
• Understanding of the requirements and specifications from client and pass-through/explain in details to the offshore team.
• Directing the work request of existing applications to offshore resources.
• Writing new COBOL program, reviewing the Code, Validating and Verifying the Test results received from subordinates.
• Status reporting of work to user team, Monitoring the production Jobs and sending the daily status to customer.
• Conducted weekly meetings with team members and discussed status of work assignments and guided best approaches.
• Conducted DR drills on each supported applications yearly twice.
• Work on enhancement projects as per user requirements and deployed them in production.
• Strictly maintained SLA at each level of support and delivered quality of work to user on time.
• Followed quality procedure for each project deliverables.
• Performing the UAT, Production and Post-production release install.
• Extended support whenever required for fixing production issues.
• Weekly status updates to business team on issues and discussion on ongoing issues in project support.
• UAT SPOC for the team, coordinate the new release into ICFS, communicate them with different team on the Install instruction of the JCL and applications which are supposed to run in CA7 scheduler
• Guiding users on functional queries and resolved them quickly.
• Involved in software upgrades and tested applications with upgraded versions.
• Create and load rental transactions using DB2 tables, VSAM
• Analyzed the mapping of XML fields to corresponding COBOL fields and developed integration with other applications.
• Involved many functional user’s discussions and guided them best possible solutions, developed many integrations.
• Load and extract data from DB2 tables for Production to Quality environment processing.
• Installing new releases into production and set up of online/batch for new countries where ICFS is installed.
• Analyze user requirements and execute the needs by developing, modifying and fixing COBOL programs (batch and online), JCL - jobs for processing the data.
• Prepared the weekly status and monthly SLA reports for the top level management
• Expert in FTP and SFTP configurations.
• Actively working on ERP migration activities and involved many functional discussions.

Environment: MVS- Z/OS, TSO/ISPF, JCL, COBOL, CICS, IMS, QMF- SPUFI, Query Monitor, DB2, VSAM, CA7, SYNCSORT, ICETOO, XML, VSAM IDCAMS, IMS DB/DC

Confidential, New York

Responsibilities:

• Support nightly batch runs and fix if any abends or issues arouse during that period and make sure production region is ready for next Business day for users.
• Worked on user tickets raised on ServiceNow tool and quickly address solutions for each issue.
• Played vital role in reducing the number of outstanding production support Data analysis and ensure data integrity.
• Writing new COBOL, DB2, CICS programs, reviewing the Code, Validating and Verifying the Test results received from subordinates.
• Monitoring the production Jobs and sending the daily status to customer.
• Co-ordination of meetings with the Onsite and team members.
• Performing the UAT, Production and Post-production release install.
• Extended support to handle batch job failures.
• Take the ownership of the task assigned to me and my team members, I ensure that they are done on time and do periodical follow up till the task is complete.
• Load and extract data from DB2 tables for Production to Quality environment processing.
• Installing new releases into production and set up of online/batch for new countries where ICFS is installed.
• Analyze user requirements and execute the needs by developing, modifying and fixing COBOL programs (batch and online), JCL - jobs for processing the data.
• Responsible for the creation, migration, and ownership of the schedules, JCL and PROC's, Parmlib's, and other batch resources. Both on and off the mainframe. Other than this, we have to take care of smooth-running and error-free environment and make sure that all work load SLA's are met for the current processing cycle.
• Prepared the weekly status and monthly SLA reports for the top level management
• Make recommendations, researches and find out alternative solutions.
• Working on the infrastructure user requests which are raised by the users. Also assign them to the offshore
• Level 2 support for production issue
• UAT SPOC for the team, coordinate the new release into ICFS, communicate them with different team on the Install instruction of the JCL and applications which are supposed to run in CA7 scheduler.

Environment: MVS- Z/OS, TSO/ISPF, JCL, COBOL, CICS, IMS, QMF- SPUFI, Query Monitor, DB2, VSAM, CA7, SYNCSORT, ICETOOL, VSAM IDCAMS, IMS DB/DC

Confidential

Applications Developer

Responsibilities:

• Played vital role in reducing the number of outstanding production support Data analysis and ensure data integrity.
• Monitoring the production batch jobs using CA-7 scheduler
• Attend ID (Internal design) and Skel (JCL) review with Dev team, actively listen and figure out the issues in the reviews it. These reviews also include to check the install instruction for new releases
• Understanding of the requirements and specifications and create programs.
• Preparation of unit test case’s and executes with sample data.
• Status reporting of the work to the onsite team for reviews.
• Writing new COBOL, DB2, CICS program, reviewing the Code, Validating and Verifying the Test results received from subordinates.
• Monitoring the production Jobs and sending the daily status to customer.
• Co-ordination of meetings with the Onsite and team members.
• Performing the UAT, Production and Post-production release install.
• Extended support to handle batch job failures.
• Provide solutions for issues of high complexity involving potential conflicting requirements
• Level 2 support for production issue
• Support user queries in Test and Production environment.
• Make recommendations, researches and find out alternative solutions.
• Working on the infrastructure user requests which are raised by the users. Also assign them to the offshore team
• Prepared the weekly status and monthly SLA reports for the top level management

Environment: MVS- Z/OS, TSO/ISPF, JCL, COBOL, IMS, QMF- SPUFI, Query Monitor, DB2, VSAM, CA7, SYNCSORT, ICETOOL, VSAM, IDCAMSConfidential

Applications Developer

Responsibilities:

• Analysis of user specifications and developed detailed design documents.
• Prepared COBOL, JCL, VSAM programs as per designed documents.
• Prepared unit test cases and executed them with developed programs.
• Executed test scenarios based on business rules.
• Created JCLs, and released to production.
• Analyze user requirements and execute the needs by developing, modifying and fixing COBOL programs (batch and online), JCL - jobs for processing the data.
• Conducted Impact Analysis of modules in OPC and prepared Analysis document for user reviews.
• Created Infoman Record and updated Change request record details.
• Provide solutions for issues of high complexity involving potential conflicting requirements

Environment: MVS- Z/OS, TSO/ISPF, JCL, COBOL, IMS, QMF- SPUFI, Query Monitor, DB2, VSAM, CA7, SYNCSORT, ICETOOL, VSAM IDCAMS, IMS DB/DC

Confidential

Applications Developer

Responsibilities:

• Analysis of user specifications and developed detailed design documents.
• Analysis of modules and created programs as per design documents.
• Modified Jobs as per enhancement requests from business.
• Created couple of batch reports and send over to users.
• Prepared unit test cases and test with sample data.
• Conducted weekly status reporting with onsite managers.

Environment: MVS- Z/OS, TSO/ISPF, JCL, COBOL, CICS, VSAM, CA7, SYNCSORT, ICETOOL, VSAM, DB2