Sr. Oracle Developer and Analyst Resume

SUMMARY:

8 YEARS of IT experience in various domains and active involvement in different phases of the software development life cycle.
Very strong understanding and extensive experience in database design, data analysis, development, performance tuning, integration, implementation and support for various databases.
Expert in SQL queries, PL/SQL Procedures, Packages, Functions, Stored Procedures, Cursors, Triggers, Interfaces and Data Conversion using PL/SQL, SQL*plus, TOAD, SQL Navigator and SQL*Loader.
Experienced in working on Oracle database 7/8i/9i/10g/11g.
Good working knowledge on oracle forms and reports.
Complete understanding and lot of experience in creating Database objects including tables, views, indexes, packages etc in Oracle.
Experience in executing SQL*LOADER, PL/SQL code and other UNIX commands.
Involved in Unit Testing, Integration testing & GUI testing, and providing Production Support.
Strong knowledge in Data Warehousing concept using Manual ETL, UNIX Shell Scripting, Crystal Reports.
Excellent communication, quantitative, analytical skills and ability to work either individually or as a member of a team
Proficient in analyzing and translating business requirements to technical requirements and architecture
Extensive experience in handling CRs, onsite - offshore interaction and co-ordination
Good communication skills, interpersonal skills, self-motivated, quick learner, team player.

TECHNICAL SKILLS:

Operating Systems: Sun Solaris, Windows NT/2000/XP/win 7.

Programming Languages: PL/SQL, Shell Scripts, XML, HTML

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

Tools and Utilities: Developer 2000 (Form 6i and Report 6i), Crystal Report and VB

Application: Oracle Application (AP, AR, Inv, OM)

Other Tools and Apps: Sqlplus, Clear case, autosys, isql, SQL Advantage, vi/emacs editors, Toad, PL/SQL developer, SQL Loader, Microsoft Office Suite, Microsoft Visio.

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Oracle Developer and Analyst

Responsibilities:

Involved in requirements review and technical design.
Involved into creating new procedures, functions, triggers, and packages based on the new process.
Implemented materialized views.
Developed Package to copy whole schema from one environment to new environment.
Involved in lots of data structures.
Implemented UNIX Shell scripts to run the process regularly
Develop SQL scripts for Releases and deploy the same in various environments
Uploading data from one environment to other database using SQL*LOADER
Involved in Data model design using Erwin.
Creation of users, roles and indexes etc.
Provided Test Data to QA team to validate front end application. Also performed unit testing.
Involved in performance tuning SQL PRODUCTION queries.
Trapped the errors using Exceptions handlers and pragma for the projects.
Involved in code review process with development and QA team for analysis and logic explanation
Process
Analysis of Production data/bugs and provide fixes.
Maintain Development and QA database environment.
Done lots of debugging process for the projects.

Environment: Oracle 10g, PL/SQL Developer, UNIX Shell Scripting using Sun Solaris, SQL*PLUS

Confidential

Oracle Developer and Analyst

Responsibilities:

Implementation of new application & creating the various existing processes for new applications
Involved into creating new procedures, functions, triggers, and packages based on the new process.
Created the integration process with the 3rd Party
We had give support for internal application which is developed in Oracle Reports Report 6i
Wrote PL/SQL functions, cursors, triggers and embedded them in PL/SQL packages.
Designed and developed the Data Model for Integration process.
Designing new DW structure along with data mapping with new application.
Designing Data conversion/Interface with the use of SQL*Loader, and Open Interface, and convert data.
Scheduled the jobs using BMC software
Designed and developed the reports using SQL Server Reporting Services
Provided Test Data to QA team to validate front end application. Also performed unit testing.
Performance tuning and optimization on SQL queries using Explain Plan, Indexing and Hints.
Tested the original and optimized codes thoroughly for failures before exporting to other environments.

Environment: Oracle 10g, PL/SQL Developer, UNIX Shell Scripting, Toad, SQL*PLUS, DataStage, D2K

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship