We provide IT Staff Augmentation Services!

Oracle Ebs Technical Consultant Resume

Sunnyvale, CA

SUMMARY:

  • Over 10.6 years as Technical Consultant in Oracle E - Business Suite Applications working with BIG 5 Consulting firms Accenture (6 years) and Confidential (4 years).
  • Clear understanding and implementation knowledge on Oracle Applications R12 and 11i. Worked on Implementation, Upgrade and Support Projects.
  • Expertise in translating functional specifications into technical specifications for development of Oracle Applications R12 extensions, modifications and integrations including system interfaces, reports, data conversions and custom extensions.
  • Expertise in requirements gathering, gap analysis, user trainings and user acceptance testing.
  • Extensively worked to Order to Cash and Procure to Pay cycles - AR, AP, GL, FA, PO, OM, INV, BOM as well as HRMS
  • Extensive experience in Development of Conversions, Interfaces(Inbound/Outbound) and XML Reports in HRMS, PO, AR, AP, GL, BOM, OM, FA using Standard API’s, PL/SQL, SQL* LOADER. Experience in writing stored procedures, Packages and functions using SQL & PL/SQL.
  • Expertise in Designing CV060, MD070, TE20 and MD120, developing the generic code to meet the client’s requirements.
  • Strong knowledge on Oracle AOL concepts like Multi-Org, System and User Profiles, Executable, Concurrent Programs, Request Groups, Responsibility, Flex fields (DFF and KFF), Lookups, Menus, Functions, Value Sets, WHO Columns, Oracle Alerts and Messages.
  • Have full life cycle implementation experience and enhancement experience on Procure to Pay (P2P) and Order to Cash (O2C) business processes with good analytical skills necessary to satisfy development, testing, documentation, and change management requirements.
  • Good experience in program debugging, issue resolutions and providing effective business solutions.

TECHNICAL SKILLS:

Operating System: MSDOS, UNIX, Linux, Windows 2003/XP/ Windows Vista/Window 7

Languages: SQL, PL/SQL, UNIX Shell Scripting, RDBMS

GUI: Oracle Forms and Reports

RDBMS: ORACLE 9i/ 10g/ 11g/ 12c

ERP: Oracle Applications 11i & R12

Modules: Application Object Library, Oracle Payables, Oracle Receivables, Oracle General Ledger, Oracle Purchasing, Oracle Inventory, Oracle BOM, Oracle Alerts, Oracle Order Management, System Administrator, Oracle Incentive Compensation, Oracle HRMS

Tools: TOAD, SQL *Plus, SQL*Loader, UTL FILE, Oracle Workflow Builder 2.6, Forms Personalization, Oracle XML Publisher, Shell Scripting, JDeveloper 10g, Discoverer, WebADI, OAF

PROFESSIONAL EXPERIENCE:

Confidential, Sunnyvale, CA

Oracle EBS Technical Consultant

Responsibilities:

  • Performed System Study and Design of retro-fitting of the existing PL/SQL outbound program as per the Revenue Recognition Standard ASC 606.
  • Closely worked with users to understand business needs and objectives in AR, OM, Service Contracts and GL.
  • Working on JIRA tickets, perform the unit testing and migrating to next environments.
  • Extensive use of PL/SQL programming like Procedures, Functions, Packages and Used Dynamic SQL in stored procedures.
  • Involved in design and development of Dynamic validation logic for OM and Invoice transaction Types.
  • Involved in Design Reviews, Code Reviews and Testing.
  • Assigning the work to offshore and tracking the deliverables.
  • Documentation using AIM methodologies of MD50, MD70 and MD120.

Environment: Oracle Applications 12.1.3, Oracle Database 10g, SQL*Plus, SQL Developer, WinSCP, HPPM.

Confidential, San Jose, CA

Sr Oracle EBS Technical Consultant

Responsibilities:

  • Worked on R12 Upgrade OLP compliance Issues.
  • Worked with Oracle Integration Services Team and providing support for Oracle related issues and bug fixes.
  • Responsible for the upgrade of all the custom views used by 5 APIs (Finance API, Supplier API, Order Management API, Reference Data API, Fixed Assets API)
  • Created scripts to move views to editioned schemas and create the proper grants for the APIs to consume the views.
  • Coordinating with the Client team to provide the mapping related to the GL tables to design the proto.
  • Worked on the creation of GL Views which are being referred in the General Ledger API created by Oracle Integration and Services Team.
  • Involved in the support and upgrade of the Oracle Advanced Queues related objects. The upgrade involved the migration of a custom publish / subscribe solution built with Oracle Advanced Queue (AQ) and Oracle XDB.
  • Worked with Java developers to troubleshoot any integration issues, identify fixes and migrate the fixes to the respective environments.
  • Involved in creation of unit testing document and sharing the results.
  • Migration of the objects to other environments using HPPM tool for different Cycles.

Environment: Oracle Applications 11i, R12.2.5, Oracle Database 12c, SQL*Plus, SQL Developer, WinSCP, HPPM.

Confidential, Charlotte, NC

Sr Oracle EBS Technical Consultant

Responsibilities:

  • The scope of the project is to implement Oracle Incentive Compensation, and calculate the commission paid to the Representatives, supervisors and managers based on the sales performed with in a period.
  • Modified the custom pre-proc program which processes the billing data received from different source systems for different regions. This program basically pushes the valid data into Oracle Commission lines API tables. This involves the modification of custom package.
  • Created an Account snapshot custom program which loads the billing data received from different source systems for different regions daily. This involves creation of custom PL/SQL package using advanced PL/SQL Concepts to process the data.
  • Developed UNIX shell scripts to download the files placed under cloud directory, unzip/gunzip, encrypt and decrypt the files and loader shell scripts to load the data into required tables for processing.
  • Configured the Jobs through tidal process and make sure they run on daily basis based on the shell scripts created.
  • Understanding the business requirements, coordinating with the client team and sharing the details to the offshore team to complete the deliverables and track the status of the objects.
  • Creation of the custom AOL objects which involves of lookups, profiles, enabling of DFF’s at the lookup level as per the requirements.
  • Development and review of code. Review of deliverables - technical designs, code and technical unit testing etc. and perform peer testing .
  • Developed and designed the Documents like MD70, MD120, and TE020.

Environment: Oracle Applications 12.1.3(Oracle Incentive Compensation), Oracle Database 10g, SQL*Plus, TOAD, WinSCP, Tidal, Putty and SQL*Loader.

Confidential, Seattle, WA

Sr Oracle EBS Technical Consultant

Responsibilities:

  • Worked as an individual contributor and developing the technical solutions based on the functional requirements. Analysing business requirements, gaps and providing solutions in AR, GL, AP.
  • Provided Estimates, solution feasibility and end to end technical.
  • Worked on the performance improvement of the Custom Views required for the generation of XML Files and Extracts of GL Journals and BI Objects for Cloudtail.
  • Generation of XML Files using Java Concurrent Programs. Modifying the existing custom interface logic of AR vendor returns and Contra Cogs Invoice processing for Confidential India OU.
  • Development of different XML publisher reports related to Confidential cloud tail business based on different scenarios.
  • End to end testing of the objects designed and preparation of unit test document.
  • Enhancements on the existing code with respect to Contra cogs AR invoices and respective modifications in the XML report layouts.
  • Enhancements to the Debit Memo and Credit Memo layouts of AP Invoices.
  • Creation of the custom AOL objects which involves creation of lookups, profiles, Concurrent programs, value sets, as per the requirements.
  • Development and review of code. Review of deliverables - technical designs, code and technical unit testing etc. and perform peer testing.
  • Creation of Change management requests to migrate the objects to different environments.
  • Developed and designed the Technical Documents like MD70, MD120, and TE020.

Environment: Oracle Applications 12.1.3, AR, AP, GL, PO, Oracle Database 10g, SQL*Plus, TOAD, WinSCP, Putty, SQL*Loader, XML Publisher reports, Oracle Reports 10g

Confidential

Sr Oracle EBS Technical Lead

Responsibilities:

  • Worked as an individual contributor and developing the technical solutions based on the functional requirements.
  • Analyzed business requirements, gaps and providing solutions in AP Suppliers Conversion, AP Invoices Conversion, IBY Banks Conversion.
  • Provided Estimates, solution feasibility and end to end technical. Working on the development of Supplier conversion using standard API’s.
  • Worked on the development of Supplier Banks conversion using standard API’s.
  • Developed a generic custom view related to suppliers. This view can be used across different reports with the different layouts.
  • Designed different XML report layouts based on requirement.
  • Generated XML templates based on the requirements.
  • End to end testing of the objects designed and preparation of unit test document.
  • Created custom AOL objects which involves creation of lookups, profiles, Concurrent programs, value sets, as per the requirements.
  • Developed and designed the Technical Documents like MD70, MD120, and TE020.

Environment: Oracle Applications 12.1.3, AP, IBY, Oracle Database 10g, SQL*Plus, TOAD, WinSCP, Putty, SQL*Loader, XML Publisher reports, Oracle Reports 10g

Confidential

Sr Oracle EBS Technical Lead

Responsibilities:

  • Worked as individual contributor and leading a team of 2 members. Involved in the requirement gathering and sharing the status daily.
  • Worked completely on design and development of custom package to generate the XML output which is required for the Visa Invite/support letter generation.
  • Gathered the requirements with business and makes changes accordingly on the development and communicate the same to onshore lead.
  • Involved in daily stand up meeting to track the status of the project and deliverables.
  • Development of XML publisher reports using sub templates concept. This involves the development of 198 combinations of XML publisher templates for different countries. Involves the registration of XML publisher sub templates for different countries.
  • Involved in end to end testing for the generation of different Visa letters based on the requirements.
  • Created custom AOL objects which involves creation of lookups, profiles, value sets, as per the requirements.
  • Created kintana package requests to migrate the custom objects to different environments.
  • Developed the Technical Documentations like MD70, MD120, and TE020.

Environment: Oracle Applications 12.1.3, HRMS, Oracle Database 10g, SQL*Plus, TOAD, WinSCP, Putty, SQL*Loader, XML Publisher reports, Oracle Reports 10g, OAF

Confidential

Sr Oracle EBS Technical Systems Analyst

Responsibilities:

  • Developed the deliverables/technical solutions based on the day to day functional requirements. Analysing business requirements, gaps and providing solutions in AR, GL, AP. Provided Estimates, solution feasibility and end to end technical.
  • Worked on the enhancements of ‘Returned Vendor Returns’interface.
  • Worked on the enhancements of AR invoice processing related to ‘Vendor Returns’. The existing code imports the Invoice data and Bill to address Information. The enhancement code should include the ship to address logic and tax code derivation and specific related to European countries.
  • Worked on the enhancements of the ‘AR Invoice Import’ and ‘AR Credit Memo for Original Invoice’ related to AWS ( Confidential Web Service) functionality using Standard Interface Tables and Standard Oracle API. The existing code imports the Invoice data and for negative invoices there should be Accounting Rules applied once Create accounting program has run.
  • Worked on defect fixes related to AR functionality, Sysadmin and HRMS.
  • Net Balances -- Extensively worked on the AP and AR to pull the open balance transactions. This program is primarily to improve vendor experience and our transparency with vendors. Custom Package has been created. Basically, this program is scheduled for every 15 minutes and the volume of the invoices which has been created, updated in OFA (Oracle Finance application) will be inserted into custom table and if the data already exists in the custom table the amount gets updated if any of the payment has been done within 15 minutes of time. This way the program runs every 15 minutes and for every 24hrs also the program runs daily to avoid the missing data for that day.
  • ICR/OCR -- AP Invoice Creation Process in OFA using custom Package. This process involves the creation of invoices using Advanced Queues to process the invoice XML payload. End to end testing of the objects designed and preparation of unit test document.
  • Creation of Change management requests to migrate the objects to different environments.
  • Creation of the custom AOL objects which involves creation of lookups, profiles, value sets, concurrent programs as per the requirements.
  • Developed and designed the Technical Documents like MD70, MD120, and TE020.

Environment: Oracle Applications 12.1.3, Oracle Database 10g, SQL*Plus, TOAD, WinSCP, Putty, SQL*Loader, XML Publisher reports, Oracle Reports 10g

Confidential

Sr Oracle EBS Technical Systems Analyst

Responsibilities:

  • Developed the deliverables/technical solutions based on the functional requirements. Provided Estimates, solution feasibility and end to end technical.
  • Upgraded the custom interfaces which will import the requisitions from Purchasing Module, Asset Life adjustments from Fixed Assets.
  • Involved in the development of Bank Account conversion using Oracle standard API’s.
  • Upgraded the existing Oracle RDF reports to XML publisher reports.
  • Developed a report which pulls the details of sub ledger accounting details related to AR and AP invoices.
  • Upgraded the Discoverer reports from various modules like PO, GL, AR, FA and AP.
  • End to end testing of the objects designed and preparation of unit test document.
  • Creation of the custom AOL objects which involves creation of lookups, profiles, value sets, concurrent programs as per the requirements.
  • Developed and designed the Technical Documents like MD70, MD120, and TE020.

Environment: Oracle Applications 12.1.3, Oracle Database 10g, SQL*Plus, TOAD, WinSCP, Putty, SQL*Loader, XML Publisher reports, Oracle Reports 10g, Discoverer Reports.

Confidential

Sr Oracle EBS Technical Systems Analyst

Responsibilities:

  • Developed the deliverables/technical solutions based on the functional requirements. Provided Estimates, solution feasibility and end to end technical.
  • Developed outbound interfaces in GL to get the Accounting segments information.
  • Developed inbound interface in GL to create Journals for different sources.
  • Developed Supplier Conversion to create suppliers using standard interface tables.
  • Developed E-text based format XML Reports to print the output for EFT and Check Payments.
  • End to end testing of the objects designed and preparation of unit test document.
  • Creation of the custom AOL objects which involves creation of lookups, profiles, value sets, concurrent programs as per the requirements.
  • Developed and designed the Technical Documents like MD70, MD120, and TE020.

Environment: Oracle Applications 12.1.3, Oracle Database 10g, SQL*Plus, TOAD, WinSCP, Putty, SQL*Loader, XML Publisher reports, Oracle Reports 10g

Confidential

Oracle EBS Programmer Analyst-II

Responsibilities:

  • Developed the deliverables/technical solutions based on the day to day functional requirements.
  • Provided Estimates, solution feasibility and end to end technical.
  • Developed Supplier Conversion using standard oracle API’s.
  • Customization of Oracle standard reports which involves
  • Aging Bucket Report. AP&PO Accrual Reconciliation report
  • Open PO Report (by cost centre). Print Purchase Orders Report
  • Worked on Bill Presentment Architecture which will be used to print the AR invoice Reports
  • End to end testing of the objects designed and preparation of unit test document.
  • Creation of the custom AOL objects which involves creation of lookups, profiles, value sets, concurrent programs as per the requirements.
  • Developed and designed the Technical Documents like MD70, MD120, and TE020.

Environment: Oracle Applications 12.1.3, Oracle Database 10g, SQL*Plus, TOAD, WinSCP, Putty, SQL*Loader, XML Publisher reports, Oracle Reports 10g, BPA

Confidential

Oracle Business Technical Analyst

Responsibilities:

  • Developed the deliverables/technical solutions based on the functional requirements.
  • Developed BOM and Bill of Routings Conversion to create Bill of Material and Bill of routing using standard Interface Tables.
  • Extension to activate the newly costed items in Inventory.
  • Development of custom Net change report in Order Management.
  • Development of custom Financial AP/AR Freight report.
  • End to end testing of the objects designed and preparation of unit test document.
  • Creation of the custom AOL objects which involves creation of lookups, profiles, value sets, concurrent programs as per the requirements.
  • Developed and designed the Technical Documents like MD70, MD120, and TE020.

Environment: Oracle Applications 12.1.3, Oracle Database 10g, SQL*Plus, TOAD, WinSCP, Putty, SQL*Loader, XML Publisher reports, Oracle Reports 10g

Confidential

Oracle EBS Programmer Analyst-II

Responsibilities:

  • Developed the deliverables/technical solutions based on the functional requirements. Developed Purchase requisition, Purchase Order and Archival conversion.
  • Development of Views related to Discoverer reports. End to end testing of the objects designed and preparation of unit test document.
  • Creation of the custom AOL objects which involves creation of lookups, profiles, value sets, concurrent programs as per the requirements.
  • Developed and designed the Technical Documents like MD70, MD120, and TE020.

Environment: Oracle Applications 12.1.3, Oracle Database 10g, SQL*Plus, TOAD, WinSCP, Putty, SQL*Loader, XML Publisher reports, Oracle Reports 10g

Confidential

Oracle EBS software Trainee

Responsibilities:

  • The vision and goals of the project are to achieve the following results:
  • Streamlining of business processes. One centralized integrated system, eliminating fragmentation and duplication
  • Self Service (employees and managers) Improved reporting and data access. The Objective was to implement Oracle apps R12.
  • Developing the deliverables/technical solutions based on the functional requirements. Provided Estimates, solution feasibility and end to end technical.
  • Designed an ODI package which will involves transforming the data of the legacy system into staging tables using ODI Technology, perform all the required transformations and load the valid data into custom tables.
  • Developed Customer Conversion Using the TCA API’s which will load the data into Oracle Standard Tables.
  • Developed an AR invoice Conversion using Standard Oracle Interface Tables. Then import the invoices into oracle using standard import programs.
  • End to end testing of the objects designed and preparation of unit test document. Creation of the custom AOL objects which involves creation of lookups, profiles, value sets, concurrent programs as per the requirements.
  • Developed and designed the Technical Documents like MD70, MD120, and TE020.

Environment: Oracle Applications 12.1.3, Oracle Database 10g, SQL*Plus, TOAD, WinSCP, Putty, SQL*Loader, XML Publisher reports, Oracle Reports 10g, ODI.

Hire Now