RUSHYA M
Chennai
Summary
Results-driven PL/SQL Developer with extensive experience at IT Services, adept in MySQL and performance tuning. Successfully automated repetitive data requests, saving over 50 hours monthly. Proven leader in driving mini-projects, fostering collaboration, and enhancing coding standards through effective communication and peer reviews.
Overview
13
13
years of professional experience
Work History
PLSQL Developer, Westpac Group
TATA CONSULTANCY SERVICES
Chennai
12.2024 - Current
- Developed and maintained 50+ scripts, stored procedures, functions, views, tables, cursors, and triggers for data migration and conversion tasks.
- Collaborated with stakeholders to gather requirements, implement report development, and custom interface programs.
- Leveraged advanced features of Oracle 11g for PL/SQL programming, including records and collections.
- Participated in the complete software development lifecycle, including planning, analysis, design, and implementation of PL/SQL solutions.
- Collaborated with web development teams to ensure seamless integration of back-end and front-end solutions.
- Trained team members on PL/SQL best practices and performance tuning techniques.
- Collaborated with stakeholders to understand business requirements and translate them into technical specifications.
- Optimized SQL queries for better performance by analyzing execution plans and query optimization techniques.
- Created test cases for unit testing of new or existing PL and SQL code.
- Conducted peer code reviews to ensure quality and adherence to coding standards.
L3 Support, Westpac Group
TATA CONSULTANCY SERVICES
Chennai
01.2020 - 02.2024
- Participated in requirement-gathering sessions with stakeholders and business analysts to understand functional specifications and requirements.
- Understanding and analysing new user requirements and accommodating the change without affecting the existing workflow.
- Dynamic Offshore team leader who successfully drove the Initiative (Mini) projects to completion with a five-member team.
- Troubleshot and debugged complex issues, identifying root causes and implementing solutions to prevent recurrence.
- Worked on many initiative (mini) projects as a PL/SQL backend developer and created 100+ scripts, procedures, functions, triggers, and tables.
- Collaborated with front-end developers to ensure a seamless integration of the back-end system with the user interface.
- I have completed the effective knowledge transition to the team members about the features of the developed or existing codes and their functionalities.
- Conducted code reviews to maintain quality standards and improve team coding practices.
- Involved in complete life cycle development activities from requirement gathering to implementation phase.
L2 Production Support, Health Logic System
TATA CONSULTANCY SERVICES
Chennai
01.2013 - 10.2018
- Having knowledge of analyzing backend PLSQL code and finding the root cause of the issues raised by users.
- Having effective communication with clients and SMEs to understand the issues and find solutions to the incidents raised.
- Created over 100 PL/SQL queries to fetch the data from the backend, as per the client’s requirements.
- Reduced over 50 hours of team time per month by identifying the repetitive data requests and automating it.
- Immediate action on Autobus job failure, and handling them effectively.
- Involved in the performance tuning of already existing code.
- Peer-reviewed the customized data-fix code created by other team members for the production release.
- Helped and advised team members on the production fix and data-fetching activities.
- Ensure value by understanding customer requirements, identifying dependencies, risks, and clearly communicating and escalating where appropriate.
- Handling all kinds of user incidents, such as prioritizing them, processing requests, and updating the log on a regular basis.
- Prepared training documents for the end user related to a few incidents.
Education
Electrical and Electronics Engineering -
Thiagarajan College of Engineering
Madurai, TN, India05.2012
Skills
- MySQL
- PLSQL
- Toad
- SQL developer
- Service now
- MS SQL
- Autobus
- Jira
- Kettle
- Putty
- Datafix tool
Affiliations
- I received many appreciations from clients for prompt solutions to the issues, providing the data needed well before, and delivering the developed functionalities quickly
- On the Spot Award and Star Team Award for Health Logic Project
Languages
Tamil
First Language
English
Upper Intermediate (B2)
B2
Timeline
PLSQL Developer, Westpac Group
TATA CONSULTANCY SERVICES
12.2024 - Current
L3 Support, Westpac Group
TATA CONSULTANCY SERVICES
01.2020 - 02.2024
L2 Production Support, Health Logic System
TATA CONSULTANCY SERVICES
01.2013 - 10.2018
Electrical and Electronics Engineering -
Thiagarajan College of Engineering
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Sreya BasuSreya Basu
Procare Analyst at Tata Steel(Tata Consultancy Services)Procare Analyst at Tata Steel(Tata Consultancy Services)
Arun VArun V
Program Manager at Tata consultancy services | Financial Ombudsman ServicesProgram Manager at Tata consultancy services | Financial Ombudsman Services
Naimish AgnihotriNaimish Agnihotri
Assistant Delivery Manager at Tata Consultancy Services, Global Shared ServicesAssistant Delivery Manager at Tata Consultancy Services, Global Shared Services
Vishnu Priyan CVishnu Priyan C
Assistant Lead Engineer - R&D at Vestas Technology R&D LtdAssistant Lead Engineer - R&D at Vestas Technology R&D Ltd