Developer Data

VENKAT REDDY Email: **********************@*****.***

PL/SQL Developer

Objective:

To work with the organization in strategizing, creating implementation plans for existing products, offering ideas for new products in the current realm, troubleshooting and resolving any engineering issues related to product, services, or clients of the organization through rational use of knowledge and skills acquired.

Education:

Master of Science in Computer Information Systems

Bachelor of Engineering in Computer Science And Engineering

Summary:

3 years of strong knowledge in Data Base Design, Data ware house, Application Development using Oracle 12c/11g,

SQL, PL/SQL, Oracle Data Integration.

knowledge in all phases of Software Development Life Cycle (SDLC) including analysis, specification, software and database

administration, development, maintenance, testing and documentation.

Excellent proficiency in Data Extraction, Transformation and Loading, Database Modeling and Data ware housing tools and

technologies.

Profound Knowledge in Star Schema Modeling and Snowflake Dimensional Modeling (Data Marts, Facts and Dimensions.

Strong technical expertise in creating and maintaining database objects - Tables, Views, Materialized Views, Indexes, Sequences,

Synonyms, Database Links and Database Directories.

Extensive experience in developing PL/SQL Stored Procedures, Functions, Packages, Cursors, Collections (Nested tables),

Records, Object types and Database Triggers.

Proficient in Oracle utilities and tools - SQL*loader, Export/Import, SQL*plus, SQL Developer and SQL Navigator.

Expertise in Performance Tuning and Query Optimization using various types of Hints, Partitioning, Bulking techniques and

Indexes.

Profound experience in Tuning SQL queries using utilities like EXPLAIN PLAN, SQL Trace and TKPROF to improve the

performance.

Strong experience in Oracle ETL data loading techniques like UTL_FILE, SQL loader, Copy Command and External tables from

various business source environments.

Exposure in Oracle Applications 11i Oracle Financials (AR, AP, GL modules of Oracle Applications 11i in multi Org, multicurrency

environment. *Hands-on experience with Oracle APEX 5.0.3 (Oracle Application Express).

Technical Skills:

Databases: Oracle 10g/11g,12c, MS-SQL Server 7/2000, MS

Access.

Languages: Basic C, C, Basic Java, HTML/DHTML, XML

and T-SQL.

Scripting: SQL, PL/SQL, UNIX Shell Scripting.

Query Tool: TOAD, SQL Developer, SQL Navigator,

SQLPlus.

Operating Systems: Windows 2000/NT/XP/7/98 and UNIX.

Packages: Micro Soft Office Suite- MS-Word, MS-Excel, MSPower

point.

Professional Experience:

PL/SQL Developer Jan 2020 – present

GDIT

GDIT (General Dynamics Information Technology) provides professional services and simulation and training to customers in the defense,

federal civilian government, health, homeland security, intelligence, state and local government and commercial sectors.Headquartered in

Fairfax with major offices worldwide, the company delivers IT enterprise solutions, manages large-scale, mission-critical IT programs and

provides mission support services.

Responsibilities:

Developed several Packages, Procedures, Functions and Triggers to use in multiple series of other backend programs using

PL/SQL.

Involved in Logical and Physical Database design and Star Schema design.

Identified Fact tables, Transaction tables for small Business and Consumer Markets (SBCM) customers.

Written SQL scripts to create database objects like tables, views and sequences.

Constant monitoring and performance tuning of Oracle12c database, checking the most queries.

Coded PL/SQL sub-programs and modified the existing PL/SQL program units for customer Contact Employees (CCE's)

relationships.

Customer Data Load from flat files into Oracle tables using PL/SQL procedures.

Created ETL design specifications.

Solid understanding of both the business and the technical aspects of BI Solutions.

Created table partitioning based on the systems and date range.

Implemented the snapshot process for moving the data into the warehouse.

Implementing the jobs using Apex with the job monitoring tool.

Assigning the Email notification then the data loading and validation is done.

Performed review and analysis of deadlocks and database performance tuning.

Conducted code walkthrough & internal/peer reviews on application code and other deliverables.

Documented the whole process flow, PL/SQL packages, log files, locations and descriptions, log tables and possible error

messages, process codes and descriptions.

Involved in the continuous enhancements and fixing of production problems.

Worked closely with the Application Development teams to identify and implement continuous improvements and effective problem

resolution strategies.

Environment: Oracle 12c, SQL, PL/SQL, Apex 5.0.3, HTML, Unix, Windows 2007/2010.

Contact this candidate