Summary
Overview
Work History
Education
Skills
Rdbms
Projects
Certification
Affiliations
References
Timeline
Generic
Modukuru Nagaraju

Modukuru Nagaraju

SQL Developer
Vetapalem

Summary

Meticulous SQL Developer with expertise in processing data and knowledge of various flowcharting techniques. An excellent understanding of database structures, theories, principles and practices. Superb problem-solving and analytical skills.

Overview

5
5
years of professional experience
4
4
Certifications
3
3
Languages

Work History

Senior SQL Developer

Capgemini Technologies India Pvt. Ltd.
05.2022 - Current

• Having 5.4 years of experience in Application development and Support projects using SQL, PL/SQL and Unix with extensive understanding of different Application development tools and technologies.

• Having good experience in SQL and PLSQL development using ORACLE 11g and ORACLE 12c. ORACLE 19c.SQL Server Management Studio 11

• Extensive experience in creating complex database objects like stored procedure, Functions, Packages, Collections and Triggers.

• Experience in Creating Tables, Views, Constraints, Sequences and Synonyms.

• Extensive experience in DDL, DML, TCL Commands.

• Proficient in PL/SQL programming of using Cursors, user defined exception, Pragma Autonomous Transaction, Bulk Collect and for all, Explain Plan, Sys refcursor, indexes, Analytical Functions,

• Aware of the Concept of Exception handling mechanism in various scope and visibility. • Having knowledge on Performance Tuning.

• Involved in development of code from scratch for the given requirement.

• Planning, delivering and implementation of quality solutions as per scheduled milestones.

• Good communicational and interpersonal skills and involved in client interactions for scoping, effort estimates and status reporting.

• Ability to learn new technologies with minimal time period and excellence in team playing with multi-location teams.

• Experience on Autosys Scheduling Jobs

  • Promoted high customer satisfaction by resolving problems with knowledgeable and friendly service.
  • Demonstrated leadership by making improvements to work processes and helping to train others.
  • Prioritized and organized tasks to efficiently accomplish service goals.
  • Planned and completed group projects, working smoothly with others.
  • Achieved cost-savings by developing functional solutions to problems.

Software Engineer

IMSI Staffing Pvt. Ltd
02.2021 - 05.2022
  • • Developed stored procedures, functions, Triggers, PLSQL programmed unit etc as per the project requirement
  • Based on the mapping document we will create tables and write triggers for enhanced validation and business logic management.
  • Modified existing procedures, functions as per the Project requirements.
  • Involved in the development backend code, altered tables to add new columns, Constraints, Sequences and Indexes as per business requirements.
  • Using SQL developer tool we are debugging the code and unit test.
  • Created record types, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
  • Attend the daily scrum meetings

Education

High School Diploma -

Bapatla Polytechnic College
Bapatla
06-2018

Bachelor of Science - Bcom

Sarada Degree College
Ongole
06-2021

MBA - Information Technology Management

Dr. D. Y. Patil Vidyapeeth
Pune
04.2001 -

Skills

Oracle SQL

undefined

Rdbms

  • Oracle 10g/11g/19c
  • 19C

Projects

Project Name : Healthcare System  

Client : GE 

Role : Team Member/Oracle SQL and  PLSQL Developer 

Environment: Oracle 12C, SQL, PLSQL, GIT Extension  Duration

Description:  The Health Care Database Management project is to automate various activities  in Hospital. The main activities covered are Doctors Information, Patient Details, Billing,  Diagnosis and Medical Products. The project has 4 modules namely General, Inpatient,  Outpatient and Reports. Details regarding patient such as name, gender, address, type  of patient complaint, assigning treatment department based on complaint etc is captured  and a unique registration number for new patient is automatically generated. All the  details such as provisional diagnosis number, unit number etc is taken for the patients  who had already been treated at some other units. The registration number in this  module is reflected from the General module. Inpatient: If the patient is admitted into the  hospital all the details such as provision diagnosis number, discharge status, ward, unit  etc are gathered. There are lots of reports used for monthly, yearly, fortnight etc. which  are taken care here

Roles & Responsibilities:  

• Developed stored procedures, functions, Triggers, PLSQL programmed unit etc as  per the project requirement

• Worked on SQL*Loader to load data from flat files obtained from various facilities  every day.

• Based on the mapping document we will create tables and write triggers for  enhanced validation and business logic management

• Based on the mapping document we will create tables and write triggers for  enhanced validation and business logic management. 

• Modified existing procedures, functions as per the Project requirements. 

• Involved in the development backend code, altered tables to add new columns,  Constraints, Sequences and Indexes as per business requirements. 

• Using SQL developer tool we are debugging the code and unit test. 

• Created record types, tables, collections (nested tables and arrays) for improving  Query performance by reducing context switching. 

Certification

I completed aws cloud architect by edureka

Affiliations

  • I'm Digital Youtube Creator
  • Reading Books
  • Traveling explore

References

References available upon request.

Timeline

Senior SQL Developer

Capgemini Technologies India Pvt. Ltd.
05.2022 - Current

Software Engineer

IMSI Staffing Pvt. Ltd
02.2021 - 05.2022

MBA - Information Technology Management

Dr. D. Y. Patil Vidyapeeth
04.2001 -

High School Diploma -

Bapatla Polytechnic College

Bachelor of Science - Bcom

Sarada Degree College
Modukuru NagarajuSQL Developer