PRASANNA KUMAR R
Chennai
Summary
With 12 years of comprehensive experience as a Techno-Functional Consultant specializing in Oracle Database and Applications, I have managed data migration and production services within the Banking and Financial sector. Additionally, I have spent 1.5 years as a PPM consultant, focusing on Project Costing, ensuring high-quality service delivery, and fostering continuous improvement. I excel in leading cross-functional teams and managing client relationships.
Overview
13
13
years of professional experience
Work History
Oracle Fusion PPM Techno Functional Consultant
BNY Mellon Technology
Chennai
12.2022 - Current
- Implemented and provided production support for the Oracle PPM Fusion modules, including Costing and Billing.
- Offered techno-functional expertise in configuring and developing custom BIP Reports for Oracle PPM Fusion applications.
- Participated in end-to-end testing of all Project Budget, Costing, and Billing processes.
- Contributed to data migration efforts, including the import of labor and miscellaneous costs from third-party systems.
- Worked with cross-functional teams to ensure smooth integration of Oracle PPM Fusion with existing systems.
- Supported project management tasks such as defining scope, planning resources, and managing timelines.
Database Support Team Lead
BNY Mellon Technology
08.2015 - 12.2022
- Oversee the design and development of database schemas, tables, views, indexes, and other database objects.
- Guide the creation of complex PL/SQL code, stored procedures, triggers, and functions to support business requirements.
- Analyze and optimize database performance, including query tuning, indexing strategies, and database configuration.
- Implement monitoring solutions and perform regular performance reviews to identify and address bottlenecks.
- Troubleshoot and resolve complex database issues, including performance problems, data corruption, and system failures.
- Implement and test solutions to prevent recurrence of similar issues.
- Working on resolving Database incidents through AWR, SQL profiling and SPM
- Developed and maintained knowledge articles to support existing processes.
Oracle Application Technical Analyst
Cognizant Technology Solutions
11.2011 - 07.2015
- Managed code migration, validation, and deployment for PL/SQL packages, procedures, synonyms, tables, indexes, and other components.
- Reviewed PL/SQL code to optimize performance and recommended improvements in coding standards.
- Developed Shell Scripts to automate code and file migrations.
- Handled application upgrades, performed clean-ups, and applied customizations to the database application tier.
- Collaborated with development teams to conduct performance testing for defects identified in production-like environments and reported findings to management.
- Conducted daily health checks of databases using custom tools to manage alerts and notifications.
Education
Bachelor of Engineering - CSE
Anna University
Chennai04-2011
Skills
- Oracle Certified Associate in SQL & PLSQL
- SQL Performance Tuning
- Oracle 10g, 11g,12C & 19C
- Unix
- Incident Management
- Change Management
- Client Relationship Management
- Product - Eagle Application
- Oracle Fusion PPM
- Project Costing
- Project Billing
Accomplishments
- Completed OCA certification in Oracle 10g administrator track.
- Completed OCA certification in Oracle 9i PL/SQL.
- ITIL V3 certified
Overall Experience
- Cognizant Technology Solutions - Nov 2011 - July 2015
- BNY Mellon Technology - Aug 2015 - Present
Timeline
Oracle Fusion PPM Techno Functional Consultant
BNY Mellon Technology
12.2022 - Current
Database Support Team Lead
BNY Mellon Technology
08.2015 - 12.2022
Oracle Application Technical Analyst
Cognizant Technology Solutions
11.2011 - 07.2015
Bachelor of Engineering - CSE
Anna University
Similar Profiles
Krishnaraja GanapathyKrishnaraja Ganapathy
Application Development Manager at BNY Mellon Technology India Pvt Ltd – Pershing TechnologyApplication Development Manager at BNY Mellon Technology India Pvt Ltd – Pershing Technology
Saravanan JGSaravanan JG
Data Engineer at BNY Mellon Technology India Pvt LtdData Engineer at BNY Mellon Technology India Pvt Ltd
Preeti AsraniPreeti Asrani
Vice President at BNY Mellon TechnologyVice President at BNY Mellon Technology
Prem Kirandeep MathiPrem Kirandeep Mathi
ESP Engineer at BNY Mellon TechnologyESP Engineer at BNY Mellon Technology
Hemachandar RajasekarHemachandar Rajasekar
Technical Support Professional (cloud Support) at Foundever (formerly Sitel)Technical Support Professional (cloud Support) at Foundever (formerly Sitel)