Isroel Aleksandr Sokol

About Isroel Aleksandr Sokol

With nearly 9 years of professional experience, seasoned Senior Data Engineer with a diverse background in multiple data realms, including sales, service, marketing, management, production, finance, accounting, human resources, and supply chain, among other domains. Expertise on high-performance solutions for data integration, designing ER and dimensional data models tailored for supporting OLAP/OLTP/Data Lake/Data Warehouse systems, and facilitating seamless cloud data migration. Proficiency in a range of BI applications, including SQL Server, Azure Data Factory, Databricks with Python and SQL, Azure Synapse, SSIS, Azure Logic App, Function App, Azure Data Lake, CICD pipelines, and other tools, empowers me to generate impactful reports and presentations. Strong background of over data visualization platforms such as Power BI and Tableau.

Experience

1. Senior Data Engineer

   Protiviti

   Oct 2020 — Present · New York, NY, US

   Utilized Agile Methodology and Scrum for project management, leveraging Azure DevOps and Jira for progress tracking, task allocation, and team communication.Collaborated closely with business users to capture and translate requirements into actionable BI solutions.Executed data architecture design, encompassing data models, integration strategies, and data quality protocols.Worked with diverse teams to ensure successful project outcomes, spanning project planning, risk mitigation, and stakeholder engagement.Architected and executed a data warehouse within Azure Synapse Analytics and a data lake using ADF and Databricks, fostering enhanced data governance and improved data accessibility.Proposed designs with cost and budget considerations in Azure, providing recommendations to optimize data infrastructure.Spearheaded the management of Azure SQL Database, Azure Synapse SQL Pools, Azure Data Factory, and Databricks notebooks for constructing Data Lakes and Data Warehouses to host Power BI reports.Conceived proof of concept (POC) solutions, showcasing the feasibility of Azure technologies like Azure Synapse, Azure Purview, and Azure Kusto Log Analytics through prototype creation.Developed Spark applications employing Spark-SQL within Azure Databricks to extract, transform, and aggregate data from diverse file formats, uncovering insights into customer usage patterns.Designed and deployed scalable and reliable big data pipelines, employing Azure Data Factory (ADF), ADLS, PYSPARK, Databricks Notebooks, and Azure Synapse.Erected a centralized data lake for processing daily price and promotional data utilizing Databricks and ADF. Leveraged Azure Data Factory for data ingestion and transformation from various sources, streamlining data preparation using PYSPARK, Python, and SQL in Azure Databricks.Created Delta Lake and Delta tables in Azure Databricks for efficient processing of large data volumes.

Education

• Udacity

  Deep Learning, Artificial Intelligence

  2016 — 2016

• Florida International University

  Bachelor's degree, Computer Science

  2012 — 2016

• Udacity

  Full-Stack Web Developer Nanodegree, Web Development

  2017 — 2017

Skills

• Python
• Project Management
• Html5
• Javascript
• Java
• Mysql