PL/SQL Developer Resume NY - Hire IT People

SUMMARY:

Six (6) years of Information Technology experience in Database designing, Development and programming using Oracle 9i/10g databases, Developer Suite 10g Reports, SQL and PL/SQL in Retail Distribution environments.
Extensive experience in PL/SQL stored procedures, functions, packages, Users/Privileges/Roles, Database Triggers for updating of daily transactions, reports extractions and handle validation of source data, creation of DB objects like tables, views, triggers, users, roles, index etc.
Expertise in the development of real - time projects Client/Server technologies, RDBMS under Windows NT/2000, Solaris and HP-UX. Strong coding and debugging skills.
Experience in production support and issue resolution.
Extraordinary Logical/Mathematical skills, very high programming aptitude and has ability to resolve most challenging complex problems.

TECHNICAL SKILLS:

SQL, PL/SQL

Data Migration using Oracle packages and SQL*Loader

Designing Procedures/Functions, Database Triggers, Sequences and other Database objects

Test scripts for Unit testing and QA

Production Support

SOFTWARES/TOOLS

Oracle Database 9i/10g

Toad

SQL Developer

SQL*Loader

PROFESSIONAL EXPERIENCE:

Confidential, NY

PL/SQL Developer

Responsibilities:

A privately held Corporation, providing high quality, advanced retail management software systems to retail organizations.
Designing/modification of triggers, stored procedures and functions using PL/SQL
Creation of database objects like tables/indexes, users, roles, privileges, constraints, regular/materialized views, sequences and synonyms etc.
Support to front end Java team
Data migration from different sources to Oracle database
Physical and logical databases designing
Interaction with users for requirement gathering
Application Performance tuning
Production support/fixing application bugs

Environment: Oracle 10g, SQL Developer, Procedure Builder, PL/SQL, SQL*Plus, UNIX Sun Solaris

Confidential, NY

PL/SQL Developer

Responsibilities:

Designing PL/SQL and Advanced PL/SQL Procedures/Functions and Packages for back end processing
Developed PL/SQL Packages, Procedures, Functions for online transactions processing, Reports extractions and data conversion from different sources to Oracle database.
Responsible to keep application up and running
Creation of new tables from existing data for error correction and implementing new structural changes in the database

Environment: Oracle 10g, UNIX Sun Solaris, Windows 2000/NT, Oracle 10g, Toad, PL/SQL, Oracle Developer Suite 10g

Confidential, New York

Oracle Backend Developer

Responsibilities:

Involved in full life cycle of Application Development for Point of Sales system on Client/Server using Oracle 10g databases.
Designing/modification of triggers, packages, store procedure and functions using PL/SQL.
Weekly creation of price book flat file from database tables for transfer to stores.
Designing of Batch files and SQL*Loader Control files for data transfer from different stores to central database.
Daily data conversion from imported text files (Invoice & Price file) into database tables using stored procedure.
Data loading from text format to Oracle tables and back from Oracle tables to text file using Oracle package UTL File.
Creation of database objects like tables/indexes, constraints, regular/materialized views, sequences and synonyms etc.
Designing/Enhancements of forms using Oracle Reports 9i
Interaction with users for requirement gathering

Environment: Oracle 9i, PL/SQL, SQL*Plus, TOAD, Windows NT, HP-UX, Developer 2000, SQL*Loader, Reports 9i