Looking for a job

Lokanath Giri

@lokanathgiri

Data Architect and Data Modeler for Mastercard and Santander, designing Apple Pay analytics and migrating Santander Cards databases to Oracle RAC.

India

Message

At NTT Data, I designed solutions for Mastercard’s Lifecycle Communication Marketing, Apple Pay transaction analytics, and historical statement modernization. I also tuned complex SQL queries and supported teams translating solution architecture into database and reporting designs.

For Santander’s Cards-IT team at Coforge and ITC Infotech, I worked on migrating the database from NuoDB to Oracle RAC 19.2 to address scalability and performance issues. I also worked with partitions in the Cards database and supported database development for the microservices team.

Across projects at Ocwen Financial Solutions, Tavant Technologies, and Robert Bosch Engineering and Business Solutions, I worked on data modeling, data migrations, validation, and data warehousing. My experience includes Oracle, SQL and PL/SQL, Informatica, and dimensional modeling, across banking, automotive, and analytics projects.

Experience

Work history, roles, and key accomplishments

Senior Specialist Advisor

NTT Data

May 2024 - Oct 2025 (1 year 5 months)

Designed end-to-end solutions for customer experience and engagement platforms, including Apple Pay transaction analytics and historical statement modernization. Performed performance tuning and optimization of complex SQL queries to improve API response times.

SQL Pl SQL Performance Optimization Data Migration Solutions Architect Microservices Oracle

Senior Technical Architect

Coforge

Nov 2021 - Apr 2023 (1 year 5 months)

Led database migration from NuoDB to Oracle RAC 19.2 for Santander UK's Cards-IT team. Provided database support to microservice teams, including object creation, query tuning, and mentoring.

Oracle RAC Database Migration SQL Pl SQL Partitioning Microservices Kafka Dynatrace Kibana

Technical Architect

ITC Infotech

Feb 2021 - Nov 2021 (9 months)

Worked on database migration from NuoDB to Oracle RAC 19.2 for Santander UK's Cards-IT team. Provided database support to microservice teams, including object creation, query tuning, and mentoring.

Oracle RAC Database Migration SQL Pl SQL Partitioning Microservices Kafka Dynatrace Kibana

Data Architect/Data Modeler

Ocwen Financial Solutions

Nov 2016 - Apr 2020 (3 years 5 months)

Responsible for data modeling in Erwin and job orchestration for HRDM, Progress DB Migration, Bankruptcy, Survey, Solicitation, BitB, and BDE projects. Designed data validation modules and wrote Oracle packages for data load and validation.

Erwin Informatica Oracle SQL Pl SQL Data Modeling Data Validation Control M Axway

Technical Architect

Silverlink Technologies

Jul 2015 - Apr 2016 (9 months)

Responsible for coding for EBI module and automated manual direct contract reconciliation for Dell Financial Services. Coordinated with stakeholders in EMEA, Brazil, and USA, and mentored team members.

Oracle SQL Pl SQL JSON Toad TFS Application Server

Associate Architect

Tavant Technologies

Sep 2012 - Apr 2015 (2 years 7 months)

Responsible for complete architectural design for data migration projects including Club Car for Ingersoll Rand, SNEI-Sony, and TiVo. Prepared HLD, performed data analysis, and mentored team members.

Erwin ODI Toad Oracle Data Migration Dimensional Modeling ETL MySQL SQL*Loader

Architect

Robert Bosch Engineering and Business Solutions

Jul 2003 - Sep 2012 (9 years 2 months)

Worked on multiple projects including Series DB, SOLA_BRASPAC, ISAC, ePC, DS/ORG, ISCOPE, and DDL. Responsible for technical leadership, data migration, SQL/PL/SQL tuning, and mentoring team members.

Oracle SQL Pl SQL Data Migration DTS Oracle Forms Oracle Reports Application Server Data Modeling

Project Assignee

CMC Ltd

Apr 2002 - Sep 2002 (5 months)

Responsible for system testing, software implementation, and user training for the Khajane Treasury Automation System for the Government of Karnataka.

Oracle Forms Oracle Reports Oracle Pl SQL System Testing User Training