SUMMARY:

• Expert in writing SQL, PL/SQL modules like functions, stored procedures, cursors (Implicit, Explicit, REF), packages, triggers, indexes, collections(Nested tables and Varrays) and materialized views.
• Strong experience in systems Analysis, design and development of complex software systems in Finance, Health, Manufacturing and al sectors.
• Proficient in Oracle tools and utilities such as TOAD, PL/SQL Developer, SQL Developer, SQL Navigator, SQL*Plus.
• Worked extensively on various technologies like Oracle 8i/9i, 10g/11g, PL/SQL, C/C++, and HTML.
• Experience in Design, Development, and Enhancement and Maintaining applications in Windows 9x/NT/2000/XP and UNIX environments.
• Developed Client/Server applications using front - end tools like Oracle Forms, Oracle Reports.
• Involved in designing numerous Oracle Forms and Reports by interacting directly with End Users and Business Analyst.
• Database triggers for Oracle 9i/8i and also SQL queries/reports and scripts.
• Extensive experience in Database query tuning, Performance tuning (Explain Plan and TKPROF utility) of Reports and troubleshooting Oracle Application issues on OLTP and DSS systems.
• Expertise in SQL and PL/SQL programming, developing complex code units, database triggers and using the latest features to optimize performance (Bulk Binds, Materialized views, Inline views, Global Temporary Tables).
• Experience in optimization of SQL statements using SQL Trace, TKPROF and Explain Plan.
• Experience in performance Tuning using various types of Hints, Partitioning and Indexes.
• Extensive exposure to concepts of Data warehouse like Design, Data Modeling, OLTP, ETL and Reporting.
• Knowledge regarding database components Parser, Transaction Manager, Lock and Resource Manager.
• Good Knowledge of Data integration and migration using SQL* Loader.
• Sound knowledge in Pearl Language.
• Experienced in requirement analysis, coding and testing various modules in a software development life cycle (SDLC).
• Interacted with Clients, Project Managers to gather the Business Requirements and developed the technical specification document.
• Assisted DBA in performing various DDL works like Creation of Schemas, tables, Indexes, Materialized Views, and Partitioning tables.
• Excellent experience in creating Test Cases, Test Plans, Technical Design Documents and Functional Design Documents.
• Excellent team player and proven track record working in various team sizes performing cross-functional roles.
• Worked on Production Support, attending production calls, troubleshooting the application and resolving bugs.
• Superior communication, presentation, analytical and problem solving skill. Work well with all levels of business.

TECHNICAL SKILLS:

Databases: Oracle 9i/10g/11g (RAC/OPS),SQL

Development Tools: TOAD, SQL Developer 3.0, OEM/EM 10g/11g, SQL*Plus, SQL* Loader, Oracle Forms and Reports 10g/11g/9i/6i, ETL, OLAP, OLTP, EXPORT/IMPORT, MS office 2007, 2010

Data Modeling: Dimensional Data Modeling, Star Join SchemaModeling, Snow Flake

Operating Systems: Windows NT/2000/XP, Sun Solaris, Linux, UNIX, HPUX

Database concepts: SQL, PL/SQL

System Management Tools: RMAN, ASM

Protocols: TCP/IP, HTTP

PROFESSIONAL EXPERIENCE:

Confidential, Denver, CO

Oracle PL/SQL Developer

Responsibilities:

• Created PL/SQL stored procedures, views, functions, packages, SQL Scripts using Rapid SQL and SQL Developer.
• Loaded database tables from Flat Files by running the batch jobs using SQL*Loader.
• Used Indexes for tuning the data and to improve the performance of the application.
• Good knowledge on Wrappers, Composite Data Types, Cursors and REF-Cursors.
• Developed Procedures for efficient error handling process by capturing errors into user managed tables.
• Involved in Unit Testing the finalized codes by creating test cases and generating the test data.
• Extensively used SQL Developer for all the database access, PL/SQL Development and SQL tuning.
• Involved in the Analysis of Facets System Requirement.
• Involved in SQL Query tuning process and Schemas.
• Worked on PL/SQL in migrating the data into Facets Application.
• Involved in the backend code for new processes to support Facets front-end systems.
• Worked on existing stored procedures, functions, tables and views to in corporate changes in Facets Database.
• Managed in activities like Modifying and Testing Unit Test Cases for checking the errors.

Environment: Oracle 11g, SQL, PL/SQL, Rapid SQL, Facets, TOAD, SQL Developer, SQL Server Management Studio, UNIX shell scripting.

Confidential, Nashville, TN

Oracle PL/SQL Developer

Responsibilities:

• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Loaded the data into database tables using SQL*loaderfrom 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 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 using PL/SQL and SQL*Loader.
• Developed Procedures for efficient error handling process by capturing errors into user managed tables.
• Involved in developing CRONTAB to schedule the information of cornentries.
• Worked with java 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 AUTOTRACE and DBMS SQLTUNE.
• Used Toad for creating PL/SQL (trigger, sequence, stored procedure).
• Designed and coded screens and reports in Oracle APEX (Application Express).
• Used UTI FILE packages for writing DBMS OUTPUT messages to file.

Confidential, Camp Hill, PA

Oracle PL/SQL Developer

Responsibilities:

• Involved in developing warehouse, including requirements gathering, requirements definition,
• Operations analysis, technical design and implementation.
• Used SQL*LOADER with the help of Control Files to load data from flat files into ORACLE staging tables.
• Designed ER diagrams and performed database normalization.
• Used Bulk Collect, Pl/SQL tables, varrays and other collection to improve the performance of the system.
• Deeply involved in writing ORACLE database objects like STORED PROCEDURES, FUNCTIONS, and PACKAGES using PL/SQL.
• Customized a number of financial reports like Invoice History Report, Invoice Aging Report, and Payment Register Report etc in AP using ORACLE Report Builder 9i.
• Worked with Discoverer 10g so users would have the ability to generate ad-hoc reports and also show the data in the form of Excel Files.
• Migrated old forms and reports from 6i to 9i and resolved issues during the process.
• Performed PL/SQL tuning to improve the performance with the help of SQL Trace, Explain Plan, Indexing and Hints.
• Created indexes to improve performance and developed test cases for user acceptance testing and unit testing.

Environment: Oracle 10g, Informatica 7.1, Report Builder 9i, Discoverer 10g, Designer 6i, PL/SQL, SQLSQL*PLUS, UNIX

Confidential, MO

Oracle PLSQL developer

Responsibilities:

• Involved in the analysis, data modeling, detailed system design, physical design, development and technical documentation.
• Developed screens using Forms 6i for various data entry forms and other business required forms.
• Enhanced CBRM (Chemistry Business Rules Management) and Registration module, which helps users in registering samples with their molecular structure.
• Developed DEAL (Data Exchange Application Layer) module, a brokering layer that helps in intermediating between core global application and local applications running in SampleManagement Centers.
• Developed PLSQL packages for DEAL layer to handle business requirements.
• Involved in Report development and tuning.
• Responsible for modifying the application and/or the change requests accurately to ensure system efficiency, integrity, productivity and maintainability.
• Used sqlldr to load the data from CSV files into the database.
• Created packages, procedures, functions and triggers to implement business logic using advancePL/SQL.
• Created views to resolve complex queries.
• Interacted with the client and knowing the requirement specifications and different types of reports.
• Troubleshoot day-to-day database issues and handled critical errors.
• Maintained detailed description of user needs, program functions and steps required to develop or modify PL/SQL package.
• Used ERWIN as the data-modeling tool to re-engineer the existing database, to define relationships, implement business rules as constraints.
• Created PL/SQL program units to include DML, DDL statements using Dynamic SQL, PL/SQL procedures, functions and cursors created to process the data.

Environment: Oracle Forms Developer 6i, Discoverer, Oracle 8i, SQL, PL/SQL, HTML, Windows XP, SQL Navigator, MS EXCEL

Confidential, Houston, TX

Oracle Developer

Responsibilities:

• Developed Stored Procedures, Function and Packages for the Financial System.
• Setup, tested and implemented new descriptive flex fields in Oracle Financials.
• Used database triggers and PL/SQL for development of system.
• Extensively used PL/SQL to write Cursors for acquiring information to be used in calculations written in stored procedures.
• Created Korne Shell scripts which act as a wrapper for various tasks like - for executing the SQL*Loader command lines, for refreshing the materialized views and for updating the Fact and the Dimension tables.
• Worked on various projects involving gap and map analysis, design and customization as per the business rules and worked on custom applications development involving.
• Load the data into Oracle 9i, Oracle High -Performance, scalable database. Change of Accounts, Currencies, Defining calendars, setup books and Multiorg setup.
• Design, development, testing and implementation of a custom billing System and order entry system. Implemented using Oracle 9i and Forms 6i.
• Conducted requirement assessments and made recommendations on the content and design of client/server applications.
• Developed forms to view payments, accept payments, view financial transactions, maintain and view cash assignments, view refunds, credit accounts, and transfer debit balances.
• Involved in Tuning Database & Application performance using Explain Plan, tkprof, resolving lock contentions, identifying & killing sessions.

Environment: Oracle Applications 11i, Oracle Database 9i, SQL, PL/SQL, UNIX, SQL* Plus, Reports 6iForms 6i/4.5, SQL* LOADER, TOAD, Discoverer 6i

Confidential

Junior SQL Developer

Responsibilities:

• Writing complex SQL for the Back End Development requirements.
• Complex SQL scripting using advanced functions.
• Core knowledge and experience on SQL for SQL* Reports.
• Top development skills include using Oracle PL/SQL to write Stored Procedures, Packages, andTriggers.
• Usage of various Built-In PL/SQL packages based on requirements.
• Good knowledge on Wrappers, Composite Data Types, Cursors and REF-Cursors.
• Writing complicated Oracle Forms and creation of customized Oracle Reports.
• Prepared Test Cases based on Test Plan for Unit Testing, System Testing, End-to-End Testing and UAT support Testing.
• Used Quality Center to report bugs.

Environment: UNIX, Shell Scripting, Oracle 8i, PL/SQL, Oracle Reports, Windows XP.