EXPERIENCE SUMMARY

10 years experience in Data Modeling Relational Star Schema and Data Warehousing.

TECHNICAL SKILLS

• RDMS and tools: Oracle 7.3, 8.04, 8i 10g, Toad, MS SQL Server 2000, MS Access, Sybase SQLAnywhere, PL/SQL, Transact SQL
• Data Modeling tools: ERWin and S-Designor 5.1 for creation of BDM, LDM and PDM
• BI and ETL tools: DTS, Analysis Services, Business Objects, Brio, Sagent now Group 1 Software
• Misc tools: SubVersion SVN , PowerBuilder 6.5, Crystal Reports, Microsoft Word, Excel
• Project Management using Timeline and MS Project. PMI Project Management.

PROFESSIONAL EXPERIENCE

Confidential

Data Architect

Responsible for understanding and translating business and data requirements into an entity relationship logical model that represents the data in 3rd normal form with fully documented data definitions, relationships, cardinality and domains using ERWin 7. Maintain enterprise and application data models. Validate schema model for deployment, logical and physical.

Confidential

Data Warehouse and Application Data Modeler and Business Analyst

• Integrated Property Tax System for the County of San Diego
• Data Warehouse data modeling using CA Erwin 4.1.4 and Oracle 10g
• Application data modeling using CA Erwin 4.1.4 / 7.2 and Oracle 10g to 3NF
• Profile source data for both Application and DW systems for migration of heterogeneous source systems
• Subject Matter Expert SME for Data Modeling Lead Data Modeling efforts for project Worked with a large group of workers here on visa
• Define and document all business related requirements as functional lead for Customer Service
• Member of Change Control Board
• Advise on reporting and interfaces
• Work with other team leaders to develop detail plans and requirements

Confidential

Data Warehouse data modeling lead using CA Erwin 4.1.4 and Oracle 10g.

Confidential

Converted and profile the primary source data for the data warehouse from an one vendor system to another system. Converted the ETL Extract, Transform and Load routines using MS SQL server 2000 stored procedures and DTS. Create Analysis Services cubes and procedures to load data.

Confidential

Data Warehouse Consultant

• Converted and profile the primary source data for the data warehouse from an in house system to a vendor based system. Converted the ETL Extract, Transform and Load routines using Sagent 4.5 and MS SQL server 2000.
• Lead Data Modeling effort. Ensured data from the source systems matches the data in the staging area, which also balances to the data in the data marts.

Confidential

Data Warehouse Data Modeler

• Lead the development of data models, data flows and metadata for the data warehouse. Used ERWin and the development of data warehouse tables and ETL Extract, Transform and Load routines.
• Designed and created an enterprise wide relational database repository using Oracle 8i. Extensive hands on work with Sagent 4.5 for modeling, ETL and automation.
• Migrate data form original system to new system and ensured data from the source systems matches the data in the staging area, which also balances to the data in the data marts.
• Performed extensive relational data modeling.
• Create and maintain Business Objects universes.

Confidential

Lead Analyst

• Lead the creation of logical and physical data models to 3NF for order management process from initial order through product configuration and factory scheduling through customer installation. Originally developed in MS Access 2.0 as a MAPI mail enabled distributed database system. Profile source data for conversion from MS Access to SQL Anywhere. Worked with numerous offshore sales offices and factories.
• Responsibilities for security, stored procedures, triggers, etc.
• Responsible for systems infrastructure H/W, Communications, etc. Lead Teams of up to 5 people and was the primary interface with users.
• Used S-Designor 5.1, PowerBuilder 6.5, SQLAnywhere 5.5.04, WinBatch, Transact SQL and Crystal Reports for object oriented program development.
• Led the Data Warehouse team building decision support data access for Oracle Applications Financial, Manufacturing, and Projects using Sagent for ETL. Queries and reports were developed using Oracle Discoverer, which provides relational OLAP ROLAP for System Configuration and Oracle Applications analysis and reporting.

Confidential

Consultant

• Developed a Spares Management System using FoxPro for Windows 2.5 and Access 2.0. Responsibilities include system design, table design and creation, view/form/report generation.
• Developed a replacement tax analysis system for Foreign Sales Corporation processing using ANSI SQL and R:BASE. Responsibilities include table design to 3NF and creation, view/form/report generation, and transaction Cursor processing.
• Fixed price bid to develop a new marketing Automated Configuration and Proposal system using ANSI SQL Table and Cursor operations and R:BASE. Responsibilities include E/R diagrams, table design and creation, view/form/report generation, and transaction Cursor processing.

Confidential

Consultant

• Business Analysis of End User Computing. Field Engineering Dispatch System FEDS CICS / IDMS . FEDS migration from Santa Clara, CA to Utica, NY. CA7 Schedule.
• Extensive Data Modeling for Information Center
• Created Ingres database for PC application.