We provide IT Staff Augmentation Services!

Senior Techno Functional Consultant Resume

0/5 (Submit Your Rating)

Palo Alto, CA

SUMMARY

  • 10+ years of experience in implementation and Customization of projects in Oracle Applications E - Business Suite 11i/R12 (EBS).
  • Experienced in Developing, Customizing and Implementation of Oracle Application various modules like Purchasing, Account Payables, Account Receivables, General Ledger, Order Management, Inventory, Bills of Materials, Advanced Pricing, Core HR and Oracle Product Data Hub.
  • Experienced in Development of Inbound and Outbound Interfaces to load the data from legacy system to Oracle Application using PL/SQL, SQL* Loader and UTL FILE package.
  • Strong experienced in developing database objects like Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
  • Good Experienced in development of RICE components and XML publisher reports.
  • Experienced on Development and customization of OAF pages.
  • Good functional knowledge on Procure to Pay (P2P) and Order to Cash cycles (O2C).
  • Experienced in System Administration and Application Developer (AOL) responsibilities such as Creation of Concurrent Programs, Executable, and registration of Forms/Reports wif Oracle Applications, Creating Messages, Value Sets and Lookups.
  • Having knowledge on Workflow, Web ADI Process and SOA.
  • Expertise experience in preparation of MD70, MD120 and TE020 documents using AIM methodology.
  • Experienced in providing as technical designing solutions for EBS projects and worked on EBS R12, 11.5.10 implementation and support projects.
  • Experience in working wif tools like HP PPM, Kintana, Vault, and Perforce.

TECHNICAL SKILLS

ERP: Oracle Applications 11i and R12

Modules: PO, AP, AR, GL, OM, INV, BOM, Core HR, CM, FA and PDH/PIM

Languages: SQL,PL/SQL

Database: Oracle 9i/10g/11g

Operating System: Unix, Linux, Windows

Oracle Tools: Toad for Oracle 10g, Reports 6i/10g,Forms 6i/10g, XML publisher, Discoverer, SQL*Loader

Other Tools: Perforce, PPM, Vault

PROFESSIONAL EXPERIENCE

Confidential, Palo Alto, CA

Senior Techno Functional Consultant

Environment: EBS 11i and R12 (11.5.10.2 and 12.1.3)

Responsibilities:

  • Developed inbound interfaces to load the ITEM, BOM, Price List, Cross Reference, Phantom and Phantom Categories data from R12 instance to 11i target instance
  • Developed an interface program in Core HR module to create/update the Employee using API’s and assign the assignments (R12).
  • Developed process to Auto derivation of Revenue Attributes based on the rules defined in lookup.
  • Coordination wif Functional Team and users for Gathering requirements, analyzing, solution design & deliverables.
  • Responsible for updating of BOM components to propagate the BOM data into child organizations through API’s
  • Interacting/Coordinating wif other technical teams on objects delivery and issue resolution.
  • Worked on updating of Price list value through API’s
  • Developed “utility package” which will sends the success/failure individual E-mail notification to user upon publish of CO for each TAB.
  • Creation of deployment scripts and responsible for raising deployment requests.

Confidential, Mountain View, CA

Senior Techno Functional

Environment: Oracle Apps 11i (11.5.10.2)

Responsibilities:

  • Coordination wif Functional Team and Client Key users for Gathering requirements, analyzing, solution design & deliverables.
  • Worked on development and modification of XML/BI Publisher, Form Personalization, Interfaces, Conversions, Customization of Standard PL /SQL Programs, AOL, OM & SYS Admin Tasks.
  • Performance tuning of PL/SQL programs, forms and reports.
  • Designing, development and providing support of various interfaces, Extensions, and reports involving Order Management, AR, Service Contracts and Install Base.
  • Development of new enhancements as and when need arises from the business and proficient in Post-production activities.
  • Build and maintain repository for deliverables & business development documents.

Confidential

Senior Techno Functional

Environment: Oracle Apps 11i (11.5.10.2)

Responsibilities:

  • Developed an interface to load the files provided by Bank for the types of payments (Bank Slip, Direct Deposit and TEF) into oracle Apps and perform reconciliation through the all the lines of the files (HL - Main Program Cash Management)
  • Developed an outbound interface (HL Trintech Subledger Extract) which will extract the data from AR, AP and Inventory Subledger balances AS OF date.
  • Developed HL Trintech Extract GL Balance program to extract all active/inactive balance sheet accounts.
  • Defining Concurrent Programs and Executable.
  • Responsible for creating lookup values and value sets.
  • Developed Sql Scripts to Resolve the Business Issues.
  • Creation of Procedures, Packages and triggers as per requirement.
  • Developed a program to generate Warning and Hold letter in FRSS process sends Hold or warning letter to Distributor mentioning that reached limit set by Tax authority.
  • Developed a new concurrent program (XXHL Invoice and Receipt Write-off) to automate the Invoice and Receipt Write-Off process.

Confidential

Senior Techno Functional

Environment: Oracle Apps 11i (11.5.10.2)

Responsibilities:

  • Developed HL Paraguay Sales VAT Report which includes information about all sales invoices.
  • Developed XHL Paraguay Whit holding Tax Certificate which prints the VAT Wifholding tax information on pre-formatted layout.
  • Customization of Aging-7 Buckets-By Account.
  • Developed HL Fixed Assets Report.
  • Developed HL Project Cost Details wif Expenditure Item Data.
  • Defining Concurrent Programs and Executable.

Confidential

Senior Techno Functional

Environment: Oracle Apps 11i (11.5.10.2) and R12 (12.1.1)

Responsibilities:

  • Developed a program to extract the data from both Applications 11i and R12 applications by using DB link.
  • Developed HL Transfer Profit 11i Monthly Extract program to calculate TP for the month period.
  • Developed HL Transfer Profit R12 Seller Monthly Extract program to calculate TP for the month period (seller in R12) tan FTP the file to Hyperion Server.
  • Defining Concurrent Programs and Executable.
  • Involved in the client meetings and coordinating wif team.
  • Preparation of Technical documentation like MD120, etc.
  • Involved in developing User Requested CMR’s (Change Module Requests).
  • Developed Sql Scripts to Resolve the Business Issues.
  • Preparation of Migration Documents to register the objects from one instance other.
  • Involved in Implementation of Turkey Localization patch.

Confidential

Responsibilities:

  • Developed document sequence for the PO and PR standard forms.
  • Developed PO Interface to transfer the data from Legacy system to Oracle Apps.
  • Registration of custom tables and concurrent programs.
  • Creation of Value Sets in various modules of application.
  • Preparation of sql*loader scripts.
  • Involved in client meetings.
  • Creation of Procedures, Packages and triggers as per requirement.
  • Developed reports in PO and Inventory module.
  • Developed Item status Report for making PR or PO (Item re-order Report).
  • Customization of Purchasing Order and Purchase Requisition Order Reports.
  • Customized the Purchase order number (Document Sequence) in Oracle Standard Forms (PO and PR) as per the client requirement by using Procedure.
  • Validations for Item and its category, Item and Organization through the Form personalization.
  • Developed Standard Purchase Order Open Interface to upload the PO data from legacy system into Oracle Apps Base tables.
  • Developed PL/SQL Procedure to update the default Buyer details for the Item in Base tables based on Item and Item category from flat file.
  • Developed an Outbound interface program to transfer the data from oracle AP base tables into the flat file by using UTL FILE Package.

Confidential

Responsibilities:

  • Developed Reports in Order Management and Receivables Module.
  • Preparing Technical Documents.
  • Preparing Unit Test Scripts.
  • Registration of reports using AOL script.
  • Responsible for preparing procedures, functions, packages as per requirements.
  • Developed Prepayment Invoice report.
  • Developed Purchase order report.
  • Customized Receipts report against the Purchase order.
  • Developed an Outbound interface program to transfer the data from oracle AP base tables into the flat file by using UTL FILE Package.
  • Developed Purchase Requisition open interface to load the requisitions into Oracle Applications.
  • Developed new forms by using TEMPLETE.fmb
  • Customized Oracle standard purchase order form and implemented ZOOM functionality to call another form.

Confidential

Responsibilities:

  • Worked on RICE components development and customization.
  • Customization of Reports as per the client requirement.
  • Preparation of AIM documents preparation.
  • Customization and development of XML Reports and programs.
  • Development and Customization of Forms and Reports as per the client requirement.
  • Involved in unit Testing and preparation of test cases.
  • Attended daily calls and weekly calls and resolved issues.
  • Developing inbound interface as per the client requirement.
  • Doing feasibility analysis and preparing technical design documents MD-070
  • Define Concurrent program, Request Sets and Executable
  • Writing SQL*Loader Scripts to create CTL files to load the data into oracle base tables.
  • Involved in developing PLSQL reports.
  • Developed DB Objects like Tables, Views, Synonyms, and Sequences.

We'd love your feedback!