Converting from Logical to Physical: Discussion of the issues

1. 16843 Harbour Town Drive Silver Spring, MD 20905 Tel: 301.476.9190 Fax: 301.476.9195 Myriad Solutions, Inc. Converting from Logical to Physical: Discussion of the issues Manan Shah manan@myriadinc.net

2. Design Layer Architecture Traditional Modeling Cycle Logical vs. Physical Technical Demo Other Helpful Features Complementary Tools Q & A Agenda

3. CA Modeling Suite Data Model Validator ERwin Data Modeler Process Modeler Model Manager Model Navigator

4. Modeling Life Cycle Logical Only Model Model Derivation Model Derivation Model Sync. Physical Only Model Fwd. Eng. Rev. Eng. Complete Compare DB System (i.e. Oracle, MS SQL, DB2…)

5. Modeling Life Cycle(cont’d) Logical UpdateLogical Update Physical Physical Rev. Eng. Fwd. Eng. Complete Compare DB System (i.e. Oracle, MS SQL, DB2…)

6. Logical vs. Physical

7. Product Demo

8. Naming Standard File (.NSF) – Organization under utilize this feature. Name Hardening – Ability to lock object names, so accidental changes cannot occur. (Version 7.x Feature) Option Set – “DOUBLE-EDGED SWORD”. Shortens your development time by almost 50-60%, if used the right way. Sessions – Gives you the ability pause your complete compare and return at a later time.(Version 7.x Feature) Known Differences – Filter out object that will always remain as a conflict. (Version 7.x Feature) Helpful Features

9. Complementary Tools

10. Client/Account Portfolio Profile Product/Service Overview • Architecture, Design, Implementation, Customization, Integration, and Fulfillment of only CA Products with an Emphasis on AllFusion and AllFusion Enterprise Solutions. • Data Warehousing Architecture consulting and implementation expertise. • Focus on Federal/State/Local/Commercial compliance regulations, including DODAF, SOX, etc. • Complete support for Application Development Lifecycle. • Skill Sets: AllFusion Data Modeling, Non-Modeling (ESP), NIKU, GEN, Harvest, Unicenter SQL Station, and Commercial Storage and Security Products. Key Differentiators Key Features/Attributes • Technical staff is certified on Erwin Data Modeler and eTrust commercial products. • Expertise in Project, Process, and Portfolio, Management consulting services. • Change and Configuration Management consulting services. • GSA Schedule, NY State Contract, Approved Supplier to GSI’s. • Pre-Sales and Post Sales support on AllFusion (examples: PBGC, SSA, FedEx/Kinko’s, FDIC) • Working on 8A/Hubzone certification • Strong expertise in data architecture for modeling and non-modeling solutions. • Only sell CA Products. • Provide first line of support for the AllFusion line of products. • Financing options available (P3). • Competitive Product Displacement Initiative. Opportunity Fit • Federal Clients – US Army, USDA, Dept of Labor, US PTO, CACI, SRA, CDC • Commercial Clients – McKinsey, Fedex/Kinko’s, Blue Cross/Blue Shield of PA, Bristol Myers Squib, AOL, Brick St. Insurance, Raymond James, Circuit City, Cisco, GEICO, Lexmark, Manhattan Associates, Starwood Hotels • GSA Contract - GS-35F-0468N • NY State Contract • W VA State Contract • Approved Supplier for Lockheed Martin, SRA, Northrop Grumman, SCITOR, and CGI AMS. • AllFusion Product Sales (Modeling and Non-Modeling, Enterprise and Commercial Products). • Data Warehousing and Data Architecture consulting and implementation services. • GSA Opportunities/Fed Bid • Application Development Projects. • AllFusion Implementation and related services.