SUMMARY:

Dedicated and accomplished professional with 25+ years experience capable of delivering large scale, complex programs/projects and expertly implementing solution designs across multiple market industries; an exemplary manager responsible for all project portfolio actions, including initiating, planning, executing, installing, monitoring, controlling, and closeout; ensure deliverables are completed on time, within budget, and according to contract scope.

CORE COMPETENCIES:

• Team Leadership
• Data Architecture
• Data Modeling
• Testing & Evaluation
• Local Data Manager
• Project Management
• Training & Development
• Lifecycle Management
• Design & Development
• Customer Support
• Budget Negotiation
• Risk Management

TECHNICAL PROFICIENCIES:

Programming Languages: Cobol, Visual Basic, Assembly Language (ALC)

Platforms: Mainframe, NT, Unix

Data Modeling Tools: ERWin, Visio, IEF, ERStudio 7.5

ETL Tools: Ascential DataStage, Ascential QualityStage, SQL Server 2000 DTS, MS Analysis Services MDX, Evoke AXIO 4.4, Informatica Data Explorer 8.6

Metadata: Metadata Manager, Designed and Modeled Processes

BI Tools: BusinessObjects (versions 4, 6.5, XI), Brio, Hummingbird, MS Analysis Services, Crystal Reports V10 and 11

DBMS: BDAM, ISAM, VSAM, QSAM, Oracle, Ingress SQL Server 2000

PROFESSIONAL EXPERIENCE:

Confidential, San Francisco, CA

Data Architect

Responsibilities:

• Develop Physical scripts and create tables in development environment.
• Create scripts for migration between Dev, Test, UAT and Prod environments. Assist ETL developers and Q/A testers, as needed.

Environment: Oracle 11g, MS Project, ERWIN, SQL Developer

Confidential, San Jose, CA

Data Architect

Responsibilities:

• Formed development team of one (1) analyst, two (2) developers and Scrum Master/analyst.
• Partitioned workloads into scrums; created Mapping Documents.

Environment : Oracle 11g, MS Project, SQL Developer

Confidential, San Francisco, CA

Data Architect

Responsibilities:

• Documented source to target data mappings with business rules and transformation rules;.
• Developed data models: ERWin with SalesForce and CISCO, Embarcadero with NVIDIA, and Tableau with CISCO. Created Project Plans

Environment : Embarcadero, ERWin, MS Project, DB2, MS SQL Server, Oracle, Unix AIX, Pentaho, Business Objects Webi

Confidential, San Francisco, CA

Senior Solution Architect

Responsibilities:

• Proficiently utilized Informatica MetaData Manager for data lineage.
• Execute high quality deliverables and solutions by effectively analyzing risk assessments and meticulously follow Method Statements.

Environment : MS Project, Sybase Power Designer, DB2, TeraData, Unix AIX, Data Stage, Business Objects Webi, WIKI Web Sharing

Confidential, San Francisco, CA

Data Modeler

Responsibilities:

• Identified and operated within project scope for a new data source.
• Interpreted data source from existing documentation and Cobol Copybooks.

Environment : ERWIN, Oracle, Unix AIX, Informatica, Windows XP, WIKI web sharing

Confidential, San Francisco, CA

Data Modeler for Enterprise Datawarehouse

Responsibilities:

• Created and test scripts for physical database schema creation and modification.
• Developed the following models: Claims, Capitation, Provider - Physician, Pharmacy, Hospital, Dental, Contract, Membership, Group, Subscriber & Enrollee, Eligibility, Financial, Payments, and Cost of Healthcare.

Environment : ERWIN, Oracle, Unix AIX, Informatica, Windows XP, Microsoft Office (Word, Access, Visio, Excel)

Confidential, San Leandro, CA

Business Analyst/Data Analyst

Responsibilities:

• Reviewed data profiles with business users and established data cleansing and exception rules.
• Identified and documented data risks and contingency strategy; proposed Data Governance to establish data Lineage requirements.

Environment : Oracle, Unix AIX, Informatica, Windows XP, Microsoft Office (Word, Access, Visio, Excel)

Confidential, San Jose, CA

Data Warehouse Architect

Responsibilities:

• Validated data integrity after DW data loads compared the results with expected results.
• Established data modeling standards. Established documentation standards. Coordinated conformed Dimensions between EDW projects.
• Maintained Dimension and Fact table matrix as well as data source for each table.
• Designed data flow between project teams and loads. Established performance standards for data loads and SQL data reporting performance.

Environment : MS Project, ERWIN, Oracle, Unix AIX, Informatica, Windows XP, Microsoft Office, SAP BW

Confidential, Palo Alto, CA

Data Architect/Data Analyst

Responsibilities:

• Validated Account data after loaded into SalesForce. Participated with a team of Data Architects in the development of a Genentech Canonical Data Model.
• Developed Data Model for Case Management Migration Data and integrated the model into the Canonical Data Model.
• Performed Reviews for the Functional Specifications and Source to Target Mappings with Business Analysts and Developers.
• Provided templates for the Business Analyst to use for Business, Data, and Exception requirements.
• Used AXIO/Informatica Data Viewer for Data Profiling for the following steps of development: Functional Specification Analysis, Source to Target Mapping Analysis, and Data Validation after development.

Environment : Embarcadero, Oracle, Unix AIX, Informatica Data Explorer, Windows XP, Microsoft Office

Confidential, Palo Alto, CA

Data Warehouse Architect/PM

Responsibilities:

• Built the relational data model for the Staging database.
• Developed the multi-dimensional data model for the datamart; identified data merges areas that minimized table and data duplication.
• Architected the phases for data scrubbing, normalization and integration.
• Identified risks and mitigation strategies. Provided templates for the Business Analyst to use for Business, Data, and Exception requirements.

Environment : ER Studio, SQL Server, DB2, Unix AIX, BusinessObject XI, Windows XP, Microsoft Office

Confidential, Palo Alto, CA

Asset Analyst

Responsibilities:

• Managed and oversaw Supply Chain Assets; administered project Plan for Data and asset migration.
• Performed migration analysis into the Consolidated Data Center; issued coordination between business users, first line of support and support developers.

Environment : ERWIN, SQL Server, Unix AIX (scripts), SQL Server DTS, Windows XP, Microsoft Office

Confidential, Irvine, CA

Methodology Lead/Data Warehouse Architect

Responsibilities:

• Lead member of the corporate architect review board where we develop standards and policies for development methods.
• Designed database schemas both relational and star schemas to improve reporting and drill down performance.
• Documented the scopes iterations by leading user requirement meetings. Design and many data source to target transformation for developers using Ascential.
• Established the quality initiative for the Data Warehouse team, business users, and data source systems.

Environment : ERWIN, Oracle, Unix AIX, Data Stage, BusinessObjects, Crystal Reports, Windows XP

Confidential, Irvine, CA

Chief Data Warehouse Architect/Methodology Integration Lead

Responsibilities:

• Architected the new Data Warehouse SQL Sever 2000 DBMS. Architect and supervised the migration to SQL Server 64 bit from 32 bit.
• Developed the transition plan for migrating uses from the existing Data Warehouse to the new.
• Led member of the corporate architect review board where we develop standards and policies for development methods.
• Assisted Project Manager with plan development.
• Designed database schemas both relational and star schemas to improve reporting and drill down performance. Documented he scopes iterations by leading user requirement meetings.
• Designed and developed many data source to target transformation using MS SQL Server DTS scripts.

Environment : Embarcadero, DB2, SQL Server, NT Server (scripts), SQL (Stored Procedure and user defined function scripts for DML), Windows XP, Reporting Website, Website for ETL processes, Microsoft Office (Word, Access, Visio, Excel)