Professional Summary:

• Over 10 years of experience as an Oracle Developer with Proficiency in Oracle 11g/10g/9i/8i, SQL, Oracle PL/SQL, Oracle Form Builder 10g/9i/6i, Report Builder 10g/9i/6i, C, C ,UNIX Shell Scripting.
• Hands on experience in design, development of end user screens and reports using Oracle Developer/2000 Forms, Reports Oracle Developer Suite 10g and other front-end tools.
• Solid experience of creating PL/SQL packages, Procedures, Functions, Triggers and Views to retrieve, manipulate and migrate complex data sets in Oracle Databases.
• Extensive working experience in developing Database Triggers, Stored Procedures, Functions for developing Forms and Reports.
• Experience in Migration of Forms 6i, Reports 6i to Forms 10g and Reports10g.
• Good understanding of oracle Data Dictionary and Normalization Techniques.
• Expertise in performing Data export, Import and various operations using TOAD,SQL Developer.
• Extensive experience in data migration techniques using Oracle External Tables, SQL Loader, Import/Export, bulk and batch processing.
• Strong programming skills on Oracle SQL, PL/SQL indexes, bulk collects and Collections.
• Extensive experience in using Cursors and Ref-cursors for processing of data.
• Experience in Performance Tuning Optimization of SQL statements using various types of Hints, Partitioning, Indexes, Explain plan, and Trace utility.
• Experience in UNIX Shell Scripting.
• Extensively Worked on Extraction, Transformation and Load ETL process using Informatica Power Center to populate the tables in OLTP and OLAP Data warehouse Environment.
• Worked with query tools like Toad, SQL Plus, PL/SQL Developer.
• Experience with DBA activities like creating users, granting and revoking privileges on database objects and taking backups.
• Enforcing experience in data integrity using integrity constraints and database triggers.
• Good knowledge and Understanding on BO Reports.
• Extensive experience in Production Support and troubleshooting data quality and integrity issues.
• Extensive experience in working with large Databases.
• Excellent analytical and interpersonal skills, oral and written communication skills.
• Ability to work individually as well as in a team with excellent problem solving and troubleshooting capabilities.
• Proven ability to handle multiple tasks with strong technical aptitude and learning skills to adapt the rapid changing technologies and implementing the same at work.
• Excellent analytical and interpersonal skills, oral and written communication skills.
• Ability to work as a team lead also.

Technical Skills:

Professional Experience:

Confidential

Oracle Lead Developer

Responsibilities:

• Interact with business analysts to get the functional requirements.
• Documenting the business requirements in the format of Technical Design specification.
• Involved in developing various functionalities with extensive use of PL/SQL packages.
• Completely owned projects from design to implementation.
• Was involved in performance tuning.
• Was involved in mentoring of newly joined in the team.
• Code review.
• Co-ordinate with teams located in various time zones during support i.e UK,US, Singapore etc.
• Generating test cases/test plans.
• Worked with Oracle AQ functionality

Environment: Oracle 11g database, PLSQL, TOAD/PL SQL Developer, SQL Plus, VSS Visual Source safe-Source Control

Confidential

Oracle Lead Developer

Responsibilities:

• Understanding the customer requirements preparing TDS.
• Worked with ORACLE advanced concepts like Oracle AQ functionality, Oracle XML processing, triggers, packages, functions etc.
• Involved in the implementation of entire life cycle which included analysis, design, development, testing and implementation.
• Worked in the roles lead PL SQL developer in the project and owned the project till completion.
• Worked with Operations/Support team to triage and resolve production issues in various time zones like Austin/Singapore/Malaysia/China/UK.
• Involved in setting up of test environment, generating test cases and code review.
• Involved in basic DBA activities like performance tuning using explain plan, hints for long running production scheduler jobs, database creation etc.

Environment: Oracle 11g Database, PLSQL, TOAD/PL SQL Developer, SQL Plus, VSS Visual Source safe-Source Control

Confidential

Oracle/PLSQL Developer

Responsibilities:

• Understanding the customer requirements preparing TDS.
• Development in PL SQL procedures and packages, DB links, object creations and scheduler jobs.
• Involved in the implementation of entire life cycle which included analysis, design, development, testing and implementation.
• Provided 24X7 support to the client for 2 months after implementation.
• Involved in setting up of test environment, generating test cases and code review.
• Involved in basic DBA activities like performance tuning using explain plan, hints, tkprof for long running production scheduler jobs, database creation etc.

Environment: Oracle 11g Database, PLSQL, TOAD/PL SQL Developer, SQL Plus, VSS Visual Source safe-Source Control

Confidential

Oracle Lead Developer

• Product, Organization Vendor management
• Purchase Order Management
• Merchandise Receiving
• Transfer management
• Exporting/importing data to host systems

Confidential

Responsibilities:

• Working with the design team for implementation of specific business rules in the product for modules 'Product, Organization Vendor management' and 'Interaction with Arthur Allocation via Allocation Bridge'.
• Writing procedures, triggers and packages as required.
• Programming and testing new application modules and enhancement of the existing ones.
• Design, develop and implement new applications.
• Unit/System Testing of the existing application.

Environment: Oracle 11g database, PLSQL, TOAD/PL SQL Developer, SQL Plus,VSS Visual Source safe-Source Control

Confidential

Oracle/PLSQL Developer

Responsibilities:

• Programming and testing new application modules and enhancement and support of the existing ones.
• Design, develop and implement new modules.
• Active daily interaction with the client.
• Written CRON jobs which run on a daily/weekly and monthly basis for updating of BT people.
• Constant performance monitoring of the performance of the cold fusion server.
• Was involved in generating adhoc reports.

Environment: Oracle 9i database, PLSQL, UNIX, PL/SQL developer

Confidential

Oracle/PLSQL Developer

Responsibilities:

• Understanding business requirements and suggesting appropriate solutions.
• Preparing and updating Functional high level Technical low level documents.
• Played the role of alternate Oracle DBA
• Played developer role
• Providing object level security across the application.
• Creating Procedures, Functions, Packages Triggers in Oracle, based on the requirement.
• Performance improvement by tuning the queries/procedures.
• Performing Unit testing

Environment: Oracle 9i/PLSQL, UNIX