Summary
Overview
Work History
Education
Skills
Timeline
Generic

Ramarajan P

PLSQL Developer
Chennai,TN

Summary

Organized and dependable candidate successful at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals.

Overview

13
13
years of professional experience

Work History

PLSQL Developer

HTC Global Services (India) Private
2011.02 - Current
  • Collaborated with cross-functional teams to integrate various systems, streamlining business processes.
  • Maintained database documentation for accurate record-keeping and easy reference for colleagues.
  • Improved database performance by optimizing PLSQL code and implementing best practices.
  • Reduced data redundancy by designing normalized database schema and enforcing referential integrity constraints.
  • Developed efficient stored procedures for seamless data retrieval and manipulation, increasing application response time.
  • Ensured compliance with industry standards by following best practices in code development, version control, and deployment methodologies.
  • Optimized existing PLSQL routines using performance tuning techniques such as indexing, query optimization, and partitioning strategies.
  • Automated routine tasks with the creation of custom scripts, boosting team productivity.
  • Worked closely with business analysts to translate requirements into functional specifications, ensuring alignment between technology solutions and business needs.
  • Collaborated effectively within an Agile development environment to rapidly respond to changing priorities while maintaining high-quality results.
  • Implemented advanced error handling techniques in PLSQL code, resulting in robust applications with minimal crashes.
  • Conducted regular database backups and recovery procedures, safeguarding valuable data against potential loss or corruption.
  • Performed thorough testing on all developed modules, guaranteeing high-quality deliverables.
  • Streamlined data migration processes by developing custom ETL tools tailored to specific project requirements.
  • Contributed to successful project completion by adhering to strict deadlines and meeting client requirements.
  • Enhanced data security with the implementation of proper access controls and user roles management.
  • Mentored junior PLSQL developers, fostering an environment of collaboration and continuous learning.
  • Participated in regular code reviews for consistent quality assurance across the team''s work output.
  • Provided technical support to end-users, ensuring smooth operations and minimal downtime.
  • Increased application stability by troubleshooting and resolving complex PLSQL issues in a timely manner.
  • Created optimal technical solutions to user needs with in-depth system analysis.
  • Analyzed existing SQL queries to identify opportunities for improvements.
  • Analyzed business reports for prompt communication, follow-up and ongoing support.
  • Helped plan data extraction and processing tasks, aiding in eventual deployments.
  • Managed workload independently but collaborated with colleagues to complete larger scale tasks in distributed team environment.
  • Maintained complex T-SQL queries, views and stored procedures in multi-database environment with little supervision.
  • Developed, implemented and optimized stored procedures and functions using T-SQL.
  • Developed reusable components for exploitation in coding and documentation.
  • Followed standard practices for migrating changes to test and production environments.
  • Supported projects enabling delivery efficiencies and technical resolution.
  • Built data integration solutions to introduce new sets into asset repositories.
  • Resolved complex business issues, proposing long-term solutions to avoid repeat problems.
  • Performed regular database backups to prevent information loss.
  • Developed custom database objects, stored procedures and delivered application support.
  • Documented analysis results and provided performance improvement feedback.
  • Implemented system enhancements to design and develop solutions to address problem reports.
  • Devised high-quality database solutions ranging in size and complexity, increasing productivity and improving data sharing.
  • Authored code fixes and enhancements for inclusion in future code releases and patches.
  • Developed next generation integration platform for internal applications.
  • Developed conversion and system implementation plans.
  • Rapidly prototyped new data processing capabilities to confirm integration feasibility into existing systems.
  • Tested troubleshooting methods and documented resolutions for inclusion in knowledge base for support team use.
  • Tuned systems to boost performance.
  • Designed and developed analytical data structures.
  • Inspected equipment, assessed functionality, and optimized controls.
  • Investigated new and emerging software applications to select and implement administrative information systems.
  • Contributed ideas and suggestions in team meetings and delivered updates on deadlines, designs, and enhancements.
  • Translated technical concepts and information into terms parties could easily comprehend.
  • Designed and developed forward-thinking systems that meet user needs and improve productivity.
  • Created proofs of concept for innovative new solutions.
  • Corrected, modified and upgraded software to improve performance.
  • Documented software development methodologies in technical manuals to be used by IT personnel in future projects.
  • Estimated work hours and tracked progress using Scrum methodology.
  • Conducted data modeling, performance and integration testing.
  • Coordinated deployments of new software, feature updates and fixes.
  • Tested functional compliance of company products.
  • Built databases and table structures for web applications.
  • Optimized dust, temperature and humidity controls for installed systems.
  • Analyzed work to generate logic for new systems, procedures and tests.
  • Tested and deployed scalable and highly available software products.
  • Designed and implemented scalable applications for data extraction and analysis.
  • Supervised work of programmers, designers and technicians, assigned tasks and monitored performance against targets.

Education

Bachelor of Science - Bsc Computer

Enadhi Rajappa Arts And Science
Pattukkottai, India
2001.04 -

Skills

Continuous integration tools

undefined

Timeline

PLSQL Developer

HTC Global Services (India) Private
2011.02 - Current

Bachelor of Science - Bsc Computer

Enadhi Rajappa Arts And Science
2001.04 -
Ramarajan PPLSQL Developer