Vaibhav Jain

Vaibhav Jain Email: - Flat No-1208, JP Deck Contact No : - Sanjay Gandhi Nagar, - Goregaon East Mumbai-400097 Experience Summary 5+ years of software engineering experience, with strong analytical skills and broad range of computer expertise. An excellent problem solver, able to quickly grasp complex systems and identify opportunities for improvements and resolution of critical issues. I am an associate with Polaris Consulting since October 2016. My main area of experience has been design, development and providing solutions for client requests. During my tenure, I have gained functional and technical proficiency in financial services and banking system related to TCS Bancs 24x7 application Atlas Application which automates every aspect of a financial institution’s back, middle and front office operations in one fully integrated solution. Earlier associated with TCS and Fintellix Solution (Formerly I Create software). I have gained technical expertise in MF COBOL, UNIX, SQL, Oracle and CICS. Technical Skills Hardware Software Products Tools Languages HP Servers Operating System/Platforms: Unix: HP–UX11i; Windows 2000; Databases: Oracle 11g Development Tools: vi Editor (Unix) Database Tools: SQL *PLUS, Isqlplus, toad, Sql developer Configuration Tools: PVCS,JIRA, Service Now (Version and Change Control System) Oracle (SQL), UNIX Shell Scripting, Micro focus COBOL Mainframes, Unix Educational Qualifications Examination Institute Aggregate (%) Year of Passing BE(Mechanical) ( 2012 ) Samrat Ashok Technological Institute, Vidisha (M.P.) 79.8 May 2012 Intermediate ( 2009 ) Govt. Boys School Banda 76.4 March 2009 SSC ( 2007 ) Saraswati High School Banda 76.4 March 2007 Certifications Title Acquired On Oracle Database SQL certified Expert 21-Feb-2015 Oracle PL/SQL Developer 14-March-2015 Achievements Title Acquired On Start of the Month ,Star Team Award ,5 time On the Spot awards from TCS - Work Experience Project 1:- Orion 2 BNP Paribas (10-Oct-2016 – Till Date) Project Title Orion 2 CBIT (Corporate Banking IT) Payment System BNP Paribas Description Orion 2 is a banking payment application used by Banks in order to process all the payments like Swift, NEFT, RTGS, IMPS, Netpay and Manual Payments etc. It is built on UNIX system and uses Micro focus COBOL and CICS and Oracle Database. Main Business logic is present in Micro focus COBOL and Screens are developed in CICS. Environment UNIX Based Platform (Solaris, HP-UX) for a business logic in Micro focus COBOL, CICS and Oracle database Role Senior Programmer/Analyst Responsibilities Requirement gathering by communication with clients Documenting solutions by creating design documents Preparing test cases and creating test data Coding and Unit Testing Generating reports and extracts as per requirement Maintaining repository of project related learning's Status reporting and task tracking Providing support for User Acceptance Testing To explore various other products that can be used to create an end-to-end solution Project 2:- RBS Reporting at Fintellix Solution (18-Mar-2016 to 04-Oct-2016) Project Title RBS Reporting (Risk Base System) at ICICI bank Description Risk-based supervision (RBS) is a regulatory reporting system where every bank to submit required data to RBI as per the RBI data points. Our role here is to gather all data from the system’s and using desired formula calculate the risk and display in the form of report or consolidate value. Environment Unix, Shell Scripting, Informatica, ETL, Oracle SQL, Sql developer, toad, MF Cobol Role Senior Consultant Responsibilities Involved in the source system analysis and development of Database Objects to extract data using Informatica. Worked on the analysis, development and enhancement of new and existing ETL’s. Shell Scripts to support the load from source file to the database using Sql loader. Worked closely in understating client requirement to fit into our products Data model. Implementation and Validation. Unit and regression testing. Involved in the creation of ETL automation and migration of ETL’s to production Environment. Involved the Design and Documentation of Integrated Workflows. Project 3:- Core Banking Solution (CBS) State Bank of India (16-Jul-2012 to 11-Mar-2016) Project Title State Bank of India, Core Banking Solution (CBS) Description SBI as part of the Centralized Core Banking Project plans to connect its branches to a single data centre in Centralized Client Server Architecture. TATA Consultancy Services (TCS) has been awarded the prestigious project for supplying a comprehensive solution that will ensure the realization of a fully functional Centralized Core banking System for SBI and it has been made possible through TCS-Bancs 24x7 application. Currently more than 16000 branches of SBI and several associate bank branches are on Core. TCS is involved in Client liaison, System integration, Project Management, Software development, Customization of software, Customer training, Data Migration, Implementation support, Post implementation support. Environment UNIX Based Platform (Solaris, HP-UX) for a business logic in COBOL, C Interface, Oracle 11g Database, .NET based front-end environment (HTML, XML, ASP.NET, JavaScript) Role Programmer/Senior Programmer/Module Leader Responsibilities Analysing the client requirement and discussions with client for any new requirements in the Deposits module. Preparing of Solution Documents as per the requirement Maintaining data of all customers through Customer Information Facility (CIF) and accounts Deposit Parameters Sweep account creation, Online/Offline sweep processing Handling transactions through alternate channels like ATM, Internet Banking. Calculation and deduction of income tax from fixed deposit accounts during online/offline transactions. Handling of new changes in the existing system for both online and offline interest related functionalities. End of day processing of Deposit accounts for interest calculations. Generation of various EOD and SOD reports. Personal Details Date of Birth 19th January 1990 Nationality Indian Passport Details N- Other Interest Trekking, Travelling, Chess, Carrom, Cricket