Lead Mainframe Developer
Resume:
Vamsi Krishna Kuppam
Centerton, AR
*****************@*****.***
https://www.linkedin.com/in/vamsi-krishna-kuppam-627170231/
PROFESSIONAL SUMMARY
Senior Mainframe developer with 14 years of experience in Application Development and support, Production Deployment and Warranty Support.
Have hands-on experience in designing and maintaining ETL workflows, GCP, Big Query and processes to support business requirements.
Involved full project life cycle, complete development life cycle in Waterfall, Agile and DevOps methodology and in end-to-end Application support.
Experience in Trade, Financial, Banking and Pharmacy.
Extensive experience in designing and maintaining data architectures, databases, and processing systems.
Superior proficiency in Mainframe application built with JCL, COBOL, CICS, DB2, PL/SQL, ISPW Git integration, TERADATA, Informatica, DataStage, WSDLs and hands on experience in Java, XML and JSON formats and Power BI.
Experience in Agile and all facets of SDLC, including Requirements gathering and analysis, Impact Analysis, Design, Coding, UNIT/SIT/UAT testing and Quality control activities along with troubleshooting and system performance tuning and application support.
Involved in Disaster Recovery Plan exercises on Applications.
Skilled in customizing PEP+ workflows to manage ACH file formatting and ensure NACHA compliance.
Experience in handling different applications platforms as part operational support.
Strong experience in PL/SQL programming and writing complex queries.
Proficient in developing and integrating RESTful APIs
Developed new inbound and outbound program in CICS web services Environment.
Experience working in End-to-End Application support project and handling Migration projects.
Expertise in Cobol-VASAM application with VSAM database.
Experience in research and implementation of automation tools and techniques to increase the efficiency of the product and to decrease the turnaround time for tedious tasks.
Extensive knowledge in onsite offshore model of working
Expertise in debugging the code to find out the root cause and provide the feasible solutions as per requirement.
Experience in working with multiple vendors and geographically distributed teams.
TECHNICAL SKILLS
Domain
Retail, Trade, Pharmacy, Banking and Heath
Programming languages
COBOL, JCL, CICS, VSAM, REXX, Eztrieve, PLI, PL/SQL, Python, Scala, Pyspark
Web programming
Java, C, Python, Webservices, XML, JSON, .Net
Database
SQL, DB2, Teradata, BigQuery, IMS DB, Mango DB
Tools
GitHub, ISPW Git, Service Now, Soap UI, RESTful APIs, TFS, JIRA, CA Gen,Visual Studio, Mobius, PyCharm, IntelliJ IDEA, GCP
Process
CI/CD, Agile methodology, DevOps, SDLC
Operating Systems
Mainframe Z/OS, Windows Server 2003, 2008,
Win XP, win 7, Win 10
PROFESSIONAL EXPEREINCE
Fiserv, Lincoln, NE Nov 2024 – Till Date
Lead Mainframe Developer
Project: Real Time
Description: This project involves banking software that includes Savings, Deposits, Loans, and Credit. It focuses on developing new COBOL programs that will extract functionality from existing programs in other areas and replicate those functionalities within the new system. All the programs are both in ISeries and Unisys.
Responsibilities
Understanding ISeries and Unisys
Understanding existing functionality of the programs and create design document for the new programs.
Designed and maintained Assembler subprograms to interface and other high-level languages, enhancing legacy applications.
Developed and maintained COBOL programs to process ACH transactions efficiently, ensuring accurate fund transfers and settlements.
Designed and implemented custom PEP+ workflows to handle ACH file formatting, ensuring compliance with NACHA guidelines.
Integrated Assembler programs with JCL (Job Control Language), ensuring seamless batch execution and efficient error handling.
Designed and enhanced CICS programs to support real-time ACH transaction processing and error handling.
Managed the end-to-end processing of ACH transactions via PEP+, ensuring accurate fund transfers and timely batch execution.
Performed code enhancements in PEP+ modules to improve transaction processing speed and reduce error rates.
Created and maintained VSAM file structures to efficiently store and manage ACH transaction data.
Create new programs using Visual Studio and compile it VSCode.
Working on GitHub for the source code.
Discuss with the business team to provide alternative solution for the existing functionality.
Coordinate with the Onsite and offshore team regarding the changes.
Understanding the existing Handler programs which will be the API between COBOL programs and .Net.
Conducting daily, weekly sprint calls.
Environment: COBOL, ISeries, Unisys, GitHub, .Net, Visual Studio
Walmart, Bentonville, AR Feb 2023 – Aug 2024
Lead Mainframe Developer
Project: Data and Analytics
Description: This project involves the progressive modernization and enhancement of an existing data integration system that currently uses a legacy Mainframe infrastructure to send data to Big Query. The project's primary objective is to convert the CA7 jobs to Control M jobs and understand the existing functionality and convert all the mainframe workflows to new tech workflows (like python, pyspark, scala). Also iteratively improves the system's efficiency, scalability, and maintainability. Also maintaining and supporting 11K mainframe, DataStage, and Teradata jobs which are used by different teams to generate reports or make business decisions.
Responsibilities
Migrate the CA7 jobs to Control M.
Understand and create the Functionality Design documents for the existing Mainframe workflows.
Create new programs using python/scala/pyspark depends on the functionality design documents.
Identify issues with jobs that repeatedly abend and make code changes to JCL or COBOL to prevent these abends.
Optimized a critical COBOL based application through CA Gen
Interfacing Assembler programs with JCL, and CICS for enterprise applications.
Developed and optimized high-performance Assembler programs for batch and online processing.
Understand the system and business requirements and propose the best feasible solutions to reduce the number of job abends due to large volume of data increase.
Discuss with the business team to provide alternative solutions for the jobs which are consuming more MIPs and repeat abends.
Understand the DB2/Teradata and convert it to Big Query.
Coordinate the on-call rotations and as L3 support team, help L2 and L1 teams for the incident resolution.
Create WSRs and MSRs to track and document the team’s progress and conduct meetings with higher management. Identifying challenges and plan strategies for the next weeks accordingly.
Coordinating with offshore Vendor team with Job failures and repeat abends and other support activities.
Environment: Mainframe, CA Gen, MVS, TSO/ISPF, COBOL, JCL, VSAM, DB2, SQL, TERADATA, FILE-MANAGER, ABEND AID, XPEDITOR, SDSF, DataStage, Informatica, GCP, Big Query, Python, GitHub, Scala.
CVS Health, Centerton, AR Aug 2022 – Jan 2023
Technology Architect
Project: OSS-MF-ETL
Description: OSS Mainframe project is a primary support project for mainframe applications along with ETL process. This project supports 24/7 across all the applications in Mainframes as well as some of the Informatica, Teradata and SAP applications. Along with support, improving the system efficiency depends on the incidents.
Responsibilities
Responsible for monitoring and maintaining all mainframe systems.
Supporting ETL processes to extract data from various sources, transform the data depending on business rules/needs and load the data into a data warehouse or other systems.
Fixing all the job failures before SLA breach.
Monitoring Informatica, Teradata and SAP systems as primary support and informing App team if there are any issues which require business team involvement.
Batch cycle support for Mainframe applications.
Coordinate with the Infrastructure teams, Storage teams, Data subset teams and Upstream applications.
Analyzing the root cause for the frequent issues and fixing it in test region and send to App team for the review.
Program Code changes using ISPF GitHub.
Preparing weekly and monthly reports for the incidents
Report status to Project team as well as higher management.
Working on SDSF, Xpediter, abend-aid and control M.
Environment: OS/390, MVS, TSO/ISPF, COBOL, JCL, VSAM, DB2, PL/SQL, CICS, ISPW Git, FILE-MANAGER, TERADATA, ABEND AID, XPEDITOR, SDSF, CLIST, DFSORT, SYNCSORT, REXX, Unix, Informatica, DataStage, GitHub, SAP application.
Tyson Foods, Bentonville, AR Mar 2020 – Jul 2022
Technology Lead
Project: Fresh Meats
Description: Fresh Meats application is a support and maintenance project for Time and attendance and HR system to calculate the gross pay of employees and send to SAP payroll. HR system is a collection of screens to run reports and receive the data from SAP and loaded to FM database. T&A system has the punch details of the employees which will come from Kronos system. Also, it has been designed to transform the data using DataStage technology to develop enterprise data warehouse. Also supporting the Master data for trade tables.
Responsibilities
Performing in different roles as a technical lead and senior application developer in obtaining requirements from user and converting the requirements into design specifications, preparing system specifications, and assigning tasks to team members and tracking the progress
Involved as Mainframe and ETL development lead during the analysis, planning, design and development stages of the project.
Developed and maintained payroll processing applications on mainframe systems, ensuring accurate salary calculations and deductions.
Interacting with business leads for better understanding of the current system issues.
Impact analysis on new requirement or change request on the existing programs.
Created and updated the incidents in SERVICE NOW for support activities as well as code deployments.
Designing the new components using CICS and DB2 and COBOL and JCL design concepts
Changing the existing MAPs and CICS programs as per business requirement and deploying the changes on a regular basis.
Operated and managed mainframe payroll systems. Processing payroll across the states.
Implemented payroll tax calculations, benefits processing, and compliance checks within mainframe applications.
Ensured timely and accurate payroll processing, including regular wages, bonuses, overtime and deductions.
Improved payroll processing efficiency by optimizing the queries in mainframe programs.
Developed payroll reports and audits using COBOL and DB2, ensuring compliance with financial and regulatory requirements.
Implemented payroll reconciliation processes, ensuring accuracy in salary payments, tax deductions, and compliance reporting.
Debug the .net programs to analyze the data flow
Writing and modifying COBOL programs for applications running on the Unisys 2200 system, ensure that they align with business requirements
Worked on CMOD for different reports storing and accessing
Sending the reports using JCL on weekly/monthly basis
Updating the existing JCLs to handle the next generation changes.
Performing functional testing and unit testing for batch and online programs
Working on ISPF, SDSF, Xpediter, abend-aid.
Reviewing and optimizing COBOL code to ensure maximum efficiency in data processing and system resource utilization on the UNISYS 2200
Analyzing .Net code for the root cause of the Data base issues
Analyzing system flow, data usage and work processes, and investigated problem areas.
Working knowledge on Power BI Dashboards and having experience as Power BI Admin.
Troubleshoot and debug any PL/SQL issues within the database.
Conduct internal reviews and participate in external audits.
Coordinating the offshore activities and providing guidance on day-to-day activities
Environment: OS/390, MVS, TSO/ISPF, COBOL, ASP.Net,JCL, VSAM, DB2, IMS DB,Unisys, TERADATA, PL/SQL, CICS, FILE-MANAGER, Easytrieve, ISPF GitHub, REXX, SPUFI, ABEND AID, XPEDITOR, SDSF, CLIST, DFSORT, SYNCSORT, QMF, Mobius, Control M, Datastage, Oracle, .Net, GCP, SPARK, BigQuery, PYTHON, PowerBI
Walmart, IND Apr 2017 – Feb 2020
Technology Lead
Project: Master Data
Description: Master Data is a maintenance project to process and maintain the customer’s data. The purpose of the project is to help the pharmacy IT division develop solutions that improve the centralized management of patient data. It also focuses to integrate the digital and physical aspects of patient processing in a redefining way – by providing existing system functionalities via the cloud, which will be easily accessible via web services with the hope of improving the customer experience while drastically reducing the processing time without compromising on compliance.
Responsibilities
Working in Agile product and participating in sprint planning and retrospective sessions.
Provide estimations in story points for the tasks to be delivered as part of product iterations.
Designed and implemented RESTful API endpoints for mainframe-based services, improving data accessibility for frontend applications
Developed the code in ATTACHMATE.
Tested the code in SoapUI for request and responses.
Used Sonar tool for code reviews.
Optimized a critical COBOL based application through CA Gen
Created and updated TFS Dashboard and JIRA for task and other issues and SERVICE NOW for code deployment
Worked on core Java front end side to understand the functional flow of the data
Worked Java APIs for the request/response process
Creating XML, JSON, WSDLs, Python scripts to send the data from mainframe application to Java application and validating in JAVA application.
Participated in code and design reviews and scrum, sprint calls.
Coordinated with multiple vendors from geographically distributed teams for a successful development, testing and deployment of a single project.
Environment: OS/390, MVS, TSO/ISPF, COBOL, CA Gen, JCL, VSAM, DB2, Core Java,SQL, REXX, PYTHON, CICS, FILE-MANAGER, SPUFI, ABEND AID, XPEDITOR, SDSF, CLIST, STROBE, CA7, SAVRs, DFSORT, SYNCSORT, DBeaver, RESTful APIs, CICS Explorer, Attachmate, JAVA, SoapUI.
Wells Fargo, IND Jan 2015 – Mar 2017
Technology Analyst
Project: Receivable Manager (RM)
Description: Receivables Manager is a remittance processing application of the Bank. This enables customers to automatically update their accounts receivable system – including check, ACH, WIRE, Desktop Deposits, Merchant Receivables, Patient payments, EBILL express, Bank’s Payment gateway – by creating a single, consolidated file of paper and electronic remittance information.
Responsibilities
Estimation and impact analysis based on the requirements.
Detailed Design preparation based on impact analysis document.
Coding based on detailed design document.
Unit & Regression testing of the code.
Peer reviews for all the deliverables.
End to end delivery of the tasks assigned.
Offshore-onsite team coordination.
Assigning the tasks to team members.
Development of various value adds/tools for clients.
Team mentoring for new jonnies in project.
Project management activities
Preparing knowledge management documents and sharing technical and domain related knowledge on a regular basis.
Defect Management and Configuration Control activities.
Environment: OS/390, MVS, TSO/ISPF, COBOL, JCL, VSAM, DB2, SQL, CICS, REXX, FILE-AID, FILE-MANAGER, SPUFI, ABEND AID, XPEDITOR, SDSF, CLIST, STROBE, CA7, SAVRs, DFSORT, SYNCSORT, Endevor, VISIO, Attachmate.
Wells Fargo, IND Apr 2014 – Dec 2014
Senior System Engineer
Project: Wire Transfer (WT) – Migration Project
Description: Wire Transfer project is a migration project. To accommodate the future needs and requirements, client have decided to migrate the programs from PLI to COBOL. The technical design and functionality of the programs should not be changed while converting the programs from PLI to COBOL. The JCLs and PROCs remains same whereas the program names also same but the code for the logic would change from PLI language to COBOL language.
Responsibilities
Analyzed the programs which are present in PLI and understood the functionality of the programs.
Developed COBOL programs to be functioned like PLI programs.
Developed online PLI programs using CICS programs.
Maintained the run time of COBOL program same as PLI program.
Prepared all types of documents like TDD, TPD, TRD and Metrics documents for future reference.
Coordinated with the client and onsite regarding functionality of the programs.
Performed Unit testing and regression testing.
Advised the clients to remove the existing known defects and develop the COBOL programs as flawless programs.
Developed the compare tools to compare PLI program outputs with the COBOL program outputs.
Environment: OS/390, MVS, TSO/ISPF, COBOL, JCL, VSAM, DB2, SQL, CICS, PL1, REXX, FILE-AID, FILE-MANAGER, SPUFI, ABEND AID, XPEDITOR, SDSF, CLIST, STROBE, CA7, SAVRs, DFSORT, SYNCSORT, Endevor, VISIO, Attachmate.
Lexis Nexis, IND Mar 2011 – Mar 2014
System Engineer
Project: Billing and Mainframes (BAM)
Description: BAM project is to process the billing of the customers. The billing is depending on the usage of the data and the mode of usage. All the customer’s billing details are processed and maintained in the IMS database. This is a maintenance project to support the continuous execution of the application smoothly.
Responsibilities
Responsible for providing application support on a 24/7 basis.
Worked on Root Cause Analysis and proposed the solutions for the bugs.
Analyzed the existing program and incorporated the requirements without changing any existing functionality.
Design, development, testing, debugging the code, regression testing and deliver it to User Acceptance Testing.
Prepared all types of documents like Technical Design Document, Test Plan Document, Test Results Document and Metrics.
Making quick changes as per the requirement to make the jobs run smoothly in production.
Identified the required changes for existing functionality to make sure that the job won’t fail with the same issue and make the changes with the client approvals.
Developed the tools to decrease the human effort to make the production jobs run on time.
Prepared DSR (Daily Status Report), WSR (Weekly Status Report) and MSR (Monthly Status Report).
Environment: OS/390, MVS, TSO/ISPF, COBOL, JCL, VSAM, IMS DB, CICS, FILE-AID, FILE-MANAGER, SPUFI, ABEND AID, SDSF, CA7, SAVRs, DFSORT, SYNCSORT, Endeavor.
EDUCATION
Master of Computer Applications in 2010 from PVP Siddhartha Institute of Technology, Vijayawada, Jawaharlal Nehru Technology University Kakinada, Andhra Pradesh, India.
Bachelor of Science in Computers in 2007 from Andhra Pradesh Residential Degree College, Nagarjuna Sagar, Acharya Nagarjuna University, Andhra Pradesh, India.
Contact this candidate