SUMMARY

• With my excellent educational background and current technical & quality exposure, want to contribute to the growth and profitability of the organization and get accepted globally as a knowledgeable and dependable professional.
• Over 8+ 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).
• Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Expertise in Client - Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.
• Ability to analyze business data requirements, functional and technical specifications as well as design conceptual, physical and logical data models.
• Excellent analytical skills and the ability to solve complex data modeling and database issues.
• Ability to cope with fast-paced and challenging environment as well as work both independently and in cross-functional teams.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views.
• Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Developed materialized views for data replication in distributed environments.
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• Loaded Data into Oracle Tables using SQL Loader.
• Partitioned large Tables using range partition technique.
• Experience with Oracle Supplied Packages such as DBMS SQL, DBMS JOB and UTL FILE.
• Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.
• Worked extensively on Ref Cursor, External Tables and Collections.
• Expertise in Dynamic SQL, Collections and Exception handling.
• Experience in SQL performance tuning using Cost-Based Optimization (CBO).
• Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
• Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.
• Created Shell Scripts for invoking SQL scripts and scheduled them using Crontab.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.
• Expertise in fine tuning of the applications for maximum performance.
• Excellent organizational and time-management skills and the ability to handle large data volumes and databases.
• Effective communication and presentation skills and the ability to engage with client or business users in technical discussions.

TECHNICAL SKILLS

Databases: Oracle 9i/10g/11g

Data Access Tools: TOAD, Oracle SQL Developer

Programming Languages: SQL, PL/SQL, Unix Shell scripting

Scheduling Tools: Autosys

Operating Systems: MS DOS, Win 98/2000/XP/7/8, UNIX

Other Tools: Win SCP, Putty, GIT

PROFESSIONAL EXPERIENCE

Confidential

Oracle Developer

Environment: Oracle 11g, PL/SQL, Unix, TOAD, GIT

Responsibilities:

• Handling development, code implementation for the new functionality and modifying existing functionality based on the client’s requirement as per Specs.
• Transformed business or data requirements into logical models and developed physical data models to define database structures as well as optimized database performance through efficient indexing and table relationships.
• Designing/modifying design of database tables, keys, indexes, grants, triggers, packages, functions and procedures etc.
• Converted logical models into physical models as well as generated DDL scripts and complex SQL views for optimal performance tuning.
• Worked on creating new database objects like Tables, Synonyms, PL/SQL Procedures, Sequences, Functions, Packages, Triggers, Views, Indexes, DB Links etc.,
• Worked on improving performance of the programs by creating indexes and using Hints and modifying the existing joins.
• Understanding and fixing of Issue reported by Clients and owners.
• Worked in enhancement and bug fixing team.
• Perform Unit Testing on the developed application.

Confidential

Oracle Developer

Environment: Oracle 11g

Responsibilities:

• Worked in development of three layers (Physical, Business and Presentation layer) using Oracle BI Administration tool.
• Created, developed, implemented, updated and maintained data models, data flows and related strategies for applications, data marts or warehouses as per established standards and procedures to ensure high data quality and reduced redundancy.
• Worked on creating new database objects like Tables, Synonyms, PL/SQL Procedures, Sequences, Functions, Packages, Triggers, Views, Indexes, DB Links etc.,
• Developed best practices for standard naming conventions to ensure data consistency as well as validated data models and physical databases for variances and discrepancies as needed.
• Developed SQL scripts to build database objects and roles that included stored procedures, views and tables, data replication and change data capture processes as needed.
• Design and documentation of Functional, Technical Specifications by checking the feasibility of the business requirements.
• Helping the new joiners in the project with the project processes and technical details.

Confidential, Sugar Land, TX

Oracle Developer

Environment: Oracle 11g, Unix, Autosys

Responsibilities:

• Created new database objects like PL/SQL Procedures, Sequences, Functions, Packages, Triggers, Views, Indexes.
• Understanding and fixing of Issue reported by Clients and owners.
• Modifying the existing package bodies as per the new data available in Production
• Participate in various project activities like planning, sign-off, team meetings, and escalations etc.
• Fixing of issues that are recorded during Development testing and UAT.
• Involvement in Production Change Management, Release Coordination
• Automation of Jobs Using Crontab in UNIX