Giga Kakhoidze Email & Phone Number

California, United States

Notable Projects:- Big Data Infrastructure: Built a robust, structured big data cloud environment from the ground up, enabling analytics on terabytes of data with high efficiency.- Analytics as a Service: Introduced a platform to streamline the onboarding process, significantly enhancing UI/UX and solution accessibility.- Optimized Data Model: Developed a highly efficient data model for analyzing over a decade of commercial data, allowing for detailed insights at minimal cost and time.- Data Analysis and ML Implementation: Supported best practices in data analysis and machine learning, leading to notable improvements in product delivery and quality control.

California, United States

Worked on Analytics as a Service company data infrastructure development and modernization.Notable Projects:- Seamless Integration: Supported the integration of external data from dozens of top US alcoholic beverage producers and multiple third-party partners.- Retail Data Cleanup: Cleansed retail input data containing billions of rows, extracting features such as Brand, Varietal, Type, AVAs, Vintage, and Volume, resulting in a high-quality dataset for advanced analytics.- PBI Model Optimization: Optimized heavy Power BI models, reducing data update times from days to mere hours and, in some cases, seconds.- Advanced Data Modelling: Enhanced data structures and models for third-party customer features, efficiently handling data with over 16,000 features.- Lifecycle Automation: Automated every aspect of the data lifecycle, significantly speeding up the onboarding of new companies and the data update process.

Tbilisi, Georgia

Worked on Business Management Analytical Systems Development.Notable Projects:- Database Partitioning: Developed a database-wide partitioning mechanism, significantly lightening database backups, DQL, and DML statements.- Archiving Solution: Implemented a database archiving solution to keep old data in separate cold-tier storage, simplifying DB maintenance, reducing costs, and boosting overall performance.- Performance Reporting: Created the first group-wide performance report providing a 360-degree view for top management.- Market Analysis Tool: Consolidated market-wide data and built a comprehensive tool for market positioning and competitor analysis.- Live IFRS Portfolio Pipeline: Established a live IFRS portfolio generation pipeline, reducing generation time from over 8 hours to just 15 minutes, allowing businesses to monitor their portfolios throughout the day.

Tbilisi, Georgia

Worked on IFRS reporting automation.Notable Projects:- Accounting Adjustment Automation: Automated the accounting adjustment process, correcting inaccuracies amounting to millions in daily transactions.- ETL Deployment Transition: Transitioned the ETL deployment process from file-based to catalog-based, enabling package deployment without external involvement, applying CI/CD practices, and protecting production user credentials.- SCD Remodeling: Remodeled SCD, eliminating additional columns while maintaining history and unifying audit data into a single object, drastically reducing storage requirements, speeding up DML operations, and simplifying audit data access.- End-to-End Data Flow Monitor: Developed an end-to-end data flow monitor used by stakeholders, analysts, and developers, providing real-time status of data ingestions, quality checks, data lineage visualizations, and embedded messaging. This tool significantly reduced the need for verbal/text communication and guided users on whom to contact for specific concerns.- Centralised Checking Infrastructure: Established a centralized checking infrastructure for real-time data quality monitoring without scripting involvement, supporting a wide variety of quality checks and ensuring the health of business logic across the entire database.