SUMMARY:

• Over 7 years of programming experience as an Oracle Developer/ PL/SQL Developer in Analysis, Design, Data Modeling (Logical and Physical), and Implementation of Business Applications using the Oracle Relational Database Management System.
• Experience in Application development using Oracle SQL, PL/SQL and Oracle Developer Forms and Reports.
• Experience with Software Development Life Cycle (SDLC) process, performing detailed analysis, collecting requirement, coding and unit testing, integration and system testing.
• Experience working in waterfall model and agile methodologies
• Strong Knowledge on oracle architecture and database design.
• Excellent conceptual knowledge of Oracle 9i/10g/11g PL/SQL.
• Proficient working experience with SQL, PL/SQL Stored Procedures, Functions, Packages, Database triggers and using the advanced features to optimize performance(Bulk binds, collections, Global Temporary Tables) and Developer 2000(Oracle Forms, Oracle Reports).
• Experience in Dynamic SQL, PL/SQL Collections and Exception handling.
• Extensive experience in developing UNIX Shell scripts, SQL and PL/SQL.
• Worked with various performance tuning techniques using tools provided by Oracle like EXPLAIN PLAN, SQL Trace, TKPROF, Oracle hints, DBMS PROFILER, DBMS STATS.
• Proficient in Oracle Tools and Utilities such as TOAD, SQL*Loader, PL/SQL Developer, SQL Developer, External tables and UTL FILE.
• Experience in Database design using Normalization and E/R Diagrams.
• Experience in designing Data Models (Logical and Physical) along with OLAP, ROLAP,MOLAP and HOLAP
• Expertise in using ERWIN Data Modeling Tool to design Relational Databases.
• Performed Extraction, Transformation, and loading (ETL) data from various sources into Data Warehouses.
• Good Knowledge in Star Schema Modeling and knowledge of Snowflake Dimensional modeling.
• Experience in development of applications using Oracle 10g/9i/8i, SQL, PLSQL
• Created various reports using oracle reports developer like matrix reports, matrix with group reports, and group above reports.
• Strong knowledge on OLAP components development.
• Strong interpersonal skills, ability to interact with people at all levels. Good communication and presentation skills.
• Experience with Client interaction, adherence to client specifications, system enhancements, understanding business data flow, data relations and production system support.

TECHNICAL SKILLS:

RDBMS: Oracle 11g/10g/9i

Languages: SQL, PL/SQL, Shell Scripting, Perl

Operating Systems: UNIX(AIX), Sun Solaris, Windows 2003, XP, 2007

Oracle Tools: SQL*Loader, TOAD, Forms Builder 10g/9i/6i, Reports Builder 10g/9i/6i

GUI: Developer/2000 Forms 10g/9i/6i, Reports 10g/9i/6i

Other tools: Sub Version (Microsoft), FileZilla, Putty

PROFESSIONAL EXPERIENCE:

Oracle Developer

Responsibilities:

• 24/7 Production support for all the database issues with integration of DBA’s during the data loading process.
• Worked with the Business analysts and the DBA for requirements gathering, business analysis, testing, metrics and project coordination.
• Involved in logical modeling and physical modeling of application.
• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• 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.
• Experience in designing data models with the help of ERWIN tool.
• Developed data model, SQL Queries, SQL Query tuning process and Schemas.
• Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database.
• Hands on experience with oracle Export and Import Utility tools to migrate data through different environments.
• Hands on experience with Unix Shell Scripting to set up data load process and ETL process with the help of some Perl scripts
• Experience in performance tuning to tune the queries using EXPLAIN PLAN and SQL Tuning Advisor
• Developed SQL scripts, packages and procedures for Business rules check to implement business rules.
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Data loaded from legacy systems (ETL Operations) using SQL*Loader.
• Developed custom Forms and Reports as per client requirements and making them web enabled using Oracle Reports builder 10g and Oracle Forms builder 10g respectively.
• Used Pragma Autonomous Transaction to avoid mutating problem in database trigger
• Developed Procedures for efficient error handling process by capturing errors into user managed tables.
• Worked with developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like TKPROF and AUTOTRACE.
• Used Toad for creating PL/SQL (trigger, sequence, stored procedure).

Confidential, Winston Salem

Oracle Developer

Responsibilities:

• Created various SQL and PL/SQL scripts for verification of the required functionality.
• Created Stored Procedures, functions, Database triggers, Packages, cursors and SQL Scripts based on business requirements.
• Developed SQL Loader and shell Scripts to load the staging tables.
• Worked on complete SDLC (System Development Life Cycle) 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 and SQL Developer.
• Modified existing codes, PL/SQL Packages to perform certain specialized functions and enhancements on Oracle Application.
• Extensively used PL/SQL Collections for high performance of stored procedures.
• Modified Shell and PL/SQL scripts for regular maintenance and production support to load the data in regular intervals.
• Creating Index’s, passing hints, analyzing the table statistics and Table partitioning.
• Applying constraints and writing triggers to apply the business rules.
• Involved in handling errors and transaction processing in the procedures.
• Oracle data loading into oracle database from intermediate files using SQL loader and UTL File.
• Involved in Bulk loading of data from non - Oracle data sources using SQL * Loader.
• Using SQL trace and TKPROF accurately assessed the efficiency of the SQL statements when application runs.
• Involved in performance tuning using Explain Plan, TKPROF utilities.
• Tuned PL/SQL packages with advances features like Bulk collect, For All, DBMS JOBS etc.
• Involved in analyzing Schema’s, Tables and Indexes as part of Optimization.
• Actively involved in System testing and deploying application.

Confidential, CA

Oracle Developer

Responsibilities:

• Gathered Business Requirements from the client and translated the business detail into technical design and specification
• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Involved in logical and physical modeling of application
• Responsible for writing PL/SQL Packages, Functions, Procedures, Collections and cursors.
• Created the Object Relational Database Tables with all the necessary Constraints and Referential Integrity using ERWIN Data modeler
• Designed and Developed Data Marts from the DWH for application users to configure their application.
• Developed back end interfaces using PL/SQL Packages, Stored Procedures, Collections and Triggers.
• Used Control Structures like IF, CASE, FOR, and WHILE Loops for standard PL/SQL programming.
• Developed crystal reports as per Business Requirements and scheduled the reports to run on SAP BO server.
• Involved in SQL and PL/SQL performance tuning using EXPLAIN PLAN, TKPROF and DBMS PROFILER.
• Handled errors using PL/SQL Exception Handling for the ease of debugging and displaying error messages.
• Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database.
• Involved in creating Index’s, passing hints, analyzing the table.
• Developed UI using bank customized IRIS Application and configured work flows for the UI, where SQL statements were used with the help of Sub Queries and Oracle Defined Functions
• Created new database objects like tables, Indexes, Views using SQL in Development and Production environment for Oracle 11g and was involved with the Performance tuning, Optimization of queries and standardization of the code.
• Created indexes for faster access of data.
• Participated in Debugging critical Production issues by working as a Team.
• Data loaded from legacy systems (ETL Operations) using PL/SQL and SQL*Loader
• Used UTL NOTIFY built in packages for the Purpose of the email Notifications
• Used Built in packages like UTL FILE to read the data from flat files and load them into their respective tables

Confidential, Grand Rapids

Oracle Developer

Responsibilities:

• Custom tables and new custom objects were designed as per business requirements.
• Created database triggers to validate complex integrity.
• PL/SQL Procedures, functions, cursors, triggers and packages were created using TOAD.
• Used Control Structures like IF, CASE, FOR, and WHILE Loops for standard PL/SQL programming.
• Created PL/SQL program units to include DML, DDL statements using Dynamic SQL.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes, Views using SQL in Development and Production environment for Oracle 10g and was involved with the Performance tuning, Optimization of queries and standardization of the code.
• Used Database trigger for making history of insertion, updating, deletion and all kind of Audit routines.
• Developed Stored Procedures to include in the existing Packages and used the same to set up scheduler Jobs
• Performed Extraction, Transformation, and loading (ETL) data from various sources into Data Warehouses.
• Developed PL/SQL Procedures and database triggers for the validation of input data and to implement business rules.
• Used exception handlers to handle exceptions like no data found, too many rows, dup val on index
• Created SQL*Loader control files for moving the data from flat files to staging area tables.
• Developed SQL scripts to create database objects like tables, views and sequences.
• Developed SQL and PL/ SQL scripts for migration of data between databases.
• Tune SQL statements using hints for maximum efficiency and performance, create and maintain/modify PL/SQL packages, complex database triggers and data migration scripts.
• Developed data model, SQL Queries, SQL Query tuning process and Schemas
• Involved in designing of required end user forms and reports using Oracle forms 10g & Reports 10g.
• Developed Master Detail, Detail reports using tabular and Group above reports.
• Worked with Sales force CRM tool Backend to load data from existing extracts to Sales Force Cloud
• Developed file mover and Archive process scripts using Perl
• Configured Data Loader for CLIQ process to load data into CRM tool
• Configured Mapping of the field to Match the User Interface

Confidential, Baltimore

Oracle Developer

Responsibilities:

• Worked closely with business users to develop BRD(Business Requirement Document), FSD(functional Requirement Document), TSD(Technical Requirement Document) for successful implementation of the project
• Responsible for writing PL/SQL Packages, Functions, Procedures, Collections and cursors.
• Developed Service Contract load and Supplier Interface program from Emptoris system into Oracle EBS service Contracts tables. Have used PL/SQL packages for data validations.
• Designed ER diagram using Erwin, to set the logical and physical relationships of database.
• Created different schemas and maintained schema objects.
• 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.
• Developed Procedures for efficient error handling process by capturing errors into user managed tables.
• Created SQL*plus reports as per client's various needs, and developed business objects.
• Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database.
• Developed SQL scripts, packages and procedures for Business rules check to implement business rules.
• Developed PL/SQL Procedures and database triggers for the validation of input data and to implement business rules.
• Created database objects like packages, procedures, and functions according to the client requirement.
• Data loaded from legacy systems (ETL Operations) using PL/SQL and SQL*Loader
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Involved in SQL and PL/SQL performance tuning using EXPLAIN PLAN, TKPROF and DBMS PROFILER.
• Handed errors using PL/SQL Exception Handling for the ease of debugging and displaying error messages.
• Developed Oracle Forms for form end user using oracle form builder 10g.
• Wrote SQL queries for business teams for reconciliation purpose.
• Developed shell Scripts to automate the Load process.
• Performed Unit and Integration Testing on Interface programs and all the reports developed to maintain consistency and efficiency to meet the user requirement.

Confidential

Database Developer

Responsibilities:

• Developed PL/SQL Packages to supply collections to Java
• Responsible for writing business logic of SC(Service Contract) using PL/SQL
• Created database triggers to enforce complex business rules.
• Developed database objects like Tables, Views, Indexes, synonyms and sequences.
• Experienced using FOR ALL and BULK COLLECT to load large volumes of data from table.
• Involved in importing flat files into Database and validated the data using PL/SQL procedures.
• Handled different errors using Exception handling.
• Loading data through SQL * Loader and UTL FILE.
• Identified, designed and developed oracle PL/SQL stored procedures, Packages, functions, database triggers.
• Created forms using Oracle forms 10g and 11g.
• Loaded data through SQL*Loader and UTL FILE.
• Involved in creation and updates of several SQL Packages and Procedures.
• Created weekly status reports using Business Objects from Remedy ticketing system.
• Responsible for raising Change requests and Change schedules for Database change management using Remedy Change Management Software
• Responsible for keeping all three environments PROD, UAT and DEV in sync for phase wise production releases and DB change management

Confidential

Jr. Oracle Developer

Responsibilities:

• Developed database objects like Tables, Views, Indexes, Synonyms and Sequences.
• Wrote stored procedures, functions, packages and triggers for modules like -products, catalogue, billing, shipping, rejected material, purchase orders and material receipts.
• Loaded traffic data logs into staging tables using SQL*Loader and shell scripts.
• Developed PL/SQL codes for Exception Handling and duplicate data maintenance.
• Used Triggers in Customizing Error conditions.
• Developed/modified PL/SQL code like stored procedures, packages, collections, bulk collections, etc for interfaces.
• Developed UNIX Shell Scripts and PL/SQL procedures to extract and load data for month-end batch processing.
• Developed PL/SQL code for updating payment terms.
• Created Forms, Pop-up Menus and maintained Master Detail relationship.
• Used various LOVs (List of Values) and record groups at various points in runtime.
• Designed and developed User Interfaces using Forms 6i, Reports 6i and coding modules in PL/SQL.
• Developed client side program units and shared them among multiple applications for processing business logic in the database.
• Tested all forms and PL/SQL code for logic correction.
• Performed code reviews.