ݺߣ

ݺߣShare a Scribd company logo

Help4Access Application Development Methodology

?Download as PPTX, PDF?
?
S
Sasha Froyland

This document discusses Help4Access, a company that specializes in developing custom Microsoft Access database applications. It provides an overview of the company's mission, leadership, value proposition, and development approach. The company was founded in 1998 and has a 100% success rate helping over 100 clients leverage the full capabilities of MS Access. It also outlines Help4Access's three-phased approach to application development: analysis and design, development and deployment, and production. Finally, the document presents models depicting how MS Access applications fit within an enterprise architecture at different stages of maturity.

1 of 20
Download to read offline
Our Application Development approach to bring you higher ROI and competitive advantage
Introductions and Company Overview
Company Snapshot ? Founded in 1998 and HQ in the San Francisco, CA ? Subsidiary of Strategic Enterprise Solutions, which specializes in management consulting in enterprise architecture, data warehousing, and business intelligence. ? Mission: driven by the desire to help our clients leverage the full power of the Microsoft Access platform ? 100% success rate in helping >100 of companies with MS Access Database applications
Leadership ? Sasha Froyland (founder), is a certified Enterprise Architect with 22+ years of experience architecting IT solutions for companies in start-up to Fortune 500. ? The inspiration to develop this unique company came from his first-hand knowledge of working for highly successful companies like Time Warner Telecommunications, Level 3 Communications and StubHub. ? As start-ups, these companies recognized the advantage of leveraging MS Accesss flexibility to develop their core business systems. This key decision point was pivotal to their future success.
Value based objectives Higher Returns Customize Application Minimize CAPEX Reduce OPEX Our primary goal is to deliver a tailored application which meets the desired business needs effectively and delivers a higher return on investment for the application.
Why Help4Access? Commitment Credentials CapabilityCharacteristics Our application ensures security, data integrity, performance and scalability which means more effective the way you need Our vast experience in building MS Access database applications with pre- built Solution building blocks and Architecture building blocks that saves development time and effort Our past success stories with multiple happy customers who are willing to refer us (Time Warner, LifeWatch, L3 Communications, Laradon Hall etc.) The founders personal commitment as a leader to ensure every single corner is touched
An enterprise architecture view from 20,000 feet
Help4Access Application Development Methodology
An enterprise architecture view from 10,000 feet
Help4Access Solution Pyramid (10,000 feet view)
Our approach to development of MS Access Applications
Post phase 2, fully developed and tested solution ready for use (Phase 3 C Production) Development from physical requirements. Actual code within the application deployed into production. Business Requirements ? Statement of work ? Spreadsheets ? Sample Reports H4As Solution Building Blocks Microsoft Access Database Platform Three phased approach to development Physical requirements guided by ABB: ? Context & Process Flow Diag. ? Physical & Logical Data model ? Data Migration Plan ? Use Cases ? Data Dictionary ? Screen Layout You Architecture Building Blocks Phase 1: Analysis and Design Phase 2: Develop & Deploy
How a MS Access Application fits into Enterprise Data Management Strategy
Maturity of Enterprise Architecture Business Silos Architecture maximizes companies individual business units functional needs. Standardized Technology Architecture provides IT efficiencies through technology standardization and, in most cases, increased centralization of technology management. Optimized Core Architecture provides companywide data and process standardization. Business Modularity Architecture manages and reuses loosely- coupled IT-enabled business process components to preserve global standards while enabling local differences.
Access sweet spot in enterprise architecture maturity Stage 1 Stage 2 Stage 3 Stage 4
Regional vs global flexibility maturity matrix
Evolution of Microsoft Access Applications in an Enterprise Architecture Diagram (1/2) Stage1 BusinessSilos Goals: - Maximize business value. - Automate business processes. - Reduce costs. - Fast solution delivery. 2 1 MS Access (2) Technology Perspective: - Front-end: Microsoft Access application on PC. - Back-end: Microsoft Access database on fileserver. * (Most processing occurs on the PC) Business Perspective: - Individual applications. - Local business leaders. - Local/functional optimization. Stage2 Standardized Technology MS Access (2) Technology Perspective: - Back-end: Microsoft SQL Server. * (Processing split evenly between PC and SQL Server) Business Perspective: - Shared technical platforms. - Increase system performance and reliability. - Reduces costs and risks but decreases flexibility slightly. - As business services mature they provide increased revenue or decrease costs. Microsoft Access Lifecycle SQL Server Technical Perspective: - Front-end: Mixed. Immature business services MS Access (2) Web Applications(3) (3)
Evolution of Microsoft Access Applications in an Enterprise Architecture Diagram (2/2) 2 3 S - As business services mature they provide increased revenue or decrease costs. SQL Server Stage3 OptimizedCore Business Perspective: - Optimized data. - Optimized core business processes. - Eliminated data redundancy. - Data available across the organization. Data Warehouse BI Reporting Dashboards Fiber Channel (FC) Technical Perspective: - Front-end: Mixed. Immature business services remain on Microsoft Access while mature business services move to web platform. - Back-end: Centralized database server. - Business services migrate away from application layer towards web server. (3) - Most project involve corporate IT. * (Most processing occurs on web server). MS Access (2) Database Server Farm Web/ Application Server Web Applications n tier 2 tier 4 Stage4 BusinessModularity Data Warehouse BI Reporting Dashboards MS Access (2) Database Server Farm n tier Web Applications Service Orientated Architecture (SOA) FC FC Technical Perspective: - Business logic as services continue to migrate away from the application and application server layers to the Service Orientated Architecture (SOA) layer. (4) (3) (4) (3) (3) (3) (3) (3) Over time business services migrate from Microsoft Access applications (stage 1) into SOA (stage 4) layer. Business Perspective: - Organization optimized for global flexibility as well as locally flexible.
ClientTele
Analyze & Design Develop & Deploy Application Production Value Delivery Thank You! Next Steps Name Designation Contact No. Name Designation Contact No. Data is your companys most valuable asset. Dont trust it to just anyone. Trust it only to the best

More Related Content

Help4Access Application Development Methodology

  • 1. Our Application Development approach to bring you higher ROI and competitive advantage
  • 3. Company Snapshot ? Founded in 1998 and HQ in the San Francisco, CA ? Subsidiary of Strategic Enterprise Solutions, which specializes in management consulting in enterprise architecture, data warehousing, and business intelligence. ? Mission: driven by the desire to help our clients leverage the full power of the Microsoft Access platform ? 100% success rate in helping >100 of companies with MS Access Database applications
  • 4. Leadership ? Sasha Froyland (founder), is a certified Enterprise Architect with 22+ years of experience architecting IT solutions for companies in start-up to Fortune 500. ? The inspiration to develop this unique company came from his first-hand knowledge of working for highly successful companies like Time Warner Telecommunications, Level 3 Communications and StubHub. ? As start-ups, these companies recognized the advantage of leveraging MS Accesss flexibility to develop their core business systems. This key decision point was pivotal to their future success.
  • 5. Value based objectives Higher Returns Customize Application Minimize CAPEX Reduce OPEX Our primary goal is to deliver a tailored application which meets the desired business needs effectively and delivers a higher return on investment for the application.
  • 6. Why Help4Access? Commitment Credentials CapabilityCharacteristics Our application ensures security, data integrity, performance and scalability which means more effective the way you need Our vast experience in building MS Access database applications with pre- built Solution building blocks and Architecture building blocks that saves development time and effort Our past success stories with multiple happy customers who are willing to refer us (Time Warner, LifeWatch, L3 Communications, Laradon Hall etc.) The founders personal commitment as a leader to ensure every single corner is touched
  • 10. Help4Access Solution Pyramid (10,000 feet view)
  • 11. Our approach to development of MS Access Applications
  • 12. Post phase 2, fully developed and tested solution ready for use (Phase 3 C Production) Development from physical requirements. Actual code within the application deployed into production. Business Requirements ? Statement of work ? Spreadsheets ? Sample Reports H4As Solution Building Blocks Microsoft Access Database Platform Three phased approach to development Physical requirements guided by ABB: ? Context & Process Flow Diag. ? Physical & Logical Data model ? Data Migration Plan ? Use Cases ? Data Dictionary ? Screen Layout You Architecture Building Blocks Phase 1: Analysis and Design Phase 2: Develop & Deploy
  • 13. How a MS Access Application fits into Enterprise Data Management Strategy
  • 14. Maturity of Enterprise Architecture Business Silos Architecture maximizes companies individual business units functional needs. Standardized Technology Architecture provides IT efficiencies through technology standardization and, in most cases, increased centralization of technology management. Optimized Core Architecture provides companywide data and process standardization. Business Modularity Architecture manages and reuses loosely- coupled IT-enabled business process components to preserve global standards while enabling local differences.
  • 15. Access sweet spot in enterprise architecture maturity Stage 1 Stage 2 Stage 3 Stage 4
  • 16. Regional vs global flexibility maturity matrix
  • 17. Evolution of Microsoft Access Applications in an Enterprise Architecture Diagram (1/2) Stage1 BusinessSilos Goals: - Maximize business value. - Automate business processes. - Reduce costs. - Fast solution delivery. 2 1 MS Access (2) Technology Perspective: - Front-end: Microsoft Access application on PC. - Back-end: Microsoft Access database on fileserver. * (Most processing occurs on the PC) Business Perspective: - Individual applications. - Local business leaders. - Local/functional optimization. Stage2 Standardized Technology MS Access (2) Technology Perspective: - Back-end: Microsoft SQL Server. * (Processing split evenly between PC and SQL Server) Business Perspective: - Shared technical platforms. - Increase system performance and reliability. - Reduces costs and risks but decreases flexibility slightly. - As business services mature they provide increased revenue or decrease costs. Microsoft Access Lifecycle SQL Server Technical Perspective: - Front-end: Mixed. Immature business services MS Access (2) Web Applications(3) (3)
  • 18. Evolution of Microsoft Access Applications in an Enterprise Architecture Diagram (2/2) 2 3 S - As business services mature they provide increased revenue or decrease costs. SQL Server Stage3 OptimizedCore Business Perspective: - Optimized data. - Optimized core business processes. - Eliminated data redundancy. - Data available across the organization. Data Warehouse BI Reporting Dashboards Fiber Channel (FC) Technical Perspective: - Front-end: Mixed. Immature business services remain on Microsoft Access while mature business services move to web platform. - Back-end: Centralized database server. - Business services migrate away from application layer towards web server. (3) - Most project involve corporate IT. * (Most processing occurs on web server). MS Access (2) Database Server Farm Web/ Application Server Web Applications n tier 2 tier 4 Stage4 BusinessModularity Data Warehouse BI Reporting Dashboards MS Access (2) Database Server Farm n tier Web Applications Service Orientated Architecture (SOA) FC FC Technical Perspective: - Business logic as services continue to migrate away from the application and application server layers to the Service Orientated Architecture (SOA) layer. (4) (3) (4) (3) (3) (3) (3) (3) Over time business services migrate from Microsoft Access applications (stage 1) into SOA (stage 4) layer. Business Perspective: - Organization optimized for global flexibility as well as locally flexible.
  • 20. Analyze & Design Develop & Deploy Application Production Value Delivery Thank You! Next Steps Name Designation Contact No. Name Designation Contact No. Data is your companys most valuable asset. Dont trust it to just anyone. Trust it only to the best