Developer Sql
Resume:
MUNI
****.********@*****.***
Experience in Summary:
Has 2 Year of Industry Experience as Oracle Developer.
Has Experience in Development and Support of Enterprise Applications in Health Care and Banking Domains.
Has Written Complex SQL Queries and created Views on the Oracle Database.
Have Developed and Documented PL/SQL Procedures, Functions, Packages and Triggers.
Has Good knowledge of SDLC, Extensively involved in BUILD Phase.
Has Utilized SQL*Loader, Bulk Load Facility in Client’s Legacy Data Conversion Activities.
Did Tuning for Long running SQL Queries (of Views) to improve the performance using EXPLAIN PLAN.
Have Handled Business User Queries and resolved critical issues during Production Support.
An Efficient Team Player with Good Communication & Customer Interaction Skills.
Education Qualifications:
M.C.A. from P. Indira Reddy Memorial Engineering College, Chevella, A.P. in 2010 with 70.5%.
Technical Skill Set:
Programming Languages : SQL, PL/SQL.
Databases : Oracle 9i, 10g.
Utilities : SQL*Loader.
Tools : SQL Developer & Putty.
Operating Systems : MS – Windows Family, UNIX.
Versioning Tools : CVS.
Project Profile:
Project # 1 Duration: Mar ‘2011 – Till Date.
Title: Rehab Management System.
Client: Serenity Foundation, Secunderabad, A.P. India.
Environment: Solaris, Windows XP, Oracle 10g, SQL, PL/SQL, SQL Developer, Putty, CVS, SQL*Loader.
Team Size: 6.
Role: Developer.
Description:
Serenity Foundation, situated at Secunderabad is a Rehabilitation Center for Drug and Alcohol Abuse. Rehab Management System is a software package which is developed to address the IT needs of Serenity Foundation. This package has several modules such as Process (Admissions, Detoxification, Allocation, and Strategy & Discharge), Stores, Purchase, Administration, and Setup.
Responsibilities:
Involved in Development of both Stores and Process Modules.
Created Complex Queries for Views for reporting purposes.
Developed PL/SQL Procedures, Functions, Packages and Triggers to satisfy Requirement Specs.
Utilized SQL*Loader during Patient Master Data Conversion into Process Module Tables.
Prepared Unit Test Plan and carried out the Tests for all developed code.
Participated in Status Meetings and sent the Daily & Weekly Status Reports.
Prepared Low Level Documents (LLDs) for all Program Units Developed.
Project # 2 Duration: Jun ‘2010 – Mar ‘2011
Title: Loan Management System.
Client: Mahesh Co – Operative Bank, Hyderabad A.P.
Environment: Windows 2003 Server, XP, Oracle 10g, SQL, PL/SQL, SQL Developer, CVS.
Team Size: 3
Role: Developer (Production Support)
Description:
Mahesh Bank based at Hyderabad, A.P. offers various loans facilities such as GOLD LOAN, VEHICLE LOAN, HOUSING LOAN, INDUSTRIAL FINANCE, BUSINESS LOAN etc., to its customers. The System which has been implemented, effectively manages complete loan process from the point when the customer submits the application till the closure of loan.
Responsibilities:
Did Root Cause Analysis and Resolved Critical Production Issues.
Changed/Modified PL/SQL Stored Units (Procedures, Functions & Packages) as part of Issue Resolutions.
Tuned Certain Long Running SQL Queries for performance using Explain Plan.
Interacted with Business Users to understand the Issue – Scenarios.
Prepared/Updated the relevant Documents to reflect the changes/modifications.
Employment History:
Employer : Right path Computer Technologies (P). Ltd., Madhapur, Hyderabad.
Designation : Software Developer.
Period : Jun’ 2010 – Till Date.
Contact this candidate