We provide IT Staff Augmentation Services!

Sr Oracle Developer Resume

Monroeville, PA

SUMMARY:

  • Working as Oracle Developer with over 9 years of IT experience in analysis, design, development, testing, Production support and deployment of custom reports, forms, and workflows.
  • Strong work experience with tool like Toad, SQL Navigator, SQL Developer, SQL*PLUS, ERWIN.
  • Conceptual knowledge of Oracle SQL, PL/SQL, Oracle server (11g/10g/9i).
  • Expert level skills as an Oracle backend developer. Includes PL/SQL and SQL coding; Stored procedures, Packages, Functions, Cursors, Triggers, Constraints, DDL and UNIX scripting for loading data to implement business logic.
  • Extensive experience in Application development using Oracle Forms and Reports.
  • Used SQL*Loader for data uploading from flat files. PL/SQL Coding and SQL tuning throughout the development wherever needed.
  • Used supplied packages to extend the functionality of PL/SQL programs such as DBMS SCHEDULER to schedule jobs, UTL FILE to read and write from database.
  • Experience in Data migration Projects which uses SQL Loader, PL / SQL programming, coding Procedures, triggers and functions.
  • Experience on User - defined and System defined exceptions to handle different types of Errors like NO DATA FOUND, TOO MANY ROWS, and PRAGMA EXCEPTION INIT
  • Very Strong skills and clear understanding of requisites and solutions to various issues in implementation throughout the Software Development life cycle ( SDLC ).
  • Strong working experience in Data Analysis, Modeling, Logical and Physical database design .
  • Excellent experience with performance tuning, normalization and denormalization, partitioning of data and indexing of partitioned tables.
  • Proficient in ETL Processes using Oracle PL/SQL, Unix Scripts and SQL*Loader for data migration to Enterprise Data Warehouse with large data volume.
  • Developed UNIX Shell scripts to run various utilities.
  • Expertise in creating shell scripts andused Crontab in UNIX environment for scheduling routine tasks.
  • Used database objects to create Reports according to requirements using Crystal Reports.
  • Expert in Oracle utilities like SQL*Loader, Export/Import and data pump utilities like EXPDP/IMPDP.
  • Developed shell scripts to run the HYPERION (SQR PROGRAM) Reports.
  • Worked on Database links and Materialized views.
  • Expertise in handling errors using Exceptions.
  • Proficient in Query/application tuning using optimizer hints, Explain plan, SQL trace, TKPROF, Analyze and Autotrace.
  • Strong knowledge with PL/SQL Wrapper to protect the PL/SQL procedures or packages.
  • Extensive experience in writing Static & Dynamic (REF) Cursors, Dynamic SQL, Records, PL/SQL tables & Exception handlers.
  • Expertise in handling errors using Exceptions.
  • Proficiency in solving the issues after the application release in production.
  • Experience in working with high transacted OLTP systems.
  • Hands on experience in working different FTP clients like Smart FTP, Cute FTP, SFTP using F-Secure and Winscp.
  • Worked closely with the technical teams and made structural changes in Database.
  • Excellent analytical, problem solving, communication and inter-personal skills to manage and interact with individuals at all levels.
  • Ability to learn new technologies at rapid speed.

TECHNICAL SKILLS:

Languages: PL/SQL, SQL, Shell Programming, C, C++

Databases: Oracle 11g, 10g, 9i, MS-Office.

DBS Tools: SQL Navigator, TOAD.

GUI / Tools/Utilities: SQL*Loader,TOAD 11.0/8.0/7.5, PL/SQL Developer, DataPump (Import/Export), SQL* PLUS, ERWIN 3.5/4.0, SQL Navigator MS VISIO,VI Editor, Oracle Wrap, Oracle Forms FTP, SFTP, Explain Plan, TKPROF, Microsoft Excel, Microsoft PowerPoint.

Operating Systems: Unix,Sun Solaris 2.x/7/8, HP-UX 10/11i, Windows XP/ NT 4.0/ 2000.

Scripting: Unix Shell Scripting

Reporting Tools: Crystal Reports 9.0

PROFESSIONAL EXPERIENCE:

Confidential, Monroeville, PA

Sr Oracle developer

Responsibilities:

  • Provide resolution to application issues in time to ensure business continuity.
  • Created complex queries to generate reports based on user requirements.
  • Developed and modified Oracle packages, stored procedures, functions, Scripts, Oracle forms, synonyms, tables and indexes to implement business requirements and rules.
  • Worked with business directly to debug and resolve application issues.
  • Performance tuning or Query Optimization done using Explain Plans, Hints.
  • Developing, testing, troubleshooting and debugging of the application.
  • Responsible fro performing code reviews and involved in unit testing the queries for Oracle forms.
  • Index Tuning for enhancing the performance of the database. Analyzing and monitoring system performances using query plan outputs, system.
  • Used Bulk Collect, Forall in stored procedures to improve performance and make application efficiency faster.
  • Developed unix shell scripts to load data into database and also automate backend jobs.
  • Worked on loading data into the database using PL/SQL and SQL loader calling UNIX scripts to download and manipulate files.
  • Handling various enhancements to the system, this entailed writing new codes and changing some existing codes.
  • Used DBMS SQLTUNE.REPORT SQL MONITOR package to generate sql monitoring report and tune the queries.
  • Partitioned tables using Range partitioning, List partitioning and created local indexes to increase the performance and to make the database objects more manageable.
  • Used bind variables while writing Dynamic SQL to improve performance for User requested reports regarding patients.
  • Improved the performance of materialized view refresh from 4 hrs to 25 min using WITH clause, indexes and bulk processing.
  • Debugging the scripts and jobs in Production environment written in Shell.
  • Providing daily status reports to the clients.
  • Involved in data migration from production to test environment and created test data for analyzing and resolveing application bug fixes.
  • Wrote UNIX scripts to automate execution of SQL scripts and sed the data to the business user via secure transport or auto generated email.
  • Created functional and technical design documents and developin unit test case documents.
  • Provided production support and 24/7 support for resolving the critical production issues.
  • Involved in the solving the tickets that are raised by the end users.
  • Responsible for creating PLSQL Programs and UNIX Scripts for Data Validation and Data Conversion.
  • Prepared UNIX shell script for the transfer of files from FTP to SFTP.
  • Involved in creating extract programs for various clients including Aetna, HMS, Milliman, CNP, Pharmacy Advisor
  • Worked with various claim adjudications systems like RXClaim, Recap, RXAmerica which combines over 12 million records on a daily basis.
  • Partitioned Tables using Range Partitioning, List Partitioning and created local indexes to increase the performance and to make the database objects more manageable
  • Used Bulk collect and Forall in stored procedures to improve the performance and make the application to run faster.
  • Worked on logical and physical data modeling and created Materialized views.
  • Designed and developed several complex database procedures, packages. Extensively used features like Cursors, autonomous transactions, distributed transactions, exception handling, Dynamic, pl/sql tables, bulk load methods, optimizer Hints, Cursor variables and returning of multi record set from procedures and functions
  • Build several Unix Shell scripts for PLSQL programs to schedule them on Control M.
  • Created various UNIX Shell Scripts for scheduling various data loading process. Maintained the batch processes using Unix Shell Scripts.
  • Also Migrated feeds from UNIX system to Linux and loaded them using SQL Loader
  • Implemented new Shell Scripts to implement the same
  • Generated AWR and SQL Monitoring reports for SQL Performance tuning.
  • Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data.
  • Created relevant staging tables to load data, identified the business validation rules. Created SQL Loader scripts using UNIX shell scripting and PL/SQL
  • Build several Unix Shell scripts for PLSQL programs to schedule them on Control M
  • Used techniques like direct path load , external tables for loading the data faster.
  • AUTONOMOUS TRANSACTION PRAGMA is used in the procedures to log the status when error occurs.
  • Extensive use of Collections like Varrays and nested tables.
  • Designed and developed several complex database procedures, packages. Extensively used features like Cursors, autonomous transactions, distributed transactions, exception handling, Dynamic, pl/sql tables, bulk load methods, optimizer Hints, Cursor variables and returning of multi record set from procedures and functions
  • Involved in various outages, major implementations and handled multiple post upgrade situations.
  • Worked on configuring SFTP protocols in Unix Servers.
  • Responsible for resolution of tickets reported by application users

Confidential

Sr. PL/SQL Developer

Responsibilities:

  • Gather Business rules from the end users
  • Created new databases from scratch, refreshed databases for DEV/UAT environments.
  • Implemented Database security via User Profiles, Roles and Grants.
  • Developed and optimized database design for new applications.
  • Data residing in the source tables have been migrated into staging and then final tables.
  • Implemented FLASHBACK recovery feature and recovered STANDBY Databases.
  • Wrote PL/SQL Procedures, Functions, and Packages for Insert, Update and Delete transactions and optimized for maximum performance.
  • Created TRIGGERS to Audit the changes to data in main Tables.
  • Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data and present it to the Front-End Team.
  • Worked on Database Links to Access data from remote Database.
  • Extensively worked on BULK COLLECTS, BULK INSERTS, BULK UPDATES & BULK DELETES for loading, updating and deleting huge data.
  • Work Closely with DBA team during Database and Performance issues.
  • Scheduled the Jobs for loading data using DBMS SCHEDULER.
  • Utilized tools like SQL Navigator during development of the application.
  • Utilized the DEBUGGING Tool of SQL Navigator to monitor the execution Process of the procedures, functions and packages.
  • Designed and developed several complex database procedures, packages. Extensively used features like Cursors, autonomous transactions, distributed transactions, exception handling, Dynamic, pl/sql tables, bulk load methods, optimizer Hints, Cursor variables and returning of multi record set from procedures and functions
  • Partitioned Tables using Range Partitioning, List Partitioning and created local indexes to increase the performance and to make the database objects more manageable
  • Performed SQL and PL/SQL tuning to improve the performance with the help of SQL Trace, Explain Plan, Indexing and Hints.
  • Involve with Business Analysts and Front - End (JAVA) users to develop the Application and fix the bugs.
  • Created PROCEDURES & FUNCTIONS by making use of UTL FILE to read and write data to the Database.
  • Created VIEWS for generating reports and restricting data access to different users.
  • Worked on MATERIALIZED VIEWS with COMPLETE, FORCE refreshes to improve the Performance of the application by making local copies of remote Tables.
  • Performance Tuning of complex SQL queries using Explain Plan to improve the performance of the application.
  • Extracted data from Flat files using SQL*LOADER.
  • Developed Unix Shell Scripts for loading data into the database using SQL* Loader .

Environment: Oracle 11g, SQL Navigator 6.5, SQL Tuning, SQL*Loader, UNIX Shell Scripting, Oracle forms, MS Excel, MS Word.

Confidential, TX

Sr. PL/SQL Developer

Responsibilities:

  • Involved in developing SQL *Loader scripts for data loading.
  • Created database objects like tables, synonyms, sequences and views.
  • Created Database Schemas and involved in Exporting existing Schemas.
  • Worked with Developers in Database Design, Data Modeling, Capacity and Scalability planning.
  • Created procedures and functions to implement business requirements.
  • Involved in the optimization of Oracle queries/scripts which resulted in substantial performance improvement for the conversion processes using Oracle Hints, Explain Plans and Trace Sessions.
  • Worked with Bulk Collects to improve the performance of multi-row queries.
  • Worked on profiling and tracing PL/SQL program to analyze the execution of program in order to enhance performance of program.
  • Handled errors using system defined exceptions and user defined exceptions like INVALID NUMBER, NO DATA FOUND and PRAGMA EXCEPTION INIT.
  • Wrote shell scripts in Crontab to automate Backend Jobs.
  • Worked on minimizing CPU overhead by Tuning SQL Statements, Tuning Subprogram Invocation and Tuning computation-intensive PL/SQL Code. .
  • Analyzed Oracle objects and created Partitions for very large tables to reduce disk contention and improve performance.
  • Performed SQL and PL/SQL tuning to improve the performance with the help of SQL Trace, Explain Plan, Indexing and Hints.
  • DBMS STATS is used to collect and build various Data statistics to provide information to COST based optimizer, to find chained rows, to build histograms.
  • Implemented CTAS (Create Table As Select) approach to optimize archive process.
  • Provide quality operations support for production environment. Work with QA and provide support to provide timely technical resolutions for defects.
  • Used Bind Variables while writing Dynamic SQL to improve performance.
  • Involved in performance tuning using Indexes, Hints, Explain Plan, Stats gathering etc.
  • Involved in writing complex SQL Queries to implement the business requirements.
  • Coordinated with the business analysts for requirements analysis.
  • Used techniques like direct path load, external tables for loading the data faster.
  • Partitioned tables based on data using LIST partitioning, Range Partitioning.
  • Created indexes for faster retrieval and improved query performance.
  • Worked on PL/SQL Tables, Records and Collections, Oracle forms.
  • Worked on Database Links to import/export data.
  • Implemented triggers based on the business rules.
  • Extensively involved in Export (expdp) and Import (impdp) utilities to move data between different databases and schemas.
  • Attended review meetings and walkthroughs to discuss the status of the project and for change requests.
  • Complete end to end validation of the data, comparing the old and new system, extracted all the discrepancies and maintained the data integrity.
  • Support for the development, test and the production databases.

Environment: Oracle 11g, TOAD 9, SQL Tuning, SQL*Loader, UNIX Shell Scripting, MS Excel, Data Pump(Export & Import).

Confidential,MO

Responsibilities:

  • Gather Business rules from the end users that are to be incorporated into the system.
  • Involved in Installing, Patching, Upgrading, Tuning and Maintaining Oracle 11G Databases.
  • Extensively worked on the analysis of Tables in both Legacy Data store and new data store.
  • Extensively worked on the analysis of Columns in mapping tables for both Legacy Data store and new data store.
  • Developed the complete documentation of the project based on the analysis of tables and Columns.
  • Created DDL scripts to create, alter, drop tables, views, synonyms and sequences.
  • Worked on PL/SQL Tables, Records and Collections.
  • Wrote PL/SQL Procedures, Fun ctions, and Triggers for Insert, Update and Delete transactions and optimized for maximum performance.
  • Extensively worked on the Database Triggers, Stored Procedures, Functions and Database Constraints.
  • Utilized tools like PL/SQL Developer during development of the application.
  • Developed SQL queries to fetch complex data from different tables in remote databases using database links.
  • Participated in Performance Tuning of SQL queries using Explain Plan to improve the performance of the application.
  • Used Bind Variables while writing Dynamic SQL to improve performance.
  • AUTONOMOUS TRANSACTION PRAGMA is used in the procedures to log the status when error occurs.
  • Involved in the LOGICAL & PHYSICAL MODELING of the CSPORTAL application.
  • Involved in performance tuning using HINTS, EXPLAIN PLAN.
  • Involved in writing complex SQL Queries to implement the business requirements.
  • Used SQL* Loader and UTL FILE Packages for data conversions and interfaces.
  • Expertise in handling System Analysis and Business Analysis related issues when the application is in earlier stages.
  • Involved in client interaction, handling change requests and implementing the application on the client side.
  • Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data.
  • Coordinated with the business analysts for requirements analysis.
  • Used techniques like direct path load, external tables for loading the data faster.
  • Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data.
  • Source data residing in Excel formats are exported verbatim to flat files and then accessed via Oracle external tables in order to load into the staging schema, at which point all source data can be efficiently transformed and migrated to the target schema.
  • Extracted data from Flat files using SQL*LOADER.
  • Created partitions on the tables to improve the performance.
  • Participated in application planning, design activities by interacting and collecting requirements from the end users.

Environment: Oracle 10g & Oracle 11g, Oracle forms, PLSQL Developer, SQL Tuning, SQL*Loader. Microsoft SQL Server.

Confidential

PL/SQL Developer

Responsibilities:

  • Wrote and modified Oracle PL/SQL, Oracle forms, SQL statements procedures and functions in Toad for Oracle 11.0.
  • Created Stored Program Units like Functions, Triggers and procedures for implementing complex database intensive business rules.
  • Used features like bulk collect to process large amount of data in data base.
  • Improving SQL and PL/SQL flexibility, usability, and performance, using dynamic SQL.
  • Worked as a SQL developer to support business applications using Oracle SQL and PL and SQL.
  • Created Tables, Indexes, views, Sequences, Synonyms and stored program units.
  • Developed Unix Shell Scripts to automate backend jobs, loading data into the database using SQL* Loader .
  • Involved in analysis, design, coding and Testing .
  • Built and maintained SQL scripts, indexes, reports and queries for data analysis and extraction.
  • Involved in creating Database Design (Physical and logical) as per the requirement given by business.
  • Analyzed tables and indexes for Cost Based Optimization (CBO) to work efficiently.
  • Work towards a balanced, risk-driven SDLC target.
  • Gathered Statistics and Analyzed Tables and Indexes for Performance tuning .
  • Extracted data from Flat files using SQL*LOADER.
  • Generated SQL and PL/SQL scripts to install create and drop database objects including: tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
  • Executing and maintaining the data warehouse extract transform load (ETL) process
  • Made use of performance tuning utilities like explain plan, SQL Trace and DBMS PROFILER to reduce the run time of complicated queries on Oracle 11g.
  • Wrote complex SQL queries using joins, sub queries and inline views to retrieve data from the database. Created Partitions on the tables to improve the performance.
  • Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data.
  • Migrated data from MS Excel sheets to Flat files.
  • Worked on java based web developmet technologies.
  • Proficiency in Core java, Collections and multithreading.
  • Extensively worked using Java IDE tools like Eclipse and Net Beans.
  • Quickly learned a wide range of technology skills and business knowledge required for my projects.
  • Interacted with client to gather the requirements and implement the same in the project.

Environment: Oracle 11g, Toad for Oracle 11.0, Forms, Oracle Enterprise manager, SQL*Loader, PLSQL, Unix Shell Scripting, java, Humming Bird 10.0.0.14

Confidential

Oracle Developer

Responsibilities:

  • Extraction of data from different flat files into Oracle Database using SQL* Loader.
  • Gather Business rules from the end users that are to be incorporated into the system.
  • Worked on PL/SQL Tables, Records and Collections.
  • Wrote PL\SQL Procedures, Functions, and Triggers for Insert, Update and Delete transactions.
  • Design, development and implementation of complex ETL Processes with Informatica 7.1.3
  • Analyzed the Oracle objects and createdPartitions for very large tables to reduce disk contention and improve performance.
  • Changed existing logic within the packages for optimum performance using Oracle Hints, Explain Plans and Trace Sessions.
  • Tested the original and optimized codes thoroughly for failures before exporting to other environments.
  • Worked on Materialized view by creating an estimated cost and solved costing issues in Production release.
  • Worked with Bulk Collects to improve the performance of multi-row queries.
  • Handled errors using system defined exceptions and user defined exceptions like INVALID NUMBER, NO DATA FOUND and PRAGMA EXCEPTION INIT.
  • Created Shell scripts for regular back up instance start and shut down.
  • Created Logical and Physical Models using ERWIN.
  • Worked on profiling and tracingPL/SQL program to analyze the execution of program in order to enhance performance of program.
  • Used KORN Scripts to automate Oracle script execution.
  • Worked on Database Links to import/export data.
  • Worked on DBMS SCHEDULER to automate jobs.
  • Implemented triggers based on the business rules.
  • Optimizing and fine tuning the Crystal Reports for efficiency.
  • Used ADO, ODBC for accessing and retrieving the data from database to Crystal Reports.
  • Uploaded files onto MS SQL server 2005.
  • Worked on the minimizing CPU overhead by TuningSQL Statements, Tuning Subprogram Invocation and Tuning computation-intensive PL/SQL Code.
  • Creating and Maintaining of different levels of users with different levels of securities by creating User Roles and Privileges.
  • Support for the development, test and the production databases.

Environment: Oracle 10g, UNIX Shell scripting, ETL, Oracle Enterprise Manager, HP-UNIX,ERWIN 3.5, Toad 8.0, Crystal reports 9.0, VSS, .NET, Java, MS SQL server 2005.

Hire Now