We provide IT Staff Augmentation Services!

Senior Oracle Pl/sql Developer Resume

PROFFESIONAL SUMMARY:

  • Confidential, currently holding an OCP (ORACLE CERTIFIED PROFESSIONAL), has over thirteen years of experience in data warehouse decision support system, On - line Transaction Processing, and Web-based multi-tier application design, and development in oracle database.
  • He has extensive experience writing Oracle PL/SQL code including procedures, functions, triggers, and packages to support extraction, transformation and loading of source data into target tables of Federated star schema multidimensional (DWH) model.
  • In addition Confidential has experience with the full system development life cycle including requirements gathering, Analysis, process design using Erwin and Rational Rose to implement the physical ER diagram, and develop PL/SQL using Native Dynamic SQL processing such as EXECUTE IMMEDIATE to support DDL directly inside a block.
  • He performed extensive SQL TUNING of programs utilizing explain plan, auto-trace, sub-query factoring, materialize views, and analytic functions.
  • Confidential has written preproduction test scripts for Unit testing, regression tests, and user acceptance testing and also, designed development and execution of test plans using Confidential ’s Win-runner, and development of end-user documents.

EXPERTISE:

PL/SQL,ORACLE 12C, 11g, 10g, 9i, 8i, MS Access 2000, J-developer, SQL-Developer, SQL*Plus, SQL Navigator 4.5, SQL*LOADER, TOAD 9.7.2, Clear CASE, Tortoise SVN 1.7.7.2, Erwin 4.1, IBM Rational Rose and UML Design, Load runner 5.0, Winrunner, Informatica 8.6, OEL(oracle enterprise Linux), Unix, Online Analytical Processing (OLAP), Relational databases analysis, design, development, GUI design, development, Online Transaction Processing (OLTP), client/Web server systems

EXPERIENCE:

Confidential

Senior Oracle PL/SQL Developer

Responsibilities:

  • The task includes working with the business community and creating partitioned and sub-partitioned tables and creating materialized views for data replication in distributed databases in order to build custom transactional database applications.
  • He helped implement and speed-up queries by changing from complete refresh to Confidential (partition change tracking) for performance.
  • Confidential changed Materialized views queries into collections for bulk-load and forall DML to further meet the coding standardization of the project and for extraction of data from multiple upstream.
  • He is used his expertise to eliminate duplicate records using Analytical functions as a mechanism to ensure the sum outstanding profit and percentage outstanding amount is correct.

Confidential

Senior Oracle PL/SQL Developer

Responsibilities:

  • He wrote functions that with result cache option and PGA based functions to measure the performance of the modules to fetch data from the database. He performed performance tuning using DBMS PROFILER, SQL ACCESS ADVISOR and wrote robust PL/SQL using bulk load. Oracle 10g and 11g full life cycle support.
  • Extensively involved in Installation, upgrade, and performance tuning. Database design, data warehouse schema design, user management and full SDLC application, database support.
  • Actively contributed to enterprise standardization effort. Confidential worked as a freelance developer for small clients such as Confidential, an oracle developer on enhancing code improvement in oracle procedures and packages using Ref cursor to be invoked by Work Day application.
  • He wrote functions that with result cache option and PGA based functions to measure the performance of the modules in conjunction to fetch data from the database.
  • He performed performance tuning and wrote robust PL/SQL using bulk load.
  • Confidential as a senior PL/SQL developer is continuing to work on 12c re-certification of OCP (Oracle Certified Professional) to further upgrade his skills and experience as he already possesses OCP for 11g.

Confidential, Houston, TX

Senior Oracle PL/SQL Developer

Responsibilities:

  • He was responsible for writing PL/SQL procedures and packages to calculate RWA (risk weight assets), LGD (loss given default) and generate reports based on legal entity id and products that are supplied by the end-user.
  • Confidential 's other roles included the reverse-engineering of the current schema and partitioning of tables and adding new data files to existing tablespaces to increase space.
  • Also, responsible for production support of high priority code fixes for a major release and modified the SQL in procedures to enhance Front-end component.
  • Confidential, using PostgreSQL developed object, including tables, triggers, stored procedures and views to in corporate business rules in the database.
  • In Postgre database, he developed and run maintenance routines to ensure database performance.
  • He implemented new functionality to existing oracle margin-loan oracle functions, and added to calculate the loan to value ratio calculation.

Confidential, Arlington, VA

Senior Oracle PL/SQL Developer

Responsibilities:

  • Confidential reverse-engineered the MAILXML data model using SQL Developer’s data modeler tool and added 30 tables. To date, his responsibilities also include the implementation and development of releases 32.0.0, 33.0.0 application by coding/developing oracle Programs using PL/SQL which extract data from external sources such as BID (business intelligence data) and MID system for surface visibility in database designed and implemented in RAC using parallel execution.
  • In addition, Confidential enhanced and optimized the existing programs to meet optimum query performance by analyzing the execution plan and modifying code using analytical functions and sub-query factoring.
  • In the process, he created oracle scripts that create and partition objects and advanced SQL query capabilities.
  • His responsibilities included writing new procedures using oracle analytical functions and tuning existing packages to meet front-end application needs.
  • He reverse-engineered the ODS data model and made enhancements and wrote the technical requirement document to meet the business functionality.

Confidential, IL

Senior Oracle Developer/Analyst

Responsibilities:

  • In addition, Confidential created tables using the compress option to free-up data blocks, utilized the DBMS STATS.GATHER TABLE STATS procedure to gather statistics, created indexes, and analyzed those objects which then used BPEL to manipulate data mart Applications into one process.
  • Also created BIGFILE Tablespace and assisted the DBA in the development databases in gathering performance reports using AWR .
  • Other major responsibilities also included the migration of Code between all three environments.
  • He Created Unix Korn shell wrapper scripts to schedule jobs such as using the nohup command.
  • Confidential re-designed the P&L (Profit and Loss) branch of the Confidential project using Snowflake dimensional modeling and developed procedures and packages using collections (nested tables and associative arrays).Involved in user security granting and revoking privileges and roles using data dictionary views.
  • Confidential worked in OLTP supply-chain management batch processing system, created hash-partitioning to reduce contention, and implemented on-line index rebuilding to make table & index accessible for active and current transactions.
  • Also he performed unit, system, volume, regression, and UAT of the applications.
  • As customers can order an Item via IVR, web, or PTOC (prime time order capture) 24/7, as a developer for Confidential for 3 types of transactions: bank payments, bank credits, and journal vouchers, Confidential developed Oracle procedures and triggers that validate the transaction's general ledger.

Confidential, VA

Senior Oracle Developer/Analyst

Responsibilities:

  • Assisted with the roll out and support of oracle 11.5.10.2 Projects module including costing and billing not limited to functional configuration changes associated with change and enhancement requests. Confidential gathered and analyzed business user requirements.
  • He designed the logical and physical data models using Erwin 7.2. He wrote PL/SQL programs and created 65 custom tables to convert Access source files into Oracle.
  • He developed additional packages which consisted of functions and procedures to validate vendor, project, task, and expenditure name and type.
  • He used SQL*Loader to load UPS billing files to custom staging tables.
  • He executed Oracle advanced native dynamic SQL (NDS) while using collections such as associative arrays, varrays, and nested tables.
  • He used BULK COLLECT to optimize SQL statements for large tables. Confidential executed the DBMS AQ package to monitor user and exception queues.
  • Additionally he made use of the DBMS PIPE package to monitor inter-send/pipeline messages between reports and end users.
  • He wrote UNIX KORN shell scripts to automate monitoring, data loading, tuning, and user auditing activities.
  • He implemented a document; testing strategy scripts and test execution scripts for Unit, system, and UTA. Confidential performed design and code reviews to ensure all requirements were met with timely delivery of high quality products.
  • He performed SQL tuning using the “ explain plan” function and implemented hints, indexes, and re-sized buffers to resolve bottlenecks.
  • He completed unit testing on all objects he created to ensure they met user requirements.

Confidential, Dallas, TX

Oracle Developer

Responsibilities:

  • He created Oracle triggers and packages that included structured record types, table types, and ref cursors.
  • Confidential performed SQL tuning and implemented hints, table partitions, and indexes to increase performance.
  • He also utilized BULK COLLECT to fetch large volumes of data with increased efficiency. He developed UNIX shell scripts to automate job control.
  • Confidential implemented a centralized data warehouse featuring key performance indicators from PeopleSoft HR, Finance, and Supply-Chain Management modules.
  • Developed queries in ODS (operational data store) for online integration of data where he created a one-to-one Local index partitioning to achieve optimal index-only maintenance.
  • He used Oracle designer to reverse engineer the schema from an early prototype, designed an enhanced multidimensional model to support the Warehouse, and documented the mappings from the PeopleSoft source elements to the warehouse schema.
  • He developed PL/SQL code to transform and load data into the warehouse and developed UNIX shell scripts to automate the load processing.
  • He conducted performance tuning using the ALL ROWS optimizer and improved the physical data model with partitioned tables and local indexes.
  • To meet Sarbanes Oxley compliance requirements, Confidential developed a web-based reporting application used by executives to access data from the warehouse.

Hire Now