SUMMARY:

• I earned my first Computer and Systems Engineering Masters degree in 1987 and then became a professor in the same department for the outstanding s. With years of experience on DSS systems and Database projects for Banks, Post Offices and other organization
• I am a typical technical lead for Enterprise Data Architecture, Enterprise Data Integration, Enterprise Data Warehouse, Business Intelligence, Data Quality and MDM (Master Data Management)/CDI, with expertise from theory to practice, from database to applications, from OLTP to OLAP, from ETL to Reporting and Analytics, from architect, DBA to Database development and performance tuning, from development support to production support.
• I am very experienced in large - scale projects in all phases of the development lifecycle including needs assessment, requirements gathering and definition, architecture/design and development, etc. These projects include EDI/Enterprise Data Warehousing/Data Marts architecture and development, MDM/CDI and Metadata Repository, ETL/BI tools selection, DW/ETL Best Practices, BI/enterprise reporting, and analytical applications.
• Either you have a new project starting from scratch, or you are suffering growing pain, or your existing systems have disparate and inconsistent data, or your systems have significant performance issues, or you want to migrate your system among Oracle, DB2/UDB, MS SQL Server and Teradata. I provide the expertise on all of these. I know all possible issues, pros and cons; trade-offs and work-around.
• Architecture, modeling and development of Database system, MDM/CDI, Enterprise Data Warehouse, Data Marts and Enterprise Metadata, especially their overall quality and optimization.
• RDBMS overall expertise. I worked on almost all kind of RDBMS like Oracle, Teradata, DB2/UDB, MS SQL Server and Sybase, etc.
• ETL systems. I worked on most of the main ETL tools like Informatica, DataStage, Ab Initio and SSIS/DTS with expertise on everything in Informatica 5 to 8: Designer/Mappings, tasks/workflows, repository, server administration and Metadata Manager.
• Business Intelligence, especially on Cognos and Business Objects.
• Data Profiling, Data quality, data standardization, stewardship and governance.
• Problem solving and troubleshooting with very strong analytic and logic ability.
• Deliver projects with high quality on time and within the budgeted resources.

TECHNICAL SKILLS:

Skills: Top Skills on Oracle (up to version 10g R2) Architect/Data Modeling, DBA, and Database Development (SQL*Plus and PL/SQL). Good and solid skills on Teradata Data Warehouse/BI including Teradata design, development and utilities like FastLoad, MultiLoad (MLoad), Teradata Parallel Data Pump (TPump) and Teradata Parallel Transport (TPT), etc. Fluent in Teradata SQL including Analytic functions. Very experienced in MS SQL Server6.5 to 2005 administration and T - SQL development as well as MS SQL Server Analysis Services (SSAS)/Analysis Manager/MDX. Hands on DB2/UDB (7.2 to 8.2) support for Data Warehouse and its source databases for PeopleSoft Finance/Oracle Financials, EPM and CRM, and Ventive, etc. Experienced DB2/UDB Data Warehouse architect and ETL engineer including DB2/UDB SQL and Its Analytic functions. Fluent in ANSI SQL including the Analytic functions. Efficient with Database tools (ERwin, Embarcadero ER/Studio and DBArtisan, Oracle Enterprise Manager, Oracle Management Package, SQL Navigator and Toad, DB2/UDB Control Center/Command Center, MS SQL Server Enterprise Manager and Sybase PowerDesigner, etc. Excellent ETL architecture, design with DTS/SSIS, DataStaging and Informatica PowerCenter5 to 8 design, development and implementation skills. Informatica PowerExchange, Repository Manager, Metadata Manager and Repository Server administration. Data sources include, but not limited to mainframe VSAM files, flat files, XML files and data stored in all kinds of databases like Oracle, DB2/UDB, Sybase and MS SQL Server. Data Warehouse Multi-Dimensional/Star Schema design and performance special skills. Data Warehouse Metadata and Enterprise Metadata Repository design and administration experience. MDM leadership on Modeling, Data quality, data standardization, stewardship and governance. Business Objects design (Designer/Universe), Web Intelligence and Dashboard/EPM. Cognos modeling with Catalog, Transformer/Cubes and Framework Manager (and Cognos ReportNet administration with Single Signon/LDAP, etc.) Unix/Korn Shell scripts for Informatica.

WORK EXPERIENCE:

Confidential, San Francisco, CA

Solution Architect

Responsibilities:

• Lead overall project planning, design and development lifecycle.
• Meeting with end users and BA to collect and understand requirements.
• Authoring Enterprise Data Modeling Best Practice Standards and Guidelines.
• Architecture, Data Integration and Data Modeling of Enterprise Data, Active Data Warehouse, and Enterprise Metadata Repository. Data Modeling of the dimensional data warehouse, data mart, and ODS (Operational Data Store.)
• Data Modeling for Data Hub/CDI/MDM and EDI/SOA/BEA WebLogic, JBoss and AquaLogic Data Services
• Establish Data Strategy, Policies, Stewardship, and Governance.
• MDM/CDI Best Practice.
• Design, Deployment, implementation of MDM Data Hub.
• Data Quality and Data Anomaly Analysis.
• Architecture, ETL/Data Integration of all kind of data sources of in-house Customer, Account, Product/Service applications and commercial applications like SAP, Siebel Analytics/SRMW/DAC, PeopleSoft, Oracle E-Business Suite/Applications (Financials, HR, Order Management, Procurement,) etc.
• Design and development of the ETL processes with type 2, type 3 and hybrid slow changing dimensions.
• Data source analyses and profiling that include data from flat file, XML source, Oracle, DB2/UDB, Sybase, MS SQL, Mainframe/VSAM and Teradata and applications include PeopleSoft Finance/Oracle ERP/Applications, Ventive CRM, SAP CRM, SAP Financial and SAP BW, etc, and self-developed applications.
• Migration of Oracle, Informatica and Cognos, Siebel Analytics and in-house applications to Teradata.
• Oracle queries migration to Teradata BTEQ Scripts.
• Establish ETL/Informatica Best Practices on all kinds of RDBMS.
• Standardize ETL design, development, QA, implementation and production support.
• Performance tuning of the ETL, Siebel Analytics and BI (Cognos, Hyperion/Brio and Business Objects) used SQL statements including Analytic functions.
• Oracle, Teradata, UDB/DB2, MS SQL Server, etc, databases design and development, Logical and Physical design and performance tuning.
• Provide guidelines on the architecture of the BI tools and how to leverage the BI functions in the overall enterprise data warehouse systems.
• Unix/Korn Shell scripting for database and Informatica command calls.
• Production support, troubleshooting and problem solving for the above listed systems, etc.
• Consulting source of SQL and database performance.

Confidential

Responsibilities:

• Erwin Data Modeler and Model Manager/ModelMart, ER\Studio, PowerDesigner, and Rochade (Metadata tool).
• All kinds of database utilities and tools.
• Rational Data Architect/Rational Rose/UML, etc.
• All kinds of ETL tools (Informatica, Ab Initio, DataStage, and SSIS, etc.)
• All kinds of BI and OLAP tools (Business Objects, Cognos, MicroStrategy, Hyperion/Brio and SSAS, etc.)
• IBM Information Server (including WebSphere DataStage, WebSphere Information Analyzer, etc.)
• Siperian and Purisma|D&B MDM, etc, and FirstLogic for data cleansing.
• SuperGlue/Metadata Manager and Rochade, etc.

Confidential

Consultant/ Data Warehouse specialist

Responsibilities:

• Lead database and data warehouse architect, DBA and developer lifecycle.
• Redesign, remodel and development of the pre-built data warehouse/BI products.
• Multi-dimensional data warehouse architecture design with conformed dimensions, facts, data marts, etc (Kimball Methodology).
• ETL design and development for the above products for the clients.
• Architect, modeler and database developer of the Next Generation QOS on Voice over IP system.
• Provide consulting on the other next generation products on database design and performance improvement.
• Implementation of BI tools for clients all over the world: Cognos, Business Objects, Brio and MS Analysis Services, etc, and also created models (relational and dimensional OLAP) with all kinds of BI/OLAP tools.
• Worked on Teradata database design, data loading with international telecom clients with FastLoad, MultiLoad (MLoad) and TPump, etc.
• ERwin data modeler and PowerDesigner.
• ETL tools (Informatica, Oracle Warehouse Builder and Data Junction).
• Database tools including Oracle and Teradata tools and utilities and Toad, etc.
• BI tools like Cognos, Business Objects, Brio and MS Analysis Services/MDX, etc.
• PL/SQL package, trigger and SQL*Plus.
• Operating systems: Windows NT, Windows 2000 Server. Unix/Sun Solaris.

Confidential

DBA, Data Warehouse Architect and ETL Developer

Responsibilities:

• Data modeling (both relational/OLTP and OLAP/dimensional including dimensions, facts and data marts) and Data Architecture with ERwin, Designer/2000 and PowerDesigner (Kimball Methodology).
• Data Warehouse Metadata and Enterprise Data Repository administration.
• Korn Shell Scripts, PL/SQL, SQL*Plus and Oracle Utilities.
• ETL with Informatica and Oracle plus korn shell scripts.
• Database logical and physical design and performance tuning (Oracle and MS Sql).
• DBA on Oracle7.3 to 8.1.6 and SQL SERVER 6.5 to 2000.
• MS OLAP/Analysis Services/MDX dimensions and cubes design and development.
• Database installation and configuration, problem solving and troubleshooting, database upgrade and migration.
• ERwin data modeler Designer/2000 and PowerDesigner.
• ETL tools (Informatica and Data Junction).
• Database tools including Oracle Enterprise Manager, Oracle Management Package and Toad.
• PL/SQL package, trigger and SQL*Plus.
• Database tools including Oracle Enterprise Manager, Oracle Management Package and SharePlex database replication tool.
• MS SQL SERVER 6.5 to 2000 and MS Analysis Services/ Analysis Manager.
• Windows NT Server. Unix/Sun Solaris.
• Change control/management with VSS, etc.

Confidential

Sr. Software Engineer and DBA

Responsibilities:

• Collecting requirements and business rules from bank clients.
• Retail banking operational data modeling with ERwin data modeler and PowerDesigner.
• Internal CRM, Profitability and Marketing data warehouse data modeling and project coordinator with Epiphany.
• Database logical and physical design, configuration, problem solving and troubleshooting.
• Transaction SQL (T-SQL) development.
• Database and application development support and performance tuning.
• ERwin data modeler and PowerDesigner.
• Database tools: MS SQL Server Enterprise Manager.
• Operating systems: NT/MS Cluster Server administration.
• Supported programming tools and language: VC++ 5 and Forte.
• Change control/management with VSS, etc.

Confidential

Senior Software Engineer/Product lead

Responsibilities:

• In charge of a Budgeting and Planning product that was sold worldwide including George Pacific, Spades (large paper company in Spain), Ford, etc.
• The next generation product design and development.
• Data modeling and Oracle database DBA for the next generation product.
• Database performance tuning, problem solving and troubleshooting.
• ERwin data modeler and Oracle Designer.
• PL/SQL package, trigger and SQL*Plus.
• Pro*C/C++.
• UML, OOD using Rational Rose and OOP using VC++ 5.
• UNIX of HP, AIX and SUN Solaris.

Confidential

Systems Development Manger

Responsibilities:

• Collect requirements and evaluate scope and cost for projects.
• Project and systems development management on Decision Support Systems (DSS) and Business Operational Systems (BOS).
• Operations and Reporting System modeling for Financial services
• Database systems design and data modeling.
• Oracle 6 to 7.2 management and development with SQL*Plus, Pro*C, etc.
• Programming with C/C++.
• Operating systems: FACOM Mainframe, UNIX, DOS and Apple/Macintosh.

Confidential

Assistant professor/Systems Development Manger

Responsibilities:

• Collect requirements and feasibility studies.
• Project Development and Team Management.
• Databases: Dbase3 and 4, FoxBase and Oracle/SQL*Plus.
• Application development with Pascal and C/Pro*C.
• Operating Systems: FACOM Mainframe, UNIX and DOS.