Sr. Oracle Plsql Developer Resume

SUMMARY

• 7 years of programming experience as an Oracle SQL, PL/SQL Developer in Analysis, Design, Data Modeling (Logical and Physical) and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Strong knowledge in front-end development using Oracle forms/reports 6i/9i/10g.
• Strong Knowledge on Oracle architecture and database design.
• Have a strong knowledge on Dataware-housing concepts and implementation using Oracle ware housing.
• Experience in creating stored procedures, PL/SQL Packages, Triggers and Functions. Strong knowledge in Oracle cursor management and exception handling.
• Expert in creating Views, Stored Procedures, effective functions and appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Excellent conceptual knowledge of Oracle 9i/10g, PL/SQL.
• Hands on experience in design, development of end user screens and reports using Forms and Reports 9i and Oracle Developer Suite 10g.
• Experience in deploying forms and reports on the web.
• Expert knowledge in using data modeling tools like ERWIN and ER diagrams, Normalization Techniques for designing database with Relational technology.
• Extensive experience in developing UNIX Shell scripts and scheduled jobs on UNIX server using Crontab utility.
• Expert in using PL/SQL advanced topics like System variables, Ref Cursors, Dynamic SQL, Collections, UTL_FILE to read and write the files.
• Expertise in Database Performance Tuning and Optimization of SQL statements using Oracle Hints, Explain plan, Tkprof, SQL*Trace and Table partitioning.
• Experience in retrieving data from external data Files and loaded into oracle tables using tools like UTL_FILE, SQL*Loader and External Tables.
• Experience in troubleshooting various aspects of the client/server architecture in both UNIX and Oracle setting.
• Identified several SQL and PL/SQL bottlenecks using PL/SQL Profiler (package DBMS_PROFILER), explain plan, auto trace.
• 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.
• Strong interpersonal skills, ability to interact with people at all levels.
• Ability to work individually as well as in a team with excellent problem solving and troubleshooting capabilities. Able to explain technical concepts and communicate with users and system administrators at all levels.

EDUCATION:

• Bachelors in Technology

TECHNICAL SKILLS:

Programming Languages

C, C++, SQL, PL/SQL

Markup Languages

HTML, XML

Databases

Oracle 11g/10g/9i, MS ACCESS

Data Modeling Tools

ERwin, ER Studio, SQL Developer Data Modeler, Visio

IDE

SQL*PLUS, SQL worksheet, iSQL*PLUS, TOAD, PLSQL Developer, SQL Developer, SQL Navigator

Source Control Software

Visual Source Safe, Clear Case, CVS

Other Tools

Microsoft office suite, Microsoft Visio

Operating Systems

UNIX (Solaris/HP-UX), Windows Server 2000/2003

PROFESSIONAL EXPERIENCE:

Client:Confidential, OH Nov’11- Present
Role: Oracle PL/SQL Developer

Description: Snap-on business solutions have individual and institutional customers worldwide. It offers a variety of products and services. It is one of the largest hardware company, based on tools. It is one of the most admired companies in United States of America. The order management dashboard is the tool used by GM project Managers and customer care agents to check the status of multiple customer orders. Using this dashboard, customer care agents were able to track and manage order status of all customer purchases with visibility from order to delivery in a near real-time manner.

Responsibilities:

• Analyzed the business requirements of the project by studying the Business Requirement Specification document.
• Createdcustom PL/SQLprocedures to read data from flat files to dump into Oracle database using SQL * Loader.
• DevelopedPL/SQL Proceduresanddatabase triggersfor the validation ofinput data and to implementbusiness rules.
• Created database objects likepackages, procedures, and functions accordingto the client requirement.
• Createdindexes on the tables for faster retrieval of the data to enhance databaseperformance.
• PerformedSQL and PL/SQLtuning and Application tuning using various tools likeEXPLAIN PLAN,TKPROF, SQL TRACE and DBMS_SQLTUNE.
• Worked withBulk Collectsto improve the performance of multi-row queries by reducing the context switching.
• Extensively involved in usinghints to direct the optimizerto choose an optimumquery execution plan.
• Used bulk processing forbetter performanceand easy retrieval of data, being a part of performance tuning of the procedures and packages.
• CreatedPL/SQL scriptsto extract the data from the operational database into simple flat text files usingUTL_FILEpackage.
• Creation of database objects like tables, views, materialized views, procedures, packages using oracle tools likeSQL developer.
• Implemented several triggers to maintainDatabase Securityby auditing log table to track information about users and to know which user is doing what operation.
• Created database links to retrieve data from multiple servers.
• Extensively usedForallandBulk collectto fetch large volumes of data from table.
• Created and run batch files on regular basis.
• Createdrecords, tables, collections(nested tables and varrays) for improving Query performance by reducingcontext switching.
• UsedPragma Autonomous_Transactionto avoid mutating problem in database trigger.
• Wrote complexSQL queriesincluding sub queries for fasterdata retrievalfrom multiple tables.
• Extensively used the advanced features ofPL/SQL like Records, Tables, Object types and Dynamic SQL.
• Handled errors usingException Handlingextensively for the ease of debugging and displaying the error messages in the application.
• Created and modified severalUNIX shellScriptsaccording to the changing needs of the project and client requirements.
• Used the standard Oracle packageDBMS_SCHEDULERto automate/schedule jobs on daily, weekly and monthly basis andto run jobs in parallel to improvetime-constrained performance.
• Designed, developed and tested Forms and Reportsas per client requirements and making themweb enabledusing Oracle Reports builder 10g and Oracle Forms builder 10g respectively.
• Developed Master Detail, Detail reports using tabular and Group above reports.
• Involved in the development of forms using various canvases like content, stacked, tabbed, horizontal and vertical toolbar and using appropriate triggers as required by the application.
• DevelopedList of Values, Record Groups, and triggers for different data blocks to improve the functionality of the forms using Oracle Forms 9i.
• Developed Procedures for efficient error handling process by capturing errors into user managed tables.

Environment:
Oracle 10g/11g, SQL, PLSQL, SQL*Loader, UNIX Shell script, TOAD, Oracle Forms 10g, Reports 10g, MS office.

Confidential,NY Oct’10- Nov’11
Role: Oracle PL/SQL Developer

The Operational Data Store (ODS) is built to store daily Membership, Group information from Legacy systems. This ODS is used for various applications and projects like COBR (Coordination of Benefits-Recertification) and for Reporting. This ODS gets the data from several legacy systems which runs on daily Kill & Fill process. This is also used by EDW to store all the historical information.

Responsibilities:

• Analyzed the Functional Specs provided by the Architect and created Technical Specs documents for all the mappings.
• Worked as part of the development team, along with the Systems Analysts/Business Analysts.
• Analyzed and fixed the data discrepancies between various systems and identified bad data caused due the data migration from various legacy systems.
• Created PL/SQL Stored Procedures, Functions, Packages, and Triggers, extensively used Cursors, REF cursors, User-defined object types, Records, in PL/SQL programming
• Developed several stored procedures and functions using advanced Oracle concepts such as Bulk Binds, Bulk Collects to improve performance.
• Involved in fine tuning the existing packages for better performance and providing on-going support to existing applications and troubleshooting serious errors when occurred.
• Modified and debugged several PL/SQL programs for performance tuning using techniques like EXPLAIN PLAN, TKPROF and DBMS_PROFILER.
• Created B Tree indexes, Function based indexes, Bit Mapped Indexes on Tables, columns to minimize query time and achieve better performance.
• Improved performance by creating Unique and Range Indexes based on the cost returned by EXPLAIN PLAN.
• Handled PL/SQL compile-time, run-time errors, debugging of Stored Procedures for business logic modification, and responding to system events through triggers.
• Effectively used Triggers to track the user profile updates and to send the messages to downstream systems.
• Extensively used Materialized views and DB links for remote instances to retrieve data from other databases.
• Worked with DBA in making enhancements to physical DB schema and coordinated with DBA in creating and managing Tables, indexes, table spaces, synonyms, db links and privileges.

Environment: Oracle 10g/9i, PL/SQL, SQL Server, UNIX Shell Scripting, Toad, ER-Win Windows XP.