Anubhav Kumar

Client: Bank of America

• Designed and developed PL/SQL packages, stored procedures, functions, and triggers to implement complex business logic for banking applications.
• Implemented file ingestion and data loading processes using external tables, SQL*Loader, and PL/SQL to read structured files and load data into Oracle databases.
• Created and maintained database objects (tables, partitioned tables, indexes, constraints, sequences) to support high-volume transactional systems.
• Applied table partitioning (range, list, composite partitioning) to improve query performance and manage large datasets.
• Wrote and optimized complex SQL queries (joins, subqueries, CTEs, window functions) for reporting and data processing.
• Implemented performance tuning techniques using execution plans, indexing strategies, and query optimization.
• Utilized bulk processing techniques (BULK COLLECT, FORALL) for high-performance data operations.
• Worked in Agile/Scrum environment, participating in sprint planning, code reviews, and deployments.
• Ensured data integrity, data security, and compliance with banking and financial regulations.
• Collaborated with cross-functional teams (developers, QA, business analysts) for requirement analysis and solution delivery.

Project: NEST(TCS-BANCS)

Client: Nest, Uk

About: A robust IT infrastructure and pension application landscape for existing UK Pension standards & regulations. Digitalization of pension process by furnishing several applications for banking transactions like infra & inter banking, internet banking, cash deposit machines.

Highlights:

• Worked as offshore SPOC of development Migration.
• Worked on development, Migration, and enhancements in agile methodology.
• Developing business logic using PLSQL, Joins ,Packages, Index, Collections, Bulk operations ,stored Procedures and Functions according to business requirements.
• The job role comprises of being a part of the entire Production support, Real time Solution to Batch issue. Creating new SQL queries as per business Requirement.
• Used Oracle external tables to migrate data from one database server to another.