PROFESSIONAL SUMMARY:

• Mainframe Programmer Analyst with 7 years of experience in Mainframe z/OS including COBOL, COBOL II, COBOL 74,COBOL 85,AS/400, DB2 V9, CICS, JCL, TSO/ISPF, MVS, VSAM, SQL, Stored Procedure, ADSO, MQ Series and IDMS.
• Excellent knowledge and work experience in various phases of SDLC such as Requirement Gathering, Analysis, Design, Development, Unit Testing, User Acceptance Testing (UAT) and Maintenance.
• Worked on development, enhancement and support of large scale mainframe applications for level 2 & 3 issues. Excellent Functional and Technical Knowledge in Utilities segment, Services segment, Customer Service, Transmission and distribution services, Billing system, MDMS, IEE and Smart Connect/Grid systems
• Worked on CICS as a front end and DB2, VSAM and IDMS as a database. Having extensive experience in COBOL, CICS, JCL, TSO/ISPF, VSAM, SQL, DB2, SPUFI, MQ Series, IDMS and Stored Procedures, ADSO.
• Strong skills in different tools like IBM/BMC Tools, Data Studio, CA - Intertest, Expediter, CA-View, CA7, SDSF, DB2I, SPUFI, File Manager, Edit Plus, FILEAID, TFS.
• Extensive experience in IBM utilities like IDCAMS, IEBGENER, IEFBR14, DFSORT, Sync SORT and COMPAREX.
• Hands on experience with Configuration Management tools like Changeman, Endevor, ISPW, INFO/MVS, PDX (Product Extension) etc.
• Hands on experience in Batch Applications using COBOL, JCL, VSAM, DB2, MQ Series, IDMS and Online Applications using COBOL, CICS, DB2, MQ Series, IDMS.
• Worked on the Performance Optimization of the existing mainframe Online and Batch systems. Identified the necessary changes required in the System Parameters and Design, which will enhance the performance of the system.
• Quick-learner and a hard worker who believes in achieving results through good teamwork.
• Self-starter with the attitude of “can do” and good to adjust in new environment easily.
• Perform day to day operations to maintain SLAs and business functions.
• Result oriented, with an ability to work with aggressive time lines for any assignment to successful completion within the established project schedule under budgetary constraints.
• Excellent oral and written communication skills.
• Key work of area is Utility and Services segment

TECHNICAL SKILLS:

Application: Mainframe, COBOL, COBOL II,COBOL 74,COBOL 85, AS/400, CICS, JCL, TSO/ISPF, IBM z/OS (MVS), VSAM, SQL, DB2, Stored Procedures, ADSO, MQ Series and IDMS, UNIX

DBMS: DB2 9.1, VSAM, MS SQL Server, IDMS.

Job Function: Requirement Gathering, Analysis, Design, Coding, Testing, UAT, Documentation, Maintenance, Application Support and Project Management.

OS/Environment: IBM z/OS (MVS), OS390, OS3270, DOS, Win 9x/Xp/2k.

Debugging Tools: CA-Intertest, Expediter

Change Control: Changeman, Endevor, Info/MVS, PDX, ISPW

Tools: IBM/BMC Tools, CA-View, OPCS, TWS, COBOL 74, COBOL 85 $AVRS, CA7 (AUTOSYS), DB2I, IBM Data Studio, SPUFI, File Manager, SDSF, Edit Plus, FILEAID, IBM Utilities, FTP, OLQ and DMLO.

Scripting Languages: VBScript and Shell Script

PROFESSIONAL EXPERIENCE:

Senior System Analyst

Confidential, Irwindale, CA

Responsibilities:

• Requirement analysis, Design, development, testing, support and implementation of Smart Connect grid and metering system
• Worked on DB2 migration project where we have migrated SQL server database and related stored procedures and functions to DB2 native SQL.
• Create, modify and enhancing COBOL programs with CICS, DB2, Stored Procedure for online applications and JCL for batch applications and testing the changes.
• Writing complex SQL queries and coding them into DB2 program to call Dynamically/Statically.
• Extensively using Data Studio for SQL queries, executing and debugging the stored procedures.
• Performing impact analysis on the complicated queries.
• Using ISPW/ChangeMan tool for version control management and product management.
• Walking thru the technical specification document with the business team and all the stakeholders in the project.
• Work closely with project managers and share responsibilities for application delivery and quality of solutions.
• Validate the test results by mapping the test results against the business rules. Coordinating with the testing team for UAT sign off.
• Preparing the package and follow up with the business team for signoff and implement the changes in production environment.

Environment: IBM z/OS (MVS), COBOL II, DB2 9.1, SQL Server, Stored Procedures, JCL, TSO/ISPF, COBOL 74,COBOL 85, AS/400, VSAM, SQL, CICS, MQ Series, IBM Data Studio v 3.1.1, ChangeMan, ISPW, IBM/BMC Tools, CA-View,TWS, File Manager, ADSO, SDSF, Edit Plus, FILEAID, IBM Utilities, FTP.

Senior Software Developer

Confidential, Irwindale, CA

Responsibilities:

• Requirement analysis, Design, development, testing, support and implementation of Customer service and billing System.
• Create, modify and enhancing COBOL programs with CICS, DB2, ADSO, MQ Series, Stored Procedure and VSAM for online applications and JCL for batch applications and testing the changes.
• Enhancing MQ programs to run dynamically and coordinating with multiple teams to ensure proper working.
• Writing complex SQL queries and coding them into DB2 program to call Dynamically/Statically.
• Extensively using DB2I and SPUFI for SQL queries and load unload utilities.
• Performing impact analysis on the complicated programs, batch jobs, online screens and Records.
• Interpreting highly complex requirements into design documentation with process flow charts.
• Preparing high level estimation for batch and online applications based on the complexity of the programs.
• Using INFO/MVS and PDX tool for information management and product management.
• Testing, debugging through Batch-Intertest and Online-Intertest and installing the components to production.
• Walking thru the technical specification document with the business team and all the stakeholders in the project.
• Work closely with project managers and share responsibilities for application delivery and quality of solutions.
• Assists in the build, making code changes and the unit testing of the batch and online systems.
• Provides technical guidance to other application developer, mentoring new Consultants and providing orientation, and on IT procedures and standards.
• Validate the test results by mapping the test results against the business rules.
• Coordinating with the testing team for UAT sign off.
• Preparing the package and follow up with the business team for signoff and implement the changes in production environment.
• Monitoring the batch jobs in production and instructing the production services team to run the job in a sequence.

Environment: IBM z/OS (MVS), COBOL II COBOL 74,COBOL 85, AS/400, CICS, JCL, TSO/ISPF, VSAM, SQL, DB2 9.1, MQ Series, Stored Procedures, ADSO, Batch-Intertest, Online-Intertest, INFO/MVS, PDX, CA-View, OPCS, TWS, DB2I, SPUFI, File Manager, SDSF, IBM/BMC Tools, Edit Plus, FILEAID, IBM Utilities, FTP.

Senior Software Developer

Confidential

Responsibilities:

• Extensive work on SDLC cycle including Requirement gathering and Analysis, Coding, Testing, Implementation and User Acceptance Testing in Customer workflow and billing Domain for customer choice aggregator (CCA)
• New customers and vendors account set-up in Mainframe using CICS screens and maintain them by CICS programs.
• Created new COBOL programs, JCL, PROC using DB2 database from scratch to design and coding.
• Implemented DB2 Stored Procedures, Cursers and worked on performance tuning.
• Writing complex SQL queries and coding them into DB2 program to call Dynamically/Statically.
• Coordinate communication with different Customers and Vendors to get their standard files or Proprietary files via VAN or FTP and test in multiple applications.
• Using Endevor tool for change management and product management.
• Testing, debugging through Expediter and Online-Intertest and installing the components to production.
• Check scheduling of Jobs in the production environment in CA7 and reviewing the Job Logs in $AVRS.
• Modification to the run-process to accommodate specification changes by Trading Partners.
• Handle support issues in transaction processing and provide 24/7 support to batch run.
• Getting specifications with client and pass it to offshore team via functional/technical specification document.
• Provide Business Specification Document (BSD) for new application/tool.
• Support VAN related issues and Coordination with VAN(3rd Party) team.
• Project Management; prepare SLA and Time Sheet Activity on regular basis.
• Technical and functional sessions.
• Documentation for new and existing processes.

Technologies Used: MAINFRAMES (JCL, COBOL, CICS screens, ADSO, IMS, Expeditor and DB2), Power Builder

Senior Software Developer

Confidential

Responsibilities:

• Requirement analysis, Design, development, testing, support and implementation of mainframe Smart Connect grid and metering services System.
• Create, modify and enhancing the COBOL programs with CICS, DB2, IDMS, MQ Series and stored procedures for online applications and JCL for batch applications and testing the changes.
• Performing impact analysis on the complicated programs, batch jobs, online screens and Records.
• Writing complex SQL queries and coding them into DB2 program to call Dynamically/Statically.
• Interpreting highly complex requirements into design documentation with process flow charts.
• Preparing high level estimation for batch and online applications based on the complexity of the programs.
• Preparing software requirements specification and technical design documents that includes high level and low level design documents.
• Testing, debugging through Xpeditor, Intertest and installing the components to production.
• Scheduling the Jobs in the production environment and reviewing the Jobdocs/copybook.
• Preparing the Job scheduling sheet, traceability matrix and issue tracker sheet.
• Walking thru the technical specification document with the business team and all the stakeholders in the project.
• Work closely with project managers and share responsibility for application delivery and quality of solutions.
• Assists in the build, making code changes and the unit testing of the batch system.
• Provides technical guidance to other application developer, mentoring new Consultants and providing orientation, and on IT procedures and standards.
• Validate the test results by mapping the test results against the business rules.
• Coordinating with the testing team for UAT sign off.
• Preparing the package and follow up with the business team for signoff and implement the changes in production environment.
• Monitoring the batch jobs in production and instructing the production services team to run the job in a sequence.
• New customers and vendors account set-up in Mainframe Online Screens.
• Modification to the run-process to accommodate specification changes by Trading partners and support issues in transaction processing.
• Project Management and actively monitoring of batch run.

Environment: IBM z/OS (MVS), COBOL II COBOL 74,COBOL 85, AS/400, CICS, JCL, TSO/ISPF, VSAM, SQL, DB2 9.1, IDMS, MQ Series, Stored Procedures, ADSO, Expediter, Online-Intertest, Endevor, CA-7 (AUTOSYS), $AVRS, DB2I, SPUFI, File Manager, SDSF, Edit Plus, IBM/BMC Tools, FILEAID, IBM Utilities, FTP.

Senior Software Developer

Confidential

Responsibilities:

• Requirement Analysis/Gathering, Coding, Testing & Implementation.
• Setup the new customers and vendors in mainframe system.
• Developed a new Online and Batch Programs for product transfer and resale report in system for VMI purpose.
• Work on mother served logic for product activity Data.
• Created new programs for batch application and online application using COBOL, JCL, CICS, IDMS, DB2 and VSAM.
• Document the new processes and updating the present documentation on a continuous basis.
• Mentor new team members, motivate them and manage the team.
• Took the initiative to create a tool for extracting any fields from any record or multiple records. It will display the extracted file automatically.
• Rename of all the reports in the system.
• Add security for all the new House and accounts.

Environment: IBM z/OS (MVS), COBOL, CICS, JCL, AS/400, TSO/ISPF, VSAM, SQL, DB2, IDMS, MQ Series, Expediter, Intertest, Changeman, CA-7 (AUTOSYS), $AVRS, DB2I, SPUFI, ADSO, IBM/BMC Tools, File Manager, SDSF, Edit Plus, FILEAID, IBM Utilities, FTP.