Data Management

Vivian Chang, MBA

* *******, ** ***** ****: 512-***-**** Email:

*************@*****.***

Expertise:

• Project Management, User Stories, engage business and technical teams, business strategy, data strategy, Data

Governance framework including business architecture and data architecture, streamline business process, improve data

quality

• Enterprise Data Architecture, BI, Data Warehouse, Enterprise Data Modeling and process modeling, Relational data

modeling, multi-dimensional data modeling, facilitate modeling session with SMEs for OLAP and transactional system

Experience:

Dec 2013 – Nov 2014

ConocoPhillips – Data Architect Consultant Houston, TX

• Designed data architecture to integrate data from various systems for well asset management, leveraged PPDM industry

model. Completed the data architecture and data mapping specification, provided guidance for ETL development and

completed project with aggressive timeline.

• Promoted using Epics and User Stories to capture business requirements and ensure business and IT alignment

• Worked with business stakeholders for business and data strategy to improve data quality, in order to report valuable

information from BI/DW

Nov 2012 –Jul 2013

Halliburton – Technical Consultant (Data Management) Houston, TX

• Provided technical consulting and data architecture for Canonical Model, proposed Data Governance and Data

Stewardship program, for the Common Ground program

• Facilitated SMEs' input to create Canonical Logical Data Model, that drives synergy with common semantics and

taxonomy, to instantiate virtual database that integrates enterprise petro-technical data

• Proposed Business Architecture and cross functional work flow, to include the “information flow” that correlates to the

data integration needs

• Advocated correlation of bottom up data integration needs with the top down business requirements as EPICS, User

Stories, and Acceptance Criteria (confirmation with business rules), to ensure IT implementation is meeting business

needs, with agile modeling practice

• Promoted Common Ground Program via Expo and Brown Bag sessions

Dec 2010 – Nov 2012

Houston Independent School District – Sr. Information Modeler Houston, TX

• Evangelized Data Governance framework for Data Driven Accountability Program

• Developed working plan and data architecture for Business Intelligence bake-off project, engaged SMEs from different

teams and rationalized different perceptions while capture common semantics in the data model

• Established Enterprise Data Model and taxonomy, to derive master data

Jan 2010 – March 2010

HP – Master level Data Architect Houston, TX

• Developed the framework of End-to-End Message Rationalization Process, to review and standardize online messages

utilized by different applications, promoted consistency among various applications throughout the enterprise. Developed

the “generic message” concepts in the framework, which using variables instead of hard coding messages, reduced 80%

of translation cost and overheads

July 2009– Dec 2009

Diamond Consulting – Senior Associate/Data Architect

Client – Allstate Traveling

• Provided advisory consulting to validate findings for the mainframe cost reduction initiative

Client - Chicago Public School Traveling

• Assessed current situation with data quality issues, provided recommendation for the future plan to address root causes,

including roadmap for data governance, business and data architecture, data governance committee, data owners, data

stewards, and enterprise information management with change control process. Recommended creating enterprise data

model with metadata and CRUD, as well as enterprise business process with RACI, to demonstrate total transparency.

• Researched on various public and private sectors that have data quality issues, and their action plans to resolve these

issues

February 2007– February 2009

SYSCO – Senior Data Architect / Enterprise Data Architect Houston, TX

• Worked with Enterprise Architecture team to come up the meta model for Enterprise Architecture utilizing TOGAF

framework (Business Architecture, Information/Data Architecture, Business Application Architecture, and Technology

Architecture).

• Evangelized and advocated the enterprise information best practice. Developed and presented framework of Data

Governance (including Data Owner, Data Stewardship, SME, Data Modeler…etc.), to improve enterprise business

process and data transparency. Proposed creating and maintaining business process model and data model at application

level and enterprise level, with common semantics and change control process, for the holistic view of the corporation.

Proposed forming Data Architecture group to enable long term change control process and synergy with Data

Governance program.

• Established Information Forum to mentor other Data Architects/Data Modelers/Database Architect from various

departments, facilitated weekly knowledge sharing, information sharing, collaboration, in order to driving synergy and

conformed data strategy. Provided cross functional leadership by mentoring and developing Data Architecture team

within Application Architecture group (not an ideal organization structure with direct report; therefore has being very

challenging). Reviewed Application Data Architecture Handbook and providing feedback, mentoring and cultivating the

interaction between Business Architect, Enterprise Data Architect, Application Data Architect, and DBA.

• Developed data architecture principles, data model standard, and change control process. Overseen different IT groups

and contractors to adhere the process and standard. Provided data modeling training across the organizations, coaching

and mentors new data modelers in the organizations and offshore contractors. Developed enterprise standard abbreviation

as the naming convention of Erwin data model (nsm file). Developed data model template with the embedded standard

abbreviation, which will save 90% of data modeling time, by having the tool to automatically abbreviating the attribute

name in the logical model view to the column name in the physical model view

July 2005 – February 2007

United Health Group – Senior Data Architect Hartford, CT

• Reinforced change control process and collaborative effort, between Data Management team and Application team, to

govern the consistent data schema between data model and database

• Facilitated working sessions with the Subject Matter Experts (IT technical director and business lead), discussed leading

questions to drive the best solution with the long term strategic goals, for the Electronic Payment System, which

innovatively providing the payer portal capability--from “payer specific payment solution” to a “multi-payer product

line”. Captured business needs and requirements to develop data architecture that yield long term ROI, including

conceptual data model, logical data model, and physical data model. Interfaced with DBA for access modeling

(considering performance and access patterns), and generated ddl as data schema reference for the DBAs.

• Investigated DB2 issues within Erwin, worked with Computer Associates for these issues, suggested and justified “design

enhancement” for the next release of Erwin (r7).

May 2005 – July 2005

Q1 Technologies/Albertson Retail Store - Information Architect Boise, ID

• Developed data architecture for asset management system. Worked with the enterprise data group and application team,

to ensure proper data governance policies were being followed. Participated in the data model review with IARC

(Information Architect Review Committee), when the proper Data Stewards of the appropriate subject areas will be able

to review and approve the model, or disapprove for further modification.

August 2004 – February 2005

SMIC – Technical Manager Shanghai, China

• Educated IT leaders the concept of data integrity and relational database, data management best practices,

including utilizing data model, data flow diagram, and business process model. Scheduled reoccurring

meeting to interview “Subject Matter Experts” to create data model for the reporting database of YMS team

(‘Yield Management System’). Created Microsoft Project Plan with the work-break-town structure, to

include all the activities with the milestones

• Provided consultation for the needs for data warehouse, data mart, and enterprise data model, which will

help to identify problematic areas and increase yield rate in the manufacturing process

Sep 1998 – July 2004

EDS – Information Analyst/Data Modeler/Data Architect (9/00 – 07/04) Plano, TX

• Utilized Erwin to create the logical data model and derive the physical data model, worked with the DBA of

the particular DBMS platform to fine tune the physical data model (in Oracle, DB2, Sybase, SQL Server…

etc.)

• Worked with Technical Team and Business Team for EDS Service Excellence Dashboard, which would

enable EDS to become a portfolio management company with a competitive advantage. Analyzed existing

logical data model and various versions of enhanced physical data model (based on different initiatives).

Analyzed and consolidated the important entities from various enterprise applications to create a merged

version of enterprise data model (As-Is version). Performed Gap analysis to identify discrepancy among

various enterprise applications. Reviewed the gap with managers to resolve the discrepancy and

rationalize the differences to create the To-Be version of the enterprise data model

• Gathered requirements and business rules by interviewing the Subject Matter Experts, scheduled modeling sessions to

guide the SMEs, to obtain business rules and define data elements. Created both the logical data models (created subject

areas with entities and attributes, established relationships among entities) and physical data models (with proper de-

normalization, data types for the appropriate database platform, performance optimization with indexes), for a Credit

Union application rewrite (conversion from flat tables in a proprietary database to SQL Server relational database for

the .NET application)

EDS – Information Analyst/DBA (9/99-9/00) Plano, TX

• Provided 24 by 7 on-call DBA support for customers with Sybase databases. Worked with development team for

object changes on the database. Worked with people who monitored the nightly batch job cycle, to resolve production

problem or backup failure

• Provided database administration with Sybase DBMS and SQL Server

EDS – Information Analyst (9/98 – 9/99) Plano, TX

• Analyzed client’s needs for internal Customer Service in BI/data warehouse and data marts

• Provided data management consultation to clients -- The internal initiative of creating data mart/data warehouse for

service area (related to marketing strategy to evaluate the performance in different service areas)

Aug 97 - Mar 98

Interactive Web Systems - Programmer Analyst Richardson, Texas

• Meeting with Nortel manager from Canada for requirements gathering, for their Intranet application - Nortel Supplier

Performance. Leading the full system life cycle process by creating the prototype, application specification, and data

model, based on the business requirements. Derived resource estimation for the project, and developed testing plan for

UAT. This application is a tool that effectively measured supplier’s performance, by soliciting regular feedback from

different branch offices, and generated score card and suppliers ranking

Apr 96 - Aug 97

UT Southwestern Medical Center - Programmer Analyst Dallas, Texas

• Provided internal consultant service regarding to data strategy, database and application design

• Supported and maintained Reconciliation system for a major client. Developed application and data model in MS Access

that integrated with data from Mainframe and another Clipper application, with full system life cycle process

(Requirement, Evaluation, Design, and Implementation).

Feb 95 - Apr 96 Bank One - Database Analyst/Programmer Dallas, Texas

• Developed reports for a Bank One corporate application - Report Profit Management. This application measured profit

that derived from various accounts of each customer. This application enabled Bank One Financial Analyst to do What-If

Analysis in order to make to most profitable deal with the customers. Coordinated with RPM Administrators of all the

Texas branches in order to feed data to the system on monthly basis. Provided technical support to the administrators.

Developed reports in Paradox for the system

Jan 94 - Feb 95

JCPenney Corporation - System Analyst Dallas, Texas

• Maintained, documented, and developed reports for client server application, with Visual Basic. Cost effective analysis

with the contract of the leasing PC inventory with the current market trend.

Jan 93 - Dec 93

The Forbes Group - Database Programmer Dallas, Texas

• Designed applications and data model in Foxbase, a tool for marketing strategy for TGIFriday. Developed reports with

existing data. Interfaced with end users to trouble shoot data entry and validation problem for the existing application.

Made enhancement to the existing application to resolved data integrity problem and increased production for data entry

personnel

Education:

The University of Texas at Austin

Bachelor of Business Administration, December 1992

Major: Management Information System

Overall GPA: 3.14/4.0 Major GPA: 3.50/4.0

Texas A&M University Commerce

Master of Business Administration, August 2011

Overall GPA: 3.9/4.0

Additional Information

• Fluent in English and Mandarin

• US citizen

Contact this candidate