SUMMARY

• 8.5 Years of experience as seniororacle developer in the field of software development, enhancements, customizations, migration and administration. Have one year experience in Oracle DBA.
• Very good exposure to modules like Supply Chain Management (SCM), Inventory (INV), Order Management (OM), Health care and insurance domain.
• Expertise in developing programs based on Oracle PL/SQLusing Oracle 11g/10g/9i/8iunder UNIX/LINUX environments.
• Extensive experience in technical specification design, development, unit testing, system integration testing, UAT and maintenance of Oracle Pl/SQL based programs.
• Extensive experience in writing Oracle backend objects like: Stored Procedures, functions, Database Triggers and Packages, tables, views, Materialized views, indexes, synonyms, cursors, ref cursors.
• Extensive knowledge in programming code using advanced concepts of Records, Collections and Dynamic SQL.
• Designing and developing application schemas, Tables (Partitioned Tables, Index Organized Tables, External Tables and Global Temporary Tables), Clusters.
• Proficient in writing complex SQL Queries, stored procedures, Normalization, creating Indexes, Functions, Triggers, Sub Queries and tuning SQL queries using HINTS and EXPLAIN PLAN.
• Strong Knowledge of PLSQL Object Types, Oracle Parallel Queries, Materialized Views, Bulk Collects and Collections.
• Experience inImport and Export utility and SQL* Loader.
• Experience inadvanced Bulk techniques (FOR ALL, BULK COLLECT) to improve performance.
• Experience in Oracle Database administration activities involvingdatabase creation, user creation, Profile Creation as part of security, backup and restore activities.
• Experience in taking backup of the database using RMAN and manualbackup techniques.
• Experience in performance tuning the PL/SQL stored procedures, functions and SQL queries used for generating reports.
• Experience in performance tuning on SQL using AUTO TRACE, EXPLAIN PLAN, TKPROF utilities.
• Experience in creating and analyzing trace files as part of performance tuning.
• Involved in implementing versions/upgrades of Oracle 9i to Oracle 10g.
• Expertise in using third party utilities/tools like TOAD, SQL Developer, PUTTY and WINSCP.
• Extensive experience in scheduling jobsusing UNIX Crontab,Autosys.
• Experience in analyzing and creating UNIX Shell script.
• Experience in Oracle Forms and Reports Analysis.
• Experience in data extraction, Transformation and loading (ETL) data from various sources like Oracle, SQL Server and different file formats utilizing oracle utility tools SQL *Loader, Import and Export.
• Experience in analyzing ETL mappings in Informatica Power Center 9.1.
• Good Knowledge in data warehousing concepts.
• Knowledge in Hyperion Essbase business user report creation(Financial Reports).
• Strong experience in interacting with business analysts and developers to analyze the user requirements, functional specifications and system specifications.
• Proficiency in understanding clients’ needs and generate, modify existing data in Oracle Applications according to the requirements and specifications.
• Great learning skills to adapt the rapid changing technologies and implementing the same at work.
• Strong Analytical, Inter - personnel, Problem-solving and Proven ability to work under pressure.

TECHNICAL SKILLS

Languages: Oracle SQL, Oracle PL/SQL, Unix Shell scripting, Visual Basic

Databases: Oracle 8i/9i/10g/11g, SQL Server

Tools: TOAD, PL/SQL Developer,Informatica Power Center 9.1, Putty, WINSCP, Visio.

Operating Systems: UNIX & Linux, Windows 2003.

PROFESSIONAL EXPERIENCE

Confidential, Edison, NJ

Senior Oracle developer

Responsibilities:

• Attending various design sessions with functional and boundary teams to understand the requirements
• Reviewing functional requirements and preparing Technical design documents.
• Managing offshore and onsite technical team and make sure technical objects delivered on time with proper unit testing.
• Developed complex custom PL/SQL customization programs
• Highly skilled and experienced in PL/SQL.
• Develop with wide knowledge of a variety of packages, functions, stored procedures of reporting, scheduling, data retrieving, data manipulating.
• Excellent programming skills, highly proficiency in developing oracle PL/SQL packages, stored procedures, functions, triggers and cursors.
• Excellent in Software Development Life Cycle (SDLC).
• Managing defects during post production support and assigning defects to appropriate resources both Onsite and Offshore.
• Generating reports on open defects and submitting it to the management on daily basis.
• Making sure all technical documents are up to date.

Environment: Oracle database 11g, Toad, Red hat Linux, SQL, PL/SQL, Visio

Confidential, Bloomfield, CT

Senior Oracle Developer

Responsibilities:

• Closely worked with offshore technical team in designing and developing custom solutions which includes PL/SQL packages modifications, creation of triggers and materialized views.
• Providing Technical solutions to new enhancements and preparing Technical design documents.
• Performing root cause analysis of the issues and avoid the occurrences of similar issues in future.
• Extensively used various PL/SQL features like Cursors, REF Cursors, Collections, Autonomous Transactions, and Bulk Binding along with the various Exceptions in the PL/SQL Stored Procedures.
• Extensively used for all and bulk collect to fetch large volumes of data from tables.
• Wrote complex Oracle SQL queries using joins, sub queries and correlated sub queries.
• Implemented Materialized Views for extracting data from remote databases.
• Collaborate and communicate a solid understanding of the database design, engineering and support procedures necessary for optimal system performance.
• Involved in creating and managing tables, indexes, db links and privileges.
• Participated in Performance Tuning the PL/SQL code using Explain Plan, TKPROF and AUTOTRACE.
• Created reusable DDL, DML SQL queries that can be used for different input data to validate against the User Interface.
• Extensively worked in Oracle SQL, PL/SQL, SQL*Plus, SQL*Loader, Query performance tuning, created DDL scripts, created database objects like Tables, Views Indexes, Synonyms and Sequences.
• Implemented various automated UNIX shell scripts to invoke PL/SQL anonymous blocks, Stored PROEDURES/FUNCTIONS/PACKAGES using SQL PLUS session in silent mode.
• Extensive use of several Oracle provided packages such as UTL FILE.
• Used Toad and SQL Navigator for development and production environments.
• Provided support and handled change requests after every release.
• Providing Technical and Functional support to the users during UAT.

Environment: Oracle 11g, PL/SQL, TOAD, Linux, Visio

Confidential, Exeter, PA

Oracle developer

Responsibilities:

• Reviewing requirements and providing feedback
• Suggesting feasible and efficient solutions for all customizations and integrations.
• Providing Technical solutions to new enhancements and preparing Technical design documents.
• Developed highly complex programs using Oracle PL/SQL.
• Extensively involved in creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
• Created programming code using advanced concepts of Records, Collections and Dynamic SQL.
• Used advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve performance. Developed Installation scripts for all the deliverables.
• Created and manipulated stored procedures, functions, packages and triggers using TOAD.
• Scheduled jobs in UNIX using Autosys.
• Created materialized views using different clauses like FAST, COMPLETE, FORCE, and ON COMMIT.
• Utilized SQL*loader to load data from external system and developed PL/SQL programs to dump the data from staging tables into Base Tables.
• Experience in working with IMPLICIT CURSORS, EXPLICIT CURSORS and REF CURSORS.
• Coordinating with offshore technical team on technical deliverables.
• Performing root cause analysis of the issues and avoid the occurrences of similar issues in future.
• Updating technical documents in case of enhancement requests raised by business users after post go live and make sure all the documentation is up to date.
• Providing Technical and Functional support to the users during UAT.

Environment: Oracle 10g, PL/SQL, TOAD,UNIX,Autosys

Confidential

Consultant ERP

Responsibilities:

• Designed solutions for customer requirement based on oracle PL/SQL.
• Developed stored procedures and functions in PL/SQL according to the approved design.
• Extensively involved in Creating stored procedures, functions, packages, views, Object data types.
• Used advanced PL/SQL techniques such as collections, BULK COLLECT, FOR ALL.
• Handled Exceptions using Exception Handling.
• Developed UNIX shell scripting for calling stored procedures and packages.
• Created and manipulated stored procedures, functions, packages and triggers using TOAD and PL/SQL Developer.
• Tuned Complex queries using EXPLAIN PLAN, HINTS, creating INDEX, restructuring SQL queries.
• Worked as team lead for four associates by allocating daily tasks and providing status updates to client.
• Provided support in QA and UAT phase
• Attended various sessions with DBA’s to come up with optimal performance criteria for all the processes.
• Prepared all technical documents for all the developed applications.

Environment: Oracle 10g, PL/SQL, SQL*PLUS,PL/SQL developer,TOAD, Windows XP, UNIX.

Confidential

Consultant ERP

Responsibilities:

• Designed solutions for customer requirement based on oracle PL/SQL.
• Developed stored procedures and functions in PL/SQL according to the approved design.
• Developed scripts using SQL*PLUS
• Extensively involved in Creating stored procedures, functions, packages, views, Object data types.
• Used advanced PL/SQL techniques such as collections, BULK COLLECT, FOR ALL.
• Handled Exceptions using Exception Handling.
• Developed UNIX shell scripting for calling stored procedures and packages.
• Performed Oracle Forms and Reports analysis during database and applcations server migration.
• Developed SQL*plus scripts according to the requirement.
• Provided support in QA and UAT phase
• Prepared all technical documents for all the developed applications.

Environment: Oracle 10g, PL/SQL, SQL*plus, Windows XP, UNIX,Autosys.

Confidential

Programmer Analyst

Responsibilities:

• Served as Database administrator for Oracle database running on UNIX server.
• Created users, profiles and granted privileges according to the business policy.
• Created backup script for taking cold backup of the database.
• Created scripts for taking hot backup of the database using RMAN.
• Automated backup scripts, alerts using UNIX shell scripting.
• Tuned SQL queries and PL/SQL based applications by creating SQL trace files and creating index and hints.
• Developed applications in PL/SQL according to the approved design.

Environment: Oracle 9i, PL/SQL, PL/SQL Developer, Windows XP, UNIX.

Confidential

Programmer Analyst

Responsibilities:

• Knowledge acquisition from third party vendor.
• Performed daily tasks of a Database administrator for Oracle running on UNIX server.
• Created users, profiles and granted privileges according to the business policy.
• Created backup script for taking cold backup of the database.
• Created scripts for taking hot backup of the database using RMAN.
• Automated backup scripts, alerts using UNIX shell scripting.
• Tuned SQL queries and PL/SQL based applications by creating SQL trace files and creating index and hints.
• Coordination between Clients and offshore peers.

Environment: Oracle 9i, PL/SQL, PL/SQL Developer, UNIX.

Confidential

Programmer Analyst

Responsibilities:

• Served as a database administrator for Oracle running on UNIX operating systems.
• Created users, profiles and granted privileges according to the business policy
• Created backup script for taking cold backup of the database
• Automated backup scripts, alerts using UNIX shell scripting.
• Tuned SQL queries and PL/SQL based applications by creating SQL trace files and creating index and hints.
• Developed control chart for Confidential business applications using VBA

Environment: Oracle 9i, PL/SQL, PL/SQL Developer, TOAD, VBA, UNIX,SQL SERVER

Confidential

Programmer Analyst

Responsibilities:

• Knowledge acquisition from third party vendor.
• Served as a database administrator for Oracle running on UNIX operating systems.
• Performed major database administration activities which include databasecreation for the New Year from the old year backup, database restoration and cold backup.
• Created backup script for taking cold backup of the database.
• Coordination between clients and offshore peers.
• Analyzed ETL mappings to understand the business logic involved.

Environment: Oracle 9i, PL/SQL, PL/SQL Developer, TOAD, VBA, UNIX,Informatica Power Center 9.1

Confidential

Programmer Analyst

Responsibilities:

• Developed applications in VB according to the approved design.
• Prepared technical documents for the developed application.
• Made changes to dll in VC++ according to the business requirement.
• Created unit test cases and executed the test cases.
• Provided technical support during UAT phase.
• Upgraded applications based on VB 4.0 to VB 6.0

Environment: Visual Basic 4.0, Visual Basic 6.0, VC++, UNIX.

Confidential

Programmer Analyst

Responsibilities:

• Provided production support to both in-house staff and user departments for Oracle/Unix based applications.
• Designed, documented and executed maintenance activities in PL/SQL.
• Created shell scripts in UNIX according to business requirements.
• Reported status of the background jobs as part of the daily task.
• Created business user reports based on Hyperion Essbase.

Environment: Oracle 9i, PL/SQL, PL/SQL Developer, UNIX,HyperionEssbase.