Download PDF

A.S.M. Golam Sarwar

OBIEE Developer at CIMB


More than 8 year of experience in Telecom & Banking industry. Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP, dimension modeling for OLAP and OBIEE. Worked on all phases of data warehouse development life cycle, gathering requirements, implementation, and support. Experience in data analysis, debug and development of various business process in development & production environment. Strong communication and self-management skills, abilities to survive in complex and challenging environments.


Oracle Report builder
Oracle Discoverer Administrator & desktop,
Oracle Warehouse Builder 11G R2,
OBIEE (Dashboard & Answer)
OCP (Forms developer & Pl/Sql 9i),
OCA (Database administration 9i),
Advanced PL/SQL
Informatica PowerCenter

Work experience

Oct 2014Present

Senior OBIEE Developer

CIMB Bank, Malaysia

Working in Investment banking (Informatica 9.5.1 & OBIEE11g) also in Consumer banking (Informatica 8.6.1 & Oracle 10g) data warehouse. Actively participate in requirement gathering, Functional & Technical design, Develop data flow from various source (Relational database, Flat file) to target with ensuring data quality. Also Support daily ETL job to make sure the extraction & loading completed successfully. For dashboard, design on different layer (Physical, BMM, Presentation) on OBIEE repository & web catalog.

Delivered Project –

1) Investment Banking - Malaysia
2) Investment Banking - Singapore

Mar 2013Sep 2014

Customer ApplicationAnalyst (Project:AIRTEL, Bangladesh )

Huawei Telecom Integrated Solutions. (Former ITS)

Worked on TABS7(Postpaid Billing Solution) up gradation project in Airtel Bangladesh.
 Implement OPBI (Operational BI) for BSS solution to refresh OPBI    database through overnight ETL process.
 Prepare SOP for ETL maintenance & enhancement for operation team.
 Tools used in ETL
i) DMEXpress
ii) OWB (Oracle WareHouse Builder 11.2)

Apart from OPBI also implemented

 Complaint Workflow Management, for call center complaint register.
 Campaign Management System, to promote new product to customer or any sort of communication for a
certain segment of customer.
 Web Services (API), for other third party integration with TABS7 (VAS, PaymentGateway etc.)
 TBS (Telco Bill ToolBox), this application uses to create text file to generate the invoice PDF after every billing cycle.

Oct 2009Feb 2013

Customer ApplicationAnalystProject: Airtel, Nigeria(Operation & Implementation)  

 Huawei Telecom Integrated Solutions. (FormerITS)


       Implement TABS7 billing reporting portal for Airtel Nigeria which extract data from production system and refresh the reporting system through overnight ETL process, which support all kinds of postpaid revenue tracker, daily & monthly billing KPI, collection KPI, gross adds KPI, inventory KPI, adhoc reporting.

 This product developed based on below tools

  • Oracle Database 11.2
  • Oracle Warehouse Builder 11.2 including repository.
  • Fast Clone (informatica product to extract & load data)
  • Oracle Discoverer administrator & Desktop


# Process CDR more than 22 million subscriber in data warehouse to ensure the NRT(Near Real Time) data available to business for analysis.

# Manage database which is more than 20TB.

# Ensure the backup of all processed CDR(s) in data warehouse.

# Ensure the data quality in each stage of the integration.

# Analysis & requirement gathering to fit the current, prioritized goals of the organization.

# Extracted data from Oracle database and flat files, perform mappings and load it into target Oracle tables by SQL Loader & external table.

# Design Logical and Physical modeling of database.

# Design and develop data validation, load processes (ETL) using Oracle Data Warehouse Builder.

# Developed procedures, functions and database triggers using PL/SQL.

# Involved in unit testing, integration testing and system Testing.

# Set up dimensions, measures and hierarchies for providing drill down facilities for reporting environment.


# Designing, integrating, review and optimization of reporting framework (OBIEE Admin, Answer, Dashboard) and data modeling.

# Management of all front end business Intelligence and reporting applications

# Provide analytical management reports on emerging issues and any other relevant areas to facilitate business management and decision making.

# Analyzing Key Performance indices of the network with set target of Subscriber base, Revenue and identification of gaps to help in meeting the Company’s objectives.

# Developed several detail and summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using Oracle BI.

BSS Reporting - Billing System

# Ensure the successfully completion of ETL(CRM,ARM,MEDIATION,BILLING,INVENTORY etc.) process within KPI

# Develop & maintain the new process flow and mapping in ETL process using OWB to integrate with  production system.

# Configure Fast Reader tools to Extract data from the production database.

# Develop script to spool data into *.csv and send via mail automatically and FTP to different server.

# Analysis business process and prepare new report and deploy into Discoverer reporting portal for business      users.

# Generate ad-hoc reports using Oracle Discoverer 10g (Admin & Desktop).

# Perform various type of data migration from different system to production system.

# Daily & Monthly analysis on revenue, customer segmentation, recharge trend with RA(Revenue Assurance),  Credit Control, Roaming, Finance, Sales & Marketing group.

# Maintain all type of change trail in production system.


Oct 2001Dec 2006

Bsc. Hons in CSE

University of Science & Technology, Chittagong.


Feb 2008May 2008

Oracle9i Forms Developer Certified Professional (OCP)


Oracle 9i PL/SQL, Oracle 9i Forms 

Jul 2004Jun 2005

Oracle9i Database Administrator Certified Associate (OCA)


Oracle 9i Database: Fundamental I, Introduction to oracle 9i: SQL , Oracle 9i Database: Fundamental II


Project Management

Resource planning, Effort estimation,


Oracle 11g/10g


Oracle PL/SQL, Procedure, Trigger, Advanced PL/Sql


OWB 11g, Informatica