SUMMARY

• Possess 12 Years 10 Months of extensive hands on IT industry experience in Application Development, Maintenance, Testing and Production Support projects involving end - to-end Project Life Cycle, complete Software Development Life Cycle (SDLC) as well as AGILE methodology
• Widespread experience in handling Requirement Gathering, Analysis, Core Application Design, Code Development, Implementation, Testing, Integration, Deployment, Documentation and Maintenance/Production Support of IBM Mainframe applications
• Strong work experience on large scale Mainframe applications interacting with Distributed Systems via Java - JCICS layer and CICS Web Services, Integrated Architecture with middleware Messaging Queue (MQ’s) and UNIX
• Extensive experience working in Application Modernization and Digital Transformation initiatives
• Expert in working on multi-tier architecture which involves calling Mainframe COBOL/PL-1/CICS programs directly from front-end applications executing on Java platform through IDF-OSA SQL calls
• Possess the ability to multi-task work across different applications. Diverse work experience with different functionalities of the application, with Development and Production Support projects
• Significant experience working in agile development projects with acquaintance of working on Rally, Kanban framework, Remedy, ServiceNow, Quality center, SharePoint, JIRA, Confluence. Involved in estimate planning, design discussions and scrum meetings for the project
• Extensive experience working as an onsite lead, managing projects by working closely with the clients, end users to gather requirements, prepare High Level Design (HLD), Low Level Design (LLD), and transition the design and requirements to offshore team to deliver highly successful projects on time based on the onshore-offshore global delivery model
• Developed MQ programs involving LOCAL and REMOTE queues connecting to other platforms
• Vast hands-on experience on developing DB2 SQL’s and REXX tools. Have strong exposure in working on both Batch/Real Time Mainframe systems. Excellent knowledge developing DB2 Stored Procedure
• Highly skillful in preparing QMS (Quality Management System) documents like Project Initiation, Project Action Plan, Detailed Requirements Specifications, Impact Analysis, File Specifications, System Run Charts, Data Base Requirements, Program Specifications, Operation Manual, Program Development, Coding, Unit/System/UA Test plan, Implementation/Post implementation plans
• Automated various daily activities using REXX, EXCEL, VB Script macros to improve throughput
• Driven Idea campaigns within teams to bring forth ideas on to the table for business improvement

TECHNICAL SKILLS

Roles Played: Developer, DB2/Teradata DBA, Technical Lead, App Mod Solution Specialist

Domain Expertise: Banking Solutions | Retail CPG | Securities & Capital Markets | Health Care

Programming Hands-On: VS COBOL-II, JCL, CICS v 4.1.0, PL/I, REXX

Databases: DB2 v10, Datacom, NCR Teradata v10, Microsoft SQL, IMS DB, Natural ADABAS, Oracle 12c

Middleware: IBM MQ Series 5.3, NDM, FTP, EFX, SMTP, Connect Direct, UDS/NDT2, IBM Content Navigator OnDemand

Operating Systems: z/OS v 1.2, Microsoft Windows, MS DOS

Tools: TSO, ISPF, Smart Sort, DFSORT, SYNCSORT, ICETOOL, CA-EZTrieve, View Direct, CA DB Tools, SPUFI, BMC4DB2, IBM RDz/RTC, ChangeMan/ZMF, Endevor, ServiceNow, BMC Remedy, ISM, CCM. Net

Performance Monitoring tools: IBM QMF, CQM, Freeze Frame, STROBE, OMEGAMON, TMON DB2, TMON CICS, TMON MQ2, MQ Monitor, IBM Application Performance Analyzer

Batch Schedulers: OPC Tivoli Work Load Scheduler, CA-7, ESP Scheduler, CA Jobtrac Job Management, BMC Control-M job scheduler

Debugging Tools: Dump Master, Abend-Aid, IBM Debugger, IBM Xpeditor, IBM Fault Analyzer

File Managers: File-Aid, Star Tool, CA-File Master Plus, INSYNC, VSAM/GDG Operations

Microsoft Applications: MS Word, Excel, Power Point, Access, Visio, Visual Source Safe, Project Planner

PROFESSIONAL EXPERIENCE

Confidential | Woodland Hills, CA

Mainframe Tech Lead

Responsibilities:

• Leading the Letters and Reports development track by providing guidance and recommendations regarding the future state, including platforms, middleware, application architecture, suggested reengineering approaches, performance and security considerations
• Design thinking: Build Functional and Technical designs for each business requirement received
• Solution Architecting: Brainstorm with client architects in order to come up with the best/optimal technical solution for the business requirements. Proposals involved using DB2 vs IMS database to store migrating legacy data, load balancing by using multi-threaded batch jobs in Control-M, using tableBASE (Data Kinetics) to manage data in real-time at the same time receiving high performance from the new batch programs
• Analyze the current state of legacy applications. Research existing complex legacy production COBOL-IMS programs to identify enhancements based on the business requirements
• Facilitate migration from legacy systems CHIPS, FACETS, ACES, CS90 to modernized platform WGS
• Develop/modify backend Mainframe programs to enhance the ability of the system but still maintaining the integrity of the legacy applications
• Provide technical design guidance to the application team, coordinate technical activities to ensure smooth system operation, implement and enforce standards
• Perform code reviews, monitor modernization / mitigation activities, coordinate application builds and deployments as appropriate
• Perform Control-M batch schedule level analysis in order to ascertain the feasibility of implementing new letters batch processes within the current system
• Coordinate testing as appropriate, and oversee interfaces and batch cycle activities as appropriate
• Coordinate with multiple customer stakeholders single handedly to fulfil business requirements and implement the project into production environment
• Work as a solutions builder on a collaborative environment, think-tank feel and share new ideas with colleagues
• Work with PSD (Publications Solution Delivery) team and Print Mail teams to successfully implement brand new letters needed as per legal requirements for each state
• Create Change Requests & Incidents in ServiceNow (SNOW) and facilitate Release Management activities during production implementation

Confidential | Quincy, MA

Mainframe Tech Lead

Responsibilities:

• Story/Sprint Planning >> Requirement Gathering >> Scrum Meetings >> System Analysis >> Product Owner and SME discussion on Definition of Done (DoD)
• Developed several new PL1 batch and online, COBOL-DB2, CICS-DB2 programs as per customer’s business requirements and implemented them in production without much defects
• Monitored critical system objects like MQALRT*, CICS region JCLs and DB2MSTR to check proactively for any program related errors that could occur due to the new programs developed
• Proficient in using TSO/ISPF and File Manager to create and modify VSAM (KSDS), PDS, PS and GDGs
• Expert in using all the TSO commands/shortcuts and TSO/ISPF utilities
• Resolved issues arising due to MQ COMMITs, CICS SYNCPOINTS or DB2 deadlocks from program standpoint. Ensured that COMMITs and ROLL BACKS are coded effectively in the programs
• Co-ordinated with IBM MQ Admins to resolve issues around LOCAL-REMOTE queues used between Mainframe, UNIX and Java (UI)
• Used CICS Web Services to integrate with the J2EE applications running in WebSphere Application Server
• The COBOL-CICS programs were running in the backend to receive input from the Java application through COMMAREAs
• Coordinated with the Java application team closely and debugged the JCICS Service Class which issued the EXEC CICS INVOKE SERVICE command in case of failures
• Coordinated with the Java application team and have written a Java Web service that can parse and generate an XML for the body of the SOAP message
• Interpreted the XML into a COMMAREA mapping to be used effectively on the backend CICS programs and SUB ROUTINES
• Set up new JCLs to unit test the new programs developed. Efficient in using the PARM/COND parameter in the JCLs to handle different client requirements appropriately
• Developed new JCL jobs and procedures and execute them in newly created job streams in TWS with the COBOL batch programs developed in order to test customer’s production data
• Developed JCL jobs to execute most of the routine IBM utilities like IEFBR14, IEBGENER, IDCAMS, IEBCOPY, IKJEFT01, SORT, ICETOOL, etc.,
• Monitor job execution and analyze output of jobs through SDSF and $AVRS to identify the job flow and the reason for the abend
• Developed new DB2 Stored Procedures which get called directly from Front End Java application and passes business user’s application data back to the GUI
• Implemented new batch Special Resources on the TWS schedule and controlled the batch scheduled to ensure effective execution between multi-region applications in the production environment
• Created new DB2 tables to be accessed in the COBOL programs and test the data INSERT/UPDATE/DELETE by coding new SQLs in the program
• Use NDM to transfer files between Mainframe the Accounting regions to Common region or vice versa
• Completed coverage of Unit Test cases in line with the identified stories in the sprint
• Identified programmatic issues during unit testing. Whenever they are difficult to resolve they have run through IBM Debugger tool and checkpoints are kept at critical intervals to find root cause of the issue
• Handed over the developed code to the SQA groups for User Acceptance Testing
• Was responsible for correct versioning of code by creating and moving the packages using IBM RDz
• Production Deployment >> Warranty Support >> Business Lead and Product Owner Signoff
• During Warranty Support, used OPC Tivoli Workload Scheduler (TWS) to monitor job runs and ensured they are abend-free. If they abend due to the deployment related issues, troubleshoot the abend in production and use FIRECALLs, coordinate with IBM COMMAND CENTER to resolve issues per SLA
• Ensured % of spilled tasks over sprint is less than 5%, raised impediments that are impacting the tasks to be completed, achieved planned sprint velocity in collaboration with the team
• Resolved 100% of tasks and impediments assigned to me
• Ensured % of defects due to code changes is restricted to planned tolerance
• Followed the customer coding standards. Ensured Sev 1 / Sev 2 / Sev 3 defect leakage is ZERO
• Implemented the solution by writing Optimized and reusable Code
• Implemented DB2 QREP (Q-REPlication) in all the non-production regions by effectively writing out the business rules as part of the QREP Subscriptions
• Ensured and supported the DB2 QREP installation between Mainframe DB2 tables in production
• Resolved the issues arose as part of the QREP installation
• Resolved DB2 utility failures in live production regions
• Assisted/advised application teams on database design, development process & online DB failures
• Investigated and resolved production environment problems
• Used BMC for DB2, QMF, IBM TOOLs (ADM Administrator) and CA-Platinum tools such as RC Query for querying database objects for effectiveness

Confidential

Technical Lead/Process Manager

Responsibilities:

• Managed an offshore Mainframe Batch Support team of 28 people
• CMMI-SVC v1.3 standards implementation
• Co-ordinated and provided consultation for information security audits
• Provided inputs to enable customers to move towards Business Process Management and Service Next
• Regularized Process Performance Baselines (Org Metrics Goals)
• Standardized application quality baselines for managed services engagements through Technical Quality Index (TQI) and other application quality health factors like control charts and PPBs for C-chart and XBar-S
• Established SLA and KPI definitions specific to engagement and ensure 100% SLA adherence
• SPOC for all the Severity 1/2 incidents and for all cross functional issues between infra & apps teams
• Created problem tickets for recurring incidents by identifying the problematic CTIs
• Ensured the overall availability of applications in the system by determining any unplanned outages which might cause severe downtime for a particular application
• Established a performance scorecard for the engagement after obtaining sign off from the customer
• Ensured collection and analysis of metrics at program level and implement corrective/preventive actions based on analysis results
• Produced performance against all SLA targets (daily and weekly dashboard) and perform an RCA for breach of each service level
• Initiated and produced exception reports whenever there is an SLA breach. Also prepare SLA failure analysis in order to provide exact root cause and reasons
• Highlighted any process issues, third party dependencies to customer that impact service in a timely manner
• Reviewed metrics, trends for the purpose of redefining metrics to achieve the program goals of productivity and quality
• Performed internal service and quality reviews on meeting SLA
• Reviewed internal performance (for all suppliers) monthly and if required review the underpinning agreement or OLA
• Used very effectively all the tools available in Excel like Pivot, Graphs, Tables, Formulas and Functions to generate management reports and shared with the upper management
• Performed impact analysis and provide recommendations when there is a change in service level scope
• Initiated and owned any actions items as required to maintain or improve service levels
• Implemented all activities as per the Service Definition and Quality Assurance as and when required
• Reviewed workload trend, analyze peaks and forecasts to proactively plan

Confidential

Sr. Developer

Responsibilities:

• Analyzed FBR’s (Functional Business Requirements)
• Prepared Functional Specification Documents (TDD, HLD, DLD, CSPEC)
• Prepared Business Flow Diagrams (VISIO)
• Created Unit Test Plans and Test Cases (UTP)
• Developed new COBOL-DB2, COBOL-IMS DB, CICS, REXX programs as per customer’s business requirements
• Included DL/I calls inside COBOL application program to communicate with IMS database and to access the database
• Most of the IMS DB calls coded in the programs involved the various IMS commands like GU, GHU, GN, GHN, GNP, GHNP, ISRT, DLET, REPL, CHKP, XRST. Developed these processes to dump database segments selectively based on keys, also convert them to DB2 format
• Proficient in using TSO/ISPF and File Manager to create and modify VSAM (KSDS), PDS, PS and GDGs
• Expert in using all the TSO commands/shortcuts and TSO/ISPF utilities
• Developed new JCL jobs and procedures and execute them in newly created job streams in TWS with the COBOL batch programs developed in order to test customer’s production data
• Set up new JCLs to unit test the new programs developed. Efficient in using the PARM/COND parameter in the JCLs to handle different client requirements appropriately
• Developed JCL jobs to execute IBM utilities like IEFBR14, IEBGENER, IDCAMS, IEBCOPY, etc
• Monitor job execution and analyze output of jobs through SDSF and $AVRS to identify the job flow and the reason for the abend
• Created new DB2 tables to be accessed in the COBOL programs and test the data INSERT/UPDATE/DELETE by coding new SQLs in the program
• Used DB2 interactive utilities like TMON DB2, STROBE in order to monitor SQL query performance
• Developed EZTrieve routines to ease out data manipulation for testing purposes
• Organized and stored reference information about Unit Tests and Test Cycles in Rational Clear Quest
• Tested (Unit/Integration/System/Interface) the newly developed programs
• Handed over the developed code to the SQA groups for User Acceptance Testing
• Implemented the developed code in all production environments through configuration management tool ChangeMan
• Identified programmatic issues during unit testing. Whenever they are difficult to resolve they have run through IBM Expeditor tool and checkpoints are kept at critical intervals to find root cause of the issue
• Was responsible for correct versioning of code by creating and moving the packages using ChangeMan
• Production Deployment >> Warranty Support >> Business Lead and Product Owner Signoff
• During Warranty Support, used CA Jobtrac Job Management tool to monitor job runs and ensured they are abend-free. If they abend due to the deployment related issues, troubleshoot the abend in production and coordinate with IBM COMMAND CENTER to resolve the issues as per SLA
• Troubleshoot the production abends like File Contention errors, Space abends, VSAM file related abends, DB2 abends and program related data issues S0C7, S0C4, S0C1, etc (if any) and provide quick resolutions
• Prepared a report with the end results/statistics of the production execution and present it to the customer management and end-clients/business users

Confidential

Sr. Developer

Responsibilities:

• Developed complex COBOL programs and customize them as per the new mainframe environment
• Developed mainframe environment components, build and load CICS regions using CICSPLEX
• Created batch schedules in TWS and execute them as part of application maintenance
• Created EZTrieve programs to generate flat files, VSAM, GDG bases required for the environment to be operational
• Forecasted future environment build activities and plan for leaves for self and team members
• Proficient in using TSO/ISPF and File Manager to create and modify VSAM (KSDS), PDS, PS and GDGs
• Expert in using all the TSO commands/shortcuts and TSO/ISPF utilities
• Set up new JCLs to unit test the new programs developed. Efficient in using the PARM/COND parameter in the JCLs to handle different client requirements appropriately
• Developed REXX tools & utilities for automating the routine environment build activities
• Support the production ADABAS database by providing 24x7 coverage
• Resolve the technical issues arising due to ADALOAD on the ADABAS environment
• Analyze the NATURAL programs in case of data issues related to the ADABAS database. Check the DDM (Data Definition Module) for the information about the individual fields of database file
• Developed product agility by fine-tuning existing SQLs thereby boost system performance
• Handed over the developed code to the SQA groups for User Acceptance Testing
• Organized and stored reference information about Unit Tests and Test Cycles in Rational Clear Quest
• Implemented the developed code in all production environments through configuration management tool ChangeMan
• Was responsible for correct versioning of code by creating and moving the packages using ChangeMan
• Production Deployment >> Warranty Support >> Business Lead and Product Owner Signoff
• During Warranty Support, used CA Jobtrac Job Management tool to monitor job runs and ensured they are abend-free. If they abend due to the deployment related issues, troubleshoot the abend in production and coordinate with IBM COMMAND CENTER to resolve the issues as per SLA
• Troubleshoot the production abends like File Contention errors, Space abends, VSAM file related abends, DB2 abends and program related data issues S0C7, S0C4, S0C1, etc., and provide quick resolutions
• Identified programmatic issues during unit testing. Whenever they are difficult to resolve they have run through Abend-Aid tool and checkpoints are kept at critical intervals to find the root cause of the issue
• Arranged for daily status update call on progress of the application build with stakeholders
• Interacted/Mentored offshore team members. Provide timely updates to Customer / SME. Set up regular project meetings to highlight issues/concerns to the SME’s and key stakeholders
• Prepared reports (Weekly/Monthly Status: Work Package Checkpoint Report to Customer PM's)
• Procured relevant application level accesses to self and team
• Maintained/Updated each portfolio level applications inventory, SMTD and technical documents
• Prepared monthly timesheets for billing and submit for invoicing
• Maintained project level trackers - Efforts / Leave / Shift Allowances / Resource On-boarding

Confidential

Mainframe DB2 DBA and Teradata Administrator

Responsibilities:

• Proficient in using TSO/ISPF and File Manager to create and modify VSAM (KSDS), PDS, PS and GDGs
• Expert in using all the TSO commands/shortcuts and TSO/ISPF utilities
• Creation of database objects like storage groups, database, tablespace, etc.,
• Storage estimation, granting access to DB2 objects, generate database reports using pre-defined standard procedures
• Proficient in using IBM DB2 utilities such as IMAGE COPY, RUNSTATS, RECOVERY, REORG, INZUTILB, LOAD and others
• Resolve failures in live regions
• Assist and advice application team on database design, development process and online database failures
• Production problem investigation and resolution
• Performance monitoring and tuning, database compression techniques
• Use BMC for DB2 and CA-Platinum tools such as RC Query for querying database objects and perform database administration
• Performance tuning, collecting statistics, analyzing explains & determining which tables needed statistics. Increased performance by 35-40% in most of the situations
• Proficient in using Teradata utilities such as MULTILOAD, BTQMAIN, FASTLOAD, FASTEXPORT
• Created & modified databases, performed capacity planning, allocated space, granted rights for all objects within databases
• Worked on creating and managing the partitions
• Performed database health checks and tuned the databases using Teradata Manager
• Deliver new and complex high quality solutions to clients in response to varying business requirements
• Responsible for correct versioning of code by creating and moving the packages using Endevor
• Created and managed user accounts
• Installed Teradata drivers for the Teradata utilities. Used Teradata Administrator and Teradata Manager Tools for monitoring and control the system

Confidential

On-Call Support Analyst/Module Lead

Responsibilities:

• Owned and managed the entire offshore batch support team and execute the project as per norms
• Allocated tasks & responsibilities for resources and ensuring co-ordination within teams
• Showed consistent month-on-month improvement on MTTR for batch incidents and RCA’s trend. Also show reduction in 2nd / 3rd callouts as well as utilization of self and reportee’s
• Prepared shift plans and managing shifts for offshore resources. Ensure that all the team members are cross-trained across portfolios to manage workload
• Proficient in using TSO/ISPF and File Manager to create and modify VSAM (KSDS), PDS, PS and GDGs
• Expert in using all the TSO commands/shortcuts and TSO/ISPF utilities
• Used FreezeFrame which was the first cost effective application performance measurement (APM) tool for z/OS and OS/390. Measured and reported on how system resources are used in Batch, CICS, DB2, and Teradata
• Ensured ZERO SLA/OLA breach at all levels - Incidents, customer reports, etc. Set up Weekly Status Meetings to interact with On-Site on a regular basis
• Maintained sufficient resource backups/rotations and high team spirits to ensure seamless delivery/business continuity
• Identified programmatic issues during unit testing. Whenever they are difficult to resolve they have run through Dump Master tool and checkpoints are kept at critical intervals to find the root cause of the issue
• Used ESP Scheduler tool to monitor job runs and ensured they are abend-free. If they abend due to the deployment related issues, troubleshoot the abend in production and coordinate with IBM COMMAND CENTER to resolve the issues as per SLA
• Troubleshoot the production abends like File Contention errors, Space abends, VSAM file related abends, DB2 abends and program related data issues S0C7, S0C4, S0C1, etc (if any) and provide quick resolutions
• Ensured overall team compliance on mandatory trainings and assessments. Participate in ticket audits, brainstorming sessions and technical forums

Confidential

Developer

Responsibilities:

• Analyzed FBR’s (Functional Business Requirements)
• Prepared Functional Specification Documents (TDD, HLD, DLD, CSPEC)
• Prepared Business Flow Diagrams (VISIO)
• Created Unit Test Plans and Test Cases (UTP)
• Developed new COBOL-DB2, COBOL-IMS, CICS, REXX programs as per customer’s business requirements
• Included DL/I calls inside COBOL application program to communicate with IMS database and to access the database
• Most of the IMS DB calls coded in the programs involved the various IMS commands like GU, GHU, GN, GHN, GNP, GHNP, ISRT, DLET, REPL, CHKP and XRST. Developed these processes to dump database segments selectively based on keys, also convert them to DB2 format
• Proficient in using TSO/ISPF and File Manager to create and modify VSAM (KSDS), PDS, PS and GDGs
• Expert in using all the TSO commands/shortcuts and TSO/ISPF utilities
• Use Connect:Direct to transfer files between Mainframe environment to the vendor’s .Net server
• Set up new JCLs to unit test the new programs developed. Efficient in using the PARM/COND parameter in the JCLs to handle different client requirements appropriately
• Developed new JCL jobs and procedures and execute them in newly created job streams in TWS with the COBOL batch programs developed in order to test customer’s production data.
• Created new DB2 tables to be accessed in the COBOL programs and test the data INSERT/UPDATE/DELETE by coding new SQLs in the program
• Used DB2 interactive utilities like TMON DB2, STROBE in order to monitor SQL query performance
• Developed EZTrieve routines to ease out data manipulation for testing purposes
• Organized and stored reference information about Unit Tests and Test Cycles in Rational Clear Quest
• Tested (Unit/Integration/System/Interface) the newly developed programs
• Responsible for correct versioning of code by creating and moving the packages using Endevor
• Troubleshoot the production abends like File Contention errors, Space abends, VSAM file related abends, DB2 abends and program related data issues S0C7, S0C4, S0C1, etc., and provide quick resolutions
• Prepared a report with the end results/statistics of the production execution and present it to the customer management and end-clients/business users