Medhani Willarachchi Email & Phone Number

Sri Lanka

Western Province, Sri Lanka

Sri Lanka

No. 402, Level 04, "Panasonic Building" Galle Road, Colombo 3

Oracle EBS ERP : AR/AP/GL/CE/FA• Working in Oracle Applications R12 Forms, Reports, Interfaces.• Requirement gathering for the related developments.• Database structure design for tables, views, sequences, synonyms and database triggers etc. • Implementing database Integrity constraints. • Development of forms and reports (Customization & Personalization).• Custom objects development in Oracle EBS AOL.• Support & trouble shooting of the existing developed applications. (Forms, Reports & Interfaces) • Integrations of customized applications with oracle standard application modules.• Creation of SQL packages, functions & procedures. • Master-data/cutover data Uploads.• Develop oracle EBS Application Desktop Integrators(ADI). • Implementing UTL_FILE for file uploads/transfers.• Perform technical documentations. • Perform query optimization.Oracle Retail Merchandising System (RMS) • Support the Deployed Merchandising solution in the retail sector of the organisation namely as bellow o Oracle Retail Merchandising System(RMS)o Store Inventory Management(SIM)o Oracle XSTOREo Oracle Retail Integration Bus(RIB)o Relate (Loyalty & Customer)Business Intelligence Applications (Oracle Analytic Cloud/Oracle BI Publisher Enterprise/QlikSense)o Developing & publishing Retail insights including geo-analytics o Merchandising Dashboards including budgets o Sales, Inventory & Inventory ageing dashboards o Loyalty Dashboards o High level management Dashboards covering seven sectors of the company. o IT Dashboards to monitor missing transactions/data between merchandising modules. (Audit insights) o Oracle EBS financial analyses [Receivables,Payables,Cash Management,General Ledger,fixed Assets]

No: 32A, Sir Mohamed Macan Markar Mawatha, Colombo

Aitken Spence Technologies (Pvt) Ltd- General Support Practice Oracle EBS ERP : AR/AP/CE/GL/FA Client : Softlogic BPO Services (Pvt) Ltd

Aitken Spence Towers, 305 Vauxhall Street, Colombo 2, Sri Lanka

Aitken Spence Technologies (Pvt) Ltd- General Support Practice Oracle EBS ERP : INV/PO/LCM/ONT/AR/AP/CE/GL/FA Clients : KIA Motors (Pvt) Ltd  NMK Holdings (Pvt) Ltd South Asia Gateway Terminals Nation’s Trust Bank Commercial Bank PLC Softlogic BPO Services (Pvt) Ltd

106, Kensey Road, Colombo 08

Oracle EBS ERP : AR/AP/INV/FA/PO/ONT/CE/GL Working in Oracle Applications R12 Forms, Reports, Interfaces and Customizations of RICE Components in the domain of Oracle Applications E-Business Suite using personalization and customized codes. Develop & maintain Oracle Forms/Reports 6i/10g and PL/SQL functions, stored procedures and packages. Master-data/cutover data Uploads. Travel to develop systems and provide support for the customers. Provide product training for customers & the team members. Design and document process functionalities. Clients: Sri Lanka Ports Authority SWADESHI  Distilleries Company of Sri Lanka PLC/MELSTA DMS Electronics  DMS-Software Technologies  Nation Lanka Finance  DILMAH MJF Group – (AR, AP, INV, ONT, GL)  NKAR Travel House – (AR, AP) SLC – Sri Lankan Catering (AR,AP,INV) JIC PLC - Janashakthi Insurance PLC oracle forms/reports 6i to 11g upgrade feasibility study.

Colombo, Sri Lanka

Responsibilities: Development and the maintenance of Financial Information systems & co- insurance applications. (Applications/databases) Troubleshooting codes Software testing and quality assurance. Maintain and document functionality areas. Requirement gathering. troubleshooting day today user issues.

Bachelor'S Degree, Information Technology

Graduated with Honors in Information Technology (IT)

Java Training

Covered all JAVA Concepts

Human Resource Management

Certificate Course In Human Resource Management

Java Programming Language

Sun Certified JAVA Programmer, JAVA Platform 1.4

Education record

Activities and Societies: A/L - Science Stream (Biology)

Education record