CURRICLUM VITAE
Gaurav Shahare
Associate Manager – Vritusa Consultancy and Services
Pride World City, Long Island C2G-101, Charoli - Pune, Maharashtra 412105
*******.******@*****.*** - +91-982*******
13 year experience on iSeries (AS/400), Extensively worked in iSeries (AS/400) system using RPGIV, RPG/400, CL/400, SQL/400, ILE, COBOL/400 and AS/400 Utilities using RDi, RTC, ARCAD, SEU, SDA, RLU, PDM, and DFU and work on Project Management.
Work Experience:
Associate Manager
Virtusa Consultancy and Services - Pune, Maharashtra: Jan 2017 to Till Date
1.StandIn Development (Client HSBC):
Platform/Lang..: AS400/RPG IV/Full free Format, MQ.
Responsibility: Project Management, Scrum Master, Requirement Gathering, Design, Development, and review
Team size ..: 12
Project Brief ..:
This project is to provide some services to the customer even after the Bank is not working due to maintenance, new software release or system downtime.
Under this project Internet Banking and phone banking is one of the most important part which is extensively used, so here in HSBC completely Stand-alone system is created to provide some services to the customer. With this extended service user can login to Internet Banking and phone banking and perform account inquiry, check the details, make transfer pay bills, and cheque related services.
RESPONSIBILITY:
Involved as a scrum master, in requirement gathering, in design, code review and testing for the same in RPGLE.
Assistant Consultant
Tata Consultancy and Services Pvt. Ltd - Pune, Maharashtra: Sep 2014 to Dec 2016
2.H21 Utility (Client HSBC):
Platform/Lang..: AS400/RPG IV.
Responsibility: Design, Development, Unit testing and review
Team size ..: 2
Project Brief ..:
This utility has been developed to generate the report of the records which are pending for the second level approval to reduce the count of tickets raised for H21 Approval and help operator to provide solution with the approval details.
3.Alert Management (Client HSBC):
Platform/Lang..: AS400/RPG IV.
Responsibility: Design, Development, Unit testing and review
Team size ..: 3
Project Brief ..:
This is the compliance project which was introduce in system to the send an Alert message to the system operator about the changes has been done to the system control files, data areas etc.
For this we have included two new screens to maintain and approve the changes made. This is two step process of making changes in any system control files and data area values which are used to control the system processes. Also introduced job which will continuously check the control file or data area values are changed. If any value is changed then alert message will be send to operator that control values are changed, need to take action before proceeding.
Technical Lead
Development in Symphony Teleca Corp (India) Pvt. Ltd - Pune, Maharashtra: November 2011 to Sep 2014
IBS Enterprise streamlines, automates and accelerates the critical supply chain processes that determine your success: from inventory planning, purchasing and supplier management through warehouse optimization, value-added services, demand management and returns processing.
All IBS software including our specific vertical solutions is built on a flexible architecture, which ensures that the system you deploy to run your business is always the most flexible, scalable, available, portable and secure that there is.
IBS Supply Management software helps you identify and work with the best suppliers, plan, forecast and manage inventories, establish the best pricing and incentive payments, handle all purchase order processing, manage delivery schedules, and much more. It aligns the best possible customer service with the lowest practical inventory costs.
4.Item Matrix Handling:
Platform/Lang..: AS400/RPG IV.
Responsibility: Development, Unit testing and review
Team size ..: 4
Project Brief ..:
This functionality is used for items that share the same characteristics except that they have different colors and sizes. Such a group of items are gathered within one model number. Matrix panels have been created where all colors and sizes for one specific model can be handled. These panels are available for item creation, sales order lines, purchase order lines and warehouse availability.
Modifications have also been done for sales pricing of matrix items. It is possible to use normal pricing for one specific item, i.e. a model/color/size combination, as well as quantity dependent pricing for the specific item. The sales pricing modification is that it is also possible to define special quantity dependent pricing for the whole model. This means that the accumulated quantity for all colors/sizes within the model are used to retrieve the sales price for the sales order lines that are about to be created.
RESPONSIBILITY:
Involved in coding and unit testing for the same in RPGLE.
Senior Engineer Development
Opus Software solution Pvt. Ltd - Pune, Maharashtra - April 2010 to October 2011
A CAMS is ERP software for MOHAWK USA. Mohawk is the leading Manufacturer and distributor of flooring Products worldwide. Mohawk manufacturing products include all major flooring categories, Carpet, rugs, hardwood, laminate, ceramic tile, and vinyl flooring. This application has been designed to fully integrate the Financial, distribution and customer service areas of the business. All applications operate online utilizing a single relational database sharing information between applications.
This application includes 16 modules, of which order to Cash, Full-fill to distribution, warehouse management, and accounts receivable modules are our mainly working modules.
Summary of Responsibilities:
Involved in Design, Development and Testing phases.
Designed and Developed in RPG ILE on AS/400 platform.
Analyzing the User Requirement Document, Functional and Technical spec.
Created Subfiles, Report programs etc.
Creating Test case scenarios and Testing.
Creation of data cases using test bench
5.EDD (Estimated Delivery Date):
Platform/Lang..: AS400/RPG IV.
Responsibility: Senior Developer
Team size ..: 4
Project Brief ..:
Modified some program to provide approximate date of delivery by considering all possible condition. Also included new system to provide the notification regarding the delivery send by e.g. Fax, Email, Verbal and so on. Also provided the information regarding the maintenance which will be done before order to be post.
RESPONSIBILITY:
Involved in coding and unit testing for the same in RPGLE.
Software Engineer
HSBC Software Development Centre (India) Pvt. Ltd - Pune, Maharashtra - March 2007 to April 2010
6.TFSA Tax Reporting:
Platform/Lang..: AS400/RPG IV, CLLE.
Responsibility: Developer
Team size ..: 3
Project Brief ..:
Created new programs to provide options to extract and generate the XML tax receipt to user. Population of the Tax receipt for TFSA accounts (Tax Free Saving Account) i.e. XML are done by using CGIDEV2.
RESPONSIBILITY:
Involved in coding and testing for the same in RPGLE.
7.FundCom 6:
Platform/Lang..: AS400/RPG IV, SQLRPGLE.
Responsibility: Developer
Team size ..: 3
Project Brief ..:
Modified some programs to increase the length, data type of fields and changed the XML schemas.
RESPONSIBILITY:
Involved in coding and testing for the same in RPGLE.
8. FundCom:
Platform/Lang..: AS400/RPG IV, SQLRPGLE, CLLE, DB2/400.
Responsibility: Developer
Team size ..: 4
Project Brief ..:
Develop a new application to eliminate the green screen involvement for the inquiry of account, the new application was developed to interact with third party tool (FundCom), which send the requests in the form of XML and receive the response as XML. CGIDEV2 is used to populate the response XML.
RESPONSIBILITY:
Involved in coding and testing for the same in RPGLE.
9. PA on FundServe:
Platform/Lang..: AS400/RPG IV, CLP, DB2/400, COBOL/400.
Responsibility: Developer
Team size ..: 2
Project Brief ..:
Modified program which interact with the third party tool (FundServ) to inquire and make the transaction on the Mutual fund system.
RESPONSIBILITY:
Involved in coding and testing for the same in RPGLE, CLP, COBOL/400.
10. Tax 2008 Changes:
Team size ..: 2
Project Brief ..:
Modified some program to incorporate the increased length of the field. Also change the program which generates the XML of tax slips.
RESPONSIBILITY:
Involved in coding and testing for the same in RPGLE, CLP, COBOL/400.
11. Tax Free Saving Account:
Platform/Lang..: AS400/RPG IV, CLLE, DB2/400, COBOL/400.
Responsibility: Developer
Team size ..: 8
Project Brief ..:
New account type ('T') has been introduced to the existing functionality of the mutual fund for the Tax free Saving accounts. All the front end and backend programs are modified in order to handle the functionality of the new account type.
RESPONSIBILITY:
Involved in coding and testing for the same in RPGLE, CLLE, COBOL/400.
12. Mutual Fund Query Automation:
Platform/Lang..: AS400/RPG IV, CLLE, DB2/400.
Responsibility: Developer
Team size: 5
Project Brief:
Mutual fund weekly, monthly, quarterly, semi-annually and yearly queries are automated to run the same as a part of offline process.
RESPONSIBILITY:
Involved in coding and testing for the same in RPGLE, CLLE.
13. TAX 2007 Trust:
Platform/Lang..: AS400/RPG IV, CL/400, DB2/400, IFS.
Responsibility: Developer
Team size: 10
Project Brief:
TAX 2007 Trust is developed for the HSBC CANADA as the Canada government requested to generate all the Tax slips only in XML format. In this project XML API are used to create the Tax slips in XML format on IFS.
RESPONSIBILITY:
Involved in coding and testing for the same in RPGLE, CLLE.
14. Mutual Fund Front End Integration:
Platform/Lang..: AS400/RPG IV, SQLRPGLE, CL/400, DB2/400, COBOL/400.
Responsibility: Developer
Team size: 20
Project Brief:
This project is divided into three different parts:
a) Front End System:
Java application sends a request to the Queue on AS400 (MQ). Front end Driver program monitors the MQ queue and once there is request driver program call the program for the requested process, process the request and again put the reply in remote queue of the same MQ Queue manager.
b) Backend System:
Mutual Fund system previously using only back end system as on AS400 green screen the same programs updated due to the addition of the new fields in the database and batch program updated for the daily offline processing.
c) Synchronization and one time conversion program:
New fields added in the database were synchronized for the values from HUB system and one time conversion programs are created for the updation of the files for existing records.
RESPONSIBILITY:
Involved in coding and testing for the same in RPGLE, CLLE, COBOL/400.
EDUCATION
B.Tech in Chemical Engg.
Dr. Babasaheb Ambedkar Technological University - Raigarh, Maharashtra 2001 to 2004 - 59.16%
Diploma in Chemical Engg.
MSBTE - Mumbai, Maharashtra 1998 to 2001 - 69.95%
SSC
Maharashtra Board, 1997 to 1998 - 68.26%
SKILLS
RPG IV, RPG ILE Concepts, SQLRPGL, RPG/400, CL/400, Query/400, COBOL/400.
ADDITIONAL INFORMATION
Technical Proficiency:
IBM AS/400, RPG IV, RPG ILE Concepts, SQLRPGLE, RPG/400, CL/400, Query/400, COBOL/400. Databases:
DB2/400 and SQL.
Utilities:
RDi, ARCAD, Robot Advance Scheduler, RTC, PDM, SEU, SDA, RLU, & DFU.
Operating Systems
OS/400(V7R1), WINXP, WIN2000, 98.
PERSONAL DETAIL:
Name: Gaurav Gopalrao Shahare
E-Mails: *******.******@*****.***
Present Address: Pride World City, Long Island C2G -101
Near D.Y. Patil University, Logegaon,
Charoli (Budruk) Road, Charoli, Pune - (Maharashtra)-412105
Phone No +919*********
Date of Birth: 05 Feb 1983
Languages Known: Marathi, Hindi and English.
Nationality: Indian
Status: Married
Looking forward to having a good time with a great work with you.
Thanking You
Gaurav Gopalrao Shahare