Data Service

CV SUMMARY

Personal Details

Name: L. Zhang MSc. (Lixia)

Sex: Female

City: Maastricht (Netherlands)

Employable as: BI Reporting Analyst/ Senior Developer (Microsoft

Stack and Qlik View)

E-mail: *****.********@*****.***

Mobile: 06-18349678

Profile

Innovative and highly competent Business Intelligence specialist with over 10 years

experiences developing creative technology solutions that enhance performance, effect

change, drive profits and growth. Strong data analysis skills, end to end MSBI

(SSIS,SSAS,SSRS) and data modeling/data warehouse architecture (OLAP-Online Analytical

Processing/Cubes) expertise, and SharePoint 2010 BI integration expertise.

Capability to approach problems effectively and creatively in complex international

environment and passion for excellence. Hands-on mentality and details oriented.

WORK EXPERIENCE

worked at TPVision Philips for SmartTV Management Reporting. Successfully translate

business reporting needs into high performance SSAS Cube technology solution, design SSIS

packages for the reporting data warehouse and cubes, design SSRS reports and Qlik View

dashboard to support business decisions.

worked at FEI for BI data modeling approach and enterprise data warehouses. Set up BI data

architecture and create OLAP cube (slice & dice) to support timely business decisions,

performance KPI and dashboards. Generate Data Quality reports and Install process Issue

Escalate reports to facilitate data cleansing & service BI related activities.

worked at GBS (Global Business Service) for 17 Country Accounting Centers (CACs) across

DHL Europe operation network. Deeply involved in the system migration and data

reconciliation process, meaning data integration, validation and data modeling. Worked as a

reporting specialist, such as: MIS reporting, Forecasting Reporting, Performance reporting

based on KPI and SLA, reconciliation for data consistency (IT Auditor between billing system

and AR, GL), using several kinds of reporting tools (SAP BW & Crystal Report), Excel &

Access Integration, and Business Intelligence (SSRS) to generate Dashboard reports to

support business decisions.

Business Consultant Experience

Period : November 2012 - present

Organisation : TPVision

Project Name : BI for Smart TV

Function : BI Reporting Analyst (SSIS, SSAS, SSRS and Qlik

View)

Situation : worked at TPVision for SmartTV Management

Reporting. Design and maintain a suite of SSRS reports.

Document and share expertise and best practices related

to data visualization. Successfully translate business

reporting needs into high performance SSAS Cube

technology solution, design SSIS packages for the

reporting data warehouse and cubes, design SSRS

reports and Qlik View Dashboard to support business

decisions.

Period : May 2012 - October 2012

Organisation : FEI

Project Name : Service Uptime Data Mart design

Function : BI Reporting Analyst(SSIS, SSAS, SSRS and Qlik

View)

Situation : worked at FEI for BI data modeling approach and

enterprise data warehouses. Set up BI data architecture

and create OLAP cube (slice & dice) to support timely

business decisions, performance KPI and dashboards.

Generate Data Quality reports and Install process Issue

Escalate reports to facilitate data cleansing & service BI

related activities.

Period : June 2000 - Apr 2012

Organisation : EFSS (Financial Share Service Center)

Function : Reporting and Reconciliation Analyst

Situation : Data Reconciliation between different service lines:

Billing, AR and GL. Creation and maintenance of

enterprise-level production reports. Intensively involved

in Business process optimization and data management

projects.

Most Recent Formal Education

University of Gent, Belgium: Chemische Technologie

Education Certificate

Chemische Technologie University of Gent, Belgium 1987 Yes

Chemische Technologie TU Wuhan University, China 1982 Yes

Technical Skills

SQL Server Database

( SQL Server 2008R2 and SQL

Server2012)

Microsoft Business Intelligence

SSIS – Integration Services

SSAS -- Analysis Services

SSRS -- Reporting Services

SharePoint 2010 Integration

MS Power Pivot Client

Performance Point Services

Qlik View BI Solution

(Designer+ Developer)

Tableau Desktop

SAP BW & Crystal Report

SAS

Languages

Verbal Correspondence

Dutch Good Basic

English Fluent Fluent

Chinese (Native)

Contact this candidate