LBM System Modeling Inc.
Expertise

Expertise

Our expertise is based on twenty years of experience of software applications design and development using various database and programming technologies.

  • Analysis, Modelling, Design, Architecture
    • Software architecture
    • Business domain analysis; requirements analysis
    • Data architecture; Data modelling; Database Design
    • Dimensional modelling; Data warehouse architecture
    • Business Intelligence
    • Application design and coding specifications
    • Object oriented analysis and design, UML.
    • Model-driven development (MDD); Meta data repository design and architecture
    • Web applications – full stack development
    • Security – implementation and integration of complex security requirements in web applications, middle-tier and the database. Role-based security, Virtual Private Database (row-level and column-level security), various authentication schemas (LDAP, database, etc.).
  • Oracle database and tools
    • PL/SQL
    • SQL
    • Oracle Developer (forms report)
    • Oracle Designer
    • Database design
    • Database and application tuning
    • APEX (Application Express)
    • Virtual Private Database
    • Other various Oracle database technologies
  • Databases
    • SQL Server
    • MariaDB
    • PostgreSQL
  • Business Intelligence
    • Power BI
    • Tableau
    • Jaspersoft, Jasper Report
  • Programming and Tools
    • Java
    • Python
    • Talend ETL tool
  • System Integration
    • Data migration, synchronization and replication between heterogeneous systems.
    • ETL design – in-depth understanding and experience with ETL for data warehouse systems.
    • Metadata integration – huge experience with metadata synchronization and integration between various modeling and development tools.
    • Custom development and extensions to packaged software