Summary
Overview
Work History
Education
Skills
Certification
Hobbies and Interests
Personal Information
Timeline
Generic
Nikhil Iyer

Nikhil Iyer

Dahisar (W)

Summary

To be professionally associated with a growth-oriented organization with an objective to accept new challenges in various aspects of work and to make a successful career and widen horizon by gaining exposure in the Information Technology Sector.

Overview

12
12
years of professional experience
1
1
Certification

Work History

Manager, Information Technology

Tata Capital Limited
04.2024 - Current
  • Handling Document Management System (DMS) which is a core system to manage document
  • Handling end to end Change Release Management, vendor management, stakeholder management, team management
  • Managing a team of 5 resources→ reviewing their work & assigning daily tasks
  • Timely review of the project and daily tracking of the project
  • Managing various project risks, issues and delivery and ensuring successful completion of the projects
  • Assigning tasks to different teams and building cross-functional teams for the project management
  • Updating the Project tracker on a daily basis and conducting review of critical projects with the senior management
  • Assisted in User Acceptance Testing (UAT), ensuring final deliverables met business needs and quality standards
  • Managing seamless integration of DMS System with other applications across Tata Capital.
  • Managing Compliance Related Projects like Aadhar Masking in DMS (AI Driven Robotic Process Automation) (Masking first 8 digits of aadhar number as per RBI mandates), conducting sanity testing in UAT, resolving key production issues, managing various access control related CR's in Document Management System (DMS)

Project Manager (Retail Banking), Technology

DBS Bank Ltd
08.2023 - 04.2024
  • Company Overview: (On payroll of Net Connect Global)
  • Handling PSL Business in Yubi system (Credavenue) for Co-lending and Direct Assignment (DA) For Retail Loans (Loan Origination Systems)
  • Managing the PSL Project in Jira
  • Stakeholder management, end to end agile project management, team management and Vendor management
  • Assigning tasks to different teams and building cross-functional teams for the project management
  • Drawing project plan and managing various project reports
  • Drawing clear lines of communication between different stakeholders and ensure all the stakeholders are informed of the project status
  • Timely review of the project and daily tracking of the project
  • Managing various project risks, issues and delivery of the project and ensuring successful completion of the project
  • (On payroll of Net Connect Global)

Project Manager (Retail), Core Banking, Technology

ICICI Bank Ltd
05.2022 - 08.2023
  • Handling Loans Module in Core Banking Application Finacle for International Geographies (IBG) like USA, UK, Dubai, Canada, Singapore, Hongkong etc
  • Working as an application owner in loans module for Loan Origination System (LOS), Loan Management System (LMS) and providing training to the team wherever necessary
  • Working as a project manager and driving key change requests in Finacle right from creating the Business Requirement Documents (BRD), development, fixing of various bugs observed during development and taking up with the vendor wherever necessary and then deploying the solution to production
  • Preparing and reviewing the documents for Change Requests, reviewing the various scrips prepared by team, guiding the team members and working in unison to ensure everything is streamlined
  • Working exclusively on Unix and SQL and also reviewing the various Unix and sql scripts prepared by the team.
  • Working closely with the business team and vendor and timely follow ups with the vendor to resolve critical bugs or delivery of the change requests on time
  • Thorough knowledge of technical and functional part and working as a techno-functional manager
  • Helping the support team as well to resolve critical production issues and raising techonline calls and ensuring the same is taken up with the vendor and the issue gets resolved on time
  • Independently managing various tasks related to loans module in Finacle, carrying out the testing, making changes in Finacle scripts, deployment of the scripts and assigning various tasks to the team members, carrying out key meetings with business team and vendors in resolving critical issues and timely follow-up and closure of the various issues and CR's
  • Permanent resolution of critical issues like Batch job failures, frequent common bugs etc

Manager (Retail Banking), Information Technology

RBL Bank
11.2019 - 05.2022
  • Handling Change Management right from delivering Change Release and Bugs right from testing in UAT, Pre-Production, getting all the relevant issues and bugs fixed in the lower environments by raising it to the vendor or analysing with the core team and getting it delivered to Production on or before the specific time.
  • Giving training and arranging various VC's to explain the complete the End-To-End flow of Loan Origination System (LOS) and Loan Management System (LMS)
  • Main Pillar in Gathering Requirements from the Business like Operations, Risk, Finance Team, etc, preparing Business Requirement Document (BRD) and communicating the various requirements to the Vendor in a very crisp and clear way and ensuring vendor delivers the functionality or the changes on time.
  • Preparing various backend reports like Reports pertaining to Risk management, Accounting, RBI Auditing, Bank Account Details, Demographic Details, Know your Customer (KYC) Details, Charges Report, Disbursement of Loan and many other reports by writing complex Queries, Views, etc in Oracle 12C by using SQL Developer and PL SQL Developer
  • Handling Various Application Program Interface (API's) like NSDL, Dedupe, Hunter, DMS, Cibil, CIF-Retail, CIF-Corporate, NEFTRTGS and many other account opening related API's Using SOAP/ REST Software.
  • Helping Internal and External Auditors by standing as a backbone of the system and solving various simple to complex system related queries.
  • As a part of BSG (Business Solution Group), ensuring there is a proper flow between all the teams like Release Team, Middleware, DBA, Server, Linux and many others.
  • Managed the DR Drill process for Indus LOS-LMS Application with proper time management.
  • Managing various finance MIS Reports like GST Interface, Income Related and Charges related reports
  • Creating Various Hierarchical Queries in Oracle for Masters like Customer Master, Branch Master, Geography Master, Deviation Master, etc
  • Post implementation of projects timely identified potential audit issues and observations which were escalated to vendors and remediated and this ensured in building process efficiencies which was an evolving activity/ process.
  • GL Reconciliation, Functional testing, Review of data correction scripts, Preparation of Business Requirement Document (BRD), getting business sign-off on the requirement document, follow up with the vendor for issue resolution, etc related to Loan Management System.

Database Developer

RBL Bank (Payroll of Questec Consulting)
06.2017 - 10.2019
  • To extract data from a Very Large Database As Per the Requirement by the Business Team.
  • Created the Entire MIS (Management Information System) Report in Loan Originating Software for Retail Loans which contains about 300 fields right from QDE (Quick Data Entry) till Disbursement. This Report is A Bible for the Entire Bank and It is scheduled on a daily basis. Was instrumental in Customizing and Moduling the Query as Per the Specifications and Requirement provided by the Business Team.
  • Creating Various Reports like Bureau Report, FCU Report, EOD Report, Summary Report using Complex Queries.
  • Query Optimization
  • To interact with Business Team, MIS Team, DBA Team, Middleware Team, Release Team and also gathering the Requirements from the Customers. Requirement Analysis.
  • Worked in Loan Originating Software (LOS) and Loans Management Software (LMS) and completely aware about the entire workflow.
  • Interface Management- Managing Various Interfaces in the Loan Originating System like Hunter, ROC, Equifax, Dedupe (Manual Dedupe Verification and Dedupe UCIC (Unique Customer Identification Code)), Bureau Verification, NSDL Pan Verification, Finacle NEFT, Finacle RTGS, Finacle CIF, Finacle OD, Perfios Verification, etc.
  • Understanding the Request that the System takes in the Loan Originating Software and the Response that is generated in the Software.
  • Testing the Same in UAT, Pre-Prod and then Implementing it in Production environment.
  • Worked in various Portfolios like BIL, SBL, LAP and HL.
  • Portfolio Management and Product Management.
  • Creating and Extracting Data from XML by creating X-Query.
  • Solving various Production issues by Data Analysis.
  • Creating Various Hierarchical Queries in Oracle for Masters like Customer Master, Branch Master, Geography Master, Deviation Master, etc.
  • Post implementation of projects timely identified potential audit issues and observations which were escalated to vendors and remediated and this ensured in building process efficiencies which was an evolving activity/ process.
  • Identifying & Providing training, development, mentoring needs of team on database.
  • Handling The Change Release Management.

SQL Developer

Nisha Enterprises
04.2013 - 06.2017
  • To write SQL Queries and fetch the desired data in SQL Server 2008
  • To design Simple and Complex Reports in Crystal Reports.
  • To develop Programs in Visual Fox Pro (Vfp9)
  • To handle the entire database of the software named Udyog. This is based on Excise Manufacturing, Inventory, Order Processing and Excise Trading.
  • To design Tax Invoice, Delivery Challans etc in Crystal Reports.
  • Writing and Developing Stored Procedures, Triggers, Packages etc.
  • Have conducted different training sessions and handled an entire team.
  • Implementation and Processing of UTLINK which is a pathway of Udyog and Tally.
  • Good knowledge of Joins, Indexing, etc.
  • Have handled the front end of Udyog Software.
  • Good knowledge of Data Migration from one database to another, backup, restoring, etc.
  • Recognized as the Best Performer of the Year 2016 at Nisha Enterprises and was awarded for the same

Education

B.E - Computers

Atharva College of Engineering
Mumbai
05.2012

HSC -

St. Francis Junior College
Maharashtra
02.2008

SSC -

St. Francis D'Assisi High School
Maharashtra
03.2006

Skills

  • IT Project Management
  • Stakeholder Management
  • Vendor Management
  • Database Development (SQL, Oracle)
  • Jira
  • Unix
  • Core banking
  • Loan Origination System
  • Lending Management System
  • Document Management System
  • Finacle
  • API Testing
  • Teamwork
  • Team management
  • Handling work pressure systematically
  • Creativity
  • Strong work ethics
  • Self-confidence
  • Motivational speaker
  • Capable of handling any given task
  • Great problem-solving skills
  • Applying the 3 D's (Dedication, Determination, and Devotion)
  • Punctual
  • Diligent in work
  • Go-getter
  • Analytical
  • Result-oriented
  • Dynamic Decision-Maker

Certification

Cisco Certified Network Associate (CCNA), 01/15

Hobbies and Interests

  • Blogging
  • Singing
  • Playing Table Tennis

Personal Information

  • Date of Birth: 05/07/90
  • Gender: Male
  • Nationality: Indian
  • Marital Status: Married

Timeline

Manager, Information Technology

Tata Capital Limited
04.2024 - Current

Project Manager (Retail Banking), Technology

DBS Bank Ltd
08.2023 - 04.2024

Project Manager (Retail), Core Banking, Technology

ICICI Bank Ltd
05.2022 - 08.2023

Manager (Retail Banking), Information Technology

RBL Bank
11.2019 - 05.2022

Database Developer

RBL Bank (Payroll of Questec Consulting)
06.2017 - 10.2019

SQL Developer

Nisha Enterprises
04.2013 - 06.2017

B.E - Computers

Atharva College of Engineering

HSC -

St. Francis Junior College

SSC -

St. Francis D'Assisi High School
Nikhil Iyer