Farid Akhmatov

About Farid Akhmatov

Senior Data Warehouse/Business Intelligence (BI) specialist and Data Engineer with over 10+ years of data warehouse architecture and data management experience, seeking a challenging position in the Data Warehouse/BI, Data Lakes, OTLP and OLAP environments. Specializing in design, development, testing and optimization of, data engineering, data warehouse and BI solutions. Experienced with all aspects of the data warehouse lifecycle including project planning and management, requirements definition, data architecture, data modeling, ETL design and development, testing, deployment, and documentation, managing information ranging from Finance, Accounting, HR, Supply-Chain, Operations, Sales, Marketing to E-Commerce business domains. Data Engineering and Reporting using BI applications such as SQL Server, Azure Data Factory, Databricks, Azure Synapse, SSIS, Azure Logic App, Function App, Azure Data Lake, CICD pipelines, Power BI, SSRS, Tableau and many others.

Experience

1. Senior Data Engineer

   Newrez

   Oct 2021 — Present

   Translated analytic business requirements into dimensional designs. Developed data standards, data mappings, load strategies and history tracking solution. Developed functional data models to enhance the reconcilability of financial and risk data by means of an integrated data model and to increase data consistency in regulatory reporting.Gathered and translated business requirements into detailed, production-level technical specifications detailing new features and enhancements to existing business functionality. • Hands on experience in monitoring SQL Server Performance tuning in SQL Server using SQL Profiler, Query Analyzer, Enterprise Manager, Index Tuning Wizard, and Windows Performance Monitor. Developed SQL queries /scripts to validate the data such as checking duplicates, null values, truncated values and ensuring correct data aggregations. • Performed data quality analysis using advanced SQL skills. Performed Count Validation, Dimensional Analysis, Statistical Analysis and Data Quality Validation in Data Migration. Extensive SQL querying on Staging, Data warehouse and Data Mart. Designed databases, created Queries in T-SQL, Stored Procedures, and Views to store data of clients, advisors. • Created advanced SQL User Defined Functions, Triggers to store data into appropriate tables. Conducted SQL performance tuning by using Extended Events, SQL Profiler and index tuning wizard. Actively worked with application developers for writing complex T-SQL queries and stored Procedures for reporting purposes and system development purposes.Created Azure Databricks namespace for big data analysis, also used Databricks in Azure data Factory pipeline for big data processing on raw data and transform into meaningful insights and store into data warehouse.Developed Power BI reports and dashboards from multiple data sources.