PROFESSIONAL SUMMARY:

• 20 years working experiences in IT and more than 16 years experiences in data warehouse and BI systems with strong experiences on data warehouse infrastructure, data modeling, ETL, OLAP and advance analytics.
• Proficient on prevalent DW/BI technologies including Oracle, SQL server, Informatica, Tableau Hyperion, OBIEE, Microsoft PowerBI, Python and R as the specialist and architect.
• Worked on multiple projects to build enterprise level data warehouse and BI systems on Oracle and SQL server platform in Finance, Telecom and manufacturing industry.
• Experiences on BI roadmap to evolve enterprise BI from a low value, cost center operation to a high value, strategic function that drives market share for the company. The roadmap encompasses data integration, data quality management, master data management and information delivery.
• Being an information solution architect and Data warehouse/BI manager to design enterprise data warehouse, data mart, Operation Data Store (ODS), Master Data Management (MDM) solution, advance analytics and self - service BI initiatives.
• Experiences on BI platform migration from on premise to Azure cloud platform.
• Managed a team with onshore and offshore resources to deliver BI/DW solutions for worldwide implementation
• Hold MBA and B.S degree of Management Information System in China and U.S with strong technical and business background to translate from business needs to a technical solution.

MAJOR TECHNICAL SKILLS:

Data warehouse: Oracle, MS SQL server, IBM DB2

ETL: SSIS, Informatica

OLAP: Oracle Essbase, Microsoft SSAS, IBM Cognos

Data Modeling: Erwin, Visio 2013

Data Science: R, Python, Tableau

Cloud Platform: Microsoft Azure (IAAS, PAAS)

Reporting and Analytics:

Oracle: OBIEE, Hyperion reporting Microsoft PowerBI, SSRS, Tabular Tableau

Big data platform: Hortonworks Hadoop HDFS/Hive/Spark

EMPLOYMENT HISTORY:

Confidential, Fort Lauderdale, FL

Data warehouse and BI solution architect/development manager

System environment:

Data warehouse/data mart: SAP/BW, MS SQL server warehouse

ETL: Microsoft SSIS, T-SQL, Informatica

OLAP: Microsoft SSAS, Hyperon Essbase

Cloud platform: Microsoft Azure (IAAS, PAAS)

Data science: R, python and Tableau

Reporting: Tableau, MS PowerBI&SSRS, Hyperion Reporting, Oracle OBIEE

Responsibilities:

• Lead BI projects in various BI platforms (Hyperion, OBIEE, Tableau and Microsoft BI)
• Design and implement the enterprise data platform including ETL processes, ODS, EDW, data marts and OLAP cubes, define BI roadmap to evolve BI systems from departmental to enterprise level
• Enable analytics platform and self-services reporting capability for business users on various reporting platforms like Tableau, PowerBI and OBIEE
• Implement multiple data science projects by establishing user story, enabling data store, exploring and mining data, and presenting findings to business users. The data science tools used in the project are R, python and Tableau.
• Experience in implementing BI solution on Azure platform by using IAAS and PAAS(SQL DB, SQL data warehouse, ETL and PowerBI)
• Explored Hadoop on the Horton works platform to store product usage data and customer behavior data by using Hive, Sqoop and Spark
• Design Hyperion system infrastructure for large scale implementation (BI and Planning ) and perform Hyperion system upgrade
• Work with business users to gather requirements and transform them to a viable technical solution
• Work with consultants and offshore resources in some projects as a technical lead and architect.
• Design and develop OBIEE dashboards for enterprise performance management
• Design semantic layer to integrate Essbase and other data sources in OBIEE

Confidential, Wilmington, Delaware

BI specialist and data modeler

System environment:

Data warehouse/data mart: IBM DB2, SQL server

ETL: Microsoft SSIS, T-SQL, DataStage

OLAP: Microsoft SSAS, Hyperon Essbase

EPM/BI system:

Microsoft BI suite: Tabluar, Powerpivot, Powerview, SSRS, sharepoint Hyperion Reporting(WebAnalysis, Interactive Reporting, Smartview), EIS

OBIEE(10g): Answers/Dashboard, BI publisher

Responsibilities:

• Worked with marketing business users to complete BRD and SRD for lead management and marketing campaign analysis. Built up a conceptual model to gather business requirement, and logical model to define model of business solution, mapped the logical model to a physical data model in star schema.
• Designed backend data mart model on SQL server for the Hyperion cubes. Developed ETL processes with SSIS to extract data from data warehouse in IBM DB2 platform to a staging area and transformed the data to a dimensional model with dimensions and fact tables in SQL server.
• Designed and developed multiple Hyperion reporting cubes on Hyperion system 9 platform. Developed dimension build and data load rule files, designed aggregation views for performance optimization, and created MaxL scripts to automate the cube build processes. Used Reporting scripts to export data for data reconciliation between cubes and source data.
• Federated multiple data sources on SQL server and IBM DB2 to construct logical dimensions and facts into multiple star schemas by using OBIEE semantic layer. The data virtualization approach allows building BI applications agilely and faster without physically moving data.
• Built marketing dashboards by using OBIEE Answers/dashboard on top of the semantic layer. Allowed user to slice and dice the data in the dashboard and receive reports by email on a daily/weekly basis.
• Maintained Hyperion Essbase cubes and Microsoft Analysis services cubes platform by performing daily data load and set up user security. Tuned up cube performance by optimizing cache and cube structures.

Confidential

Data warehouse/BI Programmer Analyst

System environment:

Data warehouse/Datamart: Oracle DB, SAS

ETL: Oracle PL/SQL and UNIX scripts

OLAP: Hyperion Essbase, IBM Cognos PowerPlay

Reporting: Hyperon reporting, Information Building Webfocus, Web portal, Cognos Reporting

Responsibilities:

• Supported company data warehouse running on Oracle DB and UNIX platform.
• The data warehouse had 2TB data with subscriber, product, sales and call activity information. Developed and maintained Oracle PL/SQL procedures and UNIX scripts for daily data warehouse/data mart refresh, and set up processes to reconcile data between data mart and downstream reporting system.
• Attended series of SAS courses on data processing and data mining from SAS institute.
• Extracted data from Oracle and performed statistics analysis and data cleaning on the data sets for data analysts to create statistic models to analyze customer churn behaviors.
• Developed Hyperion Essbase cubes to report subscriber acquisition and churn data by areas, channels and wireless plan. Supported Hyperion daily operations and troubleshot issues from users, and maintained applications security and performed daily system backup.
• Upgraded Hyperion system from version 6.5 to version 7, converted BSO applications to ASO applications.
• Developed ah-hoc and analytics reports by using various reporting tools Webfocus, Hyperion reporting and Cognos Impromptu against Essbase cubes and Oracle data mart tables

Confidential

Senior Information Service Consultant, Project Manager

System environment:

Database: Oracle, Confidential DMSII

OS: UNIX, Confidential mainframe system DMSII

Programming Language: L INC (proprietary Confidential mainframe language), Oracle PL/SQL, C and UNIX script

Responsibilities:

• Worked closely with the customers for requirement gathering and system implementation on site.
• Supported the system running on 24/7 mode and performed backup and system tuning on the mainframe platform.
• Migrated the retail banking application from mainframe to Unix platform, and re-developed the application by using Oracle PL/SQL, C and Unix scripting language
• Being a project management and application architect in the Confidential project to implement retail, ATM and cross banks clearing system in major cities in Guangdong Province. In the project, lead a project team with 5-6 people including technical architect, business analysts and developers from requirement gathering to system roll out.