Summary
Overview
Work History
Education
Websites
Timeline
Generic

Gheorghi Bezvolev

Metairie,LA

Summary

  • Highly accomplished IT professional with a distinguished track record of over 10 years of experience in Database Design, Development, Business Intelligence, and Data Warehouse Solutions. Possessing a profound understanding of BI applications across Development, Test, and Production Environments, I am adept at translating complex data into actionable insights that drive strategic decision making.
  • Results-driven IT professional with strong analytical, communication, and interpersonal skills. Proficient in technical writing and presentations. Extensive experience in both on-prem and cloud solutions, particularly within the Microsoft Azure ecosystem. Expertise includes ADF2, Azure SQL Server, Azure SQL IaaS/SaaS/PaaS, Azure SQL DW, Azure Blob, and Power BI Service. Proactively stay updated with the latest cloud and BI technologies to drive innovation and deliver value-added solutions.
  • Extensive expertise in Azure Data Factory V2, Data Flows, Snowflake, Azure Data Lake, and Azure Analysis Services.
  • Designed and managed Snowflake-based data pipelines, using Snowpipe for real-time data ingestion and automated workflows. Optimized query performance using Snowflake's features such as time travel and zero-copy cloning.
  • Built scalable analytics pipelines in Azure Synapse, combining serverless SQL pools with Spark for fast, comprehensive data processing.
  • Utilized Delta Lake for versioning, handling both batch and streaming data, and used Parquet file formats for optimized storage and query performance.
  • Proficient in implementing Incremental Load within ADF2 pipelines using various techniques based on the existence of Modified Date columns. Skilled in utilizing Look Up, Merge Statement with target staging table,CDC Control Task, Merge Join, SCD Transformations.

Overview

11
11
years of professional experience

Work History

Senior Data Engineer

Blue Triton
Stamford, Connecticut
11.2021 - Current
  • In my role as an Azure Database Administrator, I lead the design and implementation of robust database systems that align with end-users' information requirements, ensuring high availability and quality tailored to specific roles within the organization
  • I have effectively managed Azure SQL databases and dedicated SQL pools in Azure Synapse, focusing on minimizing downtime while optimizing performance through precise parameter management and query tuning
  • My responsibilities include establishing user roles and implementing effective data distribution strategies, enabling timely access to critical information in user-friendly formats
  • I take pride in developing and enforcing comprehensive database policies, procedures, and standards that enhance data security, privacy, and integrity across our platforms
  • With a strong foundation in ETL processes, I leverage Azure Synapse to monitor and troubleshoot data pipelines, ensuring seamless data movement and transformation across various systems
  • My proficiency in Azure BI and big data analytical tools, including Power BI and Azure DataBricks, has been instrumental in automating complex data processes, thus increasing operational efficiency
  • A core aspect of my role involves collaborating with cross-functional teams to identify business needs and provide customized solutions
  • By fostering strong relationships with stakeholders, I have successfully delivered data-driven reporting solutions that empower decision-making and enhance overall business performance
  • My commitment to continuous improvement and innovation in database management practices has not only elevated the quality of our data operations but also supported a data-driven culture within the organization
  • Engineered and oversaw data pipelines within Azure Synapse, implementing robust ETL processes to facilitate automated, real-time data ingestion
  • I crafted and optimized these processes to efficiently handle substantial volumes of both structured and semi-structured data
  • By leveraging Azure Synapse's advanced features, including dedicated SQL pools, serverless SQL capabilities, and integrated data lake storage, I ensured effective data management and reduced operational overhead
  • Additionally, I streamlined the ingestion of streaming data from various sources into Azure Synapse, enhancing data accessibility for analytics and reporting
  • Proficient in the Microsoft Azure ecosystem, including Power BI Service, Azure Data Factory (ADF2), Azure SQL Server, Azure SQL IaaS/SaaS/PaaS, Azure SQL Data Warehouse (DW), and Azure Blob Storage
  • As a key contributor to the BI team, I successfully met developmental needs and achieved positive outcomes utilizing Power BI
  • Assisted the Project Manager in guiding cross-functional project teams to implement effective data conversion strategies and relay critical information to team members
  • Collaborated directly with end users to gather, analyze, and document business requirements and rules
  • Configured the Azure Synapse platform for data pipelines, integrating with Azure Blob Storage and data lakes, while developing workflows to automate data flow within the Synapse environment
  • Developed complex ETL packages using Azure Synapse pipelines to efficiently process fact and dimension tables through a variety of transformations
  • Successfully migrated SQL Server schemas to Azure Synapse Analytics, overseeing the development and maintenance of databases across both on-premises and cloud environments
  • Conducted SQL performance monitoring and tuning for reporting data, optimizing indexes and stored procedures for enhanced efficiency
  • Established alerts, notifications, and emails for system errors, resource deficiencies, critical database errors, hardware issues, and security violations
  • In addition to leveraging SAP, I implemented robust data extraction processes from various sources, including Transportation Management Systems (TMS), Warehouse Management Systems (WMS), and third-party distribution platforms
  • By integrating data from these systems into our BI solution, we achieved a comprehensive view of the supply chain, empowering our clients to pinpoint bottlenecks, enhance logistics, and boost overall operational efficiency
  • My strong communication skills with stakeholders across various departments, including Finance, Sales, Operations, and HR, have significantly enhanced my ability to deliver valuable solutions
  • This cross-functional collaboration deepened my understanding of the business context, ensuring that the BI solutions were aligned with the organization's strategic goals and provided actionable insights

Data Engineer

Mizuho Financial Group
New York, New York
10.2019 - 10.2021
  • As a Cloud Data Engineer, I have been a part of transformative initiatives to modernize our data infrastructure
  • My primary focus was the meticulous design and modeling of data warehouses, requiring a comprehensive understanding of our organization’s evolving data needs and the complexities of cloud platforms
  • Leveraging my expertise in data engineering, I have been a part of the migration project from on-premises SQL Server systems to cloud-based solutions, ensuring data integrity and system stability throughout the transition
  • Collaborating closely with cross-functional stakeholders, I engaged in extensive data modeling discussions that transcended technical considerations
  • These strategic forums allowed us to align business objectives with our data architecture
  • By translating technical complexities into actionable insights, I played a crucial role in facilitating informed decision-making across the organization
  • In addition to my core responsibilities, I embraced a mentorship role within the team
  • Drawing from my experience and industry knowledge, my commitment to excellence and collaborative leadership significantly advanced the success of data initiatives
  • Demonstrated expertise in developing multiple data migration pipelines using Azure Data Factory V2 (ADF2), ensuring smooth and efficient data movement across various platforms and systems
  • Utilized the Tidal orchestration tool to automate complex ETL and migration processes, streamlining workflows and reducing manual intervention
  • This automation significantly enhanced data accuracy, consistency, and overall operational efficiency
  • Skillfully re-engineered intricate stored procedures for seamless integration into the Snowflake environment while upholding business standards and ensuring data migration integrity
  • Assumed responsibility for maintaining the highest levels of data accuracy and consistency across the data warehouse
  • Conducted rigorous data quality checks and implemented corrective actions to address discrepancies, resulting in improved reliability for business stakeholders
  • Worked directly with business stakeholders to understand their data needs and challenges, maintaining regular communication and providing valuable solutions to enhance data utilization and reporting capabilities
  • Led the migration from on-premises SQL infrastructure to the Azure environment, utilizing Snowflake and ADF as the primary tool for orchestrating the transition
  • Identified and optimized slow-running queries and stored procedures, rigorously testing applications for performance and data integrity during the migration to the new cloud environment
  • Participated in the design of the Data Warehouse by identifying dimension and fact tables to meet business requirements
  • Developed numerous stored procedures and functions to enhance performance and flexibility
  • Oversaw job creation, scheduling, and utilization in both Development and Production environments using the Tidal orchestration tool
  • Formatted and generated data to support the SAP/Salesforce teams, enabling user access to data from the Data Warehouse
  • Assisted the Project Manager in leading cross-functional project teams, implementing effective data conversion strategies, and ensuring smooth communication among team members
  • Extensive experience with the Microsoft Azure ecosystem, including Power BI Service, Azure Data Factory, Azure SQL Server, Azure SQL IaaS/SaaS/PaaS, Azure SQL Data Warehouse, and Azure Blob Storage
  • Configured the Azure platform for data pipelines, Azure Data Factory, and data lakes, building workflows to automate data flow

Senior BI Developer/ETL Developer

Kaiser Permanente
Oakland, CA
04.2017 - 10.2019
  • In my role as Senior BI Developer, I excelled in creating and implementing data-driven solutions that optimized decision-making and streamlined business processes
  • I successfully executed complex data analytics approaches by developing scalable, automated ETL processes using SQL Server Integration Services (SSIS) and SQL, driving efficiencies in data integration, transformation, and reporting across various departments
  • I led the design and development of advanced business intelligence (BI) solutions that transformed raw data into meaningful insights through dynamic reports and interactive dashboards
  • My expertise in data modeling and statistical analysis helped generate actionable insights, which directly influenced strategic decisions
  • By leveraging SQL performance tuning, I improved query performance, reducing reporting time and increasing overall operational efficiency
  • I was responsible for extracting, transforming, and loading (ETL) large data sets from diverse sources while ensuring data integrity and accuracy, leading to consistent and high-quality data for business intelligence projects
  • I collaborated with key stakeholders to define data requirements and develop reporting standards, ensuring the alignment of data solutions with business objectives
  • Additionally, I developed and optimized SSIS packages for complex ETL processes, integrating data from multiple sources like SQL Server, flat files, and cloud-based databases
  • My work also involved mentoring junior developers, providing guidance in best practices around SQL query optimization, SSIS design, and BI development
  • I played a key role in cross-functional team collaborations, working with data analysts, business leaders, and IT teams to support the development of predictive models and advanced analytics, ensuring data-driven decision-making across the organization
  • My contributions helped the company identify trends, improve business performance, and uncover new revenue opportunities, reinforcing my strong analytical and problem-solving skills
  • Deployed SSIS packages via package Bids Deployment, installation wizard, Management Studio Import for automatization of data processes
  • Generated various Power BI reports sourcing from SSAS's Multidimensional OLAP and Tabular model with DAX
  • Developed multiple Power BI reports, leveraging Power BI Desktop and Power BI Service to support healthcare operations
  • These reports covered key areas such as patient care metrics, provider performance scorecards, cost and utilization comparisons, financial performance, and logistics efficiency
  • By translating complex data into actionable insights, I supported leadership in making informed decisions that enhanced patient care and operational efficiency, while also aligning on integrated healthcare delivery and data-driven decision-making
  • Utilized DAX expressions in Power Pivot to create custom calculations, enabling deeper insights into cost analysis, financial metrics, and performance scorecards for improved decision-making
  • Managed the scheduling, distribution, and ongoing maintenance of Power BI reports published to the Power BI Service, ensuring seamless access for user groups and stakeholders
  • Configuring tuning and optimizing T- SQL
  • Responsible for performing basic developer task like creating, altering and updating tables
  • Developed simple stored procedures, queries, views, joins and indexes by using T-SQL
  • Normalized the tables and maintained Integrity by using Primary and Foreign Keys
  • Designed and developed various SSIS packages (ETL) to extract and transform data and involved in Scheduling SSIS Packages
  • Performed SSIS Development and support, developed ETL solutions for integrating data from multiple sources like Flat Files, Excel, SQL Server, Raw File, and DB2 into the data warehouse
  • Created, maintained and updated ETL packages loading both OLTP and OLAP database tables
  • Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load
  • Created packages in SSIS with error handling and worked with different methods of logging in SSIS

BI Developer

Lumen Technologies (formerly CenturyLink)
Monroe, Louisiana
06.2014 - 04.2017
  • Specialized in transforming complex data sets into actionable insights that drive informed decision-making
  • My proficiency in SQL development and extensive experience with Power BI have equipped me to excel in the full development lifecycle, from gathering requirements to designing and implementing reporting solutions
  • As a part of collaborative environments, partnering with cross-functional teams to define business needs and translate them into effective reporting system requirements
  • My expertise includes crafting complex SQL queries and optimizing performance, ensuring that our reporting applications meet the dynamic needs of the business
  • I have committed to delivering high-quality results and providing exceptional support for internal reporting activities
  • Spearheaded the development lifecycle of comprehensive reporting applications, engaging in requirements gathering, solution architecture, coding, testing, and implementation to provide insightful analytics for internal stakeholders
  • Expertly crafted and optimized complex SQL queries and database objects, including stored procedures and views, to efficiently manage and retrieve data from large datasets, significantly improving query performance and reporting accuracy
  • Designed and deployed interactive dashboards and visual reports using Power BI, providing business leaders with real-time insights into operational performance, KPIs, and strategic initiatives, thus facilitating informed decision-making across the organization
  • Provided comprehensive production support for all reporting activities, proactively identifying, and resolving data and reporting issues in collaboration with business partners to ensure seamless reporting operations and high levels of stakeholder satisfaction
  • Developed ad-hoc reporting solutions and customized data analyses to meet specific business requirements, enhancing operational efficiencies and enabling teams to respond swiftly to emerging trends and insights
  • Implemented rigorous testing protocols and quality assurance measures to validate the integrity and accuracy of reporting solutions, ensuring that all outputs meet organizational standards and user expectations
  • Configuring tuning and optimizing T- SQL
  • Responsible for performing basic developer task like creating, altering, and updating tables
  • Developed simple stored procedures, queries, views, joins and indexes by using T-SQL
  • Normalized the tables and maintained Integrity by using Primary and Foreign Keys
  • Designed and developed various SSIS packages (ETL) to extract and transform data and involved in Scheduling SSIS Packages
  • Proficient in the high-level design of ETL processes using DTS and SSIS packages for data integration from diverse sources, including flat files, text data, Excel, CSV, SAS, and Oracle, utilizing OLE DB connections
  • Effectively apply advanced SSIS transformations such as Data Conversion, Conditional Split, Bulk Insert, Derived Column, Merge, Merge Join, and Union All
  • Demonstrated ability to create, develop, test, and deploy packages to production servers while managing package configurations to ensure optimal performance
  • Extensive hands-on experience in creating database objects, including tables, constraints (primary key, foreign key, unique, default), views, and indexes
  • Skilled in developing applications through T-SQL programming, encompassing DDL, DML, and DCL operations
  • Recognized for excellence in crafting complex T-SQL queries, stored procedures, triggers, user-defined functions, joins, and common table expressions (CTE), ensuring efficient data manipulation and retrieval

Education

Bachelor's degree - Computer Science

USM – Moldova State University

Timeline

Senior Data Engineer

Blue Triton
11.2021 - Current

Data Engineer

Mizuho Financial Group
10.2019 - 10.2021

Senior BI Developer/ETL Developer

Kaiser Permanente
04.2017 - 10.2019

BI Developer

Lumen Technologies (formerly CenturyLink)
06.2014 - 04.2017

Bachelor's degree - Computer Science

USM – Moldova State University

Similar Profiles

CREATE PROFILE
Gheorghi Bezvolev