PROFESSIONAL EXPERIENCE:

Confidential, San Ramon, CA

Senior Data Architect

Responsibilities:

• As a senior data architect with 16 years of data modeling; primarily with Erwin; I complete all logical and physical dimensional modeling for new schema changes for various database platforms. I also reverse engineer existing schemas that have no supporting models and build the logical to support the physical implementation for the data warehouse, staging, data marts, etc. One current project is to analyze the Treasury Data Mart (without requirements) and identify a solution to be placed in the current enterprise data warehouse. The approach is to analyze the data using Toad, with various custom made queries. Job requirements;
• Develops and documents artifacts and templates in the chosen tool repository.
• Develop, validate and communicate modeling solutions, including both relational and dimensional models
• Analyze data - related systems integration opportunities and challenges
• Ensure solution designs address performance requirements and reusability, availability, integrity and security challenges, and business functional requirements
• To collaborate to design and develop high performing databases and maintain consistent data element definitions.
• Create conceptual data models that need to be validated with Business Users for current projects as well as other impacted projects

Confidential, San Francisco, CA

Senior Data Architect

Responsibilities:

• As a senior data architect with 16 years of data modeling; primarily with Erwin; I complete all logical and physical modeling for new schema changes for various database platforms. I also reverse engineer existing schemas that have no supporting models and build the logical to support the physical implementation. I work closely with domain experts, developers, business analysts and programmers to ensure all requirements are met in a flexible and accurate fashion, while supporting the agile methodology practices. Duties included;
• I maintain the Enterprise Common Logical Model (CLM), for the purpose of linking to the physical models. The linking effort allows data lineage reporting, which is leveraged for impact analysis on new changes to existing elements. To create a more complete lineage report, .xsd files for all service level items were imported as well. These were also modeled to give a complete picture of all services leveraged for our on line stores.
• I review/approve all DDL for any and all schema changes
• I worked pro-actively with Data Stewards and Subject Matter Experts and other specialist to help resolve data conflicts and data quality issues.
• Major contributor of the master data management specific designs and the core entities

Confidential, Collegeville, PA

Senior Data Modeler

Responsibilities:

• Responsible for data modeling both logical and physical, data analysis, process modeling. Completed installation, upgrading, testing, and support of the CA modeling tool suite; (ERwin Data Modeler, Data Model Validator, Process Modeler, Model Manager, Model Navigator), that are used to support the Enterprise Information Management initiative. I was involved with data rationalization of Entities and Attributes within the Corporate Logical Data Model. Data rationalization consists of data analysis, standardization of data and domain names, mapping attributes to legacy data fields and generation of physical names.
• Project and system knowledge includes; ongoing enhancements to existing source systems (Pricing Excellance, Rebox, Transportation Inititive, BI/DW, EDM, third party systems (PROS, SFDC, Sales Logic Eloqua, DnB, Oracle Financials, etc) Responsibilities: Reverse engineer databases ( SQL, Oracle, Progress, etc) or obtain data model definition for company or vendor systems. Organize data model presentation to be meaningful for analysis, analyze data model content and add metadata definitions as needed, summarize a the data model from a business rule and model feature perspective, compare various models for the same subject area and map similar objects, documenting the mappings as metadata, assure completeness of definition by interviews and work with steward and custodial groups, export all models to Model Manager for inclusion in a metadata repository, data Model Design and Definition, consider known requirements and future flexibility to abstract data requirements and devise flexible and robust data models, devise appropriate designs for operational, warehouse, and analytic needs, and for enterprise versus parochial application, complete logical data model design and definition in Erwin, assurance conformance of models to enterprise standards for data definition and data model practices, conduct/ participate in peer reviews of data models to assure conformance to standards and practices and to assure a good solution fit to requirements and business goals, configure and administer the CA
• Model Manager and ERwin modeling tool suite for enterprise use. Completed testing (proof of concept) on various data profiling tools to be selected for purchase; tools included Trillium, Data Profiler and Informatica. The testing involved using address data for our servicing customer address and third party address data.

Confidential, San Francisco, CA

Data Model Administrator

Responsibilities:

• Develop guidelines and procedures for managing the "check in" and "check out" of Data Models supporting the following platforms; Teradata (EDW), Oracle and SQL. Develop and test a process for converting Models created in other tools into Erwin. Assist in developing plans outlining the infrastructure requirements for centralized Model administration. Managing Model Mart/ERwin upgrades and applying service packs for product fixes and enhancements. Define the appropriate security model for accessing data models in Model Mart and setup versioning as appropriate. Provide recommendations for tuning the Model Repository for model access. Develop and publish Data Model Reports in different formats (CSV, DDE, etc.) as required by Users. Manage tool licenses for All Fusion Modeling tools. Train, assist and manage over 75 users with all tool features.

Confidential, Irvine CA

Data Analyst

Responsibilities:

• I designed logical/1st draft physical relational data models for automotive manufacturer. On a regular basis reverse engineered existing databases (SQL and DB2) to create a data model library of existing structures using ER Studio. I am in the process of cross- for support in Business Objects Universe Design and Web Intelligence. I assisted in reporting accuracy review using Crystal Reports/ Crystal Dashboards and provide recommendations for discrepancy resolution.

Confidential, Orange, CA

Programmer Analyst

Responsibilities:

• I designed logical/1st draft physical relational data models for large mortgage company. I maintained Modelmart libraries and project subject areas for an Oracle database platform.

Confidential, Orange, CA

Data Analyst

Responsibilities:

• My work was divided with 85% of my time creating logical/physical data models for OLTP applications and the other 15% completing modeling for a data warehouse environment.
• Facilitated logical JAD sessions to discuss/gather business requirements for both internal and customer facing applications for all assigned projects. This process included; scheduling meetings with the business and application groups, documenting agendas and minutes.
• Assisted in the development of the data warehouse model. Adding new fact and dimensions for the Procurement department.
• Collaborated and developed the first Enterprise Business Model for application and business team .
• Designed logical transactional model for a Promotional Database; which included approximately 30 new entities and over 250 attributes.
• Maintained standard glossary terms to help design first cut draft of physical tables/columns names.
• Maintained standard domain/datatype dictionary to ensure consistency and assist in the first cut draft of the physical structures.
• Used and analyzed existing table and columns in our Modelmart libraries to promote reusability f existing structures. These libraries consisted of large and small subject areas. DB2 libraries = over 1200 tables, SQL libraries = over 800 tables, UDB = over 200 tables.
• Reviewed DDL to data models to ensure integrity and accuracy.
• I assisted in reporting accuracy review using Microstrategy and provide recommendations for discrepancy resolution.

Confidential

Data Model Administrator

Responsibilities:

• I ensured that established standards and practices are adhered to during the logical and physical design of the data modeling; using current modeling tools Erwin and Modelmart. Maintained all data models in Modelmart libraries for all platforms; DB2, SQL, UDB. I was a team player in developing and maintaining documentation for our department modeling standards.
• Developed standard reports for model validation that would assist in identifying model inconsistencies.
• I was involved with all beta testing of new releases and patches for Erwin and Modelmart.
• I was the system administrator for Erwin and Modelmart.
• I created different subject area structures for business support and modeling prints.