MANIDEEP BOYAPATI
Cumming,GA
Summary
- Over 3+ years Strong working experience includes Software Development and Implementation of Oracle 11G/12c/19C as Developer.
- Hands on Experienced in Database programming using Oracle PL/SQL. Involved in writing PL/SQL Stored Procedures, Functions, Cursors, Triggers and Package.
- Written complex SQL (Sub queries and Join conditions), in PL/SQL.
- Troubleshoot and debug system and/or data errors.
- Proficient knowledge in performance tuning and knowledge to work according to the Work request and Change Request.
- Ability to understand the business requirements and Data models. Automated SQL LOADER to load data from flat files.
- Vast Experience in Oracle advance SQL Programming Using Analytical functions, Sub Queries, indexes and Set Operators.
- Proficient in creation, modification and effectively use of database objects like Tables, Constraint, Sequences, Indexes, Group Functions, and Views.
- Experience and Excellent Exposure in Query tuning using Materialized Views & Indexes.
Overview
8
8
years of professional experience
1
1
Certification
Work History
Oracle SQL Developer
Radiant Software Solutions Inc.
03.2024 - Current
- Designed and implemented the database schema, including tables, indexes, and relationships to support the application's requirements
- Created complex PL/SQL stored procedures, functions, triggers, and packages to automate business logic and enforce data integrity
- Wrote optimized SQL queries for data retrieval, reporting, and analysis, ensuring efficient performance and accuracy.
Oracle SQL/ETL Developer
Softekk India Private Ltd.
03.2016 - 06.2020
- Interacted with Team in Analysis, Design and Develop database using ER Diagram, involved in Design, Development and testing of the system
- Developed PL/SQL-stored procedures, Tuned SQL Queries (using Indexes),
- Created Views to facilitate easy user interface implementation and Triggers on them to facilitate consistent data entry into the database
- SQL Scripting, using Microsoft SQL Server Management Studio 2016, to research, update, add, or delete information for records within tables using SELECT, UPDATE, INSERT, or DELETE statements with JOIN, WHERE GROUP BY, and ORDER BY clauses
- Worked on analytical functions like RANK and DENSE_RANK
- Worked on client requirement and wrote Complex SQL Queries to generate Crystal Reports.
Education
Master of Science - Information Technology
Wilmington University
New Castle, DE01.2024
Skills
Languages :Oracle SQL, PLSQL and Java
Scripting : Shell Scripting, Python
Database : Oracle 11G,12C, 19C
Tools : SQL Developer, Toad,SQL*Plus
Operating System : Windows, Linux, Mac
Certification
Oracle Database SQL Certified Associate (Iz0-071) in July 2024.
Accomplishments
- Oracle Database SQL Certified Associate (Iz0-071) in May 2024
- SQL Scripting, using Microsoft SQL Server Management Studio 2016, to research, update, add, or delete information for records within tables using SELECT, UPDATE, INSERT, or DELETE statements with JOIN, WHERE GROUP BY, and ORDER BY clauses
- I worked on analytical functions like RANK and DENSE_RANK
- I worked on client requirement and wrote Complex SQL Queries to generate Crystal Reports
- Environment: :Oracle 11g/12, SQL Developer, TOAD, SQL Plus
Timeline
Oracle SQL Developer
Radiant Software Solutions Inc.
03.2024 - Current
Oracle SQL/ETL Developer
Softekk India Private Ltd.
03.2016 - 06.2020
Master of Science - Information Technology
Wilmington University
Similar Profiles
Jaykumar MistryJaykumar Mistry
Flutter Developer at Radiant Strategic SolutionsFlutter Developer at Radiant Strategic Solutions
Layasri ValabhojuLayasri Valabhoju
Ui Developer at Radiant Digital SolutionsUi Developer at Radiant Digital Solutions
Nikhil ThawareNikhil Thaware
IT Manager at Radiant 3PL Solutions India Pvt LtdIT Manager at Radiant 3PL Solutions India Pvt Ltd