About

Rishi Agarwal is a skilled Information System Consultant with over 7 years of experience in Mainframe Application Development, Maintenance & Support, and Data Migration. He is adept in PL-SQL and has 9 months of prior experience in Excel macros, Outlook scripts, Visual Basic, and .Net. Rishi has knowledge of Manufacturing, Insurance & Banking Domain, and warehouse management activities. He also has working experience on Hive and Pig with knowledge of Hadoop eco-system. He has worked on a live project to predict sales of a product using Hadoop - HDFS, Scala, Spark, and Hive. Rishi is a consistent performer and has received internal awards based on his performance within projects. He is dedicated to his work and has worked on various projects that involved Data Migration from VSAM to SQL (For CICS Screens) and other projects that involved Data Migration, Application Enhancement, and Maintenance. He has also developed a few independent programs in REXX for Job submissions and test results. Rishi has worked on Agile methodology in various projects using JIRA. Currently serving his notice period, Rishi is looking for new job opportunities in the Mainframe domain. He is currently working as an Information System Consultant II at Lumen Technologies, where he provides production support (L3 support) and on-call assistance as and when needed. He is responsible for developing and maintaining the code for applications that involve JCL, COBOL, DB2, VSAM, and Datacom. Rishi has exposure to MQ series, NDM, SFTP file transmissions, and scheduling tools like CONTROL-M, CA-7. He has also worked with version control tools like Endevor and debugging tools like Expeditor. Rishi's major role is as an analyst in debugging and analyzing the COBOL code (both Logical and Mathematical calculations) and functionality. He finds the best way around for changes that need to be implemented (any changes related to the layout of VSAM or Tables in DB2) and handles the code analysis, design, development (coding), and testing part of the project (all stages need to be performed as per agile methodology). Rishi has previously worked as a Senior System Engineer at Infosys and as a Trainee Software Engineer at Nav Backoffice. He has a Bachelor of Technology (BTech) in Computer Engineering from Hindustan College of Science & Technology. He completed his School Education from St. Peter's College. Rishi's tech stack includes SQL, test