Summary:

• Having 11+ Years of experience in full life cycles of Mainframe applications such as Analysis, Design, Coding, Implementation, Testing and production support.
• One Year of experience in ETLInformatica applications Development and Production support experience.
• Expertise on Mainframe technologies like COBOL, JCL, CICS, SAS, EASYTRIEVE, REXX, CLIST and having good knowledge on Assembler and PL/I languages.
• Proficient in working Databases like VSAM, DB2, IMS DB and using RDBMS Concepts.
• Expertise in Developing CICS online applications and CICS screens using SDF II tool or BMS Macros.
• Proficient in Writing DB2Stored 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 and EXPLAIN etc.,
• Expertise in setting up the file transfers from mainframes to servers vice versa using Connect Direct (NDM) and FTP.
• Expertise on Software Configuration Management tools Endevor, ChangeMan and Panvalet.
• Expertise on Using Mainframe schedulers like CA7, OPC, TOM and ESP.
• Proficient on Mainframe Job history tools SDSF, JHS, SAR and FLASH.
• 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 converting the open systems data into mainframe and extract the data from Mainframe to open system format using PROC SQL, DATA, PROC FORMAT etc., SAS procedures.
• Having good knowledge on Informatica 8.6 Data warehouse ETL tool to Extract, Transform and Load data from various sources into IBM DB2.
• Having good knowledge in using Source Qualifier, Filter, Router, LookUp, Update strategy, Expression, Sequence Generator, Normalizer, Sorter, Joiner, Rank, Stored Procedure, Union and XML transformations.
• Having good knowledge on creating Mappings, Mapplets, Workflows, sessions, tasks and performance tuning of Informatica tool.
• Having good knowledge on Strobe, Application Performance Analyzer (APA), Omegamon to generate performance monitoring reports and tuning COBOL, DB2 and CICS applications
• Expertise in preparing Test cases, Test plans and Test results review.
• 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.

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 and Oracle
Mainframe Tools: Endevor, ChangeMan, Fileaid for MVS, Fileaid for DB2, Platinum, Omegamon, TMON, SDSF, SAR, JHS, INS, IDCAMS, SYNCSORT, ICETOOL, SDF II, Strobe, APA, ISPF Dialog, QMF, SPUFI, NDM, FTP, XMIT and AQT.
ETL Tools: Informatica 8.6
Schedulers: CA7, OPC, ESP, TMON
Microsoft Applications: MS Office applications (Word, Excel, Power point and Access), MS Visio.
Domain Knowledge: Manufacturing, Financial Services, HealthCare, Life Insurance and Credit Cards

Education:

• Master of Computer Applications (MCA)

Certifications & Trainings:

• Brain Bench certified COBOL 74 programmer.
• Well trained on Informatica 9.0.1 ETL tool

Professional Experience:

Role: IT Analyst
Client: Confidential, Moline, IL
Duration: July 2012 - October 2012

Responsibilities:

• Provide detailed designs based on user requirements and Provide accurate estimates for development tasks.
• Understanding the business requirements and converting them into Technical Design documents.
• Preparing program, process diagrams and flow charts for existing & new programs, Jobs.
• Developed applications COBOL, JCL, DB2, IMS DB and SAS technologies.
• Reviewing the Code, test cases and test results. Validating and Verifying the Test results.
• Writing DB2 stored procedures and COBOL programs to prepare reports and store in DB2 Tables.
• Monitoring the production Jobs and sending the daily status to customer.
• Extract the Market Information data from different sources and load into DB2 tables in Batch applications.
• Written SAS program to prepare data reports and send customers on daily basis.
• Fixed exist program bugs to calculate the correct Machine rental information before load into DB2 table.
• Developed Connect Direct (NDM) Jobs to receive data from share drive, process and load into tables and transfer reports into client shared drives.
• Written SAS programs using Base, Macros, Proc SQL, Proc Mean and Charts.
• Creating User defined reports in SAS by selecting data from DB2, Flat files and Text files.
• Deployed the changed or new program into production using Panvalet version control tool.
• Written QMF Queries, reports, forms and Batch Jobs to generate reports.
• Supporting business clients in managing and reviewing their complaints and can conduct research to identify appropriate solutions to take action on problems.
• Construct solutions in a timely fashion using COBOL, SAS and other tools - Research and resolve issues.

Role: Project Lead
Client: Confidential, New York City, NY
Duration: April 2010 - July 2012

Responsibilities:

• Developing Technical and Functional designs to enhance existing mainframe systems.
• Gathering the requirements from Customers, preparing high level design documents and Work distribution to offshore team members.
• Coding the programs, Jobs and Online screens using COBOL, JCL, CICS, SAS and Easytrieve for application development.
• Reviewing the Code, Validating and Verifying the Test results received from offshore team members.
• Writing DB2 stored procedures and corresponding Cobol programs to prepare reports and store in DB2 Tables.
• Monitoring the production Jobs and sending the daily status to customer.
• Developing the mainframe ISPF tools or Utilities using CLIST/REXX programs.
• Developing COBOL programs to convert the LSB data into LMS format and load into DB2 Tables.
• Create, Audit, Freeze and promoting ChangeMan packages to move the Code changes from Development region to QA and QA to Production regions.
• Developing Connect Direct (NDM) Jobs to transfer the files between production and QA regions and reports to shared drives.
• Supporting the production fixes while Business user issues generates Account/Composite Executive summary performance reports.
• Accessing VSAM, IMS DB and DB2 databases to read and/or write data, Writing QMF queries, procs and forms to generate user defined reports.
• Using SPUFI and FileAid for DB2 to access data.
• Creating User defined reports in SAS by selecting data from DB2, Flat files and Text files.
• Using TWS to monitor production schedule jobs.
• Produce performance measurement reports using Application Performance Analyzer and make the necessary changes in program for performance tuning

Role: Senior Systems Analyst
Client: Confidential, Tampa, FL
Duration: April 2009 - January 2010

Responsibilities:

• As a senior Systems Analyst, Analyzing the existing system and recommending for proposed enhancements.
• Preparing Technical Specification design documents for Customer requirements.
• Developing new COBOL programs to enhance the existing system applications.
• Doing Code reviews, validating and verifying Test results and getting user sign off.
• Setting up Connect Direct NDM and FTP Jobs to transfer files between development and QA regions.
• Developing Transformations Maplets and Mappings in Informatica 8.1 & Parameter files promotions to QA and production regions.
• Promoting the Table changes using DSS (Distributed Sub System) from Development to QA and production regions.
• Monitoring the production Jobs, ETL workflows, providing permanent fixes for production abend and sending the daily status to customer.
• Doing enhancements to User defined panels written in CLIST/REXX languages.
• Extracting data from VSAM, DB2 and Terada databases, Transform and Loading into Data warehouse.
• Writing UNIX scripts to load data into Teradata using BTEQ, FASTLOAD, MULITLOAD and TPUMP utilities.
• Using Teradata Query Assistant to access data from Terada database.
• Using ESP (Execution Scheduling Processor) to monitor current running jobs, schedule long term plans.
• Worked on National Shared Table Support (NSTS) and Table distribution System (TDS).

Role: Systems Analyst
Client: Confidential, Bloomfield, CT
Duration: December 2005 - April 2009

Responsibilities:

• Interacting with Business Analysts, getting the requirements and prepare technical documents.
• Creating new online programs, batch programs, JCL, testing by programmers and users.
• Scheduling of jobs, documentation for the users and getting the final sign off from users.
• Doing analysis for Customer requirements and creating technical specifications.
• Doing Code reviews, validating and verifying Test results delivered by other team members.
• Written NDM Jobs to transfer reports generated by Batch jobs to external servers.
• Maintaining the existing system included making user requested changes/enhancements.
• Developing CICS screens and COBOL programs to invoke by transactions.
• Created monthly Compensation reports for producers to put on servers for customer access.
• Accessing data from VSAM, DB2 and IMS DB databases.
• Doing enhancements to User defined panels written in CLIST/REXX languages.
• Monitoring the SQL statement performance in Omegamon and tuning the SQL queries.
• Developing the COBOL programs to read data from IMS DB and DB2 databases to process and generate reports.
• Used CA7 scheduler to monitor current running jobs, Long term plan jobs.
• Produce performance measurement reports using Strobe and make the necessary changes in program for performance tuning
• Providing 24X7 On-call Production support and fixing the production abends.

Role: Senior Programmer Analyst
Client: Confidential, Bangalore, India.
Duration: July 2005 - November 2005

Responsibilities:

• Interpreted the requirements of business into design solutions.
• Responsible for coding, component integration testing and unit testing.
• Written Stored Procedures and COBOL programs to retrieve data send back front end.
• Distributing the work load between Onsite and Offshore team members.
• Responsible for the evaluation of design and development of the project lifecycle.

Role: Programmer Analyst
Client: Confidential, Bangalore, India.
Duration: October 2004 - June 2005

Responsibilities:

• Interpreted the requirements of business into design solutions.
• Reported daily status to Technical Delivery Managers and Management.
• Doing code changes, testing and implementation to production.
• Support, enhancement or maintenance existing applications.
• Coordinated with the operations areas and lines of business to spot out and specify complex business requirements and processes
• Make recommendations, researches and find out alternative solutions.

Role: Programmer Analyst
Client: Confidential, Chennai, India.
Duration: October 2003 - September 2004

Responsibilities:

• Analyzing the Customer requests and preparing HLD or LLD design documents.
• Doing Code changes, Unit, System, integration testing and Code Peer reviews.
• Implemented the Code changes in production and scheduling of jobs.
• Peer reviews of the Code changes and Test results.
• Developed CICS Maps using SDFII Tool.
• Maintaining the existing system included making user requested changes/enhancements and being on call to take care of any issues that arise.

Role: Programmer
Client: Confidential, Hyderabad, India.
Duration: September 2001 - September 2003

Responsibilities:

• Responsible for coding, component integration testing and unit testing.
• Created and updated systems functional and reference documentation.
• Daily, Monthly and annual reports generation and placing in share drive.
• Offered support during the testing phase.