Prasanth Gurrala
Hyderabad
Summary
Junior Oracle PL/SQL Developer with over 4.5 years of experience in designing complex queries to extract and manipulate data using SQL joins and exceptions from databases. Over 4 years experience in analysis and creating data extracting scripts using PLSQL. Over 3 years experience in developing and supporting front end application using PLSQL.
Overview
5
5
years of professional experience
1
1
Certification
Work History
PLSQL Developer
Tata Consultancy Services
Hyderabad
07.2019 - Current
- Developed PL/SQL scripts to efficiently retrieve project-related information from the data repository, leveraging cursors for data traversal and incorporating robust exception handling mechanisms for error management.
- Crafted numerous intricate SQL queries utilizing a variety of techniques such as SQL joins, subqueries, and correlated subqueries to efficiently retrieve and manipulate data from diverse databases.
- Designed complex database objects like tables, views, triggers and indexes as per business requirements.
- Participated in Database Design Discussions with Business Analysts and Application Teams.
- Analyzed existing SQL queries to identify opportunities for improvements.
- Loaded data from various sources to Oracle database using SQL loader.
- Maintained scripts using Perl and Python to support development.
- Created scripts to automate daily tasks such as backup jobs and scheduled jobs.
- Developed stored procedures, functions and packages using PLSQL to support the application development needs.
- Deployed production ready applications on multiple environments.
- Prepared documentation for all the processes involved in developing a software product.
Education
B-tech - Electrical And Electronics Engineering
Gandhi Institute of Technology And Management
Visakhapatnam04.2019
Skills
- PL/SQL
- SQL
- Extraction Transformation and Loading (ETL)
- MS Excel
- Python
- Perl
- Data extracting
- Technical Analysis
- Testing and maintenance
- VBScript
- Adaptability
- Excellent team player
- Excellent time management
- Critical Thinking
- Adaptability
- Excellent team player
- Excellent time management
- Critical Thinking
Accomplishments
- Received various appreciations from clients on several occasions.
- Won the star team award.
- Won the on the spot award.
- Won the on the spot award.
Certification
Power BI: Dashboards for Beginners (2020)
Timeline
PLSQL Developer
Tata Consultancy Services
07.2019 - Current
B-tech - Electrical And Electronics Engineering
Gandhi Institute of Technology And Management
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
Abhiram BarikAbhiram Barik
Architect at ZscalerArchitect at Zscaler