Zurab is currently unavailable
Zurab Grigalashvili
Verified Expert in Engineering
Data Scientist and Developer
Tbilisi, Georgia
Toptal member since June 6, 2022
Bio
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
Georgia Healthcare Group (GHG)
Business Modeling, Analytics, SQL, Microsoft Power BI, Data Analysis...
JSC Georgian Pharmacy (Gepha)
SQL, Data Analysis, Financial Data Analytics, SQL Stored Procedures...
JSC Georgian Pharmaceutical Communications (GPC)
Adobe ColdFusion, IT Management, Microsoft SQL Server, SQL Stored Procedures...
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
Work Experience
Head of Data Processing and Analytics
2018 - PRESENT
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.
Technologies: Business Modeling, Analytics, SQL, Microsoft Power BI, Data Analysis, Data Analytics, SQL Stored Procedures, SQL Functions, SQL Administration, SQL Server Profiler, Excel VBA, Inventory Management, Data, Data Processing, Data Processing Automation, Customer Segmentation, Microsoft Excel, Excel Macros, Microsoft SQL Server, Financial Modeling, Business Intelligence (BI), Data Visualization, Data Warehousing, ETL
Deputy CFO | Head of Business Analytics
2017 - 2018
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.
Technologies: SQL, Data Analysis, Financial Data Analytics, SQL Stored Procedures, SQL Functions, SQL Administration, Excel VBA, Data, Data Processing, Data Processing Automation, Customer Segmentation, Microsoft Excel, Excel Macros, Microsoft SQL Server, Financial Modeling, Business Intelligence (BI), Data Visualization, Data Warehousing, ETL
Head of Information Systems and Business Analytics
2011 - 2017
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.
Technologies: Adobe ColdFusion, IT Management, Microsoft SQL Server, SQL Stored Procedures, SQL Functions, HTML, Excel VBA, Data, SQL, Data Processing Automation, Customer Segmentation, Microsoft Excel, Excel Macros, Business Intelligence (BI), Data Visualization, Data Warehousing, ETL
Head of Payment Systems Department
2006 - 2011
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.
Technologies: Management, Financial System Implementation
Acting Head of Research Group | Research and Modeling Analyst
2003 - 2006
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.
Technologies: SQL Stored Procedures, SQL Functions, Adobe ColdFusion, Oracle SQL, PL/SQL Developer, HTML, Data Analytics, SQL, Data Processing, Data Processing Automation, Customer Segmentation, Business Intelligence (BI), Data Visualization, Data Warehousing
Project History
Automated Daily Inventory Replenishment System
A daily inventory system for pharma retail stores that automatically calculates the minimum and maximum replenishment coefficients for every item in every store.
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.
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
2001 - 2003
Master's Degree in Management Science
University of Tennessee at Knoxville - Knoxville, TN, USA
1994 - 1997
Master's Degree in Applied Mathematics
Tbilisi State University - Tbilisi, Georgia
1989 - 1994
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
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