SUMMARY:

• 7 years of experience in application development using SQL, PL/SQL and Oracle Forms and Reports.
• Involved in gathering requirements, writing technical design documents and developing unit test documents.
• Involved in RDBMS Design, Data modeling, Data normalization.
• Involved in Designing, Creating and Maintaining Oracle Database.
• Experience in creating and maintaining database objects like Tables, Views, Synonyms, Indexes, Stored Procedures and Packages.
• Involved in writing Stored Procedures, Functions, Packages, Database Triggers, Cursors Collections, Records, Exceptional Handling, Constraints using PL/SQL.
• Experience in writing and tuning of SQL Statements, Joins, Sub queries, Correlated Sub queries.
• Experience in performance tuning of SQL statements and PL/SQL using Explain Plan, SQL Trace, Auto Trace and DBMS Profiler.
• Used bulk binding techniques like bulk collect and for all to improve performance.
• Experience in Designing and Developing of forms and reports.
• Experience in using Toad, SQL Navigator, DB Artsian, SQL*Loader.
• Experience in coding ETL Procedures using PL/SQL and SQL *Loader.
• Involved in ETL processing using Informatica power center tool.
• Good Knowledge in Data Warehouse, Star Schema and Snowflake Schema.
• Experience in Data Modeling using Erwin.
• Highly skilled, self - motivated, outstanding, excellent communication and interpersonal skills with result oriented dedication towards goals.

TECHNICAL SKILLS:

Database: Oracle 11g/10g/9i, SQL Server 6.5/7/2000/2005/2008 ,Sybase and MS Access97/2000

Languages: C, SQL, PL/SQL, HTML, T- SQL, SQR, C

BI and ETL: Business objects 5/6.5/XI R2/XI R3, Informatica Power Center 6.0

Data Modeling: Erwin

Front End Tools: Oracle Forms and Reports

Operating System: Windows95/98/NT/2000/XP/Vista, Unix and DOS

Tools: SQL * PLUS, TOAD, SQL Navigator, DB Artisan, SQL *Loader

Scripting Tool: Unix Confidential

PROFESSIONAL EXPERIENCE:

Confidential, IOWA

Oracle PL/SQL Developer

Responsibilities:

• Gathered and analyzed business requirements from end users.
• Worked with applications specialists to understand requirements.
• Developed logical data models and transformed them to physical data model and created schemas using Erwin.
• Tables, Views, Sequences, Triggers are created as per requirements.
• Involved in developing and testing functions, procedures, packages and cursors.
• Designed and developed procedures to handle errors and exceptions at both database and application using PL/SQL.
• Written stored procedures to perform validations on data and to move data from staging tables to base tables.
• Involved in performance tuning of queries using SQL and PL/SQL.
• Developed database triggers to enforce security.
• Used exception handling for data validation.
• Used partitioning and sub partitioning of tables to improve performance.
• Used indexes part of tuning queries.
• Used bulk collect feature to improve performance.
• Involved in code review, test procedure and test plan.
• Used Unix Shell Scripts to automate jobs.
• Used shell scripts to automate data loading from flat files into oracle database.
• Used toad to extract data and test the data in database.
• Used SQL * Loader to load various files into the database.
• Involved in unit test and Integration test.
• Developed custom Forms and Reports as per Client requirement and making them web enabled using Oracle Reports builder and Oracle Forms builder respectively.
• Developed Master Detail, Detail Reports using tabular and Group above reports.
• Migrated the reports according to requirement using oracle reports 10g.
• Modified the existing database to meet new business requirements.
• Interacted with production support team regarding production issues.
• Responsible for writing the technical documents and maintaining documentation.

Environment: Oracle 11g,SQL *Plus, PL/SQL, Toad, Unix, Erwin, SQL * Loader, Windows XP.

Confidential, IL

Oracle PL/SQL Developer

Responsibilities:

• Involved in requirements gathering, high-level design and detail design.
• Defined and reviewed coding standards.
• Involved in code review and preparing for unit test case.
• Created and modified tables, views and triggers.
• Involved in design, development and modification of PL/SQL Procedures, Functions and Packages to implement business rules into application.
• Written procedures and functions using Dynamic SQL.
• Written complex queries using joins, sub queries and correlated sub queries.
• Used check constraints for data validation.
• Used SQL *Loader to load data into the database
• Loading of data from flat files into staging tables using sql loader.
• Involved in database tuning and improved application performance using explain plan, TKPROF and SQL Trace.
• Developed various forms for application involving modules to segregate data.
• Responsible for writing and modifying shell scripts in unix.
• Created shell scripts to pull data from database and load back into base tables.
• Worked with data warehouse and data mart for reporting and analysis.
• Created tabular, master-detail and matrix reports.
• Created a user-defined template for reports.
• Responsible for creating technical design document.
• Designed and developed Informatica mappings to data from source systems.
• Involved in design of Extraction, Transformation and loading of data into data warehouse from oracle 11g database.

Environment: Oracle 10g/11g, SQL *PLUS, PL/SQL, ER-WIN, Toad, Unix, SQL * Loader, Informatica 6.0,Windows XP, Oracle Forms 10g,Reports 10g.

Confidential, Chicago

Oracle PL/SQL Developer

Responsibilities:

• Interacting with business analyst to understand and document the requirements and translate these to Technical Specifications.
• Involved in logical modeling and physical modeling of application.
• Created Database objects like tables, views, indexes, synonyms, sequences.
• Developed Stored procedures, Functions, Packages and SQL scripts using PL/SQL.
• Developed SQL Scripts, Packages, Procedures for business rules check to implement business rules.
• Loaded Data into database tables using SQL *Loader from text and excel files.
• Data loaded from legacy systems using PL/SQL, SQL*Loader
• Performed SQL and PL/SQL tuning and application tuning using various tools like
• TKPROF, AUTOTRACE and DBMS SQLTUNE.
• Worked with bulk collect to implement the performance of multi row queries.
• Performed data partitioning.
• Developed SQL Scripts for Referential integrity check, which checks validity of incoming data with master tables in database.
• Developed complex SQL queries using various joins.
• Involved in development of Oracle Forms/Reports, New screen designs, modifications
• Upgraded to Forms 10g,Reports 10g,maintained and troubleshoot Oracle Forms and Reports.
• Designed and Developed forms and reports based on client requirement.
• Developed Shell Scripts and sql control files to load data through SQL Loader.
• Perform data conversion and data cleaning.
• Created group, tabular, form reports.

Environment: Oracle 10g/9i,SQL, PL/SQL, SQL *LOADER, ER-WIN, SQL Navigator, Unix

Confidential, AOL, VA

Oracle PL/SQL Developer

Responsibilities:

• Gathered and analyzed requirement from business users.
• Created database objects like tables, views, synonyms and sequences.
• Experience in developing oracle packages,views,triggers and collections.
• Edited procedures and functions for improved business requirements.
• Developed PL/SQL Programs for various modules to validate data while importing into oracle system.
• Created stored procedures and functions using PL/SQL.
• Designed and developed complex procedures to handle errors and exceptions at both application and database level using PL/SQL.
• Explain plan, TKPROF was used for checking the performance of queries.
• Involved in performance tuning of SQL queries to decrease execution time.
• Performed exception handling for data that did not confirm to the required format.
• Involved in implementing the data integrity validation checks through constraints and triggers.
• Modified and updated existing custom forms to adapt to new database schema.
• Developed interface screen for data entry and data validation using forms.
• Wrote complex shell scripts to automate data loading from flat files into oracle database.
• Using SQL*LOADER loads data from external files in to tables of oracle database.
• Moved data from external files in to the oracle database using SQL*loader
• Extracted the data from legacy system into production database using SQL * Loader.
• Used export and import utilities logical backups.
• Creation of technical and detailed level design documents.
• Supported development, test and production database
• Created test cases and technical design document.
• Wrote unix scripts to automate loading files into database using error handling and notification.
• Accessed Unix Server to obtain log files, which were further utilized for data analysis.

Environment: Oracle 9i, SQL, PL/SQL, SQL *Loader, SQL Navigator, DBArtisan, Unix, Business Objects 6.5/Xi R2, SQL SERVER 2005.