OBJECTIVE

• To gain expertise in my professional field and become a valuable asset for the organization.

SUMMARY

• 8 years of professional IT experience
• More than 8 years of experience in Mainframes
• Programming knowledge in COBOL, JCL, CICS and EASYTRIEVE, REXX.
• Database knowledge in VSAM, DB2, SQL server.
• Expertise in COBOL - VSAM and COBOL-DB2 programming
• Expertise in writing complex SQL QUERIES.
• Expertise in creating reports for DATA CALL requests using VSAM files, DB2 backend tables and flat files.
• Worked as first on call (Beeper) person for 3 years
• Experience in maintenance and development projects in Mainframe
• Involved in design and development of VSAM to DB2 conversion project
• Experience working on Z/OS and VSE operating systems
• Having Domain Knowledge in Insurance.
• Having experience in Mainframe to Informatica migrating projects
• Having experience in decommissioning unwanted/unused jobs in scheduling
• Having experience in performance tuning
• Gained Experience in conducting SOX testing’s
• Has experience in providing text file reports (FTP) created in Mainframe to external auditing team
• My strengths are being analytical, flexible and good team player, presentation skills
• Can work on time critical projects and customer facing projects.
• Worked on design and conversion of VSAM to DB2 projects.
• Participated in Business requirement meetings and finalizing specification document.
• Has experience in mainframe to ETL conversion project.
• Has experience in reverse engineering and documentation.
• Having experience in customer interaction.
• Experience in co-ordination with offshore team
• Worked with Zeke/Zeke Scheduling. Has experience in creating Zeke dependencies
• Having good knowledge on Data Warehousing Methodologies and Dimensional Modeling like Star Schema & Snowflake Schema

TECHNICAL SKILLS

Languages: COBOL, JCL,CICS, EASYTRIEVE, Informatica Power center 6x/7x/8x

Databases: VSAM,DB2, SQL server

Tools & Utilities: PANVALET, QMF, SPUFI, EASYTRIVE, DFSORT, FILE MANAGER, DITTO, REXX

Operating Systems: Z/OS, VSE, Windows 2000/XP

PROFESSIONAL EXPERIENCE

Confidential, New Jersey

Developer /Coordinator

Responsibilities:

• Understanding the data present in the VSAM file
• Co-ordinate with DBA’s to create the new tables in DB2
• Provide Schema of the tables
• Dump the data from VSAM file and provide it to DBA’s for loading the new tables
• Was responsible for impact analysis and feasible study
• Preparing Technical specification document.
• Writing new COBOL programs to support the maintenance of the new DB2 tables
• Involve in meeting related to enhancements and design with customer
• Create a list of impacted COBOL programs and JCLS
• Provide estimation for number of days to customer
• Make changes to the impacted COBOL programs and JCL’s
• Involved in Code review (Peer review)
• Plan on the promote activities
• Prepare test Cases and provide test results for promote support
• Involved in taking sign off from Business Users
• Providing sample test RDS reports
• Project Documentation
• Closure of the request
• Decommission of the VSAM files

ENVIRONMENT: COBOL, JCL, EASYTRIEVE, VSAM, DB2, CHANGEMAN, QMF, SPUFI, DFSORT, FILE MANAGER, DITTO, REXX, Z/OS

Confidential, New Jersey

Developer

Responsibilities:

• Understanding of the RTS Specification document.
• Preparing Technical specification document.
• Writing new COBOL programs or changing the existing programs as per the requirements of the client for Reporting purposes.
• Writing Easytrives, DB2 queries.
• Maintenance of VSAM files which are used in COBOL and CICS programs
• Impact analysis for enhancement requests
• Promoting packages into production
• First On call person for Confidential Mainframe application
• Co-ordination work between Upstream and downstream systems
• Was responsible to make sure that SLA’s have been met in production.
• Decommissioning of unwanted jobs from Scheduling
• Creates new source and target tables using Informatica to create/Accept files from ProCede Application
• Involve in meeting related to new enhancements and design.
• Developing New JCLs and Easytrieve programs to ensure regular work faster and Remove unnecessary JOBs in Scheduling
• Develop Earning process in support of General Ledger.
• Documentation of work request, test Case and test result preparation
• Closure of the requests after receiving sign off from customer
• Provide support to Data warehouse and Informatica team for decommissioning existing COBOL programs
• Involved in business meeting for Mainframe to Informatica migration project

ENVIRONMENT: COBOL, JCL, EASYTRIEVE, VSAM, DB2, CHANGEMAN, QMF, SPUFI, DFSORT, FILE MANAGER, DITTO, REXX, Z/OS

Confidential

Team Member

Responsibilities:

• Understanding of the RTS Specification document.
• Preparing Technical specification document.
• Writing new COBOL programs or changing the existing programs as per the requirements of the client.
• Writing Easytrives, DB2 queries.
• Writing COBOL programs using VSAM files and DB2 tables to create RDS reports.
• Attending Teleconference for Weekly status and clarifications of Business rules with customer.
• Attending offshore daily meetings for defect prevention and project status

ENVIRONMENT: COBOL, JCL, EASYTRIEVE, VSAM, DB2, PANVALET, QMF, SPUFI, DFSORT, FILE MANAGER, DITTO, REXX, Z/OS, VISIO

Confidential

Team Member

Responsibilities:

• Understanding of the RTS Specification document.
• Preparing Technical specification document for the impacted modules
• Performing code changes, Unit and User testing and Production parallels for the affected programs
• Attending Teleconference for Weekly status and clarifications of Business rules with onsite people.
• Attending offshore daily meetings for defect prevention and project status

ENVIRONMENT: COBOL, JCL, EASYTRIEVE, VSAM, DB2, PANVALET, QMF, SPUFI, DFSORT, FILE MANAGER, DITTO, REXX, VSE, VISIO

Confidential

Team Member

Responsibilities:

• Analyzing Programs and documenting program processing and functionality.
• Analyzing Reports and documenting reports processing and functionality.
• Attending Teleconference with the onsite people for clarifications of Business rules.
• Attending Defect prevention meetings and the project status meetings.

ENVIRONMENT: COBOL, JCL, EASYTRIEVE, VSAM, DB2, PANVALET, QMF, SPUFI, DFSORT, FILE MANAGER, DITTO, REXX, VSE, VISIO