PL/SQL Developer

Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL. Created conceptual, logical, and physical models of applications. Developed SQL scripts, packages, and procedures for business rules checks and data transfer across schemas and databases.

Requirements

• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Involved in creation of Conceptual Modeling covering all the business requirements.
• Created process force and deployed into run time depository using ware house builder
• Involved in logical modeling and physical modeling of application.
• Developed SQL scripts, packages and procedures for Business rules check to implement business rules.
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Loaded the data into database tables using SQL*loader from text and excel files.
• Developed data model, SQL Queries, SQL Query tuning process and Schemas.