EXPERIENCE SUMMARY

• Oracle Developer with over 7 years of IT experience in Development, Testing, and Deployment of PL/SQL, Forms, Reports, and Workflows.
• Knowledge of Relational Database Management System (RDBMS).
• Extensive experience in writing PL/SQL Packages, Functions, Procedures & Triggers to implement the business logic.
• Good experience and understanding of Software Development Life Cycle (SDLC) such as analysis, design, development, testing, implementation and support with exposure in database.
• Used supplied packages to extend the functionality of PL/SQL programs such as DBMS SCHEDULER to schedule jobs, UTL FILE to read and write from database.
• Extensive knowledge of SQL*Loader.
• Strong working experience in Data Analysis, Modeling, Logical and Physical Database Design.
• Experience in creating different kinds of Partitions on tables and Indexes for managing large tables.
• Proficient in ETL Processes using Oracle PL/SQL, Unix Scripts and SQL*Loader for data migration to Enterprise Data Warehouse with large data volume.
• Developed UNIX Shell Scripts to run various utilities & wrote UNIX Cron jobs for the scheduling batch processes.
• Worked on Database links, Materialized Views, Autonomous Transactions.
• Analyzed tables and indexes for Cost Based Optimization (CBO) to work efficiently.
• Good knowledge of tuning SQL, PL/SQL queries using Hints, Explain Plan, SQL Trace, TKPROF.
• Extensive experience in writing Static & Dynamic (REF) Cursors, Dynamic SQL, Records, PL/SQL Tables.
• Experience in working with high transacted OLTP systems.
• Worked on operators in SQL like Union, Union all, Intersect and Minus.
• Worked with different types of Sub Queries (Inline, Correlated) and used Loops to enhance performance of the SQL queries.
• Experience with User - defined and System defined exceptions to handle different types of Errors like NO DATA FOUND, TOO MANY ROWS, and PRAGMA EXCEPTION INIT.
• Strong work experience with tools like Toad, SQL Navigator, SQL Developer, SQL*PLUS.
• Worked closely with the technical teams and DBA’s for issues related to Code Changes, Data Fixes, and Testing.
• Excellent experience with Performance Tuning, Normalization and Denormalization.
• Ability to understand Functional specifications, Business requirements and technical Design documents.
• Excellent team player with the ability to work independently and interact with people at all levels.
• Excellent communication and interpersonal skills.

TECHNICAL SKILLS:

Languages: PL/SQL, SQL, Shell Programming, C, C++.

Databases: Oracle 11g, 10g, 9i, 8i.

Oracle Tools: TOAD, SQL Developer, PL/SQL Developer, SQL Navigator, SQL*Plus, Oracle Forms 10g/6i, Oracle Reports 10g/6i, Discoverer.

ETL Tools: Operating Systems

Informatica Power Center 8.6.X.: Unix/Linux RHEL 5, Sun Solaris 2.x/7/8, HP-UX 10/11i, Windows XP/ NT 4.0/ 2000.

PROFESSIONAL SUMMARY:

Confidential, Virginia

Oracle Developer

Responsibilities:

• Wrote and modified Oracle PL/SQL, SQL statements, Procedures and Functions that are called in the Java Scripts, Jsp and EJBs.
• Created Stored Program Units like Packages, Functions, and Procedures for implementing complex database intensive business rules.
• Used features like Bulk Collect to process large amount of data in data base.
• Improving SQL and PL/SQL flexibility, usability, and performance, using dynamic SQL.
• Created Tables, Indexes, Views, Triggers, Sequences, and Synonyms.
• Developed Unix Shell Scripts to automate backend jobs, loading data into the database using SQL* Loader.
• Involved in analysis, design, coding and testing.
• Built and maintained SQL Scripts, Indexes, Reports and queries for data analysis and extraction.
• Involved in creating Database Design (Physical and logical) as per the business requirement.
• Gathered Statistics and Analyzed Tables and Indexes for Performance tuning.
• Extracted data from Flat files using SQL*Loader.
• Generated SQL and PL/SQL Scripts to install create and drop database objects including: tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
• Executing and maintaining the data warehouse extract transform load (ETL) process
• Made use of performance tuning utilities like explain plan, SQL Trace and Dbms Profiler to reduce the run time of complicated queries on Oracle 10g.
• Wrote complex SQL queries using Joins, Sub Queries and Inline Views to retrieve data from the database. Created Partitions on the tables to improve the performance.
• Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data.
• Quickly learned a wide range of technology skills and business knowledge required for my projects.
• Interacted with client to gather the requirements and implement the same in the project.

Environment: Oracle 11g, Oracle Enterprise Manager, SQL*Loader, SQL*Plus, PL/SQL Developer.

Confidential, Dallas, TX

Oracle Developer

Responsibilities:

• Created Procedures, Functions, Packages, Triggers and also updated the existing codes based on the requirements.
• Monitoring existing SQL Code and Performance Tuning and monitoring if necessary.
• Extensively involved in new systems development with Oracle 10g.
• Supported direct mail campaign strategies. Provided segmented data to end-users.
• Interact with business analysts to develop modeling techniques and re-structuring strategies.
• Involved in Unit Testing of each module.
• Created Forms and Reports using Forms 10g and Reports 10g respectively.
• Designed the Entity-Relationship model and normalized the database.
• Documentation of all modules for user level and system level maintenance.
• Designed and developed a custom database Tables, Views, Functions, Procedures and Packages.
• Read data from flat files to oracle tables using SQL*Loader.
• Extraction, Transformation and Load was performed using Informatica Power Center to build the data warehouse.
• Extensively used the Enterprise Resource Planning modules (ERP).
• Involved in large and complex data conversion and data modeling project from the existing system to the new system which did help End-Users.
• Loaded data into warehouse using PL/SQL Scripts, ETL tools, SQL*Loader.
• Used high system securities such as unique passwords, vpn etc.
• Measuring and reporting response rates using Excel, PL/SQL scripts.
• Involved in the production support and solved the tickets that are raised by the end users.
• Developed Unix Shell Scripts to automate repetitive database processes.
• Written add-in and macros for Business Objects reports.

Environment: Oracle 10g, Forms 10g, Reports 10g, Informatica 7.1, UNIX, TOAD, SQL*PLUS, SQL Developer, SQL*Loader, Erwin, Business Objects.

Confidential, Chicago, IL

Oracle Developer

Responsibilities:

• Extensively used high level backend PL/SQL programming involving different databases.
• Involved in improving the existing Procedures, Functions, Packages, Triggers and also updating the existing ones based on the change requests.
• Involved in the analysis, design, flow, archiving of data and databases and also with their relationships.
• Also have experience in end to end of mapping from different databases.
• Developed new Forms which are used to extract data from different systems and criteria.
• Performed unit testing and also performance testing for data extraction, data conversions.
• Prepared Technical Specifications Document for the procedure which is used to update the purchase order information from one database to another database.
• Utilized tools like SQL Developer, SQL Navigator during development of the application.
• Involved in direct discussion with the End-Users to study the requirements and helped in the development of functional specifications to meet their requirements
• Loaded data into tables using PL/SQL Scripts, SQL*Loader.
• Fine tuned SQL Queries using explain plan, hints for maximum efficiency and performance.
• Involved in the solving the tickets that are raised by the end users.
• Written Cron Shell Scripts and Perl Scripting for automatic execution of the stored procedures
• Updating the existing Reports and Forms with additional functional requirements. These reports used to gather the net sales units and dollar amount information for all the stores in comparison with the previous year.
• Automated the process through the cron job scheduling.

Environment: Oracle 9i, UNIX, SQL*Plus, SQL Loader, SQL Developer, SQL Navigator.

Confidential

Oracle Developer

Responsibilities:

• Worked extensively in Developing, Deploying, and Testing of Oracle Forms 6i and Oracle Reports 6i using Oracle 8i.
• Involved in gathering user requirements.
• The project involved detailed design using E-R Diagrams, Data Flow Diagrams, Data Dictionary, and System flow Charts.
• Wrote PL/SQL Packages consisting of Procedures and Functions.
• Created Views, Triggers, Sequences.
• Involved in the Design of User Interfaces
• Created Procedures, Packages used in Oracle Forms.
• Developed the server pages with the Visual Basic and later updated to ASP.
• Involved in tuning database and SQL statements and schemas for optimal performance.
• Generated the Reports.
• Involved in direct discussion with the End-Users to study the system requirement and develop Functional and Technical specifications to meet their requirements.

Environment: Oracle 8i, Forms 6i, Reports 6i, VB, ASP, C/C++, Java, SQL, PL/SQL, SQL*PLUS, Windows 2000