Rohith Shenoy
Kitchener,ON
Summary
- As an Oracle PL/SQL developer with over 4 years of programming experience, I am looking for a responsible and challenging role to utterly use my skills, knowledge, and experienced learnings for the benefit of the company/organization and to achieve heights in my field of passion. Could be a top performer in all phases of the SDLC (Software Development Life Cycle), from analysis, design, development, testing, implementation, and maintenance, with timely delivery against aggressive deadlines. Clarity in what I know and dedication in learning what I don't are my promises towards every opportunity I get.
Overview
5
5
years of professional experience
Work History
Oracle PL/SQL Developer
Tata Consultancy Services
01.2019 - 08.2023
- Involvement in the full software development cycle of analyzing the design document, implementing the requirement using PL/SQL technology, unit testing the code, integration with existing implementation, QA and UAT support by fixing the defects, and postproduction deployment validations.
- Experience in client-server application development using Oracle 11g/10g, PL/SQL technology.
- Expertise with Oracle Database Objects: Tables DM, Indexes, Views, Synonyms, Sequences, Partitions, Clusters, Stored procedures and packages, Table spaces, constraints, and triggers.
- Expertise in forming complex queries using appropriate joins.
- Expertise in developing a whole PL/SQL package with functions, procedures, dynamic queries, and handling known exceptions.
- Experience in debugging in-built Oracle exceptions and errors.
- Partitioned large tables using range partition and split partition techniques.
- Experience with Oracle Supplied Packages such as DBMS_SQL, DBMS_JOB and UTL_FILE.
- Good knowledge of key Oracle performance-related features such as the query optimizer, execution plans, and indexes.
- Created shell scripts are invoked within PL/SQL packages to perform file transfer operations from one server to another.
Education
Post-Graduate Certificate - Reporting Systems And Database Development
Conestoga College Institute of Technology And Advanced Learning
Kitchener, ON04.2024
Bachelor of Engineering (Electronics & Communication) -
Rajalakshmi Institute of Technology
01.2018
Skills
- Databases: Oracle
- RDMS Development
- Problem-Solving
- Agile Methodologies
Professional Summary
- Internship at QuScient Technologies Private Limited from June 2018 to November 2018.
- Application developer at Tata Consultancy Services from January 2019 to August 2023.
- Key responsibilities were to develop PL/SQL packages based on the user requirements by analyzing client-provided designs and providing fixes for QA, UAT, or production bugs by prioritizing based on severity.
- Adapted to Agile working standards and, at times, took ownership of sprint planning, Jira board creation, and helped the team remove roadblocks.
- Familiar with tools like Jira, Zephyr, GIT-Bitbucket, SQL Developer, DBeaver, PuTTy, WinSCP.
Timeline
Oracle PL/SQL Developer
Tata Consultancy Services
01.2019 - 08.2023
Post-Graduate Certificate - Reporting Systems And Database Development
Conestoga College Institute of Technology And Advanced Learning
Bachelor of Engineering (Electronics & Communication) -
Rajalakshmi Institute of Technology
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
Abdullah Al-MusawiAbdullah Al-Musawi
Pharmacy Assistant at WalmartPharmacy Assistant at Walmart