SUMMARY:

• Dynamic, Result - oriented professional with over 7+ years’ experience in Oracle Database with proven success record in working as Oracle PL/SQL developer.
• Expertise in working with Oracle Versions such as Oracle 11g, Oracle 10g and Oracle 9i.
• Expertise in working complete System Development Life Cycle (SDLC) such as analysis, design, development, testing, implementation and support with exposure in database.
• Extensive knowledge of Relational Database Management System (RDBMS) Concepts.
• Significant experience in Financial, Purchasing, Inventory Control and Manufacturing applications.
• Extensive work experience in writing and implementing database objects like Tables, Views, Indexes, Sequences, Synonyms, Stored Procedures, Functions, Exceptions, Triggers and Packages.
• Efficient in Creating and Using Cursors and Ref Cursors in processing of data.
• Experience in creating different kinds of Partitions on large tables and creating indexes in order to improve performance.
• Experience in Query optimization/Performance tuning using Explain Plan command, SQL Trace, TKPROF
• Used Collections and Bulk Techniques to improve performance.
• Effectively worked on Oracle provided packages DBMS OUTPUT, DBMS JOBS, DBMS SCHEDULER, DBMS SQL and UTL FILE.
• Handled exception in PL/SQL using Pragma Exception init, Raise Application Error and error trapping functions and knowledge in managing exception conditions by using the exception handling features of PL/SQL in order to make the programs robust
• Worked on Oracle utilities SQL*Loader, export/import and data pump, dblink to load data from another database and text file to oracle database
• Performed Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses and Data Marts using Power Center and SQL*Loader for Flat files.
• Expertise in conforming SQL and PL/SQL coding standards as per business rules.
• Experienced to translate reporting and analytical needs into technical solutions.
• Experience working with test data creation, analysis and production support.
• Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies.

TECHNICAL SKILLS:

Databases: Oracle 11g, Oracle 10g, Oracle 9i,MS-Access

Languages: SQL, PL/SQL

Operating Systems: Windows, UNIX

Database Utilities: SQL*Loader, data pump IMPDP/EXPDP, IMP, EXP, External tables, TKPROF

Environment: UNIX (AIX 6.1, Sun Solaris 5.8,5.9) Windows 98/2000/2003/XP, MSDOS

Tools: TOAD 8.5/8.6/9, SQL*Plus, SQL Developer, PL/SQL Developer, Putty, SQL* Loader, Citrix.

Office Tool: MS Office

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Oracle Developer

Responsibilities

• Worked with the production support team in resolving tickets.
• Created Procedures, Triggers, and Cursors in order to meet project requirements.
• Used Package which houses all the functions and stored procedures to maintain and execute the data and extract calculated values and store them.
• Loaded data into the tables using the stored procedures.
• Enforced constraints on the tables to ensure data validations.
• Used Explain Plan for the performance tuning of PL/SQL blocks.
• Implemented Materialized view as part of improving the performance of the application.
• Extensively used Bind Variables to improve query performance.
• Used %TYPE and %ROWTYPE for anchoring the variables to the database data types.
• SQL, PL-SQL code tuning using hints, Explain Plan, SQL Trace, and TKPROF.
• Extensively used Case and Decode functions.
• Prepared documentation for Functional and Technical design specifications.
• Extensively used character-manipulation function.
• Coordinated with the offshore support team in resolving critical issues.
• Used PL/SQL table to avoid mutating problem in database trigger.
• Extensive use to data dictionary tables to manage schema objects.
• Worked on tuning the SQL queries and stored procedures.
• Prepared status reports and attended status meetings to understand the resource utilization and assignments.

Environment: Oracle 10g, SQL, TOAD 9.5, PL/SQL, Shell Script, Export, Import, Windows 2007.

Confidential, MA

Oracle developer

Responsibilities:

• Developed and maintained PL SQL packages, procedures and functions to support the reports by retrieving the data from for the application.
• Extensively involved in writing SQL queries (Sub queries and Join conditions), co-related sub queries, in-line views and PL/SQL programming.
• Extensively used the advanced features of PL/SQL like collections, nested table and dynamic SQL.
• Work with cursor and ref cursor in PL/SQL scripts. Used ref cursor in functions to write the record set of cursor.
• Used Public Synonyms, read only User Accounts and Database Links to remote database.
• SQL, PL-SQL code tuning using hints, Explain Plan, SQL Trace, and TKPROF.
• Defining requirements by interacting with business group, application development group.
• Creating job flow diagrams, data flow diagrams, ER-Diagrams and process specifications as part of design.
• Developed Code Units, testing, debugging and implemented business rules using SQL, PLSQL (functions, procedures, packages, triggers), SQL*Loader, Unix shell scripts
• Application tuning, Query tuning using Explain plan, SQL tuning sets, BULK Collect, BULK Load.
• Analyzed and designed ETL, batch and online loading processes. Used Informatica to load data into data marts from source table.
• Review and approve all application changes for all production migrations
• Co-ordinate with Production control for all production migrations.
• Tuned many objects by implementing Oracle partitioning technique, Materialized views, BULK load, BULK collect features
• Tune long running PL/SQL and SQL queries stored procedures
• Automate FTP, ETL and SQL loader batch processes
• 24 X 7 Production support for new and existing batches.

Environment: oracle 10g/11g, UNIX, Putty, relational clear case, quest toad 9.6, SQL loader, Import- Export utilities.

Confidential, Raleigh, NC

Oracle Developer

Responsibilities:

• Defining requirements by interacting with business group, application development group.
• Creating job flow diagrams, data flow diagrams, ER-Diagrams and process specifications as part of design.
• Developed and debugged SQL, PL/SQL scripts including Packages, Procedures and Functions & Triggers in ORACLE 11g environment to perform various tasks.
• SQL, PL-SQL code tuning using hints, Explain Plan, SQL Trace, and TKPROF.
• Developed packages to move large amount of data to report database using partition exchange, data loading using oracle SQL Loader scripts to load data and also loaded data from a single flat file to multiple tables.
• used the advanced features of PL/SQL like Varrays, Records, Nested Tables, Bulk collect and Dynamic SQL
• Reviewed and modified the programs to ensure technical accuracy & reliability of programs.
• Reviewed existing systems to determine compatibility with projected or identified client needs, selecting appropriate systems, ensuring forward compatibility of existing systems.
• Created Batch Job Interfaces for Data Cleaning, processing and loading using shell scripts and SQL Loader.
• Created Batch Job Interfaces using Unix Shell Scripts and pl-sql for daily file transfers using FTP, SFTP, and Connect Direct.
• Performed unit testing of the applications developed, providing support for the System Integrated Testing.
• Took part in providing after production support to the application which includes training users, handling issues in production.
• Also participated in managing versions of software programs while developing solutions for rolling back or saving the changes to software programs
• As a part of developer team, had constant interaction with Accounting Department to understand the requirement and automate the manual process using Access as the front end, Oracle as the backend.

Environment: Oracle 11g, TOAD 10.6, Relational clear case 7.1, UNIX (Sun Solaris 5.8, 5.9), Windows 2010.

Confidential, Phoenix, AZ

Oracle PL/SQL developer

Responsibilities:

• Analyzed the Business requirements of the project by studying the interface Control document.
• Worked with different types of sub queries (Inline, correlated) and used loops to suit the business logic.
• Creation of database objects like Tables, Views, Materialized views, Procedures, Packages using Oracle tools like PL/SQL Developer, SQL* Plus, TOAD.
• Created database links to retrieve data from multiple servers.
• Written a number of Cursors to select various types of records.
• Create and run Batch files on regular basis.
• Created and Scheduled Jobs from time to time.
• Created Records, Tables, Objects, Collections (Nested Tables and Varrays).
• Involved in error handling using exceptions.
• Created number of database Triggers according to business rules using PL/SQL.
• Participated in Performance Tuning the SQL queries using Explain Plan.
• Expertise in development and design of ETL methodologies for supporting data transformations and processing, in a corporate wide ETL environment using Informatica Power Center/ Power Mart 7.x.
• Created the source and target definitions in Informatica PowerCenter Designer.
• Involved in code reviews of other team members.

Environment: oracle 9i/10g, windows professional, HP UNIX 11i, TOAD, SVN, data pump, SQL loader, MS-office 2007.

Confidential, NY

Junior Oracle Developer

Responsibilities:

• Used SQL * Loader for loading data from flat files into the database tables.
• Enforced database integrity using primary keys and foreign keys.
• Created PL/SQL functions to facilitate business functions and calculations.
• Involved in coding and testing various Packages, Procedures and Functions.
• Responsible to maintain the dependencies of all Procedures, Function, Packages, Views and Triggers.
• Implemented complex business rules with the use of integrity constraints and
• Handled errors using Exceptions like DUP VAL ON INDEX, INVALID NUMBER, and CASE NOT FOUND.
• Developed Packages to validate raw data from Flat Files and insert into tables.
• Tuned and Optimized the SQL statements using Explain Plan and SQL trace utilities.
• Involved in documentation of various database objects like packages, procedures and functions.

Environments: Oracle 8i, SQL, PL/SQL, SQL * Loader

Confidential

Junior Oracle Developer

Responsibilities:

• Designing module wise Oracle 9i database structure and its implementation on the client server.
• Extensively used Explain Plan, TKPROF utilities for SQL query optimization.
• Used PL/SQL table to avoid mutating problem in database trigger.
• Using the Crontab in UNIX and Scheduler in windows for Automatic Tasks (Analyzing tables, loading into Tables, Imp/Exp).
• Develop tables, views, stored procedures, triggers, indexes, rules, defaults, and user-defined data types.
• Worked on tuning the SQL queries and stored procedures.
• Used various forms of control structures including IF-THEN-ELSE, FOR loops, WHILE loops while developing procedures.
• Used EXPORT/IMPORT to do table level and full database de-fragmentation.
• Developed packages, procedure and functions for complex Reports. Utilizing Built in Oracle Packages like (UTL FILE, DBMS OUTPUT) for better debugging.
• Worked on User-defined and System defined exceptions to handle different types of Errors like NO DATA FOUND, TOO MANY ROWS.
• Developed PL /SQL code for updating payment terms.
• Developed SQL * loader scripts to load data into the database tables.
• Created database links to retrieve data from multiple servers.
• Created public synonyms on the database links for easy reuse.
• Developed invoice-printing reports for single and consolidated invoices
• Modified existing codes PL/SQL packages to perform Certain Specialized functions and enhancements.

Environment: oracle 9i, SQL developer, TOAD 8.6, relational clear case, SQL*Loader, windows 2007, SQL, PLSQL.