Mohammad Shibly Numan
E-mail: ***********@*****.***, Phone: +964********** (Iraq), +880**********
(Bangladesh),
Flat A1, Plot 34, Road 04, Sector 10, Uttara-1230, Dhaka, Bangladesh.
Nationality: Bangladeshi Passport: AD3932109.
PROFILE
Data Warehouse & BI professional with experience in Architecture, Data
Warehousing, Business Intelligence (BI), Data Quality and Governance. Full
Systems Development experience from planning to implementation and
operations.
Additional skills include implementation of CRM, business analysis and
facilitation and practical application of various methodologies, including:
Iterative, RAD (Rapid Application Development via prototyping), Traditional
(Waterfall), and both Inmon and Kimball Data Warehouse (DW) coupled with
strong project management. Communicate well with management, technical and
non-technical personnel. Excellent administrative, verbal and written
communication and presentation skills. Proven attention to detail and
accuracy. Demonstrated ability in leadership and organization. Oriented
toward rapid results.
CORE
QUALIFICATION
TECHNICAL
SKILLS
Skills Experience Total Last Used
Years
Telecom Billing System QC, provisioning, 1.5 2006
(BSCS) Configuration
Discoverer Desktop Report & Security Design, 2 2009
Administration & Tuning
OWB Design, Development, Admin, 2.5 2010
Performance optimization
OBIEE Design, Admin & Security 5 2013
ODI Design, Development & Admin 1.5 2013
PL/SQL, T-SQL Scripting, Tuning 8 2013
Scripting Shell (Bash & Korn), Perl 5 2013
SQL Developer Data Modeling 2 2013
SAP Crystal Report Design & Admin 3 2013
SAP BO Design & Admin 1 2013
Programming Language C, C++, JAVA 5 2010
Oracle, SQL Server Design & Administration 5 2013
PROFESSIONAL
EXPERIENCE
DWH Services Architect, IT-MIS, Jul2010 till current
Korek Telecom - Erbil, Kurdistan Region, Iraq
ETL Process development, Optimization, Tuning, new source incorporation.
Report Development, Dashboard develop & maintenance, User Creation,
Security & Privilege maintenance.
Integration with all other IT system to perform IT Audit.
Co-ordinate with Source provider to configure any new source, change
management and impact analysis from source loading to ODS transfer.
New Data Model Development, BI Physical Model, Data Mart & Campaign Data
Modeling Development.
Support to different campaign.
Metadata backup ensure - OBIEE and SAP BO Repository & report backup,
security matrix & retention policy review & update.
Daily operation maintenance, alarm follow up & exception Handling.
Revenue Assurance & fraud management system control development.
IT access, security & audit policy develop and implement: Policy
Finalization for IT Audit.
Establishment of SLA: Service level agreement establishment within the
stakeholder.
Cross Functional & ad-hoc support to others team.
Support to other projects: RAFM system (Subex), Loyalty & Campaign
Management System (Sofrecom).
Administration of the Tools:- ODI, OBIEE, SAP Crystal Report, SAP BO, SSIS,
SSRS, MS Sharepoint.
Projects:
> OCDM implementation:- (ODI+OBIEE - Oracle Exadata)
> OBIEE 11g introduction
> Churn Prediction Model : Predict the probable churned subscriber with
behavior
> Quality of Sales : new sales monitoring and sales commission
validation
> Segmentation
> Campaign management Tool
> Revenue Assurance Control : High Usage, Simbox, Spam SMS, SMS Spoof
etc.
> Live CDR processing: For CRM Tool
> Sales System: New sales system to perform the sales, define the
commission, customer information, sales performance etc.
Specialist, Enterprise System Operation, Apr2008 till Jul2010
Grameenphone Ltd - Dhaka, Bangladesh.
ETL Process development, deployment, Optimization & performance tuning.
Dashboard development, new reports development, users security monitor &
synchronize.
Daily data Quality Check, Exception Handling & Alarm follow up.
DB & OS storage, process, process flow and performance optimization.
It Audit, & data security policy introduction at DWH end and co-ordinate
for all enterprise systems.
Cross functional activities with other division &
Provide daily, Weekly, Monthly customized and adhoc reports &
analysis.Changes of current process/reports and configuration
documentation.
Adhoc support for campaign disburse.
OWB administration & maintenance, ETL process performance monitoring.
Support to other projects dependent on Data Warehouse - Sales Tracking
tool, Campaign Analysis tool etc.BI Analytics CRM Analytics & BI SFA
module.
CDR fault analysis, actively participate in CDR analysis for node
migration/ up-gradation.
Different internal stack holder (Sales, Marketing, IT, Technical, Finance)
requirement collection for process improvement, New product, Pricing,
promotional campaign/offer implementation.
Feasibility analysis, priorities establish & implementation road map setup
of the projects.
Negotiation & work with different third party/Vendors to implement the
approved projects.
Storage & H/W Forecasting for DWH system.
Backup ensure with recover plan.
Projects:
Corporate Management dashboard: Dashboard Migration from OBI to OBIEE
BI Analytics (2010), Campaign Management (2009) & Network Performance
Analytics tool.
DWH process re-engineering
IBS (Interconnect billing System) integration: Interconnect billing
differentiate from DWH system.
ETL operation in sourcing.
QC process establishment, Data QC source vs fact, fact vs rpt, dwh source
vs Revenue assurance source, DWH source vs Mediation source.
Campaign management Tool: Generate target base, qualified list, bonus
disbursement & post campaign analysis.
ERP, Interconnect, SALES & CRM
Sales tracking tool, Sales agent commission validation (Crystal project)
System Engineer, Research, Analysis & Customer Experience, Mar2007 till
Apr2008
Grameenphone Ltd - Dhaka, Bangladesh.
New control development to ensure Revenue and minimize fraud.
Data (usage, demographical, Geographical etc) analysis to ensure pro-active
positive customer experience.
Analysis the CDR to find out Gap in subscriber usage (positive/negative) or
gap in revenue generating node.
Find out the system/customer fraudulent activity and way out to fix it.
Pre-Analysis of upcoming market campaign.Service & charging quality check.
Re-rate the CDR and find the gap.
Quality check of prepaid and post paid product.
Quality check of Value added service.
Report generation of subscriber base, new activation, value added service
BSCS & HLR data reconciliation.
Third Party revenue sharing reconciliation.
Projects:
Billing system migration: Data quality & consistency check and ensuring the
interim period CDR rating and barring & unbarring.
Process development for customer satisfaction index and monitoring it on
regular basis.
Post-paid billing system QC process Automation.
HLR reconciliation process enhancement & automation.
Blackberry reconciliation (Invoice & subscriber).
Officer Service Quality Assurance, Sep2005 till Mar2007
Grameenphone Ltd - Dhaka, Bangladesh.
Daily subscription quality & payments check, notification & feedback
collection.
Weekly HLR consistency check.
Identify the new areas of quality check.
Daily payment reconciliation of post paid numbers.
Monthly Finance report generation as required by SOA404 act.
EDUCATION
Bachelor Of Engineering: Computer Science & Engineering, 2005.
Shahjalal University of Science & Technology - Sylhet, Bangladesh.
> Team Lead & Building.
> Work Under pressure.
> Commit to deadline.
> Excellent communication & presentation.
> Interpersonal relation.
> Project Management.
> Discoverer Desktop
> OBIA
> OBIEE
> OWB
> ODI
> SAP Crystal Report
> SAP BO
> SSIS
> SSRS
> Oracle, SQL Server
> Star & Multi- Star Schema, Snow Flakes etc.
> ETL, OLAP - MOLAP, ROLAP design.
> Data Cleaning, QC & Validation
> Dashboard, Report, security plan design.