Oracle Developer Resume

SUMMARY

Around 9 Plus years of experience as Oracle Developer with Extensive knowledge and work Experience in SDLC including Requirements Gathering, Business Analysis, System Configuration, Design, Development, Testing, Technical Documentation and Support.
Strong experience in systems Analysis, design and development of complex software systems inBanking and Telecom Domain.
Have in - depth knowledge in Data analysis, Data warehousing and ETL techniques, Business Objects, UNIX Shell Scripting, SQL, Power Builder, PL/SQL scripts.
Rich experience working with Data Stage ETL tool for the extraction, transformation and loading of data among different databases.
Strong knowledge of ETL processes using UNIX shells scripting, SQL, PL/SQL and SQL Loader.
Strong Experience in front-end and back-end development usingForms11g/10g, SQL, PL/SQL,Oracle 11g/10gandOracle Designer10gfor Data modelling.
Experience with Data flow diagrams, Database normalisation techniques, Entity relation modeling and design techniques.
Rich experience in writingSQL queries, Views, Materialized views, PL/SQL procedures, functions, packages, triggers, cursors, collections, Ref cursor, cursor variables, Dynamic SQL.
Strong knowledge of Data Extraction, Data Mapping, Data Conversion and Data Loading process using UNIX Shell scripting, SQL, PL/SQL and SQL Loader.
Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.
Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
Effectively made use of Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
Worked extensively on Ref Cursor, External Tables and Collections.
Good knowledge on logical and physical Data Modeling using normalizing Techniques.
Created Shell Scripts for invoking SQL scripts and scheduled them using crontab.
Extensively used bulk collection in PL/SQL objects for improving the performing.
Experienced in Design and Development of Data Warehousing solutions for Extraction, Transformation and Loading (ETL) mechanism.
Usage of vi editor for writing the Unix korn, bash scripts. Experience in Unix utilities like SED, AWK
Huge experience in developingOraclePL/SQL packages and object types. Proficiency in using UNIX shell scripts for testing the application.
Good Knowledge on UNIX and Batch scripts like File watcher, File ftp, Data Validation, User defined functions, File Format Validation, Crone Jobs.
Developed Materialized views for data replication in distributed environments.
Experience in query optimization, performance and tuning (PL/SQL) usingSQL Trace, Explain Plan, Indexing, Bulk Collect, AWR and table partitioning.
Collaborated with QA teams for creating and reviewing Test Plans and Test Cases.
Experience creating and managing defects in the Quality Center.
Strong Analytical and Problem Solving skills, Multi-Tasking abilities.
Self-motivated, flexible, knowledgeable, hardworking, and detail oriented person.
Good communicator, coordinator and organizer.
Worked with business users as well as senior management and Participated in walkthroughs with the management and developer team

TECHNICAL SKILLS

Methodologies: Waterfall, Agile-Scrum

Requirements Management: JIRA

Database: SQL Server, Oracle 9i/10g/11g.

Scripting: Unix Shell, Perl 5.8.8

Release Management: ITCM, JIRA, RNOW (Release now)

Application Languages: Java, SQL, PLSQL

Scheduling Tools: Control M, Autosys

Testing Tools: HP Quality Center, JIRA

Operating Systems: Microsoft Windows Xp/2007/vista/7/8.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship