We provide IT Staff Augmentation Services!

Senior Oracle Apps Developer Resume

5.00/5 (Submit Your Rating)

SUMMARY

  • Around 10 years of experience as Oracle Applications Finance/SCM/Manufacturing consultant with Technical and Functional Knowledge on Procure to Pay, Order to Cash, Receipt to Issue Cycles.
  • Extensive experience in different phases of SDLC like analyzing & Planning, designing, implementation and support for Oracle Supply Chain Management, Order Management (OM), Bills of Material (BOM), Work in Process (WIP), Manufacturing Scheduling /MRP, Warehouse Management (WMS).Purchasing (PO) along with iProcurement, Inventory (INV), Shipping Execution(WSH) and Pricing(QP).
  • Comprehensive experience in Customizing, Modification & developing of Forms, Reports using Oracle Form builder 6i & 10g, Oracle Report builder 6i & 10g and XML/Business Intelligence(BI) Publisher, Interfaces and Conversions. Experience in design, analysis, development, testing and implementation of applications in Oracle E - Business Suite R12/11i, Oracle 11g/10g, Oracle Forms 6i/10g, Oracle Reports 6i/10g, XML Publisher 5.6, Work Flow Builder 2.6, JDeveloper10g/11g OA Framework.
  • Good experience in handling different Application Object Library (AOL), sys admin & TCA Architecture.
  • Good experience in routing information according to user defined business rules using Oracle Workflow Builder.
  • Proficient working in onsite-offshore model with different teams like business users, developers, project managers, quality assurance, DBAs and Business Analysts.
  • Good Experience in preparing Technical Specification (MD70) Documents, SMTD (System maintenance & Technical Design Document), BR100, User Training Documents.
  • Strong analytical skill and problem-solving ability coupled with excellent written, verbal and inter-personnel communication skills and client facing skills.

TECHNICAL SKILLS

  • Oracle Applications 11i (11.5.9, 11.5.10, 11.5.10.2), Release 12.
  • Supply Chain Management modules like Inventory (INV), Purchasing (PO), Bills of Material (BOM), Work in Process (WIP),, Order Management (OM)
  • SQL*Plus, SQL*Loader, Business Intelligence(BI)/XML Publisher, Workflow Builder 2.6.x, Form Builder Operating System: Windows NT/XP/ 98/2000/2003/ VISTA, UNIX

PROFESSIONAL EXPERIENCE

Senior Oracle Apps Developer

Confidential

Responsibilities:

  • Worked with Business Units to define Business strategy and create a centralized reporting capability for users to perform analytical, and ad-hoc reporting for business applications and provide accurate information available to Decision Makers.
  • Gathering new requirements analyzing the existing business requirements and interacted with business users for the methodologies.
  • Worked on planplus projects,tasks and Budgets.
  • Worked on COUPA for creating suppliers.
  • Worked on COUPA Invoices,payments,COA,projects interface in Oracle EBS .
  • Worked on labor integrations and developed accounting rules on PA.
  • Worked on AR conversions.
  • Worked on AP integrations from c2fo source and COUPA,Concur,PEOPLE SOFT,Sceptre.
  • Worked on cash management process to create bank statements.
  • Worked on the integrations on Financials modules (Cash Management, AP,PA,GL).
  • Handling application deployments into DEV, Test, Performance and Production Environments.
  • Preparing BR100, MD050, TE40, TE50, CRP execution, User training and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
  • Advanced PL/SQL Developer. Extensively worked on Advanced PL/SQL Concepts, PL/SQL Tables and Record types, Collections, Bulk Collects and Bulk Binds.
  • Well versed in creating Materialized Views. Tuning and Optimizing current and new applications utilizing DBMS packages, and enhancing performance through regeneration and rebuild of indexes
  • Creation of views and a clear understanding in using Cursors for processing of data.

Environment: Oracle Applications 12.1.3 OM, PO, iProcurement, BOM, WIP, INV, ASCP, WSH, WMS, AP, AR, GL, Oracle Database 10g, Workflows, Forms10g, Reports 10g, UNIX, Appworx, XML Publisher, EDI 850, SQL*PLUS, PL/SQL Developer

Oracle Apps Developer

Confidential

Responsibilities:

  • Handling application deployments into DEV, Test, Performance and Production Environments.
  • Worked on SAP crystal reports .
  • Worked with the Business team to baseline the 'As Is' Process and derive 'To Be' flow.
  • Worked on the entire integration strategy to update it into the current AS IS system.
  • Flow Testing for SCM Modules (Oracle OM, Shipping, Advance Pricing, Quoting, AR) to make sure flow is working without any issues.
  • Worked on plsql complex scripts materialized view /ref cursors /external tables.
  • Explicit understanding in writing Packages, Stored procedures, Functions and Database Triggers using
  • SQL and PL/SQL in Real Time Experience in Performance Tuning using Explain plan and hints and Query Optimization procedures.
  • Advanced PL/SQL Developer. Extensively worked on Advanced PL/SQL Concepts, PL/SQL Tables and Record types, Collections, Bulk Collects and Bulk Binds.
  • Well versed in creating Materialized Views. Tuning and Optimizing current and new applications utilizing DBMS packages, and enhancing performance through regeneration and rebuild of indexes
  • Creation of views and a clear understanding in using Cursors for processing of data.

Environment: Oracle Applications 12.2.2 OM, PO, iProcurement, BOM, WIP, INV, ASCP, WSH, WMS, AP, AR, GL, Oracle Database 10g, Workflows, Forms10g, Reports 10g, UNIX, Appworx, XML Publisher, EDI 850, SQL*PLUS, PL/SQL Developer

Oracle SCM Technical Consultant

Confidential

Responsibilities:

  • Worked on OM interfaces like Creating Promotion in Oracle, Item Creation, Validation & adding it to Price list, Outbound interface to send Salespersons data from Oracle, Order Management Defaulting Dependencies Extension.
  • Worked on the XML Publisher reports to send Configurator Model Report in xls Format
  • Major role in developing MD70, core development and preparation of MD120 for several modules
  • Involved in analysis and development of major conversions and interfaces
  • Used SQL*Loader, UTL FILE package and External Table concepts for loading data into the database tables through an automated process.
  • Involved in Optimizing SQL queries involving large tables.
  • Extensively worked on various business flows such as Order to Cash (O2C), Procure to Pay (P2P) cycle, Fixed Asset to GL and Account Generator Workflow.
  • Functional responsibilities include: requirements gathering, functional gap analysis, application design, configuration, module setup, test script generation, writing training guides, training end users, and production support.
  • Technical responsibilities include: interfacing the Modules, identifying functional and technical gaps, estimating work, architecting system interfaces, designing custom solutions, programming, scheduling, producing, documentation and providing production support.
  • Perform technical analysis and development on multiple moderate to large projects concurrently
  • Experience in importing data from legacy systems to Oracle Applications using Oracle Interfacing, SQL LOADER, UTL FILE, Oracle packaged APIs etc.
  • Expertise in requirement analysis, system design, Data Flow Designs, support, development, testing, documentation and design reviews.
  • Expert in developing Technical design documents (MD070), Technical Test documents (TE020), Conversion (CV050) and Migration documents (MD0120).
  • Strong in Performance Tuning, UNIX shell scripting.
  • Write technical design documents for conversions, extensions, interfaces, and reports. Troubleshoot issues, including creation/follow-up of Oracle service requests (SRs).
  • Ability to handle user defined errors by developing Error-Handling Package using PL/SQL.
  • Interacted with users, fixed the bugs, developed test plans and provides daily production support.
  • Adroit in Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL TRACE, TKPROF, HINTS.
  • Excel in team collaboration, quick adaptation and problem solving with good communication skills.
  • Worked on Key Enhancements which included development of custom objects like packages, Triggers, new custom forms, modification of reports, creation of new custom Functions and creation of various new Oracle Alerts.
  • Key activities involved sizing of various enhancements from time to time.

Environment: Oracle Applications 12.2.2 OM, PO, iProcurement, BOM, WIP, INV, ASCP, WSH, WMS, AP, AR, GL, Oracle Database 10g, Workflows, Forms10g, Reports 10g, UNIX, Appworx, XML Publisher, EDI 850, SQL*PLUS, PL/SQL Developer

Oracle SCM Technical Consultant

Confidential

Responsibilities:

  • Requirements gathering for enhancements from Business Managers for R12 components. Worked with solution architects to understand the current system and impact of R12 on existing custom objects.
  • Wrote scripts for creating tables, Indexes, Grants and Synonyms and made modifications for the existing tables as per business
  • Involved in Design Reviews, Code Reviews, Coding, and Testing. Involved in the Oracle AIM methodology throughout the project.
  • Developed the Triggers for implementing the complex business rules.
  • Used Custom PL/SQL API'S for converting open AP Invoices, Suppliers, Supplier Sites, Supplier Contacts, Customers using TCA, Open Purchase Orders from legacy system (Mainframe) to Oracle Applications.
  • Worked on SQL*Loader Scripts to migrate the invoice data from the flat files and populate the staging tables before implementing auto invoice interface.
  • Developed PL/SQL procedures, functions and packages for validating the invoice data before importing it into Account Receivables interface tables.
  • Worked on Item Conversion in the INV Module.
  • Design functional specification documents for gaps identified during fit-gap analysis.
  • Coordinate with Onsite and Offshore resources to Development of Reports in BI Environment
  • Development of new Objects that includes Triggers, APIs, & subprograms for migration Project specifically for BOM, WIP, PO & INV.
  • Involved in writing registration Scripts for Application Object Library objects, also used FND LOAD to migrate object from one instance to another.
  • Create technical design specifications based on functional requirements as received from Business Analyst. Complete all technical development tasks for any programs, forms or reports as required by the functional user community.
  • Responsible for designing, (MD70), coding, testing, debug and documentation to ensure artifact can be maintained in the future.
  • Responsible for complete unit testing, like writing test scripts and record the results for each test.

Environment: Oracle Applications 11.5.8, Oracle Database R12 ERP, GL, SLA, AR, PO, BOM, WIP and AP, SQL, PL/SQL, SQL*Plus, SQL*Loader, Putty, Forms 6i & 10g, Jira system, Reports 6i & 10g, UNIX, Windows XP, Workflow 2.6.3.

Oracle SCM Technical Consultant

Confidential

Responsibilities:

  • Worked as an Onsite Application Project lead for a custom application right from the beginning, responsible for receiving the Knowledge Transition and switching over to the main support from the previous vendor.
  • Extensively worked on PL/QL, Oracle 11g Upgrade, Server Upgrades, worked on SQL Loader, concurrent programs.
  • Worked on many Oracle Forms customizations and personalization’s.
  • Worked on scripts for creating Triggers, Indexes and other PL/SQL objects.
  • Handling Post Deployment meetings and operations to ensure that all Post Deployment issues were handled and resolved quickly.
  • Worked on creating MD70s and MD50s as per client requirements.

Environment: Oracle Applications 11i, Oracle Database 9i & 10g later, OM, BOM, Inventory, PL/SQL, SQL * PLUS, PL/SQL Developer, Toad, Citrix Server, Forms 6i, Reports 6i

We'd love your feedback!