Haiping Wang Email and Phone Number

Existing data from diverse data sources were consolidated into a uniform SQL Server2012 database. ETL capabilities of SSIS were used to define imports of data, buildscheduling packages, define integration flow, log data error exceptions and orphaned dataand to define Database Maintenance Plans and send emails. • Created cubes, dimensions, and business critical KPIs using SSAS representingaggregations in different ways - hierarchically and using custom groupings, that thecompany will use to analyze performance. Created MDX queries according to businessrequirements. • Developed detail and summary reports, line and pie charts, trend analysis reports andsub-reports according to business requirements using SSRS.• Created score cards using MS Office Performance Point Server 2007 Dashboard Designerthat feature executive summary measures for revenue, overhead costs, material purchases,labor and profitability trends for a construction company extracting data from SQL Server2012 OLAP data source and deployed to SharePoint sites. The dashboards also contain pagesto view performance by employee, by region, and by quarter enabling end-users to makefilter selections.• Key product areas utilized also include data modeling, SSRS report subscriptions anddata driven subscriptions, SSAS analysis services processing tasks, cube processingoptions and roles.• Studied and reviewed application of Kimball data warehouse methodology across variousindustries. Worked with data-handling scenarios, such as multiple hierarchies, data-drivenKPI goals, sourced either from dimension attributes or fact tables, handling Type-2 slowlychanging dimensions.

Design it's trade mark. This trade mark is still in use.• Financial management: responsibilities included raw material purchasing, warehousemanagement, bookkeeping of hundreds of products, salaries and commission reporting of oursales staff.• Packaging design with labels both in Chinese and English.

Assess and look after 200+ students' progress throughout the term and work closely withother staff to efficiently plan and coordinate work• Ensured that all students comprehended the curriculum, and supported students whorequired extra guidance• Frontier Medical literature reading skills.