PROFESSIONAL SUMMARY
• Having **+ Years of experience in full life cycles of Mainframe applications such as Analysis, Design, Coding, Implementation and production support. One Year of Production support experience on ETL Informatica applications.
• Expertise on Mainframe technologies COBOL, JCL, CICS, EASYTRIEVE, REXX, CLIST and having good knowledge on Assembler, IMS DB, PL/I and SAS.
• Proficient in working Databases like VSAM, DB2 and using RDBMS Concepts.
• Expertise in Developing CICS online applications and developing CICS screens using SDF II tool or BMS Macros.
• Proficient in Writing DB2 Stored Procedures and QMF Queries, PROCs and FORMs to generate reports using Batch Jobs.
• Expertise on using the DB2 utilities UNLOAD, LOAD, RUNSTATS, REORG, REBIND, IMAGE COPY EXPLAIN etc.,
• Expertise in setting up the file transfers using Connect Direct (NDM) from mainframes to servers vice versa.
• Expertise on Software Configuration Management tools Endevor and ChangeMan.
• Expertise on Mainframe schedulers like CA7, OPC and ESP.
• Proficient on Mainframe Job history tools SDSF, JHS, SAR and TOM (Tivoli operations manager).
• Expertise on Mainframe tools Fileaid for MVS, Fileaid for DB2, Platinum, Omegamon and TMON.
• Expert on IBM utilities IEBGENER, IEFBR14, IEBCOPY, IDCAMS, SYNCSORT and ICETOOL.
• Proficient In developing Mainframe tools or ISPF panels using REXX and CLIST Languages.
• Proficient on SAS to convert the open systems data into mainframe data and extract the data from Mainframe to open system format.
• Exceptionally well organized, strong work ethics and willingness to work hard to achieve project objectives.
• Competent to work at the highest technical level of all phases of applications programming activities.
• Having good knowledge on Informatica 8.1 Data warehouse tool to extract data from Mainframes to open systems.
TECHNICAL SKILLS
Programming Languages COBOL, JCL, SAS, ASSEMBLER, EASYTRIEVE, REXX and CLIST
Operating Systems OS/390, Z/OS, MVS, Windows XP/98, Windows 7
Online Transaction Processing CICS
Databases VSAM, DB2, IMS/DB, Oracle
Mainframe Tools Endevor, ChangeMan, Fileaid for MVS, Fileaid for DB2, Platinum, Omegamon, TMON, SDSF, SAR, TOM, JHS, INS, IDCAMS, SYNCSORT, ICETOOL and SDF II.
ETL Tools Informatica 8.1
Schedulers CA7, OPC, ESP
Microsoft Applications MS Office applications (Word, Excel, Power point and Access), MS Visio.
Domain Knowledge Financial Services, HealthCare, Life Insurance, Credit Cards and Retail.
EDUCATION
• Master of Computer Applications (MCA) from Sri Venkateswara University, Tirupathi, India.
WORK EXPERIENCE
1. Role: Project Lead
Client: Morgan Stanley Smith Barney, New York City, NY
Duration: April 2010 – Till date
Responsibilities:
o Developing Technical and Functional designs for enhancing mainframe systems.
o Getting totally involved in every step of System Development Life Cycle.
o Doing the actual coding using COBOL, JCL, DB2, CICS for developing applications.
o Directing the work request of existing applications to offshore resources.
o Reviewing the Code, Validating and Verifying the Test results received from subordinates.
o Writing DB2 stored procedures which are triggered from front end applications.
o Monitoring the production Jobs and sending the daily status to customer.
o Developing the mainframe ISPF tools or Utilities using CLIST/REXX programs.
o Doing COBOL coding to convert the LSB data into LMS format and load into DB2 Tables.
o Preparing ChangeMan packages to move the Code changes into Production through QA regions.
o Setting up Connect Direct (NDM) Jobs to transfer the files between production and QA regions.
o Providing solutions for the Business user issues while generating the performance reports.
o Technical Team Leadership of projects.
Skill Set: COBOL, JCL, CICS, CLIST, REXX, DB2, VSAM, SAS, ChangeMan, File Aid for MVS, File Aid for DB2, SYNCSORT, ICETOOL, OPC, TOM, SDFII, Z/OS, OS/390 and Windows XP.
2. Role: Systems Analyst
Client: Verizon Data Services Inc., Tampa, FL
Duration: April 2009 – January 2010
Responsibilities:
o Doing analysis for Customer requirements and creating technical specifications.
o Preparing Low level and High level design documents for enhancements.
o Doing Code reviews, validating and verifying Test results delivered by other team members.
o Setting up NDM and FTP process to transfer files between development and QA regions.
o ETL code & Para files promotions to QA and production regions.
o Promoting the Table changes using DSS (Distributed Sub System) from Development to QA and production regions.
o Monitoring the production Jobs, ETL workflows and sending the daily status to customer.
o Doing enhancements to User defined panels written in CLIST/REXX languages.
Skill Set: COBOL, JCL, VSAM, DB2, INS, ESP, ENDEVOR, NSTS/TDS, TCS, CLIST, REXX, Easytrieve and ETL (Informatica 8.1), Z/OS, OS/390, MVS and Windows XP
3. Role: Systems Analyst
Client: CIGNA HealthCare, Bloomfield, CT
Duration: December 2005 – April 2009
Responsibilities:
o Interacting with Business Analysts, getting the requirements and prepare technical documents.
o Creating new online programs, batch programs, JCL, testing by programmers and users.
o Scheduling of jobs, documentation for the users and getting the final sign off from users.
o Doing analysis for Customer requirements and creating technical specifications.
o Doing Code reviews, validating and verifying Test results delivered by other team members.
o Written NDM Jobs to transfer reports generated by Batch jobs to external servers.
o Maintaining the existing system included making user requested changes/enhancements.
o Developing CICS screens and COBOL programs to invoke by transactions.
o Created monthly Compensation reports for producers to put on servers for customer access.
o Doing enhancements to User defined panels written in CLIST/REXX languages.
o Providing 24X7 On-call Production support and fixing the production abends.
Skill Set: COBOL, JCL, CICS, VSAM, DB2, SAS, CLIST, REXX, Easytrieve, SDFII, SDSF, JHS, File Aid for MVS, File Aid for DB2, Omegamon, BMRS, CA7, Windows XP, OS/390, Z/OS, MVS.
4. Role: Senior Programmer Analyst
Client: Nationwide Insurance, Bangalore, India.
Duration: July 2005 – November 2005
Responsibilities:
o Interpreted the requirements of business into design solutions.
o Responsible for coding, component integration testing and unit testing.
o Written Stored Procedures and COBOL programs to retrieve data send back front end.
o Distributing the work load between Onsite and Offshore team members.
o Responsible for the evaluation of design and development of the project lifecycle.
Skill Set: COBOL, JCL, VSAM, DB2, SDSF, JHS, Platinum for DB2, File Aid for MVS, ChangeMan, CA7, Windows XP, OS/390, MVS.
5. Role: Programmer Analyst
Client: New York Life Insurance, Bangalore, India.
Duration: October 2004 – June 2005
Responsibilities:
o Interpreted the requirements of business into design solutions.
o Reported daily status to Technical Delivery Managers and Management.
o Doing code changes, testing and implementation to production.
o Support, enhancement or maintenance existing applications.
o Coordinated with the operations areas and lines of business to spot out and specify complex business requirements and processes
o Make recommendations, researches and find out alternative solutions.
Skill Set: COBOL, JCL, CICS, ASSEMBLER, VSAM, DB2, Endevor, File Aid for MVS, File Aid for DB2, CA7, SDSF, SDFII, Windows XP, OS/390, MVS.
6. Role: Programmer
Client: Discover Financial Services, Chennai, India.
Duration: October 2003 – September 2004
Responsibilities:
o Analyzing the Customer requests and preparing HLD or LLD design documents.
o Doing Code changes, Unit, System, integration testing and Code Peer reviews.
o Implemented the Code changes in production and scheduling of jobs.
o Peer reviews of the Code changes and Test results.
o Developed CICS Maps using SDFII Tool.
o Maintaining the existing system included making user requested changes/enhancements and being on call to take care of any issues that arise.
Skill Set: COBOL, JCL, CICS, VSAM, DB2, CLIST, REXX, SDFII, File Aid for MVS, File Aid for DB2, JHS, SDSF, SDFII, Omegamon, OPC, Windows XP, OS/390, Z/OS, MVS.
7. Role: Programmer
Duration: September 2001 – September 2003
Responsibilities:
o Responsible for coding, component integration testing and unit testing.
o Created and updated system's functional and reference documentation.
o Report generations using crystal reports.
o Offered support during the testing phase.
Skill Set: Visual Basic 6.0, Oracle, COBOL, Visual source safe.