عثمان Farooqi

Client:
Ooredoo Oman

Industry:
Telecom

Responsibilities:
I am currently working as solution architect in Ooredoo's Enterprise Architecture and design team. My responsibilities includes creating high level design for the projects involving Data warehouse. It includes working with other architects to capture how the design should be in upstream / downstream applications as well. Upstream applications involve Ericsson IN, EMM Mediation, Bundle Manager, Service Manager, CRM, Geneva Billing, IVR, Remedy, Payment gateway, Matrix for digital customers, Comptel Mediation, Selfcare Mobile App, MRMS direct sales, OIM inventory module etc. Downstream applications involve working with Enterprise Information Framework (Big data solution based on Pivotal & Java based), Campaign management systems including Aprimo & Flytxt.

I am also working as a member of DWH audit committee within DWH governance to review the design for on going DWH projects.

Client:
Ooredoo Kuwait

Industry:
Telecom

Tools and Technologies:
Informatica, Teradata, Erwin

Responsibilities:
The project was focused to implement DWH solution to fulfill IFRS Engine's business requirements. Contract data was sourced from multiple source systems and mapped on standard telecom data model (cLDM). Data was prepared by cleaning, conforming and integrating multiple sources together and then passed to IFRS engine for accounting. The solution involved creating contract definition in DWH, correlating MSISDN level information for plans, discounts, add-ons, device installments, prime numbers, termination / suspension against contract data. SSP, MRC & ETC were calculated based on the rules provided and then reconciled with IAS 18 data.

Client:
Ooredoo Oman

Industry:
Telecom

Responsibilities:

I worked as Business Intelligence Lead | Solution Architect to gather reporting requirements from business users and implementing them in form of Microstrategy Reports. It includes requirement gathering from business users, analysis of the requirement, doing the gap analysis, CLDM data modeling, Semantic Layer data model design changes, and Microstrategy based reports and dashboard creation.

Besides regular reporting requirements, I was involved in data modeling & mapping for cLDM implementation for prepaid customers. It includes Network Activity, Network, Subscription and Event subject area.

Tools and Technologies:
Microstrategy, Teradata, Erwin

Client: Emirates Airline

Industry: Aviation

Responsibilities:

Farooqi was involved in semantic layer analysis and design of a large airline company based in UAE to design Semantic Layer of their Phase 1 requirements. The objective for the first phase of the project was to integrate different source systems within Booking (PNR), Ticketing, Flown, Targets, Capacity and OD to have an overall track of the life cycle of a booking reference (PNR).

Farooqi has worked closely with client teams to get deep understanding of their reporting needs. Farooqi also worked on designing and development of Semantic layer for Microstrategy Reports.

Client:
NAWRAS

Industry:
Telecom

Responsibilities:

Farooqi was involved in requirement gathering, analysis and semantic layer design of a large telecom company based in Oman to automate the manual reporting of their Customer Care and Sales departments. Farooqi has worked closely with client teams to get deep understanding of their existing reporting structure and documented all requirements. Farooqi is currently working on designing and development of Microstrategy based reports and dashboards.

Tools and Technologies:
Microstrategy 9.3.1, Teradata, Erwin, Sql Server

Client:
DTAC | Thailand

Industry:
Telecom

Responsibilities:

Farooqi was involved in requirement gathering and analysis of business of a large telecom company based in Thailand to support its existing reporting structure when subscribers will start migration to its new subsidiary brand. Implementation required modifying existing and creating new Crystal Reports and Business Objects based universes and reports.

Farooqi conducted regular meetings with clients to understand the business requirements, creating plan for the scheduled delivery of the reports and then develop the reports and universes to meet business requirements in timely manner. Farooqi was also involved in SIT and UAT to meet the end user’s expectations with quality they desired.


Tools & Technologies:
Business Objects, Crystal Reports, Xcelsius, Teradata

Domain:
Enterprise Resource Planning (ERP)
Supply Chain

Industry:
Oil and Gas

Responsibilities:
Currently working as Business Intelligence Consultant at Allied Consultants. My responsibilities here include
• Gathering reporting requirements from client
• Designing Data Warehouse
• ETL implementation to load Data into Data Warehouse
• Development of SSAS Cubes
• Development of Sharepoint 2010 Performance Point Dashboard with SSRS and Crystal Reports
• Delivery of Crystal Reports into Sage X3 ERP Portal

Tools and Technologies:
Sharepoint 2010, Sage X3 ERP, Crystal Reports, SSIS/SSAS/SSRS 2008/2005

Domain:
Customer 360 degree feedback
Social Media Analytics

Industry:
Automobile / Retail / Social Media

Responsibilities:

Worked as Data warehousing / Business Intelligence Developer at TRG Tech. My responsibilities here include SSIS based solution for ETL which is completely configurable for multiple source systems, highly scalable, and is scheduled to pull real time data; The ETL design incorporates best practices by Ralph Kimball like Data Warehouse Bus Architecture, Conformed Dimensions, and Star / Snow Flake Schema design. ETL is completely metadata driven and hence accept changes of source or destination systems without code change.

Designing and development of SSAS Cubes and making various reports using SSRS/Report Builder and custom MDX.

Develop multiple Data Mining Models and Structures based upon best data mining algorithms using Microsoft SQL Server Analysis Services SSAS, RapidMiner which includes (Association, Clustering and Time Series Analysis). Develop DMX based reports to provide Business users best insight into their business which helps them in making critical Business Decisions.

I also design and implement the Data Warehouse and SSAS Cube for Social Media Analytics, Which includes Sentiment Analysis, Frequent Terms, Proximity of Frequent Terms, Reach Involvement etc.

Tools and Technologies:
SSIS 2008/2005, SSAS 2008/2005, SSRS 2008/2005, Report Builder, MDX Studio, DMX, RapidMiner 5, Weka, Oracle 10g, Toad For Oracle

Books Consulted:
Microsoft Data Warehouse Toolkit By Ralph Kimball
Microsoft SQL Server 2008 MDX (Step by Step)

Business Intelligence:

This Project was Microstrategy based BI platform that was capable of delivering reports and analytics for any type of web application. Reporting was primarily focused on online sale/impression of Intel based Netbooks/Notebooks from a particular retailer’s website. Farooqi Co-Architect the Data Warehouse Design, ETL Architecture in Pentaho, Analytics storage format design, Storyboarding for Dashboards, Microstrategy in-memory cubes, Solution Design in Microstrategy and administration of Microstrategy based customer portal.
Key responsibilities include


• Design and implement Schema Architecture like creating Schema objects with Microstrategy Desktop/Architect like simple and compound Facts and Attributes, Fact extensions, Hierarchies, Transformations etc.
• Create and manage Application Objects like Metrics, Compound Metrics, Filters, Custom Groups and Consolidations for Complex Reports
• Extensively worked with Microstrategy Intelligence Server, Microstrategy Web and Microstrategy Administrator reporting basics using Microstrategy Desktop and Microstrategy Web. Involved in troubleshooting Microstrategy prompt, Filter, Template, Consolidation, and Custom Group objects in an enterprise data warehouse team environment.
• Performed Administration tasks, like User Creation, Session Handling, Creating Security roles, Analyzing Report performance, administered all aspects of web and intelligence server
• Involved in administration and deployment to Test, Staging and Production environments using Microstrategy Object Manager


I also Provided help on Microstrategy Discussion Forum to common problems in Microstrategy development. Out of my 127 Posts 40 are voted as helpful and 11 as Right Answers by users

Tools & Technologies:
Microstrategy, Ruby on Rails, HTML, CSS, JavaScript, AJAX, MySQL, Erwin, C# 2008, Pentaho Data Integration, MySQL, Erwin

Software Engineer Train Control System (Absco)

This Project features complete autonomous guided system (auto pilot) for remotely controlled Locomotives.

Tools & Technologies:
Matlab 7, C# 2008