Rati is available for hire
Hire RatiRati Kunchulia
Verified Expert in Engineering
Reporting Developer
Location
Tbilisi, Georgia
Toptal Member Since
June 18, 2020
Rati is a skilled database and data warehouse developer with five years of experience in the IT industry. He's dedicated to producing only the best work in the creation of effective and reliable databases and has a comprehensive understanding of all aspects of data modeling. Rati has built the largest data warehouse in Georgia and is looking forward to his next challenge.
Portfolio
SEEL, LLC
Microsoft Power BI, Microsoft SQL Server
SEEL, LLC
Microsoft Power BI, SharePoint, Excel 365
Liberty Bank
C#, Microsoft SQL Server, Java, Visual Basic, Pentaho, Subversion (SVN), PL/SQL...
Experience
Availability
Part-time
Preferred Environment
Subversion (SVN), Git, PL/SQL, Microsoft SQL Server
The most amazing...
...project I've completed was building the largest data warehouse in Georgia.
Work Experience
Power BI Expert
2022 - 2023
SEEL, LLC
- Developed and implemented interactive dashboards, allowing users to filter, drill down, and slice data.
- Optimized data modeling and analysis for faster queries.
- Provided training and support to users of interactive dashboards.
- Resolved data quality issues and extracted insights from large, complex datasets.
- Conducted mentoring sessions, and created training material.
Technologies: Microsoft Power BI, Microsoft SQL Server
Power BI Expert
2022 - 2023
SEEL, LLC
- Developed several multi-source, role-based, and complex Power BI Reports.
- Generated SQL automation for collecting and materializing denormalized datasets for the Power BI reports.
- Automated manual input management for the Power BI reports.
Technologies: Microsoft Power BI, SharePoint, Excel 365
Senior Data Warehouse Developer
2017 - 2020
Liberty Bank
- Developed the staging layer (L0) for preparing some main repository filling basics. In the staging layer, I developed 2,100 tables and 2,500 ETL.
- Built the main repository (L1) architecture depending on data warehouse modeling concepts which consist of 60 dimensional, 60 history (of dimensional tables), and 20 fact tables.
- Incorporated the FINREP data mart database model with a galaxy schema approach which generates 80 reports every day.
- Implemented a workflow monitoring website that ensures dependencies between ETLs, scheduling ETLs, and handling errors. In case of errors, it has the functionality of resuming ETL from the exact point of termination.
- Created an ODS infrastructure for two outsourced vendors.
- Introduced a technical and business check system with 500 systems and 200 business checks.
- Developed hundreds of Power BI internal, public, and regulatory reports.
Technologies: C#, Microsoft SQL Server, Java, Visual Basic, Pentaho, Subversion (SVN), PL/SQL, Data Analysis, SQL, Microsoft Power BI, Data Engineering, Data Migration, Database Migration, ETL, ETL Tools, ETL Development
Data Engineer
2019 - 2019
Wandio
- Developed a real-time OLAP system that is unifying and consolidating transactions from 1000+ different sources. This system was unifying clients with Ratcliff/Obershelp pattern and Levenshtein edit distance algorithm.
- Tranked tasks and fixed issues/bugs with the Jira Kanban board.
- Built real-time OLAP system and generated 18 complex and real-time Power Bi reports, too.
Technologies: SQL, Microsoft Power BI, Data Analysis, Microsoft SQL Server
Senior Application Support Specialist
2016 - 2018
TBC Bank
- Created a checking system which contained hundreds of checks on the OLTP database, now there are thousands of checks in this system and they successfully prevent production databases from possible bugs and worst scenarios.
- Implemented a mini AI for auto-correction of mistakes made by careless application users. Nowadays, this mini AI is not "mini" anymore.
- Created an auto DML UI system where business analysts could manipulate data on the production environment. Thousands of checks and validations implemented in the system were preventing business analysts from making mistakes in data manipulation.
Technologies: SQL Server Profiler, PL/SQL, Microsoft SQL Server
ASP.net Developer
2015 - 2016
LTD Fina
- Involved in implementing accounting program which supports trading and financial operations and some loan management systems.
- Involved in creating cashier module which nowadays is the most sold in Georgia.
Technologies: TFS, AngularJS, C#, Microsoft SQL Server
Experience
DWH/BI Developer at Financial Bureau
https://financialbureau.ge/Financial Bureau is the biggest debt collection company in Georgia.
I was invited for designing and building DWH Project and then hundreds of Power Bi reports for different departments and Regulatory too.
All reports are covered by NDA, but I'm able to present/show them on interview.
I was invited for designing and building DWH Project and then hundreds of Power Bi reports for different departments and Regulatory too.
All reports are covered by NDA, but I'm able to present/show them on interview.
Invited DWH/BI Consultant at FAO
Worked on DWH and BI project at mepa.gov.ge which was supported by FAO. I was invited by FAO and worked on:
• Assisting system and data analysis team in all Data Quality Management activities.
• Preparing all functional and technical specification documents for developers.
• Supervising team working in various large scale and complex projects
• Planning and designing the technical architecture to integrate various data warehouse plans.
• Assisting system and data analysis team in all Data Quality Management activities.
• Preparing all functional and technical specification documents for developers.
• Supervising team working in various large scale and complex projects
• Planning and designing the technical architecture to integrate various data warehouse plans.
Invited DB Lecturer
I have been teaching Microsoft SQL Server to more than 100 students for the past three years now.
35% of my students are working as Database/DWH/BI/Machine Learning developers at leading companies in Georgia.
35% of my students are working as Database/DWH/BI/Machine Learning developers at leading companies in Georgia.
DWH/BI Architect
Defined Business Intelligence strategy based on current business and information technology realities. I was also defining, designing, and implementing Business Intelligence (BI) strategies for operational, ad-hoc, and other BI-related solutions.
Provided best practices and guidance regarding the use of ETL, data modeling (relational and dimensional), and reporting deliverables.
Designed and build complex relational data structures.
Provided best practices and guidance regarding the use of ETL, data modeling (relational and dimensional), and reporting deliverables.
Designed and build complex relational data structures.
Data Warehouse for Liberty Bank
One of the biggest data warehouse in one of the biggest bank in Georgia. My role was to built DWH architecture and build a huge amount of ETLs in it. Also developed ETL monitoring tool with administration web-page too.
Medi est Mobile Application
Participated in building/developing one of the popular mobile applications in the region with more than 100K monthly active users. I was the Data architect, defining the structure, reporting, analytics flow/development/delivery..
Bonus Calculation System for Liberty Bank
OLTP Database for HR-system which is calculating daily bonus for employees. I solely developed whole architecture, schema and processes for this particular system, Also automated data flow and Data quality pre-build checks.
BI Team Lead at Singular UK
https://singular.uk/Singular is one of the biggest iGaming companies in the world.
I was invited to Singular for designing and developing a real-time OLAP Data Warehouse while daily transactions in Gambling Databases were over billion rows. We choose the newest technology - Clickhouse for achieving our goal.
I was invited to Singular for designing and developing a real-time OLAP Data Warehouse while daily transactions in Gambling Databases were over billion rows. We choose the newest technology - Clickhouse for achieving our goal.
DWH/BI Developer at Gagua Clinic
https://gaguaclinic.ge/enGagua's Clinic is the biggest maternity clinic in Georgia.
I was chosen for DWH and BI project, which included patient, doctor, ambulatory, stationary, and financial analytics and Power Bi reports.
It was an excellent experience with tens of complex Power Bi reports.
I was chosen for DWH and BI project, which included patient, doctor, ambulatory, stationary, and financial analytics and Power Bi reports.
It was an excellent experience with tens of complex Power Bi reports.
Education
2013 - 2018
Bachelor's Degree in Mathematics and Computer science
Free University of Georgia - Tbilisi, Georgia
Skills
Tools
Microsoft Power BI, Pentaho Data Integration (Kettle), Subversion (SVN), DataGrip, SQL Prompt, SQL Server Profiler, WinSCP, Git, Jira, TFS, SQL Server BI
Languages
SQL, T-SQL (Transact-SQL), C#, Visual Basic, Python, SQL DDL, Excel VBA, Java, JavaScript
Paradigms
ETL, Database Development, Data Science, Agile, Scrum, Business Intelligence (BI)
Platforms
Pentaho, SharePoint, Oracle
Storage
Oracle PL/SQL, Microsoft SQL Server, PL/SQL, Relational Databases, SQL Stored Procedures, Database Migration, Databases, Redshift, MySQL, SQL Server Reporting Services (SSRS), PL/SQL Developer, SQL Server Integration Services (SSIS), ClickHouse, Amazon Aurora, PostgreSQL
Frameworks
AngularJS
Other
Reporting, Data Analytics, Data Warehouse Design, Data Engineering, Data Migration, ETL Tools, ETL Development, DAX, Data Quality Analysis, Data Analysis, Excel 365, Data Build Tool (dbt)
Collaboration That Works
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
1
Share your needs
Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2
Choose your talent
Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3
Start your risk-free talent trial
Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.
Top talent is in high demand.
Start hiring