Ekaterine is available for hire
Hire EkaterineEkaterine Tarkhnishvili
Verified Expert in Engineering
SQL Developer
Tbilisi, Georgia
Toptal member since August 26, 2021
Bio
Ekaterine is a highly qualified SQL developer and Microsoft Power BI-certified data visualization specialist. She has been working in the IT industry for over four years and has experience working in the renewable energy, consulting, financial, gambling and casinos, and telecommunications industries. Ekaterine is a highly dedicated employee who strives to succeed and meet the requirements of the company.
Portfolio
Rhythm Energy Inc
Tableau, SQL, Looker, Databricks, Data Modeling, Git, PySpark, Python...
Leader-bet Slot LLC
Microsoft Power BI, SQL, MySQL, Microsoft SQL Server, Amazon Web Services (AWS)...
Panzura LLC
Microsoft Power BI, Data-informed Visual Design, Data Visualization...
Experience
- SQL - 5 years
- Microsoft Power BI - 3 years
- PL/SQL - 3 years
- Data Analytics - 3 years
- Tableau - 3 years
- Data Modeling - 2 years
- PySpark - 2 years
- Databricks - 2 years
Availability
Full-time
Preferred Environment
Git, Microsoft Power BI, Amazon Web Services (AWS), Tableau, Databricks, Snowflake
The most amazing...
...challenge was developing and managing critical company-wide databases, including the creation of key tables pivotal to customer-centric views and operations.
Work Experience
Data Engineer
2022 - PRESENT
Rhythm Energy Inc
- Developed and managed critical company-wide databases, including the creation and maintenance of key tables pivotal to customer-centric views and operations.
- Created, collaboratively, with multiple business units, a logic to a new data model.
- Implemented a new data model algorithm using PySpark and Python in the Databricks environment and generated data in multiple layers.
- Performed manual testing on the output and compared to business-provided output.
- Developed numerous Tableau reports and dashboards using complex business logic.
- Recreated previously existing Looker dashboards into Tableau dashboards and performed performance optimization.
Technologies: Tableau, SQL, Looker, Databricks, Data Modeling, Git, PySpark, Python, Data Architecture, Data Analysis, Data Engineering
Senior BI Developer
2021 - 2023
Leader-bet Slot LLC
- Remodeled existing QlikView data reports into Microsoft Power BI dashboards and reports using multiple database sources.
- Implemented data warehouse model with Galaxy schema approach in MySQL for reporting purposes, which consists of multiple dimensional and fact tables.
- Developed a Star schema model in Microsoft Power BI for optimization purposes.
- Performed initial analysis to assess the quality of the data.
- Tracked tasks and fixed issues and bugs with Jira Kanban board.
Technologies: Microsoft Power BI, SQL, MySQL, Microsoft SQL Server, Amazon Web Services (AWS), Redshift, QlikView, Microsoft Excel, Data Architecture, Data Analysis
Power BI Engineer
2022 - 2022
Panzura LLC
- Gathered data and created analysis based on company and industry needs.
- Set up data connections and scheduled refreshes in Microsoft Power BI service.
- Created visualizations based on the business requirements and its wireframes.
Technologies: Microsoft Power BI, Data-informed Visual Design, Data Visualization, Dashboard Design
Power BI Engineer
2021 - 2021
BCG - Gamma
- Prepared numerous complex Power BI paginated reports based on the customer's wireframe using Azure Synapse as the data source.
- Created views using complex SQL queries backed with complex logic.
- Created DAX calculations in Power BI and worked on the reports' performance improvement.
Technologies: Microsoft Power BI, Data Visualization, Microsoft Azure, Azure Synapse, SQL, Reporting, Data Architecture
SQL Developer
2020 - 2021
MagtiCom Ltd.
- Modified existing SQL queries, procedures and functions of high complexity.
- Worked with Oracle Data Integrator to extract, transform and load data from multiple sources.
- Developed multiple automated data reports in Oracle BI.
- Tracked tasks and fixed issues and bugs with Jira Kanban board.
Technologies: SQL, PL/SQL, Oracle BI, Jira, Data Analytics, Reporting, Microsoft Excel
BI Developer
2019 - 2021
DataMind
- Developed automated Microsoft Power BI and Tableau reports for financial and healthcare industries.
- Created data transformations for report optimization purposes.
- Developed a Galaxy and Star schema for higher quality performance using multiple sources.
Technologies: Business Intelligence (BI), Microsoft Power BI, Tableau, Data Modeling, Data Analytics, Data Architecture
SQL Developer
2019 - 2021
Liberty Bank Georgia
- Developed, automated, and optimized hundreds of reports using Microsoft Power BI and SSRS.
- Built and presented analytical solutions for business teams across the company.
- Created complex SQL queries on the Oracle database and stored procedures, packages, and functions.
- Optimized SQL queries using partitioning, hints, and indexes.
- Implemented data models for the data warehouse, monitored ETL flows, and created data quality checks.
Technologies: SQL, PL/SQL, Microsoft Power BI, SQL Server Reporting Services (SSRS), T-SQL (Transact-SQL), Reporting, Microsoft Excel
Experience
Data Engineer for Rhythm Energy Inc.
Rhythm Energy is one of the leading renewable energy companies based in Texas, USA.
I have been one of the lead engineers in the latest data migration projects at Rhythm Energy. My role included gathering business requirements, setting up ETL processes, implementing data models, and testing the data.
I have been one of the lead engineers in the latest data migration projects at Rhythm Energy. My role included gathering business requirements, setting up ETL processes, implementing data models, and testing the data.
Power BI App for Leader-bet Slot
http://www.lider-bet.com/web/en/main/Leader-bet Slot is one of the biggest gambling and casino companies in Georgia.
I implemented a Power BI app consisting of slots, sport, casino, P&L statement, and HR portal reports based on the company requirements. This included tens of complex Power BI reports.
I implemented a Power BI app consisting of slots, sport, casino, P&L statement, and HR portal reports based on the company requirements. This included tens of complex Power BI reports.
Power BI Developer at DataMind
https://www.datamind.geDataMind is a multi-profile outsourcing company that provides data warehouse and Microsoft Power BI services to its customers.
I worked for financial and healthcare industries and built hundreds of complex Power BI and Tableau reports and dashboards.
I worked for financial and healthcare industries and built hundreds of complex Power BI and Tableau reports and dashboards.
Education
2016 - 2020
Bachelor's Degree in Computer Science
San Diego State University - Georgia
Certifications
APRIL 2021 - APRIL 2023
Microsoft Certified Professional
Microsoft
Skills
Libraries/APIs
PySpark
Tools
Microsoft Power BI, Jira, Tableau, Microsoft Excel, Git, Looker
Languages
SQL, T-SQL (Transact-SQL), Python, Snowflake
Paradigms
Business Intelligence (BI), Data-informed Visual Design
Platforms
Databricks, Amazon Web Services (AWS), QlikView, Azure Synapse
Storage
PL/SQL, MySQL, Oracle PL/SQL, PostgreSQL, SQL Server Reporting Services (SSRS), Microsoft SQL Server, Redshift
Other
Data Science, DAX, Reporting, Data Analytics, Dashboard Design, Data Architecture, Data Modeling, Data Analysis, Oracle BI, Data Engineering, Data Visualization, Microsoft Azure, QA Testing
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