SUMMARY

• Over 7 years of programming experience as an Oracle Developer with Software Development Life Cycle (SDLC) performing detailed analysis, design, Data Modeling (Logical and Physical), and Implementation of Business Applications using the Oracle Relational Database Management System(RDBMS).
• Experience in using Oracle tools like SQL*Loader, SQL*Plus, TOAD, SQL Navigator and SQL Developer in very high volume data.
• Strong Knowledge on oracle architecture and database design.
• Has strong noledge on data ware housing concepts and experience in Database design using Normalization and E/R Diagrams.
• Design and develop Star Schemas, identifying Fact and Dimension tables for providing a unified view to ensure consistent decision making.
• Experience in creating and maintaining database objects like Tables, Indexes, Views, Synonyms, complex Stored Procedures, TEMPeffective Functions, and appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Excellent conceptual noledge of Oracle 11g/10g/9i/8i.
• Extensive experience in database programming using SQL and PL/SQL.
• Experience in developing SQL and PL/SQL (Coding Procedures, Functions, Database Packages and Triggers).
• Experience in writing and Tuning of complex SQL statements, complex Joins and Sub Queries.
• Experience in UNIX Korn Shell Scripting, scheduling cron jobs.
• Experience in working with Dynamic SQL, Ref Cursors, Bulk Collections and Exception Handling.
• Proficient in designing and developing of Forms and Reports using Oracle Forms 10g/9i/6i and Reports 10g/9i/6i.
• Experience in creating SQL Loader scripts to load data from flat files into the database and also creating external tables to manage data which is stored at the OS level.
• Experience in retrieving data from Personal Data Files and Stored Procedures.
• Excellent planning, analytical, written Communication, ability to work under pressure and Interpersonal skills.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, C, HTML, XML, JavaScript, C#, ASP.net

Database (RDBMS): Oracle 11g/10g/9i/8i, SQL Server 2008/2005/2000

GUI: Oracle Forms 10g/9i/6i and Reports 10g/9i/6i

Database back - end-tools: SQL Developer, SQL * Loader, TOAD, SQL * Navigator, SQL * Plus, SQL Server Management Studio

Operating Systems: Windows 7, Windows Vista/XP/NT, UNIX, Linux, Sun Solaris

Designing Tools: IBM Rational rose.

PROFESSIONAL EXPERIENCE

Confidential, OH

Sr.Oracle Developer

Responsibilities:

• Collaborated with the Business analysts and the DBA for requirements gathering, business analysis, testing and project coordination.
• Analysis of business functionality with the client and the developers.
• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Involved in developing crontab to schedule the information of cron entries.
• Involved in creation of Conceptual Modeling covering all the business requirements.
• 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.
• Worked with Bulk Collect to implement the performance of multi row queries.
• Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database.
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Data loaded from legacy systems using PL/SQL and SQL*Loader.
• Developed Procedures for efficient error handling process by capturing errors into user managed tables.Executed automatic call processes on UNIX through Perl, Shell, SQL, and Control files.
• Developed Shell scripts to automate execution of SQL scripts, Table creation and execute Procedures.
• Used Toad for creating PL/SQL (trigger, sequence, stored procedure).

Environment: Oracle 10g/9i, SQL, PL/SQL, SQL*Loader, Perl, UNIX Shell script, TOAD, Oracle Forms 10g, Reports10g, UNIX, Windows XP/2000.

Confidential, OH

Oracle Developer/Data Analyst

Responsibilities:

• Analyzed and overviewed the database design for better understanding the relations, associations and dependencies within the database.
• Depending on the business requirements, created and modified database objects like Tables, Indexes, Views, Stored Procedures, Functions, Packages, Triggers, Synonyms, and Materialized Views to make new enhancements or resolve problems.
• Created various SQL and PL/SQL scripts as required.
• Extensively used Cursors, Ref Cursors and Exceptions in developing Packaged Procedures and Functions.
• Developed SQL and PL/SQL scripts to transfer tables across the Schemas and Databases.
• Worked on complete System Development Life Cycle (SDLC) including system analysis, high level design, detailed design, coding and testing.
• Creation of database objects like Tables, Views, Procedures using Oracle tools like SQL*Plus, SQL Developer and Toad.
• Developed various complex queries to generate various reports based on the requirements.
• Used VI editor for PL/SQL scripts and UNIX Shell Scripting for regular maintenance and production support to load the data in regular intervals.
• Involved in creating Indexes to avoid the need for large table, full table scans and disk sorts, and for fast retrieval of data from database objects while generating reports.
• Created complex Triggers for generating primary key values and for implementing the complex business logic.
• Involved in Bulk loading of data from non-Oracle data sources, flat files using SQL * Loader.

Environment: Oracle 10g, Perl, Forms 10g, Reports 10g, SQL*Plus, TOAD, SQL*Loader, SQL, PL/SQL, UNIX, Linux, Windows XP.

Confidential, NY

Oracle PL/SQL Developer

Responsibilities:

• Interacted with Business Analysts and client representatives for requirements gathering, research and solving client specific data issues.
• Created Tables, Indexes, Synonyms, Sequences, Materialized Views, Inline Views and Normal Views needed as per the requirements.
• Generated SQL and PL/SQL scripts to create and drop database objects including Tables, Views, Primary Keys, Indexes, Constraints, Packages, Sequences, Grants and Synonyms.
• Tune the SQL queries and complex Procedures to improve performance.
• Created database Triggers for data security and Consistency.
• Wrote Procedures, Functions and packages for new requirements.
• Implemented advanced PL/SQL Concepts for better performance of PL/SQL Applications.
• Developed SQL*Loader scripts to load data from various forms of flat files into staging tables in Oracle database using Shell scripts.
• Created Scripting using perl.
• Utilized Partitions to fine-tune SQL data retrieval and to load the data.
• Used Toad as an advanced SQL - PL/SQL editor.
• Built and tested PL/SQL Packages, Procedures, Triggers, and Functions.
• Creating and editing database tables, views, indexes, constraints, and users.
• Developed packages for processing data in the staging tables according to the Clients requirements
• Writing UNIX Shell Scripts to run automated DBA process, scheduling batch jobs and Oracle processes
• Documented changes and enhancements in code

Environment: Oracle 10g/9i, SQL, PL/SQL, SQL*Loader, Forms9i, Reports9i, TOAD, UNIX.

Confidential

Oracle Developer

Responsibilities:

• Worked on complete SDLC (System Development Life Cycle) including system analysis, high level design, detailed design, coding and testing.
• Created various SQL and PL/SQL scripts for verification of the required functionality.
• Created Stored Procedures, functions, Data base triggers, Packages, cursors and SQL Scripts based on business requirements.
• Developed Triggers and shell Scripts to load the staging tables.
• Creation of database objects like Tables, Views, Procedures using Oracle tools like SQL*Plus and SQL Developer.
• Modified existing codes, PL/SQL Packages to perform certain specialized functions and enhancements on Oracle Application.
• Created number of database Triggers according to business rules using PL/SQL.
• Involved in Index Monitoring for identifying the Unused Indexes.
• PL/SQL Collections were extensively used for high performance of stored procedures.
• Developed Shell and PL/SQL scripting for regular maintenance and production support to load the data in regular intervals.
• Creating Indexes, passing hints, analyzing the table statistics and Table partitioning to improve the Query performance.
• Involved in Bulk loading of data from non-Oracle data sources using SQL * Loader.
• Worked with Indexes to avoid full table scans on large tables for the fast retrieval of data.

Environment: Oracle 9i, SQL, PLSQL, SQL*Loader, Perl, Bourne Shell script, TOAD, Oracle Forms 9i, Reports9i.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Involved in creating tables and data transfer from various tables, coding using PL/SQLPackages, Stored Procedures and Triggers.
• Worked with DBA in creating and managing Tables, Indexes and Privileges.
• Developed back end interfaces using PL/SQLStored Procedures, Functions, Packages, Collections, Object types and Triggers.
• Developed screens and reports using Oracle Forms/Reports 6i/9i and PL/SQL.
• Utilized SQL*Loader to load flat files database tables.
• Utilized SQL Developer tool in developing all back end database interfaces.
• Extensively performed code reviews.
• Developed user documentation for all the application modules.
• Performance tuned Stored Procedures and long running queries by looking at query plans.

Environment: Oracle 8i, Forms 6i, Reports 6i, SQL, PL/SQL, Perl, SQL*Loader, SQL Developer, TOAD, Windows 2000