PRASANTH GURRALA
Hyderabad
Summary
Dedicated Oracle PL/SQL Developer with over 5 years of professional experience specializing in database design, query optimization, and data manipulation. Demonstrated expertise in developing complex SQL joins and PL/SQL scripts to efficiently handle large datasets and support business intelligence efforts. Proficient in crafting and maintaining robust ETL processes, as well as developing front-end applications that streamline database interactions. Recognized for analytical skills, attention to detail, and the ability to translate complex business requirements into high-performance technical solutions. Committed to continuous learning and leveraging new technologies to drive efficiency and innovation.
Overview
5
5
years of professional experience
1
1
Certification
Work History
PL/SQL Developer
Tata Consultancy Services
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, sub queries, and correlated sub queries 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 PL/SQL 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
04.2019
Skills
- SQL & PL/SQL programming
- Design and implementation of Triggers, Functions, Stored Procedures, and Packages
- Extraction, Transformation, and Loading (ETL) processes
- Advanced Excel usage
- Scripting with Python and Perl
- Unix and shell scripting
Ide
- PL/SQL Developer
- Oracle SQLDeveloper
- MYSQL Front
- Apache Netbeans
Database
Oracle
Certification
- Power BI: Dashboards for Beginners
- Azure Data Engineer Associate certification
Accomplishments
- Received multiple client appreciations for exceptional performance.
- Awarded the Service and Commitment Award.
- Recipient of the On-the-Spot Award for outstanding contributions.
- Honored with the Star Team Award for collaborative team efforts.
Timeline
PL/SQL 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
Prakash GadhamsettyPrakash Gadhamsetty
Assistant Consultant at Tata consultancy services limitedAssistant Consultant at Tata consultancy services limited