Position: SQL Database developer, Data Engineer, ETL developer, BI Engineer, Power BI Developer
Category: Data Engineer
English level: fluent
Years of experience: 5


BI DEVELOPER (remote)
Sompo International Holdings Ltd. | New York, NY | Jan 2019 – Present                                                                                               
	As a key member of BI team, delivered the best results to the development needs, accomplished successful outcomes by working with T-SQL, Power BI, SSAS, SSRS, SSIS, ADF2, and other Azure Cloud tools;
	Daily scrum meetings with Project Managers, Business Analysts and end users/clients to gather, analyze and document the business requirements and business rules; discuss the project specs in order to understand the business needs;
	Implemented performance tuning on complex stored procedures, views, user defined functions and queries by creating proper indexes and optimizing the existing ones, creating and updating tables and checking the database consistency by executing DBCC commands;
	Built reports for different domains such as Finance, Accounting, Management, and other client teams;
	Created Power BI reports on account information, research reports using ad-hoc reporting to be used by clients and advisors. Created reports on both cascading and standard parameters. Worked on Power BI and Tableau in creating dashboards and reports and visualizing data;
	Helped clients to convert Excel reports for Accounting Department into Power BI reports by automating the whole lifecycle of report generation. Generated OLTP database objects. designed Data Warehouse. and created all Power BI reports. Created ETL processes to automated data flow;
	Accounting Reports included Year-To-Date, Month-To-Date, Period Close reports, Transaction and Snapshot reports for General Ledger, Budget reports, etc.;
	Developed filters, reports, dashboards and also created chart types, visualizations and complex DAX calculations to manipulate the data in Power BI;
BI DEVELOPER (remote)
DataSite Technology LLC | Tashkent | Nov 2017 – Dec 2018
	Actively participated in meetings with different Departments, Managers and End users to capture and document system requirements;
	Created complex analytic queries on huge data sets; developed T-SQL stored procedures, triggers, and user-defined functions. Handled data manipulations as required;
	Croreeated joins and sub-queries for complex queries involving multiple tables from different databases; 
	Normalized the tables and maintained Integrity by using Primary and Foreign Keys;
	Created Views to enforce security and data customization;