Grandhi - Oracle PL/SQL Developer - Bangalore, KA, India

Nirmaladevi Grandhi

Bangalore, KA, India

Services

Oracle PL/SQL Developer

Summary:

• Having 2 Years of IT work experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Expertise in Client-Server application development using Oracle 11g/10g/9i SQL/PLSQL, ,ERP(Axpert)
• Has good experiences in IT industry in a broad range of functions & involved in development of various Software projects.
• Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Flexible and able to work effectively in a team environment or as an individual.
• Developing Complex database objects like Stored Procedures, Functions and Triggers using SQL and PL/SQL.
• Creating Sequence,Tables, Views, Constraints, Index
• Developed Materialized Views for data replication in distributed environments.
• Good domain experience

Work History

Oracle PL/SQL Developer

Chemistry For

From May 2013

Life, Oman
Organization: Infoway Technosoft Solutions, Bangalore
Team Size: 3
Duration: May2013 - Till Date
Role: Oracle PL/SQL Developer.
Environment: Oracle 10g Database, ERP Tool(Axpert)

Project Description:
Chemistry for Life has earned an outstanding reputation as a preferred Chemicals supplier in the Sultanate of Oman for its full range of Products, all supported by unsurpassed service. This project mainly focused to provide an integrated procurement management system to an organization .Design end to end development of Manufacturing Management Functionality.Given Integration Purchase, Sales module with Finance, Inventory Modules.Purchase module mainly decides the product quantity to be purchased and as per the supplier response, will purchase the product and also pays the bills and receiving the products, will update the inventory and to pay the bills will update the finance module .HR and Payroll module handles employee services like Attendance, Salary Processing, Leaves, Promotions.

Following modules developed in this project
Purchase, Sales, Financial Accounting (AR, AP), Inventory, HR and Payroll Modules

Role Description:
• Requirements Analysis: Understanding the requirements of the client and act as a sole of Techno-functional resource.
• Involved in development of the forms and reports and fast reports in Purchase Management, Sales Management and Inventory Management.
• Creating Indexes on the tables for faster retrieval of the data to enhance database Performance.
• Involved in Logical & Physical Database Layout Design.
• Developed Views, Materialized Views for data replication in distributed environments.
• Developed Complex database objects like Stored Procedures, Functions and Triggers using SQL and PL/SQL.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.

Software Engineer

Infoway Technosoft solutions pvt. Ltd

From May 2012

Oracle PL/SQL Developer

ABIRAMI HOSPITAL

July 2012 - April 2013

(Coimbatore).
Organization: Infoway Technosoft Solutions, Bangalore.
Team Size: 5.
Duration: July 2012 - April 2013.
Role: Oracle PL/SQL Developer.
Skills: Oracle 10g Database(SQL, PL/SQL ), ERP Tool(Axpert)


Project Description:
ABIRAMI has been a key member of Windows Based ERP Product over the last 1 Year in establishing the requirements. HIMS will give automate solution for Hospital activities. HIMS will provide complete package for maintain the hospital regular activities. This product process starts from patient level with registration and end with Discharge. Before discharge this will involve Laboratory services or Diagnostics services. Billing will cover room rent, doctor consultation charge and pharmacy activities. Human resource will maintain the details of working and non-working employees. Appointment is very useful for patients, to schedule their appointment with specialized doctor.

Following modules developed in this project
Inpatient Module, Laboratory Module, Purchase Module, Inventory Module

Role Description:
• Involved in development of Inpatient Module, Laboratory Module, Purchase Module, Inventory Module
• Requirements Analysis: Understanding the requirements of the client and act as a sole of Techno-functional resource.
• Involved in development of the forms and reports and Fast reports in Inpatient Module, Laboratory Module, Purchase Module, Inventory Module.
• Creating Indexes on the tables for faster retrieval of the data to enhance database Performance.
• Involved in Logical & Physical Database Layout Design.
• Developed Views, Materialized Views for data replication in distributed environments.
• Developed Complex database objects like Stored Procedures, Functions and Triggers using SQL and PL/SQL.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Created scripts to create new tables, views, queries for new enhancement in the application using...

Qualifications & Certifications

CSE

JNTU

Skillpages has been acquired by Bark.com!

Bark.com is pioneering the way people find local services. Skillpages is the world’s premier directory of service providers.

Find out more

Are you sure that you want to leave?