SUMMARY

• 12+ Years of overall IT experience in Requirements Gathering, Analysis, Design, Development, Maintenance, Support, Testing and Implementation of Software Applications.
• Having 12+ years of experience on Mainframe - COBOL, PL/1, DB2, IDMS, IMSDB, IMSDC, CICS, CA-DADS, MacKinney Batch to CICS, IMS HALDB, JCL, ICETOOL, Easytrieve, File manager, SPUFI, QMF, RDZ, Fault analyzer, SAR, Changeman, CA7, ESP Scheduler, MainView, AbendAid, Fault Analyzer, SoupUI, PQEdit, Core Java and configuring SOAP and REST web services in a CICS environment.
• 2 years of experience in Assembler
• Good knowledge and experience in Informatica, PERL, Python, PolicyCenter, Guidewire, Jenkins, GitHub, Unix Shell scripting, Oracle sql and RPA tool UiPath
• Have very good experience in application rollout, application retirement and decommission.
• Have good experience in data extraction, transformation and migration to distributed systems.
• Worked on integrating Mainframe applications with 3rd party vendors, regulatory agencies and Government agencies.
• IBM Certified in PL/I.
• Worked under both Agile and waterfall method.
• Worked on WindChill FlexPLM - Java.
• Good Knowledge in MS Excel Macro’s, Mainframe macros and Automation.
• ITIL Foundation Certified.

PROFESSIONAL EXPERIENCE

Confidential, Columbus, OH

Mainframe Developer

Responsibilities:

• Modifying the Cobol IMS code.
• Developing and modifying Mainframe JCLs to support state rollout.
• Developing and modifying CA ESP scripts to run the jobs in batch.
• Attending daily scrum meeting.
• Review the code.
• Attending workshops to discuss and understand business requirements.
• Develop technical design document as per the requirement.
• Modify the Cobol CICS code to support the state roll-out.
• Modify COBOL, DB2 programs for the new requirements.
• Modifying the Cobol IDMS code.
• Modify COBOL, VSAM programs for the new requirements
• Modify the Cobol IMS DC code to support the state roll-out.
• Create JCL’s to run the Cobol code, syncsort, icetool and other IBM utilities to achieve the file layout that is desired as per the requirement.
• Use IBM fault analyzer and IBM debugger to fix the issue arise during development long with other tools like File-aid, QMF, SPUFI.
• Generating reports using SAS.
• Developing Perl scripts to run WMB, ETL and invoking Guidewire Policy Center API in batch.
• Attending working session to resolve issues emerged during development.

Confidential

Responsibilities:

• Analyze the legacy application and identify the rules that are required by the go-forward UWRS Cloud.
• Documenting mapping between the legacy application data and the go-forward application.
• Data extraction and report generation from IBM DB2 for regulatory agencies and Government agencies.
• Transforming the data as per the requirement.
• Coordinate and Communicate with the Business team to modify the interfaces with external vendors, regulatory agencies and Government agencies.
• Design and develop new interface when there is a vendor change.
• Configuring SOAP and REST web services in a Cobol CICS environment.
• Work with 3rd party vendors whenever there is enhancement in the interface layout.
• Fix any issue related to vendors files and connections like EDI files, XML files and SOA interface
• Working with business team to identify the process that can be decommissioned.
• Monitoring the user activities on the application that are identified for decommission and generating a report for Business team.
• Analyzing the various applications and create retirement and decommission strategy.
• Create JCL’s to run batch jobs and schedule the same in ESP
• Generate reports using SAS
• Create Changeman package for Cobol, JCL, Copybook to promote the code to the lower environments and then to the production.
• Taking back-up and decommissioning the databases, that are identified for the decommission.
• Do Impact analysis due to infrastructure release and Software upgrades.
• Conducting DR test.
• Analyze and fix defects.
• Conduct Unit and Integration Testing. Performing code-walkthroughs and reviews.

Confidential

Mainframe Developer

Responsibilities:

• Analyze the legacy application and identify the data that is required by the go-forward application.
• Documenting mapping between the legacy application data and the go-forward application.
• Data extraction from IBM DB2, IMS, ODS DB, AS400, Tapes, VSAM, SQL server.
• Transforming the data as per the requirement.
• Configuring SOAP and REST web services in a CICS environment.
• FTPing the files to NAS drives for the Hadoop to consume.
• Identifying all the fields required to apply the retention rules on the Legacy data.
• Coordinate and Communicate with the Business team to design new interfaces with external vendors, regulatory agencies and Government agencies.
• Generating reports for Business team by connecting different types of databases using ODBC connections.
• Generating activity log report in a formatted layout, so that can be used in Analytics.
• Design and develop new interface when there is a change in the vendor.
• Work with 3rd party vendors whenever there is enhancement in the interface layout.
• Fix any issue related to vendors files, like EDI files, XML files.
• Modify the Assembler code to enable the data migration.
• Code the new JCL that to extract the data and transform the according to the requirement layout.
• Code the Cobol DB2 code to identify and extract the data that is needed for the migration.
• Working with business team to identify the process that can be decommissioned.
• Monitoring the user activities on the application that are identified for decommission and generating a report for Business team.
• Using the tools like QMF, SPUFI, FILEAID, Fault Analyzer, IBM debugger to find the deviation and debug the issue.
• Analyzing the various applications and create retirement and decommission strategy.
• Identifying the components that can be decommissioned without impacting the existing applications that are still needed or tagged under go-forward applications.
• Taking back-up and decommissioning the databases, that are identified for the decommission.
• Analyze the charge-back cost for the legacy application and identify the components that can be decommissioned with few work arounds.
• Do Impact analysis due to infrastructure release and Software upgrades.
• Conducting DR test.
• Conduct Unit and Integration Testing. Performing code-walkthroughs and reviews.

Confidential

SQL Developer

Responsibilities:

• Supporting the existing legacy application that runs on Mainframe, AS400, Java.
• Working on the batch abends.
• Working on the user-initiated incidents.
• Handling P0 calls and taking appropriate action to fix it.
• Communicating outages and providing workarounds to the users.
• Configuring SOAP web services in a CICS environment.
• Modifying and fixing JCL errors and failures.
• Modify the Assembler code to support the application.
• Modifying the Cobol, DB2, IMS code to support the application.
• Packaging the code in changeman and implementing in the lower regions and promoting the same to Production during implementation.
• Resolve issues related to file transfers.
• Modifying the Cobol IDMS code.
• Using the tools like QMF, SPUFI, FILEAID, Fault Analyzer, IBM debugger to find the deviation and debug the issue.
• Testing MQ connections to the vendor, during MQ‘s upgrades.
• Analyze and do necessary changes whenever a new vendor onboards.
• Identifying and Automating the repetitive tasks.
• Flagging the Jobs or transactions that are consuming more CPU and fine-tune them.
• Involved in creating and developing test cases for Unit, Integration and QA testing.
• Coordinating with test team in resolving defects or enhancements throughout testing cycle.
• Responsible for resolving the problems identified while doing the end-to-end testing.
• Working on enhancements.
• Documents all the interfaces and its corresponding data mapping.

Confidential

SQL Developer

Responsibilities:

• Involved in POC for migration of data from Legacy applications to FlexPLM.
• Impact analysis on integrating the FlexPLM product with mainframe Systems.
• Configuring the FlexPLM production according to the Business Needs.
• Developing the tool in SQL Server for Data Migration activity
• Developing Cobol Db2 code to extract the data from Legacy applications
• Developing JCL to run the code in batch.
• Schedule the JCL in CA7 to extract the data to file for the migration
• Using the tools like QMF, SPUFI, FILEAID, Fault Analyzer, IBM debugger to find the deviation and debug the issue.

Mainframe Production Support - Onsite

Confidential

Responsibilities:

• Attending P0 and outages calls and providing the fix or workaround with minimum impact to business.
• Fix job abends and online transactions within SLA
• Coordinating and fixing the incidents or tickets raised by the user.
• Ad hoc analysis based on business requirements and handling client queries.
• Coding Cobol Db2, Cobol VSAM code as per the requirement.
• Coding JCL to run the Cobol code in batch and schedule the same in CA7
• Conduct Unit and Integration Testing.
• Generating the SAS reports.
• Daily interactions with Client for Reporting/resolutions of Tickets.
• Coordinate and Communicate between customers and offshore team.
• Performing code-walkthroughs and reviews. Finding the business/process improvements. Preparing Review Checklist.
• Preparing the code fixes to reduce the Production Job abends.

Confidential

Responsibilities:

• Impact analysis on downstream mainframe applications due to implementation of the JDA Product
• Customizing the mainframe system to handle smooth transition between mainframe applications and JDA Product.
• Developing the technical design as per the requirement
• Develop Cobol DB2 code.
• Generate reports as per the business requirements.
• Attending business workshops.
• Packaging the code into changeman and promoting it to lower regions and then to production
• Schedule the JCL in CA7 scheduler.
• Using Fault analyzer, IBM debugger and other tools to solve the issues that might a raise during development
• Code JCL to support the batch.
• Customizing Warehouse System to handle the orders from both JDA allocation system and allocation from Mainframe system during the department transition’s