فرحان حسين

Senior Manager - Business/Customer Analytics
• Managing multiple resources spanning data integration, visualization and analytics with key objectives of monetizing enterprise dataset through revenue stimulation, churn mitigation, sales performance and fraud analytics.
• Defining and implementing strategy of empowering business users by introducing a self-service platform inclusive of both business-oriented data model and intent-driven BI/Analytics layers.
• Leveraging Pay TV operator’s datasets to facilitate analytical customer relationship management in particular delivering customer value analysis and process improvement covering payment optimization, inventory and agent placement.
• Responsible for phased migration of on premise IBM Netezza DWH to Microsoft’s cloud-based Azure platforms: SQL DWH, Analysis service, Power BI. Establishing and executing roadmap ensuring business continuity.
• Delivering regular actionable insights to understand customer patterns, viewership trends, growth opportunities, product performance, and profiling at each stage of customer journey: acquisition, growth, churn, winback.
• Developing and managing a comprehensive SMS and email marketing campaigns roadmap in line with commercial, brand, product objectives. Ensuring all campaigns are monitored, measured and ROI reported.
• Implementation of “Churn Prediction” and “Behavior Segmentation” analytical models built on SAS platform for HVC customer segments in established markets. Conducting econometric and statistical analysis of credit card payments to optimize collection processes.
• Utilizing Netezza’s analytical modules to deliver improved online/digital/STB/OTT viewership experience through implementation of “Recommendation Engine” analytical model, content marketing, plus key KPI forecasts.
• Working cross-functionally with Technology, Sales, Inventory, Retention, Digital teams to ensure optimization of data hygiene, compliance and process development.

• Project management for a green field DWH/BI implementation involving 2 Vendors and 1 System Integrator for both Operational reporting and Management insights.
• Coordinating closely with Business stakeholders, IT Director, Technology Project Management Office, Group IT and other domain experts to manage project stream, promote best practices, sharing expertise, and devising workarounds.
• Best in breed BI architecture selection of: Greenplum DCA, Informatica Powercenter, Business Objects, and SAS Enterprise Miner/Analytics Pro.
• Utilizing TM Forum SID-compliant Pivotal’s Logical Telecom Data Model as starter base.
• Covering all phases of a BI life cycle implementation, including blueprinting, gap analysis, mapping, prototypes, design, configuration, testing, go-live, user training and post production support.
• Utilizing DWH/BI domain knowledge and experience including Data architecture, Data integration, BI framework, and Data mining.
• Designing Base, Analytical, and Metadata layers that can take large volumes of data and rapidly generate meaningful reports and actionable insights/results.
• Documented requirements and functional specifications covering areas of Sales, Distribution, Marketing, CVM, Wholesale, Roaming, B2B, Customer Experience, Contact Center, Finance, Revenue Assurance and Corporate Strategy.
• Mapping of requirements to Software and Data source components including Huawei NGBSS (CRM, CBS, IPCC, BICP), NSN, and VAS platforms.
• Establishing and executing multi-phase roadmap to meet both immediate informational needs plus cultivating long term strategic BI goals inclusive of Business Performance Monitoring, Analytics, and Geo-Marketing.
• Conducting Geospatial analysis through PostGis2.0, plotting of sales channels, sites, utilization, market share over Myanmar townships geometries. Facilitating Geo-Marketing analysis and visualization using KML overlaying business datasets on SAP BO maps.
• Setting up Data Quality Framework processes covering functions of: data profiling, cleansing, standardization, enrichment and timeliness.
• Leveraging PostgreSQL strengths and best practice guidelines for an efficient and robust implementation.
• Responsible for managing and building BI team inclusive of both expatriate and local resources.

Client: Saudi Telecom Company, Riyadh, KSA www.stc.com.sa
Senior Solution Consultant / Manager (Data Warehouse, Business Intelligence, Customer Analytics)
• Implementing Customer Value Management enablers into key business processes and activities to align with overall Enterprise Strategy.
• CVM strategy and initiatives for segments of: Newcomer on-boarding, Base Retention, High Value Customer Growth (Cross/Up Sell) etc.
• Comprehensive assessment of data capabilities. Developing detailed roadmap & implementation plan to leverage data for decision making
• Working closely with business users (CXO level etc) on requirements definition, support and problem solving.
• Leading and managing local analytical and reporting infrastructure teams to meet enterprise goals ensuring operational and analytical data warehouses are able to support all business requirements.
• Single point of contact for information needs and development. Managing, conducting & finalizing UAT/BAT plans and SLAs.
• Assessment of Data Quality and implementation of Master Data Management principles by establishing controlled processes to improve data accuracy, reliability, relevancy, consistency and availability. Single unified customer view across lines of business.
• Reviewing existing EDWH ETL information flow methodologies & recommending data integration best practices into Teradata cLDM layer.
• Mapping of source to target databases including documentation of transformation rules, applying industry standard modeling techniques. Developing logical and physical Data models that document source data from multiple sources.
• Designing & developing optimized datamarts in Teradata RDBMS v13 covering pertinent subject areas inclusive of subscriber usage and revenue, behavior segmentation, sales performance, network usage, churn management, location based & social network analysis etc.
• Building and designing dashboards and scorecards with KPIs broken down by Telco business dimensions.
• Utilizing Teradata v13 & DataStage ETL utilities for datamart development. FastLoad, MultiLoad, FastExport, BTEQ, Advanced SQL.
• Using Business Objects and Microstrategy for automated information dissemination over iPad, Web Portal Dashboards, Email and SMS.
• Implementation of automated analytical scoring models for: churn prediction, best next product offer etc; customer profiling through behavior & value segmentation; and white-list generation for BTL, ATL, tailored customer focused campaigns.
• Designing and developing automated Campaign performance monitoring infrastructure for marketing analysis.
• Translating client needs into business results. Developing and presenting solutions / recommendations to client.

Performed roles as both Manager as well as Lead Developer & Administrator for the Telco Business IT unit of KOREK Telecom (2.5G).
• Managing teams of cross departmental employees (Data Warehouse & Business Intelligence, Billing & Charging, Interconnect, Fraud).
• Hands-on customer facing role in defining end-to-end solution including metadata, ETL & BI architecture.
• Designing, developing, administering and maintaining ORACLE 11g R1 based Enterprise Telecom Data Warehouse on a SUN M4000 platform (4 dual core) and IBM DS5020 Storage (14TB).
• Designing/creating Published and OLAP reports for BI analysis on Crystal Reports 2008 and OBIEE 11g servers on Windows 2008 platform.
• Performing technical role of DBA: Installation, Configuration, Maintenance, Capacity Planning, Upgrade/Patching, Recovery/Backups (RMAN & Data Pump), Tuning, Security, Policies, Roles & Audits.
• Database developer/modeler/architect using latest ORACLE 11g stack toolset. Optimized DWH design to meet performance metrics & business objectives (Multi-dimensional modeling, PL/SQL procedures/packages/functions/types, Summary tables/MVs/Cubes, Indexing (Bitmap, Function-based), Dynamic Partitioning, Compression, Bulk Processing, Advanced SQL, Gateways, Parallel Processing, RPD Repository Design).
• Using OWB 11g (w/ UNIX shell scripting, PERL, JAVA sub-modules, Workflow processes) for ETL; and ASM for storage management.
• Cube development using AWM 11g: stored/calculated Revenue and Usage measures with Time, Region, Product, Profile dimensions.
• Near real-time ETL of OLTP data sources inclusive of Sybase, MS-SQL, flat file, and ORACLE platforms.
• Automated Reports delivered over Email, SMS, Web-portals. Performing roles of Crystal Reports 2008 and OBIEE 11g Server Admin.
• Developing Fraud Management System (FMS) automated anti-Fraud processes to counter existing revenue leakages (Gray-route/VOIP, Voucher, FOC) using conventional pattern analysis techniques and comparative CDR reconciliations.

Performing roles as both a developer and manager for an internal team of 4 junior Data Warehouse developers plus external 2-member system administration team (ZTE) to design, develop and maintain Enterprise Data Warehouse. Responsibilities include:
• Developing and maintaining data marts in Oracle 10g on IBM AIX 5.3 platform with 1TB storage serving 12 operational sources with historical summary data retention of 24 months.
• Using ORACLE 10g OWB as ETL tool to import OLTP data sources: CRM, MSC CDRs, IN CDRs, TAP CDRs, SMSC CDRs, NSS/BSS KPI/counters etc.
• Using relational + multi-dimensional data modeling skill set and experience.
• Using ORACLE developer toolset knowledge and experience (PL/SQL, packages, materialized views, triggers, partitions, indexes, sequences, analytical SQL).
• Using COGNOS Transformer tool for Powerplay Cubes modeling and development.
• Development of a common web portal using COGNOS 7 Powerplay Enterprise Server (PPWEB) to provide one-stop secured and reliable access to information in the Enterprise Data Warehouse for OLAP analysis, reporting and ad-hoc querying.
• Using extensive Telecom business data and logic experience to serve all inclusive departments: Revenue Assurance, QoS/KPI, Fraud, Sales, Marketing, Core-Network, VAS, Finance etc.
• Working closely with business leaders/analysts to ensure consistent and accurate reporting along prevalent business dimensions.
• Maintaining documentation of operating procedures, application designs and user guides.
• Providing continuous end-customer support and training in information and reporting.
• Assisting with mentoring and coaching team members.

Employed as a contractor for Afghanistan’s leading Telco operator to manage two teams of 5-members each responsible for designing, developing and maintaining Enterprise Data Warehouse and functionality-specific Application/Web tools:
• Managed & developed core components of a fully redundant EDW logical/physical architecture in Oracle 9i on a 12 dual-core SPARC SunOS platform with EMC DMX1000(20TB) as external storage serving 25 operational sources with historical data retention of 18 mon.
• Maintained database: backup/recovery (RMAN), partition, optimization, performance, security, redundancy processes.
• Complete DW development lifecycle design/implementation: Requirement Analysis, Data Modeling, ETL, & Report Development.
• Designed/developed functional focused data marts, materialized views & dimensions w/ hierarchies within the overall EDW model for BI analysis for varying departments: Business, Finance, VAS, Marketing, Revenue Assurance, Billing.
• Developed complex ETL procedures mining various structured, unstructured, and semi-structured data sources like MS SQL, Oracle, XML, ASN.1, flat files from varying systems. Customized automated ETL, Metadata processes developed in PERL, PL/SQL (packages, procedures, functions), Unix Shell, Advanced SQL-Loader tools.
• Liaised with Senior Management and Business Analysts to develop multitude of low to high-level business reports.
• Used main stream reporting tools like Crystal Reports, Business Objects, EXCEL using Advanced/Analytical SQL queries.
• Comprehensive understanding of business and technology.
• Developed: ASN.1 to text/XML decoders in C++.
• Managed & developed major Web/Windows Application projects: Intranet, IN/HLR provisioning, Sales tools on .NET/MS-SQL platforms.
• Designed/developed automated core processes performing interval-based statistical analysis of CDRs/SS7 xDRs to successfully eradicate SIMBOX operators resulting in increase of international incoming revenue of more than 60%.

Performed role as Product Support Engineer for a UK based International company specializing in 2G/3G Radio Planning, Network Optimization and Statistical Analysis products for its Gulf, South-Asian, African and Soviet-bloc customers. Responsibilities included:
• Providing technical software support for AIRCOM Enterprise Suite (1st and 2nd line to customers). Enterprise Suite included industry recognized toolset: ASSET 3g, OPTIMA, CONNECT, DIRECT, RANOPT, and WEBWIZARD.
• Liaising with customers on a regular basis, logging & interfacing with development team for quick resolution of defects.
• On-site installation and support, locally and internationally.
• Providing customer training and demonstration to current plus potential customers.
• Performing system testing and acceptance testing of software tools.
• Utilizing GSM, GPRS, UMTS radio planning/optimization knowledge and experience.
• Utilizing Oracle DBA, SQL, & PL/SQL experience.
• Utilizing IT networking experience; installing VPN-based CITRIX solutions.
• Developing customized 2G/3G KPI reports.
• Developing 'Power Tools' in Visual C#.net to convert customer specific data to product specific.

Client: G-Tel Wireless - Permanent Senior Web Developer / Graphics Designer / E-Marketing
Designed, developed and maintained E-commerce websites (Retail and Wholesale) for a Cellular company:
• Developed customized front-end pages & extensible shopping cart using JavaScript and PHP scripts.
• Designed & developed an extensible online inventory SQL Relational Database in MySQL.
• Performed role as a Sales Rep. for company’s product line. E-Marketed products through email flyers, Opt-in lists, and building customer relations over the Internet.
• Responsible for database integrity and data updates. Centralized database to support sister websites.
• Used Adobe Photoshop/ ImageReady, CorelDraw, and Flash for site graphics (static + animation).
• Optimized websites to improve site rankings on Yahoo, Google, MSN and other SEs for thousands of keywords.
• Developed an easy-to-use customized Customer email application in Visual C#.net for marketing department.
• In-charge for daily operations, maintenance & marketing.
• Provided Product, Customer, and Website statistical reports to marketing department.
• Managed a three-member team for website maintenance and support.
• Increased sales by 70%.
Also, performed as a Network administrator & PC Support for company LAN. Provided PC troubleshooting support to network users; secured network through configuring hardware/ software firewalls; and, updating anti-virus apps and patches for Windows XP, NT, 2000 systems.

Client: Zunch Communications - Contract Website development
Designed and developed web application modules for Zunch’s - a professional Web Development firm - customers:
Some Sites: http://www.zunch.com/; http://www.medfuture.com/; http://www.vttvacation.com/; etc
Responsibilities: Site graphics; Developing modules in: CFM, ASP, ASP.NET, XML, SQL Server 2000, JavaScript; SEO

Commenced career as a GSM Validation Engineer for Piconode Verification (Mini-GSM Network). Work involved understanding individual components of a GSM Network (BSC/BTS/MSC), their inter-working, and designing test plans. Worked with DMS (Nortel's proprietary HLR switch). Was an integral part of a successful Piconode Service Introduction in London for BTCellNet as On-site engineer.

Promoted to GPRS Service Introduction. Learned individual components/technologies/protocols of the Core network (SGSN/GGSN/SIG). Assigned as a Lead for ‘Preside’ - Operations And Maintenance (OAM) - side of the network. This involved reviewing specifications, requirements, and design roles for individual OAM Components (OMC-D, CGF, PPS, MDP/PPR) ranging from Network Operations and Maintenance, Billing, IP related Services (DNS/DHCP), Performance Reporting (SNMP). Acquired thorough knowledge of quality assurance, configuration and maintenance of these elements and their inter-working. Closely interacted with development teams to verify functionality as per design; writing, implementing, and executing test cases for unit/integration testing; and, driving bug fixes through to resolution. Was part of a successful GPRS 2.0 Service Introduction for Telstra, Australia as an On-site engineer.