SUMMARY:

• A challenging position in data architecting, data modeling, database and data warehouse design and development; pattern match algorithm design
• Expertise in data modeling, conceptual, logical and physical database/knowledge base/data warehouse design, master data management or MDM, performance tuning
• Application areas of OLTP, OLAP, ODS, Business Intelligence, data analysis
• Extensive experience with Teradata, Oracle, SQL Server, MySql, DB2;
• High proficiency in SQL, on - the-fly SQL writer, SQL analytics,
• Programming languages Python, R for stats
• Working knowledge of Big data, NewSql, NoSQL, Vertica, MongoDB
• Research in pattern match, parsing (Essential Context Free Expressions)
• ACM lifetime member
• Strong logical and mathematical analysis skills at system, conceptual, and tech levels
• Data modeling tools: Power Designer, ERwin, ER-studio

PROFESSIONAL EXPERIENCE:

Data Modeler

Confidential, San Ramon

Responsibilities:

• Data modeling and related analysis and development for new ODS, EDW, MDM, using, Erwin, Oracle, Teradata, and canonical data modeling with Teradata model

Data Analyst contract

Confidential, San Francisco, CA

Responsibilities:

• Data modeling and data analysis with Teradata, Oracle, SQL Server, using Erwin for OLTP, ODS, EDW

Data Architect contract

Confidential, Foster City CA

Responsibilities:

• Data modeling for OLTP, ODS, EDW, MDM, in charge of naming standards, responsible for data modeling for many subject areas of logical and physical data modeling, with environments of DB2,Oracle, SQL Server,MySQL, coordinating with US and offshore resources, using Erwin. Exercised agile data modeling, canonical data modeling in many areas

Data Architect consusltant

Confidential, Milpitas, CA

Responsibilities:

• Database Design and Development for the business of an automated wireless phone testing system and service using SQL Server 2008. Worked on projects include robust and flexible data modeling and sophisticated SQL query design. Provided database maintenance guidelines, naming standards and data governance

Data Architect Consultan

Confidential, San Jose, CA

Responsibilities:

• Data modeling for Confidential enterprise data warehouse, with Teradata, using PowerDesigner; led data modeling projects for a big China division in ShangHai, China, and offering advice to junior DAs in the team; Participated data modeling projects from counseling, full service, to advisory, in areas across different domain areas of Confidential business. Proceeded in canonical data modeling approach in many sub areas. Actively participated in DA group discussions over design issues including standards and guidelines formulation and revision for different aspects of data modeling, including meta data management and master data management, assumed responsibility for the overall data modeling compliance project across all subject areas.

Data Architect Consultant

Confidential, Sunnyvale, CA

Responsibilities:

• Business analysis and data modeling (using Erwin) on projects for renovation of Confidential ’s Enterprise Data Warehouse and Business Intelligence applications under OBIEE Oracle Business Intelligence Enterprise Edition. Integration with Oracle CRM, Siebel, SAP, covering the domain areas of products, sales, billing, HR, inventory.

Database Consultant

Confidential, Santa Clara, CA

Responsibilities:

• Business analysis and SQL Server 2005 database application development for energy trading, for both OLTP and OLAP, SSIS, SQL and stored procedure coding, .Net environment

Data Architect

Confidential, San Jose, CA

Responsibilities:

• In charge of Data modeling, database design, tuning, participated database project management, worked on multi database instance optimization, requirement analysis and formulation, re-factorization of Party-Role, Promotion Pricing, Network Inventory, Process and Scheduling Management, migration from Oracle to MySql

Data Modeling Consultant

Confidential, Pleasanton, CA

Responsibilities:

• Data modeling, data schema maintenance and enhancement for misc. database, ODS, data mart, data warehouse systems for the business of credit/debit cards and general banking industry, also worked on business requirement formulation and data modeling standards.

Database Applications Consultant

Confidential, San Jose, CA

Responsibilities:

• Data modeling, Database and schema optimization, system data configuration, PL/SQL coding and performance tuning, requirement analysis and formulation, in the domain of Energy Trading, special application for data conversion from vertical to horizontal

Data Architect

Confidential, San Jose, CA

Responsibilities:

• In charge of data modeling, design standards, documentation, and schema maintenance; performed database related project management, conducted data model refactorizing, partner billing business re-architecting, data mart and warehouse architecting, XSD data modeling, query optimization for financial institution OLTP system, OLAP for financial analysis and fraud detection analysis.

Data Modeling Consultant

Confidential, Dublin, CA

Responsibilities:

• Conducted logical and physical data modeling tasks for business intelligence applications with data marts and data warehouse for mutual fund investment, worked on ODS, OLTP, and OLAP projects for the mutual fund management. Actively worked on database design standards and guidelines and meta data management.

Data Architect

Confidential, Mountain View, CA

Responsibilities:

• In charge of an SPM (service provider management) database design under SOA and its maintenance for the business of Enterprise Service Provider Management; performed project management for database related projects, designed a through database re-factorization, went through entire life cycle of materialized view design and implementation for reporting; and delivered it as means of transforming a reporting schema into a center part of a data warehouse; played key role in Multi-Tenancy, On-demand system design of the company’s next generation system.

Data Architect

Confidential, Alameda, CA

Responsibilities:

• In charge of design, development, and performance tuning of a relational database from scratch for a general purpose healthcare information system with modules of coding, compliance, correspondence, abstracting, electric signature, etc. Managed projects of database development including data warehousing and ODS, provided supervision, advice to the entire team on all database related projects, conducted FRD analysis and formulation, setup guidelines and conventions for data design, data quality.
• Designed and implemented innovative path index method for handling hierarchical coding and generic XML data. Pushed for canonical data modeling. Developed tools for schema comparison, data comparing, data difference resolving, and data transferring, semi-auto design defect detecting. Solved issues of DB vendor independence, migration between SQL Server and Oracle, data driven rule engine, dynamic data customization, systematic test data design, and common user database functions.

Database Architect

Confidential, Redwood City, CA

Responsibilities:

• In charge of design of a relational database (Oracle, ER/Studio) underneath the top level of FRS (Frame Representation System) knowledge base for life science and biology. Managed database related projects, investigated and developed innovative methods for storing and searching highly dynamic and structure-rich, computation-intensive data of hierarchies or DAG. Made a proposal of normal forms for storing DAG (directed acyclic graphs) within FRS on computational ontology.

Database Architect

Confidential, Milpitas, CA

Responsibilities:

• Responsible for design and development of Internet Phone, Fax, and roaming settlement database (Oracle) and data warehouse, participated in defining business rules regarding internet business pricing, marketing, billing, and reporting. Provided extensible pricing model. Delivered flexible and efficient schema design for both OLTP and OLAP. Provided query schemes for decision support.

Sr. Software Engineer Consultant

Confidential, San Jose, CA

Responsibilities:

• Responsible for migration of Legacy database into an Internet Information system (Portal).

Consultant Engineer, Project Lead

Confidential, Dearborn, MI

Responsibilities:

• Responsible for Database component design & development, performance tuning.

Consultant Software Engineer

Confidential, Dearborn, MI

Responsibilities:

• Application development for Compass Project, for car wholesale, retail, and credit.