Nagaraju.G Contact: + 91-9916280601

Nagaraju.G Contact: + 91-9916280601

PL/SQL DeveloperE-Mail:

PROFILE SUMMARY AND RELATIVE SKILLS

Having3.2years of Total IT experience in designing, customizing and developing enhanced functionality to Oracle like SQL, PL/SQL, stored procedures, packages on Oracle 9i/10g Database as backend. Mainly in software analysis, design, implementation and development of Oracle.

Extensive experience in SQL, PL/SQL Programming concepts.

Has an extensive experience in data migration process from various data sources to Oracle9i/10g and SQL* loader.

Having knowledge in writing complex stored procedures involving in-depth data analysis, triggers and views as per business requirements.

Having knowledge in writing Complex Queries.

Has an Extensive experience in writing Materialized views.

Good Knowledge in creating PL/SQL Procedures.

Good Knowledge in creating PL/SQL Functions, Packages.

Good Knowledge in Forms and Reports.

Willingness and ability to quickly adapt to new cutting edge technologies and mastering sought-after skills.

Educational Qualifications:

B.Sc from Sri Krishna Devaraya University.

Professional Experience:

Technical Skills:

Languages: SQL, PL/SQL.

GUI: Developer 2000/6i.

Databases: Oracle 8i/9i, Oracle 10g.

Utilities: SQL * Loader

Operating Systems: WINDOWS2000, UNIX

Work Experience:

Project I:

Project Name:MASTER HEALTH

Client: Indo-American Cancer Hospital

Team Size:12.

Environment: Oracle8i/9i,Windows 2000/XP

Project Description:

Master Health was designed and developed for Indo-American Cancer Hospital (A Super specialist Hospital offering distinguished medical and theraphatic services around the clock). This project is basically providing sophisticated software for the automation of the various transactions in the hospital. It includes total 27 modules like Security, Registration, Doctor Appointments, Inpatient, and Outpatient, Investigative lab Services, House keeping, Radiology, Operation Theatre, Finance and Accounting with MIS Reports.

Role and Responsibilities:

• Involved in design of the database, which includes, table design and their relations.
• Written stored procedures, functions, packages and triggers.
• Develop SQL Queries for checking data transaction and database integrity.
• Involved in coding part of all respective module.
• Involved in writing stored procedures.
• Creating PL/SQL Packages,Procedures, Functions for data population and updation as per project requirements.
• Writing queries based on specifications.
• Analysis of requirements.
• Writing cursors according to specifications.
• Creating Database Triggers To Maintain Data Integrity.

Project II:

Client: Jewish Community Center

Team Size: 10

Role: Developer

Environment: Oracle9i, PL/SQL, Sql*Loader, Windows 2000/XP

Project Description:

Jewish Community Center is web-based application, which provides the information about health club, and the events that take place in the Community center etc. The Software includes content management System for administrator purpose, where the administrator can be able to maintain the site by updating the details. The other part is client user interface where the clients can become part by providing the details and can get the details of the events that take place in Community Center.

Role & Responsibilities:

• Created Database objects like Tables, Views, Procedures, Packages using Oracle Tools like PL/SQL, SQL * Plus.
• Responsible for the database release activities by creation data scripts and maintaining clear case release process.
• Extensively involved in production support of the application which is very complex by nature and has dependencies with four other systems.
• Creation Data Structures i.e. Tables & Views and applying the referential integrity.
• Design Data Conversion/Interface with the use of Sql * Loader.
• Documented User Requirements and Testing of developed modules.
• Responsible for creating complex stored procedures involving in-depth data analysis.
• Responsible for creating triggers to enforce complex business logics.

Project III:

Project Name: PAYROLL SYSTEM

Client: Bharat Biotech International Limited

Role: Developer

Environment: Oracle9i, PL/SQL, Sql*Loader, Windows 2000/XP

Description:

Payroll System which allows the user to define standard and non standard allowances deductions, option to input the non standard allowances and deductions month wise, calculations depending upon different Categories, Designations and Grades, attendances entry for the employees, Loan monitoring, Printing of payslip and generating reports like IT Recovery and loan Recovery,PF Recovery, LIC Recovery, Summary Salary Bill etc.

Roles & Responsibilities:

• Involved in writing stored procedures.
• Creating PL/SQL Packages, Procedures, Functions for data population and updating as per project requirements
• Writing queries based on specifications.
• Analysis of customer requirements.
• Writing cursors according to specifications.
• Creating Database Triggers To Maintain Data Integrity.