RESUME of Dylan Wan in 2003

Dylan Wan
500 Oracle Parkway
M/S 3op13
Redwood Shores, CA 94065
Phone: (650)506-2844(Office), (510)494-1793(Home)
E-mail: dylan.wan@oracle.com, wan2802@yahoo.com 


OBJECTIVE

I am looking for an application architect, IT analyst, or Database Manager/Consultant position, which I can best apply my skills and knowledge in the area of product strategy, functional and technical design, and application integration.

SUMMARY OF QUALIFICATIONS

* Excellent analytical and problem solving skills
* Familiar with the products and business flows supported by Oracle E-Business Suite Release 11i
* Cross Product Functional knowledge - Both CRM and ERP
* Strong Data Modeling skill
* People Management, meeting, and influence/persuasion skills
* Familiar with Oracle Application Technology and Coding Standards
* Strong knowledge of Oracle RDBMS and Development Tools

WORK EXPERIENCE

April 2003 - Current Oracle Corporation Redwood Shores, CA
Group Architect, Trading Community Architecture and Customer Data Management
1. Chair the TCA Architecture Review board
* Review all architecture decision made to ensure a coherent schema
* Define and review the usage guidelines around TCA schema to ensure consistent usages across E-Business Suite.
* Identify the architecture issues that require manager's attentions
2. Point of contact from Oracle Financials to participate in the E-Business Suite central architecture review board
3. Lead the integration team that is responsible for the following tasks:
* TCA SPOC meeting: Bi-weekly meeting with the internal TCA development community to resolve the integration issues and uptake the latest features provided by Trading Community Architecture.
* Coordinate the product teams to provide the Party Merge and Account Routines.
4. Lead the architecture team that provides the architecture design for the following projects:
* Import Data Load and UI Console
* Address Validation: Integrating with 3rd party address service vendor such as trillium and first logic.  Defining the XML Message standard as part of Open Application Group Specification.

June 2002 - April 2003 Oracle Corporation Redwood Shores, CA
Senior Architect, Architecture and Integration, Trading Community Architecture
1. Chair the TCA Architecture Review board
2. Point of contact from Oracle Financials in the E-Business Suite central architecture review board
3. Lead the integration team that is responsible for the integration between TCA and the rest of E-Business Suite products.
4. Lead the architecture team that provided the architecture design for the following projects:
* Geography Hierarchy Model: Provide the architecture design of the data model to capture the geography information like countries, states, cities, etc.  It is the model that will be used for address component validation and Tax jurisdiction finding.  Served the architect lead that made or was involved in all technical design decisions.
* Common Party UI components
* Multiple Original System Reference (Source System Management)

May 2001 - June 2002 Oracle Corporation Redwood Shores, CA
Senior Architect, Trading Community Architecture
1. Lead the architecture team that provided the architecture design for the following projects:
* Data Sharing and Security: Provided the data model that captures the security rules on how TCA data can be shared and secured.  Internally we use the Application Technology group's data grant model and API.
* Oracle Spatial eLocation Service integration: Populated the geometry column by integrated with the geocoding services provided by Oracle Spatial.
* Name and Address Formatting:  Provided a central model and routine which can format the name and address components according to the formats required in different locales and situations.
* Relationship Hierarchy Model: Support the model to capture the hierarchical relationships among customer organizations. 
2. Architect Lead and Project Captain for the following projects:
* Workflow Directory Synchronization:  Designed the architecture that will keep the workflow directory in sync with the data entered and maintained in TCA.
* Oracle Exchange Integration
* Supplier Model Integration
* HRMS Integration

Jan 2000 - May 2001 Oracle Corporation Redwood Shores, CA
Architect, Trading Community Architecture
Played the various individual contributor roles in the following projects:
* Business Event Based Callout: Provide the technical and architecture design. Worked as the project captain for this project.
* Classification Model: Provide the technical design and in charge of the predefined industrial classification schemes.
* Relationship Meta Model
* Sales Tax Based Address Validation: 
* D&B Content Source Provider Integration
* Logical Data Model

Nov 1999 - Jan 2000 Oracle Corporation Redwood Shores, CA
Project Lead, Trading Community Architecture
* Self Service User Registration and Profile Maintenance: Created the High Level design.  This was not implemented.

May 1999 - Nov 1999 Oracle Corporation Redwood Shores, CA
Project Lead, Multi-Org and Shared Service Architecture
* Multi-Org Access Control: Design the VPD based architecture for supporting multi-org access control.

Dec 1997 - May 1999 Oracle Corporation Redwood Shores, CA
Senior Application Engineer, Financial Architecture
* Multi-Org Cross Org Reporting
* Oracle Asset Security by Books

Nov 1996 - Dec 1997 Oracle Corporation Redwood Shores, CA
Application Engineer, Financial Architecture
* Application Integration using the standards defined by Open Application Group
* Receivable Transaction API: Provided the PL/SQL API for creating maintaining the Receivables Transactions, including invoices, credit memos, debit memos, deposits, and guarantees. 

EDUCATION

Carnegie Mellon University Pittsburgh, PA
Master of Information System, August 1996
John Heinz III School of Public Policy and Management 
W. W. Cooper Merit Scholarship

National Chengchi University Taipei, Taiwan
Bachelor of Business Administration, May 1992
Major in Statistics

REFERENCES

Available upon request.