Thomas Ching Email & Phone Number

Thousand Oaks, Ca, Us

Chiyoda-Ku, Tokyo, Jp

Design, development, implementation, governance, adoption, education, and support of Enterprise Metadata Repository (Collibra/MetaCenter).

Thousand Oaks, Ca, Us

Developed definition of business requirements to support accurate, creative and credible solutions to measure, analyze and report Global Development Operations performance. Leveraged multiple client-facing source systems (Medidata RAVE, eClinical, FIRM, LIFT), vendor data streams, ODS environments, and related enterprise data marts. Led interviews with business owners and SME’s to identify relevant measures, reporting context, data currency, and presentation to support Operations, Oversight, and Management reporting. Led interviews with relevant system owners to validate source data. Facilitated workshops with business/system owners to determine Fit/Gap of business requirements against current Data Warehouse and Business Intelligence applications. Led solution design sessions with technical teams to identify Gap resolution strategies. Worked with business owners to strike a balance between business requirements vs. system/data constraints. Validated technical solutions with business/system owners. Authored high-level and detailed design documentation to facilitate solution development (Informatica/Cognos/Spotfire) and support quality assurance testing (Quality Center). Prepared summary documentation for Governance Committee review and prioritization. Facilitated issue management for technical teams during solution development, quality assurance, user acceptance, and implementation activities. Managed UAT activities with business owners and technical teams. Collected final production sign-off from all relevant stakeholders.

Calabasas Hills, Ca, Us

Developed definition of business OLAP requirements for Bakery Production, Distribution and Sales organizations to capture/report trends in performance, attainment, material usage, material disposal/salvage, fulfillment, labor, and sales. Led interviews with business stakeholders to define metrics, reporting context, data currency, and presentation layout. Performed assessment/analysis of source system MRP to validate metrics, identify data granularity, data currency, and embedded data hierarchies. Authored Requirements Traceability Matrix (RTM) to capture business requirements, data analysis, and business rules for data transformation. Performed profiling of relevant source system database tables to identify anomalies/exceptions. Worked with business stakeholders to strike a balance on business requirements vs. system/data constraints. Authored business process change to address data exceptions and data currency issues. Authored new business processes to address data holes and disparate source data. Authored data model and led workshops with data architects/modelers to finalize data model. Collaborated on development of the OLAP star schema. Captured all data mapping (source->target) in the RTM. Facilitated ETL logical/physical design workshop to identify ETL (SSIS) data flow process, staging requirements, major transformation requirements, and infrastructure requirements. Prepared summary project documentation for Business/IT Governance Committees. Authored/maintained all PMLC documentation. Authored/maintained all client-facing workshop/meeting materials. Led meetings with project sponsors from the business/IT community. Provided support to ETL team through development/unit test. Facilitated issue management for technical teams during development, testing, quality assurance, user acceptance, and implementation activities. Managed UAT activities with business stakeholders. Obtained final production sign-off from business stakeholders.

Thousand Oaks, Ca, Us

Developed definition of business reporting requirements for national sales organizations to support Q1/Q2 2011 sales goals. Led interviews with business stakeholders to identify relevant measures, reporting context, data currency, and presentation to support sales reporting. Led interviews with relevant data owners to validate source data. Facilitated workshops with system owners to determine Fit/Gap of business requirements against current Enterprise Data Warehouse. Led solution design sessions with technical teams to identify Gap resolution strategies. Validated technical solutions with system and data owners. Worked with business stakeholders to strike a balance on business requirements vs. system/data constraints. Authored high-level and detailed design documentation to facilitate solution development (Informatica/Cognos) and support quality assurance testing (Quality Center). Prepared summary documentation for Governance Committee review and prioritization. Facilitated issue management for technical teams during solution development, quality assurance, user acceptance, and implementation activities. Managed UAT activities with business stakeholders. Collected final production sign-off from business stakeholders.

Charlotte, Nc, Us

Developed information systems to address rapidly evolving requirements in the Mortgage and Insurance Services divisions. Participating throughout the SDLC (Six Sigma) from project definition, planning, business/technical design, development, quality assurance, documentation, and user training. Modeling business requirements, leveraging use cases, data flow, and process flow diagrams. Conducting feasibility analysis when required. Developing activity cost estimates. Developing detailed functional specifications for use in coding/programming. Assessing the impact of changes to systems, processes, and organization. Providing detailed analysis of complex data, processes, and systems. Creating current and future state conceptual, logical, and physical models. Facilitating joint application design sessions with business and technical project teams. Working between technical and business groups to manage/resolve issues. Participating in testing and/or working with QA teams during testing activities. Ensuring quality of deliverables throughout all phases of the SDLC.

Developed knowledge of current business processes, workflow, related application software, and databases using a process of interviews and workshops with business stakeholders of the Claims Processing, Policy Management, Underwriting, and Finance groups. Identified and documented business OLAP requirements and performance metrics for the Data Warehouse (DW) solution. Translate business reporting requirements into technical specifications to support authoring of reports via Cognos Report Studio. Translate data requirements into traceability matrix to support mapping and transformation logic for DW (star schema) elements. Designed extensions (data elements) to existing star schema to support new OLAP functionality. Supported design (business rules) and development (unit/system testing) of ETL using Cognos Data Manager. Supported definition of functional specifications for DW (SQL Server). Executed enhancement of existing Framework Model to support data requirements via Cognos Framework Manager. Executed development of 100+ managed ad-hoc reporting requirements via Cognos Report Studio for Claims, Policy, and Underwriting users. Facilitated UAT workshops to validate Cognos Framework Model and Cognos reports (Report Studio). Conducted classroom training on Report Authoring in Cognos Report Studio to unrelated IT Staff and Business Users. Contributed to the enhancement of software development (RUP) best practices through definition of standards and procedures in compliance with the Sarbanes-Oxley Act.

Thousand Oaks, Ca, Us

Developed understanding of current business processes, workflow, related applications, source databases, and analytical information requirements through interviews and workshops with key business stakeholders of the Contracts Management, Product Pricing, Payments, Rebates, Customer Membership, and Finance groups. Developed use case scenarios to document key business processes. Developed technical specifications to refine and document business OLAP requirements. Performed detailed analysis of supporting data including process relationship, update frequency, retention policy, and source system. Collaborated with data modeling team to develop multi-dimensional star schema (Oracle 10g) using baseline information from business OLAP requirements and use case scenarios. Collaborated with Informatica developers to validate data extraction, transformation, and load logic. Collaborated with Cognos development team to design/build/test Framework Model (presentation layer). Developed test case/scenarios to support unit, system, and user acceptance testing of the DW. Provided compliance to ‘early adoption’ of RUP methodology and best practices. Facilitated numerous presentations to business stakeholders to demonstrate compliance with defined business objectives and cultivate user acceptance/ownership. Collaborated with project team to determine user training requirements and create training material. Facilitated classroom delivery of user training material regarding the OLAP functionality. Provided on-going production support and governance of DW solution.

DirecTV - Inventory Tracking System (2005) Project Manager; Childrens Hospital Los Angeles - PeopleSoft ERP (2003) Technical Architect; Childrens Hospital Los Angeles - Cerner CIS (2002) Technical Architect; DirecTV - SAP Data Archive (2002) Project Manager; American Express - iMarket Launch (2002) Technical Architect; Chevron - iMarket Business Launch (2001) Technical Architect; Solectron – Information Portal (Broadvision/Business Objects) (2001) Project Manager; Veritas Software – ERP Package Evaluation and Selection (Oracle/PeopleSoft) (2001) Technical Architect; Unocal - Business Continuity Planning and Infrastructure Recovery (1999) Technical Architect; O'Melveny and Myers LLP - Litigation Support (1999) Subject Matter Expert; Kaiser Permanente - Y2K Readiness Program Review Diagnostic (1999) Technical Specialist; Herbalife - Millennium Program (1998) Technical Specialist; Herbalife - Application Transformation (1998) Technical Specialist; Herbalife - Technology Assessment (1997) Technical Specialist.