- Created end to end solution designs from data sourcing to data consumption. Created Data Vault data model to integrate data from different sources and create dimensional data model for business domain consumption. - Led Data Engineers to conduct data build. Conduct quality assurance review on code base, data model, data mapping, and related release objects. Oversaw post release monitor and transition activities.- Provided consultations on design patterns, solution designs, and data models to broad data community. - Established data management standards and processes

• Analyze data requirements, create logical and physical data models, and generate Data Definition Language (DDL) for developers to create database structures in Teradata data warehouse. Monitor the development process, test data and ensure the design implemented correctly.• Analyze data structures of data sources in different formats, including Oracle, SQL Server, XML files, SGML files, JSON, flat files, and create data models for data sources. Ingest source data in data warehouse, and integrate master and reference data, to enable cross-functional, cross-systems data analysis.• Capture data element names, definitions and business rules, and publish data models for business users to better understand data and relations.• Create Data Modeling and Metadata Standards, Class Words Standards, Data Abbreviation and Acronym Standards for Enterprise Data Management.• Work closely with business analysts, developers and project managers to manage project scope and timeline.

• Reviewed and analyzed business requirements, processes, policies, artifacts and data to understand business’ information needs. Gathered and clarified data requirements with business stakeholders by facilitating workshops and meetings.• Reverse engineered existing applications to capture and document current data structure and business rules• Integrated different systems’ data structures. Created conceptual and logical data models to support existing and new data requirements.• Worked closely with development teams worldwide, explaining data model design, and instructing databases updates and new developments. Monitored development process and ensured correct implementation, enabling data integration and communication across systems.• Designed data models for Master Data and Reference Data. Facilitated data definition creation, and domain data change management process, through active collaboration with data stewards.

• Captured metadata for enterprise core data elements, documenting data definitions, business rules, data stewards, data models, data quality, system of origin, system of record, and other associated systems, domain values, data type and data length.• Managed enterprise reference data. Coordinated data stewards to update domain values periodically. Coordinated impacted systems to implement reference data updates, and ensured reference data consistent and in sync across systems.• Documented existing "as-is" data models and designed "to-be" data models for key data elements.• Participated in establishing common Metadata Standards for data elements. Enhanced reference data management process. Monitored and controlled implementations of standards and processes.• Created and maintained a cohesive, coordinated plan to deliver metadata management solutions that meet stakeholders’ priorities within budgetary and product requirements.

• Designed and built financial analytical data warehouse (SSIS), analytical cube (SSAS) and periodic financial reports (SSRS), using customers’ monthly accounting data. • Created ad-hoc data analysis reports for various customers and groups, such as financial health score, and sales per employee trend and forecast.• Created periodic industry financial benchmark reports. Created customers’ financial performance reports, identifying areas of concerns.

• Designed and built financial analytical data warehouse (SSIS), analytical cube (SSAS) and periodic financial reports (SSRS), using customers’ monthly accounting data. • Created ad-hoc data analysis reports for various customers and groups, such as financial health score, and sales per employee trend and forecast.• Created periodic industry financial benchmark reports. Created customers’ financial performance reports, identifying areas of concerns.

Responsible for retrieving materials, such as books, manuscripts, pamphlet files, thesis, photographs, architectural drawings, and maps, for patrons and reference staffs.Also responsible for registering patrons, answering phone calls, reproducing and shelving materials.

• Mapped international standard Dublin Core properties to Library of Congress MARC fields, and harvested Metadata to enable users to search digital resources across the world using the same metadata elements.• Co-authored Metadata publication: “Best Practices for CONTENTdm and other OAI-PMH compliant repositories: creating sharable metadata”.• Developed program to extract digital content metadata from XML files.• Collected contact information of Open Archives Initiative member libraries worldwide. Notified organizations regarding digital content metadata harvesting issues, and coordinated feedbacks.

• Facilitated metadata sessions and created over 1000 business terms and definitions for Enterprise Data Warehouse and Business Intelligence initiative data elements.• Led and created user-created metadata standards for Cognos (BI tool) to standardize the reports repository;• Tested business glossary metadata repository and built enterprise taxonomy with data stewards

• Designed and developed automatic book extracting and tagging system. Trained program to automatically tag book information, such as book title, author, price and so on, enabling users to search books by various attributes and compare prices from different vendors.• Improved “Mining Data Records in Web Pages” computing algorithm, and published research.

Responsible for collecting and reporting check in/out accommodation information for Olympic Village Committee.Responsible for providing information and business services to athletes and officers.