SUMMARY:

• 35 years of IT experience. 20 years of data warehouse and business intelligence focus. Modeling/DWH, Architecture, Project Management, Account Management, Portfolio Management, technical proficiency.
• Provided directional advice and created conceptual, logical and physical models for building Health Information Exchange for a regional BC/BS affiliate. Architected HL7 to XML to database process. Performed physical tuning. (Teradata 14.10).
• Created semantic model for cross LOB BASEL reporting. Focus on Automotive Finance (Teradata 14.10).
• Resolved data architecture issues for multinational banking and financial services corporation including: review and modification of dimensional model, generation of physical model across multiple environments and resolving performance and process issues (Oracle Exadata 11.2).
• Created 3NF logical model for Emergency Department based on the Medhost Emergency Department application using the Teradata Health Care Logical Data Model. Developed Emergency Department metrics by profiling Medhost software. Developed Meaningful Use Stage 2 med extract from Medhost (Teradata 14.0, SQL Server 2005/2008. Erwin 8).
• Developed initial sub - surface model for wells using non-traditional drilling (hydraulic fracturing) using the Teradata Oil and Gas logical data model (Teradata 13.1, Erwin 7).
• Integrated and enhanced European logical model for use in North and Latin America for a multi-national corporation using the Teradata Logical Data model (Teradata 13.1, Erwin 7).
• Ported ETL using stored procedures written in T-SQL to SQL Server Integration Services (SSIS) ETL tool. No documentation existed. Determined business rules by analyzing over 2000 lines of SQL (SQL Server 2008),
• Created dimensional models used for various Enterprise Asset Management analytical functions at the Confidential . Reviewed, recommended, and implemented changes to data architecture (ERP, ODS, DW and Data Marts). Worked closely with Informatica ETL developers to create data maps and ETL processes. Worked closely with Cognos report writers and Cognos Framework developer to establish robust reporting environment. Developed dimensional data models. Worked closely with DBA’s to dramatically improve DB performance (Oracle 10, Erwin 7) .
• Maintained and enhanced cubes used for analysis by Confidential Global Market Industry Analysis function. Architected new MS SSAS/SSIS solution providing analysis for senior level (CEO, COO) level management. Created dimensional models (SSIS ROLAP/MOLAP) (SQL Server 2005).
• Developed DW/BI architecture for Confidential Material Cost Reporting. Created data architecture including data models (3NF/Dimensional), designed and coded ETL solution (PL/SQL), assisted Cognos architect and report writers (Oracle 11, Erwin).
• Built conceptual data model for a regional Health Care Provider. Architect, planner, project manager and technical contributor to phase 1 Business Intelligence application (Oracle 10.0).
• Architected, planned and costed phase 1 Business Intelligence system for a logistics company. Developed data architecture. Worked closely with client HW experts to develop hardware architecture (MS Access, Oracle 10.0, Erwin).
• Helped public school district to implement Cognos reporting solution by modifying Cognos catalogs and Informatica ETL maps.
• Program Manager for MIROR reporting system at Confidential . In first 90 days, initiated 6 projects (SAS, Ascential ETL products, and other development) for Actuarial department at MIC totaling over $1.5M. SDP-21 methodology used in all Confidential projects. Managed internal and external (remote and offshore) resources. Negotiated contracts.
• Portfolio manager for Confidential Powertrain Compliance and . Supervised 6 contract employees. Initiated process re-engineering effort. Responsible for $2M annual budget. Managed internal and external (remote) resources. Negotiated contracts.
• Project manager for Confidential Production Volume reporting mart from inception to completion including business requirements, ETL requirements, hardware/software requirements, tools evaluation, contract negotiation, end user for Cognos Query. Managed internal and external (remote) resources. Negotiated contracts.
• Project Manager for Confidential VSSM Data Warehouse. Reduced operating and development costs for VSSM Data Warehouse by over $1M. Negotiated contracts with EDS. Worked with business units to develop requirements. Worked with Confidential IS&S organizations to develop common data model across business units. Managed internal and external (remote) resources. Negotiated contracts.
• Project manager for Confidential Distribution reporting mart. Produced reports using Microstrategy and Oracle Discoverer. Negotiated contracts with Microstrategy and Oracle. Worked with business unit to develop requirements, train users on Oracle Discoverer and data model. Managed internal and external (remote) resources. Negotiated contracts.

TECHNICAL SKILLS:

Software/ Hardware: MS Windows (clients and servers), UNIX, Linux, C, Informix 4GL, MS VB, Oracle 8/9/10, PL/SQL, SQL Server, Toad, Informix 5/7, ErWin 4/7, IIS, Cognos Query/Impromptu/IWR/PowerPrompt/Architect/Framework Manager/ReportNet, MS Project, MS Office, TCP/IP, HP, Sun, AT&T, IBM, Dell, EMC, Informatica Designer/Server Manager,/Repository Manager, Microsoft SQL Server, SSIS and SSAS

WORK EXPERIENCE:

Senior Data Modeler/Data Architect

Confidential, Union, New Jersey

Responsibilities:

• Responsible for creating data model for the product subject area by understanding DDL, ETL (using SQL) developed during a failed effort by a vendor to install a product. Teradata 14.10, Erwin 9.x.

Senior Data Modeler/Data Architect

Confidential, Teaneck, New Jersey

Responsibilities:

• Provided directional advice and created conceptual, logical and physical models for building Health Information Exchange for a regional BC/BS affiliate. Responsible for BASEL Committee on Banking Supervision reporting semantic layer for automotive finance division of a major bank and physical data model for major hospitality vacation sharing data warehouse. Teradata 14.10, Erwin 9.x, 7.3, Embarcadero ER/Studio.

Senior Data Modeler/Architect

Confidential, Plantation, Florida

Responsibilities:

• Responsible for data modeling and architecture for Atlantis Resort (Bahamas). Assessed current environment including SSIS, Teradata physical implementation and physical data model. Installed and configured ABU. Performance tuning using DBQL, Viewpoint and SQL explain plans. Tuned physical database (PI, skewing, cardinality indexing, STJI). Teradata 14.10.

Senior Data Modeler/Architect

Confidential, New York, New York

Responsibilities:

• Responsible for data modeling and architecture for Intraday Exposure, Enterprise Risk Integration project. Extremely high profile project with global economic ramifications. Project is monitored by the Federal Exchange Commission. Enhanced and modeled logical and physical model using Erwin 9.5. Provided architecture recommendations to support alignment of SLA’s, business requirements and performance. Oracle 11.2 Exadata, Erwin 9.5.

Data Modeler/Data Architect

Confidential, Naples, Florida

Responsibilities:

• Created 3NF logical model for Emergency Department based on the Medhost Emergency Apartment application Responsible for sourcing and source to target mapping for Emergency Room metrics for approximately 70 hospitals. Assisted in metadata management (Erwin) and model enhancements (Teradata Health Care LDM). Teradata 14.0, Erwin 8.2, SQL Server 2008 R2.

Senior Data Modeler

Confidential, Houston, Texas

Responsibilities:

• Lead logical modeler. Developed initial sub-surface model for wells using non-traditional drilling (hydraulic fracturing). Base logical model is the Teadata Oil and Gas Logical Data Model. Teradata version 13.10. Oracle 9/10. Erwin 7.3.

Lead logical modeler

Confidential, Englewood Cliffs, New Jersey

Responsibilities:

• Integrated and enhanced European Order to Cash and Sales Performance model for use in Latin America. Subject areas included but not limited to sales, deliveries and various hierarchies. Used SAP R/3 tools to profile data and map SAP source to model Base logical model is the Teadata Manufacturing Logical Model (mLDM) version 5.0. Teradata version 13. Oracle 9/10. Erwin 7.3, SAP R/3.

Senior Data Modeler

Confidential, Hartford Connecticut

Responsibilities:

• Responsible for logical and physical modeling. Focused on BOM for Commercial and Military Engines and assisted with data mapping from SAP R/3 to Teradata. Base logical model is the Teadata Manufacturing Logical Model (mLDM) version 5.0. Teradata version 2.6. Oracle 9/10. Erwin 7.3, SAP R/3.

Senior Data Modeler/Data Architect

Confidential, Cincinnati Ohio

Responsibilities:

• Responsible for Logical and Physical modeling, Fuel and Carbon Systems, myEngines mobile application and eRedBook metal/composite performance application at General Electric Aviation. Base logical model is the Teadata Manufacturing Logical Model (mLDM) version 5.0. Teradata version 2.6. Oracle 9/10. Erwin 7.3.

Senior Consultant (MicroStrategy Employee)

Confidential, Alpharetta Georgia

Responsibilities:

• After passing employee at MicroStrategy, ported ETL using stored procedures written in T-SQL to SQL Server Integration Services (SSIS) ETL tool. No documentation existed. Determined business rules by analyzing over 2000 lines of SQL, profiling the databases and interviewing subject matter experts. (SQL Server 2005)

Data Modeler

Confidential, Chattanooga, Tennessee

Responsibilities:

• Responsible for gathering requirements and developing logical and physical dimensional models used for Enterprise Asset analysis. Created 7 stars including work flow analysis and work order cost analysis. (Oracle 10g, Toad 8.x, Erwin 7.2)

ETL Developer

Confidential, Medley, Florida

Responsibilities:

• Responsible for developing and testing enhancements to the BI system. (Oracle 10g, SQL Developer 1.5.4)

BI Architect, Data Modeler, Developer

Confidential, Detroit, Michigan

Responsibilities:

• Responsible for maintaining and enhancing cubes uses for various analytics. Primary data source is JD Power Power Information Network. Responsible for gathering requirements, designing and building new cubes for Confidential sales analytics. (SQL Server, SSIS and SSAS 2005 and 2008, Erwin).

Independent Consultant

Confidential

Responsibilities:

• DataModeler/Data Architect for new EDW/BI solution with Material Cost Performance Requirements as the first subject area. Responsible for gathering requirements, data model and data mapping and ETL. Source system is MRP and Purchase Orders subject area of Oracle eBusiness 11g. Responsible for installing and configuring OWB 10gR2. (Solaris, Oracle DB 9/10, OWB 10gR2, Erwin).

Confidential, Detroit, Michigan

Responsibilities:

• Data Modeler/Data Architect for professional claims subject area. Led team of employees and contractors to create data models, source to target mapping, ETL processes, data quality processes for claims subject area of a new data warehouse initiative. Experience with HIPAA 835 and 837, data model review, mining requirements from COBOL programs and ETL requirements from IBM mainframe (Informatica).

Confidential, Cleveland, Ohio

Responsibilities:

• Installed, configured and created initial mapping using Oracle Warehouse Builder 10gR2 and Oracle 9i and 10g databases.

Senior Consultant

Confidential, Detroit, Michigan

Responsibilities:

• Working at a regional Health Care provider, initial project successfully created conceptual data model. Currently acting as project manager, architect and data modeler for Phase 1 Business Intelligence application primarily employing Oracle technology stack (10g database and OWB 10.2). Source systems include Clinical Case Management and Perot Diamond Claims Management system. (Erwin)

Data Warehouse Architect, Project Manager, Data Modeler

Confidential, Columbus, Ohio

Responsibilities:

• Working at a national logistics company, initial project successfully created conceptual data model. Architected, planned and provided cost estimate for Phase 1 Business Intelligence application.

Independent Consultant

Confidential, Detroit, Michigan

Responsibilities:

• Determined requirements and developed new reports for the Detroit Public Schools Office of Research Evaluation and Assessment using Cognos Impromptu, IWR and Powerprompt. Created and modified scripts to load data into reporting database using Informatica Designer, Server Manager, Repository Manager, Oracle SQL Loader and PL/SQL scripts.

Data Modeler

Confidential, Mayfield Village, Ohio

Responsibilities:

• Responsible for developing requirements, logical and physical model for Confidential Enterprise Data Warehouse. Source system is Oracle Financials, A/P and P/O Erwin employed as modeling tool.

BI Developer

Confidential, Detroit, MI

Responsibilities:

• Responsible for creating dealer reporting metrics using Cognos ReportNet and Framework Manager, Oracle 9i, PL/SQL and Unix ksh. Performed analysis, development and testing.

Data Architect

Confidential

Responsibilities:

• Responsible for creating physical model for spoke and hub architecture for spirits and beverages company headquartered in Bristol, England. Worked with resources in Canada and Europe.

Program Manager

Confidential, Southfield, MI

Responsibilities:

• Responsible for project management and program development for the MIROR reporting system (data warehouse) for the Actuarial department of Confidential, Motors Insurance Company. Followed SDP-21 structured methodology.

Independent Consultant

Confidential

Responsibilities:

• Held various positions including portfolio manager for Confidential Powertrain Compliance and, architect for Compliance and at PowerTrain and portfolio manager for Vehicle Sales, Service and Marketing. Managed data warehouse for VSSM and built data marts for Distribution and Compliance and . Responsible for requirements, budget, tool/hardware evaluation, and SDLC. Data marts were approximately 300 gigabytes each, largest tables have 1.5 billion rows. Followed SDP-21 structured methodology. (Oracle 9i, 10g, PL/SQL, HP-UX, Korn Shell)

Architect/Supervisor

Confidential

Responsibilities:

• Technical account manager, pre-sales system engineer, pre-sales system engineer supervisor for Confidential . Responsible for technical account management at Confidential, Troy, MI. Responsible for supervision of 5 system engineers in Midwest Region. Responsible for responding to RFP’s, RFQ’s.