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.
BKM data warehouse system contains all credit card data transfer operations between banks. Central data warehouse is the mission critical component for reconciliations between banks. In the scope of the project, current data warehouse system is migrated to ODI 12c (Oracle Data Integrator) environment. Moreover, as-is performance problems are resolved, data quality controls are restructured, recycle mechanisms are added and DWH data model structures are improved.
TARSİM has reshaped the entire IT infrastructure by making significant technological investments during the last 10 years in order to achieve its growth targets. In order to meet the requirements of the growing policy pool, TARSİM improves its base insurance software and Oracle hardware and software requirements every year. It has been a very important and special experience for us to be part of this transformation journey.
During the Tarsim infrastructure transformation project, Oracle Exadata was used as database server, ZFS and Active Dataguard as backup structure, Oracle Multitenancy option for database consolidation, Oracle Business Intelligence (OBIEE 12c) on reporting front-end and Oracle Data Integrator (ODI 12c) as ETL tool. With the migration of Tarsim infrastructure to Oracle Exadata platform, a transition was made to secure, fast, robust and high capacity architecture that provides high performance. At the same time, Oracle Pluggable Database structure provided significant savings in resource usage on servers. In parallel to this, after the Tarsim data warehouse transition to ODI 12c, faster and error-free ETL development, better quality and consistent data access, more powerful and real-time tests were possible.
In August 2017, InspireIT has started works for "Datawarehouse Reengineering and Self-Service Reporting Project" for Fibabanka. As part of the project; a new "Self-Service Financial Control Datamart" model has been developed, where all kind of mission-critical financial reports can be prepared via Oracle Business Intelligence (OBIEE) dashboards and reports. Corporate and individual datamart models serving all kind of customer insights has been a success story for InspireIT and Fibabanka.
A new “Automated Data Lake Environment” has been developed by “InspireIT Report Loader” utility which runs 900+ reports daily, taking into account of their internal and external data, ETL, OFSAA and report dependencies. Additionally, nightly ETL processes are optimized, ETL and OBIEE usage monitoring infrastructure have been developed to get alerts regarding ETL and reporting jobs.
The Oracle Modern Cloud Day provides the chance to immerse in cloud and digital innovation and gain insight into future technologies, alongside hundreds of your professional peers. Register now for Oracle Modern Cloud Day. https://www.oracle.com/tr/cloudday/?source=:ow:evp:cpo::RC_EMMK190719P00044:EVENT_MCD_SP_TU&intcmp=:ow:evp:cpo::RC_EMMK190719P00044:EVENT_MCD_SP_TU
We are at your service in our new office since August 2019 with our constantly growing team. We are waiting for our valuable clients to share our solutions in our brand new office at Maslak Iz Giz Plaza.
The data warehouse and reporting infrastructure project for Magticom -the largest GSM operator in Georgia- was launched in August 2019 as a result of the collaboration of InspireIT and Oracle Consulting teams.
InspireIT, with many projects and work experience in different countries in Eastern Europe, Central Asia and Gulf region, has opened its London office as of July 2019 in order to increase its effectiveness in the European market.
InspireIT developed "Inspire Report Loader" solution for Fibabanka, to enable loading more than 900 reports to ODS environment. With dependency resolution, scheduling and parallel-run mechanisms developed under the hoods, all reports are loaded daily into "Data lake" environment.
InspireIT developed "Inspire Data Quality" Solution for "Bankalararası Kart Merkezi (BKM) allowing them to run hundreds of controls over tens of mission critical reports data in less than 5 minutes. By this solution BKM had also the ability to manage reconciliation controls of the datawarehouse with multiple source systems.