InspireIT Information Technologies Consultancy has been established at April 2003 to provide consultancy and software services on information technologies area in Europe, Middle East and CIS region. Throughout the short period since our startup, InspireIT has provided various types of IT outsourcing, consultancy, education, support services and software projects under subject areas of Oracle/Internet Technologies and Datawarehouse/Business Intelligence Reporting Systems and became one of the leading firms in its area. In all the projects involved, our timely and successful approach has been rewarded by the clients and InspireIT has become one of the most trusted partners of its customers.
After Geocell changed the billing system for prepaid subscribers in 2014, there was a need for a new Data Warehouse design. Geocell Data Warehouse projects (DWH) aimed to meet the customer's sales, marketing and finance teams' urgent reporting requirements through the new billing system. InspireIT experts worked actively in the analysis, design, ETL code development, testing and loading of historical data phases. After an intensive requirement analysis phase, new reporting needs of the business units were identified, new Logical Data Model design was completed and ETL flows were developed.
As part of the project's first phase, all historical modules, prepaid and postpaid call details and Datamarts for Subscribers and Accounts have been historically loaded into the new Data Warehouse model. In the second phase of the project, the Reporting Universe was redesigned, more than 50 reports were developed, and the existing postpaid subscriber ETL codes were merged. The projects have been completed on time and on budget in accordance with the plan.
As part of the consultancy agreement with InspireIT, we moved Alternatifbank production and test environments from 8i to 10g. Following this mission-critical operation, we implemented RMAN backup work, conducted healthcheck studies for performance bottlenecks and implemented Oracle Data Guard at our remote disaster recovery center. All these works have been completed successfully thanks to InspireIT’s results driven and dedicated efforts. Currently we are conducting Oracle Database Vault and Security products’ test and deployment studies as part of the compliance work.
InspireIT performed the backup system evaluation, provided recommendations, implemented changes, and tested backup/recovery of all databases. InspireIT deployed Oracle Recovery Manager (RMAN) integrated with Symantec Backup Exec tape library to backup these large, growing databases. The use of multiple backup channels, RMAN catalog enabled the company to meet their business guidelines and maintenance windows.
Project is aimed to migrate data between different applications (Logali to Oracle Retek RMS) and different platforms (AS/400 to Unix systems) at database level. Project took place for 1 year at customer site in the UK and Turkey. Application migration architecture design, development phases are followed by Data Quality and Data Synchronization tasks between dual maintained systems. Project is completed successfully on budget.
Hugo Boss production systems has been switched from single instance to clustered Oracle 10g RAC technology. All phases of the transition including analysis, upgrade management, and proction migration has been accomplished sucessfully.
Mascom Oracle Applications 11i ERP production system databases has been upgraded from 9i to 10g with minimal downtime.
Database Healthcheck Studies have been conducted in various sector-leadýng clients throughout Istanbul - Grundig, Coca Cola, Düzey Pazarlama, Baylas etc. Several overlooked issues are highlighted -missing configurations, inadequate database parameter values, open database security points, sub-optimal database performance metrics-, shared with customer database administration teams and actioned accordingly within the scope of the onsite studies.
Beko/Grundig production Oracle RAC databases are optimized for top performance. As part of the study, Oracle databases are switched from Standard Edition to Enterprise Edition and cluster registry and datafiles are moved on to new ASM disk groups. Cluster, ASM and Database homes are patched to the latest release and performance tuning has been done based on real-time loads. Mission-critical operation is completed with minimal downtime and risk.
Schneider Electric factory automation reporting system implementation has been started with Oracle BI Suite . By the delivery of the project in a short time, key users have been able to generate customized reports, conduct ad hoc queries and use dynamic reporting infrastructure of dashboards.
Remote Database Administration Services started for Hedef Alliance Production database systems.
Remote Database Administration Services started for KVK Production database systems.
InspireIT has been completed following project tasks for Data warehouse Reengineering ( CVM Improvement ) project for “Vodafone TR” within a 2 year period by a team of 6 senior data warehouse developer. Project is composed of 4 major “Work package”s WP4 : Design and Development of new data marts, WP5 : Data quality Analysis and Improvement Suggestions on current DWH system. WP6 : Overall DWH ETL Enhancement. Including performance tuning of ETL processes ,Data extraction processes improvement , Improvement of parallel processing , Improvement of ETL coding standards and ETL process logging mechanisms ; Addition of unified subscriber mechanism , slowly changing dimension and recycling mechanisms.