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.
• Good understanding of oracle Data Dictionary and Normalization Techniques.
• Expertise in performing Data export, Import and various operations using TOAD, SQL Developer.
• Experience in Performance Tuning Optimization of SQL statements using various types of Hints, Partitioning, Indexes, Explain plan, and Trace utility.
• Extensive experience in using Cursors and Ref-cursors for processing of data.
• Worked on advanced PL/SQL constructs like Oracle supplied packages, Nested tables, Arrays, Records and Types.
• Strong programming skills on Oracle SQL, PL/SQL indexes, bulk collects and Collections.
• Extensive experience in data migration techniques using Oracle External Tables, SQL Loader, Import/Export, bulk and batch processing.
• Experience in UNIX Shell Scripting.
• Good knowledge and Understanding on Extraction, Transformation and Load ETL process using Informatica Power Center to populate the tables in OLTP and OLAP Data warehouse Environment.
• Knowledge of Golden Gate.
• 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.

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 and optimization of SQL statements using various types of Hints, Partitioning, Indexes, Explain plan, and Trace utility.
• Was involved in mentoring of newly joined in the team.
• Was involved in database monitoring like dropping partitions, creating table spaces, indexing etc.
• Extensively used Informatica Power Center for data loading in Dell Warehouse using business rules.
• Was responsible for code review to adhere to quality.
• 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, Informatica power Center, 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 Golden gate for data replication.
• Was involved in ETL activities using Informatica Power Center for OLTP and OLAP transactions.
• 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, Informatica Power Center, VSS Visual Source safe-Source Control

Confidential

Oracle/PLSQL Developer

Responsibilities:

• Understanding the customer requirements from BRD and preparing TDS Technical Design Specification .
• 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.
• Involved in data loading activities using Informatica Power Center.

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

Confidential

Oracle Lead Developer

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.
• Extensive use of shell scripting.

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