We provide IT Staff Augmentation Services!

Oracle Developer Resume

Pittsburg, PA

SUMMARY

  • Overall 8 years of programming experience as an Oracle PL/SQL Developer in analysis, design and implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
  • Expertise in development of business applications using Oracle 11g/10g/9i/8i, SQL, PL/SQL, Toad, SQL*Loader.
  • Involved in all phases of Software Development Life Cycle (SDLC) from analysis, gathering requirements, design, development, testing, implementing, support and documentation of business applications using Oracle technologies.
  • Strong knowledge on various database concepts like Normalization and ER Diagrams.
  • Extensively used PL/SQL to build Oracle Packages, stored procedures, functions, triggers, cursors, ref cursors, views for processing data, enforcing referential integrity and business rules.
  • Experienced in Tuning SQL and PL/SQL code for better performance with large volume of data.
  • Strong knowledge of Extraction Transformation and Loading (ETL) processes using UNIX shell scripting, SQL, PL/SQL and SQL Loader.
  • Implemented PL/SQL advanced topics like System variables, Ref Cursors, Dynamic SQL, Collections, UTL FILE to read and write the files.
  • Good knowledge in creating DDL, DML and transaction quires in Oracle SQL and SQL Server Database.
  • Proficient in shell scripting, unit testing, code migration/deployment, Pre and post production support, extensions, customizations and Maintenance.
  • Have in - depth knowledge in Data analysis, Data warehousing and ETL techniques, Business Objects, UNIX Shell Scripting, SQL, Power Builder, PL/SQL scripts.
  • Rich experience working with Data Stage ETL tool for the extraction, transformation and loading of data among different databases. Strong knowledge of ETL processes using UNIX shells scripting, SQL, PL/SQL and SQL Loader.
  • Extensive Experience on Materialized views, Collections like Nested Tables, Objects, Autonomous Transactions, Dynamic SQL, SQL* Loader.
  • Working experience in data extraction, transformation and loading operations into oracle using SQL Loader, External tables, DB links, Export/import and UTL FILE to read and write the files.
  • Expertise in Database Performance Tuning, Performance Monitoring and Optimization using Oracle Hints, SQL Trace, Explain plan and TKPROF.
  • Proficient in developing and maintaining of packages, functions, application procedures, stored procedures, triggers, tables, indexes, views using Oracle PL/SQL database programming language and maintaining the DDL scripts
  • Used DBMS PROFILER package which enables the collection of profiler data for performance improvement.
  • Experience in using DBMS SCHEDULER to run jobs in parallel to improve time-constrained performance.
  • Developed and maintained system documents, including technical specifications, data mapping, program logic and flowcharts.
  • Strong communication, interpersonal, analytical skills with proficiency at grasping new concepts quickly and utilizing the same in a productive manner.

TECHNICAL SKILLS

Programming: Confidential ++, Oracle PL/SQL and Java

Operating Systems: Windows2000/XP/NT/7, UNIX, Solaris, Linux

Databases: Oracle 9i/10g/11g

Middleware: IBM WebSphere MQ

Scripting: Shell, Perl 5.8.8

SCM Tools: ClearCase, SVN, HP Quality Center

IDE Tools: SQL Developer, SSRS, SSIS Toad for Oracle 12.1, Eclipse, IBM Rational Synergy

Business Intelligence Tools: Cognos 8.1

Release Management: ITCM, JIRA, RNOW (Release now)

Scheduling Tool: Control M, Autosys

PROFESSIONAL EXPERIENCE

Confidential, Pittsburg, PA

Oracle Developer

Responsibilities:

  • Generated DDL scripts and Created and modified database objects such as tables, views, sequences, functions, synonyms, indexes, packages, stored procedures, Records and Collections using TOAD tool.
  • Used Bulk Collect, PL/SQL tables, arrays and other collection for huge data manipulations and improve the performance of the system. Involved in the detailed data mapping from the source legacy systems (WWCOM, CSPORTAL) extract files to the Oracle Payables tables.
  • Implemented CTAS (Create Table As Select) approach to optimize an update process reducing runtime from 14 hours to 4 min 36 sec.
  • Provide quality operations support for production environment. Work with QA and provide support to provide timely technical resolutions for defects.
  • Gathered the business requirement from clients and translated the business details into technical requirements.
  • Redshift is a fully managed, petabyte-scale data warehouse service in the cloud. Design Redshift based BI solution platform for optimized performance and usability.
  • Use AWS Data Pipeline to specify the data source, desired data transformations and then execute a prewritten import script to load your data into Redshift.
  • Implemented Temp table of rowid’s - Primary key approach to update user id/week no coming from CHAMP (Point of Sale) system into DOTCOM system.
  • Enhanced a Champ module's performance in a preexisting product by 2800% faster (reducing runtime from 16 hours to 40 mins) adopting a more efficient data accessing path than the old one.
  • 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 and 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.
  • Implemented Data loading process using UNIX Korn shell scripts resolved application issues in UNIX production environment. Read and interpreted UNIX logs
  • Involved in client interaction, handling change requests and implementing the application on the client side.
  • Implemented various automated UNIX shell scripts to invoke PL/SQL anonymous blocks, Stored Procedures/Functions/Packages
  • Implemented various UNIX scripts to generate the data in txt format
  • 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.
  • Developed technical design documents by reviewing functional requirement documents.
  • Involved in preparing the test scenarios and performed unit tests on PL/SQL programs.

Environment: Oracle 10g/11g, PL/SQL Developer, SQL*Plus, TOAD 10.1, SQL*Loader, Windows Server 2008/Windows 7, UNIX, IBM Rational Synergy 7.1, Eclipse IDE, Bing Maps API.

Confidential, Keene, NH

Oracle PL/SQL Developer

Responsibilities:

  • Analyzed the Functional Specification 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.
  • 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.
  • Implemented Data loading process using UNIX Korn shell scripts resolved application issues in UNIX production environment. Read and interpreted UNIX logs
  • 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.
  • Coordinate with offshore team and client, update daily status reporting to client.

Environment: Oracle 10g/11g, SQL, PL/SQL, Java, JIRA, UNIX Shell Scripting, Perl 5.8.8 Scripting, Linux, IBM WebSphere MQ, SVN, sqlloader, Control M

Confidential, MA

Oracle Developer

Responsibilities:

  • Developing Flexible PL/SQL Scripts/Packages for Data Objects Creation such as Tables to store legacy data and to maintain data for staging interim phase
  • Many previous utilities written in Pro Confidential and Confidential ++ were written in PL/SQL to enhance their performance using oracle 10g database.
  • Developed stored procedures / packages to run ETL jobs to extract customer information from OLTP database into data warehouse.
  • Developed stored procedures to extract data to generate WEBFOCUS reports.
  • Optimized many previously written utilities to perform better compared to their performance using oracle 9i.
  • Implemented performance tuning using indexes, inline views and sub queries.
  • Responsible in the migration efforts of NEXTEL customers from BCGI platform.
  • Developed UNIX Shell scripts, Batch file to perform job scheduling and execute the utilities.
  • Created installation libraries for the installation of the application on test and production, using WISE Software Packaging and Installation Tools.
  • Converted the Functional requirement to technical design document, wrote utility release notes and install documents

Environment: Oracle10g, PL/SQL, Toad, Windows NT, UNIX Shell Scripts, Webfocus Reporting, Wise Package Studio 7.0

Confidential, FL

Oracle Developer

Responsibilities:

  • Developed and modified PL/SQL code for complete process of conversion from mainframes database to oracle database.
  • Coded and debugged the Stored Procedures, Packages, and Views in Oracle Databases using SQL and PL/SQL, which were called by user-oriented application modules.
  • Extensive querying using SQL * plus / TOAD to monitor quality and integrity of data.
  • Design and prepared Data Flow Diagrams and mapping documents for existing PL/SQL code.
  • Involved in coding of data extraction scripts as per technical specifications.
  • Designed database tables as per technical specifications.
  • Used Informatica Power Center for (ETL) extraction, transformation and loading data from heterogeneous source systems.
  • Translated business requirements into creation and alteration of database objects: tables, indexes, constraints, triggers and stored procedures.
  • Involved in Performance tuning which included creating indexes and modifying tables using explain plan utility.
  • Created SQL Loader script generator application using PERL shell scripting and PL/SQL
  • Optimized SQL statements and PL/SQL blocks by analyzing the execute plans and statistics of SQL statements and created and modified some Oracle Database objects to make sure all SQL statements could be executed in the most efficient ways.
  • Involved in Batch Operations.
  • Responsible for writing the night batch process using Shell scripts.
  • Developed automating reports by validating converted data.
  • Involved in production support and resolved many critical issues by providing emergency cleanup scripts.

Environment: Oracle 9i/10g, OAS 9i (Oracle Application Server), PL/SQL, TOAD, SQL*Loader, Informatica 8.x, SQL Server 2000/2005, UNIX, PERL, WINDOWS, HP 9000 server HP-UX.

Confidential, Denver, CO

Oracle Developer

Responsibilities:

  • Involved in Requirement Analysis, System Design, Preparing Functional Specifications, Preparing Design.
  • Validating extracted data from Legacy system.
  • Developed database objects including tables, clusters, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems.
  • Created SQL*Loader scripts to load data into the temporary staging tables.
  • Created Custom Triggers, Stored Procedures, Packages and SQL Scripts.
  • Involved in uploading of the data from flat files into Databases and validated the data with PL/SQL procedures.
  • Tuned complex Stored Procedures for faster execution and Developed database structures, according to the requirements
  • Developed various complex stored procedures, packages, interfaces and triggers in PL/SQL.
  • Created various SQL and PL/SQL scripts for verification of the required functionalities.
  • Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
  • Developed complex SQL queries for data retrieval from various database objects including tables and views.
  • Worked on various backend Procedures and Functions using PL/SQL.
  • Involved in Requirement gathering and creating Dataflow Diagrams, ER diagrams and database diagrams using Oracle Designer.
  • Wrote shell scripts to automate the loading, balancing and extraction process
  • Performance tuning using Explain plan, TkProf and statspack.
  • Executing ftp, telnet for remote access between UNIX systems.
  • Check the functionality of data in the front-end whether it is displaying properly or not.
  • Extensively involved in UNIX shell scripting for writing Wrapper scripts, SQL Execution scripts in ETL processes
  • Managing Version Control Tool like Clear Case and Start Team.

Environment: Oracle 9i, PL/SQL, SQL*Loader, TOAD, Java, HTML, HP-UX 11i, MS Visual Source Safe, Star Team, Clear Case PL/SQL Developer.

Hire Now