Photo of MANDYAM BHUPATHI

MANDYAM BHUPATHI

plsql developer

Hyderabad, Telangana, India
0
Followers
5
Following
Having 4+ years of Experience in Application development and Maintenance/Support projects using SQL, PL/SQL with extensive understanding of different Application development tools and technology.
Extensive experience in creating complex database objects like stored procedure, Functions, Packages, Collections and Triggers,Tables, Views, Constraints, Sequences and Synonyms.
Proficient in PL/SQL programming - SQL tuning, Cursors, user defined exception, Pragma Autonomous Transaction, Bulk Collect and for all,Views, Sys refcursor, indexes, Analytical Functions like RANK (), DENSE RANK (), ROW_NUMBER () …etc., SQL-Loader,PL/SQL Collections, Global Temporary Tables etc.

Careers

Software Developer

Virtusa consulting services Pvt Ltd

Full time05/2022 - 07/2023
  1. Gathering development requirement from client's and internal functional team and from functional specification design documents.
  2. Involved in development of code from scratch for the given requirement.
  3. Performed Unit testing and Documented for each Job and same reviewing with Technical Architect.
  4. Coordinating with Functional folks to understand the functional Spec and building the Technical specification based on Business requirement meets.
  5. Involved in Grant, Stored procedures, functions, triggers, packages, Arrays,Bulk collect, for all DML, Collections, tables, views, Synonyms, Sequences, Views, Indexes, Gather Stats for Schema and Table level, SQL tuning, Cursors, Ref Cursors, Anonymous blocks.
  6. Understanding the pre-existing Procedures and functions and if necessary, then update the procedures and functions according to the requirement.
  7. Attending the meetings and updating my status and discussing about the requirements.
  8. Writing SQL queries using joins, sub queries and correlated sub queries.
  9. Coordinated with team members in business requirements analysis, system analysis, design and development of the application.
  10. Used pragma autonomous transaction for avoiding the mutating error in database trigger.
  11. Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
  12. Coordinating with the Testing team and UAT team about any bug fixes and for any other requirements to developer.
  13. Worked on JSON and XML files and have good knowledge.
  14. Using WINMERGE to merge and compare the code
  15. Using Postman Application to test the orders.
  16. Using Git for application repository.

Education

Sri Venkateswara college of Engineering and technology

EEE

08/2013 - 03/2017Bachelor's DegreeClass of 2017
Skills
PLSQL Developer SQLPostgreSQLUnixServiceNow
Experience3-5 years
Hourly rate$484/hr
Open to
remotehybridonsite

astro circleWelcome to Outdefine

A free tokenized community dedicated to connecting global tech talent with remote job opportunities. Our platform is designed to help you connect, learn, and earn in the tech industry while providing the chance to collect DEF tokens. Join our vibrant community today and explore a world of possibilities for your tech career!

Join for free
astro-hello

Join a community, when you join Outdefine!Connect with 72,000 tech professionals globally.

A free tokenized community dedicated to connecting global tech talent with remote job opportunities. Our platform is designed to help you connect, learn, and earn in the tech industry while providing the chance to collect DEF tokens. Join our vibrant community today and explore a world of possibilities for your tech career!