MANDYAM BHUPATHI
plsql developer
Hyderabad, Telangana, India
0
Followers5
FollowingHaving 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
- Gathering development requirement from client's and internal functional team and from functional specification design documents.
- Involved in development of code from scratch for the given requirement.
- Performed Unit testing and Documented for each Job and same reviewing with Technical Architect.
- Coordinating with Functional folks to understand the functional Spec and building the Technical specification based on Business requirement meets.
- 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.
- Understanding the pre-existing Procedures and functions and if necessary, then update the procedures and functions according to the requirement.
- Attending the meetings and updating my status and discussing about the requirements.
- Writing SQL queries using joins, sub queries and correlated sub queries.
- Coordinated with team members in business requirements analysis, system analysis, design and development of the application.
- Used pragma autonomous transaction for avoiding the mutating error in database trigger.
- Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
- Coordinating with the Testing team and UAT team about any bug fixes and for any other requirements to developer.
- Worked on JSON and XML files and have good knowledge.
- Using WINMERGE to merge and compare the code
- Using Postman Application to test the orders.
- 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
Welcome 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