Chandima Sirisoma

Software Engineer @ Salama Insurance

About

Professional Summary: An accomplished Data Engineer, Oracle APPS DBA, Senior Software Engineer, and Business Intelligence Specialist with over 12 years of experience in developing ERP solutions using Oracle and Java technologies. Extensive experience working on diverse projects for both government and private sector clients in the UAE and Sri Lanka. Areas of Specialization and Experience: Proficient in business intelligence tools such as Oracle BI Analytics, Tableau, QlikView, and Alteryx. Skilled in analytics, KPI development, and logic implementation. Expertise in Oracle database technologies (19C, 12C, 11G) and tools including OEM, Toad, Oracle Data Integrator (ODI), Data Guard, RMAN, Security, Auditing, and Disaster recovery (DR). Experienced in managing Oracle WebLogic Server 11g, and 12C. Proficient in advanced SQL and PL/SQL optimization and tuning, utilizing tools like Oracle Tuning Advisor, ADDM/AWR, ASH reports in OEM, and Toad. Skilled in Oracle development technologies including PL/SQL programming, Data modeling, SQL, Oracle Discoverer, Oracle Developer (12C, 11g, and 10g for Forms and Reports), SQL*Plus, Oracle SQL Developer. Expertise in developing requirement specifications, user training, and conducting demonstrations. Extensive experience in ERP systems covering modules such as Finance, Insurance Management Systems (GT, HT, FT, RI), HR & Payroll, Inventory, and Purchasing. Major Projects in the Last 5 Years: Lead Oracle Cloud migration projects involving Oracle Database, Application Server, Oracle BI Analytics, Oracle Data Integrator (ODI), and Oracle Data Warehouse. Lead the integration of medical insured data with SlashData at SALAMA Insurance. Lead business integrations for motor and medical insurance Shory Business Integrations at SALAMA Insurance. IFRS 17 Financial Reporting Implementation at SALAMA Insurance in consultation with Willis Towers Watson (WTW). CBUAE & IA Policy and Claims Integration Project at SALAMA Insurance Oracle Upgrade Projects: Oracle Cloud Data Center Migration (WebLogic Server, API & Database) Upgrading Oracle DB from 12C - 19C, Oracle WebLogic from 11g - 12C, and Oracle D2K from 11g - 12C as part of Data Center Migration Project (Etisalat DC to BIOS DC). Upgrading Oracle Database from 11g - 12C, Oracle App Server from 10g to WebLogic Server 11g, and Oracle D2K from 11g - 12C. Business Intelligence Architecture Implementation at SALAMA: Implemented BI architecture using Tableau, Oracle Data Warehouse, ETL, and Alteryx. Led VAT implementation for General Takaful, Health Takaful, and Finance modules.

Country

United Arab Emirates

City

Dubai

Industry

Computer Software

Skill

Machine Learning, Cloud Computing, Data Visualization and Warehousing, Deep Learning, Security Engineering and Compliance, Robotics, Java, Java Enterprise Edition, Struts, Oracle, Oracle PL/SQL Development, JSP, SQL, PL/SQL, Hibernate, Oracle Application Server, JBoss Application Server, MySQL, PHP, Web Logic

Experience

Software Engineer

Salama Insurance

2014-2 - Present · 12 yrs 8 mos

Dubai

Project: Insurance Management System - ORACLE Platform : Oracle PL/SQL, Oracle Developer 11g and 10g, Oracle 10g Application Server, Weblogic Application Server, Oracle 11g R2 Database, Toad 10.2, Oracle Discoverer, Quest SQL Optimizer, Oracle Tuning advisor, Java Technologies Size: 6 Members Scope/Details of Project: Maintenance, Enhancement and Development of Insurance Management System for SALAMA insurance company, which has developed by OPTIMIZA Jordan. The System includes all Insurance Modules (Motor, Non-Motor, Medical, and Re-Insurance etc.), Account (GL, AP, and AR), In-housed developed Inventory, Purchasing and MISC Module. Responsibilities: • Analysis of the requirement and system enhancements, handling change requests from users and building requirement spec • Coordinate development activities, bug reporting and enhancement with vendors and Coordinate testing activities, End User support and training users • Maintenance and Administration of Oracle Database 11g R2, Oracle Application Server 10g and Oracle Weblogic Server 11g • Development of database triggers, packages, functions & procedures in Oracle database 11g R2 • Fine tuning database relying on alert log, AWR, ADDM & AWR reports back up and repair of the database • Tuning and Optimizing the SQL & PL/SQL using looking after Quest SQL Optimizer, Oracle Tuning advisor

Software Engineer

Department of Presidents Affaires, Abu Dhabi, UAE

2011-3 - 2014-1 · 2 yrs 11 mos

Dubai, UAE

Oracle ERP System Client : Department of Presidents Affaires, Abu Dhabi, UAE Platform : Oracle PL/SQL, Oracle Developer 11g and 10g, Oracle 10g Application Server, Weblogic Application Server, Oracle 11g R2 Database, Toad 10.2, Oracle Discoverer, Quest SQL Optimizer, Oracle Tuning advisor, Java Technologies Duration : 2 Years and 9 Months Size : 8 Members Scope/Details of project : Enterprise Resource Planning System for Department of Presidents Affaires to manage all the Projects and Palaces in UAE and Oversees, DPA Stores, and DPA Employees etc. ERP system includes Account (GL, AP, and AR), Inventory, Purchasing, HR, Payroll, Projects and MISC Module. Responsibilities : • Development of the system based on the functional model (PL/SQL development) • System study & analysis, handling change requests from users and building requirement spec and flow charts • Build UML diagrams and Database modeling based on UML diagrams • Development of database triggers, packages, functions & procedures in Oracle database 11g R2 (Using SQL Developer/ Oracle Developer 11g or 10g / Toad for Oracle 10.6) • Fine tuning database relying on alert log, AWR, ADDM & AWR reports back up and repair of the database • Tuning and Optimizing the SQL & PL/SQL using looking after Quest SQL Optimizer, Oracle Tuning advisor by looking after top SQL and top PL/SQL from ASH reports • System user & role management for various modules • End User support and training users