Intermediate
Kolla Soft Pvt. Ltd
مجموع سنوات الخبرة :8 years, 0 أشهر
Proficient in developing and maintaining of packages, functions, application procedures, stored
procedures, indexes, using Oracle PL/SQL database programming language.
• Design and Generation of different Database Objects like Tables, Views, Materialized Views,
Synonyms and Sequences, Cursors, PL/SQL packages and Database Triggers.
SQL, PL/SQL Experience:
• Analyze the Business Requirements (BRD) and convert them into Technical Specification (Technical Design Document).
• Co-ordinate with business and data analysts in reviewing the requirements, posing questions and translating business requirements to technical specifications.
• Proficient in advance features of Oracle 11g for PL/SQL programming like using cursor variables, Reference cursors, Array’s, nested tables, Dynamic SQL and Bulk Binds.
• Modifying the queries to reduce the time for performance issues.
• Designed and developed master tables, views, sequences and synonyms.
• Developed various Complex Queries, Views for generating Reports.
• Worked on various DDL, DML, and DCL (TCL, ACL) statements.
• Created Tables, Views, and Indexes according to application specification.
• Used SQL Loader, Data Mapping to run batch jobs to retrieve data from flat files to database tables.
• Created Materialized Views to maintain duplicate data on local node.
• Worked on requirements analysis for change requests and defects raised by end users
• Interacted with business clients in the remote locations to verify customer requirements
Work Experience:
. Currently working as a Trainee in Kolla Soft Pvt. Ltd., Hyderabad from June 2016 to till date.
Project Summary:
TRAVEL UR is a tourism development corporation and is a online e-Ticket Booking web -portal for flights, buses, hotels and vacation packages and also in this a Social Messenger chat server is developed. TravelUR gets all the travel information need into one place. Best vacation destinations, best travel deals, social media features, customized travel deals based on interest and profile preferences and great giveaways, together in one app called TravelUR.
Roles & Responsibilities:
. Creation of Database Objects Tables, Table Spaces, Indexes and extensively involved in
performance tuning
. Creation of DB links & Materialized Views and Tuning of DB configuration parameters.
. Creating the database’s for straight Environment.
. Database maintenance and support.
. Conducted Basic Training for Server Administration.
Travel UR
Environment :PostgreSQL
(
from
from