SUMMARY

• 15+ years of experience in various roles as Manager, Solution Architect, Data Architect, System analyst wif hands on experience.
• Strong exposure in COBOL and JCL developing job flows, schedules and batch processing.
• Good experience developing CICS modules/transactions for real - time application scenarios.
• Worked on exposing an existing CICS module as webservices wif CTS DFHLS2WS.
• Expertise in working wif DB2 for z/OS 8.0/9.0/10 databases and in writing triggers, COBOL stored procedures and native stored procedures.
• Expertise working wif IMS DB/DC database.
• Very Well experienced in IBM mainframe computer systems using COBOL, DB2, JCL, CICS, VSAM, IMS and TSO/ISPF.
• Well experienced in release management tools UDeploy and providing/implement the automation solutions to customer.
• Good experience in architecting and developing large data movement between systems, developing data analytics.
• Working noledge on Datastage 9.1 ETL tool. UNIX shell Scripting Job scheduling.
• Strong experience working wif Waterfall as well as Agile based Mainframe application development.
• Participated in requirements analysis, reviews and working sessions to understand the systems and system design. Experience in designing Low level and High-level design documents.
• Created, presented Estimates, proposals and gap analysis documents to client leader ship.
• Extensive experience wif Sort Utilities like DFSORT and SYNCSORT and ICETOOL.
• Strong Experience wif usage of IBM DB2 Utilities for LOAD, UNLOAD, FASTLOAD.
• Created new tools using REXX language, integrated them wif CLIST.
• Scheduled batch flows using the CA7 scheduler, Datastage Sequencer jobs using AUTOSYS.
• Strong experience in VSAM file processing
• Experience in version control tools like ChangeMan and Endevor.
• Experience in tools like PLAT, BMC, IBM Datastudio to evaluate the performance of a query using EXPLAINS.
• Experience writing technical specifications for IDMS Logical Record Facility.
• Expertise MF tools like TSO/ISPF, FileAid, FileAid for DB2, SPUFI, PDSMAN, and SDSF.

TECHNICAL SKILLS:

Languages: COBOL, Ezetrieve, REXX

Platforms: Windows 9X/ 2000/XP/7/8, zOS, MVS/ESA

Database: DB2 V8.1/V10, Microsoft SQL Server 2005/2008/2012, IMS DB/DC RDBMS concepts, CA IDMS

Utilities: DF SORT, SYNCSORT, ICETOOL, IBM Utilities for DB2, NDM/FTP, VSAM

Tools: TSO/ISPF, SPUFI, FileAid, PDS MAN, CA7, Xpeditor, SAR, SDSF, JCLPREP, Endevor, ChangeMan, Expeditor, MainframeExpress, IBM Debug tool, HP Quality Center, IBM Datastudio, Micro focus

ETL Tools: IBM - Datastage 8.5/ MS SQL Server SSIS/DTS packages

DB Tools: File-Aid for DB2, PLAT, BMC, QMF, TOAD

Methodologies: Agile, waterfall, SDLC

Tools: Jenkins, GITHUB, UDeploy, CONTROL-M, Quality Center, Remedy, service now, BMC utilities, FTP, IDCAMS, FILE AID, Xpeditor, Endeavor, DB2-File Aid, QMF, SPUFI, JIRA, Tivoli.,Udepoy, Cognos, QuickStart.

PROFESSIONAL EXPERIENCE:

Confidential

Solution Architect

Responsibilities:

• Application monitoring, design, architecture reviews making technical development & design decisions.
• Analyse current issues, existing systems and taking care of impact analysis to identify areas for improvement and integration.
• Analyse the business requirements and creates the technical design, process documentation and create an application roadmap.
• Taking care of production support and L1, L2 and L3 support requests.
• Analysis of project requirements, Estimation, Design and provide solution Architecture, experience wif database management activities.
• Worked on automation proposal and implementation of the solutions to avoid day to day requests. Working on establishing CI/CD pipeline to deliver fast and efficiently.
• Create reports defining project progress and process improvement documents.

Confidential

Senior Mainframe Developer

Responsibilities:

• Analysis of project requirements, Estimation, Design and Development.
• Identification of support requirements, taking care of L1, L2 and L3 support requests.
• Mainframe migration & rehosting on Micro focus environment - providing the system and database assessment, building solutions for code migration, testing, implementation and support of new environment. Prepared Disaster and application recovery plans.
• Worked wif QA Engineers, Performance Analysts, Business users, Implementation Coordinator during various lifecycles of the project.
• Taking care of Production implementation setting once code is approved in test region.
• Mentored team of developers in analysis, design, coding and trouble shooting.
• Business process analysis and Improvement.
• Conducted design and code reviews across project teams to help identify opportunities for improvement. Tuned few complex queries to improve performance.

Confidential

Mainframe Developer

Responsibilities:

• Served as an onsite co-coordinator for the application mentoring the 8-member offshore team.
• Responsible for Requirements gathering, Impact analysis, Project estimation, scheduling and tracking the deliverables.
• Designed the database for the application. Created logical and Physical data-model
• Coded native stored procedures to support our application UI to interact wif DB2 database. Translated all the requirements into SP Calls and designed the application.
• Used IBM Datastudio extensively to develop, test and deploy the native stored procedures.
• Extensively used BMC and IBM Datastudio to do EXPLAINS on stored proc queries to understand the access path and optimized the queries accordingly.
• Used File-Aid for DB2, QMF and SPUFI for accessing the DB2 database. Created DCLGENs and used them in COBOL modules.
• Used Endevor tool to maintain the COBOL/CICS modules, JCLs, parms and procs and for promoting the same to higher environments.
• Used NDM and FTP TEMPhas file transfer protocols between mainframe LPARs and between mainframe and midrange servers respectively.
• Used CA-7 as the scheduler tool for all the batch flows inside the application.