Zurab Grigalashvili
Verified Expert in Engineering
Data Scientist and Developer
Tbilisi, Georgia
Toptal member since June 6, 2022
Zurab has a master's in applied mathematics and another in management science, with solid knowledge in statistics, analytics, database design, and SQL data warehouse development. In his 20 years of experience, Zurab has implemented modeling and automation projects, including sales price optimization, customer segmentation, product categorization, inventory management and central warehouse ordering system, and post-sales customer behavior models for return and cancelation forecasts.
Portfolio
Experience
- Mathematics - 20 years
- Business Modeling - 18 years
- SQL - 18 years
- Analytics - 18 years
- Excel VBA - 18 years
- Data Processing - 10 years
- Data Processing Automation - 10 years
- Statistics - 8 years
Availability
Preferred Environment
SQL, Microsoft Power BI, Excel VBA
The most amazing...
...project I've delivered is the full-scale design and SQL implementation of an automated daily stock replenishment system for a large pharma retail chain.
Work Experience
Head of Data Processing and Analytics
Georgia Healthcare Group (GHG)
- Developed the group-wide SQL-based automated data warehouse for collecting, updating, and aggregating data from seven different company data sources, mainly from MS SQL and some from Amazon Redshift.
- Built an inventory management system based on statistical methods to automate the daily stock replenishment for a pharma retail chain.
- Introduced a group-wide data analytics and reporting environment on Microsoft Power BI.
- Implemented fully-automated analytical reports in Power BI for daily updates on sales and other KPIs for companies within the GHG group.
Deputy CFO | Head of Business Analytics
JSC Georgian Pharmacy (Gepha)
- Developed an SQL data warehouse for business, commercial, and financial analytics.
- Built automated reporting systems in an SQL database/Excel for complex financial computation and analysis, including FIFO modeling, net realizable value estimation, and obsolete inventory.
- Contributed to the merger of two pharmacy chains in data migration and database and financial reporting consolidation.
Head of Information Systems and Business Analytics
JSC Georgian Pharmaceutical Communications (GPC)
- Established information systems management and support infrastructure.
- Built an SQL data warehouse for analytical and financial reporting.
- Implemented a web-based analytical reporting environment on Adobe ColdFusion and Excel VBA.
Head of Payment Systems Department
National Bank of Georgia
- Initiated the payment system reform project in Georgia and implemented the two most critical financial systems: the real-time gross settlement system and the central securities depository.
- Introduced the International Bank Account Number standard in all Georgian banks.
- Reduced client-to-client interbank transfers in Georgia from at least one day to near real-time by introducing the straight-through processing practice.
Acting Head of Research Group | Research and Modeling Analyst
Jewelry Television
- Boosted sales and operational efficiency by implementing decision-making concepts, models, and tools for virtually all areas of the company’s activity.
- Developed business and data models for customer segmentation, product sales efficiency and categorization, inventory evaluation, financial reporting in real-time, product return, order cancelation, and price optimization.
- Introduced the web-based reporting system in the Adobe ColdFusion environment.
- Coordinated, trained, and mentored the research group.
Experience
Automated Daily Inventory Replenishment System
I developed and implemented the system that performs its calculations in the SQL environment. The previous 365 days of sale patterns are analyzed daily for every item in every store, identifying the outlier points and eliminating and/or haircutting values. The orders are automatically generated for further processing by the centralized warehouse for daily replenishment, based on the calculated minimum and maximum values and remaining quantities.
Education
Master's Degree in Management Science
University of Tennessee at Knoxville - Knoxville, TN, USA
Master's Degree in Applied Mathematics
Tbilisi State University - Tbilisi, Georgia
Bachelor's Degree in Mathematics
Tbilisi State University - Tbilisi, Georgia
Skills
Tools
Microsoft Power BI, Microsoft Excel, SQL Server Profiler
Languages
SQL, Excel VBA, HTML
Paradigms
Business Intelligence (BI), Management, ETL
Storage
Microsoft SQL Server, SQL Stored Procedures, SQL Functions, Oracle SQL, PL/SQL Developer
Platforms
Adobe ColdFusion
Other
Mathematics, Data Warehousing, Business Modeling, Statistics, Inventory Management, Data Processing, Customer Segmentation, Excel Macros, Analytics, Data, Data Processing Automation, Financial Modeling, Data Visualization, Data Analysis, Data Analytics, Financial System Implementation, Financial Data Analytics, IT Management, SQL Administration
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring