Summary
Overview
Work History
Education
Skills
Certification
Declaration
Personal Profile
Timeline
Generic

Parthiban Sekar Murali

Ambattur

Summary

PLSQL Developer with 11 years of experience in designing and implementing complex database solutions using Oracle 12C. Experienced with database programming, focusing on PLSQL. Utilizes effective query optimization to improve database performance and reliability. Knowledge of data modeling and schema design ensures robust database architecture.

Data migration professional with deep expertise in data analysis, ETL processes, and database management. Exceptional at leveraging technical skills to streamline data transfer, ensuring data integrity and accuracy. Strong focus on team collaboration and adaptability, consistently delivering results in dynamic environments. Proven ability to manage complex data migration projects with precision and efficiency.

Overview

11
11
years of professional experience
1
1
Certification
1
1
Language

Work History

Data Analyst

Tata Consultancy Service
Chennai
04.2022 - Current

Client :Bank of New York Mellon.

  • Optimized database performance by implementing efficient SQL queries and PL/SQL procedures.
  • Gathered and documented business requirements to determine capabilities to be delivered.
  • Data mapping will be done for source and target fields, and then data profiling will be done for the source data.
  • Identified opportunities for process improvement through regular evaluation of existing systems and development methodologies.
  • Optimized existing PLSQL routines using performance tuning techniques such as indexing, query optimization, and partitioning strategies.
  • Improved database performance by optimizing PLSQL code and implementing best practices.
  • Reduced data redundancy by designing normalized database schema and enforcing referential integrity constraints.
  • Streamlined data migration processes by developing custom ETL tools tailored to specific project requirements.
  • Worked closely with business analysts to translate requirements into functional specifications, ensuring alignment between technology solutions and business needs.
  • Ensured smooth application deployment by effectively managing version control systems and coordinating with system administrators during release cycles.
  • Conducted thorough code reviews to maintain consistency, improve code quality, and adhere to industry best practices.
  • Worked with end-users and functional analysts to capture and document business requirements.
  • Collaborated with cross-functional teams to develop high-quality business applications, resulting in increased operational efficiency.
  • Conducted data modeling, performance and integration testing.

Oracle Developer

Cognizant Technology Solution
06.2018 - 03.2022

Client: Hartford Insurance.

  • Developed efficient stored procedures for seamless data retrieval and manipulation, increasing application response time.
  • Optimized existing PLSQL routines using performance tuning techniques such as indexing, query optimization, and partitioning strategies.
  • Increased application stability by troubleshooting and resolving complex PLSQL issues in a timely manner.
  • Developed custom scripts for automating routine tasks, reducing manual effort required from the team while increasing accuracy rates in task execution.
  • Implemented best practices for change management, minimizing risk during system updates or enhancements.
  • Mentored junior engineers, fostering a culture of continuous learning and professional development within the team.
  • Developed custom Unix scripts for various business needs, simplifying tasks and improving productivity across departments.

Oracle Developer

Virtusa
02.2015 - 06.2018

Client : Citi Bank India

  • Developed or customized Oracle reports and forms to meet functional business requirements.
  • Provided technical expertise to support daily operations in Oracle applications.
  • Contributed to successful project completion by adhering to strict deadlines and meeting client requirements.
  • Collaborated effectively within an Agile development environment to rapidly respond to changing priorities while maintaining high-quality results.
  • Performed thorough testing on all developed modules, guaranteeing high-quality deliverables.
  • Ensured compliance with industry standards by following best practices in code development, version control, and deployment methodologies.
  • Automated routine tasks with the creation of custom scripts, boosting team productivity.
  • Reduced downtime by proactively monitoring systems for potential issues and addressing them before they escalated.
  • Earned recognition from management for consistently going above and beyond the call of duty, demonstrating a deep commitment to organizational success.
  • Improved production efficiency by identifying and troubleshooting issues in a timely manner.
  • Developed comprehensive documentation for system configurations, allowing for easier troubleshooting and faster resolution times.
  • Collaborated with cross-functional teams to identify areas for improvement in the production process, resulting in cost savings and increased efficiency.
  • Identified risk mitigation actions to reduce injuries, accidents and hazards in production environment.
  • Performed regular production studies and machine analysis to identify any quality and process problems.

Education

Bachelor of Technology - Information Technology

Vel Tech Engineering College (Anna University)
Chennai, India
04-2012

12th - undefined

Ebenezer Marcus Matriculation Higher Secondary School
Chennai, India
04-2008

10th - undefined

Ebenezer Marcus Matriculation Higher Secondary School
Chennai, India
04-2006

Skills

Data analysis

Performance tuning techniques

Advanced PL and SQL programming

Triggers and functions

Error handling and debugging

Stored procedures development

Database migration techniques

Partitioning and indexing

Certification

Oracle Cloud Infrastructure Foundation Associate, 2020

Declaration

I hereby declare that the details furnished above are true to the best of my knowledge and belief. [Parthiban S.M]

Personal Profile

  • Name: Parthiban S.M.
  • Date of Birth: 18-12-1990
  • Marital Status: Married.
  • Languages Known: English, Tamil.
  • Preferred Job locations: Chennai, Bangalore, Coimbatore.
  • Permanent Address: N0:79, Murugappa Reddy Street, Venkatapuram, Ambattur, Chennai-53.

Timeline

Data Analyst

Tata Consultancy Service
04.2022 - Current

Oracle Developer

Cognizant Technology Solution
06.2018 - 03.2022

Oracle Developer

Virtusa
02.2015 - 06.2018

12th - undefined

Ebenezer Marcus Matriculation Higher Secondary School

10th - undefined

Ebenezer Marcus Matriculation Higher Secondary School

Bachelor of Technology - Information Technology

Vel Tech Engineering College (Anna University)
Parthiban Sekar Murali