Doston Otakhonovich
Summary
SUMMARY MS Business Intelligence Developer and Data Engineer with more than 8+ years of experience working with BI applications such as SSMS, SSIS, SSRS, ADF in Development, Test and Production Environments, visualization tools such as Power BI, Azure Services (Azure Data Lake, Azure Storage, Azure SQL, Azure DW) and processing the data in Azure Databricks. and Tableau. Have work experience in different industries such as healthcare, service, leasing and insurance.
Overview
10
10
years of professional experience
Work History
Google SQL Developer
Google
01.2019 - Current
- SQL SSIS/ SSRS
- Designing Logical and Physical Data Model with Erwin tools
- Developed, implemented and optimized stored procedures and functions using T-SQL.
- Worked with installing, designing and managing MS SQL Server 2008.
- Designed and developed customized extract, transform and load (ETL) applications per client specifications.
SSIS developer/ Data analyst
Kaiser Permanante
01.2017 - 01.2019
- Analyzed existing SQL queries to identify opportunities for improvements.
- Designed and implemented TSQL queries for reporting and complex solution development.
- Developed, implemented and optimized stored procedures and functions using T-SQL.
- Performed regular database backups to prevent information loss.
Data engineer/ Analyst/ SQLdeveloper
Safeway Inc
01.2016 - 02.2017
- Prepares performance Dashboard, Jobs Failure stats, Data Volume check using SSRS
- SSIS, SQL and Excel and gives PPT presentation near client for this on a daily basis
- Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements.
BI developer/ Data analyst
Twin Group Funding
01.2014 - 02.2016
- Worked as a developer in creating complex Stored Procedures, Triggers and
- Functions
- Managed index statistics, Tables, Views, cursors and optimizing queries by using execution plan for tuning the database
- Implemented different types of constraints on tables.
Education
Bachelor of Computer Science -
Bangor University
2014
Skills
- Business Intelligence
- Data Warehousing and Analytics
- Project Specifications
- Web-Based Software Engineering
- Database Schemas
- Data Modeling
- Compatibility Testing
- Extraction Transformation and Loading (ETL)
- T-SQL Coding
- MS SQL Server 2000
- SQL Server Integration Services (SSIS)
Timeline
Google SQL Developer
Google
01.2019 - Current
SSIS developer/ Data analyst
Kaiser Permanante
01.2017 - 01.2019
Data engineer/ Analyst/ SQLdeveloper
Safeway Inc
01.2016 - 02.2017
BI developer/ Data analyst
Twin Group Funding
01.2014 - 02.2016
Bachelor of Computer Science -
Bangor University