SUMMARY

• Over 7 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS)
• 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.
• Extensive use of Crontab and Cronjobs in UNIX environment for scheduling routine tasks and other UNIX commands as per need. Knowledge of UNIX shells scripting
• 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.
• 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, CVS & SVN and Clear Case for Version Control

Office Tool: MS Office

PROFESSIONAL EXPERIENCE

Confidential, Jersey City, NJ

Oracle Developer

Responsibilities:

• Involved into updating procedures, functions, triggers, and packages based on the change request.
• Implemented Complex business Logic as per the client requirement.
• Writing triggers to apply the business rules. Involved in handling errors and transaction processing in the procedures.
• Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables.
• Creation of database objects like tables, views, synonyms, materialized views, procedures, packages using oracle tools like SQL* plus.
• Extensively used for all and bulk collect to fetch large volumes of data from table.
• Developed Reports to extract the monthly sales information.
• Performed performance tuning using the DBMS PROFILER package, this checks the run time behavior.
• Involved in debugging and Tuning the PL/SQL code, tuning queries, optimization for the Oracle database.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like TKPROF, AUTOTRACE and DBMS SQLTUNE.
• Involved in testing all forms, PL/SQL code for logic correction. Performed Unit testing on queries and reports.
• Developed User Interfaces (forms 10g).
• Having good knowledge on UNIX operating system.

Environment: Oracle 11g, PL/SQL, TOAD, Forms10g, Reports10g, MS Windows XP/ 7

Confidential, Reading, 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 Cron 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.
• Created test plans and test data using UT/PLSQL testing Frame work.
• 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 Ad-hoc queries to generate data for business analysis.
• 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.
• Automated tasks like Analyze Tables, Collapse Partition Monthly, pulling data using PL/SQL packages and Autosys.
• 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

PL/SQL Developer

Responsibilities:

• Developing packages, procedures, functions, and triggers for the application.
• Using UNIX environment for performing the testing.
• Performing the tests on the newly coded procedures and documenting the same.
• Writing technical documents using the functional specifications.
• Writing PL/SQLcode using the technical and functional specifications.
• Creating Oracle objects like tables, types, packages, procedures and functions.
• Automated data fetch using UNIX shell script.
• Optimized the queries to improve the performance of the application.

Environment: Oracle 10g, SQL, PL/SQL, UNIX shell scripting.

Confidential

Database Developer

Responsibilities:

• Involved in software requirement specification and technical design.
• Performed Normalization and Logical Database Design.
• Developed data model, SQL Queries, SQL Query tuning process and Schemas.
• Created Database links and accessing the data through SQL statements.
• Responsible for writing and modification of PL/SQL stored procedures, functions, packages and Database triggers.
• Responsible to tune ETL mappings to optimize load and query Performance.
• Created new Tables, Indexes, Synonyms and Sequences needed as per new requirements.
• Created materialized views, Inline Views & normal views where business requirements needed.
• Created database, table spaces, user schemas, and assisted in database administration.
• Developed Stored Procedures, Database Triggers, Functions and Packages to manipulate the database and to apply the business logic according to the user's specifications.
• PerformedSQLand PL/SQLTuning and application tuning using various tools like EXPLAIN PLAN,SQL*TRACE, AUTOTRACE.
• Worked on Database tuning and performance monitoring.
• Partitioned large Tables using range partition technique.

Environment: oracle 9i, Reports 6i, Forms 6I, TOAD, SQL*Loader, SQL, PLSQL.