Liberty Global

Royalties Analyst

Prepare, analyse and process stream licence and the usage of movies and series.

Reporting tools

• SQL

• BI techniques

AWCC Mobile Telecom

Senior Business Data Analyst

Providing business insights, customer analysis and Campaign tracking for the CCO Marketing. Providing data analysis by applying inductive approach determined by objective. Ensuring data quality and using data for business intelligence analytical and reporting purpose.

Responsibilities

• Developing

• Reports related to customers insight from multiple disparate, raw data sources.

• Database application using MS Access, Visual Basic and MS-SQL.

• Revenue and trend analysis reports (historical and forecast)

• Reporting

• Analysis and reconciliation reports to identify and predict marketing issues, customers insight, technical issues and revenue related issues.

• Modelling

• Multidimensional/relational modelling, T-SQL (from multiple disparate data sources).

• Setting rules for finding and describing patterns (logical design).

• Predictive / ARIMA model, Neuron function and data normalization.

Key Achievements

• Creating reports to drive informed workforce decisions, to support short and long term organization goals.

• Utilizing BI techniques and machine learning to generate, analyse and create reports to the appropriate stakeholders.

AT&T Global Service

Business Data Analyst

Responsibilities

Conducting a transition and transformation process from Shell to AT&T

Conducted in depth data analysis critical to evaluating business matrix.

Developed reports to identify and track needed actions

Reporting Global business matrix per country and global projects activities.

Key Achievements

Developing and implementing different reports for decision support.

Getronics

Business Analyst

Operational report production and analysis of projected revenue.

Calculated monthly, forecasted yearly revenue for contracts.

Tools and applications

• Access

• Excel

• SAP

UPC

Quality and Revenue Assurance Analyst

Objective

Developed Revenue Breakdown analysis reports for management.

Responsible for the quality of the data for SOX Control.

Conducted ad hoc analyses as needed to support operational decision-making.

Provided drill down reports and analysis to support high level management information and answer the question of why?

Process reconciliation audits that include end-to-end systems' reconciliation, product and clients reconciliation.

Monitor and auditing revenue elements through its generation and processing.

Bill revenue/charges reconciliation.

Price and quantity analysis.

Earned and unearned revenue, sliced and diced by package, customer and per date of earning.

Methods

Accounting (US.GAAP) and auditing,

Statistical modelling, extracting and modelling data (relational and multidimensional) and data analysis.

Reporting tools and applications

• SQL Statement

• Excel

• Access

• ODBC

• PowerPoint

• Brio Business intelligence

• Oracle database and Golden Benthic

• Operational systems and database volume

10 systems interface and large database which exceeds 15 million records per month, modelling dimension like time dimension and attribute (unit price, discount percentage)