Principal Technical Consultant at Finastra
19 Years of Experience
Bengaluru, Karnataka, India
-
-
Not Available
Profile: Loan IQ Techno-Functional consultant with over 9 years of experience in Loan IQ implementation for multiple Banks. Finastra Loan IQ Principal Consultant with expertise in Loan IQ Implementation, Integration, Customizations using SDK & Business Analysis. Technical Architect with expertise in Application & Data Integration, Data Migration, Data Warehouse solutions. Key areas of Expertise: Loan IQ Technical/Functional Specialist: Loan IQ Solution Consultant with expertise in technology and business/functional aspects of Loan IQ product. Good understanding of lending domain with exposure to multiple implementation projects for major banks. - Loan IQ Architecture, Data model, Installation, Administration, APIs, Migration, Customization using Loan IQ SDK. - Expertise in key Loan IQ product features and have good understanding of Loan IQ accounting. - Design & Implementation of Integration solution using Core Java and Loan IQ SDK. - Automated Migration solution using Data Conversion Tool (DCT) and additional utilities to overcome the gaps in DCT tool. - Expertise in design and development of customizations using Loan IQ SDK, Inquiry API, Event management framework. - Deep understanding of Loan IQ data model with experience in building reporting and analytical solutions. Application Integration Architect: - Design and development of Real-time integration solutions using SOAP & REST APIs, TCP Sockets and Message Queues. - Built batch integration solutions using Core Java and Open source ETL tool Talend. - Strong Java programming skills and experience and expertise in design and implementation software system solutions using Java. Experienced Data Architect & Data Integration/Migration Specialist: - Expertise in Data Architecture, Database modeling, ETL Architecture and Data Migration. - Architected and led the development effort for building Migration tool used by Finastra Core Banking implementation teams. - Strong Oracle, IBM DB2 and MS SQL Server Database development skills with exposure to DBA functions. - Strong ETL skills. Experienced in implementing ETL processes using Talend, SQL Server DTS and proprietary ETL solutions using Perl-DBI, PL/SQL and shell scripts. - Experienced in Design and Development of Operational and Analytical reporting solutions.
Finastra, SaaS/Cloud Product, Computer Software
Finastra
Finastra
Finastra, Finastra, Finastra, Tata Consultancy Services
Job Title : Principal Technical Consultant
Company name : Finastra
Period : November 2011 - Present
Summary : - Lead a team of Technical consultants working on Loan IQ implementation/upgrade/integration & customization projects for leading Banks.
- Estimation and planning of Loan IQ implementation and upgrade projects.
- Design and develop Loan IQ integration and customization solutions using SDK.
- Train Bank’s implementation teams and Finastra implementation partners in the areas of Loan IQ Architecture, Data model, Installation, Administration, Application Programming Interface (API), Migration, Standard Interfaces and SDK (Loan IQ Software Development Kit)
- Assist Banks in the design of Deployment architecture and hardware sizing.
- Assist pre-sales teams in building Proof of concept solutions to demonstrate application integration and customization capabilities.
- Experience in Loan IQ implementation/upgrade/integration & SDK customization projects for ADB, MUFG, ANZ, Westpc, Macquarie, ING, Natixis, Erste, RBS, US Bank, CTL, ACB and many others.
Location : Bengaluru, Karnataka, India
Job Title : Principal Consultant
Company name : Finastra
Period : June 2018 - October 2020
Summary : Lead consultant handling functional, technical and hosting aspects of Loan IQ implementation project for ADB.
- Training: Delivered Loan IQ Technical training, Integration, Reporting and Migration workshops.
- Solution Design: Assisted in functional training, solution design workshops and business solution design documentation.
- Deployment architecture: Design of deployment and Integration architecture to deploy Loan IQ on Finastra managed Azure cloud infrastructure (Managed Services) with real-time and batch integration with on-premise client systems.
- Migration: Automated migration of Guarantees and Loans portfolio from ADB legacy application using Loan IQ Data Conversion Tool (DCT) and custom migration utility.
- Integration: Design and development of following integration solutions:
o Daily load of FX rates, Funding rates and Holiday calendar loads.
o Disbursements/Outward payments - Real-time integration with Oracle Accounts Payable and SwiftAlliance systems using event management framework.
o Billing/Incoming payments – Interface to send Loan IQ bills/invoices to Oracle-Accounts Receivables and automatic application of incoming payments.
o Automatic booking of Guarantees/SBLC in Loan IQ using real-time integration with Bank's trade finance system (TFPMS).
o Origination – Integration of Loan IQ with Moody's Analytics CreditLens application to automatically create/update Customer, Deal, Facility and Primary Trades in Loan IQ.
o Finastra Summit – Integrate Loan IQ and Summit to manage Equity and Debt Security facility commitments in Loan IQ and EI & DS exposure as Non-loans in Loan IQ.
- Customization – Designed and developed following customizations.
o Monthly USD revaluation of Banks portfolio managed in Loan IQ.
o Custom email solution to send Loan IQ notices as password protected PDF attachments.
o Client specific business validations during Customer & Deal setup and Loan servicing transactions.
Location : Bengaluru, Karnataka, India
Job Title : Architect - BankFusion Essence Core Banking Solution
Company name : Finastra
Period : May 2006 - October 2011
Summary : - Design and Implement Data Migration solution from Finastra legacy Core Banking application
BankMaster to BFUB, solution was built using Open source ETL tool Talend.
- Design and Development of meta-data driven generic migration solution that can be used to migrate
data from any legacy application to BFUB.
- Lead the data migration and integration efforts at various client sites.
Location : Bengaluru Area, India
Job Title : Assistant Consultant
Company name : Tata Consultancy Services
Period : April 1997 - April 2006
Summary : - Design and implementation of Enterprise Data Warehouse, Data Mart and Operation Data Store solutions.
- Data architect, Logical Data modeling for OLTP and OLAP applications. Designed Star Schema /Dimensional Modeling in multiple projects.
- Design and development of DW ETL and Data Integration projects using Informatica, SQL Server DTS, Proprietary ETL solutions built using Perl, Pro* C, Oracle PL/SQL, Shell scripts.
- Design and development of Business Intelligence and Reporting solutions using Business Objects and Cognos. Expertise in building Business Objects Universe, Reports and Management Dashboards.
- Year 2000 Conversion/Remediation projects.
Location : Mumbai Area, India
NA
Show More