We provide IT Staff Augmentation Services!

Sr. Oracle Pl/sql Developer Resume

TX

SUMMARY

  • Working as Oracle Developer with over 8 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.
  • Experience using X-Windows software like Humming Bird.
  • 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.

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 VISIOVI Editor, Oracle Wrap, 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, TX

Sr. Oracle PL/SQL Developer

Responsibilities:

  • Developed PL/SQL Packages, Procedures and Functions accordance with requirements for loading data into database tables.
  • Loading of data from using SQL* Loader and import/export utilities.
  • Developed technical specifications for various back end modules from Business Principles.
  • Developed stored procedures to extract the data from different sources and load it into data warehouse.
  • Analyzing the data needs for the customized reports. Mapping the data requirements developing Stored Procedures, Functions, Views, Materialized View and Triggers.
  • Created and modified several views on tables which will be populating the Warehouse system. Also involved in creation of aggregate materialized views on Data Warehouse.
  • Created Partitioned tables and indexes for improving the performance of application.
  • Developed reports using complex queries as risk manager request as a part of production support.
  • Improved the performance of the slow SQL queries by implementing indexes, using FORALL, BULK COLLECT and developed various procedures, functions and packages to implement the new business
  • Developed complex SQL queries to perform the back end testing of the Oracle database using SQL and UNIX shell commands
  • Performed the uploading and downloading of flat files from UNIX server using FTP

Environment: UNIX,Oracle10g/11g,Windows 7, PL/SQL, SQL*PLUS SQL, SQL*Loader, PL/SQL Developer, JAVA J2EE.

Confidential, Ann Arbor, Michigan

Oracle PL/SQL Developer

Responsibilities:

  • Responsible for analysis, design, development, and testing of the application.
  • Used ETL to load data into Oracle database.
  • Analyzed and designed tables based on small and large database transactions.
  • Used SQL*Loader utilities to Export and Import Large Volumes of Data in the Excel Sheets into the Tables.
  • Created and modified primary database objects, such as Triggers, Procedures, Functions, Packages and bulk collections using PL/SQL.
  • Developed PL/SQL Views and Materialized Views with fast and incremental Refresh Rates using PL/SQL to enhance read operation.
  • Optimized lot of SQL statements and PL/SQL blocks by analyzing the execute plans of SQL statement and created and modified triggers, SQL queries, stored procedures for performance improvement.
  • Involved in performance tuning using HINTS, EXPLAIN PLAN.
  • Used SQL to create cross tab reports.
  • Improved the performance of the slow SQL queries by implementing indexes, using FORALL, BULK COLLECT and developed various procedures, functions and packages to implement the new business
  • Actively involved in preparing Technical and Business documentation for the application in design, which could serve as future reference to the programmers and system developers.

Environment: SQL, Oracle 10g/11g, TOAD, PL/SQL, SQL* LOADER, UNIX, Windows NT, SQL*PLUS, Java J2EE

Confidential, Lewisville, Texas

Oracle Developer

Responsibilities:

  • Created Database Objects like Tables and Views as per Client Requirements.
  • Created Stored Procedures, Functions, and Triggers to maintain various business rules.
  • Actively Participated in different phases of SDLC. Extensively worked towards optimizing the Queries to enhance the performance. Analyzed Indexes on regular basis.
  • Involved in the optimization of Oracle queries.
  • Managing Tables, Indexes, Constraints, Views, Sequences, and stored program units.
  • Design, development and implementation of complex ETL Processes with Informatica.
  • Involved in database tuning using Oracle Hints, Optimizers and Indexes for better query performance. Implemented Triggers based on the business rules.
  • Created SQL Loader Control Files for moving data from Flat Files (Fixed Record Length) to Staging Area Tables. Analyzed the existing Stored Procedures, Functions, Triggers and Cursors on performance issues. Used various forms of control structures including CASE, DECODE, IF-THEN-ELSE, FOR loops, WHILE loops while developing procedures.
  • Worked with Dynamic Queries (SQL). Served as a technical expert in developing database designs for Data Warehouse. Created users privileges and managed user roles and grants. Worked on DBMS SCHEDULER to automate jobs. Made use of DB LINKS for accessing data across different databases. Stored data in the audit log tables using the old and new column attributes. Loading data into Database using SQL* LOADER. Used the Oracle Import/Export utilities for taking backup of a particular partition data.
  • Gathered Statistics and Analyzed Tables and Indexes for Performance tuning.

Environment: Oracle 11g/10g, Oracle Forms and reports 10g, Sun Solaris 10, Erwin, SQL*Plus, TOAD, Quality Center, Relational Clear Case, Informatica Power Center 8.1.1.

Confidential 

Jr.PL/SQL Developer

Responsibilities:

  • Handling the request according to the User Specifications.
  • Created Grants of roles and privileges to the user.
  • Resolved application problems to maintain high level of customer satisfaction.
  • Created varioustables, indexes, constraints, views sequences, synonyms and stored program units.
  • DevelopedSQL* Loader scripts for data extraction and transformation.
  • Participated in Performance Tuning of SQL queries using Explain Plan to improve the performance of the application.
  • Developed Unix Shell Scripts to automate backend jobs, loading data into the Database using SQL* Loader.
  • Developed database triggers required for the Integrity constraints.
  • Analyzed current procedures, recommended and implemented improvements as needed.
  • Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data.
  • Written PL/SQL cursors for transaction processing.
  • Written Queries for the management in the form of stored procedures and packages.
  • Involved in writing complex queries to generate reports as per client request as a part of production support.
  • Created partitions on the tables to improve the performance.
  • Extracted data from Flat files, Oracle and SQL server sources.
  • Designed and generated reports using Crystal Reports.

Environment: Oracle 9i, PL/SQL Developer, Solaris 5.9, SQL Developer 1.1, Serena PVCS, Oracle Enterprise Manager, Windows 2000, Crystal reports.

Hire Now