Mainframe, Natural/Adabas, Cobol/DB2, Jcl, Ims-Db, Jira, Kanban
Resume:
VIKAS KUMAR PANDEY
Email : ****************@*****.***
Mobile : +1-225-***-****
Summary:
Currently working as a Senior Application Programmer at HTC Global and having more than 14 years of IT experience. As part of my assignments:
•Have been a part of the Analysis, Design, System Testing, Programming, Maintenance & Support and Implementation stages of the project process cycle.
•Worked as a Subject Matter Expert for Treasury and Payment reconciliation system
•Worked extensively in Natural, COBOL, AFP, Overlays, ADABAS, JCL, DB2, and SQL.
•Expertise in requirement analysis and writing Test Plan for system testing.
•Knowledge of Industry: Banking and Petrochemical and Child Support enforcement domain.
•Mentored and guided employees ensuring all were trained in application and technical knowledge and capable of performing assigned duties.
•Developed online and batch programs using NATURAL/ADABAS, Natural/DB2, Natural/IMS, Cobol/DB2, COBOL/IMS.
•Developed AFP and overlay programs to print notices.
•Working as a Scrum Mater on team transition from SDLC to Agile
Areas of Expertise:
Technical Areas:
•Languages - Natural, Cobol, AFP, Overlays, JCL, FOCUS, SAS, Rexx
•Database - ADABAS, DB2, SQL, IMS
•Operating Systems - Windows9X/XP
•Tools and utilities - JIRA, KANBAN Board, TSO/ISPF, Endevor, Easytrieve, FileAid, CA7, SDLM, QC, Clarify, IBM utilities, Natural Engineer, IDT, WEBI, Remedy, I Request, Team Track, MyID, Clearquest
Process and Other Areas:
•Application Analysis
•Enhanced sprint planning skills
•Extensive knowledge of backlog management
•Effective leadership, team building and communication skills
•Ownership Attitude
•Presentation Skills
Certification:
•IBM DB2 9 Fundamentals
•KYI – Petrochemical Industry
•BFS L0, BFS L1 (Treasury and cash management), COBOL L0, JCL L0.
•Cognitive Class: Data analysis for python
•Cognitive Class badge: Python for Data science
https://www.youracclaim.com/badges/87cd0961-e862-4f78-8ac6-d901f4681324/public_url
•Cognitive Class badge: IBM Blockchain Essentials
https://www.youracclaim.com/badges/2f47d578-fd0c-4f94-8ad2-8ef842308fed/public_url
•Mainframe Application Services - Z/OS Application Development and Support
Issued by IBM
https://www.youracclaim.com/badges/87a9cf79-67ce-41ad-bb90-2a9f7afd0c1f/public_url
Professional Experience:
Projects Worked On:
Project: 3
Title: The Department of Children and Family Services (DCFS)
Technology: Natural, JCL, AFP, Overlays
Database: Adabas
Duration: Jan 2020 – Till date
Company: HTC Global
Client Description:
DCFS is working to keep children safe, helping individuals and families become self-sufficient, and providing safe refuge during disasters.
Description of Project:
•The Department of Children and Family Services (DCFS), Fraud and Recovery Unit (FRU) in an effort to protect recipients’ personal information, needs to have the recipient’s social security number (SSN) disguised on the majority of the correspondence generated from the Recovery Account System (RAS).
OTS will make changes to RAS on outgoing correspondence that will disguise the SSN using a combination of letters and numbers.
•The Fraud and Recovery Unit (FRU) needs the current letter head updated to reflect FRU is no longer under Program Integrity.
Roles and responsibilities in the project:
•Currently handling RAS, SIEVS, TIPS and LASES application for DCFS.
•Collaborate with team members to develop timelines, sprints and tasks to complete for upcoming projects.
•Build policies and educational materials to update team members, managers and stakeholders on scrum methodologies and Agile frameworks.
•Develop new online and batch programs in CICS and TSO environments for the above projects using NATURAL/ADABAS
•Develop new AFP and Overlays to generate notice
•Modify existing modules to include new requirements
•Modify existing AFP modules to include new requirements
•Develop, maintain and execute unit test scripts/plans
•Update and maintain Object Traceability Matrix and other IEEE standard documentations
•Perform unit testing and system integration testing
•Modify existing JCLs and create new ones to execute batch programs
•Develop adhoc programs using Natural / Adabas to extract data from TIPS and LASES system for reporting purpose.
•Meticulously gathered and documented business rules from complex mainframe systems and applications, in order to mentor and provide knowledge transfer to other consultants.
•Frequently strategized with business clients and team to design full cycle project documentation and assign tasks, both in Waterfall and Agile.
•Achieved company’s “Your Best Style” award for conceptualizing and developing client solutions as a Subject Matter Expert. Award honors an employee for improving company’s performance in the areas of safety, operational excellence, and customer experience.
•Involved in all aspects of the System Development Life Cycle (SDLC)
•Coordinate with business clients and provide new and complex high-quality solutions to clients in response to varying business requirements. Design and programming in NATURAL Report and Structured Modes using ADABAS and disk dataset storage.
•Develop new online and batch programs using NATURAL/ADABAS
•Design and programming in NATURAL Report and Structured Modes using ADABAS
•Preparation of functional documents and maintaining process documents for quality reasons. Involved in several project related reports creation to maintain the number of incidents and SR requests.
Project: 2
Title: Sunoco INC.
Technology: Natural, Cobol, JCl, SQL, Focus, Rexx
Database: Adabas, DB2, IMS DB
Duration: Oct 2010 – Jan 2020
Company: IBM India Pvt. Ltd
Client Description:
Sunoco, Inc. is a leading manufacturer and marketer of petroleum and petrochemical products. As one of the largest independent refiner- marketers in the United States, Sunoco operates refineries, markets gasoline and manufactures approximately five million tons annually of high quality metallurgical- grade coke for use in the steel industry.
Description of Project:
•SUNOCO AMS project is mainly the outsourced project that is being handled by IBM. The team size for this project is around 60 including the managers and project leads. The project is being executed from three different locations Philadelphia, Pune and Bangalore.
•Teams are divided based upon the technologies and applications. Worked on technologies which include Mainframe, Microsoft (.net, VB), BI (Business Intelligence) and DB part. There are overall around 800 applications in it.
Roles and responsibilities in the project:
•Worked on enhancements, incidents and production issues designed in COBOL/DB2,NATURAL/DB2,NATURAL/ADABAS, COBOL/IMS, NATURAL/IMS,JCL, FOCUS, SAS, EASYTRIEVE and VSAM related mainframe applications.
•Worked extensively on 24*7 Production Support. This involved office and after office production issues that require immediate fix in the mentioned application areas.
•Responsible for coordinating with third party vendor teams like ENSONO, DTN, FDC and EasyLink to debug the transmission issues within and from mainframe batch jobs.
•Performed batch jobs scheduled validation and schedule checks using tools like CA-7 for the batch jobs that run daily, weekly, monthly, semi-annually or yearly.
•Provided his applications functional expertise to the SAP vendor team for the SAP Migration project to help SAP to perform similar tasks as being done in Legacy.
•Worked on the Legacy Data Archiving projects to SQL server using JIVS platform.
•Regular interactions with customers on a regular basis for gathering business requirements. It Involve of meeting business teams and managers to understand the requirements.
•Responsible for creating new reports as per the changing business model using technology like EasyTrieve, FOCUS and SAS.
•Coordinate with IBM offshore delivery team and track the progress of development done for Projects, Enhancement, Maintenance & Support activities.
•Responsible for attending regular calls with clients and the IBM management for providing periodical reports on Project statuses to PMO.
•Translate customer requirements of Projects & Enhancements into formal requirements and design documents, establish specific solutions, and lead the efforts including programming and testing.
•Responsible for delivering new and complex high-quality solutions to clients in response to varying
business requirements as part of Projects & Enhancements.
•Responsible for enhancing the existing customer business requirements for the Treasury applications using technologies like COBOL,NATURAL, JCL, DB2, ADABAS, IMS and VSAM.
•Responsible for fixing the production issues that come up during business hours and off business hours using technical expertise of the tools like ABEND-AID, FILE-AID SYNCSORT and XPEDITOR.
•Developed implemented new bank interfaces using Electronic Data Interchange (EDI) with Customer financial data.
Project: 1
Title: JPMC – TS UK - Network Expansion Phase 2
Technology: Natural, Cobol, JCL, SQL
Database: ADABAS, DB2
Operating Systems: MVS/ESA, OS/390
Duration: Sep 2007 – Oct 2010
Company: Cognizant Technology Solutions Pvt. Ltd
Client Description:
Treasury Services provides clients with solutions that maximize the efficiency of their cash assets, and the financial tools to manage, analyze and invest their funds for peak performance, while helping to manage risk. These solutions are profitable for the Firm, and value-added for the client.
•Treasury services perform following significant functions:
•Funds Transfer
•Cash Management:
•Liquidity:
•Multi-currency Payments:
•Trade Commerce:
•E-commerce:
Description of Project:
The network expansion program is an enhancement of the existing partner bank strategy where JPMC purchases a white labeled sub-account structure from a partner bank that will allow customers to perform domestic cash management from a JP Morgan London account.
Managing and controlling the transaction flow between JPMC and a local bank will be performed through Nostro-Vostro and associated sub-accounts (JPMC RE: Account). Our clients will be shielded from the activities between JPMorgan and the in-sourcing local bank provider; in effect, reflecting all activity as domestic, despite our clients technically holding accounts with JPMC London. This initiative creates an in-country local bank capability without JPMorgan physical banking presence or banking license In-Country.
Roles and responsibilities in the project:
•Develop new online and batch programs in CICS and TSO environments for the projects using NATURAL/CONSTRUCT/ADABAS
•Modify existing modules in Natural language to include new requirements
•Perform unit testing and system integration testing
•Convert COBOL programs to NATURAL/CONSTRUCT/ADABAS for Fund Distribution Subsystem
•Modify existing JCLs and create new ones to execute batch programs
•Design and programming in NATURAL Report and Structured Modes using ADABAS and DB2 DBMS and disk dataset storage
•Addressing alongside trade holdings (position keeping) accuracy and income/tax rates is Asset prices/yields and FX rates.
•Offering a full quality offering in certain market segments, in particular where JPMorgan are servicing fund assets
•Develop adhoc programs in reporting mode of Natural to generate report for the user.
•Develop new program in Natural and Focus to generate report in spreadsheet for the user.
•Assisted user department implementation of vendor software using FrontPage and SQL Server DBMS
•Worked on project to migrate DB2/Adabas historical data to SQL server.
•Involved in all aspects of the System Development Life Cycle (SDLC)
•Provided UAT and QA support for the project
Education:
Examination passed Institution Year of passing % of marks
Masters of Technology MNNIT, Allahabad, India 2007 89.4
Bachelors of Engineering. BBDNITM, Lucknow, India 2005 67.4
Career Profile:
Date Organization Title
Since Oct 2021 – Till date HTC Global Senior Application Programmer
Since Feb 2020 – Oct 2021 Ciber LLC Senior Application Programmer
Since October 2010 – Jan 2020 IBM Senior System Engineer
Since September, 2007- October 2010 Cognizant Technology Solutions Programmer Analyst
Contact this candidate