Resume of Senior Oracle Developer

Title
Senior Oracle Developer

Primary Skills
Senior Oracle Developr

Location
US-MA-Boston (will consider relocating)

Posted
Apr-03-08


SUMMARY:

• Around 6 years of strong experience in analysis, design, development and deploying Business solutions using Oracle Technologies.
• Extensive experience in developing applications using tools like oracle Forms 10g/9i/6i, Oracle Reports 10g/9i/6i and Oracle database 10g/9i/8i, on Windows/Unix/Linux Environment.
• An Oracle developer with extensive experience in data transformations, conversion and interface, data loading, database modeling and performance tuning.
• Strong Coding and Designing Experience in Oracle PL/SQL & SQL.
• Extensive experience in Oracle Back-end (server-side) PL/SQL Development i.e. Packages, Stored Procedures, Functions & Triggers using SQL Developer and Toad as development tools.
• Extensive experience in Performance Tuning of SQL queries & Views using Explain Plan, SQL Trace & TKPROF utilities.
• Extensive experience in Creating and maintained Database Objects like Tables, Views, Materialized views, Indexes, Constraints, Sequence, Synonyms and Database Link.
• Strong technical hands on experience in Oracle 10g/9i/8i databases.
• Expert in using Oracle Export, Import, SQL*Loader and data pump utilities.
• Experience in developing and modifying reports in Oracle Discoverer 10g/9i/4i and BI (XML) Publisher 5.6.2.
• Extensively involved in all the phases of SDLC (Software Development Life Cycle).
• Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment. Strong communication, organizational and interpersonal competencies along with detail-oriented and problem solving skills in the technology arena.
• Ability to work individually as well as in a team with excellent problem solving and trouble-shooting capabilities.
• Self-motivated and committed person with excellent interpersonal communication skills and willingness to learn new tools, concepts and environments


CERTIFICATIONS:

• Oracle Certified Associate


TECHNICAL SKILL:

RDBMS Oracle 10g, 9i, 8i
Languages PL/SQL, SQL, Unix Shell Scripts, C, C++, JAVA
Development Tools Oracle Forms 10g/9i/6i
Reporting Tools Oracle Reports 10g/9i/6i, Discoverer 10g/9i/4i, BI/XML Publisher 5.6.2
Operating System WINDOWS Vista/XP/2000/NT/9x, DOS 6.22, Unix, Linux.
Other Tools SQL Loader, TOAD, SQL Developer, Microsoft Visual Source Safe, Microsoft Office products (Word, Excel, PowerPoint, MS Access)


Professional Experience:

Hope Global, Cumberland RI

Project: Data Migration & Oracle Development
Duration: Aug 2006 to Till Date
Role: Oracle Developer
Environment: Oracle Database 10g, Oracle Discoverer 10g, Oracle BI/XML publisher 5.6.2, Oracle Forms 10g, Oracle Reports 10g, SQL*Loader, Toad, Unix, Windows XP

Responsibilities:

• Meeting with end user, collecting requirements and converting into technical specification.
• Developed Server side PL/SQL (Stored Procedures, Functions & Packages) for implementing complex business logic.
• Created data entry Forms using oracle Forms 10g for entering data related to Order Information and inventory.
• Created and customized analytical reports for existing system using Reports 10g.
• Converted data from legacy system to Oracle 10g using SQL*Loader and PL/SQL programs.
• Responsible for tuning of SQL queries written in procedures/functions at the back end which are called from the front end forms.
? Created UNIX Shell script for sending email to alert users for erroneous records.
? Created SQL*Loader scripts to load data from external system to oracle & created discoverer report based on this.
? Responsible for creating complex views for EUL of Oracle Discoverer10g.
? Responsible for developing new reports using Oracle Discoverer Desktop/Plus 10g.
? Responsible for modifying & creating Business Areas using Oracle Discoverer Admin for changed & new reports.
? Responsible for developing new reports in Oracle XML/BI publisher 5.6.2.
? Involved in Technical Documentation, Unit test, Integration Test and writing Test plan.

ESA Inc, Chelmsford, MA

Project: Oracle Development
Duration: Dec 2005 to Jul 2006
Role: Oracle Developer
Environment: PL/SQL, Oracle 9i database, Oracle BI/XML publisher, Forms 9i, Reports 9i, SQL*Loader, Toad, SQL Developer, Unix, Windows XP


Responsibilities:

• Designed and developed complex Procedures, Functions & Packages to handle errors and exceptions at database level using PL/SQL
• Used Forms 9i for creating forms to do data entry and various utilities.
• Created complex analytical reports using inline view, lexical parameters with Oracle Report 9i.
• Used ANALYZE, DBMS_STATS, EXPLAIN PLAN, SQL TRACE and TKPROF to tune SQL queries.
• Usage of UTL_FILE package to load the data from external files that is exported from Server
• Wrote UNIX shell scripts to spawn the Loader job for daily load of data.
• Developed and customized various forms and Reports using Oracle Forms / Reports 9i
• Worked on development design documents like functional documents and technical documents
• Developed business areas, analytical queries, EUL and Defining security for user and multi organization using Discoverer Administrator and Discoverer Desktop 9i.
• Created and customized Discoverer 9i reports using Discoverer admin and desktop.
• Defining database Job Schedule programs for routine bases activities using DBMS_JOB and PL/SQL.
• Created XML/BI reports using XML/BI Publisher
• Worked extensively to formalize the logical design using ERWIN and physical creation of database objects like tables, view, sequences, function, packages, procedures etc.


Center for Development of Advanced Computing (CDAC), India

Project: Inventory And Sales Management System (ISMS)
Duration: Jan 2004 to Nov 2005
Role: Oracle PL/SQL Developer
Environment: Forms 6i, Reports 6i, PL/SQL, SQL, Oracle 9i database, SQL*Loader, Toad, Unix, Windows NT, Microsoft Visual Source Safe


Responsibilities:

? Extensively involved in the development Forms 6i, Reports 6i & PL/SQL packages for Inventory and sales management System (ISMS).
? Requirement capture, analysis of requirements, design solution based on clients needs.
? Exposure to full life cycle of product development starting from requirement analysis to deployment and maintenance.
? Used PLSQL Records, Collections (Nested Tables and Varrays) in complex backend packages.
? Wrote SQL*Loader script file for reading data from text file and loading into oracle table.
? Involved in the management of customer logged issues by providing priority based timely resolution.
? Used DBMS_AQ package to enqueue, dequeue messages from oracle queues and
? DBMS_AQADM package to create, manage, and drop queues and queue tables.
? Responsible for designing, developing, specification of test plans
? Documentation of user manual and other generic documentation required for the module.
? Done effective requirement gathering for creating new reports.
? Review and assignment of issues for team members.
? Training the new resources and knowledge sharing by in-house training sessions.
? Code review of fixed issue.


CMC Ltd, India

Project: Personnel Information System
Duration: Feb 2003 to Dec 2003
Role: Engineer -- Systems Integration
Environment: Forms 6i, Reports 6i, PL/SQL, SQL, Oracle 9i database, Toad, Unix, Windows NT, Microsoft Visual Source Safe

Responsibilities:

• Created various Forms for entry screens and Reports using Forms 6i and Reports 6i.
• Developed many reports using Reports 6i to show audit related information.
• Exposure to full life cycle of product development starting from requirement analysis to deployment and maintenance.
• Tuning of SQL Statements using EXPLAIN PLAN, SQL-TRACE and TKPROF
• Used Export/Import utility for backup purpose and transferring data from one database to another.
• Responsible for designing, developing, specification of test plans
• Documentation of user manual and other generic documentation required for the module.
• Creation of new reports to suit customer needs.
• Training the new resources and knowledge sharing by in-house training sessions.


New Delhi Municipal Council (NDMC), New Delhi, India
May 2002 to Jan 2003
Oracle Developer

Project: Property Tax Module
Duration: Dec 2004 to Dec 2005
Role: Team Member
Environment: Developer 2000 (Forms 6i & Reports 6i), PL/SQL, SQL, Oracle 8i, Windows NT, Microsoft Visual Source Safe


Responsibilities:

• Extensively involved in the development of Property Tax Module using Forms 6i, Reports 6i.
• Developed Server side PL/SQL (Stored Procedures, Functions & Packages) in Oracle 8i for implementing complex business logic.
• Developed materialized views for reporting purpose in Oracle 8i.
• Extensively used PL/SQL tables, cursors and exception handling.
• Requirement capture, analysis of requirements, design solution based on clients needs.
• Exposure to full life cycle of product development starting from requirement analysis to deployment and maintenance.
• Documentation of user manual and other generic documentation required for the module.



EDUCATION:

• Masters in Computer Applications

Certifications
See above


You must be logged in and have a current resume access subscription. Login or Register »

View all resumes in US-MA-Boston »
View all resumes in US-MA »

View other Senior Oracle Developer resumes, Programmer / Developer resumes