Prasanth Gurrala
Hyderabad
Summary
Junior Oracle PL/SQL Developer with over 3 years of experience in designing complex queries to extract and manipulate data using SQL joins and exceptions from databases. Over 2 years experience in analysis and creating data extracting scripts using PLSQL. Over 3 years experience in supporting and maintaining front end application using PLSQL.
Overview
3
3
years of professional experience
1
1
Certification
Work History
PLSQL Developer
Tata Consultancy Services
Hyderabad
07.2019 - Current
- Wrote PL/SQL programs required to retrieve project related data from data repository using cursors and exception handling.
- Wrote many complex queries using SQL joins, sub queries and correlated sub queries.
- 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.
- Developed scripts using Python and SQL to automate repetitive database processes.
- Tracked and documented all releases regularly.
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
Websites
Accomplishments
- Received various appreciations from clients on several occasions.
- Won the star team award.
Certification
Power BI: Dashboards for Beginners (2020)
Languages
English
Advanced (C1)
Telugu
Bilingual or Proficient (C2)
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
RaviTeja PisupatiRaviTeja Pisupati
Equity Research Analyst at ERP Consulting Client - Jio Financial services LtdEquity Research Analyst at ERP Consulting Client - Jio Financial services Ltd