We provide IT Staff Augmentation Services!

Oracle Apps Technical Consultant Resume

SUMMARY:

  • Over 10+ years of extensive experience as Oracle Application Techno Functional Consultant in implementation, upgrade and customization of Oracle e - Business Suite Applications (R12, 11i). This includes system study, design, development, post implementation maintenance and support of Oracle EBS.
  • Extensive experience in implementation, Migration, Customization, Production and support of various modules in Oracle Applications with major focus in Order Management (OM), Advanced Pricing , Inventory (INV), Accounts Receivable (AR), Accounts Payables (AP), Purchasing (PO), Bill of Materials (BOM), Oracle Process Manufacturing (OPM), Oracle Work in Process (WIP) and Oracle ASCP, I-Procurement, General Ledger (GL),Oracle Human Resources (HRMS), Oracle Payroll Benefits.
  • Hands-on experience in Data Conversion, Data Migration, Report Generation and Developing Interfaces within several modules in Oracle Applications.
  • Technically proficient in RICEW components (Reports, Interfaces, Conversions, Extensions, Workflows).
  • Good Experience in Procure to Pay (P2P), Order to cash (O2C) life cycles and Manufacturing business flows.
  • Proficient in development of interfaces and conversion programs to integrate Oracle Applications modules to import data from various sources into Oracle Applications using PL/SQL, SQL*Loader.
  • Expert in Oracle Application Framework (OAF) applications, customization of OAF pages, extension and creation of new OAF pages in JDeveloper environment.
  • Expert in requirement gathering, design and development of custom applications in Oracle Applications Framework (OAF) environment.
  • Strong Knowledge of Application Implementation Methodology (AIM), Application object Library (AOL) implementation standards, Trading Community Architecture (TCA) and software Development Life Cycle (SDLC).
  • Expertise on designing and implementing Oracle Alerts and Lookups.
  • Fair Knowledge in customizing existing OAF Screens, forms and reports as per business needs using OAF Substitutions.
  • Experienced in Customizing Oracle Forms with Forms Personalization using Custom.pll and Zoom functionality.
  • Dexterous in Customizing Oracle reports and developing new reports by using Oracle Report 6i/10g and XML Publisher (BI Publisher).
  • Good experience in creating Custom pricing package based on the item types and order type
  • Extensive development experience and expertise extending Oracle Advanced Pricing Applications using Pricing Entities, Price Breaks, Pricing Modifiers, Pricing Contexts and Attributes and pricing APIs, also having good experience with pricing engine rules.
  • Developed new Concurrent Programs, Custom Forms, Reports and Flex Field Customizations.
  • Extensively used TCA (Trading Community Architecture) to create customers in AR.
  • Well versed with client server environment and tools like SQL*Plus, PL/SQL, SQL*Loader, Toad, Oracle*Forms, Oracle*Reports, Workflow and modified the formats using XML publisher for customizations as per client specification.
  • 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).
  • Experience in customizing oracle workflows such as the PO approval process, Order/Line Flow to send user notifications based on the business requirement.
  • Experience in customizing Approval Management Engine (AME) for i-Supplier Approval Users and Journal Import Approval Process.
  • 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.
  • Beginners experience in Cloud migration using web services in ADF.
  • Experience in using web services and SOAP UI tool.
  • Possesses strong analytical, diagnostic and troubleshooting skills and ability to lead a team in a fast-paced environment.
  • Strong work ethic and the ability to work well within a team environment.
  • Highly motivated and enthusiastic, capable of working on own initiative.
  • Good Experience in monitoring schedules through Control-M
  • Experience in interacting with end clients as well as internal managers in identifying and implementing processes of mutual consent and advantage.

TECHNICAL SKILLS:

Oracle Applications: Oracle SCM, Finance, OPM,WIP,ASCP, Oracle HRMS & Benefits

Development Tools: Oracle Developer Suite 6i/10g Forms/Reports, XML/BI Publisher, Workflow Builder, OAF, ADF, OBIEE Reports, SOAP UI, Crystal Report.

Oracle Tools: SQL*PLUS, TOAD, PL/SQL Developer, Data Loader, Web ADI Oracle, SQL Server, MS Access

Languages: SQL,PL/SQL,JAVA,VB,HTML,XML,ASP,JSP,UNIX,ASP.Net, VB.Net

Operating Systems: Windows XP/7,Windows Server 2003 and Windows NT

Other: FTP Tool, WINSCP, Putty, Unix Shell Scripts, JIRA, Control - M Scheduler, SVN, SPLUNK, Eclipse

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Apps Technical Consultant

Environment: Oracle Apps EBS R12, AP, AR, GL, Benefits, SQL, PL/SQL, Oracle Forms/Reports 10g, BI/XML Publisher, UNIX, Workflow, OAF, SQL Developer.

Responsibilities:

  • Oracle Apps Technical Consultant for support and enhancement project.
  • Implemented Approval Management Engine for Journal Import Approval Process.
  • Worked For Migrating 401K Eligible Employees Benefits from SCHWAB to Fidelity System.
  • Customized AR invoice Print report and Print Statement report based on the business requirements.
  • Worked with Oracle Support for Performance tuning in Journal Posting Program.
  • Worked on Fast Formula to validate IRS Limit
  • Worked in Performance tuning for EIS Submit Report for Financial Reconciliation.
  • Involved in the day to day activities of production support of Oracle applications environment in AP,AR and GL.
  • Involved in the analysis of the assigned support tickets including replicating the issue, analyzing the custom processes/API’s/reports/forms and updating the ticket with the appropriate information.
  • Work on the development activities as part of issue resolution. Perform Unit Testing, Migrate to next environments, assist user testing and closing the tickets.
  • Involved in the analysis of the assigned support tickets including replicating the issue, analyzing the custom processes/API’s/reports/forms and updating the ticket with the appropriate information.
  • Work on the development activities as part of issue resolution. Perform Unit Testing, Migrate to next environments, assist user testing and closing the tickets.
  • Worked on Inbound and outbound interface for black integrity project.
  • Closely worked with users to understand business needs and objectives.
  • Implemented dynamic level for approval in Journal Import posting in oracle.
  • Worked on database view for the daily extract of GL account
  • Worked on matching process and reconciliation process between oracle and third party software.
  • Personalized Supplier Page and payment process page.
  • Worked on Journal Import Interface in GL module.
  • Created new forms for validating records and to correct the failed records in interface for reprocessing in HR module.
  • Created custom templates with Data Definitions for XML Publisher and Developed reports using reports and registered as XML reports in applications.
  • Registered the Concurrent Programs, Forms, Reports and Requests Sets in AOL and System Administration.
  • Worked in Oracle backend objects like: Database Triggers, Stored Procedures, Functions, Collections, records, views, materialized views and Packages using PL/SQL.
  • Extensively worked in developing technical documents (MD70).
  • Extensively involved in SQL tuning, troubleshooting, debugging and fixing the code and made the changes according to the new business requirements.
  • Working with Oracle support through Service requests to fix Oracle standard bugs and data fixes.
  • Interacting with Business lead over weekly support status.
  • Working with Oracle support through Service requests to fix Oracle standard bugs and data fixes.

Confidential

Technical Lead / Oracle Techno-Functional Consultant

Technologies: Environment: Oracle Apps EBS R12, PO, INV, i-Procurement, i-Supplier Portal, GL, SQL, PL/SQL, Oracle Forms/Reports 10g, BI/XML Publisher, UNIX, TOAD, Workflow, OAF, SQL Developer.

Responsibilities:

  • Oracle Apps Technical Consultant for upgrade and support project.
  • Involved in the day to day activities of production support of Oracle applications environment in PO,INV, i-Procurement and i-Supplier portal.
  • Involved in the analysis of the assigned support tickets including replicating the issue, analyzing the custom processes/API’s/reports/forms and updating the ticket with the appropriate information.
  • Work on the development activities as part of issue resolution. Perform Unit Testing, Migrate to next environments, assist user testing and closing the tickets.
  • Closely worked with users to understand business needs and objectives.
  • Worked on Approval Management Engine for i-Supplier registration approval.
  • Worked on Oracle Application Framework (OAF) to develop custom solutions for i-Procurement module. Development involves analyzing MD50 (Functional Spec) and then writing MD70 (Technical Spec).
  • Worked on setting up i-supplier creation through external link.
  • Worked on rounding customizations of dollar amount in i-Procurement using OAF. This involves customizing and extending controller CO and entity object EO.
  • Worked on customizing i-Procurement Requisition and Receiving pages.
  • Personalized i-Procurement Preferences page, i-Supplier portal registration and Requisition Checkout page.
  • Personalized Oracle standard and custom Forms using oracle forms builder as per the Client requirements.
  • Expertise in implementation of procures to pay life cycle.
  • Customized forms using custom.pll to change the functionally of the standard forms.
  • Developed various Custom reports, Customized existing reports (PO Purchase Order and Releases Detail Report, Purchase Requisition Status Report) according to the functional specifications using Reports 10g and XML publisher.
  • Created custom templates with Data Definitions for XML Publisher and Developed reports using reports and registered as XML reports in applications.
  • Worked on Form Personalization in Order Management.
  • Worked on Journal Import Interface in GL module.
  • Developed a program to load external data from legacy system into PO HEADERS INTERFACE and PO LINES INTERFACE.
  • Registered the Concurrent Programs, Forms, Reports and Requests Sets in AOL and System Administration.
  • Worked in Oracle backend objects like: Database Triggers, Stored Procedures, Functions, Collections, records, views, materialized views and Packages using PL/SQL.
  • Extensively worked in developing technical documents (MD70).
  • Extensively involved in SQL tuning, troubleshooting, debugging and fixing the code and made the changes according to the new business requirements.
  • Customized PO Output for communication Report with additional data and New Template.
  • Working with Oracle support through Service requests to fix Oracle standard bugs and data fixes.
  • Interacting with Business lead over weekly support status.
  • Extensive experience in database query tuning (Explain Plan and TKPROF utility) of Reports.

Confidential

Techno Functional Consultant

Environment: Oracle Apps EBS R12, PO, INV, BOM, WIP, OM, ASCP, SQL, PL/SQL, Oracle Reports 10g, BI/XML Publisher, UNIX, TOAD, Workflow, OAF, SQL Developer.

Responsibilities:

  • 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.
  • Worked in Inventory Consolidation Report, QOH Reservation for Work order, Shop floor to WIP interface program.
  • Developed custom components for transit shipment and RMA receipt program.
  • Worked in Material Compression report in ASCP for displaying Lead time, demand and substitution of items.
  • Worked in Sales order pegging report for ASCP.
  • Worked on Inventory Consolidation Report to run for all organizations in INVENTORY.
  • Documentation using AIM methodologies of MD50’s, MD70’s .
  • Design and Development of Oracle BI Publisher Reports Layouts Templates and Data Templates using Oracle SQL and Wen Services as Data Source.
  • Extensive experience in database query tuning (Explain Plan and TKPROF utility) of Reports.
  • Involved in the day to day activities of production support of Oracle applications environment in WIP, ASCP, AP, PO, OM, INV, AR and GL.
  • Created new OAF pages which includes custom simple search committing data through EO(Entity Objects)
  • Created new OAF pages in which user can upload the input file to the server.
  • Involved in the analysis of the assigned support tickets including replicating the issue, analyzing the custom processes/API’s/reports/forms and updating the ticket with the appropriate information.
  • Work on the development activities as part of issue resolution. Perform Unit Testing, Migrate to next environments, assist user testing and closing the tickets.
  • Closely worked with users to understand business needs and objectives.
  • Personalized Oracle standard and custom Forms using oracle forms builder as per the Client requirements.
  • Customized forms using custom.pll to change the functionally of the standard forms.
  • Customized the existing forms with descriptive flex fields.
  • Developed various Custom reports, Customized existing reports (PO Purchase Order and Releases Detail Report, Purchase Requisition Status Report) according to the functional specifications using Reports 10g and XML publisher.
  • Developed custom forms to perform tasks such as creating WIP jobs, updating WIP jobs, performing WIP moves and making material transactions via writing to the appropriate interface tables and then calling the concurrent manager which processes the interface tables.
  • Created custom templates with Data Definitions for XML Publisher and Developed reports using reports and registered as XML reports in applications.
  • Designed and developed Bill and Routing Interface by dumping the data files into the BOM base tables.
  • Developed Alerts in Inventory Modules.
  • Registered the Concurrent Programs, Forms, Reports and Requests Sets in AOL and System Administration.
  • Worked in Oracle backend objects like: Database Triggers, Stored Procedures, Functions, Collections, records, views, materialized views and Packages using PL/SQL.
  • Extensively worked in developing technical documents (MD70).
  • Extensively involved in SQL tuning, troubleshooting, debugging and fixing the code and made the changes according to the new business requirements.

Confidential

Oracle Apps Technical Consultant

Environment: Oracle Apps EBS R12, PO, INV, OM, Advanced Pricing, AP, Service Contract, Install Base, SQL, PL/SQL, Oracle Reports 10g, BI/XML Publisher, UNIX, TOAD, Workflow, OAF.

Responsibilities:

  • Worked as Oracle Apps Data Migration Consultant in various Oracle Implementations,
  • Specializing in modules like OM, PO, INV, AP.
  • Worked on the development of interfaces, Data Conversions, Developing new Forms, Reports, Customizing Oracle Reports In order to Cash cycles touching various modules such as AR, PO and AP.
  • Implemented AP Invoice import through Payables Open Interface Import Program.
  • Extensive development experience and expertise creating custom pricing API's that can price single line and order level queries applying all Advanced Pricing engine rules
  • Using Oracle Advanced Pricing attribute mapping checked the attribute sourcing. Pricelist upload program will be executed for every pricing engine call.
  • Designed and created custom form using Forms 10g tool to hold lookup cross reference values between legacy system and oracle apps. Registered the form and migrated .fmx executable file to $AU TOP on forms server of client.
  • Designed and implemented custom Summary Billing Utility in AR with integration to Trading Community and Receivables. Implementation involves design and development of various objects using Oracle SQL & PLSQL, Oracle Forms, Oracle Reports and Oracle Discoverer.
  • Used FNDLOAD to migrate Concurrent Programs and Data Definitions in Various Instances.
  • Strong Knowledge in Development and Customization of Forms/Reports with sound understanding of Application Object Library (AOL).
  • Zoom feature is enabled using custom.pll, and whenever user in sales order form clicks the zoom button. Its displays the discount amount calculated for that order basing on the payment terms of the order.
  • Expertise in System Administrator responsibility to create users, responsibilities, Values Sets and Request sets.
  • Developed UNIX Shell scripts to FTP the flat file from External Server to Oracle UNIX Server location. Automated the process of encrypting and archiving.
  • Submitted Service Request with Oracle Support in different Scenarios, for providing Solutions to the Bugs identified during Production support resolved various bugs, working in collaboration with Oracle Support.
  • Developed PL/SQL scripts for validating the data and Storing the data into MTL SYSTEM ITEMS INTERFACE and then populating the base tables by running the ITEM IMPORT Interface.
  • Used Bulk Collect feature to improve performance.
  • Developed PL/SQL procedures, functions, packages, triggers to validate the data and insert the validate data into Oracle Standard interface tables.
  • Proactively tuned SQL queries & Views using Explain Plan, Hints and indexes, SQL trace.
  • Developed Custom OAF Page for Blanket Sales Agreement & Part number Mass Move Roll.
  • Developed Order Constraint, Process Constraints, Pick Release Program.
  • Developed Sales Order And Price List Form Personalization.
  • Developed and worked on various customer facing reports.
  • Extensive experience in database query tuning (Explain Plan and TKPROF utility) of Reports.

Confidential

Oracle Apps Technical Consultant

Environment: Oracle Apps EBS R12, AP, SQL, PL/SQL, Oracle Reports 10g, BI/XML Publisher, UNIX, TOAD.

Responsibilities:

  • Requirement gathering and analysis.
  • Data migration scripts for creating banking details, Reports (XML / Reports)
  • Worked in Payment Void API.
  • Email Notification for internal team and for suppliers.
  • Preparation of MD 70 Documents
  • Code review, Code backup, conducting trainings, knowledge transfer
  • Involved in Unit Testing, Integration Testing, Process Improvement unit & Production support tasks on different applications.

Confidential

Oracle Apps Technical Consultant

Environment: Oracle Apps EBS R12, OM, Custom Pricing, AR, GL, AP, SQL, PL/SQL, Oracle Reports 10g, BI/XML Publisher, UNIX, TOAD.

Responsibilities:

  • Requirement gathering and analysis.
  • Developed Complex Custom Forms, Reports (XML/Reports)
  • Performance improved setting up the profile QP: Build Attributes Mapping Options is set to active only
  • Created Custom pricing package based on the item types and order type
  • Worked in Form Personalization in AR module
  • Worked in Interfaces for creating Debit memos in AR
  • Preparation of MD 70 and CV 60 and TE 20 Documents
  • Code review, Code backup, conducting trainings, knowledge transfer
  • Involved in Unit Testing, Integration Testing, Process Improvement unit & Production support tasks on different applications.
  • Developed and worked on various customer facing reports.
  • Extensive experience in database query tuning (Explain Plan and TKPROF utility) of Reports.

Confidential

Oracle Apps Technical Consultant

Environment: Oracle Apps EBS R12, PO, INV, OM, OPM, Custom Pricing, Costing, SQL, PL/SQL, Oracle Reports 10g, BI/XML Publisher, UNIX, TOAD.

Responsibilities:

  • Requirement gathering and analysis.
  • Developed Complex Custom Forms, Reports (XML/Reports)
  • Upgrading R12 for existing 11.5.10 Tanis hq Jewellery Manufacturing project.
  • Developed numerous forms customization and forms are newly developed
  • Created numerous Conversions and Interfaces
  • Created Custom pricing package
  • Created and registered the custom reports to fulfill the user requirements
  • Written numerous procedures, packages and performed external validations as per the requirement.
  • Experience in using Standard API’s.
  • Tuning of SQL Queries, Pl/SQL procedures/ functions for maximizing performance.
  • Involved in Forms personalization and Custom.pll changes
  • Experience in MD70 and Change Request documentations
  • Creating FND Load files of Concurrent Programs, Reports and Form Personalization to go towards the Production Instance.
  • Responsible for overseeing the Quality procedures related to the project.
  • Involved in Unit Testing, Integration Testing, Process Improvement unit & Production support tasks on different applications.
  • Developed and worked on various customer facing reports.

Confidential

Technical Developer

Environment: Oracle apps 11.5.10, Oracle Forms (6i) and Oracle Reports (6i), SQL, PL/SQL, Unix, Windows-2003 (Advanced Server)

Responsibilities:

  • Requirement gathering and analysis.
  • Support and enhancing 11.5.10 Tanis hq Jewellery Manufacturing project.
  • Developed numerous forms customization and forms are newly developed
  • Created numerous Conversions and Interfaces
  • Troubleshooting the Production issues on Pricing
  • Created and registered the custom reports to fulfill the user requirements
  • Written numerous procedures, packages and performed external validations as per the requirement.
  • Experience in using Standard API’s.
  • Tuning of SQL Queries, Pl/SQL procedures/ functions for maximizing performance.
  • Experience in MD70 and Change Request documentations

Confidential

Technical Developer

Environment: ASP.NET 2005, SQL Server 2005, Crystal report

Responsibilities:

  • Analysis of the specifications provided by the clients
  • Involved in the Sales, Purchase and Production module
  • Design and Development
  • Unit testing

Hire Now