Amos Langat Email & Phone Number

Extensive Experience in Production & Support Projects for Oracle e-Business Suite Applications (R12)/Oracle fusion.Oracle Reports Development, Oracle SQL, Oracle PL/SQL, Approvals Management (AME), Workflow Development, SOA, ODI, OIC, VBCS, OTBI, Oracle Fusion• This Includes System Study, Design, Development, Post Implementation Maintenance and Support of Oracle EBS.• Worked as Techno-Functional resource in various projects.• Good Technical Knowledge In Developing Oracle XML Publisher and Oracle Reports, Forms, Interfaces, Oracle Standard API, Form Personalization’s.• Involved In Writing PL/SQL Scripts.• Sound Communication Skills, Result Oriented, Open To Learning New Technologies And Good Team Player.• Worked On Oracle fusion Absences management HCM, performances management PMS.• Worked On Oracle fusion BIP Reports, Alerts and email Bursting.• Have Hands On Experience On RICE Components.• Extensively Worked On SQL, PL/SQL, XML Reports, Oracle Alerts, And Concurrent Programs.• Functional Knowledge In Oracle Modules Such As AP, AR, PO, OM, GL, INV,HRMS• Experience In Procure To Pay, Order To Cash Cycles.• Good knowledge And Understanding Of Application Object Library (AOL) And TradingCommunity Architecture (TCA).• Application Maintenance And End User Support.• Interaction With End Users To Get The User Or Process Requirement Related To Technical Work.• Highly Quality oriented, self-driven and motivated for timely target achievements.

• 

  Oracle Application Technical Consultant

  Adk Technologies

  May 2019 - Present - Kenya

  * Environment Oracle Applications R12, SQL, PL/SQL, Forms (91), Report builder (91), XMLPublisher.* Responsibilities Worked development interfaces, Data Conversions, custom Forms, Reports.* Used Standard APIs to Define and Schedule Concurrent Programs launch ConcurrentRequests.* Involved AP Invoice, PO, OM Conversions load legacy data using SQL Loader into OracleApplications base tables.* Developed Custom Forms create AP Consolidated Invoices closing Individual AP… Show more * Environment Oracle Applications R12, SQL, PL/SQL, Forms (91), Report builder (91), XMLPublisher.* Responsibilities Worked development interfaces, Data Conversions, custom Forms, Reports.* Used Standard APIs to Define and Schedule Concurrent Programs launch ConcurrentRequests.* Involved AP Invoice, PO, OM Conversions load legacy data using SQL Loader into OracleApplications base tables.* Developed Custom Forms create AP Consolidated Invoices closing Individual AP invoices.* Developed Customer facing custom reports i.e.* External Quote pdf report.* Environment Oracle Applications 11/R12 (Order Management, PO, AP, AR), SQL, PL/SQL,Forms (61), Report builder (61), XML Publisher.* Responsibilities Production support, bug fixing, enhancements to existing reports andinterfaces, developing new reports, coordinating with business team and providingcustomized solutions, technical design, development and support business processes.* Design and development of XML Template reports for Intercompany transactions in AR, PO,OM modules.* Worked on the Bursting functionality of the XML Publisher to send the output of a concurrentprogram as an attachment to a mail id.* Worked on Kintana migration tool to migrate components from Development instances to Testinstance.* Proactively tuned SQL queries & Views using Explain Plan, Hints and indexes, SQL trace.Modified existing custom packages to add new functionality and to optimize the performance. Show less

• 

  Rongo University

  Informatics