SUMMARY

• 15+ years of experience in various roles as Manager, Solution Architect, Data Architect, System analyst with 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 with CTS DFHLS2WS.
• Expertise in working with DB2 for z/OS 8.0/9.0/10 databases and in writing triggers, COBOL stored procedures and native stored procedures.
• Expertise working with 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 teh automation solutions to customer.
• Good experience in architecting and developing large data movement between systems, developing data analytics.
• Working knowledge on Datastage 9.1 ETL tool. UNIX shell Scripting Job scheduling.
• Strong experience working with Waterfall as well as Agile based Mainframe application development.
• Participated in requirements analysis, reviews and working sessions to understand teh 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 with Sort Utilities like DFSORT and SYNCSORT and ICETOOL.
• Strong Experience with usage of IBM DB2 Utilities for LOAD, UNLOAD, FASTLOAD.
• Created new tools using REXX language, integrated them with CLIST.
• Scheduled batch flows using teh 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 teh 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 teh business requirements and creates teh 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 with database management activities.
• Worked on automation proposal and implementation of teh 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 teh system and database assessment, building solutions for code migration, testing, implementation and support of new environment. Prepared Disaster and application recovery plans.
• Worked with QA Engineers, Performance Analysts, Business users, Implementation Coordinator during various lifecycles of teh 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 halp identify opportunities for improvement. Tuned few complex queries to improve performance.

Confidential

Mainframe Developer

Responsibilities:

• Served as an onsite co-coordinator for teh application mentoring teh 8-member offshore team.
• Responsible for Requirements gathering, Impact analysis, Project estimation, scheduling and tracking teh deliverables.
• Designed teh database for teh application. Created logical and Physical data-model
• Coded native stored procedures to support our application UI to interact with DB2 database. Translated all teh requirements into SP Calls and designed teh application.
• Used IBM Datastudio extensively to develop, test and deploy teh native stored procedures.
• Extensively used BMC and IBM Datastudio to do EXPLAINS on stored proc queries to understand teh access path and optimized teh queries accordingly.
• Used File-Aid for DB2, QMF and SPUFI for accessing teh DB2 database. Created DCLGENs and used them in COBOL modules.
• Used Endevor tool to maintain teh COBOL/CICS modules, JCLs, parms and procs and for promoting teh 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 teh scheduler tool for all teh batch flows inside teh application.