Natalia Chervaneva
Austin,TX
Summary
- Experienced MS Business Intelligence Developer with 5+ years of working with applications such as SSMS, Azure Data Factory, and Power BI in Development, Test, and Production Environments. A wide practice working in different industry areas such as service, healthcare, finance, and IT industry.
- High abilities in deploying and operating large-scale cloud infrastructure and application services Azure Cloud.
- Maintained databases across on-premises and cloud deployments and moved on-premises SQL Server schemas in the cloud on Azure SQL Server DB and Azure VM.
- Excellent experience in designing Data warehousing, OLAP, and Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, and FACT and Dimensions Tables using Analysis Services.
- Impressive skill in creating Databases, Stored Procedures, Tables, DDL/DML Triggers, User defined data types, Views, Functions, Cursors, and Indexes using T-SQL.
- Constructed Power BI reports on account information, and research reports using ad-hoc reporting for clients and advisors. Created reports on both cascading and standard parameters.
- Worked with Dax Studio to analyze reports and performed DAX and model tuning.
- Skillful in Software Development Life Cycle (SDLC) process, which includes Agile, RUP, and Waterfall methodologies.
- Outstanding analytical, and communication skills and competent in writing and presenting complex technical concepts, comfortable working with different-sized teams and independently.
Overview
12
12
years of professional experience
Work History
ADF | TSQL | POWER BI Developer
Family Health International
01.2023 - Current
- Worked with the Azure platform using Azure Data Factory, Data Lake Storage, Azure Synapse, Blob Storage, and Logic Apps
- Converted and analyzed data with Data flows within the Azure Data Factory
- Designed Azure platform for data pipelines, ADF, Azure data lakes, and blob storage and developed workflows to automate data flow using ADF
- Cooperated with developers on various aspects ranging from usage of utilities to SQL performance, general troubleshooting, and test data
- Created custom and efficient stored procedures, CTEs, functions (UDF), indexes, tables, DML triggers, and views as part of the project
- Made SQL performance monitoring and tuning of reporting data by optimizing indexes and stored procedures
- Created and Implemented triggers in T-SQL to facilitate assistance in entering consistent data into the database
- Transformed the raw data into significant insight by using the Power BI dashboards and reports
- Created filters, reports, and dashboards and created chart types, visualizations, and DAX calculations to control the data in Power BI
- Worked with various formatting techniques and features like interactive sorting, grouping, bookmarks, slicer, RLS, and others for creating user-friendly reports
- Exploring Fabric
TSQL | ADF | POWER BI Developer
Re: start Financial Inc.
09.2020 - 12.2023
- Experience in the migration of on-premises SQL Server schemas to the cloud on Azure SQL Server DB and Azure VM and developed and maintained databases across both on-premise and cloud deployments
- Worked with the Azure platform using Azure Data Factory, Data Lake Storage, Azure Synapse, and Blob Storage
- Skill in SQL Pool and SQL on-demand to build a data warehouse in Azure Synapse environment
- Designed Azure platform for data pipelines, ADF, Azure data lakes, and blob storage and developed workflows to automate data flow using ADF
- Joint structured, unstructured, and semi-structured data (log files and media) using Azure Data Factory to Azure Blob Storage
- Transformed the raw data into significant insight by using the Power BI dashboards and reports
TSQL Developer
INFOPRO
07.2013 - 11.2016
- Produced complex queries on SQL (Oracle server)
- Developed optimized stored procedures, CTEs, user-defined functions (UDFs), indexes, tables, DML triggers, and views to enhance project performance and efficiency
- Generated Reports in Crystal Reports
- Constructed Crystal reports on account information, and research reports using ad-hoc reporting for clients and advisors
Education
Master's degree - Economics
Samara State University
Skills
- Advanced T-SQL coding
- Data analysis
- Agile methodology
- Performance tuning
- Data warehousing
- Cloud technologies
- Debugging/Troubleshooting
- ETL implementation
- Business analysis
Personal Information
Citizenship: US Citizen
Timeline
ADF | TSQL | POWER BI Developer
Family Health International
01.2023 - Current
TSQL | ADF | POWER BI Developer
Re: start Financial Inc.
09.2020 - 12.2023
TSQL Developer
INFOPRO
07.2013 - 11.2016
Master's degree - Economics
Samara State University
Similar Profiles
MOSES LUKEMOSES LUKE
Senior Technical Advisor, Analytics & Data at Family Health InternationalSenior Technical Advisor, Analytics & Data at Family Health International
NATTKARN PATTANACHOONATTKARN PATTANACHOO
Administrative Officer-Networks for Peace Project at Family Health InternationalAdministrative Officer-Networks for Peace Project at Family Health International
Selina MwalyoloSelina Mwalyolo
Data Analyst at Family Health InternationalData Analyst at Family Health International
Shelby HoltShelby Holt
Brand Manager at HeartGift FoundationBrand Manager at HeartGift Foundation
Brandon ValdezBrandon Valdez
Floor Associate, Cashier, Shoe Runner at Aldo ShoesFloor Associate, Cashier, Shoe Runner at Aldo Shoes