Forms and Reports, SQL, PL/SQL Developer Resume

SUMMARY:

More than 8 years proven experience in Oracle Forms, Reports, SQL and PL/SQL that includes Cursors, Ref - cursors, Procedures, Functions and Packages, Triggers, Materialized Views, Table Indexing,, SQL*Loader etc.
Expertise in Data Conversions/Migration from Legacy System of various sources (flat files, Oracle, Non Oracle Database) to Oracle system Using SQL LOADER, External table and Calling Appropriate Interface tables and API’s.
More than 8 years’ experience with proven ability in the area of Mainframe, Client/Server and Distributed Multi-tier Application Development, Database Design, Data processing and Support mainly using Oracle technology on different platforms.
Extensive experience in Complex SQL Queries, Dynamic SQL, Analytical function, Oracle Object etc.
Expert in Query Optimization, Debugging and Tuning for improving performance.
Knowledge of command line interface (CLI) in UNIX/LINUX.
Before Oracle I worked on Basic language and then Foxpro language.
Total 29 years of work experience of progressive IT development and support.
Excellent troubleshooting and debugging skills.
Strong interpersonal skills, ability to interact with people. Good presentation skills.
I am a Permanent Resident (green card) of US so I am authorized to work for any employer without requiring any visa sponsorship.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, SQLPLUS, Developer 2000 Forms and Reports

RDBMS: Oracle 10g/9i/6i/5.0, MS Access

ETL: SQL, PL/SQL

Other Tools: TOAD 8.0/8.5/9.0, SQL Loader, Export, Import, MS Office, Basic and FoxPro Language

Operating Systems: Unix, Linux, Windows

PROFESSIONAL EXPERIENCE:

Confidential

Forms and Reports, SQL, PL/SQL Developer

Responsibilities:

Designed and created complex PL/SQL code for the Migrating data from Mainframe, Flat files into Oracle database tables for BI purpose.
Developing and Modifying Oracle Forms and Reports (10g, 9i, 6i).
Extensively Works on production supports in bellow system.
Developing and Modifying Packages, Stored Procedures, Functions, triggers, grants and Developing and modifying PL/SQL packages, SQL Scripts to load data from different sources clean and transform data to provide quality information, and manage corporate metadata.
Developed Database Triggers for the integrity and security purpose.
Extract data into Oracle table using SQL LOADER.
Knowledge of using TOAD 9.0 (quest Soft).
Prepare Proper Documentation and Decode Mapping for further upgrade of code.
Created Complex SQL script, Dynamic SQL, Analytical function.

Confidential

Computer Operator

Responsibilities:

Collect Data from all section. Confirm that all data are entered in System.
Create a checklist / Error List through program and Confirm that all correction have been made.
Run reports and print all analytical reports.
Make file of all report and then present it to top management.