Veerapandian M
Chennai
Summary
Technical Lead with significant expertise in Oracle Database Management and data migration at Wipro Technologies. Demonstrated ability to optimize complex SQL procedures, resulting in improved operational efficiency. Experienced in mentoring teams and fostering collaboration to deliver high-quality results in dynamic environments. Proficient in Jira for effective project management.
Overview
9
9
years of professional experience
1
1
Certification
Work History
Technical Lead
Wipro Technologies CDC5
Chennai
07.2025 - Current
- Executed migration of Citi FX Trade Processing application from Sybase ASE to Oracle, supporting large-scale initiative.
- Converted and optimized complex Sybase stored procedures into Oracle PL/SQL, ensuring performance and functionality.
- Conducted data reconciliation validation between Sybase and Oracle to guarantee accuracy of FX trade transactions.
- Performed impact analysis on trade processing workflows, addressing defects related to data and logic.
- Engaged in unit testing and integration testing, resolving migration defects for stable production rollout.
- Delivered end-to-end migration support for critical FX trade processing modules with minimal disruption.
Senior Software Developer
Mindgate Solutions Private Limited
Chennai
02.2024 - 03.2025
- Performing the application developer for the major developments and implementations, requirements, and impact analysis in payments module.
- Designed and Implemented Archival and Purging strategies using PL/SQL procedures in MSSQL, ORACLE, POSTGRES.
- Leveraged Azure Data Factory and Synapse to develop scalable data processing solutions.
- Acquired expertise in Big Bang Migration, facilitating seamless version-to-version transition.
- Developed SQL scripts, packages, and procedures for Business rules check to implement business rules.
- Developed Procedures for efficient error handling process by capturing errors into user-managed tables.
- Involved in tuning the SQL queries, creating database objects, and optimizing storage parameters for tables and indexes.
- Mentored junior PL/SQL developers, fostering an environment of collaboration and continuous learning.
- Participated in regular code reviews for consistent quality assurance across the team’s work output.
- Worked closely with business analysts to translate requirements into functional specifications, ensuring alignment between technology solutions and business needs.
- Performed thorough testing on all developed modules, guaranteeing high-quality deliverables.
Specialist Software Engineer
LTIMindtree
Chennai
06.2022 - 05.2023
- Utilized Oracle tools to create database objects, including tables, views, and indexes.
- Designed and coded necessary database structures and components for optimal performance.
- Developed PL/SQL stored procedures, functions, and triggers to implement business logic.
- Implemented Change Data Capture technology in microservices architecture for data warehouse integration.
- Created Materialized Views and optimized loading processes for Dimensions and Facts.
- Employed query tuning techniques and applied hints to enhance SQL performance.
- Executed EXPLAIN PLAN and utilized DBMS_PROFILER for query optimization analysis.
- Led initiatives to improve operational efficiency while ensuring data accuracy and regulatory compliance.
PLSQL Developer
YOHO Technologies
Chennai
07.2017 - 06.2022
- Analyzed existing SQL queries to identify opportunities for improvements.
- Responsible for sending daily and weekly status reports.
- Involved in table creation, constraint maintenance.
- Writing complex SQL queries using Subquery, Joins, and Functions.
- Created and debugged various PL/SQL subprograms like Procedures to support various areas of development.
- Experience in anonymous block, cursors, exception handling.
- Used SQL Loader to load data from flat files to tables.
Education
PGDPMIR -
Alagappa University
Chennai05.2020
BBA -
Alagappa University
Karaikudi05.2013
Skills
- Oracle Database Management (11g, 12c, 19c)
- MSSQL and PostgreSQL
- Jira project management
- intellij
- GitHub, Bitbucket
- Autosys job scheduling
- Azure Data Factory
- Synapse analytics
Certification
Oracle Database Certified Associate (SQL (1Z0-071))
Disclaimer
I hereby declare that all the information furnished above is true to the best of my belief.
Languages
Tamil
Native
Native
English
Proficient (C2)
C2
Timeline
Technical Lead
Wipro Technologies CDC5
07.2025 - Current
Senior Software Developer
Mindgate Solutions Private Limited
02.2024 - 03.2025
Specialist Software Engineer
LTIMindtree
06.2022 - 05.2023
PLSQL Developer
YOHO Technologies
07.2017 - 06.2022
PGDPMIR -
Alagappa University
BBA -
Alagappa University