Vikram Nagalikar
Oracle PL/SQL & Performance Tuning Lead
Pune
Summary
15+ years of experience in Oracle PL/SQL development and performance tuning with a strong focus on automation and process optimization — driven by a “learn-any-tech” attitude to get things done efficiently.
Overview
15
15
years of professional experience
4
4
years of post-secondary education
4
4
Languages
Work History
Oracle PL/SQL Lead
Citibank India
09.2018 - Current
- Led large-scale data migrations, with accountability for over 4 TB of financial and accounting data.
- Proficient in analyzing AWR reports, reading execution plans, and optimizing complex SQL queries.
- Hands-on expertise in advanced Oracle features, including SQL Macros, Buffer Keep Pool, Packages, Procedures, and other core PL/SQL components for building efficient, high-performance applications.
- Leveraged Oracle Advanced Compression and Partitioning to effectively control database growth, preventing exponential storage expansion, and improving data manageability.
- Utilized DBMS_PARALLEL_EXECUTE to break down and process large-volume DML operations in parallel, reducing batch job runtime by up to 70%.
- Leveraged Result Cache to store frequently accessed query outputs, significantly reducing CPU load and response time for read-heavy operations.
- Developed in-house automation tools that delivered cost savings of over $100K, and significantly improved team productivity.
Data Migration Consultant
EdgeVerve
Jakarta
12.2016 - 08.2018
- Performed large-scale data migration for a leading banking client in Indonesia, ensuring accuracy, consistency, and minimal downtime.
- Engaged in regular client interactions to understand source data structures and accurately map them to the target banking system fields.
Technology Analyst
Infosys
09.2010 - 12.2016
- Worked as an Oracle PL/SQL Developer for a leading pharmaceutical company, managing a complex enterprise application built entirely on Oracle.
- Played a key role in Oracle database upgrades, application tuning, and leveraging new Oracle features to enhance performance and scalability.
Education
Bachelor of Engineering - Electronics & Telecommunication
Mumbai University
Mumbai 01.2006 - 01.2010
Skills
Oracle PL/SQL
Orcale Performance Tuning
Python
Oracle Advanced Compression
Excel Macros
Source and version control: git, github
Address
- K 806 Dynasty Society
- Pune
- 411057
- India
Timeline
Oracle PL/SQL Lead
Citibank India
09.2018 - Current
Data Migration Consultant
EdgeVerve
12.2016 - 08.2018
Technology Analyst
Infosys
09.2010 - 12.2016
Bachelor of Engineering - Electronics & Telecommunication
Mumbai University
01.2006 - 01.2010
Similar Profiles
Sudesna ChakrabortySudesna Chakraborty
Senior Production Support Engineer at Citibank IndiaSenior Production Support Engineer at Citibank India
SNEHA SHARMASNEHA SHARMA
Bank Loan Officer at CitiBank India N.A.Bank Loan Officer at CitiBank India N.A.
Annie Jacob Annie Jacob null
Junior Processing Officer at Citigroup Global Services Ltd ((Expenses & Processing for Citibank India)Junior Processing Officer at Citigroup Global Services Ltd ((Expenses & Processing for Citibank India)
Komal SatputeKomal Satpute
Azure Data Engineer at Motifworks Inc. – An Accion Labs CompanyAzure Data Engineer at Motifworks Inc. – An Accion Labs Company
MOHIT SINGHMOHIT SINGH
Fiber Network Planner at Tech MahindraFiber Network Planner at Tech Mahindra