Oracle Pl/sql Developer Resume
San Francisco, CA
SUMMARY
- Over 7+ years of extensive IT experience in all aspects of Systems Development and complete Project Life Cycle in Oracle PL/SQL including requirements, Analysis, Design, Development, Testing and Implementation.
- Extensively worked in Client - Server application development using Oracle 8.0/8i, 9i, 10/g/11g, PL/SQL and SQL *PLUS.
- Experience with Data flow diagrams, Database normalization theory techniques, Entity relation modeling and design techniques.
- Extensively worked in PL/SQL for creating stored procedures, packages, database triggers, exception handlers, cursors, cursor variables.
- Working knowledge of SQL Trace, TK-Prof, Explain Plan, SQL Loader for performance tuning and database optimization.
- Experience in taking backup and restore using RMAN utility.
- Extensively worked in writing PL/SQL stored procedures, database triggers, exception handlers and cursors and ref-cursors and PL/SQL test cases.
- Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
- Experienced in working with many complex SQL queries with joins, date functions, inline functions, cursors, ref cursors, collections, partition tables, external tables, materialized views, sub-queries and analytical queries to generate reports.
- Expert in maintaining data integrity using various constraints and database triggers.
- Extensively worked on TOAD DATA POINT to create the automation scripts of the monthly reports.
- Proficient in interpersonal relations, communication, outsourcing partner teamwork and organization with excellent communication and presentation skills.
TECHNICAL SKILLS
- Windows 95/98
- Windows2000/NT/XP
- Unix
- Sun-Solaris2.x
- SQL
- PL/SQL
- C and UML
- Oracle 8i/9i/10g/11g
- Visual Basic6.0
- SQL*Loader
- Export/Import
- TOAD
- SQL Navigator
- MS-Office Tools (MS-Office 2000
- Internet Explorer MS-Excel
- Visio)
- ERWin
- Dreamweaver4.0
- Flash 5
- Data reports
- SQL Navigator and TOAD
- Oracle Internet Applications Server (9iAS)
- Oracle Application Server (OAS)
- Apache Server
- Informatica Power center 8.6.1
- Toad Data Point
- Toad for data analysts.
PROFESSIONAL EXPERIENCE
Confidential, San Francisco, CA
Oracle PL/SQL Developer
Responsibilities:
- Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
- Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
- Performed Performance tuning for SQL Queries and the system.
- Created PL/SQL stored procedures to perform ETL operations.
- Created various database objects like Views, Tables, Sequences, Packages and Procedures.
- Extensively involved in usinghints to direct the optimizerto choose an optimumquery execution plan.
- UsedBulk Collectionsforbetter performanceand easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
- Createdrecords, tables, collections(nested tables and arrays) for improving Query performance by reducingcontext switching.
- Handled errors usingException Handlingextensively for the ease of debugging and displaying the error messages in the application.
- Used PL/SQL profiler to debug the performance of procedures and identify the bottlenecks.
- Used explain plan for slow running queries and made necessary changes to code to expedite the query execution.
Confidential, Augusta, ME
Oracle Database Developer
Responsibilities:
- Extensively worked on the Adhoc Data requests to satisfy the needs of the program managers to achieve different goals of the project.
- Extensively worked of Toad Data Point to create automation scripts for the recurring Monthly, Weekly and Daily data requests.
- Extensively did Quality test plans and reviewed the Quality System Test Plan & Test cases.
- Worked with various complex queries with joins, sub-queries, and nested queries in SQL queries.
- Developed Oracle PL/SQL triggers and procedures. Set up Oracle PL/SQL package to analyze the tables and indexes, records tables and rebuild indexes.
- Created database objects, tables, indexes, procedures, SQL scripts.
- Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
- Developed ETL mappings, transformations using Informatica Power center 8.6.
- Extensively used Informatica Transformation like Source Qualifier, Rank, SQL, Router, Filter, Lookup, Joiner, Aggregator, Normalizer, Sorter etc. and all transformation properties.
- Identified the bottlenecks in the sources, targets, mappings, sessions and resolved the problems.
- Worked extensively in PL/SQL to develop packages, stored procedures, functions and database triggers.
- Loaded External files into database using import utility in Toad data-point.
- Support for the development, test and the production databases
- Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
- Performed Performance tuning for SQL Queries and the system.
- Extensively worked with testing team to coordinate changes in the system.
- Involved in managing security, granting and revoking privileges on database objects.
- Extensively coordinated with program managers to explain what tasks were possible for the system to achieve their desired output.
- Managed the monthly pool of recurring reports and data requests
Environment: Oracle 10g, SQL * Plus, TOAD for oracle, SQL*Loader, SQL Developer, Shell Scripts, UNIX, Windows XP, Microsoft Visio 2007,Data modeler, Informatica Power center 8.x, TOAD Datapoint.
Confidential, Holmdel, NJ
Oracle PL/SQL Developer
Responsibilities:
- Extensively did Quality test plans and reviewed the Quality System Test Plan & Test cases
- Worked with various complex queries with joins, sub-queries, and nested queries in SQL queries.
- Fine-tuned for performance and in corporate changes to complex PL/SQL procedure / Packages for updating the existing dimension tables using PL/SQL Developer on Oracle RDBMS
- Creating and executing SQL queries to perform Data Integrity testing on an Oracle Database to validate and test data using TOAD
- Develop Oracle PL/SQL triggers and procedures. Set up Oracle PL/SQL package to analyze the tables and indexes, records tables and rebuild indexes.
- Created database objects, tables, indexes, writing procedures, SQL scripts
- Worked in Identifying and requirements and developing models according to the customer’s specifications and drafting detailed documentation for the same.
- Worked extensively in PL/SQL to develop packages, stored procedures, functions and database triggers.
- Extensively worked towards optimizing the query to enhance the performance.
- Used %Row type and %type to define data types based on row and column respectively.
- Loaded external files into our Database through UTL FILE.
- Involved in Tuning SQL queries using Explain Plan and TKPROF utility to improve performance of the queries.
- Developed tables with partitions and created indexes, constraints, triggers, synonyms.
- Involved in managing security, granting and revoking privileges on database objects
Environment: Oracle 10g, SQL * Plus, TOAD, SQL*Loader, SQL Developer, Shell Scripts, UNIX, Windows XP, Microsoft Visio 2007
Confidential, Southborough, MA
Oracle Developer
Responsibilities:
- Gathering business requirements.
- Worked with many different clients to deliver new products, upgrades and program fixes.
- Active Participation in the System Study
- Physical designing and development of Database
- Creating database objects like tables, synonyms, sequences and views
- Created and modified procedures and functions to suite the improved business requirements.
- Worked closely with the technical teams and DBAs for issues related to code changes, data fixes, and testing
- Loaded external files into our Database through UTL FILE.
- Extensively worked towards optimizing the query to enhance the performance.
- Managed and resolved design issues during different phases of Project.
- Created records and nested tables in the procedures for handling of data
- Worked on different types of Array’s (Collections, Record Types).
- Used %Row type and %type to define data types based on row and column respectively.
- Coded complex SQL queries to retrieve data from the database depending on the need
- Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data
- Made use of Bulk Collect feature to process the data from cursor/ Ref Cursors
- Using set operators in PL/SQL like Union, Union all, Intersect and Minus
- Performed exception handling for the procedures created
- Experience in resolving anomalies in the production database
- Created indexes for faster retrieval and improved query performance
- Worked with performance tuning tools like TK-Prof, explain plan, hints to improve the database performance
- Support for the development, test and the production databases
- Used SQL plus and TOAD to develop database applications
Environment: VB 6, JAVA, Oracle 10g, PL/SQL, SQL*LOADER, Oracle Streams 10g (Replication), SQL PLUS, HTML, SQL Server SSIS, TOAD, XML, HP-UNIX shell scripting.
