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

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
Data purification - 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:

Confidential is Information Technology Services provider to its chain of 100+ food stores in NYC. The corporation provides Price/Cost control system to its stores. Initially application was designed on AS/400 platform using RPG language. Then new "Point of Sales" application was designed using Oracle 10g to maintain price books, financial control and order maintenance. All data from AS/400 was transferred to Client/Server using SQL*Loader.
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