We provide IT Staff Augmentation Services!

Pl Sql Developer Resume

SUMMARY

  • Over 8 years of IT work experience as Oracle Apps Technical Developer using Oracle Applications 11i, R12.
  • Extensively worked on page development and customization in 11i using Oracle Application Framework (OAF).
  • Proficient in implementing project in Agile/SCRUM methodology.
  • Great working experience in PL/SQL programming and integrating PL/SQL with OAF.
  • Excellent knowledge in MVC Architecture used in Oracle Application Framework (OAF).
  • Extensively worked on development of BC4J objects which include Entity Objects (EO), View Objects (VO), Application Module (AM) and Controller(CO).
  • Expertise in creating and modifying database objects like Tables, Indexes, Views, Triggers, Synonyms, Sequences, and Materialized views using SQL and PL/SQL.
  • Expert level experience on PL/SQL that includes Cursors, Ref - cursors, Procedures, Functions and Packages, Object, and Table Indexing.
  • Expertise in using user defined and system defined Exceptions for Error handling.
  • Experience in creating composite data types and collections.
  • Developing Unix Shell Scripts to Execute the Database Packages and Procedures on daily basis.
  • Worked on integration of Sales Force application with a custom application by hitting SOAP/Rest web services.
  • Migrated OAF Pages from development to production instance.
  • Excellent interaction with all levels of management, customers, development team members and stakeholders.
  • Quick to learn about new business industries and models with excellent organization skills.
  • Work under tight schedules with good problem solving skills.
  • Created mappings using expression transformations, filter transformations, join transformations, aggregate transformations and stored procedure transformations in Informatica.
  • Administrating and fulfilling the user needs.
  • Good support, development experience.
  • Expert in preparing and giving presentations.
  • Trained new joinees in OAF and PL/SQL.
  • Lead onsite team by proactively coordinating between onsite and offshore team.
  • Performed unit testing, documented unit test cases and code review for QA.
  • Understood C101 documents and created P950 documents required for development in JIRA tool.
  • Worked on AIM documents like MD 50 and MD 70 to understand technical/functional requirements and TE 20 to prepare unit test case documents.
  • Ability to understand the requirement and implement quick logical solutions.
  • Took part in scrum, sprint review, sprint retrospective and grooming sessions as part of AGILE/SCRUM environment.
  • Excellent analytical, communication skills and a good team player.
  • Working experience in Oracle EBS components, AOL objects.
  • Working experience on Application Development Framework (ADF).
  • Good working experience in Interface using APIs and SQL programming.
  • Worked on development, support and UAT issues on RICE components in R12.
  • Got trained in Oracle standard O2C cycle and P2P cycle and the modules involved like AR, AP, OM, GL, INV, SCM.
  • Working knowledge on Oracle workflows and XML publisher reports.

TECHNICAL SKILLS

Technologies: Oracle Applications 11i, R12

Programming Languages: PL/SQL, JAVA, XML

Declarative Languages: SQL

Database: Oracle 9i/10i

Database Tools: SQL Developer, TOAD

Development Tools: Jdeveloper (9i, 10g), BI Publisher, Report builder (6i, 10g), Workflow Builder, Informatica

Tracking Tool: Rally, JIRA

Environment: UNIX, shell scripting

Framework: Oracle Application Framework (OAF), Application Development Framework (ADF)

Operating System: WINDOWS XP

PROFESSIONAL EXPERIENCE

Confidential

PLSQL Developer

Responsibilities:

  • Worked with the Client team in understanding the business processes to prepare the business requirements definition document.
  • Analyzed existing DB objects PL/SQL packages, complex functions, stored procedures, packages, views and Triggers and modified them by using Oracle PL/SQL.
  • Understood existing views in third party system and created the replica of those views in new system.
  • Created custom PL/SQL procedures to read data from flat files to dump into Oracle database.
  • Worked on SQL Loader to load data from flat files obtained from various facilities every day and Created SQL Loader scripts to load data into the temporary staging tables.
  • Worked with DBA's regarding the data checks during migration, loading, creation and management of tables, indexes, table spaces etc.
  • Used cursors and collections for accessing complex data resulted from joining many tables.
  • Developed various PL/SQL procedures to automate the routine tasks and to extract and load data for month-end batch processing.
  • Plan production deployment activities, ITSM processes, raise RFCs and coordinate with various teams like DBAs, Unix Admins, Informatica Admins etc.
  • Using Informatica PowerCenter created mappings and mapplets to transform the data according to the business rules.
  • Developing Unix Shell Scripts to Execute the Database Packages and Procedures on daily basis.
  • Implemented indexes for faster retrieval of data in Weekly and Monthly Metrics reports.
  • Involved in optimizing database performance by analyzing database objects, creating indexes, creating materialized views etc.
  • Developed PL/SQL triggers and master tables for automatic creation of primary keys.

Environment: Oracle 10g/11g, PL/SQL, TOAD, SQL*Loader, UNIX Shell Scripting, MS Visio, Informatica 9.6.1

Confidential, Windsor, CT

OAF Developer & PLSQL Integrator

Responsibilities:

  • Proposed Changes to the existing Database Architecture as per the requirement.
  • Drafted a Solution Design Documentation for the proposed changes to the database.
  • Changed the Architecture of the Current data flow along with their Exception Handling methodology to handle the unprocessed Transactions.
  • Produced physical data models and suggested proper indexing that promotes fast data retrieval.
  • Designing, Developing, Enhancing and Maintaining Data warehouse Oracle ETL Processes, PL/SQL scripts, DB Procedures, DB functions, creating tables and indexes.
  • Worked on XML pages, java classes and OA pages along with BC4J components for validation and updated records to the oracle database based on the validation checks.
  • Imported/Exported different PG files using standard oracle import/export utility for modifications.
  • Developed Model Objects like Entity Objects, View Objects, and Application Modules.
  • Developed OAF Pages that calls PLSQL packages using OracleCallableStatement.
  • Developed OAF pages that employ DML operations insert, update, delete, SPEL Simplest Possible Extension Language, PPR Partial Page Rendering and Independent and Dependent LOV's.
  • Migrated OAF Page Customizations from development to production instance.
  • Interaction with the End users for the Functional requirements and Design specifications on daily basis as part of Agile methodology.
  • Tuned the SQL Queries by Statically Analyzing the Database Tables.
  • Created Stored Procedures, functions, and packages as per ETL Framework.
  • Modified Existing Packages, Procedures, Functions, and transformations as per the New Architecture.
  • Extensively performed Unit Testing with different test cases.
  • Provided Test Data to QA team for validation.
  • Created and altered database Objects as per business requirements.
  • Create a risk plan and list all the mitigations.
  • Present the change requests for approvals during post production support.
  • Took part in scrum, sprint review, sprint retrospective and grooming sessions as part of AGILE/SCRUM environment.
  • Involved in Technical Documentation, Unit test, Integration Test and writing Test plan.

Environment: Oracle Applications 11i, PL/SQL, Oracle Quoting module, Oracle Application Framework (OAF), MS Visio, Rally tool.

Confidential

OAF Developer & PLSQL Integrator

Responsibilities:

  • Analyzed the requirements and gave estimates for the task.
  • Created 8 new OAF pages.
  • Involved in the design and development of various PL/SQL and OAF components.
  • Worked on integration of Oracle sales order creation into new Confidential application.
  • Provided solutions for integration of Confidential application with Oracle Quoting module.
  • Worked on Oracle EBS interfaces to implement standard Oracle functionality for different products in Confidential application.
  • Created PLSQL interfaces to load data into Confidential application using upload functionality (only CSV files).
  • Developed ValidationReport.jsp to extract data from front end pages of Confidential application
  • Used standard Oracle APIs to create Oracle quotes from Confidential application.
  • Involved in designing and development of business rules and transactions using BC4J components.
  • Worked on different BC4J Components for customizations. Created AM (Application Module), VO (View Objects) and CO (Controllers).
  • Worked on Transient View Objects, PPR to render and hide fields based on the button event.
  • Imported/Exported different PG files using standard oracle import/export utility for modifications.
  • Created new OAF pages which includes custom simple search, advanced search, PPR (partial page rendering) select option, committing data through EO (Entity Objects)
  • Calling plsql packages from the OAF page to submit the concurrent request.
  • Creation of search pages and drill down pages for the unapproved forms for detailed information allowing to update the data in the pages and resubmit it for triggering of plsql packages.
  • Developed OAF Pages that employs the concept of SPEL for implementing the PPR (Partial Page Rendering) using JDeveloper.
  • Migrated OAF Page Customizations from development to production instance.
  • Created PL/SQL stored procedures, packages and functions to validate the inbound data of Confidential application.
  • Performed unit testing, design and code reviews as part of QA.
  • Took part in scrum, sprint review, sprint retrospective and grooming sessions as part of AGILE/SCRUM environment.
  • Prepared unit test case documents.
  • Migrated files using WINSCP FTP server.
  • Interacted with client on daily basis as part of agile methodology.
  • Provided post production go-live support.

Environment: Oracle Applications 11i, PL/SQL, Oracle Quoting module, Oracle Application Framework (OAF), MS Visio, Rally tool.

Confidential

Oracle Consultant

Responsibilities:

  • Generated SQL and PL/SQL scripts to install building database objects including: tables, views, primary keys, indexes, constraints, packages, sequences, grants, and synonyms with oracle 10gdatabase.
  • Created complex functions, stored procedures, and packages by using PL/SQL.
  • Responsible working with user groups, analyzing reported problems, performing root cause analysis and presenting alternatives to correct the problem.
  • Developed back end interfaces using PL/SQL packages, stored procedures, functions, Object Types and used Collections, Bulk Collects to improve performance by minimizing the number of context switches between the PL/SQL and SQL engines.
  • Wrote complex SQL queries using Joins, sub queries and inline views to retrieve data from the database.
  • Created Cursors, Collections, and database triggers for maintaining complex integrity constraints and implementing the complex business rules.
  • Worked on various tables to create Indexes to improve query performance.
  • Involved in Data Extraction, Transformation, and Loading (ETL process) from Source to target.
  • Developed complex triggers in reports before/after for validation of user input.
  • Performed unit testing and supported integration testing and end user testing.
  • Extensively worked on production issues with effective defect management.
  • Proactively tuned SQL queries and performed refinement of the database design leading to significant improvement of system response time and efficiency.
  • Involved in SQL tuning, PL/SQL tuning and Application tuning using EXPLAIN PLAN etc.
  • Facilitate timely approval of major milestones, approvals, and signoff.
  • Report the project status and generate milestone reports.
  • Communicate with developers, database administrators, project managers, Systems analysts and senior management about the issues that impact the project’s success.
  • Facilitate and document the post implementation results in the form of closure reports.
  • Developed the Error Logs Information for the failed transactions and procedures to handle them.
  • Responsible for data analysis, engineering, programming, implementation, and Support for the product.

Environment: s: Oracle 10g/11g, Oracle forms/reports, SQL, PL/SQL, SQL*Plus, Toad, HTML, XML.

Hire Now