Giorgi Kharaishvili

I implemented a complete BI project. I also planned and created a data warehouse, which included all kinds of data from the country's biggest telecommunication company. In addition, I made proper infrastructure, designed and implemented ETL processes, made detailed tracking.

I also created areas for data visualization and made it easily accessible and understandable for business users for better efficiency that helped all of the company departments to speak in the 'same language.' Oracle built-in machine learning algorithms were used to test data and better understand our customers, which resulted in an improved retention rate.

I was one of the key members of this project and the only one who had a part in every part of this process, starting from discussions with the outsourcing consultancy team.

The company makes reports for the country's communication regulatory commission.

Those reports are from all departments, with a wide variety of data and source types. Collecting those reports and checking them was difficult, and there has a high probability of mistakes.

I made a centralized system where users had different options for importing data. Some were automatically calculated, some were imported by excel, inserted with simple data entry, and others.

In case of changes, old data is kept for comparison.
Every report is only accepted after double-checking and approval of the supervisor.
Users are reminded if they have forgotten uploading or approving.

All data is centralized in one DB and is easily accessible.

Also, in the same web portal where data is integrated, there is a snowflake schema-based visualization part, which allows one to check data trends and find possible problems.

After all, this project made the process of high importance much more accessible and transparent.

After the company's acquisition, there was a need to transfer and consolidate reports and data visualizations from SSRS to OBIEE.

We learned data from a new company during the project and integrated data from MS SQL to Oracle. We transferred snowflake, star schema-based reports/visualizations, and reports from direct database queries.

In response to the challenges posed by manual data consolidation and reporting processes, our project, the Automated Consolidated Financial Reporting System, aimed to revolutionize financial reporting by introducing efficiency, accuracy, and real-time insights.

Traditionally, financial reporting involved collecting data from diverse sources, relying heavily on manual input, and grappling with the complexities of Excel spreadsheets.

Our solution transforms this arduous process into a streamlined, automated system that ensures data integrity and provides Tableau dynamic visualizations for enhanced decision-making.