Oracle SQL

Professional Summary: • SQL-PL/SQL Developer with 1.8 years of experience in professional application and database development with thorough knowledge of different phases of software development lifecycle including analysis, design, development, documentation, deployment and system support. • Experience in designing of the database in SQL Server 2012, 2008, 2005 and 2000. • Hands on experience in writing T-SQL queries, Stored Procedures, User Defined Functions (UDF), Cursors, Derived Tables, Views, and Triggers. Professional Education: • B. Tech in Computer Science Engineering (2013-2016) from Jawaharlal Nehru Technological University (JNTU) Professional Experience: • Worked as SQL Developer in Extranet Software Solutions pvt ltd, Vijayawada from Dec’2016 to Oct’2018. Skills: • Java, Oracle10g/11g, SQL Server, PLSQL, HTML, CSS, XML, MS Office, TOAD, SQLDeveloper. Project: 1 Customer: MTAR Personal information System relates to HR operations. It contains few modules with a tag called, Time Office, which is a major concern in the Payroll. Masters contains a provision for new companies, unit, channel, department, employee, shift, schedules, holidays and leave types. This module provides an interface for processing leave form, Compensatory off, on duty, shift change, on tour and on tour authorization. Process module has provision for schedule creation, attendance processing, and holiday payment schedule and holiday payment authorization. Reports module provides information to the management as daily attendance, monthly attendance, loss of pay, leave status, man power, shifts, abstract and comp off. Team Size: Dev-5, QA-3 Project Role: SQL developer Tasks performed: • Understanding the Client Requirements Clearly. • Developed stored procedures, calculated members, perspectives based on the user’s requirements. • Designed and created SQL Databases, tables, indexes, and views based on user requirements. • Responsible for installation of Oracle 10g, database design, and create schema objects like tables, views and indexes. • Backend database development in oracle, writing complex queries, stored procedures, views, triggers, UDFs. • Depth knowledge of writing Procedures, Functions, Packages, Triggers, Cursors, Exceptions. • Move the database from Dev environment to Production environment. • Analyzed and optimized the existing procedures and codes for the best performance. • Maintain the regular backups. Environment: Oracle 10g