How To Create Rpd In Obiee 11g

مجموع سنوات الخبرة: 9 سنوات, 1 أشهر

مجموع سنوات الخبرة

أبريل 2020 إلى حتى الآن

Senior Business Intelligence Engineer

وجدت هذه الوظيفة عبر بيت.كوم

في Just in Time group

البلد : سريلانكا - كولومبوا 3

يناير 2019 إلى حتى الآن

Business Intelligence Specilieast

في Visual Next

البلد : سريلانكا - كولومبوا 6

يناير 2018 إلى يناير 2019

APAC Region Data Migrator

في Camso

البلد : كندا - كيبيك

• Manage SAP Enterprise Master data in Camso Asia Pacific Region Instances.
• Manage Master Data Governances in SAP
Cleansing Master data in SAP ERP Modules (MM/ SAP FI/ SAP PP) in APAC Region instances
• Develop ETL process to Migrate legacy system master data into SAP ERP
• Develop data models for SAP BO and SAP BODS
• Load data OBIEE Oracle Datawarehouse

فبراير 2016 إلى ديسمبر 2017

Oracle BI, ETL & DWH Specialist

في Synapsys (DFCC Group IT)

البلد : سريلانكا - كولومبوا 3

• Migrate OBIEE 11g to OBIEE 12C
• Upgrade ODI 12.1.2 to ODI 12.2.1
• Develop OBIEE RPD & Dashboards.
• Admin OBIEE & WebLogic Server.
• Analyze various types of Core Banking, ERP and CRM system data source, Create ETL mappings using ODI 12c to transform and load data to Oracle BI DWH as per the user's requirements.
• Develop/Testing/Deploy ETL for Customer Profitability Analysis and Cost Managements Projects.
• Design/Develop ETL mapping and BI data warehouse after the merge of core banking system in DFCC and Vardhana Bank.
• Develop automated ETL processes to load core banking system data to oracle finance.
• Developing ETL processes for real-time customer 360 analysis.
• Involved in data migrate for IFRS Project.
• Develop EDW for DFCC bank (SCD/ CDC/ DIM/ FACT/Data mart)
• Data modelling (Relational, dimensional, Star and snowflake schema) and analyze.
• Maintain meta-data in the repository, preparing mapping documents.

أكتوبر 2012 إلى يناير 2016

Revenue Analyses & Assurance Executive

في Hutchison Telecommunication Lanka

البلد : سريلانكا - كولومبوا 4

• Monitoring. • The monitoring Telecom Revenue Assurance functional takes, transactional and/or cumulated data and applies validation rules for them to detect Habit Anomalies, or compares current to historical values to detect Habit Differences. Correlation.
• Analyze product profitability and assessing the health of the products
• End to End post-paid assurance (Bill validation, roaming assurance, provisioning, etc.)
• Ensure customer satisfaction and customer retention through error free billing as the owner of a connection.
• Reviewed actual performance against forecasts and analyses reasons for variation.
• Correlation
• Correlation takes transactional or aggregated data from two different sources for the same period of time and compares the two values with absolute or relative thresholds, if the difference exceeds the threshold Problems and Alarms are generated.
• Identifies issues, analyze available data and information, and recommends changes to management.
• Provides analytical support of actual results against budget and feasibility of proposed business strategies.
• Product test.
• Validate all technical upgrades and give required go ahead for new MSC, HLR, MDSP Migration etc.
• User Acceptable testing for new product and business system.
• Business Solution Implementation and investigate.
• Implementation new business solutions for the telecommunication industries' and investigate about revenue comes from implemented solutions.
• Implementation of Business Intelligence into Telco Revenue Assurance environment. The whole project was successfully delivered (installation, configuration, development of the Repository, ETL, Requests and Dashboards).
• Data warehouse Management.
• Implement new independent data warehouse for revenue assurance department to analyze huge data set using RDBMS and also Hadoop, Develop ETL process to upload real-time data from switches, Billing System, interconnect routing system, Distributor Management system, Accounting System and various business systems to RA data warehouse, upload daily more than 20GB data.
Design, develop and maintain daily revenue statistics dashboard for RA department.

• Tasks/Analysis/Reconciliations.
• ARPU/AMPU, CDR rating, Age analysis, Churn analysis, Site wise revenue (Voice/Data), Retailers GEO analysis, Interconnect analysis,
Product profitability, Retailers commission analysis, Reload and scratch card data analysis, VAS product analysis. Campaign profitability data analysis, Products and systems user acceptance testing, HLR/VLR analysis, CRM.
• Roaming CDR analysis (TADIC base, TAP/RAP Analysis, Abnormal Behaviors Monitoring).
• IDD Analysis (IDD CDRs Rating, VOIP Analysis, IDD Routing Analysis, ILAC/OLAC Analysis, County wise analysis, Abnormal Behaviors Monitoring).
• Data CDRs Analysis (IN, SGSN, GGSN, MIH, Mediations, Billing, Bucket wise usage vs revenue, Time Slab traffic).
• Postpaid Billing Data Analysis, Postpaid bill verification.