Database Management Senior Mainframe

Venkat Kayam

Senior Mainframe IT Consultant

e-mail:*****.******@*****.***

Mobile Ph: +1-516-***-****

Summary

Over 17 years experience in IT professional with IBM mainframe technologies. Proven ability to manage complex projects, lead cross-functional teams, and deliver successful solutions across various industries (Telecom, Finance, Banking, Healthcare). Skilled in database management (DB2, PostgreSQL), application development (COBOL, Assembler, PL/I), DevOps, and SDLC/STLC methodologies. Seeking to leverage in-depth knowledge and strong leadership skills to contribute to the success of a dynamic organization.

Technical Skills

Programming Languages: COBOL, Assembler, PL/I, JCL, Core Java

Database Management: DB2, IMS/DB, IDMS, PostgreSQL (Netezza)

RDBMS: DB2 LUW, SQL

Technologies/Tools: Endeavor, Changeman, Panvalet, Control-M, SAR, File-Aid-MVS/DB2, Fault-analyzer, Xpediter, Remedy, SPUFI, QMF, Easytrieve, Abend-Aid, FTP/SFTP, IDCAMS, SYNCSORT, Intertest, CA7, MQ series, Jobtrac, Micro Focus Cobol workbench, Service Now, Jira, Linux, Git, GitHub, Ubuntu, IBM Slack,Zen hub, PagerDuty, Chai portal, Grafana, Qtest, Db2 Stored Procedures,RedHatOpenShift,Jenkins,Kubernetes,CACS, SAS,TSO/ISPF,RACF,Intertest,ServiceCenter,MicrofocusWorkbench,AWS,Python,IBMExplorer,Rally,Cassandra, ACSS, B360, My Biz, VDRT, IFE

Methodologies: Agile, DevOps, Continuous Integration/Continuous Deployment (CI/CD)

Version Control Tools: Endeavor, Changeman, Panvalet

Platforms: z/OS, MVS/VSE/ESA, Linux, Unix, Windows

Domain Knowledge: Telecommunications, Banking, Finance, Manufacturing, Life Insurance, Health insurance, Retail, Healthcare

Education & Certifications

B. Tech in Chemical Engineering, Sri Venkateswara University, Tirupati, India

Certified Scrum Master (CSM) by Scrum Alliance

Additional Information

Overseas assignments: USA (4+ years), Australia (1 year)

Work Experience

Sr. Mainframe Tech Lead (Feb 2023 - Present) Verizon, Cary, NC, USA (Team Size: 6)

Led the migration project from Db2 to a cloud-based data management system, resulting in cost reduction.

Managed the requirement gathering, analysis, and documentation (HLD, TDD) for the Vision Billing application.

Collaborated with cross-functional teams to ensure smooth integration between CICS and web applications.

Provided subject matter expertise (SME) for technical challenges and troubleshooting.

Provided E2E testing for technical challenges of each CPR.

Sr. Mainframe Tech Lead/PostgreSQL DBA (May 2021 - Oct 2022) Persistent Systems Limited, Hyderabad, India (Team Size: 20) (Client: IBM)

Performed database installation and configuration based on organizational requirements.

Monitored database performance to identify bottlenecks and optimize queries.

Developed and implemented backup and disaster recovery strategies for data security.

Sr. Mainframe Tech Lead (Mar 2018 to June 2020) Vanguard, PA, USA (TeamSize:10)

Involved in maintenance and enhancement, support of the VAST application.

Involved in analysis of the applications for the claim process and billing for the customers by generating invoices depends on the cycle of billing.

Attending daily status calls to share the status testing statuses and involve in grooming calls to understand the user stories testing requirements.

Involved in creating packages and web forms for requesting to execute the UAT/Stage packages with Endevor source code management tool.

Sr. Mainframe Tech Lead (Oct 2015 to Mar 2018) Scotia Bank, Tech M, Hyderabad, India (Team Size: 05)

Involved in analyzing the core banking IDS (Integrated Deposits System) and CIS (Customer Information System) application to capture all business requirements related to core banking application built in Assembler.

Involved in analyzing the Assembler programs to prepare High level documents and Technical design documents.

Involved in creation of requirement understanding the Assembler programs documents based on client requirements.

Sr. Mainframe Developer (Aug 2013 to Sept 2015) Material Planning & Logistics (Ford Motors), Tech M Chennai, India (Team Size: 05)

Involved in analyzing, understanding the application to support and resolving production issues and postproduction support of mainframe host batch / online processing of integrated customer platform applications using COBOL, VSAM, JCL, IMS-DB/DC, DB2.

Involved in code changes in COBOL, DB2, JCL, IMS-DB/DC and VSAM for the impacted components.

Involved in creating packages and web forms for requesting to execute the UAT/Stage packages with Endevor source code management tool.

Sr. Mainframe Developer (May 2011 to Aug 2013) DVA, Tech M, Australia (Team Size: 10)

Involved in analysis of the payment processing like lump sum amount, annuity applications.

Involved in code changes in COBOL, DB2, JCL, and VSAM for the impacted components.

Prepared Business Requirement Documents (BRD) which will be the key artifact for rebuilding the applications in distributed platforms.

Sr. Mainframe Developer (July 2009 to May 2011) ITS (BCBS), Tetra soft, Hyderabad, India (Team Size: 15)

Involved in impact analysis for the technical changes based on the client/business functionality requirement.

Involved in enhancement and development of the ITS application.

Responsible for resolving the production issues and postproduction support of mainframe host batch / online processing of integrated customer platform applications.

Involved in providing support for the ITS system on a 24/7 basis.

Mainframe Developer (Dec 2005 to June 2009) Warranty System, KPIT, Pune, India (Team Size: 05)

Involved in maintenance and enhancement and support of the warranty application.

Involved in code changes in COBOL, DB2, JCL, and VSAM for the impacted components.

Involved in system testing, resolving production issues and postproduction support of mainframe host batch / online processing of integrated customer platform applications.

Performed Unit Test Plans for these programs and Unit testing the programs.

Contact this candidate