ARUN RAVI RAVEENDRAN NAIR VIJAYALEKSHMI

Old Bethpage New York – 11804

È908-528-1113 Email: ac5nul@r.postjobfree.com Skype Id: arun.ravi82

LinkedIn: https://www.linkedin.com/in/arun-ravi-raveendran-nair-vijayalekshmi-59b39a9a/

SUMMARY

An IBM Certified Mainframe Technical Professional with 12 Years of experience in Mainframe Technologies in z/OS, OS/390 environments.

Experience in all facets of Software Development Life Cycle (SDLC) including requirement gathering, analysis, estimation, designing, coding, testing and deployment using Agile as well Waterfall Methodology.

Very good exposure in handling end-to-end management of project deliverables at onsite and involve in Design, Development and Testing of Mainframe Applications and work with offshore team to ensure the delivery on time.

Evaluated and formulated technical specifications and designs.

Monitored mainframe coding and testing activities. Supervised work estimates and resolved technical issues.

Ensured quality standards of codes for company and buyers.

Conducted unit testing and supported business procedures. Prioritized business beneficial work promptly and accurately.

Collaborated with developers to resolve defects in coding.

Expertise in estimation of application projects using WBS, Three point & Functional Point Method.

Excellent knowledge on core Mainframe technologies like COBOL, JCL, DB2, DB, SQL, CICS, VSAM and IBM tools & utilities.

Designed and developed batch and on-line system applications in an IBM z/OS environment.

Good at creating design documents, UTP, UTR using MS Excel, MS Power Point, & MS Word.

Good exposure in requirements gathering & analysis, preparing detailed design, development, testing & leading the team from Onsite.

Strong knowledge in creating JCL and JCL PROCs using various JCL utilities like DFSORT, SYNCSORT, IDCAMS, IEBFR14, IKJEFT01, IEBGENER etc.

Hands on experience on DB2 DBA utilities like Copy, Recover, Load, Unload, Reorg, Check index, Repair etc.

Strong Experience with CICS Transaction processing with DB2 & MQ functionalities to transact with cross-platform systems.

Good knowledge & hands on experience in working with most of the Mainframe tools & utilities like ENDEVOR, File-Aid, $avers, CA7, CAT, CHANGEMAN, XPEDITOR, SMARTTEST, SPUFI, SYNCSORT, DFSORT, ICETOOL,, Micro Focus Enterprise Server, Cute FTP, Drag & Drop and Putty.

Developed few DB2 Stored Procedures which is executable in Micro Focus Enterprise Server.

Strong development experience and debugging skills. Monitoring production batch operations, which also include scheduling and monitoring jobs for SIT & UAT.

Participated in performance improvement activities for both batch and online modules.

Created/reviewed unit test plans (UTP), performed unit testing and documented unit test results (UTR).

Worked on enhancement of Online Credit Card Application transactions (CICS) to facilitate Credit Card Order processing.

Involved in Credit Card process changes to send merchant number for VISA, MC, AMEX, NOVS cards to First Data to support the Global Alliance Credit Card processing with Automatic Re-Auth facility.

Assists in integration, systems, acceptance, and regression testing with the testing team.

Compliant with IT policies and procedures, especially those for quality and productivity standards that enable the team to meet established milestones.

Good analytical & communication skills and ability to work independently.

Good working experience in Coordinating and Supporting the Development, Testing and Deployment of Project in Off-Shore/On-Site model.

PROFESSIONAL EXPERIENCE

Arrow Electronics Inc. 03/22/2010 – Present

Role: Senior Technical Consultant

Arrow Electronics is a major global provider of products, services and solutions to industrial and commercial users of electronic components and computer products. Arrow brings the technology solutions of its customers and suppliers to a breadth of markets, including telecommunications, information systems, automotive and transportation, medical and life sciences, industrial equipment, and consumer electronics.

Projects:

(a)Arrow Maintenance & Production support

Arrow Legacy Mainframe system in z/OS operating system has various sub applications which includes Purchasing System, SDT (Sales Desktop system), BOM (Bill of Material), Programming VAS (Value Added System), Credit Card Order Processing, Web Order Services, GFS (Global Finance System) etc. The data to all these applications are fed from AEGIS Legacy Mainframe system.

Job Summary:

Production support and enhancements of Legacy Mainframe Applications used with in the Arrow system. Arrow Application platform has various interfaces from Mainframe AEGIS system to the Arrow Shop Floor System, DMS Value Added System, Warehouse Management System (WMS), EDI transmissions to vendor and the Financial System.

As part of Production Support activity, solve production/quality online & batch abends in given time frame. I.e. solve Hotline/Helpdesk cases based upon the priority of the ticket and maintain SLA. Hotline cases are mainly user reported CICS online problems or batch abends in the production environment which needs to be resolved efficiently.

Analyzing the business requirements and transforming the requirements to Functional design specifications.

Estimation of new projects or enhancements using Work Breakdown Structure (WBS), Function Point or Three Point Method based on the Size of the project.

Design, code, unit test, debug of the code and produced high quality deliverables with least number of defects.

As part of small projects, work on enhancements to online CICS programs, Credit Card Order transactions, COBOL batch programs and RMDS reports.

Monitor Credit Card transaction processing by Batch & AEGIS Online interface transaction with First Data/Bank.

Worked on enhancement of Online Credit Card Application transactions (CICS) to facilitate credit card order processing. Also involved in Credit Card settlement process changes to support the Global Alliance credit card processing.

Effective defect tracking through Mercury Test Director.

Interacting with Business for getting the requirements for User acceptance testing and have a good rapport with Client partners.

Assigning the testing tasks to offshore resources and track the status.

Reviewed and provided feedback on Unit Test scenarios, Unit test case/scripts, and data to offshore resources as well as other team members.

(b)Arrow Dispute Processing Systems (ADPS)

This project settles disputes on credit card transactions like lost/stolen cards, fraud transactions, multiple charges for single transaction, damaged cards, billing errors, incorrect charge backs etc. ADPS receives responses from First Data and validates data from DB2 tables and the sends the data back to First Data system. ADPS also generates the settlement reports/letters for the customers.

(c)MCRD (Merchant Credit Card Maintenance)

We used to fetch data from the DB2 tables based on merchant number which was a unique number given to all the credit cards (VISA, MC, AMEX, NOVS). But when Arrow starts accepting CAD cards, duplicate issue started arising as the merchant number was same for each card type which impacted Credit Card Processing. This project was to add 2 new fields (REAUTH & currency type (USD/CAD)) to MCRD database to resolve duplicate issue.

(d)Unity Conversion Project

Unity is a Migration Project from Mainframe to Oracle ERP platform. To position Arrow for the future, Executive Leadership decided to move to a single operating platform by migrating Legacy business to the Oracle platform. The benefits from this initiative include greater flexibility and speed-to-market, reduced administrative cost etc., In order to achieve the Single Operating Platform objective, all the data that is currently processed on mainframe needs to be extracted as per the ERP requirement and interfaced to ERP conversion team. Similarly create de-conversion tasks on mainframe to successfully close out all open sales orders and purchase orders after conversion. This was implemented (Go Live) on January 4, 2018.

Job Summary:

Developed effective AEGIS OS-390 technical and user documentation for Unity Team for the smooth migration.

Provided required data Extracts to Oracle Unity ERP team.

Development of both online and batch programs with database connectivity like CICS-DB2 and COBOL-DB2 for De-conversion Tasks after the migration on year-end.

(e)NuHo Conversion Project

Arrow Electronics has acquired Nu Horizons Electronics in 2011. NuHo system was running in AS/400 platform & Arrow Electronics in OS/390. NuHo is a Migration Project from AS/400 Mainframe to OS-390 Mainframe platform. To position Arrow for the future, Executive Leadership decided to move to a single operating platform by migrating AS/400 to Legacy business and then to the Oracle platform.

Role:

Coordinated with Business Analyst to define requirements, analyze business needs and validated solutions with client and prepared the estimation document for the requirement.

Prepared the Functional Spec (POS) & design document (PDD) for all the functional requirements.

Creating the Flowchart and coding of application programs using COBOL, DB2 & CICS.

Developed JCL’s, procedures for the batch system as per the client standards.

Execute the batch module using JCL.

FTP or SFTP (FTP File Transfer z/OS) application output files/reports to user servers, Oracle Servers and other local directories through daily/weekly/monthly batch process as per business requirements.

Used DB2/File-Aid for preparing test data.

Modified the existing online programs using CICS with MQ & TSQ functionality to send/receive data from other systems.

Copied data from production region to UAT/Dev region as part of Testing. Preparing UTP and UTR.

Creating package in Endevor to install code in UAT and Prod environment.

Altered the DB2 tables to accommodate new columns as per business requirement.

Done DB2 backup and recovery tasks through batch JCL.

Performed DB2 performance tuning to improve job run time & online screen improvement.

Used IBM utilities like IDCAMS, IEBGENER, IEFBR14, DFSORT etc.

Experience with code review and peer review.

Excellent problem solving skills and ability to work independently.

Prepared code documentation for future reference and upgrades.

Understanding the existing functions and designing the system for the enhancements.

Provided post implementation support.

Participated in Daily & Weekly status calls and updating status of the Batch calls, Online tickets & project.

Technical Environment:

COBOL, VSAM, MVS, JCL, $avers, DB2, SQL, CICS, z/OS-390, SAS, MQ, TSQ, SQL, File Transfer Protocols(FTP & SFTP) through batch, CA7 Scheduler, CAT, ENDEVOR, FILE-AID, XPEDITER(Batch debug) and INTERTEST.

TESCO HSC PVT Ltd 02/09/2009 – 03/19/2010

Role: Senior Software Engineer

Client: Tesco US, Bangalore, India

Project: TESCO GO

TESCO GO (Group Ordering) was a team of 21 members which is involved in both online and batch changes for US retail IT operations by Tesco.

(a)Mass Trading Hours Update: Group Ordering (GO) system holds the details of store opening and closing times for all Tesco stores in USA. . There is a function in the online system which enables maintenance of these trading hours’ patterns. As part of this requirement, new user friendly online screen has been introduced on GO system using TELON & COBOL language, where Central Supply Chain users will be able to update the store opening time and/or closing time for a set of stores in a single process.

(b)Simpler Diaries: The purpose of this project is to find a Business Solution required allowing the Group Ordering system to handle ‘Near & Far Store’ Deliveries. This development consists of the following main changes in Mainframe System:

oA new Non Delivery Days control screen has been built.

oA new Non Delivery Days Exceptions control screen has been built.

oA new set of programs/screens have been built to allow the users to apply and maintain bulk overrides to the Non Delivery Days and Non Delivery Days Exceptions Controls.

oA new option, ‘Non Delivery Days Maintenance - Mass Update’ has been created.

oNon Delivery Days Table - Batch Update.

(c)GAP REPORTING: The purpose of this project is to find a Business Solution required allowing the Group Ordering system to handle ‘GAPS’ in the store shelf. This development consists of the following main changes:

oCobol DB2 Stored procedures has been coded to get the products which are all found ‘GAP’ in a store for a particular date and take immediate action to fill the same.

oOnline Screen has been built to update the necessary tables in real time in order to close the GAP in stores.

oA Summary report has been coded to provide the necessary details to the business every day through daily batch. SMARTTEST will be used to debug critical batch issues and solve it on time before business hours starts.

Technical Environment: MF COBOL, VSAM, JCL, SQL, Stored Procedure, Telon, Micro Focus Enterprise Server, File Manager, Changeman, UNIX, SMARTTEST, Cute FTP, Drag & Drop and Putty.

CGI TECHNOLOGIES & SOLUTIONS INC. 06/14/2006 – 02/06/2009

Role: Software Engineer

Client: Arrow Electronics Inc.

As a Team member, my responsibilities include resolving Quality & Production batch calls & online application tickets. As a Team member, responsibility includes Production batch & online support and involved in Analysis, design, development, unit testing, code review, UTP review, documentation etc on multiple projects listed below.

(a)Arrow Maintenance

This is a Core Support/Maintenance project in Arrow Legacy System to support/maintain the batch & online mainframe applications used within the Arrow Retail system. As a team member, involved in production support and enhancements of Legacy Mainframe Applications used with in the Arrow system. As part of support activity, solved production, quality, online & batch problems in given time frame. Built new Arrow applications as per new business requirement in batch or online using COBOL-BATCH, COBOL-DB2 or COBOL-DB2-CICS languages.

(b)Arrow NAC City Alignment

This is to convert multiple branches to a single branch per city under a single company for sales business. This went live on January 3, 2009.

(c)ARROW-SHIPSOMP is a development project. The purpose is to design and develop a system to show the daily changes in the ship dates for sales orders due to changes in vender confirmed ship dates for the ordered part. This involves new screen and report to show the changes.

(d)ARROW-SHIP DATE ENHANCEMENT is an enhancement project. The purpose is to standardize the ship date value calculation in the system. His introduces the new variables Transit time to customer, PDC receipt time, PDC pick/pack time in the calculation of the ship date for the sales order line item

(e)Arrow MNT MISC is a conversion project for Arrow Electronics Inc. The purpose was to convert some existing Assembler programs to COBOL.

Technical Environment: COBOL, MVS, VSAM, JCL, DB2, SQL, CICS, UNIX, SAS, CA7, CAT, FTP/SFTP, ENDEVOR, FILE-AID and INTERTEST.

ACADEMIC BACKGROUND

Bachelor of Engineering (B.E) from Manonmaniam Sundaranar University, Tamil Nadu, India in 2004.

TRAINING & CERTIFICATIONS

IBM Mainframe Certification from C-DAC, Trivandrum, Kerala, India in 2006.

Contact this candidate