Sophia Nabieva

Data Engineer @AccentCare

Bronx, NY, US

Proficient in SQL Server and T-SQL, with a strong command of database development, encompassing the creation and management ofStored Procedures, Triggers, Nested Queries, Joins, Views, User-Defined Functions, Indexes, and Relational Database Models. Expertlyadministered table operations, updates, and database consistency through DBCC commands.• Leveraged SQL Server Integration Services (SSIS) as a robust ETL tool for efficient data extraction from diverse sources, crafting packagesfor data loading tasks. Adapted and developed ETL processes as needed.• Designed and implemented dynamic SSIS packages incorporating intricate expressions, variables, and control flow components like thefor-each Loop Container, enabling iterative loading of incoming files.• Employed Microsoft Power BI Power Query for data extraction and transformation from external sources, harnessing Data AnalysisExpressions (DAX) within Power BI desktop to create intricate calculated columns and measures for the generation of data-richvisualizations.• Spearheaded the creation of modern data solutions within Azure Platform as a Service (PaaS) offerings to support data visualization,with a keen assessment of the impacts on existing business processes.• Executed data extraction, transformation, and loading (ETL) from source systems to Azure Data Storage services, effectively blendingAzure Data Factory, T-SQL, and U-SQL in Azure Data Lake Analytics. Ingested data into various Azure Services, including Azure DataLake, Azure Storage, Azure SQL, and Azure Data Warehouse, applying Azure Databricks for data processing.• Engineered Azure Data Factory (ADF) pipelines for streamlined data extraction, transformation, and loading operations from varioussources, encompassing Azure SQL, Blob storage, and Azure SQL Data Warehouse.• Utilized Power BI to construct semantic models facilitating simplified data analysis and relationship-building, while loading pertinent datafrom Azure Syn data warehouse.