We provide IT Staff Augmentation Services!

Data Modeler Resume

Emeryville, CA

OBJECTIVE:

A position in data modeling, database and data warehouse design and development, performance tuning; pattern match and parsing algorithm design

SUMMARY:

  • Expertise in data modeling, conceptual, logical and physical database/knowledge base/data warehouse design, ETL, master data management or MDM
  • Application areas of OLTP, OLAP, ODS, Business Intelligence, Analytics
  • Extensive experience with Vertica,Teradata, Oracle, SQL Server, MySql, DB2;
  • High proficiency in SQL, SQL analytics, able to write complex SQL on the fly
  • Programming languages Python, R
  • In depth knowledge and understanding of Big data, variety of NOSQL, NewSQL
  • Research in pattern match, parsing (Essential Context Free Expressions)
  • Strong logical and mathematical analysis skills at system, conceptual, and tech levels
  • Data modeling tools: Erwin, Power Designer, ER - studio
  • ACM lifetime member

EXPERIENCE:

Data Modeler

Confidential, Emeryville, CA

Responsibilities:

  • Responsible for originating and maintaining a harmonized data model towards the goal of an integrated database for multiple products of the company for multiple clients.
  • Designed a normalized core data model and provided a variety of de-normalizations.
  • Provided hands on guidance for ETL, query optimization, performance tuning, transformation of SQL queries and stored procedures between SQL Server and Vertica. Using Er-Studio, test integration with Oracle Enterprise Healthcare Analytics, in the area of healthcare information analytics.

Data Modeler

Confidential, San Ramon, CA

Responsibilities:

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

Data Analyst contract

Confidential, San Francisco, CA

Responsibilities:

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

Data Architect

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

Data Architect consultant

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 including data modeling and sophisticated SQL query design, and all related ETL.
  • Provided database maintenance guidelines, naming standards and data governance

Data Architect Consultant

Confidential, San Jose, CA

Responsibilities:

  • Data modeling for Confidential enterprise data warehouse, with Teradata, using Power Designer; led data modeling projects for a big China division in Shanghai, China, and offering advice to junior DAs for ETL and related work;
  • Participated data modeling projects from counseling, full service, to advisory.
  • Proceeded in canonical data modeling approach in many sub areas.
  • Actively participated in DA group for setting standards and guidelines, including Meta data management and master data management, assumed responsibility for the overall data modeling compliance project.

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.
  • 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 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.

Hire Now