Oracle PL/SQL Developer (Job ID: 1347-16GMK)


Professional Summary:



 



  • 9+ years of experience in Oracle Application systems, Oracle e-business suite (EBS); excellent technical experience with the customization & full implementation experience in Oracle Application versions from 10.7 to R12.1.3.  Advanced level/High levels of expertise in PL/SQL programming.

  • Worked in various roles as Technical Lead, Tester, Designer, and Developer which includes RICE objects – Reports, Interfaces, Conversions, Extensions, & customizations to different modules of Oracle Applications.

  • Technical experience across multiple streams in the product suite - Financials, Supply Chain Management (SCM), Oracle Process Manufacturing (OPM), Human Resources (HRMS).

  • Excellent knowledge in Software Development Life Cycle(SDLC) including Analysis, Design, Development, Implementation, Testing and Post Production issues/Support using Oracle Applications R12 (12.1.3), 11i (11.5.9,11.5.10.2) in various testing methodologies(Agile/SCRUM, Waterfall methodologies).

  • Technically experience in General Ledger (GL), Account Payable (AP), Account Receivable (AR), Purchasing (PO), Order Management (OM), Inventory (INV), Payroll and Bills of Material (BOM). 

  • Expertise in the AIM Methodology, Documentation, Configuration of Applications, Testing, End-User Training and Supporting for Oracle Financials R12/11i GL, AP, AR, CM, and FA modules.

  • Experience in preparing RD020, BP040, BP080, BR100, MD050 and TE040 documents.

  • Experience in Data mapping the external source files with oracle columns in Oracle Accounts Receivables, Accounts Payables and Fixed Assets, OM, Shipping and Purchasing modules.

  •  Worked on AOL objects and has knowledge in using FND Library.

  • Good Experience in business flows - Procure to Pay (P2P), Order to Cash (OTC) Cycles.

  • Also performed ad-hoc testing to ensure Security, Availability and Recovery Testing.

  • Experienced in defining Testing Methodologies, Test Environment, Designing Test Plans, Writing Test Cases and Test Scripts, Verifying and Validating Application Software.

  • Experience in Customization and Implementation of Oracle Reports 6i/10g.

  • Experience in development & customization of XML/BI Publisher and Discoverer Reports and data structures and setup.

  • Basic knowledge of forms and workflow.

  • Experience in Oracle Fusion- SOA.

  • Migration of legacy data to oracle using SQL*Loader and UTL_FILE utilities.



  • Experience in all phases of the system development/implementation life cycle.



  • Develop Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.

  • Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions and Materialized Views.

  • Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.



  • Experience in Oracle Packages, Dynamic SQL, Records and PL/SQL Tables.

  • Experience in DBA activities -SQL performance tuning using Cost-Based Optimization (CBO).

  • Partition large Tables using range partition and Date partition technique.

  • Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans, Table partitioning and Indexes.

  • Expertise in Dynamic SQL, Collections and Exception handling.

  • Create Shell Scripts for invoking SQL scripts and scheduled them using crontab


 

  • ID#: 106712
  • Location: Bellevue, WA , 98005

Don't Be Fooled

  • When selling, do not put your home address in your ad.
  • To avoid scams, buy and sell with people you can meet locally, in person.
  • When meeting with someone you don't know, meet in a public place. If that's not possible, have a buddy with you. Also, carry a cell phone; if you feel unsafe, you can call a trusted friend, and stay on the line.
  • Never give out financial or private information like account numbers, PayPal login, or social security number.
  • If an offer sounds too good to be true, it is. Walk away!

Look Who's Hiring!

Oracle DBA+ PL SQL developer
Bellevue, WA Vava Consulting
Oracle PL/SQL Consultant
Federal Way, WA Tech Mahindra (Americas) Inc.
Oracle Digital Business Development Specialist
Seattle, WA Oracle
Oracle Digital Business Development Specialist
Bellevue, WA Oracle
Software Developer Job
Kirkland, WA Kenworth Truck Company
iXp Intern - Business Development Job
Bellevue, WA SAP