SUMMARY

• 6+ years of experience diversified experience as ORACLE PL/SQL DEVELOPER.
• Strong experience in systems Analysis, design and development of complex software systems in Finance, Health, Manufacturing and Educational sectors. Expertise in Oracle 10g/11g, 9i, 8i databases, cluster databases, SQL - Server, PL/SQL, UNIX Shell Scripting, OEM Oracle Enterprise Manager/10g/11gGrid Controller.
• 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.
• Extensively worked on Backend Programming using PL/SQL, Stored Procedures, Functions, Packages, Database triggers for Oracle 9i/8i and also SQL queries/reports and scripts.
• 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.
• Expertisein 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).
• Extensive exposure to concepts of Data warehouse like Design, Data Modeling, OLTP, ETL and Reporting.
• Experience in HTML, XML, Java Script, VB Script.
• Knowledge regarding database components like 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.
• 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.
• Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings, and sessions. Extensively worked on Data Extraction, Transformation, and Loading with RDBMS, Flat files.
• 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, 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*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 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.
• 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, PA

Oracle PL/SQL Developer

Responsibilities:

• Involved in developing warehouse, including requirements gathering, requirements definition, perations 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.
• Customized the login page and dashboards using style sheets and XML files.
• 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, 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, TKPROF, Indexing and Hints.
• Created indexes to improve performance and developed test cases for user acceptance testing and unit testing.

Environment: Oracle 10g, Informatica, 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 9i 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 Sample Management 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 advance PL/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 9i, 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 Multi org setup.
• Design, development, testing and implementation of a custom billing System and order entry system. Implemented using Oracle 9i and Forms 6i.
• 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 9iForms 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.